MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Culture = 2249

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Artist Role, 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 Repository
100063 91.16.15a–d 0 1 187412 European Sculpture and Decorative Arts 3 Knife and fork with case 6935 Knife and fork with case German, Hamburg 2249                           17th century 1600 1699 Steel 658 Length (fork .15a): 6 in. (15.2 cm); Length (knife .15b): 6 1/8 in. (15.6 cm); Length (case .15c, d): 7 in. (17.8 cm) Gift of R. Stuyvesant, 1891                       Metalwork-Steel 329   Metropolitan Museum of Art, New York, NY 1
104261 12.35.1 0 0 191875 European Sculpture and Decorative Arts 3 Tankard 888 Tankard German, Hamburg 2249         Maker 1   Adolf Steinweg     Steinweg, Adolf 8760       17th century, with 19th century additions 1600 1900 Silver, partly gilt 20535 Height: 8 1/2 in. (21.6 cm) Rogers Fund, 1912                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
104429 13.41.9 0 1 192064 European Sculpture and Decorative Arts 3 Hanukkah lamp 7479 Hanukkah lamp German, Hamburg 2249                           17th century 1600 1699 Silver 2 Overall: 13 1/2 × 10 1/2 in. (34.3 × 26.7 cm) Rogers Fund, 1913                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
104631 13.42.140 0 1 192280 European Sculpture and Decorative Arts 3 Spoon 78 Spoon German, Hamburg 2249         Maker 1   Leonhard Rothaer I working 1671–90   Rothaer Leonhard I 8876   1671 1690 late 17th century 1685 1699 Silver gilt 9203 Overall: 7 1/8 × 2 1/4 in. (18.1 × 5.7 cm) Rogers Fund, 1913                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
108039 27.185.301 0 1 196047 European Sculpture and Decorative Arts 3 Standing cup 855 Standing cup (Flügelglas) German, Hamburg 2249         Maker 1   Carl Heinrich Florenz Müller German, Piesau 1845–1912 Hamburg   Müller, Carl Heinrich Florenz 9692   1845 1912 1865–77 1865 1877 Glass 31 Overall: 11 3/16 × 3 9/16 in. (28.4 × 9 cm) Munsey Fund, 1927                       Glass 3   Metropolitan Museum of Art, New York, NY 1
108968 32.75.83 0 1 197010 European Sculpture and Decorative Arts 3 Tankard 888 Tankard German, Hamburg 2249         Maker 1   Hanss Lambrecht III active 1630–70   Lambrecht, Hanss, III 9786   1630 1670 ca. 1660 1655 1665 Silver, partly gilded 20540 Height: 8 5/8 in. (21.9 cm) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
116908 1974.28.210 0 0 205692 European Sculpture and Decorative Arts 3 Tankard 888 Tankard German, Hamburg 2249         Maker|Artist 39 Probably by|Engraved figures after costume prints by Hermann Lambrecht|Abraham Bosse 1670–1675|French, Tours 1602/1604–1676 Paris   Lambrecht Hermann|Bosse, Abraham 11417 French 2 1670 |1602 1675 |1676 1670–75 1670 1675 Silver, partly gilt 20535 Overall: 9 1/16 × 6 5/8 in. (23 × 16.8 cm) Bequest of Irwin Untermyer, 1973                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
117361 1974.356.759a, b 0 1 206254 European Sculpture and Decorative Arts 3 Canister 7388 Canister German, Hamburg 2249         Maker 1   Juergen Richels master 1664, died ca. 1711   Richels Juergen 11482   1611 1711 ca. 1670–80 1665 1685 Silver gilt 9203 Height: 10 in. (25.4 cm) The Lesley and Emma Sheafer Collection, Bequest of Emma A. Sheafer, 1973                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
118955 1991.149.2 0 1 207981 European Sculpture and Decorative Arts 3 Krug 8557 Krug German, Hamburg 2249                           dated 1642 1642 1642 Faience (tin-glazed earthenware); pewter 21070   Bequest of Lola Kramarsky, in memory of Siegfried Kramarsky, 1991                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
118956 1991.149.3 0 1 207982 European Sculpture and Decorative Arts 3 Krug 8557 Krug German, Hamburg 2249                           dated 1642 1642 1642 Faience (tin-glazed earthenware); pewter 21070   Bequest of Lola Kramarsky, in memory of Siegfried Kramarsky, 1991                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
121061 2000.421.1 0 1 210313 European Sculpture and Decorative Arts 3 Portfolio 723 Portfolio German, Hamburg 2249         Maker 1   Georg Hulbe German, 1851–1917   Hulbe Georg 12110 German 10 1851 1917 dated 1902 1902 1902 Leather, partially painted and gilded 24225 15 1/8 x 12 3/16 inches (38.4 x 31 cm) Gift of Bernard Heitmann, 2000                       Natural Substances-Leatherwork 331   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 122.763ms · Data license: CC0 · Data source: metmuseum/openaccess