MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Artist Prefix = "Foreword by"

View and edit SQL

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
219235 1986.1034.6 0 0 346753 Drawings and Prints 11 Book 97 Let's Laugh!: A Book of Humorous Inventions           Author|Illustrator|Publisher|Printer 1121 Foreword by Kenneth Robert Gordon Browne|William Heath Robinson|Hutchinson & Co.|Anchor Press British, born 1895|British, London 1872–1944 Highgate, London|Tiptree, Essex Ltd., London Browne, Kenneth Robert Gordon|Robinson, William Heath|Hutchinson & Co.|Anchor Press 22400 British|British|British 178 1895 |1872 |1900 1995 |1944 |1999 [1939] 1939 1939 Illustrations: lithography 28996 7 7/16 x 5 1/4 in. (18.9 x 13.3 cm) Gift of Special Publications Department, Robie Rogge, 1986   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
220508 1970.678 0 0 348042 Drawings and Prints 11 Book 97 Physiologie de la Boxe           Author|Designer|Publisher|Printer|Printer|Author 2167 Foreword by Edouard des Courières|Luc-Albert Moreau|Librairie Floury|R. Coulouma|Auguste Clot|Henry de Montherlant French, 20th century|1882–1948|Argenteuil, France|French, 1858–1936|French, 1896–1972 , Paris|(illustrations) Courières, Edouard des|Moreau, Luc-Albert|Floury|Coulouma, R.|Clot, Auguste|Montherlant, Henry de 23310 French|French|French|French|French|French 744 1900 |1882 |1858 |1896 1999 |1948 |1936 |1972 1929 1929 1929 Lithograph 14948 Overall: 16 9/16 x 11 13/16 x 1 3/8 in. (42 x 30 x 3.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1970   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
228093 55.578.11 0 0 355721 Drawings and Prints 11 Book 97 It's Smart to be People           Author|Author|Publisher 1051 Foreword by George Price|S. J. Perelman|Farrar, Straus and Giroux American, 20th century|American, 1904–1979|New York, NY   Price, George|Perelman, S. J.|Farrar, Straus and Giroux 28812 American|American|American 101 1900 |1904 |1900 1999 |1979 |2050 1942 1942 1942 Illustrations: reproductions of original drawings 35085 13 3/4 x 8 11/16 in. (35 x 22 cm) Bequest of Helen W.D. Mileham, 1955                       Books 442   Metropolitan Museum of Art, New York, NY 1
242377 1995.25.1a,b 0 0 370541 Drawings and Prints 11 Book 97 Sternberg: A Life in Woodcuts           Artist|Publisher|Author 1021 Foreword by Harry Sternberg|Brighton Press|Bella Lewitsky American, New York 1904–2001 Escondido, California|San Diego, California|American, Los Angeles, California 1916–2004 Pasadena, California   Sternberg, Harry|Brighton Press|Lewitsky, Bella 33849 American|American|American 101 1904 |1950 |1916 2001 |2010 |2004 1991 1991 1991 Illustrations: woodcut 33876 13 1/2 x 10 1/2 in. (34.3 x 26.7 cm) Purchase, John B. Turner Fund, 1995                       Books 442   Metropolitan Museum of Art, New York, NY 1
242741 39.500.2 0 0 370906 Drawings and Prints 11 Book 97 Wood Engravings           Illustrator|Author|Publisher 1083 Foreword by Fred Thomas Larson|Jewell F. Stevens|The Black Cat Press American, Chicago, Illinois 1868–1944 Chicago, Illinois|American, 20th century|Chicago, Illinois   Larson, Fred Thomas|Stevens, Jewell F.|Black Cat Press 33958 American|American|American 101 1868 |1938 |1880 1944 |1938 |1950 1938 1938 1938 Illustrations: wood engraving 28946 9 x 6 1/4 in. (22.9 x 15.9 cm) Rogers Fund, transferred from the Library, 1939                       Books 442   Metropolitan Museum of Art, New York, NY 1
242834 58.662 0 0 371004 Drawings and Prints 11 Book 97 Letters from and to the Ford Motor Company           Author|Author|Publisher|Author|Printer|Illustrator|Publisher 4073 Foreword by Marianne Moore|David Wallace|The New Yorker|Frederick B. Adams Jr.|The Spiral Press|Leonard Baskin|Morgan Library & Museum American, Kirkland, Missouri 1887–1972 New York|American, mid-20th century|American, 1910–2001|New York, NY|American, New Brunswick, New Jersey 1922–2000 Northampton, Massachusetts   Moore, Marianne|Wallace, David|New Yorker|Adams, Frederick B. Jr.|Spiral Press|Baskin, Leonard|Morgan Library & Museum 33995 American|American|American|American|American|American 663 1887 |1900 |1910 |1900 |1922 1972 |2000 |2001 |2000 |2000 1958 1958 1958 Illustrations: wood engraving 28946 9 7/8 x 6 1/2 in. (25.1 x 16.5 cm) Gift of A. Hyatt Mayor, 1958                       Books 442 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
377887 270.52 T49 1 0 591867 The Libraries 20   The Handmade Papers of Japan Rutland & Tokyo, 1952 6815         Author|Author 796 Foreword by Dard Hunter|Tindale, Thomas & Harriet R. American, Steubenville, Ohio 1883–1966 Chillicothe, Ohio   Hunter, Dard|Tindale, Thomas & Harriet R. 48557 American 1 1883 1966 1952 1952 1952 Illustrated books, envelope containing fiber samples 57674 4 vols. in box Presented by James H. Hyde                           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 7828.761ms · Data license: CC0 · Data source: metmuseum/openaccess