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 | |
| 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 | |
| 56496 | 56496 | 1936-12-19 | 3 | a | No-war movement in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24097100 | 24097100 | |
| 56497 | 56497 | 1936-12-19 | 3 | c | The anti-Chinese movement in the Philippines. | China | http://trove.nla.gov.au/newspaper/page/24097100 | 24097100 | |
| 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 | |
| 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 | |
| 56502 | 56502 | 1936-12-19 | 8 | a | Soviet Russia strengthen its national defence. | Russia | http://trove.nla.gov.au/newspaper/page/24097109 | 24097109 | |
| 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 | |
| 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 | |
| 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 |
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]);