This data as json, CSV (advanced)
Suggested facets: 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 | |
46374 | 46374 | 1927-10-29 | 7 | a | Warning to the compatriots who want to take risk overseas. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 |
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]);