This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56463 | 56463 | 1936-12-05 | 2 | b | Teachers and students in Beijing are determined to resist Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097085 | 24097085 | |
56464 | 56464 | 1936-12-05 | 2 | d | China news/ Han Fuqu on the way to meet Jiang Jieshi in Hangzhou. There are 2.6 million opium smokers registered nation-wide. The national congress is postponed. Grain prices going up in China. Jiang Jieshi flies to Xi'an to personally command the suppression of Chinese Communist troops. China and Japan have nearly conclude their treaty talks. | China | http://trove.nla.gov.au/newspaper/page/24097085 | 24097085 |
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]);