MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Classification = 191 and Department = 17

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	Geography Type	City	Country	Classification	Link Resource	Metadata Date	Repository
326171	326171	1984.344	1	466119	The Cloisters 17	Silk textile 14776	Silk with Griffins	Central Asian, Sicilian, or North African 6057	first half 13th century	1200	1250	Silk, silver-gilt metal on parchment over cotton 49766	69 1/4 x 38 1/4 in. (175.9 x 97.2 cm)	The Cloisters Collection, 1984				Textiles-Woven 191	http://www.metmuseum.org/art/collection/search/466119	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
326596	326596	25.120.422	1	466594	The Cloisters 17	Altar frontal 8759	Textile, Altar Frontal	French or Italian 63	ca. 1500	1500	1500	Silk, metal thread 14027	Overall: 48 1/2 x 108 in. (123.2 x 274.3 cm)	The Cloisters Collection, 1925				Textiles-Woven 191	http://www.metmuseum.org/art/collection/search/466594	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
327817	327817	53.35.2	1	468431	The Cloisters 17	Hanging 1025	Wall Hanging, with Pomegranate Pattern	German 27	early 16th century	1500	1550	Compound twill weave, brocaded. Wool, linen, and metallic thread 50101	96 × 40 in. (243.8 × 101.6 cm) Framed: 9 ft. 2 1/2 in. × 47 in. × 4 3/4 in., 138 lb. (280.7 × 119.4 × 12.1 cm, 62.6 kg)	The Cloisters Collection, 1953	Made in 1	Nuremberg 149		Textiles-Woven 191	http://www.metmuseum.org/art/collection/search/468431	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
327929	327929	58.54	1	468553	The Cloisters 17	Frontal 14865	Altar Frontal	Spanish 13	ca. 1500	1500	1500	Silk & metal thread 50030	Overall: 39 1/2 x 80 1/2in. (100.3 x 204.5cm)	The Cloisters Collection, 1958				Textiles-Woven 191	http://www.metmuseum.org/art/collection/search/468553	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
332733	332733	2011.480	1	479581	The Cloisters 17	Fragment 486	Silk Fragment with Lions and Pomegranates	Spanish 13	late 15th century	1475	1500	Silk, lampas weave 50755	Overall: 9 3/16 x 10 1/8 in. (23.3 x 25.7 cm) Framed: 13 1/4 x 14 5/16 x 1 in. (33.6 x 36.3 x 2.5 cm)	The Cloisters Collection, 2011	Made in 1	probably Granada 1745	Spain 5	Textiles-Woven 191	http://www.metmuseum.org/art/collection/search/479581	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");