MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where "Artist End Date" is on date -4708-10-07 and Culture = 6

View and edit SQL

Suggested facets: Object Name, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Object Date, Object Begin Date, Object End Date, Classification

Artist End Date (date)

  • -4708-10-07 · 8
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
104556 13.42.81b 0 1 192205 European Sculpture and Decorative Arts 3 Strainer spoon 7033 Strainer spoon British 6         Maker 1 Possibly by John Perry entered 1757– ca. 1779   Perry John 8851   1757 1779 18th century 1700 1799 Silver 2 Length: 6 5/8 in. (16.8 cm) Rogers Fund, 1913                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
108492 29.114.2 0 1 196512 European Sculpture and Decorative Arts 3 Desk 89 Desk (bonheur du jour) British 6         Maker 1 Probably Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 ca. 1770–80 1765 1785 Harewood, rosewood, ebony, boxwood, satiné, purple-heart, mahogany 21909 Overall: 40 1/2 × 29 × 15 1/2 in. (102.9 × 73.7 × 39.4 cm) Fletcher Fund, 1929                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
112420 50.187.24 0 1 200700 European Sculpture and Decorative Arts 3 Medallion 72 The Dying Cleopatra British 6         Artist 2 Probably by Robert Bateman Wray British, Salisbury 1715–1779   Wray, Robert Bateman 10611   1715 1779 18th century 1700 1799 Colorless wax under glass; frame: gold wood 22531 Framed: 6 1/4 × 5 1/4 in. (15.9 × 13.3 cm) The Glenn Tilley Morse Collection, Bequest of Glenn Tilley Morse, 1950                       Sculpture-Miniature 311   Metropolitan Museum of Art, New York, NY 1
115236 64.101.983, .984 0 1 203749 European Sculpture and Decorative Arts 3 Side chairs 199 Pair of side chairs British 6         Designer 5 After a design by Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 ca. 1755–60 1750 1765 Mahogany; tent stitch embroidery on canvas 22861 Overall (each): 39 1/2 × 23 × 19 1/2 in. (100.3 × 58.4 × 49.5 cm) Gift of Irwin Untermyer, 1964                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
116625 1971.145 0 1 205348 European Sculpture and Decorative Arts 3 Writing table 988 Writing table British 6         Designer 5 After a design by Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London in "Director" of 1759, plate 77 Chippendale, Thomas 9727 British 7 1718 1779 ca. 1760 1755 1765 Mahogany, leather, gilt bronze 23169 30 3/4 × 71 1/2 × 41 1/2 in. (78.1 × 181.6 × 105.4 cm) Purchase, Irwin Untermyer Gift and Gift of Irwin Untermyer, by exchange, 1971                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
119494 1995.414 0 1 208530 European Sculpture and Decorative Arts 3 Medal 148 Academy of Ancient Music British 6         Artist 2 Medalist: Richard Yeo British, ca. 1720–1779 London   Yeo, Richard 11927   1720 1779 1750 1750 1750 Bronze 23 Diameter: 49 mm Purchase, Gift of Susan Dwight Bliss, by exchange and Various Donors, 1995                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
119523 1996.426.1–.14 0 1 208559 European Sculpture and Decorative Arts 3 Side chairs 199 Set of fourteen side chairs British 6         Maker 1   Thomas Chippendale British, baptised Otley, West Yorkshire 1718–1779 London   Chippendale, Thomas 9727 British 7 1718 1779 ca. 1772 1767 1777 Mahogany, covered in modern red morocco leather 23791 Overall (each): 38 1/4 × 22 × 22 1/2 in. (97.2 × 55.9 × 57.2 cm) Purchase, Lila Acheson Wallace and The Annenberg Foundation Gifts, Gift of Irwin Untermyer and Fletcher Fund, by exchange, Bruce Dayton Gift, and funds from various donors, 1996                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
121254 2001.432.13 0 1 210874 European Sculpture and Decorative Arts 3 Proof guinea 8715 Proof guinea of George III British 6         Maker 1   Richard Yeo British, ca. 1720–1779 London   Yeo, Richard 11927   1720 1779 1761 1761 1761 Gold 1 Diameter: 1 in. (25 mm) Gift of Assunta Sommella Peluso, Ada Peluso, and Romano I. Peluso, in memory of Ignazio Peluso, 2001                       Coins 241   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 1712.187ms · Data license: CC0 · Data source: metmuseum/openaccess