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 |
---|---|---|---|---|---|---|---|---|---|
47088 | 47088 | 1928-06-02 | 2 | b | Editorial by Tung Wah Times on the obstacles to the elimination of the Chinese Communist Party. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098826 | 24098826 | |
47091 | 47091 | 1928-06-02 | 3 | b | The Communist bandits set fire in Jiading, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24098825 | 24098825 | |
47095 | 47095 | 1928-06-02 | 5 | b | Fourth part of the survey on the tobacco production in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098827 | 24098827 | |
47101 | 47101 | 1928-06-02 | 7 | b | Guangdong agricultural and industrial administration issues temporary regulations on the labour movement, relations between employers and employees, and others. | China | http://trove.nla.gov.au/newspaper/page/24098829 | 24098829 | |
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 |
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]);