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 "City" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Culture	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	County	Country	Classification	Link Resource	Metadata Date	Repository
217013	21.4.3	1	344503	11	97	Aesopi Fabulas		1498	Published by\|Translated by\|Written by\|Woodcuts designed by	Giovanni & Alberto Alvise\|Accio Zucchi\|Aesop\|Liberale da Verona	Italian\|Greek, ca. 620–560 B.C.\|Italian, Verona ca. 1445–1527/29 Verona	, Verona	20883	1071	-0620 \|1445	-0560 \|1529	June 26, 1479	1479	1479	33926	Overall: 8 1/4 x 6 1/4 x 7/8 in. (21 x 15.8 x 2.2 cm)	Rogers Fund, 1920		1115			442	http://www.metmuseum.org/art/collection/search/344503	4/23/2018 8:00:01 AM	1
222504	66.675	0	350065	11	97	Il Pastor Fido Tragicommedia		2476	Illustrations etched and designed by\|Etched by\|Designed by\|Designed by\|Written by\|Etched by	Nicolas Chasteau\|Vincenzo Franceschini\|William Kent\|Pier Leone Ghezzi\|Battista Guarini\|Francesco Zucchi	French, Paris 1680–ca. 1750 Paris\|Italian, Rome, 1680–after 1740\|British, Bridlington, Yorkshire ca. 1685–1748 London\|Italian, Comunanza near Ascoli Piceno 1674–1755 Rome\|Italian, 1538–1612\|Italian, Venice 1692–1764 Venice		24698	1635	1680 \|1680 \|1684 \|1674 \|1538 \|1692	1755 \|1740 \|1748 \|1755 \|1612 \|1764	1735	1735	1735	35087	9 13/16 × 7 5/16 × 1 3/4 in. (25 × 18.5 × 4.5 cm)	The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966		1115			442	http://www.metmuseum.org/art/collection/search/350065	4/23/2018 8:00:01 AM	1
225797	58.570	0	353399	11	97	Della colitvazione de' monti, canti IV		1649	Written by	Bartolommeo Lorenzi\|Domenico Lorenzi\|Guiseppe Lante	Italian, 1732–1822\|Italian, active ca. 1778\|Italian, born Belluno, 1726		27217	145	1732 \|1770 \|1726	1822 \|1785 \|1826	1778	1778	1778			The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1958		1115			442	http://www.metmuseum.org/art/collection/search/353399	4/23/2018 8:00:01 AM	1
229023	32.115	0	356668	11	13811	De origine et amplitudine civitatis Veronæ: Eiusdem de viris illustribus antiquis veronensibus. De his, qui potiti fuerunt dominio civitatis Veronæ. De monumentis antiquis urbis, & agri veronensis. De interpretatione litterarum antiquarum.		3416		Giovanni Battista Caroto\|Torello Sarayna\|Antonio Putelleti	Italian, 1488–1563/66\|Italian, died 1550		29446	145	1488 \|1550	1563 \|1550	1540	1540	1540	33727	12 13/16 x 8 9/16 x 1 1/16 in. (32.5 x 21.7 x 2.7 cm)	Harris Brisbane Dick Fund, 1932		1115			665	http://www.metmuseum.org/art/collection/search/356668	4/23/2018 8:00:01 AM	1
230587	26.71.4	1	358276	11	97	De Re Militari (On the Military Arts)		854		Johannes ex Verona\|Roberto Valturio\|Matteo de' Pasti	Italian, active Verona ca. 1472\|Italian, Rimini 1405–1475 Rimini\|Italian, Verona ca. 1420–after 1467 Rimini		30502	145	1420 \|1405 \|1420	1520 \|1475 \|1467	1472	1472	1472	36346	13 x 9 7/16 x 1 7/8 in. (33 x 24 x 4.8 cm)	Harris Brisbane Dick Fund, 1926		1115			442	http://www.metmuseum.org/art/collection/search/358276	4/23/2018 8:00:01 AM	1
324103	12.56.3	1	463604	6	14664	Manuscript Illumination with David in Prayer in an Initial M, from a Psalter	36	2		Girolamo dai Libri	Italian, Verona 1474–1555 Verona		43581	6	1474	1555	1501–2	1501	1502	49035	Overall: 8 15/16 x 6 1/4 in. (22.7 x 15.9 cm) Illumination: 3 3/16 x 3 1/8 in. (8.1 x 8 cm) Mat: 19 3/16 x 14 3/16 in. (48.7 x 36.1 cm)	Rogers Fund, 1912	1	1115		14	162	http://www.metmuseum.org/art/collection/search/463604	4/23/2018 8:00:01 AM	1
324104	12.56.4	1	463605	6	14664	Manuscript Illumination with Singing Monks in an Initial D, from a Psalter	36	2		Girolamo dai Libri	Italian, Verona 1474–1555 Verona		43581	6	1474	1555	1501–2	1501	1502	49035	Overall: 9 1/16 x 7 in. (23 x 17.8 cm) Illumination: 4 x 4 1/8 in. (10.2 x 10.5 cm) Mat size: 19 1/4 x 14 1/4 in. (48.9 x 36.2 cm)	Rogers Fund, 1912	1	1115		14	162	http://www.metmuseum.org/art/collection/search/463605	4/23/2018 8:00:01 AM	1
326375	21.123.2	1	466328	6	255	Column and Capital	229										14th century	1300	1399	49702	Overall: 107 x 17 x 16 1/4 in. (271.8 x 43.2 x 41.3 cm)	Rogers Fund, 1921	1	1115	684	14	806	http://www.metmuseum.org/art/collection/search/466328	4/23/2018 8:00:01 AM	1
327070	30.95.138	1	467383	6	3890	Standing Virgin and Child	229										ca. 1425	1425	1425	49925	Overall: 51 1/4 x 16 3/4 x 10 7/8 in. (130.2 x 42.5 x 27.6 cm) Weight approx.: 862.953lb. (391.4kg)	Theodore M. Davis Collection, Bequest of Theodore M. Davis, 1915	1	1115	327	14	806	http://www.metmuseum.org/art/collection/search/467383	4/23/2018 8:00:01 AM	1
327965	62.122.17	1	468590	6	14658	Manuscript Illumination with the Holy Women at the Tomb in an Initial A, from an Antiphonary	36	2		Girolamo dai Libri	Italian, Verona 1474–1555 Verona		43581	6	1474	1555	ca. 1490–1500	1490	1500	6705	Overall: 8 15/16 x 6 1/4 in. (22.7 x 15.9 cm) Illumination: 5 15/16 x 5 9/16 in. (15.1 x 14.2 cm) Mat size: 19 1/4 x 14 1/4 in. (48.9 x 36.2 cm)	Bequest of Millie Bruhl Frederick, 1962	1	1115		14	162	http://www.metmuseum.org/art/collection/search/468590	4/23/2018 8:00:01 AM	1