MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where Artist Alpha Sort = 19511

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

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 Metadata Date Repository
212275 212275 21.71.4 0 0 339668 Drawings and Prints 11 Drawing 23 Squadron of Lancers           Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860 19th century 1820 1860 Oil paint and gouache on paper 32059 7 3/4 x 13 in. (19.7 x 33.0 cm) Rogers Fund, 1921                       Drawings 9   http://www.metmuseum.org/art/collection/search/339668 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
212276 212276 22.155 0 1 339669 Drawings and Prints 11 Drawing 23 Prise de Constantine           Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860 19th century 1820 1860 Pen and ink and watercolor 29423 5 7/8 x 11 in. (14.9 x 27.9 cm) Rogers Fund, 1922                       Drawings 9   http://www.metmuseum.org/art/collection/search/339669 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
212277 212277 1993.1130.2 0 1 339670 Drawings and Prints 11 Drawing 23 Uniforms of the civil guard in Courtray, Belgium           Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860 1832 1832 1832 Black chalk and watercolor 29355 11 1/4 x 8 5/16 in. Gift of Alexander B.V. Johnson and Roberta J.M. Olson, 1993                       Drawings 9   http://www.metmuseum.org/art/collection/search/339670 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
251975 251975 2007.303 0 0 380468 Drawings and Prints 11 Print 731 A Turk, study for one of the figures in Voyage dans la Russie Mèridionale et la Crimée...Paris, 1848           Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860 1848 1848 1848 Lithograph on wove paper; one of five known impressions 40332 sheet: 21 7/16 x 6 7/8 in. (54.5 x 17.5 cm) Janet Lee Kadesky Ruttenberg Fund, in honor of Colta Ives, 2007                       Prints 13   http://www.metmuseum.org/art/collection/search/380468 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
265914 265914 18.63.13 0 0 394882 Drawings and Prints 11 Print 731 Revue. Après la prise de Constantine. (Octobre, 1837.), plate 12           Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860 1838 1838 1838 Lithograph with chine collé 42561 image: 6 11/16 x 10 13/16 in. (17 x 27.5 cm) plate: 14 1/4 x 21 5/8 in. (36.2 x 55 cm) Rogers Fund, 1918                       Prints 13   http://www.metmuseum.org/art/collection/search/394882 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
398233 398233 63.625.151 0 0 652288 Drawings and Prints 11 Print 731 An Écorché         Reports sur Pierre, 1857 2574 Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860 1857 1857 1857 Lithograph on chine 58813 Sheet: 19 5/16 × 12 3/16 in. (49 × 31 cm) Image: 13 7/8 × 8 3/4 in. (35.3 × 22.3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1963                       Prints 13   http://www.metmuseum.org/art/collection/search/652288 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
398235 398235 63.625.208 0 0 652290 Drawings and Prints 11 Print 731 Various Sketches           Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860   1824 1860 Etching on chine collé 34071 Sheet: 7 3/8 in. × 11 in. (18.8 × 28 cm) Plate: 2 × 4 15/16 in. (5.1 × 12.6 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1963                       Prints 13   http://www.metmuseum.org/art/collection/search/652290 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
398241 398241 63.625.152 0 0 652297 Drawings and Prints 11 Print 731 Study of a Horse         Reports sur Pierre, 1859 2578 Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860 1859 1859 1859 Lithograph on chine 58813 Sheet: 12 3/16 × 18 7/8 in. (30.9 × 48 cm) Image: 8 11/16 × 10 13/16 in. (22 × 27.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1963                       Prints 13   http://www.metmuseum.org/art/collection/search/652297 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
399445 399445 63.625.146 0 0 653894 Drawings and Prints 11 Print 731 Cardinal Antonelli           Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860 1859 1859 1859 Lithograph on chine collé 31088 Sheet: 19 in. × 12 1/2 in. (48.2 × 31.8 cm) Image: 11 1/4 × 8 3/8 in. (28.5 × 21.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1963                       Prints 13   http://www.metmuseum.org/art/collection/search/653894 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
399448 399448 63.625.145 0 0 653897 Drawings and Prints 11 Print 731 Monsieur Scellier           Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860   1824 1860 Lithograph on chine collé 31088 Sheet: 13 3/4 × 11 7/16 in. (35 × 29 cm) Image: 11 3/8 × 9 13/16 in. (28.9 × 25 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1963                       Prints 13   http://www.metmuseum.org/art/collection/search/653897 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
399450 399450 63.625.141 0 0 653899 Drawings and Prints 11 Print 731 Call Me, I Will Return         Vignettes pour Romances 2592 Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860 1831 1831 1831   Sheet: 13 1/16 × 9 3/16 in. (33.2 × 23.4 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1963                       Prints 13   http://www.metmuseum.org/art/collection/search/653899 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
399468 399468 59.596.42 0 0 653917 Drawings and Prints 11 Print 731 The Cardinal Antonelli           Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860 1859 1859 1859 Lithograph on chine collé 31088 Sheet: 15 13/16 × 12 11/16 in. (40.1 × 32.2 cm) Image: 11 3/16 × 8 1/4 in. (28.4 × 21 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   http://www.metmuseum.org/art/collection/search/653917 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
399511 399511 58.580.4 0 0 653960 Drawings and Prints 11 Print 731 Charge of the Cavalry         L’Album Cosmopolite 2601 Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860   1824 1860 Lithograph on wove paper 29142 Sheet: 10 7/8 × 12 1/4 in. (27.7 × 31.1 cm) Gift of Louise Bechtel, 1958                       Prints 13   http://www.metmuseum.org/art/collection/search/653960 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
399963 399963 17.4.2 0 0 654523 Drawings and Prints 11 Print 731 Taking Fort Mulgrave—said the little Gibraltar—Siege of Toulon, December 19, 1793         Album de 1834, no. 1 2621 Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860 1834 1834 1834 Lithograph on wove paper 29142 Sheet: 11 3/8 × 15 13/16 in. (28.9 × 40.2 cm) Gift of Paul J. Sachs, 1917                       Prints 13   http://www.metmuseum.org/art/collection/search/654523 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
403725 403725 22.63.21 0 0 659775 Drawings and Prints 11 Print 731 Napoleon in Egypt. Poster for the Poems of Barthélemy and Méry/           Artist 2   Auguste Raffet French, Paris 1804–1860 Gênes   Raffet, Auguste 19511 French 2 1804 1860 1835 1835 1835 Lithograph on wove paper 29142 Image: 12 × 12 in. (30.5 × 30.5 cm) Sheet: 13 11/16 × 14 1/16 in. (34.8 × 35.7 cm) Rogers Fund, 1922                       Prints 13   http://www.metmuseum.org/art/collection/search/659775 4/23/2018 8:00:01 AM 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 146.207ms · Data license: CC0 · Data source: metmuseum/openaccess