This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50573 | 50573 | 1931-08-01 | 8 | b | Storm in Poland and the damages. | Britain | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50574 | 50574 | 1931-08-01 | 8 | b | Heavy rain and floods in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50575 | 50575 | 1931-08-01 | 8 | b | American missionary hospital is robbed in Shantou, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50576 | 50576 | 1931-08-01 | 8 | b | Song Ziwen is assassinated in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50577 | 50577 | 1931-08-01 | 8 | b | Soviet Union to build a radio station. | Russia | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50578 | 50578 | 1931-08-01 | 8 | c | Indian students assassinate the governor-general. | Other... | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50579 | 50579 | 1931-08-01 | 8 | c | Accident of war plane in Poland. | Other... | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50580 | 50580 | 1931-08-01 | 8 | c | The longest road in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50581 | 50581 | 1931-08-01 | 8 | c | Ms Johnson is flying from Britain to Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50582 | 50582 | 1931-08-01 | 8 | c | President of Chile runs away. | Other... | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50583 | 50583 | 1931-08-01 | 8 | c | Australia news/ Policeman in injured by robbers. The Savings Bank of New South Wales is closed down once again. More Australian wheat are exported to China. Opium addicts are penalised in Sydney. Three Chinese men are robbed in Sydney. Shop owner is sentenced in Sydney for killing a thief. Issue of lottery postponed again. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
50584 | 50584 | 1931-08-01 | 8 | e | Notice issued by the Chinese Consulate-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 |
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]);