MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

21 rows where City = 5

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Culture, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, Classification, Artist Begin Date (date), Artist End Date (date)

Link 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 Repository
39 18.11.10 0 1 39 American Decorative Arts 1 Advertisement 10 Advertisement for Norwich Stone Ware Factory American 1                           1770–1800 1770 1800 Paper 10 11 x 9 in. (27.9 x 22.9 cm) Rogers Fund, 1918 Made in 1 Norwich 5     United States 3             Natural Substances 6   Metropolitan Museum of Art, New York, NY 1
533 15.79.10 0 1 594 American Decorative Arts 1 Bottle 48 Bottle American 1                           1800–1830 1800 1830 Earthenware 21 6 1/8 x 2 1/2 in. (15.6 x 6.4 cm) Gift of Charles M. Baldwin, 1915 Made in 1 Norwich 5     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
1089 69.207 0 1 1180 American Decorative Arts 1 Candle stand 167 Candlestand American 1                           1770–1800 1770 1800 Cherry 71 28 1/2 x 10 1/4 x 17 in. (72.4 x 26 x 43.2 cm) Gift of Elizabeth B. Carrick, 1969 Made in 1 Norwich 5     United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
1290 47.5.2 0 1 1390 American Decorative Arts 1 Candlestick 163 Candlestick American 1                           ca. 1835 1832 1835 Brass 12 H. 9 in. (22.9 cm) Rogers Fund, 1947 Made in 1 Norwich 5     United States 3             Metal 1   Metropolitan Museum of Art, New York, NY 1
1295 47.5.1 0 1 1395 American Decorative Arts 1 Candlestick 163 Candlestick American 1         Maker 1   Barlow     Barlow,  245     9999 ca. 1835 1832 1835 Brass 12 H. 9 in. (22.9 cm) Rogers Fund, 1947 Made in 1 Norwich 5     United States 3             Metal 1   Metropolitan Museum of Art, New York, NY 1
3070 46.151 0 1 3288 American Decorative Arts 1 Dish 110 Dish American 1         Maker|Maker 6   John Danforth|Thomas Danforth, I 1741–1799|1703–1786   Danforth, John|Danforth, I Thomas 480   1741 |1703 1799 |1786 ca. 1762–73 1759 1773 Pewter 104 H. 3/4 in. (1.9 cm); Diam. 12 in. (30.5 cm) Gift of Mrs. J. Insley Blair, in memory of her husband, 1941 Made in 1 Norwich 5     United States 3             Metal 1   Metropolitan Museum of Art, New York, NY 1
4161 20.109.17 0 1 4490 American Decorative Arts 1 Toy 536 Toy American 1                           1800–1830 1800 1830 Stoneware 209 H. 3 1/8 in. (7.9 cm) Gift of Robert Macauley Jackson, 1920 Made in 1 Norwich 5     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4240 18.95.14 0 1 4575 American Decorative Arts 1 Pitcher 296 Pitcher American 1         Maker 1   Peleg Armstrong and Erastus Wentworth active 1814–28   Armstrong and Wentworth  610   1814 1814 1814–28 1814 1828 Stoneware 209 H. 11 1/2 in. (29.2 cm) Rogers Fund, 1918 Made in 1 Norwich 5     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4320 38.127 0 1 4659 American Decorative Arts 1 Ladle 556 Ladle American 1         Maker|Maker 6   William Cleveland|Samuel Post 1770–1837   Cleveland, William|Post, Samuel 633   1770 1837 |9999 ca. 1815 1800 1820 Silver 2 L. 12 in. (30.5 cm) Rogers Fund, 1938 Made in 1 Norwich 5     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
5425 14.102.344 0 1 5801 American Decorative Arts 1 Pitcher 296 Pitcher American 1         Designer|Manufacturer 3 Possibly designed by|Possibly manufactured by Sidney Risley|Norwich Pottery ca. 1814–1875   Risley, Sidney|Norwich Pottery  804   1809 1819 |9999 ca. 1845–58 1842 1858 Mottled brown earthenware 118 H. 8 3/8 in. (21.3 cm) Bequest of Mary Mandeville Johnston, from the collection of Mr. and Mrs. Edward W. S. Johnston, 1914 Made in 1 Norwich 5     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5736 43.162.15 0 1 6124 American Decorative Arts 1 Plate 356 Plate American 1         Maker 1   John Danforth 1741–1799   Danforth, John 861   1741 1799 1773–93 1773 1793 Pewter 104 H. 3/4 in. (1.9 cm); Diam. 7 3/4 in. (19.7 cm) Gift of Joseph France, 1943 Made in 1 Norwich 5     United States 3             Metal 1   Metropolitan Museum of Art, New York, NY 1
6945 33.120.498b 0 1 7415 American Decorative Arts 1 Sheath 795 Sheath American 1         Maker 1   Hart and Wilcox active ca. 1805–7   Hart and Wilcox  970   1802 1807 1805–7 1805 1807 Silver, leather 1173 Dimensions unavailable Bequest of Alphonso T. Clearwater, 1933 Made in 1 Norwich 5     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
7307 65.187 0 0 7787 American Decorative Arts 1 Spoon 78 Spoon American 1         Maker 1 Marked by Harland     Harland 1002       1800–1900 1800 1900 Silver 2 L. 8 5/8 in. (21.9 cm) Gift of Lansdell K. Christie, 1965 Made in 1 Norwich 5     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
7312 33.120.429 0 1 7792 American Decorative Arts 1 Spoon 78 Spoon American 1         Maker 1 Probably Thomas Kinney 1786–1824   Kinney, Thomas 1005   1786 1824 ca. 1810 1807 1810 Silver 2 L. 9 3/8 in. (23.8 cm) Bequest of Alphonso T. Clearwater, 1933 Made in 1 Norwich 5     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
7548 33.120.498a 0 1 8037 American Decorative Arts 1 Sword 379 Sword American 1         Maker 1   Hart and Wilcox active ca. 1805–7   Hart and Wilcox  970   1802 1807 1805–7 1805 1807 Silver 2 L. 35 3/4 in. (90.8 cm) Bequest of Alphonso T. Clearwater, 1933 Made in 1 Norwich 5     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
7655 18.110.29 0 1 8155 American Decorative Arts 1 Tall clock 886 Tall Clock American 1         Maker 1   Thomas Harland 1735–1807   Harland, Thomas 1075   1735 1807 ca. 1775 1772 1775 Mahogany, white pine 179 93 3/4 x 21 1/8 x 10 1/2 in. (238.1 x 53.7 x 26.7 cm) John Stewart Kennedy Fund, 1918 Made in 1 Norwich 5     United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
12612 1971.62 0 1 13755 American Decorative Arts 1 Embroidered picture 1059 Hector Taking Leave of His Family American 1         Maker 1   Lucy C. Huntington 1794–1818   Huntington, Lucy C. 2014   1794 1818 1810 1810 1810 Silk embroidered with silk and metallic threads, sequins, watercolor 2198 31 1/8 x 28 3/4 in. (79.1 x 73 cm) Purchase, Mrs. Russell Sage Gift, 1971 Made in 1 Norwich 5     United States 3             Textiles 16   Metropolitan Museum of Art, New York, NY 1
16901 2016.797.4 0 1 20598 American Decorative Arts 1 Chest of drawers 216 Chest of drawers American 1                           1770–1800 1770 1800 Cherry 71 32 1/2 × 41 × 21 7/8 in. (82.6 × 104.1 × 55.6 cm) Bequest of Mrs. Screven Lorillard (Alice Whitney), from the collection of Mrs. J. Insley Blair, 2016 Made in 1 Norwich 5     United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
16937 2011.321.26 0 1 20741 American Decorative Arts 1 Pitcher 296 Pitcher American 1         Maker|Designer 7   Norwich Pottery|Sidney Risley ca. 1814–1875   Norwich Pottery |Risley, Sidney 2625   1809 9999 |1819 1845–75 1845 1875 Stoneware 209 10 1/2 in. (26.7 cm) Gift of Emma and Jay Lewis, 2011 Made in 1 Norwich 5     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
20408 1990.137a–j 0 1 24941 Arms and Armor 5 Percussion revolver with case 2300 Cased Six-Barreled Revolving Percussion Pistol ("Pepperbox") American, Norwich, Connecticut 381         Manufacturer|Manufacturer 19   Ethan Allen|Charles T. Thurber American, 1808–1871|American, active 1837–55   Allen|Thurber, Charles T. 2921 American|American 5 1808 |1837 1871 |1855 1842–47 1842 1847 Steel, gold, silver, ivory, wood (rosewood), velvet 4388 L. of pistol 7 in. (17.78 cm); case 12 15/16 x 8 3/16 x 2 5/8 in. (32.84 x 20.78 x 6.65 cm) Gift of Eric Vaule, 1990   Norwich 5   Connecticut 118               Firearms-Pistols-Percussion 96   Metropolitan Museum of Art, New York, NY 1
349476 89.4.2523 0 1 504262 Musical Instruments 18 Bass Drum 16964 Bass Drum American 1         Maker 1   John G. Pike American, Plymouth, New York 1815–1884 Norwich, New York   Pike, John G. 48254 American 1 1815-12-23 1884-07-01 1860–80 1860 1880 Wood, parchment, leather, metal 55176 Diameter ±68.7cm (±27 1/16 in.); Depth 44.3 cm (17 7/16 in.) The Crosby Brown Collection of Musical Instruments, 1889   Norwich 5   New York 126 United States 3             Membranophone 972   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 225.611ms · Data license: CC0 · Data source: metmuseum/openaccess