This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48283 | 48283 | 1929-07-13 | 8 | c | French concession in Shanghai bans gambling. | China | http://trove.nla.gov.au/newspaper/page/24099285 | 24099285 | |
48284 | 48284 | 1929-07-13 | 8 | c | Yan Xishan delays his overseas tour due to illness. | China | http://trove.nla.gov.au/newspaper/page/24099285 | 24099285 | |
48285 | 48285 | 1929-07-13 | 8 | c | New era for the aviation industry in China. | China | http://trove.nla.gov.au/newspaper/page/24099285 | 24099285 | |
48286 | 48286 | 1929-07-13 | 8 | c | Wife of Chinese deputy consul to San Francisco is detained by American customs for opium smuggling. | America | http://trove.nla.gov.au/newspaper/page/24099285 | 24099285 | |
48287 | 48287 | 1929-07-13 | 8 | c | Australia news/ How to apply for the subsidy from the government for children education. Post office start to sell new and hard envelopes. Chinese businessman in Sydney Ye Tonggui's third daughter, Ye Zuyi, is engaged with Tsung Yung Lo (Luo Zengrong), and a photograph of the wedding. Statistics on the burglaries in Sydney in the past eight days. Chinese opium addicts are arrested in Sydney. A notice issued by the Chinese Consulate-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099285 | 24099285 |
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]);