MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Portfolio = 2169

View and edit SQL

Suggested facets: Dimensions

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
301424 33.84(1.202) 0 0 431203 Drawings and Prints 11 Print collection ornament & architecture 13848 Title Page depicting figures in Roman dress with a bed at the back of a vaulted room, from Livre de lits à la romaine, plate 1, bound in Oeuvres. Vol. I         Livre de lits à la romaine 2169 Artist 2   Jean Le Pautre French, Paris 1618–1682 Paris   Le Pautre, Jean 10804 French 2 1618 1682 17th century 1633 1682 Etching; second state of three (Préaud) 44263 Sheet: 13 9/16 × 8 1/4 in. (34.5 × 21 cm) Plate: 8 7/8 × 6 in. (22.5 × 15.2 cm) Harris Brisbane Dick Fund, 1933   Paris 27                   Prints|Ornament & Architecture 673   Metropolitan Museum of Art, New York, NY 1
301425 33.84(1.203) 0 0 431204 Drawings and Prints 11 Print collection ornament & architecture 13848 Bed with Venus seated on a shell on the headboard, from Livre de lits à la romaine, plate 6, bound in Oeuvres. Vol. I         Livre de lits à la romaine 2169 Artist 2   Jean Le Pautre French, Paris 1618–1682 Paris   Le Pautre, Jean 10804 French 2 1618 1682 17th century 1633 1682 Etching; second state of three (Préaud) 44263 Sheet: 13 9/16 × 8 1/4 in. (34.5 × 21 cm) Plate: 8 7/8 × 6 in. (22.5 × 15.2 cm) Harris Brisbane Dick Fund, 1933   Paris 27                   Prints|Ornament & Architecture 673   Metropolitan Museum of Art, New York, NY 1
301428 33.84(1.204) 0 0 431207 Drawings and Prints 11 Print collection ornament & architecture 13848 Bed with a statue of Minerva flanked by putti on the headboard, from Livre de lits à la romaine, plate 3, bound in Oeuvres. Vol. I         Livre de lits à la romaine 2169 Artist 2   Jean Le Pautre French, Paris 1618–1682 Paris   Le Pautre, Jean 10804 French 2 1618 1682 17th century 1633 1682 Etching; second state of three (Préaud) 44263 Sheet: 13 9/16 × 8 1/4 in. (34.5 × 21 cm) Plate: 8 7/8 × 6 in. (22.5 × 15.3 cm) Harris Brisbane Dick Fund, 1933   Paris 27                   Prints|Ornament & Architecture 673   Metropolitan Museum of Art, New York, NY 1
301429 33.84(1.205) 0 0 431208 Drawings and Prints 11 Print collection ornament & architecture 13848 Bed ornamented with a painting of sleeping Venus and with Cupid above, from Livre de lits à la romaine, plate 4, bound in Oeuvres. Vol. I         Livre de lits à la romaine 2169 Artist 2   Jean Le Pautre French, Paris 1618–1682 Paris   Le Pautre, Jean 10804 French 2 1618 1682 17th century 1633 1682 Etching; second state of three (Préaud) 44263 Sheet: 13 9/16 × 8 1/4 in. (34.5 × 21 cm) Plate: 8 7/8 × 6 1/16 in. (22.5 × 15.4 cm) Harris Brisbane Dick Fund, 1933   Paris 27                   Prints|Ornament & Architecture 673   Metropolitan Museum of Art, New York, NY 1
301430 33.84(1.206) 0 0 431209 Drawings and Prints 11 Print collection ornament & architecture 13848 A female figure in a bed listening to a companion, from Livre de lits à la romaine, plate 2, bound in Oeuvres. Vol. I         Livre de lits à la romaine 2169 Artist 2   Jean Le Pautre French, Paris 1618–1682 Paris   Le Pautre, Jean 10804 French 2 1618 1682 17th century 1633 1682 Etching; second state of three (Préaud) 44263 Sheet: 13 9/16 × 8 1/4 in. (34.5 × 21 cm) Plate: 8 3/4 × 6 1/16 in. (22.2 × 15.4 cm) Harris Brisbane Dick Fund, 1933   Paris 27                   Prints|Ornament & Architecture 673   Metropolitan Museum of Art, New York, NY 1
301431 33.84(1.207) 0 0 431210 Drawings and Prints 11 Print collection ornament & architecture 13848 Two variants for a Roman bed with putti on the headboard, from Livre de lits à la romaine, plate 5, bound in Oeuvres. Vol. I         Livre de lits à la romaine 2169 Artist 2   Jean Le Pautre French, Paris 1618–1682 Paris   Le Pautre, Jean 10804 French 2 1618 1682 17th century 1633 1682 Etching; second state of three (Préaud) 44263 Sheet: 13 9/16 × 8 1/4 in. (34.5 × 21 cm) Plate: 8 7/8 × 6 1/8 in. (22.5 × 15.5 cm) Harris Brisbane Dick Fund, 1933   Paris 27                   Prints|Ornament & Architecture 673   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 123.358ms · Data license: CC0 · Data source: metmuseum/openaccess