MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where City = 1363

View and edit SQL

Suggested facets: Is Highlight, Department, Culture, Artist Role, Medium, Country

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
222695 31.24 0 1 350256 Drawings and Prints 11 Book 97 Nouveau Recueil d'Ostéologie et de Myologie           Artist|Publisher 710 Published by Jacques Gamelin|Desclassan French, Carcassonne 1738–1803 Carcassonne , Toulouse Gamelin, Jacques|Desclassan 24861 French|French 21 1738 1803 1779 1779 1779     Harris Brisbane Dick Fund, 1931   Toulouse 1363                   Books 442   Metropolitan Museum of Art, New York, NY 1
324629 17.190.361 1 1 464341 Medieval Art 6 Reliquary statuette 14707 Reliquary Statuette of Saint Christopher French 7                           ca. 1375–1425 1375 1425 Silver, silver-gilt 22415 Overall: 23 7/8 x 11 5/8 x 7 13/16 in. (60.6 x 29.5 x 19.8 cm) Gift of J. Pierpont Morgan, 1917 Made in 1 Toulouse 1363                   Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
326038 1976.160 0 1 465983 Medieval Art 6 Statue head 14770 Head of a Youth French 7                           ca. 1100–1120 1100 1120 Marble 750 Overall: 8 7/16 x 6 7/16 x 4 5/8 in. (21.4 x 16.4 x 11.7 cm) Pin: 2 1/2 x 1/2 in. (6.4 x 1.3 cm) weight: 13lb. (5.9kg) Gift of Ella Brummer, in memory of Ernest Brummer, 1976 Made in 1 Toulouse 1363     France 9             Sculpture-Stone 806   Metropolitan Museum of Art, New York, NY 1
326379 21.172.1 0 1 466332 Medieval Art 6 Column 255 Column Frankish 1063                           5th–6th century 400 599 Marble 750 Overall: 74 1/4 x 17 1/2 x 17 3/4 in. (188.6 x 44.5 x 45.1 cm) Purchase, Rogers Fund, and Henry Walters and George Blumenthal Gifts, 1921 Made in 1 Toulouse 1363     Southern France 574             Sculpture-Architectural 336   Metropolitan Museum of Art, New York, NY 1
347253 89.4.1345 0 1 501911 Musical Instruments 18 Treble Viol 16000 Treble Viol French 7         Maker 1   Cabroly Italian (active France), Toulouse, France, active ca. 1730–1749   Cabroly 47804 Italian (active France) 3499 1730 1749 1730 1730 1730 Wood 25 Height: 13 7/8 in. (35.3 cm) Width (Lower bout): 8 18/ in. (20.7 cm) Depth (Center bout rib height): 2 13/16 in. (7.2 cm) The Crosby Brown Collection of Musical Instruments, 1889   Toulouse 1363     France 9             Chordophone-Lute-bowed-fretted 951   Metropolitan Museum of Art, New York, NY 1
350758 2007.323 0 1 505742 Musical Instruments 18 Harp Guitar 16029 Harp Guitar French 7         Maker 1   Joseph Laurent Mast French, Mirecourt 1779–after 1830 Toulouse   Mast, Joseph Laurent 48434 French 2 1779 1830 1827 1827 1827 Spruce, maple, iron, nickel silver 55519 Height: 88.5 cm (34- 13/16 in.) Purchase, Frederick M. Lehman Bequest, 2007   Toulouse 1363     France 9             Chordophone-Lute-plucked-fretted 921   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 116.56ms · Data license: CC0 · Data source: metmuseum/openaccess