Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Department, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object End Date, 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 | Metadata Date | Repository |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 305752 | 305752 | 49.7.1 | 0 | 1 | 435642 | European Paintings 15 | Painting 69 | Madonna and Child with Saints | Artist 2 | Giovanni Bellini | Italian, Venice, active by 1459–died 1516 Venice | and Workshop | Bellini, Giovanni 43405 | Italian 6 | 1459 | 1516 | 1459 | 1516 | Tempera and oil on wood 44483 | 38 1/4 x 60 1/2 in. (97.2 x 153.7 cm) | The Jules Bache Collection, 1949 | Paintings 11 | http://www.metmuseum.org/art/collection/search/435642 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 305833 | 305833 | 48.78 | 0 | 1 | 435734 | European Paintings 15 | Painting 69 | Saint Sebastian | Artist 2 | Francesco Botticini (Francesco di Giovanni) | Italian, Florentine, ca. 1446–1497 | Botticini, Francesco (Francesco di Giovanni) 43437 | Italian 6 | 1446 | 1497 | 1466 | 1497 | Tempera and oil on wood 44483 | Overall, with arched top and engaged frame, 56 3/4 x 26 1/4 in. (144.1 x 66.7 cm); painted surface 53 3/4 x 23 in. (136.5 x 58.4 cm) | Gwynne Andrews, Rogers, and Harris Brisbane Dick Funds, 1948 | Paintings 11 | http://www.metmuseum.org/art/collection/search/435734 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
| 305931 | 305931 | 35.121 | 0 | 1 | 435848 | European Paintings 15 | Painting 69 | The Birth of the Virgin | Artist 2 | Fra Carnevale (Bartolomeo di Giovanni Corradini) | Italian, born by 1416–died 1484 Urbino | Carnevale, Fra (Bartolomeo di Giovanni Corradini) 43464 | Italian 6 | 1416 | 1484 | 1467 | 1467 | 1467 | Tempera and oil on wood 44483 | 57 x 37 7/8 in. (144.8 x 96.2 cm) | Rogers and Gwynne Andrews Funds, 1935 | Paintings 11 | http://www.metmuseum.org/art/collection/search/435848 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 306997 | 306997 | 27.41 | 0 | 1 | 437081 | European Paintings 15 | Painting 69 | Madonna and Child with the Infant Saint John the Baptist | Artist 2 | Michele da Verona (Michele di Zenone) | Italian, Verona 1470–1536/37 Verona (?) | Michele da Verona (Michele di Zenone) 43747 | Italian 6 | 1470 | 1537 | probably late 1490s | 1497 | 1499 | Tempera and oil on wood 44483 | 29 x 22 3/4 in. (73.7 x 57.8 cm) | Anonymous Gift, 1927 | Paintings 11 | http://www.metmuseum.org/art/collection/search/437081 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 307183 | 307183 | 75.7.1 | 0 | 1 | 437284 | European Paintings 15 | Painting 69 | The Return from the Hunt | Artist 2 | Piero di Cosimo (Piero di Lorenzo di Piero d'Antonio) | Italian, Florence 1462–1522 Florence | Piero di Cosimo (Piero di Lorenzo di Piero d'Antonio) 19699 | Italian 6 | 1462 | 1522 | ca. 1494–1500 | 1494 | 1500 | Tempera and oil on wood 44483 | 27 3/4 x 66 1/2 in. (70.5 x 168.9 cm) | Gift of Robert Gordon, 1875 | Paintings 11 | http://www.metmuseum.org/art/collection/search/437284 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 307184 | 307184 | 22.60.52 | 0 | 1 | 437285 | European Paintings 15 | Painting 69 | The Young Saint John the Baptist | Artist 2 | Piero di Cosimo (Piero di Lorenzo di Piero d'Antonio) | Italian, Florence 1462–1522 Florence | Piero di Cosimo (Piero di Lorenzo di Piero d'Antonio) 19699 | Italian 6 | 1462 | 1522 | 1482 | 1521 | Tempera and oil on wood 44483 | 11 1/2 x 9 1/4 in. (29.2 x 23.5 cm) | The Bequest of Michael Dreicer, 1921 | Paintings 11 | http://www.metmuseum.org/art/collection/search/437285 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
| 329658 | 329658 | 55.120.2 | 0 | 1 | 471730 | The Cloisters 17 | Painting 69 | Saint Michael | North Spanish 1204 | Artist 2 | Master of Belmonte | Spanish, Aragon, active ca. 1460–90 | Master of Belmonte 44740 | Spanish 76 | 1455 | 1490 | 1450–1500 | 1450 | 1500 | Tempera and oil on wood 44483 | Overall: 85 1/2 x 47 in. (217.2 x 119.4 cm) | The Cloisters Collection, 1955 | Paintings-Panels 812 | http://www.metmuseum.org/art/collection/search/471730 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
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");