This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, 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 | |
56505 | 56505 | 1936-12-19 | 8 | g | Australia news/ Australia and Japan to conclude their trade talks. Heavy rains in Albury. Gibbs Bright has new passenger liner to Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097109 | 24097109 | |
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 | |
56500 | 56500 | 1936-12-19 | 5 | b | Election of the Chinese Society in Melbourne and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097102 | 24097102 | |
56501 | 56501 | 1936-12-19 | 8 | a | Further report on the revolution in Spain. | Other... | http://trove.nla.gov.au/newspaper/page/24097109 | 24097109 | |
56498 | 56498 | 1936-12-19 | 3 | c | Italy wants Austria to be independent. | Other... | 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 | |
56503 | 56503 | 1936-12-19 | 8 | b | King Edward of Britain to abdicate for love. | Britain | http://trove.nla.gov.au/newspaper/page/24097109 | 24097109 | |
56496 | 56496 | 1936-12-19 | 3 | a | No-war movement in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24097100 | 24097100 | |
56502 | 56502 | 1936-12-19 | 8 | a | Soviet Russia strengthen its national defence. | Russia | http://trove.nla.gov.au/newspaper/page/24097109 | 24097109 | |
56497 | 56497 | 1936-12-19 | 3 | c | The anti-Chinese movement in the Philippines. | 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]);