MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where County = 126, Department = 20 and Is Public Domain = 0

View and edit SQL

Suggested facets: Is Highlight, Object Date, Object Begin Date, Object End Date

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
412565 139.3 N48 F 1 0 680379 The Libraries 20   The Bishop collection: investigations and studies in jade           Author|Author|Author|Author|Publisher|Author 5158   Tadamasa Hayashi|George Frederick Kunz|Dr. Stephen Wootton Bushell|Robert Lilley|De Vinne Press|Heber R. Bishop 1856–1932|British, 1844–1908|American, New York   Hayashi, Tadamasa|Kunz George Frederick|Bushell Stephen Wootton Dr.|Lilley, Robert|De Vinne Press|Bishop, Heber R. 51997 American 1 1853 |1856 |1844 |1839 |1840 1906 |1932 |1844 |1914 |1902 1906 1906 1906   2 volumes : frontispiece (portrait), illustrations (some color), 93 plates (some color, including map), 2 diagrams; Height: 24 13/16 in. (63 cm); Width: 18 7/8 in. (48 cm)     New York 3   New York 126                   Metropolitan Museum of Art, New York, NY 1
421112 123.1 F412 1 0 697342 The Libraries 20   The metropolis of tomorrow           Publisher|Author 45   Ives Washburn|Hugh Ferriss New York, NY|American, 1889–1962   Washburn, Ives|Ferriss, Hugh 53527   1900 |1889 1999 |1962 1929 1929 1929   140, 4 pages, frontispiece, illustrations, Height: 12 3/16 in. (31 cm)     New York 3   New York 126                   Metropolitan Museum of Art, New York, NY 1
421121 159.4 N486 1 0 697355 The Libraries 20   The architect and the industrial arts : an exhibition of contemporary American design, the eleventh in the museum series, New York, February 12 to March 24, and continued to September 2, 1929           Printer|Designer|Subject of book|Publisher 5320   Plandome Press, Inc.|David Silve|William Addison Dwiggins|The Metropolitan Museum of Art American, Martinsville, Ohio 1880–1956 Hingham, Massachusetts   Plandome Press, Inc.|Silve, David|Dwiggins, William Addison|Metropolitan Museum of Art 53530   1880 1956 1929 1929 1929   83 pages, 3 leaves : illustrations, plates ; Height: 8 11/16 in. (22 cm)     New York 3   New York 126                   Metropolitan Museum of Art, New York, NY 1
441547 Vogue April 1, 1950 0 0 737907 The Libraries 20   Vogue           Artist 2   Irving Penn American, Plainfield, New Jersey 1917–2009 New York   Penn, Irving 6707   1917 2009 April 1, 1950 1950 1950 Offset lithography 35448 12 3/4 × 9 13/16 × 5/16 in. (32.4 × 24.9 × 0.8 cm) Irene Lewisohn Costume Reference Library   New York 3   New York 126                   Metropolitan Museum of Art, New York, NY 1
446760 100.51 B61 no.2 1 0 747647 The Libraries 20   The blind man           Editor|Editor|Publisher 1423   Man Ray|Marcel Duchamp|H. P. Roché American, Philadelphia, Pennsylvania 1890–1976 Paris|American (born France), Blanville 1887–1968 Neuilly-sur-Seine|French, 20th century   Man Ray|Duchamp, Marcel|Roché, H. P. 57073   1890 |1887 |1900 1976 |1968 |2000 1917 1917 1917   15 pages : illustrations ; Height: 11 in. (28 cm)     New York 3   New York 126                 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
457679 N6494.C8 G6 1959 1 0 773144 The Libraries 20   Cubism : a history and an analysis, 1907-1914           Author|Publisher 44   John Golding|George Wittenborn, Inc. New York, NY   Golding, John|Wittenborn, George, Inc. 58699   1900 1999 1959 1959 1959   207 pages, illustrations (some color), Height: 10 1/4 in. (26 cm)     New York 3   New York 126                   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 220.403ms · Data license: CC0 · Data source: metmuseum/openaccess