MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Portfolio = 10

View and edit SQL

Suggested facets: Is Public Domain, Artist Role, Artist Nationality, Object 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
206503 22.82.1-59 0 1 333847 Drawings and Prints 11 Print 731 At Les Ambassadeurs (Au Café-Concert / At the Café Concert)         L'Estampe originale, Album VI 10 Printer|Artist|Publisher 990   Edward Ancourt|Henri de Toulouse-Lautrec|André Marty French, 19th century|French, Albi 1864–1901 Saint-André-du-Bois|French, born 1857   Ancourt, Edward|Toulouse-Lautrec, Henri de|Marty, André 17333 French|French|French 103 1800 |1864 |1857 1899 |1901 |1957 1894 1894 1894 Crayon, brush and spatter lithograph printed in six colors on wove paper; only state 28979 Image: 4 7/16 × 3 13/16 in. (11.3 × 9.8 cm) Sheet: 23 1/4 in. × 17 in. (59.1 × 43.2 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
210445 22.82.1-53 0 1 337828 Drawings and Prints 11 Print 731 Spirit of the Dead Watching (Manao Tupapau)         L'Estampe originale, Album VI 10 Artist|Publisher 710   Paul Gauguin|André Marty French, Paris 1848–1903 Atuona, Hiva Oa, Marquesas Islands|French, born 1857   Gauguin, Paul|Marty, André 18851 French|French 21 1848 |1857 1903 |1957 April–June 1894 1894 1894 Zincograph on wove paper 31216 image: 7 3/16 x 10 11/16 in. (18.3 x 27.2 cm) sheet: 13 1/2 x 18 13/16 in. (34.3 x 47.8 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
270799 22.82.1-55 0 1 399929 Drawings and Prints 11 Print 731 Return from Fishing, Honfleur (Retour de Peche, Honfleur) (Bateaux dans le brouillard / Boats in a Fog)         L'Estampe originale, Album VI 10 Artist|Publisher 710   Henri-Charles Guérard|André Marty French, Paris 1846–1897 Paris|French, born 1857   Guérard, Henri-Charles|Marty, André 40245 French|French 21 1846 |1857 1897 |1957 1894 1894 1894 Roulette and lavis; first state of two 43188 Plate: 5 3/4 in. × 8 in. (14.6 × 20.3 cm) Sheet: 13 3/8 × 13 1/16 in. (33.9 × 33.1 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
321869 22.82.1-58 0 1 459993 Drawings and Prints 11 Print 731 Woman Combing Her Hair (Femme se coiffant)         L'Estampe originale, Album VI 10 Artist|Publisher 710   Maximilien Luce|André Marty French, Paris 1858–1941 Paris|French, born 1857   Luce, Maximilien|Marty, André 44515 French|French 21 1858 |1857 1941 |1957 1894 1894 1894 Transfer lithograph on chine collé 48156 Image: 17 in. × 12 1/4 in. (43.2 × 31.1 cm) Sheet: 23 5/8 × 16 7/8 in. (60 × 42.9 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
384046 22.82.1-52 0 1 633552 Drawings and Prints 11 Print 731 The Source of Evil (La Source du Mal) (Evil Spring / Deadly Woman)         L'Estampe originale, Album VI 10 Artist|Publisher 710   Georges de Feure|André Marty French, Paris 1868–1943 Paris|French, born 1857   Feure, Georges de|Marty, André 49398 French|French 21 1868 |1857 1943 |1957 1894 1894 1894 Lithograph in five colors 30863 Image: 13 5/8 × 9 7/8 in. (34.6 × 25.1 cm) Sheet: 18 1/2 × 13 1/4 in. (47 × 33.7 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
384048 22.82.1-54 0 1 633554 Drawings and Prints 11 Print 731 Vitrioleuse         L'Estampe originale, Album VI 10 Printer|Artist|Publisher 990   Auguste Delâtre|Eugène-Samuel Grasset|André Marty French, Paris 1822–1907 Paris|French, born Switzerland, Lausanne 1841–1917 Paris|French, born 1857   Delâtre, Auguste|Grasset, Eugène-Samuel|Marty, André 49400 French|French|French 103 1822 |1841 |1857 1907 |1917 |1957 1894 1894 1894 Lithograph, hand-stenciled in 5 colors 58208 Image: 15 1/2 × 10 13/16 in. (39.3 × 27.4 cm) Sheet: 20 5/8 × 15 1/4 in. (52.4 × 38.7 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
384065 22.82.1-51 0 1 633572 Drawings and Prints 11 Print 731 Portrait of Huysmans         L'Estampe originale, Album VI 10 Artist|Publisher 710   Eugène Delâtre|André Marty French, Paris 1864–1938 Paris|French, born 1857   Delâtre, Eugène|Marty, André 49408 French|French 21 1864 |1857 1938 |1957 1894 1894 1894 Etching and aquatint in three colors 58211 Plate: 12 5/8 × 9 7/16 in. (32 × 23.9 cm) Sheet: 19 in. × 13 11/16 in. (48.2 × 34.8 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
405428 22.82.1-60 0 1 662126 Drawings and Prints 11 Print 731 Hanging Pierrot (Pierrot pendu)         L'Estampe originale, Album VI 10 Publisher|Artist 740   André Marty|Adolphe-Léon Willette French, born 1857|French, Châlons-sur-Marne 1857–1926 Paris   Marty, André|Willette, Adolphe-Léon 51266 French|French 21 1857 |1857 1957 |1926 1894 1894 1894 Lithograph 14948 Sheet: 18 5/16 × 11 7/16 in. (46.5 × 29.1 cm) Image: 10 7/8 × 7 5/16 in. (27.6 × 18.6 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
405430 22.82.1-57 0 0 662128 Drawings and Prints 11 Print 731 The Wave (La Vague)         L'Estampe originale, Album VI 10 Publisher|Artist 740   André Marty|Henri Gustave Jossot French, born 1857|French, Dijon 1866–1951 Sidi Bou Said   Marty, André|Jossot, Henri Gustave 51267 French|French 21 1857 |1866 1957 |1951 1894 1894 1894 Lithograph printed in olive green on laid paper 59164 Sheet: 24 in. × 16 7/8 in. (61 × 42.9 cm) Image: 20 11/16 × 13 13/16 in. (52.5 × 35.1 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
405433 22.82.1-56 0 1 662133 Drawings and Prints 11 Print 731 Milliners (Modistes)         L'Estampe originale, Album VI 10 Publisher|Artist 740   André Marty|René-Georges Hermann-Paul French, born 1857|French, Paris 1874–1940 Saintes-Maries-de-la-Mer   Marty, André|Hermann-Paul, René-Georges 51270 French|French 21 1857 |1874 1957 |1940 1894 1894 1894 Lithograph in three colors 38543 Sheet: 17 in. × 23 13/16 in. (43.2 × 60.5 cm) Image: 9 3/4 × 13 15/16 in. (24.8 × 35.4 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 145.404ms · Data license: CC0 · Data source: metmuseum/openaccess