MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

26 rows where Artist Alpha Sort = 32770

View and edit SQL

Suggested facets: Is Highlight, Department, Object Name, 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
238171 25.31.1 0 0 366204 Drawings and Prints 11 Print 731 East Side Interior           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1922 1922 1922 Etching 26137 Plate: 7 7/8 x 9 7/8 in. (20 x 25.1 cm) Sheet: 12 3/8 x 14 1/4 in. (31.5 x 36.2 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238173 25.31.2 0 0 366206 Drawings and Prints 11 Print 731 Night Shadows           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1921 1921 1921 Etching 26137 Plate: 6 7/8 x 8 3/16 in. (17.4 x 20.8 cm) Sheet: 13 3/16 x 14 7/16 in. (33.5 x 36.6 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238174 25.31.3 0 0 366207 Drawings and Prints 11 Print 731 The Lighthouse           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1923 1923 1923 Etching 26137 Plate: 9 15/16 x 11 13/16 in. (25.2 x 30 cm) Sheet: 14 x 15 7/8 in. (35.5 x 40.4 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238175 25.31.4 0 0 366208 Drawings and Prints 11 Print 731 American Landscape           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1920 1920 1920 Etching 26137 Plate: 7 5/16 x 12 3/8 in. (18.5 x 31.4 cm) Sheet: 12 1/16 x 16 5/8 in. (30.7 x 42.3 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238176 25.31.5 0 0 366209 Drawings and Prints 11 Print 731 Aux Fortifications           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1923 1923 1923 Etching 26137 Plate: 11 3/4 x 14 3/4 in. (29.9 x 37.5 cm) Sheet: 13 7/8 x 16 7/8 in. (35.3 x 42.8 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238177 25.31.6 0 0 366210 Drawings and Prints 11 Print 731 Les Deux Pigeons           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1920 1920 1920 Etching 26137 Plate: 8 3/8 x 9 7/8 in. (21.2 x 25.1 cm) Sheet: 10 7/8 x 12 3/16 in. (27.7 x 31 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238178 25.31.7 0 0 366211 Drawings and Prints 11 Print 731 Evening Wind           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1921 1921 1921 Etching 26137 Plate: 6 15/16 x 8 1/4 in. (17.6 x 21 cm) Sheet: 9 7/16 x 10 5/8 in. (24 x 27 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238179 25.31.8 0 0 366212 Drawings and Prints 11 Print 731 Night in the Park           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1921 1921 1921 Etching 26137 Plate: 6 7/8 × 8 1/4 in. (17.4 × 21 cm) Sheet: 9 7/16 × 10 7/8 in. (24 × 27.6 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238180 25.31.9 0 0 366213 Drawings and Prints 11 Print 731 Train and Bathers           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1920 1920 1920 Etching 26137 Plate: 8 5/16 x 9 13/16 in. (21.1 x 25 cm) Sheet: 11 7/8 x 13 9/16 in. (30.2 x 34.4 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238181 25.31.10 0 0 366214 Drawings and Prints 11 Print 731 House Tops           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1921 1921 1921 Etching 26137 Plate: 5 13/16 x 7 13/16 in. (14.8 x 19.9 cm) Sheet: 9 1/8 x 11 1/8 in. (23.2 x 28.3 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238182 25.31.11 0 0 366215 Drawings and Prints 11 Print 731 Night on the El Train           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1918 1918 1918 Etching 26137 Plate: 7 3/8 x 7 13/16 in. (18.7 x 19.9 cm) Sheet: 11 7/8 x 12 3/8 in. (30.2 x 31.4 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238183 25.31.12 0 0 366216 Drawings and Prints 11 Print 731 The Lonely House           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1923 1923 1923 Etching 26137 Plate: 7 13/16 x 9 13/16 in. (19.9 x 25 cm) Sheet: 11 11/16 x 13 15/16 in. (29.7 x 35.4 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238184 25.31.13 0 0 366217 Drawings and Prints 11 Print 731 Cat Boat           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1922 1922 1922 Etching 26137 Plate: 7 13/16 x 9 13/16 in. (19.9 x 25 cm) Sheet: 11 1/2 x 13 3/8 in. (29.2 x 33.9 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238185 25.31.14 0 0 366218 Drawings and Prints 11 Print 731 Railroad Crossing           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1923 1923 1923 Drypoint 29360 Plate: 6 15/16 x 8 7/8 in. (17.6 x 22.5 cm) Sheet: 8 7/16 x 10 5/16 in. (21.4 x 26.2 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
238186 25.31.15 0 0 366219 Drawings and Prints 11 Print 731 The Railroad           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1922 1922 1922 Etching 26137 Plate: 7 13/16 x 9 13/16 in. (19.9 x 24.9 cm) Sheet: 11 15/16 x 13 13/16 in. (30.4 x 35.1 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   Metropolitan Museum of Art, New York, NY 1
333996 1974.356.21 0 0 481209 Modern and Contemporary Art 4 Drawing 23 Folly Beach, Charleston, South Carolina           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1929 1929 1929 Watercolor, gouache and charcoal on paper 50929 13 7/8 x 19 3/4 in. (35.2 x 50.2 cm) The Lesley and Emma Sheafer Collection, Bequest of Emma A. Sheafer, 1973                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
333998 1974.356.23 0 0 481211 Modern and Contemporary Art 4 Drawing 23 Barn and Silo, Vermont           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1927 1927 1927 Watercolor, gouache and charcoal on paper 50929 13 7/8 x 19 7/8 in. (35.2 x 50.5 cm) The Lesley and Emma Sheafer Collection, Bequest of Emma A. Sheafer, 1973                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
333999 1974.356.25 0 0 481213 Modern and Contemporary Art 4 Drawing 23 Coast Guard Station, Two Lights, Maine           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1927 1927 1927 Watercolor, gouache and charcoal on paper 50929 13 7/8 x 19 7/8 in. (35.2 x 50.5 cm) The Lesley and Emma Sheafer Collection, Bequest of Emma A. Sheafer, 1973                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
339911 31.62 1 0 487695 Modern and Contemporary Art 4 Painting 69 Tables for Ladies           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1930 1930 1930 Oil on canvas 953 48 1/4 x 60 1/4 in. (122.6 x 153 cm) George A. Hearn Fund, 1931                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
340027 37.44 0 0 487834 Modern and Contemporary Art 4 Painting 69 From Williamsburg Bridge           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1928 1928 1928 Oil on canvas 953 29 3/8 × 43 3/4 in. (74.6 × 111.1 cm) George A. Hearn Fund, 1937                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
340316 45.157.2 0 0 488165 Modern and Contemporary Art 4 Drawing 23 Saltillo Mansion           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1943 1943 1943 Watercolor on paper 177 21 1/4 x 27 1/8 in. (54 x 68.9 cm) George A. Hearn Fund, 1945                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
340410 48.35.2 0 0 488273 Modern and Contemporary Art 4 Drawing 23 Church of San Esteban           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1946 1946 1946 Watercolor on paper 177 22 1/4 x 30 1/2in. (56.5 x 77.5cm) George A. Hearn Fund, 1948                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
340812 53.183 0 0 488730 Modern and Contemporary Art 4 Painting 69 Office in a Small City           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1953 1953 1953 Oil on canvas 953 28 x 40 in. (71.1 x 101.6 cm) George A. Hearn Fund, 1953                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
340972 56.216 0 0 488919 Modern and Contemporary Art 4 Drawing 23 House of the Foghorn, I           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1927 1927 1927 Watercolor, gouache and charcoal on paper 50929 13 7/8 x 20 in. (35.2 x 50.8 cm) Bequest of Elizabeth Amis Cameron Blanchard, 1956                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
341015 57.76 0 0 488969 Modern and Contemporary Art 4 Drawing 23 D. & R.G. Locomotive           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1925 1925 1925 Watercolor and graphite on paper 1782 13 7/8 x 20 in. (35.2 x 50.8 cm) Hugo Kastor Fund, 1957                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
341282 62.95 1 0 489258 Modern and Contemporary Art 4 Painting 69 The Lighthouse at Two Lights           Artist 2   Edward Hopper American, Nyack, New York 1882–1967 New York   Hopper, Edward 32770 American 1 1882 1967 1929 1929 1929 Oil on canvas 953 29 1/2 x 43 1/4 in. (74.9 x 109.9 cm) Hugo Kastor Fund, 1962                       Paintings 11   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 124.474ms · Data license: CC0 · Data source: metmuseum/openaccess