MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where County = 654

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Culture, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, City, 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
324861 17.190.719 0 1 464590 Medieval Art 6 Statuette 14 Bishop German 27                           ca. 1500 1500 1500 Oak 32 Overall: 27 9/16 x 9 1/16 x 7 5/16 in. (70 x 23 x 18.6 cm) Gift of J. Pierpont Morgan, 1917 Made in 1 Calcar 1915   Lower Rhineland 654 Germany 16             Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
324862 17.190.720 0 1 464592 Medieval Art 6 Statuette 14 Saint Gregory as Pope German 27                           ca. 1500 1500 1500 Oak 32 Overall: 27 9/16 x 10 1/8 x 8 in. (70 x 25.7 x 20.3 cm) Gift of J. Pierpont Morgan, 1917 Made in 1 Calcar 1915   Lower Rhineland 654 Germany 16             Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
326280 1991.471.3 0 1 466230 The Cloisters 17 Jug 293 Jug German 27                           first half 14th century 1300 1350 Proto-stoneware, unglazed 49802 Overall: 7 15/16 x 4 3/16 x 3 11/16 in. (20.2 x 10.6 x 9.3 cm) Gift of Anthony and Lois Blumka, 1991 Made in 1 Siegburg 1936   Lower Rhineland 654 Germany 16             Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
326281 1991.471.4 0 1 466231 The Cloisters 17 Jug 293 Jug German 27                           late 1300s or early 1400s 1350 1450 Partially salt-glazed stoneware 49803 Overall: 9 1/8 x 5 1/2 x 4 3/4 in. (23.1 x 13.9 x 12.1 cm) Gift of Anthony and Lois Blumka, 1991 Made in 1 Siegburg 1936   Lower Rhineland 654 Germany 16             Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
326333 1995.325 0 1 466283 The Cloisters 17 Jug 293 Jug German 27                           ca. 1175–1250 1175 1250 Earthenware, unglazed and partially salt glazed 49823 Overall: 7 3/4 x 5 9/16 x 5 1/16 in. (19.7 x 14.2 x 12.9 cm) The Cloisters Collection, 1995 Made in 1 Siegburg 1936   Lower Rhineland 654 Germany 16             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
327999 64.101.1504 0 1 468645 Medieval Art 6 Plate 356 Plate with Five Angels German or South Netherlandish 5986                           ca. 1475–1500 1470 1480 Copper alloy 4107 Diam.: 18 1/2 in. (47 cm) Gift of Irwin Untermyer, 1964 Made in 1     Lower Rhineland 654 Germany 16             Metalwork-Copper alloy 804   Metropolitan Museum of Art, New York, NY 1
328506 1985.137 0 1 469896 The Cloisters 17 Reliquary pendant 14728 Reliquary Pendant with Hounds Coursing a Hare German 27                           late 14th century 1350 1399 Silver, partly gilt, niello 50226 Overall: 2 1/4 x 1 x 1/4 in. (5.7 x 2.5 x 0.7 cm) Gift of Rainer M. Zietz, 1985 Made in 1     Lower Rhineland 654 Germany 16             Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
328570 1997.513 0 1 469962 The Cloisters 17 Reliquary 3989 Glass Reliquary German or Netherlandish 710                           late 15th–early 16th century 1475 1525 Free-blown glass with applied decoration, boiled leather, silk, and wax 50258 2 3/4in. (7cm) The Cloisters Collection, 1997 Made in 1     Lower Rhineland 654               Glass-Vessels 143   Metropolitan Museum of Art, New York, NY 1
410609 SL.19.2016.1.3 0 0 676610 Medieval Art 6   Upper Knave of Pinks, from The Round Playing Cards of Master PW of Cologne German 27         Artist 2   Master PW of Cologne German, active Cologne, ca. 1490–1515   Master PW of Cologne 51827   1485 1520 ca. 1500 1495 1505 Copperplate engraving on paper 59552 Diam. approx.: 2 3/4 in. (7 cm) Museum of Fine Arts, Boston, Harvey D. Parker Collection-Harvey Drury Parker Fund (P18239) Made in 1 Cologne 556   Lower Rhineland 654 Germany 16             Miscellaneous-Paper 865   Metropolitan Museum of Art, New York, NY 1
410610 SL.19.2016.9.2 0 0 676611 Medieval Art 6   Upper Knave of Parrots, from The Round Playing Cards of Master PW of Cologne German 27         Artist 2   Master PW of Cologne German, active Cologne, ca. 1490–1515   Master PW of Cologne 51827   1485 1520 ca. 1500 1495 1505 Copperplate engraving on paper 59552 Diam. approx.: 2 3/4 in. (7 cm) National Gallery of Art, Washington, D.C., Rosenwald Collection (1948.11.138) Made in 1 Cologne 556   Lower Rhineland 654 Germany 16             Miscellaneous-Paper 865   Metropolitan Museum of Art, New York, NY 1
421204 SL.19.2016.1.4 0 0 697453 Medieval Art 6   6 of Roses, from The Round Playing Cards of Master PW of Cologne German 27         Artist 2   Master PW of Cologne German, active Cologne, ca. 1490–1515   Master PW of Cologne 51827   1485 1520 ca. 1500 1495 1505 Copperplate engraving on paper 59552 Diam. approx.: 2 3/4 in. (7 cm) Museum of Fine Arts, Boston, Anonymous gift in memory of FitzRoy Carrington (55.135) Made in 1 Cologne 556   Lower Rhineland 654 Germany 16             Miscellaneous-Paper 865   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 8554.594ms · Data license: CC0 · Data source: metmuseum/openaccess