This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55598 | 55598 | 1935-11-23 | 2 | b | Comments on the National Day celebration in China and advice to the Chinese people, selected from a Hong Kong newspaper. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096652 | 24096652 | |
55599 | 55599 | 1935-11-23 | 2 | c | China news/ Draft of the Chinese constitution to be submitted to the Legislature Council. Key members of the Chinese government meet in Nanjing for domestic and foreign policies. British economic expert claims that Britain is unable to help China by economic ways. The conflict in Mongolia. A Japanese meeting in Shanghai for the China policy. Hengyang Railway Station in Hunan province is opened. | China | http://trove.nla.gov.au/newspaper/page/24096652 | 24096652 |
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]);