MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

21 rows where Subregion = 29

View and edit SQL

Suggested facets: Is Highlight, Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, 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
201040 95.28 0 1 322265 Ancient Near Eastern Art 14 Altar 6816 Altar                             ca. 232 232 232 Limestone 1737 20.47 x 8.27 in. (51.99 x 21.01 cm) Purchase, 1895           Syria 354 probably from Palmyra 29         Stone-Architectural-Inscribed 601   Metropolitan Museum of Art, New York, NY 1
201041 98.19.1 0 1 322266 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 150–200 150 200 Stone 164 21 5/8 x 17 1/4 x 8 3/4 in. (54.9 x 43.9 x 22.2 cm) Purchase, 1898           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201042 98.19.2 0 1 322267 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 150–200 150 200 Limestone 1737 20 5/8 × 15 1/8 × 7 5/8 in., 98 lb. (52.4 × 38.4 cm) Purchase, 1898           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201043 98.19.3 0 1 322268 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 200–273 200 273 Limestone 1737 20 x 15 7/16 x 9 1/16 in. (50.8 x 39.3 x 23 cm) Purchase, 1898           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201044 98.19.4 0 1 322269 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 150–200 150 200 Limestone 1737 19 1/4 x 13 7/8 x 8 15/16 in. (48.9 x 35.3 x 22.7 cm) Purchase, 1898           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201135 01.25.1 0 1 322367 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 50–150 50 150 Limestone 1737 20 x 14.96 in. (50.8 x 38 cm) Purchase, 1901           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201136 01.25.2 0 1 322368 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 150–200 150 200 Limestone, paint 25808 21 3/4 x 17 x 10 9/16 in. (55.2 x 43.2 x 26.8 cm) Purchase, 1901           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201137 01.25.3 0 1 322369 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 200–273 200 273 Limestone 1737 19 1/8 x 17 x 9 1/2 in. (48.6 x 43.2 x 24.1 cm) Purchase, 1901           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201138 01.25.4 0 1 322370 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 125–150 125 150 Limestone 1737 21 3/8 x 17 x 7 1/4 in. (54.3 x 43.2 x 18.4 cm) Purchase, 1901           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201139 01.25.5 0 1 322371 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 150–200 150 200 Limestone 1737 15.75 x 10.43 in. (40.01 x 26.49 cm) Purchase, 1901           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201140 01.25.6 0 1 322372 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 200–273 200 273 Limestone 1737 20 7/8 x 18 x 7 3/8 in. (53 x 45.7 x 18.7 cm) Purchase, 1901           Syria 354 probably from Palmyra 29         Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
201141 01.25.7 0 1 322373 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 50–150 50 150 Limestone 1737 10.55 x 9.57 in. (26.8 x 24.31 cm) Purchase, 1901           Syria 354 probably from Palmyra 29         Stone-Sculpture 479   Metropolitan Museum of Art, New York, NY 1
201142 01.25.8 0 1 322374 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 125–150 125 150 Limestone 1737 17 1/8 x 13 7/8 x 7 5/8 in. (43.5 x 35.2 x 19.4 cm) Purchase, 1901           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201143 02.29.1 1 1 322375 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 2nd–3rd century A.D. 100 299 Limestone 1737 H. 20 1/4 in. (51.4 cm) Purchase, 1902           Syria 354 probably from Palmyra 29         Stone-Reliefs-Inscribed 603   Metropolitan Museum of Art, New York, NY 1
201144 02.29.2 0 1 322376 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 150–200 150 200 Limestone 1737 20.51 x 17.01 in. (52.1 x 43.21 cm) Purchase, 1902           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201145 02.29.3 0 1 322377 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 148 148 148 Limestone, paint 25808 20.39 x 17.36 in. (51.79 x 44.09 cm) Purchase, 1902           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201146 02.29.4 0 1 322378 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 181 181 181 Limestone 1737 20.39 x 17.64 in. (51.79 x 44.81 cm) Purchase, 1902           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201147 02.29.5 0 1 322379 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 150–200 150 200 Limestone 1737 17.68 x 16.46 in. (44.91 x 41.81 cm) Purchase, 1902           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
201148 02.29.6 0 1 322380 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 172 172 172 Limestone 1737 20.63 x 15.63 in. (52.4 x 39.7 cm) Purchase, 1902           Syria 354 probably from Palmyra 29         Stone-Sculpture-Inscribed 604   Metropolitan Museum of Art, New York, NY 1
203075 55.109 0 1 324430 Ancient Near Eastern Art 14 Relief 3917 Tessera                             ca. 1st–2nd century A.D 1 2 Ceramic 161 1.18 x 1.5 in. (3 x 3.81 cm) Gift of Mr. and Mrs. Harry G. Friedman, 1955           Syria 354 probably from Palmyra 29         Ceramics-Reliefs 614   Metropolitan Museum of Art, New York, NY 1
206214 2012.454 0 1 328241 Ancient Near Eastern Art 14 Funerary relief 13638 Funerary relief                             ca. 125–150 125 150 Limestone 1737 25 1/2 x 20 1/8 x 12 in. (64.8 x 51.1 x 30.5 cm) Bequest of Armida B. Colt, 2011           Syria 354 probably from Palmyra 29         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 253.103ms · Data license: CC0 · Data source: metmuseum/openaccess