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 |
|---|---|---|---|---|---|---|---|---|---|
| 55630 | 55630 | 1935-12-07 | 2 | b | First part of editorial on Japanese invasion of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096668 | 24096668 | |
| 55631 | 55631 | 1935-12-07 | 2 | c | Song Zheyuan in Beijing has agreed to stop anti-Japanese demonstration. Japanese military police search headquarters of Chinese security troops in Beijing. Chinese government to disband anti-Japanese associations in Beijing and Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24096668 | 24096668 | |
| 55632 | 55632 | 1935-12-07 | 2 | f | China has new consulate office in Vietnam. | China | http://trove.nla.gov.au/newspaper/page/24096668 | 24096668 | |
| 55633 | 55633 | 1935-12-07 | 3 | a | Britain, America and Japan have different opinions on the coming navy conference. | Britain | http://trove.nla.gov.au/newspaper/page/24096667 | 24096667 | |
| 55634 | 55634 | 1935-12-07 | 3 | c | Jiang Jieshi in Nanjing on the relations with Japan. | China | http://trove.nla.gov.au/newspaper/page/24096667 | 24096667 | |
| 55635 | 55635 | 1935-12-07 | 3 | c | The Nanjing government denies any new demands from Japan. | China | http://trove.nla.gov.au/newspaper/page/24096667 | 24096667 | |
| 55636 | 55636 | 1935-12-07 | 3 | c | Japanese cabinet decides to control currency system in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24096667 | 24096667 | |
| 55637 | 55637 | 1935-12-07 | 3 | e | Leader of Liberal Party in Britain criticises the foreign policy of the government. | Britain | http://trove.nla.gov.au/newspaper/page/24096667 | 24096667 | |
| 55638 | 55638 | 1935-12-07 | 5 | e | Chinese associations in New Zealand donates to the floods victims in China and names listed. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096669 | 24096669 | |
| 55639 | 55639 | 1935-12-07 | 6-7 | a-f | Guangdong news/ A reply from the Nanjing government to the southwest authority. National Chamber of Commerce proposes to boycott Japanese goods. Provincial government to ban any gambling from next January. HSBC in Guangzhou refuses to accept coins. Hu Hanmin leaves France for America. Jiang Jieshi flies to Nanchang in Jiangxi province. Inflation in Guangzhou following the new currency policy. Bandits arrested in Zhongshan county. Ming lun tang in Dongguan help peasants. Bandits in Panyu. | China | http://trove.nla.gov.au/newspaper/page/24096672 | 24096672 | |
| 55640 | 55640 | 1935-12-07 | 8 | a | Autonomous movement in Tianjin fails. | China | http://trove.nla.gov.au/newspaper/page/24096673 | 24096673 | |
| 55641 | 55641 | 1935-12-07 | 8 | a | A notice by the Chinese Chamber of Commerce in NSW for the increase of its membership fees. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096673 | 24096673 | |
| 55642 | 55642 | 1935-12-07 | 8 | b | Japanese soldiers in north China. | China | http://trove.nla.gov.au/newspaper/page/24096673 | 24096673 | |
| 55643 | 55643 | 1935-12-07 | 8 | c | Yin Rugeng is wanted by the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24096673 | 24096673 | |
| 55644 | 55644 | 1935-12-07 | 8 | d | Japanese troops leave Tianjin railway station. | China | http://trove.nla.gov.au/newspaper/page/24096673 | 24096673 | |
| 55645 | 55645 | 1935-12-07 | 8 | f | Australia news/ A bank robbery in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096673 | 24096673 |
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]);