MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

17 rows where State = 25

View and edit SQL

Suggested facets: Object Name, Title, Artist Role, Artist Prefix, 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

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
2133 34.100.149a, b 0 1 2312 American Decorative Arts 1 Bowl 106 Covered bowl American 1         Maker 1 Probably David Haring 1801–1871   Haring, David 367   1801 1871 ca. 1830–40 1830 1840 Earthenware; Redware 548 H. 7 in. (17.8 cm); Diam. 10 1/2 in. (26.7 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2134 34.100.150a, b 0 1 2313 American Decorative Arts 1 Bowl 106 Covered Bowl American 1         Maker 1 Probably David Haring 1801–1871   Haring, David 367   1801 1871 ca. 1835 1832 1835 Earthenware 21 H. 4 1/2 in. (11.4 cm); Diam. 6 1/2 in. (16.5 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2135 34.100.151a, b 0 1 2314 American Decorative Arts 1 Bowl 106 Covered Bowl American 1         Maker 1 Probably David Haring 1801–1871   Haring, David 367   1801 1871 1830–70 1830 1870 Earthenware 21 H. 4 in. (10.2 cm); Diam. 6 3/4 in. (17.1 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4174 1986.451 0 1 4505 American Decorative Arts 1 Jar 116 Jar American 1         Maker 1 Attributed to Philip Kline active ca. 1806–34   Kline, Philip 599   1806 1834 1809 1809 1809 Earthenware; Redware with sgraffito decoration 585 9 1/8 x 4 1/2 in. (23.2 x 11.4 cm) Anonymous Gift, 1986 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4175 13.145.2 0 1 4506 American Decorative Arts 1 Jar 116 Jar American 1         Artist 2 Attributed to Christian Klinker active 1773–98   Klinker, Christian 600   1773 1798 ca. 1773 1773 1773 Earthenware; Redware with slip decoration 206 H. 10 in. (25.4 cm) Rogers Fund, 1913 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5580 13.145.1 0 1 5960 American Decorative Arts 1 Plate 356 Plate American 1         Maker 1 Possibly David Spinner 1758–1811   Spinner, David 837   1758 1758 ca. 1810 1800 1810 Earthenware; Redware with slip decoration  132 Diam. 12 in. (30.5 cm) Rogers Fund, 1913 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5616 34.100.120 0 1 5997 American Decorative Arts 1 Plate 356 Plate American 1         Maker 1   John Leidy I 1764–1846   Leidy, John I 841   1764 1846 ca. 1775–1800 1775 1800 Earthenware; Redware  1093 Diam. 12 in. (30.5 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5618 34.100.128 0 1 5999 American Decorative Arts 1 Plate 356 Plate American 1         Artist 2 Possibly Conrad Mumbouer 1761–1845   Mumbouer, Conrad 842   1761 1845 ca. 1794–1844 1794 1844 Earthenware; Redware with sgraffito decoration  1094 Diam. 11 3/4 in. (29.8 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5619 34.100.132 0 1 6000 American Decorative Arts 1 Plate 356 Plate American 1         Artist 2   John Monday 1809–1862   Monday, John 843   1809 1862 1830 1830 1830 Earthenware; Redware with sgraffito decoration 585 Diam. 11 in. (27.9 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5748 34.100.119 0 1 6136 American Decorative Arts 1 Plate 356 Plate American 1         Maker 1 Attributed to John Leidy I 1764–1846   Leidy, John I 841   1764 1846 ca. 1790–1800 1790 1800 Earthenware; Redware with sgraffito decoration 585 Diam. 12 in. (30.5 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5800 34.100.117 0 1 6188 American Decorative Arts 1 Plate 356 Plate American 1         Maker 1 Possibly Conrad Mumbouer 1761–1845   Mumbouer, Conrad 842   1761 1845 ca. 1794–1844 1794 1844 Earthenware; Redware with sgraffito decoration 585 Diam. 13 3/8 in. (34 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5801 12.177.3 0 1 6189 American Decorative Arts 1 Plate 356 Plate American 1         Maker 1 Attributed to David Spinner 1758–1811   Spinner, David 837   1758 1758 ca. 1800 1800 1800 Earthenware; Redware 548 Diam. 11 5/8 in. (29.5 cm) Rogers Fund, 1912 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5803 34.100.121 0 1 6191 American Decorative Arts 1 Plate 356 Plate American 1         Maker 1 Attributed to David Spinner 1758–1811   Spinner, David 837   1758 1758 ca. 1800 1797 1800 Earthenware; Redware with sgraffito decoration 585 Diam. 11 3/4 in. (29.8 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6111 34.100.146 0 1 6507 American Decorative Arts 1 Dish 110 Dish American 1         Artist 2 Possibly by Simon Singer born 1822   Singer, Simon 893   1822 1822 1889 1889 1889 Earthenware; Redware 548 10 3/8 x 8 1/8 in. (26.4 x 20.6 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
7075 17.203.19 0 1 7548 American Decorative Arts 1 Slip cup 814 Slip cup American 1         Maker 1   Judah R. Teaney born 1814   Teaney, Judah R. 980   1814 1914 1827 1824 1827 Earthenware; Redware with incised decoration 1190 2 3/8 x 4 1/4 x 3 1/4 in. (6 x 10.8 x 8.3 cm) Rogers Fund, 1917 Made in 1   Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
7758 1981.46 0 1 8267 American Decorative Arts 1 Tea canister 893 Tea Canister American 1         Maker 1   Joseph Smith   , active 1760s Smith, Joseph 1103       1769 1769 1769 Earthenware; Redware 548 H. 7 1/2 in. (19.1 cm) Purchase, Peter H. B. Frelinghuysen and Anonymous Gifts, and Friends of the American Wing Fund, 1981 Made in 1 Wrightstown 268 Bucks County 25 Bucks County 25 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
12951 1984.331.18 0 1 14096 American Decorative Arts 1 Sampler 1007 Embroidered Sampler American 1         Maker|Maker 6   Lydia Headly|Rachel Headly born 1793|born 1795   Headly, Lydia|Headly, Rachel 2123   1793 |1795 1893 |1895 ca. 1805 1802 1805 Embroidered silk on linen 2199 20 x 18 3/4 in. (50.8 x 47.6 cm) Gift of Barbara Schiff Sinauer, 1984 Made in 1   Bucks County 25 Bucks County 25 United States 3             Textiles 16   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 136.505ms · Data license: CC0 · Data source: metmuseum/openaccess