This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41003 | 41003 | 1924-01-26 | 8 | a-d | Guangdong news/ Guangzhou has turned into a world of bandits. Wounded soldier reports their battle in Jiangbei. Shen Hongying's army approach Lianjiang. General commander of Hunan Lu Diping resigns. United army resist Guangdong army. Guangdong army takes over Baoan county. Fighting between Guangdong and united armies. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100588 | 24100588 |
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]);