This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41439 | 41439 | 1924-04-19 | 7 | a | A visit to The Royal Centenary Show, Moore Park, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41440 | 41440 | 1924-04-19 | 7 | a | A murderer in Melbourne is executed and the report on the process. | Australia | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41441 | 41441 | 1924-04-19 | 7 | a | The Sydney pianist is to be executed for murdering his three daughters. | Australia | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41442 | 41442 | 1924-04-19 | 7 | a | A coal miner in New South Wales is killed in an accident. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41443 | 41443 | 1924-04-19 | 7 | a | Circus performance in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41444 | 41444 | 1924-04-19 | 7 | b | British fleet escorts passenger liner in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41445 | 41445 | 1924-04-19 | 7 | b | American House of Representatives approves to ban entry of Japanese immigrant. | America | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41446 | 41446 | 1924-04-19 | 7 | b | American government criticise the tax regulations in Samoa island imposed by New Zealand authority. | America | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41447 | 41447 | 1924-04-19 | 7 | b | American navy to build more warships. | America | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41448 | 41448 | 1924-04-19 | 7 | b | A German teacher is sacked for introducing students to naked exercise. | Germany | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41449 | 41449 | 1924-04-19 | 7 | b-c | Military situation in the south and southeast of Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41450 | 41450 | 1924-04-19 | 7 | e | An open letter from some Chinese immigrants in Samoa thanks Chinese consul general Li Zhaosong for his kind help. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
41451 | 41451 | 1924-04-19 | 7 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 |
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]);