MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Classification = 16 and Is Highlight = 1

View and edit SQL

Suggested facets: Department, Object Name, Title, Artist Begin Date, Artist End Date, Credit Line, Geography Type, Country

Is Highlight

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
12472 38.59 1 1 13606 American Decorative Arts 1 Coverlet 1040 Phebe Warner Coverlet American 1         Maker 1 Probably Sarah Furman Warner Williams born 1764   Furman, Warner Williams Sarah 1973 American 1 1764 1864 ca. 1803 1800 1806 Linen and cotton 2136 103 1/4 x 90 1/2 in. (262.3 x 229.9 cm) Gift of Catharine E. Cotheal, 1938 Made in 1 New York 3     United States 3             Textiles 16   Metropolitan Museum of Art, New York, NY 1
12512 1989.66 1 1 13647 American Decorative Arts 1 Quilt 1039 Quilt Top, Crazy pattern American 1                           ca. 1885 1882 1888 Silk, satin, velvet, and cotton 2153 60 3/4 x 52 in. (154.3 x 132.1 cm) Gift of Tracey Blumenreich Zabar, 1989 Made in 1       United States 3             Textiles 16   Metropolitan Museum of Art, New York, NY 1
12620 48.81 1 1 13763 American Decorative Arts 1 Memorial painting 1069 Memorial painting American 1         Maker 1   Sally Miller     Miller, Sally 2020     9999 1811 1811 1811 Watercolor and ink on silk 2202 28 x 32 3/8 in. (71.1 x 82.2 cm) Rogers Fund, 1948 Made in 1 Litchfield 317     United States 3             Textiles 16   Metropolitan Museum of Art, New York, NY 1
12904 14.26 1 1 14049 American Decorative Arts 1 Sampler 1007 Embroidered Sampler American 1         Maker 1   Patty Coggeshall 1780–1797   Coggeshall, Patty 2081 American 1 1780 1797 ca. 1792 1789 1792 Silk on linen, embroidered 2266 19 1/2 x 16 5/8 in. (49.5 x 42.2 cm) Rogers Fund, 1914 Made in 1 Bristol 2     United States 3             Textiles 16   Metropolitan Museum of Art, New York, NY 1
12947 1984.331.13 1 1 14092 American Decorative Arts 1 Sampler 1007 Embroidered sampler American 1         Maker 1   Rebekah S. Munro 1780–1803   Munro, Rebekah S. 2119   1780 1803 ca. 1791 1788 1791 Embroidered silk on linen 2199 15 3/4 x 11 3/4 in. (40 x 29.8 cm) Gift of Barbara Schiff Sinauer, 1984 Made in 1 Providence 36     United States 3             Textiles 16   Metropolitan Museum of Art, New York, NY 1
16911 2010.466 1 1 20615 American Decorative Arts 1 Sampler 1007 Embroidered sampler American 1         Maker 1 Embroidered by Julia Ann Fitch born 1792   Fitch, Julia Ann 2618   1793 9999 1807 1807 1807 Silk on linen 2281 18 x 15 3/4 in. (45.7 x 40 cm) Framed: 22 in. × 19 1/4 in. × 1 1/4 in. (55.9 × 48.9 × 3.2 cm) Purchase, William Cullen Bryant Fellows Gifts, 2010 Made in 1 Hatfield 403     United States 3             Textiles 16   Metropolitan Museum of Art, New York, NY 1
311474 12.72.5 1 1 446218 Islamic Art 9 Fragment 486 Velvet Panel with Flowering Plants                             first half 17th century 1600 1650 Silk, cotton, flat metal wrapped thread; cut and voided velvet, brocaded 45284 Textile: H. 45 in. (114.3 cm) W. 27 in. (68.6 cm) Mount: H. 52 in. (132.1 cm) W. 32 1/2 in. (82.6 cm) Wt. 30 lbs. (13.6 kg) Rogers Fund, 1912 Attributed to 20       Iran 59             Textiles 16   Metropolitan Museum of Art, New York, NY 1
313537 29.179.9 1 1 448294 Islamic Art 9 Tiraz fragment 14287 Tiraz Textile Fragment                             late 9th–early 10th century 875 925 Cotton, ink, and gold; plain weave, resist-dyed (ikat), painted Inscription: black ink and gold leaf; painted 45714 Textile: L. 23 in. (58.4 cm) W. 16 in. (40.6 cm) Mount: L. 27 1/2 in. (69.9 cm) W. 21 in. (53.3 cm) D. 7/8 in. (2.2 cm) Wt. 8 lbs. (3.6 kg) Gift of George D. Pratt, 1929 Attributed to 20       Yemen 315             Textiles 16   Metropolitan Museum of Art, New York, NY 1
316325 52.20.11 1 1 451091 Islamic Art 9 Fragment 486 Velvet with Figural Imagery                             mid-16th century 1525 1575 Silk, metal wrapped thread; cut and voided velvet 45269 Textile: L. 31 in. (78.7 cm) W. 13 1/2 in. (34.3 cm) Mount: L. 35 5/8 in. (90.5 cm) W. 17 3/8 in. (44.1 cm) D. 3 1/8 in. (7.9 cm) Purchase, Joseph Pulitzer Bequest, 1952 Attributed to 20       Iran 59             Textiles 16   Metropolitan Museum of Art, New York, NY 1
316335 52.20.21 1 1 451101 Islamic Art 9 Fragment 486 Fragmentary Loom Width with Wavy-vine Pattern                             ca. 1565–80 1540 1605 Silk, metal wrapped thread; lampas (kemha) 45007 Textile: L. 48 in. (121.9 cm) W. 26 1/2 in. (67.3 cm) Mount: L. 53 1/4 in. (135.3 cm) W. 32 in. (81.3 cm) D. 1 in. (2.5 cm) Purchase, Joseph Pulitzer Bequest, 1952 Attributed to 20 probably Istanbul 431     Turkey 61             Textiles 16   Metropolitan Museum of Art, New York, NY 1
318268 1981.321 1 1 453054 Islamic Art 9 Tent lining 14432 Floral Tent Panel                             ca. 1635 1610 1660 Silk, gold; cut velvet, painted 47107 Textile: L. 105 3/4 in. (268.6 cm) W. 221 1/4 in. (562 cm) Tube: L. 120 in. (304.8 cm) W. 20 in. (50.8 cm) Purchase, Bequest of Helen W. D. Mileham, by exchange, Wendy Findlay Gift, and funds from various donors, 1981 Attributed to 20       India 27             Textiles 16   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 1084.65ms · Data license: CC0 · Data source: metmuseum/openaccess