This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50539 | 50539 | 1931-07-25 | 3 | c | Economic development plan of the Soviet Russia and their plan to set up bank branch in China. | China | http://trove.nla.gov.au/newspaper/page/24090460 | 24090460 | |
50540 | 50540 | 1931-07-25 | 3 | c | Chinese citizens are murdered or injured in Korea. | China | http://trove.nla.gov.au/newspaper/page/24090460 | 24090460 | |
50554 | 50554 | 1931-07-25 | 8 | c | The Communist members in Germany rob shops. | Germany | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 | |
50555 | 50555 | 1931-07-25 | 8 | c | Martial law enforced in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 | |
50556 | 50556 | 1931-07-25 | 8 | c | Bandits in India commits physical assault in the court. | Other... | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 | |
50557 | 50557 | 1931-07-25 | 8 | c | Australia news/ Member of Federal House of Representatives criticises the use of public car for private purpose. Sales of lottery to be postponed. Young Chinese man is sentenced for car accident. Party on board of the passenger liner Changte and speakers include Pang Zijun, Chinese Consul-General Gui Zhi, Zhu Songqing, Ouyang Nan, Huang Zhu, Liu Guangfu and others. NSW state government needs money for daily administration. Two Chinese men are detained in Sydney for gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 |
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]);