MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

16 rows where Country = 53

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Object Name, Title, Culture, Artist Role, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, County, 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
12430 40.84a–h 0 1 13563 American Decorative Arts 1 Curtain 1002 Curtain                             1700–1800 1700 1800 Linen, block-printed 2108 40.84a: 81 × 83 3/4 in. (205.7 × 212.7 cm); length includes 2 ½ in. tall curtain tabs 40.84b: 80 1/2 × 83 7/8 in. (204.5 × 213 cm); length includes 2 3/8 in. tall curtain tabs 40.84c: 80 1/2 × 83 3/4 in. (204.5 × 212.7 cm); length includes 2 ¼ in. tall curtain tabs 40.84d: 22 × 71 3/4 in. (55.9 × 182.2 cm); width includes 5 in. tall valance tabs 40.84e: 21 × 56 in. (53.3 × 142.2 cm); width includes 4 ½ in. tall valance tabs 40.84f: 12 × 84 1/4 in. (30.5 × 214 cm) 40.84g: 10 7/8 × 83 1/2 in. (27.6 × 212.1 cm) 40.84h: 11 × 73 in. (27.9 × 185.4 cm) Rogers Fund, 1940 Made in 1       Portugal 53             Textiles 16   Metropolitan Museum of Art, New York, NY 1
345934 89.2.160 0 1 500557 Musical Instruments 18 Cavaco 15408 Cavaco Portuguese 148                           19th century 1801 1900 Wood 25 L. 25.4 cm (10 in.); W. 8.3 cm (3-1/4 in.) Gift of Joseph W. Drexel, 1889         Portugal 53             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
346227 89.4.1033 0 1 500854 Musical Instruments 18 Guitar 15412 Guitar Portuguese 148                           19th century 1801 1900 wood, brass 17235   The Crosby Brown Collection of Musical Instruments, 1889       Madeira 880 Portugal 53             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
346819 89.4.844 0 1 501456 Musical Instruments 18 Pandeiro 15938 Pandeiro Portuguese 148                           early 19th century 1801 1825 tin 53942 Diam. of circle 8-1/2 in. The Crosby Brown Collection of Musical Instruments, 1889       Madeira 880 Portugal 53             Idiophone-Shaken-jingle 958   Metropolitan Museum of Art, New York, NY 1
346820 89.4.845 0 1 501457 Musical Instruments 18 Pandeiro 15938 Pandeiro Portuguese 148                           early 19th century 1801 1825 Metal 772 Diam. of circle 8-1/4 in., Depth 2-3/4 in. The Crosby Brown Collection of Musical Instruments, 1889       Madeira 880 Portugal 53             Idiophone-Shaken-jingle 958   Metropolitan Museum of Art, New York, NY 1
346965 89.4.996 0 0 501606 Musical Instruments 18 Set of Bones 16022 Set of Bones Portuguese 148                           19th century 1801 1900 bone, cord 54351 Longest bone 5-1/2 in., Shortest bone 4 in. The Crosby Brown Collection of Musical Instruments, 1889       Madeira 880 Portugal 53             Idiophone-Friction 991   Metropolitan Museum of Art, New York, NY 1
346984 89.4.1019 0 1 501626 Musical Instruments 18 Cittern 15413 Cittern Portuguese 148                           19th century (?) 1801 1900 Wood and various materials 53951 Total length 67 cm., Fingerboard length 28 cm., Fingerboard width--top/bottom 4.7/5.3 cm., Body length 34.5 cm. Body width--widest/narrowest 29/5 cm. Body depth--neck/foot 6.5/8.2 cm. Vibrating length of strings 42 cm., Diameter of soundhole--horizontal/vertical 6.5/6.0, Bridge height 1.8 cm. The Crosby Brown Collection of Musical Instruments, 1889       Madeira 880 Portugal 53             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
346992 89.4.1049 0 1 501636 Musical Instruments 18 Guitar 15412 Guitar Portuguese 148                           19th century 1801 1900 wood, brass 17235   The Crosby Brown Collection of Musical Instruments, 1889       Madeira? 919 Portugal 53             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
346994 89.4.1051 0 1 501638 Musical Instruments 18 Guitar 15412 Guitar Portuguese 148                           19th century 1801 1900 wood, brass, inlay 54360   The Crosby Brown Collection of Musical Instruments, 1889       Madeira 880 Portugal 53             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
347092 89.4.1169a, b 0 0 501740 Musical Instruments 18 Castanets 15873 Castanets Portugese 6380                           19th century 1801 1900 Wood 25 Length +/-6.5 cm, Width +/-4.6 cm The Crosby Brown Collection of Musical Instruments, 1889       Madeira 880 Portugal 53             Idiophone-Concussion 929   Metropolitan Museum of Art, New York, NY 1
347093 89.4.1170a, b 0 0 501741 Musical Instruments 18 Castanets 15873 Castanets Portugese 6380                           19th century 1801 1900 Wood 25 Length +/-6.5 cm, Width +/-4.8 cm The Crosby Brown Collection of Musical Instruments, 1889       Madeira 880 Portugal 53             Idiophone-Concussion 929   Metropolitan Museum of Art, New York, NY 1
348755 1996.211 0 0 503472 Musical Instruments 18 Gaita 16664 Gaita Portuguese 148                           early 20th century 1901 1925 Wood 25 L. 11.7 cm (4-2/3 in.); W. 8 cm (3-1/8 in.) Gift of H.R. Nasser, 1996         Portugal 53             Aerophone-Blow Hole-panpipe 944   Metropolitan Museum of Art, New York, NY 1
349012 89.4.2234 0 0 503738 Musical Instruments 18 Machete 16781 Machete Portuguese 148         Maker 1   Augusto Merciano da Costa     da Costa Augusto Merciano 48084       late 19th Century 1875 1899 Wood, gut 55016 26 3/4 × 7 7/8 in. (68 × 20 cm) Length (Of string): 17 in. (43.2 cm) The Crosby Brown Collection of Musical Instruments, 1889   Funchal 2308   Madeira 880 Portugal 53             Chordophone-Lute-plucked-unfretted 905   Metropolitan Museum of Art, New York, NY 1
349435 1985.408 0 1 504214 Musical Instruments 18 Mandolin 15406 Mandolin Portuguese 148         Maker 1   Joao Vieira da Silva     Silva, Joao Vieira da 48235       18th century 1740 1780 Maple?, tortoiseshell, various materials 55157 L.: 58 cm Stg L.: 34 cm Gift of Mrs. Charles Wrightsman, 1985   Lisbon 1155     Portugal 53             Chordophone-Lute-plucked 960   Metropolitan Museum of Art, New York, NY 1
413476 GB1321 .M68 1766 1 1 682011 The Libraries 20   Dialogo sobre hua nova obra no Rio Tejo ...           Author 41   Bento de Moura Portugal Portuguese, 1702–1776   Moura Portugal, Bento de 52095 Portuguese 874 1702 1776 1776 (?) 1771 1781   235 pages, [7] leaves of plates (some folded); Overall: 8 1/16 × 6 1/16 × 1 1/2 in. (20.4 × 15.4 × 3.8 cm) Gift of Jayne Wrightsman, 2008         Portugal 53             || 277   Metropolitan Museum of Art, New York, NY 1
423151 2016.246 0 1 701903 The Cloisters 17 Canopy 5748 Canopy Portuguese 148                           ca. 1402–26 1397 1426 Limestone 1737 20 7/8 × 19 1/2 × 13 3/4 in., 120 lb. (53 × 49.5 × 34.9 cm, 54.4 kg) The Cloisters Collection, 2016 Made in 1 Batalha 2535   Leiria 1110 Portugal 53             Sculpture-Architectural-Stone 852   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 146.409ms · Data license: CC0 · Data source: metmuseum/openaccess