This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28852 | 28852 | 1914-05-23 | 3 | a | Japan has concluded the investigation on the bribery of navy. | Japan | http://trove.nla.gov.au/newspaper/page/24093117 | 24093117 | |
28853 | 28853 | 1914-05-23 | 3 | a | Strike in the capital of Russia and the influence. | Russia | http://trove.nla.gov.au/newspaper/page/24093117 | 24093117 | |
28854 | 28854 | 1914-05-23 | 3 | a | Epidemic in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24093117 | 24093117 | |
28855 | 28855 | 1914-05-23 | 3 | a | Warm relations between Russia and France. | Britain | http://trove.nla.gov.au/newspaper/page/24093117 | 24093117 | |
28856 | 28856 | 1914-05-23 | 3 | b | Two French tourists murder German driver. | Britain | http://trove.nla.gov.au/newspaper/page/24093117 | 24093117 | |
28857 | 28857 | 1914-05-23 | 3 | b | War and chaos in Mexico. | Britain | http://trove.nla.gov.au/newspaper/page/24093117 | 24093117 | |
28858 | 28858 | 1914-05-23 | 3 | b | The Australian woman writer who plans to tour the west of China is returning to Beijing on the security consideration. | China | http://trove.nla.gov.au/newspaper/page/24093117 | 24093117 | |
28859 | 28859 | 1914-05-23 | 3 | b-c | Beijing news/ Chinese President Yuan Shikai pays attention to the loan conference in Paris. Two supervisors are appointed for the history project of Qing dynasty. Ministry of Internal Affairs repeats the ban on opium smoking. Norway and China start negotiation on the murder of Norwegian missionary in Hubei province. The Cabinet discusses regulations for chamber of commerce. Shaanxi provincial authority reports the protection of foreign missionaries. Local residents in Le'an county kills their county magistrate. Sale of salt is prosperous. Model farm in Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24093117 | 24093117 | |
28860 | 28860 | 1914-05-23 | 3 | c-d | Guangdong news/ Rebels Li Liejun, Chen Jiongming and Zhu Zijing prepare for another uprising from the Nanyang (Southeast Asian) area. Salary levels set for county magistrate. The Guangzhou-Hankou railway company repays loans. Government troops suppress bandits in Xiangshan county. A case of adultery in Xingning county and the solution. Orders from the central government in Beijing for government department redundancy. Provincial authority to dispatch more spies to Hong Kong and Macao. | China | http://trove.nla.gov.au/newspaper/page/24093117 | 24093117 |
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]);