MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Artist Alpha Sort = 35769

View and edit SQL

Suggested facets: Object Name, Artist Role, Artist Prefix, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, 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 Repository
252332 54.90.762 0 0 380832 Drawings and Prints 11 Print 731 Brooklyn City Hospital, New York           Artist 2   George Hayward American (born England), ca. 1800–ca. 1872   Hayward, George 35769 American, born England 16 1895 1867 ca. 1851–52 1846 1857 Lithograph with tint stone 34961 image: 9 3/8 x 15 1/16 in. (23.8 x 38.3 cm) sheet: 20 7/8 x 17 5/16 in. (53.1 x 44 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
252648 54.90.1137 0 0 381152 Drawings and Prints 11 Print 731 Strawberry Hill Hotel, now Woodlawn           Lithographer 28   George Hayward American (born England), ca. 1800–ca. 1872   Hayward, George 35769 American, born England 16 1895 1867 1856 1856 1856 LIthograph with tint stone 40447 image: 3 7/16 x 6 in. (8.7 x 15.2 cm) sheet: 4 3/16 x 7 5/16 in. (10.7 x 18.6 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
254694 54.90.1315 0 0 383318 Drawings and Prints 11 Print 731 Everett House, Union Square, New York, 1856           Lithographer 28   George Hayward American (born England), ca. 1800–ca. 1872   Hayward, George 35769 American, born England 16 1895 1867 1857 1857 1857 Lithograph with tint stone 34961 sheet: 4 7/16 x 7 3/16 in. (11.2 x 18.3 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
256163 24.90.1332 0 0 384834 Drawings and Prints 11 Print 731 "The Duke's Plan." A Description of the Towne of Mannados, or New Amsterdam as it was in September 1665           Artist 2   George Hayward American (born England), ca. 1800–ca. 1872   Hayward, George 35769 American, born England 16 1895 1867 1858 1858 1858 Engraving, hand colored 31472 image: 22 3/16 x 27 7/8 in. (56.4 x 70.8 cm) sheet: 23 5/16 x 28 15/16 in. (59.2 x 73.5 cm) Bequest of Charles Allen Munn, 1924                       Prints 13   Metropolitan Museum of Art, New York, NY 1
259308 54.90.677 0 0 388007 Drawings and Prints 11 Print 731 Junction of Broadway and Eighth Avenue, New York, 1861           Artist 2   George Hayward American (born England), ca. 1800–ca. 1872   Hayward, George 35769 American, born England 16 1895 1867 1862 1862 1862 Lithograph with tint stone 34961 sheet approx.: 6 11/16 x 11 7/16 in. (17 x 29 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
259309 54.90.658 0 0 388008 Drawings and Prints 11 Print 731 View of City Hall, Park, Theatre, Broadway and Chatham Street, etc. 1822           Artist 2   George Hayward American (born England), ca. 1800–ca. 1872   Hayward, George 35769 American, born England 16 1895 1867 1857 1857 1857 Lithograph with tint stone 34961 sheet approx.: 6 7/8 x 14 3/8 in. (17.5 x 36.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
260960 54.90.35 0 0 389679 Drawings and Prints 11 Drawing 23 Bath House, Long Island, New York           Artist 2 Attributed to George Hayward American (born England), ca. 1800–ca. 1872   Hayward, George 35769 American, born England 16 1895 1867 June 1846 1846 1846 Ink and wash and graphite 36094 irregular sheet approx.: 9 13/16 x 11 13/16 in. (25 x 30 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
261017 54.90.34 0 0 389741 Drawings and Prints 11 Drawing 23 Burnham's Hotel, Bloomingdale, Road, New York           Artist 2 Attributed to George Hayward American (born England), ca. 1800–ca. 1872   Hayward, George 35769 American, born England 16 1895 1867 1856 1856 1856 Gouache 29287 sheet: 6 11/16 x 9 in. (17 x 22.9 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
261120 54.90.286 0 0 389845 Drawings and Prints 11 Drawing 23 View in Central Park, New York Showing the Balcony Bridge and Oak Bridge           Artist 2   George Hayward American (born England), ca. 1800–ca. 1872   Hayward, George 35769 American, born England 16 1895 1867 1861 1861 1861 Brush and wash 37228 sheet: 8 1/4 x 12 7/16 in. (21 x 31.6 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
261121 54.90.33 0 0 389846 Drawings and Prints 11 Drawing 23 Strawberry Hill Hotel, now Woodlawn, New York           Artist 2   George Hayward American (born England), ca. 1800–ca. 1872   Hayward, George 35769 American, born England 16 1895 1867 ca. 1856 1851 1861 Brush and wash 37228 sheet: 5 1/4 x 8 9/16 in. (13.4 x 21.8 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
261122 54.90.287 0 0 389847 Drawings and Prints 11 Drawing 23 View in Central Park, New York, from 59th Street           Artist 2   George Hayward American (born England), ca. 1800–ca. 1872   Hayward, George 35769 American, born England 16 1895 1867 August 1861 1861 1861 Brush and wash 37228 sheet: 8 1/4 x 11 5/8 in. (21 x 29.5 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
295919 21.36.237 0 0 425555 Drawings and Prints 11 Print 731 Bloemen Heuvel, The Residence of Mr. J. A. Willink, Flatbush           Lithographer 28 Lithographed by George Hayward American (born England), ca. 1800–ca. 1872   Hayward, George 35769 American, born England 16 1895 1867 1842 1842 1842 Lithograph 14948 Image: 10 3/8 × 14 9/16 in. (26.3 × 37 cm) Sheet: 13 3/4 × 21 3/8 in. (35 × 54.3 cm) Museum Accession, transferred from the Library, 1921                       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 146.106ms · Data license: CC0 · Data source: metmuseum/openaccess