This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10825 | 10825 | 1902-06-11 | 3 | a | Tang Jingsong, general of Guangxi province, met Jing Liansan recently. | China | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10826 | 10826 | 1902-06-11 | 3 | a | Three prisoners in Guangzhou wish to be beheaded rather than dying in the convict's cage. Their wish was granted by Li Hongzhang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10827 | 10827 | 1902-06-11 | 3 | a | A young woman in Guangzhou married the young man she loves. | China | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10828 | 10828 | 1902-06-11 | 3 | a | Li Hongzhang's son died recently. | China | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10829 | 10829 | 1902-06-11 | 3 | a | Students in St Petersburg held a protest. | Russia | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10830 | 10830 | 1902-06-11 | 3 | b | Several items of report on Western customs and society. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10831 | 10831 | 1902-06-11 | 3 | b | Coronation celebrations in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10832 | 10832 | 1902-06-11 | 3 | c | A son in Ballarat stole his mother's money. | Australia | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10833 | 10833 | 1902-06-11 | 3 | c | A girl thief in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10834 | 10834 | 1902-06-11 | 3 | d | Statistics of Chinese population in New South Wales, ratio of men and women, number born in Australia, other population details.. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10835 | 10835 | 1902-06-11 | 3 | d | Britain and Transvaal talk in an attempt to end the war in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10836 | 10836 | 1902-06-11 | 3 | e | Britain and Transvaal sign a truce to end the Boer War in South Africa. | Britain | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10837 | 10837 | 1902-06-11 | 3 | e | Mail from China awaits collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 | |
10838 | 10838 | 1902-06-11 | 3 | e | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100452 | 24100452 |
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]);