This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35566 | 35566 | 1920-04-03 | 7 | a-c | Australia news/ A letter from Zhao Qiuping for his article published in the Republic News (min guo bao). A shop robbery in Sydney. A Chinese gardener in Sydney is robbed. Tickets to the Royal Easter Show (nine days and five nights) by the Royal Agricultural Society of New South Wales. First part of new tax regulations recently issued by the Australian federal government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098112 | 24098112 | |
35567 | 35567 | 1920-04-03 | 7 | b | A notice by Chen Yiwen on his business dispute with others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098112 | 24098112 | |
35568 | 35568 | 1920-04-03 | 7 | c | A notice issued by Lei Zhangqian on his involvement in the Masonic Society, zhi gong tang and his relations with Mei Dongxing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098112 | 24098112 |
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]);