MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Nationality = 92 and Credit Line = "Purchase, 2012 NoRuz at The Met Benefit, 2014"

View and edit SQL

Suggested facets: Title, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object End Date, Medium, Geography Type, Country

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
320981 2014.430 0 0 458947 Islamic Art 9 Painting 69 Ahmad Shah - The Last King of Qajar           Artist 2   Ardeshir Mohassess Iranian, Rasht 1938–2008 New York   Mohassess, Ardeshir 44318 Iranian 92 1938 2008 1980s 1955 2005 Ink and watercolor on paper 174 H: 20 in (50.80 cm) x W: 18 in (45.70 cm) - sheet size Purchase, 2012 NoRuz at The Met Benefit, 2014 Country of Origin 23       United States 3             Paintings 11 © Estate of ardeshir Mohassess Metropolitan Museum of Art, New York, NY 1
382583 2014.45 0 0 631633 Islamic Art 9 Painting 69 Untitled           Artist 2   Sohrab Sepehri Iranian, Kashan 1928–1980 Kashan   Sepehri, Sohrab 49193 Iranian 92 1928 1980 1970–71 1945 1996 Watercolor on paper 177 H. 7 1/16 in. (18 cm.) W. 5 1/2 in. (14 cm.) Purchase, 2012 NoRuz at The Met Benefit, 2014 Country of Origin 23       Iran 59             Paintings 11 © Sohrab Sepehri Metropolitan Museum of Art, New York, NY 1
388986 2014.152 0 0 639544 Islamic Art 9 Painting 69 Untitled           Artist 2   Ardeshir Mohassess Iranian, Rasht 1938–2008 New York   Mohassess, Ardeshir 44318 Iranian 92 1938 2008 1996 1996 1996 Ink and watercolor on paper 174 H. 22 in (55.88 cm) W. 30 in (76.20 cm) Purchase, 2012 NoRuz at The Met Benefit, 2014 Country of Origin 23       United States 3             Paintings 11   Metropolitan Museum of Art, New York, NY 1
389387 2014.299.1, .2 0 0 640046 Islamic Art 9 Painting 69 Callilgraphic Drawing 1 and 2, Untitled           Artist 2   Faramarz Pilaram Iranian, Tehran 1937–1982 Tehran   Pilaram, Faramarz 49688 Iranian 92 1937 1982 1979 1954 2004 Ink and acrylic on paper 47664 H. 8 in. (20.32 cm) W. 8 in. (20.32 cm) Purchase, 2012 NoRuz at The Met Benefit, 2014                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
392885 2014.201 0 0 645148 Islamic Art 9 Painting 69 1907 (Palimpsest #9)           Artist 2   Kamrooz Aram born Shiraz, Iran, 1978   Aram, Kamrooz 50022 Iranian 92 1978 2078 2013 1998 2038 Oil, oil pastel, and wax pencil on canvas 58662 Unframed: H. 60 in. (152.4 cm) W. 54 in. (137.2 cm) D. 1 5/8 in. (4.1 cm) Purchase, 2012 NoRuz at The Met Benefit, 2014 Made in 1       United States 3             Paintings 11 © Kamrooz Aram Metropolitan Museum of Art, New York, NY 1
393992 2014.524a, b 0 0 646740 Islamic Art 9 Painting 69 Untitled, 2013           Artist 2   Golnaz Fathi Iranian, born Tehran, 1972   Fathi, Golnaz 50180 Iranian 92 1972 2072 2013 1988 2038 Acrylic, pen, and varnish on canvas 58688 [Two panels together] H. 39 3/8 in. (100 cm) W. 55 1/8 in. (140 cm) D. 1 1/8 in. (2.9 cm) Purchase, 2012 NoRuz at The Met Benefit, 2014 Country of Origin 23       Iran 59             Paintings 11   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 162.779ms · Data license: CC0 · Data source: metmuseum/openaccess