This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31449 | 31449 | 1916-07-29 | 8 | a-b | Beijing news/ Liang Qichao arrives Shanghai. Huang Peisong arrive Xiamen (Amoy) from Beijing. Cruelty of the Changshu county magistrate in Jiangsu province. Murderer of the Haizhu case escapes to Beijing. Britain, France, Japan and Russia to protect the Republic system in China. Sign of foreign management of Chinese finance. Wang Jitang in collaboration with bandits. | China | http://trove.nla.gov.au/newspaper/page/24095353 | 24095353 | |
31450 | 31450 | 1916-07-29 | 8 | b-d | Guangdong news/ Commercial and charity institution discuss the distribution of fire wood. Kong Zhaodu resigns from his position of commandership. Rice ferry is hijacked by bandits in Shunde county. Passenger ferries are hijacked in Jiujiang. Li Hu and his revolutionary troops. A woman in Foshan sells her daughter in order to pay ransom for her husband. Bandits in Raoping county. Bandits in Hainan island. | China | http://trove.nla.gov.au/newspaper/page/24095353 | 24095353 | |
31451 | 31451 | 1916-07-29 | 8 | d | A dangerous plant in South America. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095353 | 24095353 |
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]);