This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27535 | 27535 | 1913-06-28 | 7 | a | Liang Qichao and Xu Qin of the newly formed Progressive Party (jin bu dang) in Beijing sends telegram to the Nationalist Association, formerly Chinese Empire Reform Association, in Sydney, and the reply. Another telegram to the Chinese consulate-general in Melbourne which is signed by Li Yuanhong, Liang Qichao, Tang Hualong, Wu Tingfang and Wang Geng. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092732 | 24092732 | |
27536 | 27536 | 1913-06-28 | 7 | a-b | Australia news/ A man, Mr Brown, in Sydney is brought to trial for shooting a policeman. White guests fight in the Chinese restaurant Hong Kong Cafe in Melbourne. A hotel maid keeps the lost money for the guest. A woman in Melbourne murders another woman in order to marry her husband. A young man in Sydney dies for love. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092732 | 24092732 |
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]);