This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33999 | 33999 | 1919-01-11 | 8 | a-b | Beijing news/ Chinese President Xu Shichang proposes to borrow foreign loans to deal with the aftermath. Anhui provincial authority prohibits the organisation of peace association. Tang Jiyao convenes a political conference in Chongqing. China gives the coal mines in Shaanxi province to Britain and America. Military governor of Anhui province wants to build a big iron factory. The Nationalist Party (Guomindang) puts forwards their conditions for peace talks. | China | http://trove.nla.gov.au/newspaper/page/24097573 | 24097573 | |
34000 | 34000 | 1919-01-11 | 8 | b-c | Guangdong news/ Weapons confiscated in the German consulate in Shamian, of Guangzhou. German nationals are preparing to leave Guangzhou. Shen Peizhen sues Wei Zhaowen and the court hearing in Guangzhou. Foreign currency found while demolishing the city wall of Guangzhou. River dyke to be built in the city south. People in the Beijiang area are fighting for their mining rights. Land tax in Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24097573 | 24097573 |
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]);