This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50548 | 50548 | 1931-07-25 | 8 | b | Zhang Xueliang's troops are going south to attack Shijiazhuang in Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 | |
50549 | 50549 | 1931-07-25 | 8 | b | Twenty-eight passengers die when a ferry capsized down in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 | |
50550 | 50550 | 1931-07-25 | 8 | b | Call for boycott to Japanese goods in Shanghai. Navigators on strike in Shanghai and incoming ships stranded. | China | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 | |
50551 | 50551 | 1931-07-25 | 8 | b | Celebrations for the successful imitation of car in Shenyang, Liaoning province. | Britain | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 | |
50552 | 50552 | 1931-07-25 | 8 | b | Police in India shoot dead workers. | Other... | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 | |
50553 | 50553 | 1931-07-25 | 8 | b | Kidnap and ransom in London. | Britain | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 | |
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 | |
50558 | 50558 | 1931-07-25 | 8 | e | Notice issued by the Chinese Consulate-General in Australia. | 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]);