MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Prefix = "Imitator of" and Department = 15

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Artist Nationality, Object Begin Date, Credit Line, Classification

Department ✖

  • European Paintings · 5 ✖

Artist Prefix ✖

  • Imitator of · 5 ✖
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 Metadata Date Repository
306645 306645 62.122.109 0 1 436666 European Paintings 15 Painting, miniature 73 Portrait of a Man, Said to Be Arnold Franz           Artist 2 Imitator of Hans Holbein the Younger 17th or early 18th century   Holbein, Hans, the Younger 19243 German 10 1497 1543   1600 1729 Vellum laid on card 44503 Diameter 2 1/8 in. (53 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/436666 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307542 307542 41.191.2 0 1 437696 European Paintings 15 Painting, miniature 73 Portrait of an Officer           Artist 2 Imitator of John Smart 1784 or later?   Smart, John 30850 British 7 1741 1811   1784 1789 Ivory 148 Oval, 1 3/4 x 1 1/4 in. (45 x 32 mm) Gift of Mrs. Thomas Hunt, 1941                       Miniatures 771   http://www.metmuseum.org/art/collection/search/437696 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307696 307696 49.7.40 0 1 437882 European Paintings 15 Painting 69 A Young Woman Reading           Artist 2 Imitator of Johannes Vermeer ca. 1925–27   Vermeer, Johannes 43926 Dutch 11 1632 1675   1900 1924 Oil on canvas 953 7 3/4 x 5 3/4 in. (19.7 x 14.6 cm) The Jules Bache Collection, 1949                       Paintings 11   http://www.metmuseum.org/art/collection/search/437882 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307988 307988 2006.151.1 0 1 438844 European Paintings 15 Painting 69 Portrait of a Woman, Said to Be Caritas Pirckheimer (1467–1532)           Artist 2 Imitator of Albrecht Dürer 20th century   Dürer, Albrecht 9043 German 10 1471 1528   1900 1999 Oil on linen 44632 18 1/2 x 14 1/2 in. (47 x 36.8 cm) Gift of Julie and Lawrence Salander, 2006                       Paintings 11   http://www.metmuseum.org/art/collection/search/438844 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307989 307989 2006.151.2 0 0 438845 European Paintings 15 Painting 69 Portrait of a Man           Artist 2 Imitator of Netherlandish Painter early 20th century   Netherlandish Painter 43533 Netherlandish 179       1900 1929 Oil on wood 156 11 x 8 1/4 in. (27.9 x 21 cm) Gift of Julie and Lawrence Salander, 2006                       Paintings 11   http://www.metmuseum.org/art/collection/search/438845 4/23/2018 8:00:01 AM 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 437.488ms · Data license: CC0 · Data source: metmuseum/openaccess