This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 |
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]);