Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Object Name, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Object Date, Object Begin Date, Object End Date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
166898 | 166898 | 47.50.19 | 0 | 0 | 269160 | Photographs 13 | Photograph 997 | [Man and Child Holding U.S. Flag] | Artist 2 | Unknown | American | Unknown 1237 | 1850s, printed 1858 | 1850 | 1859 | Ambrotype with applied color 26239 | 8.8 x 5.6 cm. (3 7/16 x 2 3/16 in.) | Gift of Constance P. Brown, 1947 | Photographs 21 | http://www.metmuseum.org/art/collection/search/269160 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
166903 | 166903 | 47.50.23 | 0 | 0 | 269165 | Photographs 13 | Photograph 997 | [Young Woman] | Artist 2 | Unknown | American | Unknown 1237 | 1850s–60s | 1850 | 1869 | Ambrotype with applied color 26239 | 6.6 x 5.4 cm. (2 5/8 x 2 1/8 in.) | Gift of Constance P. Brown, 1947 | Photographs 21 | http://www.metmuseum.org/art/collection/search/269165 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
166904 | 166904 | 47.50.24a–c | 0 | 0 | 269166 | Photographs 13 | Photograph 997 | [Young Child in a Cape, Woman in Lace Collar, Man with Moustache (Wm. E. Pine?)] | Artist 2 | Unknown | American | Unknown 1237 | ca. 1859 | 1857 | 1861 | Ambrotype with applied color 26239 | Plate A: 6.5 x 5.2cm (2 9/16 x 2 1/16in.) Plate B: 5.1 x 3.9 cm. (2 x 1 9/16 in.) Plate C: 5.1 x 3.9 cm. (2 x 1 9/16 in.) Case: 18.4 × 14.3 cm (7 1/4 × 5 5/8 in.) | Gift of Constance P. Brown, 1947 | Photographs 21 | http://www.metmuseum.org/art/collection/search/269166 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
166905 | 166905 | 47.50.25 | 0 | 0 | 269169 | Photographs 13 | Photograph 997 | [Young Child on a Chair] | Artist 2 | Unknown | American | Unknown 1237 | 1850s–60s | 1850 | 1869 | Ambrotype with applied color 26239 | 6.4 x 5.0 cm. (2 1/2 x 2 in.) | Gift of Constance P. Brown, 1947 | Photographs 21 | http://www.metmuseum.org/art/collection/search/269169 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
166907 | 166907 | 47.50.4 | 0 | 0 | 269171 | Photographs 13 | Photograph 997 | Sophronia Belle Hinkley Pine and Daughter Cornelia ("Nellie") | Artist 2 | Unknown | American | Unknown 1237 | ca. 1858 | 1856 | 1860 | Ambrotype with applied color 26239 | 6.2 x 5.0 cm (2 7/16 x 2 in.) | Gift of Constance P. Brown, 1947 | Photographs 21 | http://www.metmuseum.org/art/collection/search/269171 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
166908 | 166908 | 47.50.5 | 0 | 0 | 269172 | Photographs 13 | Photograph 997 | Sophronia Belle Hinkley Pine | Artist 2 | Unknown | American | Unknown 1237 | 1850s–60s | 1850 | 1869 | Ambrotype with applied color 26239 | 6.8 x 5.5 cm. (2 11/16 x 2 3/16 in.) | Gift of Constance P. Brown, 1947 | Photographs 21 | http://www.metmuseum.org/art/collection/search/269172 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
166909 | 166909 | 47.50.6 | 0 | 0 | 269173 | Photographs 13 | Photograph 997 | Emily Pine | Artist 2 | Unknown | American | Unknown 1237 | 1860s | 1860 | 1869 | Ambrotype with applied color 26239 | 6.4 x 5.0 cm. (2 1/2 x 2 in.) | Gift of Constance P. Brown, 1947 | Photographs 21 | http://www.metmuseum.org/art/collection/search/269173 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
169601 | 169601 | 47.37.19 | 0 | 0 | 271928 | Photographs 13 | Photograph 997 | [Girl in Dotted Dress] | Maker|Artist 39 | Case manufactured by | Wadham's Manufacturing Co.|Unknown | American, active ca. 1858–65|American | Wadham's Manufacturing Co.|Unknown 15261 | American 1 | 1858 | 1865 | ca. 1858 | 1857 | 1859 | Ambrotype with applied color 26239 | 5.2 x 4 cm (2 1/16 x 1 9/16 in.) visible, oval | Gift of Miss Georgia W. Bellinger | Photographs 21 | http://www.metmuseum.org/art/collection/search/271928 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
169603 | 169603 | 47.46.5 | 0 | 0 | 271930 | Photographs 13 | Photograph 997 | [Man with Fife] | Artist 2 | Unknown | American | Unknown 1237 | 1851–65 | 1851 | 1865 | Ambrotype with applied color 26239 | 6.9 x 5.6 cm (2 11/16 x 2 3/16 in.) visible, nonpareil | Gift of Eva Kasiska, 1947 | Photographs 21 | http://www.metmuseum.org/art/collection/search/271930 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
169622 | 169622 | 47.46.64 | 0 | 0 | 271949 | Photographs 13 | Photograph 997 | [Three Men Raising Drinking Glasses] | Artist 2 | Unknown | American | Unknown 1237 | 1851–55 | 1851 | 1865 | Ambrotype with applied color 26239 | 6.9 x 9.2 cm (2 11/16 x 3 5/8 in.) visible, nonpareil | Gift of Eva Kasiska, 1947 | Photographs 21 | http://www.metmuseum.org/art/collection/search/271949 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
178669 | 178669 | 1998.153 | 0 | 0 | 282242 | Photographs 13 | Photograph; Ambrotype 13052 | [Pacific Island Couple] | Artist 2 | Unknown | Unknown 1237 | ca. 1860 | 1858 | 1862 | Ambrotype with applied color 26239 | 8.3 x 10.8 cm (3 1/4 x 4 1/4 in. ) | Purchase, The Horace W. Goldsmith Foundation Gift through Joyce and Robert Menschel, by exchange and Rogers Fund, 1998 | Photographs 21 | http://www.metmuseum.org/art/collection/search/282242 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
179369 | 179369 | 68.552.2 | 0 | 0 | 282948 | Photographs 13 | Photograph 997 | [Clara Friedrich] | Artist 2 | Unknown | Unknown 1237 | 1850s | 1850 | 1859 | Ambrotype with applied color 26239 | 8.1 x 6.6 cm (3 3/16 x 2 5/8 in. ) visible | Gift of Mr. and Mrs. F.S. Sander, 1968 | Photographs 21 | http://www.metmuseum.org/art/collection/search/282948 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
180197 | 180197 | 55.578.20 | 0 | 0 | 283784 | Photographs 13 | Photograph 997 | [Boy; Woman; Girl; Girl] | Artist 2 | Unknown | American | Unknown 1237 | 1850s–60s | 1850 | 1869 | Ambrotype with applied color 26239 | 6.4 x 5.0 cm (2 1/2 x 1 15/16 in. ) each | Bequest of Helen W.D. Mileham, 1955 | Photographs 21 | http://www.metmuseum.org/art/collection/search/283784 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
180224 | 180224 | 1982.1131 | 0 | 0 | 283813 | Photographs 13 | Photograph 997 | [Woman] | Artist 2 | Unknown | American | Unknown 1237 | 1850s–60s | 1850 | 1869 | Ambrotype with applied color 26239 | 8.8 x 6.6cm (3 7/16 x 2 5/8in.), oval, visible | Gift of Monroe I. Warshaw, 1982 | Photographs 21 | http://www.metmuseum.org/art/collection/search/283813 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
180234 | 180234 | 62.665 | 0 | 0 | 283823 | Photographs 13 | Photograph 997 | [Man with Over-the-Shoulder Saxhorn] | Artist 2 | Unknown | American | Unknown 1237 | 1850s–80s | 1850 | 1889 | Ambrotype with applied color 26239 | 8.8 x 6.3 cm (3 7/16 x 2 1/2 in. ) visible | Gift of David Belcher, 1962 | Photographs 21 | http://www.metmuseum.org/art/collection/search/283823 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
180463 | 180463 | X.729 | 0 | 0 | 284065 | Photographs 13 | Photograph 997 | [Woman and Child in Loose-Fitting Printed Dresses] | Maker|Artist 39 | Case manufactured by | S. Peck and Co.|Unknown | American | S. Peck and Co.|Unknown 15862 | 1850s | 1850 | 1859 | Ambrotype with applied color 26239 | 7 x 5.6 cm (2 3/4 x 2 3/16 in.) | Museum Accession | Photographs 21 | http://www.metmuseum.org/art/collection/search/284065 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
186621 | 186621 | 2015.400.110 | 0 | 1 | 291910 | Photographs 13 | Ambrotype 13100 | [Man Riving Wood with Froe and Club] | Artist 2 | Unknown | American | Unknown 1237 | 1860s | 1860 | 1869 | Ambrotype with applied color 26239 | Image: 6.9 x 5.5 cm (2 11/16 x 2 3/16 in.) Plate: 8.3 x 7 cm (3 1/4 x 2 3/4 in.) Case: 1.1 x 9.2 x 7.9 cm (7/16 x 3 5/8 x 3 1/8 in.) | Bequest of Herbert Mitchell, 2008 | Photographs 21 | http://www.metmuseum.org/art/collection/search/291910 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
186622 | 186622 | 2015.400.111 | 0 | 1 | 291911 | Photographs 13 | Ambrotype 13100 | [Bearded Plasterer with Hawk and Trowel] | Artist 2 | Unknown | American | Unknown 1237 | 1860s | 1860 | 1869 | Ambrotype with applied color 26239 | Image: 6.4 x 5.1 cm (2 1/2 x 2 in.) Plate: 8.3 x 7 cm (3 1/4 x 2 3/4 in.) Case: 1.6 x 9.4 x 7.9 cm (5/8 x 3 11/16 x 3 1/8 in.) | Bequest of Herbert Mitchell, 2008 | Photographs 21 | http://www.metmuseum.org/art/collection/search/291911 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
186628 | 186628 | 2015.400.113 | 0 | 1 | 291917 | Photographs 13 | Ambrotype 13100 | [Painter Dipping Brush into Paint Jug] | Artist 2 | Unknown | American | Unknown 1237 | late 1850s–60s | 1858 | 1865 | Ambrotype with applied color 26239 | Image: 8.9 x 6.9 cm (3 1/2 x 2 11/16 in.) Plate: 10.8 x 8.2 cm (4 1/4 x 3 1/4 in.) Case: 1.9 x 11.9 x 9.4 cm (3/4 x 4 11/16 x 3 11/16 in.) | Bequest of Herbert Mitchell, 2008 | Photographs 21 | http://www.metmuseum.org/art/collection/search/291917 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
186647 | 186647 | 2015.400.97 | 0 | 1 | 291936 | Photographs 13 | Ambrotype 13100 | [Union Militia Soldier with Rifled Musket] | Artist 2 | Unknown | American | Unknown 1237 | 1860s | 1860 | 1869 | Ambrotype with applied color 26239 | Image: 9 x 6.4 cm (3 9/16 x 2 1/2 in.) Plate: 10.8 x 8.3 cm (4 1/4 x 3 1/4 in.) Case: 1.9 x 11.9 x 9.5 cm (3/4 x 4 11/16 x 3 3/4 in.) | Bequest of Herbert Mitchell, 2008 | Photographs 21 | http://www.metmuseum.org/art/collection/search/291936 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
186649 | 186649 | 2015.400.99 | 0 | 1 | 291938 | Photographs 13 | Ambrotype 13100 | [Two Women Wearing Striped Dresses, One Standing, the Other Seated] | Artist 2 | Unknown | British | Unknown 1237 | 1850s–1860s | 1854 | 1869 | Ambrotype with applied color 26239 | Image: 10.6 x 8 cm (4 3/16 x 3 1/8 in.) Plate: 12.7 x 10.2 cm (5 x 4 in.) Case: 2.1 x 13.8 x 11.3 cm (13/16 x 5 7/16 x 4 7/16 in.) | Bequest of Herbert Mitchell, 2008 | Photographs 21 | http://www.metmuseum.org/art/collection/search/291938 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
186650 | 186650 | 2015.400.100 | 0 | 1 | 291939 | Photographs 13 | Ambrotype 13100 | [Plasterer in Oilskin Hat] | Artist 2 | Unknown | American | Unknown 1237 | 1850s–1860s | 1854 | 1869 | Ambrotype with applied color 26239 | Image: 11.7 x 8.8 cm (4 5/8 x 3 7/16 in.) Plate: 14 x 10.8 cm (5 1/2 x 4 1/4 in.) Case: 2.4 x 15.1 x 12.1 cm (15/16 x 5 15/16 x 4 3/4 in.) | Bequest of Herbert Mitchell, 2008 | Photographs 21 | http://www.metmuseum.org/art/collection/search/291939 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
186651 | 186651 | 2015.400.101 | 0 | 1 | 291940 | Photographs 13 | Ambrotype 13100 | [Nude Man Squatting on Chair] | Artist 2 | Unknown | American | Unknown 1237 | 1850s–1860s | 1850 | 1869 | Ambrotype with applied color 26239 | Image: 5 x 3.8 cm (1 15/16 x 1 1/2 in.) Plate: 6.4 x 5.1 cm (2 1/2 x 2 in.) Case: 1.4 x 7.6 x 6.2 cm (9/16 x 3 x 2 7/16 in.) | Bequest of Herbert Mitchell, 2008 | Photographs 21 | http://www.metmuseum.org/art/collection/search/291940 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
186652 | 186652 | 2015.400.102 | 0 | 1 | 291941 | Photographs 13 | Ambrotype 13100 | [Three Carpenters, Standing, Holding a Ruler, Hammer, and Sheet of Paper] | Artist 2 | Unknown | American | Unknown 1237 | 1850s–1860s | 1854 | 1869 | Ambrotype with applied color 26239 | Image: 7.3 x 6 cm (2 7/8 x 2 3/8 in.) Plate: 8.3 x 7 cm (3 1/4 x 2 3/4 in.) Case: 1 x 9.4 x 8.1 cm (3/8 x 3 11/16 x 3 3/16 in.) | Bequest of Herbert Mitchell, 2008 | Photographs 21 | http://www.metmuseum.org/art/collection/search/291941 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
186654 | 186654 | 2015.400.104 | 0 | 1 | 291943 | Photographs 13 | Ambrotype 13100 | [Man Holding Book, Standing Before a Painted Scenic Backdrop] | Artist 2 | Unknown | British | Unknown 1237 | 1850s–1860s | 1854 | 1869 | Ambrotype with applied color 26239 | Image: 15 x 10.7 cm (5 7/8 x 4 3/16 in.) Plate: 16.5 x 12.1 cm (6 1/2 x 4 3/4 in.) Case: 1.9 x 17.8 x 13.3 cm (3/4 x 7 x 5 1/4 in.) | Bequest of Herbert Mitchell, 2008 | Photographs 21 | http://www.metmuseum.org/art/collection/search/291943 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
186655 | 186655 | 2015.400.105 | 0 | 1 | 291944 | Photographs 13 | Ambrotype 13100 | [Two Men, One in Military Garb, and a Woman, Seated Around a Table] | Artist 2 | Unknown | American | Unknown 1237 | 1860s | 1860 | 1869 | Ambrotype with applied color 26239 | Image: 8.8 x 12 cm (3 7/16 x 4 3/4 in.) Plate: 10.8 x 14 cm (4 1/4 x 5 1/2 in.) Case: 2.2 x 12.1 x 15.1 cm (7/8 x 4 3/4 x 5 15/16 in.) | Bequest of Herbert Mitchell, 2008 | Photographs 21 | http://www.metmuseum.org/art/collection/search/291944 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
186657 | 186657 | 2015.400.107 | 0 | 1 | 291946 | Photographs 13 | Ambrotype 13100 | [Mother and Father with Three Children, a Boy and Two Girls] | Artist 2 | Unknown | American | Unknown 1237 | 1850s–1860s | 1854 | 1869 | Ambrotype with applied color 26239 | Image: 9 x 11.7 cm (3 9/16 x 4 5/8 in.) Plate: 10.9 x 14 cm (4 5/16 x 5 1/2 in.) Case: 1.9 x 12.4 x 15.6 cm (3/4 x 4 7/8 x 6 1/8 in.) | Bequest of Herbert Mitchell, 2008 | Photographs 21 | http://www.metmuseum.org/art/collection/search/291946 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
186659 | 186659 | 2015.400.109 | 0 | 1 | 291948 | Photographs 13 | Ambrotype 13100 | [Carpenter in Top Hat with Hatchet, Compass, Square, and Hand Saw] | Artist 2 | Unknown | American | Unknown 1237 | 1850s–1860s | 1854 | 1869 | Ambrotype with applied color 26239 | Image: 6.6 x 5.3 cm (2 5/8 x 2 1/16 in.) Plate: 8.3 x 7 cm (3 1/4 x 2 3/4 in.) Case: 1.1 x 9.1 x 7.9 cm (7/16 x 3 5/8 x 3 1/8 in.) | Bequest of Herbert Mitchell, 2008 | Photographs 21 | http://www.metmuseum.org/art/collection/search/291948 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
187000 | 187000 | SL.17.2012.45.2 | 0 | 0 | 294844 | Photographs 13 | Photograph 997 | [Family] | Artist 2 | Robert H. Vance | American, died 1876 | Vance, Robert H. 15752 | 1876 | 1876 | 1855 | 0 | 0 | Ambrotype with applied color 26239 | Case: 14 x 10.8 cm (5 1/2 x 4 1/4 in.) | The Isenburg Collection at AMC Toronto | Photographs 21 | http://www.metmuseum.org/art/collection/search/294844 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
187141 | 187141 | 2011.474 | 0 | 1 | 299307 | Photographs 13 | Photograph 997 | [Union Soldier Holding Rifle, with Photographer's Posing Stand] | Artist 2 | Unknown | American | Unknown 1237 | 1861–65 | 1861 | 1865 | Ambrotype with applied color 26239 | Visible: 8.7 x 6.5 cm (3 7/16 x 2 9/16 in.), oval Passe-partout: 10.7 x 8.2 cm (4 3/16 x 3 1/4 in.) Frame: 16.5 x 14 cm (6 1/2 x 5 1/2 in.) | The Horace W. Goldsmith Foundation Fund, through Joyce and Robert Menschel, 2011 | Photographs 21 | http://www.metmuseum.org/art/collection/search/299307 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
187318 | 187318 | 2012.504 | 0 | 1 | 301903 | Photographs 13 | Ambrotype 13100 | [Union Officer Standing at Attention] | Artist 2 | Unknown | American | Unknown 1237 | 1861–65 | 1861 | 1865 | Ambrotype with applied color 26239 | Image: 10.8 x 8.3 cm (4 1/4 x 3 1/4 in.) Case: 12 × 9.7 cm (4 3/4 × 3 13/16 in.) | Anonymous Gift, 2012 | Photographs 21 | http://www.metmuseum.org/art/collection/search/301903 | 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");