MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Country = 514

View and edit SQL

Suggested facets: Is Highlight, Department, Object Name, Culture, Object End Date, Medium, City, County, 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
324177 16.154.10a, b 0 1 463706 Medieval Art 6 Statue 3890 Enthroned Virgin and Child Italian 36                           mid-14th century 1330 1470 Wooden core, painted canvas and gesso 49076 Virgin and Child only: 64 1/4 × 35 × 14 3/4 in., 54 lb. (163.2 × 88.9 × 37.5 cm, 24.5 kg) Rogers Fund, 1916 Made in 1 probably Umbria 1871   Tuscany 119 Central Italy 514             Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
327615 47.100.45a–g 1 1 468207 Medieval Art 6 Doorway 369 Doorway from the Church of San Nicolò, San Gemini Central Italian 2954                           carved 1000s, assembled 1100s or 1200s 1000 1299 Marble (Lunense marble from Carrara) 48997 H. 11 ft. 9 in. x 8 ft. 4 in. (358.4 x 254.2 cm) Fletcher Fund, 1947 Made in 1 San Gemini 1991   Umbria 621 Central Italy 514             Sculpture-Architectural 336   Metropolitan Museum of Art, New York, NY 1
327827 53.49 0 1 468441 Medieval Art 6 Statue 3890 Standing Virgin and Child Central Italian 2954                           ca. 1380–1400 1380 1400 Wood, painted and gilded 13007 Overall: 47 x 16 3/16 x 9 3/8 in. (119.4 x 41.1 x 23.8 cm) at base: 13 7/8 x 5 3/4 in. (35.2 x 14.6 cm) Gift of Mrs. A. Stewart Walker, in memory of A. Stewart Walker, 1953 Made in 1     Umbria 621 Central Italy 514             Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
327867 55.56 0 1 468487 Medieval Art 6 Brooch 131 Bow Brooch Langobardic 377                           late 6th–early 7th century 575 625 Silver-gilt, niello 23099 Overall: 6 3/16 x 3 11/16 x 11/16 in. (15.7 x 9.4 x 1.8 cm) Purchase, Joseph Pulitzer Bequest, 1955 Made in 1       Central Italy 514             Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
328492 1984.197 0 1 469882 The Cloisters 17 Relief 3917 Relief from a Pulpit with the Symbol of Saint Luke Italian 36         Artist 2   Master Christophanus or Stephanus Italian, active late 12th century , and his Workshop Master Christophanus or Stephanus 44717 Italian 6 1171 1200 ca. 1180 1176 1183 Limestone with lead 50219 Overall: 45 1/4 x 22 1/16 x 8 1/4in. (115 x 56 x 21cm) The Cloisters Collection, 1984 Made in 1     Abruzzo 763 Central Italy 514             Sculpture-Architectural 336   Metropolitan Museum of Art, New York, NY 1
329309 47.101.19 0 1 471261 The Cloisters 17 Sculpture 100 Seated Figure (Prophet or Apostle) Italian 36         Artist 2 Attributed to the Master of Santa Maria la Bianca Italian, active late 12th–early 13th century   the Master of Santa Maria la Bianca 44736 Italian 6     ca. 1200 1197 1203 Marble (Carrara marble) with lead and serpentine inlay 50340 Overall: 24 1/2 x 9 1/2 x 10 7/8 in. (62.2 x 24.1 x 27.6 cm) The Cloisters Collection, 1947 Made in 1 probably Lucca 2070   Tuscany 119 Central Italy 514             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
329753 57.63 0 1 471825 The Cloisters 17 Sculpture 100 Fragment of a Figure Italian 36                           ca. 1225 1222 1228 Marble (Carrara marble) 48969 Overall: 31 3/4 x 13 7/8 x 7 5/8 in. (80.6 x 35.2 x 19.4 cm) The Cloisters Collection, 1957 Made in 1 probably Lucca 2070   Tuscany 119 Central Italy 514             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
329776 60.140 0 1 471848 The Cloisters 17 Relief 3917 Relief with the Annunciation Italian 36                           ca. 1180–1200 1177 1203 Carrara marble inlaid with serpentine (verde di Prato) 50396 26 1/2 x 24 x 4 3/4 in. (67.3 x 61 x 12.1 cm) The Cloisters Collection, 1960 Made in 1 Florence 562     Central Italy 514             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
329850 64.96 0 1 471922 The Cloisters 17 Font 14699 Holy-water Font Italian 36         Artist 2 Follower of Guglielmus Italian, active 1158–65   Guglielmus 44754 Italian 6 1158 1165 ca. 1160–65 1157 1168 Marble (Carrara marble) 48969 Overall: 9 1/2 x 4 1/2 x 15 in. (24.1 x 11.4 x 38.1 cm) The Cloisters Collection, 1964 Made in 1 probably Pisa 2087   Tuscany 119 Central Italy 514             Sculpture-Architectural 336   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 130.128ms · Data license: CC0 · Data source: metmuseum/openaccess