MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Culture = 7, Geography Type = 1 and Object Name = 100

View and edit SQL

Suggested facets: Is Highlight

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
324187 16.31.1 0 1 463716 Medieval Art 6 Sculpture 100 Pietà with Donors French 7                           ca. 1515 1515 1515 Limestone, traces of polychromy 49077 Overall: 43 3/8 x 92 1/2 x 22 in. (110.2 x 235 x 55.9 cm) Gift of J. Pierpont Morgan, 1916 Made in 1 Biron 1875   Dordogne 628 France 9             Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
324188 16.31.2a 0 1 463717 Medieval Art 6 Sculpture 100 Entombment of Christ French 7                           ca. 1515 1515 1515 Limestone, polychromy 4597 Figurative area: 90 in. × 9 ft. 8 1/2 in. × 39 in. (228.6 × 295.9 × 99.1 cm) Other (Recess): 90 in. × 9 ft. 8 1/2 in. × 31 in. (228.6 × 295.9 × 78.7 cm) Stone Frame: 8 ft. 10 in. × 12 ft. 4 1/2 in. × 31 in. (269.2 × 377.2 × 78.7 cm) Gift of J. Pierpont Morgan, 1916 Made in 1 Biron 1875   Dordogne 628 France 9             Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
324209 16.32.160 0 1 463758 Medieval Art 6 Sculpture 100 Saint Mary Magdalene French 7                           ca. 1500–1525 1500 1525 Limestone with traces of paint 48956 Overall: 43 7/8 x 12 1/2 x 10 3/8 in. (111.4 x 31.8 x 26.4 cm) Gift of J. Pierpont Morgan, 1916 Made in 1 Troyes 1169                   Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
324213 16.32.166 0 1 463765 Medieval Art 6 Sculpture 100 Virgin and Child French 7                           early 16th century 1500 1525 Limestone, traces of polychromy 49077 Overall: 29 7/8 x 17 1/4 x 12in. (75.9 x 43.8 x 30.5cm) Gift of J. Pierpont Morgan, 1916 Made in 1 Troyes 1169                   Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
324288 16.32.30 0 1 463903 Medieval Art 6 Sculpture 100 Virgin and Child French 7                           15th century 1400 1499 Limestone with polychromy 49100 Overall: 64 1/4 x 23 3/8 x 16 in. (163.2 x 59.4 x 40.6 cm) Weight approx.: 1236lb. (560.6kg) Gift of J. Pierpont Morgan, 1916 Made in 1 Touraine 1880   Loire 634               Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
324876 17.190.750 0 1 464612 Medieval Art 6 Sculpture 100 Saint Savina of Troyes or Saint Syra French 7                           1510–20 1510 1520 Limestone with paint 49316 Overall (without pedestal): 48 3/8 x 15 x 11 1/2 in. (122.9 x 38.1 x 29.2 cm) Base (stone pedestal): 29 1/4 x 17 3/8 x 14 1/8 in. (74.3 x 44.1 x 35.9 cm) Gift of J. Pierpont Morgan, 1917 Made in 1     Champagne 625 France 9             Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
326359 20.157 1 1 466311 Medieval Art 6 Sculpture 100 Column Statue of a King French 7                           ca. 1150–60 1150 1160 Limestone 1737 Overall: 45 7/8 × 9 1/4 × 9 1/8 in. (116.5 × 23.5 × 23.2 cm) Other (Column without king): 45 7/8 × diam. 5 1/2 in. (116.5 × diam. 14 cm) Other (weight): 155 lb. (70.3 kg) Purchase, Joseph Pulitzer Bequest, 1920 Made in 1 Saint-Denis 1867                   Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
326442 22.60.17 0 1 466404 Medieval Art 6 Sculpture 100 The Priest Aaron French 7                           ca. 1170 1170 1170 Limestone 1737 Overall: 50 x 16 1/2 x 13 1/2 in. (127 x 41.9 x 34.3 cm) The Bequest of Michael Dreicer, 1921 Made in 1 Noyon 1955   Picardy (Oise) 700               Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
329310 47.101.20 0 1 471262 The Cloisters 17 Sculpture 100 Angel French 7                           ca. 1120 1117 1123 Limestone 1737 Overall: 13 3/4 in. (34.9 cm) The Cloisters Collection, 1947 Made in 1     Burgundy 211 France 9             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
329778 65.268 0 1 471850 The Cloisters 17 Sculpture 100 Sculpture of Moses with Tablets of the Law French 7                           ca. 1170 1167 1173 Limestone, polychromy 4597 Overall: 49 x 15 3/4 x 13 3/8 in. (124.5 x 40 x 34 cm) Gift of Raymond Pitcairn, 1965 Made in 1 Noyon 1955   Picardy (Oise) 700 France 9             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
329781 67.153 0 1 471853 The Cloisters 17 Sculpture 100 Enthroned Virgin and Child French 7                           1150–1200 1150 1200 Walnut with gesso, paint, tin leaf, and traces of linen 50397 27 × 11 1/4 × 11 in. (68.6 × 28.6 × 27.9 cm) The Cloisters Collection and James J. Rorimer Memorial Fund, 1967 Made in 1     Auvergne 342 France 9             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
330199 25.120.221 0 1 472310 The Cloisters 17 Sculpture 100 Torso of Christ French 7                           late 12th century 1150 1199 Poplar, gesso, paint, and metal leaf 50434 43 x 13 3/4 x 9 1/2 in. (109.2 x 34.9 x 24.1 cm) The Cloisters Collection, 1925 Made in 1     Auvergne 342 France 9             Sculpture-Wood 166   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 6126.558ms · Data license: CC0 · Data source: metmuseum/openaccess