This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45455 | 45455 | 1927-02-05 | 2 | c-d | Foreign diplomat comments on the current situations in China. | China | http://trove.nla.gov.au/newspaper/page/24101872 | 24101872 | |
45457 | 45457 | 1927-02-05 | 2 | f | Soviet Russia might invade China and the rumours. | China | http://trove.nla.gov.au/newspaper/page/24101872 | 24101872 | |
45463 | 45463 | 1927-02-05 | 5 | a-b | Foreign reports on the current situation in China. | China | http://trove.nla.gov.au/newspaper/page/24101873 | 24101873 | |
45467 | 45467 | 1927-02-05 | 8 | a-d | Guangdong news/ Song Ziwen at a financial conference in Hankou. Provincial government has decided to take over the tap water company. Public security bureau investigate the rumours. Tourism workers on strike in Guangzhou. Ministry of Transportation on the Ningyang railway. Strike in Shilong town. Navigation in the Dongjiang area. Employees of the Guangzhou-Sanshui railway ask for pay rise. Bandits in Xinhui county. | China | http://trove.nla.gov.au/newspaper/page/24101878 | 24101878 |
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]);