MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Role = 1912

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Prefix, Artist Nationality, Credit Line, City, 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
218982 38.94.1 0 1 346493 Drawings and Prints 11 Book ; Ornament and architecture 13811 Book of Designs [for Ironwork]           Designer|Designer|Publisher 1912   J. Bottomley|J. & W. Welldon|Henry Webley British, active late 18th century|British, active 18th century|British, active London 1760s   Bottomley, J.|Welldon, J. & W.|Webley, Henry 22202 British|British|British 178 1750 |1730 |1760 1800 |1800 |1770 1765 and 1793 1765 1793 Illustrations: etching 28943 10 11/16 x 7 15/16 x 1 7/16 in. (27.2 x 20.1 x 3.6 cm) Harris Brisbane Dick Fund, 1938   London 14                   Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
219622 37.90.1 0 0 347142 Drawings and Prints 11 Book ; Ornament and architecture 13811 The Carpenters Companion, for Chinese Railing and Gates           Designer|Designer|Publisher 1912 Designed and engraved by|Designed and engraved by|Published by John Crunden|J. H. Morris|Isaac Taylor, I active London 1765–77|British, 18th century|British, Worcester 1730–1807 Edmonton, Greater London   Crunden, John|Morris, J. H.|Taylor, Isaac I 22688 British|British 9 1765 |1700 |1730 1777 |1800 |1807 18th century 1700 1800 Illustrations: engraving 28942 8 7/8 x 5 13/16 x 3/8 in. (22.6 x 14.7 x 1 cm) Harris Brisbane Dick Fund, 1937   London 14                   Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
223462 1970.565.153 0 0 351040 Drawings and Prints 11 Book 97 Architecture Suisse, ou choix des maisons rustiques des Alpes du Canton de Berne           Designer|Designer|Publisher 1912 Designed by|Designed by|Published by Adolf von Graffenried|Gabriel Ludwig Rudolf von Stürler|J. J. Burgdorfer Swiss|Swiss   Graffenried, Adolf von|Stürler, Gabriel Ludwig Rudolf von|Burgdorfer, J. J. 25481 Swiss|Swiss|Swiss 217     1844 1844 1844     Gift of Lincoln Kirstein                       Books 442   Metropolitan Museum of Art, New York, NY 1
227080 1970.565.116 0 0 354695 Drawings and Prints 11 Book 97 New York Plaisance, number one: An Illustrated Series of New York Places of Amusement: New Amsterdam Theatre...Murray's Restaurant...           Designer|Designer|Publisher 1912   Henry Erkins|Herts and Tallant|Rogers & Company American, active early 20th century|American, active early 20th century|Chicago and New York   Erkins, Henry|Herts and Tallant|Rogers & Company 28058 American|American|American 101 1850 |1850 |1850 1950 |1950 |1950 1908 1908 1908   12 3/4 x 9 1/4 in. (32.4 x 23.5 cm) Gift of Lincoln Kirstein, 1970                       Books 442   Metropolitan Museum of Art, New York, NY 1
227153 66.576.9 0 0 354768 Drawings and Prints 11 Book 97 Epoque Louis XVI. Décorations intérieures, frises, dessus de portes, panneaux, devant de cheminées, etc.           Designer|Designer|Publisher 1912 Designed by|Designed by|Published by Charles Pierre Joseph Normand|François Marie Isidore Queverdo|Bance l'ainé French, Goyencourt 1765–1840 Paris|French, Josselin 1748–1797 Paris , Paris Normand, Charles Pierre Joseph|Queverdo, François Marie Isidore|Bance l'ainé 28117 French|French|French 103 1765 |1748 1840 |1797 n.d. 1780 1965 Engraving 7208 Overall: 10 9/16 x 8 1/4 x 3/8 in. (26.9 x 21 x 1 cm) Gift of Lincoln Kirstein, 1966   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
231297 1970.565.56bis 0 0 359029 Drawings and Prints 11 Book ; ornament and architecture 13813 Suggestions in Design. Being a Comprehensive Series of Original Sketches in Various Styles of Ornament           Designer|Designer|Publisher 1912 Descriptive and historical letterpress by John Leighton|James K. Colling|Blackie & Son, Ltd. British, 1822–1912 Middlesex|British, 19th century|British, Bishopbriggs, Scotland, 1890–1991 London Leighton, John|Colling, James K.|Blackie & Son, Ltd. 30808 British|British|British 178 1822 |1800 |1890 1912 |1900 |1991 1880 1880 1880 Illustrations: lithography and wood engraving 29202 12 1/2 x 10 3/8 x 1 7/8 in. (31.7 x 26.4 x 4.7 cm) Gift of Lincoln Kirstein, 1970                       Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
268651 Ref.1960.3022 0 0 397715 Drawings and Prints 11 Book Ornament & Architecture 13815 A Book of Mantels           Designer|Designer|Publisher 1912   Robert Adam|James Adam|Architectural Book Publishing Company Inc. British, Kirkcaldy, Scotland 1728–1792 London|British, Edinburgh, Scotland 1732–1794 London|New York, NY   Adam, Robert|Adam, James|Architectural Book Publishing Company Inc. 39732 British, Scottish|British, Scottish|American 3085 1728 |1732 |1900 1792 |1794 |1999 1915 1915 1915 Illustrations: colored lithography  43023 14 x 11 13/16 x 1/2 in. (35.5 x 30 x 1.3 cm) Museum Accession, The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1960                       Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
277840 1991.1073.179 0 0 407023 Drawings and Prints 11 Book 97 Some Designs of Mr. Inigo Jones and Mr. Wm. Kent           Designer|Designer|Publisher 1912 Drawn, engraved, and published by Inigo Jones|William Kent|John Vardy British, London 1573–1652 London|British, Bridlington, Yorkshire ca. 1685–1748 London|British, Durham baptised 1718–1765 London   Jones, Inigo|Kent, William|Vardy, John 40764 British|British|British 178 1573 |1684 |1718 1652 |1748 |1765 1744 1744 1744 Illustrations: etching, engraving 34430 17 1/16 x 11 3/16 x 7/8 in. (43.4 x 28.4 x 2.3 cm) Rogers Fund, 1991                       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 167.383ms · Data license: CC0 · Data source: metmuseum/openaccess