MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where City = 1131

View and edit SQL

Suggested facets: Object Name, Title, Artist Role, Artist Prefix, Artist Nationality, 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
217209 46.23 0 0 344700 Drawings and Prints 11 Book ; Ornament and Architecture 13814 Elementa architecturae civilis ad Vitruvii veterumque disciplinam et recentiorum praesertim a Palladii exempla probatiora concinnata           Artist|Engraver|Author|Publisher|Sitter|Author 1564 Frontispiece after|Frontispiece engraved by Sir Godfrey Kneller|James Heath|Philip Smyth|D. Prince and J. Cooke|Henry Aldrich|Henry Aldrich German, Lübeck 1646–1723 London|British, London 1757–1834 London|British, late 18th century|Oxford|British, Westminster 1648–1710 London|British, Westminster 1648–1710 London   Kneller, Godfrey, Sir|Heath, James|Smyth, Philip|Prince, D., and J. Cooke|Aldrich, Henry|Aldrich, Henry 21026 German|British|British|British|British|British 1120 1646 |1757 |0018 |1750 |1648 |1648 1723 |1834 |0018 |1800 |1710 |1710 1789 1789 1789 Frontispiece: stipple engraving; other illustrations: etching and engraving 33983 9 7/16 × 6 1/16 × 1 9/16 in. (24 × 15.4 × 4 cm) Harris Brisbane Dick Fund, 1946   Oxford 1131                   Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
219292 60.633.14 0 0 346810 Drawings and Prints 11 Book ; Ornament and Architecture 13814 Elevations, sections, and details of Saint Peter's Church, Wilcote, Oxfordshire           Publisher|Draftsman|Architect 1985 Surveyed by John Henry Parker|Henry Thompson|John Chessell Buckler Oxford|British, active 1844|British, 1793–1894 for the Architectural Society Parker, John Henry|Thompson, Henry|Buckler, John Chessell 22454 British|British|British 178 1800 |1800 |1793 1900 |1900 |1894 1844 1844 1844 Illustrations: etching and engraving 29021 15 3/8 x 10 1/16 x 3/16 in. (39 x 25.5 x 0.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1960   Oxford 1131                   Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
222191 63.609.5 0 0 349751 Drawings and Prints 11 Book 97 Decimus Junius Juvenalis, and Aulus Persius Flaccus           Translator|Printer|Publisher|Author|Author 2429   Barten Holyday|W. Downing|F. Oxlad Senior, J. Adams, and F. Oxlad Junior|Decimus Junius Juvenal|Aulus Persius Flaccus British, Oxford 1593–1661 Iffley|Oxford|Oxford|Aquinum 55/60?–?127/140|Volterra 34–62 Campania   Holyday, Barten|Downing, W.|Oxlad F. Senior, Adams J., and Oxlad F. Junior|Juvenal, Decimus Junius|Flaccus, Aulus Persius 24478 British|British|British|Roman|Roman 1619 1593 |1600 |1600 |0055 |0034 1661 |1699 |1699 |0140 |0062 1673 1673 1673 Illustrations: engraving and woodcut 35042 11 3/4 x 7 5/8 x 1 5/16 in. (29.8 x 19.4 x 3.3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1963   Oxford 1131                   Books 442   Metropolitan Museum of Art, New York, NY 1
391627 58.549.11 0 0 643596 Drawings and Prints 11 Print 731 Mary, Queen of Scots           Sitter|Artist|Artist|Publisher 4959 After Mary, Queen of Scots|Thomas Woolnoth|George Perfect Harding|Butler & Margetts Linlithgow 1542–1587 Fotheringhay, England|British, London 1785–1857?|British, Kent 1780–1853 London|British, Oxford   Mary Queen of Scots|Woolnoth, Thomas|Harding, George Perfect|Butler & Margetts 49888 Scottish|British|British|British 3566 1542 |1785 |1780 |1825 1587 |1857 |1853 |1875 January 1, 1839 1839 1839 Stipple engraving 37370 Sheet: 13 3/4 × 9 3/4 in. (35 × 24.8 cm) Gift of Susan Dwight Bliss, 1958   Oxford 1131                   Prints 13   Metropolitan Museum of Art, New York, NY 1
399796 58.549.221 0 0 654303 Drawings and Prints 11 Print 731 Mary, Queen of Scots           Sitter|Artist|Publisher 3695   Mary, Queen of Scots|John Whessell|John Whessell Linlithgow 1542–1587 Fotheringhay, England|British, ca. 1760–after 1820|British, ca. 1760–after 1820   Mary Queen of Scots|Whessell, John|Whessell, John 50848 Scottish|British|British 3556 1542 |1755 |1755 1587 |1855 |1855 1825 1825 1825 Stipple engraving 37370 Plate: 9 3/8 × 6 9/16 in. (23.8 × 16.6 cm) Sheet: 13 1/8 × 9 13/16 in. (33.4 × 25 cm) Gift of Susan Dwight Bliss, 1958   Oxford 1131                   Prints 13   Metropolitan Museum of Art, New York, NY 1
399800 58.549.223 0 0 654307 Drawings and Prints 11 Print 731 Mary, Queen of Scots           Sitter|Artist|Artist|Publisher 4959 After Mary, Queen of Scots|Thomas Woolnoth|George Perfect Harding|Thomas Butler Linlithgow 1542–1587 Fotheringhay, England|British, London 1785–1857?|British, Kent 1780–1853 London|British, Oxford 1800–before 1871 Oxford   Mary Queen of Scots|Woolnoth, Thomas|Harding, George Perfect|Butler, Thomas 50851 Scottish|British|British|British 3566 1542 |1785 |1780 |1800 1587 |1857 |1853 |1871 January 14, 1831 1831 1831 Stipple engraving 37370 Plate: 10 15/16 × 7 5/16 in. (27.8 × 18.6 cm) Sheet: 17 1/4 × 13 9/16 in. (43.8 × 34.5 cm) Gift of Susan Dwight Bliss, 1958   Oxford 1131                   Prints 13   Metropolitan Museum of Art, New York, NY 1
444636 2016.708.4 0 0 742598 Drawings and Prints 11 Book Ornament & Architecture 13815 The Elements of Civil Architecture, According to Vitruvius and other Ancients (...)           Author 41 Written and illustrated by Henry Aldrich British, Westminster 1648–1710 London   Aldrich, Henry 56587   1648 1710 1824 1824 1824 Letterpress and engravings 62177 9 1/4 × 5 7/8 × 1 in. (23.5 × 15 × 2.5 cm) Gift of Morrison Heckscher, 2016   Oxford 1131                   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 292.044ms · Data license: CC0 · Data source: metmuseum/openaccess