This data as json, CSV (advanced)
Suggested facets: date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 29918 | 29918 | 1915-04-17 | 2 | b-c | Chinese president calls on the senate for a meeting to discuss promoting military preparation. | China | http://trove.nla.gov.au/newspaper/page/24094809 | 24094809 | |
| 29924 | 29924 | 1915-04-17 | 3 | b-c | Regulations for readjusting share funds of Guangdong-Sichun-Hankou Railway in Hubei. | China | http://trove.nla.gov.au/newspaper/page/24094808 | 24094808 | |
| 29941 | 29941 | 1915-04-17 | 6 | b-c | News miscellany/ Xu Shiying, police chief in Fujian is impeded for corruption. Yuan Shikai orders Foreign Ministry reconsider opening port in Hulu Island. Chahare divides its border with Zhili. Li Jingyi is said to be promoted as police chief in Zhili. Government guards are of five ranks. South Manchu Railway Association is buying ignite strings. Xu Donghai leads bandits to rebel in Yangjiang. Vietnam revolutionaries are defeated by French troops. Tang Jirao cables the Finance Ministry for help. Sun Yatsen is injured in assassination in Tokyo. | China | http://trove.nla.gov.au/newspaper/page/24094813 | 24094813 | |
| 29947 | 29947 | 1915-04-17 | 8 | b-c | Beijing news/ Personnel in various provinces responsible for collecting files and documents. Key points in the revised custom tax regulations. Xu Shidao, governor of Qufu county, Shandong, commits suicide for offending offspring of Confucius. Bandits riots in Hunan, Yunnan, Guangxi and Henan are still serios. | China | http://trove.nla.gov.au/newspaper/page/24094815 | 24094815 |
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]);