This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29909 | 29909 | 1915-04-10 | 7 | a-b | Australia news/The man who killed Huang Ji in Sydney is sentence for 12 years in Prison. Income of trims in Sydney declines due to bad weather. Japan tries to sell more goods in Australia. A Chinese is arrested for illegally selling opium. | Australia | http://trove.nla.gov.au/newspaper/page/24094804 | 24094804 | |
29910 | 29910 | 1915-04-10 | 7 | b | Japanese volunteers join Russian army to fight against Germany. | Other... | http://trove.nla.gov.au/newspaper/page/24094804 | 24094804 | |
29911 | 29911 | 1915-04-10 | 7 | b | Chinese people and soldiers are angry with Japanese troops coming to China. | Britain | http://trove.nla.gov.au/newspaper/page/24094804 | 24094804 | |
29912 | 29912 | 1915-04-10 | 7 | b | News from overseas/Chen Jintao, a special Chinese financial officer in Britain, resigns and returns to China. Wang Jinfang cables to enroll some officials to inspect American currency system. China and Cuba is negotiating business treaty. Chinese overseas students in Belgium transfer to Britain due to the war. | Other... | http://trove.nla.gov.au/newspaper/page/24094804 | 24094804 | |
29913 | 29913 | 1915-04-10 | 7 | b-c | Headline news miscellany/20 one-line news from China on government policies, important events. Sun Sujun, Yuan Shikai, Zhang Hu, Lin Su, and others are mentioned. | China | http://trove.nla.gov.au/newspaper/page/24094804 | 24094804 |
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]);