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 |
---|---|---|---|---|---|---|---|---|---|
55953 | 55953 | 1936-04-11 | 2 | b | First part of a letter to the Chinese people from the Cultural Ministry of the Nanjing government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096808 | 24096808 | |
55954 | 55954 | 1936-04-11 | 2 | c | New arrangement on transportation in north China. Magistrate of Jinshan county in Jiangsu province believes superstition. The autonomous movement in Fujian province. Ponographic performance in Shanghai. Bai Chongxi in Guangxi talks to students. New enlistment system in China. Japanese make trouble in Fujian province. Russian communists in Manchuria. Japanese prevent Chinese from leaving Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096808 | 24096808 | |
55955 | 55955 | 1936-04-11 | 3 | a | British House of Commons approves new budget for national defence. | Britain | http://trove.nla.gov.au/newspaper/page/24096807 | 24096807 | |
55956 | 55956 | 1936-04-11 | 3 | d | A speech of French Prime Minister on the future of the League of Nations. | France | http://trove.nla.gov.au/newspaper/page/24096807 | 24096807 | |
55957 | 55957 | 1936-04-11 | 3 | e | Bandits in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24096807 | 24096807 | |
55958 | 55958 | 1936-04-11 | 5 | b | The Latern Festival in China. | China | http://trove.nla.gov.au/newspaper/page/24096809 | 24096809 | |
55959 | 55959 | 1936-04-11 | 6-7 | a-d | Guangdong news/ Zou Lu talks to school students. The southwest authority urges a reply from the central government. Hails in Dongjiang area. The National Bank to be reopened. Textile industry promote Chinese products. A woman in Taishan county is alleged to murder her husband. Big fish found in Kaiping. Chen Jitang writes a poem in Nanhai. Famine victims in Shunde county. | China | http://trove.nla.gov.au/newspaper/page/24096812 | 24096812 | |
55960 | 55960 | 1936-04-11 | 8 | a | The anti-Japanese sentiment in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096814 | 24096814 | |
55961 | 55961 | 1936-04-11 | 8 | e | Australia news/ Royal Agricultural Show in Sydney. A murder on the train in Queensland. A car accident in Sydney and the casualties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096814 | 24096814 |
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]);