MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Subregion = 153

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Title, Period, Dynasty, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Geography Type

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
351326 351326 10.176.48 0 0 544016 Egyptian Art 19 Bottle with ribbed neck 17657 Bottle with ribbed neck   Second Intermediate Period Second Intermediate Period 43                       ca. 1700–1550 B.C. -1700 -1550 Anhydrite 55653   Rogers Fund, 1910 From|Said to be from 74   | 96   Egypt 104 Northern Upper Egypt 644 Girga (Thinis) 153             http://www.metmuseum.org/art/collection/search/544016 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
351345 351345 10.176.54a, b 0 1 544035 Egyptian Art 19 Ointment jar, baboon 17669 Ointment jar in the shape of a baboon   Middle Kingdom Dynasty 13–17 35                       ca. 1800–1550 B.C. -1800 -1800 Anhydrite 55653 H. 13.3 cm (5 1/4 in.); W. 5.9 cm (2 5/16 in.); D. 8.2 cm (3 1/4 in.) Rogers Fund, 1910 From|Said to be from 74   | 96   Egypt 104 Northern Upper Egypt 644 Girga (Thinis) 153             http://www.metmuseum.org/art/collection/search/544035 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
351346 351346 12.182.77a–d 0 1 544036 Egyptian Art 19 Ointment jar, baboons holding a jar 17670 Ointment vessel in the shape of two baboons holding a jar   Middle Kingdom Dynasty 13–17 35                       ca. 1800–1550 B.C. -1800 -1800 Anhydrite 55653 h. 9.8 cm (3 7/8 in) Rogers Fund, 1912 From|Said to be from 74   | 96   Egypt 104 Northern Upper Egypt 644 Girga (Thinis) 153             http://www.metmuseum.org/art/collection/search/544036 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
351350 351350 10.176.52 0 1 544040 Egyptian Art 19 Ointment jar, bulti fish 17674 Ointment vase in the shape of a bulti fish   Middle Kingdom Dynasty 12–17 23                       ca. 1800–1550 B.C. -1800 -1800 Anhydrite 55653   Rogers Fund, 1910 From|Said to be from 74   | 96   Egypt 104 Northern Upper Egypt 644 Girga (Thinis) 153             http://www.metmuseum.org/art/collection/search/544040 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
351546 351546 10.176.51 0 0 544239 Egyptian Art 19 Flask in the shape of two trussed geese 17829 Flask in the shape of two trussed geese   Second Intermediate Period Second Intermediate Period 43                       ca. 1700–1550 B.C. -1700 -1550 Anhydrite 55653 H. 11 × W. 9.9 × D. 5.3 cm (4 5/16 × 3 7/8 × 2 1/16 in.) Rogers Fund, 1910 From|Said to be from 74   | 96   Egypt 104 Northern Upper Egypt 644 Girga (Thinis) 153             http://www.metmuseum.org/art/collection/search/544239 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
351547 351547 10.176.50 0 0 544240 Egyptian Art 19 Flask, goose 17830 Flask in the form of a trussed goose   Second Intermediate Period Second Intermediate Period 43                       ca. 1700–1550 B.C. -1700 -1550 Anhydrite 55653 H. 15.3 × W. 8 × D. 6.8 cm (6 × 3 1/8 × 2 11/16 in.) Rogers Fund, 1910 From|Said to be from 74   | 96   Egypt 104 Northern Upper Egypt 644 Girga (Thinis) 153             http://www.metmuseum.org/art/collection/search/544240 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
351548 351548 12.182.76a, b 0 0 544241 Egyptian Art 19 Bottle in the shape of a trussed goose 17831 Bottle in the shape of a trussed goose   Middle Kingdom–Early New Kingdom Second Intermediate Period 43                       ca. 1700–1550 B.C. -1700 -1550 Anhydrite 55653 Diam. 6.2 × H. 9.5 cm (2 7/16 × 3 3/4 in.) Rogers Fund, 1912 From|Said to be from 74   | 96   Egypt 104 Northern Upper Egypt 644 Girga (Thinis) 153             http://www.metmuseum.org/art/collection/search/544241 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
362472 362472 13.126.9 0 0 555930 Egyptian Art 19 Jar 116 Jar   Middle Kingdom Dynasty 11–17 261                       ca. 2124–1580 B.C. -2124 -2124 Pottery 7419 Ht. 18.5 × Diam. 8.3 cm (7 5/16 × 3 1/4 in.) Anonymous Gift, 1913 From 19       Egypt 104 Northern Upper Egypt 644 Girga (Thinis) 153     Hearst Egyptian Expedition 279       http://www.metmuseum.org/art/collection/search/555930 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
363113 363113 10.176.46 0 0 556579 Egyptian Art 19 Bottle 48 Jar   Late Second Intermediate Period Dynasty 17 42                       ca. 1580–1550 B.C. -1580 -1550 Anhydrite 55653   Rogers Fund, 1910 From|Said to be from 74   | 96   Egypt 104 Northern Upper Egypt 644 Girga (Thinis) 153             http://www.metmuseum.org/art/collection/search/556579 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
363114 363114 10.176.53 0 0 556580 Egyptian Art 19 Lentoid flask 23648 Lentoid flask   Second Intermediate Period Second Intermediate Period 43                       ca. 1700–1550 B.C. -1700 -1550 Anhydrite 55653   Rogers Fund, 1910 From|Said to be from 74   | 96   Egypt 104 Northern Upper Egypt 644 Girga (Thinis) 153             http://www.metmuseum.org/art/collection/search/556580 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
363880 363880 11.150.29 0 0 557548 Egyptian Art 19 Slender bottle 23918 Slender Bottle   Late Second Intermediate Period Dynasty 17 42                       ca. 1580–1550 B.C. -1580 -1550 Anhydrite 55653 Diam. 7 × H. 15 cm (2 3/4 × 5 7/8 in.) Rogers Fund, 1911 From|Said to be from 74   | 96   Egypt 104 Northern Upper Egypt 644 Girga (Thinis) 153             http://www.metmuseum.org/art/collection/search/557548 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
375734 375734 30.7.3 0 1 573649 Egyptian Art 19 Model, Weavers 26088 Fragmentary Model of a Weavers Shop   Middle Kingdom                         ca. 2030–1640 B.C. -2030 -1640 Wood, gesso, paint 55718 L. 59 cm (23 1/4 in); W. 35.5 cm (14 in); H. 22 cm (8 11/16 in) Anonymous Gift, 1930 From|Said to be from 74   | 96   Egypt 104 Northern Upper Egypt 644 Girga (Thinis) 153             http://www.metmuseum.org/art/collection/search/573649 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 225.717ms · Data license: CC0 · Data source: metmuseum/openaccess