This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7590 | 7590 | 1901-05-01 | 2 | e | Several people were detained for gambling on La Trobe Street, Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7591 | 7591 | 1901-05-01 | 2 | e | Some British people like to store wine for their children as a way to make money. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7592 | 7592 | 1901-05-01 | 2 | f | A comet was seen in some areas of New South Wales such as West Wylong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7595 | 7595 | 1901-05-01 | 3 | a | Guangdong's relations with Japan has recovered as Tao Mo, new governor of Guangdong, met the Japanese Consul General in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100023 | 24100023 | |
7597 | 7597 | 1901-05-01 | 3 | a | A woman from Panyu county vowed to avenge her husband. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100023 | 24100023 | |
7599 | 7599 | 1901-05-01 | 3 | b | Gentry in Huaiji county, western Guangdong, requested government troops to suppress bandits there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100023 | 24100023 | |
7600 | 7600 | 1901-05-01 | 3 | b | Liang Qichao's poems written in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100023 | 24100023 | |
7601 | 7601 | 1901-05-01 | 3 | b | The population of London, Paris, Berlin, St Petersburg, New York, Philadelphia, Glasgow, Liverpool, Manchester, Chicago, Sydney, and Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100023 | 24100023 | |
7602 | 7602 | 1901-05-01 | 3 | c | Bao Chi, a Chinese businessman from Western Australia, gave a speech in Brisbane, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100023 | 24100023 | |
7604 | 7604 | 1901-05-01 | 3 | c | Australian soldiers arrived in Sydney after their service in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100023 | 24100023 | |
7605 | 7605 | 1901-05-01 | 3 | c | Dozens of bank branches in Sydney stopped service suddenly. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100023 | 24100023 | |
7606 | 7606 | 1901-05-01 | 3 | c | An ammunition storehouse in Germany exploded. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100023 | 24100023 | |
7608 | 7608 | 1901-05-01 | 3 | d | Imperial commissioner Yu Jinsan, of Zhejiang province, was ordered to settle the Quzhou missionary case as soon as possible. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100023 | 24100023 | |
7610 | 7610 | 1901-05-01 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100023 | 24100023 |
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]);