This data as json, CSV (advanced)
Suggested facets: page, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24582 | 24582 | 1911-05-29 | 3 | b | A paint worth 20,000 pounds | A paint of a lady by a British famous painter is worth 20,000 pounds. | Britain | ||
24583 | 24583 | 1911-05-29 | 3 | b | German King returns home | German King returned home after the coronation ceremony in Britain. | Britain | ||
24584 | 24584 | 1911-05-29 | 3 | b | The end of riots in Mexico | Riots in Mexico is nearly ended. | Other... | ||
24585 | 24585 | 1911-05-29 | 3 | b | Japan-American negotiation over the Panama Canal | Japan negotiates with America about the Panama Canal. | Other... | ||
24586 | 24586 | 1911-05-29 | 3 | b | Russia's railway plan in Xinjiang | Russia plans to build a railway in Xinjiang. | Other... | ||
24587 | 24587 | 1911-05-29 | 3 | b | Japan's control over Fushun mine | Fushun mine is run by a Japanese company. | Other... | ||
24592 | 24592 | 1911-05-29 | 6 | b | The new sytem for the new cabinet | The new system for the new cabinet has been revealed. | China | ||
24593 | 24593 | 1911-05-29 | 6 | b | Overseas Chinese proposals for saving China | Overseas Chinese have made several proposals for saving China. | Other... | ||
24594 | 24594 | 1911-05-29 | 6 | b | China's loans | China has borrowed loans from several foreign countries. | China | ||
24595 | 24595 | 1911-05-29 | 6 | b | Public telegrams | French war affairs minister died from a plance crash. India suffers from epidemic. Russia builds more military ships. British King held a lunch for leaders from other countries who attended the coronation. | Other... | ||
24599 | 24599 | 1911-05-29 | 8 | b | A statement from Yunnan | Yunnan border protection society issued its statement. | Other... |
JSON shape: default, array, newline-delimited
CREATE TABLE [article_index] ( [date] TEXT, [page] TEXT, [column] TEXT, [title] TEXT, [description] TEXT, [source] TEXT, [page_url] TEXT, [trove_id] TEXT ); CREATE INDEX [idx_article_index_date] ON [article_index] ([date]);