This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18939 | 18939 | 1908-02-29 | 2 | a-b | Editorial/ White Australia and white New Zealand (Chinese may exterminate in the Australasia region). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801646 | 26801646 | |
18946 | 18946 | 1908-02-29 | 3 | a-b | Guangdong is ready to implement the law of compulsory education. Imperial court in Beijing permits Guangdong to build arterial roads for military purpose. Guangdong educational authority to publish an official bulletin. Liner route to be opened from Guangzhou to Nanyang (Southeast Asia). Guangdong to have a new educational officer. Sun Yatsen retreats and now lives in Hanoi. A letter from the ministry of communication in Beijing to railway company of Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801645 | 26801645 | |
18961 | 18961 | 1908-02-29 | 6 | a-b | Third part of travel notes to Britain, written by Kang Youwei. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801650 | 26801650 | |
18965 | 18965 | 1908-02-29 | 7 | a-b | George Street in Sydney to be widened which has lead to anti-Chinese movement, and response from the Chinese community. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801649 | 26801649 | |
18972 | 18972 | 1908-02-29 | 8 | a-b | Political parties and newspaper during the constitutional reform in Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801652 | 26801652 |
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]);