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 |
|---|---|---|---|---|---|---|---|---|---|
| 55796 | 55796 | 1936-02-15 | 2 | b | Editorial on the relations between China and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096744 | 24096744 | |
| 55797 | 55797 | 1936-02-15 | 2 | d | Zhang Fakui agrees to be the General Commander of suppression of the communists. | China | http://trove.nla.gov.au/newspaper/page/24096744 | 24096744 | |
| 55798 | 55798 | 1936-02-15 | 2 | d | Japanese sailors land in Qingdao, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24096744 | 24096744 | |
| 55799 | 55799 | 1936-02-15 | 2 | e | Japanese in north China and the miscellaneous report. | China | http://trove.nla.gov.au/newspaper/page/24096744 | 24096744 | |
| 55800 | 55800 | 1936-02-15 | 3 | c | Greece is preparing for war. | Other... | http://trove.nla.gov.au/newspaper/page/24096743 | 24096743 | |
| 55801 | 55801 | 1936-02-15 | 3 | c | The Sino-Filipino Association and its gathering in Manila. | China | http://trove.nla.gov.au/newspaper/page/24096743 | 24096743 | |
| 55802 | 55802 | 1936-02-15 | 3 | d | Japan seeks to improve its relations with Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24096743 | 24096743 | |
| 55803 | 55803 | 1936-02-15 | 5 | a | A further report on the Republic of Mongolia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096745 | 24096745 | |
| 55804 | 55804 | 1936-02-15 | 6-7 | a-d | Guangdong news/ Declarations issued by the students association in Guangzhou. Chen Jitang convenes a political and military conference in Guangzhou. Business in Guangzhou during the Chinese New Year. Bandits in Zhongshan and Dongguan. | China | http://trove.nla.gov.au/newspaper/page/24096748 | 24096748 | |
| 55805 | 55805 | 1936-02-15 | 8 | a | Japan has set time to invade Australia. | Britain | http://trove.nla.gov.au/newspaper/page/24096750 | 24096750 | |
| 55806 | 55806 | 1936-02-15 | 8 | c | Soviet Russia reforms its parliament system. | Russia | http://trove.nla.gov.au/newspaper/page/24096750 | 24096750 | |
| 55807 | 55807 | 1936-02-15 | 8 | d | British parliament debates the crisis in north China. | Britain | http://trove.nla.gov.au/newspaper/page/24096750 | 24096750 | |
| 55808 | 55808 | 1936-02-15 | 8 | f | Australia news/ Federal government abrogates taxes on flour. Export of Australia. Business of the Chinese firm Simpson Lee's in Sydney. Flour price going down again. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096750 | 24096750 |
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]);