This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20941 | 20941 | 1909-04-24 | 2 | a-b | Chinese community in New York organises a society to help Chinese naval rejuvenation (zhen xing hai jun she), the notice from the society, its management committee, and name list of the shareholders of zhenhua company in Guangxi province. | America | http://trove.nla.gov.au/newspaper/page/26802158 | 26802158 | |
20946 | 20946 | 1909-04-24 | 3 | a-b | China news/ Prince Regent comments on Yu Shimei. Prince Regent reads mail personally. Zhao Binglin and his frankness. Fujian businessmen and their tributes to the Beijing court. Lu Chuanlin in the court. China to redeem Weihaiwei from Britain. Qu Hongji might be back to politics. Li Dianlin and the ministry of communications. New bank notes issued by the state bank of China. Dalai Lama receives a letter from new emperor of China. Revised regulation for research institution on local self-government. Draft of the revised nationality law. China and America to sign a trade treaty. | China | http://trove.nla.gov.au/newspaper/page/26802157 | 26802157 | |
20949 | 20949 | 1909-04-24 | 6 | a-b | Second and final part of a report submitted by Shen Zuyan on November 22, 1908, which suggests severe punishment for Li Lianying. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802162 | 26802162 | |
20959 | 20959 | 1909-04-24 | 7 | a-b | Easter parade in Bendigo, Victoria, and the involvement of Chinese community there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802161 | 26802161 | |
20968 | 20968 | 1909-04-24 | 8 | a-b | Border demarcation between Macao and Guangdong province and a further report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802164 | 26802164 |
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]);