MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Medium = 34617

View and edit SQL

Suggested facets: Title, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Suffix, Artist Alpha Sort, Artist Nationality, Object Begin Date, Object End Date

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
220030 61.580.1 0 0 347558 Drawings and Prints 11 Book 97 Ornements en Bronze Galvanique           Designer|Printer 1002 Designed and published by|Printed by Charles Christofle & Cie.|D. A. Longuet French|French   Christofle Charles & Cie.|Longuet, D. A. 23000 French|French 21     19th century 1800 1900 Commercial photo process 34617 Overall: 16 15/16 x 12 5/16 x 1 1/4 in. (43 x 31.3 x 3.1 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1961   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
222288 1977.595.85 0 0 349848 Drawings and Prints 11 Book 97 Album de Serrurerie Décorative           Manufacturer|Printer|Printer 2446 Issued by Fontaine et Cie.|Reboul et Fils|Maréchal French , Paris|, Paris Fontaine et Cie.|Reboul et Fils|Maréchal 24546 French|French 21     [1930] 1930 1930 Commercial photo process 34617 13 3/8 x 10 5/8 x 1 1/16 in. (34 x 27 x 2.7 cm) Gift of Harvey Smith, 1977   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
222290 60.633.22 0 0 349850 Drawings and Prints 11 Book 97 Album de Serrurerie Décorative           Manufacturer 20 Issued by Fontaine et Cie.     Fontaine et Cie. 24548 French 2     1900–1960 1900 1960 Commercial photo process 34617 Overall: 13 3/8 x 10 7/8 x 7/8 in. (33.9 x 27.6 x 2.3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1960   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
228441 1984.1091 0 0 356075 Drawings and Prints 11 Book 97 Devantures Vitrines Installations de Magasins A l'Exposition Internationale des Arts Decoratifs, Paris 1925           Author|Publisher 44   René-Herbst|Charles H. Moreau   , Paris René-Herbst|Moreau, Charles H. 29024 French 2     1927 1927 1927 Commercial photo process 34617 Overall: 9 15/16 x 12 3/4 x 11/16 in. (25.2 x 32.4 x 1.8 cm) Edward Pearce Casey Fund, 1984   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
228442 1979.501 0 0 356076 Drawings and Prints 11 Book 97 Nouvelles Devantures et Agencements de Magasins Parisiens           Author|Publisher 44 Written by|Published by René-Herbst|Charles H. Moreau   , Paris René-Herbst|Moreau, Charles H. 29024 French 2     1928 1928 1928 Commercial photo process 34617 Overall: 9 15/16 x 12 15/16 x 11/16 in. (25.2 x 32.8 x 1.8 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1979   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
230331 1970.565.198 0 0 358018 Drawings and Prints 11 Book 97 Album de Fleuriste           Designer|Publisher 1009 Designed by|Published by James Tissot|MM. Tissot & Cie. French, Nantes 1836–1902 Chenecey-Buillon , Paris Tissot, James|Tissot, & Cie. MM. 30321 French 2 1836 1902 1900 1900 1900 Commercial photo process 34617 Overall: 8 3/8 x 10 13/16 x 9/16 in. (21.3 x 27.5 x 1.4 cm) Gift of Lincoln Kirstein, 1970   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
252111 1974.695 0 0 380608 Drawings and Prints 11 Book 97 Objets d'Art           Author|Publisher 44 Written by|Published by Pierre Legrain|Editions d'Art Charles Moreau French, Levallois-Perret 1889–1929 Paris|French   Legrain, Pierre|Moreau, Charles Editions d'Art 35664 French|French 21 1889 1929 1900–1929 1900 1929 Commercial photo process 34617 Overall: 13 3/16 x 10 1/8 x 7/8 in. (33.5 x 25.7 x 2.3 cm) Purchase, Administrative Fund, 1974   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
252162 1981.1089 0 0 380660 Drawings and Prints 11 Book 97 Boutiques 1931           Author|Publisher 44 Written by|Published by Roger Poulain|Vincent Freal et Cie. French   Poulain, Roger|Freal, Vincent et Cie. 35686 French|French 21     1931 1931 1931 Commercial photo process 34617 Overall: 12 1/2 x 8 1/4 x 13/16 in. (31.8 x 21 x 2 cm) Edward Pearce Casey Fund, 1981   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
252164 1980.1078 0 0 380662 Drawings and Prints 11 Book 97 Le Métal           Author|Publisher 44 Written by|Published by Jean Prouvé|Editions d'Art Charles Moreau French, Paris 1901–1984 Nancy|French   Prouvé, Jean|Moreau, Charles Editions d'Art 35687 French|French 21 1901 1984 1915–80 1915 1980 Commercial photo process 34617 Overall: 13 1/4 x 10 3/16 x 13/16 in. (33.6 x 25.8 x 2 cm) Edward Pearce Casey Fund, 1980   Paris 27                   Books 442   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 122.187ms · Data license: CC0 · Data source: metmuseum/openaccess