This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
12031 | 12031 | 1903-07-18 | 3 | a | The new imperial commissioner for Hunan province is keen to implement new policies. | China | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12032 | 12032 | 1903-07-18 | 3 | a | Germans seek dock in Wuhan, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12033 | 12033 | 1903-07-18 | 3 | a | Bandits in Changping county and other areas in the north of Zhili province. | China | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12034 | 12034 | 1903-07-18 | 3 | a | Ren Shouguo, a native of Hunan province, establishes a society in Beijing advocating loyalty, filial duty, feminism, women's issues, and others. | China | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12035 | 12035 | 1903-07-18 | 3 | a | Chinese government requests its students in Japan to concentrate on their study. | Japan | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12036 | 12036 | 1903-07-18 | 3 | a | Liu Chengyu, a Chinese student leader in Japan, is going to America. | Japan | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12037 | 12037 | 1903-07-18 | 3 | a | Report on tuberculosis and casualties in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12038 | 12038 | 1903-07-18 | 3 | b | Japanese government was questioned on their policy. | Japan | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12039 | 12039 | 1903-07-18 | 3 | b | Negotiation between Russia and China over financial issues. | China | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12040 | 12040 | 1903-07-18 | 3 | b | Singapore will ban entry of Chinese from June 14 this year. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12041 | 12041 | 1903-07-18 | 3 | b | Hawaii will ban entry of Japanese. | America | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12042 | 12042 | 1903-07-18 | 3 | b | An American farmer invents electrical fertiliser. | America | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12043 | 12043 | 1903-07-18 | 3 | b | A big cake in New York. | America | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12044 | 12044 | 1903-07-18 | 3 | b | Government in Guangxi tries to wipe out bandits. Japan prepares for a war with Russia. Russian troops in Lushun, China. | Other... | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12045 | 12045 | 1903-07-18 | 3 | c | Chinese businessmen in Sydney Liu Ruxing, Xian Junhao, Tang Caizhi and Chen Xia visit Melbourne for share issue of the China commercial company. They are warmly welcomed by the Melbourne Chinese community. A dinner party was organised and hosted by Huang Shiyan and Tan Kailing, and attended by hundreds of people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12046 | 12046 | 1903-07-18 | 3 | c | Rev. Sun Zhiyu and Chinese Presbyterian church in New Castle. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12047 | 12047 | 1903-07-18 | 3 | c | Australia will have stricter regulations on immigration to ban Asian entry. | Australia | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12048 | 12048 | 1903-07-18 | 3 | c | Two Chinese in Sydney were sentenced for opium smuggling. | Australia | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12049 | 12049 | 1903-07-18 | 3 | c | Qin Chunxuan has removed Su Yuanchun for his incapability to suppress bandits. | Britain | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12050 | 12050 | 1903-07-18 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 |
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]);