MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Culture = 70 and Department = 5

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Object Date, Object Begin Date, Object End Date, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
22089 14.25.1827 0 0 26945 Arms and Armor 5 Banner 1326 Banner Russian 70                           possibly ca. 1810 1785 1835 Textile, gold 4915 48 x 34 1/2 in. (121.9 x 87.6 cm) Gift of William H. Riggs, 1913                       Banners 45   Metropolitan Museum of Art, New York, NY 1
22091 14.25.1825 0 1 26947 Arms and Armor 5 Church banner 2623 Church Banner Russian 70                           possibly ca. 1810 1785 1835 Textile, gilt, polychromy 4916 47 x 39 1/4 in. (119.3 x 99.6 cm) Gift of William H. Riggs, 1913                       Banners 45   Metropolitan Museum of Art, New York, NY 1
22172 14.25.463 0 0 27064 Arms and Armor 5 Berdiche 2645 Berdiche Russian 70                           15th century 1401 1500 Steel, wood, leather 3836 L. 60 7/8 in. (154.6 cm); L. of head 23 1/4 in. (59.1 cm); W. 5 3/8 in. (13.6 cm); Wt. 2 lbs. 15 oz. (1332.4 g) Gift of William H. Riggs, 1913                       Shafted Weapons 35   Metropolitan Museum of Art, New York, NY 1
22476 69.138.1 0 0 27381 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Russian 70                           dated 1749 1749 1749 Steel, silver, gold, wood (walnut), bone 5051 L. 17 3/8 in. (44.1 cm); L. of barrel 11 1/16 in. (28.1 cm); Cal. .60 In. (15.2 mm); Wt. 2 lb. 4 oz. (1020.6 g) Rogers Fund, 1969   Tula 478                   Firearms-Pistols-Flintlock 41   Metropolitan Museum of Art, New York, NY 1
27005 34.57.12a, b 0 0 32158 Arms and Armor 5 Smallsword with scabbard 1641 Smallsword with Scabbard Russian 70                           1770 1770 1770 Steel, gold, silver, wood, leather 6500 L. with scabbard 35 3/4 in. (90.8 cm); L. without scabbard 35 1/4 in. (89.5 cm); L. of blade 29 1/4 in. (74.3 cm); W. 3 15/16 in. (10 cm); Wt. 11 oz. (311.8 g); Wt. of scabbard 3 oz. (85 g) Gift of Jean Jacques Reubell, in memory of his mother, Julia C. Coster, and of his wife, Adeline E. Post, both of New York City, 1926                       Swords 29   Metropolitan Museum of Art, New York, NY 1
27583 26.43.2 0 1 32747 Arms and Armor 5 Berdiche 2645 Berdiche Russian 70                           17th century 1601 1700 Steel, wood 82 L. 71 1/2 in. (181.6 cm); L. of head 26 1/4 in. (66.7 cm.); W. 6 1/4 in. (15.9 cm); Wt. 3 lbs. 6.6 oz. (1547.9 g) John Stoneacre Ellis Collection, gift of Augustus Van Horne Ellis, 1926                       Shafted Weapons 35   Metropolitan Museum of Art, New York, NY 1
27821 22.122.45 0 1 32994 Arms and Armor 5 Medal 148 Medal Commemorating the Coronation of Peter II at Moscow, 1728 Russian 70                           1728 1728 1728 Bronze 23 Diam. 2 1/2 in. (6.4 cm); thickness 3/16 in. (0.5 cm); Wt. 3.5 oz. (99.2 g) Gift of Bashford Dean, 1922                       Miscellaneous-Coins and Medals 155   Metropolitan Museum of Art, New York, NY 1
28155 19.53.86 0 0 33334 Arms and Armor 5 Primer 1926 Primer Russian 70                           18th century 1701 1800 Horn, silver, steel 6762 L. 5 3/4 in. (14.6 cm); D. 1/2 in. (1.3 cm); Wt. 5.2 oz. (147.4 g) Gift of Charles M. Schott Jr., 1917                       Firearms Accessories-Flasks & Primers 53   Metropolitan Museum of Art, New York, NY 1
30298 2013.493.4 0 1 35882 Arms and Armor 5 Medal 148 Medal for the Seventh Russian Mining Congress, Kychtym Mountainous District, 1897 Russian 70                           dated 1897 1897 1897 Iron 13 Diam. 2 1/2 in. (6.4 cm) Gift of Dean K. Boorman, 2013                       Miscellaneous-Coins and Medals 155   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 346.959ms · Data license: CC0 · Data source: metmuseum/openaccess