Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Department, Object Name, Title, 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, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9135 | 9135 | 1972.20.1 | 0 | 0 | 9849 | American Decorative Arts 1 | Stained glass window 229 | Window from the J. C. Cross House, Minneapolis, Minnesota | American 1 | Manufacturer|Designer 18 | Manufactured by|Designed by | Purcell, Feick and Elmslie|George Grant Elmslie | 1909–13|American, Aberdeenshire 1871–1952 Chicago, Illinois | Purcell, Feick and Elmslie |Elmslie, George Grant 1222 | American 1 | 1909 |1871 | 1913 |1952 | 1911 | 1911 | 1911 | Glass 31 | 63 x 15 in. (160 x 38.1 cm) | Gift of Roger G. Kennedy, 1972 | Made in 1 | Minneapolis 288 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/9849 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||
| 9136 | 9136 | 1972.20.2 | 0 | 0 | 9850 | American Decorative Arts 1 | Stained glass window 229 | Window from the J. C. Cross House, Minneapolis, Minnesota | American 1 | Designer|Manufacturer 3 | Designed by|Manufactured by | George Grant Elmslie|Purcell, Feick and Elmslie | American, Aberdeenshire 1871–1952 Chicago, Illinois|1909–13 | Elmslie, George Grant|Purcell, Feick and Elmslie 1223 | American 1 | 1871 |1909 | 1952 |1913 | 1911 | 1911 | 1911 | Glass 31 | 63 x 15 in. (160 x 38.1 cm) | Gift of Roger G. Kennedy, 1972 | Made in 1 | Minneapolis 288 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/9850 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||
| 9137 | 9137 | 1972.20.3 | 0 | 0 | 9851 | American Decorative Arts 1 | Stained glass window 229 | Window from the J. C. Cross House, Minneapolis, Minnesota | American 1 | Designer|Manufacturer 3 | Designed by|Manufactured by | George Grant Elmslie|Purcell, Feick and Elmslie | American, Aberdeenshire 1871–1952 Chicago, Illinois|1909–13 | Elmslie, George Grant|Purcell, Feick and Elmslie 1223 | American 1 | 1871 |1909 | 1952 |1913 | 1911 | 1911 | 1911 | Glass 31 | 63 x 15 in. (160 x 38.1 cm) | Gift of Roger G. Kennedy, 1972 | Probably made in 2 | Minneapolis 288 | United States 3 | Glass 3 | http://www.metmuseum.org/art/collection/search/9851 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||
| 12516 | 12516 | 1987.400 | 0 | 0 | 13651 | American Decorative Arts 1 | Curtain 1002 | Curtain | American 1 | Maker 1 | John Scott Bradstreet | 1845–1914 | Bradstreet, John Scott 1326 | 1845 | 1914 | 1905 | 1905 | 1905 | Cotton appliqued with linen, stitched with silk 2155 | 61 1/8 x 44 in. (155.3 x 111.8 cm) | Gift of Geoffrey N. Bradfield, 1987 | Made in 1 | Minneapolis 288 | United States 3 | Textiles 16 | http://www.metmuseum.org/art/collection/search/13651 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
| 14365 | 14365 | 1996.242 | 0 | 1 | 15550 | American Decorative Arts 1 | Sofa 824 | Sofa | American 1 | Maker 1 | John Scott Bradstreet and Company | 1901–1914 | Bradstreet and Company John Scott 2320 | 1901 | 1914 | 1903–5 | 1903 | 1905 | Cypress and chestnut 2463 | 40 7/8 x 64 1/4 x 26 in. (103.8 x 163.2 x 66 cm) | Purchase, Mrs. Daniel Fraad Gift, Friends of the American Wing Fund, and Mr. and Mrs. Donald R. Gordon, Lois and Arthur Stainman Philanthropic Fund, and Mrs. Moreau D. Brown Gifts, 1996 | Made in 1 | Minneapolis 288 | United States 3 | Furniture 4 | http://www.metmuseum.org/art/collection/search/15550 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
| 217653 | 217653 | 26.28.131 | 0 | 0 | 345148 | Drawings and Prints 11 | Book 97 | Price List, 1874. Manufacturers of all descriptions of artificial cut, carved, and ornamental stone | Author 41 | Asbestine Stone Company | Minneapolis, Minnesota | Asbestine Stone Company 21363 | American 1 | 1850 | 1900 | 1874 | 1874 | 1874 | Illustrations: lithography 28996 | 5 11/16 x 3 7/16 in. (14.5 x 8.7 cm) | Gift of Bella C. Landauer, 1925 | Minneapolis 288 | Books 442 | http://www.metmuseum.org/art/collection/search/345148 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 219363 | 219363 | 63.675.14 | 0 | 0 | 346883 | Drawings and Prints 11 | Book 97 | Illustrated Catalogue and Price-List [picture frames] | Author 41 | I. E. Burt Portrait Co. | Minneapolis, Minnesota | Burt, I. E., Portrait Co. 22519 | American 1 | 1850 | 1950 | 1890–91 | 1890 | 1891 | Illustrations: lithography 28996 | 4 3/16 x 7 1/16 in. (10.7 x 18 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1963 | Minneapolis 288 | Books 442 | http://www.metmuseum.org/art/collection/search/346883 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 222260 | 222260 | 65.658.19 | 0 | 0 | 349820 | Drawings and Prints 11 | Book 97 | Bronze Tablets | Author 41 | The Flour City Ornamental Iron Company | Minneapolis, Minnesota | Flour City Ornamental Iron Company 24528 | American 1 | 1850 | 1950 | 19th–20th century | 1850 | 1960 | Illustrations: photomechanical process 33879 | 9 1/4 x 3 7/8 in. (23.5 x 9.8 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1965 | Minneapolis 288 | Books 442 | http://www.metmuseum.org/art/collection/search/349820 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 222383 | 222383 | 1972.605 | 0 | 0 | 349943 | Drawings and Prints 11 | Book 97 | Edward Ruscha, Young Artist | Author|Artist|Publisher 1302 | Edward A. Foster|Edward Ruscha|Minneapolis Institute of Arts | American, 20th century|American, born Omaha, Nebraska, 1937 | Foster, Edward A.|Ruscha, Edward|Minneapolis Institute of Arts 24612 | American|American 5 | 1900 |1937 | 1999 |2037 | 1972 | 1972 | 1972 | Adminstrative Purchase Fund, 1972 | Minneapolis 288 | Books 442 | http://www.metmuseum.org/art/collection/search/349943 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
| 264828 | 264828 | 26.28.156(1–16) | 0 | 0 | 393795 | Drawings and Prints 11 | Book 97 | Paine's Furniture Manufactory, Church Furniture | Author 41 | Paine Furniture Company | Boston, Massachusetts | Paine Furniture Company 28321 | American 1 | 1835 | 1935 | after 1876 | 1876 | 1890 | Illustrations: wood engraving and photomechanical process 34419 | 3 1/8 x 4 15/16 in. (8 x 12.6 cm) | Gift of Bella C. Landauer, 1925 | Minneapolis 288 | Books 442 | http://www.metmuseum.org/art/collection/search/393795 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
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");