MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Medium = 42724

View and edit SQL

Suggested facets: Is Public Domain, Artist Role, Artist Begin Date, Object Date, Object Begin Date, Object End Date, Credit Line

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
265976 60.683.24 0 0 394944 Drawings and Prints 11 Print 731 The Sword-Dance at a Pacha's           Artist|Publisher 710 After Jean-Léon Gérôme|George Barrie French, Vesoul 1824–1904 Paris|Philadelphia, Pennsylvania   Gérôme, Jean-Léon|Barrie, George 39080 French|American 153 1824 |1850 1904 |1925 1881 1881 1881 Photogravure on chine collé 42724 image: 6 x 9 5/8 in. (15.2 x 24.5 cm) plate: 7 7/8 x 10 15/16 in. (20 x 27.8 cm) sheet: 11 11/16 x 16 15/16 in. (29.7 x 43 cm) Gift of Mrs. Ellen Robinson, 1960                       Prints 13   Metropolitan Museum of Art, New York, NY 1
422571 2015.653.1 0 1 700927 Drawings and Prints 11 Print 731 Andromache in Captivity           Subject|Artist|Publisher 5345 After Homer|Frederic, Lord Leighton|George Barrie Greek, active 13th or 8th century BCE|British, Scarborough 1830–1896 London|Philadelphia, Pennsylvania   Homer|Leighton, Frederic, Lord|Barrie, George 53873   -1200 |1830 |1850 -0700 |1896 |1925 1889 1889 1889 Photogravure on chine collé 42724 Plate: 8 1/16 × 13 in. (20.5 × 33 cm) Sheet: 11 9/16 × 16 13/16 in. (29.3 × 42.7 cm) Gift of Donato Esposito, 2015                       Prints 13   Metropolitan Museum of Art, New York, NY 1
435843 60.683.75 0 1 725783 Drawings and Prints 11 Print 731 Haddon Hall with elegantly dressed figures in the foreground           Publisher|Artist 740 After George Barrie|Ignacio de León y Escosura Philadelphia, Pennsylvania|Spanish, Oviedo 1834–1901 Toledo   Barrie, George|León y Escosura, Ignacio de 55437   1850 |1834 1925 |1901 1881 1881 1881 Photogravure on chine collé 42724 Sheet: 8 9/16 × 10 5/8 in. (21.7 × 27 cm) Gift of Mrs. Ellen Robinson, 1960                       Prints 13   Metropolitan Museum of Art, New York, NY 1
435845 60.683.77 0 1 725785 Drawings and Prints 11 Print 731 Figures inside a Spanish inn           Publisher|Artist 740 After George Barrie|Francisco Domingo y Marqués Philadelphia, Pennsylvania|Spanish, Valencia 1842–1920 Madrid   Barrie, George|Domingo y Marqués, Francisco 55438   1850 |1842 1925 |1920 1881 1881 1881 Photogravure on chine collé 42724 Sheet: 7 3/16 × 8 7/8 in. (18.2 × 22.5 cm) Gift of Mrs. Ellen Robinson, 1960                       Prints 13   Metropolitan Museum of Art, New York, NY 1
436225 60.683.74 0 0 726203 Drawings and Prints 11 Print 731 A young woman on a couch convalescing while another reads to her           Artist|Publisher 710 After Vicente Palmaroli González|George Barrie Spanish, 1834–1896|Philadelphia, Pennsylvania   Palmaroli González, Vicente|Barrie, George 55464   1834 |1850 1896 |1925 1881 1881 1881 Photogravure on chine collé 42724 Sheet: 9 1/16 × 9 15/16 in. (23 × 25.2 cm) Gift of Mrs. Ellen Robinson, 1960                       Prints 13   Metropolitan Museum of Art, New York, NY 1
436226 60.683.73 0 0 726204 Drawings and Prints 11 Print 731 A young woman on a couch, a musician playing a guitar at left, a prelate seated at right           Publisher|Artist 740 After George Barrie|Vicente Palmaroli González Philadelphia, Pennsylvania|Spanish, 1834–1896   Barrie, George|Palmaroli González, Vicente 55465   1850 |1834 1925 |1896 1881 1881 1881 Photogravure on chine collé 42724 Sheet: 8 11/16 × 9 7/16 in. (22 × 24 cm) Gift of Mrs. Ellen Robinson, 1960                       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 140.545ms · Data license: CC0 · Data source: metmuseum/openaccess