Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Highlight, Is Public Domain, Department, Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10859 | 10859 | 39.65.45 | 0 | 1 | 11859 | American Paintings and Sculpture 2 | Sculpture 100 | The Broncho Buster | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1895, revised 1909, cast by November 1910 | 1895 | 1909 | Bronze 23 | 32 1/4 x 27 1/4 x 15 in. (81.9 x 69.2 x 38.1 cm) | Bequest of Jacob Ruppert, 1939 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11859 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10860 | 10860 | 1986.81.2 | 0 | 1 | 11860 | American Paintings and Sculpture 2 | Sculpture 100 | The Broncho Buster | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1895, cast 1918 | 1895 | 1918 | Bronze 23 | 22 3/4 x 18 3/4 x 14 in. (57.8 x 47.6 x 35.6 cm) | Bequest of Helen R. Bleibtreu, 1985 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11860 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10861 | 10861 | 62.241.2 | 0 | 1 | 11861 | American Paintings and Sculpture 2 | Watercolor 198 | On the Head-Waters--Burgess Finding a Ford | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | ca. 1893 | 1890 | 1896 | Watercolor on paper 177 | 20 1/2 x 30 1/2 in. (52.1 x 77.5 cm) | Anonymous Gift, 1962 | Drawings 9 | http://www.metmuseum.org/art/collection/search/11861 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10862 | 10862 | 07.80 | 0 | 1 | 11862 | American Paintings and Sculpture 2 | Sculpture 100 | The Cheyenne | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1901, cast by March 1907 | 1901 | 1907 | Bronze 23 | 20 1/4 x 25 x 8 in. (51.4 x 63.5 x 20.3 cm) | Rogers Fund, 1907 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11862 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10863 | 10863 | 39.65.44a, b | 0 | 1 | 11863 | American Paintings and Sculpture 2 | Sculpture 100 | Coming Through the Rye | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1902, cast before 1939 | 1902 | 1938 | Bronze 23 | 27 1/4 x 30 x 26 1/4 in. (69.2 x 76.2 x 66.7 cm) | Bequest of Jacob Ruppert, 1939 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11863 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10864 | 10864 | 62.241.3 | 0 | 1 | 11864 | American Paintings and Sculpture 2 | Painting 69 | Pitched It Sheer into the River . . . Where It Still Is Seen in the Summer | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1889 | 1889 | 1889 | Oil on canvas 953 | 20 x 28 1/4in. (50.8 x 71.8cm) | Anonymous Gift, 1962 | Paintings 11 | http://www.metmuseum.org/art/collection/search/11864 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10865 | 10865 | 07.79 | 1 | 1 | 11865 | American Paintings and Sculpture 2 | Sculpture 100 | The Mountain Man | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1903, cast by March 1907 | 1903 | 1907 | Bronze 23 | 27 3/4 x 12 x 10 in. (70.5 x 30.5 x 25.4 cm) | Rogers Fund, 1907 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11865 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10866 | 10866 | 07.77 | 0 | 1 | 11866 | American Paintings and Sculpture 2 | Sculpture 100 | The Old Dragoons of 1850 | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1905, cast 1907 | 1905 | 1907 | Bronze 23 | 26 7/8 x 47 x 17 in. (68.3 x 119.4 x 43.2 cm) | Rogers Fund, 1907 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11866 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10867 | 10867 | 11.192 | 0 | 1 | 11867 | American Paintings and Sculpture 2 | Painting 69 | On the Southern Plains | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1907 | 1907 | 1907 | Oil on canvas 953 | 30 1/8 x 51 1/8in. (76.5 x 129.9cm) | Gift of Several Gentlemen, 1911 | Paintings 11 | http://www.metmuseum.org/art/collection/search/11867 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10868 | 10868 | 39.65.50a, b | 0 | 1 | 11868 | American Paintings and Sculpture 2 | Sculpture 100 | The Outlaw | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1906, cast before 1939 | 1906 | 1938 | Bronze 23 | 22 5/8 x 15 1/4 x 9 3/4 in. (57.5 x 38.7 x 24.8 cm) | Bequest of Jacob Ruppert, 1939 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11868 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10869 | 10869 | 39.65.43a, b | 0 | 1 | 11869 | American Paintings and Sculpture 2 | Sculpture 100 | The Rattlesnake | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1905, revised 1908; this cast, before 1939 | 1905 | 1938 | Bronze 23 | 23 1/8 x 17 3/4 x 14 1/2 in. (58.7 x 45.1 x 36.8 cm) | Bequest of Jacob Ruppert, 1939 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11869 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10870 | 10870 | 39.65.51a, b | 0 | 1 | 11870 | American Paintings and Sculpture 2 | Sculpture 100 | The Savage | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1908, cast ca. 1916 | 1908 | 1916 | Bronze 23 | 10 7/8 x 6 1/4 x 6 in. (27.6 x 15.9 x 15.2 cm) | Bequest of Jacob Ruppert, 1939 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11870 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10871 | 10871 | 39.65.49a, b | 0 | 1 | 11871 | American Paintings and Sculpture 2 | Sculpture 100 | The Scalp | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1898, cast before 1939 | 1898 | 1938 | Bronze 23 | 22 3/4 x 23 1/4 x 9 5/8 in. (57.8 x 59.1 x 24.4 cm) | Bequest of Jacob Ruppert, 1939 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11871 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10872 | 10872 | 39.65.52a, b | 0 | 1 | 11872 | American Paintings and Sculpture 2 | Sculpture 100 | The Sergeant | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1904, cast before 1939 | 1904 | 1938 | Bronze 23 | 10 3/8 x 5 1/4 x 4 in. (26.4 x 13.3 x 10.2 cm) | Bequest of Jacob Ruppert, 1939 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11872 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10873 | 10873 | 39.65.47a, b | 0 | 1 | 11873 | American Paintings and Sculpture 2 | Sculpture 100 | Trooper of the Plains | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1908, cast before 1939 | 1908 | 1938 | Bronze 23 | 24 5/8 x 25 1/2 x 8 1/4 in. (62.6 x 64.8 x 21 cm) | Bequest of Jacob Ruppert, 1939 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11873 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10874 | 10874 | 39.65.48a, b | 0 | 1 | 11874 | American Paintings and Sculpture 2 | Sculpture 100 | The Wicked Pony | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1898, cast before 1939 | 1898 | 1938 | Bronze 23 | 21 7/8 x 21 1/4 x 8 3/4 in. (55.6 x 54 x 22.2 cm) | Bequest of Jacob Ruppert, 1939 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11874 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
10875 | 10875 | 39.65.46a, b | 0 | 1 | 11875 | American Paintings and Sculpture 2 | Sculpture 100 | The Wounded Bunkie | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1896, cast before 1939 | 1896 | 1938 | Bronze 23 | 19 7/8 x 31 x 11 1/2 in. (50.5 x 78.7 x 29.2 cm) | Bequest of Jacob Ruppert, 1939 | Sculpture 12 | http://www.metmuseum.org/art/collection/search/11875 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
16986 | 16986 | L.2011.90.1 | 0 | 0 | 21072 | American Paintings and Sculpture 2 | Sculpture 100 | The Broncho Buster | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1895, cast by 1898 | 1895 | 1898 | Bronze 23 | 23 3/4 x 21 1/8 x 11 7/8 in. (60.3 x 53.7 x 30.2 cm) | Sagamore Hill National Historic Site, Oyster Bay, New York (SAHI-918) | Sculpture 12 | http://www.metmuseum.org/art/collection/search/21072 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
17040 | 17040 | SL.1.2013.8.4 | 0 | 0 | 21295 | American Decorative Arts 1 | Sculpture 100 | The Cheyenne | American 1 | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1901, cast by 1903 | 1901 | 1903 | Bronze 23 | 20 7/8 × 24 3/8 × 7 1/2 in. (53 × 61.9 × 19.1 cm) | Denver Art Museum, Funds from William D. Hewit Charitable Annuity Trust (1981.14) | Sculpture 12 | http://www.metmuseum.org/art/collection/search/21295 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
17069 | 17069 | SL.1.2013.14.1 | 0 | 0 | 21339 | American Decorative Arts 1 | Sculpture 100 | The Broncho Buster | American 1 | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1895, cast 1906 | 1895 | 1906 | Bronze 23 | 22 5/8 x 22 3/4 x 15 1/4 in. (57.5 x 57.8 x 38.7 cm) | The Museum of Fine Arts, Houston, The Hogg Brothers Collection, gift of Miss Ima Hogg (43.73) | Sculpture 12 | http://www.metmuseum.org/art/collection/search/21339 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
17070 | 17070 | SL.1.2013.30.3 | 0 | 0 | 21342 | American Decorative Arts 1 | Sculpture 100 | The Norther | American 1 | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1900 | 1900 | 1900 | Bronze 23 | 22 × 20 1/2 × 8 in. (55.9 × 52.1 × 20.3 cm) | The Rees-Jones Collection | Sculpture 12 | http://www.metmuseum.org/art/collection/search/21342 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
17077 | 17077 | SL.1.2013.3.1 | 0 | 0 | 21351 | American Decorative Arts 1 | Sculpture 100 | The Wounded Bunkie | American 1 | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1896, cast 1896 | 1896 | 1896 | Bronze 23 | 20 3/4 x 11 x 31 in. (52.7 x 27.9 x 78.7 cm) | Birmingham Museum of Art, Gift of Dr. and Mrs. Harold E. Simon (1973.148) | Sculpture 12 | http://www.metmuseum.org/art/collection/search/21351 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
17090 | 17090 | SL.1.2013.7.1 | 0 | 0 | 21375 | American Decorative Arts 1 | Painting 69 | Turn Him Loose, Bill | American 1 | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | ca. 1893 | 1888 | 1898 | Oil on canvas on masonite 3354 | 25 x 33 in. (63.5 x 83.8 cm) Framed: 32 1/4 × 40 1/4 × 2 1/4 in. (81.9 × 102.2 × 5.7 cm) | American Museum of Western Art—The Anschutz Collection, Denver (#0258) | Paintings 11 | http://www.metmuseum.org/art/collection/search/21375 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
412886 | 412886 | 2015.222 | 0 | 1 | 680855 | Drawings and Prints 11 | Print Poster 13847 | The Century: New Year's Number, January | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | American 1 | 1861 | 1909 | 1902 | 1902 | 1902 | Color lithograph 30750 | Sheet: 16 9/16 in. × 14 in. (42 × 35.5 cm) | Purchase, Leonard A. Lauder Gift, 2015 | Prints|Posters 666 | http://www.metmuseum.org/art/collection/search/680855 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
433864 | 433864 | 60.520.2 | 0 | 1 | 720504 | Drawings and Prints 11 | Print 731 | The Smoke Signal | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | 1861 | 1909 | 1923–60 | 1923 | 1960 | Color lithograph 30750 | Sheet: 17 1/2 × 25 1/4 in. (44.5 × 64.1 cm) | Gift of Mrs. Archer M. Huntington, 1960 | Prints 13 | http://www.metmuseum.org/art/collection/search/720504 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
445370 | 445370 | SL.36.2017.3.1 | 0 | 0 | 744935 | American Paintings and Sculpture 2 | Drawing 23 | Sketch for The Portage Sleigh on a Lumber Road | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | 1861 | 1909 | 1889 | 1889 | 1889 | Pencil on paper 3177 | 10 1/4 × 14 1/2 in. (26 × 36.8 cm) | Frederic Remington Art Museum, Ogdensburg, N.Y. (Public Library Collection) | Drawings 9 | http://www.metmuseum.org/art/collection/search/744935 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
445371 | 445371 | SL.36.2017.1.1 | 0 | 0 | 744936 | American Paintings and Sculpture 2 | Drawing 23 | Lin McLean | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | 1861 | 1909 | 1897 | 1897 | 1897 | Ink, wash, and gouache on paper 62274 | 17 5/8 × 11 3/8 in. (44.8 × 28.9 cm) Framed: 21 3/8 × 15 1/4 in. (54.3 × 38.7 cm) | The Rockwell Museum, Corning, N.Y. | Drawings 9 | http://www.metmuseum.org/art/collection/search/744936 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
449196 | 449196 | SL.36.2017.2.1 | 0 | 0 | 752039 | American Paintings and Sculpture 2 | Painting 69 | Standing Off Indians | Artist 2 | Frederic Remington | American, Canton, New York 1861–1909 Ridgefield, Connecticut | Remington, Frederic 1710 | 1861 | 1909 | ca. 1888 | 1883 | 1893 | Oil on board 1756 | Framed: 23 × 29 in. (58.4 × 73.7 cm) Unframed: 18 × 24 in. (45.7 × 61 cm) | Private collection | Paintings 11 | http://www.metmuseum.org/art/collection/search/752039 | 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");