MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

35 rows where Geography Type = 45 and Object Name = 116

✎ View and edit SQL

This data as json, CSV (advanced)

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

Geography Type ✖

  • Excavated in · 35 ✖
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 Metadata Date Repository
314303 314303 36.20.34 0 0 449065 Islamic Art 9 Jar 116 Jar                             10th–11th century 900 1099 Earthenware; turquoise glaze 45923 H. 2 1/8 in. (5.4 cm) Diam. 2 1/2 in. (6.4 cm) Wt. 2.8 oz. (79.4 g) Rogers Fund, 1936 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449065 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314310 314310 36.20.41 0 1 449072 Islamic Art 9 Jar 116 Jar                             9th–10th century 800 999 Earthenware; slip covered and incised, unglazed 45933   Rogers Fund, 1936 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449072 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314327 314327 36.20.58 0 1 449089 Islamic Art 9 Jar 116 Jar                             9th–10th century 800 999 Earthenware; incised and unglazed 45943   Rogers Fund, 1936 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449089 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314573 314573 38.40.123 0 0 449335 Islamic Art 9 Jar 116 Jar                             late 8th–first half 9th century 775 850 Earthenware; slip covered and incised, unglazed 45933   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449335 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314601 314601 38.40.152 0 1 449363 Islamic Art 9 Jar 116 Jar                             9th–10th century 800 999 Earthenware; slip covered and incised, unglazed 45933   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449363 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314630 314630 38.40.182 0 1 449392 Islamic Art 9 Jar 116 Jar                             10th–11th century 900 1099 Earthenware; slip covered and incised, unglazed 45933 H. 15 3/8 in. (39.1 cm) W. 18 1/2 in. (47 cm) Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449392 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314644 314644 38.40.196 0 1 449406 Islamic Art 9 Jar 116 Green Glass Jar                             10th century 900 999 Glass, green; blown 45968 H. 3 7/16 in. (8.7 cm) Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Glass 3   http://www.metmuseum.org/art/collection/search/449406 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314657 314657 38.40.209 0 0 449419 Islamic Art 9 Jar 116 Jar                             9th century 800 899 Earthenware; unglazed 44668   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449419 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314658 314658 38.40.210 0 1 449420 Islamic Art 9 Jar 116 Jar                             8th–9th century 700 899 Earthenware; slip covered and unglazed 45934   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449420 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314659 314659 38.40.211 0 1 449421 Islamic Art 9 Jar 116 Jar                             8th–10th century 700 999 Earthenware; slip covered and unglazed 45934   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449421 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314660 314660 38.40.212 0 1 449422 Islamic Art 9 Jar 116 Jar                             9th century 800 899 Earthenware; slip covered and unglazed 45934   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449422 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314662 314662 38.40.214 0 1 449424 Islamic Art 9 Jar 116 Jar                             10th–12th century 900 1199 Earthenware; slip covered and incised, unglazed 45933   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449424 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314663 314663 38.40.215 0 0 449425 Islamic Art 9 Jar 116 Jar                             9th century 800 899 Earthenware; slip covered and incised, unglazed 45933   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449425 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314667 314667 38.40.219 0 1 449429 Islamic Art 9 Jar 116 Jar                             8th–early 9th century 700 825 Earthenware; slip covered, unglazed 45996   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449429 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314668 314668 38.40.220 0 1 449430 Islamic Art 9 Jar 116 Jar                             late 8th–first half 9th century 775 825 Earthenware; unglazed 44668   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449430 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314674 314674 38.40.226 0 1 449436 Islamic Art 9 Jar 116 Jar                             late 9th–10th century 875 999 Earthenware; slip covered and incised, unglazed 45933   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449436 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314693 314693 38.40.245 0 1 449455 Islamic Art 9 Jar 116 Jar                             late 8th–9th century 775 899 Earthenware; slip covered and incised, unglazed 45933   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449455 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314702 314702 38.40.254 0 0 449464 Islamic Art 9 Jar 116 Jar                             9th century 800 899 Earthenware; unglazed 44668 H. 7/8 in. (2.2 cm) Diam. 7/8 in. (2.2 cm) Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449464 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314719 314719 38.40.276 0 1 449481 Islamic Art 9 Jar 116 Jar                             9th–10th century 800 999 Earthenware; slip covered and unglazed 45934   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449481 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314723 314723 38.40.280 0 0 449485 Islamic Art 9 Jar 116 Jar                             9th century 800 899 Earthenware; slip covered and incised, unglazed 45933   Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449485 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314795 314795 39.40.23 0 1 449557 Islamic Art 9 Jar 116 Jar                             9th century 800 899 Earthenware; unglazed 44668   Rogers Fund, 1939 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449557 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314853 314853 39.40.83 0 0 449615 Islamic Art 9 Jar 116 Jar                             9th–10th century 800 999 Earthenware; monochrome glazed 45900 H. 4 3/4 in. (12 cm) Diam. 3 7/8 in. (9.8 cm) Rogers Fund, 1939 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449615 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314858 314858 39.40.88 0 0 449620 Islamic Art 9 Jar 116 Jar                             9th–10th century 800 999 Earthenware; unglazed 44668 H. 2 9/16 in. (6.5 cm) W. 2 5/8 in. (6.7 cm) Rogers Fund, 1939 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449620 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314860 314860 39.40.90 0 1 449622 Islamic Art 9 Jar 116 Jar                             9th–10th century 800 999 Earthenware; slip covered and unglazed 45934   Rogers Fund, 1939 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449622 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314861 314861 39.40.91a, b 0 1 449623 Islamic Art 9 Jar 116 Jar                             9th–10th century 800 999 Earthenware; slip covered and unglazed 45934   Rogers Fund, 1939 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449623 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314874 314874 39.40.105 0 1 449636 Islamic Art 9 Jar 116 Jar                             9th–10th century 800 999 Earthenware; slip covered and unglazed 45934   Rogers Fund, 1939 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449636 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314890 314890 39.40.121 0 1 449652 Islamic Art 9 Jar 116 Jar                             10th century 900 999 Earthenware; slip covered and incised, unglazed 45933   Rogers Fund, 1939 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449652 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314946 314946 40.170.12 0 0 449708 Islamic Art 9 Jar 116 Jar                             9th century 800 899 Earthenware; buff body, green glaze 46158 H. 4 7/16 in. (11.2 cm) Diam. 2 3/8 in. (6.1 cm) Base: 3 1/4 in. (8.3 cm) Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449708 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314981 314981 40.170.48 0 1 449743 Islamic Art 9 Jar 116 Jar                             9th century 800 899 Earthenware; slip covered and unglazed 45934   Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449743 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315010 315010 40.170.78 0 1 449772 Islamic Art 9 Jar 116 Jar                             11th–12th century 1000 1199 Earthenware; slip covered and incised, unglazed 45933   Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449772 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315011 315011 40.170.79 0 1 449773 Islamic Art 9 Jar 116 Jar                             8th–9th century 700 899 Earthenware; slip covered and unglazed 46180   Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449773 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315088 315088 40.170.163 0 1 449851 Islamic Art 9 Jar 116 Jar                             11th–12th century 1000 1199 Earthenware; gritty gray body, turquoise glaze 46215 H. 6 3/16 in. (15.7 cm) Diam. 2 15/16 in. (7.4 cm) Base: 4 in. (10.2 cm) Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449851 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315107 315107 40.170.185 0 1 449870 Islamic Art 9 Jar 116 Jar                             late 8th–9th century 775 899 Earthenware; slip covered and unglazed 45934   Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/449870 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315995 315995 48.101.1 0 1 450759 Islamic Art 9 Jar 116 Jar                             9th–10th century 800 999 Earthenware; painted in white under green and brown glaze 46528 H. 3 3/16 in. (8.1 cm) Diam. 2 1/4 in. (5.7 cm) Wt. 5.7 oz. (161.6 g) Rogers Fund, 1948 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/450759 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
316004 316004 48.101.12 0 1 450768 Islamic Art 9 Jar 116 Jar                             11th century 1000 1099 Earthenware; incised and unglazed 45943   Rogers Fund, 1948 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   http://www.metmuseum.org/art/collection/search/450768 4/23/2018 8:00:01 AM 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 486.715ms · Data license: CC0 · Data source: metmuseum/openaccess