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 |
---|---|---|---|---|---|---|---|---|---|
53025 | 53025 | 1933-07-01 | 2 | d | Wang Jingwei on the possibility of two governments respectively in the north and the south. | China | http://trove.nla.gov.au/newspaper/page/24091278 | 24091278 | |
53029 | 53029 | 1933-07-01 | 3 | d | The Jewish problems in Soviet Russia after the October Revolution. | Russia | http://trove.nla.gov.au/newspaper/page/24091277 | 24091277 | |
53030 | 53030 | 1933-07-01 | 3 | d | Anti-Chinese movement in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24091277 | 24091277 | |
53042 | 53042 | 1933-07-01 | 6 | d | Flooding of the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 | |
53043 | 53043 | 1933-07-01 | 6 | d | Australia news/ Court hearing in Sydney on the robbery of a Chinese shop. Visitor talks about Japan on his return. Chinese man is arrested in Sydney for using fake notes. Census in Australia. Manager of liner service company in Sydney entertains Chinese passengers. Two white men are arrested in Perth for opium smuggling. Sydney Chinese Saving China Association acknowledges receipt of donations to the war of resistance in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 |
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]);