This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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]);