MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Culture = 33

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Artist Role, Object Date, Object End Date, Medium, Credit Line, Geography Type, Country, Classification

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
3076 1980.466 0 0 3294 American Decorative Arts 1 Dish 110 Dish American or German 33         Decorator|Maker 36   Caroline Marie Gleason|R. C.     Gleason, Caroline Marie|R. C. 485 German 10   9999 |9999 ca. 1906 1903 1906 Porcelain, overglaze enamel decoration and gilding 666 H. 1 5/8 in. (4.1 cm); Diam. 6 1/4 in. (15.9 cm) Gift of Mary Louise Chorles, 1980 Made in|Made in 6 Cincinnati 41     United States|Germany 39             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4548 1986.307.9 0 0 4902 American Decorative Arts 1 Plate 356 Plate American or German 33         Decorator|Manufacturer 21 Manufactured by Olga St. John|Rosenthal German, Selb, Germany, 1876–1920   St. John, Olga|Rosenthal 664 German 10 1876 9999 |1920 ca. 1900 1900 1900 Porcelain, overglaze enamel decoration 224 H. 1 in. (2.5 cm); Diam. 8 1/2 in. (21.6 cm) Purchase, Friends of the American Wing Fund and Anonymous Gift, 1986 Made in|Made in 6 Albany 40     United States|Germany 39             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
4754 83.2.379 0 1 5111 American Decorative Arts 1 Medal 148 Medal of Captain Isaac Hull American or German 33         Maker 1   Johann Christian Reich German, Eisenberg 1740–1814 Fürth   Reich, Johann Christian 702 German 10 1740 1814 1800–1830 1800 1830 Bronze 23 Diam. 2 1/2 in. (6.4 cm) Gift of William H. Huntington, 1883 Possibly made in|Possibly made in 3       United States|Germany 39             Metal 1   Metropolitan Museum of Art, New York, NY 1
8135 30.120.123 0 1 8766 American Decorative Arts 1 Toy kitchen 918 Toy Kitchen American or German 33                           1830–80 1830 1880 Wood, metal, ceramics 1282 17 x 29 x 13 7/8 in. (43.2 x 73.7 x 35.2 cm) The Sylmaris Collection, Gift of George Coe Graves, 1930 Possibly made in|Possibly made in 3       United States|Germany 39             Natural Substances 6   Metropolitan Museum of Art, New York, NY 1
349104 89.4.2298 0 1 503843 Musical Instruments 18 Baritone Horn in B-flat 16827 Baritone Horn in B-flat American or German 33                           mid-19th century 1855 1875 Brass, nickel-silver 54086 Height: 36 in (91.5 cm) Diameter (Of bell): 8 3/4 in. (22.3 cm) The Crosby Brown Collection of Musical Instruments, 1889 | 33   | 96   United States|Germany 39             Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
349621 1989.330.83 0 0 504410 Musical Instruments 18 Pitch Pipe 15975 Pitch Pipe American or German 33                           ca. 1900 1895 1905 Metal 772   Purchase, Kay T. Krechmer Gift, in memory of her husband, Harold Krechmer; Gifts of Mr. and Mrs. Robert P. Freedman and Dr. Irven Paul, by exchange; and funds from various donors, 1989 | 33   | 96   United States|Germany 39             Accessory 256   Metropolitan Museum of Art, New York, NY 1
349817 89.4.2184 0 1 504636 Musical Instruments 18 Alto Saxhorn in E-flat 16829 Alto Saxhorn in E-flat American or German 33                           1850–75 1850 1875 Brass 12 L.: 595 mm (23-1/2 in.); Diam. of bell: 178 mm (7 in.); Diam. of bore: 12 mm (1/2 in.) The Crosby Brown Collection of Musical Instruments, 1889         United States or Germany 923             Aerophone-Lip Vibrated 1012   Metropolitan Museum of Art, New York, NY 1
349843 89.4.2198 0 1 504675 Musical Instruments 18 French Horn in F 17094 French Horn in F American or German 33         Maker 1   J. L. Allen?     Allen? J. L. 48312       1862–70 1862 1870 Brass, nickel-silver 54086 16 1/8 × 22 × 11 5/16 in. (41 × 55.9 × 28.7 cm) Diameter (Of bell): 11 3/16 in. (28.4 cm) The Crosby Brown Collection of Musical Instruments, 1889 | 33   | 96   United States|Germany 39             Aerophone-Lip Vibrated 1012   Metropolitan Museum of Art, New York, NY 1
349857 89.4.2312 0 0 504689 Musical Instruments 18 Baritone Horn in B-flat 16827 Baritone Horn in B-flat American or German 33                           1875–1900 1875 1900 Brass, nickel-silver 54086 Length: 62 cm (24-1/2 in.); Diam. of bell: 20.5 cm (8-1/8 in.) The Crosby Brown Collection of Musical Instruments, 1889 | 33   | 96   United States|Germany 39             Aerophone-Lip Vibrated-horn 912   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 149.749ms · Data license: CC0 · Data source: metmuseum/openaccess