MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

13 rows where "Artist End Date" is on date -4707-03-15 and Culture = 6

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, 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
103100 08.53.26 0 1 190642 European Sculpture and Decorative Arts 3 Medal 148 In Memory of the visit of King Christian IX and Queen Louisa of Denmark to the City of London, July 8, 1893 British 6         Artist 2 Medalist: Frank Bowcher British, London 1864–1938 London   BOWCHER FRANK 8593 British 7 1864 1938 1893 1893 1893 Gilt bronze, struck 20531 Diameter: 3 in. (7.6 cm) Gift of the Corporation of the City of London, 1908                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
103101 08.53.27 0 1 190643 European Sculpture and Decorative Arts 3 Medal 148 Opening of the Tower Bridge, June 30, 1894 British 6         Artist 2 Medalist: Frank Bowcher British, London 1864–1938 London   BOWCHER FRANK 8593 British 7 1864 1938 19th century 1800 1899 Bronze, struck 20482 Diameter: 3 in. (7.6 cm) Gift of the Corporation of the City of London, 1908                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
103102 08.53.28 0 1 190644 European Sculpture and Decorative Arts 3 Medal 148 Struck by order of the City of London in Honor of Queen Victoria's Diamond Jubilee, 1897 British 6         Artist 2 Medalist: Frank Bowcher British, London 1864–1938 London   BOWCHER FRANK 8593 British 7 1864 1938 1887 1887 1887 Bronze, struck 20482 Diameter: 3 in. (7.6 cm) Gift of the Corporation of the City of London, 1908                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
107222 24.189.1 0 1 195167 European Sculpture and Decorative Arts 3 Medal 148 Commemorating the rulers of the Baroda State, Malharrao, Gaekwar (1871–75) (one of a set of eight) British 6         Artist 2 Medalist: Frank Bowcher British, London 1864–1938 London   BOWCHER FRANK 8593 British 7 1864 1938 20th century 1900 1999 Bronze, struck 20482 3 × 2 in. (7.6 × 5.1 cm) Gift of H.H. Sir Sayaji Rao, G.C.S.I., Maharaja Gaekwar of Baroda, 1924                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
107223 24.189.2 0 1 195168 European Sculpture and Decorative Arts 3 Medal 148 Commemorating rulers of the Baroda State, Anandrao, Gaekwar (1801–20) (one of a set of eight) British 6         Artist 2 Medalist: Frank Bowcher British, London 1864–1938 London   BOWCHER FRANK 8593 British 7 1864 1938 20th century 1900 1999 Bronze, struck 20482 3 × 2 in. (7.6 × 5.1 cm) Gift of H.H. Sir Sayaji Rao, G.C.S.I., Maharaja Gaekwar of Baroda, 1924                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
107224 24.189.3 0 1 195169 European Sculpture and Decorative Arts 3 Medal 148 Commemorating the rulers of the Baroda State, Ganpatrao, Gaekwar (1848–57) (one of a set of eight) British 6         Artist 2 Medalist: Frank Bowcher British, London 1864–1938 London   BOWCHER FRANK 8593 British 7 1864 1938 20th century 1900 1999 Bronze, struck 20482 3 × 2 in. (7.6 × 5.1 cm) Gift of H.H. Sir Sayaji Rao, G.C.S.I., Maharaja Gaekwar of Baroda, 1924                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
107225 24.189.4 0 1 195170 European Sculpture and Decorative Arts 3 Medal 148 Commemorating the rulers of the Baroda State, Fatehsingrao, Regent, (1807–19) (one of a set of eight) British 6         Artist 2 Medalist: Frank Bowcher British, London 1864–1938 London   BOWCHER FRANK 8593 British 7 1864 1938 20th century 1900 1999 Bronze, struck 20482 3 × 2 in. (7.6 × 5.1 cm) Gift of H.H. Sir Sayaji Rao, G.C.S.I., Maharaja Gaekwar of Baroda, 1924                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
107226 24.189.5 0 1 195171 European Sculpture and Decorative Arts 3 Medal 148 Commemorating the rulers of the Baroda State, Sayaji Rao, Gaekwar, (1820–48) (one of a set of eight) British 6         Artist 2 Medalist: Frank Bowcher British, London 1864–1938 London   BOWCHER FRANK 8593 British 7 1864 1938 20th century 1900 1999 Bronze, struck 20482 3 × 2 in. (7.6 × 5.1 cm) Gift of H.H. Sir Sayaji Rao, G.C.S.I., Maharaja Gaekwar of Baroda, 1924                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
107227 24.189.6 0 1 195172 European Sculpture and Decorative Arts 3 Medal 148 Commemorating the rulers of the Baroda State, Khanderao, Gaekwar, (1857–71) (one of a set of eight) British 6         Artist 2 Medalist: Frank Bowcher British, London 1864–1938 London   BOWCHER FRANK 8593 British 7 1864 1938 20th century 1900 1999 Bronze, struck 20482 3 × 2 in. (7.6 × 5.1 cm) Gift of H.H. Sir Sayaji Rao, G.C.S.I., Maharaja Gaekwar of Baroda, 1924                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
107228 24.189.7 0 1 195173 European Sculpture and Decorative Arts 3 Medal 148 Commemorating the rulers of the Baroda State, Pilajirao, Gaekwar, (1721–32) (one of a set of eight) British 6         Artist 2 Medalist: Frank Bowcher British, London 1864–1938 London   BOWCHER FRANK 8593 British 7 1864 1938 20th century 1900 1999 Bronze, struck 20482 3 × 2 in. (7.6 × 5.1 cm) Gift of H.H. Sir Sayaji Rao, G.C.S.I., Maharaja Gaekwar of Baroda, 1924                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
107229 24.189.8 0 1 195174 European Sculpture and Decorative Arts 3 Medal 148 Commemorating the rulers of the Baroda State, Fatehsingrao, Gaekwar (1778–89) (one of a set of eight) British 6         Artist 2 Medalist: Frank Bowcher British, London 1864–1938 London   BOWCHER FRANK 8593 British 7 1864 1938 20th century 1900 1999 Bronze, struck 20482 3 × 2 in. (7.6 × 5.1 cm) Gift of H.H. Sir Sayaji Rao, G.C.S.I., Maharaja Gaekwar of Baroda, 1924                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
445177 2017.178.1 0 0 744452 European Sculpture and Decorative Arts 3 Bedcover 1248 "Lotus" pattern bedcover or hanging British 6         Manufactory|Designer 484 Attributed to|Design and embroidery possibly by Morris & Company|May Morris British, Bexley, Kent 1862–1938   Morris & Company|Morris, May 56744   1862 1938 late 19th century 1880 1899 Silk embroidery on woven silk foundation silk, with fringed trim 62254 Overall: 8 ft. 6 in. × 80 in. (259.1 × 203.2 cm) Gift of Jessie and Charles Price, 2017                       Textiles-Embroidered 187   Metropolitan Museum of Art, New York, NY 1
445178 2017.178.2 0 0 744453 European Sculpture and Decorative Arts 3 Valance 925 Valance British 6         Manufactory|Designer 484 Attributed to|Design and embroidery possibly by Morris & Company|May Morris British, Bexley, Kent 1862–1938   Morris & Company|Morris, May 56744   1862 1938 late 19th century 1880 1899 Silk embroidery on woven silk foundation silk, with fringed trim 62254 Overall: 23 × 83 in. (58.4 × 210.8 cm) Gift of Jessie and Charles Price, 2017                       Textiles-Embroidered 187   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 1882.106ms · Data license: CC0 · Data source: metmuseum/openaccess