MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

48 rows where Country = 1 and Medium = 5548

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Culture, Period, Object Date, Object Begin Date, Object End Date, Credit Line, City, County, Region, Classification

Country

  • Mexico · 48
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
346638 89.4.656 0 1 501272 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11                           19th century 1801 1900 Clay 5548 L. 47 mm.; W. 41 mm.; D. 20 mm.; Wt. 18 g. The Crosby Brown Collection of Musical Instruments, 1889   Oaxaca? 2153     Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
346639 89.4.657 0 1 501273 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11 Probably late postclassic (Pre-Columbian)                         ca. 1200–1521 1200 1521 Clay 5548 2 5/16 × 1 5/16 × 1 1/4 in., 0.776oz. (5.8 × 3.3 × 3.2 cm, 22g) The Crosby Brown Collection of Musical Instruments, 1889   Tlatelolco?, Mexico City 2154     Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
346640 89.4.658 0 1 501274 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11                           19th century 1801 1900 Clay 5548 L. 83 mm.; W. 30 mm.; D. 81 mm.; Wt. 67 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
347193 89.4.1284 0 0 501850 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11                           19th century 1800 1899 Clay 5548 H. 46 mm, W. 29 mm, D. 53 mm, Wt. 20 g The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Idiophone-Shaken-rattle 908   Metropolitan Museum of Art, New York, NY 1
347350 89.4.1447 0 0 502013 Musical Instruments 18 Pottery Whistle and Rattle 15646 Pottery Whistle and Rattle Mexican 11                           19th century 1801 1900 Clay 5548 H. 36 mm.; Diam. 36 mm.; Wt. 25 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone and Idiophone-flue blown / vessel rattle 966   Metropolitan Museum of Art, New York, NY 1
347705 89.4.3467 0 1 502378 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11 Classic Period (Pre-Columbian)                         ca. 300–900 300 900 Clay 5548 H:65mm; W: 33mm; D: 49mm; Wt: 33g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1 Oaxaca valley 595           Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
347706 89.4.3469 0 1 502379 Musical Instruments 18 Pottery Flute 15836 Pottery Flute Aztec 4364 Late Post Classic period (Pre-Columbian)                         ca. 1300–1500 1300 1500 Clay 5548 L. 202 mm.; W. 26 mm.; D. 25 mm.; Wt 68 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Blow Hole-vessel flute 918   Metropolitan Museum of Art, New York, NY 1
347708 89.4.3471 0 1 502381 Musical Instruments 18 Pottery Flute 15836 Pottery Flute Mexican 11 Pre-Columbian                         ca. 1200–1521 1200 1521 Clay 5548 L. 105 mm.; W. 23 mm.; D. 28 mm.; Wt. 30 g. The Crosby Brown Collection of Musical Instruments, 1889   Coatepec 2222   Veracruz 365 Mexico 1             Aerophone-Whistle Flute-recorder 965   Metropolitan Museum of Art, New York, NY 1
347710 89.4.3473 0 1 502383 Musical Instruments 18 Pottery Flute 15836 Pottery Flute Mexican 11 Pre-Columbian                         ca. 300–900 300 900 Clay 5548 L. 50 mm.; W. 31 mm.; D. 40 mm.; Wt. 21 g. The Crosby Brown Collection of Musical Instruments, 1889   San Diego 2224     Mexico 1             Aerophone-Whistle Flute-recorder 965   Metropolitan Museum of Art, New York, NY 1
347711 89.4.3474 0 1 502384 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11                           1880 1880 1880 Clay 5548 H: 52mm; W: 31mm; D: 30mm; Wt: 18 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
347712 89.4.3475 0 0 502385 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11                           19th century 1800 1900 Clay 5548 W. 51 mm.; L. 98. mm.; D. 50 mm.; Wt. 71 gr. The Crosby Brown Collection of Musical Instruments, 1889   Huexotla District, Texcoco 2225     Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
347840 07.94 0 1 502524 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican (Veracruz) 6461 Pre-Columbian                         300–1200 300 1200 Clay 5548 Overall: H. 7.4 x W. 5.5 x D. 7.6cm, 80 g. (2 15/16 x 2 3/16 x 3in., 0.2lb.) The Crosby Brown Collection of Musical Instruments, 1889       Veracruz 365 Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
347842 89.4.1947 0 0 502526 Musical Instruments 18 Silbato 16352 Silbato Mexican 11                           19th century 1801 1900 Clay 5548 L. 100 mm.; W. 57 mm.; D. 72 mm.; Wt. 108 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
347843 89.4.1948 0 0 502527 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Guadalajara 6462                           19th century 1801 1900 Clay 5548 L. 77 mm.; W. 47 mm.; D. 51 mm.; Wt. 74 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
347844 89.4.1949 0 1 502528 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11 Pre-Columbian                         300–600 300 600 Clay 5548 L. 100 mm.; W. 36 mm.; D. 42 mm. Wt. 44 g. The Crosby Brown Collection of Musical Instruments, 1889       Central Plateau 927 Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
347845 89.4.1950 0 1 502529 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11                           mid 3rd–9th century? 200 899 Clay 5548 L. 164 mm.; W. 99 mm.; D. 63 mm.; Wt. 207 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
347943 89.4.2061 0 1 502628 Musical Instruments 18 Pottery Flute 15836 Pottery Flute Probably Toltec 6478 Pre-Columbian                         ca. 900–1521 900 1521 Clay 5548 Height: 10 5/8 in. (27 cm) Diameter (Of bell): 2 5/8 in. (6.7 cm) Weight: 6.172 oz. (175 g) The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Blow Hole-vessel flute 918   Metropolitan Museum of Art, New York, NY 1
347944 89.4.2062 0 0 502629 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11                           late 19th century 1866 1900 Clay 5548 H. 64 mm, W. 72 mm, D. 69 mm, Wt. 91 g The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Idiophone-Shaken-rattle 908   Metropolitan Museum of Art, New York, NY 1
347946 89.4.2064 0 0 502631 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11                           19th century (?) 1801 1900 Clay 5548 L. 74 mm.; W. 64 mm.; D. 32 mm.; Wt. 66 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
347947 89.4.2065 0 1 502632 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11 Pre-Columbian                         1200–1521 1200 1521 Clay 5548 Weight 79 g, Diamter 54 mm. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1 Central Plateau Region 604           Idiophone-Shaken-rattle 908   Metropolitan Museum of Art, New York, NY 1
347948 89.4.2066 0 1 502633 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11 Pre-Columbian                         900–1521 (?) 900 1521 Clay 5548 L. 95 mm.; W. 56 mm.; D. 53 mm.; Wt. 79 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
348073 89.4.2656 0 0 502762 Musical Instruments 18 Pottery Flute 15836 Pottery Flute Oaxaca? 6490                           19th century 1800 1899 Clay 5548 L. 200 mm.; W. 93 mm.; D. 32 mm.; Wt. 98 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-recorder 965   Metropolitan Museum of Art, New York, NY 1
348105 89.4.2773 0 0 502794 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11                           late 19th century 1875 1900 Clay 5548 H. 136 mm.; W. 102 mm.; D. 131 mm.; Wt. 475 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
348106 89.4.2774 0 1 502795 Musical Instruments 18 Pottery Flute 15836 Pottery Flute Aztec? 6497 Pre-Columbian                         1400–1500? 1400 1500 Clay 5548 L. 168 mm.; W. 37 mm.; D. 36 mm.; Wt. 56 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-recorder 965   Metropolitan Museum of Art, New York, NY 1
348107 89.4.2775 0 1 502796 Musical Instruments 18 Pottery Flute 15836 Pottery Flute Aztec 4364                           ca. 1200–1521 1200 1521 Clay 5548 L. 163 mm.; Diam. of bell (greatest) 32 mm.; Wt. 40 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-recorder 965   Metropolitan Museum of Art, New York, NY 1
348194 89.4.3300 0 0 502884 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11                           19th century (?) 1801 1900 Clay 5548 L. 9 cm.; D. 5.4 cm.; W. 3.4 cm.; Wt. 50 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
348200 89.4.3308 0 1 502890 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11 Pre-Columbian                         ca. 900–1500 900 1500 Clay 5548   The Crosby Brown Collection of Musical Instruments, 1889   San Sebastian, Texcoco 2246     Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
348201 89.4.3309 0 1 502891 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11                           before 1599? 1300 1599 Clay 5548 L. 4.8 cm.; D. 3 cm.; W. 2.8 cm.; Wt. 14 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
348202 89.4.3312 0 0 502892 Musical Instruments 18 Pottery Flute 15836 Pottery Flute Mexican 11                             0 0 Clay 5548 L. 72 mm.; W. 22 mm.; D. 20 mm.; Wt. 16 g. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone-Whistle Flute-recorder 965   Metropolitan Museum of Art, New York, NY 1
348207 89.4.3332 0 0 502897 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11                           19th century 1801 1900 Clay 5548 L. 12.4 cm.; W: 5.4 cm.; H: 9.5 cm.; Wt.: 106 gr. The Crosby Brown Collection of Musical Instruments, 1889   Oaxaca 2247     Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
348208 89.4.3333 0 1 502898 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11                           before 1889 1300 1889 Clay 5548 L. 10.6 cm.; W.: 6.9 cm.; H.: 10.8 cm.; Wt.: 164 gr. The Crosby Brown Collection of Musical Instruments, 1889   Oaxaca? 2153     Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
348260 89.4.3461 0 0 502950 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11                           19th century 1800 1900 Clay 5548 H: 131mm; W: 71mm; D: 40mm; Wt:164g. The Crosby Brown Collection of Musical Instruments, 1889       Oaxaca Valley 964 Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
348261 89.4.3463 0 1 502951 Musical Instruments 18 Pottery Whistle 15645 Pottery Whistle Mexican 11                           date uncertain 1300 1599 Clay 5548 H: 65mm; W: 60mm; D:36mm; Wt: 48g. The Crosby Brown Collection of Musical Instruments, 1889   Oaxaca 2247     Mexico 1             Aerophone-Whistle Flute-whistle 914   Metropolitan Museum of Art, New York, NY 1
349715 89.4.3328 0 0 504524 Musical Instruments 18 Bell 64 Bell Mexican 11                           late 19th century 1885 1899 Clay 5548 H. 20.3 x Diam. 10.5cm (8 x 4 1/8in.) The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Idiophone-Struck-bell-clapper 950   Metropolitan Museum of Art, New York, NY 1
349721 89.4.3460 0 1 504532 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Aztec 4364 Late Postclassic (Pre-Columbian)                         1200–1521 1200 1521 Clay 5548 Diameter: 1 11/16 in. (4.3 cm) Weight: 1.376 oz. (39 g) The Crosby Brown Collection of Musical Instruments, 1889   Mazapa 2341   Texcoco District 1016 Mexico 1             Idiophone-Shaken-rattle 908   Metropolitan Museum of Art, New York, NY 1
349722 89.4.3464 0 0 504533 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11                           19th century 1801 1900 Clay 5548 H: 84 mm; D: 61 mm; W: 49 mm; Wt: 89 grams The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Idiophone-Shaken-rattle 908   Metropolitan Museum of Art, New York, NY 1
349724 89.4.3465 0 0 504535 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11                           19th century 1801 1900 Clay 5548 H: 69 mm; W: 37 mm; D: 36 mm; Wt: 53 grams The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Idiophone-Shaken-rattle 908   Metropolitan Museum of Art, New York, NY 1
349725 89.4.3466 0 0 504536 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11                           19th century 1801 1900 Clay 5548 H: 75 mm; W: 35 mm; D: 46 mm; Wt: 55 grams The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Idiophone-Shaken-rattle 908   Metropolitan Museum of Art, New York, NY 1
349726 89.4.3468 0 0 504537 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11                           19th century 1801 1900 Clay 5548 H: 79 mm; W: 48 mm; D: 62 mm; Wt: 50 grams The Crosby Brown Collection of Musical Instruments, 1889   Texcoco 2342     Mexico 1             Idiophone-Shaken-rattle 908   Metropolitan Museum of Art, New York, NY 1
349874 89.4.3303 0 1 504706 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11                           14th–16th century? 1300 1599 Clay 5548   The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Idiophone 999   Metropolitan Museum of Art, New York, NY 1
349908 89.4.3310 0 0 504743 Musical Instruments 18 Whistle 963 Whistle Mexican 11                             0 0 Clay 5548   The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Aerophone 955   Metropolitan Museum of Art, New York, NY 1
349909 89.4.3311 0 0 504744 Musical Instruments 18 Pottery Rattle (and Whistle?) 17126 Pottery Rattle (and Whistle?) Mexican 11                           19th century 1800 1899 Clay 5548   The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Idiophone 999   Metropolitan Museum of Art, New York, NY 1
349914 89.4.3327 0 1 504749 Musical Instruments 18 Pottery Bell 15841 Pottery Bell Mexican 11                           ca. 1889 1889 1889 Clay 5548 Overall: 12.7 x 11.4cm (5 x 4 1/2in.) The Crosby Brown Collection of Musical Instruments, 1889       Oaxaca 363 Mexico 1             Idiophone-Struck-bell-clapper 950   Metropolitan Museum of Art, New York, NY 1
411101 00.5.140 0 0 677432 Arts of Africa, Oceania, and the Americas 10 Vessel 3894 Funerary Urn Oaxaca 5445                           100 B.C.–A.D. 200 -100 200 Clay 5548 Height: 11 in. (27.9 cm) Museum Purchase, 1900       Veracruz 365 Mexico 1 Mesoamerica 34           Ceramics-Vessels 504   Metropolitan Museum of Art, New York, NY 1
411104 00.5.178 0 0 677436 Arts of Africa, Oceania, and the Americas 10 Figure 9 Human Figure Maya 4341                           100 B.C.–A.D. 200 -100 200 Clay 5548 H. 7 1/2 x W. 6 5/16 x D. 4 3/4 in. (19 x 16 x 12 cm) Museum Purchase, 1900       Veracruz 365 Mexico 1 Mesoamerica 34           Ceramics-Sculpture 490   Metropolitan Museum of Art, New York, NY 1
411105 00.5.92 0 0 677437 Arts of Africa, Oceania, and the Americas 10 Vessel 3894 Funerary Urn Oaxaca 5445                           100 B.C.–A.D. 200 -100 200 Clay 5548 H. 10 3/4 x W. 3 1/4 in. (27.3 x 8.3 cm) Museum Purchase, 1900       Veracruz 365 Mexico 1 Mesoamerica 34           Ceramics-Vessels 504   Metropolitan Museum of Art, New York, NY 1
411126 x.2.432 0 0 677460 Arts of Africa, Oceania, and the Americas 10 Figure 9 Terracotta Standing Human Figure Guerrero 5446                           A.D. 500–1000 500 1000 Clay 5548 Height: 10 5/8 in. (27 cm) Museum Accession         Mexico 1 Mesoamerica 34           Ceramics-Sculpture 490   Metropolitan Museum of Art, New York, NY 1
411127 x.2.433 0 0 677461 Arts of Africa, Oceania, and the Americas 10 Figure 9 Human Figure Guerrero 5446                           A.D. 500–1000 500 1000 Clay 5548 Height: 15 in. (38.1 cm) Museum Accession       Guerrero 366 Mexico 1             Ceramics-Sculpture 490   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 335.79ms · Data license: CC0 · Data source: metmuseum/openaccess