MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Culture = 70 and Department = 6

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

Department

  • Medieval Art · 8
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
323722 07.169.44 0 1 462997 Medieval Art 6 Crucifix 4298 Crucifix Russian 70                           16th century 1500 1599 Wood 25 Overall (without nail): 6 7/16 x 3 9/16 x 15/16 in. (16.4 x 9 x 2.4 cm) with nail: 6 13/16 in. (17.3 cm) Gift of Charles W. Woolsey, 1906                       Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
324336 17.190.129 0 1 464010 Medieval Art 6 Disk 2494 Disk from a Panagiarion with the Virgin and Child Russian 70                           ca. 1500 or later 1500 1699 Ivory 148 Overall: Diam. 2 3/8 x 1/4 in. (Diam. 6 x 0.7 cm) Gift of J. Pierpont Morgan, 1917                       Ivories 181   Metropolitan Museum of Art, New York, NY 1
325999 18.88 0 0 465941 Medieval Art 6 Icon 4044 Devotional Icon Russian 70                           19th century 1800 1899 Copper alloy, surrey enamel 49707 Overall: 13 1/4 x 6 1/4 x 3/8 in. (33.7 x 15.9 x 1 cm) Gift of Percy Stickney Grant, 1918                       Enamels-Surrey 846   Metropolitan Museum of Art, New York, NY 1
326671 28.217.1 0 1 466711 Medieval Art 6 Triptych 6914 Triptych with Christ, Virgin, St. John The Baptist Russian 70                           18th century 1700 1799 Brass, surrey enamel 49893 Overall (opened): 7 7/16 x 18 1/2 x 9/16 in. (18.9 x 47 x 1.5 cm) Overall (closed): 7 7/16 x 6 7/16 x 5/16 in. (18.9 x 16.3 x 0.8 cm) Gift of V. Everitt Macy, 1928                       Enamels-Translucent 835   Metropolitan Museum of Art, New York, NY 1
327246 34.163a-c 0 1 467608 Medieval Art 6 Panagiarion 14823 Panagiarion with the Virgin and Child and the Three Angels at Mamre (interior) and the Crucifixion and Three Church Fathers (exterior) Russian 70                           ca. 1500 or later 1500 1700 Wood, stained, silver-gilt, pearls and garnet 49957 Overall (opened): 3 x 4 1/8 x 9/16 in. (7.6 x 10.5 x 1.4 cm) Overall (closed): 3 x 2 1/4 x 13/16 in. (7.6 x 5.7 x 2.1 cm) without mount: Diam. 1 13/16 x 3/8 in. (Diam. 4.6 x 1 cm) Rogers Fund, 1934                       Sculpture-Miniature-Wood 820   Metropolitan Museum of Art, New York, NY 1
328111 83.18.196 0 1 468766 Medieval Art 6 Bowl 106 Bowl Russian 70                           19th century 1800 1883 Gold plate 49005 Overall: 5/8 x 10 1/16 x 6 5/8 in. (1.6 x 25.5 x 16.8 cm) Gift of Henry G. Marquand, 1883                       Reproductions-Metalwork 810   Metropolitan Museum of Art, New York, NY 1
328112 83.18.199 0 1 468767 Medieval Art 6 Bowl 106 Bowl Russian 70                           19th century 1800 1883 Gold plate 49005 Overall: 1 1/4 x 4 3/4 in. (3.2 x 12.1 cm) Gift of Henry G. Marquand, 1883                       Reproductions-Metalwork 810   Metropolitan Museum of Art, New York, NY 1
328260 89.2.42 0 1 468932 Medieval Art 6 Diptych leaf 14650 Diptych Leaf Russian 70                           18th–19th century 1700 1899 Brass, surrey enamel 49893 Overall: 2 5/16 x 2 5/16 x 1/4 in. (5.9 x 5.8 x 0.7 cm) Gift of Joseph W. Drexel, 1889                       Enamels-Surrey 846   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 230.388ms · Data license: CC0 · Data source: metmuseum/openaccess