MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where "Artist End Date" is on date -4707-04-20 and Department = 10

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, 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

Department ✖

  • Arts of Africa, Oceania, and the Americas · 9 ✖

Artist End Date (date) ✖

  • -4707-04-20 · 9 ✖
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
380680 380680 b1239070 0 0 627320 Arts of Africa, Oceania, and the Americas 10 The Jaguar's Children: Pre-classic Central Mexico 26578 The Jaguar's Children: Pre-classic Central Mexico           Author|Publisher 44   Michael D. Coe|Museum of Primitive Art American, 1929–   Coe, Michael D.|Museum of Primitive Art 48933   1957 1974 1964 1964 1964   11 7/16 in. (29 cm) The Metropolitan Museum of Art, Thomas J. Watson Library                       Books 442   http://www.metmuseum.org/art/collection/search/627320 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
384816 384816 MOPA box 5 Charter Museum Indigenous Art 0 0 634425 Arts of Africa, Oceania, and the Americas 10 MOPA box 5 Charter Museum Indigenous Art 26625 MOPA box 5 Charter Museum Indigenous Ar           Archive constituent 4984   Museum of Primitive Art     Museum of Primitive Art 49484   1957 1974 1954 1954 1954     Rockefeller Family Archives. Courtesy of Rockefeller Archive Center.                       Documents 1030   http://www.metmuseum.org/art/collection/search/634425 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
414848 414848 VRA.2014.8.053 0 0 685320 Arts of Africa, Oceania, and the Americas 10 Photographs 13012 Woman with Curtains           Artist 2   Salla Casset Senegalese, 1910–1974   Casset, Salla 52283   1910 1974 1950s–1960s 1950 1969 Gelatin silver print 14941 7 × 4 1/2 in. (17.8 × 11.4 cm) Visual Resource Archive, Department of the Arts of Africa, Oceania, and the Americas   Dakar 2449     Senegal 282             Photographs 21   http://www.metmuseum.org/art/collection/search/685320 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
416228 416228 2015.499.8.1 0 0 687775 Arts of Africa, Oceania, and the Americas 10 Negative 13046 Two Young Women with Short Hair           Artist 2   Salla Casset Senegalese, 1910–1974   Casset, Salla 52283   1910 1974 1960s 1960 1969 Glass, emulsion 58964 H. 7 1/2 x W. 9 1/2 in. (19.1 x 24.1 cm) Gift of Susan Mullin Vogel, 2015         Senegal 282             Negatives|Glass 1060   http://www.metmuseum.org/art/collection/search/687775 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
416229 416229 2015.499.9.1 0 0 687777 Arts of Africa, Oceania, and the Americas 10 Negative 13046 Woman With a Flower Brooch           Artist 2   Salla Casset Senegalese, 1910–1974   Casset, Salla 52283   1910 1974 1960s 1960 1969 Glass, emulsion 58964 H. 9 1/2 x W. 7 1/2 in. (24.1 x 19.1 cm) Gift of Susan Mullin Vogel, 2015         Senegal 282             Negatives|Glass 1060   http://www.metmuseum.org/art/collection/search/687777 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
416230 416230 2015.499.10.1 0 0 687778 Arts of Africa, Oceania, and the Americas 10 Negative 13046 Woman holding an overdressed baby           Artist 2   Salla Casset Senegalese, 1910–1974   Casset, Salla 52283   1910 1974 1950s–1960s 1950 1969 Glass, emulsion 58964 H. 9 1/2 × W. 7 1/2 in. (24.1 × 19.1 cm) Gift of Susan Mullin Vogel, 2015         Senegal 282             Negatives|Glass 1060   http://www.metmuseum.org/art/collection/search/687778 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
426887 426887 2015.499.8.2 0 0 708783 Arts of Africa, Oceania, and the Americas 10 Photograph 997 Two young women with short hair           Artist 2   Salla Casset Senegalese, 1910–1974   Casset, Salla 52283   1910 1974 1975 1975 1975 Gelatin silver print 14941 H. 7 1/2 x W. 9 1/2 in. (19.1 x 24.1 cm) Gift of Susan Mullin Vogel, 2015         Senegal 282             Photographs 21   http://www.metmuseum.org/art/collection/search/708783 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
426945 426945 2015.499.9.2 0 0 708884 Arts of Africa, Oceania, and the Americas 10 Photograph 997 Woman with a flower brooch           Photographer 280   Salla Casset Senegalese, 1910–1974   Casset, Salla 52283   1910 1974 1975 1975 1975 Gelatin silver print 14941 H. 9 1/2 × W. 7 1/2 in. (24.1 × 19.1 cm) Gift of Susan Mullin Vogel, 2015         Senegal 282             Paper-Photographs 581   http://www.metmuseum.org/art/collection/search/708884 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
426946 426946 2015.499.10.2 0 0 708885 Arts of Africa, Oceania, and the Americas 10 Photograph 997 Woman Holding an Overdressed Baby           Photographer 280   Salla Casset Senegalese, 1910–1974   Casset, Salla 52283   1910 1974 1975 1975 1975 Gelatin silver print 14941 H. 9 1/2 × W. 7 1/2 in. (24.1 × 19.1 cm) Gift of Susan Mullin Vogel, 2015         Senegal 282             Paper-Photographs 581   http://www.metmuseum.org/art/collection/search/708885 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 2954.53ms · Data license: CC0 · Data source: metmuseum/openaccess