MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where "Artist Begin Date" is on date -4707-04-12 and Culture = 6

✎ 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 End Date, Object Date, Object Begin Date, Object End Date, Credit Line

Artist Begin Date (date) ✖

  • -4707-04-12 · 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 Metadata Date Repository
77304 77304 2004.153.1 0 0 101597 Costume Institute 8 Hat 1056 Hat British 6         Designer 5   Philip Treacy British, born Ireland, 1966   Treacy Philip 6459 British 7 1966 2067 ca. 2003 1998 2004 synthetic, feathers, elastic, plastic, silk 17453   Gift of Caroline Rennolds Milbank, 2004                           http://www.metmuseum.org/art/collection/search/101597 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
88008 88008 2006.119 0 0 128080 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   Robert Cary Williams British, born 1966   Williams Robert Cary 6771   1966 2066 2005 2005 2005 nylon 15130   Millia Davenport and Zipporah Fleisher Fund and Isabel Shults Fund, 2006                           http://www.metmuseum.org/art/collection/search/128080 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
88115 88115 2006.211 0 0 128827 Costume Institute 8 Headdress 3952 Crown British 6         Designer 5   Philip Treacy British, born Ireland, 1966   Treacy Philip 6459 British 7 1966 2067 spring/summer 2005 2005 2005 silk, cotton 15149   Alfred Z. Solomon-Janet A. Sloane Endowment Fund, 2006                           http://www.metmuseum.org/art/collection/search/128827 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
88464 88464 2006.420.111 0 0 131414 Costume Institute 8 Hat 1056 Hat British 6         Designer 5   Philip Treacy British, born Ireland, 1966   Treacy Philip 6459 British 7 1966 2067 late 1990s 1995 1999 synthetic, silk, metal 16700   Gift of Thomas L. Kempner, 2006                           http://www.metmuseum.org/art/collection/search/131414 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
88465 88465 2006.420.112 0 0 131415 Costume Institute 8 Hat 1056 Hat British 6         Designer 5   Philip Treacy British, born Ireland, 1966   Treacy Philip 6459 British 7 1966 2067 late 1990s 1995 1999 synthetic, cotton 15944   Gift of Thomas L. Kempner, 2006                           http://www.metmuseum.org/art/collection/search/131415 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
88466 88466 2006.420.113 0 0 131418 Costume Institute 8 Hat 1056 Hat British 6         Designer 5   Philip Treacy British, born Ireland, 1966   Treacy Philip 6459 British 7 1966 2067 ca. 2002 1997 2006 leather, feathers, synthetic, metal 18880   Gift of Thomas L. Kempner, 2006                           http://www.metmuseum.org/art/collection/search/131418 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
88467 88467 2006.420.114 0 0 131419 Costume Institute 8 Hat 1056 Hat British 6         Designer 5   Philip Treacy British, born Ireland, 1966   Treacy Philip 6459 British 7 1966 2067 ca. 2002 1997 2006 feathers, wire 18881   Gift of Thomas L. Kempner, 2006                           http://www.metmuseum.org/art/collection/search/131419 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95907 95907 2012.519 0 0 171324 Costume Institute 8 Hat 1056 Hat British 6         Designer 5   Philip Treacy British, born Ireland, 1966   Treacy Philip 6459 British 7 1966 2067 2011 2011 2011 silk, metal, synthetic 19768   Gift of Melinda B. Hildebrand, 2012                           http://www.metmuseum.org/art/collection/search/171324 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 1917.087ms · Data license: CC0 · Data source: metmuseum/openaccess