MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Classification = 1 and Object Name = 6 sorted by Country

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 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
1924	1924	1974.214.23	0	2093	American Decorative Arts 1	Clock 6	Clock	American 1									1890–1905	1890	1905	Bronze 23	18 5/16 x 9 in. (46.5 x 22.9 cm)	Gift of Mr. and Mrs. Hugh J. Grant, 1974	Possibly made in 5		United States 3	Metal 1	http://www.metmuseum.org/art/collection/search/2093	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
1928	1928	68.97.4	1	2097	American Decorative Arts 1	Clock 6	Clock	American 1	Maker 1		Tiffany & Co.	1837–present	Tiffany & Co. 193		1837	9999	ca. 1885	1882	1885	Marble, bronze 537	18 1/8 x 20 1/8 x 7 3/4 in. (46 x 51.1 x 19.7 cm)	Purchase, The Edgar J. Kaufmann Foundation Gift, 1968	Made in 1	New York 3	United States 3	Metal 1	http://www.metmuseum.org/art/collection/search/2097	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
1930	1930	62.233.16	1	2099	American Decorative Arts 1	Clock 6	Clock	American 1	Designer\|Maker 4	Designed by	Louis Comfort Tiffany\|Tiffany Studios	American, New York 1848–1933 New York\|1902–32	Tiffany, Louis Comfort\|Tiffany Studios 134	American 1	1848 \|1902	1933 \|1932	ca. 1905–20	1902	1920	Glass, bronze 276	4 3/4 x 3 1/2 x 2 3/8 in. (12.1 x 8.9 x 6 cm)	Gift of Mrs. H. S. Mesick, 1962	Made in 1	New York 3	United States 3	Metal 1	http://www.metmuseum.org/art/collection/search/2099	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
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

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