This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26046 | 26046 | 1912-04-20 | 8 | a-b | Australian news | Value of newly-built warship by Britain for Australia. Annual expenses of federal government. Treasurer of New South Wales died. New South Wales richest businesswoman died. Norwegian ship strangely sunk in South Australia dock. Mother and two sons drowned in Brisbane. Scholar dreams post from Britain to Australia could be shortened to less than 14 days. British navy tells Japan intends to invade Australia. Former key writer of The Tung Wah Times returns to China. Melbourne born Chinese boy allowed to stay in Australia. Chinese in Brisbane celebrate establishment of republic China. Japanese keen to learn Australian railway. | Other... | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
26047 | 26047 | 1912-04-20 | 8 | b | big iron mine found | Big iron mine found in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
26048 | 26048 | 1912-04-20 | 8 | b-c | Current situation in China | Some Beijing government officials do not want to follow Nanjing government. President Yuan appoints Huang Xing army chief. soldier rebel under control in Nanjing. Former financial minister appointed head of Shandong province. Former army general of Qing government Zhang Xun does not allow republic army to use railways under his control in Shandong. | Other... | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
26049 | 26049 | 1912-04-20 | 8 | a | Notice for donation to temple renovation | Notice for donations to renovation of Guanghua Temple in Xiangshan, Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
26050 | 26050 | 1912-04-20 | 8 | a-b | South and North governments forced to unite | South Nanjing and North Beijing governments forced to unite due to worsening economy. | Other... | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
26051 | 26051 | 1912-04-20 | 8 | b | Republic advocator killed | Famous republic advocator Guo Guiwen killed by warlord soldiers in Hunan. | China | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
26052 | 26052 | 1912-04-20 | 8 | b | Stubborn Qing officials | Some Qing officials are not aware of newly established republic. | Other... | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
26053 | 26053 | 1912-04-20 | 8 | b-c | Guangdong warlords executed | Two key Guangdong warlords executed. | Other... | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
26054 | 26054 | 1912-04-20 | 8 | c-d | Substitution for rubber | German scientist invents substitution for rubber. | Other... | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
26055 | 26055 | 1912-04-20 | 8 | d | Donation notice | More than 20 organisations and more than 50 names listed for their donations to republic army. (to be continued) | Other... | http://trove.nla.gov.au/newspaper/page/24092214 | 24092214 |
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]);