MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

16 rows where Medium = 1437

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Department, Object Name, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, 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
9464 9464 1974.358 0 1 10214 American Paintings and Sculpture 2 Watercolor 198 The Farm           Artist 2   Alfred Thompson Bricher 1837–1908   Bricher, Alfred Thompson 1292   1837 1908 ca. 1880–90 1880 1890 Watercolor, gouache, and graphite on white wove paper 1437 14 x 19 15/16 in. (35.6 x 50.6 cm) Gift of Mr. and Mrs. Stuart P. Feld, 1974                       Drawings 9   http://www.metmuseum.org/art/collection/search/10214 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11044 11044 50.130.80j 0 1 12053 American Paintings and Sculpture 2 Watercolor 198 Brook and Meadow           Artist 2   John Singer Sargent American, Florence 1856–1925 London   Sargent, John Singer 23 American 1 1856 1925 ca. 1907 1906 1909 Watercolor, gouache, and graphite on white wove paper 1437 14 x 20 in. (35.6 x 50.8 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12053 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11069 11069 50.130.62 0 1 12078 American Paintings and Sculpture 2 Watercolor 198 Man and Pool, Florida           Artist 2   John Singer Sargent American, Florence 1856–1925 London   Sargent, John Singer 23 American 1 1856 1925 1917 1917 1917 Watercolor, gouache, and graphite on white wove paper 1437 13 11/16 x 21 in. (34.8 x 53.3 cm) Mat: 22 × 28 in. (55.9 × 71.1 cm) Framed (standard exhibition frame): 24 1/2 × 30 1/2 × 1 1/8 in. (62.2 × 77.5 × 2.9 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12078 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11071 11071 50.130.57 0 1 12080 American Paintings and Sculpture 2 Watercolor 198 Figure in Hammock, Florida           Artist 2   John Singer Sargent American, Florence 1856–1925 London   Sargent, John Singer 23 American 1 1856 1925 1917 1917 1917 Watercolor, gouache, and graphite on white wove paper 1437 13 5/8 x 21 in. (34.6 x 53.3 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12080 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11081 11081 50.130.59 0 1 12090 American Paintings and Sculpture 2 Watercolor 198 Man and Trees, Florida           Artist 2   John Singer Sargent American, Florence 1856–1925 London   Sargent, John Singer 23 American 1 1856 1925 1917 1917 1917 Watercolor, gouache, and graphite on white wove paper 1437 21 x 15 5/8 in. (53.3 x 39.7 cm) Mat: 28 × 22 in. (71.1 × 55.9 cm) Framed (standard exhibition frame): 24 1/2 × 30 1/2 × 1 1/8 in. (62.2 × 77.5 × 2.9 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12090 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11123 11123 50.130.28 0 1 12132 American Paintings and Sculpture 2 Watercolor 198 Market Place           Artist 2   John Singer Sargent American, Florence 1856–1925 London   Sargent, John Singer 23 American 1 1856 1925 1890s 1890 1890 Watercolor, gouache, and graphite on white wove paper 1437 10 x 13 9/16 in. (25.4 x 34.4 cm) Mat: 16 × 22 in. (40.6 × 55.9 cm) Framed (standard exhibition frame): 18 1/4 × 24 1/4 × 1 1/8 in. (46.4 × 61.6 × 2.9 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12132 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11161 11161 50.130.80e 0 1 12170 American Paintings and Sculpture 2 Watercolor 198 Rushing Water           Artist 2   John Singer Sargent American, Florence 1856–1925 London   Sargent, John Singer 23 American 1 1856 1925 ca. 1901–7 1901 1907 Watercolor, gouache, and graphite on white wove paper 1437 14 x 9 15/16 in. (35.6 x 25.2 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12170 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11298 11298 50.130.71 0 1 12307 American Paintings and Sculpture 2 Watercolor 198 Stream and Rocks           Artist 2   John Singer Sargent American, Florence 1856–1925 London   Sargent, John Singer 23 American 1 1856 1925 ca. 1901–8 1901 1908 Watercolor, gouache, and graphite on white wove paper 1437 10 x 14 in. (25.4 x 35.6 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12307 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11336 11336 50.130.46 0 1 12345 American Paintings and Sculpture 2 Watercolor 198 Sunset           Artist 2   John Singer Sargent American, Florence 1856–1925 London   Sargent, John Singer 23 American 1 1856 1925 1905–6 1905 1906 Watercolor, gouache, and graphite on white wove paper 1437 12 7/16 x 18 1/2 in. (31.6 x 47 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12345 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11421 11421 50.130.42 0 1 12430 American Paintings and Sculpture 2 Watercolor 198 Tangier           Artist 2   John Singer Sargent American, Florence 1856–1925 London   Sargent, John Singer 23 American 1 1856 1925 1895 1895 1895 Watercolor, gouache, and graphite on white wove paper 1437 13 15/16 x 9 in. (35.4 x 22.9 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12430 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11431 11431 50.130.58 0 1 12440 American Paintings and Sculpture 2 Watercolor 198 Tommies Bathing           Artist 2   John Singer Sargent American, Florence 1856–1925 London   Sargent, John Singer 23 American 1 1856 1925 1918 1918 1918 Watercolor, gouache, and graphite on white wove paper 1437 13 5/8 x 20 15/16 in. (34.6 x 53.2 cm) Mat: 22 × 28 in. (55.9 × 71.1 cm) Framed (standard exhibition frame): 24 1/2 × 30 1/2 × 1 1/8 in. (62.2 × 77.5 × 2.9 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12440 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11449 11449 50.130.77 0 1 12458 American Paintings and Sculpture 2 Watercolor 198 Venetian Passageway           Artist 2   John Singer Sargent American, Florence 1856–1925 London   Sargent, John Singer 23 American 1 1856 1925 ca. 1905 1905 1905 Watercolor, gouache, and graphite on white wove paper 1437 21 3/16 x 14 1/2 in. (53.8 x 36.8 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12458 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11451 11451 50.130.37 0 1 12460 American Paintings and Sculpture 2 Watercolor 198 Venice           Artist 2   John Singer Sargent American, Florence 1856–1925 London   Sargent, John Singer 23 American 1 1856 1925 ca. 1903 1903 1903 Watercolor, gouache, and graphite on white wove paper 1437 9 7/8 x 13 13/16 in. (25.1 x 35.1 cm) Mat: 16 × 22 in. (40.6 × 55.9 cm) Framed (standard exhibition frame): 18 1/4 × 24 1/4 × 1 1/8 in. (46.4 × 61.6 × 2.9 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12460 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
11466 11466 50.130.27 0 1 12475 American Paintings and Sculpture 2 Watercolor 198 Woman with Collie           Artist 2   John Singer Sargent American, Florence 1856–1925 London   Sargent, John Singer 23 American 1 1856 1925 after 1890 1890 1890 Watercolor, gouache, and graphite on white wove paper 1437 13 15/16 x 9 15/16 in. (35.4 x 25.2 cm) Mat: 19 1/4 × 14 1/4 in. (48.9 × 36.2 cm) Gift of Mrs. Francis Ormond, 1950                       Drawings 9   http://www.metmuseum.org/art/collection/search/12475 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
13286 13286 1992.184 0 0 14447 American Paintings and Sculpture 2 Watercolor 198 Malayan Moonlight           Artist 2   Reynolds Beal 1867–1951   Beal, Reynolds 1259   1867 1951 1935 1935 1935 Watercolor, gouache, and graphite on white wove paper 1437 21 x 15 in. (53.3 x 38.1 cm) Gift of Mr. and Mrs. Sidney Bressler, 1992                       Drawings 9   http://www.metmuseum.org/art/collection/search/14447 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
15676 15676 67.654.21 0 0 17078 American Decorative Arts 1 Drawing 23 Design for a mausoleum in a landscape American 1         Artist|Maker|Maker|Maker 73 Possibly|Possibly|Possibly Louis Comfort Tiffany|Tiffany Studios|Tiffany Glass Company|Tiffany Glass and Decorating Company American, New York 1848–1933 New York|1902–32|1885–92|American, 1892–1902   Tiffany, Louis Comfort|Tiffany Studios |Tiffany Glass Company|Tiffany Glass and Decorating Company 2441 American 1 1848 |1902 |1885 |1892 1933 |1932 |1892 |1902 late 19th–early 20th century 1870 1930 Watercolor, gouache, and graphite on white wove paper 1437 29 9/16 x 21 3/4 in. (75.1 x 55.2 cm) Purchase, Walter Hoving and Julia T. Weld Gifts and Dodge Fund, 1967 Made in 1       United States 3             Drawings 9   http://www.metmuseum.org/art/collection/search/17078 4/23/2018 8:00:01 AM 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 136.344ms · Data license: CC0 · Data source: metmuseum/openaccess