This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46707 | 46707 | 1928-02-04 | 5 | a | The Communists in Guangzhou is planning another rebellion. Foreign powers to ask the Nationalist government in Nanjing to suppress bandits seriously. Farewell to British military commander in Shanghai. Warlords in north China purchase large numbers of weapons from overseas and the report. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098681 | 24098681 | |
46711 | 46711 | 1928-02-04 | 7 | a | A notice issued by Miu Huili to resign from the position of director of the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098683 | 24098683 | |
46712 | 46712 | 1928-02-04 | 7 | a | A meeting notice by the Dongguan and Zengcheng lian yi tang in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098683 | 24098683 | |
46713 | 46713 | 1928-02-04 | 7 | a | Australia news/ Agricultural research helps the harvest this year. Two prisoners escape from a New South Wales prison. Advertisement for Assurance Homes of Australia Ltd. Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098683 | 24098683 | |
46714 | 46714 | 1928-02-04 | 7 | a | Ye Tonggui, Chen Yin and other Chinese businessmen in Sydney help to set up a high-level Chinese school in their home town, Zengcheng, which is named dong qiao xue xiao (Eastern Overseas Chinese School), and its regulations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098683 | 24098683 |
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]);