This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37049 | 37049 | 1921-05-28 | 8 | a-b | Guangdong news/ Telegram from Hunan legislature assembly against President Sun Yatsen. Politicians in Guangdong are all seeking their own supporters. Provincial legislature assembly to elect the governor. Conflict between Sun Yatsen and Chen Jiongming. Sun Yatsen issues bank notes. Hong Zhaolin seeks independence. Panic in Guangzhou. Business associations in Xiangshan request to abolish some taxes. Zhu Naibin speaks to villagers in Xiangshan the Three Principles of the People (san min zhu yi) and communism. New regulation for government bonds. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093562 | 24093562 | |
37050 | 37050 | 1921-05-28 | 8 | c | Lin Tian thanks fellows in Australia for financially helping him return to China at this old age. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093562 | 24093562 | |
37051 | 37051 | 1921-05-28 | 8 | c | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093562 | 24093562 |
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]);