MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

17 rows where Artist Alpha Sort = 19367

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, 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
211701 1986.1005.5 0 1 339092 Drawings and Prints 11 Print; Poster 13843 Tales of the Sunland           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1897 1897 1897 Commerical relief 31866 Sheet: 19 13/16 × 13 3/4 in. (50.4 × 35 cm) Image: 17 7/8 × 12 1/16 in. (45.4 × 30.6 cm) Purchase, The Lauder Foundation, Evelyn H. and Leonard A. Lauder Fund Gift, 1986                       Prints|Posters 666   Metropolitan Museum of Art, New York, NY 1
234563 1990.1100.9 0 0 362320 Drawings and Prints 11 Print 731 Overland Monthly: September           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1895 1895 1895 Lithograph 14948 Sheet: 14 1/2 × 10 3/8 in. (36.9 × 26.3 cm) Purchase, Leonard A. Lauder Gift, 1990                       Prints 13   Metropolitan Museum of Art, New York, NY 1
234564 1990.1100.10 0 0 362321 Drawings and Prints 11 Print 731 Overland Monthly: July           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1895 1895 1895 Lithograph 14948 Sheet: 22 in. × 15 9/16 in. (55.9 × 39.6 cm) Purchase, Leonard A. Lauder Gift, 1990                       Prints 13   Metropolitan Museum of Art, New York, NY 1
234585 1991.1236.5 0 1 362342 Drawings and Prints 11 Print 731 Overland Monthly: December           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1895 1895 1895 Commercial relief press 37122 Sheet: 14 in. × 12 1/8 in. (35.6 × 30.8 cm) Purchase, Leonard A. Lauder Gift, 1991                       Prints 13   Metropolitan Museum of Art, New York, NY 1
234586 1991.1236.6 0 0 362343 Drawings and Prints 11 Print 731 Overland Monthly for August           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 n.d. 1885 1946 Commercial relief press 37122 17-3/8 x 11 inches (44 x 28 cm) Purchase, Leonard A. Lauder Gift, 1991                       Prints 13   Metropolitan Museum of Art, New York, NY 1
234677 1995.491.73 0 0 362435 Drawings and Prints 11 Print 731 Overland Monthly: October           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1897 1897 1897 Lithograph 14948 Sheet: 14 in. × 10 1/2 in. (35.6 × 26.6 cm) Purchase, Leonard A. Lauder Gift, 1995                       Prints 13   Metropolitan Museum of Art, New York, NY 1
234678 1995.491.74 0 0 362436 Drawings and Prints 11 Print 731 Overland Monthly: May           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1895 1895 1895 Lithograph 14948 Sheet: 14 3/16 × 10 1/2 in. (36 × 26.6 cm) Purchase, Leonard A. Lauder Gift, 1995                       Prints 13   Metropolitan Museum of Art, New York, NY 1
234739 1988.1120.5 0 0 362497 Drawings and Prints 11 Print 731 Overland Monthly: August           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1895 1895 1895 Lithograph 14948 Sheet: 14 5/16 × 11 9/16 in. (36.3 × 29.3 cm) Image: 13 7/16 × 10 11/16 in. (34.2 × 27.1 cm) Purchase, Leonard A. Lauder Gift, 1988                       Prints 13   Metropolitan Museum of Art, New York, NY 1
234903 1989.1108.1 0 1 362661 Drawings and Prints 11 Print 731 Overland Monthly: July           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1895 1895 1895 Commercial relief press 37122 Sheet: 19 11/16 × 14 3/4 in. (50 × 37.5 cm) Image: 18 1/4 × 12 7/8 in. (46.3 × 32.7 cm) Purchase, Leonard A. Lauder Gift, 1989                       Prints 13   Metropolitan Museum of Art, New York, NY 1
234908 1990.1016.2 0 1 362667 Drawings and Prints 11 Print 731 Overland: January           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1896 1896 1896 Commercial relief process 31862 Sheet: 15 9/16 in. × 10 in. (39.5 × 25.4 cm) Image: 13 7/8 × 8 5/16 in. (35.3 × 21.1 cm) Purchase, Leonard A. Lauder Gift, 1990                       Prints 13   Metropolitan Museum of Art, New York, NY 1
234909 1990.1016.3 0 0 362668 Drawings and Prints 11 Print 731 Sunset Magazine: Standing Indian           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1902 1902 1902 Lithograph 14948 Sheet: 25 3/16 × 15 5/8 in. (64 × 39.7 cm) Image: 22 15/16 × 13 1/8 in. (58.2 × 33.4 cm) Purchase, Leonard A. Lauder Gift, 1990                       Prints 13   Metropolitan Museum of Art, New York, NY 1
234963 1995.264.5 0 0 362722 Drawings and Prints 11 Print 731 Overland Monthly: November           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1895 1895 1895 Lithograph 14948 Sheet: 13 1/2 × 9 3/4 in. (34.3 × 24.8 cm) Purchase, Leonard A. Lauder Gift, 1995                       Prints 13   Metropolitan Museum of Art, New York, NY 1
234966 1995.264.8 0 1 362725 Drawings and Prints 11 Print 731 Overland Monthly: August           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 ca. 1895 1890 1900 Lithograph 14948 Sheet: 14 1/2 × 11 9/16 in. (36.9 × 29.3 cm) Purchase, Leonard A. Lauder Gift, 1995                       Prints 13   Metropolitan Museum of Art, New York, NY 1
412875 2015.211 0 1 680844 Drawings and Prints 11 Print Poster 13847 Overland Monthly: Pélé , June           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1895 1895 1895 Lithograph 14948 Sheet: 15 × 11 in. (38.1 × 28 cm) Purchase, Leonard A. Lauder Gift, 2015                       Prints 13   Metropolitan Museum of Art, New York, NY 1
412876 2015.212 0 1 680845 Drawings and Prints 11 Print Poster 13847 Sunset Magazine: October           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1902 1902 1902 Lithograph 14948 Sheet: 23 × 19 in. (58.4 × 48.3 cm) Purchase, Leonard A. Lauder Gift, 2015                       Prints 13   Metropolitan Museum of Art, New York, NY 1
412877 2015.213 0 1 680846 Drawings and Prints 11 Print Poster 13847 Sunset Magazine: Thanksgiving Number, November           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1904 1904 1904 Lithograph 14948 Sheet: 26 × 17 in. (66 × 43.2 cm) Purchase, Leonard A. Lauder Gift, 2015                       Prints 13   Metropolitan Museum of Art, New York, NY 1
412878 2015.214 0 1 680847 Drawings and Prints 11 Print Poster 13847 Sunset Magazine: September           Artist 2   Lafayette Maynard Dixon American, 1875–1946   Dixon, Lafayette Maynard 19367 American 1 1875 1946 1904 1904 1904 Lithograph 14948 Sheet: 26 × 17 in. (66 × 43.2 cm) Purchase, Leonard A. Lauder Gift, 2015                       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 125.642ms · Data license: CC0 · Data source: metmuseum/openaccess