This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29170 | 29170 | 1914-08-15 | 8 | a-b | Criticism on Sun Yatsen's correspondence with Japanese politician, selected from newspapers in China. | China | http://trove.nla.gov.au/newspaper/page/24093218 | 24093218 | |
29171 | 29171 | 1914-08-15 | 8 | b-c | Beijing news/ President Yuan Shikai cares about overseas Chinese. New plan to retrieve paper bank notes. Judicial law to be revised and the key points. Budget for the central government has been finalised. China to compensate foreign countries fro their loss during the 1911 Revolution. Plague of bandits and locusts in Xiangyang, of Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24093218 | 24093218 | |
29172 | 29172 | 1914-08-15 | 8 | c | Guangdong news/ The Disaster Relief Committee in Guangzhou calls for donations and more funds for the flooding areas. Miscellaneous report on the fundraising activities in Guangzhou and involvement of government officials such as Long Jiguang and the new General Inspector. | China | http://trove.nla.gov.au/newspaper/page/24093218 | 24093218 |
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]);