This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16251 | 16251 | 1906-09-29 | 3 | a | Detailed report on the typhoon and casualties in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801094 | 26801094 | |
16252 | 16252 | 1906-09-29 | 3 | a | Russian government permits Jewish people to leave the country freely. Tens of thousands of Jews have left for the West but they can not find a land of happiness. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801094 | 26801094 | |
16253 | 16253 | 1906-09-29 | 3 | a-b | Russian aristocrats flee their country for Paris. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801094 | 26801094 | |
16254 | 16254 | 1906-09-29 | 3 | b | Emperor of Persia agrees to allow Germans to set up their bank in the capital Teheran. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801094 | 26801094 | |
16255 | 16255 | 1906-09-29 | 3 | b | British foreign secretary is urged to ask Chinese government withdraw appointment of Chinese customs officials. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801094 | 26801094 | |
16256 | 16256 | 1906-09-29 | 3 | b | Persian people now have the right to vote following constitutional reform. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801094 | 26801094 | |
16257 | 16257 | 1906-09-29 | 3 | b | American government seeks to employ Chinese labourers in the Panama Canal. And comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801094 | 26801094 | |
16258 | 16258 | 1906-09-29 | 3 | b | Chinese community in Sydney calls for donations to typhoon victims in Hong Kong and Guangdong. Donations should be sent to Mr Guo Biao, of Wing Sang & Co, on 22 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801094 | 26801094 |
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]);