This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27999 | 27999 | 1913-10-11 | 8 | a | Guangdong people request to list crimes committed by Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24092855 | 24092855 | |
28000 | 28000 | 1913-10-11 | 8 | a-b | Military governor of Sichuan province lists 10 crimes committed by Xiong Kewu. | China | http://trove.nla.gov.au/newspaper/page/24092855 | 24092855 | |
28001 | 28001 | 1913-10-11 | 8 | b-c | Sun Yatsen in recent days. Japan provides shelter to Chinese rebellion leaders on exile. | China | http://trove.nla.gov.au/newspaper/page/24092855 | 24092855 | |
28002 | 28002 | 1913-10-11 | 8 | c | Guangdong news/ Wang Heshun arrives Guangzhou. Huang Shilong farewells the Chamber of Commerce in Guangzhou and his speech. Long Jiguang helps and donates to the flood victims. Railway bridge in Xinning is damaged by the flood. Damages in Xiangshan county caused by the storm. Flooding in Gaoyao county. | China | http://trove.nla.gov.au/newspaper/page/24092855 | 24092855 |
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]);