MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

108 rows where City = 6 sorted by Geography Type

✎ View and edit SQL

This data as json, CSV (advanced)

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 Metadata Date Repository
412898 412898 2015.256.1 0 1 680874 American Decorative Arts 1 Decanter 123 Cologne decanter American 1         Maker|Manufacturer 23   Louis Friedrich Vaupel|New England Glass Company 1824–1930|American, East Cambridge, Massachusetts, 1818–1888   Vaupel, Louis Friedrich|New England Glass Company  435   1824 |1818 1930 |1888 1876 1876 1876 Glass, cut and engraved 59672 H. 9 in. (22.9 cm) Purchase, Sylvia and Leonard Marx Jr. and Mr. and Mrs. James M. Myers Gifts, 2015 Made in 1 East Cambridge 6     United States 3             Glass 3   http://www.metmuseum.org/art/collection/search/680874 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
412899 412899 2015.256.2 0 1 680875 American Decorative Arts 1 Decanter 123 Cologne decanter American 1         Maker|Manufacturer 23   Louis Friedrich Vaupel|New England Glass Company 1824–1930|American, East Cambridge, Massachusetts, 1818–1888   Vaupel, Louis Friedrich|New England Glass Company  435   1824 |1818 1930 |1888 1876 1876 1876 Glass, cut and engraved 59672 H. 9 in. (22.9 cm) Purchase, Sylvia and Leonard Marx Jr. and Mr. and Mrs. James M. Myers Gifts, 2015 Made in 1 East Cambridge 6     United States 3             Glass 3   http://www.metmuseum.org/art/collection/search/680875 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
412900 412900 2015.257 0 1 680876 American Decorative Arts 1 Spoon holder 843 Spoon holder American 1         Maker|Manufacturer 23   Louis Friedrich Vaupel|New England Glass Company 1824–1930|American, East Cambridge, Massachusetts, 1818–1888   Vaupel, Louis Friedrich|New England Glass Company  435   1824 |1818 1930 |1888 ca. 1876 1871 1881 Glass, cut and engraved 59672 H. 3 in. (7.6 cm) Purchase, Edward J. Scheider Gift, in memory of Kathleen N. Scheider, 2015 Made in 1 East Cambridge 6     United States 3             Glass 3   http://www.metmuseum.org/art/collection/search/680876 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
5093 5093 1980.511.1 0 1 5457 American Decorative Arts 1 Oil lamp 653 Oil Lamp American 1         Maker 1 Probably New England Glass Company American, East Cambridge, Massachusetts, 1818–1888   New England Glass Company  10   1818 1888 1830–40 1830 1840 Pressed and free-blown white opaque glass 995 13 1/2 x 3 1/8 in. (34.3 x 7.9 cm) Gift of Mr. and Mrs. Stuart P. Feld, 1980 Probably made in 2 East Cambridge 6     United States 3             Glass 3   http://www.metmuseum.org/art/collection/search/5457 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
5094 5094 1980.511.2 0 1 5458 American Decorative Arts 1 Oil lamp 653 Oil Lamp American 1         Maker 1 Probably New England Glass Company American, East Cambridge, Massachusetts, 1818–1888   New England Glass Company  10   1818 1888 1830–40 1830 1840 Pressed and free-blown white opaque glass 995 13 1/2 x 3 1/8 in. (34.3 x 7.9 cm) Gift of Mr. and Mrs. Stuart P. Feld, 1980 Probably made in 2 East Cambridge 6     United States 3             Glass 3   http://www.metmuseum.org/art/collection/search/5458 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
5453 5453 10.60.26 0 1 5829 American Decorative Arts 1 Pitcher 296 Pitcher American 1         Maker 1 Probably New England Glass Company American, East Cambridge, Massachusetts, 1818–1888   New England Glass Company  10   1818 1888 1817–40 1817 1840 Blown glass with applied decoration 112 11 3/8 x 6 in. (28.9 x 15.2 cm) Rogers Fund, 1910 Probably made in 2 East Cambridge 6     United States 3             Glass 3   http://www.metmuseum.org/art/collection/search/5829 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
5779 5779 51.171.47 0 1 6167 American Decorative Arts 1 Plate 356 Plate American 1         Maker 1 Possibly New England Glass Company American, East Cambridge, Massachusetts, 1818–1888   New England Glass Company  10   1818 1888 ca. 1835 1832 1835 Lacy pressed glass 218 Diam. 5 3/4 in. (14.6 cm) Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951 Possibly made in 5 East Cambridge 6     United States 3             Glass 3   http://www.metmuseum.org/art/collection/search/6167 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
5780 5780 51.171.99 0 1 6168 American Decorative Arts 1 Plate 356 Plate American 1         Maker 1 Possibly New England Glass Company American, East Cambridge, Massachusetts, 1818–1888   New England Glass Company  10   1818 1888 ca. 1830 1827 1830 Lacy pressed opaque white glass 1098 Diam. 7 in. (17.8 cm) Gift of Mrs. Charles W. Green, in memory of Dr. Charles W. Green, 1951 Possibly made in 5 East Cambridge 6     United States 3             Glass 3   http://www.metmuseum.org/art/collection/search/6168 4/23/2018 8:00:01 AM 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 41.935ms · Data license: CC0 · Data source: metmuseum/openaccess