MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where "Artist End Date" is on date -4707-02-08, Artist Nationality = 2 and Is Public Domain = 0

✎ View and edit SQL

This data as json, CSV (advanced)

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
179540 179540 2005.100.44 0 0 283119 Photographs 13 Photograph 997 [Self-Portrait]           Artist 2   Adrien Tournachon French, 1825–1903   Tournachon, Adrien 15738 French 2 1825 1903 ca. 1855 1853 1857 Salted paper print from glass negative 26095 Image: 23.6 x 17.6 cm (9 5/16 x 6 15/16 in.) Mount: 32.4 x 21.2 cm (12 3/4 x 8 3/8 in.) Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005                       Photographs 21   http://www.metmuseum.org/art/collection/search/283119 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
180948 180948 2001.211 0 0 284559 Photographs 13 Photograph 997 Lefrisé           Artist 2   Adrien Tournachon French, 1825–1903   Tournachon, Adrien 15738 French 2 1825 1903 1860 1860 1860 Salted paper print from glass negative 26095 16.3 x 22.6 cm (6 7/16 x 8 7/8 in.) Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2001                       Photographs 21   http://www.metmuseum.org/art/collection/search/284559 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
181966 181966 2005.100.1285 0 0 285633 Photographs 13 Photograph 997 Pascaline           Artist 2   Adrien Tournachon French, 1825–1903   Tournachon, Adrien 15738 French 2 1825 1903 ca. 1855–60 1853 1862 Salted paper print or albumen print 26396 Image: 6 5/8 × 8 9/16 in. (16.9 × 21.8 cm) Mount: 11 7/8 × 14 5/16 in. (30.2 × 36.3 cm) Gilman Collection, Purchase, Denise and Andrew Saul Gift, 2005                       Photographs 21   http://www.metmuseum.org/art/collection/search/285633 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
213388 213388 2000.255 0 0 340784 Drawings and Prints 11 Drawing 23 The Artist's Portfolio, Pont Aven           Artist 2   Paul Gauguin French, Paris 1848–1903 Atuona, Hiva Oa, Marquesas Islands   Gauguin, Paul 10995 French 2 1848 1903 1894 1894 1894 Two inside covers decorated in watercolor and gouache over charcoal with graphite on heavy gray wove (blotting) paper sewn to leather; leather binding inscribed in pen and ink with additions in watercolor; multicolored silk ribbons stitched into binding. 32842 each drawing: 16-3/4 x 10-3/8 in. (42.5 x 26.4 cm) Promised Gift of Leon D. and Debra R. Black, and Purchase, Joseph Pulitzer and Florence B. Selden Bequests, and 1999 Benefit Fund, 2000                       Drawings 9   http://www.metmuseum.org/art/collection/search/340784 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
217125 217125 29.10.2(2) 0 0 344615 Drawings and Prints 11 Print 731 Portfolio of facsimiles of works by Paul Gauguin, Berlin (Marees Gesellschaft), 1926         Portfolio of 14 facsimiles 268 Artist 2   Paul Gauguin French, Paris 1848–1903 Atuona, Hiva Oa, Marquesas Islands   Gauguin, Paul 10995 French 2 1848 1903 1926 1926 1926 Facsimiles 33958   Harris Brisbane Dick Fund, 1929                       Prints 13   http://www.metmuseum.org/art/collection/search/344615 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
220120 220120 1984.1203.48 0 0 347651 Drawings and Prints 11 Print 731 Manao Tupaupau (Spirit of the Dead Watching)         L'Estampe originale 181 Artist 2   Paul Gauguin French, Paris 1848–1903 Atuona, Hiva Oa, Marquesas Islands   Gauguin, Paul 10995 French 2 1848 1903 1894 1894 1894 Lithograph on zinc printed on wove paper for L'Estampe originale, Part 6, April-June 1894 34634   Bequest of Scofield Thayer, 1982                       Prints 13   http://www.metmuseum.org/art/collection/search/347651 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
231042 231042 28.92.1 0 0 358742 Drawings and Prints 11 Print 731 Bather with Geese           Artist 2   Camille Pissarro French, Charlotte Amalie, Saint Thomas 1830–1903 Paris   Pissarro, Camille 19505 French 2 1830 1903 1895 1895 1895 Etching and drypoint on laid paper; third state of sixteen 36433 sheet: 5 7/8 x 8 1/8 in. (14.9 x 20.7 cm) plate: 5 1/16 x 7 in. (12.9 x 17.8 cm) Harris Brisbane Dick Fund, 1928                       Prints 13   http://www.metmuseum.org/art/collection/search/358742 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
266230 266230 2010.544 0 0 395206 Drawings and Prints 11 Print 731 Trees at Night           Artist 2   Armand Séguin French, Brittany 1869–1903 Finistère, Brittany   Séguin, Armand 39190 French 2 1869 1903 ca. 1894 1889 1899 Sugar-lift aquatint 35640 sheet: 11 5/8 x 17 5/16 in. (29.5 x 44 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 2010                       Prints 13   http://www.metmuseum.org/art/collection/search/395206 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307207 307207 1992.103.3 0 0 437313 European Paintings 15 Painting 69 The Garden of the Tuileries on a Spring Morning           Artist 2   Camille Pissarro French, Charlotte Amalie, Saint Thomas 1830–1903 Paris   Pissarro, Camille 19505 French 2 1830 1903 1899 1899 1899 Oil on canvas 953 28 7/8 x 36 1/4 in. (73.3 x 92.1 cm) Partial and Promised Gift of Mr. and Mrs. Douglas Dillon, 1992                       Paintings 11   http://www.metmuseum.org/art/collection/search/437313 4/23/2018 8:00:01 AM 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 7359.213ms · Data license: CC0 · Data source: metmuseum/openaccess