MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Artist Nationality = 10 and Culture = 247

View and edit SQL

Suggested facets: Is Public Domain, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object End 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
106075 17.190.1242 0 1 193912 European Sculpture and Decorative Arts 3 Snuffbox, painting 7005 Snuffbox with portrait of Frederick the Great (1712–1786), King of Prussia German, Berlin 247         Maker|Artist 39 Miniature attributed to Daniel Baudesson|Daniel Nikolaus Chodowiecki 1716–1785, working 1730–80|German, Danzig 1726–1801 Berlin   Baudesson Daniel|Chodowiecki, Daniel Nikolaus 9164 German 10 1716 |1726 1785 |1801 1745–55 1745 1755 Gold, enamel, diamonds; ivory 20682 1 1/2 x 3 3/8 x 2 1/2 in. (3.8 x 8.6 x 6.4cm); Miniature: 2 3/8 x 3 1/4 in. (60 x 83 mm) Gift of J. Pierpont Morgan, 1917                       Metalwork-Gold and Platinum|Miniatures 317   Metropolitan Museum of Art, New York, NY 1
113290 53.125a–p, aa–pp 0 1 201583 European Sculpture and Decorative Arts 3 Chess set 212 Chess set German, Berlin 247         Designer 5   Max Esser German, Barth 1885–1945 Berlin   Esser Max 10732 German 10 1885 1945 1944 1944 1944 Silver, ivory 1272 Height (b): 5 1/8 in. (13 cm); Height (d): 8 3/8 in. (21.3 cm); Height (g): 5 1/8 in. (13 cm); Height (i): 3 11/16 in. (9.4 cm); Height (j): 3 1/4 in. (8.3 cm); Height (k): 3 7/8 in. (9.8 cm); Height (l): 3 5/8 in. (9.2 cm); Height (m): 3 3/4 in. (9.5 cm); Height (n): 3 1/2 in. (8.9 cm); Height (o): 3 3/8 in. (8.6 cm); Height (p): 3 1/2 in. (8.9 cm); Height (aa): 4 7/8 in. (12.4 cm); Height (bb): 5 1/8 in. (13 cm); Height (dd): 8 3/8 in. (21.3 cm); Height (gg): 5 1/8 in. (13 cm); Height (hh): 4 7/8 in. (12.4 cm); Height (ii): 3 11/16 in. (9.4 cm); Height (jj): 3 1/4 in. (8.3 cm); Height (kk): 3 7/8 in. (9.8 cm); Height (ll): 3 5/8 in. (9.2 cm); Height (mm): 3 3/4 in. (9.5 cm); Height (nn): 3 1/2 in. (8.9 cm); Height (oo): 3 3/8 in. (8.6 cm); Height (pp): 3 1/2 in. (8.9 cm) Gift of Gustavus A. Pfeiffer, 1948                       Chess Sets 338   Metropolitan Museum of Art, New York, NY 1
113543 55.21.10 0 0 201847 European Sculpture and Decorative Arts 3 Statuette 14 Seated statuette German, Berlin 247         Artist|Founder 355 Cast by Georg Kolbe|H. Noack German, Waldheim 1877–1947 Berlin , Berlin Kolbe, Georg|Noack H. 10785 German 10 1877 1947 modeled ca. 1926, cast before 1928 1921 1931 Bronze 23 11 1/8 x 10 1/2 x 7 3/8 in. (28.3 x 26.7 x 18.7cm) Edith Perry Chapman Fund, 1951; acquired from The Museum of Modern Art, gift of Abby Aldrich Rockefeller                       Sculpture-Bronze 304 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
117496 1976.155.3 0 1 206404 European Sculpture and Decorative Arts 3 Snuffbox 818 Snuffbox German, Berlin 247         Maker|Enameler 403 Attributed to|Possibly by Daniel Baudesson|Daniel Nikolaus Chodowiecki 1716–1785, working 1730–80|German, Danzig 1726–1801 Berlin   Baudesson Daniel|Chodowiecki, Daniel Nikolaus 9164 German 10 1716 |1726 1785 |1801 1755–60 1755 1760 Gold, enamel, diamonds 3242 Overall: 1 1/2 × 3 3/16 × 2 3/8 in. (3.8 × 8.1 × 6 cm) Gift of Mr. and Mrs. Charles Wrightsman, 1976                       Metalwork-Gold and Platinum 326   Metropolitan Museum of Art, New York, NY 1
120943 2000.189 0 1 210179 European Sculpture and Decorative Arts 3 Table 477 Table German, Berlin 247         Designer|Decorator|Decorator|Maker|Manufactory 627 Design attributed to|Figural and zodiac decoration by|Floral decoration by|Bronze and metal mounts by Karl Friedrich Schinkel|August von Kloeber|Gottfried Wilhelm Voelker|Bronzeure Werner und Neffen|Royal Porcelain Manufactory, Berlin German, Neuruppin 1781–1841 Berlin|1793–1864|1772–1849|Berlin|German, founded 1763   Schinkel, Karl Friedrich|Kloeber August von|Voelker Gottfried Wilhelm|Bronzeure Werner und Neffen|Royal Porcelain Manufactory, Berlin 12097 German 10 1781 |1793 |1772 |1763 1841 |1864 |1849 |9999 ca. 1833–34 1828 1839 Hard-paste porcelain, gilded bronze, and yellow metal; iron and wood as support materials 24222 Overall: 35 1/2 x 31 in. diameter of top (includes frame) (90.2 x 78.7 cm) Wrightsman Fund, 2000                       Ceramics-Porcelain 307   Metropolitan Museum of Art, New York, NY 1
139336 2006.242.1a, b, .2a, b 0 1 232013 European Sculpture and Decorative Arts 3 Candlesticks 4275 Pair of candlesticks German, Berlin 247         Maker 1   Carl Heinrich Hoffmann German, 1788–1840   Hoffmann Carl Heinrich 12676 German 10 1788 1840 ca. 1821–30 1816 1835 Silver 2 Overall: .1ab: 8 3/4 x 4 5/8 in. (22.2 x 11.7 cm) .2ab: 8 11/16 x 4 5/8 in. (22 x 11.7 cm) Purchase, The Isak and Rose Weinman Foundation Inc. Gift, Gifts in honor of Ruth Stanton, and funds from various donors, 2006                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
139385 2007.188.1, .2 0 1 232191 European Sculpture and Decorative Arts 3 Torchères 8018 Pair of torchères German, Berlin 247         Designer|Manufacturer 3 Possibly after a design by Karl Friedrich Schinkel|Royal Ironworks, Berlin German, Neuruppin 1781–1841 Berlin   Schinkel, Karl Friedrich|Royal Ironworks, Berlin 12686 German 10 1781 1841 ca. 1820–30 1815 1835 Cast iron 61 Height (each): 44 in. (111.8 cm); Diam. of rim (each): 5 in. (12.7 cm); Diam. of base (each): 14 in. (35.6 cm) Purchase, Friends of European Sculpture and Decorative Arts Gifts, 2007                       Metalwork-Iron 322   Metropolitan Museum of Art, New York, NY 1
140312 2012.179a, b 0 1 238970 European Sculpture and Decorative Arts 3 Potpourri vase 1109 Potpourri vase German, Berlin 247         Designer|Maker 4   Karl Friedrich Schinkel|Werner & Mieth, Berlin German, Neuruppin 1781–1841 Berlin   Schinkel, Karl Friedrich|Werner & Mieth, Berlin 12861 German 10 1781 1841 ca. 1810 1805 1815 Glass, gilded yellow metal, marble 25526 Overall (confirmed): 20 1/2 × 12 7/8 × 9 1/8 in., 9lb. (52 × 32.7 × 23.2 cm, 4.0597kg) Purchase, Mercedes T. Bass Gift, in honor of Mrs. Charles Wrightsman, 2012                       Glass 3   Metropolitan Museum of Art, New York, NY 1
140550 2013.616 0 1 239508 European Sculpture and Decorative Arts 3 Stool 861 Stool (tabouret) German, Berlin 247         Designer 5 After a design by Friedrich Gilly German, Szczecin, Poland 1772–1800 Carlsbad, Czech Republic   Gilly, Friedrich 12906 German 10 1772 1800 ca. 1805–10 1800 1810 Pine, birch, mahogany; silk, lampas 25593 Overall (confirmed, ht. with current upholstery profile): 20 3/8 × 19 1/8 × 19 1/8 in. (51.8 × 48.6 × 48.6 cm) Purchase, Friends of European Sculpture and Decorative Arts Gifts, 2013                       Woodwork-Furniture 321   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 249.077ms · Data license: CC0 · Data source: metmuseum/openaccess