This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56037 | 56037 | 1936-07-11 | 2 | b | Circular telegrams issued by the Southwest authorities to protest against more Japanese troops in north China. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56038 | 56038 | 1936-07-11 | 2 | c | Dispute between Guangzhou and Nanjing over the resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56039 | 56039 | 1936-07-11 | 2 | e | New deals between the Nanjing government and Japan. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56040 | 56040 | 1936-07-11 | 2 | f | Japanese argues for their military existence in north China. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56041 | 56041 | 1936-07-11 | 2 | f | Many students are leaving Tianjin for the south. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56042 | 56042 | 1936-07-11 | 3 | a | Japanese economic invasion of China. | China | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 | |
56044 | 56044 | 1936-07-11 | 3 | a | The war clouds over north China. | China | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 | |
56045 | 56045 | 1936-07-11 | 3 | a | Japanese smuggling in north China. | China | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 | |
56046 | 56046 | 1936-07-11 | 3 | d | Japanese organise self-government authority in Inner Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 | |
56047 | 56047 | 1936-07-11 | 3 | e | Japanese send more airforce troops to Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 | |
56056 | 56056 | 1936-07-11 | 6-7 | a-d | Guangdong news/ The Southwest authority and their plan to fight Japanese invasion. The new notes issued by Guangdong banks. Buddhists in Guangzhou pray for peace. The Nanjing government may have military conflict with Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24096918 | 24096918 |
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]);