MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Medium = 2473

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Culture, Artist Role, Artist Nationality, Credit Line, City, 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 Repository
14409 1996.381 0 1 15595 American Decorative Arts 1 Vase 7 Vase American 1         Maker|Maker 6   Volkmar Ceramic Company|Charles Volkmar ca.1893–ca.1902|American, Baltimore, Maryland 1841–1914 Metuchen, New Jersey   Volkmar Ceramic Company|Volkmar, Charles 2322 American 1 1890 |1841 1902 |1914 1896–1902 1896 1902 White earthenware 2473 7 7/8 x 4 5/8 in. (20 x 11.7 cm) Gift of Dr. Clark S. Marlor, in memory of Warren Zerbe, 1996 Made in 1 New York 3 Queens 32 Queens 32 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
14423 1997.57 0 1 15659 American Decorative Arts 1 Plaque 75 Plaque American 1         Decorator|Manufacturer 21 Manufactured by John Mackie Falconer|James Carr New York City Pottery American, Edinburgh 1820–1903 New York   Falconer, John Mackie|Carr, New York City Pottery James 2323 American 1 1820 1903 |9999 1878 1878 1878 White earthenware 2473 19 x 23 1/2 in. (48.3 x 59.7 cm) Gift of Emma and Jay Lewis, 1997 Made in 1 New York 3     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
16933 2011.321.1 0 1 20737 American Decorative Arts 1 Vase 7 Vase American 1         Maker 1   John Bennett 1840–1907   Bennett, John 830   1840 1907 1877 1877 1877 White earthenware 2473 6 1/2 in. (16.5 cm) Gift of Emma and Jay Lewis, 2011 Made in 1 New York 3     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
16945 2011.321.21 0 0 20749 American Decorative Arts 1 Vase 7 Vase American 1         Maker 1   Odell & Booth Brothers 1880–1884   Odell & Booth Brothers 2632   1880 1880 1880–84 1880 1884 White earthenware 2473 10 in. (25.4 cm) Gift of Emma and Jay Lewis, 2011 Made in 1 Tarrytown 405     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
30831 1992.297.3 0 1 36447 Asian Art 7 Cup 107   China 51 Neolithic period, late Dawenkou culture                         2800–2400 B.C. -2800 -2400 White earthenware 2473 H. 6 3/4 in. (17.2 cm); Diam. of mouth 3 3/16 in. (8.1 cm) Rogers and Seymour Funds, 1992                       Ceramics 5   Metropolitan Museum of Art, New York, NY 1
117961 1981.454.7 0 0 206906 European Sculpture and Decorative Arts 3 Dessert dish 1091 Dessert dish Italian, Milan 120         Maker 1   Società Ceramica Richard     Richard Società Ceramica 11592       ca. 1890–99 1885 1904 White earthenware 2473 7/8 × 7 15/16 in. (2.2 × 20.2 cm) Gift of Madame Lilliana Teruzzi, 1981                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
140536 2013.239.14 0 1 239492 European Sculpture and Decorative Arts 3 Vase 7 Vase with mythological scenes French, Paris 114         Maker|Decorator 35   Joseph-Théodore Deck|Auguste-Alexandre Hirsch French, Guebwiller, Alsace 1823–1891 Paris|French, 1833–1912   Deck, Joseph-Théodore|Hirsch, Auguste-Alexandre 12900 French|French 21 1823 |1833 1891 |1912 1867 1867 1867 White earthenware 2473 Overall (confirmed): 26 1/4 × 14 1/8 in., 26.3 lb. (66.7 × 35.9 cm, 12 kg) Robert A. Ellison Jr. Collection, Gift of Robert A. Ellison Jr., 2013                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
336654 1985.3.1 0 0 484189 Modern and Contemporary Art 4 Water tray 15185 Water tray           Designer 5   Betty Woodman American, Norwalk, Connecticut, 1930–2018 New York   Woodman, Betty 45594 American 1 1930 2018 1978 1978 1978 White earthenware 2473 H.9, W.16-1/2, D.9-3/4 in. (20.3 x 41.9 x 24.8 cm.) Purchase, Louis Comfort Tiffany Foundation Gift, 1985                       Ceramics-Pottery 314   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 147.607ms · Data license: CC0 · Data source: metmuseum/openaccess