MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

29 rows where Object Name = 9947

View and edit SQL

Suggested facets: Title, Object Begin Date, Object End Date, Dimensions

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
144109 74.51.3701 0 1 243119 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Diameter: 9/16 x 1/4 in. (1.5 x 0.6 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144110 74.51.3702 0 1 243120 Greek and Roman Art 12 Earring with plain loop and disc 9947 Gold earring with convex disc Roman 736 Imperial                         2nd–3rd century A.D. 100 299 Gold 1 Diam.: 9/16 in. (1.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144111 74.51.3703 0 1 243121 Greek and Roman Art 12 Earring with plain loop and disc 9947 Gold earring with convex disc Roman 736 Imperial                         2nd–3rd century A.D. 100 299 Gold 1 Diam.: 5/8 in. (1.6 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144112 74.51.3704 0 1 243122 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 7/16 x 3/16 x 1/2 in. (1.1 x 0.5 x 1.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144113 74.51.3705 0 1 243123 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 1/2 x 3/16 x 9/16 in. (1.2 x 0.5 x 1.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144114 74.51.3706 0 1 243124 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Diameter: 1/2 x 1/4 in. (1.3 x 0.6 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144115 74.51.3707 0 1 243125 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Diameter: 1/2 x 1/8 in. (1.3 x 0.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144116 74.51.3708 0 1 243126 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Diameter: 5/8 x 3/16 in. (1.6 x 0.6 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144117 74.51.3709 0 1 243127 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Diameter: 5/8 x 1/8 in. (1.6 x 0.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144118 74.51.3710 0 1 243128 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Diameter: 1/2 x 3/16 in. (1.3 x 0.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144119 74.51.3711 0 1 243129 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 3/8 x 3/16 x 1/2 in. (1 x 0.5 x 1.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144120 74.51.3712 0 1 243130 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 5/16 x 3/16 x 3/4 in. (0.7 x 0.5 x 1.9 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144121 74.51.3713 0 1 243131 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Diameter: 7/16 x 3/16 in. (1.2 x 0.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144122 74.51.3714 0 1 243132 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 5/16 x 1/4 x 5/16 in. (0.8 x 0.7 x 0.9 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144123 74.51.3715 0 1 243133 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 3/8 x 3/16 x 7/16 in. (1 x 0.5 x 1.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144124 74.51.3716 0 1 243134 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 7/16 x 5/16 x 9/16 in. (1.2 x 0.8 x 1.5 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144125 74.51.3717 0 1 243135 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 7/16 x 3/16 x 1/2 in. (1.1 x 0.4 x 1.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144126 74.51.3718 0 1 243136 Greek and Roman Art 12 Earring with plain loop and disc 9947 Gold earring with convex disc Roman 736 Imperial                         2nd–3rd century A.D. 100 299 Gold 1 Other: 1/2 in. (1.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144127 74.51.3719 0 1 243137 Greek and Roman Art 12 Earring with plain loop and disc 9947 Gold earring with convex disc Roman 736 Imperial                         2nd–3rd century A.D. 100 299 Gold 1 Other: 1/2 in. (1.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144128 74.51.3720 0 1 243138 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 1/2 x 3/16 x 9/16 in. (1.2 x 0.5 x 1.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144129 74.51.3721 0 1 243139 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 1/2 x 3/16 x 9/16 in. (1.2 x 0.5 x 1.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144130 74.51.3722 0 1 243140 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 1/2 x 3/16 x 9/16 in. (1.3 x 0.5 x 1.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144131 74.51.3723 0 1 243141 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 1/2 x 3/16 x 9/16 in. (1.3 x 0.4 x 1.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144132 74.51.3724 0 1 243142 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 1/2 x 3/16 x 9/16 in. (1.3 x 0.5 x 1.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144133 74.51.3725 0 1 243143 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Diameter: 5/16 x 1/4 in. (0.8 x 0.6 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144134 74.51.3726 0 1 243144 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 3/8 x 3/16 x 1/2 in. (1 x 0.4 x 1.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144135 74.51.3727 0 1 243145 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 3/8 x 1/4 x 1/2 in. (1 x 0.7 x 1.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144136 74.51.3728 0 1 243146 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 9/16 x 1/4 x 5/8 in. (1.4 x 0.7 x 1.6 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
144137 74.51.3729 0 1 243147 Greek and Roman Art 12 Earring with plain loop and disc 9947 Earring with plain loop and disc                               -7000 330 Gold 1 Other: 5/16 x 7/16 x 1/2 in. (0.7 x 1.2 x 1.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   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 127.449ms · Data license: CC0 · Data source: metmuseum/openaccess