MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

22 rows where Classification = 1 and Geography Type = 34

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Highlight, Is Public Domain, Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, City, Country

Geography Type ✖

  • Found · 22 ✖
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
310617 310617 08.202.29 0 1 445358 Islamic Art 9 Spindle 6925 Spindle                             3rd–12th century 400 1199 Iron 13 H. 1 3/16 in. (3 cm) W. 8 1/8 in. (20.6 cm) D. 1 7/16 in. (3.7 cm) Wt. 1.1 oz. (31.2 g) Rogers Fund, 1908 Found 34 near Thebes 1540     Egypt 104             Metal 1   http://www.metmuseum.org/art/collection/search/445358 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
311556 311556 13.182.11 0 1 446300 Islamic Art 9 Lamp 558 Lamp                             2nd–7th century 100 699 Bronze 23 9/16 x 1 1/16 in. (1.5 x 2.7 cm) Rogers Fund, 1913 Found 34 Medinet Habu 1572     Egypt 104             Metal 1   http://www.metmuseum.org/art/collection/search/446300 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
311877 311877 14.1.433 0 1 446621 Islamic Art 9 Censer 3914 Censer                             7th century 600 699 Bronze 23 H. 7 1/8 in. (18.1 cm) Diam. 2 1/2 in. (6.4 cm) Wt. 10.8 oz. (306.2 g) Rogers Fund, 1914 Found 34 Thebes 1556     Egypt 104             Metal 1   http://www.metmuseum.org/art/collection/search/446621 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
313072 313072 26.3.84 0 0 447825 Islamic Art 9 Ring handle 5284 Ring Handle                             3rd–12th century 200 1199 Iron and bronze 45632 H. 15/16 in. (2.4 cm) W. 1 13/16 in. (4.6 cm) D. 3/8 in. (1 cm) Wt. 0.2 oz. (5.7 g) Rogers Fund, 1926 Found 34       Egypt 104             Metal 1   http://www.metmuseum.org/art/collection/search/447825 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
313073 313073 26.3.85 0 0 447826 Islamic Art 9 Razor 2486 Razor                             3rd–12th century 200 1199 Iron 13 H. 3/4 in. (1.9 cm) W. 3 1/2 in. (8.9 cm) D. 1/4 in. (0.6 cm) Wt. 0.5 oz. (14.2 g) Rogers Fund, 1926 Found 34 Thebes 1556     Egypt 104             Metal 1   http://www.metmuseum.org/art/collection/search/447826 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314820 314820 39.40.49 0 1 449582 Islamic Art 9 Finial 3921 Finial                             11th–12th century 1000 1199 Bronze; cast, incised, inlaid with silver 46104 H. 7/8 in. (2.2 cm) L. 2 13/16 in. (7.2 cm) Rogers Fund, 1939 Found 34 Nishapur 1514     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/449582 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314821 314821 39.40.50 0 0 449583 Islamic Art 9 Lamp 558 Lamp                             10th–11th century 900 1099 Bronze; cast 44734 H. 11/16 in. (1.7 cm) W. 1 3/4 in. (4.5 cm) L. 2 3/8 in. (6.0 cm) Rogers Fund, 1939 Found 34 Nishapur 1514     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/449583 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
314822 314822 39.40.51 0 0 449584 Islamic Art 9 Mortar 4468 Mortar                             9th–10th century 800 999 Bronze 23 H. 15/16 in. (2.4 cm) Diam. 2 3/8 in. (6 cm) L. (existing) 3 1/8 in. (8 cm) Rogers Fund, 1939 Found 34 Nishapur 1514     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/449584 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315134 315134 40.170.212 0 1 449897 Islamic Art 9 Horse trappings 1625 Horse harness                             10th–11th century 900 1099 Bronze; cast, silvered 46231 L. 1 7/16 in. (3.6 cm) W. 1 1/2 in. (3.8 cm) Th. 1/8 in. (.25 cm) Rogers Fund, 1940 Found 34 Nishapur 1514     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/449897 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315163 315163 40.170.242 0 0 449926 Islamic Art 9 Plaque 75 Plaque                             9th–11th century 800 1099 Bronze; gilded 45289 H. 1 in. (2.6 cm) W. 1/2 in. (1.3 cm) Rogers Fund, 1940 Found 34 Nishapur 1514     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/449926 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315165 315165 40.170.244 0 1 449928 Islamic Art 9 Handle 4249 Handle                             9th–11th century 800 1099 Bronze; cast 44734 L. 5 11/16 in. (14.5 cm) Diam. 9.16 in. (1.5 cm) Rogers Fund, 1940 Found 34 Nishapur 1514     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/449928 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315166 315166 40.170.245 0 1 449929 Islamic Art 9 Pendant 1129 Pendant with Lion and Scorpion                             10th century 900 999 Bronze; cast 44734 Diam. 15/16 in. (2.4 cm) Th. 3/16 in. (0.5 cm) Rogers Fund, 1940 Found 34 Nishapur 1514     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/449929 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315179 315179 40.170.258 0 1 449942 Islamic Art 9 Support fitting 14339 Support fitting                             10th century 900 999 Bronze; cast 44734 H. 2 3/8 in. (6 cm) Max. W. 1 1/8 in. (2.9 cm) Min. W. 3/4 in. (1.9 cm) Depth 1 3/8 in. (3.5 cm) Rogers Fund, 1940 Found 34 Nishapur 1514     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/449942 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315185 315185 40.170.264 0 0 449948 Islamic Art 9 Handle 4249 Handle                             10th century 900 999 Bronze; cast 44734 H. 2 3/16 in. (5.5 cm) W. 1 3/8 in. (3.5 cm) Rogers Fund, 1940 Found 34 Nishapur 1514     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/449948 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315186 315186 40.170.265 0 1 449949 Islamic Art 9 Mirror 3984 Mirror                             12th–13th century 1100 1299 Bronze; cast 44734 Diam. 2 3/8 in. (6 cm) Th. 3/16 in. (0.5 cm) Rogers Fund, 1940 Found 34 Nishapur 1514     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/449949 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315193 315193 40.170.272 0 0 449956 Islamic Art 9 Flask 96 Flask                             10th–11th century 900 1099 Bronze; cast 44734 L. 2 1/4 in. (5.7 cm) W. 1 1/8 in. (2.8 cm) Th. 1/4 in. (.7 cm) Rogers Fund, 1940 Found 34 Nishapur 1514     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/449956 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315196 315196 40.170.276 0 1 449959 Islamic Art 9 Lid 580 Two Bird Finials and a Bird Pin                             10th–11th century 900 1099 Bronze; cast 44734 H. 2 3/8 in. (6 cm) Diam. ca. 1 3/4 in. (4.5 cm) Rogers Fund, 1940 Found 34 Nishapur 1514     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/449959 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
315202 315202 40.170.282 0 1 449965 Islamic Art 9 Weight 4427 Weight                             9th–11th century 800 1099 Bronze; cast 44734 H. 9/16 in. (1.4 cm) Diam. 9/16 in. (1.4 cm) Wt. 14.116g Rogers Fund, 1940 Found 34 Nishapur 1514     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/449965 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
316277 316277 51.56 1 1 451042 Islamic Art 9 Incense burner 4170 Incense Burner of Amir Saif al-Dunya wa’l-Din ibn Muhammad al-Mawardi           Maker 1   Ja`far ibn Muhammad ibn `Ali     Ja'far ibn Muhammad ibn `Ali 44132       dated A.H. 577/ A.D. 1181–82 1166 1207 Bronze; cast, engraved, chased, pierced 46649 OveralL. H. 33 1/2 in. (85.1 cm) L. 32 1/2 in. (82.6 cm) W. 9 in. (22.9 cm) L. from heel of back foot to toe of front foot: 22 in. (55.9 cm) L. from toe of front foot to tip of nose: 4 in. (10.2 cm) L. from heel of back foot to tip of taiL. 7 in. (17.8 cm) Rogers Fund, 1951 Found 34 Taybad 1700     Iran 59             Metal 1   http://www.metmuseum.org/art/collection/search/451042 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
319723 319723 12.182.12 0 1 456075 Islamic Art 9 Knife 141 Knife                             6th century or later 500 599 Iron 13 H. 2 3/16 in. (5.6 cm) W. 5 3/8 in. (13.7 cm) D. 3/16 in. (0.5 cm) Wt. 0.9 oz. (25.5 g) Gift of Herbert E. Winlock, 1912 Found 34 Medinet Habu 1572     Egypt 104             Metal 1   http://www.metmuseum.org/art/collection/search/456075 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
319724 319724 12.180.41a–r 0 1 456076 Islamic Art 9 Nails 14478 Nails                             7th century 600 699 Bronze and iron 12236 Largest: 2 1/2 in. (6.3 cm) Smallest: 1 in. (2.6 cm) Gift of Herbert E. Winlock, 1912 Found 34       Egypt 104             Metal 1   http://www.metmuseum.org/art/collection/search/456076 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
319725 319725 26.3.83 0 0 456077 Islamic Art 9 Pin 238 Pin                             3rd–12th century 200 1199 Iron pin with bronze ring 47551 H. 1 1/8 in. (2.9 cm) W. 1 13/16 in. (4.6 cm) D. 5/16 in. (0.8 cm) Wt. 0.2 oz. (6.5 g) Rogers Fund, 1926 Found 34 Thebes 1556     Egypt 104             Metal 1   http://www.metmuseum.org/art/collection/search/456077 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 685.347ms · Data license: CC0 · Data source: metmuseum/openaccess