MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where City = 27 and Medium = 148

View and edit SQL

Suggested facets: Department, Object Name, Object Date, Object Begin Date, Object End Date, Credit Line, Country

City

  • Paris · 7
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
324572 17.190.276 0 1 464275 Medieval Art 6 Triptych leaf 14702 Central Portion from a Triptych with the Crucifixion and Virgin and Child French 7                           ca. 1250–80 1250 1280 Ivory 148 Overall: 6 15/16 x 3 7/8 x 1/4 in. (17.6 x 9.8 x 0.7 cm) Gift of J. Pierpont Morgan, 1917 Made in 1 Paris 27     France 9             Ivories 181   Metropolitan Museum of Art, New York, NY 1
327281 38.108 0 1 467643 Medieval Art 6 Plaque 75 Leaf of a Writing Tablet French 7                           14th century 1300 1399 Ivory 148 Overall: 4 9/16 x 3 1/16 x 3/16 in. (11.7 x 7.8 x 0.6 cm) Gift of Ann Payne Blumenthal, 1938 Made in 1 Paris 27     French 532             Ivories 181   Metropolitan Museum of Art, New York, NY 1
327346 41.100.164 0 1 467737 Medieval Art 6 Statuette 14 Angel French 7                           ca. 1360–70 1360 1370 Ivory 148 Overall (without base): 5 3/4 x 1 3/4 x 1 in. (14.6 x 4.5 x 2.5 cm) Base (Wooden base): 7/8 x 1 9/16 x 2 3/16 in. (2.3 x 4 x 5.6 cm) Gift of George Blumenthal, 1941 Made in 1 Paris 27     France 9             Ivories 181   Metropolitan Museum of Art, New York, NY 1
331362 2003.131.1 0 1 475487 The Cloisters 17 Roundel 760 Roundel with Scenes of the Attack on the Castle of Love French 7                           ca. 1320–40 1320 1340 Ivory 148 Overall: Diam. 5 9/16 x 1/2 in. (Diam. 14.1 x 1.2 cm) The Cloisters Collection, 2003 Made in 1 Paris 27     France 9             Ivories 181   Metropolitan Museum of Art, New York, NY 1
331363 2003.131.2 0 1 475488 The Cloisters 17 Casket plaque 14685 Panel with Hunting Scenes French 7                           ca. 1350 1350 1350 Ivory 148 Overall: 4 5/16 x 12 1/8 x 3/16 in. (11 x 30.8 x 0.5 cm) W: 29.0-30.8 cm; Depth: .2-.5 cm The Cloisters Collection, 2003 Made in 1 Paris 27     France 9             Ivories 181   Metropolitan Museum of Art, New York, NY 1
331364 2003.131.3a, b 0 1 475489 The Cloisters 17 Plaque 75 Cover of a Writing Tablet French 7                           ca. 1325–50 1325 1350 Ivory 148 Overall: 3 11/16 x 2 5/16 x 5/16 in. (9.3 x 5.9 x 0.8 cm) The Cloisters Collection, 2003 Made in 1 Paris 27   Île-de-France 330 France 9             Ivories 181   Metropolitan Museum of Art, New York, NY 1
331365 2003.131.4 0 1 475490 The Cloisters 17 Plaque 75 Plaque with the Fountain of Youth French 7                           ca. 1320–40 1320 1340 Ivory 148 Overall: 4 7/16 x 2 5/8 x 3/16 in. (11.2 x 6.6 x 0.4 cm) The Cloisters Collection, 2003 Made in 1 Paris 27   Île-de-France 330 France 9             Ivories 181   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 1551.1ms · Data license: CC0 · Data source: metmuseum/openaccess