MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

16 rows where "Artist End Date" is on date -4707-04-06 and Artist Role = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Title, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, Classification

Artist End Date (date) ✖

  • -4707-04-06 · 16 ✖

Rights and Reproduction ✖

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
334899 334899 1981.445.1 0 0 482343 Modern and Contemporary Art 4 Dinner plate 355 Conversation           Designer|Manufacturer 3   Walter Dorwin Teague|Taylor, Smith, & Taylor American, Decatur, Indiana 1883–1960 Flemington, New Jersey|American, Chester, West Virginia   Teague, Walter Dorwin|Taylor, Smith, & Taylor 45234 American|American 5 1883 1960 ca. 1951 1951 1951 Earthenware 21 10 3/8 x 10 3/8 x 3/4 in. (26.4 x 26.4 x 1.9 cm) Gift of David A. Hanks, 1981                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/482343 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
334900 334900 1981.445.2 0 0 482344 Modern and Contemporary Art 4 Dinner plate 355 Conversation           Designer|Manufacturer 3   Walter Dorwin Teague|Taylor, Smith, & Taylor American, Decatur, Indiana 1883–1960 Flemington, New Jersey|American, Chester, West Virginia   Teague, Walter Dorwin|Taylor, Smith, & Taylor 45234 American|American 5 1883 1960 ca. 1951 1951 1951 Earthenware 21 10 3/8 x 10 3/8 x 3/4 in. (26.4 x 26.4 x 1.9 cm) Gift of David A. Hanks, 1981                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/482344 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
334901 334901 1981.445.3 0 0 482345 Modern and Contemporary Art 4 Bread plate 128 Conversation           Designer|Manufacturer 3   Walter Dorwin Teague|Taylor, Smith, & Taylor American, Decatur, Indiana 1883–1960 Flemington, New Jersey|American, Chester, West Virginia   Teague, Walter Dorwin|Taylor, Smith, & Taylor 45234 American|American 5 1883 1960 ca. 1951 1951 1951 Earthenware 21 6 1/2 x 6 1/2 x 3/4 in. (16.5 x 16.5 x 1.9 cm) Gift of David A. Hanks, 1981                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/482345 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
334902 334902 1981.445.4 0 0 482346 Modern and Contemporary Art 4 Bread plate 128 Conversation           Designer|Manufacturer 3   Walter Dorwin Teague|Taylor, Smith, & Taylor American, Decatur, Indiana 1883–1960 Flemington, New Jersey|American, Chester, West Virginia   Teague, Walter Dorwin|Taylor, Smith, & Taylor 45234 American|American 5 1883 1960 ca. 1951 1951 1951 Earthenware 21 6 3/8 x 6 3/8 x 5/8 in. (16.2 x 16.2 x 1.6 cm) Gift of David A. Hanks, 1981                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/482346 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
334903 334903 1981.445.5 0 0 482347 Modern and Contemporary Art 4 Bowl 106 Conversation           Designer|Manufacturer 3   Walter Dorwin Teague|Taylor, Smith, & Taylor American, Decatur, Indiana 1883–1960 Flemington, New Jersey|American, Chester, West Virginia   Teague, Walter Dorwin|Taylor, Smith, & Taylor 45234 American|American 5 1883 1960 ca. 1951 1951 1951 Earthenware 21 6 1/2 x 6 1/2 x 1 3/4 in. (16.5 x 16.5 x 4.4 cm) Gift of David A. Hanks, 1981                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/482347 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
334904 334904 1981.445.6 0 0 482348 Modern and Contemporary Art 4 Bowl 106 Conversation           Designer|Manufacturer 3   Walter Dorwin Teague|Taylor, Smith, & Taylor American, Decatur, Indiana 1883–1960 Flemington, New Jersey|American, Chester, West Virginia   Teague, Walter Dorwin|Taylor, Smith, & Taylor 45234 American|American 5 1883 1960 ca. 1951 1951 1951 Earthenware 21 6 1/2 x 6 1/2 x 1 3/4 in. (16.5 x 16.5 x 4.4 cm) Gift of David A. Hanks, 1981                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/482348 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
334905 334905 1981.445.7ab 0 0 482349 Modern and Contemporary Art 4 Gravy boat with plate 15135 Conversation           Designer|Manufacturer 3   Walter Dorwin Teague|Taylor, Smith, & Taylor American, Decatur, Indiana 1883–1960 Flemington, New Jersey|American, Chester, West Virginia   Teague, Walter Dorwin|Taylor, Smith, & Taylor 45234 American|American 5 1883 1960 ca. 1951 1951 1951 Earthenware 21 gravy boat: 3 1/4 x 7 3/4 x 3 1/4 in. (8.3 x 19.7 x 8.3 cm) plate: 5/8 x 8 1/2 x 8 1/2 in. (1.6 x 21.6 x 21.6 cm) Gift of David A. Hanks, 1981                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/482349 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
334906 334906 1981.445.8ab 0 0 482350 Modern and Contemporary Art 4 Coffee Pot 15136 Conversation           Designer|Manufacturer 3   Walter Dorwin Teague|Taylor, Smith, & Taylor American, Decatur, Indiana 1883–1960 Flemington, New Jersey|American, Chester, West Virginia   Teague, Walter Dorwin|Taylor, Smith, & Taylor 45234 American|American 5 1883 1960 ca. 1951 1951 1951 Earthenware 21 7 5/8 x 7 1/2 x 4 1/8 in. (19.4 x 19.1 x 10.5 cm) Gift of David A. Hanks, 1981                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/482350 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339463 339463 1998.537.31 0 0 487118 Modern and Contemporary Art 4 Radio 15259 "Bluebird" Radio           Designer|Manufacturer 3   Walter Dorwin Teague|Sparton Corporation (Jackson, Michigan) American, Decatur, Indiana 1883–1960 Flemington, New Jersey   Teague, Walter Dorwin|SPARTON CORPORATION 46394 American 1 1883 1960 1934 1934 1934 Glass, chrome-plated metal, fabric, painted wood 52398 H. 14-1/4, W. 14-1/2, D. 7 inches (36.2 x 36.8 x 17.8 cm) John C. Waddell Collection, Gift of John C. Waddell, 1998                       Machines & Appliances 895   http://www.metmuseum.org/art/collection/search/487118 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339772 339772 27.149.10 0 0 487509 Modern and Contemporary Art 4 Textile 1143 Americana Print: Falls Village           Designer|Manufacturer 3   Charles B. Falls|Stehli Silks Corporation American, Fort Wayne, Indiana 1874–1960 New York, New York   Falls, Charles|STEHLI SILKS CORPORA 46509 American|American 5 1874 1960 1925 1925 1925 Silk 165 36 × 40 in. (91.4 × 101.6 cm) Gift of Stehli Silks Corp., 1927                       Textiles-Printed 239   http://www.metmuseum.org/art/collection/search/487509 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339831 339831 27.243.1 0 0 487570 Modern and Contemporary Art 4 Textile 1143 "Americana Print: Ticker Tape" Textile           Designer|Manufacturer 3   Charles B. Falls|Stehli Silks Corporation American, Fort Wayne, Indiana 1874–1960 New York, New York   Falls, Charles|STEHLI SILKS CORPORA 46509 American|American 5 1874 1960 ca. 1927 1927 1927 Silk 165 38 1/2 x 27 in. (97.8 x 68.6 cm) Gift of Stehli Silks Corporation, 1927                       Textiles-Printed 239   http://www.metmuseum.org/art/collection/search/487570 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342248 342248 2001.722.4 0 0 490900 Modern and Contemporary Art 4 Vase 7 Vase           Designer|Manufacturer 3   Walter Dorwin Teague|Corning Glass Works, Steuben Division American, Decatur, Indiana 1883–1960 Flemington, New Jersey|Corning, New York   Teague, Walter Dorwin|STEUBEN 47124 American 1 1883 1960 1932 1932 1932 Glass 31 11 3/8 x Diam. 4 3/4 in. (28.9 x 12.1 cm) John C. Waddell Collection, Gift of John C. Waddell, 2001                       Glass 3   http://www.metmuseum.org/art/collection/search/490900 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342249 342249 2011.594 0 0 490901 Modern and Contemporary Art 4 Bowl 106 Bowl           Designer|Manufacturer 3   Walter Dorwin Teague|Corning Glass Works, Steuben Division American, Decatur, Indiana 1883–1960 Flemington, New Jersey|Corning, New York   Teague, Walter Dorwin|STEUBEN 47124 American 1 1883 1960 1932 1932 1932 Glass 31 H. 2-5/8, Diam. 16 in. (6.7 x 40.6 cm) John C. Waddell Collection, Gift of John C. Waddell, 2011                       Glass 3   http://www.metmuseum.org/art/collection/search/490901 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342250 342250 2002.585.13 0 0 490902 Modern and Contemporary Art 4 Vase 7 Vase           Designer|Manufacturer 3   Walter Dorwin Teague|Corning Glass Works, Steuben Division American, Decatur, Indiana 1883–1960 Flemington, New Jersey|Corning, New York   Teague, Walter Dorwin|STEUBEN 47124 American 1 1883 1960 ca. 1934 1929 1939 Glass 31 8 3/4 x Diam. 3 3/4 in. (22.2 x 9.5 cm) John C. Waddell Collection, Gift of John C. Waddell, 2002                       Glass 3   http://www.metmuseum.org/art/collection/search/490902 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342251 342251 2002.585.14 0 0 490903 Modern and Contemporary Art 4 Camera 13112 "Bantam Special"           Designer|Manufacturer 3   Walter Dorwin Teague|Eastman Kodak Co. American, Decatur, Indiana 1883–1960 Flemington, New Jersey|American   Teague, Walter Dorwin|Eastman Kodak Co. 47125 American|American 5 1883 1960 1936 1936 1936 Metal, enamel 21393 3 1/4 x 5 x 2 in. (8.3 x 12.7 x 5.1 cm) John C. Waddell Collection, Gift of John C. Waddell, 2002                       Machines & Appliances 895   http://www.metmuseum.org/art/collection/search/490903 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342261 342261 2001.722.3 0 0 490919 Modern and Contemporary Art 4 Vase 7 Vase           Designer|Manufacturer 3   Walter Dorwin Teague|Corning Glass Works, Steuben Division American, Decatur, Indiana 1883–1960 Flemington, New Jersey|Corning, New York   Teague, Walter Dorwin|STEUBEN 47124 American 1 1883 1960 1932 1932 1932 Glass 31 6 5/8 x Diam. 7 1/4 in. (16.8 x 18.4 cm) John C. Waddell Collection, Gift of John C. Waddell, 2001                       Glass 3   http://www.metmuseum.org/art/collection/search/490919 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 768.811ms · Data license: CC0 · Data source: metmuseum/openaccess