MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Nationality = 1187

View and edit SQL

Suggested facets: Object Name, Artist Role, Medium, Credit Line, 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
217705 66.542.15 0 0 345200 Drawings and Prints 11 Book 97 Guide to the art of illuminating and missal painting. . .with eight pages of lithographic illustrations           Author|Publisher|Author|Author 1667   W. & G. Audsley|George Rowney & Co.|William James Audsley|George Ashdown Audsley British|London|British, born 1833|British, Elgin, Scotland 1838–1925 New York   Audsley, W. & G.|Rowney, George & Co.|Audsley, William James|Audsley, George Ashdown 21402 British|British|British|British, Scottish 1187 1840 |1783 |1833 |1838 1900 |1900 |1933 |1925 1862 1862 1862 Illustrations: lithography 28996 7 1/2 x 4 15/16 in. (19 x 12.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
219242 1983.1223.10 0 0 346760 Drawings and Prints 11 Book 97 The Pied Piper of Hamelin           Author|Illustrator|Publisher|Printer 1121   Robert Browning|Arthur Rackham|George G. Harrap & Co. Ltd.|R. & R. Clark British, London 1812–1889 Venice|British, London 1867–1939 Limpsfield, Surrey|London|Edinburgh   Browning, Robert|Rackham, Arthur|Harrap, George G. & Co. Ltd.|Clark, R. & R. 22408 British|British|British|British, Scottish 1187 1812 |1867 |1880 |1846 1889 |1939 |1999 |1979 [1934] 1934 1934 Illustrations: photomechanical process 33879 9 1/16 x 6 in. (23 x 15.2 cm) Gift of Mrs. John Barry Ryan, transferred from the Library, 1983   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
220252 52.561.2 0 0 347785 Drawings and Prints 11 Book 97 The Comic English Grammar; A New and Facetious Introduction to the English Tongue           Illustrator|Publisher|Printer|Author 2146   John Leech|Richard Bentley|Samuel Bentley|Percival Leigh British, London 1817–1864 London|British, London 1794–1871 Ramsgate|London|British, Haddington, Scotland 1813–1889 London   Leech, John|Bentley, Richard|Bentley, Samuel|Leigh, Percival 23180 British|British|British|British, Scottish 1187 1817 |1794 |1785 |1813 1864 |1871 |1868 |1889 1840 1840 1840 Illustrations: lithography 28996 7 3/4 x 5 in. (19.7 x 12.7 cm) Gift of Sinclair Hamilton, 1952   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
223262 64.616 0 0 350838 Drawings and Prints 11 Book 97 Poems Dramatic and Lyrical           Author|Publisher|Illustrator|Publisher|Printer 2605   John Byrne Leicester Warren, Baron de Tabley|Elkin Mathews & John Lane|Charles de Sousy Ricketts|Macmillan & Co.|T. and A. Constable British, Knutsford, Cheshire 1835–1895 Ryde, Isle of Wight|at the Sign of the Bodley Head, London|British, Geneva 1866–1931 London|Edinburgh New York Warren, John Byrne Leicester Baron de Tabley|Mathews, Elkin & John Lane|Ricketts, Charles de Sousy|Macmillan & Co.|Constable, T. and A. 25324 British|British|British|British, Scottish 1187 1835 |1887 |1866 |1843 |1800 1895 |1894 |1931 |2012 |1999 1893 1893 1893 Illustrations: etching 28943 7 7/8 x 5 7/16 in. (20 x 13.8 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1964                       Books 442   Metropolitan Museum of Art, New York, NY 1
228665 21.36.62 0 0 356301 Drawings and Prints 11 Book 97 A Royal Warren or Picturesque Rambles in the Isle of Purbeck           Author|Publisher|Illustrator|Printer 1151   Charles Edmund Newton-Robinson|The Typographic Etching Company|Alfred Dawson|R. & R. Clark British, 1853–1913|London|British, active 1860–94|Edinburgh   Robinson, Charles Edmund Newton-|Typographic Etching Company|Dawson, Alfred|Clark, R. & R. 29168 British|British|British|British, Scottish 1187 1853 |1800 |1840 |1846 1913 |1900 |1940 |1979 1882 1882 1882 Illustrations: etching, photoengraving, wood engraving 36009 11 5/8 x 9 1/4 x 1 1/4 in. (29.5 x 23.5 x 3.2 cm) Rogers Fund, transferred from the Library, 1921                       Books 442   Metropolitan Museum of Art, New York, NY 1
231192 1972.655.6 0 0 358916 Drawings and Prints 11 Book 97 A Book of Christmas Verse           Editor|Illustrator|Publisher|Printer 2804   Henry Charles Beeching|Walter Crane|Methuen & Co., Ltd.|T. and A. Constable British, London 1859–1919 Norwich|British, Liverpool 1845–1915 Horsham|London|Edinburgh   Beeching, Henry Charles|Crane, Walter|Methuen & Co., Ltd.|Constable, T. and A. 30764 British|British|British|British, Scottish 1187 1859 |1845 |1900 |1800 1919 |1915 |1950 |1999 1895 1895 1895 Illustrations: wood engraving 28946 7 5/8 x 5 3/8 x 1 in. (19.3 x 13.6 x 2.6 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1972   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
231235 1972.655.9 0 0 358960 Drawings and Prints 11 Book 97 King Arthur's Knights: The Tales Retold for Boys and Girls           Author|Illustrator|Publisher|Printer 1121   Henry Gilbert|Walter Crane|T. C. & E. C. Jack|T. and A. Constable British, 1868–1937|British, Liverpool 1845–1915 Horsham|Edinburgh Edinburgh and London Gilbert, Henry|Crane, Walter|Jack, T. C. & E. C.|Constable, T. and A. 30772 British|British|British|British, Scottish 1187 1868 |1845 |1900 |1800 1937 |1915 |1999 |1999 1911 1911 1911 Illustrations: commercial color process 34637 9 7/16 x 6 13/16 x 1 7/8 in. (23.9 x 17.3 x 4.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1972                       Books 442   Metropolitan Museum of Art, New York, NY 1
231381 35.93.1 0 0 359117 Drawings and Prints 11 Book ; Ornament and Architecture 13814 An Attempt to Discriminate the Styles of Architecture           Architect|Publisher|Printer|Engraver 2216   Thomas Rickman|Longman, Hurst, Rees and Orme|George Smith, Liverpool|William Miller British, Maidenhead, Berkshire, 1776–1841|London|British, Edinburgh, Scotland 1796–1882 Sheffield   Rickman, Thomas|Longman, Hurst, Rees and Orme|Smith, George|Miller, William 30827 British|British|British|British, Scottish 1187 1776 |1790 |1800 |1796 1841 |1830 |1850 |1882 1825 1825 1825 Illustrations: etching and engraving 29021 9 1/8 × 5 11/16 × 1 3/8 in. (23.2 × 14.5 × 3.5 cm) Harris Brisbane Dick Fund, 1935                       Books|Ornament & Architecture 665   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.181ms · Data license: CC0 · Data source: metmuseum/openaccess