This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41573 | 41573 | 1924-05-17 | 7 | a | Melbourne businessmen organise a company to cultivate the land in Northern Territory. | Australia | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41574 | 41574 | 1924-05-17 | 7 | a | Ticket money are robbed in a Melbourne railway station. | Australia | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41575 | 41575 | 1924-05-17 | 7 | a | Four Chinese are fighting in Innisfail, Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41576 | 41576 | 1924-05-17 | 7 | a | Australian federal government bans export of some birds. | Australia | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41577 | 41577 | 1924-05-17 | 7 | a | A man in Rockhampton, Queensland, shoots dead his girlfriend and then, commits suicide. | Australia | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41578 | 41578 | 1924-05-17 | 7 | a-b | Income of railway in New South Wales this year. | Australia | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41579 | 41579 | 1924-05-17 | 7 | b | A gay is detained in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41580 | 41580 | 1924-05-17 | 7 | b | A woman's body is found in the bushes near Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41581 | 41581 | 1924-05-17 | 7 | b | A Sydney policeman is sentenced for raping. | Australia | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41582 | 41582 | 1924-05-17 | 7 | b | A 87 year-old bridegroom and his 80 year-old bride in London. | Britain | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41583 | 41583 | 1924-05-17 | 7 | b | Hong Kong newspaper reports that Sun Yatsen is dying. Sun Yatsen dies. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41584 | 41584 | 1924-05-17 | 7 | c-d | Fierce battle in Dongjiang area, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41585 | 41585 | 1924-05-17 | 7 | e | A notice by the Heng Shan Tang (an association of Chinese fellows from Nanhai, Panyu and Shunde counties) in Sydney on the transfer of remains of their deceased fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 |
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]);