This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20720 | 20720 | 1909-02-27 | 7 | a | Detailed report on new restrictions imposed by Queensland government upon Chinese business. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802095 | 26802095 | |
20721 | 20721 | 1909-02-27 | 7 | a | Victorian business representative talks about trade between Australia and east Asia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802095 | 26802095 | |
20722 | 20722 | 1909-02-27 | 7 | a | Chinese Cheng Li in Sydney is sentenced for sexual harassment. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802095 | 26802095 | |
20723 | 20723 | 1909-02-27 | 7 | b | Thirty-five Chinese in Redfern, Sydney, are penalised for gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802095 | 26802095 | |
20724 | 20724 | 1909-02-27 | 7 | b | Several cases of opium smuggling in Sydney and the involvement of Chinese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802095 | 26802095 | |
20725 | 20725 | 1909-02-27 | 7 | b | A Chinese man in Sydney murders his white girlfriend. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802095 | 26802095 | |
20726 | 20726 | 1909-02-27 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802095 | 26802095 | |
20727 | 20727 | 1909-02-27 | 7 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802095 | 26802095 | |
20729 | 20729 | 1909-02-27 | 7 | b-c | Yuan Shikai in the court, his power and the removal. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802095 | 26802095 |
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]);