MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

14 rows where "Artist End Date" is on date -4707-04-06 and Artist Nationality = 5

View and edit SQL

Suggested facets: Object Name, Title, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, 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
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
339467 1998.537.38 0 0 487122 Modern and Contemporary Art 4 Camera 13112 Camera           Manufacturer|Designer 18   Eastman Kodak Co.|Walter Dorwin Teague American|American, Decatur, Indiana 1883–1960 Flemington, New Jersey   Eastman Kodak Co.|Teague, Walter Dorwin 46398 American|American 5 1883 1960 1930 1930 1930 Metal, lacquer 52401 Closed: 8 1/4 x 3 7/8 x 1 5/8 in. (21 x 9.8 x 4.1 cm) John C. Waddell Collection, Gift of John C. Waddell, 1998                       Machines & Appliances 895   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
339832 27.243.2 0 0 487571 Modern and Contemporary Art 4 Textile 1143 "Americana Print: Pegs" Textile           Manufacturer|Designer 18   Stehli Silks Corporation|Charles B. Falls American, Fort Wayne, Indiana 1874–1960 New York, New York   STEHLI SILKS CORPORA|Falls, Charles 46527 American|American 5 1874 1960 ca. 1927 1927 1927 Printed silk 52399 38 1/2 x 29 1/4 in. (97.8 x 74.3 cm) Gift of Stehli Silks Corporation, 1927                       Textiles-Printed 239   Metropolitan Museum of Art, New York, NY 1
342232 1998.537.39a-c 0 0 490879 Modern and Contemporary Art 4 Camera Box 15322 Camera Box           Manufacturer|Designer 18   Eastman Kodak Co.|Walter Dorwin Teague American|American, Decatur, Indiana 1883–1960 Flemington, New Jersey   Eastman Kodak Co.|Teague, Walter Dorwin 46398 American|American 5 1883 1960 1930 1930 1930 Metal, lacquer 52401 2 1/2 x 8 7/8 x 4 3/8 in. (6.4 x 22.5 x 11.1 cm) John C. Waddell Collection, Gift of John C. Waddell, 1998                       Machines & Appliances 895   Metropolitan Museum of Art, New York, NY 1
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   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 2500.18ms · Data license: CC0 · Data source: metmuseum/openaccess