This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24575 | 24575 | 1911-05-29 | 3 | a | Fire in Jilin | A huge fire in Jilin costed China several million pounds. | China | ||
24576 | 24576 | 1911-05-29 | 3 | a | British financial budget | Details are revealed about British financial budget. | Britain | ||
24577 | 24577 | 1911-05-29 | 3 | a | German prince meets Russian King | German prince meets Russian King. | Russia | ||
24578 | 24578 | 1911-05-29 | 3 | a | India's future | Former British commercial counsellor to India told that India's future depends on its tax reform. | Britain | ||
24579 | 24579 | 1911-05-29 | 3 | a | Coronation in Britain | The coronation ceremony in Britain is spectacular. | Britain | ||
24580 | 24580 | 1911-05-29 | 3 | a | Relation between Canada and Japan | Canadian government reviewed its relation with Japan. | Canada | ||
24581 | 24581 | 1911-05-29 | 3 | a | Hot weather in America | Hot weather in America resulted in loss of many people's lives. | America | ||
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... | ||
24588 | 24588 | 1911-05-29 | 3 | c | American correspondence | A Chinese court historian returned to China from America. About 650 Chinese students study in America. Ma Zhuo's invention of measuring machine is patented. | America | ||
24589 | 24589 | 1911-05-29 | 3 | c-d | Honolulu's correspondence | Honolulu prepares new regulations for Chinese entry into Honolulu. | Other... | ||
24590 | 24590 | 1911-05-29 | 3 | d | Zhang Mingqi's appointment | Zhang Mingqi is appointed governor of Guangdong and Guangxi. | China |
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]);