MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where Culture = 2148

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, Classification

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
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
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
110023 38.113.17 0 1 198133 European Sculpture and Decorative Arts 3 Spoon handle section 7018 Section of a spoon handle French, Orléans 2148         Maker 1   Pierre IX Hanappier master 1730, active 1775   HANAPPIER PIERRE IX 10048   1700 1805 1772–74 1772 1774 Silver 2 Length: 1 7/16 in. (3.7 cm) Gift of Jacques Helft, 1938                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
110288 39.70.12 0 1 198405 European Sculpture and Decorative Arts 3 Spoon handle section 7018 Section of a spoon handle French, Orléans 2148         Maker 1   P. B., Orleans     B. P. 10082       1780–82 1780 1782 Silver 2 Length: 1 1/4 in. (3.2 cm) Gift of Jacques Helft, 1939                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
111912 48.187.151 0 1 200181 European Sculpture and Decorative Arts 3 Wine taster 7726 Wine taster French, Orléans 2148         Maker 1   Pierre IX Hanappier master 1730, active 1775   HANAPPIER PIERRE IX 10048   1700 1805 1768–70 1768 1770 Silver 2 Overall: 1 × 3 1/8 in. (2.5 × 7.9 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
112033 48.187.323 0 1 200302 European Sculpture and Decorative Arts 3 Wine taster 7726 Wine taster French, Orléans 2148         Maker 1   Jacques Hanappier master 1730   HANAPPIER JACQUES 10511   1700 1760 1758–60 1758 1760 Silver 2 Overall: 1 1/4 × 4 1/2 in. (3.2 × 11.4 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
112190 48.187.501 0 1 200460 European Sculpture and Decorative Arts 3 Scissors 4386 Scissors French, Orléans 2148                           1775–81 1775 1781 Gold, steel 3844 Length: 3 13/16 in. (9.7 cm) Bequest of Catherine D. Wentworth, 1948                       Metalwork-Gold and Platinum 326   Metropolitan Museum of Art, New York, NY 1
113975 59.208.10 0 1 202345 European Sculpture and Decorative Arts 3 Group 3937 Europe and America French, Orléans 2148         Factory 328   Orléans factory French, 1753–82   Orléans factory 10906   1753 1782 ca. 1760–70 1755 1775 Soft-paste porcelain 2061 Height: 10 7/16 in. (26.5 cm) Gift of Estate of James Hazen Hyde, 1959                       Ceramics-Porcelain 307   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 98.706ms · Data license: CC0 · Data source: metmuseum/openaccess