Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Portfolio, Artist Role, Medium, Dimensions, Credit Line
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
208207 | 208207 | 68.640.1 | 0 | 0 | 335566 | Drawings and Prints 11 | Print 731 | View of Venice, with a view across the water to the Piazzetta and the Doge's Palace, many boats in the canal in the foreground, from 'Views of Venice' (Magnificentiores Selectioresque Urbis Venetiarum Prospectus) | 'Views of Venice' (Magnificentiores Selectioresque Urbis Venetiarum Prospectus) 104 | Artist 2 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching and engraving; first state of four (Succi) 29965 | Plate: 13 × 18 11/16 in. (33 × 47.5 cm) Sheet: 17 13/16 × 24 1/8 in. (45.3 × 61.2 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1968 | Prints 13 | http://www.metmuseum.org/art/collection/search/335566 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
208208 | 208208 | 68.640.2 | 0 | 0 | 335567 | Drawings and Prints 11 | Print 731 | The Piazza San Marco seen from the side of the Basilica, looking towards the church of San Geminiano, from 'Views of Venice' (Magnificentiores Selectioresque Urbis Venetiarum Prospectus) | 'Views of Venice' (Magnificentiores Selectioresque Urbis Venetiarum Prospectus) 104 | Artist 2 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching; first state of four (Succi) 29966 | Plate: 12 3/16 × 16 15/16 in. (31 × 43 cm) Sheet: 17 7/8 × 24 1/8 in. (45.4 × 61.2 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1968 | Prints 13 | http://www.metmuseum.org/art/collection/search/335567 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
208209 | 208209 | 67.688.6 | 0 | 0 | 335568 | Drawings and Prints 11 | Print 731 | The Campo dei Frari, the Basilica di Santa Maria Gloriosa dei Frari at center, gondolas and other boats in the foreground, from 'Views of Venice' (Magnificentiores Selectioresque Urbis Venetiarum Prospectus) | 'Views of Venice' (Magnificentiores Selectioresque Urbis Venetiarum Prospectus) 104 | Artist 2 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching; first state of four (Succi) 29966 | Plate: 12 1/2 × 18 1/2 in. (31.8 × 47 cm) Sheet: 15 9/16 × 21 7/8 in. (39.6 × 55.5 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967 | Prints 13 | http://www.metmuseum.org/art/collection/search/335568 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
271067 | 271067 | 2012.136.918 | 0 | 1 | 400200 | Drawings and Prints 11 | Print 731 | Plate 9: the bridge and market of the Rialto, Venice, from 'Views of Venice' (Magnificentiores Selectioresque Urbis Venetiarum Prospectus) | 'Views of Venice' (Magnificentiores Selectioresque Urbis Venetiarum Prospectus) 104 | Artist 2 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching; second state of four (Succi) 43208 | Plate: 12 1/2 × 18 9/16 in. (31.8 × 47.1 cm) Sheet: 17 3/8 × 24 1/2 in. (44.2 × 62.2 cm) | Bequest of Phyllis Massar, 2011 | Prints 13 | http://www.metmuseum.org/art/collection/search/400200 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410051 | 410051 | 69.551(2) | 0 | 0 | 676030 | Drawings and Prints 11 | Print 731 | Dedication plate for the series, a view to the Piazzetta and the Doge's Palace, with a dedication to the Prince of Beauvau-Craon | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 13 × 18 1/2 in. (33 × 47 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676030 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410155 | 410155 | 69.551(3) | 0 | 0 | 676137 | Drawings and Prints 11 | Print 731 | The Piazzetta in Venice with many figures, the Doge's Palace to the left and Campanile to the right | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 5/16 × 18 1/2 in. (31.3 × 47 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676137 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410156 | 410156 | 69.551(4) | 0 | 0 | 676138 | Drawings and Prints 11 | Print 731 | The view along the Grand Canal in Venice from the Rialto Bridge with the Fondaco dei Tedeschi at the right | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 5/16 × 18 1/2 in. (31.3 × 47 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676138 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410157 | 410157 | 69.551(5) | 0 | 0 | 676139 | Drawings and Prints 11 | Print 731 | The church of the Frari in Venice with the Scuola of St Antonio at the left | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 5/16 × 18 1/2 in. (31.3 × 47 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676139 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410158 | 410158 | 69.551(6) | 0 | 0 | 676140 | Drawings and Prints 11 | Print 731 | The island of S. Girogio Maggiore a distant view of the Doge's Palace across the water | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 5/16 × 18 1/2 in. (31.3 × 47 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676140 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410159 | 410159 | 69.551(7) | 0 | 0 | 676141 | Drawings and Prints 11 | Print 731 | The Cannaregio on the Grand Canal, with the Ghetto in the background | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 7/16 × 18 1/2 in. (31.6 × 47 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676141 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410160 | 410160 | 69.551(8) | 0 | 0 | 676142 | Drawings and Prints 11 | Print 731 | The Grand Canal in Venice with the churches of S. Simeon on the left and the Carmelite church on the right | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 7/16 × 18 1/2 in. (31.6 × 47 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676142 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410161 | 410161 | 69.551(9) | 0 | 0 | 676143 | Drawings and Prints 11 | Print 731 | View along the Molo in Venice with the Doge's Palace on the right, S. Maria della Salute in the distance | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 7/16 × 18 1/2 in. (31.6 × 47 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676143 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410162 | 410162 | 69.551(10) | 0 | 0 | 676144 | Drawings and Prints 11 | Print 731 | The Palazzo Pesaro on the Grand Canal in Venice with gondoliers clearly in the foreground | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 15/16 × 18 1/2 in. (32.9 × 47 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676144 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410347 | 410347 | 69.551(11) | 0 | 0 | 676330 | Drawings and Prints 11 | Print 731 | View of the Rialto Bridge seen from the traghetto of Ca Bembo in Venice | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 9/16 × 18 1/2 in. (31.9 × 47 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676330 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410348 | 410348 | 69.551(12) | 0 | 0 | 676331 | Drawings and Prints 11 | Print 731 | Two entrances to the Arsenal in Venice, one for the workmen and the other for those involved in shipping | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 3/8 × 18 1/2 in. (31.5 × 47 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676331 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410349 | 410349 | 69.551(13) | 0 | 0 | 676332 | Drawings and Prints 11 | Print 731 | The courtyard of the Doge's Palace in Venice with many people, the cupolas of St Mark's Basilica in the background | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 3/16 × 17 9/16 in. (31 × 44.6 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676332 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410350 | 410350 | 69.551(14) | 0 | 0 | 676333 | Drawings and Prints 11 | Print 731 | The square and church of Sanata Maria Formosa in Venice | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 3/8 × 18 1/2 in. (31.5 × 47 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676333 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410351 | 410351 | 69.551(15) | 0 | 0 | 676334 | Drawings and Prints 11 | Print 731 | The Piazza San Marco in Venice with the Basilica to the left, the Campanile in the centre, a proecession in the foreground | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 3/16 × 17 1/2 in. (31 × 44.5 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676334 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410352 | 410352 | 69.551(16) | 0 | 0 | 676335 | Drawings and Prints 11 | Print 731 | The square and the church of SS. Giovanni e Paolo, with the Scuola di San Marco and the equestrian statue of Bartolomeo Colleoni by Verrocchio at right | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 1/16 × 17 1/2 in. (30.6 × 44.5 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676335 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410353 | 410353 | 69.551(17) | 0 | 0 | 676336 | Drawings and Prints 11 | Print 731 | The Campo San Rocco with the Scuola designed by Serlio and church with a façade invented by Marieschi (façade was incomplete in 1741) | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 3/8 × 18 1/2 in. (31.5 × 47 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676336 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410354 | 410354 | 69.551(18) | 0 | 0 | 676337 | Drawings and Prints 11 | Print 731 | The church of Santa Maria della Salute across the water; gondolas in the foreground | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 3/8 × 18 5/16 in. (31.5 × 46.5 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676337 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410355 | 410355 | 69.551(19) | 0 | 0 | 676338 | Drawings and Prints 11 | Print 731 | The Piazza San Marco, Venice with the Basilica and Campanile at the far end, the buildings of the Procuratie on either side | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 11 13/16 × 17 1/2 in. (30 × 44.5 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676338 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410376 | 410376 | 69.551(20) | 0 | 0 | 676359 | Drawings and Prints 11 | Print 731 | The Piazza San Marco, Venice looking towards church of San Geminiano in the background | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 3/16 × 16 15/16 in. (31 × 43 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676359 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410377 | 410377 | 69.551(21) | 0 | 0 | 676360 | Drawings and Prints 11 | Print 731 | The Market and Rialto Bridge in Venice, gondola and figures in the foreground | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 12 1/2 × 18 5/16 in. (31.8 × 46.5 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676360 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
410378 | 410378 | 69.551(22) | 0 | 0 | 676361 | Drawings and Prints 11 | Print 731 | The Regatta on the Grand Canal in Venice, with floats and gondola, between the Palazzi of the Foscari and the Palazzo Balbi | Magnificentiores Selectioresque Urbis Venetiarum Prospectus 2657 | Printmaker 3654 | Michele Marieschi | Italian, Venice 1710–1743 Venice | Marieschi, Michele 18122 | Italian 6 | 1710 | 1743 | 1741 | 1741 | 1741 | Etching 26137 | Sheet: 15 3/8 × 19 7/8 in. (39 × 50.5 cm) Plate: 13 3/16 × 18 5/16 in. (33.5 × 46.5 cm) | Rogers Fund, 1969 | Prints 13 | http://www.metmuseum.org/art/collection/search/676361 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
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");