This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50722 | 50722 | 1931-09-19 | 8 | b | Australia to build a wool factory in China. | Britain | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50723 | 50723 | 1931-09-19 | 8 | b | The Hong Kong - Shanghai Banking Corporation finds counterfeit bank notes. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50724 | 50724 | 1931-09-19 | 8 | b | Russia exports petrol to China. | China | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50725 | 50725 | 1931-09-19 | 8 | b | Train bombed in Hungary. | Britain | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50726 | 50726 | 1931-09-19 | 8 | b | Guangdong troops occupy Hengyang in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50727 | 50727 | 1931-09-19 | 8 | b | Gandhi arrives London and his speech. | Britain | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50728 | 50728 | 1931-09-19 | 8 | c | Australia news/ An old man in Sydney dies with grievance because of his savings in the Savings Bank of New South Wales. Profit of lottery in New South Wales. Dozens of people arrested in Sydney for communist propaganda. The Overseas Chinese Famine Relief Committee in Shanghai acknowledges receipt of the donations from the Chinese communities in Australia. Girl is raped in Sydney. Police arrest in a Sydney dancing club. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50729 | 50729 | 1931-09-19 | 8 | d | Notice issued by the Chinese Consulate-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50730 | 50730 | 1931-09-19 | 8 | e | Chinese Chamber of Commerce in Sydney calls for donations to the flooding areas in China and names listed for all donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 |
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]);