MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Object Name = 13017

View and edit SQL

Suggested facets: Is Public Domain, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium

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
159783 1976.617 0 0 261918 Photographs 13 Waxed paper negative 13017 [Tree Study]           Artist 2   Benjamin Brecknell Turner British, 1815–1894   Turner, Benjamin Brecknell 13744 British 7 1815 1894 ca. 1855 1853 1857 Waxed paper negative 26108 26.5 x 21.2 cm. (10 7/16 x 8 3/6 in.) Gift of Professor Giles Robertson, 1976                       Negatives 451   Metropolitan Museum of Art, New York, NY 1
163837 1988.1134.1 0 1 266025 Photographs 13 Waxed paper negative 13017 The Diwan-i Khas from the Mussaman Burj, Agra Palace           Artist 2   John Murray British, Blackhouse, Aberdeenshire, Scotland 1809–1898 Sheringham, Norfolk county, England   Murray, John 14067 British, Scottish 8 1809 1898 1862–64 1862 1864 Waxed paper negative with applied media 26168 37.1 x 46.4cm (14 5/8 x 18 1/4in.) Frame: 68.7 x 122.6 cm (27 1/16 x 48 1/4 in.) (Framed with 1988.1134.2) Purchase, Cynthia Hazen Polsky Gift, 1988                       Negatives 451   Metropolitan Museum of Art, New York, NY 1
163887 1989.1008 0 0 266075 Photographs 13 Waxed paper negative 13017 The Jewels of the Pagoda           Artist 2   Linnaeus Tripe British, Devonport (Plymouth Dock) 1822–1902 Devonport   Tripe, Linnaeus 14446 British 7 1822 1902 January 1858 1858 1858 Waxed paper negative 26108 33.1 x 39.1 cm (13 1/16 x 15 3/8 in.) Gift of Charles Isaacs Photographs, 1989                       Negatives 451   Metropolitan Museum of Art, New York, NY 1
178497 1997.382.57 0 1 282068 Photographs 13 Waxed paper negative 13017 Taj Mahal and Gardens           Artist 2   John Murray British, Blackhouse, Aberdeenshire, Scotland 1809–1898 Sheringham, Norfolk county, England   Murray, John 14067 British, Scottish 8 1809 1898 ca. 1855 1853 1857 Waxed paper negative 26108 38.5 x 47.2 cm (15 3/16 x 18 9/16 in.) The Rubel Collection, Purchase, Anonymous Gift and Cynthia Hazen Polsky Gift, 1997                       Negatives 451   Metropolitan Museum of Art, New York, NY 1
178498 1997.382.58 0 0 282069 Photographs 13 Waxed paper negative 13017 Taj Mahal           Artist 2   John Murray British, Blackhouse, Aberdeenshire, Scotland 1809–1898 Sheringham, Norfolk county, England   Murray, John 14067 British, Scottish 8 1809 1898 ca. 1855 1853 1857 Waxed paper negative 26108 39.3 x 46.5 cm (15 1/2 x 18 5/16 in.) The Rubel Collection, Purchase, Ann Tenenbaum and Thomas H. Lee and Lila Acheson Wallace Gifts, 1997                       Negatives 451   Metropolitan Museum of Art, New York, NY 1
180140 2000.235 0 1 283727 Photographs 13 Waxed paper negative 13017 Jacques-Joseph Ebelman on his Deathbed           Artist 2   Louis-Rémy Robert French, 1810–1882   Robert, Louis-Rémy 14280 French 2 1810 1882 March 31, 1852 1852 1852 Waxed paper negative 26108 19 x 24.5 cm (7 1/2 x 9 5/8 in.) Purchase, The Hite Foundation Gift, 2000                       Negatives 451   Metropolitan Museum of Art, New York, NY 1
382124 2013.1098.2 0 1 631026 Photographs 13 Waxed paper negative 13017 [Street with Lamp Post and Wine Shop]           Artist 2   Unknown British   Unknown 1237       1850s 1850 1859 Waxed paper negative 26108 Image: 6 15/16 × 8 3/4 in. (17.7 × 22.3 cm), irregularly trimmed Gift of Joyce F. Menschel, 2013                       Negatives 451   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 118.166ms · Data license: CC0 · Data source: metmuseum/openaccess