This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43881 | 43881 | 1925-09-26 | 5 | a-b | Tung Wah Times suspects the possible collaboration between Feng Yuxiang and Wu Peifu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
43882 | 43882 | 1925-09-26 | 5 | b | A joint committee of justice (British, American and Japanese) investigates the May 30 incident in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
43883 | 43883 | 1925-09-26 | 5 | b | American authorities try to stop the fighting among Chinese communities. | America | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
43884 | 43884 | 1925-09-26 | 5 | c | Tobacco consumption in America. | America | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
43885 | 43885 | 1925-09-26 | 5 | c | Economic development in Russia is slow. | Britain | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
43886 | 43886 | 1925-09-26 | 5 | c | Flood in Taiwan and the damages. | China | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
43887 | 43887 | 1925-09-26 | 5 | c | Japanese parliament is on fire. | Japan | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
43888 | 43888 | 1925-09-26 | 5 | c | A Spanish woman gives birth to 29 sons. | Other... | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
43889 | 43889 | 1925-09-26 | 5 | c | Signs for chaos in China. | America | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
43890 | 43890 | 1925-09-26 | 5 | c | Yellow River dyke bursts in Yuncheng county, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 |
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]);