MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Artist Alpha Sort = 45665

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Object Begin Date, Object End Date, Medium

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
336894 336894 1986.252.10 0 0 484441 Modern and Contemporary Art 4 Drawing 23 Ward           Artist 2   Bernard Sanders American, New York 1906–1967 New York   Sanders, Bernard 45665 American 1 1906 1967   1906 1967 Ink on paper 760 H. 9-3/4, W. 12-3/8 inches (24.8 x 31.4 cm.) Gift of Mrs. Bernard Sanders, 1986                       Drawings 9   http://www.metmuseum.org/art/collection/search/484441 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
336895 336895 1986.252.11 0 0 484442 Modern and Contemporary Art 4 Drawing 23 Untitled           Artist 2   Bernard Sanders American, New York 1906–1967 New York   Sanders, Bernard 45665 American 1 1906 1967   1906 1967 Ink on paper 760 H. 8-7/8, W. 11-1/2 inches (22.5 x 29.2 cm.) Gift of Mrs. Bernard Sanders, 1986                       Drawings 9   http://www.metmuseum.org/art/collection/search/484442 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
336896 336896 1986.252.1a-o 0 0 484443 Modern and Contemporary Art 4 Drawing 23 Sketchbook           Artist 2   Bernard Sanders American, New York 1906–1967 New York   Sanders, Bernard 45665 American 1 1906 1967   1906 1967 Ink, wash, watercolor, and graphite on paper 51635 H. 9, W. 12 inches (22.9 x 30.5 cm.) Gift of Mrs. Bernard Sanders, 1986                       Drawings 9   http://www.metmuseum.org/art/collection/search/484443 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
336897 336897 1986.252.2 0 0 484444 Modern and Contemporary Art 4 Drawing 23 Sedative Baths on the Violent Ward           Artist 2   Bernard Sanders American, New York 1906–1967 New York   Sanders, Bernard 45665 American 1 1906 1967   1906 1967 Ink on paper 760 H. 25, W. 19 inches (83.5 x 48.3 cm.) Gift of Mrs. Bernard Sanders, 1986                       Drawings 9   http://www.metmuseum.org/art/collection/search/484444 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
336898 336898 1986.252.3 0 0 484445 Modern and Contemporary Art 4 Drawing 23 Train Bridge           Artist 2   Bernard Sanders American, New York 1906–1967 New York   Sanders, Bernard 45665 American 1 1906 1967 1939 1939 1939 Ink and wash on paper 14561 H. 25, W. 19-1/4 inches (83.5 x 48.9 cm.) Gift of Mrs. Bernard Sanders, 1986                       Drawings 9   http://www.metmuseum.org/art/collection/search/484445 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
336899 336899 1986.252.4 0 0 484446 Modern and Contemporary Art 4 Drawing 23 Man under a Bed           Artist 2   Bernard Sanders American, New York 1906–1967 New York   Sanders, Bernard 45665 American 1 1906 1967   1906 1967 Ink on paper 760 H. 15, W. 5 inches (38.1 x 12.7 cm.) Gift of Mrs. Bernard Sanders, 1986                       Drawings 9   http://www.metmuseum.org/art/collection/search/484446 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
336900 336900 1986.252.5 0 0 484447 Modern and Contemporary Art 4 Drawing 23 Ward           Artist 2   Bernard Sanders American, New York 1906–1967 New York   Sanders, Bernard 45665 American 1 1906 1967   1906 1967 Ink on paper 760 H. 12-7/8, W. 5 inches (32.7 x 12.7 cm.) Gift of Mrs. Bernard Sanders, 1986                       Drawings 9   http://www.metmuseum.org/art/collection/search/484447 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
336901 336901 1986.252.6 0 0 484448 Modern and Contemporary Art 4 Drawing 23 Morgue           Artist 2   Bernard Sanders American, New York 1906–1967 New York   Sanders, Bernard 45665 American 1 1906 1967   1906 1967 Ink on paper 760 H. 14-3/8, W. 5 inches (36.5 x 12.7 cm.) Gift of Mrs. Bernard Sanders, 1986                       Drawings 9   http://www.metmuseum.org/art/collection/search/484448 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
336902 336902 1986.252.7 0 0 484449 Modern and Contemporary Art 4 Drawing 23 Woman Hung on a Bed           Artist 2   Bernard Sanders American, New York 1906–1967 New York   Sanders, Bernard 45665 American 1 1906 1967   1906 1967 Ink on paper 760 H. 11-1/2, W. 9-1/8 inches (29.2 x 23.2 cm.) Gift of Mrs. Bernard Sanders, 1986                       Drawings 9   http://www.metmuseum.org/art/collection/search/484449 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
336903 336903 1986.252.8 0 0 484450 Modern and Contemporary Art 4 Drawing 23 Standing Man           Artist 2   Bernard Sanders American, New York 1906–1967 New York   Sanders, Bernard 45665 American 1 1906 1967   1906 1967 Ink on paper 760 H. 12-1/8, W. 10-1/4 inches (30.8 x 26 cm.) Gift of Mrs. Bernard Sanders, 1986                       Drawings 9   http://www.metmuseum.org/art/collection/search/484450 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
336904 336904 1986.252.9 0 0 484451 Modern and Contemporary Art 4 Drawing 23 Soldier           Artist 2   Bernard Sanders American, New York 1906–1967 New York   Sanders, Bernard 45665 American 1 1906 1967   1906 1967 Ink and wash on paper 14561 H. 9-1/8, W. 8-1/2 inches (3.2 x 21.6 cm.) Gift of Mrs. Bernard Sanders, 1986                       Drawings 9   http://www.metmuseum.org/art/collection/search/484451 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 128.786ms · Data license: CC0 · Data source: metmuseum/openaccess