MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Portfolio = 370

View and edit SQL

Suggested facets: Artist Role, Artist Display Name, Artist Alpha Sort, Object Begin Date, Object End Date, Medium, Dimensions, 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
228203 63.527.13 0 0 355834 Drawings and Prints 11 Print 731 Dire que ça se dandine avec un petit air qu on..., from Mœurs Conjugales, published in Le Charivari, October 27, 1839         Moeurs Conjugales 370 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 October 27, 1839 1839 1839 Lithograph; second state of two (Delteil) 30728 Sheet: 12 5/16 × 8 7/16 in. (31.2 × 21.5 cm) Gift of Miss Frederick S. Hoppin, 1963                       Prints 13   Metropolitan Museum of Art, New York, NY 1
228212 63.713.4 0 0 355844 Drawings and Prints 11 Print 731 Ça n'empêche que ça vaut encore mieux..., from Mœurs Conjugale,s published in Le Charivari, March 5, 1842         Moeurs Conjugales 370 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 March 5, 1842 1842 1842 Lithograph; third state of three (Delteil) 30272 Sheet: 11 3/4 × 9 5/16 in. (29.8 × 23.6 cm) Gift of Mrs. Louis Cons, 1963                       Prints 13   Metropolitan Museum of Art, New York, NY 1
389168 63.527.16 0 0 639766 Drawings and Prints 11 Print 731 Petit scélérat! je crois qu'il aura mon nez!..., from Mœurs Conjugales, published in Le Charivari, March 1, 1840         Moeurs Conjugales 370 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 March 1, 1840 1840 1840 Lithograph; second state of two (Delteil) 30728 Sheet: 12 5/16 × 8 7/16 in. (31.2 × 21.5 cm) Gift of Miss Frederick S. Hoppin, 1963                       Prints 13   Metropolitan Museum of Art, New York, NY 1
389638 57.650.470 0 0 640311 Drawings and Prints 11 Print 731 Et on appelle ça descendre le fleuve de la vie..., from Mœurs Conjugales, published in Le Charivari, June 28, 1842         Moeurs Conjugales 370 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 June 28, 1842 1842 1842 Lithograph; third state of four (Delteil) 30271 Sheet: 13 in. × 9 15/16 in. (33 × 25.2 cm) Bequest of Edwin De T. Bechtel, 1957                       Prints 13   Metropolitan Museum of Art, New York, NY 1
389650 50.587.19 0 0 640324 Drawings and Prints 11 Print 731 L'Oeil du Maître, from Mœurs Conjugales, published in Le Charivari, September 16, 1842         Moeurs Conjugales 370 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 September 16, 1842 1842 1842 Lithograph; third state of three (Delteil) 30272 Sheet: 14 in. × 9 13/16 in. (35.5 × 25 cm) Gift of Albert Ten Eyck Gardner, 1950                       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 145.881ms · Data license: CC0 · Data source: metmuseum/openaccess