MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Role = 1 and State = 96

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Credit Line, Geography Type, Classification

Artist Role

  • Maker · 8
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
311210 09.87 0 1 445953 Islamic Art 9 Tile with niche design 14217 Tile Panel in the form of an Architectural Niche           Maker 1   Hasan ibn `Ali ibn Ahmad Babavaih     Hasan ibn `Ali ibn Ahmad Babavaih 44056       first half 14th century 1300 1350 Stonepaste; inglaze painted in blue, luster-painted on opaque white glaze, modeled 45088 H. 48 1/2 in. (123.2 cm) W. 23 1/2 in. (59.7 cm) Rogers Fund, 1909 Made in|Found 37 Kashan|Natanz 1550 | 96   Iran|Iran 351             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
320945 SL.13.2014.1.33 0 0 458825 Islamic Art 9 Brooch 131 Brooch           Maker 1   Cartier French, founded Paris, 1847   Cartier 660 French 2 1847 2047 Mounts 1650–1750; Brooch made by Cartier ca. 1930 1625 1955 Jade, inlaid with rubies, emeralds, and diamonds 47718 H. 1 in. (2.5 cm) W. 2 1/4 in. (5.7 cm) The Al-Thani Collection Made in|Made in 6 Paris 27 | 96   France 9 North India 534           Jewelry 10   Metropolitan Museum of Art, New York, NY 1
320954 SL.13.2014.1.42 0 0 458841 Islamic Art 9 Necklace 237 The Patiala Ruby Choker           Maker 1   Cartier French, founded Paris, 1847   Cartier 660 French 2 1847 2047 1931; restored and restrung to the original design by Cartier Tradition, Geneva, 2012 1906 2014 Rubies, diamonds, and pearls, with platinum mounts 47727 L. 13 1/8 in. (33.3 cm) H. 7/8 in. (2.2 cm) The Al-Thani Collection Made in|(none assigned) 12 Paris|Geneva 1844 | 96   France|Switzerland 57             Jewelry 10   Metropolitan Museum of Art, New York, NY 1
346042 89.4.107a, b 0 1 500667 Musical Instruments 18 Jinghu/Kokin 15491 Jinghu (京胡) Japanese/Chinese 6180         Maker 1   Shinsai, "Katsu" Tajima Japanese, active 1877–1888   Tajima, Shinsai, "Katsu" 47651   1877 1888 19th century 1801 1900 Bamboo, snakeskin, parchment, silk, horsehair 54004 20 1/2 × 1 7/8 × 5 1/16 in. (52.1 × 4.8 × 12.8 cm) Length (Of bow): 21 15/16 in. (55.8 cm) The Crosby Brown Collection of Musical Instruments, 1889 | 33   | 96   Japan|China 728             Chordophone-Lute-bowed-unfretted 925   Metropolitan Museum of Art, New York, NY 1
348800 1999.26 1 1 503517 Musical Instruments 18 Violin 15655 ex "Kurtz" Violin Italian (Cremona) 6542         Maker 1   Andrea Amati Italian, Cremona ca. 1505–1578 Cremona   Amati Andrea 48013 Italian 6 1505 1578 ca. 1560 1558 1565 Spruce, maple, ebony, paint, gilding 54904 Height: 22 5/8 in. (57.4 cm) Width: 7 15/16 in. (20.2 cm) Purchase, Robert Alonzo Lehman Bequest, 1999 | 33 Cremona 1178 | 96   Italy 14             Chordophone-Lute-plucked 960   Metropolitan Museum of Art, New York, NY 1
348957 2003.378 0 0 503680 Musical Instruments 18 Lira 16760 Lira Greek 777         Maker 1 possibly Küçük Izmitli Greek, İzmit, active late 19th century   Izmitli, Küçük 48071 Greek 237     ca. 1900 1875 1925 Wood, tortoiseshell 246 Height: 15 7/8 in. (40.3 cm) Width: 5 3/4 in. (14.6 cm) Purchase, Robert Alonzo Lehman Bequest, 2003 | 33   | 96   Greece|Turkey 886             Chordophone-Lute-bowed-unfretted 925   Metropolitan Museum of Art, New York, NY 1
349843 89.4.2198 0 1 504675 Musical Instruments 18 French Horn in F 17094 French Horn in F American or German 33         Maker 1   J. L. Allen?     Allen? J. L. 48312       1862–70 1862 1870 Brass, nickel-silver 54086 16 1/8 × 22 × 11 5/16 in. (41 × 55.9 × 28.7 cm) Diameter (Of bell): 11 3/16 in. (28.4 cm) The Crosby Brown Collection of Musical Instruments, 1889 | 33   | 96   United States|Germany 39             Aerophone-Lip Vibrated 1012   Metropolitan Museum of Art, New York, NY 1
351088 2010.205 0 1 506723 Musical Instruments 18 Tenor Recorder 17399 Tenor Recorder Italian or British 2646         Maker 1   Bassano workshop active 1530–1650, Venice and London   Bassano 48472 Italian 6 1530 1650 ca. 1600 1595 1605 Boxwood 7916 Height: 12 13/16 in. (32.5 cm) Purchase, Amati Gifts, 2010 | 33   | 96   Italy|United Kingdom 973             Aerophone-Whistle Flute-recorder 965   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 683.65ms · Data license: CC0 · Data source: metmuseum/openaccess