This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43339 | 43339 | 1925-06-13 | 7 | a | Vegetable price in low in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
43340 | 43340 | 1925-06-13 | 7 | a | Fire in Flinders Street, Melbourne, destroys many shops. | Australia | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
43341 | 43341 | 1925-06-13 | 7 | a | Australia imports more from Germany. | Australia | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
43342 | 43342 | 1925-06-13 | 7 | a | American and Japanese navel fleet arrive Shanghai to deal with the chaos and demonstrations. | Japan | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
43343 | 43343 | 1925-06-13 | 7 | b-c | Miscellaneous report on the May 30 demonstration in Shanghai and the aftermath. | China | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
43344 | 43344 | 1925-06-13 | 7 | c | Labour union in Britain supports their counterparts in China. | Britain | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
43345 | 43345 | 1925-06-13 | 7 | c | Chinese students in Japan and their request on the solution to the May 30 demonstration in Shanghai. | Japan | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
43346 | 43346 | 1925-06-13 | 7 | c | Another war break out in Guangzhou between Yang Ximin, Liu Zhenhuan and Zhu Peide. | China | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
43347 | 43347 | 1925-06-13 | 7 | d | More Japanese cruisers are on the way to China. | Japan | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 | |
43348 | 43348 | 1925-06-13 | 7 | d | Some workers are preparing for more riots in Guangzhou and Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101169 | 24101169 |
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]);