MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

68 rows where Country = 5 and Geography Type = 20

View and edit SQL

Geography Type

  • Attributed to · 10
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
316696 58.85.2 0 1 451473 Islamic Art 9 Fragment 486 Spanish Textile                             first half 12th century 1100 1150 Silk, metal wrapped thread; lampas 45006 Textile: H. 17 in. (43.2 cm) W. 13 in. (33 cm) Mount: H. 20 5/8 in. (52.4 cm) W. 16 5/8 in. (42.2 cm) D. 1 1/4 in. (3.2 cm) Funds from various donors, 1958 Attributed to 20       Spain 5             Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
316939 63.183 0 0 451719 Islamic Art 9 Handle 4249 Handle                             20th century 1900 1963 Gold, niello, and silver 46797 L. 7 1/16 in. (17.9 cm) Diam. (of knob) 1 1/8 in. (2.9 cm) Wt. 2.5 oz. (70.9 g) Gift of Mr. B. Muggenthaler, 1963 Attributed to 20 Toledo 96     Spain 5             Metal 1   Metropolitan Museum of Art, New York, NY 1
317164 67.178.3a, b 0 1 451945 Islamic Art 9 Incense burner 4170 Incense Burner                             11th century 1000 1099 Bronze; cast, chased, and pierced 46865 H. 9 3/4 in. (24.8 cm) W. 10 in. (25.4 cm) D. 4 1/4 in. (10.8 cm) Purchase, Joseph Pulitzer Bequest, 1967 Attributed to 20       Spain 5 Andalusia 501           Metal 1   Metropolitan Museum of Art, New York, NY 1
317213 68.215.2 1 1 451995 Islamic Art 9 Dish 110 Brasero                             late 15th–early 16th century 1475 1525 Earthenware; molded, luster-painted on opaque white glaze 46882 2 1/16 x 19 5/16 in. (5.2 x 49.1 cm) Gift of Dr. and Mrs. Lewis Balamuth, 1968 Attributed to 20 Manises (Valencia) 1487     Spain 5             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
317616 1972.120.1 0 1 452398 Islamic Art 9 Fragment 486 Fragment                             probably 14th century 1300 1399 Wool (warp, weft and pile); single-warp (Spanish) knotted pile 45335 Textile: Max. H. 4 3/4 in. (12.1 cm) Max. w. 4 3/4 in. (12.1 cm) Mount: H. 12 in. (30.5 cm) W. 9 in. (22.9 cm) W. 1/4 in. (0.6 cm) Rogers Fund, 1972 Attributed to 20       Spain 5             Textiles-Rugs 196   Metropolitan Museum of Art, New York, NY 1
318218 1980.539 0 1 453004 Islamic Art 9 Fragment 486 Fragment                             15th century 1400 1499 Silk; lampas 45079 Textile: H. 15 7/8 in. (40.3 cm) W. 8 1/2 in. (21.6 cm) Gift of Clara Waldeck, in memory of her husband Hans Waldeck, 1980 Attributed to 20       Spain 5             Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
318269 1981.372 0 1 453057 Islamic Art 9 Fragment 486 Fragment                             15th century 1400 1499 Silk; lampas 45079 Textile: H. 10 1/4 in. (26 cm) W. 14 5/8 in. (37.1 cm) Gift of Clara Waldeck, in memory of her husband, Hans Waldeck, 1981 Attributed to 20       Spain 5             Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
318504 1987.440.2 0 1 453294 Islamic Art 9 Fragment 486 Fragment                             13th century 1200 1299 Silk, metal wrapped thread 16384 Textile: H. 3 3/8 in. (8.6 cm) W. 2 1/4 in. (5.7 cm) Mount: H. 7 3/8 in. (18.7 cm) W. 6 1/8 in. (15.6 cm) D. 1 1/2 in. (3.8 cm) Gift of Mrs. Hayford Peirce, 1987 Attributed to 20       Spain 5             Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
319494 56.234.27.4 0 1 455291 Islamic Art 9 Capital 176 Capital                             14th century 1300 1399 white marble 46722 Wt. 72 lbs. wb Gift of The Hearst Foundation, 1956 Attributed to 20       Spain 5             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
320637 2011.182 0 1 457717 Islamic Art 9 Panel 399 Panel with Geometric Pattern and Benedictory Inscriptions                             late 13th–mid-14th century 1275 1350 Limestone; carved 45230 H. 30 5/16 in. (77 cm) W. 11 in. (28 cm) D. 3 15/16 in. (10 cm) Purchase, Friends of Islamic Art Gifts, 2011 Attributed to 20 Granada 1561     Spain 5             Stone 209   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 48.535ms · Data license: CC0 · Data source: metmuseum/openaccess