This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38950 | 38950 | 1922-08-26 | 8 | b-c | Guangdong news/ Why Sun Yatsen moves his warships. Battle in Sanshan and Jiangmen. Panic in Guangzhou. Eight Banners Society in Guangzhou is bombed. Workers on strike in Guangzhou in support of Sun Yatsen. The Guangzhou-Hankou railway company can now have a bit more profit. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094096 | 24094096 |
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]);