MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Alpha Sort = 14895

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, 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
166947 48.190 0 0 269216 Photographs 13 Cabinet card 13014 Sarah Bernhardt           Artist 2   Napoleon Sarony American (born Canada), Quebec 1821–1896 New York   Sarony, Napoleon 14895 American, born Canada 42 1821 1896 1880 1880 1880 Albumen silver print from glass negative 26061   Museum Accession, 1948                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
169213 69.659 0 0 271534 Photographs 13 Cabinet card 13014 Oscar Wilde           Artist 2   Napoleon Sarony American (born Canada), Quebec 1821–1896 New York   Sarony, Napoleon 14895 American, born Canada 42 1821 1896 ca. 1882 1880 1884 Albumen silver print from glass negative 26061 Image: 30 x 18 cm (11 13/16 x 7 1/16 in.) Mount: 32.8 x 19 cm (12 15/16 x 7 1/2 in.) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1969                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
179667 2005.100.120 0 1 283247 Photographs 13 Photograph 997 Oscar Wilde           Artist 2   Napoleon Sarony American (born Canada), Quebec 1821–1896 New York   Sarony, Napoleon 14895 American, born Canada 42 1821 1896 1882 1882 1882 Albumen silver print 26060 Image: 30.5 x 18.4 cm (12 x 7 1/4 in.) Gilman Collection, Purchase, Ann Tenenbaum and Thomas H. Lee Gift, 2005                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
182013 2005.100.828 0 1 285691 Photographs 13 Photograph 997 Oscar Wilde           Artist 2   Napoleon Sarony American (born Canada), Quebec 1821–1896 New York   Sarony, Napoleon 14895 American, born Canada 42 1821 1896 1882 1882 1882 Albumen silver print from glass negative 26061 Image: 12 in. × 7 1/4 in. (30.5 × 18.4 cm) Mount: 12 15/16 × 7 3/8 in. (32.8 × 18.8 cm) Gilman Collection, Purchase, Ann Tenenbaum and Thomas H. Lee Gift, 2005                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
182014 2005.100.778 0 1 285692 Photographs 13 Photograph 997 [Advertisement for Sarony's Photographic Studies]           Artist 2   Napoleon Sarony American (born Canada), Quebec 1821–1896 New York   Sarony, Napoleon 14895 American, born Canada 42 1821 1896 1880s 1880 1889 Albumen silver print from glass negative; lithograph 26400 7 3/4 x 9 5/16 Gilman Collection, Joyce F. Menschel Photography Library Fund, 2005                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
254598 1974.673.59 0 0 383222 Drawings and Prints 11 Print 731 Burning of the Old National Theatre, corner Leonard and Church Streets, the Church of Saint Esprit, Corner of Church and Franklin Streets, and the Dutch Reformed Church, on Franklin Street, New York, September 23, 1839           Artist 2   Napoleon Sarony American (born Canada), Quebec 1821–1896 New York   Sarony, Napoleon 14895 American, born Canada 42 1821 1896 1839 1839 1839 Lithograph 14948 image: 9 1/16 x 12 13/16 in. (23 x 32.5 cm) sheet: 12 11/16 x 18 in. (32.2 x 45.7 cm) Gift of Mary Knight Arnold, 1974                       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 115.332ms · Data license: CC0 · Data source: metmuseum/openaccess