Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, 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, Credit Line
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 219301 | 219301 | 46.117.15 | 0 | 0 | 346819 | Drawings and Prints 11 | Book 97 | Views of New York State | Artist|Artist|Artist|Engraver|Lithographer 1990 | After|After|Maps after | Charles Cromwell Ingham|E. Emmons|E. N. Horsford|George W. Merchant|John H. Bufford | American (born Ireland), Dublin 1786–1863 New York|American, active 19th century|American, 19th century|American, active mid 19th century|American, 1810–1870 | Ingham, Charles Cromwell|Emmons, E.|Horsford, E. N.|Merchant, George W.|Bufford, John H. 22463 | American, born Ireland|American|American|American|American 1357 | 1786 |1800 |1800 |1800 |1810 | 1863 |1900 |1900 |1900 |1870 | 1838–39 | 1838 | 1839 | Illustrations: lithography, engraving 34456 | 11 7/16 x 9 5/8 x 3/8 in. (29 x 24.5 x 1 cm) | Gift of Estate of Marie L. Russell, 1946 | Books 442 | http://www.metmuseum.org/art/collection/search/346819 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 228152 | 228152 | 32.8 | 0 | 0 | 355782 | Drawings and Prints 11 | Book 97 | The Lady's Manual of Fancy-Work | Author|Publisher 44 | Mrs. Matilda Marian Chesney Pullan|Dick & Fitzgerald | British, active 19th century|New York | Pullan, Matilda Marian Chesney Mrs.|Dick & Fitzgerald 28862 | British|American 33 | 1800 |1800 | 1900 |1900 | 1859 | 1859 | 1859 | Illustrations: lithography, engraving 34456 | 8 1/4 x 5 1/2 x 1 in. (21 x 14 x 2.6 cm) | Harris Brisbane Dick Fund, 1932 | Books 442 | http://www.metmuseum.org/art/collection/search/355782 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 230561 | 230561 | 63.601.2 | 0 | 0 | 358250 | Drawings and Prints 11 | Book 97 | The Sunshade, the Glove -- the Muff | Illustrator|Publisher 1092 | Paul Avril|J. C. Nimmo and Bain | French, born 1843|London | Avril, Paul|Nimmo, J. C. and Bain 30480 | French|British 229 | 1843 |1875 | 1943 |1899 | 1884 | 1884 | 1884 | Illustrations: lithography, engraving 34456 | 10 13/16 x 7 5/16 x 13/16 in. (27.5 x 18.5 x 2 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1963 | Books 442 | http://www.metmuseum.org/art/collection/search/358250 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 236683 | 236683 | 68.715 | 0 | 0 | 364645 | Drawings and Prints 11 | Book 97 | The Obsequies of Abraham Lincoln | Author|Publisher|Engraver 1469 | Portrait of Lincoln by | David Thomas Valentine|Edmund Jones|J. Rogers | American, 1801–1869|New York|American, active 1866–70 | Valentine, David Thomas|Jones, Edmund|Rogers, J. 32373 | American|American|American 101 | 1801 |1800 |1866 | 1869 |1900 |1870 | 1866 | 1866 | 1866 | Illustrations: lithography, engraving 34456 | 10 5/8 x 7 1/16 x 1 3/16 in. (27 x 18 x 3 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1968 | Books 442 | http://www.metmuseum.org/art/collection/search/364645 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 239968 | 239968 | 1979.571.68 | 0 | 0 | 368054 | Drawings and Prints 11 | Book 97 | The Lady's Manual of Fancy Work: A Complete Instructor in Every Variety of Ornamental Needlework | Author|Publisher 44 | Mrs. Matilda Marian Chesney Pullan|Dick & Fitzgerald | British, active 19th century|New York | Pullan, Matilda Marian Chesney Mrs.|Dick & Fitzgerald 28862 | British|American 33 | 1800 |1800 | 1900 |1900 | 1858 | 1858 | 1858 | Illustrations: lithography, engraving 34456 | 8 x 5 5/16 x 1 in. (20.3 x 13.5 x 2.5 cm) | Gift of Lincoln Kirstein, 1979 | Books 442 | http://www.metmuseum.org/art/collection/search/368054 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 240536 | 240536 | 24.90.1839 | 0 | 0 | 368652 | Drawings and Prints 11 | Book 97 | Manual of the Common Council of the City of New York for the Years 1845 & 1846 | Author|Printer 1012 | David Thomas Valentine|Levi D. Slamm & C. C. Childs | American, 1801–1869|New York, NY | Valentine, David Thomas|Slamm, Levi D., & C. C. Childs 33385 | American|American 5 | 1801 |1800 | 1869 |1900 | 1845–46 | 1845 | 1846 | Illustrations: lithography, engraving 34456 | 6 1/8 x 4 in. (15.5 x 10.2 cm) | Bequest of Charles Allen Munn, 1924 | Books 442 | http://www.metmuseum.org/art/collection/search/368652 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 240539 | 240539 | 24.90.1843 | 0 | 0 | 368655 | Drawings and Prints 11 | Book 97 | Manual of the Corporation of the City of New York for the Year 1850 | Author|Printer|Lithographer|Lithographer 2690 | David Thomas Valentine|McSpedon & Baker|George Hayward|Henry R. Robinson | American, 1801–1869|New York, NY|American (born England), ca. 1800–ca. 1872|American, active ca. 1830/33–1850 | Valentine, David Thomas|McSpedon & Baker|Hayward, George|Robinson, Henry R. 33388 | American|American|American, born England|American 1119 | 1801 |1800 |1895 |1830 | 1869 |1900 |1867 |1850 | 1850 | 1850 | 1850 | Illustrations: lithography, engraving 34456 | 7 11/16 x 4 3/4 in. (19.5 x 12 cm) | Bequest of Charles Allen Munn, 1924 | Books 442 | http://www.metmuseum.org/art/collection/search/368655 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 240584 | 240584 | 24.90.1852 | 0 | 1 | 368700 | Drawings and Prints 11 | Book 97 | Manual of the Corporation of the City of New York for 1859 | Author|Printer|Lithographer|Sitter|Lithographer|Engraver 3980 | David Thomas Valentine|Charles W. Baker|George Hayward|David Thomas Valentine|Adam Weingartner|John Rogers | American, 1801–1869|New York, NY|American (born England), ca. 1800–ca. 1872|American, 1801–1869|American, active 1851–60|American (born England) 1808–1888 | Valentine, David Thomas|Baker, Charles W.|Hayward, George|Valentine, David Thomas|Weingartner, Adam|Rogers, John 33400 | American|American|American, born England|American|American|American, born England 2617 | 1801 |1800 |1895 |1801 |1851 |1808 | 1869 |1900 |1867 |1869 |1860 |1888 | 1859 | 1859 | 1859 | Illustrations: lithography, engraving 34456 | 7 5/16 x 5 1/2 in. (18.5 x 14 cm) | Bequest of Charles Allen Munn, 1924 | Books 442 | http://www.metmuseum.org/art/collection/search/368700 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 240604 | 240604 | 24.90.1853 | 0 | 0 | 368720 | Drawings and Prints 11 | Book 97 | Manual of the Corporation of the City of New York for 1860 | Author|Printer|Printer 2029 | David Thomas Valentine|McSpedon & Baker|Adam Weingartner | American, 1801–1869|New York, NY|American, active 1851–60 | Valentine, David Thomas|McSpedon & Baker|Weingartner, Adam 33405 | American|American|American 101 | 1801 |1800 |1851 | 1869 |1900 |1860 | 1860 | 1860 | 1860 | Illustrations: lithography, engraving 34456 | 7 1/2 x 4 15/16 in. (19 x 12.5 cm) | Bequest of Charles Allen Munn, 1924 | Books 442 | http://www.metmuseum.org/art/collection/search/368720 | 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");