MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Artist Alpha Sort = 8020

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, 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
98974 83.7.19a, b 0 1 186310 European Sculpture and Decorative Arts 3 Scent bottle 775 Amethyst-colored flacon de poche decorated with imperial eagle and floral bouquet French, Orléans 2148         Maker 1   Glasshouse of Bernard Perrot, Verrerie Royale d'Orléans 1640–1709   Perrot Bernard 8020   1640 1709 18th century 1700 1799 Glass, pewter 2329 Height: 3 3/4 in. (9.5 cm) Gift of Henry G. Marquand, 1883                       Glass 3   Metropolitan Museum of Art, New York, NY 1
98975 83.7.20 0 1 186311 European Sculpture and Decorative Arts 3 Scent bottle 775 Blue-colored flacon de poche decorated with fleur de lys and hearts French, Orléans 2148         Maker 1   Glasshouse of Bernard Perrot, Verrerie Royale d'Orléans 1640–1709   Perrot Bernard 8020   1640 1709 late 17th–early 18th century 1685 1715 Glass, pewter 2329 Height: 3 1/4 in. (8.3 cm) Gift of Henry G. Marquand, 1883                       Glass 3   Metropolitan Museum of Art, New York, NY 1
98976 83.7.21 0 1 186312 European Sculpture and Decorative Arts 3 Scent bottle 775 Blue-colored flacon de poche decorated with lion rampant and enflamed cross potant French, Orléans 2148         Maker 1   Glasshouse of Bernard Perrot, Verrerie Royale d'Orléans 1640–1709   Perrot Bernard 8020   1640 1709 late 17th–early 18th century 1685 1715 Glass, pewter 2329 Height: 3 1/2 in. (8.9 cm) Gift of Henry G. Marquand, 1883                       Glass 3   Metropolitan Museum of Art, New York, NY 1
98977 83.7.22a, b 0 0 186313 European Sculpture and Decorative Arts 3 Scent bottle 775 Amber-colored flacon de poche decorated with fleur de lys and hearts French, Orléans 2148         Maker 1   Glasshouse of Bernard Perrot, Verrerie Royale d'Orléans 1640–1709   Perrot Bernard 8020   1640 1709 late 17th–early 18th century 1685 1715 Glass, pewter 2329 Height: 3 1/8 in. (7.9 cm) Gift of Henry G. Marquand, 1883                       Glass 3   Metropolitan Museum of Art, New York, NY 1
98981 83.7.26 0 1 186317 European Sculpture and Decorative Arts 3 Flacon 6831 Head-shaped flacon French, Orléans 2148         Maker 1   Glasshouse of Bernard Perrot, Verrerie Royale d'Orléans 1640–1709   Perrot Bernard 8020   1640 1709 ca. 1700 1695 1705 Glass 31 H. 2 1/2 in. (6.4 cm) Gift of Henry G. Marquand, 1883                       Glass 3   Metropolitan Museum of Art, New York, NY 1
98996 83.7.43 0 1 186332 European Sculpture and Decorative Arts 3 Shaft 6832 Millefiore shaft Italian, Venice and French, Orlêans 2151         Maker 1   Glasshouse of Bernard Perrot, Verrerie Royale d'Orléans 1640–1709 (from Venetian elements) Perrot Bernard 8020   1640 1709 17th century 1600 1699 Glass 31 Height: 8 3/8 in. (21.3 cm) Gift of Henry G. Marquand, 1883                       Glass 3   Metropolitan Museum of Art, New York, NY 1
99099 83.7.165 0 1 186435 European Sculpture and Decorative Arts 3 Scent bottle 775 Amber-colored flacon de poche decorated with fleur de lys and hearts French, Orléans 2148         Maker 1   Glasshouse of Bernard Perrot, Verrerie Royale d'Orléans 1640–1709   Perrot Bernard 8020   1640 1709 late 17th–early 18th century 1685 1715 Glass, pewter 2329 Height: 3 1/2 in. (8.9 cm) Gift of Henry G. Marquand, 1883                       Glass 3   Metropolitan Museum of Art, New York, NY 1
99127 83.7.201a, b 0 0 186463 European Sculpture and Decorative Arts 3 Jam jar 6842 Lidded jam jar (confiturier) with ribbed decoration French, possibly Orléans 2170         Maker 1 Possibly made at Glasshouse of Bernard Perrot, Verrerie Royale d'Orléans 1640–1709   Perrot Bernard 8020   1640 1709 ca. 1700 1695 1705 Glass 31 Height (with cover): 3 7/8 in. (9.8 cm) Gift of Henry G. Marquand, 1883                       Glass 3   Metropolitan Museum of Art, New York, NY 1
99933 91.1.1187 0 1 187281 European Sculpture and Decorative Arts 3 Beaker 58 White beaker decorated with red lines French, Orléans 2148         Maker 1   Glasshouse of Bernard Perrot, Verrerie Royale d'Orléans 1640–1709   Perrot Bernard 8020   1640 1709 18th century 1700 1799 Glass 31 Height: 3 7/8 in. (9.8 cm) Edward C. Moore Collection, Bequest of Edward C. Moore, 1891                       Glass 3   Metropolitan Museum of Art, New York, NY 1
118289 1982.97.6 0 1 207288 European Sculpture and Decorative Arts 3 Beaker 58 Octagonal beaker decorated with bird and trees French, Orléans 2148         Maker 1 Attributed to followers of the Glasshouse of Bernard Perrot, Verrerie Royale d'Orléans 1640–1709   Perrot Bernard 8020   1640 1709 1726 1726 1726 Glass 31 Height: 2 7/8 in. (7.3 cm) Gift of Dr. Eugen Grabscheid, 1982                       Glass 3   Metropolitan Museum of Art, New York, NY 1
119507 1996.90 0 1 208543 European Sculpture and Decorative Arts 3 Scent bottle 775 Blue-colored flacon de poche decorated with fleur de lys, hearts and roses French, Orléans 2148         Maker 1   Glasshouse of Bernard Perrot, Verrerie Royale d'Orléans 1640–1709   Perrot Bernard 8020   1640 1709 late 17th–early 18th century 1685 1715 Glass 31 Height: 3 1/8 in. (7.9 cm) Gift of Joseph G. Reinis, 1996                       Glass 3   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 289.799ms · Data license: CC0 · Data source: metmuseum/openaccess