This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
56497 | 56497 | 1936-12-19 | 3 | c | The anti-Chinese movement in the Philippines. | China | http://trove.nla.gov.au/newspaper/page/24097100 | 24097100 | |
56499 | 56499 | 1936-12-19 | 3 | e | Journalists in Shanghai refuse to attend banquet at Japanese consulate. | China | http://trove.nla.gov.au/newspaper/page/24097100 | 24097100 | |
56504 | 56504 | 1936-12-19 | 8 | d | The mutiny in Xi'an, Shaanxi province, by Zhang Xueliang and Yang Hucheng. | China | http://trove.nla.gov.au/newspaper/page/24097109 | 24097109 |
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]);