MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

1 row where Portfolio = 200

✎ View and edit SQL

This data as json, CSV (advanced)

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
211420 211420 1979.62.1(1–66) 0 1 338810 Drawings and Prints 11 Collection Ornament & Architecture 13829 Album Containing Architectural, Ornament, and Figure Drawings.         folio 2, folio 7, folio 9, folio14, folio 16, folio 22 verso, folio 27, folio 31, folio 32, folio 36, folio 42, folio 45, folio 46, folio 47, folio 49, and folio 50 200 Artist|Artist 13   Pier Francesco Mola|Giovanni Battista Mola Italian, Coldrerio 1612–1666 Rome|Italian, Coldrerio 1585–1665 Rome   Mola, Pier Francesco|Mola, Giovanni Battista 19254 Italian|Italian 93 1612 |1585 1666 |1665 1630–31 1630 1631 folio 1 - Pen and brown ink, brush and brown and blue wash. folio 2 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 3 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 4 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 5 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 6 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 7 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 8 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 9 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 10 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 10v - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 11 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 12 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 13 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 14 - Pen and brown ink, brush and pale brown wash, over black chalk construction lines and traces of black chalk. folio 15 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 16 - Pen and brown ink, over traces of black chalk (the doorway); black chalk (the figures on the pediment). folio 17 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 18 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 19 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 20 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 21 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 22 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 22v - Red chalk. folio 23 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 24 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 25 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 26 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 27 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 28 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 29 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 29v - Construction lines in black chalk. folio 30 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 31 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 32 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 33 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 33v - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 34 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 35 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 36 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 37 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 38 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 39 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. Abrasion of drawing surface. folio 40 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 41 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 42 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 43 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 44 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 45 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 45v - Graphite. folio 46 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. Some offsetting and stray marks in red chalk and graphite. folio 47 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 48 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 49 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 50 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 51 - Pen and black and brown ink, brush and brown wash, over graphite or black chalk and red chalk underdrawing. folio 52 - Pen and black and brown ink, brush and pink, blue, brown, ochre and light green wash over graphite or black chalk construction lines. folio 52v - Pen and brown ink and graphite. folio 53 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 54 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 55 - Pen and brown ink. folio 56v - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 57 - Pen and brown ink over graphite construction lines, yellow and pink wash. folio 58 - Pen and brown ink over stylus-incised construction lines. folio 58v - Pen and brown ink over stylus-incised construction lines. folio 59 - Pen and brown ink, brush and brown wash over stylus-incised construction lines with traces of red chalk. folio 60 - Pen and brown ink over stylus-incised construction lines. folio 60v - Pen and brown ink over stylus-incised construction lines. folio 61 - Pen and brown ink over stylus-incised construction lines. folio 61v - Pen and brown ink over stylus-incised construction lines. folio 62 - Pen and brown ink, brush and brown wash, over black chalk construction lines and traces of black chalk. folio 63 - Pen and brown ink over stylus-incised construction lines. folio 63v - Pen and brown ink over stylus-incised construction lines. folio 64 - Pen and brown ink and graphite. folio 65 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 65v - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 66 - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite. folio 66v - Pen and brown ink over black chalk construction lines and traces of black chalk or graphite 31728 overall: 7 15/16 x 7 11/16 in. (20.1 x 19.5 cm) folio 2 -- 7-15/16 x 5-3/8 in. (20.1 x 13.7 cm) folio 7 -- 8 x 4-15/16 in. (20.3 x 12.5 cm) folio 9 -- 7-9/16 x 5-1/8 in. (19.2 x 13.0 cm) folio 14 -- 7-3/4 x 5-11/16 in. (19.7 x 14.4 cm) folio 16 -- 7 x 4-13/16 in. (17.8 x 12.3 cm) folio 22v -- 7-5/8 x 5-7/16 in. (19.3 x 13.8 cm) folio 27 -- 7-3/16 x 5-1/2 in. (18.2 x 14.0 cm) folio 31 -- 7-1/2 x 5-1/4 in. (19.0 x 13.4 cm) folio 32 -- 7-5/16 x 4-15/16 in. (18.5 x 12.5 cm) folio 36 -- 7-5/16 x 4-13/16 in. (18.5 x 12.3 cm) folio 42 -- 10-11/16 x 7-5/16 in. (27.1 x 18.5 cm) folio 45 -- 11-1/8 x 8-1/16 in. (28.3 x 20.4 cm) folio 46 -- 7-3/4 x 4-11/16 in. (19.7 x 11.9 cm) folio 47 -- 8-7/16 x 5-1/2 in. (21.4 x 14.0 cm) folio 49 -- 6-3/4 x 7-1/2 in. (17.1 x 19.0 cm) folio 50 --7-15/16 x 7-11/16 in. (20.1 x 19.5 cm) Harry G. Sperling Fund, 1978                       Albums|Ornament & Architecture 680   http://www.metmuseum.org/art/collection/search/338810 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 158.118ms · Data license: CC0 · Data source: metmuseum/openaccess