This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10882 | 10882 | 1902-06-18 | 2 | d-e | Statistics of Chinese students in Japan, which province they come from, number of students in military school, and name of those who have returned. | Japan | http://trove.nla.gov.au/newspaper/page/24100461 | 24100461 | |
30966 | 30966 | 1916-02-19 | 3 | d-e | The Yunnan Republican troops have taken over Chongqian, Sichun. | Japan | http://trove.nla.gov.au/newspaper/page/24095162 | 24095162 | |
33407 | 33407 | 1918-07-06 | 2 | d-e | Japanese newspaper on the economic alliance between China and Japan and its meaning. | Japan | http://trove.nla.gov.au/newspaper/page/24097346 | 24097346 | |
34207 | 34207 | 1919-03-01 | 2 | d-e | Lu Zhengxang on Chinese attitudes at the Paris peace conference. | Japan | http://trove.nla.gov.au/newspaper/page/24097630 | 24097630 | |
35907 | 35907 | 1920-07-17 | 2 | d-e | First part of military agreement signed between Russia and Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24098237 | 24098237 | |
40316 | 40316 | 1923-09-01 | 2 | d-e | Japanese provide weapon and other assistance to the bandits in China. | Japan | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
40422 | 40422 | 1923-09-22 | 2 | d-e | Japanese newspaper reports the secret agreement between Mongolia and Russia. | Japan | http://trove.nla.gov.au/newspaper/page/24094552 | 24094552 | |
40893 | 40893 | 1924-01-05 | 3 | d-e | Japanese regent prince narrowly escapes an assassination. | Japan | http://trove.nla.gov.au/newspaper/page/24100557 | 24100557 | |
41008 | 41008 | 1924-02-02 | 2 | d-e | Chief-negotiator of the Chinese government Wang Zhengting on the coming negotiation with Russian in Tokyo. | Japan | http://trove.nla.gov.au/newspaper/page/24100590 | 24100590 | |
41403 | 41403 | 1924-04-12 | 3 | d-e | Japanese seismologist predicts another earthquake in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24100679 | 24100679 | |
41572 | 41572 | 1924-05-17 | 6 | d-e | Japanese researchers find significant changes under the sea after the Tokyo earthquake. | Japan | http://trove.nla.gov.au/newspaper/page/24100725 | 24100725 | |
41753 | 41753 | 1924-06-28 | 6 | d-e | Japanese authority protests American for the immigration restrictions. | Japan | http://trove.nla.gov.au/newspaper/page/24100773 | 24100773 |
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]);