This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50847 | 50847 | 1931-10-31 | 8 | a | Miscellaneous report on Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090581 | 24090581 | |
50848 | 50848 | 1931-10-31 | 8 | c | Nanjing government to set up a technical university. | China | http://trove.nla.gov.au/newspaper/page/24090581 | 24090581 | |
50849 | 50849 | 1931-10-31 | 8 | c | Tens of thousands of Indian people have mental problems. | Other... | http://trove.nla.gov.au/newspaper/page/24090581 | 24090581 | |
50850 | 50850 | 1931-10-31 | 8 | c | A court in Nanjing sentences envoy of the Comintern to death. | China | http://trove.nla.gov.au/newspaper/page/24090581 | 24090581 | |
50851 | 50851 | 1931-10-31 | 8 | c | peace talks between Guangdong and Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24090581 | 24090581 | |
50852 | 50852 | 1931-10-31 | 8 | d | Australia news/ Chinese communities in Melbourne and Darwin donate to the flooding victims in China. Chinese community in Auckland, New Zealand, organises an association to fight Japan and to save China. NSW state government issues new regulations for coach services. Wool prices going up sharply. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090581 | 24090581 | |
50853 | 50853 | 1931-10-31 | 8 | e | Chinese Chamber of Commerce in Sydney calls for donations to the flooding areas in China and names listed for all donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090581 | 24090581 |
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]);