MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

17 rows where Medium = 42207

View and edit SQL

Suggested facets: Title, Object Date, Object Begin Date, Object End Date, Dimensions

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
261617 20.40.1(44) 0 1 390520 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Cornices, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 ca. 1753–62 1748 1758 Black ink, gray ink, gray wash 42207 sheet: 8 7/8 x 14 in. (22.5 x 35.5 cm) Rogers Fund, 1920                       Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261618 20.40.1(45) 0 1 390521 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Bed Pillars, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 1759 1759 1759 Black ink, gray ink, gray wash 42207 sheet: 13 7/8 x 8 7/8 in. (35.2 x 22.6 cm) Rogers Fund, 1920   London 14                   Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261619 20.40.1(46) 0 1 390522 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Bed Pillars, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 1762 1762 1762 Black ink, gray ink, gray wash 42207 sheet: 13 7/8 x 8 13/16 in. (35.2 x 22.4 cm) Rogers Fund, 1920                       Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261621 20.40.1(48) 0 1 390524 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Frames for Marble Slabs, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 1760 1760 1760 Black ink, gray ink, gray wash 42207 sheet: 8 1/2 x 12 3/4 in. (21.7 x 32.4 cm) Rogers Fund, 1920   London 14                   Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261622 20.40.1(49) 0 1 390525 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Sideboard Tables, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 ca. 1753–62 1748 1758 Black ink, gray ink, gray wash 42207 sheet: 13 7/16 x 8 7/16 in. (34.1 x 21.4 cm) Rogers Fund, 1920                       Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261623 20.40.1(50) 0 1 390526 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Frames for Marble Slabs, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 1754 1754 1754 Black ink, gray ink, gray wash 42207 sheet: 5 7/16 x 7 15/16 in. (13.8 x 20.2 cm) Rogers Fund, 1920   London 14                   Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261624 20.40.1(51) 0 1 390527 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Frames for Marble Slabs, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 1754 1754 1754 Black ink, gray ink, gray wash 42207 sheet: 4 13/16 x 7 in. (12.2 x 17.8 cm) Rogers Fund, 1920   London 14                   Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261625 20.40.1(52) 0 1 390528 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Sideboard Table, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 1760 1760 1760 Black ink, gray ink, gray wash 42207 sheet: 6 9/16 x 4 in. (16.7 x 10.2 cm) Rogers Fund, 1920   London 14                   Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261632 20.40.1(59) 0 1 390535 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Pier Glass Frames, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 1754 1754 1754 Black ink, gray ink, gray wash 42207 sheet: 12 1/16 x 7 1/8 in. (30.6 x 18.2 cm) Rogers Fund, 1920   London 14                   Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261633 20.40.1(60) 0 1 390536 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Pier Glass Frames, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 1754 1754 1754 Black ink, gray ink, gray wash 42207 sheet: 12 3/8 x 7 1/2 in. (31.4 x 19.1 cm) Rogers Fund, 1920   London 14                   Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261634 20.40.1(61) 0 1 390537 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Pier Glass Frames, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 1754 1754 1754 Black ink, gray ink, gray wash 42207 sheet: 11 9/16 x 6 5/16 in. (29.4 x 16 cm) Rogers Fund, 1920   London 14                   Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261635 20.40.1(62) 0 1 390538 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Pier Glass Frames, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 1754 1754 1754 Black ink, gray ink, gray wash 42207 sheet: 12 1/8 x 6 3/4 in. (30.8 x 17.1 cm) Rogers Fund, 1920   London 14                   Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261636 20.40.1(63) 0 1 390539 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Pier Glass Frames, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 1754 1754 1754 Black ink, gray ink, gray wash 42207 sheet: 10 7/8 x 6 5/8 in. (27.6 x 16.8 cm) Rogers Fund, 1920   London 14                   Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261639 20.40.1(66) 0 1 390542 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Shields for Pediments, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 1754 1754 1754 Black ink, gray ink, gray wash 42207 sheet: 5 7/8 x 8 3/8 in. (14.8 x 21.3 cm) Rogers Fund, 1920   London 14                   Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261640 20.40.1(67) 0 1 390543 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Shields for Pediments, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 1754 1754 1754 Black ink, gray ink, gray wash 42207 sheet: 5 7/8 x 8 3/8 in. (14.8 x 21.3 cm) Rogers Fund, 1920   London 14                   Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261646 20.40.1(73) 0 1 390549 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Design for a Neo-Gothic Chimneypiece, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 ca. 1760–70 1755 1765 Black ink, gray ink, gray wash 42207 sheet: 11 7/16 x 6 7/8 in. (29.1 x 17.5 cm) Rogers Fund, 1920                       Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
261647 20.40.1(74) 0 1 390550 Drawings and Prints 11 Drawing Ornament and Architecture 13862 Mirror with Sconces, in Chippendale Drawings, Vol. I           Artist 2   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 ca. 1753–62 1748 1758 Black ink, gray ink, gray wash 42207 sheet: 11 1/2 x 7 1/4 in. (29.1 x 18.4 cm) Rogers Fund, 1920                       Drawings|Ornament & Architecture 671   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 126.537ms · Data license: CC0 · Data source: metmuseum/openaccess