MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Department = 20 and Medium = 33728

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Artist Role, Artist Nationality

Medium ✖

  • Printed book · 7 ✖

Department ✖

  • The Libraries · 7 ✖
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
377850 377850 109A L83 1 1 591829 The Libraries 20   Trattato dell' arte della pittura, scultura et architetettura Milan: [s.n.], 1585 6786         Author 41   Giovanni Paolo Lomazzo Italian, Milan 1538–1600 Milan   Lomazzo, Giovanni Paolo 32595 Italian 6 1538 1600 1585 1585 1585 Printed book 33728 H: 8 5/8 in. (22 cm) Purchased with income from the Library Fund   Milan 420                       http://www.metmuseum.org/art/collection/search/591829 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
377855 377855 912.1 K63 Q 1 1 591834 The Libraries 20   Athanasii Kircheri e Soc. Jesu China monumentis: qua sacris qua profanis, nec non variis naturae & artis spectaculis, aliarumque rerum memorabilium argumentis illustrata           Author 41   Athanasius Kircher German, 1602–1680   Kirchner Athanasius 48534 German 10 1602 1680 1667 1667 1667 Printed book 33728 H: 14 5/8 in. (37 cm) Jane E. Andrews Fund, in memory of her husband, William Loring Andrews   Amsterdam: Apud Joannem Janssonium a Waesberge 2413   & Elizeum Weyerstraet, 1667 1054                   http://www.metmuseum.org/art/collection/search/591834 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
377857 377857 911.1. M362 1 1 591836 The Libraries 20   Il Ritratto di Venezia Venice: Presso Gio. Giacomo Hertz, 1684 6791         Author 41   Domenico Martinelli active 1663–1669   Martinellie Domenico 48535   1663 1669 1684 1684 1684 Printed book 33728 H: 6 3/4 in. (17 cm) Presented by Bobby and Allan Weissglass                           http://www.metmuseum.org/art/collection/search/591836 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
377862 377862 143.7W41 W413 1 1 591841 The Libraries 20   An Address to the Workmen in the Pottery on the Subject of Entering into the Service of Foreign Manufacturers Newcastle: J. Smith, 1783 (1st ed.) 6796         Artist 2   Josiah Wedgwood British, Burslem, Stoke-on-Trent 1730–1795 Burslem, Stoke-on-Trent   Wedgwood, Josiah 8583 British 7 1730 1795 1783 1783 1783 Printed book 33728 24 pp.; H: 7 7/8 in. (20 cm) Purchased with income from the Jacob S. Rogers Fund                           http://www.metmuseum.org/art/collection/search/591841 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
377868 377868 532 Eg961 1 1 591847 The Libraries 20   Narrative of the Operations and Recent Discoveries Within the Pyramids, Temples, Tombs and Excavations in Egypt and Nubia; and of a Journey to the Coast of the Red Sea, in Search of the Ancient Berenice; and Another to the Oasis of Jupiter Ammon London: J. Murray, 1820 6800         Author 41   Giovanni Battista Belzoni Italian, 1778–1823   Belzoni, Giovanni Battista 48542 Italian 6 1778 1823 1820 1820 1820 Printed book 33728 xix + 533 pp.; H: 11 3/8 in. (29 cm) Presented by Mr. Theodore M. Davis                           http://www.metmuseum.org/art/collection/search/591847 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
377873 377873 UD S83 1842 v.1 1 1 591852 The Libraries 20   Incidents of Travel in Central America, Chiapas, and Yucatan London: J. Murray, 1842 (new ed.) 6805         Author 41   John Lloyd Stephens American, 1805–1852   Stephens John Lloyd 48547 American 1 1805 1852 1842 1842 1842 Printed book 33728 2 vols.; H: 9 in. (23 cm) Gift of the Dept. of Twentieth Century Art, 1998                           http://www.metmuseum.org/art/collection/search/591852 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
377885 377885 926.1 M642 1 1 591864 The Libraries 20   Paradise Lost Hammersmith: Doves Press, 1902 6813         Author 41   John Milton British, London 1608–1674 London   Milton, John 48555 British 7 1608 1674 1902 1902 1902 Printed book 33728 386 + [2] pp.; H: 9 1/2 in. (24 cm) Presented by Alice M. Dike                       | 259   http://www.metmuseum.org/art/collection/search/591864 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 131.497ms · Data license: CC0 · Data source: metmuseum/openaccess