MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Alpha Sort = 2358

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Role, 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
15116 67.654.405 0 1 16382 American Decorative Arts 1 Drawing 23 Sketch of fireset for third-floor silk room (H.O. Havemeyer house, 1 East 66th Street, New York, NY) American 1         Artist|Maker 57   Louis Comfort Tiffany|Tiffany Glass Company American, New York 1848–1933 New York|1885–92   Tiffany, Louis Comfort|Tiffany Glass Company 2358 American 1 1848 |1885 1933 |1892 ca. 1891 1891 1891 Watercolor and graphite on off-white wove paper-faced lightweight paper board 2548 Overall: 14 x 11 1/16 in. (35.5 x 28.1 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
15117 67.654.408 0 0 16383 American Decorative Arts 1 Drawing 23 Aesthetic room interior with window and fireplace American 1         Artist|Maker 57   Louis Comfort Tiffany|Tiffany Glass Company American, New York 1848–1933 New York|1885–92   Tiffany, Louis Comfort|Tiffany Glass Company 2358 American 1 1848 |1885 1933 |1892 ca. 1883–87 1880 1887 Watercolor, metallic silver ink, pen and black ink, and graphite on wove paper 2549 13 1/8 x 10 5/8 in. (33.3 x 27 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
15123 53.679.1824 0 1 16389 American Decorative Arts 1 Drawing 23 Design for Lyceum Theatre, New York American 1         Artist|Maker 57   Louis Comfort Tiffany|Tiffany Glass Company American, New York 1848–1933 New York|1885–92   Tiffany, Louis Comfort|Tiffany Glass Company 2358 American 1 1848 |1885 1933 |1892 ca. 1885 1882 1888 Watercolor, pen and gold-colored bronze metallic ink, brown and black India ink, and graphite on tan-colored wove paper 2553 11 7/16 x 10 15/16 in. (29 x 27.7 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
15632 2000.623 0 1 16974 American Decorative Arts 1 Mosaic panel 632 Mosaic Panel American 1         Designer|Maker 4 Designed by Louis Comfort Tiffany|Tiffany Glass Company American, New York 1848–1933 New York|1885–92   Tiffany, Louis Comfort|Tiffany Glass Company 2358 American 1 1848 |1885 1933 |1892 ca. 1890–91 1887 1894 Favrile glass 231 35 1/8 x 22 x 2 in. (89.2 x 55.9 x 5.1 cm) Gift of Paul and Chloe Nassau, 2000                       Glass 3   Metropolitan Museum of Art, New York, NY 1
15979 67.654.431 0 0 17406 American Decorative Arts 1 Drawing 23 Design for skylight American 1         Artist|Maker 57   Louis Comfort Tiffany|Tiffany Glass Company American, New York 1848–1933 New York|1885–92   Tiffany, Louis Comfort|Tiffany Glass Company 2358 American 1 1848 |1885 1933 |1892 late 19th–early 20th century 1885 1892 Watercolor, graphite, and ink on paper mounted on board 2967 Overall: 14 x 10 7/8 in. (35.6 x 27.6 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 165.817ms · Data license: CC0 · Data source: metmuseum/openaccess