MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Country = 5 and County = 630

View and edit SQL

Suggested facets: Department, Medium, Credit Line, Classification

County

  • Castile · 6
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
324203 16.32.153 0 1 463751 Medieval Art 6 Statuette 14 Saint James the Lesser Spanish 13         Artist 2 Workshop of Gil de Siloe Spanish, active 1475–1505   Siloe, Gil de 44653 Spanish 76 1475 1505 ca. 1500 1495 1505 Alabaster 162 Overall: 29 x 9 11/16 x 7 1/4 in. (73.6 x 24.6 x 18.4 cm) Gift of J. Pierpont Morgan, 1916 Made in 1     Castile 630 Spain 5             Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
324491 17.190.2118 0 1 464183 Medieval Art 6 Panel 399 Panel from the tomb of Don Garcia Osorio Spanish 13                           16th century 1500 1599 Alabaster 162 Overall: 25 3/4 x 8 1/2 in. (65.4 x 21.6 cm) Gift of J. Pierpont Morgan, 1917 Made in 1 Ocana 1891   Castile 630 Spain 5             Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
327483 41.190.86 0 1 468046 Medieval Art 6 Statue 3890 Virgin and Child Spanish 13                           15th century 1400 1499 Wood with paint and gilding 49233 43 x 16 x 8 1/2 in. (109.2 x 40.6 x 21.6 cm) Bequest of George Blumenthal, 1941 Made in 1     Castile 630 Spain 5             Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
328973 25.120.476 0 1 470899 The Cloisters 17 Altar 6816 Altar Spanish 13                           late 12th century 1171 1199 Stone 164 Overall: 35 3/4 x 53 1/4 x 22 in. (90.8 x 135.3 x 55.9 cm) The Cloisters Collection, 1925 Made in 1     Castile 630 Spain 5             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
330211 25.120.257 0 1 472322 The Cloisters 17 Altarpiece 4380 Scenes from the Life of Saint Andrew Spanish 13                           late 14th century 1350 1399 Tempera on wood, gold ground 44477 78 1/4 in. × 39 3/4 in. × 2 1/8 in. × 15/16 in. (198.8 × 101 × 5.4 × 2.4 cm) The Cloisters Collection, 1925 Made in 1     Castile 630 Spain 5             Paintings-Panels 812   Metropolitan Museum of Art, New York, NY 1
457629 2018.59 0 1 773026 The Cloisters 17   Hebrew Bible Spanish 13                           1300–1350 (before 1366) 1300 1350 Ink, tempera, and gold on parchmen; leather binding 63708 476 folios: 9 5/16 × 7 15/16 in. (23.7 × 20.1 cm) Binding: 9 15/16 × 8 3/4 × 4 1/4 in. (25.2 × 22.3 × 10.8 cm) The Cloisters Collection, 2018 Made in 1     Castile 630 Spain 5             Manuscripts and Illuminations 162   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 200.621ms · Data license: CC0 · Data source: metmuseum/openaccess