MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

41 rows where "Artist End Date" is on date -4707-05-16 and Culture = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Title, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, 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
70436 70436 1985.275.4 0 0 84395 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1965–75 1965 1975 silk (?) or silk blend 16223   Gift of Barbaralee Diamonstein-Spielvogel, 1985                           http://www.metmuseum.org/art/collection/search/84395 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72305 72305 C.I.69.37.25 0 0 88444 Costume Institute 8 Scarf 1153 Scarf British 6         Designer 5   Henry Moore 20th century   Moore Henry 6065 British 7 1900 2000 1950–69 1950 1969 silk 15101   Gift of Mr. and Mrs. Burton Tremaine, 1969                           http://www.metmuseum.org/art/collection/search/88444 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
73838 73838 1978.582.217 0 0 92412 Costume Institute 8 Scarf 1153 Scarf British 6         Designer 5   Henry Moore 20th century   Moore Henry 6065 British 7 1900 2000 1940s 1940 1949 silk 15101   Gift of Marvin B. Patterson (Mrs. Jefferson Patterson)                           http://www.metmuseum.org/art/collection/search/92412 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75647 75647 1974.384.20 0 0 97108 Costume Institute 8 Evening coat 5920 Evening coat British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1965–69 1965 1969 wool, silk 15161   Gift of Jane Holzer, 1974                           http://www.metmuseum.org/art/collection/search/97108 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75648 75648 1977.115.4a, b 0 0 97109 Costume Institute 8 Evening ensemble 5879 Evening ensemble British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1970–75 1970 1975 cotton, synthetics, gilt, silk 17159   Gift of Jane Holzer, 1977                           http://www.metmuseum.org/art/collection/search/97109 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75649 75649 1977.200a, b 0 0 97110 Costume Institute 8 Cocktail Dress 5933 Cocktail dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1972–73 1972 1973 silk, synthetics 15195   Gift of Mrs. Leonard S. Field, 1977                           http://www.metmuseum.org/art/collection/search/97110 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75650 75650 1980.586.15 0 0 97111 Costume Institute 8 Evening coat 5920 Evening coat British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1969 1964 1974 cotton, fur 16919   Gift of Jane Holzer, 1980                           http://www.metmuseum.org/art/collection/search/97111 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75652 75652 1982.81a–c 0 0 97113 Costume Institute 8 Evening ensemble 5879 Evening ensemble British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1972 1972 1972 silk 15101   Gift of Mrs. Leonard S. Field, 1982                           http://www.metmuseum.org/art/collection/search/97113 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75653 75653 1983.400.1 0 0 97114 Costume Institute 8 Coat 4973 Coat British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1969 1964 1974 wool, fur 15216   Gift of Jane Holzer, 1983                           http://www.metmuseum.org/art/collection/search/97114 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75654 75654 1983.400.3 0 0 97115 Costume Institute 8 Skirt 1152 Skirt British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1969 1964 1974 cotton, silk 15395   Gift of Jane Holzer, 1983                           http://www.metmuseum.org/art/collection/search/97115 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75660 75660 1973.136.1 0 0 97122 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1969 1969 1969 silk 15101   Gift of Mrs. David K.E. Bruce, 1973                           http://www.metmuseum.org/art/collection/search/97122 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75661 75661 1973.136.2 0 0 97123 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1970 1970 1970 [no medium available] 15100   Gift of Mrs. David K.E. Bruce, 1973                           http://www.metmuseum.org/art/collection/search/97123 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75662 75662 1973.136.3a, b 0 0 97124 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1969 1969 1969 [no medium available] 15100   Gift of Mrs. David K.E. Bruce, 1973                           http://www.metmuseum.org/art/collection/search/97124 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75663 75663 1974.55.2a, b 0 0 97125 Costume Institute 8 Evening dress 5874 Evening dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 fall/winter 1972–73 1972 1973 silk 15101   Gift of Mrs. Leonard S. Field, 1974                           http://www.metmuseum.org/art/collection/search/97125 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75664 75664 1976.125a, b 0 0 97126 Costume Institute 8 Evening dress 5874 Evening dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1970 1965 1975 silk 15101   Gift of Mrs. Leonard S. Field, 1976                           http://www.metmuseum.org/art/collection/search/97126 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75665 75665 1977.115.2a–c 0 0 97127 Costume Institute 8 Evening ensemble 5879 Evening ensemble British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1970–75 1970 1975 synthetics, silk, metallic 17162   Gift of Jane Holzer, 1977                           http://www.metmuseum.org/art/collection/search/97127 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75666 75666 1977.115.3a, b 0 0 97128 Costume Institute 8 Evening ensemble 5879 Evening ensemble British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1970–75 1970 1975 synthetics, silk 15309   Gift of Jane Holzer, 1977                           http://www.metmuseum.org/art/collection/search/97128 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75667 75667 1977.115.5 0 0 97129 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1970 1965 1975 wool, snakeskin 17163   Gift of Jane Holzer, 1977                           http://www.metmuseum.org/art/collection/search/97129 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75668 75668 1977.115.6 0 0 97130 Costume Institute 8 Evening dress 5874 Evening dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1970–73 1970 1973 silk 15101   Gift of Jane Holzer, 1977                           http://www.metmuseum.org/art/collection/search/97130 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75669 75669 1977.115.7 0 0 97131 Costume Institute 8 Evening dress 5874 Evening dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1970–73 1970 1973 synthetics 15103   Gift of Jane Holzer, 1977                           http://www.metmuseum.org/art/collection/search/97131 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75670 75670 1979.149 0 0 97132 Costume Institute 8 Evening dress 5874 Evening dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1969 1964 1974 silk, rayon, metallic thread 17164   Gift of Mrs. Leonard S. Field, 1979                           http://www.metmuseum.org/art/collection/search/97132 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75671 75671 1979.435.31 0 0 97133 Costume Institute 8 Caftan 5929 Caftan British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1969–73 1969 1973 rayon, metallic thread 17165   Gift of Diana Vreeland, 1979                           http://www.metmuseum.org/art/collection/search/97133 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75672 75672 1980.124.1a, b 0 0 97134 Costume Institute 8 Evening dress 5874 Evening dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1970s 1970 1979 silk, plastic, metallic thread 17166   Gift of Eleanor Lambert Berkson, 1980                           http://www.metmuseum.org/art/collection/search/97134 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75673 75673 1980.586.11a–c 0 0 97135 Costume Institute 8 Evening ensemble 5879 Evening ensemble British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1969 1964 1974 silk, cotton 15149   Gift of Jane Holzer, 1980                           http://www.metmuseum.org/art/collection/search/97135 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75674 75674 1980.586.12 0 0 97136 Costume Institute 8 Nehru jacket 6299 Nehru jacket British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1968 1963 1973 silk, metal 15118   Gift of Jane Holzer, 1980                           http://www.metmuseum.org/art/collection/search/97136 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
75675 75675 1980.586.4 0 0 97137 Costume Institute 8 Skirt 1152 Skirt British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1970 1965 1975 wool 15104   Gift of Jane Holzer, 1980                           http://www.metmuseum.org/art/collection/search/97137 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
87939 87939 2005.412.4 0 0 127641 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 last quarter 20th century 1975 1999 silk, metallic, cotton, metal 18683   Gift of Jane B. Holzer, 2005                           http://www.metmuseum.org/art/collection/search/127641 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
93342 93342 2009.300.978 0 0 159568 Costume Institute 8 Evening dress 5874 Evening dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1972 1970 1974 synthetic 15169   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Stanley Mortimer, 1976                           http://www.metmuseum.org/art/collection/search/159568 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95347 95347 2009.300.5830 0 0 170035 Costume Institute 8 Necklace 237 Necklace British 6         Designer 5 Possibly Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1970 1968 1972 Leather, feather, wood 20100   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Stanley Mortimer, 1972                           http://www.metmuseum.org/art/collection/search/170035 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95363 95363 2009.300.5846 0 0 170051 Costume Institute 8 Choker 6272 Choker British 6         Designer 5 Possibly Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1979 1977 1981 Synthetic, glass, beads, shell 20104   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Stanley Mortimer, 1974                           http://www.metmuseum.org/art/collection/search/170051 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
95430 95430 2009.300.5922 0 0 170118 Costume Institute 8 Shoulder bag 6094 Shoulder bag British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1965 1963 1967 Jute, wool, silk 20115   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Stanley Mortimer, 1982                           http://www.metmuseum.org/art/collection/search/170118 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
97469 97469 2009.300.7817 0 0 174848 Costume Institute 8 Evening jumpsuit 6182 Evening jumpsuit British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1970 1968 1972 Silk 165   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Stanley Mortimer, 1972                           http://www.metmuseum.org/art/collection/search/174848 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
97562 97562 2009.300.7918 0 0 174942 Costume Institute 8 Cocktail dress 6005 Cocktail dress British 6         Designer 5 Attributed to Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1972 1970 1974 Cotton (?) 20358   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Stanley Mortimer, 1976                           http://www.metmuseum.org/art/collection/search/174942 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
97564 97564 2009.300.7920 0 0 174944 Costume Institute 8 Evening dress 5874 Evening dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 1972 1972 1972 Silk  13944   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Stanley Mortimer, 1976                           http://www.metmuseum.org/art/collection/search/174944 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
97574 97574 2009.300.7930 0 0 174954 Costume Institute 8 Cocktail dress 6005 Cocktail dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1970 1968 1972 Silk 165   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jane Holzer, 1977                           http://www.metmuseum.org/art/collection/search/174954 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
97577 97577 2009.300.7933a, b 0 0 174957 Costume Institute 8 Evening ensemble 5879 Evening ensemble British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1968 1964 1970 Cotton 2154   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jane Holzer, 1977                           http://www.metmuseum.org/art/collection/search/174957 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
97635 97635 2009.300.7991 0 0 175015 Costume Institute 8 Evening cape 5919 Evening cape British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1976 1974 1978 Silk 165   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Stanley Mortimer, 1980                           http://www.metmuseum.org/art/collection/search/175015 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
97679 97679 2009.300.8035 0 0 175060 Costume Institute 8 Evening dress 5874 Evening dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1970 1968 1972 Silk  13944   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Stanley Mortimer, 1982                           http://www.metmuseum.org/art/collection/search/175060 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
97880 97880 2009.300.8243 0 0 175261 Costume Institute 8 Dressing Gown 6017 Dressing Gown British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1975 1973 1977 Silk 165   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jane Holzer, 1986                           http://www.metmuseum.org/art/collection/search/175261 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
97881 97881 2009.300.8244a–d 0 0 175262 Costume Institute 8 Evening ensemble 5879 Evening ensemble British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1975 1973 1977 Silk 165   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jane Holzer, 1986                           http://www.metmuseum.org/art/collection/search/175262 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
97882 97882 2009.300.8245 0 0 175263 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   Thea Porter British, Jerusalem 1927–2000 London   Porter Thea 5938 British 7 1927 2000 ca. 1968 1966 1970 Cotton 2154   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Jane Holzer, 1986                           http://www.metmuseum.org/art/collection/search/175263 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 1932.869ms · Data license: CC0 · Data source: metmuseum/openaccess