MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Portfolio = 380

View and edit SQL

Suggested facets: Is Public Domain, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Begin Date, Object End Date, 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
228342 1978.656.15 0 0 355976 Drawings and Prints 11 Print 731 Un voyage d'agrément de Paris à Orleans, Les Chemins de Fer, published in Le Charivari, July 7, 1843         Les Chemins de Fer 380 Artist|Publisher|Printer 1061   Honoré Daumier|Pannier et Cie.|Aubert et Cie French, Marseilles 1808–1879 Valmondois|Paris   Daumier, Honoré|Pannier et Cie.|Aubert et Cie 18320 French|French|French 103 1808 |1800 |1829 1879 |1900 |1929 July 7, 1843 1843 1843 lithograph 29295 Sheet: 9 3/16 × 11 7/16 in. (23.4 × 29 cm) Gift of Weston J. Naef in honor of Kathleen W. Naef, 1978                       Prints 13   Metropolitan Museum of Art, New York, NY 1
254852 1989.1070 0 0 383479 Drawings and Prints 11 Print 731 Impressions et Compressions de Voyage, from Les Chemins de Fer, published in Le Charivari, July 25, 1843         Les Chemins de Fer 380 Artist|Publisher|Printer 1061   Honoré Daumier|Pannier et Cie.|Aubert et Cie French, Marseilles 1808–1879 Valmondois|Paris   Daumier, Honoré|Pannier et Cie.|Aubert et Cie 18320 French|French|French 103 1808 |1800 |1829 1879 |1900 |1929 July 25, 1843 1843 1843 Lithograph; second state of three (Delteil) 35928 Sheet: 10 1/8 × 13 3/8 in. (25.7 × 34 cm) Image: 7 3/4 × 10 3/8 in. (19.7 × 26.4 cm) A. Hyatt Mayor Purchase Fund, Marjorie Phelps Starr Bequest, 1989                       Prints 13   Metropolitan Museum of Art, New York, NY 1
389935 1986.1180.940 0 0 640723 Drawings and Prints 11 Print 731 Allons donc...que diable cocher..., from Les Chemins de Fer, publilshed in Le Charivari, June 9, 1843         Les Chemins de Fer 380 Printer|Publisher 68   Honoré Daumier|Aubert et Cie French, Marseilles 1808–1879 Valmondois   Daumier, Honoré|Aubert et Cie 21002 French|French 21 1808 |1829 1879 |1929 June 9, 1843 1843 1843 Lithograph; third state of three (Delteil) 30272 Sheet: 9 1/2 × 12 1/16 in. (24.2 × 30.7 cm) Image: 7 13/16 × 10 3/16 in. (19.9 × 25.9 cm) Bequest of Grace M. Pugh, 1985                       Prints 13   Metropolitan Museum of Art, New York, NY 1
389983 57.660.2 0 0 640780 Drawings and Prints 11 Print 731 Le Danger de s'Assoupier en Voyage, from Les Chemins de Fer         Les Chemins de Fer 380 Artist 2   Honoré Daumier French, Marseilles 1808–1879 Valmondois   Daumier, Honoré 12265 French 2 1808 1879 1843 1843 1843 Lithograph; first state of four (Delteil) 58351 Sheet: 10 7/16 × 14 3/16 in. (26.5 × 36 cm) Image: 7 7/16 × 9 15/16 in. (18.9 × 25.2 cm) Gift of Herbert E. Hirschland, 1957                       Prints 13   Metropolitan Museum of Art, New York, NY 1
391134 57.660.1 0 0 642820 Drawings and Prints 11 Print 731 Un monsieur qui veut se donner la satisfaction..., from Les Beaux Jours de la Vie         Les Chemins de Fer 380 Artist 2   Honoré Daumier French, Marseilles 1808–1879 Valmondois   Daumier, Honoré 12265 French 2 1808 1879 1846 1846 1846 Lithograph; first state of two (Delteil) 30948 Sheet: 13 9/16 × 10 5/16 in. (34.5 × 26.2 cm) Gift of Herbert E. Hirschland, 1957                       Prints 13   Metropolitan Museum of Art, New York, NY 1
391976 1986.1180.937 0 0 644062 Drawings and Prints 11 Print 731 Rentrée nocturne de l'Électeur de Hesse..., from Actualités, published in Le Charivari, December 28, 1850         Les Chemins de Fer 380 Printer|Publisher 68   Honoré Daumier|Aubert et Cie French, Marseilles 1808–1879 Valmondois   Daumier, Honoré|Aubert et Cie 21002 French|French 21 1808 |1829 1879 |1929 December 28, 1850 1850 1850 Lithograph; second state of two (Delteil) 30728 Sheet: 9 13/16 × 14 7/16 in. (25 × 36.6 cm) Image: 8 1/16 × 10 1/16 in. (20.4 × 25.5 cm) Bequest of Grace M. Pugh, 1985                       Prints 13   Metropolitan Museum of Art, New York, NY 1
392378 1986.1180.955 0 0 644546 Drawings and Prints 11 Print 731 Une victime de la politesse, from Croquis Musicaux, published in Le Charivari, February 26, 1852         Les Chemins de Fer 380 Artist|Printer|Publisher 849   Honoré Daumier|Pannier et Cie.|Charles Trinocq French, Marseilles 1808–1879 Valmondois|Paris|Paris   Daumier, Honoré|Pannier et Cie.|Trinocq, Charles 18566 French|French|French 103 1808 |1800 |1800 1879 |1900 |1900 February 26, 1852 1852 1852 Lithograph; second state of two (Delteil) 30728 Sheet: 14 5/16 × 9 3/4 in. (36.4 × 24.8 cm) Image: 9 15/16 × 8 9/16 in. (25.2 × 21.7 cm) Bequest of Grace M. Pugh, 1985                       Prints 13   Metropolitan Museum of Art, New York, NY 1
411562 22.61.333 0 1 678710 Drawings and Prints 11 Print 731 Il me semble que nous allons dérailler..., from Les Chemins de Fer, published in Le Charivari, December 19, 1857         Les Chemins de Fer 380 Publisher|Artist|Printer 1318   Aaron Martinet|Honoré Daumier|Destouches French, 1762–1841|French, Marseilles 1808–1879 Valmondois|Paris   Martinet, Aaron|Daumier, Honoré|Destouches 28894 French|French|French 103 1762 |1808 |1800 1841 |1879 |1900 December 19, 1857 1857 1857 Lithograph on newsprint; second state of two (Delteil) 29466 Sheet: 9 15/16 × 12 9/16 in. (25.3 × 31.9 cm) Image: 7 13/16 × 9 1/2 in. (19.9 × 24.1 cm) Rogers Fund, 1922                       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 115.553ms · Data license: CC0 · Data source: metmuseum/openaccess