This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56494 | 56494 | 1936-12-19 | 2 | b | An open letter from Luo Jieshi on his arrival in Australia for the inspection of New Life Movement and other missions. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097101 | 24097101 | |
56495 | 56495 | 1936-12-19 | 2 | d | China news/ Shanxi provincial government deports Korean dissident. Japanese are ready to occupy Suiyuan province. Beiping municipal authority to execute drug smugglers. Prominent people in Shanghai jointly issue declaration against Japanese invasion. Japanese consul in Qingdao and his protest over the Bank of China. Duan Qirui's coffin on the way to Beiping. | China | http://trove.nla.gov.au/newspaper/page/24097101 | 24097101 |
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]);