This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20453 | 20453 | 1909-01-02 | 2 | a-b | An article denouncing Yuan Shikai. Prepared by Chinese communities of 300 cities in Thailand, British, American, Dutch and French colonies. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802004 | 26802004 | |
20456 | 20456 | 1909-01-02 | 3 | a-b | Guangdong news. Process of the Guangzhou-Hankou railway project in Qingyuan county and the disputes with local residents. Liang Dunyan arrives in Guangzhou. Portuguese ambassador to Beijing rescinds the agreement with China on the railway project from Guangzhou to Kowloon. Guangdong officials in Beijing raises funds for flood victims in Guangdong. Travel permit for Chinese returned from overseas. Government officials in Foshan mourn over death of Emperor Guangxu. Many people delay their marriage or haircut due to the state funeral. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802003 | 26802003 | |
20459 | 20459 | 1909-01-02 | 6 | a-b | Letter from a reader in Queensland on the some unscrupulous Chinese merchants who are still making profit by opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802008 | 26802008 | |
20485 | 20485 | 1909-01-02 | 8 | a-b | Eighth part of the report, prepared by Liu Shiji, on the investment in Guangxi province by Zhenhua industrial company (Jun Wah Sut Yip Co. Ltd). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802010 | 26802010 |
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]);