MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where City = 27 and Object Name = 6

Search:

descending

Link	rowid ▼	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Culture	Artist Role	Artist Display Name	Artist Display Bio	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	Country	Classification	Link Resource	Metadata Date	Repository
1923	1923	83.2.75	1	2091	American Decorative Arts 1	Clock 6	Clock									1792–1819	1792	1819	Gilt bronze 30	H. 12 in. (30.5 cm)	Gift of William H. Huntington, 1883	Made in 1	Paris 27	France 9	Metal 1	http://www.metmuseum.org/art/collection/search/2091	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
1925	1925	31.41.1	1	2094	American Decorative Arts 1	Clock 6	Clock		Maker 1	Dubuc	active ca. 1780–1819	Dubuc 334		1777	1819	1815–20	1815	1820	Gilt bronze 30	19 x 14 1/8 in. (48.3 x 35.9 cm)	Bequest of Jane E. Andrews, in memory of her husband, William Loring Andrews, 1930	Made in 1	Paris 27	France 9	Metal 1	http://www.metmuseum.org/art/collection/search/2094	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
1926	1926	25.111	1	2095	American Decorative Arts 1	Clock 6	Clock		Maker 1	Jacob		Jacob 335			9999	1800–1830	1800	1830	Gilt bronze 30	16 1/2 x 12 1/2 x 5 1/4 in. (41.9 x 31.8 x 13.3 cm)	Gift of Miss Julia Yard, 1925	Made in 1	Paris 27	France 9	Metal 1	http://www.metmuseum.org/art/collection/search/2095	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
1927	1927	68.165.9a, b	1	2096	American Decorative Arts 1	Clock 6	Clock		Maker 1	Auguste-Émile Rinquet-Leprince	1801–1886	Ringuet-Leprince, Auguste-Émile 48	French 2	1801	1886	ca. 1860	1857	1860	Gilt bronze, porcelain 536	28 x 13 5/8 x 10 3/8 in. (71.1 x 34.6 x 26.4 cm)	Gift of Mrs. Douglas M. Moffat, 1968	Made in 1	Paris 27	France 9	Metal 1	http://www.metmuseum.org/art/collection/search/2096	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

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