MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

36 rows where Culture = 41 and Department = 8

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Artist Role, Artist Nationality, Object Date, Object Begin Date, Object End Date, Medium, Credit Line

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
67681 1994.327 0 1 80391 Costume Institute 8 Shawl 1281 Shawl Scottish 41                           1856 1856 1856 wool 15104   Purchase, Janet A. Sloane Gift Fund and Funds from Various Donors, 1994                           Metropolitan Museum of Art, New York, NY 1
70280 C.I.51.88.14 0 0 84207 Costume Institute 8 Brooch 131 Brooch Scottish 41                           late 19th–early 20th century 1850 1950 metal 6962   Gift of Miss Alberta Welch, 1951                           Metropolitan Museum of Art, New York, NY 1
72295 C.I.58.21.2a–k 0 0 88351 Costume Institute 8 Ensemble 5875 Ensemble Scottish 41                           ca. 1909 1904 1904 (a, b) silk, metal (c) silk, wool (d, e, g, h) wool (f) leather, metal, hair (i) silk (j) metal, glass (k) silk, metal, feather 16632   Gift of Marie Zeigler Lake, 1958                           Metropolitan Museum of Art, New York, NY 1
72296 C.I.64.42.4a–c 0 1 88353 Costume Institute 8 Ensemble 5875 Ensemble Scottish 41                           1860s 1860 1869 (a, b) silk, cotton, metal; (c) silk 16633   Gift of Madeleine Sinco Verne, 1964                           Metropolitan Museum of Art, New York, NY 1
72297 1985.154.2a–f 0 1 88355 Costume Institute 8 Ensemble 5875 Ensemble Scottish 41                           1860s 1860 1869 (a) silk, wool (b) silk, cotton (c) silk, cotton, metal (d) wood, metal, glass (e) leather, metal, hair 16634   Purchase, Irene Lewisohn Trust Gift, 1985                           Metropolitan Museum of Art, New York, NY 1
72298 1985.249a–l 0 0 88356 Costume Institute 8 Ensemble 5875 Ensemble Scottish 41                           1938–39 1938 1939 (a) silk, metal (b) wool, cotton (c, g) silk (d, e, i, j) wool (f) silk (h) leather, metal, hair (k, l) metal, glass 16635   Purchase, Irene Lewisohn Bequest, 1985                           Metropolitan Museum of Art, New York, NY 1
72400 1973.103a–u 0 0 89106 Costume Institute 8 Ensemble 5875 Ensemble Scottish 41                           1931 1931 1931 wool 15104   Gift of Mrs. Lee Bowman, 1973                           Metropolitan Museum of Art, New York, NY 1
72564 C.I.51.88.15 0 0 90143 Costume Institute 8 Ornament 656 Ornament Scottish 41                           late 19th–early 20th century 1850 1950 metal 6962   Gift of Miss Alberta Welch, 1951                           Metropolitan Museum of Art, New York, NY 1
73286 1978.582.72 0 0 91720 Costume Institute 8 Sweater 5882 Sweater Scottish 41                           1950s 1950 1959 wool 15104   Gift of Marvin B. Patterson (Mrs. Jefferson Patterson), 1978                           Metropolitan Museum of Art, New York, NY 1
74149 C.I.58.21.1a–m 0 0 94227 Costume Institute 8 Ensemble 5875 Ensemble Scottish 41                           ca. 1909 1904 1904 (a, b) silk, metal (c) wool, silk (e, g, h) wool (f) leather, metal, hair (i) silk (k) silk, metal, feather (m, n) metal 16936   Gift of Marie Zeigler Lake, 1958                           Metropolitan Museum of Art, New York, NY 1
77150 1981.264.13 0 0 100819 Costume Institute 8 Coat 4973 Coat Scottish 41                           ca. 1934 1929 1939 wool 15104   Gift of Laurie Vance Johnson, 1981                           Metropolitan Museum of Art, New York, NY 1
77904 1979.346.130a, b 0 1 103083 Costume Institute 8 Ensemble 5875 Ensemble Scottish 41                           ca. 1858 1853 1863 wool 15104   Gift of The New York Historical Society, 1979                           Metropolitan Museum of Art, New York, NY 1
78565 C.I.50.97.3 0 0 104526 Costume Institute 8 Necktie 5902 Necktie Scottish 41                           20th century 1900 1999 silk 15101   Gift of Mrs. Alexander M. Welch, 1950                           Metropolitan Museum of Art, New York, NY 1
78566 C.I.50.97.4 0 0 104527 Costume Institute 8 Necktie 5902 Necktie Scottish 41                           20th century 1900 1999 silk 15101   Gift of Mrs. Alexander M. Welch, 1950                           Metropolitan Museum of Art, New York, NY 1
82082 1975.128.11 0 0 113051 Costume Institute 8 Hat 1056 Hat Scottish 41                           ca. 1900 1895 1905 straw, silk 15933   Purchase, Irene Lewisohn Bequest, 1975                           Metropolitan Museum of Art, New York, NY 1
84076 1979.45 0 0 117047 Costume Institute 8 Evening bag 6072 Evening bag Scottish 41                           1925–27 1925 1927 glass, metal, stones, mother-of-pearl 18226   Gift of Katherine and Albert Hartog, 1979                           Metropolitan Museum of Art, New York, NY 1
86882 1977.105.4 0 1 123070 Costume Institute 8 Shawl 1281 Shawl Scottish 41                           1870s 1870 1879 wool 15104   Gift of Echo Scarfs, 1977                           Metropolitan Museum of Art, New York, NY 1
87825 C.I.50.97.2a–c 0 1 127320 Costume Institute 8 Ensemble 5875 Ensemble Scottish 41                           1800–1875 1800 1875 silk, wool 15122   Gift of Mrs. Alexander M. Welch, 1950                           Metropolitan Museum of Art, New York, NY 1
88491 2006.370 0 0 131962 Costume Institute 8 Bracelet 119 Bracelet Scottish 41                           1930s–60s 1930 1965 metal, stone 15449   Gift of Robert R. Littman, 2006                           Metropolitan Museum of Art, New York, NY 1
91124 2009.300.2326 0 1 157139 Costume Institute 8 Shawl 1281 Shawl Scottish 41                           ca. 1870 1868 1872 wool 15104   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. J. B. Putnam in memory of Amy R. Edwards, 1932                           Metropolitan Museum of Art, New York, NY 1
91141 2009.300.2341 0 1 157156 Costume Institute 8 Shawl 1281 Shawl Scottish 41                           1860–69 1860 1869 wool, cotton 15214   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Claire Lorraine Wilson, 1942                           Metropolitan Museum of Art, New York, NY 1
91164 2009.300.2362a, b 0 0 157179 Costume Institute 8 Kilt 6294 Kilt Scottish 41                           late 19th century 1851 1899 wool, leather, metal 15726   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the Y.M.C.A., 1946                           Metropolitan Museum of Art, New York, NY 1
91451 2009.300.262 0 1 157467 Costume Institute 8 Evening coat 5920 Evening coat Scottish 41         Designer 5   Henry, Darling & Company Scottish   Henry, Darling & Company 7169 Scottish 4     1880–89 1880 1889 silk, fur 15225   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Miss B. Graham, 1959                           Metropolitan Museum of Art, New York, NY 1
91863 2009.300.3010 0 1 157900 Costume Institute 8 Shawl 1281 Shawl Scottish 41                           1865–75 1865 1875 wool, silk 15161   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Catherine Courtney, 1933                           Metropolitan Museum of Art, New York, NY 1
93203 2009.300.852a–f 0 0 159429 Costume Institute 8 Ensemble 5875 Ensemble Scottish 41         Designer|Designer 85   Dorothea Knitting Mills, Limited|R. W. Forsyth, Ltd.     Dorothea Knitting Mills, Limited|Forsyth, Ltd. R. W. 7441 Scottish 4     1944–46 1944 1946 wool, metal, leather 16291   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Gypsy Rose Lee, 1961                           Metropolitan Museum of Art, New York, NY 1
93607 2009.300.4034 0 1 168295 Costume Institute 8 Shawl 1281 Shawl Scottish 41                           1860–80 1860 1880 Wool 2116   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Robert B. Woodward Memorial Fund, 1921                           Metropolitan Museum of Art, New York, NY 1
93608 2009.300.4035 0 1 168296 Costume Institute 8 Shawl 1281 Shawl Scottish 41                           third quarter 19th century 1851 1875 Wool 2116   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Robert B. Woodward Memorial Fund, 1921                           Metropolitan Museum of Art, New York, NY 1
94169 2009.300.4647 0 0 168857 Costume Institute 8 Bib 6319 Bib Scottish 41                           ca. 1900 1898 1902 Cotton 2154   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Merle Munn, 1951                           Metropolitan Museum of Art, New York, NY 1
94838 2009.300.5309 0 1 169526 Costume Institute 8 Shawl 1281 Shawl Scottish 41                           1846 1846 1846 Wool 2116   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mae Schenck, 1963                           Metropolitan Museum of Art, New York, NY 1
95194 2009.300.5670 0 1 169882 Costume Institute 8 Shawl 1281 Shawl Scottish 41                           1850–59 1850 1859 Wool 2116   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Gunnar Maske, 1969                           Metropolitan Museum of Art, New York, NY 1
95282 2009.300.5766 0 1 169970 Costume Institute 8 Collar 1038 Collar Scottish 41                           ca. 1845 1843 1847 Silk 165   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jean Douglas, 1970                           Metropolitan Museum of Art, New York, NY 1
95283 2009.300.5767 0 1 169971 Costume Institute 8 Chemisette 6274 Chemisette Scottish 41                           ca. 1845 1843 1847 Cotton 2154   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jean Douglas, 1970                           Metropolitan Museum of Art, New York, NY 1
95284 2009.300.5768 0 1 169972 Costume Institute 8 Chemisette 6274 Chemisette Scottish 41                           ca. 1845 1843 1847 Cotton 2154   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jean Douglas, 1970                           Metropolitan Museum of Art, New York, NY 1
95861 2009.300.4367 0 1 170549 Costume Institute 8 Shawl 1281 Shawl Scottish 41                           1850–57 1850 1857 Wool 2116   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Claire Lorraine Wilson, 1942                           Metropolitan Museum of Art, New York, NY 1
97053 2009.300.7340a–c 0 0 174432 Costume Institute 8 Ensemble 5875 Ensemble Scottish 41         Retailer 8   Saks Fifth Avenue American, founded 1924   Saks Fifth Avenue 5336 American 1 1924 9999 ca. 1950 1948 1952 Wool 2116   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Adelaide Goan, 1964                           Metropolitan Museum of Art, New York, NY 1
97199 2009.300.7525a, b 0 0 174578 Costume Institute 8 Sweater set 6666 Sweater set Scottish 41         Designer 5 Attributed to Mainbocher American, 1890–1976   Mainbocher 5498 American 1 1890 1976 ca. 1948 1946 1950 Wool, synthetic 19886   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Edith d'Errecalde, 1967                           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 168.185ms · Data license: CC0 · Data source: metmuseum/openaccess