MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Is Public Domain = 0 and Object Name = 674

View and edit SQL

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
5150 30.120.342 0 0 5517 American Decorative Arts 1 Paperweight 674 Paperweight                             19th–20th century 1800 2000 Free-blown glass 186 H. 1 5/8 in. (4.1 cm) The Sylmaris Collection, Gift of George Coe Graves, 1930 Made in 1       China 13             Glass 3   Metropolitan Museum of Art, New York, NY 1
5151 30.120.332 0 0 5518 American Decorative Arts 1 Paperweight 674 Paperweight American 1         Maker 1 Probably Ralph Barber     Barber, Ralph 773     9999 1905–12 1905 1912 Free-blown glass 186 H. 4 in. (10.2 cm) The Sylmaris Collection, Gift of George Coe Graves, 1930 Made in 1 Millville 178     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
5152 30.120.335 0 0 5519 American Decorative Arts 1 Paperweight 674 Paperweight American 1         Maker 1 Probably Ralph Barber     Barber, Ralph 773     9999 1905–12 1905 1912 Free-blown glass 186 H. 4 1/2 in. (11.4 cm) The Sylmaris Collection, Gift of George Coe Graves, 1930 Made in 1 Millville 178     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
5161 30.120.336 0 0 5528 American Decorative Arts 1 Paperweight 674 Paperweight American 1         Maker 1 Possibly Mount Washington Glass Company 1837–1958   Mount Washington Glass Company  358   1837 1958 1870–1900 1870 1900 Free-blown glass 186 H. 4 in. (10.2 cm) The Sylmaris Collection, Gift of George Coe Graves, 1930 Made in 1 New Bedford 65     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
108637 30.120.333 0 0 196674 European Sculpture and Decorative Arts 3 Paperweight 674 Paperweight British 6         Manufactory|Maker 432 Possibly made at|Possibly made by Islington Glass Works, Birmingham|George Bacchus and Sons, Birmingham     Islington Glass Works|George Bacchus and Sons, Birmingham 9750       19th century 1800 1899 Glass 31 Diameter: 4 1/2 in. (11.4 cm) The Sylmaris Collection, Gift of George Coe Graves, 1930                       Glass 3   Metropolitan Museum of Art, New York, NY 1
108638 30.120.334 0 0 196675 European Sculpture and Decorative Arts 3 Paperweight 674 Paperweight British 6         Manufactory|Maker 432 Possibly made at Islington Glass Works, Birmingham|George Bacchus and Sons, Birmingham     Islington Glass Works|George Bacchus and Sons, Birmingham 9750       19th century 1800 1899 Glass 31 Diameter: 3 1/4 in. (8.3 cm) The Sylmaris Collection, Gift of George Coe Graves, 1930                       Glass 3   Metropolitan Museum of Art, New York, NY 1
108641 30.120.340 0 0 196678 European Sculpture and Decorative Arts 3 Paperweight 674 Paperweight probably French 203         Maker 1   Baccarat glasshouse     Baccarat glasshouse 9751       19th century 1800 1899 Glass 31 Diameter: 3 1/8 in. (7.9 cm) The Sylmaris Collection, Gift of George Coe Graves, 1930                       Glass 3   Metropolitan Museum of Art, New York, NY 1
334050 1975.278.1 0 0 481443 Modern and Contemporary Art 4 Paperweight 674 Paperweight           Designer 5   Roland R. Correia American, born 1949   Correia, Roland 44910 American 1 1949 2049 ca. 1975 1975 1975 Glass 31 H. 2-3/8, Diam. 3-3/8 in. (6 x 8.6 cm.) Purchase, The Chace Foundation Inc. Gift, 1975                       Glass 3   Metropolitan Museum of Art, New York, NY 1
334051 1975.278.2 0 0 481444 Modern and Contemporary Art 4 Paperweight 674 Paperweight           Designer 5   Roland R. Correia American, born 1949   Correia, Roland 44910 American 1 1949 2049 ca. 1975 1975 1975 Glass 31 H. 2-1/4, Diam. 3-3/8 in. (5.7 x 8.6 cm.) Purchase, The Chace Foundation Inc. Gift, 1975                       Glass 3   Metropolitan Museum of Art, New York, NY 1
337011 1986.407 0 0 484565 Modern and Contemporary Art 4 Paperweight 674 Paperweight           Artist 2   Paul Stankard American, born North Attleboro, Massachusetts 1943   Stankard, Paul 45698 American 1 1943 2043 1986 1986 1986 Glass 31 H. 5-3/8, W. 2-3/4, D. 2-3/8 inches (13.7 x 7 x 6 cm.) Gift of Jack Feingold, 1986                       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 6881.306ms · Data license: CC0 · Data source: metmuseum/openaccess