MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Classification = 479, Department = 10 and Object Name = 100

View and edit SQL

Suggested facets: Is Public Domain, Culture, Object Date, Object Begin Date, Object End Date, Medium, Country, Region

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
199286 2013.1137.2 0 0 318900 Arts of Africa, Oceania, and the Americas 10 Sculpture 100 Figure with Spinning Wheel Sumba Island 5228                           19th– early 20th century 1800 1950 Stone 164 H. 9 × W. 10 1/2 in. (22.9 × 26.7 cm) Gift of Fred and Rita Richman, 2013         Indonesia 106 Nusa Tenggara 42           Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
426850 2016.734.8 0 1 708746 Arts of Africa, Oceania, and the Americas 10 Sculpture 100 Sculpture in the shape of a feline Condorhuasi 5288                           500 B.C.–A.D. 500 -500 500 Stone 164 Other: 4 × 5 1/2 × 2 in. (10.2 × 14 × 5.1 cm) Anonymous Gift, 2016       Northwest Argentina 1112 Argentina 153             Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
434306 GK.160 0 0 722106 Arts of Africa, Oceania, and the Americas 10 Sculpture 100 Male Figure Huastec 4646                           A.D. 1200–1521 1200 1521 Sandstone 6928 H. 65 1/4 × W. 20 1/4 × D. 6 3/4 in. (165.7 × 51.5 × 17.1 cm) Museo de Antropología de Xalapa, Universidad Veracruzana, Xalapa (Reg. 49 P.J. 320)         Mexico 1 Veracruz 610           Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
434307 GK.161 0 0 722107 Arts of Africa, Oceania, and the Americas 10 Sculpture 100 Female Figure Huastec 4646                           A.D. 1200–1521 1200 1521 Limestone 1737 H. 66 × W. 27 5/8 × D. 10 in. (167.6 × 70.2 × 25.4 cm) Museo de Antropología de Xalapa, Universidad Veracruzana, Xalapa (INV09-211134)         Mexico 1 Veracruz 610           Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
434308 GK.162 0 0 722108 Arts of Africa, Oceania, and the Americas 10 Sculpture 100 Maize Cob Effigy Olmec 4549                           900–400 B.C. -900 -400 Jadeite 8170 H. 3 3/4 × Diam. 1 in. (9.5 × 2.5 cm) Museo de Antropología de Xalapa, Universidad Veracruzana, Xalapa         Mexico 1 Veracruz 610           Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
434310 GK.164 0 0 722110 Arts of Africa, Oceania, and the Americas 10 Sculpture 100 Cruz del Milagro Monument 1 (El Príncipe) Olmec 4549                           1200–900 B.C. -1200 -900 Basalt  61455 H. 50 1/4 × W. 31 1/2 × D. 30 in., 1300 lb. (1.28, 80 × 76.2 cm, 589676.132 g) Museo de Antropología de Xalapa, Universidad Veracruzana, Xalapa (Reg. 49 P.J. 4023)         Mexico 1 Veracruz 610           Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
434408 GK.125 0 0 722231 Arts of Africa, Oceania, and the Americas 10 Sculpture 100 Chalchiuhtlicue Aztec 4364                           ca. A.D. 1500 1500 1500 Diorite 25928 H. 31 1/2 × W. 14 3/4 × D. 10 13/16 in., Wt. 150 lb. (80 × 37.5 × 27.5 cm, 68039.554 g) Museo Nacional de Antropología, Secretaría de Cultura-INAH, Mexico City (10-82215)   Mexico City 1134     Mexico 1             Stone-Sculpture 479   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 2922.008ms · Data license: CC0 · Data source: metmuseum/openaccess