This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29939 | 29939 | 1915-04-17 | 6 | a-b | Brief biography of Sun Yatsen by the central government (to be continued). | China | http://trove.nla.gov.au/newspaper/page/24094813 | 24094813 | |
29940 | 29940 | 1915-04-17 | 6 | b | Brief biography of Huang Xing by the central government ( to be continued). | China | http://trove.nla.gov.au/newspaper/page/24094813 | 24094813 | |
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 |
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]);