MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

39 rows where State = 24

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Object Date, Object Begin Date, Object End Date, Dimensions, Credit Line

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
2109 36.22.15 0 0 2287 American Decorative Arts 1 Dish cover 277 Dish Cover British 6                           1750–75 1750 1775 Earthenware 21 3 1/8 x 9 7/8 x 6 7/8 in. (7.9 x 25.1 x 17.5 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2110 36.22.16 0 0 2288 American Decorative Arts 1 Dish cover 277 Dish Cover British 6                           1750–75 1750 1775 Earthenware 21 3 1/4 x 9 15/16 x 6 7/8 in. (8.3 x 25.2 x 17.5 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2202 36.22.8 0 1 2385 American Decorative Arts 1 Dish 110 Covered Dish British 6                           1750–75 1750 1775 Earthenware 21 5 x 11 1/2 x 8 1/2 in. (12.7 x 29.2 x 21.6 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2328 36.22.13a, b 0 0 2513 American Decorative Arts 1 Sugar bowl 307 Covered Sugar Bowl British 6                           1750–75 1750 1775 Earthenware 21 4 7/8 x 6 5/8 x 4 in. (12.4 x 16.8 x 10.2 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2360 36.22.7a, b 0 1 2547 American Decorative Arts 1 Tureen 315 Covered Tureen British 6                           1750–75 1750 1775 Earthenware 21 8 x 12 3/4 x 7 5/8 in. (20.3 x 32.4 x 19.4 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3102 36.22.9 0 1 3320 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 2 3/4 x 12 1/2 x 7 1/2 in. (7 x 31.8 x 19.1 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3103 36.22.10 0 1 3321 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 3 3/8 x 1 3/8 x 8 1/8 in. (8.6 x 3.5 x 20.6 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3104 36.22.11 0 1 3322 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 1 7/8 x 10 3/8 x 7 7/8 in. (4.8 x 26.4 x 20 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3113 36.22.37 0 1 3331 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 H. 7 1/4 in. (18.4 cm); Diam. 6 in. (15.2 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3114 36.22.38 0 1 3332 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 H. 7 1/4 in. (18.4 cm); Diam. 6 in. (15.2 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5636 38.165.34 0 0 6018 American Decorative Arts 1 Plate 356 Plate British 6                           1780–90 1780 1790 Earthenware 21 1 1/4 x 11 x 9 1/2 in. (3.2 x 27.9 x 24.1 cm) Harris Brisbane Dick Fund, 1938 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5981 36.22.29 0 1 6377 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 6 3/4 in. (17.1 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5982 36.22.30 0 1 6378 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 6 3/4 in. (17.1 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5983 36.22.31 0 1 6379 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 6 3/4 in. (17.1 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5984 36.22.32 0 1 6380 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 6 3/4 in. (17.1 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5985 36.22.33 0 1 6381 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 6 3/4 in. (17.1 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5986 36.22.34 0 1 6382 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 6 3/4 in. (17.1 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5987 36.22.35 0 1 6383 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 6 3/4 in. (17.1 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5988 36.22.36 0 1 6384 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 6 3/4 in. (17.1 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5994 36.22.17 0 1 6390 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 Diam. 9 3/4 in. (24.8 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5995 36.22.18 0 1 6391 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 Diam. 9 3/4 in. (24.8 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5996 36.22.19 0 1 6392 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 Diam. 9 3/4 in. (24.8 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5997 36.22.20 0 1 6393 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 Diam. 9 3/4 in. (24.8 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5998 36.22.21 0 1 6394 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 Diam. 9 3/4 in. (24.8 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5999 36.22.22 0 1 6395 American Decorative Arts 1 Dish 110 Dish British 6                           1750–75 1750 1775 Earthenware 21 Diam. 9 3/4 in. (24.8 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6000 36.22.23 0 1 6396 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 8 1/4 in. (21 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6001 36.22.24 0 1 6397 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 8 1/4 in. (21 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6002 36.22.25 0 1 6398 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 8 1/4 in. (21 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6003 36.22.26 0 1 6399 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 8 1/4 in. (21 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6004 36.22.27 0 1 6400 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 8 1/4 in. (21 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6005 36.22.28 0 1 6401 American Decorative Arts 1 Plate 356 Plate British 6                           1750–75 1750 1775 Earthenware 21 Diam. 8 1/4 in. (21 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6192 36.22.1 0 0 6588 American Decorative Arts 1 Platter 289 Platter British 6                           1750–75 1750 1775 Earthenware 21 20 1/2 x 15 3/4 in. (52.1 x 40 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6193 36.22.2 0 0 6589 American Decorative Arts 1 Platter 289 Platter British 6                           1750–75 1750 1775 Earthenware 21 16 1/2 x 13 in. (41.9 x 33 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6194 36.22.3 0 0 6590 American Decorative Arts 1 Platter 289 Platter British 6                           1750–75 1750 1775 Earthenware 21 14 1/4 x 11 1/8 in. (36.2 x 28.3 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6195 36.22.4 0 0 6591 American Decorative Arts 1 Platter 289 Platter British 6                           1750–75 1750 1775 Earthenware 21 14 1/4 x 11 1/8 in. (36.2 x 28.3 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6196 36.22.5 0 0 6592 American Decorative Arts 1 Platter 289 Platter British 6                           1750–75 1750 1775 Earthenware 21 14 1/4 x 11 1/8 in. (36.2 x 28.3 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6197 36.22.6 0 0 6593 American Decorative Arts 1 Platter 289 Platter British 6                           1750–75 1750 1775 Earthenware 21 10 1/2 x 8 1/8 in. (26.7 x 20.6 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6749 36.22.12 0 1 7207 American Decorative Arts 1 Sauceboat 302 Sauceboat British 6                           1750–75 1750 1775 Earthenware 21 3 3/4 x 7 1/4 x 2 7/8 in. (9.5 x 18.4 x 7.3 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
7493 36.22.14 0 1 7981 American Decorative Arts 1 Sugar bowl 307 Sugar Bowl British 6                           1750–75 1750 1775 Earthenware 21 2 7/8 x 6 5/8 x 3 7/8 in. (7.3 x 16.8 x 9.8 cm) Gift of Col. G. Creighton Webb, 1936 Made in 1 Leeds 125 West Yorkshire 24 West Yorkshire 24 England 4             Ceramics 5   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 241.46ms · Data license: CC0 · Data source: metmuseum/openaccess