This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21905 | 21905 | 1909-11-06 | 2 | a-b | Editorial on Ito Hirobumi: biography and the assassination. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802384 | 26802384 | |
21906 | 21906 | 1909-11-06 | 2 | b | A Parisian newspaper comments on the Manchuria agreement signed by China and Japan. | France | http://trove.nla.gov.au/newspaper/page/26802384 | 26802384 | |
21907 | 21907 | 1909-11-06 | 2 | b-c | News in brief/ Chinese students are leaving Shanghai for America. Zhu Ruzhen suggests for the election of legislature assembly. Li Jiaju reports his investigation on foreign parliamentary system. Clash between Russian and Japanese in Jilin province. Gao Er'qian reports progress of demarcation of Macao border. Lin Runzhao is appointed consul to Nanyang. Students are prohibited to boycott foreign goods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802384 | 26802384 | |
21908 | 21908 | 1909-11-06 | 2 | c | China's plan to rebuild its navy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802384 | 26802384 | |
21909 | 21909 | 1909-11-06 | 2 | c | People in Manchuria boycott Japanese goods and the negotiations that followed. | China | http://trove.nla.gov.au/newspaper/page/26802384 | 26802384 | |
21910 | 21910 | 1909-11-06 | 2 | c-d | Beijing news/ A report from Li Jiaju on political reform. Dutch naval fleet to visit China. More students return this year for the selective examination. A survey on China's warship. The case of Yu Facheng in Jiangxi. | China | http://trove.nla.gov.au/newspaper/page/26802384 | 26802384 |
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]);