MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 45 rows (hide)

Query parameters

rowidObject NumberIs HighlightIs Public DomainObject IDDepartmentObject NameTitleCulturePeriodDynastyReignPortfolioArtist RoleArtist PrefixArtist Display NameArtist Display BioArtist SuffixArtist Alpha SortArtist NationalityArtist Begin DateArtist End DateObject DateObject Begin DateObject End DateMediumDimensionsCredit LineGeography TypeCityStateCountyCountryRegionSubregionLocaleLocusExcavationRiverClassificationRights and ReproductionLink ResourceRepository
5280 83.2.133 0 1 5653 1 296 Pitcher 2                           1800–1810 1800 1800 119 H. 9 1/2 in. (24.1 cm) Gift of William H. Huntington, 1883 2 61 11 11 4             5   1
5281 10.60.24 0 1 5654 1 296 Pitcher 1                           1830–70 1830 1870 598 H. 9 1/4 in. (23.5 cm) Rogers Fund, 1910 2       3 1           3   1
5282 10.60.25 0 1 5655 1 296 Pitcher 1                           1830–70 1830 1870 598 H. 10 in. (25.4 cm); Diam. 6 in. (15.2 cm) Rogers Fund, 1910 2       3 1           3   1
5283 10.60.27 0 1 5656 1 296 Pitcher 1                           1830–70 1830 1870 192 H. 10 1/4 in. (26 cm) Rogers Fund, 1910 2 32     3             3   1
5286 10.122.28 0 1 5659 1 296 Pitcher 1                           1825–40 1825 1825 195 H. 7 in. (17.8 cm); Diam. 5 1/2 in. (14 cm) Rogers Fund, 1910 2       3             3   1
5296 14.74.19 0 1 5669 1 296 Pitcher 15                           1770–1830 1770 1830 1059 H. 3 3/4 in. (9.5 cm) Gift of Frederick W. Hunter, 1913 2       4             3   1
5297 14.120.3 0 1 5670 1 296 Pitcher 1                           1800–1830 1800 1830 1060 H. 5 1/2 in. (14 cm); Diam. 6 in. (14 x 15.2 cm) Gift of Frederick W. Hunter, 1914 2       3 2           3   1
5298 14.120.15 0 1 5671 1 296 Pitcher 1                           1800–1830 1800 1830 1060 H. 4 1/4 in. (10.8 cm); Diam. 4 7/8 in. (12.4 cm) Gift of Frederick W. Hunter, 1914 2       3 2           3   1
5336 40.13.2 0 1 5709 1 296 Pitcher 1                           1815–40 1815 1815 195 H. 4 3/4 in. (12.1 cm) Rogers Fund, 1940 2       3             3   1
5337 41.135.3 0 1 5710 1 296 Pitcher 1                           1830–70 1830 1870 118 H. 10 3/4 in. (27.3 cm) Rogers Fund, 1941 2 122     3             5   1
5342 46.140.22 0 1 5715 1 296 Pitcher 1                           1850–70 1850 1870 178 H. 6 1/8 in. (15.6 cm) Gift of Mrs. Emily Winthrop Miles, 1946 2 32     3             3   1
5346 46.140.243 0 1 5719 1 296 Pitcher 15                           ca. 1885 1882 1885 1070 H. 4 1/2 in. (11.4 cm) Gift of Mrs. Emily Winthrop Miles, 1946 2   13 13 4             3   1
5347 46.140.782 0 1 5720 1 296 Pitcher 1                           1850–60 1850 1860 178 H. 6 3/8 in. (16.2 cm) Gift of Mrs. Emily Winthrop Miles, 1946 2 32     3             3   1
5348 46.140.783 0 1 5721 1 296 Pitcher 1                           1850–60 1850 1860 178 H. 6 1/2 in. (16.5 cm) Gift of Mrs. Emily Winthrop Miles, 1946 2 32     3             3   1
5353 47.90.10 0 1 5726 1 296 Pitcher 1                           1830–70 1830 1870 103 3 1/4 x 3 1/4 x 2 1/2 in. (8.3 x 8.3 x 6.4 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5354 47.90.19 0 1 5727 1 296 Pitcher 1                           1830–70 1830 1870 103 4 3/8 x 3 1/8 x 3 1/4 in. (11.1 x 7.9 x 8.3 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5355 47.90.20 0 1 5728 1 296 Pitcher 1                           1830–70 1830 1870 103 3 5/8 x 3 3/8 x 2 1/8 in. (9.2 x 8.6 x 5.4 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5356 47.90.39 0 1 5729 1 296 Pitcher 1                           1830–70 1830 1870 103 8 3/4 x 4 x 3 1/2 in. (22.2 x 10.2 x 8.9 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5357 47.90.47 0 1 5730 1 296 Pitcher 1                           1830–70 1830 1870 103 4 1/8 x 3 1/2 x 3 in. (10.5 x 8.9 x 7.6 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5358 47.90.52 0 1 5731 1 296 Pitcher 1                           1830–70 1830 1870 103 4 1/8 x 3 1/2 x 2 3/16 in. (10.5 x 8.9 x 5.6 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5359 47.90.79 0 1 5732 1 296 Pitcher 1                           1830–70 1830 1870 103 4 7/8 x 4 x 3 9/16 in. (12.4 x 10.2 x 9 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5360 47.90.82 0 1 5733 1 296 Pitcher 1                           1830–70 1830 1870 103 7 5/8 x 5 3/8 x 5 1/16 in. (19.4 x 13.7 x 12.9 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5361 47.90.84 0 1 5734 1 296 Pitcher 1                           1830–70 1830 1870 103 7 1/8 x 4 x 3 5/8 in. (18.1 x 10.2 x 9.2 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5362 47.90.90 0 1 5735 1 296 Pitcher 1                           1830–70 1830 1870 103 4 1/4 x 4 5/8 x 3 3/8 in. (10.8 x 11.7 x 8.6 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5363 47.90.136 0 1 5736 1 296 Pitcher 1                           1830–70 1830 1870 103 3 5/8 x 3 1/4 x 2 5/8 in. (9.2 x 8.3 x 6.7 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5364 47.90.137 0 1 5737 1 296 Pitcher 1                           1830–70 1830 1870 103 3 3/4 x 3 1/4 x 2 1/16 in. (9.5 x 8.3 x 5.2 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5365 47.90.138 0 1 5738 1 296 Pitcher 1                           1830–70 1830 1870 103 3 x 3 1/8 x 2 3/8 in. (7.6 x 7.9 x 6 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5366 47.90.139 0 1 5739 1 296 Pitcher 1                           1830–70 1830 1870 103 3 5/8 x 3 5/8 x 2 7/8 in. (9.2 x 9.2 x 7.3 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5367 47.90.140 0 1 5740 1 296 Pitcher 1                           1830–70 1830 1870 103 H. 3 5/8 in. (9.2 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5368 47.90.143 0 1 5741 1 296 Pitcher 1                           1830–70 1830 1870 103 3 1/4 x 2 5/8 x 2 1/4 in. (8.3 x 6.7 x 5.7 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5369 47.90.144 0 1 5742 1 296 Pitcher 1                           1830–70 1830 1870 103 2 x 2 5/16 x 1 15/16 in. (5.1 x 5.9 x 4.9 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5370 47.90.146 0 1 5743 1 296 Pitcher 1                           1830–70 1830 1870 103 2 1/2 x 1 13/16 x 1 9/16 in. (6.4 x 4.6 x 4 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5371 47.90.178 0 1 5744 1 296 Pitcher 1                           1830–70 1830 1870 103 H. 3 7/8 in. (9.8 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5372 47.90.186 0 1 5745 1 296 Pitcher 1                           1830–70 1830 1870 103 10 7/8 x 8 1/2 x 7 3/4 in. (27.6 x 21.6 x 19.7 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5373 47.90.188 0 1 5746 1 296 Pitcher 1                           1830–70 1830 1870 103 9 1/4 x 7 1/2 x 6 1/2 in. (23.5 x 19.1 x 16.5 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5374 47.90.189 0 1 5747 1 296 Pitcher 1                           1830–70 1830 1870 103 10 1/2 x 8 x 6 7/8 in. (26.7 x 20.3 x 17.5 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5375 47.90.190 0 1 5748 1 296 Pitcher 1                           1830–70 1830 1870 103 9 1/4 x 8 1/2 x 6 1/8 in. (23.5 x 21.6 x 15.6 cm) Gift of Dr. Charles W. Green, 1947 2 25     3             5   1
5380 1979.191.1 0 1 5754 1 296 Pitcher 1                           1835–70 1835 1870 194 H. 8 15/16 in. (22.7 cm); Diam. 7 5/8 in. (19.4 cm) Gift of Anita G. Muller, 1979 2 32     3             3   1
5382 1980.356 0 1 5756 1 296 Pitcher 1                           1820–40 1820 1840 382 H. 7 1/2 in. (19.1 cm) Friends of the American Wing Fund, 1980 2 32     3             3   1
5386 1980.502.6 0 0 5760 1 296 Pitcher 24                           1870–1930 1870 1930 966 H. 8 in. (20.3 cm) Gift of Henry G. Schiff, 1980 2       3 2           3   1
5453 10.60.26 0 1 5829 1 296 Pitcher 1         1 Probably New England Glass Company American, East Cambridge, Massachusetts, 1818–1888   10   1818 1888 1817–40 1817 1840 112 11 3/8 x 6 in. (28.9 x 15.2 cm) Rogers Fund, 1910 2 6     3             3   1
5464 14.102.381 0 1 5840 1 296 Pitcher 1         1 Probably Pyatt active 1849–79   820   1849 1879 ca. 1849–79 1846 1879 118 H. 7 5/8 in. (19.4 cm) Bequest of Mary Mandeville Johnston, from the collection of Mr. and Mrs. Edward W. S. Johnston, 1914 2 57     3             5   1
5481 41.135.2 0 1 5858 1 296 Pitcher 1         1 Probably United States Pottery Company 1852–58   75   1852 1852 1849–58 1849 1858 118 H. 9 7/8 in. (25.1 cm) Rogers Fund, 1941 2 25     3             5   1
5482 41.135.5 0 1 5859 1 296 Pitcher 1         1 Probably United States Pottery Company 1852–58   75   1852 1852 1849–58 1849 1858 118 H. 6 1/8 in. (15.6 cm) Rogers Fund, 1941 2 25     3             5   1
5501 1984.423 0 1 5879 1 296 Pitcher 1         20 Probably Woodward and Blakely Company 1848–57   826   1848 1848 1848–57 1848 1848 21 H. 11 3/4 in. (29.8 cm) Friends of the American Wing Fund, 1984 2 70     3             5   1
Powered by Datasette · Query took 7.949ms · Data license: CC0 · Data source: metmuseum/openaccess