MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where "Artist End Date" is on date -4707-01-16 and City = 3

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

Artist End Date (date)

  • -4707-01-16 · 8
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
893 66.130a–e 0 1 970 American Decorative Arts 1 Brandy Warmer 126 Brandy Warmer American 1         Maker 1   Gerardus Boyce 1795/96–1880   Boyce, Gerardus 199   1795 1880 1840–57 1840 1857 Silver 2 Overall: 5 3/8 x 3 in. (13.7 x 7.6 cm); 16 oz. 5 dwt. (505.2 g) Base: Diam. 2 7/8 in. (2 7/8 in.) Purchase, Rogers Fund, 1966 Made in 1 New York 3     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
3128 46.148a, b 0 1 3346 American Decorative Arts 1 Dish Cross 359 Dish Cross American 1         Maker 1   Gerardus Boyce 1795/96–1880   Boyce, Gerardus 199   1795 1880 1820–40 1820 1840 Silver 2 Overall: 3 7/16 x 11 7/8 in. (8.7 x 30.2 cm); 16 oz. 18 dwt. (525.4 g) At feet: W. 11 15/16 in. (30.3 cm) Stand: 15 oz. 16 dwt. (490.9 g) Cover: 2 9/16 in. (6.5 cm); 1 oz. 2 dwt. (34.5 g) Burner: H. 2 1/16 in. (5.2 cm) Rogers Fund, 1946 Made in 1 New York 3     United States 3             Silver 2   Metropolitan Museum of Art, New York, NY 1
217874 24.66.118 0 0 345373 Drawings and Prints 11 Book 97 Catalogue of a Choice Collection of Fine Line Engravings, Ancient and Modern, Comprising a Great Variety, Including Many by the Old Masters, That are Very Scarce, and a Collection by Modern Englihs, French and German Artist, &c. to be sold at auction... Dec. 12th & 13th, 1865           Publisher 16   Bangs, Merwin & Co. New York, NY   Bangs, Merwin & Co. 21539 American 1 1860 1880 December 12–13, 1865 1865 1865 Letterpress, no illustrations 34144 8 9/16 × 5 1/2 in. (21.8 × 14 cm) Harris Brisbane Dick Fund, 1924   New York 3                   Books 442   Metropolitan Museum of Art, New York, NY 1
217878 24.66.120 0 0 345377 Drawings and Prints 11 Book 97 Catalogue of Lithographs, Etchings, Portraits, and Engravings by and after the Great Masters–Rembrandt, Bergham, Rubens, Titian, Vernet, Raphael, Claude Lorraine, Carache, Paul Veronese, De Vincie, Landseer &c., Also a Number of Rare Prints, Interesting to Collectors of America, to be sold at auction...Dec. 28, 1870           Publisher 16   Bangs, Merwin & Co. New York, NY   Bangs, Merwin & Co. 21539 American 1 1860 1880 December 31, 1870 1870 1870 Letterpress, no illustrations 34144 8 9/16 × 5 7/16 in. (21.8 × 13.8 cm) Harris Brisbane Dick Fund, 1924   New York 3                   Books 442   Metropolitan Museum of Art, New York, NY 1
217879 24.66.119 0 0 345378 Drawings and Prints 11 Book 97 Catalogue of a Large and Varied Collection of Engravings, Comprising Works after the Old Masters; Etchings by Rembrandt and others; Pencil and Water-Color Drawings; also a very large number of American and Foreign Portraits, to be sold at auction on...February 7th, 8th, and 9th, 1865           Publisher 16   Bangs, Merwin & Co. New York, NY   Bangs, Merwin & Co. 21539 American 1 1860 1880 February 7–9, 1866 1866 1866 Letterpress, no illustrations 34144 8 3/4 × 5 5/8 in. (22.2 × 14.3 cm) Harris Brisbane Dick Fund, 1924   New York 3                   Books 442   Metropolitan Museum of Art, New York, NY 1
218257 64.629.15 0 0 345760 Drawings and Prints 11 Book 97 Beauty and the Beast. Strong's New Nursery Tales           Engraver 137 Engraved and published by Thomas W. Strong New York   Strong, Thomas W. 21712 American 1 1850 1880 [1850–70] (?) 1850 1870 Illustrations: hand colored wood engravings 34220 7 13/16 x 6 1/8 x 1/16 in. (19.8 x 15.6 x 0.2 cm) Gift of Lincoln Kirstein, 1964   New York 3                   Books 442   Metropolitan Museum of Art, New York, NY 1
252630 54.90.1117 0 0 381133 Drawings and Prints 11 Print 731 Governor's Island, New York           Artist 2   George E. Leefe American, active New York, 1849–58   Leefe, George E. 35950 American 1 1820 1880 ca. 1850–59 1845 1864 Lithograph 14948 plate: 7 3/8 x 13 5/8 in. (18.7 x 34.6 cm) sheet: 12 1/8 x 17 3/16 in. (30.8 x 43.7 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954   New York 3                   Prints 13   Metropolitan Museum of Art, New York, NY 1
260214 53.607(8) 0 1 388932 Drawings and Prints 11 Print 731 The Jesuits' Lament           Lithographer 28   Francis Raab American (born Germany), ca. 1813, active New York, before 1854   Raab, Francis 37717 American 1 1813 1880 before 1854 1840 1854 Lithograph 14948 sheet: 13 9/16 x 9 7/16 in. (34.4 x 24 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1953   New York 3                   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 1266.23ms · Data license: CC0 · Data source: metmuseum/openaccess