This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33984 | 33984 | 1919-01-11 | 3 | b-c | Military commanders from the north and the south meet together in Hengyang, Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24097566 | 24097566 | |
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]);