MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 10 rows (hide)

select 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], [Metadata Date], Repository from MetObjects where "Excavation" = :p0 and "Medium" = :p1 and rowid > :p2 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Period	Dynasty	Object Date	Object Begin Date	Object End Date	Medium	Dimensions	Credit Line	Geography Type	Country	Region	Subregion	Locale	Locus	Excavation	Link Resource	Metadata Date	Repository
354026	22.1.102	0	546803	19	40	Ball	Middle Kingdom	74	ca. 1900–1802 B.C.	-1900	-1802	148	diam. 2.8 cm (1 1/8 in)	Rogers Fund and Edward S. Harkness Gift, 1922	19	104	645	135	79	85	50	http://www.metmuseum.org/art/collection/search/546803	4/23/2018 8:00:01 AM	1
354027	22.1.105	1	546804	19	17833	Magic wand fragment	Middle Kingdom	74	ca. 1900–1802 B.C.	-1900	-1802	148	L. 4.8 × W. 3.7 × Th. 0.9 cm (1 7/8 × 1 7/16 × 3/8 in.)	Rogers Fund and Edward S. Harkness Gift, 1922	19	104	645	135	79	85	50	http://www.metmuseum.org/art/collection/search/546804	4/23/2018 8:00:01 AM	1
354032	22.1.108	1	546809	19	19243	Figure of lion	Late Middle Kingdom	44	ca. 1850–1700 B.C.	-1850	-1700	148	h. 7.4 cm (2 15/16 in)	Rogers Fund and Edward S. Harkness Gift, 1922	19	104	645	135	274	424	50	http://www.metmuseum.org/art/collection/search/546809	4/23/2018 8:00:01 AM	1
354061	22.1.189	0	546838	19	5268	Inlay	Middle Kingdom	14	ca. 1850–1750 B.C.	-1850	-1750	148	l. 2.6 cm (1 in)	Rogers Fund and Edward S. Harkness Gift, 1922	19	104	645	135	283	428	50	http://www.metmuseum.org/art/collection/search/546838	4/23/2018 8:00:01 AM	1
354062	22.1.142	1	546839	19	18174	Clapper	Middle Kingdom	175	ca. 1900–1640 B.C.	-1900	-1640	148	L. 22 × W. 6.1 × Th. 0.8 cm (8 11/16 × 2 3/8 × 5/16 in.)	Rogers Fund and Edward S. Harkness Gift, 1922	19	104	645	135	77	83	50	http://www.metmuseum.org/art/collection/search/546839	4/23/2018 8:00:01 AM	1
354064	22.1.146	1	546841	19	18174	Clapper	Middle Kingdom	176	ca. 1900–1640 B.C.	-1900	-1640	148	L. 20.1 × W. 6 × Th. 1 cm (7 15/16 × 2 3/8 × 3/8 in.)	Rogers Fund and Edward S. Harkness Gift, 1922	19	104	645	135	77	83	50	http://www.metmuseum.org/art/collection/search/546841	4/23/2018 8:00:01 AM	1
354065	22.1.148	0	546842	19	19336	Clapper Handle fragment (?)	Middle Kingdom	73	ca. 1900–1640 B.C.	-1900	-1640	148	W. 3.2 × H. 5.4 cm (1 1/4 × 2 1/8 in.)	Rogers Fund and Edward S. Harkness Gift, 1922	19	104	645	135	77	83	50	http://www.metmuseum.org/art/collection/search/546842	4/23/2018 8:00:01 AM	1
354066	22.1.149	0	546843	19	19337	Finial of a fan	Middle Kingdom	73	ca. 1900–1640 B.C.	-1900	-1640	148	W. 5.4 × H. 6.9 cm (2 1/8 × 2 11/16 in.)	Rogers Fund and Edward S. Harkness Gift, 1922	19	104	645	135	77	83	50	http://www.metmuseum.org/art/collection/search/546843	4/23/2018 8:00:01 AM	1
354067	22.1.152	1	546844	19	18174	Clapper	Middle Kingdom	73	ca. 1900–1640 B.C.	-1900	-1640	148	L. 21.5 × W. 7.4 × Th. 0.9 cm (8 7/16 × 2 15/16 × 3/8 in.)	Rogers Fund and Edward S. Harkness Gift, 1922	19	104	645	135	77	83	50	http://www.metmuseum.org/art/collection/search/546844	4/23/2018 8:00:01 AM	1
363806	22.1.96	1	557436	19	17833	A fragment of a magic wand illustrating a frog headed deity	Middle Kingdom	14	ca. 1981–1640 B.C.	-1981	-1640	148	L. 2.7 × W. 5.6 × Th. 0.9 cm (1 1/16 × 2 3/16 × 3/8 in.)	Rogers Fund and Edward S. Harkness Gift, 1922	19	104	645	135	689	1110	50	http://www.metmuseum.org/art/collection/search/557436	4/23/2018 8:00:01 AM	1