This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26131 | 26131 | 1912-05-11 | 6 | a-b | Counsellor Huang's diplomatic documentation | Counsellor Huang's negotiation with Australian premier and the foreign minister. The new regulations to Chinese businessmen, students and labourers are designated by Australian government, which treats Chinese equally with all European people. | Australia | http://trove.nla.gov.au/newspaper/page/24092236 | 24092236 |
26134 | 26134 | 1912-05-11 | 7 | a-b | Australian news | Australian government is to build a new capital. Statistics of population in various states in Australia. Notice of Hu Hanming being appointed Guangdong governor. False money appears in Sydney. Thefts and robberies are increasing in Sydney. Gao Liang, a Chinese in Hobart, was robbed. A black youngster was hanged due to his raping a white girl. Donations to Sydney Hospital are increasing rapidly. Sydney Nationalist Association memebers hold farewell parties to Cai Chang, Xian Junhao, and Chen Lin, who are returning to China. | Australia | http://trove.nla.gov.au/newspaper/page/24092235 | 24092235 |
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]);