MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

14 rows where Medium = 329

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, 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
1138 34.82.2 0 0 1229 American Paintings and Sculpture 2 Medal 148 Mr. and Mrs. Robert W. de Forest           Artist 2   Evelyn Beatrice Longman American, Winchester, Ohio 1874–1954 Osterville, Massachusetts   Longman, Evelyn Beatrice 229 American 1 1874 1954 1922 1922 1922 Bronze and gold leaf 329 Diam. 2 1/16 in. (5.2 cm) Gift of Mrs. Robert W. de Forest, 1934                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
9989 27.64 0 1 10807 American Paintings and Sculpture 2 Sculpture 100 Tomb Effigy of Elizabeth Boott Duveneck           Artist 2   Frank Duveneck American, Covington, Kentucky 1848–1919 Cincinnati, Ohio   Duveneck, Frank 1406 American 1 1848 1919 1891; cast 1927 1891 1927 Bronze and gold leaf 329 28 1/2 x 85 x 41 1/4 in. (72.4 x 215.9 x 104.8 cm) Rogers Fund, 1927                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
11921 07.251.69 0 1 12963 American Paintings and Sculpture 2 Medal 148 Philadelphia Centennial Exhibition           Artist 2   William Barber 1807–1879   Barber, William 1868   1807 1879 1876 1876 1876 Bronze and gold leaf 329 Diam. 2 1/4 in. (5.7 cm) Gift of Mr. and Mrs. F. S. Wait, 1907                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
13399 07.288.11 0 1 14561 American Paintings and Sculpture 2 Medal 148 Centennial Exhibition at Philadelphia           Artist 2   William Barber 1807–1879   Barber, William 1868   1807 1879 1876 1876 1876 Bronze and gold leaf 329 Diam. 2 1/4 in. (5.7 cm) Gift of Mr. and Mrs. F. S. Wait, 1907                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
13489 09.10.1 0 1 14651 American Paintings and Sculpture 2 Medal 148 Centenary of the New York Historical Society           Artist 2   Victor David Brenner American (born Lithuania), Kaunas 1871–1924 New York   Brenner, Victor David 574 American, born Lithuania 15 1871 1924 1904 1904 1904 Bronze and gold leaf 329 Diam. 2 1/2 in. (6.4 cm) Gift of Mr. and Mrs. F. S. Wait, 1909                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
13507 09.43.8 0 1 14669 American Paintings and Sculpture 2 Medal 148 The Elliot Cresson Medal                             1894 1894 1894 Bronze and gold leaf 329 Diam. 1 3/8 in. (3.5 cm) Gift of James B. Hammond, 1909                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
13515 09.140.3 0 1 14677 American Paintings and Sculpture 2 Medal 148 Panama Canal Medal for Two Years Continuous Service on the Canal           Artist 2   Victor David Brenner American (born Lithuania), Kaunas 1871–1924 New York   Brenner, Victor David 574 American, born Lithuania 15 1871 1924 1908 1908 1908 Bronze and gold leaf 329 Diam. 1 1/4 in. (3.2 cm) Gift of the sculptor, 1909                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
13516 09.140.4 0 1 14678 American Paintings and Sculpture 2 Medal 148 Panama Canal Medal for Two Years Continuous Service on the Canal           Artist 2   Victor David Brenner American (born Lithuania), Kaunas 1871–1924 New York   Brenner, Victor David 574 American, born Lithuania 15 1871 1924 1908 1908 1908 Bronze and gold leaf 329 Diam. 1 1/4 in. (3.2 cm) Gift of the sculptor, 1909                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
13540 10.160 0 1 14702 American Paintings and Sculpture 2 Medal 148 Franklin Birthday Dinner of the Typothetae of New York           Artist 2   Victor David Brenner American (born Lithuania), Kaunas 1871–1924 New York   Brenner, Victor David 574 American, born Lithuania 15 1871 1924 1902 1902 1902 Bronze and gold leaf 329 2 1/4 x 2 1/2 in. (5.7 x 6.4 cm) Gift of American Type Founders Company, 1910                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
13606 33.152.7 0 1 14768 American Paintings and Sculpture 2 Medal 148 Commemorating Lindbergh's Trans-Atlantic Flight, 1927           Artist 2   Frederick William MacMonnies American, New York 1863–1937 New York   MacMonnies, Frederick William 1601 American 1 1863 1937 1931 1931 1931 Bronze and gold leaf 329 Diam. 2 7/8 in. (7.3 cm) Gift of the Society of Medalists (through George D. Pratt), 1933                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
13607 33.152.8 0 1 14769 American Paintings and Sculpture 2 Medal 148 Commemorating Lindbergh's Trans-Atlantic Flight, 1927           Artist 2   Frederick William MacMonnies American, New York 1863–1937 New York   MacMonnies, Frederick William 1601 American 1 1863 1937 1931 1931 1931 Bronze and gold leaf 329 Diam. 2 7/8 in. (7.3 cm) Gift of the Society of Medalists (through George D. Pratt), 1933                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
13621 38.111.1 0 1 14783 American Paintings and Sculpture 2 Medal 148 Life as a Dance           Artist 2   Alexander Stirling Calder American, Philadelphia, Pennsylvania 1870–1945 Brooklyn, New York   Calder, Alexander Stirling 1312 American 1 1870 1945 1938 1938 1938 Bronze and gold leaf 329 Diam. 2 3/4 in. (7 cm) Gift of the Society of Medalists, 1938                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
13622 38.111.2 0 1 14784 American Paintings and Sculpture 2 Medal 148 Life as a Dance           Artist 2   Alexander Stirling Calder American, Philadelphia, Pennsylvania 1870–1945 Brooklyn, New York   Calder, Alexander Stirling 1312 American 1 1870 1945 1938 1938 1938 Bronze and gold leaf 329 Diam. 2 3/4 in. (7 cm) Gift of the Society of Medalists, 1938                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
13655 34.82.1 0 0 14819 American Paintings and Sculpture 2 Medal 148 Mr. and Mrs. Robert W. de Forest           Artist 2   Evelyn Beatrice Longman American, Winchester, Ohio 1874–1954 Osterville, Massachusetts   Longman, Evelyn Beatrice 229 American 1 1874 1954 1922 1922 1922 Bronze and gold leaf 329 Diam. 5 1/2 in. (14 cm) Gift of Mrs. Robert W. de Forest, 1934                       Sculpture 12   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 145.467ms · Data license: CC0 · Data source: metmuseum/openaccess