MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

18 rows where Portfolio = 295

View and edit SQL

Suggested facets: Object Name, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Dimensions

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
219760 43.65.8 0 0 347282 Drawings and Prints 11 Book 97 Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist|Artist|Artist|Artist|Artist|Artist|Artist 2063   Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Michele Augusta|Giacomo Carboni|Cristofaro Cattelli|Carlo Virginio Draghi|Prospero Manzini|Orazio Talami|Francesco Torri Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century|Italian, active 17th century|Italian, active 17th century|Italian, active 17th century|Italian, active 17th century|Italian, active 17th century|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Augusta, Michele|Carboni, Giacomo|Cattelli, Cristofaro|Draghi, Carlo Virginio|Manzini, Prospero|Talami, Orazio|Torri, Francesco 22800 Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian 1129 1600 |1634 |1600 |1600 |1600 |1600 |1600 |1600 |1600 1700 |1718 |1700 |1700 |1700 |1700 |1700 |1700 |1700 1675 1675 1675 Etching 26137 13 3/4 × 9 7/16 × 1 3/16 in. (35 × 24 × 3 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382141 43.65.8(2) 0 0 631046 Drawings and Prints 11 Print 731 Portrait of Duke Francesco II d'Este, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist 750   Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli Italian|Italian, Bologna (?) 1634–1718 Bologna , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria 49102 Italian|Italian|Italian 145 1600 |1634 1700 |1718 1675 1675 1675 Etching 26137 Sheet: 13 9/16 × 9 1/16 in. (34.5 × 23 cm) Plate: 12 3/4 × 8 9/16 in. (32.4 × 21.8 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382142 43.65.8(1) 0 0 631047 Drawings and Prints 11 Print 731 Frontispiece, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist 2717   Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Orazio Talami Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Talami, Orazio 49103 Italian|Italian|Italian|Italian 315 1600 |1634 |1600 1700 |1718 |1700 1675 1675 1675 Etching 26137 Sheet: 13 9/16 × 9 1/16 in. (34.5 × 23 cm) Plate: 12 3/8 × 8 1/2 in. (31.5 × 21.6 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382143 43.65.8(3) 0 0 631048 Drawings and Prints 11 Print 731 Dancing Angels with S. Carlo venerating the Madonna della Ghiara at top, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist 2717 After Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Cristofaro Cattelli Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Cattelli, Cristofaro 49104 Italian|Italian|Italian|Italian 315 1600 |1634 |1600 1700 |1718 |1700 1675 1675 1675 Etching 26137 Sheet: 13 9/16 × 9 1/16 in. (34.5 × 23 cm) Plate: 12 1/2 × 8 1/2 in. (31.8 × 21.6 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382144 43.65.8(4) 0 0 631049 Drawings and Prints 11 Print 731 Chariot surrounded by two rows of halberdiers before cart on which there is a temple, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist 2717 After Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Francesco Torri Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Torri, Francesco 49105 Italian|Italian|Italian|Italian 315 1600 |1634 |1600 1700 |1718 |1700 1675 1675 1675 Etching 26137 Sheet: 13 9/16 × 26 3/4 in. (34.4 × 68 cm) Plate: 12 11/16 × 25 9/16 in. (32.3 × 65 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382157 43.65.8(5) 0 0 631064 Drawings and Prints 11 Print 731 Soldiers on foot and horseback surround a temple in which Christ crowns the Madonna della Ghiara, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist 2717 After Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Carlo Virginio Draghi Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Draghi, Carlo Virginio 49109 Italian|Italian|Italian|Italian 315 1600 |1634 |1600 1700 |1718 |1700 1675 1675 1675 Etching 26137 Sheet: 13 1/2 × 26 3/8 in. (34.3 × 67 cm) Plate: 12 11/16 × 25 9/16 in. (32.2 × 65 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382158 43.65.8(6) 0 0 631065 Drawings and Prints 11 Print 731 The Chariot of Theological Virtue drags Heresy at left and following it is a representation of the Garden of Flora with a small temple ornamented with statues, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist 2717 After Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Giacomo Carboni Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Carboni, Giacomo 49110 Italian|Italian|Italian|Italian 315 1600 |1634 |1600 1700 |1718 |1700 1675 1675 1675 Etching 26137 Sheet: 13 1/2 × 26 3/4 in. (34.3 × 68 cm) Plate: 12 5/8 × 25 13/16 in. (32.1 × 65.5 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382159 43.65.8(7) 0 0 631066 Drawings and Prints 11 Print 731 Moses Strikes the Rock for Water, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist 750   Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli Italian|Italian, Bologna (?) 1634–1718 Bologna , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria 49102 Italian|Italian|Italian 145 1600 |1634 1700 |1718 1675 1675 1675 Etching 26137 Sheet: 13 1/2 × 9 1/16 in. (34.3 × 23 cm) Plate: 12 7/16 × 8 9/16 in. (31.6 × 21.8 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382161 43.65.8(8) 0 0 631068 Drawings and Prints 11 Print 731 Fountain made of rocks, topped with the Madonna della Ghiara, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist 750   Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli Italian|Italian, Bologna (?) 1634–1718 Bologna , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria 49102 Italian|Italian|Italian 145 1600 |1634 1700 |1718 1675 1675 1675 Etching 26137 Sheet: 13 1/2 × 9 1/16 in. (34.3 × 23 cm) Plate: 12 7/16 × 8 9/16 in. (31.6 × 21.8 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382162 43.65.8(9) 0 0 631069 Drawings and Prints 11 Print 731 Fountain topped with the Madonna della Ghiara with a procession on foot and horseback, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist 750   Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli Italian|Italian, Bologna (?) 1634–1718 Bologna , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria 49102 Italian|Italian|Italian 145 1600 |1634 1700 |1718 1675 1675 1675 Etching 26137 Sheet: 13 9/16 × 27 3/16 in. (34.5 × 69 cm) Plate: 12 11/16 × 26 in. (32.3 × 66 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382163 43.65.8(10) 0 0 631070 Drawings and Prints 11 Print 731 The Triumphal Chariot of the Virgin on top of boulders that crush the Seven Deadly Sins, surrounded by figures on foot and on horseback, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist 2717 After Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Prospero Manzini Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Manzini, Prospero 49112 Italian|Italian|Italian|Italian 315 1600 |1634 |1600 1700 |1718 |1700 1675 1675 1675 Etching 26137 Sheet: 13 5/8 × 26 15/16 in. (34.6 × 68.5 cm) Plate: 12 11/16 × 25 9/16 in. (32.3 × 65 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382164 43.65.8(11) 0 0 631071 Drawings and Prints 11 Print 731 The Throne of Solomon with female figures on either side hilding incense burners and flowers, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist 2717 After Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Prospero Manzini Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Manzini, Prospero 49112 Italian|Italian|Italian|Italian 315 1600 |1634 |1600 1700 |1718 |1700 1675 1675 1675 Etching 26137 Sheet: 13 9/16 × 34 1/4 in. (34.5 × 87 cm) Plate: 12 13/16 × 23 7/16 in. (32.5 × 59.5 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382165 43.65.8(12) 0 0 631072 Drawings and Prints 11 Print 731 A Cart Topped with an open sepulcher, over which the Virgin is depicted in glory with the Holy Trinity at the top, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist 2717 After Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Prospero Manzini Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Manzini, Prospero 49112 Italian|Italian|Italian|Italian 315 1600 |1634 |1600 1700 |1718 |1700 1675 1675 1675 Etching 26137 Sheet: 13 9/16 × 27 9/16 in. (34.5 × 70 cm) Plate: 12 13/16 × 26 3/16 in. (32.6 × 66.5 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382170 43.65.8(13) 0 0 631104 Drawings and Prints 11 Print 731 Cart Drawn by elephants carrying the Madonna della Ghiara, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist 2717 After Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Carlo Virginio Draghi Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Draghi, Carlo Virginio 49109 Italian|Italian|Italian|Italian 315 1600 |1634 |1600 1700 |1718 |1700 1675 1675 1675 Etching 26137 Sheet: 13 9/16 × 27 1/16 in. (34.5 × 68.8 cm) Plate: 12 11/16 × 25 9/16 in. (32.3 × 65 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382171 43.65.8(14) 0 0 631105 Drawings and Prints 11 Print 731 A group of trumpeters lead a procession featuring the banner of the City of Reggio, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist 2717 After Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Orazio Talami Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Talami, Orazio 49103 Italian|Italian|Italian|Italian 315 1600 |1634 |1600 1700 |1718 |1700 1675 1675 1675 Etching 26137 Sheet: 13 9/16 × 26 1/2 in. (34.5 × 67.3 cm) Plate: 12 5/16 × 25 9/16 in. (31.3 × 65 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382173 43.65.8(15) 0 0 631107 Drawings and Prints 11 Print 731 Obelisque between two fountains, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist 2717 After Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Orazio Talami Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Talami, Orazio 49103 Italian|Italian|Italian|Italian 315 1600 |1634 |1600 1700 |1718 |1700 1675 1675 1675 Etching 26137 Sheet: 18 1/2 × 13 9/16 in. (47 × 34.5 cm) Plate: 15 9/16 × 11 11/16 in. (39.5 × 29.7 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382174 43.65.8(16) 0 0 631108 Drawings and Prints 11 Print 731 Crown given to the Madonna della Ghiara, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist 2717 After Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Orazio Talami Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Talami, Orazio 49103 Italian|Italian|Italian|Italian 315 1600 |1634 |1600 1700 |1718 |1700 1675 1675 1675 Etching 26137 Sheet: 18 1/8 × 13 9/16 in. (46 × 34.5 cm) Plate: 14 1/2 × 10 7/8 in. (36.8 × 27.7 cm) Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   Metropolitan Museum of Art, New York, NY 1
382176 43.65.8(17) 0 0 631110 Drawings and Prints 11 Print 731 Fountain topped with an Angel and with the Virgin and Child seated on clouds above, from Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674         Maria Vergine Coronata; Descrizione e dichiarazione della Divota Solennita fatta in Reggio li 13 Maggio 1674 295 Author|Printer|Artist|Artist 2717 After Giacomo Certani|Prospero Vedrotti|Giuseppe Maria Mitelli|Orazio Talami Italian|Italian, Bologna (?) 1634–1718 Bologna|Italian, active 17th century , Reggio Certani, Giacomo|Vedrotti, Prospero|Mitelli, Giuseppe Maria|Talami, Orazio 49103 Italian|Italian|Italian|Italian 315 1600 |1634 |1600 1700 |1718 |1700 1675 1675 1675 Etching 26137 Sheet: 12 11/16 × 6 1/4 in. (32.2 × 15.8 cm) pasted into the back Harris Brisbane Dick Fund, 1943   Reggio 674                   Prints 13   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 129.107ms · Data license: CC0 · Data source: metmuseum/openaccess