MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where "Artist End Date" is on date -4707-02-25 and City = 3

View and edit SQL

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

Artist End Date (date)

  • -4707-02-25 · 9
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
2770 68.132 0 1 2974 American Decorative Arts 1 Curio cabinet 329 Curio Cabinet American 1         Maker 1   George C. Flint and Company active ca. 1868–1920   Flint and Company George C. 452   1865 1920 ca. 1910 1907 1910 Mahogany, glass 628 58 3/4 x 36 x 16 in. (149.2 x 91.4 x 40.6 cm) Purchase, Anonymous Gift, 1968 Made in 1 New York 3     United States 3             Furniture 4   Metropolitan Museum of Art, New York, NY 1
217368 54.509.27 0 0 344860 Drawings and Prints 11 Book 97 Holiday Catalogue 1883 Electrotype Cuts           Author 41   American Pictorial Co. New York, NY   American Pictorial Co. 21133 American 1 1850 1920 October 1883 1883 1883 Illustrations: photomechanical process 33879 11 13/16 x 9 7/16 in. (30 x 24 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1954   New York 3                   Books 442   Metropolitan Museum of Art, New York, NY 1
218123 54.638.1 0 0 345624 Drawings and Prints 11 Book 97 Crockery, China, Glassware, and Kerosene Goods           Author 41   George F. Bassett & Co. New York, NY   Bassett, George F., & Co. 21648 American 1 1880 1920 late 19th century 1870 1900 Illustrations: wood engraving 28946 9 1/4 x 11 13/16 in. (23.5 x 30 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1954   New York 3                   Books 442   Metropolitan Museum of Art, New York, NY 1
219247 41.134 0 1 346765 Drawings and Prints 11 Book 97 An Abridged Specimen of Printing Types           Author 41   George Bruce's Son & Co. New York, NY   Bruce's, George, Son & Co. 22413 American 1 1820 1920 1869 1869 1869     Harris Brisbane Dick Fund, 1941   New York 3                   Books 442   Metropolitan Museum of Art, New York, NY 1
219344 58.595.2 0 0 346864 Drawings and Prints 11 Book 97 Descriptive Catalogue of Children's Carriages, Handsleds, Toy Carriages, Carts, etc. . .Hoes, Rakes, and etc.           Author 41   George H. Burke New York, NY   Burke, George H. 22500 American 1 1820 1920 1871 1871 1871     Max G. Wildnauer Fund, 1958   New York 3                   Books 442   Metropolitan Museum of Art, New York, NY 1
222003 1970.565.188 0 0 349563 Drawings and Prints 11 Book 97 Typographic Specimens; Illustrated catalogue           Author 41   A. D. Farmer & Son Type Founding Co. New York, NY   Farmer, A. D. & Son Type Founding Co. 24324 American 1 1880 1920 September 1900 1900 1900     Gift of Lincoln Kirstein, 1970   New York 3                   Books 442   Metropolitan Museum of Art, New York, NY 1
222719 56.516.39 0 0 350281 Drawings and Prints 11 Book 97 Perforated Veneer Seats, Chairs, Settees, etc.           Author 41   Gardner and Co. New York, NY   Gardner and Co. 24884 American 1 1850 1920 ca. 1880 1875 1885 Illustrations: wood engraving 28946 7 1/16 x 3 9/16 in. (18 x 9 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956   New York 3                   Books 442   Metropolitan Museum of Art, New York, NY 1
223042 61.618.1 0 0 350612 Drawings and Prints 11 Book 97 Catalogue of Glassware for Illuminating Purposes. . .           Author 41   E. P. Gleason Manufacturing Co. New York, NY   Gleason, E. P. Manufacturing Co. 25151 American 1 1850 1920 September 1892 1892 1892     The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1961   New York 3                   Books 442   Metropolitan Museum of Art, New York, NY 1
444651 2016.708.12 0 0 742614 Drawings and Prints 11 Book Ornament & Architecture 13815 Hope's Casement and Leaded Glass           Artist 2   Henry Hope & Sons, Ltd. American, active New York early 20th century   Hope, Henry & Sons, Ltd. 56600   1900 1920 1919 1919 1919 Photography and lithography 62181 18 7/16 × 12 3/16 × 1/2 in. (46.8 × 31 × 1.2 cm) Gift of Morrison Heckscher, 2016   New York 3                   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 1031.604ms · Data license: CC0 · Data source: metmuseum/openaccess