MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where County = 126 and Department = 20

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Object Date, Object Begin Date, Object End Date, Credit Line

Department

  • The Libraries · 11

County

  • New York · 11
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
424796 153 Ar7 F 1 1 705638 The Libraries 20   Artistic houses : being a series of interior views of a number of the most beautiful and celebrated homes in the United States : with a description of the art treasures contained therein           Publisher 16   D. Appleton & Co.     Appleton & Co. 54207       1883–84 1883 1884   2 volumes in 4, [193] leaves of plates ; Height: 20 1/2 in. (52 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
441847 170.1 R674 1 1 738466 The Libraries 20   Modern chromatics : with applications to art and industry           Author 41   Ogden Nicholas Rood 1831-1902   Rood, Ogden Nicholas 56339   1831 1902 1879 1879 1879   3 pages, 1 leaf, [v]-viii, [9]-329 pages : color frontispiece, illustrations, diagrams ; Height: 7 7/8 in. (20 cm)     New York 3   New York 126                   Metropolitan Museum of Art, New York, NY 1
442026 F595 .R38 1895 1 1 738758 The Libraries 20   Pony tracks           Publisher|Artist 740   Harper & Brothers|Frederic Remington American, New York|American, Canton, New York 1861–1909 Ridgefield, Connecticut   Harper & Brothers|Remington, Frederic 56364   1833 |1861 1962 |1909 1895 1895 1895   viii pages, 1 leaf, 269 pages including plates : illustrations, frontispiece ; Height: 9 1/16 in. (23 cm) Gift of Friends of the Thomas J. Watson Library   New York 3   New York 126                   Metropolitan Museum of Art, New York, NY 1
442031 PS2267 .A1 1891 1 1 738765 The Libraries 20   The song of Hiawatha           Illustrator|Author|Publisher 1083   Frederic Remington|Henry Wadsworth Longfellow|Houghton Mifflin Company American, Canton, New York 1861–1909 Ridgefield, Connecticut|American, Portland, Maine 1807–1882 Cambridge, Massachusetts   Remington, Frederic|Longfellow, Henry Wadsworth|Houghton Mifflin Company 56365   1861 |1807 1909 |1882 1891 1891 1891   xviii, 242 pages : frontispiece (portrait), illustrations, plates ; Height: 9 7/16 in. (24 cm) Gift of Friends of the Thomas J. Watson 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
447829 107.1 K75 1920 no.8 1 1 749370 The Libraries 20   Messrs. M. Knoedler & Co. announce an exhibition of water colors, drawings and stage decorations by Leon Bakst : April 10th to April 24th, inclusive, 1920           Artist|Publisher 710   Léon Bakst|M. Knoedler & Co. Russian, Grodno 1866–1924 Paris   Bakst, Léon|Knoedler, M., & Co. 57216   1866 |1857 1924 |2011 1920 1920 1920   8 unnumbered pages : Height: 7 7/8 in. (20 cm)     New York 3   New York 126                   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 175.744ms · Data license: CC0 · Data source: metmuseum/openaccess