MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Nationality = 21 and Object Name = 148

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Department, Artist Role, Artist Prefix, Medium, Dimensions, Credit Line, Classification

Artist Nationality ✖

  • French|French · 5 ✖
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
4668 4668 83.2.423 0 1 5025 American Decorative Arts 1 Medal 148 Medal Commemorating the Treaty of Commerce between France and the United States           Maker|Maker 6   Bertrand Andrieu|Raymond Gayrard French, 1761–1822|French, Rodez 1777–1858 Paris   Andrieu, Bertrand|Gayrard, Raymond 684 French|French 21 1761 |1777 1822 |1858 1822 1822 1822 Bronze 23 Diam. 2 in. (5.1 cm) Gift of William H. Huntington, 1883 Made in 1       France 9             Metal 1   http://www.metmuseum.org/art/collection/search/5025 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
99398 99398 85.2.49 0 1 186740 European Sculpture and Decorative Arts 3 Medal 148 French Eagles on the Volga French 7         Artist|Artist|Manufactory|Factory director 336 Struck at the Bertrand Andrieu|Auguste-François Michaut|Paris Mint|baron Dominique Vivant Denon French, 1761–1822|French, Paris 1786–1879 Paris|864–present|French, Givry 1747–1825 Paris   Andrieu, Bertrand|Michaut Auguste-François|Paris Mint|Denon, Dominique Vivant Baron 8070 French|French 21 1761 |1786 |0864 |1747 1822 |1879 |1825 1812 1812 1812 Gilt bronze, struck 20531 Diameter: 1 5/8 in. (4.1 cm) Gift of Hon. Levi P. Morton, 1885                       Medals and Plaquettes 306   http://www.metmuseum.org/art/collection/search/186740 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
99463 99463 85.2.114 0 0 186805 European Sculpture and Decorative Arts 3 Medal 148 Completion of the Road from Nice to Rome, 1807 French 7         Artist|Artist|Factory director|Manufactory 334 Medalist (obverse):|Medalist (reverse):|Struck at the Bertrand Andrieu|Raymond Gayrard|baron Dominique Vivant Denon|Paris Mint French, 1761–1822|French, Rodez 1777–1858 Paris|French, Givry 1747–1825 Paris|864–present   Andrieu, Bertrand|Gayrard, Raymond|Denon, Dominique Vivant Baron|Paris Mint 8097 French|French 21 1761 |1777 |1747 |0864 1822 |1858 |1825 19th century 1800 1899 Gilt bronze, struck 20531 Diameter: 1 9/16 in. (4 cm) Gift of Hon. Levi P. Morton, 1885                       Medals and Plaquettes 306   http://www.metmuseum.org/art/collection/search/186805 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
102984 102984 07.251.78 0 0 190519 European Sculpture and Decorative Arts 3 Medal 148 To commemorate the Universal Exhibition of 1878 French 7         Artist|Artist 13 Medalist (obverse):|Medalist (reverse): Alphée Dubois|Jean Lagrange French, Paris 1831–1905 Clamart|French, Lyon 1831–1908 Paris   Dubois Alphée|LAGRANGE JEAN 8549 French|French 21 1831 |1831 1905 |1908 1878 1878 1878 Gilt bronze 30 Diameter: 2 in. (5.1 cm) Gift of Mr. and Mrs. Frederick S. Wait, 1907                       Medals and Plaquettes 306   http://www.metmuseum.org/art/collection/search/190519 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
117893 117893 1980.283.2 0 1 206834 European Sculpture and Decorative Arts 3 Medal 148 Louis XVIII, King of France French 7         Artist|Artist 13 Medalist (obverse):|Medalist (reverse): Bertrand Andrieu|Jacques Édouard Gatteaux French, 1761–1822|French, Paris 1788–1881 Paris   Andrieu, Bertrand|Gatteaux, Jacques Édouard 11583 French|French 21 1761 |1788 1822 |1881 1814 1814 1814 Bronze 23 Diameter: 2 in. (5.1 cm) Purchase, Mr. and Mrs. David C. Schiff Gift, 1980                       Medals and Plaquettes 306   http://www.metmuseum.org/art/collection/search/206834 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 3993.676ms · Data license: CC0 · Data source: metmuseum/openaccess