MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

25 rows where County = 118

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Highlight, Is Public Domain, Department, Object Name, Title, Culture, 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, Medium, Credit Line, City, Country, 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
17419 17419 96.5.36 0 0 21921 Arms and Armor 5 Flintlock duelling pistol 1313 Flintlock Duelling Pistol American, Middletown, Connecticut 110         Gunsmith 96   Simeon North American, Middletown, Connecticut, 1765–1852   North Simeon 2676 American 1 1765 1852 ca. 1815–20 1790 1845 Steel, gold, silver, wood (walnut, hickory), horn 3493 L. 15 3/4 in. (40.01 cm); L. of barrel 10 in. (25.4 cm); Cal. .56 in. (14.2 mm); Wt. 2 lb. 2 oz. (964 g) John Stoneacre Ellis Collection, Gift of Mrs. Ellis and Augustus Van Horne Ellis, 1896   Middletown 34   Connecticut 118               Firearms-Pistols 38   http://www.metmuseum.org/art/collection/search/21921 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20265 20265 48.125 0 1 24794 Arms and Armor 5 Percussion revolver 2242 Colt Dragoon Percussion Revolver, Third Model, serial no. 13096 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1853 1853 1853 Steel, brass, silver, wood (walnut) 4325 L. 14 3/4 in. (37.47 cm); L. of barrel 7 1/2 in. (19.05 cm); Cal. .45 in. (11.4 mm) Purchase, Friends of Albert Foster Jr. Gifts, in his memory, 1948   Hartford 26   Connecticut 118               Firearms-Pistols-Percussion 96   http://www.metmuseum.org/art/collection/search/24794 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20307 20307 55.206.2 0 1 24836 Arms and Armor 5 Percussion revolver 2242 Colt Model 1861 Navy Percussion Revolver, serial no. 12240 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1863 1863 1863 Steel, brass, wood (walnut) 4339 L. 12 3/4 in. (32.39 cm); L. of barrel 7 1/2 in. (19.05 cm); Cal. .36 in. (9.1 mm) Gift of John E. Parsons, 1955   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   http://www.metmuseum.org/art/collection/search/24836 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20310 20310 56.167.2 0 1 24839 Arms and Armor 5 Percussion revolver 2242 Colt Dragoon Percussion Revolver, Third Model, serial no. 12403 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1852 1852 1852 Steel, brass, silver, wood (walnut) 4325 L. 14 in. (35.56 cm); L. of barrel 7 1/2 in. (19.05 cm); Cal. .44 in. (11 mm) Gift of John E. Parsons, 1956   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   http://www.metmuseum.org/art/collection/search/24839 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20311 20311 58.171.3 0 1 24840 Arms and Armor 5 Revolver 2256 Colt Model 1851 Navy Revolver with Thuer Conversion for Self-Contained Cartridges, Serial no. 27060 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1853; converted for cartidges, ca. 1868–71 1853 1896 Steel, brass, silver, ivory 4340 L. 13 in. (33.02 cm); L. of barrel 7 1/2 in. (19.05 cm); Cal. .36 in. (9 mm) Gift of John E. Parsons, 1958   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   http://www.metmuseum.org/art/collection/search/24840 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20313 20313 57.166.2a–e 0 1 24842 Arms and Armor 5 Percussion revolver with case and accessories 2255 Colt Model 1855 Pocket Percussion Revolver, Serial no. 4460, with Case and Accessories American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1855 1855 1855 Steel, wood (oak) 4171 L. 7 7/8 in. (19.99 cm); L. of barrel 3 1/2 in. (8.89 cm); Cal. .28 in. (7 mm); case 9 3/8 x 5 3/4 x 1 7/8 in. (23.8 x 14.61 x 4.75 cm); L. of spanner-screwdriver 3 1/4 in. (8.26 cm); greatest W. of spanner-screwdriver 1 3/8 in. (3.48 cm); L. of primer 4 5/8 in. (11.73 cm); greatest W. of primer 2 in. (5.08 cm); L. of bullet mould 4 3/8 in. (11.1 cm) Gift of John E. Parsons, 1957   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   http://www.metmuseum.org/art/collection/search/24842 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20315 20315 58.171.1 0 1 24844 Arms and Armor 5 Percussion revolver 2242 Colt Walker Percussion Revolver, serial no. 1017 American, Whitneyville, Connecticut 361         Designer|Engraver|Designer|Manufacturer 143   Samuel Colt|Waterman Lilly Ormsby|Captain Samuel Hamilton Walker|Eli Whitney Jr. American, Hartford, Connecticut 1814–1862|American, Hampton, Connecticut 1809–1883 Brooklyn, New York|American, died 1847|American, 1820–1888   Colt, Samuel|Ormsby, Waterman Lilly|Walker, Samuel Hamilton Captain|Whitney, Eli Jr. 2896 American|American|American|American 97 1814 |1809 |1747 |1820 1862 |1883 |1847 |1888 1847 1847 1847 Steel, brass, wood (walnut) 4339 L. 15 1/2 in. (39.37 cm); L. of barrel 9 in. (22.86 cm); Cal. .44 in. (11 mm) Gift of John E. Parsons, 1958   Whitneyville 516   Connecticut 118               Firearms-Pistols-Revolvers 133   http://www.metmuseum.org/art/collection/search/24844 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20319 20319 59.143.4 0 1 24848 Arms and Armor 5 Revolver 2256 "Peacemaker" Colt Single-Action Army Revolver, serial no. 4519 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1874 1874 1874 Steel, iron, wood 3504 L.13 in. (33.02 cm); L. of barrel 7 1/2 in. (19.05 cm); Cal. .45 in. (11 mm) Gift of John E. Parsons, 1959   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   http://www.metmuseum.org/art/collection/search/24848 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20325 20325 68.157.1 0 1 24854 Arms and Armor 5 Percussion revolver 2242 Colt Model 1849 Pocket Percussion Revolver, Serial no. 81015 American, Hartford, Connecticut 350         Engraver|Manufacturer 144   Gustave Young|Samuel Colt American (born Prussia), 1827–1895 Springfield, Massachusetts|American, Hartford, Connecticut 1814–1862   Young, Gustave|Colt, Samuel 2899 American, born Prussia|American 99 1827 |1814 1895 |1862 ca. 1853 1828 1878 Steel, brass, silver, ivory 4340 L. of barrel 6 in. (15.24 cm); Cal. .32 in. (8 mm) Gift of John E. Parsons, 1968   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   http://www.metmuseum.org/art/collection/search/24854 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20326 20326 68.157.2 0 1 24855 Arms and Armor 5 Percussion revolver 2242 Colt Model 1851 Navy Percussion Revolver, serial no. 2 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1850 1850 1850 Steel, brass, silver, wood (walnut) 4325 L. of barrel 7 1/2 in. (19.05 cm); Cal. .38 in. (10 mm) Gift of John E. Parsons, 1968   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   http://www.metmuseum.org/art/collection/search/24855 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20361 20361 1983.442a–o 0 1 24892 Arms and Armor 5 Percussion revolver with case and accessories 2255 Cased Colt Model 1860 Army Percussion Revolver, Serial no. 7569, with Accessories American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1861 1861 1861 Steel, brass, silver, gold, wood (mahogany), textile 4366 L. 14 1/2 in. (36.83 cm); L. of barrel 8 in. (20.32 cm); Cal. .44 in. (11 mm) Gift of Mr. and Mrs. Jerry D. Berger, 1983   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   http://www.metmuseum.org/art/collection/search/24892 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20408 20408 1990.137a–j 0 1 24941 Arms and Armor 5 Percussion revolver with case 2300 Cased Six-Barreled Revolving Percussion Pistol ("Pepperbox") American, Norwich, Connecticut 381         Manufacturer|Manufacturer 19   Ethan Allen|Charles T. Thurber American, 1808–1871|American, active 1837–55   Allen|Thurber, Charles T. 2921 American|American 5 1808 |1837 1871 |1855 1842–47 1842 1847 Steel, gold, silver, ivory, wood (rosewood), velvet 4388 L. of pistol 7 in. (17.78 cm); case 12 15/16 x 8 3/16 x 2 5/8 in. (32.84 x 20.78 x 6.65 cm) Gift of Eric Vaule, 1990   Norwich 5   Connecticut 118               Firearms-Pistols-Percussion 96   http://www.metmuseum.org/art/collection/search/24941 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20427 20427 1995.336 1 1 24960 Arms and Armor 5 Percussion revolver 2242 Colt Third Model Dragoon Percussion Revolver, Serial Number 12406 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 ca. 1853 1828 1878 Steel, brass, gold, wood (walnut) 4396 L. 14 in. (35.6 cm); L. of barrel 7 1/2 in. (19.1 cm); Cal. .44 in. (11.2 mm); case; H. 3 in. (7.6 cm); W. 16 3/16 in. (41.1 cm); D. 8 1/8 in. (20.6 cm); Wt. 3 lb. 9.8 oz. (224 g) Gift of George and Butonne Repaire, 1995   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   http://www.metmuseum.org/art/collection/search/24960 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20498 20498 96.5.149 0 0 25035 Arms and Armor 5 Flintlock duelling pistol 1313 Flintlock Duelling Pistol American, Middletown, Connecticut 110         Gunsmith 96   Simeon North American, Middletown, Connecticut, 1765–1852   North Simeon 2676 American 1 1765 1852 ca. 1815–20 1790 1845 Steel, gold, silver, wood (walnut, hickory), horn 3493 L. 15 3/4 in. (40 cm); L. of barrel 10 in. (25.4 cm); Cal. .56 in. (14.2 mm); Wt. 2 lb. (907 g) John Stoneacre Ellis Collection, Gift of Mrs. Ellis and Augustus Van Horne Ellis, 1896   Middletown 34   Connecticut 118               Firearms-Pistols-Flintlock 41   http://www.metmuseum.org/art/collection/search/25035 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22589 22589 53.187 0 1 27500 Arms and Armor 5 Halberd 1309 Halberd American, Connecticut 621                           ca. 1620 1595 1645 Steel, wood 82 L. 87 in. (221 cm); L. of head 18 1/4 in. (46.4 cm); W. 9 5/16 in. (23.7 cm); Wt. 3 lbs. 13.5 oz. (1743.5 g) Bequest of Mellicent Blair, 1953       Connecticut 118               Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/27500 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
30174 30174 2010.481a–l 0 1 35690 Arms and Armor 5 Percussion revolver with case and accessories 2255 Colt Model 1851 Navy Percussion Revolver, Serial Number 29705, with Case and Accessories American, Hartford, Connecticut 350         Engraver|Manufacturer 144 Engraved by Gustave Young|Samuel Colt American (born Prussia), 1827–1895 Springfield, Massachusetts|American, Hartford, Connecticut 1814–1862   Young, Gustave|Colt, Samuel 2899 American, born Prussia|American 99 1827 |1814 1895 |1862 ca. 1853–54 1828 1879 Steel, brass, silver, wood, copper, tin, lead, paper 7190 L. of pistol 13 in. (33 cm); L. of barrel 7 1/2 in. (19 cm); Cal. .36 in. (9 mm); case: 14 1/4 x 6 3/8 x 2 1/4 in. (36.2 x 16.2 x 5.6 cm) Gift of Jack Sayre, 2010   Hartford 26   Connecticut 118               Firearms-Pistols-Percussion 96   http://www.metmuseum.org/art/collection/search/35690 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
30256 30256 96.5.36, .149 0 1 35815 Arms and Armor 5 Pair of flintlock duelling pistols 3847 Pair of Flintlock Duelling Pistols American, Middletown, Connecticut 110         Gunsmith 96   Simeon North American, Middletown, Connecticut, 1765–1852   North Simeon 2676 American 1 1765 1852 ca. 1815–20 1790 1845 Steel, gold, silver, wood (walnut, hickory), horn 3493 L. of each 15 3/4 in. (40 cm); L. of barrel of each 10 in. (25.4 cm); Cal. of each .56 in. (14.2 mm); Wt. of 96.5.36, 2 lb. 2 oz. (964 g); Wt. of 96.5.149, 2 lb. (907 g) John Stoneacre Ellis Collection, Gift of Mrs. Ellis and Augustus Van Horne Ellis, 1896   Middletown 34   Connecticut 118               Firearms-Pistols 38   http://www.metmuseum.org/art/collection/search/35815 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
199375 199375 2011.154.1 0 1 319012 Arts of Africa, Oceania, and the Americas 10 Basket 55 Basket Quinnipiac (?) 5475                           ca. 1850 1830 1870 Brown ash splint, wood, pigment 28136 H. 8 x W. 17 1/4 x D. 12 1/4 in. (20.3 x 43.8 x 31.1 cm) Ralph T. Coe Collection, Gift of Ralph T. Coe Foundation for the Arts, 2011       Connecticut 118 United States 3             Basketry-Containers 526   http://www.metmuseum.org/art/collection/search/319012 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342326 342326 23.14.13 0 0 491003 Modern and Contemporary Art 4 Sample 1077 Piece American 1         Manufacturer 20   Cheney Brothers American, 1838–1955   Cheney Brothers 46441 American 1 1838 1955 ca. 1923 1920 1923 Printed silk 52399 72 x 30 3/4 in. (182.9 cm. x 78.1 cm. ) Purchase, Edward C. Moore Jr. Gift, 1923 Object place 67 Manchester and Hartford 2115   Connecticut 118 America 719 New England 563           Textiles-Printed 239   http://www.metmuseum.org/art/collection/search/491003 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
348840 348840 2002.571.1a–c 0 0 503559 Musical Instruments 18 Violin 15655 Violin           Maker 1   Frederick L. Dautrich American, Schleierbach, Germany 1875–1942 Torrington, Connecticut   Dautrich Frederick L. 48031 American, born Germany 14 1875 1942 1933 1933 1933 Wood 25 L. 58.7 cm (23-1/2 in.); W. 21 cm (8-1/4 in.); D. 8.3 cm (3-1/4 in.) Gift of Carleen Maley Hutchins, 2002   Torrington 2301   Connecticut 118 United States 3             Chordophone-Lute-bowed-unfretted 925   http://www.metmuseum.org/art/collection/search/503559 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
348841 348841 2002.571.2 0 0 503560 Musical Instruments 18 Vilonia 16701 Vilonia           Maker 1   Frederick L. Dautrich American, Schleierbach, Germany 1875–1942 Torrington, Connecticut   Dautrich Frederick L. 48031 American, born Germany 14 1875 1942 1927 1927 1927 Wood. metal 54926 L. 87.7 cm (34-1/2 in.); W. 30.5 cm (12 in.); D. 15.2 cm (6 in.) Gift of Carleen Maley Hutchins, 2002   Torrington 2301   Connecticut 118 United States 3             Chordophone-Lute-bowed-unfretted 925   http://www.metmuseum.org/art/collection/search/503560 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
348842 348842 2002.571.3a–l 0 0 503561 Musical Instruments 18 Vilon 16702 Vilon           Maker 1   Frederick L. Dautrich American, Schleierbach, Germany 1875–1942 Torrington, Connecticut   Dautrich Frederick L. 48031 American, born Germany 14 1875 1942 1931 1931 1931 Wood, metal 6120 Overall: 35.6 x 17.8 x 100.3cm (14 x 7 x 39 1/2in.) Gift of Carleen Maley Hutchins, 2002   Torrington 2301   Connecticut 118 United States 3             Chordophone-Lute-bowed-unfretted 925   http://www.metmuseum.org/art/collection/search/503561 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
348843 348843 2002.571.4a–f 0 0 503562 Musical Instruments 18 Vilono 16703 Vilono           Maker 1   Frederick L. Dautrich American, Schleierbach, Germany 1875–1942 Torrington, Connecticut   Dautrich Frederick L. 48031 American, born Germany 14 1875 1942 1935 1935 1935 Wood 25 Overall: 52.1 x 27.9 x 144.8cm (20 1/2 x 11 x 57in.) Gift of Carleen Maley Hutchins, 2002   Torrington 2301   Connecticut 118 United States 3             Chordophone-Lute-bowed-unfretted 925   http://www.metmuseum.org/art/collection/search/503562 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
418536 418536 2015.458.1a–f, .2a–f 0 0 692630 Arms and Armor 5 Pair of arm defenses 1715 Pair of Arm Defenses American, Middletown, Connecticut 110         Manufacturer 20   New England Enameling Company, Inc. American, incorporated 1917   New England Enameling Company, Inc. 53160   1917   1918 1918 1918 Steel, paint, leather, copper alloy 60063 Overall length of each when assembled, 29 1/2 in. (74.9 cm); wt. of each when assembled, 3lb. 1.8 oz. (1413 g) left shoulder flap (2015.458.1a): 3 5/8 x 6 3/8 in. (9.2 x 16.2 cm); left shoulder (2015.458.1b): 7 3/4 x 6 7/8 in. (16.7 x 17.5 cm); left upper arm (2015.458.1c): 9 7/8 x 5 1/2 in. (25.1 x 14 cm); left elbow (2015.458.1d) 6 x 6 1/2 in. (15.2 x 16.5 cm); left forearm (2015.458.1e): 10 5/8 x 5 (27 x 12.7 cm); left hand plate (2015.458.1f): 4 1/2 x 4 3/8 in. (11.4 x 11.1 cm); right shoulder flap (2015.458.2a): 3 1/2 x 6 1/2 in. (8.9 x 16.5 cm); right shoulder (2015.458.2b): 7 5/8 x 6 3/4 in. (19.4 x 17.1 cm); right upper arm (2015.458.2c): 10 x 6 in. (25.4 x 15.2 cm); right elbow (2015.458.2d): 5 5/8 x 6 1/4 in. (14.3 x 15.9 cm); right forearm (2015.458.2e): 10 1/2 x 4 1/2 in. (26.7 x 11.4 cm); right hand plate (2015.458.2f): 4 x 4 1/4 in. (10.2 x 10.8 cm) Purchase, Arthur Ochs Sulzberger Gift, 2015   Middletown 34   Connecticut 118               Armor Parts-Arms & Shoulders 36   http://www.metmuseum.org/art/collection/search/692630 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
418537 418537 2015.458.3 0 0 692631 Arms and Armor 5 Defense for the neck and shoulders (necklet or gorget) 26915 Defense for the Neck and Shoulders (Necklet or Gorget) American, Middletown, Connecticut 110         Manufacturer 20   New England Enameling Company, Inc. American, incorporated 1917   New England Enameling Company, Inc. 53160   1917   1918 1918 1918 Steel, paint, rubber, copper alloy 60064 13 x 11 5/8 x 8 1/2 in. (33 x 29.5 x 21.6 cm); wt. 1 lb. 12.6 oz. (812 g) Purchase, Arthur Ochs Sulzberger Gift, 2015   Middletown 34   Connecticut 118               Armor Parts 47   http://www.metmuseum.org/art/collection/search/692631 4/23/2018 8:00:01 AM 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 174.02ms · Data license: CC0 · Data source: metmuseum/openaccess