This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48227 | 48227 | 1929-06-22 | 8 | a | Soviet Russia dispatches troops to invade Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24099262 | 24099262 | |
48228 | 48228 | 1929-06-22 | 8 | a | Soviet Russian's military response to China. | Britain | http://trove.nla.gov.au/newspaper/page/24099262 | 24099262 | |
48229 | 48229 | 1929-06-22 | 8 | a | Aviation industry in China. | China | http://trove.nla.gov.au/newspaper/page/24099262 | 24099262 | |
48230 | 48230 | 1929-06-22 | 8 | a | Japan and Soviet Russia fight for the fishing resource in Siberia. | Japan | http://trove.nla.gov.au/newspaper/page/24099262 | 24099262 | |
48231 | 48231 | 1929-06-22 | 8 | b | Australia news/ A burglary in a Brisbane hotel. Earthquake in New Zealand. Facsimile transmission machine installed in Melbourne post office. Police raid Chinese opium den in Sydney. A Chinese wedding (Li Chun's son and Guan Le's daughter). Timber workers in Sydney back to work. Number of foreign immigrants in Australia decreases. Chinese consul Liu Xi is returning. Acknowledgement from the Chinese-Foreign Famine Relief Committee in Shanghai for the donations of Australian Chinese communities to the famine victims in north China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099262 | 24099262 |
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]);