MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Geography Type = 33 and Is Highlight = 1

View and edit SQL

Suggested facets: Is Public Domain, Department, Artist Role, Artist Nationality, 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
348800 1999.26 1 1 503517 Musical Instruments 18 Violin 15655 ex "Kurtz" Violin Italian (Cremona) 6542         Maker 1   Andrea Amati Italian, Cremona ca. 1505–1578 Cremona   Amati Andrea 48013 Italian 6 1505 1578 ca. 1560 1558 1565 Spruce, maple, ebony, paint, gilding 54904 Height: 22 5/8 in. (57.4 cm) Width: 7 15/16 in. (20.2 cm) Purchase, Robert Alonzo Lehman Bequest, 1999 | 33 Cremona 1178 | 96   Italy 14             Chordophone-Lute-plucked 960   Metropolitan Museum of Art, New York, NY 1
377847 175T49 R43 1 1 591826 The Libraries 20   Vita del Tintoretto Venice: Oddoni, 1642 6784         Author 41   Carlo Ridolfi Italian, Lonigo 1594–1658 Venice   Ridolfi, Carlo 48528 Italian 6 1594 1658 1642 1642 1642 Illustrated book 11174 H: 9 in. (23 cm) Purchased with income from the Jacob S. Rogers Fund | 33   | 96                     Metropolitan Museum of Art, New York, NY 1
377889 233.4 G25 1 0 591869 The Libraries 20   Gazette du bon ton: arts, modes et frivolities                             1912–15 and 1920–25 1912 1915 Serial publication, illustrated 57675 H: 10 1/4 in. (26 cm) Purchased with income from the Jacob S. Rogers Fund | 33 Vols. 1 (November 1912)–7 (September 1925)|copy 2 of vols. 2–3 2416 | 96                     Metropolitan Museum of Art, New York, NY 1
411878 PQ4567 .A2 1584 1 1 679465 The Libraries 20   Orlando furioso di M. Lodouico Ariosto nuouamente adornato di figure di rame da Girolamo Porro Padouano ; et di altre cose che saranno notate nella sequente facciata           Author|Author|Author|Author|Author|Author|Author|Author|Author|Publisher|Engraver|Author 5156 Appresso Alberto Lavezzola|Girolamo Garofolo|Giuseppe Bononome|Luigi Groto|Niccolò Eugenico|Giovanni Battista Pigna|Giovanni Rota|Camillo Camilli|Girolamo Ruscelli (Alessio Piemontese)|Francesco de' Franceschi|Girolamo Porro|Ludovico Ariosto Italian, active 1584|Italian, active 1584|Italian|Italian, 1541–1585|Italian|Italian, died 1615|Italian, Viterbo 1500–1566 Venice|Italian, active 16th century|Italian, 1520–1604|Italian, Reggio Emilia 1474–1533 Ferrara   Lavezzola, Alberto|Garofolo, Girolamo|Bononome, Giuseppe|Groto, Luigi|Eugenico, Niccolò|Pigna, Giovanni Battista|Rota, Giovanni|Camilli, Camillo|Ruscelli, Girolamo (Alessio Piemontese)|Franceschi Francesco de'|Porro, Girolamo|Ariosto, Ludovico 51971 Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian 1587 1584 |1584 |1541 |1615 |1500 |1500 |1520 |1474 1584 |1584 |1585 |1615 |1566 |1600 |1604 |1533 1584 1584 1584   1 volume bound in 2 (40, 654, 34 pages ; 44 leaves), Height: 11 in. (28 cm) Gift of Jayne Wrightsman, 2009 | 33 Venice|Paris 1234 | 96   Italy|France 128             | 259   Metropolitan Museum of Art, New York, NY 1
412021 PA6555 .A2 1585 1 1 679629 The Libraries 20   A. Persii Satyrarum liber I.D. Iunii Iuuenalis Satyrarum lib. V. Supliciae Satyra I : cum veteribus commentarijs nunc primum editis ex bibliotheca P. Pithoei I C. cuius etiam notae quaedam adiectae sunt           Author|Author|Author|Publisher|Printer|Author 5157   Pierre Pithou|Sulpicia|Persius|Robert Estienne|Mamert Patisson|Decimus Junius Juvenal French, 1539–1596|Aquinum 55/60?–?127/140   Pithou, Pierre|Sulpicia|Persius|Estienne, Robert|Patisson, Mamert|Juvenal, Decimus Junius 51978 French|German|French|French|Roman 3772 1539 |0055 1596 |0140 1585 1585 1585   12, 302, 10 pages; Height: 6 11/16 in. (17 cm) Gift of Jayne Wrightsman, 2009 | 33 Paris|Paris 2498 | 96   France|France 625             | 259   Metropolitan Museum of Art, New York, NY 1
434911 130.8 C23 1 1 724625 The Libraries 20   Istruzione elementare per gli studiosi della scultura           Author 41   Francesco Carradori Italian, Pistoia, 1747–1825   Carradori, Francesco 22694   1747 1825 1802 1802 1802   4 unnumbered pages, XXXVII pages, XVII leaves of plates : illustrations ; Height: 11 7/16 in. (29 cm)   | 33 Firenze|Pisa 2554 | 96   Italy|Italy 1074             | 259   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 2349.611ms · Data license: CC0 · Data source: metmuseum/openaccess