This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42491 | 42491 | 1924-12-27 | 5 | a-d | Articles written by anonymous condemn condemn Huang Laiwang, secretary of the Guomindang group in Sydney, Xu Richu, Liu Boming and other Sydney Nationalist Party members for their radical ideas. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100980 | 24100980 | |
42512 | 42512 | 1924-12-27 | 8 | a-d | Guangdong news/ Troops in Guangzhou and report on their lootings. Yunnan army on their way to Shunde county. Businessmen and ordinary residents in Guangzhou condemn the Nationalist Party. Election of the Guangzhou mayor. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100984 | 24100984 |
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]);