MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where "Artist End Date" is on date -4707-05-05 and City = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Medium

Artist End Date (date) ✖

  • -4707-05-05 · 10 ✖
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
342330 342330 42.81.1 0 0 491007 Modern and Contemporary Art 4 Textile piece 6366 Piece American 1         Maker 1   Catoir Silk Company American, founded New York, 1889–1989   Catoir Silk Company  47163 American 1 1889 1989 1942 1942 1942 Silk 165 36 x 27 in. (91.4 cm. x 68.6 cm. ) Gift of Catoir Silk Company, 1942 Object place 67 New York 3   New York 126 America 719 Mid-Atlantic 562           Textiles-Woven 191   http://www.metmuseum.org/art/collection/search/491007 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342331 342331 42.81.2 0 0 491008 Modern and Contemporary Art 4 Textile piece 6366 Piece American 1         Maker 1   Catoir Silk Company American, founded New York, 1889–1989   Catoir Silk Company  47163 American 1 1889 1989 1942 1942 1942 Rayon 15135 37 x 50 in. (94.0 cm. x 127.0 cm. ) Gift of Catoir Silk Company, 1942 Object place 67 New York 3   New York 126 America 719 Mid-Atlantic 562           Textiles-Woven 191   http://www.metmuseum.org/art/collection/search/491008 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342332 342332 42.81.3 0 0 491009 Modern and Contemporary Art 4 Textile piece 6366 Piece American 1         Maker 1   Catoir Silk Company American, founded New York, 1889–1989   Catoir Silk Company  47163 American 1 1889 1989 1942 1942 1942 Silk 165 10 x 27 1/4 in. (25.4 cm. x 69.2 cm. ) Gift of Catoir Silk Company, 1942 Object place 67 New York 3   New York 126 America 719 Mid-Atlantic 562           Textiles-Woven 191   http://www.metmuseum.org/art/collection/search/491009 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342333 342333 42.81.4 0 0 491010 Modern and Contemporary Art 4 Textile piece 6366 Piece American 1         Maker 1   Catoir Silk Company American, founded New York, 1889–1989   Catoir Silk Company  47163 American 1 1889 1989 1942 1942 1942 Rayon 15135 37 x 48 1/2 in. (94.0 cm. x 123.2 cm. ) Gift of Catoir Silk Company, 1942 Object place 67 New York 3   New York 126 America 719 Mid-Atlantic 562           Textiles-Woven 191   http://www.metmuseum.org/art/collection/search/491010 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342334 342334 42.81.5 0 0 491011 Modern and Contemporary Art 4 Textile piece 6366 Piece American 1         Maker 1   Catoir Silk Company American, founded New York, 1889–1989   Catoir Silk Company  47163 American 1 1889 1989 1942 1942 1942 Rayon 15135 38 1/2 x 50 1/2 in. (97.8 cm. x 128.3 cm. ) Gift of Catoir Silk Company, 1942 Object place 67 New York 3   New York 126 America 719 Mid-Atlantic 562           Textiles-Woven 191   http://www.metmuseum.org/art/collection/search/491011 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342335 342335 42.81.6 0 0 491012 Modern and Contemporary Art 4 Textile piece 6366 Piece American 1         Maker 1   Catoir Silk Company American, founded New York, 1889–1989   Catoir Silk Company  47163 American 1 1889 1989 1942 1942 1942 Rayon 15135 37 x 49 1/2 in. (94.0 cm. x 125.7 cm. ) Gift of Catoir Silk Company, 1942 Object place 67 New York 3   New York 126 America 719 Mid-Atlantic 562           Textiles-Woven 191   http://www.metmuseum.org/art/collection/search/491012 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342336 342336 42.81.7 0 0 491013 Modern and Contemporary Art 4 Textile piece 6366 Piece American 1         Maker 1   Catoir Silk Company American, founded New York, 1889–1989   Catoir Silk Company  47163 American 1 1889 1989 1942 1942 1942 Silk satin 14034 19 x 51 in. (48.3 cm. x 129.5 cm. ) Gift of Catoir Silk Company, 1942 Object place 67 New York 3   New York 126 America 719 Mid-Atlantic 562           Textiles-Woven 191   http://www.metmuseum.org/art/collection/search/491013 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342337 342337 42.81.8 0 0 491014 Modern and Contemporary Art 4 Textile piece 6366 Piece American 1         Maker 1   Catoir Silk Company American, founded New York, 1889–1989   Catoir Silk Company  47163 American 1 1889 1989 1942 1942 1942 Rayon satin 52993 18 x 52 in. (45.7 cm. x 132.1 cm. ) Gift of Catoir Silk Company, 1942 Object place 67 New York 3   New York 126 America 719 Mid-Atlantic 562           Textiles-Woven 191   http://www.metmuseum.org/art/collection/search/491014 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342338 342338 42.81.9 0 0 491015 Modern and Contemporary Art 4 Textile piece 6366 Piece American 1         Maker 1   Catoir Silk Company American, founded New York, 1889–1989   Catoir Silk Company  47163 American 1 1889 1989 1942 1942 1942 Silk 165 19 x 52 in. (48.3 cm. x 132.1 cm. ) Gift of Catoir Silk Company, 1942 Object place 67 New York 3   New York 126 America 719 Mid-Atlantic 562           Textiles-Woven 191   http://www.metmuseum.org/art/collection/search/491015 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
342339 342339 42.81.10 0 0 491016 Modern and Contemporary Art 4 Textile piece 6366 Piece American 1         Maker 1   Catoir Silk Company American, founded New York, 1889–1989   Catoir Silk Company  47163 American 1 1889 1989 1942 1942 1942 Silk or rayon, taffeta 52994 18 x 52 1/2 in. (45.7 cm. x 133.4 cm. ) Gift of Catoir Silk Company, 1942 Object place 67 New York 3   New York 126 America 719 Mid-Atlantic 562           Textiles-Woven 191   http://www.metmuseum.org/art/collection/search/491016 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 1389.576ms · Data license: CC0 · Data source: metmuseum/openaccess