MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

25 rows where Classification = 133

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Object Name, 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, County

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 Repository
20306 55.206.1 0 1 24835 Arms and Armor 5 Percussion revolver 2242 Colt Paterson Percussion Revolver, No. 5, Holster Model, serial no. 528 American, Paterson, New Jersey 359         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 ca. 1838–40 1813 1865 Steel, silver, ivory 4338 L. 16 3/4 in. (42.55 cm); L. of barrel 12 in. (30.48 cm); Cal. .40 in. (10.2 mm) Gift of John E. Parsons, 1955   Paterson 316   New Jersey 154               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
20309 56.167.1a–g 0 1 24838 Arms and Armor 5 Percussion revolver with case and accessories 2255 Colt Paterson Pocket Percussion Revolver, Fourth Ehlers Model, serial no. 152, with Case and Accessories American, Paterson, New Jersey 359         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 ca. 1840–43 1815 1868 Steel, wood (walnut) 3526 Revolver (a); L. 6 1/2 in. (16.5 cm); L. of barrel 3 in. (7.6 cm); Cal. .28 in. (7.1 mm); bullet mould (b); L. 3 3/16 in. (8.1 cm); W. (when closed) 1 3/4 in. (4.5 cm); Wt. 2.2 oz. (62.4 g); primer (c); L. 3 11/16 in. (9.4 cm); Diam. 1 1/8 in. (2.8 cm); Wt. 3.3 oz. (93.6 g); cleaning rod (d); L. 4 5/8 in. (11.7 cm); Wt. 1.2 oz. (34 g); spanner-screwdriver (e); L. 2 5/8 in. (6.7 cm); W. 2 in. (5.1 cm); Wt. 0.9 oz. (25.5 g); case (f); H. 2 in. (5.1 cm); W. 10 in. (25.4 cm); D. 5 7/8 in. (14.9 cm); Wt. 1 lb. 0.8 oz. (476.3 g); key (g); L. 1 1/8 in. (2.8 cm) Gift of John E. Parsons, 1956   Paterson 316   New Jersey 154               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
20312 57.166.1 0 1 24841 Arms and Armor 5 Percussion revolver 2242 Colt Paterson Percussion Revolver, No. 5, Holster Model, serial no. 940 American, Paterson, New Jersey 359         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 ca. 1840 1815 1865 Steel, silver, mother-of-pearl 3835 L. 14 in. (35.56 cm); L. of barrel 9 in. (22.86 cm); Cal. .40 in. (10 mm) Gift of John E. Parsons, 1957   Paterson 316   New Jersey 154               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
20317 59.143.1a–h 0 1 24846 Arms and Armor 5 Percussion revolver with case and accessories 2255 Colt Paterson Percussion Revolver, No. 3, Belt Model, Serial no. 156, with Case and Accessories American, Paterson, New Jersey 359         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 ca. 1838 1813 1863 Steel, silver, brass, wood (walnut), copper, velvet 4342 Revolver (a); L. 9 5/8 in. (24.4 cm); L. of barrel 5 1/2 in. (14 cm); Cal. .34 in. (8 mm); extra cylinder (b); L. 1 1/4 in. (3.2 cm); Diam. 1 1/4 in. (3.2 cm); Wt. 4.2 oz. (119.1 g); combination patch, powder and ball cylinder (c); L. 5 3/8 in. (13.6 cm); Diam. 1 5/16 in. (3.3 cm); Wt. 12.2 oz. (345.9 g); bullet mould (d); L. 3 11/16 in. (9.4 cm); W. 1 1/4 in. (3.2 cm); Wt. 2.2 oz. (62.4 g); combination screwdriver and pricker (e); L. 4 11/16 in. (11.9 cm); Wt. 1.7 oz. (48.2 g); percussion cap box (f); L. 3 5/16 in. (8.4 cm); Diam. 1 13/16 in. (4.6 cm); Wt. 3.1 oz. (87.9 g); cleaning rod (g); L. 6 7/8 in. (17.5 cm); Wt. 1.1 oz. (31.2 g); case (h); H. 2 1/8 in. (5.4 cm); W. 10 3/8 in. (26.3 cm); D. 7 in. (17.8 cm); Wt. 2 lb. 3.3 oz. (1000.7 g) Gift of John E. Parsons, 1959   Paterson 316   New Jersey 154               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20318 59.143.3 0 1 24847 Arms and Armor 5 Percussion revolver 2242 Colt Navy Percussion Revolver, Confederate Model, serial no. 2651 American, Griswoldville, Georgia 362         Manufacturer|Designer 18   The Griswold and Grier Company|Samuel Colt American, 19th century|American, Hartford, Connecticut 1814–1862   The Griswold and Grier Company|Colt, Samuel 2897 American|American 5 1801 |1814 1900 |1862 1862–64 1862 1864 Steel, brass, wood 3878 L. 13 1/8 in. (33.3 cm); L. of barrel 7 1/2 in. (19.1 cm); Cal. .36 in. (9 mm) Gift of John E. Parsons, 1959   Griswoldville 517   Georgia 177               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
20389 1985.264a–r 0 1 24921 Arms and Armor 5 Revolver with case and accessories 2291 Cased Colt Model 1862 Police Revolver, Serial no. 9174, with Thuer Conversion for Self-contained Cartridges, and Accessories American, Hartford, Connecticut and New York 378         Manufacturer|Steel-chiseler|Maker 148 Decoration attributed to|Case made by Samuel Colt|Louis D. Nimschke|Schuyler, Hartley and Graham American, Hartford, Connecticut 1814–1862|American, New York, active ca. 1850–1900|American, New York, 19th century   Colt, Samuel|Nimschke, Louis D.|Schuyler, Hartley and Graham 2913 American|American|American 101 1814 |1825 |1801 1862 |1925 |1900 1862 1862 1862 Steel, gold, silver, brass, wood (rosewood), textile 4375 Cal. .36 in. (9 mm); case 15 x 9 in. (38 x 23 cm) Gift of Mr. and Mrs. Jerry D. Berger, 1985   Hartford|New York 38   Connecticut|New York 182               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
20433 2013.904a–c 0 0 24967 Arms and Armor 5 Double-action revolver with case and cleaning brush 2314 Smith and Wesson .44 Double-Action Revolver for George Jay Gould (1864–1923), serial no. 23402, with Case and Cleaning Brush American, Springfield, Massachusetts and New York 387         Manufacturer|Decorator 61   Smith & Wesson|Tiffany & Co. American, established 1852|1837–present   Smith & Wesson|Tiffany & Co. 2932 American 1 1852 |1837 9999 ca. 1889 1864 1914 Steel, silver, ivory, wood, paper, textile, leather, gold, copper alloy, iron, silver substitute, fiber 4401 L. 10 7/16 in. (26.5 cm); L. of barrel 5 in. (12.7 cm); Cal. .44 in. (11.2 mm); Wt. 2 lb. 8 oz. (1134 g); case; H. 2 9/16 in. (6.5 cm); W. 12 5/16 in. (31.3 cm); D. 9 13/16 (24.9 cm); Wt. 4 lb. 2 oz. (1867 g); cleaning brush; L. 9 3/4 in. (24.8 cm); Diam. 7/8 in. (2.2 cm); Wt. .8 oz. (22 g) Purchase, Arthur Ochs Sulzberger Bequest, 2013   New York 3   Massachusetts|New York 183               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20434 2003.546.1 0 0 24968 Arms and Armor 5 Single-action revolver 2315 Smith and Wesson .32 Caliber Single-Action Revolver, Serial no. 17156 American, Springfield, Massachusetts and New York 387         Decorator|Manufacturer 21   Tiffany & Co.|Smith & Wesson 1837–present|American, established 1852   Tiffany & Co.|Smith & Wesson 2933 American 1 1837 |1852 9999 ca. 1889–90 1864 1915 Steel, silver, laminated metal, nickel 4402 L. 7 1/8 in. (18.1 cm); L. of barrel 3 in. (7.6 cm); Cal. .32 in. (8 mm); Wt. 15 oz. (438 g) Gift of Gerald Klaz, M.D., Trustee - The Gerald Klaz Trust, 2003   Springfield|New York 528   Massachusetts|New York 183               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20435 2003.546.2 0 0 24969 Arms and Armor 5 Double-action revolver 2316 Smith and Wesson .38 Caliber Double-Action Revolver, Serial no. 70002 American, Springfield, Massachusetts and New York 387         Manufacturer|Decorator 61   Smith & Wesson|Tiffany & Co. American, established 1852|1837–present   Smith & Wesson|Tiffany & Co. 2932 American 1 1852 |1837 9999 ca. 1883 1858 1908 Steel, nickel, silver 4403 L. 8 in. (20.4 cm); L. of barrel 3 ½ in. (8.2 cm); Wt. 1 lb. 5 oz. (586 g) Gift of Gerald Klaz, M.D., Trustee - The Gerald Klaz Trust, 2003   Springfield|New York 528   Massachusetts|New York 183               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20437 2010.482 0 0 24971 Arms and Armor 5 Single-action revolver 2315 Smith and Wesson .32 Caliber Single-Action Revolver, Serial no. 94421 American, Springfield, Massachusetts and New York 387         Manufacturer|Decorator 61   Smith & Wesson|Tiffany & Co. American, established 1852|1837–present   Smith & Wesson|Tiffany & Co. 2932 American 1 1852 |1837 9999 ca. 1891–93 1866 1918 Steel, silver, niello 4038 L. 7 3/8 in. (18.7 cm); L. of barrel 3 1/2 in. (8.8 cm); Cal. .32 in. (8.13 mm); Wt. 15 oz. (424 g) Gift of Gerald Klaz, M.D., Trustee - The Gerald Klaz Trust, 2010   Springfield|New York 528   Massachusetts|New York 183               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20438 2013.903a, b 0 0 24972 Arms and Armor 5 Double-action revolver with case 2318 Smith and Wesson .38 Caliber Safety Third Model Double-Action Revolver, serial no. 83097, with Case American, Springfield, Massachusetts and New York 387         Manufacturer|Decorator 61   Smith & Wesson|Tiffany & Co. American, established 1852|1837–present   Smith & Wesson|Tiffany & Co. 2932 American 1 1852 |1837 9999 ca. 1890–93 1865 1918 Steel, silver, enamel, wood, leather, copper alloy, gold 4405 Revolver (a); L. 9 1/16 in. (23 cm); L. of barrel 4 in. (10.2 cm); Cal. .38 in. (9.7 mm); Wt. 1 lb. 6 oz. (628 g); case (b); H. 2 1/16 in. (5.2 cm); W. 10 5/8 in. (27 cm); D. 6 1/2 in. (16.5 cm); Wt. 1 lb. 8.7 oz. (700.2 g) Purchase, Arthur Ochs Sulzberger Bequest, 2013   Springfield|New York 528   Massachusetts|New York 183               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20439 2007.477 0 0 24973 Arms and Armor 5 Single-action revolver 2315 Smith and Wesson .44 New Model No. 3 Single-Action Revolver, serial no. 25120 American, Springfield, Massachusetts and New York 387         Manufacturer|Decorator 61   Smith & Wesson|Tiffany & Co. American, established 1852|American, established 1837   Smith & Wesson|Tiffany & Co. 2932 American 1 1852 |1837 9999 ca. 1888 1863 1913 Steel, silver, nickel 4406 L. 11 in. (28 cm); L. of barrel 5 in. (12.7 cm); Cal. .44 in. (11 mm); Wt. 2 lb. 8 oz. (1123 g) Gift of Gerald Klaz, M.D., Trustee - The Gerald Klaz Trust, 2007   Springfield|New York 528   Massachusetts|New York 183               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
22039 2013.902 0 0 26885 Arms and Armor 5 Revolver  2607 Smith and Wesson New Model No. 3, .44 Caliber Double-Action Navy Revolver, serial no. 23060 American, Springfield, Massachusetts and New York 387         Manufacturer|Decorator 61   Smith & Wesson|Tiffany & Co. American, established 1852|1837–present   Smith & Wesson|Tiffany & Co. 2932 American 1 1852 |1837 9999 ca. 1891–92 1866 1917 Steel, silver, turquoise, lapis lazuli 4892 L. 11 3/4 in. (29.8 cm); barrel L. 6 1/2 in. (16.51 cm); Cal. .44 in. (11 mm); Wt. 2 lb. 9 oz. (1150 g) Purchase, Arthur Ochs Sulzberger Bequest, 2013   Springfield|New York 528   Massachusetts|New York 183               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
22658 58.171.2 0 1 27569 Arms and Armor 5 Colt revolver 2770 "Wells Fargo" Colt Revolver American 1                           ca. 1851 1826 1876 Steel, silver, wood (mahogany) 5120 L. 8 3/4 in. (22.2 cm); L. of barrel 4 in. (10.2 cm); Cal. .31 in. (7.9 mm); Wt. 1 lb. 5.8 oz. (618 g) Gift of John E. Parsons, 1958   New York City 587   New York 126               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
22661 59.143.2 0 1 27572 Arms and Armor 5 Colt revolver 2770 Pocket Model Colt Revolver American 1                           1848 1848 1848 Steel, wood, gold 3519 L. 9 3/4 in. (24.8 cm); L. of barrel 5 in. (12.7 cm); Cal. .31 in. (7.9 mm); Wt. 1 lb. 7.7 oz. (671.9 g) Gift of John E. Parsons, 1959   New York City 587   New York 126               Firearms-Pistols-Revolvers 133   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 160.729ms · Data license: CC0 · Data source: metmuseum/openaccess