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 |
|---|---|---|---|---|---|---|---|---|---|
| 55548 | 55548 | 1935-11-02 | 2 | b | Editorial on the internal conflicts in Inner Mongolia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096628 | 24096628 | |
| 55549 | 55549 | 1935-11-02 | 2 | c | China news/ Peasants on riots in Suining county, north Jiangsu province. Han Fuqu decides to stay on. Another Japanese army commander comes to China. Local bullies in Fujian province encourage peasants to stop paying land tax. The internal conflicts in Inner Mongolia. Song Zheyuan has to consult Japanese before the manoeuvre of his troops in Beijing. Hu Hanmin leaves Germany for America and then come back to China. | China | http://trove.nla.gov.au/newspaper/page/24096628 | 24096628 | |
| 55550 | 55550 | 1935-11-02 | 3 | a | Chinese troops in Jilin province and their resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096627 | 24096627 | |
| 55551 | 55551 | 1935-11-02 | 3 | a | New Japanese foreign minister and his China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24096627 | 24096627 | |
| 55552 | 55552 | 1935-11-02 | 3 | a | Japanese newspapers comment on Ross' visit to China. | Japan | http://trove.nla.gov.au/newspaper/page/24096627 | 24096627 | |
| 55553 | 55553 | 1935-11-02 | 3 | b | Rumour says a Republic to be set up in Xinjiang, northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24096627 | 24096627 | |
| 55554 | 55554 | 1935-11-02 | 3 | c | Britain notifies American government on the expansion of their naval forces. | Britain | http://trove.nla.gov.au/newspaper/page/24096627 | 24096627 | |
| 55555 | 55555 | 1935-11-02 | 3 | c | Diplomatic negotiations between Hungary and Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24096627 | 24096627 | |
| 55556 | 55556 | 1935-11-02 | 3 | e | The 25th anniversary of the conquering of Korea. | Other... | http://trove.nla.gov.au/newspaper/page/24096627 | 24096627 | |
| 55557 | 55557 | 1935-11-02 | 3 | e | American President Roosevelt writes to the League of Nations for the tariff and truce. | America | http://trove.nla.gov.au/newspaper/page/24096627 | 24096627 | |
| 55558 | 55558 | 1935-11-02 | 6-7 | a-f | Guangdong news/ Different response to the budget report prepared by the Guangzhou Chamber of Commerce. A report on the Guangdong Military and Political School. Branches of the Bank of Guangdong reopened. General Commander Chen Jitang on the military expenditure. French consul agrees to return some Chinese territory in Conghua county. Guangdong encourages industrial investment. Decline of the real estate in Shanghai. A case of incest in Zhongshan county. Zengcheng county authority punishes human traffic. Gaoming to resume bus service. | China | http://trove.nla.gov.au/newspaper/page/24096632 | 24096632 | |
| 55559 | 55559 | 1935-11-02 | 8 | a | The war between Italy and Algeria. | Britain | http://trove.nla.gov.au/newspaper/page/24096634 | 24096634 | |
| 55560 | 55560 | 1935-11-02 | 8 | f | Britain dispatches more troops to Egypt. | Britain | http://trove.nla.gov.au/newspaper/page/24096634 | 24096634 | |
| 55561 | 55561 | 1935-11-02 | 8 | g | Australia news/ Funeral of the Lord Mayor of Sydney. Tariff exempted for the imported Chinese medicine. Sand storm in Broken Hill. | South America | http://trove.nla.gov.au/newspaper/page/24096634 | 24096634 |
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]);