This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32134 | 32134 | 1917-03-10 | 6 | a-b | Beijing news/ China's state revenue in 1917. Army to be restrained and the strategies. Liang Qichao, Tan Yankai, Xiong Xiling and Fan Yuanlian help to education children of the late Cai E. Sichuan people demand punishment to the provincial legislature members. Prisoners in Yangzhou, Jiangsu province, are frozen to death. Profit of the transportation last year in China. | China | http://trove.nla.gov.au/newspaper/page/24095621 | 24095621 | |
32135 | 32135 | 1917-03-10 | 6 | b-c | Guangdong news/ Lu Rongting is back to office after a holiday. President Li Yuanhong awards medal to Lu Rongting. Guangdong businessmen request awards for Xu Qin. Portuguese soldiers erect their flag on Chinese territory. Treasurer of Guangxi province Tian Wenfu arrives Guangzhou. Central government permits Guangdong to auction the leather company, a government property. Lu Rongting is to stay in Guangdong. Kaiping county magistrate disbands the civil corps and the investigation. Chinese merchant ships are not allowed to hand foreign flags. | China | http://trove.nla.gov.au/newspaper/page/24095621 | 24095621 |
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]);