This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37497 | 37497 | 1921-08-20 | 8 | a-c | Guangdong news/ Heavy rain in Guangzhou. Rice mill workers in Shunde are on strike for more pay. Tea shop employees on strike for more pay. Educational commissioner in Guangdong and the new policy. Guangxi legislature assembly members pay a visit to Chen Jiongming for peace talk. Battle in Qinxian and Lianzhou. Wuzhou after the war. Bandits in Zengcheng rob shops in broad daylight. A ferry from Dongguan to Longcheng is hijacked on the way. A staff officer is executed for collaboration with Guangxi army. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093661 | 24093661 | |
37498 | 37498 | 1921-08-20 | 8 | d | Hong Kong & Shanghai Xinghua Flour Co Ltd raises funds by floating shares. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093661 | 24093661 | |
37499 | 37499 | 1921-08-20 | 8 | d | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093661 | 24093661 |
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]);