MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

3 rows where Artist Role = 1023

Search:

descending

Link	rowid ▼	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Artist Role	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	Classification	Rights and Reproduction	Link Resource	Metadata Date	Repository
206781	206781	49.55.163	1	334125	Drawings and Prints 11	Print 731	Portrait Bust of Mademoiselle Marcelle Lender	Artist\|Printer\|Printer\|Publisher 1023	Henri de Toulouse-Lautrec\|Edward Ancourt\|H. Stern\|Pan	French, Albi 1864–1901 Saint-André-du-Bois\|French, 19th century\|Brazilian\|German, 1895–1900	Toulouse-Lautrec, Henri de\|Ancourt, Edward\|H. Stern\|Pan 17411	French\|French\|Brazilian\|German 766	1864 \|1800 \|1895	1901 \|1899 \|1900	1895	1895	1895	Crayon, brush, and spatter lithograph printed in eigt colors with letterpress text on wove paper; fourth state of four (Pan edition 1895) 29117	Image: 13 9/16 x 9 5/8 in. (34.5 x 24.4 cm) Sheet: 14 9/16 x 11 in. (37 x 28 cm)	Alfred Stieglitz Collection, 1949	Prints 13		http://www.metmuseum.org/art/collection/search/334125	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
255057	255057	2008.263a–c	0	383685	Drawings and Prints 11	Print 731	Man Spirit Mask	Artist\|Printer\|Printer\|Publisher 1023	Willie Cole\|Randy Hemminghaus\|Gail Deery\|Brodsky Center for Innovative Editions	American, born Newark, New Jersey, 1955\|American, 20th–21st century\|American, 19th–20th century\|New Brunswick, New Jersey	Cole, Willie\|Hemminghaus, Randy\|Deery, Gail\|Brodsky Center for Innovative Editions 36569	American\|American\|American\|American 97	1955 \|1950 \|1950 \|1900	2055 \|2050 \|2050 \|1999	1999	1999	1999	Left panel: Photo-etching, embossing and hand coloring Middle panel: Silkscreen with lemon juice and scorching Right panel: Photo etching and woodcut 40900	48 7/8 x 26 1/2 in. (124.1 x 67.3 cm) each	Francis Lathrop Fund and John B. Turner Fund, 2008	Prints 13	©2010 Willie Cole	http://www.metmuseum.org/art/collection/search/383685	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
271594	271594	2011.519	0	400755	Drawings and Prints 11	Print 731	Sway	Artist\|Printer\|Printer\|Publisher 1023	Melissa Meyer\|Gregory Burnet\|Brian Rumbolo\|The Metropolitan Museum of Art	American, born New York, 1947	Meyer, Melissa\|Burnet, Gregory\|Rumbolo, Brian\|Metropolitan Museum of Art 40371	American\|American\|American 101	1947	2047	2006	2006	2006	Aquatint with spit bite 43231	plate: 20 x 16 in. (50.8 x 40.6 cm) sheet: 29 1/2 x 24 in. (74.9 x 61 cm)	Gift of the artist, 2011	Prints 13		http://www.metmuseum.org/art/collection/search/400755	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");