MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Medium = 43984

View and edit SQL

Suggested facets: Is Public Domain, Department, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Credit Line, Rights and Reproduction

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
294120 24.80.283 0 0 423462 Drawings and Prints 11 Print 731 Portrait of Jacques Necker           Artist|Publisher|Artist|Artist 927 After Augustin de Saint-Aubin|Antoine Louis François Sergent Marceau|Joseph Siffred Duplessis|La Vachez French, Paris 1736–1807 Paris|French, Chartres 1751–1847 Nice|French, Carpentras 1725–1802 Versailles   Saint-Aubin, Augustin de|Sergent Marceau, Antoine Louis François|Duplessis, Joseph Siffred|La Vachez 41990 French|French|French|French 95 1736 |1751 |1725 1807 |1847 |1802 1789 1789 1789 Colored etching 43984 Sheet: 4 15/16 × 3 5/8 in. (12.5 × 9.2 cm) Anonymous Gift, 1924                       Prints 13   Metropolitan Museum of Art, New York, NY 1
339067 1996.272.1 0 0 486713 Modern and Contemporary Art 4 Print 731 Five A.M.           Artist 2   Jennifer Bartlett American, born Long Beach, California, 1941   Bartlett, Jennifer 44990 American  34 1941 2041 1994 1994 1994 Colored etching 43984 Sheet: H. 19-1/4, W. 19-1/2 inches (48.9 x 49.5 cm.) Plate: H. 16-7/8, W. 16-7/8 inches (42.9 x 42.9 cm.) Purchase, Reba and Dave Williams Gift, 1996                       Prints 13 © Jennifer Bartlett Metropolitan Museum of Art, New York, NY 1
339068 1996.272.2 0 0 486714 Modern and Contemporary Art 4 Print 731 Five P.M.           Artist 2   Jennifer Bartlett American, born Long Beach, California, 1941   Bartlett, Jennifer 44990 American  34 1941 2041 1994 1994 1994 Colored etching 43984 Sheet: H. 19-1/2, W. 19-1/2 inches (49.5 x 49.5 cm.) Plate: H. 16-3/4, W. 16-3/4 inches (42.5 x 42.5 cm.) Purchase, Reba and Dave Williams Gift, 1996                       Prints 13 © Jennifer Bartlett Metropolitan Museum of Art, New York, NY 1
339069 1996.272.3 0 0 486715 Modern and Contemporary Art 4 Print 731 Six P.M.           Artist 2   Jennifer Bartlett American, born Long Beach, California, 1941   Bartlett, Jennifer 44990 American  34 1941 2041 1994 1994 1994 Colored etching 43984 Sheet: H. 19-1/4, W. 19-1/2 inches (48.9 x 49.5 cm.) Plate: H. 16-3/4, W. 16-3/4 inches (42.5 x 42.5 cm.) Purchase, Reba and Dave Williams Gift, 1996                       Prints 13 © Jennifer Bartlett Metropolitan Museum of Art, New York, NY 1
339114 1996.405 0 1 486761 Modern and Contemporary Art 4 Print 731 Viola Nadelman as a Bride           Artist 2   Paul-César Helleu French, Vannes 1859–1927 Paris   Helleu, Paul-César 18697 French 2 1859 1927 1920 1920 1920 Colored etching 43984 Plate: H. 22-1/4, W. 13-3/4 inches (56.5 x 34.9 cm.) Sheet: H. 23-1/2, W. 15 inches (sight) (59.7 x 38.1 cm.) Bequest of Lincoln Kirstein, 1996                       Prints 13   Metropolitan Museum of Art, New York, NY 1
343194 2001.311 0 0 491973 Modern and Contemporary Art 4 Print 731 Under a Blood Red Sky           Artist 2   Faith Ringgold American, born New York, 1930   Ringgold, Faith 46013 American 1 1930 2030 2001 2001 2001 Colored etching 43984 sheet: 17 x 13 in. (43.2 x 33.0 cm) plate: 11 7/8 x 9 in. (30.2 x 22.9 cm) Gift of Jeffrey Bergen, 2001                       Prints 13 © 2018 Artists Rights Society (ARS), New York 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 154.483ms · Data license: CC0 · Data source: metmuseum/openaccess