MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

4 rows where Artist Nationality = 1252

View and edit SQL

Suggested facets: Object Name, 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
218249 33.61 0 0 345752 Drawings and Prints 11 Book 97 L'Enciclopédie Perruquiere           Publisher|Publisher|Author 1773 Published by|Published by|Written by Beaumont|Hochereau|J. H. Marchand   , Paris|, Amsterdam Beaumont|Hochereau|Marchand, J. H. 21708 French|Dutch|French 1252     1757 1757 1757 plates: etchings 31907 Overall: 6 1/2 x 3 15/16 x 11/16 in. (16.5 x 10 x 1.8 cm) Harris Brisbane Dick Fund, 1933                       Books 442   Metropolitan Museum of Art, New York, NY 1
234454 32.133.3 0 0 362210 Drawings and Prints 11 Book 97 Narcisse           Author|Publisher|Binder 1814 Written by|Published by|Bound by Paul Valéry|Alexander Alphonse Marius Stols|Pierre Legrain French, Sète 1871–1945 Paris|Dutch, Maastricht 1900–1973 Tarragona|French, Levallois-Perret 1889–1929 Paris   Valéry, Paul|Stols, Alexander Alphonse Marius|Legrain, Pierre 31758 French|Dutch|French 1252 1871 |1900 |1889 1945 |1973 |1929 1926 1926 1926     Gift of George and Florence Blumenthal, 1932                       Books 442   Metropolitan Museum of Art, New York, NY 1
283536 42.24(3) 0 0 412846 Drawings and Prints 11 Print 731 Portrait of Antoine Coypel, from Gravures de Boucher pour les Oeuvres de Molière [Figures de Boucher pour Molière]         Gravures de Boucher pour les Oeuvres de Molière (Figures de Boucher pour Molière) 1917 Artist|Artist|Sitter 1046 After Isaac Sarrabat|Theodorus Netscher|Antoine Coypel French, 18th century|Dutch, Bordeaux 1661–1732 Hulst|French, Paris 1661–1722 Paris   Sarrabat, Isaac|Netscher, Theodorus|Coypel, Antoine 41174 French|Dutch|French 1252 1675 |1661 |1661 1775 |1732 |1722 mid-18th century 1734 1770 Mezzotint 29072 Sheet: 11 5/16 x 8 1/4 in. (28.7 x 21 cm) Plate: 10 3/4 x 7 11/16 in. (27.3 x 19.6 cm) Harris Brisbane Dick Fund, 1942                       Prints 13   Metropolitan Museum of Art, New York, NY 1
389818 48.1(1.57) 0 0 640546 Drawings and Prints 11 Print 731 A lion gnawing on a bone, bound in L'Oeuvre original de Vivant Denon. Collection de eaux-fortes, Volume 1           Publisher|Artist|Artist 878 Published by|After A. Barrand|Rembrandt (Rembrandt van Rijn)|baron Dominique Vivant Denon Dutch, Leiden 1606–1669 Amsterdam|French, Givry 1747–1825 Paris , Paris Barrand, A.|Rembrandt (Rembrandt van Rijn)|Denon, Dominique Vivant Baron 49739 French|Dutch|French 1252 1606 |1747 1669 |1825 1873 1873 1873 Lithograph 14948 Plate: 6 3/8 × 8 7/8 in. (16.2 × 22.5 cm) Sheet: 15 3/8 × 11 1/4 in. (39 × 28.5 cm) Harris Brisbane Dick Fund, 1948   Paris 27                   Books 442   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.211ms · Data license: CC0 · Data source: metmuseum/openaccess