MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Role = 5476

View and edit SQL

Suggested facets: Is Public Domain, Object Name, 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
429012 2012.403.4 0 0 712043 Drawings and Prints 11 Drawing 23 Pyramus (Shakespeare, Le songe d'une nuit d'été / A Midsummer Night's Dream)           Publisher|Subject|Artist 5476   Georges Guillot, Paris|William Shakespeare|Umberto Brunelleschi British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon|Italian, Montemurlo, 1879–1949 Paris   Georges Guillot, Paris|Shakespeare, William|Brunelleschi, Umberto 54678   1564 |1879 1616 |1879 1947 1947 1947 Gouache 29287 Image: 10 3/8 × 8 1/16 in. (26.3 × 20.4 cm) Sheet: 12 7/8 × 10 13/16 in. (32.7 × 27.4 cm) Gift of Gloria Gallucci and Julien Stock, 2012                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
431240 1976.653.60 0 0 716192 Drawings and Prints 11 Print 731 An Odd Angle of the Isle (The Tempest, Act 1, Scene 2)         Tempest Series 1067 Publisher|Subject|Artist 5476 After Dodge Publishing Co.|William Shakespeare|Maxfield Parrish New York, NY|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon|American, Philadelphia, Pennsylvania 1870–1966 Plainfield, New Hampshire   Dodge Publishing Co.|Shakespeare, William|Parrish, Maxfield 54995   1850 |1564 |1870 1900 |1616 |1966 1909–1910 1909 1910 Color photographic process 37614 Sheet: 6 15/16 × 6 5/8 in. (17.7 × 16.8 cm) John O. Hamlin Bequest, 1976                       Prints 13   Metropolitan Museum of Art, New York, NY 1
445435 59.533.1317 0 0 745527 Drawings and Prints 11 Print 731 The Burning Shame           Publisher|Subject|Artist 5476   Thomas Tegg|Mary Anne Clarke|Thomas Rowlandson British, 1776–1846|British, London 1776?–1852 Boulogne|British, London 1757–1827 London   Tegg, Thomas|Clarke, Mary Anne|Rowlandson, Thomas 56826   1776 |1776 |1757 1846 |1852 |1827 March 9, 1809 1809 1809 Hand-colored etching 34862 Sheet: 10 3/8 × 14 11/16 in. (26.3 × 37.3 cm) Plate: 9 3/4 × 13 3/4 in. (24.7 × 35 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
450208 59.533.762(6) 0 0 754250 Drawings and Prints 11 Print 731 Captain Bowling introduced to Narcissa           Publisher|Subject|Artist 5476   Rudolph Ackermann, London|Tobias Smollett|Thomas Rowlandson active 1794–1829|British, Renton, Scotland 1721–1771 Livorno, Italy|British, London 1757–1827 London   Ackermann, Rudolph|Smollett, Tobias|Rowlandson, Thomas 57463   1764 |1721 |1757 1834 |1771 |1827 May 12, 1800 1800 1800 Hand-colored etching and aquatint 32179 Plate: 10 11/16 × 14 1/8 in. (27.2 × 35.8 cm) Sheet: 12 3/16 in. × 16 in. (31 × 40.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
456249 66.748.28 0 1 769170 Drawings and Prints 11 Print 731 Axel Tallberg's etching class (Från Etsareskolan), from the portfolio of the Swedish Fine Art Print Society (Föreningen för Grafisk Konst)         The Swedish Fine Art Print Society portfolio (Föreningen för Grafisk Konst) 1349 Publisher|Subject|Artist 5476   Föreningen för Grafisk Konst|Axel Tallberg|Axel Sjöberg Swedish|Swedish, Gävle 1860–1928 Solna|Swedish, Stockholm 1866–1950 Stockholm   Föreningen för Grafisk Konst|Tallberg, Axel|Sjöberg, Axel 58333   1887 |1860 |1866 9999 |1928 |1950 1896 1896 1896 Soft-ground etching 31185 Image: 9 7/16 × 6 7/16 in. (24 × 16.3 cm) Sheet: 19 1/2 × 15 3/4 in. (49.6 × 40 cm) Gift of Föreningen för Grafisk Konst, 1966                       Prints 13   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 138.239ms · Data license: CC0 · Data source: metmuseum/openaccess