This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50628 | 50628 | 1931-08-22 | 3 | a | Talks between China and Japan over the atrocity of Japanese police in Jilin province. | China | http://trove.nla.gov.au/newspaper/page/24090494 | 24090494 | |
50632 | 50632 | 1931-08-22 | 5 | a | Hong Kong news/ Talks between China and Britain over the Guangzhou-Kowloon railway is halted. The Wing On Company in Hong Kong donates to the inland disastrous area. The Communist troops have occupied Dingzhou, Fujian province. Hong Kong businessman He Shiyao on the world trade. Hong Kong businessman Hu Wenhu donates to the flooding victims inland. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090496 | 24090496 |
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]);