This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42529 | 42529 | 1925-01-03 | 5 | a-d | Articles written by anonymous authors condemn Huang Laiwang, Liu Boming and other Nationalist Party members in Sydney and their radical propaganda. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100988 | 24100988 | |
42546 | 42546 | 1925-01-03 | 8 | a-d | Guangdong news/ Chen Jiongming and the defence plan in suburb Guangzhou. Chen Jiongming reviews his troops in Chaoan county. Disaster of war in Taishan county. Tan Qixiu's troops extort businessmen in Humen. Commercial chambers in Guangzhou and their self-defence strategy. Chen Lianbo's followers are wanted by the provincial authority. More troops on the way to Dongguan county. Local self-defence in Xiangshan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100993 | 24100993 |
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]);