MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where "Artist Begin Date" is on date -4709-12-08 and Culture = 36

View and edit SQL

Suggested facets: Object Name, Artist Prefix, Artist Display Name, Artist Display Bio, Object Date, Object End Date, Medium, Credit Line, 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
116695 1971.206.35 0 1 205436 European Sculpture and Decorative Arts 3 Statuette 14 The Day (one of a pair) Italian 36         Artist 2 After an original by Michelangelo Buonarroti Italian, Caprese 1475–1564 Rome   Michelangelo Buonarroti 8300 Italian 6 1475 1564 ca. 1600 1595 1605 Terracotta 160 Overall: 15 1/2 × 28 × 10 in. (39.4 × 71.1 × 25.4 cm); Base: 9 × 20 1/2 × 11 in. (22.9 × 52.1 × 27.9 cm) Gift of Mr. and Mrs. Charles Wrightsman, 1971                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
116696 1971.206.36 0 1 205437 European Sculpture and Decorative Arts 3 Statuette 14 The Dusk (one of a pair) Italian 36         Artist 2 After an original by Michelangelo Buonarroti Italian, Caprese 1475–1564 Rome   Michelangelo Buonarroti 8300 Italian 6 1475 1564 ca. 1600 1595 1605 Terracotta 160 Overall: 14 1/2 × 31 × 12 in. (36.8 × 78.7 × 30.5 cm); Base: 9 × 20 1/2 × 11 in. (22.9 × 52.1 × 27.9 cm) Gift of Mr. and Mrs. Charles Wrightsman, 1971                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
139094 95.40.2a 0 0 231325 European Sculpture and Decorative Arts 3 Cast 7458 Lorenzo de Medici Italian 36         Artist 2 After an original by Michelangelo Buonarroti Italian, Caprese 1475–1564 Rome   Michelangelo Buonarroti 8300 Italian 6 1475 1564 1521–34 1521 1534 Plaster 153   John Taylor Johnston Memorial Collection, 1895                       Sculpture-Reproductions-Casts 332   Metropolitan Museum of Art, New York, NY 1
139095 95.40.2b 0 0 231326 European Sculpture and Decorative Arts 3 Tomb 9057 Evening Italian 36         Artist 2 After an original by Michelangelo Buonarroti Italian, Caprese 1475–1564 Rome   Michelangelo Buonarroti 8300 Italian 6 1475 1564 1521–34 1521 1534 Plaster 153   John Taylor Johnston Memorial Collection, 1895                       Sculpture-Reproductions-Casts 332   Metropolitan Museum of Art, New York, NY 1
139096 95.40.2c 0 0 231327 European Sculpture and Decorative Arts 3 Tomb 9057 Dawn Italian 36         Artist 2 After an original by Michelangelo Buonarroti Italian, Caprese 1475–1564 Rome   Michelangelo Buonarroti 8300 Italian 6 1475 1564 1521–34 1521 1534 Plaster 153   John Taylor Johnston Memorial Collection, 1895                       Sculpture-Reproductions-Casts 332   Metropolitan Museum of Art, New York, NY 1
139097 95.40.3 0 0 231329 European Sculpture and Decorative Arts 3 Cast 7458 Moses Italian 36         Artist 2 After an original by Michelangelo Buonarroti Italian, Caprese 1475–1564 Rome   Michelangelo Buonarroti 8300 Italian 6 1475 1564 1505–45 1505 1545 Plaster 153   John Taylor Johnston Memorial Collection, 1895                       Sculpture-Reproductions-Casts 332   Metropolitan Museum of Art, New York, NY 1
139098 95.48.1 0 0 231335 European Sculpture and Decorative Arts 3 Cast 7458 Pietà Italian 36         Artist 2 After an original by Michelangelo Buonarroti Italian, Caprese 1475–1564 Rome   Michelangelo Buonarroti 8300 Italian 6 1475 1564 1550–55 1550 1555 Plaster 153   John Taylor Johnston Memorial Collection, 1895                       Sculpture-Reproductions-Casts 332   Metropolitan Museum of Art, New York, NY 1
139099 95.49.1 0 1 231343 European Sculpture and Decorative Arts 3 Cast 7458 Dying Slave Italian 36         Artist 2 After an original by Michelangelo Buonarroti Italian, Caprese 1475–1564 Rome   Michelangelo Buonarroti 8300 Italian 6 1475 1564 1505–45 1505 1545 Plaster 153   John Taylor Johnston Memorial Collection, 1895                       Sculpture-Reproductions-Casts 332   Metropolitan Museum of Art, New York, NY 1
139100 95.49.2 0 1 231344 European Sculpture and Decorative Arts 3 Cast 7458 Rebellious Captive Italian 36         Artist 2 After an original by Michelangelo Buonarroti Italian, Caprese 1475–1564 Rome   Michelangelo Buonarroti 8300 Italian 6 1475 1564 1505–45 1505 1545 Plaster 153   John Taylor Johnston Memorial Collection, 1895                       Sculpture-Reproductions-Casts 332   Metropolitan Museum of Art, New York, NY 1
236501 62.93.1 (Mich) 0 0 364397 Greek and Roman Art 12 Drawing 23 Design for the Tomb of Pope Julius II della Rovere. Italian 36             Michelangelo Buonarroti     Michelangelo Buonarroti 8300   1475 1564 1506–13 1506 1513 Pen and brown ink, brush and brown wash, over stylus ruling and leadpoint 29397 20-1/16 x 12-9/16 in. (51 x 31.9 cm) Rogers Fund, 1962                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
328634 25.120.217 0 1 470265 The Cloisters 17 Statue 3890 Kneeling Virgin Italian 36         Artist 2 Attributed to Paolo Aquilano Italian, Abruzzo, active ca. 1475–1503 (Sculptor of the Berlin Enthroned Virgin?) Aquilano, Paolo  44728 Italian 6 1475 1503 ca. 1475–1500 1471 1503 Willow with paint and gilding 50275 Overall: 46 1/8 x 31 1/2 x 19 3/4 in., 63lb. (117.2 x 80 x 50.2 cm, 28576.6g) The Cloisters Collection, 1925 Made in 1     Abruzzo 763 Italy 14             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 4188.854ms · Data license: CC0 · Data source: metmuseum/openaccess