MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where City = 222

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, 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, 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
5457 1981.432.1 0 1 5833 American Decorative Arts 1 Pitcher 296 Pitcher American 1         Maker|Manufacturer 23   George E. Ohr|Biloxi Art Pottery American, Biloxi, Mississippi 1857–1918 Biloxi, Mississippi|1883–1906   Ohr, George E.|Biloxi Art Pottery  816 American 1 1857 |1883 1918 |1906 ca. 1893–1909 1890 1909 Earthenware 21 H. 4 1/2 in. (11.4 cm); Diam. 6 in. (15.2 cm) Gift of Florence I. Balasny-Barnes, in honor of her brother, Raymond L. Balasny, and children, Susan, Jill and Neal, 1981 Made in 1 Biloxi 222     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5458 1986.80 0 1 5834 American Decorative Arts 1 Pitcher 296 Pitcher American 1         Maker|Manufacturer 23   George E. Ohr|Biloxi Art Pottery American, Biloxi, Mississippi 1857–1918 Biloxi, Mississippi|1883–1906   Ohr, George E.|Biloxi Art Pottery  816 American 1 1857 |1883 1918 |1906 1890–1905 1890 1905 Earthenware 21 4 1/4 x 6 1/2 in. (10.8 x 16.5 cm) Gift of Joan and Jack Alter, 1986 Made in 1 Biloxi 222     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
8716 1976.97 0 0 9367 Modern and Contemporary Art 4 Vase 7 Vase American 1         Maker|Manufacturer 23   George E. Ohr|Biloxi Art Pottery American, Biloxi, Mississippi 1857–1918 Biloxi, Mississippi|1883–1906   Ohr, George E.|Biloxi Art Pottery  816 American 1 1857 |1883 1918 |1906 1894–1906 1894 1906 Earthenware 21 H. 4 1/4 in. (10.8 cm); Diam. 5 3/4 in. (14.6 cm) Purchase, Virginia H. Groomes Gift, in memory of her mother, Mary W. Groomes, 1976 Made in 1 Biloxi 222   Mississippi 56 United States 3 South United States 15           Ceramics 5   Metropolitan Museum of Art, New York, NY 1
8717 1982.224 0 1 9368 American Decorative Arts 1 Vase 7 Vase American 1         Maker|Manufacturer 23   George E. Ohr|Biloxi Art Pottery American, Biloxi, Mississippi 1857–1918 Biloxi, Mississippi|1883–1906   Ohr, George E.|Biloxi Art Pottery  816 American 1 1857 |1883 1918 |1906 1890–1905 1890 1905 Earthenware 21 H. 7 1/2 in. (19.1 cm) Friends of the American Wing Fund, 1982 Made in 1 Biloxi 222     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
15278 1998.447 0 1 16544 American Decorative Arts 1 Vase 7 Vase American 1         Artist 2   George E. Ohr American, Biloxi, Mississippi 1857–1918 Biloxi, Mississippi   Ohr, George E. 2367 American 1 1857 1918 ca. 1895–1900 1895 1900 Glazed red earthenware 2605 H. 14 1/8 in. (35.9 cm); Diam. 6 1/8 in. (15.6 cm) Gift of Jean and Martin Mensch,1998 Made in 1 Biloxi 222     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
16638 2017.357.11 0 1 19875 American Decorative Arts 1 Vase 7 Vase American 1         Maker 1   George E. Ohr American, Biloxi, Mississippi 1857–1918 Biloxi, Mississippi   Ohr, George E. 2367   1857 1918 1897—1900 1897 1900 Earthenware 21 11 7/16 x 6 3/8 in. (29.1 x 16.2 cm) Gift of Robert A. Ellison Jr., 2017 Made in 1 Biloxi 222     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
16639 2017.357.12 0 1 19878 American Decorative Arts 1 Vase 7 Vase American 1         Maker 1   George E. Ohr American, Biloxi, Mississippi 1857–1918 Biloxi, Mississippi   Ohr, George E. 2367   1857 1918 1897–1900 1897 1900 Earthenware 21 7 3/4 x 4 3/8 in. (19.7 x 11.1 cm) Gift of Robert A. Ellison Jr., 2017 Made in 1 Biloxi 222     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
16681 2017.357.13a, b 1 1 20144 American Decorative Arts 1 Teapot 26 Teapot American 1         Maker 1   George E. Ohr American, Biloxi, Mississippi 1857–1918 Biloxi, Mississippi   Ohr, George E. 2367   1857 1918 1897–1900 1897 1900 Earthenware 21 7 3/16 x 7 1/8 in. (18.3 x 18.1 cm) Gift of Robert A. Ellison Jr., 2017 Made in 1 Biloxi 222     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
16682 2017.357.14 0 1 20145 American Decorative Arts 1 Vase 7 Vase American 1         Maker 1   George E. Ohr American, Biloxi, Mississippi 1857–1918 Biloxi, Mississippi   Ohr, George E. 2367   1857 1918 1897–1900 1897 1900 Earthenware 21 13 x 6 7/8 in. (33 x 17.5 cm) Gift of Robert A. Ellison Jr., 2017 Made in 1 Biloxi 222     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
431730 2017.444.2 0 0 716909 American Decorative Arts 1 Vase 7 Vase American 1         Maker 1   George E. Ohr American, Biloxi, Mississippi 1857–1918 Biloxi, Mississippi   Ohr, George E. 2367   1857 1918 ca. 1895–1905 1895 1905 earthenware 46537 H. 9 1/2 in. Gift of Martin Eidelberg, 2017 Made in 1 Biloxi 222     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
432614 2017.444.1 0 1 718151 American Decorative Arts 1 Vase 7 Vase American 1         Maker 1   George E. Ohr American, Biloxi, Mississippi 1857–1918 Biloxi, Mississippi   Ohr, George E. 2367   1857 1918 ca. 1895–1905 1890 1900 earthenware 46537 H. 10 1/4 in. Gift of Martin Eidelberg, 2017 Made in 1 Biloxi 222     United States 3             Ceramics 5   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 138.821ms · Data license: CC0 · Data source: metmuseum/openaccess