This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24969 | 24969 | 1911-09-09 | 7 | a | Calling on relief fund for Anhui | Great losses in Anhui flooding need helps from overseas Chinese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091913 | 24091913 |
24970 | 24970 | 1911-09-09 | 7 | a-b | Australia news | Sydney Empire Constitutional Association starts relief activities for Anhui. Business and industries increase in Queensland. More immigrants come to Australia. Government income of Queensland. Japanese businessmen offend regulations. governor of New South Wales returns home from Britain. Chinese woman has no right to stay in Australia. Huang Zicheng's letter praising his nephew. Test results of Sydney China's primary school. People from Australia and New Zealand set up an association in Shanghai. Li Zhao killed an European during a conflict. | Australia | http://trove.nla.gov.au/newspaper/page/24091913 | 24091913 |
24971 | 24971 | 1911-09-09 | 7 | b | Letters from America | Mei Hongjun is coming to America. President of Stanford University is to advocating peace in Far East. Britain, Japan and other European nations have much military debt. | America | http://trove.nla.gov.au/newspaper/page/24091913 | 24091913 |
24972 | 24972 | 1911-09-09 | 7 | c | Case of Liu Shiji's assassination | The revolutionaries want to escape their punishment. | China | http://trove.nla.gov.au/newspaper/page/24091913 | 24091913 |
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]);