MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Artist Alpha Sort = 5457

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Title, 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 Metadata Date Repository
67046 67046 1997.465 0 0 79646 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer 5   Tina Leser American, 1910–1986   Leser Tina 5457 American 1 1910 1986 spring/summer 1948 1948 1948 silk 15101   Gift of Lenore and Elliott Sylvan, 1997                           http://www.metmuseum.org/art/collection/search/79646 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
67836 67836 1994.582.4 0 0 80562 Costume Institute 8 Blouse 5953 Blouse American 1         Designer 5   Tina Leser American, 1910–1986   Leser Tina 5457 American 1 1910 1986 1960s 1960 1969 silk 15101   Gift of Mary M. Rumsey, 1994                           http://www.metmuseum.org/art/collection/search/80562 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
67837 67837 1994.582.6a, b 0 0 80564 Costume Institute 8 Beachwear 5881 Beachwear American 1         Designer 5   Tina Leser American, 1910–1986   Leser Tina 5457 American 1 1910 1986 late 1940s 1945 1949 wool 15104   Gift of Mary M. Rumsey, 1994                           http://www.metmuseum.org/art/collection/search/80564 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
70069 70069 1988.402.1a, b 0 0 83914 Costume Institute 8 Beach cover-up 6093 Beach cover-up American 1         Designer 5   Tina Leser American, 1910–1986   Leser Tina 5457 American 1 1910 1986 late 1940s 1945 1949 cotton 3340   Gift of Mrs. John Saril, 1988                           http://www.metmuseum.org/art/collection/search/83914 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
70319 70319 2002.198.5a, b 0 0 84255 Costume Institute 8 Playsuit 5959 Playsuit American 1         Designer 5   Tina Leser American, 1910–1986   Leser Tina 5457 American 1 1910 1986 1950s 1950 1959 silk 15101   Gift of Molly Milbank, 2002                           http://www.metmuseum.org/art/collection/search/84255 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
71789 71789 C.I.55.14 0 0 86475 Costume Institute 8 Bathing suit 5913 Bathing suit American 1         Designer 5   Tina Leser American, 1910–1986   Leser Tina 5457 American 1 1910 1986 1955 1955 1955 cotton, rayon 15620   Gift of Gabar, Inc., 1955                           http://www.metmuseum.org/art/collection/search/86475 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75308 75308 1985.364.8 0 0 96611 Costume Institute 8 Blouse 5953 Blouse American 1         Designer 5   Tina Leser American, 1910–1986   Leser Tina 5457 American 1 1910 1986 1940–55 1940 1955 wool, silk 15161   Gift of Miriam Whitney Coletti, 1985                           http://www.metmuseum.org/art/collection/search/96611 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75309 75309 C.I.45.74a, b 0 0 96612 Costume Institute 8 Evening ensemble 5879 "Doves" American 1         Designer 5   Tina Leser American, 1910–1986   Leser Tina 5457 American 1 1910 1986 1945 1945 1945 [no medium available] 15100   Gift of Tina Leser, 1945                           http://www.metmuseum.org/art/collection/search/96612 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
77778 77778 1978.36.4 0 0 102806 Costume Institute 8 Necktie 5902 Necktie American 1         Designer 5   Tina Leser American, 1910–1986   Leser Tina 5457 American 1 1910 1986 1950s 1950 1959 silk 15101   Gift of Mrs. Doris E. Grossman, 1978                           http://www.metmuseum.org/art/collection/search/102806 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
89704 89704 2009.300.1038a, b 0 0 155709 Costume Institute 8 Evening ensemble 5879 Evening ensemble American 1         Designer 5   Tina Leser American, 1910–1986   Leser Tina 5457 American 1 1910 1986 ca. 1978 1976 1980 silk, synthetic 15328   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of James Howley in memory of his wife Tina Leser, 1987                           http://www.metmuseum.org/art/collection/search/155709 4/23/2018 8:00:01 AM 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 123.337ms · Data license: CC0 · Data source: metmuseum/openaccess