MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Culture = 5657 and Object Name = 100

View and edit SQL

Suggested facets: Object Date, Object Begin Date, Object End Date, Medium, Region, Classification

Object Name

  • Sculpture · 9
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
201252 17.230.129 0 1 322494 Ancient Near Eastern Art 14 Sculpture 100 Head of a wild ram Achaemenid 5657 Achaemenid                         ca. 6th–4th century B.C. -600 -300 Gold 1 0.62 in. (1.57 cm) Rogers Fund, 1917           Iran (?) 363           Metalwork-Sculpture 521   Metropolitan Museum of Art, New York, NY 1
201280 25.95 0 1 322539 Ancient Near Eastern Art 14 Sculpture 100 Figure of a horseman Achaemenid 5657 Achaemenid                         ca. 5th–4th century B.C. -500 -300 Ceramic 161 0.98 in. (2.49 cm) Gift of Edward Robinson, 1925           Iran 347           Ceramics-Sculpture 490   Metropolitan Museum of Art, New York, NY 1
202696 47.100.83 0 1 324025 Ancient Near Eastern Art 14 Sculpture 100 Bull's head from column capital Achaemenid 5657 Achaemenid                         ca. 5th century B.C. -500 -400 Limestone 1737 18.5 in. (46.99 cm) Rogers Fund, 1947 From 19         Iran 347 Istakhr, near Persepolis 75         Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
202776 50.197 0 1 324109 Ancient Near Eastern Art 14 Sculpture 100 Lion head Achaemenid 5657 Achaemenid                         ca. 6th–4th century B.C. -600 -300 Gold 1 1.75 in. (4.45 cm) Purchase, Joseph Pulitzer Bequest, 1950           Iran 347           Metalwork-Sculpture 521   Metropolitan Museum of Art, New York, NY 1
203078 55.121.3 0 1 324433 Ancient Near Eastern Art 14 Sculpture 100 Head of a Persian guard Achaemenid 5657 Achaemenid                         ca. 486–465 B.C. -486 -465 Limestone 1737 21.26 x 24.41 x 4.72 in. (54 x 62 x 11.99 cm) Purchase, Joseph Pulitzer Bequest, 1955           Iran  385 Persepolis 49         Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
203464 59.41.25 0 1 324855 Ancient Near Eastern Art 14 Sculpture 100 Figurine Achaemenid 5657 Achaemenid                         ca. 6th–5th century B.C. -600 -400 Ceramic 161 2.68 x 2.2 x 0.79 in. (6.81 x 5.59 x 2.01 cm) Rogers Fund, 1959           Mesopotamia 335 Nippur 81         Ceramics-Sculpture 490   Metropolitan Museum of Art, New York, NY 1
203924 61.120 0 1 325339 Ancient Near Eastern Art 14 Sculpture 100 Head of a ram Achaemenid 5657 Achaemenid                         ca. 5th–4th century B.C. -500 -300 Limestone (tura) 28711 2.99 x 2.48 x 3.07 in. (7.59 x 6.3 x 7.8 cm) Rogers Fund, 1961           Egypt (?) 372           Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
204087 62.73 0 1 325506 Ancient Near Eastern Art 14 Sculpture 100 Figure of a horse and rider Achaemenid 5657 Achaemenid                         ca. 5th–4th century B.C. -500 -300 Ceramic 161 3.66 x 1.26 x 2.17 in. (9.3 x 3.2 x 5.51 cm) Rogers Fund, 1962           Iran 347           Ceramics-Sculpture 490   Metropolitan Museum of Art, New York, NY 1
206254 X.720 0 1 328794 Ancient Near Eastern Art 14 Sculpture 100 Sculpture fragment Achaemenid 5657 Achaemenid                         ca. 6th–4th century B.C. -600 -300 Stone 164 1 15/16 × 2 13/16 in. (5 × 7.1 cm) Museum Accession           Iran  385 possibly from Persepolis 126         Stone-Sculpture-Inscribed 604   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 145.57ms · Data license: CC0 · Data source: metmuseum/openaccess