MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Artist Alpha Sort = 17 and Object Begin Date = 1892

View and edit SQL

Suggested facets: Object Name, Title, Artist Role, Object Date, Object End Date, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
8786 55.213.2 0 1 9447 American Decorative Arts 1 Vase 7 Vase American 1         Designer|Maker 4 Designed by Louis Comfort Tiffany|Tiffany Glass and Decorating Company American, New York 1848–1933 New York|American, 1892–1902   Tiffany, Louis Comfort|Tiffany Glass and Decorating Company 17 American 1 1848 |1892 1933 |1902 ca. 1895 1892 1898 Favrile glass 231 H. 2 in. (5.1 cm) Anonymous Gift, 1955 Made in 1 New York 3     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
8792 55.213.9 0 1 9453 American Decorative Arts 1 Vase 7 Vase American 1         Designer|Maker 4 Designed by Louis Comfort Tiffany|Tiffany Glass and Decorating Company American, New York 1848–1933 New York|American, 1892–1902   Tiffany, Louis Comfort|Tiffany Glass and Decorating Company 17 American 1 1848 |1892 1933 |1902 ca. 1895 1892 1898 Favrile glass 231 H. 4 in. (10.2 cm) Anonymous Gift, 1955 Made in 1 New York 3     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
8809 62.251 0 1 9470 American Decorative Arts 1 Vase 7 Vase American 1         Designer|Maker 4 Designed by Louis Comfort Tiffany|Tiffany Glass and Decorating Company American, New York 1848–1933 New York|American, 1892–1902   Tiffany, Louis Comfort|Tiffany Glass and Decorating Company 17 American 1 1848 |1892 1933 |1902 ca. 1895 1892 1898 Favrile glass 231 9 5/8 x 5 1/2 in. (24.4 x 14 cm) Gift of Mr. and Mrs. Lawrence Morris, 1962 Made in 1 New York 3     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
8810 69.263.1 0 1 9471 American Decorative Arts 1 Vase 7 Vase American 1         Designer|Maker 4 Designed by Louis Comfort Tiffany|Tiffany Glass and Decorating Company American, New York 1848–1933 New York|American, 1892–1902   Tiffany, Louis Comfort|Tiffany Glass and Decorating Company 17 American 1 1848 |1892 1933 |1902 ca. 1895 1892 1898 Favrile glass 231 H. 10 3/16 in. (25.9 cm); Diam. 5 7/8 in. (14.9 cm) Gift of Fenton L. B. Brown, in memory of his mother, Blanche Butler Brown, 1969 Made in 1 New York 3     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
15119 67.654.274 0 1 16385 American Decorative Arts 1 Drawing 23 Design for a filigree spandrel American 1         Artist|Maker 57   Louis Comfort Tiffany|Tiffany Glass and Decorating Company American, New York 1848–1933 New York|American, 1892–1902   Tiffany, Louis Comfort|Tiffany Glass and Decorating Company 17 American 1 1848 |1892 1933 |1902 ca. 1892 1892 1892 Ink and watercolor over graphite on paper 2551 Overall: 14 x 11in. (35.6 x 27.9cm) Purchase, Walter Hoving and Julia T. Weld Gifts and Dodge Fund, 1967 Made in 1       United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
15130 67.654.423 0 1 16396 American Decorative Arts 1 Drawing 23 Design of Altar Rail for St. Paul's Church, Troy, New York American 1         Artist|Maker 57   Louis Comfort Tiffany|Tiffany Glass and Decorating Company American, New York 1848–1933 New York|American, 1892–1902   Tiffany, Louis Comfort|Tiffany Glass and Decorating Company 17 American 1 1848 |1892 1933 |1902 ca. 1895–98 1892 1898 Watercolor, pen and a variety of inks—metallic bronze, brown and black, and graphite on off-white wove paper-faced illustration board with original warm grey window matt 2560 9 3/16 x 17 in. (23.3 x 43.2 cm) Other (Design): 4 3/16 x 13 9/16 in. (10.6 x 34.4 cm) Purchase, Walter Hoving and Julia T. Weld Gifts and Dodge Fund, 1967 Made in 1       United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
15138 53.679.1814 0 1 16404 American Decorative Arts 1 Drawing 23 Design for marble pulpit American 1         Artist|Maker 57   Louis Comfort Tiffany|Tiffany Glass and Decorating Company American, New York 1848–1933 New York|American, 1892–1902   Tiffany, Louis Comfort|Tiffany Glass and Decorating Company 17 American 1 1848 |1892 1933 |1902 ca. 1895–1900 1892 1900 Watercolor, glazing media, pen and inks, including brown ink and bronze metallic ink, and graphite on off-white wove paper 2568 9 13/16 x 14 7/8 in. (24.9 x 37.8 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund,1953 Made in 1       United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
15662 67.654.6 0 1 17064 American Decorative Arts 1 Drawing 23 Design for an interior American 1         Artist|Maker 57   Louis Comfort Tiffany|Tiffany Glass and Decorating Company American, New York 1848–1933 New York|American, 1892–1902   Tiffany, Louis Comfort|Tiffany Glass and Decorating Company 17 American 1 1848 |1892 1933 |1902 1892–1902 1892 1902 Watercolor, colored inks, and graphite on off-white wove paper mounted overall to an artist board  2754 20 7/8 x 18 1/2 in. (53 x 47 cm) Purchase, Walter Hoving and Julia T. Weld Gifts and Dodge Fund, 1967 Made in 1       United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
15845 67.654.279 0 1 17266 American Decorative Arts 1 Drawing 23 Sketch for Mirror Frame of Jewels & Wirework American 1         Artist|Maker 57   Louis Comfort Tiffany|Tiffany Glass and Decorating Company American, New York 1848–1933 New York|American, 1892–1902   Tiffany, Louis Comfort|Tiffany Glass and Decorating Company 17 American 1 1848 |1892 1933 |1902 1892–1902 1892 1902 Watercolor, pen and black India ink, and graphite on white watercolor paper in warm grey original window matt 2867 Overall: 18 5/16 x 13 7/8 in. (46.5 x 35.2 cm) Other (Design): 12 5/8 x 9 3/8 in. (32.1 x 23.8 cm) Purchase, Walter Hoving and Julia T. Weld Gifts and Dodge Fund, 1967 Made in 1       United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
15976 67.654.428 0 1 17403 American Decorative Arts 1 Drawing 23 Design for heating register plate American 1         Artist|Maker 57   Louis Comfort Tiffany|Tiffany Glass and Decorating Company American, New York 1848–1933 New York|American, 1892–1902   Tiffany, Louis Comfort|Tiffany Glass and Decorating Company 17 American 1 1848 |1892 1933 |1902 late 19th–early 20th century 1892 1902 Pen, black ink, and graphite on light-tan smooth-surfaced lightweight artist board 2964 Overall: 10 5/8 x 13 3/16 in. (27 x 33.5 cm) Purchase, Walter Hoving and Julia T. Weld Gifts and Dodge Fund, 1967 Made in 1       United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
15977 67.654.429 0 1 17404 American Decorative Arts 1 Drawing 23 Design for firescreen American 1         Artist|Maker 57   Louis Comfort Tiffany|Tiffany Glass and Decorating Company American, New York 1848–1933 New York|American, 1892–1902   Tiffany, Louis Comfort|Tiffany Glass and Decorating Company 17 American 1 1848 |1892 1933 |1902 late 19th–early 20th century 1892 1902 Watercolor and graphite on off-white lightweight artist board 2965 Overall: 14 3/16 x 11 in. (36 x 28 cm) Purchase, Walter Hoving and Julia T. Weld Gifts and Dodge Fund, 1967 Made in 1       United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 234.445ms · Data license: CC0 · Data source: metmuseum/openaccess