This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
11674 | 11674 | 1903-03-28 | 3 | a | A further report on the Hanoi fair. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 | |
11675 | 11675 | 1903-03-28 | 3 | a | A Thai student in America. | America | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 | |
11676 | 11676 | 1903-03-28 | 3 | a | Chinese Ya Lian was beaten by a navy officer on aSydney street. Investigations into the crime are continuing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 | |
11677 | 11677 | 1903-03-28 | 3 | b | Chinese Li Kai was punished in Sydney for tobacco smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 | |
11678 | 11678 | 1903-03-28 | 3 | b | Religious clashes in Fiji and comments of clergymen in Melbourne, Adelaide, Goulburn and Sydney in Australia. | Australia | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 | |
11679 | 11679 | 1903-03-28 | 3 | b | A priest in Perth sues a newspaper for defamation. | Australia | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 | |
11680 | 11680 | 1903-03-28 | 3 | b | A Sydney court has found some witnesses provide false evidence. | Australia | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 | |
11681 | 11681 | 1903-03-28 | 3 | b-c | Li Bu lodges an appeal to higher court in his case with Xian Junhao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 | |
11682 | 11682 | 1903-03-28 | 3 | c | Dozens of Chinese were arrested and penalised for gambling on Goulburn Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 | |
11683 | 11683 | 1903-03-28 | 3 | c | A warehouse in Sydney was burned to ashes. | Australia | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 | |
11684 | 11684 | 1903-03-28 | 3 | c | Fighting between American soldiers and local residents in the Philippines. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 | |
11685 | 11685 | 1903-03-28 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 |
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]);