This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
12667 | 12667 | 1904-01-09 | 2 | c | Jiang Shixing submits a report which was kept secret by the Empress. | China | http://trove.nla.gov.au/newspaper/page/26800357 | 26800357 | |
12668 | 12668 | 1904-01-09 | 2 | c | A new drama based on a novel published in Shanghai has been well received. | China | http://trove.nla.gov.au/newspaper/page/26800357 | 26800357 | |
12669 | 12669 | 1904-01-09 | 2 | c | Record on Zhang Zhidong's talks with Russian ambassador to Beijing. They discussed the situation in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/26800357 | 26800357 | |
12670 | 12670 | 1904-01-09 | 2 | c | Bandits in Manchuria are more aggressive under the flag of Russia. | China | http://trove.nla.gov.au/newspaper/page/26800357 | 26800357 | |
12671 | 12671 | 1904-01-09 | 2 | c | Wang Wenshao tries hard to block Zhang Zhidong's promotion to the court. | China | http://trove.nla.gov.au/newspaper/page/26800357 | 26800357 | |
12672 | 12672 | 1904-01-09 | 2 | c | Tight security check in Fengtian. All shops have to apply for Russian license to continue their business. Gold miners in Rehe suffer exploitation from Russian troops. Russian soldiers are looting Dadonggou area. Russian are building fortifications near Shengjing (Shenyang). Russian notice to residents in Fengtian. | China | http://trove.nla.gov.au/newspaper/page/26800357 | 26800357 | |
12680 | 12680 | 1904-01-09 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800356 | 26800356 |
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]);