MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

19 rows where City = 1527 and Geography Type = 35

View and edit SQL

Suggested facets: Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, Credit Line

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
311221 09.217.1a, b 0 1 445964 Islamic Art 9 Frieze fragment 7204 Fragment from a Frieze with Meander Pattern and Diamond-Shaped Rosettes                             6th century 500 599 Limestone; carved in relief 45017 H. 13 3/4 in. (34.9 cm) W. 44 1/8 in. (112.1 cm) Rogers Fund, 1909 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
311222 09.217.3 0 1 445965 Islamic Art 9 Frieze fragment 7204 Fragment from a Molding with Acanthus Clusters under Arcades                             5th–6th century 400 599 Limestone; carved in relief 45017 H. 7 in. (17.8 cm) W. 43 5/8 in. (110.8 cm) Rogers Fund, 1909 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
311394 10.176.4 0 1 446137 Islamic Art 9 Frieze 463 Panel with Animals Flanking a Vase                             6th–7th century 500 599 Limestone; carved 45230 H. 9 7/8 in. (25.1 cm) W. 40 3/4 in. (103.5 cm) D. 2 3/4 in. (7 cm) Wt. 100 lbs. (45.4 kg) Rogers Fund, 1910 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
311399 10.176.14 0 1 446142 Islamic Art 9 Frieze 463 Frieze                             5th–7th century 400 600 Limestone; carved in relief 45017 47 3/8 x 4 9/16 x 3 3/16 in. (120.3 x 11.6 x 8.1 cm) Rogers Fund, 1910 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
311402 10.176.19 0 1 446145 Islamic Art 9 Block 262 Fragment from a Post or Lintel with Leaves Branching from a Running Vine                             6th–7th century 500 699 Limestone; carved in relief 45017 H. 7 1/4 in. (18.4 cm) W. 35 7/16 in. (90 cm) D. 3 5/8 in. (9.2 cm) Rogers Fund, 1910 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
313469 29.9.2 0 1 448226 Islamic Art 9 Arch 14291 Arch with Running Vines, Leaves, and Fruit                             6th century 500 599 Limestone 1737   Gift of Edward S. Harkness, 1929 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
318806 09.217.14 0 1 453602 Islamic Art 9 Frieze fragment 7204 Fragment from a Frieze with a Meander Pattern and Rosettes                             6th century 500 599 Limestone; carved 45230 22 7/16 x 11 13/16 x 1 3/4 in. (57 x 30 x 4.5 cm) Rogers Fund, 1909 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
318807 09.217.5 0 1 453603 Islamic Art 9 Frieze fragment 7204 Fragment from a Frieze with Meander Pattern and Rosettes                             500–600 500 600 Limestone 1737 H. 11 13/16 in. (30 cm) W. 29 1/8 in. (74 cm) D. 2 3/16 in. (5.5 cm) Rogers Fund, 1909 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
318831 10.176.1 0 1 453627 Islamic Art 9 Fragment 486 Fragment of a Frieze with a Saint                             5th–6th century 400 599 Limestone; carved in relief 45017   Rogers Fund, 1910 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
318870 14.7.5 0 1 453854 Islamic Art 9 Capital 176 Capital                             ca. 6th century 500 599 Limestone; carved 45230 H. 18 7/8 in. (47.9 cm) W. D. Wt. 406 lbs. (184.2 kg) Gift of Edward S. Harkness, 1914 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
318876 10.176.12 0 1 453860 Islamic Art 9 Fragment 486 Fragment from a Molding with Vines and an Amphora (Vase)                             6th century 500 599 Limestone; carved in relief 45017   Rogers Fund, 1910 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
318928 07.228.38 0 1 454042 Islamic Art 9 Frieze fragment 7204 Corner Block from a Frieze with a Meander Pattern of Lines and Rosettes                             6th century 500 599 Limestone; carved in relief 45017 H. 5 7/8 in. (15 cm) W. 18 7/8 in. (15 cm) D. 4 5/16 in. (11 cm) Rogers Fund, 1907 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
318932 10.176.21 0 1 454052 Islamic Art 9 Frieze 463 Fragment of a Frieze with the Miracle of Loaves and Fishes                             6th–7th century 500 699 Limestone; carved 45230 H. 9 5/8 in. (24.5 cm) W. 39 38 in. (100 cm) D. 4 1/2 in. (11.4 cm) W. 112 lb. (50.8 kg) Rogers Fund, 1910 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
319730 07.228.39 0 1 456082 Islamic Art 9 Fragment 486 Fragment from a Molding with Rosettes and Acanthus Clusters                             5th–6th century 400 599 Limestone; carved in relief 45017 H. 7 11/16 in. (19.5 cm) W. 38 1/2 in. (97.8 cm) D. 3 9/16 in. (9 cm) Rogers Fund, 1907 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
319736 09.217.10 0 1 456088 Islamic Art 9 Column fragment 11571 Engaged Column Part with Meander Pattern                             ca. 6th century 500 599 Limestone; carved 45230 H. 12 3/8 in. (31.4 cm) W. 8 7/16 in. (21.4 cm) D. 10 1/4 in. (26 cm) Wt. 64 lbs. (29 kg) Rogers Fund, 1909 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
319740 10.176.11 0 1 456092 Islamic Art 9 Fragment 486 Fragment of a Frieze with Vine Scrolls Bearing Grapes                             6th–7th century 500 699 Limestone; carved in relief 45017 H. 23 5/8 in. (60 cm) W. 12 5/8 in. (32 cm) D. 2 3/8 in. (6 cm) Rogers Fund, 1910 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
319741 10.176.13 0 1 456093 Islamic Art 9 Molding fragment 7228 Fragment from a Molding with Rosettes and Acanthus Clusters                             5th–6th century 400 599 Limestone; carved in relief 45017 H. 27 1/2 in. (69.9 cm) W. 7 1/8 in. (18.1 cm) D. 7 7/8 in. (20 cm) Rogers Fund, 1910 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
319742 10.176.16 0 1 456094 Islamic Art 9 Panel Fragment 13193 Panel with Grapevine Emerging from a Bed of Leaves                             6th–7th century 500 699 Limestone; carved 45230 H. 26 3/4 in. (68 cm) W. 11 13/16 in. (30 cm) D. 2 3/4 in. (7 cm) Wt. 52 lbs. (23.6 kg) Rogers Fund, 1910 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
319748 10.176.160 0 1 456100 Islamic Art 9 Capital 176 Capital with a Basket-Weave Pattern and Rams’ Heads                             5th–6th century 400 599 Limestone; carved in relief 45017 H. 16 1/8 in. (41 cm) Diam. (base) 15 5/8 in. (39.7 cm) Max. W. 41 5/16 in. (105 cm) Rogers Fund, 1910 Said to be from 35 Bawit 1527     Egypt 104             Sculpture 12   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 146.388ms · Data license: CC0 · Data source: metmuseum/openaccess