This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44773 | 44773 | 1926-05-29 | 3 | a-d | Lu Zhonglin in Beijing removes Duan Qirui and releases Cao Kun, report part I. | China | http://trove.nla.gov.au/newspaper/page/24101573 | 24101573 | |
44795 | 44795 | 1926-05-29 | 8 | a-d | Guangdong news/ Wang Jingwei and Jiang Jieshi in Guangzhou. The Nationalist government in Guangzhou orders to arrest delegates to the Shanghai conference. Rumours on the troops from the north and their intention to take over Guangdong. Li Zhilong might be released soon. Cargo ship Xinghua is detained for suspicion of smuggling. Clash between civil corps and peasants' association in Nanhai county. River navigation is blocked from Shilong to Huizhou. Bomb found on board of ferry in Xintang area. | China | http://trove.nla.gov.au/newspaper/page/24101580 | 24101580 |
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]);