MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

Custom SQL query returning 79 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
8551 10.122.29 0 0 9196 1 7 Vase 1                           19th century 1800 1900 194 H. 10 5/8 in. (27 cm) Rogers Fund, 1910 1       3             3   1
8556 13.179.42 0 1 9201 1 7 Vase 1                           1800–1830 1800 1830 194 H. 8 in. (20.3 cm) Gift of Frederick W. Hunter, 1913 2       3 1           3   1
542 40.150.1 0 1 603 1 48 Bottle 1                           1820–40 1820 1840 194 H. 8 3/8 in. (21.3 cm) Bequest of Constance R. Brown, 1939 5 57     3             3   1
543 40.150.2 0 1 604 1 48 Bottle 1                           1820–40 1820 1840 194 H. 7 3/8 in. (18.7 cm) Bequest of Constance R. Brown, 1939 5 57     3             3   1
546 40.150.78 0 0 607 1 48 Bottle 1                           19th century 1800 1900 194 H. 5 1/4 in. (13.3 cm) Bequest of Constance R. Brown, 1939 1       3             3   1
547 40.150.83 0 1 608 1 48 Bottle 1                           1800–1830 1800 1830 194 H. 3 3/8 in. (8.6 cm) Bequest of Constance R. Brown, 1939 3 58     8             3   1
555 42.20.2 0 1 616 1 48 Bottle 1                           ca. 1820 1817 1820 194 H. 4 3/8 in. (11.1 cm) Rogers Fund, 1942 1       3 2           3   1
1373 1980.502.74 0 1 1482 1 48 Castor Bottle 1                           1800–1860 1800 1860 194 H. 6 in. (15.2 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
4925 14.74.3 0 1 5288 1 49 Mug 1                           1770–1800 1770 1800 194 H. 6 in. (15.2 cm) Gift of Frederick W. Hunter, 1913 2       3             3   1
8371 13.179.166 0 0 9011 1 60 Tumbler 24                           1770–1830 1770 1830 194 H. 6 1/2 in. (16.5 cm) Gift of Frederick W. Hunter, 1913 2       3             3   1
8372 13.179.189 0 1 9012 1 60 Tumbler 1                           1770–1830 1770 1830 194 H. 5 5/8 in. (14.3 cm) Gift of Frederick W. Hunter, 1913 2       3             3   1
8375 22.224.12 0 1 9015 1 60 Tumbler 1                           1800–1830 1800 1830 194 H. 4 in. (10.2 cm); Diam. 3 1/2 in. (8.9 cm) Rogers Fund, 1922 1       3 2           3   1
3456 13.120.22 0 1 3694 1 96 Flask 1                           1750–1800 (?) 1750 1800 194 H. 5 1/2 in. (14 cm) Gift of Frederick W. Hunter, 1913 1       3             3   1
3463 38.78.1 0 1 3701 1 96 Flask 1                           1820–40 1820 1840 194 H. 6 5/8 in. (16.8 cm) Rogers Fund, 1938 1       3 2           3   1
3464 38.78.5 0 1 3702 1 96 Flask 1                           1770–1830 1770 1830 194 H. 6 5/8 in. (16.8 cm) Rogers Fund, 1938 2       3 2           3   1
3469 45.35.3 0 1 3707 1 96 Flask 1                           1770–1830 1770 1830 194 H. 6 1/4 in. (15.9 cm) Bequest of Helen Hay Whitney, 1944 1       3             3   1
3470 45.35.11 0 1 3708 1 96 Flask 1                           1800–1830 1800 1830 194 H. 8 in. (20.3 cm) Bequest of Helen Hay Whitney, 1944 1       3             3   1
1312 1980.462.2 0 1 1413 1 177 Carafe 1                           1850–70 1850 1870 194 H. 6 in. (15.2 cm); Diam. 5 1/4 in. (13.3 cm) Anonymous Gift, 1980 1 32     3             3   1
2106 13.31.29 0 1 2284 1 276 Cover 1                           1770–1800 1770 1800 194 H. 3 5/8 in. (9.2 cm); Diam. 3 5/8 in. (9.2 cm) Rogers Fund, 1913 2       3             3   1
3870 1980.463.1 0 1 4133 1 287 Goblet                             1876 1876 1876 194 H. 6 1/4 in. (15.9 cm); Diam. 3 1/4 in. (8.3 cm) Gift of Margaretta M. Salinger, 1980                       3   1
3871 1980.463.2 0 1 4134 1 287 Goblet                             1876 1876 1876 194 H. 6 1/4 in. (15.9 cm); Diam. 3 1/4 in. (8.3 cm) Gift of Margaretta M. Salinger, 1980                       3   1
3872 1980.463.3 0 1 4135 1 287 Goblet                             1876 1876 1876 194 H. 6 1/4 in. (15.9 cm); Diam. 3 1/4 in. (8.3 cm) Gift of Margaretta M. Salinger, 1980                       3   1
5295 14.74.18 0 1 5668 1 296 Pitcher 1                           1780–1825 1780 1825 194 H. 5 1/8 in. (13 cm) Gift of Frederick W. Hunter, 1914 5       3             3   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
6524 13.179.170 0 1 6981 1 299 Saltcellar 3                           1780–1825 1780 1825 194 H. 2 3/4 in. (7 cm) Gift of Frederick W. Hunter, 1913 3       6             3   1
6525 13.179.171 0 1 6982 1 299 Saltcellar 3                           1780–1825 1780 1825 194 H. 2 3/4 in. (7 cm) Gift of Frederick W. Hunter, 1913 3       6             3   1
6528 13.179.174 0 1 6985 1 299 Saltcellar 1                           1780–1825 1780 1825 194 H. 3 in. (7.6 cm) Gift of Frederick W. Hunter, 1913 5       3             3   1
6507 10.109.3 0 1 6964 1 300 Salt 1                           1820–40 1820 1840 194 Dimensions unavailable Rogers Fund, 1910 3       6             3   1
6508 10.122.23 0 1 6965 1 300 Salt 1                           1780–1825 1780 1825 194 2 1/2 x 2 3/4 in. (6.4 x 7 cm) Rogers Fund, 1910 3       6             3   1
6596 2000.511 0 1 7053 1 300 Salt 1         6 Attributed to|Attributed to John Frederick Amelung|New Bremen Glass Manufactory active 1784–ca. 1791|1784–1795   954   1784 |1784 1791 |1795 1784–95 1784 1784 194 H. 2 1/2 in. (6.4 cm); Diam. 2 1/4 in. (5.7 cm) Gift of Cylia G. and William G. Siedenburg, 2000 1 131 26 26 3             3   1
7445 13.31.28 0 1 7932 1 307 Sugar bowl 1                           1770–1800 1770 1800 194 H. 3 5/8 in. (9.2 cm); Diam. 3 5/8 in. (9.2 cm) Rogers Fund, 1913 2       3             3   1
7451 30.120.211 0 1 7938 1 307 Sugar bowl 1         29 Possibly by|Possibly by|Possibly by Henry William Stiegel|Stenger Glass House|American Flint Glass Manufactory American (born Germany), Cologne 1729–1785 Charming Forge, Pennsylvania|1764–1774 or|or 1031 14 1729 |1764 1785 |1774 1765–90 1765 1790 194 H. 4 1/4 in. (10.8 cm); Diam. 3 1/8 in. (7.9 cm) The Sylmaris Collection, Gift of George Coe Graves, 1930 3 156 51 51 8             3   1
7462 1980.502.86 0 1 7950 1 307 Sugar bowl 3                           1769–75 1769 1775 194 H. 6 3/8 in. (16.2 cm) Gift of Henry G. Schiff, 1980 3       6             3   1
3373 1978.504.3 0 1 3608 1 418 Finger Bowl 3                           1815–50 1815 1850 194 H. 3 7/8 in. (9.8 cm); Diam. 4 7/8 in. (12.4 cm) Gift of Mrs. Maurice Blin, 1978 3       6             3   1
3459 13.179.6 0 1 3697 1 445 Pocket bottle 1         6 Attributed to|Attributed to Henry William Stiegel|American Flint Glass Manufactory American (born Germany), Cologne 1729–1785 Charming Forge, Pennsylvania|1764–1774   524 14 1729 |1764 1785 |1774 1769–74 1769 1774 194 H. 5 1/4 in. (13.3 cm) Gift of Frederick W. Hunter, 1913 1 156     3             3   1
6204 15.79.3 0 1 6600 1 445 Pocket Bottle 1                           1780–1820 1780 1820 194 H. 6 1/2 in. (16.5 cm) Gift of Charles M. Baldwin, 1915 1       3 12           3   1
6205 20.109.22 0 1 6601 1 445 Pocket Bottle 1                           ca. 1821–40 1818 1840 194 6 1/8 x 5 in. (15.6 x 12.7 cm) Gift of Robert Macauley Jackson, 1920 2 63     3             3   1
6208 1980.502.37 0 1 6604 1 445 Pocket bottle 1                           1815–45 1815 1815 194 H. 6 5/8 in. (16.8 cm) Gift of Henry G. Schiff, 1980 7       8             3   1
6239 14.74.17 1 1 6635 1 445 Pocket bottle 1         6 Attributed to|Attributed to American Flint Glass Manufactory|Henry William Stiegel 1764–1774|American (born Germany), Cologne 1729–1785 Charming Forge, Pennsylvania   897 14 1764 |1729 1774 |1785 1769–74 1769 1774 194 H. 4 3/4 in. (12.1 cm) Gift of Frederick W. Hunter, 1914 1 156     3             3   1
6240 1980.502.68 0 1 6636 1 445 Pocket bottle 1         6 Attributed to|Attributed to Henry William Stiegel|American Flint Glass Manufactory American (born Germany), Cologne 1729–1785 Charming Forge, Pennsylvania|1764–1774   524 14 1729 |1764 1785 |1774 1769–74 1769 1774 194 H. 4 3/4 in. (12.1 cm) Gift of Henry G. Schiff, 1980 1 156     3             3   1
8056 34.65 0 1 8685 1 445 Pocket bottle 1         6 Attributed to|Attributed to American Flint Glass Manufactory|Henry William Stiegel 1764–1774|American (born Germany), Cologne 1729–1785 Charming Forge, Pennsylvania   897 14 1764 |1729 1774 |1785 1769–74 1769 1774 194 H. 5 in. (12.7 cm) Gift of Mrs. David Dows, 1934 3 273     8             3   1
4197 13.120.62 0 1 4530 1 539 Jelly Glass 3                           1785–1825 1785 1825 194 H. 4 in. (10.2 cm) Gift of Frederick W. Hunter, 1913 3       6             3   1
4202 X.260.1 0 1 4535 1 539 Jelly Glass 3                           1785–1825 1785 1825 194 H. 4 in. (10.2 cm) Museum Accession 3       6             3   1
4203 X.260.2 0 1 4536 1 539 Jelly Glass 3                           1785–1825 1785 1825 194 H. 3 13/16 in. (9.7 cm) Museum Accession 3       6             3   1
4382 10.122.17 0 0 4723 1 559 Chimney Lamp 1                           1800–1900 1800 1900 194 H. 16 1/2 in. (41.9 cm) Rogers Fund, 1910 1       3             3   1
6207 42.20.5 0 1 6603 1 718 Pocket flask 1                           1820–40 1820 1840 194 H. 5 1/8 in. (13 cm) Rogers Fund, 1942 2 57     3             3   1
6209 1980.502.38 0 0 6605 1 718 Pocket flask 1                           1800–1900 1800 1900 194 H. 6 7/8 in. (17.5 cm) Gift of Henry G. Schiff, 1980 2 57     3             3   1
6211 1980.502.40 0 0 6607 1 718 Pocket flask 1                           1800–1900 1800 1900 194 H. 5 1/8 in. (13 cm) Gift of Henry G. Schiff, 1980 2       3             3   1
6216 1980.502.45 0 1 6612 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 5 3/8 in. (13.7 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6217 1980.502.46 0 1 6613 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 7 1/4 in. (18.4 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6218 1980.502.47 0 1 6614 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 4 9/16 in. (11.6 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6220 1980.502.49 0 1 6616 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 5 3/8 in. (13.7 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6221 1980.502.50 0 1 6617 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 6 3/4 in. (17.1 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6222 1980.502.51 0 1 6618 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 6 1/16 in. (15.4 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6223 1980.502.52 0 1 6619 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 6 11/16 in. (17 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6225 1980.502.54 0 1 6621 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 6 1/4 in. (15.9 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6226 1980.502.55 0 1 6622 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 7 9/16 in. (19.2 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6228 1980.502.57 0 1 6624 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 4 1/4 in. (10.8 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6229 1980.502.58 0 1 6625 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 5 in. (12.7 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6230 1980.502.59 0 1 6626 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 4 1/2 in. (11.4 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6231 1980.502.60 0 1 6627 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 6 11/16 in. (17 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6234 1980.502.63 0 1 6630 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 6 in. (15.2 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6235 1980.502.64 0 1 6631 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 6 1/8 in. (15.6 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6236 1980.502.65 0 1 6632 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 4 5/8 in. (11.7 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6237 1980.502.66 0 1 6633 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 6 in. (15.2 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6238 1980.502.67 0 1 6634 1 718 Pocket flask 1                           1800–1860 1800 1860 194 H. 5 1/4 in. (13.3 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6213 1980.502.42 0 0 6609 1 719 Pocket dlask 1                           1800–1900 1800 1900 194 H. 5 1/8 in. (13 cm) Gift of Henry G. Schiff, 1980 5 63     3             3   1
6863 38.78.4 0 1 7329 1 775 Scent Bottle 1                           1780–1820 1780 1820 194 H. 2 in. (5.1 cm) Rogers Fund, 1938 1       3             3   1
6866 1980.502.90 0 1 7332 1 775 Scent Bottle 1                           1800–1860 1800 1860 194 H. 2 in. (5.1 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6867 1980.502.91 0 1 7333 1 775 Scent Bottle 1                           1800–1860 1800 1860 194 H. 2 3/4 in. (7 cm) Gift of Henry G. Schiff, 1980 1       3             3   1
6868 1980.502.92 0 1 7334 1 775 Scent Bottle                             1800–1860 1800 1860 194 H. 2 1/2 in. (6.4 cm) Gift of Henry G. Schiff, 1980                       3   1
7272 1980.502.87 0 0 7747 1 837 Spinning Implement                             1800–1900 1800 1900 194 H. 2 3/4 in. (7 cm) Gift of Henry G. Schiff, 1980                       3   1
9163 13.120.54 0 1 9878 1 978 Wine Glass 3                           1780–1825 1780 1825 194 H. 4 1/8 in. (10.5 cm) Gift of Frederick W. Hunter, 1913 3       6             3   1
9165 13.170.103 0 1 9880 1 978 Wine Glass 3                           1780–1825 1780 1825 194 H. 4 in. (10.2 cm) Gift of Frederick W. Hunter, 1913 3       6             3   1
9173 13.179.83 0 0 9888 1 978 Wine Glass 3                           1780–1825 1780 1825 194 H. 4 in. (10.2 cm) Gift of Frederick W. Hunter, 1913 3       6             3   1
9181 13.179.101 0 1 9896 1 978 Wine Glass 3                           1780–1825 1780 1825 194 H. 4 in. (10.2 cm) Gift of Frederick W. Hunter, 1913 3       6             3   1
9182 13.179.105 0 0 9897 1 978 Wine Glass 3                           1780–1825 1780 1825 194 H. 4 in. (10.2 cm) Gift of Frederick W. Hunter, 1913 3       6             3   1
9183 13.179.106 0 0 9898 1 978 Wine Glass 3                           1780–1825 1780 1825 194 H. 4 in. (10.2 cm) Gift of Frederick W. Hunter, 1913 3       6             3   1
9184 13.179.107 0 1 9899 1 978 Wine Glass 3                           1780–1825 1780 1825 194 H. 4 in. (10.2 cm) Gift of Frederick W. Hunter, 1913 3       6             3   1
Powered by Datasette · Query took 3.096ms · Data license: CC0 · Data source: metmuseum/openaccess