MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Medium = 34623

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Prefix, 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
220059 32.83.4(9) 0 0 347587 Drawings and Prints 11 Book 97 Advertisement or prospectus for: The New Drawing Book: A Series of Practical Instructions in Landscape Painting in Water Colours           Artist 2 Written and illustrated by John Heaviside Clark British (born Scotland), 1771–1863 Edinburgh   Clark, John Heaviside 23022 British, Scottish 8 1771 1863 ca. 1827 1822 1832 Not illustrated 34623 11 3/4 x 9 1/2 in. (29.8 x 24.1 cm) Harris Brisbane Dick Fund, 1932                       Books 442   Metropolitan Museum of Art, New York, NY 1
220063 32.83.4(1-8) 0 0 347591 Drawings and Prints 11 Book 97 A Series of Practical Instructions in Landscape Painting in Water Colours           Publisher|Artist 740 Written and illustrated by Samuel Leigh|John Heaviside Clark London|British (born Scotland), 1771–1863 Edinburgh   Leigh, Samuel|Clark, John Heaviside 23023 British|British, Scottish 336 1800 |1771 1899 |1863 1827 1827 1827 Not illustrated 34623 7 3/4 x 10 3/8 in. (19.7 x 26.4 cm) Harris Brisbane Dick Fund, 1932   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
221156 24.90.1807 0 0 348698 Drawings and Prints 11 Book 97 Dictionary or Index to a Set of Cuts for Children           Publisher 16   Jacob Johnson Phildelphia, Pennsylvania   Johnson, Jacob 23758 American 1 1800 1850 1804 1804 1804 Not illustrated 34623 4 × 3 1/4 in. (10.2 × 8.3 cm) Bequest of Charles Allen Munn, 1924   Philadelphia 1                   Books 442   Metropolitan Museum of Art, New York, NY 1
226151 60.574.4 0 0 353757 Drawings and Prints 11 Book 97 A Treatise on the Art of Painting and the Composition of Colours, Containing Instructions for all the Various Processes of Painting, Together with Observations upon the Qualties and Ingredients of Colours           Author|Printer 1012   Constant de Massoul|T. Baylis French, active 1790s|British, London   Massoul, Constant de|Baylis, T. 27469 French 2 1790 |1750 1800 |1850 1797 1797 1797 Not illustrated 34623 7 × 4 3/4 × 13/16 in. (17.8 × 12.1 × 2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1960                       Books 442   Metropolitan Museum of Art, New York, NY 1
228094 60.574.2(1-3) 0 0 355722 Drawings and Prints 11 Book 97 Essays on the Picturesque..and on the Use of Studying Pictures for the Purpose of Improving Real Landscape           Author|Publisher 44   Sir Uvedale Price, 1st Baronet|J. Mawman London   Price, Uvedale, 1st Baronet|Mawman, J. 28813 British 7 1747 |1800 1829 |1850 1810 1810 1810 Not illustrated 34623 8 1/2 x 5 1/4 in. (21.6 x 13.3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1960                       Books 442   Metropolitan Museum of Art, New York, NY 1
240500 20.90.1 0 0 368616 Drawings and Prints 11 Book 97 An Essay of the Truth of Physiognomy, and its Application to Medicine           Publisher|Dedicatee|Dedicatee|Author 3971   Thomas T. Stiles|Bushrod Washington|Dr. Philip Thomas|Richard Brown Philadelphia, Pennsylvania|American, Westmoreland, Virginia 1762–1829|American, active 19th century|American, active early 19th century   Stiles, Thomas T.|Washington, Bushrod|Thomas, Philip Dr.|Brown, Richard 33376 American|American|American|American 97 1800 |1762 |1800 |1750 1900 |1829 |1900 |1850 1807 1807 1807 Not illustrated 34623 9 1/16 x 5 1/2 in. (23 x 14 cm) Gift of William E. Baillie, 1920                       Books 442   Metropolitan Museum of Art, New York, NY 1
254925 64.607 0 0 383553 Drawings and Prints 11 Book ; Ornament and architecture 13811 The Cabinet-Maker's Guide; or, Rules and Instructions in the art of varnishing, dying, staining, japanning, polishing, lackering, and beautifying Wood, Ivory, Tortoiseshell and Metal           Publisher|Publisher|Printer 1056   Knight and Lacey|Westley & Tyrrell|T. C. Hansard London|Dublin|London   Knight and Lacey|Westley & Tyrrell|Hansard, T. C. 36553 British|Irish|British 1381 1800 |1800 |1800 1900 |1900 |1900 1825 1825 1825 Not illustrated 34623 6 1/4 x 3 13/16 x 3/8 in. (15.8 x 9.7 x 1 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1964   Dublin|London 1454                   Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
275397 2012.128.3 0 1 404572 Drawings and Prints 11 Book 97 The Girl at Cobhurst           Artist|Publisher|Author 1021 Binding and decorations by Margaret Neilson Armstrong|Charles Scribner's Sons|Frank Richard Stockton American, New York 1867–1944 New York|New York, NY|American, 1834–1902   Armstrong, Margaret Neilson|Scribner's, Charles, Sons|Stockton, Frank Richard 40601 American|American|American 101 1867 |1800 |1834 1944 |1999 |1902 1898 1898 1898 Not illustrated 34623 7 7/16 x 5 1/16 x 1 1/4 in. (18.9 x 12.8 x 3.2 cm) Gift of Constance C. McPhee, 2012                       Books 442   Metropolitan Museum of Art, New York, NY 1
445272 69.633.114 0 0 744591 Drawings and Prints 11 Book 97 Regulations of the National Fire Board of Fire Underwriters for the Installation, Maintenance and Use of Gasoline Vapor Gas Lighting Machines, Lamps and Systems           Author 41 Recommended by the National Fire Protection Association American, early 20th century   National Fire Protection Association 56779   1900 1950 1919 1919 1919 Not illustrated 34623 5 3/16 × 3 7/16 in. (13.2 × 8.7 cm) Gift of Mrs. James S. Hedges, 1969                       Books 442   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 124.72ms · Data license: CC0 · Data source: metmuseum/openaccess