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 |
|---|---|---|---|---|---|---|---|---|---|
| 52996 | 52996 | 1933-06-24 | 2 | b | Editorial on Jiang Jieshi's compromise with Japanese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091270 | 24091270 | |
| 52997 | 52997 | 1933-06-24 | 2 | b | The assassination of Huang Fu in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24091270 | 24091270 | |
| 52998 | 52998 | 1933-06-24 | 2 | e | Chinese government replies to American President Roosevelt. | China | http://trove.nla.gov.au/newspaper/page/24091270 | 24091270 | |
| 52999 | 52999 | 1933-06-24 | 2 | e | Song Zheyuan reports his retreat under Japanese fire. | China | http://trove.nla.gov.au/newspaper/page/24091270 | 24091270 | |
| 53000 | 53000 | 1933-06-24 | 3 | a | Japanese invasion of north China. | China | http://trove.nla.gov.au/newspaper/page/24091269 | 24091269 | |
| 53001 | 53001 | 1933-06-24 | 3 | b | Attitudes of foreign countries towards the Manchurian government. | China | http://trove.nla.gov.au/newspaper/page/24091269 | 24091269 | |
| 53002 | 53002 | 1933-06-24 | 3 | c | The nonaggression pact between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24091269 | 24091269 | |
| 53003 | 53003 | 1933-06-24 | 3 | d | French government and its attitude on the disarmament. | Other... | http://trove.nla.gov.au/newspaper/page/24091269 | 24091269 | |
| 53004 | 53004 | 1933-06-24 | 3 | d | Japanese navy to have an exercise. | China | http://trove.nla.gov.au/newspaper/page/24091269 | 24091269 | |
| 53005 | 53005 | 1933-06-24 | 3 | d | Ma Zhanshan to return to Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091269 | 24091269 | |
| 53006 | 53006 | 1933-06-24 | 3 | e | Wang Jingwei's speech in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091269 | 24091269 | |
| 53007 | 53007 | 1933-06-24 | 3 | e | Russia to resume their consulate service in Nanjing and Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091269 | 24091269 | |
| 53008 | 53008 | 1933-06-24 | 5 | a | Couplets in memory of Liang Shiyi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091271 | 24091271 | |
| 53009 | 53009 | 1933-06-24 | 5 | e | Folk songs from Guangdong on the compromise with Japanese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091271 | 24091271 | |
| 53010 | 53010 | 1933-06-24 | 5 | e | Chinese Society (zhonghua gonghui) in Melbourne farewells Chinese consuls Wu Qinxun and Jiang Jiedong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091271 | 24091271 | |
| 53011 | 53011 | 1933-06-24 | 5 | f | Chinese communities in Sydney and Melbourne donate to the war of resistance in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091271 | 24091271 | |
| 53012 | 53012 | 1933-06-24 | 7-8 | a-f | Guangdong news/ Circular telegrams oppose to Jiang Jieshi's compromise with Japanese. Yan Huiqing and others condemn the central authority for their compromise with Japanese. Progress of the railway from Zhuzhou to Shaoguan. Floods in east Guangdong. Zou Lu condemns Jiang Jieshi's compromise with Japanese. Dramatic fall of the rice price in Guangzhou. A returned Chinese from overseas in Nanhai and his love story. Provincial government repeats the ban on silver export. Number of overseas Chinese. | China | http://trove.nla.gov.au/newspaper/page/24091273 | 24091273 | |
| 53013 | 53013 | 1933-06-24 | 6 | a | Japan boycotts Indian cotton. | Japan | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
| 53014 | 53014 | 1933-06-24 | 6 | a | An international conference on economic development in London. | Britain | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
| 53015 | 53015 | 1933-06-24 | 6 | a | Election in Mexico and the chaos. | Other... | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
| 53016 | 53016 | 1933-06-24 | 6 | b | League of Nations refuses to recognise the Manchurian state government. | Britain | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
| 53017 | 53017 | 1933-06-24 | 6 | b | Bandits in Shenyang demand ransom from French man. | China | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
| 53018 | 53018 | 1933-06-24 | 6 | c | Japanese withdraw their troops from north China. | China | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
| 53019 | 53019 | 1933-06-24 | 6 | c | Dispute between Britain and Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
| 53020 | 53020 | 1933-06-24 | 6 | d | Australia news/ Japanese fishermen murdered in Darwin. Police in Sydney raid shops. Cabinet factory in Perth on fire. Japanese steal marine products in north Australian water territories. Australian and New Zealand to have a joint exercise. Heavy fog in Sydney harbour. Chinese man robbed in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
| 53021 | 53021 | 1933-06-24 | 6 | f | A census notice issued by the Commonwealth government of Australia on 30 June 1933. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 | |
| 53022 | 53022 | 1933-06-24 | 6 | a | Advertisement of the Bank of New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091274 | 24091274 |
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]);