MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where State = 5

View and edit SQL

Suggested facets: Object Name, Title, Artist End Date, Object End Date, Medium, Credit Line, Geography Type, 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
465 34.100.61 0 1 523 American Decorative Arts 1 Birth and baptismal certificate, Fraktur 84 Birth and Baptismal Certificate American 1                           1780 1780 1780 Ink and watercolor on paper 174 13 7/8 x 16 7/8 in. (35.2 x 42.9 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Chester County 5 Chester County 5 United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
468 34.100.67 0 1 526 American Decorative Arts 1 Birth and baptismal certificate, Fraktur 84 Birth and Baptismal Certificate American 1                           1787 1787 1787 Ink and watercolor on paper 174 12 1/4 x 16 1/2 in. (31.1 x 41.9 cm) Gift of Mrs. Robert W. de Forest, 1933 Made in 1   Chester County 5 Chester County 5 United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
3451 15.104.1a–e 0 1 3689 American Decorative Arts 1 Jamb stove 443 Jamb stove American 1         Maker 1   Samuel Flower     Flower, Samuel 521     9999 1756 1756 1756 Iron 13 Various dimensions Rogers Fund, 1915 Made in 1   Chester County 5 Chester County 5 United States 3             Metal 1   Metropolitan Museum of Art, New York, NY 1
3526 1974.7a, b 0 1 3764 American Decorative Arts 1 Flowerpot and stand 454 Flowerpot and stand American 1         Maker 1   James Pottery 1796–1863   James Pottery  546   1796 1863 1824 1824 1824 Earthenware; Redware with sgraffito decoration 585 H. 9 7/8 in. (25.1 cm) Purchase, Virginia H. Groomes Gift, in memory of her mother, Mary W. Groomes, 1974 Made in 1   Chester County 5 Chester County 5 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
8930 48.38 0 1 9601 American Decorative Arts 1 Wainscot armchair 932 Wainscot Armchair American 1                           1740–80 1740 1780 Walnut 50 49 1/2 x 22 3/4 in. (125.7 x 57.8 cm) Anonymous Gift, 1948 Made in 1   Chester County 5 Chester County 5 United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
8931 48.61 0 1 9602 American Decorative Arts 1 Joined armchair 933 Joined armchair American 1                           1690–1720 1690 1720 Black walnut 78 45 1/2 x 22 x 23 1/4 in. (115.6 x 55.9 x 59.1 cm) Rogers Fund, 1948 Made in 1   Chester County 5 Chester County 5 United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
12902 13.69.10 0 1 14047 American Decorative Arts 1 Sampler 1007 Embroidered Sampler American 1         Maker 1   A. H.     A. H. 1131     9999 1810 1810 1810 Linen on linen, embroidered 2270 11 3/4 x 11 3/4 in. (29.9 x 29.9 cm) Rogers Fund, 1913 Probably made in 2   Chester County 5 Chester County 5 United States 3             Textiles 16   Metropolitan Museum of Art, New York, NY 1
16290 2005.19 0 1 18824 American Decorative Arts 1 Sampler 1007 Sampler made at the Westtown Quaker School American 1         Maker 1   Sarah Thomas 1786–1826   Thomas, Sarah 2500   1786 1826 1801 1801 1801 Silk on linen 2281 14 3/4 x 12 1/2 in. (37.5 x 31.8 cm) Purchase, Mr. and Mrs. Frank Martucci and Mr. and Mrs. Robert T. Schaffner Gifts, and Gift of George Coe Graves, by exchange, 2005 Made in 1 Westtown 236 Chester County 5 Chester County 5               Textiles 16   Metropolitan Museum of Art, New York, NY 1
16339 2005.463.2 0 1 19018 American Decorative Arts 1 Sampler 1007 Sampler made at the Westtown Quaker School American 1         Maker 1   Rebecca Marsh American, born 1791   Marsh, Rebecca 2510   1791   1802 1802 1802 Silk embroidery on linen 2085 12 3/4 x 16 3/4 in. (32.4 x 42.5 cm) Gift of Virginia F. Thors, 2005 Made in 1 Westtown 236 Chester County 5 Chester County 5 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 133.7ms · Data license: CC0 · Data source: metmuseum/openaccess