MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 50 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 "City" = :p0 and "Geography Type" = :p1 order by Title limit 101

Query parameters

This data as json, CSV

rowid	Object Number	Is Highlight	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
318896	48.101.13	0	1	453995	9	48	Bottle with Ribbed Design	11th–12th century	1000	1199	47265	H. 6 5/16 in. (16 cm) Diam. (base) 3 5/8 in. (9.2 cm)	Rogers Fund, 1948	19	1514	59	1	http://www.metmuseum.org/art/collection/search/453995	4/23/2018 8:00:01 AM	1
316006	48.101.15	0	0	450770	9	106	Bowl	11th century	1000	1099	46533	H. 11/16 in. (1.7 cm) Diam. 1 5/16 in. (3.4 cm)	Rogers Fund, 1948	19	1514	59	1	http://www.metmuseum.org/art/collection/search/450770	4/23/2018 8:00:01 AM	1
317020	65.106.1	0	0	451801	9	106	Bowl	10th century	900	999	44669	H. 5 1/8 (13 cm) Diam. 14 5/16 in. (36.4 cm)	Purchase, Joseph Pulitzer Bequest, 1965	19	1514	59	5	http://www.metmuseum.org/art/collection/search/451801	4/23/2018 8:00:01 AM	1
317021	65.106.2	1	1	451802	9	106	Bowl with Arabic Inscription	10th century	900	999	46819	H. 7 in. (17.8 cm) Diam. 18 in. (45.7 cm)	Rogers Fund, 1965	19	1514	59	5	http://www.metmuseum.org/art/collection/search/451802	4/23/2018 8:00:01 AM	1
320028	39.40.127.33	0	1	457105	9	1	Coin	dated A.H. 376/A.D. 986	961	1011	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457105	4/23/2018 8:00:01 AM	1
320032	39.40.127.37	0	1	457109	9	1	Coin	dated A.H. 370/ A.D. 980	955	1005	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457109	4/23/2018 8:00:01 AM	1
320039	39.40.127.44	0	1	457116	9	1	Coin	dated A.H. 348/ A.D. 958/59	934	984	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457116	4/23/2018 8:00:01 AM	1
320042	39.40.127.47	0	1	457119	9	1	Coin	dated A.H. 376/A.D. 986	961	1011	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457119	4/23/2018 8:00:01 AM	1
320049	39.40.127.54	0	1	457126	9	1	Coin	dated A.H. 377/A.D. 987	962	1012	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457126	4/23/2018 8:00:01 AM	1
320078	39.40.127.83	0	1	457155	9	1	Coin	dated A.H. 375/A.D. 985	960	1010	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457155	4/23/2018 8:00:01 AM	1
320081	39.40.127.86	0	1	457158	9	1	Coin	dated A.H. 366/ A.D. 976	951	1001	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457158	4/23/2018 8:00:01 AM	1
320087	39.40.127.92	0	1	457164	9	1	Coin	dated A.H. 36?/ A.D. 97?	955	1005	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457164	4/23/2018 8:00:01 AM	1
320093	39.40.127.98	0	1	457170	9	1	Coin	dated A.H. 37?/ A.D. 98?	951	1004	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457170	4/23/2018 8:00:01 AM	1
320094	39.40.127.99	0	1	457171	9	1	Coin	977–82	952	1007	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457171	4/23/2018 8:00:01 AM	1
320095	39.40.127.100	0	1	457172	9	1	Coin	dated A.H. 363/ A.D. 973	948	998	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457172	4/23/2018 8:00:01 AM	1
320096	39.40.127.101	0	1	457173	9	1	Coin	976–83	951	1008	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457173	4/23/2018 8:00:01 AM	1
320102	39.40.127.107	0	1	457179	9	1	Coin	977–82	952	1007	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457179	4/23/2018 8:00:01 AM	1
320104	39.40.127.109	0	1	457181	9	1	Coin	dated A.H. 374/A.D. 984	959	1009	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457181	4/23/2018 8:00:01 AM	1
320107	39.40.127.112	0	1	457184	9	1	Coin	dated A.H. 364/ A.D. 974/75	949	999	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457184	4/23/2018 8:00:01 AM	1
320108	39.40.127.113	0	1	457185	9	1	Coin	dated A.H. 364/ A.D. 974/75	949	999	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457185	4/23/2018 8:00:01 AM	1
320111	39.40.127.116	0	1	457188	9	1	Coin	dated A.H. 367/ A.D. 977/78	952	1002	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457188	4/23/2018 8:00:01 AM	1
320112	39.40.127.117	0	1	457189	9	1	Coin	949–76	924	1001	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457189	4/23/2018 8:00:01 AM	1
320117	39.40.127.122	0	1	457194	9	1	Coin	dated A.H. 368/ A.D. 978	953	1003	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457194	4/23/2018 8:00:01 AM	1
320120	39.40.127.125	0	1	457197	9	1	Coin	dated A.H. 376/A.D. 986	961	1011	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457197	4/23/2018 8:00:01 AM	1
320131	39.40.127.136	0	1	457208	9	1	Coin	dated A.H. 373/ A.D. 983	958	1008	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457208	4/23/2018 8:00:01 AM	1
320137	39.40.127.142	0	1	457214	9	1	Coin	dated A.H. 371/ A.D. 981	956	1006	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457214	4/23/2018 8:00:01 AM	1
320138	39.40.127.143	0	1	457215	9	1	Coin	dated A.H. 367/ A.D. 979	954	1004	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457215	4/23/2018 8:00:01 AM	1
320142	39.40.127.147	0	1	457219	9	1	Coin	10th century	900	999	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457219	4/23/2018 8:00:01 AM	1
320144	39.40.127.149	0	1	457221	9	1	Coin	977–82	952	1007	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457221	4/23/2018 8:00:01 AM	1
320146	39.40.127.151	0	1	457223	9	1	Coin	dated A.H. 37?/ A.D. 98?	952	1007	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457223	4/23/2018 8:00:01 AM	1
320147	39.40.127.152	0	1	457224	9	1	Coin	977–82	952	1007	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457224	4/23/2018 8:00:01 AM	1
320152	39.40.127.157	0	1	457229	9	1	Coin	983–97	958	1022	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457229	4/23/2018 8:00:01 AM	1
320153	39.40.127.158	0	1	457230	9	1	Coin	dated A.H. 37?/ A.D. 98?	955	1014	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457230	4/23/2018 8:00:01 AM	1
320154	39.40.127.159	0	1	457231	9	1	Coin	977–82	952	1007	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457231	4/23/2018 8:00:01 AM	1
320155	39.40.127.160	0	1	457232	9	1	Coin	dated A.H. 375/ A.D. 985–86	960	1011	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457232	4/23/2018 8:00:01 AM	1
320156	39.40.127.161	0	1	457233	9	1	Coin	10th century	900	999	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457233	4/23/2018 8:00:01 AM	1
320158	39.40.127.163	0	1	457235	9	1	Coin	dated A.H. 369/A.D. 979	954	1004	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457235	4/23/2018 8:00:01 AM	1
320161	39.40.127.166	0	1	457238	9	1	Coin	977–82	952	1007	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457238	4/23/2018 8:00:01 AM	1
320163	39.40.127.168	0	1	457240	9	1	Coin	dated A.H. 37?/ A.D. 98?	955	1014	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457240	4/23/2018 8:00:01 AM	1
320165	39.40.127.170	0	1	457242	9	1	Coin	dated A.H. 37?/ A.D. 98?	955	1014	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457242	4/23/2018 8:00:01 AM	1
320169	39.40.127.174	0	1	457246	9	1	Coin	977–82	952	1007	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457246	4/23/2018 8:00:01 AM	1
320172	39.40.127.177	0	1	457249	9	1	Coin	dated A.H. 37?/ A.D. 98?	956	1004	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457249	4/23/2018 8:00:01 AM	1
320173	39.40.127.178	0	1	457250	9	1	Coin	dated A.H. 37.?/ A.D. 98.?	951	1022	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457250	4/23/2018 8:00:01 AM	1
320174	39.40.127.179	0	1	457251	9	1	Coin	970–97	945	1022	2		Rogers Fund, 1939	19	1514	59	241	http://www.metmuseum.org/art/collection/search/457251	4/23/2018 8:00:01 AM	1
316831	60.39	0	1	451609	9	227	Ewer	late 12th–early 13th century	1175	1225	46765	H. 6 5/8 in. (16.8 cm) Diam. 5 3/8 in. (13.7 cm)	Rogers Fund, 1960	19	1514	59	5	http://www.metmuseum.org/art/collection/search/451609	4/23/2018 8:00:01 AM	1
314734	38.40.291	0	0	449496	9	116	Jar	8th–10th century	700	999	45996		Rogers Fund, 1938	19	1514	59	5	http://www.metmuseum.org/art/collection/search/449496	4/23/2018 8:00:01 AM	1
314736	38.40.293	0	1	449498	9	116	Jar	11th–12th century	1000	1199	46071	H. 5 5/8 in. (14.3 cm) Diam. 4 3/8 in. (11.1 cm) Wt. 12.1 oz. (343.1 g)	Rogers Fund, 1938	19	1514	59	5	http://www.metmuseum.org/art/collection/search/449498	4/23/2018 8:00:01 AM	1
314735	38.40.292	0	1	449497	9	116	Jug with Handles	11th–12th century	1000	1199	45900	H. 9 7/8 in. (25.1 cm)	Rogers Fund, 1938	19	1514	59	5	http://www.metmuseum.org/art/collection/search/449497	4/23/2018 8:00:01 AM	1
314292	36.20.20	0	1	449054	9	558	Lamp	10th century	900	999	44685	H. 1 1/8 in. (2.9 cm) W. 4 3/8 in. (11.1 cm)	Rogers Fund, 1936	19	1514	59	209	http://www.metmuseum.org/art/collection/search/449054	4/23/2018 8:00:01 AM	1
316015	48.101.24	0	1	450779	9	760	Roundel	9th–10th century	800	999	46537		Rogers Fund, 1948	19	1514	59	5	http://www.metmuseum.org/art/collection/search/450779	4/23/2018 8:00:01 AM	1