This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
12386 | 12386 | 1903-11-07 | 2 | a | The Tung Wah Times starts a new era after reorganisation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 | |
12387 | 12387 | 1903-11-07 | 2 | a-b | Third and final part of Qin Chunxuan's proposal to set up a commercial association in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 | |
12388 | 12388 | 1903-11-07 | 2 | b | A visit to the imperial palace in Xi'an. | China | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 | |
12389 | 12389 | 1903-11-07 | 2 | c | Emperor Guangxu is a promising leader. | China | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 | |
12390 | 12390 | 1903-11-07 | 2 | c | Zhang Zhidong feels disappointed as his educational suggestion was rejected. | China | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 | |
12391 | 12391 | 1903-11-07 | 2 | c | Yuan Shikai is to send more students to study in Japan and will be teaching in Zhili schools after return. | China | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 | |
12392 | 12392 | 1903-11-07 | 2 | c | Hubei students in Japan try to translate Japanese books into Chinese. | China | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 | |
12393 | 12393 | 1903-11-07 | 2 | c | Imperial examination to be changed this year. Beijing University is to change name. Beijing University is to send more students to study overseas. | China | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 | |
12394 | 12394 | 1903-11-07 | 2 | c | Russia and China sign a treaty on mining issues in Heilongjiang and Jilin provinces. Outline of the treaty. | China | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 | |
12395 | 12395 | 1903-11-07 | 2 | c | Most foreign tourists to Xi'an, especially those from Germany, are very arrogant . | China | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 | |
12396 | 12396 | 1903-11-07 | 2 | d | Russia has just set up a new office to manage east Asia issues. Response of Empress Dowager to this. | China | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 | |
12397 | 12397 | 1903-11-07 | 2 | d | Nanjing is on alert for possible unrest. | China | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 | |
12398 | 12398 | 1903-11-07 | 2 | d | Governor Qin Chunxuan leads government forces to suppress bandits in Guangxi. | China | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 | |
12399 | 12399 | 1903-11-07 | 2 | d | Stories about Shen Jin and his execution. | China | http://trove.nla.gov.au/newspaper/page/26800321 | 26800321 |
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]);