MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Nationality = 3020

View and edit SQL

Suggested facets: Object Name, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, 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 Repository
261891 53.600.1021 0 0 390798 Drawings and Prints 11 Collection Ornament & Architecture 13829 The Laboring Shepherdess           Artist|Artist|Publisher 895 After Jean Michel Liotard|François Boucher|Audran Swiss, Geneva 1702–1796 Geneva|French, Paris 1703–1770 Paris|French   Liotard, Jean Michel|Boucher, François|Audran 38112 Swiss|French|French 3020 1702 |1703 1796 |1770 18th century 1715 1796 Etching and engraving 6712 sheet: 11 7/16 x 7 3/16 in. (29 x 18.3 cm) trimmed Harris Brisbane Dick Fund, 1953                       Prints|Ornament & Architecture 673   Metropolitan Museum of Art, New York, NY 1
261892 53.600.1022 0 0 390799 Drawings and Prints 11 Collection Ornament & Architecture 13829 The House of Cards           Artist|Artist|Publisher 895 After Jean Michel Liotard|François Boucher|Audran Swiss, Geneva 1702–1796 Geneva|French, Paris 1703–1770 Paris|French   Liotard, Jean Michel|Boucher, François|Audran 38112 Swiss|French|French 3020 1702 |1703 1796 |1770 18th century 1715 1796 Etching and engraving 6712 Sheet: 11 7/16 x 7 5/16 in. (29 x 18.5 cm) trimmed Harris Brisbane Dick Fund, 1953                       Prints|Ornament & Architecture 673   Metropolitan Museum of Art, New York, NY 1
295243 67.749.41(139) 0 0 424749 Drawings and Prints 11 Print 731 Vignette Depicting a Man and a Young Boy with a Watering Can Conversing with a Farmer, from Rousseau's Oeuvres         Rousseau's Oeuvres 2068 Author|Artist|Artist 722 After Jean Jacques Rousseau|Lorieux|Jean Michel Moreau the Younger Swiss, Geneva 1712–1778 Ermenonville|French, active 19th century|French, Paris 1741–1814 Paris   Rousseau, Jean Jacques|Lorieux|Moreau, Jean Michel, the Younger 42185 Swiss|French|French 3020 1712 |0019 |1741 1778 |0019 |1814 ca. 1775 1770 1780 Etching and engraving 6712 Sheet: 6 9/16 × 4 1/2 in. (16.6 × 11.5 cm) Gift of Walter Smith, 1967                       Prints 13   Metropolitan Museum of Art, New York, NY 1
295245 67.749.41(138) 0 0 424752 Drawings and Prints 11 Print 731 Vignette Depicting a Man and a Young Boy Crossing a Road, from Emile ou de l'Education, part of Rousseau's Oeuvre's         Emile ou de l'Education, part of Rousseau's Oeuvre's 2069 Author|Artist|Artist 722 After Jean Jacques Rousseau|Lorieux|Jean Michel Moreau the Younger Swiss, Geneva 1712–1778 Ermenonville|French, active 19th century|French, Paris 1741–1814 Paris   Rousseau, Jean Jacques|Lorieux|Moreau, Jean Michel, the Younger 42185 Swiss|French|French 3020 1712 |0019 |1741 1778 |0019 |1814 ca. 1775 1770 1780 Etching and engraving 6712 Sheet: 7 3/16 × 4 7/8 in. (18.2 × 12.4 cm) Gift of Walter Smith, 1967                       Prints 13   Metropolitan Museum of Art, New York, NY 1
295619 33.77.4(1) 0 0 425181 Drawings and Prints 11 Print 731 Title Page, from Pygmalion, Scene Lyrique de Mr. J. J. Rousseau, Mise en Vers par Mr. Berquin. Le Text Gravé par Droüet. Paris 1775 in a blue paper folder with Idylle par Mr. Berquin         Pygmalion, Scene Lyrique de Mr. J. J. Rousseau, Mise en Vers par Mr. Berquin. Le Text Gravé par Droüet. Paris 1775 in a blue paper folder with Idylle par Mr. Berquin 279 Author|Author|Artist 960   Jean Jacques Rousseau|Arnaud Berquin|Droüet Swiss, Geneva 1712–1778 Ermenonville|French, 1749–1791|French, 18th century   Rousseau, Jean Jacques|Berquin, Arnaud|Droüet 42258 Swiss|French|French 3020 1712 |1749 |1760 1778 |1791 |1860 published in 1775 1775 1775 Etching and engraving 6712 Sheet: 9 1/8 × 6 1/16 in. (23.2 × 15.4 cm) Gift of Philip Hofer, 1933   Paris 27                   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 133.051ms · Data license: CC0 · Data source: metmuseum/openaccess