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 |
---|---|---|---|---|---|---|---|---|---|
49089 | 49089 | 1930-04-26 | 2 | d | Tao Menghe delivers a speech in the Beijing University on Chinese intellectuals and unemployment. | China | http://trove.nla.gov.au/newspaper/page/24099611 | 24099611 | |
49090 | 49090 | 1930-04-26 | 2 | d | Military organisation of Feng Yuxiang's army. Another circular telegram issued by the people who are against Jiang Jieshi. Yan Xishan and Feng Yuxiang are sworn in as commander-in-chief and the deputy of the united armies against Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24099611 | 24099611 | |
49097 | 49097 | 1930-04-26 | 3 | d | The defence of north Chinese border after the sudden death of Liang Zhongjia, Chinese military commander. | China | http://trove.nla.gov.au/newspaper/page/24099610 | 24099610 | |
49107 | 49107 | 1930-04-26 | 8 | d | Soviet Russia orders chemical products from Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24099617 | 24099617 | |
49108 | 49108 | 1930-04-26 | 8 | d | A plane crashes on its way from Paris to Sydney. | France | http://trove.nla.gov.au/newspaper/page/24099617 | 24099617 | |
49109 | 49109 | 1930-04-26 | 8 | d | The war clouds in China. | China | http://trove.nla.gov.au/newspaper/page/24099617 | 24099617 | |
49110 | 49110 | 1930-04-26 | 8 | d | Australia news/ A man is shot dead in Sydney restaurant. White woman commits suicide. Visitors to the Royal Agricultural Show in Sydney. Parade in Sydney on the Easter Day. New South Wales government to collect income tax. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099617 | 24099617 |
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]);