This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
55603 | 55603 | 1935-11-23 | 3 | c | A meeting of Japanese counsels in Shanghai has outlined new steps to invade China. | China | http://trove.nla.gov.au/newspaper/page/24096651 | 24096651 | |
55610 | 55610 | 1935-11-23 | 8 | c | The murder of Japanese sailor in Shanghai and the investigation. | China | http://trove.nla.gov.au/newspaper/page/24096658 | 24096658 |
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]);