This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46962 | 46962 | 1928-04-21 | 6 | a-d | Guangdong news/ Fan Shisheng leads his troops to attack Communist leader Zhu De and his Soviet government on the border of Guangdong and Hunan. Chen Jitang and Xu Jingtang are appointed army commander. The Fifth Army after restructure. Report from Haifeng and Lufeng county after the recapture. Navy has secured new gunboats. Wei Bangping on the way to Guangzhou for business purpose. Police in Guangzhou and their income. | China | http://trove.nla.gov.au/newspaper/page/24098772 | 24098772 | |
46973 | 46973 | 1928-04-21 | 8 | a-d | Guangdong news/ Chen Mingshu proposes to ban gambling. A case of defraud in the Central Bank in Guangzhou. Hotel is closed for illegal prostitution. Two sisters marry a man. Cruiser is lost in Zhaoqing. Robbery in Zhaoqing. Suppress of bandits in north suburb of Guangzhou. Bandits set fire on ferry in Qingyuan county. Another robbery in Jiujiang. Radio communication in Jiujiang. Returned Chinese from overseas in Taishan help cultural and educational development. Internal fighting with the peasants' association in Puning county. News from Zengcheng county. | China | http://trove.nla.gov.au/newspaper/page/24098774 | 24098774 |
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]);