This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53973 | 53973 | 1934-03-17 | 6 | a | British navy to have exercise. | Britain | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53974 | 53974 | 1934-03-17 | 6 | b | Muslim government in Xinjiang collapses. | China | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53975 | 53975 | 1934-03-17 | 6 | c | Japanese business in Indochina. | Japan | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53976 | 53976 | 1934-03-17 | 6 | d | Jiang Jieshi denies dictatorship charges. | China | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53977 | 53977 | 1934-03-17 | 6 | d | Chinese man in Singapore shoots dead police officer. | Singapore | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53978 | 53978 | 1934-03-17 | 6 | d | Earthquake in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53979 | 53979 | 1934-03-17 | 6 | d | Farmers in Korea and Manchuria attack Japanese soldiers. | Japan | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53980 | 53980 | 1934-03-17 | 6 | d | Japanese seek to restore the emperor system in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53981 | 53981 | 1934-03-17 | 6 | e | Australia news/ Dr Kuang Fuzhuo arrives Sydney from New Zealand. Import of tea and wine increases. Court hearing on the defraud of Chinese businessmen in Sydney. Chinese man in Sydney is arrested for laziness. Trial on the theft of Chinese garden in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 |
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]);