This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46365 | 46365 | 1927-10-29 | 5 | a | News on the war in north China. The Nationalist government and the Northern Expedition. Chinese National Chamber of Commerce and other commercial associations seek to borrow internal loans. British navy protect the Hong Kong and Shanghai Bank. Dog racing in Shanghai. Some British troops are leaving China. | China | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46366 | 46366 | 1927-10-29 | 5 | b | Industrial progress in the Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46367 | 46367 | 1927-10-29 | 5 | b | Secretary of the British coal miners' union will not go to Poland. | Britain | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46368 | 46368 | 1927-10-29 | 5 | b | Soviet Russia appoints new ambassador to France. | Britain | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46369 | 46369 | 1927-10-29 | 5 | b | Cases of kidnap in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46370 | 46370 | 1927-10-29 | 5 | c | Bandits in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46371 | 46371 | 1927-10-29 | 5 | c | Bandits hijack ship near Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46372 | 46372 | 1927-10-29 | 5 | c | German government intervenes with the strike. | Germany | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
46373 | 46373 | 1927-10-29 | 5 | c | The Yangtze River is not quiet. | China | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 |
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]);