MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

4 rows where Artist Nationality = 1669

View and edit SQL

Suggested facets: Is Public Domain, Object Name, 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
222802 41.100.175 0 0 350368 Drawings and Prints 11 Book 97 The Antiquities of Magna Graecia . . .           Author|Printer|Publisher|Engraver 2528   William Wilkins|Richard Watts|Longman, Hurst, Rees and Orme|Filippo Morghen British, 1778–1839|at the University Press, Cambridge|London|Italian, Florence 1730–after 1807 Naples   Wilkins, William|Watts, Richard|Longman, Hurst, Rees and Orme|Morghen, Filippo 24959 British|British|British|Italian 1669 1778 |1800 |1790 |1730 1839 |1820 |1830 |1807 1807 1807 1807 Illustrations: engraving 28942 22 7/16 x 14 15/16 x 1 9/16 in. (57 x 38 x 4 cm) Bequest of W. Gedney Beatty, 1941                       Books 442   Metropolitan Museum of Art, New York, NY 1
230255 21.36.76 0 1 357941 Drawings and Prints 11 Book 97 The Pastorals of Virgil, with a Course of English Reading, Adapted for Schools, Vol. I           Editor|Illustrator|Publisher|Author 3439   Robert John Thornton|William Blake|F. C. & J. Rivington|Virgil British, 1768–1837|British, London 1757–1827 London|London|Roman, Andes 70 B.C.–19 B.C. Brundisium   Thornton, Robert John|Blake, William|Rivington, F. C. & J.|Virgil 30296 British|British|British|Italian 1669 1768 |1757 |1750 |-0070 1837 |1827 |1850 |-0019 1821 1821 1821 Illustrations: wood engraving 28946 7 1/16 x 4 5/16 in. (18 x 11 cm) Museum Accession, transferred from the Library, 1921                       Books 442   Metropolitan Museum of Art, New York, NY 1
287648 21.72(3) 0 1 416962 Drawings and Prints 11 Print 731 Shrimps!           Publisher|Publisher|Artist|Engraver 4687 Originally published by|Here published by|after Jane Hogarth|Boydell and Co.|William Hogarth|Francesco Bartolozzi British, 1709–1789|London|British, London 1697–1764 London|Italian, Florence 1728–1815 Lisbon   Hogarth, Jane|Boydell and Co.|Hogarth, William|Bartolozzi, Francesco 41538 British|British|British|Italian 1669 1709 |1760 |1697 |1728 1789 |1820 |1764 |1815 [March 25, 1782], reissued 1790 1782 1790 Stipple engraving, printed in brown ink; third state 43733 Sheet: 10 5/16 x 7 in. (26.2 x 17.8 cm) Gift of Mrs. Frederick Allien, 1921                       Prints 13   Metropolitan Museum of Art, New York, NY 1
380942 53.600.2268 0 0 628040 Drawings and Prints 11 Print 731 The Disciples at Emmaus           Publisher|Artist|Artist|Artist 1298 Intermediary draftsman|After John Boydell|Robert Dunkarton|Josiah Boydell|Guercino (Giovanni Francesco Barbieri) British, Shropshire 1720–1804 London|British, 1744–1811|British, Hawarden, Flintshire 1752–1817 Middlesex|Italian, Cento 1591–1666 Bologna   Boydell, John|Dunkarton, Robert|Boydell, Josiah|Guercino (Giovanni Francesco Barbieri) 48964 British|British|British|Italian 1669 1720 |1744 |1752 |1591 1804 |1744 |1817 |1666 1779 1779 1779 Mezzotint 29072 Sheet (Trimmed): 17 1/2 × 21 1/16 in. (44.5 × 53.5 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 249.707ms · Data license: CC0 · Data source: metmuseum/openaccess