home / MetObjects

MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

3 rows where Artist Alpha Sort = 13

View and edit SQL

This data as .json

Suggested facets: Is Public Domain, Department, Object Name, Title, Artist Role, Artist Display Bio, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Credit Line, City, Classification

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
102 41.160.374 0 1 110 American Decorative Arts 1 Andiron 12 Andiron American 1         Maker 1   James Davis active 1803–28   Davis, James 13   1803 1828 1803–28 1803 1828 Brass 12 18 1/2 x 17 in. (47 x 43.2 cm) Bequest of W. Gedney Beatty, 1941 Made in 1 Boston 8     United States 3             Metal 1   Metropolitan Museum of Art, New York, NY 1
103 41.160.375 0 1 111 American Decorative Arts 1 Andiron 12 Andiron American 1         Maker 1   James Davis active 1803–28   Davis, James 13   1803 1828 1803–28 1803 1828 Brass 12 18 1/2 x 17 in. (47 x 43.2 cm) Bequest of W. Gedney Beatty, 1941 Made in 1 Boston 8     United States 3             Metal 1   Metropolitan Museum of Art, New York, NY 1
220872 62.573.2 0 0 348411 Drawings and Prints 11 Book 97 Hints & suggestions for the use of artistic paper hangings           Author 41   James Davis American, active early 20th century   Davis, James 13 American 1 1900 1920 1913–14 1913 1914     The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1962   Chicago 19                   Books 442   Metropolitan Museum of Art, New York, NY 1
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))
Powered by Datasette · Query took 18.258ms · Data license: CC0 · Data source: metmuseum/openaccess