MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

49 rows where State = 2

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Artist Display Name, Artist Alpha Sort, Object Date, Object Begin 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
327 52.77.21 0 1 373 American Decorative Arts 1 Beaker 58 Beaker British 6                           ca. 1765 1762 1765 Opaque glass with enamel decoration 131 H. 8 in. (20.3 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
328 52.77.22 0 1 374 American Decorative Arts 1 Beaker 58 Beaker British 6                           1760–65 1760 1765 Opaque glass with enamel decoration 131 H. 7 1/4 in. (18.4 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
363 52.77.3 0 1 417 American Decorative Arts 1 Beaker 58 Beaker British 6                           1760–65 1760 1765 Opaque glass with enamel decoration 131 H. 7 1/8 in. (18.1 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
364 52.77.4 0 1 418 American Decorative Arts 1 Beaker 58 Beaker British 6                           1760–65 1760 1765 Opaque glass with enamel decoration 131 6 3/4 × 4 × 4 in. (17.1 × 10.2 × 10.2 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
556 52.77.9 0 1 617 American Decorative Arts 1 Bottle 48 Bottle British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 H. 3 1/2 in. (8.9 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
557 52.77.10 0 1 618 American Decorative Arts 1 Bottle 48 Bottle British 6                           18th century 1700 1800 Painted glass 199 H. 5 in. (12.7 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
559 52.77.35 0 1 620 American Decorative Arts 1 Bottle 48 Bottle British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 H. 4 in. (10.2 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
560 52.77.36 0 1 621 American Decorative Arts 1 Bottle 48 Bottle British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 H. 4 5/16 in. (11 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
561 52.77.41 0 1 622 American Decorative Arts 1 Bottle 48 Bottle British 6                           1760–70 1760 1770 Opaque glass 200 H. 5 1/8 in. (13 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
562 52.77.42 0 1 623 American Decorative Arts 1 Bottle 48 Bottle British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 H. 3 3/8 in. (8.6 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
563 52.77.43 0 1 624 American Decorative Arts 1 Bottle 48 Bottle British 6                           1760–70 1760 1770 Opaque glass with enamel decoration 131 H. 4 1/8 in. (10.5 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
574 52.77.30 0 1 636 American Decorative Arts 1 Bottle 48 Bottle British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 H. 4 5/8 in. (11.7 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
575 52.77.31 0 1 637 American Decorative Arts 1 Bottle 48 Bottle British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 H. 4 5/8 in. (11.7 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
576 18.110.48b 0 0 638 American Decorative Arts 1 Bottle 48 Bottle British, probably 15                           1700–1800 1700 1800 Free-blown glass 186 Dimensions unavailable John Stewart Kennedy Fund, 1918 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
577 18.110.48c 0 0 639 American Decorative Arts 1 Bottle 48 Bottle British, probably 15                           1700–1800 1700 1800 Free-blown glass 186 Dimensions unavailable John Stewart Kennedy Fund, 1918 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
578 18.110.48d 0 0 640 American Decorative Arts 1 Bottle 48 Bottle British, probably 15                           1700–1800 1700 1800 Free-blown glass 186 Dimensions unavailable John Stewart Kennedy Fund, 1918 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
579 18.110.48e 0 0 641 American Decorative Arts 1 Bottle 48 Bottle British, probably 15                           1700–1800 1700 1800 Free-blown glass 186 Dimensions unavailable John Stewart Kennedy Fund, 1918 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
580 18.110.48f 0 0 642 American Decorative Arts 1 Bottle 48 Bottle British, probably 15                           1700–1800 1700 1800 Free-blown glass 186 Dimensions unavailable John Stewart Kennedy Fund, 1918 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
581 18.110.48g 0 0 643 American Decorative Arts 1 Bottle 48 Bottle British, probably 15                           1700–1800 1700 1800 Free-blown glass 186 Dimensions unavailable John Stewart Kennedy Fund, 1918 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
629 37.169 0 1 691 American Decorative Arts 1 Bowl 106 Bowl British 6                           1750–60 1750 1760 Tin-enameled earthenware 193 H. 5 5/8 in. (14.3 cm); Diam. 13 13/16 in. (35.1 cm) Purchase, Anita M. Linzee Bequest, 1937 Made in 1 Bristol 2 Bristol 2 Bristol 2 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
643 44.110.16 0 1 708 American Decorative Arts 1 Bowl 106 Bowl British (American market) 2                           ca. 1760 1757 1760 Tin-enameled earthenware 193 H. 5 1/8 in. (13 cm); Diam. 12 in. (30.5 cm) Gift of Mrs. Russell S. Carter, 1944 Made in 1 Bristol 2 Bristol 2 Bristol 2 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
1216 52.77.38 0 1 1313 American Decorative Arts 1 Candlestick 163 Candlestick British 6         Maker 1 Possibly Michael Edkins     Edkins, Michael 234       1760–70 1760 1770 Opaque glass with enamel decoration 131 H. 8 15/16 in. (22.7 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
1217 52.77.39a, b 0 1 1314 American Decorative Arts 1 Candlestick 163 Candlestick British 6         Maker 1 Possibly Michael Edkins     Edkins, Michael 234       1760–70 1760 1770 Opaque glass with enamel decoration 131 9 5/16 × 4 11/16 × 4 11/16 in. (23.7 × 11.9 × 11.9 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
1957 27.17.15a, b 0 0 2127 American Decorative Arts 1 Coffeepot 251 Coffeepot British 6                           ca. 1770–81 1767 1767 Porcelain (hard-paste), transfer-printed 543 H. 7 3/4 in. (19.7 cm) Rogers Fund, 1927 Made in 1 Bristol 2 Bristol 2 Bristol 2 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
2164 52.77.26a, b 0 1 2346 American Decorative Arts 1 Tea caddy 282 Tea Caddy British 6         Maker 1 Possibly Michael Edkins     Edkins, Michael 234       1760–70 1760 1770 Opaque glass with enamel decoration 131 H. 5 5/16 in. (13.5 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
2165 52.77.27a, b 0 1 2347 American Decorative Arts 1 Tea caddy 282 Tea Caddy British 6         Maker 1 Possibly Michael Edkins     Edkins, Michael 234       1760–70 1760 1770 Opaque glass with enamel decoration 131 H. 5 1/4 in. (13.3 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
2375 52.77.20a, b 0 1 2562 American Decorative Arts 1 Vase 7 Covered Vase British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 9 1/2 × 4 5/16 × 4 5/16 in. (24.1 × 11 × 11 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
2551 52.77.19a–k 0 1 2746 American Decorative Arts 1 Cruet 323 Cruet British 6                           ca. 1765 1762 1765 Opaque glass with enamel decoration 131 H. 7 7/8 in. (20 cm); Diam. 7 1/8 in. (18.1 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
3276 52.77.32 0 1 3509 American Decorative Arts 1 Egg cup 371 Egg Cup British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 H. 2 5/8 in. (6.7 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
3277 52.77.33 0 1 3510 American Decorative Arts 1 Egg cup 371 Egg Cup British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 H. 2 5/8 in. (6.7 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
3371 52.77.13 0 1 3606 American Decorative Arts 1 Finger bowl 418 Finger Bowl British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 H. 2 in. (5.1 cm); Diam. 3 3/8 in. (8.6 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
4771 07.280.13 0 1 5128 American Decorative Arts 1 Medal 148 George Washington Commemorative Medal           Maker 1 Possibly Joseph S. and Alfred Wyon active 18th–19th century   Wyon, Joseph S. and Alfred 708   1700 1900 1800–1907 1800 1907 Bronze 23 Diam. 1 1/4 in. (3.2 cm) Gift of Mr. and Mrs. Frederick S. Wait, 1907 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Metal 1   Metropolitan Museum of Art, New York, NY 1
6352 35.14 0 1 6793 American Decorative Arts 1 Punch bowl 298 Punch Bowl British 6                           1730–50 1730 1750 Tin-enameled earthenware 193 H. 6 1/2 in. (16.5 cm); Diam. 12 in. (30.5 cm) Rogers Fund, 1935 Made in 1 Bristol 2 Bristol 2 Bristol 2 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
6779 52.77.40 0 1 7238 American Decorative Arts 1 Saucer 326 Saucer British 6                           1760–70 1760 1770 Opaque glass with enamel decoration 131 Diam. 6 in. (15.2 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
6865 52.77.44 0 1 7331 American Decorative Arts 1 Scent bottle 775 Scent Bottle British 6                           1779 1779 1779 Opaque glass with enamel decoration 131 H. 2 3/4 in. (7 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
7744 52.77.37a, b 0 1 8251 American Decorative Arts 1 Taperstick 890 Taperstick British 6         Maker 1 Possibly Michael Edkins     Edkins, Michael 234       1760–70 1760 1770 Opaque glass with enamel decoration 131 H. 6 1/8 in. (15.6 cm); Diam. 3 3/8 in. (8.6 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
8523 52.77.45a–e 0 1 9164 American Decorative Arts 1 Bottle 48 Bottle British 6                           ca. 1775 1772 1775 Opaque glass with enamel decoration, gold, metal 1306 H. 2 in. (5.1 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
8644 52.77.1 0 1 9291 American Decorative Arts 1 Vase 7 Vase British 6                           1760–65 1760 1765 Opaque glass with enamel decoration 131 H. 6 1/4 in. (15.9 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
8645 52.77.2 0 1 9292 American Decorative Arts 1 Vase 7 Vase British 6                           1760–65 1760 1765 Opaque glass with enamel decoration 131 H. 6 3/8 in. (16.2 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
8646 52.77.5 0 1 9293 American Decorative Arts 1 Vase 7 Vase British 6                           1760–65 1760 1765 Opaque glass with enamel decoration 131 H. 9 3/8 in. (23.8 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
8647 52.77.6 0 1 9294 American Decorative Arts 1 Vase 7 Vase British 6                           1760–65 1760 1765 Opaque glass with enamel decoration 131 H. 7 3/4 in. (19.7 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
8648 52.77.7 0 1 9295 American Decorative Arts 1 Vase 7 Vase British 6                           1760–65 1760 1765 Opaque glass with enamel decoration 131 H. 7 1/16 in. (17.9 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
8649 52.77.8 0 1 9296 American Decorative Arts 1 Vase 7 Vase British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 6 3/16 × 3 5/8 × 3 5/8 in. (15.7 × 9.2 × 9.2 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
8650 52.77.11 0 1 9297 American Decorative Arts 1 Vase 7 Vase British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 H. 5 1/2 in. (14 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
8653 52.77.23 0 1 9300 American Decorative Arts 1 Vase 7 Vase British 6                           1755–65 1755 1765 Opaque glass with enamel decoration 131 H. 5 in. (12.7 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
8654 52.77.24 0 0 9301 American Decorative Arts 1 Vase 7 Vase British 6                           1755–65 1755 1765 Opaque glass with enamel decoration 131 H. 5 1/8 in. (13 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
8655 52.77.25 0 1 9302 American Decorative Arts 1 Vase 7 Vase British 6                           1755–65 1755 1765 Opaque glass with enamel decoration 131 6 7/8 × 4 1/16 × 4 1/16 in. (17.5 × 10.3 × 10.3 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
8657 52.77.29a, b 0 1 9304 American Decorative Arts 1 Vase 7 Vase British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 H. 7 1/2 in. (19.1 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   Metropolitan Museum of Art, New York, NY 1
8658 52.77.34 0 1 9305 American Decorative Arts 1 Vase 7 Vase British 6                           ca. 1760 1757 1760 Opaque glass with enamel decoration 131 H. 4 in. (10.2 cm) Bequest of Mrs. J. Insley Blair, 1951 Probably made in 2 Bristol 2 Bristol 2 Bristol 2 England 4             Glass 3   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 185.13ms · Data license: CC0 · Data source: metmuseum/openaccess