MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

18 rows where Medium = 30131

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Title, Artist Role, Artist Display Name, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Dimensions, 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
208472 208472 67.547.1–.15 0 0 335835 Drawings and Prints 11 Drawing 23 Chinese Tables, Vases and Objects           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/335835 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
236046 236046 49.93.9 0 1 363891 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Design for an Enameled Watchcase and Châtelaine with Mythological Figures           Artist 2   George Michael Moser Swiss (active Britain), Schaffhausen 1706–1783 London   Moser, George Michael 32174 Swiss 61 1706 1783 ca. 1766 (?) 1761 1771 Pen and ink and gouache 30131 sheet: 8 11/16 x 6 3/8 in. (22 x 16.2 cm) frame: 21 x 16 in. (53.3 x 40.6 cm) Gift of Janos Scholz, 1949                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/363891 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
256153 256153 67.827.196 0 1 384824 Drawings and Prints 11 Drawing 23 Design for the painted decoration of panels           Artist|Artist 13   Jules-Edmond-Charles Lachaise|Eugène-Pierre Gourdet French, died 1897|French, born Paris, 1820–1889   Lachaise, Jules-Edmond-Charles|Gourdet, Eugène-Pierre 20300 French|French 21 1897 |1820 1897 |1889 second half 19th century 1845 1900 Pen and ink and gouache 30131 sheet: 14 5/8 x 10 11/16 in. (37.1 x 27.2 cm) Dodge Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/384824 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258523 258523 67.547.1 0 1 387217 Drawings and Prints 11 Drawing 23 Hanging Lantern           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387217 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258524 258524 67.547.2 0 1 387218 Drawings and Prints 11 Drawing 23 Hanging Lantern           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387218 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258525 258525 67.547.3 0 1 387219 Drawings and Prints 11 Drawing 23 Hanging Lantern           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387219 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258526 258526 67.547.4 0 1 387220 Drawings and Prints 11 Drawing 23 Hanging Lantern           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387220 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258527 258527 67.547.5 0 1 387221 Drawings and Prints 11 Drawing 23 Table with Ornamental Objects           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387221 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258528 258528 67.547.6 0 1 387222 Drawings and Prints 11 Drawing 23 Two Low Tables with Ornamental Objects           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387222 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258529 258529 67.547.7 0 1 387223 Drawings and Prints 11 Drawing 23 Small Stove and Two Tall Objects           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387223 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258530 258530 67.547.8 0 1 387224 Drawings and Prints 11 Drawing 23 Low Table with Vases           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387224 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258531 258531 67.547.9 0 1 387225 Drawings and Prints 11 Drawing 23 Large Table and Two Small Higher Ones with Vases           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387225 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258532 258532 67.547.10 0 1 387226 Drawings and Prints 11 Drawing 23 Table with Three Levels with Ornamental Objects           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387226 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258533 258533 67.547.11 0 1 387227 Drawings and Prints 11 Drawing 23 Long, Low Purple Lacquer Table with Objects           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387227 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258534 258534 67.547.12 0 1 387228 Drawings and Prints 11 Drawing 23 Two Tables, One Blond the Other Purple Lacquer, both with Vases and Objects           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387228 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258535 258535 67.547.13 0 1 387229 Drawings and Prints 11 Drawing 23 Long Dark Table with Decorative Objects           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387229 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258536 258536 67.547.14 0 1 387230 Drawings and Prints 11 Drawing 23 Two Tables, One Low with Large Vase and Objects, One Higher with Covered Pot, Lion and Small Bowl           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387230 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
258537 258537 67.547.15 0 1 387231 Drawings and Prints 11 Drawing 23 Two Tables with a Purple Finish, One with a Red Vase, the Other with Three Vases           Artist 2   Anonymous, Chinese, 19th century     Anonymous, Chinese, 19th century 18245 Chinese 116 1800 1900 19th century 1800 1900 Pen and ink and gouache 30131 Overall: 14 1/8 x 18 3/8 in. (35.9 x 46.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Drawings 9   http://www.metmuseum.org/art/collection/search/387231 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 138.035ms · Data license: CC0 · Data source: metmuseum/openaccess