MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Medium = 36845

View and edit SQL

Suggested facets: Is Public Domain, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Credit Line

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
232641 18.47 0 1 360392 Drawings and Prints 11 Print 731 Amelia Elizabeth, Landgravine of Hesse           Artist 2   Ludwig von Siegen German, 1609–after 1676   Siegen, Ludwig von 31398 German 10 1609 1676 17th century 1600 1699 Mezzotint; first state 36845 Sheet: 16 7/16 x 11 15/16 in. (41.8 x 30.3 cm) Rogers Fund, 1918                       Prints 13   Metropolitan Museum of Art, New York, NY 1
237975 17.3.756-2187 0 0 365962 Drawings and Prints 11 Print 731 Owen MacSwiny           Artist|Sitter 972 Portrait of Pieter van Bleeck|Owen MacSwiny Dutch, The Hague 1695–1764 England|British, active ca. 1749   Bleeck, Pieter van|MacSwiny, Owen 32674 Dutch|British 597 1695 |1700 1764 |1800 1749 1749 1749 Mezzotint; first state 36845   Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
261794 53.600.302 0 0 390697 Drawings and Prints 11 Print 731 Thomas Browne           Artist|Artist|Publisher|Publisher 939 After William Dickinson|Nathaniel Dance-Holland|Thomas Watson|William Dickinson British, 1746–1823|British, London 1735–1811 Winchester|British, London 1743–1781 London|British, 1746–1823   Dickinson, William|Dance-Holland, Nathaniel|Watson, Thomas|Dickinson, William 38062 British|British|British|British 177 1746 |1735 |1743 |1746 1823 |1811 |1781 |1823 November 1, 1780 1780 1780 Mezzotint; first state 36845 25 x 15 1/16 in. (63.5 x 38.3 cm) Harris Brisbane Dick Fund, 1953                       Prints 13   Metropolitan Museum of Art, New York, NY 1
261796 41.105.21 0 0 390699 Drawings and Prints 11 Print 731 John Penn           Artist|Artist|Sitter 1046 After|Portrait of Robert Dunkarton|Sir William Beechey|John Penn British, 1744–1811|British, Burford, Oxfordshire 1753–1839 Hampstead|British, 1760–1834   Dunkarton, Robert|Beechey, William, Sir|Penn, John 38064 British|British|British 178 1744 |1753 |1760 1744 |1839 |1834 March 25, 1809 1809 1809 Mezzotint; first state 36845 plate: 27 1/4 x 17 in. (69.2 x 43.2 cm) sheet: 28 3/8 x 18 1/8 in. (72.1 x 46 cm) Harris Brisbane Dick Fund, 1941                       Prints 13   Metropolitan Museum of Art, New York, NY 1
414839 54.508.1 0 0 685303 Drawings and Prints 11 Print 731 Pheasants           Artist|Artist 13 after Charles Turner|James Barenger British, Woodstock, Oxfordshire 1774–1857 London|British, London 1780–1831 London   Turner, Charles|Barenger, James 52279 British|British 9 1774 |1780 1857 |1831 1906 1906 1906 Mezzotint; first state 36845 Sheet (trimmed to image): 14 1/2 × 17 7/16 in. (36.8 × 44.3 cm) Gift of William P.J. O'Connor, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
414840 54.508.2 0 0 685304 Drawings and Prints 11 Print 731 Black Grouse           Artist|Artist 13 after Charles Turner|James Barenger British, Woodstock, Oxfordshire 1774–1857 London|British, London 1780–1831 London   Turner, Charles|Barenger, James 52279 British|British 9 1774 |1780 1857 |1831 1906 1906 1906 Mezzotint; first state 36845 Image: 13 3/4 × 17 5/16 in. (34.9 × 44 cm) Plate: 14 7/8 × 17 1/2 in. (37.8 × 44.5 cm) Sheet: 15 5/8 × 20 1/16 in. (39.7 × 51 cm) Gift of William P.J. O'Connor, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
426260 53.600.4478 0 1 707898 Drawings and Prints 11 Print 731 Mrs. Gwyn & Mrs. Bunbury in the Characters of The Merry Wives of Windsor           Engraver|Sitter|Artist|Subject|Publisher|Sitter|Publisher 5415 After William Dickinson|Catherine Bunbury|Daniel Gardner|William Shakespeare|Thomas Watson|Mary Gwyn|William Dickinson British, 1746–1823|British, 1754–1799|British, Kendal, Cumbria 1750–1805 London|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon|British, London 1743–1781 London|British, ca. 1752–1840|British, 1746–1823   Dickinson, William|Bunbury, Catherine|Gardner, Daniel|Shakespeare, William|Watson, Thomas|Gwyn, Mary|Dickinson, William 54386   1746 |1754 |1750 |1564 |1743 |1752 |1746 1823 |1799 |1805 |1616 |1781 |1840 |1823 1780 1780 1780 Mezzotint; first state 36845 Sheet (trimmed to image): 11 3/4 × 10 11/16 in. (29.8 × 27.2 cm) Harris Brisbane Dick Fund, 1953                       Prints 13   Metropolitan Museum of Art, New York, NY 1
457165 53.600.175 0 0 771511 Drawings and Prints 11 Print 731 Sir Edward Hughes           Engraver|Artist|Sitter 3726 After John Jones|Sir Joshua Reynolds|Admiral Sir Edward Hughes British, ca. 1745–1797|British, Plympton 1723–1792 London|British, 1720?–1794   Jones, John|Reynolds, Joshua, Sir|Hughes, Edward Admiral Sir 58579   1745 |1723 |1720 1797 |1792 |1794 1786 1786 1786 Mezzotint; first state 36845 Sheet (trimmed to plate): 24 3/8 × 14 7/8 in. (61.9 × 37.8 cm) Harris Brisbane Dick Fund, 1953                       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 112.383ms · Data license: CC0 · Data source: metmuseum/openaccess