This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50920 | 50920 | 1931-12-05 | 2 | b | Editorial by Tung Wah Times says that resistance to Japanese invasion should start with violence. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090621 | 24090621 | |
50921 | 50921 | 1931-12-05 | 2 | c | Chinese communities in America organise the dare-to-die unit to fight Japan. | America | http://trove.nla.gov.au/newspaper/page/24090621 | 24090621 | |
50922 | 50922 | 1931-12-05 | 2 | c | Feng Yong returns to Beijing safely and his story. | China | http://trove.nla.gov.au/newspaper/page/24090621 | 24090621 | |
50923 | 50923 | 1931-12-05 | 2 | e | Li Shizeng talks about military and administrative divisions in China again. | China | http://trove.nla.gov.au/newspaper/page/24090621 | 24090621 | |
50924 | 50924 | 1931-12-05 | 2 | e | Yan Xishan requests civil administration. Talks by Hu Hanmin. Zhang Xueliang is optimistic over the Chinese affairs. Loss of railways in Manchuria. Japanese troops in Shenyang set fire on radio station. Du Xuantai is arrested. | China | http://trove.nla.gov.au/newspaper/page/24090621 | 24090621 |
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]);