MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

4 rows where Object Name = 97 and Rights and Reproduction = "© 2018 Succession H. Matisse / Artists Rights Society (ARS), New York"

View and edit SQL

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

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
224718 1984.1038.2(1–6) 0 0 352312 Drawings and Prints 11 Book 97 Ulysses           Author|Artist|Publisher 1302 Written by James Joyce|Henri Matisse|G. Macy Irish, Dublin 1882–1941 Zurich|French, Le Cateau-Cambrésis 1869–1954 Nice|New York, NY   Joyce, James|Matisse, Henri|Macy, G. 26464 Irish|French|American 1854 1882 |1869 |1900 1941 |1954 |1999 1935 1935 1935 Soft ground etching 33730 Sheet: 16 1/4 x 12 3/8 in. (41.3 x 31.4 cm) Gift of David A. Prager, in memory of Henry G. Schiff, 1984                       Books 442 © 2018 Succession H. Matisse / Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
224719 62.644.1 0 0 352313 Drawings and Prints 11 Book 97 Ulysses           Author|Artist|Author|Publisher 2826 Written by|Introduction written by|Published by James Joyce|Henri Matisse|Stuart Gilbert|The Limited Editions Club Irish, Dublin 1882–1941 Zurich|French, Le Cateau-Cambrésis 1869–1954 Nice|British, Chipping Onger 1883–1969 Paris New York Joyce, James|Matisse, Henri|Gilbert, Stuart|Limited Editions Club The 26465 Irish|French|British 1855 1882 |1869 |1883-10-25 1941 |1954 |1969-01-05 1935 1935 1935   Overall: 11 13/16 x 9 3/8 x 1 5/16 in. (30 x 23.8 x 3.3 cm) Gift of Charles K. Wilkinson, 1962                       Books 442 © 2018 Succession H. Matisse / Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
226163 1982.1030.1–.2 0 0 353769 Drawings and Prints 11 Book 97 Gravures originales sur le thème de Pasiphaé Pour le texte de H. de Montherlant           Designer|Author|Publisher|Author|Printer 3040 Introduction by Henri Matisse|Henry de Montherlant|Les héritiers de l'artiste|Dominque Bozo|Fequet et Baudier (Marthe Fequet et Pierre Baudier) French, Le Cateau-Cambrésis 1869–1954 Nice|French, 1896–1972|Paris|French, 20th century|French   Matisse, Henri|Montherlant, Henry de|Héritiers, de l'artiste Les|Bozo, Dominque|Fequet et Baudier (Marthe Fequet et Pierre Baudier) 27478 French|French|French|French|French 106 1869 |1896 |1880 1954 |1972 |1950 1981 1981 1981 Linoleum cut 35094 sheet: 12 13/16 x 9 13/16 in. (32.5 x 25 cm) Gift of Les Héritiers d'Henri Matisse, 1982                       Books 442 © 2018 Succession H. Matisse / Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
226164 1983.1009(1–22) 0 0 353770 Drawings and Prints 11 Book 97 Jazz           Artist|Publisher 710 Published by Henri Matisse|Tériade French, Le Cateau-Cambrésis 1869–1954 Nice , Paris Matisse, Henri|Tériade 27479 French|French 21 1869 1954 1947 1947 1947 Pochoir 30782 Height: 16 5/8 in. (42.2 cm) Width: 25 5/8 in. (65.1 cm) Gift of Lila Acheson Wallace, 1983                       Books 442 © 2018 Succession H. Matisse / 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 3514.533ms · Data license: CC0 · Data source: metmuseum/openaccess