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 |
|---|---|---|---|---|---|---|---|---|---|
| 56363 | 56363 | 1936-10-31 | 2 | b | A speech by General Cai Tingkai at a gathering in Nanning, of Guangxi province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097044 | 24097044 | |
| 56364 | 56364 | 1936-10-31 | 2 | c | China news/ Chinese troops in Hebei, Gansu and Shaanxi province and their resistance to Japanese invasion. Princes of Mongolia reviews military parade in Japan. Navigation between Thailand and China. More than ten counties in Guangxi province are flooded. Japanese prepare to take over Suiyuan province. Japanese smuggling in Tianjin. Public notice issued by the Shanghai government requests friendship with neighbour country. | China | http://trove.nla.gov.au/newspaper/page/24097044 | 24097044 | |
| 56365 | 56365 | 1936-10-31 | 3 | a | Three Japanese sailors are killed in Shanghai and the response of Japanese government. | China | http://trove.nla.gov.au/newspaper/page/24097043 | 24097043 | |
| 56366 | 56366 | 1936-10-31 | 3 | b | Chinese communities in Europe gather in Paris for the resistance to Japanese invasion of China. | France | http://trove.nla.gov.au/newspaper/page/24097043 | 24097043 | |
| 56367 | 56367 | 1936-10-31 | 3 | c | Soviet Russian may start a counterattack on Hitler. | Russia | http://trove.nla.gov.au/newspaper/page/24097043 | 24097043 | |
| 56368 | 56368 | 1936-10-31 | 3 | d | Strike in Singapore stops the building of naval port. | Singapore | http://trove.nla.gov.au/newspaper/page/24097043 | 24097043 | |
| 56369 | 56369 | 1936-10-31 | 3 | d | Filipino President escapes from a bomb blast. | Other... | http://trove.nla.gov.au/newspaper/page/24097043 | 24097043 | |
| 56370 | 56370 | 1936-10-31 | 5 | a | Chen Jitang talks before leaving China. | China | http://trove.nla.gov.au/newspaper/page/24097045 | 24097045 | |
| 56371 | 56371 | 1936-10-31 | 5 | c | The Chinese Society in Melbourne organises drama performance to raise funds to the war of resistance in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097045 | 24097045 | |
| 56372 | 56372 | 1936-10-31 | 6-7 | a-d | Guangdong news/ Jiang Jieshi to unify the leadership of army and the government. Cai Tingkai talks in Guangzhou on his return from Guangxi. Japanese to set up textile factory in Hong Kong. Plan to ban opium trade and opium smoking in Guangdong. A fire in Guangzhou. Japanese sailors land in Beihai, of Guangxi province. Famine in Longchuan county. New penalties in Boluo county. | China | http://trove.nla.gov.au/newspaper/page/24097048 | 24097048 | |
| 56373 | 56373 | 1936-10-31 | 8 | a | Jiang Jieshi and Han Fuqu have a secret meeting. | China | http://trove.nla.gov.au/newspaper/page/24097050 | 24097050 | |
| 56374 | 56374 | 1936-10-31 | 8 | a | Britain seeks more export to China. | Britain | http://trove.nla.gov.au/newspaper/page/24097050 | 24097050 | |
| 56375 | 56375 | 1936-10-31 | 8 | a | Jiang Jieshi convenes a military conference in Hankou. | China | http://trove.nla.gov.au/newspaper/page/24097050 | 24097050 | |
| 56376 | 56376 | 1936-10-31 | 8 | b | Further report on the revolution in Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24097050 | 24097050 | |
| 56377 | 56377 | 1936-10-31 | 8 | c | Small countries in east Europe seek to protect themselves. | Britain | http://trove.nla.gov.au/newspaper/page/24097050 | 24097050 | |
| 56378 | 56378 | 1936-10-31 | 8 | d | Soviet Russia to help the Spanish government. | Other... | http://trove.nla.gov.au/newspaper/page/24097050 | 24097050 | |
| 56379 | 56379 | 1936-10-31 | 8 | d | White woman in New Zealand injures Chinese man. | New Zealand | http://trove.nla.gov.au/newspaper/page/24097050 | 24097050 | |
| 56380 | 56380 | 1936-10-31 | 8 | e | Yang Yongtai is attacked in Wuchang, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24097050 | 24097050 | |
| 56381 | 56381 | 1936-10-31 | 8 | e | Australia news/ Pearl production in Australia and the involvement of Japanese. Australian and New Zealand governments to increase the trade. A robber in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097050 | 24097050 |
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]);