MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Portfolio = 1438

View and edit SQL

Suggested facets: Is Public Domain, Artist Nationality, Artist Begin Date, 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
261960 22.82.1-80 0 1 390871 Drawings and Prints 11 Print 731 The Bath (Le Bain)         L'Estampe originale, Album VIII 1438 Artist|Publisher 710   Félix Vallotton|André Marty Swiss, Lausanne 1865–1925 Paris|French, born 1857   Vallotton, Félix|Marty, André 38133 Swiss|French 387 1865 |1857 1925 |1957 1894 1894 1894 Woodcut on cream wove paper 42249 Sheet: 8 1/2 x 10 in. (21.6 x 25.4 cm) Plate: 7 13/16 x 9 5/16 in. (19.9 x 23.6 cm) Image: 7 1/8 x 8 13/16 in. (18.1 x 22.4 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
383206 22.82.1-79 0 1 632515 Drawings and Prints 11 Print 731 Portrait (The Millamant / Bonnet and Powder)         L'Estampe originale, Album VIII 1438 Artist|Publisher 710   William Rothenstein|André Marty British, Bradford, Yorkshire 1872–1945 Far Oakridge, Gloucestershire|French, born 1857   Rothenstein, William|Marty, André 49275 British|French 169 1872 |1857 1945 |1957 October–December 1894 1894 1894 Lithograph on laid Japan paper 58101 Image: 7 9/16 in. × 6 in. (19.2 × 15.2 cm) Sheet: 15 11/16 × 9 1/2 in. (39.8 × 24.1 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
383207 22.82.1-75 0 0 632516 Drawings and Prints 11 Print 731 Under the Arch of the Bridge (Sous l'arche du pont)         L'Estampe originale, Album VIII 1438 Artist|Publisher 710   William Nicholson|André Marty British, Newark-on-Trent 1872–1949 Berkshire|French, born 1857   Nicholson, William|Marty, André 49276 British|French 169 1872 |1857 1949 |1957 October–December 1894 1894 1894 Color lithograph; printed in black with touches of blue 58102 Image: 9 3/8 × 11 1/4 in. (23.8 × 28.6 cm) Sheet: 11 3/8 × 17 3/16 in. (28.9 × 43.7 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
383209 22.82.1-76 0 1 632518 Drawings and Prints 11 Print 731 Evening Harbor Scene with Bridge (Mist on the Thames)         L'Estampe originale, Album VIII 1438 Artist|Publisher 710   Joseph Pennell|André Marty American, Philadelphia, Pennsylvania 1857–1926 New York|French, born 1857   Pennell, Joseph|Marty, André 49278 American|French 26 1857 |1857 1926 |1957 October–December 1894 1894 1894 Etching and aquatint, printed in dark gray ink 58104 Plate: 8 1/4 × 10 7/16 in. (21 × 26.5 cm) Sheet: 10 in. × 11 15/16 in. (25.4 × 30.3 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
384056 22.82.1-73 0 1 633562 Drawings and Prints 11 Print 731 Frogs (Grenouilles)         L'Estampe originale, Album VIII 1438 Artist|Publisher 710   Charles Louis M. Houdard|André Marty French, late 19th century|French, born 1857   Houdard, Charles Louis M.|Marty, André 49406 French|French 21 1850 |1857 1900 |1957 1894 1894 1894 Aquatint in three colors 58210 Plate: 10 1/8 × 15 5/8 in. (25.7 × 39.7 cm) Sheet: 14 9/16 × 18 1/2 in. (37 × 47 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
384058 22.82.1-74 0 1 633564 Drawings and Prints 11 Print 731 Street Pavers (Les Paveurs)         L'Estampe originale, Album VIII 1438 Artist|Publisher 710   Henri-Gabriel Ibels|André Marty French, Paris 1867–1936 Paris|French, born 1857   Ibels, Henri-Gabriel|Marty, André 41168 French|French 21 1867 |1857 1936 |1957 1894 1894 1894 Etching 26137 Plate: 12 × 7 7/8 in. (30.5 × 20 cm) Sheet: 18 7/8 × 13 3/8 in. (48 × 33.9 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
384076 22.82.1-72 0 1 633584 Drawings and Prints 11 Print 731 Cluster of Trees (Bouquet d'arbres)         L'Estampe originale, Album VIII 1438 Artist|Publisher 710   Charles-Marie Dulac|André Marty French, Paris 1865–1898 Paris|French, born 1857   Dulac, Charles-Marie|Marty, André 49379 French|French 21 1865 |1857 1898 |1957 1894 1894 1894 Lithograph 14948 Image: 18 1/2 × 14 1/16 in. (47 × 35.7 cm) Sheet: 23 7/16 × 16 3/4 in. (59.5 × 42.5 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 125.874ms · Data license: CC0 · Data source: metmuseum/openaccess