MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Classification = 4 and Country = 9

Search:

descending

Link	rowid ▼	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Culture	Artist Role	Artist Prefix	Artist Display Name	Artist Display Bio	Artist Alpha Sort	Artist Begin Date	Artist End Date	Object Date	Object Begin Date	Object End Date	Medium	Dimensions	Credit Line	Geography Type	City	Country	Classification	Link Resource	Metadata Date	Repository
166	166	48.135.24	0	198	American Decorative Arts 1	Armchair 21	Armchair	French 7								1800–1830	1800	1830	Mahogany 45	36 x 22 1/2 x 19 1/4 in. (91.4 x 57.2 x 48.9 cm)	Bequest of Adeline R. Brown, 1947	Made in 1		France 9	Furniture 4	http://www.metmuseum.org/art/collection/search/198	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
16661	16661	2009.147	0	20105	American Decorative Arts 1	Clock 6	Clock	French 7	Maker 1		Gaspard Cachard	active 1792/95–1802	Cachard, Gaspard 2583	1792	1802	ca. 1800	1795	1805	Black marble, ormolu, gilt bronze and/or brass, enamel dial, and clock mechanism 3210	26 15/16 x 17 x 6 1/8 in. (68.4 x 43.2 x 15.6 cm)	Purchase, Morris K. Jesup Fund, by exchange, and Jan and Warren Adelson Gift, 2009	Probably made in 2	Paris 27	France 9	Furniture 4	http://www.metmuseum.org/art/collection/search/20105	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
16847	16847	2012.443a, b	1	20532	American Decorative Arts 1	Clock 6	Clock with Bust of Washington and Relief of Cornwallis Resigning his Sword to Washington	American 1	Maker 1		Armingaud L’Ainé	1806–1813	L’Ainé, Armingaud 2611	1806	1813	ca. 1815	1810	1820	Marble and patinated bronze 3263	18 3/4 x 7 3/4 x 4 3/4 in. (47.6 x 19.7 x 12.1 cm)	Gift of Judith F. Hernstadt, 2012	Made in 1	Paris 27	France 9	Furniture 4	http://www.metmuseum.org/art/collection/search/20532	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
390675	390675	SL.14.2015.9.2a–d	0	641788	American Decorative Arts 1	Tiles 1198	Tiles from a bathroom of the Worsham-Rockefeller House	America 6596	Maker\|Maker 6		George A. Schastey\|George A. Schastey & Co.	1839–1894\|1873–97	Schastey, George A.\|George A. Schastey & Co. 2567	1839 \|1873	1894 \|1897	ca. 1880	1875	1885	Glazed earthenware 9554	Assembled: 15 13/16 × 15 13/16 × 3/8 in. (40.2 × 40.1 × 1 cm)	Gift of John Davison Rockefeller, Jr., Cooper Hewitt, Smithsonian Design Museum, Smithsonian Institution	(none assigned) 9	Gien 2429	France 9	Furniture 4	http://www.metmuseum.org/art/collection/search/641788	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
422236	422236	L.2015.74	0	700211	American Decorative Arts 1	Clock 6	Wall clock from the Japanese parlor of the William H. Vanderbilt House	French 7	Designer 5	Design attributed to	Marcelle Lancelot	French, 1849–1942	Lancelot, Marcelle 53819	1849	1942	ca. 1882	1877	1887	Bronze, gilded bronze, and cloisonné enamel 60453	38 × 15 1/2 in. (96.5 × 39.4 cm)	Collection of Margot Johnson	Country of Origin 23		France 9	Furniture 4	http://www.metmuseum.org/art/collection/search/700211	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

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");