MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

4 rows where Artist Prefix = "Attributed to" and Medium = 21

Search:

descending

Link	rowid ▼	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Culture	Artist Role	Artist Prefix	Artist Display Name	Artist Display Bio	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	Classification	Link Resource	Metadata Date	Repository
4800	4800	42.76.14	0	5157	American Decorative Arts 1	Medallion 72	Medallion of Benjamin Franklin	British 6	Artist\|Manufacturer 26	Attributed to	Jean-Baptiste Nini\|Josiah Wedgwood and Sons	Italian, Urbino 1717–1786 Chaumont-sur-Loire\|1759–present	Nini, Jean-Baptiste\|Wedgwood and Sons, Josiah 220	Italian 6	1717 \|1759	1786 \|9999	1760–1800	1760	1800	Earthenware 21	4 1/8 x 3 1/8 in. (10.5 x 7.9 cm)	Purchase, Joseph Pulitzer Bequest, 1942	Made in 1	Stoke-on-Trent 79	Staffordshire 1	Staffordshire 1	England 4	Ceramics 5	http://www.metmuseum.org/art/collection/search/5157	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
5393	5393	1983.206.6	1	5767	American Decorative Arts 1	Pitcher 296	Pitcher	American 1	Maker\|Manufacturer 23	Attributed to	Charles Coxon\|E. & W. Bennett Pottery	1805–1868\|1847–1857	Coxon, Charles\|Bennett, E. and W. 791		1805 \|1847	1805 \|1847	ca. 1850–56	1847	1856	Earthenware 21	H. 8 1/2 in. (21.6 cm)	Gift of Mr. and Mrs. Stanley Herzman, 1983	Made in 1	Baltimore 35			United States 3	Ceramics 5	http://www.metmuseum.org/art/collection/search/5767	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
6243	6243	13.31.18	1	6640	American Decorative Arts 1	Figure 9	Standing poodle	American 1	Manufacturer 20	Attributed to	United States Pottery Company	1852–58	United States Pottery Company 75		1852	1852	1849–58	1849	1858	Earthenware 21	8 1/2 x 9 1/2 in. (21.6 x 24.1 cm)	Rogers Fund, 1913	Made in 1	Bennington 25			United States 3	Ceramics 5	http://www.metmuseum.org/art/collection/search/6640	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
17016	17016	2011.549	0	21184	American Decorative Arts 1	Dedham Pottery Plate 1261	Dedham Pottery Plate	American 1	Maker\|Maker 6	Attributed to	Dedham Pottery\|Joseph Lindon Smith	1895–1943\|American, Pawtucket, Rhode Island 1863–1950 Dublin, New Hampshire	Dedham Pottery\|Smith, Joseph Lindon 2644	American 1	1895 \|1863	1943 \|1950	ca. 1895	1890	1900	Earthenware 21	8 1/2 in. diam.	Gift of John R. Bermingham, 2011	Made in 1	Chelsea 56			United States 3	Ceramics 5	http://www.metmuseum.org/art/collection/search/21184	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

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");