MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Classification = 252

View and edit SQL

Suggested facets: Department, Object Name, Title, Object Date, Object Begin Date, Object End Date, Dimensions, Geography Type, Country

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
68843 C.I.43.90.60a, b 0 0 81706 Asian Art 7 Shoes 5896   Chinese 10                           1800–1943 1800 1943 silk, cotton 15149 Length: 6 1/2 in. (16.5 cm) Gift of Mrs. Robert Woods Bliss, 1943                       Accessory-Foot and Leg wear-Womenswear 252   Metropolitan Museum of Art, New York, NY 1
68855 1972.248.5a, b 0 0 81722 Islamic Art 9 Clogs 5914 Clogs                             19th century 1800 1899 wood, mother-of-pearl, metallic thread, metal 15736 Length: 9 in. (22.9 cm) Gift of Mrs. J. Wright Rumbough, 1972 Attributed to 20       Turkey 61             Accessory-Foot and Leg wear-Womenswear 252   Metropolitan Museum of Art, New York, NY 1
69818 2002.164a, b 0 0 83514 Islamic Art 9 Sandals 4088 Sandals                             1920s 1920 1929 Wood, mother-of-pearl, metal wrapped thread, velvet; embroidered 16027 Heel to Toe (a, b): 9 in. (22.9 cm) Heel to Toe (a, b): 11 in. (27.9 cm) Gift of Harold Koda, 2002 Made in 1       Syria 69             Accessory-Foot and Leg wear-Womenswear 252   Metropolitan Museum of Art, New York, NY 1
72353 C.I.63.35.1a, b 0 0 88829 Islamic Art 9 Mules 5926 Mules                             19th century 1800 1899 Silk, leather, metal wrapped thread, sequins; embroidered 16656 Length: 10 in. (25.4 cm) Purchase, Irene Lewisohn Bequest, 1963 Attributed to 20       Turkey 61             Accessory-Foot and Leg wear-Womenswear 252   Metropolitan Museum of Art, New York, NY 1
72356 C.I.48.69.31a, b 0 0 88834 Islamic Art 9 Slippers 5749 Slippers                             1800–1948 1800 1948 Leather, silk, metal wrapped thread, cotton; embroidered 16658 Length: 10 in. (25.4 cm) Gift of Karl M. Stone, 1948 (none assigned) 9         Middle East 20           Accessory-Foot and Leg wear-Womenswear 252   Metropolitan Museum of Art, New York, NY 1
72363 C.I.51.88.1a, b 0 0 88856 Islamic Art 9 Mules 5926 Mules                             late 19th–early 20th century 1875 1925 Silk, metal, wood, leather 16660 Heel to Toe: 10 1/4 in. (26 cm) Gift of Alberta Welch, 1951 (none assigned) 9       Turkey 61             Accessory-Foot and Leg wear-Womenswear 252   Metropolitan Museum of Art, New York, NY 1
72365 C.I.39.91.44a, b 0 0 88863 Islamic Art 9 Slippers 5749 Slippers                             19th century 1800 1899 Wood, silver, leather 16662 [no dimensions available] Gift of Irene Lewisohn and Alice Lewisohn Crowley, 1939 Made in 1       Turkey 61             Accessory-Foot and Leg wear-Womenswear 252   Metropolitan Museum of Art, New York, NY 1
72373 C.I.43.13.24a, b 0 0 88882 Islamic Art 9 Boots 5898 Boots                             1800–1943 1800 1943 Silk, metal wrapped thread; embroidered 15375 [no dimensions available] Gift of Mrs. John Jay Whitehead, 1943 Made in 1       Russia 60             Accessory-Foot and Leg wear-Womenswear 252   Metropolitan Museum of Art, New York, NY 1
72391 1984.64.4b 0 0 88992 Asian Art 7 Geta 6193   Japanese 35                           late 19th–early 20th century 1875 1925 wood, raffia, natural fibers 16671 Length (b): 9 1/4 in. (23.5 cm) Height (b; of heel): 1 1/2 in. (3.8 cm) Gift of Mr. and Mrs. John A. Traina, Jr., 1984                       Accessory-Foot and Leg wear-Womenswear 252   Metropolitan Museum of Art, New York, NY 1
76239 13.49.38a, b 0 0 98049 Islamic Art 9 Boots 5898 Boots                             19th century 1800 1899 Embroidered 2112 Length: 9 3/4 x 14 3/4 in. (24.8 x 37.5 cm) Gift of Mrs. Frank D. Millet, 1913 Made in 1       Russia 60             Accessory-Foot and Leg wear-Womenswear 252   Metropolitan Museum of Art, New York, NY 1
93444 2011.24a, b 0 0 162816 Islamic Art 9 Sandals 4088 Sandals                             19th century 1800 1899 Wood, mother-of-pearl, silver 19748 Height: 12 in. (30.5 cm) Purchase, Gould Family Foundation Gift, in memory of Jo Copeland, 2011 Made in 1       Turkey 61             Accessory-Foot and Leg wear-Womenswear 252   Metropolitan Museum of Art, New York, NY 1
396324 2014.261a, b 0 0 649794 Islamic Art 9 Sandals 4088 Sandals                             late 19th century 1850 1899 Metal, wood, synthetic 58771 Heel to Toe (a, b): 9 13/16 in. (25 cm) Alfred Z. Soloman-Janet A. Sloane Endowment Fund, 2014 From 19       Turkey 61             Accessory-Foot and Leg wear-Womenswear 252   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 238.379ms · Data license: CC0 · Data source: metmuseum/openaccess