Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Object Name, Title, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Credit Line, 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 | Metadata Date | Repository |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
210817 | 210817 | 66.62.3 | 0 | 1 | 338203 | Drawings and Prints 11 | Drawing 23 | Architectural fantasy | Artist 2 | Attributed to | Jean Henri Alexandre Pernet | French, Paris 1763–after 1789 | Pernet, Jean Henry Alexandre 18983 | French 2 | 1763 | 1789 | late 18th century | 1775 | 1805 | Pen and black ink, watercolor 31431 | 9 in. (22.6 cm.) in diameter | Gift of Julian Clarence Levi, 1966 | Drawings 9 | http://www.metmuseum.org/art/collection/search/338203 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
213889 | 213889 | 69.683.4a, b | 0 | 1 | 341308 | Drawings and Prints 11 | Drawing 23 | Costume Design for "Andrey" [a]; Descriptive sheet of Accessories [b] | Artist 2 | Charles Bianchini | French, Lyons 1860–1905 Paris | Bianchini, Charles 19917 | French 2 | 1860 | 1905 | 1889 | 1889 | 1889 | Pen and black ink, watercolor 31431 | 12 3/8 x 9 7/16 in. (31.5 x 24.0 cm) | Gift of Robert R. Banks, 1969 | Drawings 9 | http://www.metmuseum.org/art/collection/search/341308 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
215772 | 215772 | 69.660.12 | 0 | 1 | 343197 | Drawings and Prints 11 | Drawing 23 | Designs for Arched Doorway | Artist 2 | Charles Monblond | French, 19th century | Monblond, Charles 20315 | French 2 | 1800 | 1900 | 19th century | 1800 | 1899 | Pen and black ink, watercolor 31431 | 10 1/8 x 5 1/2in. (25.7 x 14cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1969 | Drawings 9 | http://www.metmuseum.org/art/collection/search/343197 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
216081 | 216081 | 1970.736.66 | 0 | 1 | 343512 | Drawings and Prints 11 | Drawing Ornament & Architecture 13828 | Plan for a Menagerie | Artist 2 | Charles Percier | French, Paris 1764–1838 Paris | Percier, Charles 18276 | French 2 | 1764 | 1838 | ca. 1783 | 1778 | 1788 | Pen and black ink, watercolor 31431 | 20 5/8 x 17 15/16 in. (52.4 x 45.6 cm) | Gift of Mr. and Mrs. Charles Wrightsman, 1970 | Drawings|Ornament & Architecture 671 | http://www.metmuseum.org/art/collection/search/343512 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
217900 | 217900 | 67.827.67 | 0 | 1 | 345399 | Drawings and Prints 11 | Drawing 23 | Design for Salon Ceiling, Hôtel Candamo | Artist|Artist 13 | Jules-Edmond-Charles Lachaise|Eugène-Pierre Gourdet | French, died 1897|French, born Paris, 1820–1889 | Lachaise, Jules-Edmond-Charles|Gourdet, Eugène-Pierre 20300 | French|French 21 | 1897 |1820 | 1897 |1889 | ca. 1873 | 1868 | 1878 | Pen and black ink, watercolor 31431 | 7 7/8 x 12 3/8 in. (20 x 31.4 cm) | Dodge Fund, 1967 | Drawings 9 | http://www.metmuseum.org/art/collection/search/345399 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
217904 | 217904 | 67.827.68 | 0 | 1 | 345403 | Drawings and Prints 11 | Drawing 23 | Design for Wall Elevation, Hôtel Candamo | Artist|Artist 13 | Jules-Edmond-Charles Lachaise|Eugène-Pierre Gourdet | French, died 1897|French, born Paris, 1820–1889 | Lachaise, Jules-Edmond-Charles|Gourdet, Eugène-Pierre 20300 | French|French 21 | 1897 |1820 | 1897 |1889 | 1873 | 1873 | 1873 | Pen and black ink, watercolor 31431 | 10 11/16 x 14 7/8 in. (27.1 x 37.8 cm) | Dodge Fund, 1967 | Drawings 9 | http://www.metmuseum.org/art/collection/search/345403 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
217907 | 217907 | 67.827.69 | 0 | 1 | 345406 | Drawings and Prints 11 | Drawing 23 | Design for Grand Salon, Ground Floor, Hôtel Candamo | Artist|Artist 13 | Jules-Edmond-Charles Lachaise|Eugène-Pierre Gourdet | French, died 1897|French, born Paris, 1820–1889 | Lachaise, Jules-Edmond-Charles|Gourdet, Eugène-Pierre 20300 | French|French 21 | 1897 |1820 | 1897 |1889 | ca. 1873 | 1868 | 1878 | Pen and black ink, watercolor 31431 | 8 3/8 x 10 7/8 in. (21.3 x 27.6 cm) | Dodge Fund, 1967 | Drawings 9 | http://www.metmuseum.org/art/collection/search/345406 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
217912 | 217912 | 67.827.71 | 0 | 1 | 345411 | Drawings and Prints 11 | Drawing 23 | Design for Stable Arches, Hôtel Candamo | Artist|Artist 13 | Jules-Edmond-Charles Lachaise|Eugène-Pierre Gourdet | French, died 1897|French, born Paris, 1820–1889 | Lachaise, Jules-Edmond-Charles|Gourdet, Eugène-Pierre 20300 | French|French 21 | 1897 |1820 | 1897 |1889 | ca. 1873 | 1868 | 1878 | Pen and black ink, watercolor 31431 | 14 7/8 x 10 5/8 in. (37.8 x 27.0 cm) | Dodge Fund, 1967 | Drawings 9 | http://www.metmuseum.org/art/collection/search/345411 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
217916 | 217916 | 67.827.70 | 0 | 1 | 345415 | Drawings and Prints 11 | Drawing 23 | Design for Stable Arches, Hôtel Candamo | Artist|Artist 13 | Jules-Edmond-Charles Lachaise|Eugène-Pierre Gourdet | French, died 1897|French, born Paris, 1820–1889 | Lachaise, Jules-Edmond-Charles|Gourdet, Eugène-Pierre 20300 | French|French 21 | 1897 |1820 | 1897 |1889 | ca. 1873 | 1868 | 1878 | Pen and black ink, watercolor 31431 | 14 7/8 x 10 1/2 in. (37.8 x 26.7 cm) | Dodge Fund, 1967 | Drawings 9 | http://www.metmuseum.org/art/collection/search/345415 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
217920 | 217920 | 67.827.72 | 0 | 1 | 345419 | Drawings and Prints 11 | Drawing 23 | Design for Decorated "Sultan" Plaque for Stable Wall, Hôtel Candamo | Artist|Artist 13 | Jules-Edmond-Charles Lachaise|Eugène-Pierre Gourdet | French, died 1897|French, born Paris, 1820–1889 | Lachaise, Jules-Edmond-Charles|Gourdet, Eugène-Pierre 20300 | French|French 21 | 1897 |1820 | 1897 |1889 | ca. 1873 | 1868 | 1878 | Pen and black ink, watercolor 31431 | 9 1/4 x 14 1/4 in. (23.5 x 36.2 cm) | Dodge Fund, 1967 | Drawings 9 | http://www.metmuseum.org/art/collection/search/345419 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
218139 | 218139 | 67.827.58 | 0 | 1 | 345641 | Drawings and Prints 11 | Drawing 23 | Design for Bedroom Doors, Hôtel de Jagan | Artist|Artist 13 | Jules-Edmond-Charles Lachaise|Eugène-Pierre Gourdet | French, died 1897|French, born Paris, 1820–1889 | Lachaise, Jules-Edmond-Charles|Gourdet, Eugène-Pierre 20300 | French|French 21 | 1897 |1820 | 1897 |1889 | second half 19th century | 1850 | 1900 | Pen and black ink, watercolor 31431 | 12 13/16 x 6 15/16 in. (32.5 x 17.6 cm) | Dodge Fund, 1967 | Drawings 9 | http://www.metmuseum.org/art/collection/search/345641 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
218163 | 218163 | 67.827.113 | 0 | 1 | 345665 | Drawings and Prints 11 | Drawing 23 | Design for Trompe L'Oeil Ceiling for Dining Room, Hôtel de Trévise | Artist|Artist 13 | Jules-Edmond-Charles Lachaise|Eugène-Pierre Gourdet | French, died 1897|French, born Paris, 1820–1889 | Lachaise, Jules-Edmond-Charles|Gourdet, Eugène-Pierre 20300 | French|French 21 | 1897 |1820 | 1897 |1889 | 1850–1910 | 1850 | 1910 | Pen and black ink, watercolor 31431 | 6 3/8 x 12 3/4 in. (16.2 x 32.4 cm) | Dodge Fund, 1967 | Drawings 9 | http://www.metmuseum.org/art/collection/search/345665 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
218164 | 218164 | 67.827.88 | 0 | 1 | 345666 | Drawings and Prints 11 | Drawing 23 | Pompeiian Design for Paneling | Artist|Artist 13 | Jules-Edmond-Charles Lachaise|Eugène-Pierre Gourdet | French, died 1897|French, born Paris, 1820–1889 | Lachaise, Jules-Edmond-Charles|Gourdet, Eugène-Pierre 20300 | French|French 21 | 1897 |1820 | 1897 |1889 | second half 19th century | 1850 | 1900 | Pen and black ink, watercolor 31431 | 9 5/16 x 5 11/16 in. (23.6 x 14.4 cm) | Dodge Fund, 1967 | Drawings 9 | http://www.metmuseum.org/art/collection/search/345666 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
220045 | 220045 | 64.695.30 | 0 | 0 | 347573 | Drawings and Prints 11 | Drawing 23 | Harlem Cotton Club | Artist 2 | Tsuguharu Foujita | French (born Japan), Tokyo 1886–1968 Zurich | Foujita, Tsuguharu 20289 | French, born Japan 979 | 1886 | 1968 | 20th century | 1900 | 1968 | Pen and black ink, watercolor 31431 | 12 1/2 x 16 7/8 in. (31.8 x 42.8 cm) | Gift of Edna H. Sachs, 1964 | Drawings 9 | © 2018 Artists Rights Society (ARS), New York | http://www.metmuseum.org/art/collection/search/347573 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
227721 | 227721 | 1970.736.34 | 0 | 1 | 355341 | Drawings and Prints 11 | Drawing 23 | Cross-Section of the Temple of Jupiter, Pompeii | Former Attribution|Former Attribution|Artist 1101 | Formerly attributed to|Formerly attributed to | Charles Percier|Pierre François Léonard Fontaine|Anonymous, French, 19th century | French, Paris 1764–1838 Paris|French, Pontoise 1762–1853 Paris | Percier, Charles|Fontaine, Pierre François Léonard|Anonymous, French, 19th century 20319 | French|French|French 103 | 1764 |1762 |1800 | 1838 |1853 |1900 | after 1825 | 1825 | 1840 | Pen and black ink, watercolor 31431 | 9 3/8 x 15 7/8 in. (23.8 x 40.4 cm) | Gift of Mr. and Mrs. Charles Wrightsman, 1970 | Drawings 9 | http://www.metmuseum.org/art/collection/search/355341 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
234372 | 234372 | 1970.731.82 | 0 | 1 | 362128 | Drawings and Prints 11 | Drawing 23 | Joan of Arc; costume design for Jeanne d'Arc by the Paris Opera Company, 1897 | Artist 2 | Charles Bianchini | French, Lyons 1860–1905 Paris | Bianchini, Charles 19917 | French 2 | 1860 | 1905 | 1897 | 1897 | 1897 | Pen and black ink, watercolor 31431 | sheet: 12 5/16 x 9 7/16 in. (31.2 x 23.9 cm) | Gift of Dr. Adrian Lambert, 1970 | Drawings 9 | http://www.metmuseum.org/art/collection/search/362128 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
234428 | 234428 | 49.50.163 | 0 | 1 | 362184 | Drawings and Prints 11 | Drawing ; Ornament and architecture 13833 | Design for the Interior Elevation of a Theater | Artist 2 | Anonymous, French, 19th century | Anonymous, French, 19th century 18980 | French 2 | 1800 | 1900 | ca. 1800 | 1795 | 1805 | Pen and black ink, watercolor 31431 | sheet: 5 1/4 x 6 9/16 in. (13.4 x 16.6 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1949 | Drawings|Ornament & Architecture 671 | http://www.metmuseum.org/art/collection/search/362184 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
234429 | 234429 | 49.50.162 | 0 | 1 | 362185 | Drawings and Prints 11 | Drawing ; Ornament and architecture 13833 | Design for the Exterior of a Theater | Artist 2 | Anonymous, French, 19th century | Anonymous, French, 19th century 18980 | French 2 | 1800 | 1900 | ca. 1800 | 1795 | 1805 | Pen and black ink, watercolor 31431 | sheet: 5 1/4 x 6 9/16 in. (13.3 x 16.6 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1949 | Drawings|Ornament & Architecture 671 | http://www.metmuseum.org/art/collection/search/362185 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
235028 | 235028 | 56.559.3 | 0 | 1 | 362787 | Drawings and Prints 11 | Drawing 23 | Interior Elevation, Reims Cathedral | Artist|Artist 13 | Charles Percier|Pierre François Léonard Fontaine | French, Paris 1764–1838 Paris|French, Pontoise 1762–1853 Paris | Percier, Charles|Fontaine, Pierre François Léonard 18288 | French|French 21 | 1764 |1762 | 1838 |1853 | n.d. | 1775 | 1838 | Pen and black ink, watercolor 31431 | 29 15/16 x 17 1/16 in. (76 x 43.3 cm) | Gift of Lincoln Kirstein, 1956 | Drawings 9 | http://www.metmuseum.org/art/collection/search/362787 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
235029 | 235029 | 56.559.4 | 0 | 1 | 362788 | Drawings and Prints 11 | Drawing 23 | Interior Elevation with Statue of Louis II, Reims Cathedral | Artist|Artist 13 | Charles Percier|Pierre François Léonard Fontaine | French, Paris 1764–1838 Paris|French, Pontoise 1762–1853 Paris | Percier, Charles|Fontaine, Pierre François Léonard 18288 | French|French 21 | 1764 |1762 | 1838 |1853 | n.d. | 1775 | 1838 | Pen and black ink, watercolor 31431 | 29 15/16 x 18 1/16 in. (76 x 45.9 cm) | Gift of Lincoln Kirstein, 1956 | Drawings 9 | http://www.metmuseum.org/art/collection/search/362788 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
235030 | 235030 | 56.559.6 | 0 | 1 | 362789 | Drawings and Prints 11 | Drawing 23 | Elevation of the Royal Box for the Coronation of Louis XVIII, Reims Cathedral | Artist|Artist 13 | Charles Percier|Pierre François Léonard Fontaine | French, Paris 1764–1838 Paris|French, Pontoise 1762–1853 Paris | Percier, Charles|Fontaine, Pierre François Léonard 18288 | French|French 21 | 1764 |1762 | 1838 |1853 | n.d. | 1775 | 1838 | Pen and black ink, watercolor 31431 | 30 3/16 x 34 1/8 in. (76.6 x 86.6 cm) | Gift of Lincoln Kirstein, 1956 | Drawings 9 | http://www.metmuseum.org/art/collection/search/362789 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
235041 | 235041 | 24.66.1496 | 0 | 0 | 362800 | Drawings and Prints 11 | Drawing Ornament & Architecture 13828 | Plans for the Exterior and Floors of the Château de Bagatelle | Artist 2 | Pierre Lapie | French (1771–1850) | Lapie, Pierre 31946 | French 2 | 1771 | 1850 | 1817 | 1817 | 1817 | Pen and black ink, watercolor 31431 | sheet: 20 1/16 x 35 7/8 in. (51 x 91.2 cm) | Harris Brisbane Dick Fund, 1924 | Drawings|Ornament & Architecture 671 | http://www.metmuseum.org/art/collection/search/362800 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
235043 | 235043 | 24.66.1494 | 0 | 1 | 362802 | Drawings and Prints 11 | Drawing Ornament & Architecture 13828 | Plan for the Garden of the Château de Bagatelle | Artist 2 | Pierre Lapie | French (1771–1850) | Lapie, Pierre 31946 | French 2 | 1771 | 1850 | 1817 | 1817 | 1817 | Pen and black ink, watercolor 31431 | 20 1/2 x 36 1/4 in. (52 x 92.1 cm) | Harris Brisbane Dick Fund, 1924 | Drawings|Ornament & Architecture 671 | http://www.metmuseum.org/art/collection/search/362802 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
235044 | 235044 | 24.66.1495 | 0 | 0 | 362803 | Drawings and Prints 11 | Drawing Ornament & Architecture 13828 | Plan for the Ground level of the Château de Bagatelle | Artist 2 | Pierre Lapie | French (1771–1850) | Lapie, Pierre 31946 | French 2 | 1771 | 1850 | 1817 | 1817 | 1817 | Pen and black ink, watercolor 31431 | sheet: 20 3/8 x 36 5/16 in. (51.8 x 92.3 cm) | Harris Brisbane Dick Fund, 1924 | Drawings|Ornament & Architecture 671 | http://www.metmuseum.org/art/collection/search/362803 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
235993 | 235993 | 62.659.40 | 0 | 1 | 363836 | Drawings and Prints 11 | Drawing ; Ornament and architecture 13833 | An Italianate Villa | Artist 2 | Henry Edward Kendall Jr. | British, ca. 1805–1885 | Kendall, Henry Edward Jr. 32153 | British 7 | 1805 | 1885 | 1820–85 | 1820 | 1885 | Pen and black ink, watercolor 31431 | sheet: 12 3/8 x 16 3/8 in. (31.4 x 41.6 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1962 | Drawings|Ornament & Architecture 671 | http://www.metmuseum.org/art/collection/search/363836 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
235994 | 235994 | 1970.681.4 | 0 | 0 | 363837 | Drawings and Prints 11 | Drawing 23 | "Bare-limbed and Pipe in Hand..." – The Young King | Artist|Author 709 | Jessie Marion King|Oscar Wilde | British, New Kilpatrick, Dunbartonshire, Scotland 1875–1949 Kirkcudbright|Irish, Dublin 1854–1900 Paris | King, Jessie Marion|Wilde, Oscar 32154 | British, Scottish|Irish 762 | 1875 |1854 | 1949 |1900 | ca. 1915 | 1910 | 1920 | Pen and black ink, watercolor 31431 | sheet: 11 5/8 x 7 1/8 in. (29.6 x 18.1 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1970 | Drawings 9 | http://www.metmuseum.org/art/collection/search/363837 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
251672 | 251672 | 23.112.2062 | 0 | 1 | 380131 | Drawings and Prints 11 | Drawing 23 | Design for Phaeton, no. 897 | Manufacturer 20 | Brewster & Co. | American, New York | Brewster & Co. 32247 | American 1 | 1850–70 | 1850 | 1870 | Pen and black ink, watercolor 31431 | sheet: 6 x 8 7/8 in. (15.2 x 22.5 cm) | Gift of William Brewster, 1923 | Drawings 9 | http://www.metmuseum.org/art/collection/search/380131 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
391326 | 391326 | 2014.773 | 0 | 1 | 643063 | Drawings and Prints 11 | Drawing Ornament & Architecture 13828 | Design for the Gardens of the Château de Savigny-lès-Beaune | Artist 2 | Anonymous, French, 18th century | Anonymous, French, 18th century 19522 | French 2 | 1700 | 1800 | ca. 1782–90 | 1777 | 1787 | Pen and black ink, watercolor 31431 | Sheet: 19 11/16 × 29 1/8 in. (50 × 74 cm) | Edward Pearce Casey Fund, 2014 | Drawings|Ornament & Architecture 671 | http://www.metmuseum.org/art/collection/search/643063 | 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");