MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

14 rows where Artist Alpha Sort = 9728

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Department, Object Name, Title, Artist Role, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

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
108493 108493 29.118.1 0 1 196513 European Sculpture and Decorative Arts 3 Side table 1235 Side table British 6         Designer 5 Probably after a design by John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 ca. 1780 1775 1785 Carved, painted and gilded pine and mahogany; gilt bronze and gilt copper 21910 Overall: 30 1/2 × 46 × 21 in. (77.5 × 116.8 × 53.3 cm) Fletcher Fund, 1929                       Woodwork-Furniture 321   http://www.metmuseum.org/art/collection/search/196513 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
235191 235191 35.73.2 0 1 362950 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for a Mirror           Artist 2   John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 late 18th–early 19th century 1770 1821 Pen and ink and wash 34014 sheet: 14 5/8 x 8 3/4 in. (37.1 x 22.2 cm) Harris Brisbane Dick Fund, 1935                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/362950 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
235192 235192 35.73.3 0 1 362951 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for a Chimneypiece           Artist 2   John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 late 18th–early 19th century 1770 1821 Pen and ink and wash 34014 sheet: 16 1/8 x 11 in. (41 x 27.9 cm) Harris Brisbane Dick Fund, 1935                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/362951 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
235194 235194 35.73.8 0 1 362953 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for a Mirror Surmounted by a Vase           Artist 2   John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 late 18th–early 19th century 1770 1821 Pen and ink and wash 34014 sheet: 11 3/4 x 7 5/8 in. (29.8 x 19.4 cm) Harris Brisbane Dick Fund, 1935                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/362953 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
235195 235195 35.73.9 0 1 362954 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for a Oblong Mirror with Sconces           Artist 2   John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 late 18th–early 19th century 1770 1821 Pen and ink and wash 34014 sheet: 8 7/8 x 12 in. (22.5 x 30.5 cm) Harris Brisbane Dick Fund, 1935                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/362954 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
235196 235196 35.73.10 0 1 362955 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for an Oval Mirror           Artist 2   John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 late 18th–early 19th century 1770 1821 Pen and ink and wash 34014 sheet: 15 5/8 x 8 1/4 in. (39.7 x 21 cm) Harris Brisbane Dick Fund, 1935                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/362955 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
235197 235197 35.73.11 0 1 362956 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for a a Mirror with a Rounded Top           Artist 2   John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 late 18th–early 19th century 1770 1821 Pen and ink and watercolor 29423 sheet: 12 1/4 x 8 7/8 in. (31.1 x 22.5 cm) Harris Brisbane Dick Fund, 1935                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/362956 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
235198 235198 35.73.12 0 1 362957 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for a Chimneypiece           Artist 2   John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 late 18th–early 19th century 1770 1821 Pen and ink and watercolor 29423 sheet: 9 1/4 x 10 3/4 in. (23.5 x 27.3 cm) Harris Brisbane Dick Fund, 1935                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/362957 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
235199 235199 35.73.13 0 1 362958 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for a Chimneypiece           Artist 2   John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 late 18th–early 19th century 1770 1821 Pen and ink and watercolor 29423 sheet: 10 5/8 x 14 3/8 in. (27 x 36.5 cm) Harris Brisbane Dick Fund, 1935                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/362958 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
235200 235200 35.73.15 0 1 362959 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for a Chimneypiece           Artist 2   John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 late 18th–early 19th century 1770 1821 Pen and ink and watercolor 29423 sheet: 10 1/4 x 10 1/4 in. (26 x 26 cm) Harris Brisbane Dick Fund, 1935                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/362959 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
235201 235201 35.73.16 0 1 362960 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for a Chimneypiece           Artist 2   John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 late 18th–early 19th century 1770 1821 Pen and ink and watercolor 29423 sheet: 12 x 10 1/4 in. (30.5 x 26 cm) Harris Brisbane Dick Fund, 1935                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/362960 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
235202 235202 35.73.18 0 1 362961 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for a Chimneypiece           Artist 2   John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 late 18th–early 19th century 1770 1821 Pen and ink and wash 34014 sheet: 10 1/4 x 12 1/8 in. (26 x 30.8 cm) Harris Brisbane Dick Fund, 1935                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/362961 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
235203 235203 35.73.19 0 1 362962 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for a Chimneypiece           Artist 2   John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 late 18th–early 19th century 1770 1821 Pen and ink and watercolor 29423 sheet: 14 1/2 x 10 in. (36.8 x 25.4 cm) Harris Brisbane Dick Fund, 1935                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/362962 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
236364 236364 34.78.2(53) 0 1 364243 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for a Sconce with a Mirror           Artist 2   John Yenn British, London (?) 1750–1821 London   Yenn, John 9728 British 7 1750 1821 late 18th–early 19th century 1770 1821 Pen and wash 34306 sheet: 5/8 x 9 7/8 in. (1.6 x 25.1 cm) Harris Brisbane Dick Fund, 1934                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/364243 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 130.321ms · Data license: CC0 · Data source: metmuseum/openaccess