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 |
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]);