This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54637 | 54637 | 1934-11-03 | 2 | a | Comments selected from an American newspaper on General Cai Tingkai. | America | http://trove.nla.gov.au/newspaper/page/24096216 | 24096216 | |
54638 | 54638 | 1934-11-03 | 2 | c | China news/ Chinese troops in Liaoning province take over Changbai county town. Jiang Jieshi orders Sichuan army to suppress the communists. Japanese troops in north China. Japanese protest against Chinese government over the murder of Japanese businessman in Shanghai. Construction of the Longhai railway. Japanese plan to invade the west of Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24096216 | 24096216 |
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]);