This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49002 | 49002 | 1930-03-22 | 8 | c | British governor in Nanyang suppresses the Chinese Nationalist Party there. | China | http://trove.nla.gov.au/newspaper/page/24099575 | 24099575 | |
49003 | 49003 | 1930-03-22 | 8 | c | Opium smuggling in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24099575 | 24099575 | |
49004 | 49004 | 1930-03-22 | 8 | c | War clouds over Yan Xishan, Feng Yuxiang and Jiang Jieshi. Zhang Xueliang is critical to the confrontation with Jiang Jieshi. Feng Yuxiang's army approach Henan province. Yan Xishan seeks truce with Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24099575 | 24099575 | |
49005 | 49005 | 1930-03-22 | 8 | e | Australia news/ Huang Qiming, principal of the Peizheng School in Guangzhou, raise huge amount of funds from the Chinese communities in Australia. Robbers arrested in Sydney. Chinese man is penalised for pretending to be returned serviceman. Police in Sydney raid gambling den. Chinese sailors detained in Sydney for leaving their post without permission. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099575 | 24099575 |
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]);