MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

13 rows where Artist Nationality = 1 and Artist Role = 68

View and edit SQL

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
14913 54.90.1044 0 0 16174 American Paintings and Sculpture 2 Print 731 Broadway from Warren to Reade Street           Printer|Publisher 68   Dumcke and Keil|Stephenson and Co. American, New York   Dumcke and Keil|Stephenson and Co. 2348 American 1     1855 1855 1855 Lithograph printed in colors 2535 21 1/4 x 33 1/2 in. (54.0 x 85.1 cm) The Edward W. C. Arnold Collection of New York Prints, Maps, and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
227276 32.124.1 0 0 354893 Drawings and Prints 11 Book 97 Orr's Book of Swimming: As Practised And Taught in Civilized and Savage Nations           Printer|Publisher 68 Published and engraved by Robert, Hovey & King|J. W. & N. Orr New York, NY|New York   Robert, Hovey & King|Orr, J. W. & N. 28218 American 1 1800 |1815 1900 |1887 1846 1846 1846 Illustrations: wood engraving 28946 6 1/8 x 3 15/16 in. (15.5 x 10 cm) Max G. Wildnauer Fund, 1932                       Books 442   Metropolitan Museum of Art, New York, NY 1
252593 54.90.1076 0 0 381096 Drawings and Prints 11 Print 731 Central Park, New York, Winter Sports           Printer|Publisher 68   George Schlegel, New York|Henry Schile active 1849–1957|American, born Germany, active 1870–80   Schlegel, George|Schile, Henry 35927 American 1 1849 |1870 1957 |1880 1874 1874 1874 Hand-colored lithograph 3394 image: 18 x 24 1/2 in. (45.7 x 62.2 cm) sheet: 23 3/4 x 29 3/4 in. (60.3 x 75.6 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
252594 54.90.1077 0 0 381097 Drawings and Prints 11 Print 731 Central Park, New York, Preparing for a Drive           Printer|Publisher 68   George Schlegel, New York|Henry Schile active 1849–1957|American, born Germany, active 1870–80   Schlegel, George|Schile, Henry 35927 American 1 1849 |1870 1957 |1880 1874 1874 1874 Hand-colored lithograph 3394 image: 18 x 24 3/8 in. (45.7 x 61.9 cm) sheet: 22 1/4 x 28 in. (56.5 x 71.1 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
267832 1972.535.84 0 0 396875 Drawings and Prints 11 Poster 5842 Remember Your First Thrill of American Liberty, Your Duty-Buy United States Government Bonds, 2nd Liberty Loan of 1917           Printer|Publisher 68   Sackett & Wilhelms Corp.|Division of Pictorial Publicity, United States Government New York, NY   Sackett & Wilhelms Corp.|Division of Pictorial Publicity, United States Government 39557 American 1 1900 1950 1917 1917 1917 Lithograph 14948 sheet: 30 x 20 1/16 in. (76.2 x 51 cm) Gift of William C. Moore, 1972                       Posters 677   Metropolitan Museum of Art, New York, NY 1
413737 Burdick 435, PC225-1.7 0 0 682830 Drawings and Prints 11 Print 731 Travel Building, from the Chicago World's Fair series (PC225-1)           Printer|Publisher 68   C.T. Art-Colortone, Curt Teich|Max Rigot Selling Company     C.T. Art-Colortone|Max Rigot Selling Company 52164 American 1     1933 1933 1933 Commercial color lithograph 30785 Sheet: 3 9/16 × 5 1/2 in. (9 × 14 cm) The Jefferson R. Burdick Collection, Gift of Jefferson R. Burdick                       Prints|Ephemera 676   Metropolitan Museum of Art, New York, NY 1
413779 Burdick 435, PC225-1.33 0 0 682874 Drawings and Prints 11 Print 731 Hall of Science by Night, from the Chicago World's Fair series (PC225-1)           Printer|Publisher 68   C.T. Art-Colortone, Curt Teich|Max Rigot Selling Company     C.T. Art-Colortone|Max Rigot Selling Company 52164 American 1     1933 1933 1933 Commercial color lithograph 30785 Sheet: 3 9/16 × 5 1/2 in. (9 × 14 cm) The Jefferson R. Burdick Collection, Gift of Jefferson R. Burdick                       Prints|Ephemera 676   Metropolitan Museum of Art, New York, NY 1
413781 Burdick 435, PC225-1.34 0 0 682876 Drawings and Prints 11 Print 731 Hall of Science, from the Chicago World's Fair series (PC225-1)           Printer|Publisher 68   C.T. Art-Colortone, Curt Teich|Max Rigot Selling Company     C.T. Art-Colortone|Max Rigot Selling Company 52164 American 1     1933 1933 1933 Commercial color lithograph 30785 Sheet: 3 9/16 × 5 1/2 in. (9 × 14 cm) The Jefferson R. Burdick Collection, Gift of Jefferson R. Burdick                       Prints|Ephemera 676   Metropolitan Museum of Art, New York, NY 1
413782 Burdick 435, PC225-1.35 0 0 682877 Drawings and Prints 11 Print 731 Section of Belgian Village, from the Chicago World's Fair series (PC225-1)           Printer|Publisher 68   C.T. Art-Colortone, Curt Teich|Max Rigot Selling Company     C.T. Art-Colortone|Max Rigot Selling Company 52164 American 1     1933 1933 1933 Commercial color lithograph 30785 Sheet: 3 9/16 × 5 1/2 in. (9 × 14 cm) The Jefferson R. Burdick Collection, Gift of Jefferson R. Burdick                       Prints|Ephemera 676   Metropolitan Museum of Art, New York, NY 1
413783 Burdick 435, PC225-1.36 0 0 682878 Drawings and Prints 11 Print 731 Rocket Cars Crossing Lagoon, from the Chicago World's Fair series (PC225-1)           Printer|Publisher 68   C.T. Art-Colortone, Curt Teich|Max Rigot Selling Company     C.T. Art-Colortone|Max Rigot Selling Company 52164 American 1     1933 1933 1933 Commercial color lithograph 30785 Sheet: 3 9/16 × 5 1/2 in. (9 × 14 cm) The Jefferson R. Burdick Collection, Gift of Jefferson R. Burdick                       Prints|Ephemera 676   Metropolitan Museum of Art, New York, NY 1
413784 Burdick 435, PC225-1.37 0 0 682879 Drawings and Prints 11 Print 731 Fireworks Display over Lagoon, from the Chicago World's Fair series (PC225-1)           Printer|Publisher 68   C.T. Art-Colortone, Curt Teich|Max Rigot Selling Company     C.T. Art-Colortone|Max Rigot Selling Company 52164 American 1     1933 1933 1933 Commercial color lithograph 30785 Sheet: 3 9/16 × 5 1/2 in. (9 × 14 cm) The Jefferson R. Burdick Collection, Gift of Jefferson R. Burdick                       Prints|Ephemera 676   Metropolitan Museum of Art, New York, NY 1
413786 Burdick 435, PC225-1.38 0 0 682881 Drawings and Prints 11 Print 731 Admiral Byrd's Polar Ship, "The City of New York", from the Chicago World's Fair series (PC225-1)           Printer|Publisher 68   C.T. Art-Colortone, Curt Teich|Max Rigot Selling Company     C.T. Art-Colortone|Max Rigot Selling Company 52164 American 1     1933 1933 1933 Commercial color lithograph 30785 Sheet: 3 9/16 × 5 1/2 in. (9 × 14 cm) The Jefferson R. Burdick Collection, Gift of Jefferson R. Burdick                       Prints|Ephemera 676   Metropolitan Museum of Art, New York, NY 1
413789 Burdick 435, PC225-1.40 0 0 682884 Drawings and Prints 11 Print 731 Streets of Paris, from the Chicago World's Fair series (PC225-1)           Printer|Publisher 68   C.T. Art-Colortone, Curt Teich|Max Rigot Selling Company     C.T. Art-Colortone|Max Rigot Selling Company 52164 American 1     1933 1933 1933 Commercial color lithograph 30785 Sheet: 3 9/16 × 5 1/2 in. (9 × 14 cm) The Jefferson R. Burdick Collection, Gift of Jefferson R. Burdick                       Prints|Ephemera 676   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 6556.152ms · Data license: CC0 · Data source: metmuseum/openaccess