MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where "Artist End Date" is on date -4707-02-21 and Is Highlight = 1

View and edit SQL

Suggested facets: Department, Object Name, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Object Date, Object Begin 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
9693 67.187.123 1 1 10464 American Paintings and Sculpture 2 Painting 69 At the Seaside           Artist 2   William Merritt Chase American, Williamsburg, Indiana 1849–1916 New York   Chase, William Merritt 1337 American 1 1849 1916 ca. 1892 1889 1892 Oil on canvas 953 20 x 34 in. (50.8 x 86.4 cm) Bequest of Miss Adelaide Milton de Groot (1876–1967), 1967                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
10001 34.92 1 1 10819 American Paintings and Sculpture 2 Painting 69 The Champion Single Sculls (Max Schmitt in a Single Scull)           Artist 2   Thomas Eakins American, Philadelphia, Pennsylvania 1844–1916 Philadelphia, Pennsylvania   Eakins, Thomas 1408 American 1 1844 1916 1871 1871 1871 Oil on canvas 953 32 1/4 x 46 1/4 in. (81.9 x 117.5 cm) Purchase, The Alfred N. Punnett Endowment Fund and George D. Pratt Gift, 1934                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
10009 17.172 1 1 10827 American Paintings and Sculpture 2 Painting 69 The Thinker: Portrait of Louis N. Kenton           Artist 2   Thomas Eakins American, Philadelphia, Pennsylvania 1844–1916 Philadelphia, Pennsylvania   Eakins, Thomas 1408 American 1 1844 1916 1900 1900 1900 Oil on canvas 953 82 x 42 in. (208.3 x 106.7 cm) John Stewart Kennedy Fund, 1917                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
13134 1991.145 1 1 14282 American Decorative Arts 1 Library table 579 Library Table American 1         Maker|Maker 6   William Lightfoot Price|Rose Valley 1861–1916   Price, William Lightfoot|Rose Valley 2153   1861 1916 1904 1904 1904 White oak, stained 2324 29 1/2 x 66 x 39 1/2 in. (74.9 x 167.6 x 100.3 cm) Sansbury-Mills Fund, 1991 Made in 1 Rose Valley 367 Delaware 83 Delaware 84 United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
160461 1979.622 1 1 262612 Photographs 13 Photograph 997 View on the Columbia, Cascades           Artist 2   Carleton E. Watkins American, 1829–1916   Watkins, Carleton E. 13489 American 1 1829 1916 1867 1867 1867 Albumen silver print from glass negative 26061 40.0 x 52.4 cm (15 3/4 x 20 5/8 in.) Warner Communications Inc. Purchase Fund and Harris Brisbane Dick Fund, 1979                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
163944 1989.1083 1 1 266133 Photographs 13 Photograph 997 The Town on the Hill, New Almaden           Artist 2   Carleton E. Watkins American, 1829–1916   Watkins, Carleton E. 13489 American 1 1829 1916 1863 1863 1863 Albumen silver print from glass negative 26061 39.7 x 52.3 cm (15 5/8 x 20 9/16 in.) Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 1989                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
169558 43.87.17 1 1 271885 Photographs 13 Photograph 997 Two Pupils in Greek Dress           Artist 2   Thomas Eakins American, Philadelphia, Pennsylvania 1844–1916 Philadelphia, Pennsylvania   Eakins, Thomas 1408 American 1 1844 1916 1883 1883 1883 Platinum print  26262 36.8 x 26.7 cm. (14 1/2 x 10 1/2 in.) David Hunter McAlpin Fund, 1943                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
169563 43.87.23 1 1 271890 Photographs 13 Photograph 997 [Thomas Eakins and John Laurie Wallace on a Beach]           Artist 2   Thomas Eakins American, Philadelphia, Pennsylvania 1844–1916 Philadelphia, Pennsylvania   Eakins, Thomas 1408 American 1 1844 1916 ca. 1883 1882 1884 Platinum print  26262 25.5 x 20.4 cm (10 1/16 x 8 1/16 in.), irregular David Hunter McAlpin Fund, 1943                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
179643 2005.100.109 1 1 283222 Photographs 13 Photograph 997 Cape Horn near Celilo           Artist 2   Carleton E. Watkins American, 1829–1916   Watkins, Carleton E. 13489 American 1 1829 1916 1867 1867 1867 Albumen silver print from glass negative 26061 Image: 40 x 52.4cm (15 3/4 x 20 5/8in.) Mount: 54.5 x 68.6 cm (21 7/16 x 27 in.) Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
337911 1990.38.1 1 1 485518 Modern and Contemporary Art 4 Sculpture 100 Antigraceful           Artist 2   Umberto Boccioni Italian, Reggio 1882–1916 Sorte   Boccioni, Umberto 39736 Italian 6 1882 1916 1913, cast 1950 1913 1950 Bronze 23 23 × 21 × 16 1/2 in. (58.4 × 53.3 × 41.9 cm) Weight: 105 lb. (47.6 kg) Bequest of Lydia Winston Malbin, 1989                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
337933 1990.38.3 1 1 485540 Modern and Contemporary Art 4 Sculpture 100 Unique Forms of Continuity in Space           Artist 2   Umberto Boccioni Italian, Reggio 1882–1916 Sorte   Boccioni, Umberto 39736 Italian 6 1882 1916 1913, cast 1950 1913 1913 Bronze 23 47 3/4 x 35 x 15 3/4 in. (121.3 x 88.9 x 40 cm) Bequest of Lydia Winston Malbin, 1989                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
348576 1986.353.2 1 1 503283 Musical Instruments 18 Guitar 15412 Guitar Spanish 13         Maker 1 Workshop of Manuel Ramírez Spanish, Alhama de Aragon, 1864–1916   Ramírez, Manuel 47920 Spanish 76 1864 1916 1912 1901 1925 Spruce, rosewood, cedar, ebony, ivory or bone 54814 Height (Total): 38 in. (96.5 cm) Width (At lower bouts): 10 9/16 in. (26.9 cm) Gift of Emilita Segovia, Marquessa of Salobreña, 1986   Madrid 467     Spain 5             Chordophone-Lute-plucked-fretted 921   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 1100.207ms · Data license: CC0 · Data source: metmuseum/openaccess