MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

21 rows where Artist Alpha Sort = 36577

View and edit SQL

Suggested facets: Object Date, Object Begin Date, Object End Date, Medium, Dimensions

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
255083 54.90.151 0 0 383711 Drawings and Prints 11 Drawing 23 New York Free School           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 ca. 1840 1835 1840 Ink and watercolor 35730 image: 15 9/16 x 12 3/8 in. (39.5 x 31.5 cm) sheet: 20 7/8 x 17 7/8 in. (53.1 x 45.4 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
260911 54.90.320 0 0 389630 Drawings and Prints 11 Drawing 23 Dutch Farm House, Astoria           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1890 1890 1890 Ink and wash 34346 sheet: 5 7/8 x 8 3/8 in. (15 x 21.3 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
260912 54.90.308 0 0 389631 Drawings and Prints 11 Drawing 23 Washington's Headquarters, Brooklyn, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1892 1892 1892 Graphite and watercolor on brown paper 42087 sheet: 5 7/16 x 9 13/16 in. (13.8 x 25 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
260913 54.90.304 0 0 389632 Drawings and Prints 11 Drawing 23 Old Farmhouse Near Bushwick, Long Island, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1860–90 1860 1890 Graphite 28967 sheet: 9 1/4 x 10 1/16 in. (23.5 x 25.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
260914 54.90.311 0 0 389633 Drawings and Prints 11 Drawing 23 78th Street and the East River, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1860–90 1860 1890 Graphite 28967 sheet: 5 13/16 x 8 7/16 in. (14.8 x 21.4 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
260915 54.90.312 0 0 389634 Drawings and Prints 11 Drawing 23 87th Street and First Avenue, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1880 1880 1880 Graphite 28967 sheet: 5 13/16 x 8 7/16 in. (14.8 x 21.4 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
260916 54.90.313 0 0 389635 Drawings and Prints 11 Drawing 23 Tenth Avenue, Harlem, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1860–90 1860 1890 Graphite 28967 sheet: 5 13/16 x 8 7/16 in. (14.8 x 21.4 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
260917 54.90.314 0 0 389636 Drawings and Prints 11 Drawing 23 89th Street and First Avenue, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1860–90 1860 1890 Graphite 28967 sheet: 5 13/16 x 8 7/16 in. (14.8 x 21.4 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
260918 54.90.315 0 0 389637 Drawings and Prints 11 Drawing 23 89th Street and Second Avenue, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1860–90 1860 1890 Graphite 28967 sheet: 5 13/16 x 8 7/16 in. (14.8 x 21.4 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
260919 54.90.316 0 0 389638 Drawings and Prints 11 Drawing 23 Junk Shop, 94th Street and Second Avenue, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1883 1883 1883 Graphite 28967 sheet: 5 13/16 x 8 7/16 in. (14.8 x 21.4 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
260920 54.90.317 0 0 389639 Drawings and Prints 11 Drawing 23 98th Street and Park Avenue, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1860–90 1860 1890 Graphite 28967 sheet: 5 13/16 x 8 7/16 in. (14.8 x 21.4 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
260921 54.90.318 0 0 389640 Drawings and Prints 11 Drawing 23 98th Street and Madison Avenue, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1860–90 1860 1890 Graphite 28967 sheet: 5 13/16 x 8 7/16 in. (14.8 x 21.4 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
260922 54.90.319 0 0 389641 Drawings and Prints 11 Drawing 23 121st Street and Madison Avenue, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1860–90 1860 1890 Graphite 28967 sheet: 5 13/16 x 8 7/16 in. (14.8 x 21.4 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
260942 54.90.305 0 0 389661 Drawings and Prints 11 Drawing 23 The Old Hustedt House, built about 1690, Williamsbridge, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1860–90 1860 1890 Graphite 28967 sheet: 9 5/8 x 10 7/8 in. (24.4 x 27.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
260944 54.90.306 0 0 389663 Drawings and Prints 11 Drawing 23 One of Harlem's Oldest Houses, 119th Street between Second and Third Avenues, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1860–90 1860 1890 Graphite 28967 sheet: 9 15/16 x 11 1/8 in. (25.3 x 28.2 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
260945 54.90.307 0 0 389664 Drawings and Prints 11 Drawing 23 One of Fordham's Oldest Farmhouses, Near Washington Avenue and 188th Street, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1860–90 1860 1890 Graphite 28967 sheet: 9 7/16 x 11 1/4 in. (24 x 28.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
260946 54.90.309 0 0 389665 Drawings and Prints 11 Drawing 23 The Old Cromwell House, Built 1735, near Jerome Avenue and 165th Street, at Cromwell Creek, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1860–90 1860 1890 Graphite 28967 sheet: 10 3/16 x 11 1/8 in. (25.9 x 28.3 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
260947 54.90.310 0 0 389666 Drawings and Prints 11 Drawing 23 Weekawken Street, Near Hoboken Ferry, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1860–90 1860 1890 Graphite 28967 sheet: 9 5/8 x 10 7/8 in. (24.4 x 27.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
260948 54.90.210 0 0 389667 Drawings and Prints 11 Drawing 23 Lorilard's Old Snuff Mill in Bronx Park, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1862 1862 1862 Graphite 28967 sheet: 11 1/8 x 15 1/2 in. (28.3 x 39.4 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
261000 54.90.303 0 0 389724 Drawings and Prints 11 Drawing 23 Edgar Allan Poe House, New York, 1845           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 September 16, 1884 1884 1884 Graphite and wash 33428 sheet: 8 1/4 x 11 1/2 in. (20.9 x 29.2 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
261288 54.90.188 0 0 390013 Drawings and Prints 11 Drawing 23 Flood Rock, Hell Gate, New York           Artist 2   H. Metzner American, active New York, ca. 1840–1909   Metzner, H. 36577 American 1 1840 1909 1885 1885 1885 Graphite 28967 sheet: 12 5/16 x 18 11/16 in. (31.2 x 47.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

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 125.936ms · Data license: CC0 · Data source: metmuseum/openaccess