MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

19 rows where Portfolio = 1031

View and edit SQL

Suggested facets: 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, 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 Repository
252250 54.90.632 0 0 380749 Drawings and Prints 11 Print 731 Union Square, Bird's Eye View (Henry Hoff's Views of New York)         Views of New York 1031 Publisher|Artist 740   Henry Hoff|John Bornet New York, NY|American, active New York, 1850–55   Hoff, Henry|Bornet, John 35710 American|American 5 1800 |1850 1900 |1855 1850 1850 1850 Handcolored lithograph 40394 sheet: 6 1/16 x 8 11/16 in. (15.4 x 22.1 cm) mount: 10 7/8 x 13 7/8 in. (27.6 x 35.2 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252525 54.90.1001 0 0 381028 Drawings and Prints 11 Print 731 Stewart's Buildings and Broadway (Henry Hoff's Views of New York)         Views of New York 1031 Publisher|Artist 740   Henry Hoff|Augustus Fay New York, NY|American, born ca. 1824, active 1840–60   Hoff, Henry|Fay, Augustus 35882 American|American 5 1800 |1824 1900 |1860 1850 1850 1850 Lithograph with tint stone and hand-coloring, with gum arabic 40435 sheet: 6 1/16 x 9 in. (15.4 x 22.9 cm) mount: 10 13/16 x 13 11/16 in. (27.5 x 34.8 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252526 54.90.1002 0 0 381029 Drawings and Prints 11 Print 731 Institution of the Blind (Henry Hoff's Views of New York)         Views of New York 1031 Lithographer|Publisher|Artist 1804 After Charles Autenrieth|Henry Hoff|John Bornet American, active 1850–60|New York, NY|American, active New York, 1850–55   Autenrieth, Charles|Hoff, Henry|Bornet, John 35883 American|American|American 101 1850 |1800 |1850 1860 |1900 |1855 1850 1850 1850 Lithograph with tint stone and hand-coloring, with gum arabic 40435 sheet: 6 1/8 x 8 7/8 in. (15.6 x 22.6 cm) mount: 10 7/8 x 13 3/4 in. (27.6 x 35 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252527 54.90.1003 0 0 381030 Drawings and Prints 11 Print 731 Niblo's Hotel (Metropolitan Hotel) (Henry Hoff's Views of New York)         Views of New York 1031 Artist|Publisher 710   Augustus Fay|Henry Hoff American, born ca. 1824, active 1840–60|New York, NY   Fay, Augustus|Hoff, Henry 35884 American|American 5 1824 |1800 1860 |1900 1850 1850 1850 Lithograph with tint stone and hand-coloring, with gum arabic 40435 sheet: 6 3/16 x 9 in. (15.7 x 22.9 cm) mount: 10 13/16 x 13 13/16 in. (27.5 x 35.1 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252528 54.90.1004 0 0 381031 Drawings and Prints 11 Print 731 Grace Church (Henry Hoff's Views of New York)         Views of New York 1031 Artist|Publisher 710   John Bornet|Henry Hoff American, active New York, 1850–55|New York, NY   Bornet, John|Hoff, Henry 35885 American|American 5 1850 |1800 1855 |1900 1850 1850 1850 Lithograph with tint stone and hand-coloring, with gum arabic 40435 sheet: 6 1/8 x 9 in. (15.6 x 22.9 cm) mount: 10 7/8 x 13 3/4 in. (27.6 x 35 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252529 54.90.1005 0 0 381032 Drawings and Prints 11 Print 731 Grace Church (Henry Hoff's Views of New York)         Views of New York 1031 Artist|Publisher 710   John Bornet|Henry Hoff American, active New York, 1850–55|New York, NY   Bornet, John|Hoff, Henry 35885 American|American 5 1850 |1800 1855 |1900 1850 1850 1850 Lithograph with tint stone and hand-coloring 40436 sheet: 6 1/8 x 9 1/16 in. (15.5 x 23 cm) mount: 10 13/16 x 13 15/16 in. (27.5 x 35.4 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252530 54.90.1006 0 0 381033 Drawings and Prints 11 Print 731 Tombs (Henry Hoff's Views of New York)         Views of New York 1031 Lithographer|Publisher|Artist 1804 After Charles Autenrieth|Henry Hoff|John Bornet American, active 1850–60|New York, NY|American, active New York, 1850–55   Autenrieth, Charles|Hoff, Henry|Bornet, John 35883 American|American|American 101 1850 |1800 |1850 1860 |1900 |1855 1850 1850 1850 Lithograph with tint stone and hand-coloring 40436 sheet: 6 1/16 x 8 7/8 in. (15.4 x 22.6 cm) mount: 10 7/8 x 13 3/4 in. (27.6 x 35 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252531 54.90.1007 0 0 381034 Drawings and Prints 11 Print 731 Trinity Church (Henry Hoff's Views of New York)         Views of New York 1031 Artist|Lithographer|Publisher 1670 After Charles Autenrieth|John Bornet|Henry Hoff American, active 1850–60|American, active New York, 1850–55|New York, NY   Autenrieth, Charles|Bornet, John|Hoff, Henry 35886 American|American|American 101 1850 |1850 |1800 1860 |1855 |1900 1850 1850 1850 Lithograph with tint stone and hand-coloring, with gum arabic 40435 sheet: 6 3/16 x 8 13/16 in. (15.7 x 22.4 cm) mount: 10 7/8 x 13 3/4 in. (27.6 x 35 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252532 54.90.1008 0 0 381035 Drawings and Prints 11 Print 731 High Bridge (Henry Hoff's Views of New York)         Views of New York 1031 Publisher|Artist 740   Henry Hoff|C. G. New York, NY|American, active 1850   Hoff, Henry|C. G. 35887 American|American 5 1800 |1840 1900 |1860 1850 1850 1850 Lithograph with tint stone and hand-coloring 40436 sheet: 6 1/16 x 8 3/4 in. (15.4 x 22.3 cm) mount: 10 7/8 x 13 3/4 in. (27.6 x 35 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252533 54.90.1009 0 0 381036 Drawings and Prints 11 Print 731 Astor Place Theatre (Henry Hoff's Views of New York)         Views of New York 1031 Publisher|Artist 740 Attributed to Henry Hoff|John Bornet New York, NY|American, active New York, 1850–55   Hoff, Henry|Bornet, John 35710 American|American 5 1800 |1850 1900 |1855 1850 1850 1850 Lithograph with tint stone and hand-coloring 40436 sheet: 6 1/16 x 8 7/8 in. (15.4 x 22.5 cm) mount: 6 7/8 x 13 3/4 in. (17.5 x 35 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252534 54.90.1010 0 0 381037 Drawings and Prints 11 Print 731 Odd Fellows Hall (Henry Hoff's Views of New York)         Views of New York 1031 Artist|Publisher|Lithographer 1536 After Charles Autenrieth|Henry Hoff|John Bornet American, active 1850–60|New York, NY|American, active New York, 1850–55   Autenrieth, Charles|Hoff, Henry|Bornet, John 35883 American|American|American 101 1850 |1800 |1850 1860 |1900 |1855 1850 1850 1850 Lithograph with tint stone and hand-coloring, with gum arabic 40435 sheet: 6 1/8 x 8 7/8 in. (15.5 x 22.5 cm) mount: 10 11/16 x 13 3/4 in. (27.2 x 35 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252535 54.90.1011 0 0 381038 Drawings and Prints 11 Print 731 City Hall of Brooklyn (Henry Hoff's Views of New York)         Views of New York 1031 Artist|Lithographer|Publisher 1670 After Charles Autenrieth|John Bornet|Henry Hoff American, active 1850–60|American, active New York, 1850–55|New York, NY   Autenrieth, Charles|Bornet, John|Hoff, Henry 35886 American|American|American 101 1850 |1850 |1800 1860 |1855 |1900 1850 1850 1850 Lithograph with tint stone and hand-coloring, with gum arabic 40435 sheet: 6 1/8 x 8 13/16 in. (15.6 x 22.4 cm) mount: 10 13/16 x 13 13/16 in. (27.5 x 35.1 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252537 54.90.1013 0 0 381040 Drawings and Prints 11 Print 731 Hospital of Brooklyn (U.S. Naval Hosptial) (Henry Hoff's Views of New York)         Views of New York 1031 Artist|Publisher|Artist 867 After Charles Autenrieth|Henry Hoff|Augustus Fay American, active 1850–60|New York, NY|American, born ca. 1824, active 1840–60   Autenrieth, Charles|Hoff, Henry|Fay, Augustus 35889 American|American|American 101 1850 |1800 |1824 1860 |1900 |1860 1850 1850 1850 Lithograph with tint stone and hand-coloring, with gum arabic 40435 sheet: 6 3/16 x 8 7/8 in. (15.7 x 22.6 cm) mount: 10 13/16 x 13 9/16 in. (27.5 x 34.5 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252539 54.90.1015 0 0 381042 Drawings and Prints 11 Print 731 City Hall (Henry Hoff's Views of New York)         Views of New York 1031 Artist|Publisher 710   Charles Autenrieth|Henry Hoff American, active 1850–60|New York, NY   Autenrieth, Charles|Hoff, Henry 35891 American|American 5 1850 |1800 1860 |1900 1850 1850 1850 Lithograph with tint stone and hand-coloring, with gum arabic 40435 sheet: 6 1/8 x 8 15/16 in. (15.5 x 22.7 cm) mount: 10 13/16 x 13 3/4 in. (27.5 x 35 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252540 54.90.1016 0 0 381043 Drawings and Prints 11 Print 731 Merchants' Exchange (Henry Hoff's Views of New York)         Views of New York 1031 Artist|Publisher|Lithographer 1536 After Charles Autenrieth|Henry Hoff|John Bornet American, active 1850–60|New York, NY|American, active New York, 1850–55   Autenrieth, Charles|Hoff, Henry|Bornet, John 35883 American|American|American 101 1850 |1800 |1850 1860 |1900 |1855 1850 1850 1850 Lithograph with tint stone and hand-coloring, with gum arabic 40435 sheet: 6 1/4 x 8 7/8 in. (15.8 x 22.6 cm) mount: 10 13/16 x 13 3/4 in. (27.5 x 35 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252541 54.90.1017 0 0 381044 Drawings and Prints 11 Print 731 Castle Garden (Henry Hoff's Views of New York)         Views of New York 1031 Artist|Lithographer|Publisher 1670 After Charles Autenrieth|John Bornet|Henry Hoff American, active 1850–60|American, active New York, 1850–55|New York, NY   Autenrieth, Charles|Bornet, John|Hoff, Henry 35886 American|American|American 101 1850 |1850 |1800 1860 |1855 |1900 1850 1850 1850 Lithograph with tint stone and hand-coloring 40436 sheet: 6 3/16 x 8 7/8 in. (15.7 x 22.5 cm) mount: 10 13/16 x 13 3/4 in. (27.5 x 35 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252653 54.90.1143 0 0 381157 Drawings and Prints 11 Print 731 Metropolitan Hotel and Niblo's Garden (Henry Hoff's Views of New York)         Views of New York 1031 Artist|Publisher 710   Augustus Fay|Henry Hoff American, born ca. 1824, active 1840–60|New York, NY   Fay, Augustus|Hoff, Henry 35884 American|American 5 1824 |1800 1860 |1900 ca. 1850 1845 1855 Lithograph 14948 sheet: 8 1/16 x 9 3/4 in. (20.4 x 24.7 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252718 54.90.1221 0 0 381222 Drawings and Prints 11 Print 731 New York University (Henry Hoff's Views of New York)         Views of New York 1031 Publisher 16   Henry Hoff New York, NY   Hoff, Henry 36003 American 1 1800 1900 1850 1850 1850 Lithograph with tint stone and hand-coloring 40436 sheet: 5 3/4 x 8 15/16 in. (14.6 x 22.7 cm) mount: 10 13/16 x 13 7/8 in. (27.4 x 35.2 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
254557 1974.673.60 0 0 383176 Drawings and Prints 11 Print 731 New York from Governor's Island (Henry Hoff's Views of New York)         Views of New York 1031 Publisher 16   Henry Hoff New York, NY   Hoff, Henry 36003 American 1 1800 1900 1850 1850 1850 Lithograph with tint stone and hand-coloring 40436 sheet: 6 1/8 x 8 7/8 in. (15.6 x 22.5 cm) mount: 10 7/16 x 13 9/16 in. (26.5 x 34.5 cm) Gift of Mary Knight Arnold, 1974                       Prints 13   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 120.627ms · Data license: CC0 · Data source: metmuseum/openaccess