MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Portfolio = 2430

View and edit SQL

Suggested facets: Artist Role, Artist Nationality, Artist Begin Date, Artist End Date, Medium

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
383946 22.82.1-21 0 1 633449 Drawings and Prints 11 Print 731 The Visitor (La Visiteuse) (L'Intruse / The Intruder)         L'Estampe originale, Album III 2430 Artist|Publisher 710   Albert Bernard|André Marty French, Paris 1849–1934 Paris|French, born 1857   Bernard, Albert|Marty, André 49382 French|French 21 1849 |1857 1934 |1957 1893 1893 1893 Lithograph 14948 Image: 14 1/8 × 18 1/8 in. (35.9 × 46 cm) Sheet: 16 1/8 × 22 5/8 in. (41 × 57.5 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
383947 22.82.1-22 0 1 633450 Drawings and Prints 11 Print 731 The Mandolin Player (Mandoliniste)         L'Estampe originale, Album III 2430 Artist|Publisher 710   Henri Patrice Dillon|André Marty French, 1851–1909|French, born 1857   Dillon, Henri Patrice|Marty, André 49383 French|French 21 1851 |1857 1909 |1957 1893 1893 1893 Lithograph 14948 Image: 5 3/8 in. × 12 in. (13.7 × 30.5 cm) Sheet: 13 7/16 × 17 11/16 in. (34.2 × 45 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
384026 22.82.1-23 0 1 633530 Drawings and Prints 11 Print 731 Temptation of St. Anthony (Tentation de Saint Antoine)         L'Estampe originale, Album III 2430 Printer|Artist|Publisher 990   Lemercier & Cie.|Henri Fantin-Latour|André Marty French, Paris|French, Grenoble 1836–1904 Buré|French, born 1857   Lemercier & Cie.|Fantin-Latour, Henri|Marty, André 49387 French|French|French 103 1836 |1857 1904 |1957 1893 1893 1893 Lithograph 14948 Image: 12 11/16 × 15 3/4 in. (32.2 × 40 cm) Sheet: 16 1/8 × 22 13/16 in. (40.9 × 58 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
384027 22.82.1-24 0 1 633531 Drawings and Prints 11 Print 731 Laundresses (Blanchisseuses) (How Quickly Youth Fades! / Jeunesse passe vite vertu!)         L'Estampe originale, Album III 2430 Artist|Publisher 710   Auguste-Louis Lepère|André Marty French, Paris 1849–1918 Domme|French, born 1857   Lepère, Auguste-Louis|Marty, André 49388 French|French 21 1849 |1857 1918 |1957 1893 1893 1893 Soft-ground etching and aquatint; printed in three colors 58202 Plate: 15 1/2 × 9 in. (39.4 × 22.9 cm) Sheet: 17 15/16 × 9 7/8 in. (45.5 × 25.1 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
384028 22.82.1-26 0 1 633532 Drawings and Prints 11 Print 731 The Road from Gaud (La Route de Gaud)         L'Estampe originale, Album III 2430 Artist|Publisher 710   Maxime Maufra|André Marty French, Nantes 1861–1918 Poncé|French, born 1857   Maufra, Maxime|Marty, André 49389 French|French 21 1861 |1857 1918 |1957 1893 1893 1893 Lithograph in four colors 58198 Image: 7 7/8 × 11 1/2 in. (20 × 29.2 cm) Sheet: 16 3/8 × 23 1/8 in. (41.6 × 58.7 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
384029 22.82.1-27 0 1 633533 Drawings and Prints 11 Print 731 Birds of prey (Ouiseux de proie)         L'Estampe originale, Album III 2430 Artist|Publisher 710   Victor Emile Prouvé|André Marty French, Nancy 1858–1943 Sétif, Algeria|French, born 1857   Prouvé, Victor Emile|Marty, André 49390 French|French 21 1858 |1857 1943 |1957 1893 1893 1893 Etching in two colors 58203 Plate: 9 7/16 × 16 5/8 in. (24 × 42.2 cm) Sheet: 16 7/8 × 23 5/8 in. (42.9 × 60 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
384031 22.82.1-28 0 1 633535 Drawings and Prints 11 Print 731 The Annunciation (L'Annonciation)         L'Estampe originale, Album III 2430 Artist|Publisher 710   Carlos Schwabe|André Marty German, Altona 1866–1927 Paris, (active Switzerland and France from 1884)|French, born 1857   Schwabe, Carlos|Marty, André 49391 German|French 288 1866 |1857 1927 |1957 1893 1893 1893 Lithograph 14948 Image: 10 in. × 13 3/4 in. (25.4 × 34.9 cm) Sheet: 12 15/16 × 17 11/16 in. (32.9 × 44.9 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
384070 22.82.1-25 0 1 633578 Drawings and Prints 11 Print 731 The Light (L'Illumination)         L'Estampe originale, Album III 2430 Printer|Artist|Publisher 990   A. Lafontaine|Alexandre Lunois|André Marty French, 1863–1916|French, born 1857   Lafontaine, A.|Lunois, Alexandre|Marty, André 49410 French|French|French 103 1863 |1857 1916 |1957 1893 1893 1893 Lithograph in five colors 30863 Image: 13 in. × 10 11/16 in. (33 × 27.1 cm) Sheet: 23 1/2 × 16 15/16 in. (59.7 × 43 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
405446 22.82.1-29 0 1 662149 Drawings and Prints 11 Print 731 The Cow (La Vache)         L'Estampe originale, Album III 2430 Publisher|Artist 740   André Marty|Victor Alfred Paul Vignon French, born 1857|French, Villers-Cotterêts 1847–1909 Meulan   Marty, André|Vignon, Victor Alfred Paul 51281 French|French 21 1857 |1847 1957 |1909 1893 1893 1893 Etching, printed in brown 35103 Image: 9 7/8 × 10 1/2 in. (25.1 × 26.7 cm) Sheet: 16 3/4 × 23 5/8 in. (42.5 × 60 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
405448 22.82.1-30 0 1 662151 Drawings and Prints 11 Print 731 Fortune (La Fortune)         L'Estampe originale, Album III 2430 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 1893 1893 1893 Lithograph 14948 Image: 10 5/8 × 9 7/8 in. (27 × 25.1 cm) Sheet: 23 1/2 × 16 15/16 in. (59.7 × 43 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 129.388ms · Data license: CC0 · Data source: metmuseum/openaccess