MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

51 rows where Culture = 59 and Object Begin Date = 1800

View and edit SQL

Suggested facets: Credit Line, Classification

Object Begin Date

  • 1800 · 51
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
133771 36.90.2160 0 0 225239 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899   Overall (confirmed): 1/2 × 4 3/4 in. (1.3 × 12.1 cm) Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133772 36.90.2161 0 0 225240 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899   Overall (confirmed): 7/16 × 7 1/8 in. (1.1 × 18.1 cm) Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133773 36.90.2162 0 0 225241 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133774 36.90.2163 0 0 225242 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133775 36.90.2164 0 0 225243 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133776 36.90.2165 0 0 225244 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133777 36.90.2166 0 0 225245 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133778 36.90.2167 0 0 225246 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133779 36.90.2168 0 0 225247 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133780 36.90.2169 0 0 225248 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133781 36.90.2170 0 0 225249 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133782 36.90.2171 0 0 225250 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133783 36.90.2172 0 0 225251 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133784 36.90.2173 0 0 225252 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133785 36.90.2174 0 0 225253 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133786 36.90.2175 0 0 225254 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133787 36.90.2176 0 0 225255 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133788 36.90.2177 0 0 225256 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133789 36.90.2178 0 0 225257 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133790 36.90.2179 0 0 225258 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133791 36.90.2180 0 0 225259 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133792 36.90.2181 0 0 225260 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133793 36.90.2182 0 0 225261 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133794 36.90.2183 0 0 225262 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133795 36.90.2184 0 0 225263 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133796 36.90.2185 0 0 225264 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133797 36.90.2186 0 0 225265 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133798 36.90.2187 0 0 225266 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133799 36.90.2188 0 0 225267 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133800 36.90.2189 0 0 225268 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133801 36.90.2190 0 0 225269 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133802 36.90.2191 0 0 225270 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133803 36.90.2192 0 0 225271 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133804 36.90.2193 0 0 225272 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133805 36.90.2194 0 0 225273 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133806 36.90.2195 0 0 225274 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133807 36.90.2196 0 0 225275 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133808 36.90.2197 0 0 225276 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133809 36.90.2198 0 0 225277 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133810 36.90.2199 0 0 225278 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133811 36.90.2200 0 0 225279 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133812 36.90.2201 0 0 225280 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133813 36.90.2202 0 0 225281 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133814 36.90.2203 0 0 225282 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133815 36.90.2204 0 0 225283 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133816 36.90.2205 0 0 225284 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133817 36.90.2206 0 0 225285 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133818 36.90.2207 0 0 225286 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133819 36.90.2208 0 0 225287 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
133820 36.90.2209 0 0 225288 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899     Gift of The United Piece Dye Works, 1936                       Textiles-Trimmings 380   Metropolitan Museum of Art, New York, NY 1
138947 X.552 0 0 230923 European Sculpture and Decorative Arts 3 Piece 1049 Piece French or British 59                           19th century 1800 1899 Silk 165 85 x 21 1/2 inches (215.9 x 54.6 cm) Museum Accession                       Textiles-Woven 191   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 147.463ms · Data license: CC0 · Data source: metmuseum/openaccess