MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Object Name = 7143

View and edit SQL

Suggested facets: Is Public Domain, Culture, Artist Display Name, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

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
101717 07.102.8 0 1 189235 European Sculpture and Decorative Arts 3 Dish ring 7143 Dish ring British, Sheffield 2294         Maker 1 Probably by Tudor and Leader     Tudor and Leader 8463       ca. 1787 1782 1792 Sheffield plate 20806 4 × 7 1/4 in. (10.2 × 18.4 cm) Rogers Fund, 1907                       Metalwork-Silverplate 335   Metropolitan Museum of Art, New York, NY 1
101755 07.158.1 0 0 189274 European Sculpture and Decorative Arts 3 Dish ring 7143 Dish ring Irish, Dublin 2300         Maker 1   Edmond Johnson     Johnson Edmond 8148   1850 1950 1906–7 1906 1907 Silver 2 Overall: 4 1/2 × 8 7/8 in. (11.4 × 22.5 cm) Rogers Fund, 1907                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
101756 07.158.2 0 0 189275 European Sculpture and Decorative Arts 3 Dish ring 7143 Dish ring Irish, Dublin 2300         Maker 1   Edmond Johnson     Johnson Edmond 8148   1850 1950 1906–7 1906 1907 Silver 2 3 1/2 × 8 3/4 in. (8.9 × 22.2 cm) Rogers Fund, 1907                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
101757 07.158.3 0 0 189276 European Sculpture and Decorative Arts 3 Dish ring 7143 Dish ring Irish, Dublin 2300         Maker 1   Edmond Johnson     Johnson Edmond 8148   1850 1950 1906–7 1906 1907 Silver 2 4 1/2 × 8 3/4 in. (11.4 × 22.2 cm) Rogers Fund, 1907                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
101758 07.158.4 0 0 189277 European Sculpture and Decorative Arts 3 Dish ring 7143 Dish ring Irish, Dublin 2300         Maker 1   Edmond Johnson     Johnson Edmond 8148   1850 1950 1906–7 1906 1907 Silver 2 3 5/8 × 8 1/2 in. (9.2 × 21.6 cm) Rogers Fund, 1907                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
101759 07.158.5 0 0 189278 European Sculpture and Decorative Arts 3 Dish ring 7143 Dish ring Irish, Dublin 2300         Maker 1   Edmond Johnson     Johnson Edmond 8148   1850 1950 1906–7 1906 1907 Silver 2 4 1/2 × 8 1/2 in. (11.4 × 21.6 cm) Rogers Fund, 1907                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
101760 07.158.6 0 0 189279 European Sculpture and Decorative Arts 3 Dish ring 7143 Dish ring Irish, Dublin 2300         Maker 1   Edmond Johnson     Johnson Edmond 8148   1850 1950 1903–4 1903 1904 Silver 2 3 3/4 × 8 3/4 in. (9.5 × 22.2 cm) Rogers Fund, 1907                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
107566 26.260.65a, b 0 1 195550 European Sculpture and Decorative Arts 3 Dish ring 7143 Dish ring Irish, Dublin 2300                           1786 1786 1786 Silver, glass 619 3 7/8 × 7 5/8 in. (9.8 × 19.4 cm) Bequest of Annie C. Kane, 1926                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
113554 55.111.1 0 1 201863 European Sculpture and Decorative Arts 3 Dish ring 7143 Dish ring Irish, Dublin 2300                           ca. 1760 1755 1765 Silver 2 3 3/4 × 7 7/8 in. (9.5 × 20 cm) Bequest of Mrs. Helen W.D. Mileham, 1955                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
115841 64.187.14 0 1 204474 European Sculpture and Decorative Arts 3 Dish ring 7143 Dish ring British, Birmingham 398         Maker 1   H. Freeth     FREETH H. 11138   1750 1850 ca. 1816 1811 1821 Sheffield plate 20806 3 5/16 × 7 1/16 in. (8.4 × 17.9 cm) Gift of Frances and Edward Munves, 1964                       Metalwork-Silverplate 335   Metropolitan Museum of Art, New York, NY 1
116209 68.141.78 0 1 204894 European Sculpture and Decorative Arts 3 Dish ring 7143 Dish ring Irish, Dublin 2300         Maker 1   Christopher Haines     Haines Christopher 8606   1725 1825 1770 1770 1770 Silver 2 Diameter: 7 1/2 in. (19.1 cm) Gift of Irwin Untermyer, 1968                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
391139 2014.759 0 1 642825 European Sculpture and Decorative Arts 3 Dish ring 7143 Dish ring Irish 26         Maker 1 Unidentified Dublin maker W. H.     W. H. 422       1777 1777 1777 Silver 2 Overall (confirmed): 3 7/8 × 8 1/8 × 8 1/8 in. (9.8 × 20.6 × 20.6 cm) Purchase, The Isaacson-Draper Foundation Gift, in memory of Hazel Draper, 2014                       Metalwork-Silver 313   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 121.685ms · Data license: CC0 · Data source: metmuseum/openaccess