MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

17 rows where Artist Alpha Sort = 7188

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Artist Prefix, Artist Display Bio, 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
91608 2009.300.2763 0 0 157626 Costume Institute 8 Corset 5923 Corset American 1         Manufacturer 20   Royal Worcester Corset Company American, 1901–1949   Royal Worcester Corset Company 7188 American 1 1861 1950 1917–19 1917 1919 cotton, bone, metal, elastic 19536   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E.A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
91968 2009.300.3104a–c 0 0 158005 Costume Institute 8 Corset 5923 Corset probably American 40         Manufacturer 20 Attributed to Royal Worcester Corset Company American, 1861–1950   Royal Worcester Corset Company 7188 American 1 1861 1950 ca. 1871 1869 1873 cotton, metal, bone 19562   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E. A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
91980 2009.300.3115a–c 0 0 158017 Costume Institute 8 Corset 5923 Corset American 1         Manufacturer 20 Attributed to Royal Worcester Corset Company American, 1861–1950   Royal Worcester Corset Company 7188 American 1 1861 1950 ca. 1890 1888 1892 silk, bone, metal, cotton 19577   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E.A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
91987 2009.300.3122a–g 0 0 158024 Costume Institute 8 Corset 5923 Corset American 1         Manufacturer 20 Attributed to Royal Worcester Corset Company American, 1861–1950   Royal Worcester Corset Company 7188 American 1 1861 1950 ca. 1902 1900 1904 cotton, elastic, bone, metal 19580   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E.A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
91992 2009.300.3127a–c 0 0 158029 Costume Institute 8 Waist Cincher 5947 Waist cincher American 1         Manufacturer 20 Attributed to Royal Worcester Corset Company American, 1861–1950   Royal Worcester Corset Company 7188 American 1 1861 1950 ca. 1939 1937 1941 silk, metal 15118   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E.A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
96444 2009.300.6637a, b 0 1 173651 Costume Institute 8 Corset 5923 Corset American 1         Manufacturer 20   Royal Worcester Corset Company American, 1861–1950   Royal Worcester Corset Company 7188 American 1 1861 1950 ca. 1870 1868 1872 Cotton, metal, bone 20256   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E. A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
96445 2009.300.6638a, b 0 1 173652 Costume Institute 8 Corset 5923 Corset American 1         Manufacturer 20   Royal Worcester Corset Company American, 1861–1950   Royal Worcester Corset Company 7188 American 1 1861 1950 ca. 1872 1870 1874 Cotton, metal, bone 20256   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E. A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
96451 2009.300.6651a, b 0 0 173658 Costume Institute 8 Waist cincher 6734 Waist cincher American 1         Manufacturer 20 Possibly Royal Worcester Corset Company American, 1861–1950   Royal Worcester Corset Company 7188 American 1 1861 1950 ca. 1900 1898 1902 Cotton, metal, bone 20256   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E.A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
96453 2009.300.6653a, b 0 0 173660 Costume Institute 8 Waist cincher 6734 Waist cincher American 1         Manufacturer 20 Possibly Royal Worcester Corset Company American, 1861–1950   Royal Worcester Corset Company 7188 American 1 1861 1950 ca. 1903 1901 1905 Cotton, metal, silk, bone 20259   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E.A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
96456 2009.300.6656a, b 0 0 173663 Costume Institute 8 Corset 5923 Corset American 1         Manufacturer 20   Royal Worcester Corset Company American, 1901–1949   Royal Worcester Corset Company 7188 American 1 1861 1950 1917–19 1917 1919 Cotton, bone, metal, elastic 20260   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E.A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
96459 2009.300.6659a, b 0 0 173666 Costume Institute 8 Corset 5923 Corset American 1         Manufacturer 20   Royal Worcester Corset Company American, 1901–1949   Royal Worcester Corset Company 7188 American 1 1861 1950 ca. 1917 1915 1919 Cotton, bone, metal, elastic 20260   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E.A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
96460 2009.300.6660a, b 0 0 173667 Costume Institute 8 Corset 5923 Corset American 1         Manufacturer 20   Royal Worcester Corset Company American, 1901–1949   Royal Worcester Corset Company 7188 American 1 1861 1950 1917 1917 1917 Cotton, bone, metal, elastic 20260   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E.A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
96463 2009.300.6663 0 0 173670 Costume Institute 8 Girdle 5946 Girdle American 1         Manufacturer 20   Royal Worcester Corset Company American, 1901–1949   Royal Worcester Corset Company 7188 American 1 1861 1950 1920–25 1920 1925 Cotton, metal, elastic, bone 20262   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E.A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
96464 2009.300.6664 0 0 173671 Costume Institute 8 Corselet 6422 Corselet American 1         Manufacturer 20   Royal Worcester Corset Company American, 1901–1949   Royal Worcester Corset Company 7188 American 1 1861 1950 1924–25 1924 1925 Cotton, bone, metal, elastic 20260   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E.A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
96465 2009.300.6665a–c 0 0 173672 Costume Institute 8 Corselet 6422 Corselet American 1         Manufacturer 20   Royal Worcester Corset Company American, 1901–1949   Royal Worcester Corset Company 7188 American 1 1861 1950 ca. 1925 1923 1927 Cotton, bone, metal, elastic, synthetic 20263   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E.A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
96467 2009.300.6667a, b 0 0 173674 Costume Institute 8 Waist cincher 6734 Waist cincher American 1         Manufacturer 20 Probably Royal Worcester Corset Company American, 1861–1950   Royal Worcester Corset Company 7188 American 1 1861 1950 ca. 1939 1937 1941 Synthetic, silk 19864   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E.A. Meister, 1950                           Metropolitan Museum of Art, New York, NY 1
98209 2009.300.6636a, b 0 1 175653 Costume Institute 8 Corset 5923 Corset American 1         Manufacturer 20 Probably Royal Worcester Corset Company American, 1861–1950   Royal Worcester Corset Company 7188 American 1 1861 1950 ca. 1872 1870 1874 Cotton, bone 20257   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of E. A. Meister, 1950                           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 194.652ms · Data license: CC0 · Data source: metmuseum/openaccess