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 |
---|---|---|---|---|---|---|---|---|---|
55426 | 55426 | 1935-09-14 | 2 | e | Japanese embassy staff detain Chinese government officials in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096571 | 24096571 | |
55427 | 55427 | 1935-09-14 | 2 | e | Clash between Chinese rickshaw men and French police in the French settlement in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096571 | 24096571 | |
55435 | 55435 | 1935-09-14 | 3 | e | Hu Hanmin may return to China. | China | http://trove.nla.gov.au/newspaper/page/24096570 | 24096570 | |
55443 | 55443 | 1935-09-14 | 8 | e | Australia news/ German Chamber of Commerce in Sydney entertains the trade commissioner to the Far East. Chinese communities in Sydney and the clan members entertain Wu Liande, envoy of Chinese government. Chinese sailors are barred from entry in Melbourne. Representative of the Chinese government Wu Liande at the international conference in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096577 | 24096577 |
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]);