This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42459 | 42459 | 1924-12-20 | 5 | a-d | Articles written by anonymous authors 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/24100972 | 24100972 | |
42475 | 42475 | 1924-12-20 | 8 | a-d | Guangdong news/ Guangdong people request politicians in the north to condemn Sun Yatsen. Sun Yatsen's government seals up more properties owned by businessmen. Guangdong commercial chambers to elect the chairman. Troops and their looting in Guangzhou. Hunan army in Shaoguan and their pressgang. Chen Jiongming to be the general commander. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100977 | 24100977 |
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]);