MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

4 rows where Portfolio = 116

View and edit SQL

Suggested facets: Is Public Domain, Artist Role, Artist Display Name, Artist Alpha Sort, Medium, Credit Line

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
208686 1995.228.1 0 1 336058 Drawings and Prints 11 Print 731 Qui aime Bertrand aime son chien (He who loves Bertrand loves his dog), from Proverbes et Maximes, published in Le Charivari, July 22, 1840         Proverbes et Maximes 116 Artist|Publisher|Printer 1061   Honoré Daumier|Bauger et Cie|Aubert et Cie French, Marseilles 1808–1879 Valmondois|Paris   Daumier, Honoré|Bauger et Cie|Aubert et Cie 18321 French|French|French 103 1808 |1829 1879 |1929 July 22, 1840 1840 1840 Lithograph; third state of three (Delteil) 30272 Sheet: 13 3/8 × 10 1/4 in. (34 × 26 cm) Image: 9 1/4 × 7 3/8 in. (23.5 × 18.8 cm) Gift of Mrs. Howard W. Geiger in Memory of Howard W. Geiger                       Prints 13   Metropolitan Museum of Art, New York, NY 1
389169 36.12.145 0 0 639767 Drawings and Prints 11 Print 731 La patience est la vertu des ânes, from Proverbes et Maximes, published in Le charivari, July 1840         Proverbes et Maximes 116 Artist|Printer|Publisher 849   Honoré Daumier|Aubert et Cie|Bauger et Cie French, Marseilles 1808–1879 Valmondois|Paris   Daumier, Honoré|Aubert et Cie|Bauger et Cie 18563 French|French|French 103 1808 |1829 1879 |1929 July, 1840 1840 1840 Lithograph; third state of three (Delteil) 30272 Sheet: 13 3/4 × 9 3/4 in. (35 × 24.8 cm) Sheet: 9 1/8 × 7 3/8 in. (23.2 × 18.8 cm) Harris Brisbane Dick Fund, 1936                       Prints 13   Metropolitan Museum of Art, New York, NY 1
389275 57.650.592 0 0 639879 Drawings and Prints 11 Print 731 Une homme sans asile est comme un soieau sans nid, from Proverbes et Maximes, published in Le Charivari, July 17, 1840         Proverbes et Maximes 116 Artist|Printer|Publisher 849   Honoré Daumier|Aubert et Cie|Bauger et Cie French, Marseilles 1808–1879 Valmondois|Paris   Daumier, Honoré|Aubert et Cie|Bauger et Cie 18563 French|French|French 103 1808 |1829 1879 |1929 July 17, 1840 1840 1840 Lithograph; second state of three (Delteil) 35928 Sheet: 13 5/16 × 9 13/16 in. (33.8 × 25 cm) Image: 9 1/4 × 7 1/16 in. (23.5 × 18 cm) Bequest of Edwin De T. Bechtel, 1957                       Prints 13   Metropolitan Museum of Art, New York, NY 1
389298 57.650.593 0 0 639907 Drawings and Prints 11 Print 731 Bien venu qui apporte, from Proverbes et Maximes, published in Le Charivari, July 12, 1840         Proverbes et Maximes 116 Artist|Printer|Publisher 849   Honoré Daumier|Aubert et Cie|Bauger et Cie French, Marseilles 1808–1879 Valmondois|Paris   Daumier, Honoré|Aubert et Cie|Bauger et Cie 18563 French|French|French 103 1808 |1829 1879 |1929 July 12, 1840 1840 1840 Lithograph; third state of three (Delteil) 30272 Sheet: 13 5/16 × 9 13/16 in. (33.8 × 25 cm) Image: 9 5/16 × 7 9/16 in. (23.6 × 19.2 cm) Bequest of Edwin De T. Bechtel, 1957                       Prints 13   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 146.706ms · Data license: CC0 · Data source: metmuseum/openaccess