MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Culture = 4191

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, 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
149551 13.225.3 0 1 248753 Greek and Roman Art 12 Statuette of a girl 10961 Statuette of a girl Greek ? 4191 Archaic                           -800 -480 Bronze 23 H.: 3 13/16 in. (9.7 cm) Rogers Fund, 1913                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
151295 17.230.4 0 1 250542 Greek and Roman Art 12 Statuette of an athlete 11520 Statuette of an athlete Greek ? 4191 Late Classical                         4th century B.C. -399 -300 Bronze 23 H.: 6 1/4 in. (15.9 cm) Rogers Fund, 1917                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
151331 17.230.47 0 0 250580 Greek and Roman Art 12 Relief of a satyr and goat 11532 Relief of a satyr and goat Greek ? 4191 Hellenistic                         3rd–1st century B.C. -299 -1 Terracotta 160 H. 4 5/16 in. (11 cm) Rogers Fund, 1917                       Terracottas 411   Metropolitan Museum of Art, New York, NY 1
151749 21.88.154, .155 0 1 251024 Greek and Roman Art 12 Earring with head of lion, pair 11681 Earring with head of lion, pair Greek ? 4191 Late Classical or Hellenistic                         4th–3rd century B.C. -399 -200 Gold 1 Other (.154): 7/16 × 7/8 × 15/16 in. (1.1 × 2.2 × 2.3 cm) Other (.155): 3/8 × 3/4 × 1 in. (1 × 1.9 × 2.5 cm) Rogers Fund, 1921                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
153043 26.31.451 0 0 252373 Greek and Roman Art 12 Head 3965 Head Greek ? 4191                             -7000 -30 Terracotta 160 H. 2 9/16 in. (6.5 cm) Bequest of Richard B. Seager, 1926                       Terracottas 411   Metropolitan Museum of Art, New York, NY 1
153044 26.31.452 0 0 252374 Greek and Roman Art 12 Head 3965 Head Greek ? 4191                             -7000 -30 Terracotta 160 H. 4 3/4 in. (12.1 cm) Bequest of Richard B. Seager, 1926                       Terracottas 411   Metropolitan Museum of Art, New York, NY 1
153046 26.31.454 0 0 252376 Greek and Roman Art 12 Statuette of a woman 9360 Statuette of a woman Greek ? 4191                             -7000 -30 Terracotta 160 H. 3 1/2 in. (8.9 cm) Bequest of Richard B. Seager, 1926                       Terracottas 411   Metropolitan Museum of Art, New York, NY 1
153048 26.31.456 0 0 252378 Greek and Roman Art 12 Head of a woman 9346 Head of a woman Greek ? 4191                             -7000 -30 Terracotta 160 H. 4 1/8 in. (10.5 cm) Bequest of Richard B. Seager, 1926                       Terracottas 411   Metropolitan Museum of Art, New York, NY 1
153051 26.31.459 0 0 252381 Greek and Roman Art 12 Head of a youth 9322 Head of a youth Greek ? 4191                             -7000 -30 Terracotta 160 H. 4 1/8 in. (10.5 cm) Bequest of Richard B. Seager, 1926                       Terracottas 411   Metropolitan Museum of Art, New York, NY 1
153053 26.31.461 0 0 252383 Greek and Roman Art 12 Head of a bull 9329 Head of a bull Greek ? 4191                             -7000 -30 Terracotta 160 H. 3 1/4 in. (8.3 cm) Bequest of Richard B. Seager, 1926                       Terracottas 411   Metropolitan Museum of Art, New York, NY 1
153999 31.11.9 0 1 253347 Greek and Roman Art 12 Relief of a woman playing flutes and man 12155 Terracotta relief Greek ? 4191 Classical ?                         ca. 450 B.C. or later -450 -330 Terracotta 160 H.: 6 5/16 in. (16 cm) Fletcher Fund, 1931                       Terracottas 411   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 138.628ms · Data license: CC0 · Data source: metmuseum/openaccess