This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47275 | 47275 | 1928-07-28 | 6 | a-d | Guangdong news/ Wang Zulin, Communist military commander, confesses the military secrets and their plan. The Communists are preparing for another uprising in Shantou. Fan Shisheng on the effort to eliminate the Communists. Cargo ship sinks in Zhaoqing. | China | http://trove.nla.gov.au/newspaper/page/24098894 | 24098894 |
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]);