This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29920 | 29920 | 1915-04-17 | 2 | c-d | The senate of China proposes the land investigation and map drawing for China. | China | http://trove.nla.gov.au/newspaper/page/24094809 | 24094809 | |
29948 | 29948 | 1915-04-17 | 8 | c-d | Guangdong news/ Military plan of Long Jiguang and police cheif Li to wipe off riot parties. Various government organisations are ordered to keep secret of government plans. Some troops in Guangdong do not abide by laws and government regulations. Central government expects to allow gambling for pacifying bandits riots. A troop is ordered to protect Guangdong-Jiulong railway. | China | http://trove.nla.gov.au/newspaper/page/24094815 | 24094815 |
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]);