This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47103 | 47103 | 1928-06-02 | 8 | a | Gas factory explodes in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47104 | 47104 | 1928-06-02 | 8 | a | Gas explosion in America and the tragedy. | America | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47105 | 47105 | 1928-06-02 | 8 | a | Battle on the Beijing-Hankou railway between Feng Yuxiang and Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47106 | 47106 | 1928-06-02 | 8 | a | Communists are detained in Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47107 | 47107 | 1928-06-02 | 8 | a | Foreign missions in Beijing mediate the military clashes. | Japan | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47108 | 47108 | 1928-06-02 | 8 | a | Pirates hijack British ship near Hong Kong and a further report. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47109 | 47109 | 1928-06-02 | 8 | a | Communist office smashed in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47110 | 47110 | 1928-06-02 | 8 | b | Japan's attitude on the disarmament treaty. | America | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47111 | 47111 | 1928-06-02 | 8 | b | Another strike in India. | Other... | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47112 | 47112 | 1928-06-02 | 8 | b | Australia news/ Vietnamese sailor is punished in Sydney for opium smuggling. Bank manager is killed in a traffic accident. A woman in Sydney is charged with murder. Chinese consul in New Zealand Li Guangheng dies in Wellington. Australian Ministry of Defence organises air force. Chefs on board of ships on strike. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47113 | 47113 | 1928-06-02 | 8 | c | Message by Yu Enhe, Chinese consul in New Zealand, thanks the Chinese communities in Australia and New Zealand for their condolences on the death of consul Li Guangheng. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 |
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]);