MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

4 rows where City = 1 and Department = 5

Search:

descending

Link	rowid ▼	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Culture	Artist Role	Artist Prefix	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	Dimensions	Credit Line	City	County	Classification	Link Resource	Metadata Date	Repository
22650	22650	56.164.3	0	27561	Arms and Armor 5	Flintlock gun 2157	Flintlock Gun	American, Philadelphia, Pennsylvania, 631									ca. 1825	1800	1850	Steel, wood (curly maple, ash), brass, silver, bone 5117	L. 53 7/8 in. (136.8 cm); L. of barrel 39 in. (90.1 cm); Cal. .41 in. (10.4 mm); Wt. 5 lb. 13 oz. (2363.5 g)	Gift of Marion Eppley, 1956	Philadelphia 1	Pennsylvania 172	Firearms-Guns-Flintlock 117	http://www.metmuseum.org/art/collection/search/27561	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
30315	30315	2012.473	0	35909	Arms and Armor 5	Experimental helmet prototype 3870	American Helmet Model No. 8	American, Philadelphia 1265	Manufacturer 20		Ford Motor Company	American, founded 1903	Ford Motor Company 3150	American 1	1903	2099	1918	1918	1918	Steel, leather, felt, canvas, bronze, pigment, sawdust 7226	H. 9 in. (22.9 cm); W. 10 1/2 in. (26.7 cm); D. 12 1/4 in. (31.1 cm); Wt. 3 lb. 10.5 oz. (1660 g)	Rogers Fund, by exchange, 2012	Philadelphia 1	Pennsylvania 172	Helmets 37	http://www.metmuseum.org/art/collection/search/35909	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
30347	30347	2013.582	1	35957	Arms and Armor 5	Experimental helmet prototype 3870	American Helmet Model No. 5	American, Philadelphia 1265	Manufacturer 20		Hale & Kilburn Company	American, Philadelphia, Pennsylvania 1873–1933 Indianapolis, Indiana	Hale & Kilburn Company 3155	American 1	1873	1933	1918	1918	1918	Steel, paint, leather, textile, string 7236	H. 6 1/2 in. (16.5 cm); W. 10 3/4 in. (27.3 cm); D. 12 5/8 in. (32.1 cm); Wt. 2 lb. 8 oz. (1130 g)	Purchase, Gift of Bashford Dean, by exchange, 2013	Philadelphia 1	Pennsylvania 172	Helmets 37	http://www.metmuseum.org/art/collection/search/35957	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
411803	411803	2015.126	1	679349	Arms and Armor 5	Sword 379	Cavalry Officer's Saber	American, Philadelphia 1265	Silversmith 122	Hilt by	Parry & Musgrave	American, Philadelphia 1792–1796 Philadelphia	Parry & Musgrave 51967	American 1	1792	1796	ca. 1793–95	1768	1820	Steel, silver, wood, textile, copper 59625	H. 41 in. (104.1 cm); H. of blade 34 1/2 in. (87.6 cm); W. 4 5/8 in. (11.7 cm); D. 4 in. (10.2 cm); Wt. 1 lb. 10.3 oz. (745.6 g)	Purchase, Arthur Ochs Sulzberger Bequest, 2015	Philadelphia 1	Pennsylvania 172	Swords 29	http://www.metmuseum.org/art/collection/search/679349	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1

Advanced export

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");