This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13445 | 13445 | 1904-07-02 | 2 | d | Xi Liang, imperial commissioner to Sichuan province, is moved on hearing speech of a Japanese teacher at the Sichuan University. | China | http://trove.nla.gov.au/newspaper/page/26800470 | 26800470 | |
13446 | 13446 | 1904-07-02 | 2 | d | Zou Rong and Zhang Binglin, two editors detained in the subao case, will be released soon. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26800470 | 26800470 | |
13447 | 13447 | 1904-07-02 | 2 | d | It is said that overseas Chinese businessmen will be forced to pay for army training. | China | http://trove.nla.gov.au/newspaper/page/26800470 | 26800470 | |
13448 | 13448 | 1904-07-02 | 2 | d | Report on the Guangzhao (Guangdong and Zhaoqing) high school and Guangzhao primary school in Shanghai. These two schools are set up to train children whose parents are natives of Guangdong province. | China | http://trove.nla.gov.au/newspaper/page/26800470 | 26800470 | |
13449 | 13449 | 1904-07-02 | 2 | d | A letter from Xiangshan county, Guangdong, about 1) bandits headed by Lin Guasi who clashed with government forces and, 2) pig tax and social chaos that followed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800470 | 26800470 | |
13450 | 13450 | 1904-07-02 | 2 | d | An American journalist reports and comments on morale of Japanese people and the yellow peril. | America | http://trove.nla.gov.au/newspaper/page/26800470 | 26800470 |
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]);