MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Department = 10 and Rights and Reproduction = "Image © Charles and Valerie Diker Collection/Photo: Dirk Bakker"

View and edit SQL

Suggested facets: Artist Display Bio, County, Country

Rights and Reproduction

  • Image © Charles and Valerie Diker Collection/Photo: Dirk Bakker · 6
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
432180 L.2017.57.24 0 0 717545 Arts of Africa, Oceania, and the Americas 10 Shirt 5887 Boy's Shirt Apsáalooke (Crow) 7013         Artist 2   Unrecorded Apsaalooke (Crow) Artist Native American   Unrecorded Apsaalooke (Crow) Artist 55119       1870–1900 1870 1900 Hide, glass, cotton, wool, sinew 61345 H. 21 5/16 × W. 31 1/2 in. (54.1 × 80 cm) Collection of Charles and Valerie Diker (665)       Montana 502 United States 3             Hide-Costumes 270 Image © Charles and Valerie Diker Collection/Photo: Dirk Bakker Metropolitan Museum of Art, New York, NY 1
432185 L.2017.57.25 0 0 717550 Arts of Africa, Oceania, and the Americas 10 Drawing 23 Kiowa Vanquishing Navajo Ka’igwu (Kiowa) 7016         Artist 2   Artist A (Julian Scott Ledger) Native American, Oklahoma, Ka’igwu (Kiowa)   Artist A (Julian Scott Ledger) 55123       1880 1880 1880 Pencil, colored pencil, and ink on paper 28087 H. 7 1/2 × W. 12 in. (19.1 × 30.5 cm) Collection of Charles and Valerie Diker (021LD)   Comanche Indian Reservation 2544   Oklahoma 400 United States 3             Paper-Drawings 515 Image © Charles and Valerie Diker Collection/Photo: Dirk Bakker Metropolitan Museum of Art, New York, NY 1
432191 Diker.016 0 0 717557 Arts of Africa, Oceania, and the Americas 10 Pipe bowl 8222 Pipe Bowl Muscogee (Creek) (?) 7020         Artist 2   Unrecorded Muscogee (Creek) (?) Artist Native American   Unrecorded Muscogee (Creek) (?) Artist 55129       ca. 1780 1775 1785 Wood, metal 6120 H. 3 1/2 × W. 6 × D. 2 in. (8.9 × 15.2 × 5.1 cm) Collection of Charles and Valerie Diker (531)       Georgia or Alabama 1115 United States 3             Wood-Implements 484 Image © Charles and Valerie Diker Collection/Photo: Dirk Bakker Metropolitan Museum of Art, New York, NY 1
432195 L.2017.57.28 0 0 717561 Arts of Africa, Oceania, and the Americas 10 Bag 5052 Fire Bag Cree or Anishinaabe (Ojibwa) 7024         Artist 2   Unrecorded Cree or Anishinaabe (Ojibwa) Artist Unrecorded Cree or Anishinaabe (Ojibwa) Artist, First Nations   Unrecorded Cree or Anishinaabe (Ojibwa) Artist 55133       ca. 1820 1820 1820 Hide, quill, pigment 61356 H. 10 × W. 6 1/2 × D. 1 in. (25.4 × 16.5 × 2.5 cm) Collection of Charles and Valerie Diker (496)       Western Ontario 1116 Canada 10             Hide-Containers 564 Image © Charles and Valerie Diker Collection/Photo: Dirk Bakker Metropolitan Museum of Art, New York, NY 1
432208 L.2017.57.29 0 0 717575 Arts of Africa, Oceania, and the Americas 10 Figure 9 Female Figure Okvik 7032         Artist 2   Unrecorded Okvik Artist Native American   Okvik, Unrecorded Okvik Artist 55145       2nd–5th century 100 499 Walrus ivory 822 H. 6 × W. 2 × D. 2 in. (15.2 × 5.1 × 5.1 cm) Collection of Charles and Valerie Diker (730)       Alaska 386 United States 3 Bering Strait region 735           Bone/Ivory-Sculpture 506 Image © Charles and Valerie Diker Collection/Photo: Dirk Bakker Metropolitan Museum of Art, New York, NY 1
432211 L.2017.57.30 0 0 717578 Arts of Africa, Oceania, and the Americas 10 Goggles 6491 Snow Goggles Ipiutak 7034         Artist 2   Unrecorded Ipiutak artist     Ipiutak, Unrecorded Ipiutak artist 55147       5th–10th century 400 999 Wood, walrus ivory 61366 H. 1 1/2 × W. 4 3/4 × D. 1 in. (3.8 × 12.1 × 2.5 cm) Collection of Charles and Valerie Diker (774)   Point Hope 2547   Alaska 386 United States 3             Wood-Implements|Bone/Ivory-Implements 1119 Image © Charles and Valerie Diker Collection/Photo: Dirk Bakker 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 1915.487ms · Data license: CC0 · Data source: metmuseum/openaccess