This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54503 | 54503 | 1934-09-15 | 2 | a | Editorial on the national defence of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096158 | 24096158 | |
54504 | 54504 | 1934-09-15 | 2 | b | China news/ Unsolved criminal cases in north China. Japanese troops on the way to north Manchuria. Red Army and their exercise in the Far East of Russia. Zhejiang province to issue more government bonds. Factories in Shanghai are closed as sink price going down. | China | http://trove.nla.gov.au/newspaper/page/24096158 | 24096158 | |
54505 | 54505 | 1934-09-15 | 2 | d | Chinese troops in Manchuria are ready to take over Changchun. Bandits attack Shenyang. Wang Jingwei to see doctor in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096158 | 24096158 | |
54506 | 54506 | 1934-09-15 | 2 | f | Institution set up in Beijing to help quit drug-use. | China | http://trove.nla.gov.au/newspaper/page/24096158 | 24096158 |
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]);