This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50499 | 50499 | 1931-07-11 | 8 | b | Hot weather in America. | America | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 | |
50500 | 50500 | 1931-07-11 | 8 | b | Japanese police in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 | |
50501 | 50501 | 1931-07-11 | 8 | b | Air mail service started between Britain and China. | Britain | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 | |
50502 | 50502 | 1931-07-11 | 8 | b | Plea for help to the unemployed people in America. | America | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 | |
50503 | 50503 | 1931-07-11 | 8 | b | Chaos in Burma. | Other... | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 | |
50504 | 50504 | 1931-07-11 | 8 | c | Chinese government prohibits foreigners from exploring to the inland. | China | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 | |
50505 | 50505 | 1931-07-11 | 8 | c | Chinese nationals murdered in Korea. | Japan | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 | |
50506 | 50506 | 1931-07-11 | 8 | c | An English man is murdered in Singapore while walking on the street with his Chinese wife. | Singapore | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 | |
50507 | 50507 | 1931-07-11 | 8 | c | Japanese ship stranded in heavy fog. | Japan | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 | |
50508 | 50508 | 1931-07-11 | 8 | c | New statistics on the population of Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 | |
50509 | 50509 | 1931-07-11 | 8 | d | Australia news/ Storm in Sydney and the damages. China purchases railway sleepers from Australia. Australia repays debts to Britain with gold. Snow in Broken Hill, NSW. The future of the Savings Bank of New South Wales unclear. Australia exports railway sleepers to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090451 | 24090451 |
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]);