This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53113 | 53113 | 1933-07-29 | 2 | e | Feng Yuxiang on the crisis in Chaha'er, north China. | China | http://trove.nla.gov.au/newspaper/page/24091310 | 24091310 | |
53114 | 53114 | 1933-07-29 | 2 | e | Jiang Jieshi repeatedly orders to ban banquets, gambling and similar things. | China | http://trove.nla.gov.au/newspaper/page/24091310 | 24091310 | |
53123 | 53123 | 1933-07-29 | 3 | e | Japan to propose joint defence alliance with China. | China | http://trove.nla.gov.au/newspaper/page/24091309 | 24091309 | |
53124 | 53124 | 1933-07-29 | 3 | e | The world economic conference in London. | Britain | http://trove.nla.gov.au/newspaper/page/24091309 | 24091309 | |
53125 | 53125 | 1933-07-29 | 3 | e | Russia and Britain talk over trade. | Britain | http://trove.nla.gov.au/newspaper/page/24091309 | 24091309 | |
53129 | 53129 | 1933-07-29 | 5 | e | Sydney Chinese Saving China Association writes respectively to the authorities in Nanjing and the Guangdong. Donations from the Chinese communities in Auckland and Melbourne to the war of resistance in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091311 | 24091311 | |
53137 | 53137 | 1933-07-29 | 6 | e | Australia news/ Chinese businessman in Hobart, Tasmania, is robbed. Japanese immigration to the Northern Territory. White women detained from Chinese houses in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091314 | 24091314 |
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]);