This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30891 | 30891 | 1916-01-15 | 7 | a-b | Australia news/ Letter to overseas Chinese in Australia by Guangdong Disasters Relieving Department. Russian people in Australia must join the Army. An 18-year girl from Newcastle , who wants to be a soldier, is found hidden in soldier shipping warship. A Chinese businessman named Chen Binhui, suffers a big loss over fire in his shop. Several Chinese are poisoned dead after eating pigs' feet in Guangdong. Australian federal government requires Chinese join the army. Chinese Wu Yunchang and Ying Su are killed in a wagon crashed on a running train in Liao Wen Don (ppp). | Australia | http://trove.nla.gov.au/newspaper/page/24095113 | 24095113 | |
30892 | 30892 | 1916-01-15 | 7 | b | Battle situation in east Europe between Russian and German troops. | Russia | http://trove.nla.gov.au/newspaper/page/24095113 | 24095113 | |
30893 | 30893 | 1916-01-15 | 7 | b | Battle situation in west Europe between the Ally and German-Austrian troops. | France | http://trove.nla.gov.au/newspaper/page/24095113 | 24095113 | |
30894 | 30894 | 1916-01-15 | 7 | b-c | The Ally troops retreat from Turkish strait without much loss. | Britain | http://trove.nla.gov.au/newspaper/page/24095113 | 24095113 | |
30895 | 30895 | 1916-01-15 | 7 | c | Riots in China/ The revolutionary troops led by Cai E have plenty of weapons and funds. Guangdong, Guizhou and Sichuan oppose Yuan Shikai and support the revolutionary troops. | Britain | http://trove.nla.gov.au/newspaper/page/24095113 | 24095113 |
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]);