This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30541 | 30541 | 1915-10-02 | 8 | a | Notice of Chinese council general in Australia on awards by Chinese Finance Ministry to Chinese in Australia donating to Chinese government. | Australia | http://trove.nla.gov.au/newspaper/page/24095009 | 24095009 | |
30542 | 30542 | 1915-10-02 | 8 | a-c | Notice of China's Business and Trade Association in New Zealand on donations to Guangdong floods, with names of donators listed. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095009 | 24095009 | |
30543 | 30543 | 1915-10-02 | 8 | c-d | Guangdong news/Long Jiguang orders to construct iron net walls for Guanyingshan fort to prevent bandits attacking. A bomb is found in the Governor's building. Xu Qilong, head of bandit troops in Huaxian county, Guangdong, leads his men to attack county governor building and loot people where they go. Jifuwei, a place in Gaoyao, Guangdong, suffers the worst in Guangdong floods, with over 4,000 casualties. | China | http://trove.nla.gov.au/newspaper/page/24095009 | 24095009 |
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]);