MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 35 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 "Geography Type" = :p0 and "Object Name" = :p1 order by Locale limit 101

Query parameters

This data as json, CSV

rowid	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Object Date	Object Begin Date	Object End Date	Medium	Dimensions	Credit Line	Geography Type	City	Country	Classification	Link Resource	Metadata Date	Repository
314303	36.20.34	0	449065	9	116	Jar	10th–11th century	900	1099	45923	H. 2 1/8 in. (5.4 cm) Diam. 2 1/2 in. (6.4 cm) Wt. 2.8 oz. (79.4 g)	Rogers Fund, 1936	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449065	4/23/2018 8:00:01 AM	1
314310	36.20.41	1	449072	9	116	Jar	9th–10th century	800	999	45933		Rogers Fund, 1936	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449072	4/23/2018 8:00:01 AM	1
314327	36.20.58	1	449089	9	116	Jar	9th–10th century	800	999	45943		Rogers Fund, 1936	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449089	4/23/2018 8:00:01 AM	1
314573	38.40.123	0	449335	9	116	Jar	late 8th–first half 9th century	775	850	45933		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449335	4/23/2018 8:00:01 AM	1
314601	38.40.152	1	449363	9	116	Jar	9th–10th century	800	999	45933		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449363	4/23/2018 8:00:01 AM	1
314630	38.40.182	1	449392	9	116	Jar	10th–11th century	900	1099	45933	H. 15 3/8 in. (39.1 cm) W. 18 1/2 in. (47 cm)	Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449392	4/23/2018 8:00:01 AM	1
314644	38.40.196	1	449406	9	116	Green Glass Jar	10th century	900	999	45968	H. 3 7/16 in. (8.7 cm)	Rogers Fund, 1938	45	1514	59	3	http://www.metmuseum.org/art/collection/search/449406	4/23/2018 8:00:01 AM	1
314657	38.40.209	0	449419	9	116	Jar	9th century	800	899	44668		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449419	4/23/2018 8:00:01 AM	1
314658	38.40.210	1	449420	9	116	Jar	8th–9th century	700	899	45934		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449420	4/23/2018 8:00:01 AM	1
314659	38.40.211	1	449421	9	116	Jar	8th–10th century	700	999	45934		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449421	4/23/2018 8:00:01 AM	1
314660	38.40.212	1	449422	9	116	Jar	9th century	800	899	45934		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449422	4/23/2018 8:00:01 AM	1
314662	38.40.214	1	449424	9	116	Jar	10th–12th century	900	1199	45933		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449424	4/23/2018 8:00:01 AM	1
314663	38.40.215	0	449425	9	116	Jar	9th century	800	899	45933		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449425	4/23/2018 8:00:01 AM	1
314667	38.40.219	1	449429	9	116	Jar	8th–early 9th century	700	825	45996		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449429	4/23/2018 8:00:01 AM	1
314668	38.40.220	1	449430	9	116	Jar	late 8th–first half 9th century	775	825	44668		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449430	4/23/2018 8:00:01 AM	1
314674	38.40.226	1	449436	9	116	Jar	late 9th–10th century	875	999	45933		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449436	4/23/2018 8:00:01 AM	1
314693	38.40.245	1	449455	9	116	Jar	late 8th–9th century	775	899	45933		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449455	4/23/2018 8:00:01 AM	1
314702	38.40.254	0	449464	9	116	Jar	9th century	800	899	44668	H. 7/8 in. (2.2 cm) Diam. 7/8 in. (2.2 cm)	Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449464	4/23/2018 8:00:01 AM	1
314719	38.40.276	1	449481	9	116	Jar	9th–10th century	800	999	45934		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449481	4/23/2018 8:00:01 AM	1
314723	38.40.280	0	449485	9	116	Jar	9th century	800	899	45933		Rogers Fund, 1938	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449485	4/23/2018 8:00:01 AM	1
314795	39.40.23	1	449557	9	116	Jar	9th century	800	899	44668		Rogers Fund, 1939	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449557	4/23/2018 8:00:01 AM	1
314853	39.40.83	0	449615	9	116	Jar	9th–10th century	800	999	45900	H. 4 3/4 in. (12 cm) Diam. 3 7/8 in. (9.8 cm)	Rogers Fund, 1939	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449615	4/23/2018 8:00:01 AM	1
314858	39.40.88	0	449620	9	116	Jar	9th–10th century	800	999	44668	H. 2 9/16 in. (6.5 cm) W. 2 5/8 in. (6.7 cm)	Rogers Fund, 1939	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449620	4/23/2018 8:00:01 AM	1
314860	39.40.90	1	449622	9	116	Jar	9th–10th century	800	999	45934		Rogers Fund, 1939	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449622	4/23/2018 8:00:01 AM	1
314861	39.40.91a, b	1	449623	9	116	Jar	9th–10th century	800	999	45934		Rogers Fund, 1939	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449623	4/23/2018 8:00:01 AM	1
314874	39.40.105	1	449636	9	116	Jar	9th–10th century	800	999	45934		Rogers Fund, 1939	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449636	4/23/2018 8:00:01 AM	1
314890	39.40.121	1	449652	9	116	Jar	10th century	900	999	45933		Rogers Fund, 1939	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449652	4/23/2018 8:00:01 AM	1
314946	40.170.12	0	449708	9	116	Jar	9th century	800	899	46158	H. 4 7/16 in. (11.2 cm) Diam. 2 3/8 in. (6.1 cm) Base: 3 1/4 in. (8.3 cm)	Rogers Fund, 1940	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449708	4/23/2018 8:00:01 AM	1
314981	40.170.48	1	449743	9	116	Jar	9th century	800	899	45934		Rogers Fund, 1940	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449743	4/23/2018 8:00:01 AM	1
315010	40.170.78	1	449772	9	116	Jar	11th–12th century	1000	1199	45933		Rogers Fund, 1940	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449772	4/23/2018 8:00:01 AM	1
315011	40.170.79	1	449773	9	116	Jar	8th–9th century	700	899	46180		Rogers Fund, 1940	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449773	4/23/2018 8:00:01 AM	1
315088	40.170.163	1	449851	9	116	Jar	11th–12th century	1000	1199	46215	H. 6 3/16 in. (15.7 cm) Diam. 2 15/16 in. (7.4 cm) Base: 4 in. (10.2 cm)	Rogers Fund, 1940	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449851	4/23/2018 8:00:01 AM	1
315107	40.170.185	1	449870	9	116	Jar	late 8th–9th century	775	899	45934		Rogers Fund, 1940	45	1514	59	5	http://www.metmuseum.org/art/collection/search/449870	4/23/2018 8:00:01 AM	1
315995	48.101.1	1	450759	9	116	Jar	9th–10th century	800	999	46528	H. 3 3/16 in. (8.1 cm) Diam. 2 1/4 in. (5.7 cm) Wt. 5.7 oz. (161.6 g)	Rogers Fund, 1948	45	1514	59	5	http://www.metmuseum.org/art/collection/search/450759	4/23/2018 8:00:01 AM	1
316004	48.101.12	1	450768	9	116	Jar	11th century	1000	1099	45943		Rogers Fund, 1948	45	1514	59	5	http://www.metmuseum.org/art/collection/search/450768	4/23/2018 8:00:01 AM	1