MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Medium = 3820

Search:

descending

Link	rowid ▼	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Culture	Object Date	Object Begin Date	Object End Date	Medium	Dimensions	Credit Line	Classification	Link Resource	Metadata Date	Repository
18356	18356	25.26.3	0	22877	Arms and Armor 5	Shield (Pavise) 1737	Shield (Pavise)	possibly Bohemian 240	ca. 1475–1500	1450	1525	Wood, leather, gesso, polychromy 3820	H. 22 1/2 in. (57.15 cm); W. 16 1/2 in. (41.91 cm)	Gift of Mrs. Florence Blumenthal, 1925	Shields 39	http://www.metmuseum.org/art/collection/search/22877	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
18809	18809	29.158.591	1	23332	Arms and Armor 5	Shield (Pavise) 1737	Shield (Pavise)	Austrian 184	1450–1500	1450	1500	Wood, leather, gesso, polychromy 3820	H. 22 1/4 in. (56.5 cm); W. 16 in. (40.6 cm); D. 4 in. (10.2 cm)	Bashford Dean Memorial Collection, Funds from various donors, 1929	Shields 39	http://www.metmuseum.org/art/collection/search/23332	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
20171	20171	42.50.29	1	24698	Arms and Armor 5	Hungarian-style shield 2228	Hungarian-Style Shield	Eastern European 345	ca. 1500–1550	1475	1575	Wood, leather, gesso, polychromy 3820	H. 50 in. (127 cm); W. 20 in. (50.8 cm)	Gift of Stephen V. Grancsay, 1942	Shields 39	http://www.metmuseum.org/art/collection/search/24698	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
20172	20172	42.50.30	0	24699	Arms and Armor 5	Hungarian-style shield 2228	Hungarian-Style Shield	Eastern European 345	ca. 1500–1550	1475	1575	Wood, leather, gesso, polychromy 3820	H. 45 in. (114.3 cm); W. 25 in. (63.5 cm)	Gift of Stephen V. Grancsay, 1942	Shields 39	http://www.metmuseum.org/art/collection/search/24699	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
20274	20274	49.57.1	1	24803	Arms and Armor 5	Hungarian-style shield 2228	Hungarian-Style Shield	Eastern European 345	ca. 1500–1550	1475	1575	Wood, leather, gesso, polychromy 3820	H. 32 1/2 in. (82.55 cm); W. 21 5/8 in. (54.91 cm)	Rogers Fund, 1949	Shields 39	http://www.metmuseum.org/art/collection/search/24803	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
30238	30238	42.50.29, .30; 49.57.1	1	35793	Arms and Armor 5	Three hungarian-style shields 3844	Three Hungarian-Style Shields	Eastern European 345	ca. 1500–1550	1475	1575	Wood, leather, gesso, polychromy 3820	42.50.29: H. 50 in. (127 cm); W. 20 in. (50.8 cm); 42.50.30: H. 45 in. (114.3 cm); W. 25 in. (63.5 cm); 49.57.1: H. 32 1/2 in. (82.55 cm); W. 21 5/8 in. (54.91 cm)	42.50.29, .30: Gift of Stephen V. Grancsay, 1942; 49.57.1: Rogers Fund, 1949	Shields 39	http://www.metmuseum.org/art/collection/search/35793	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");