This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46901 | 46901 | 1928-03-31 | 7 | a | Feng Yuxiang leads his troops to retreat to Zhangde while Jiang Jieshi is guiding his army going north. Zhang Shaozeng is assassinated in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 | |
46902 | 46902 | 1928-03-31 | 7 | a | Earthquake in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 | |
46903 | 46903 | 1928-03-31 | 7 | a | Foreigners in north China are very arrogant. British ambassador on his negotiation with the Nanjing government before leaving Shanghai. Japanese in Xiamen, Fujian, arrest to Korean men in the Chinese territory. Borodin is back to China again. | China | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 | |
46904 | 46904 | 1928-03-31 | 7 | b | Australia news/ A young woman is raped in Darlinghurst, Sydney. Chinese school boy in Sydney dies in an accident. Chinese are penalised for opium smoking. White men are penalised for gambling. White women in Melbourne are detained for dating black boys from America. Young woman in detained in Sydney for shoplift. Ouyang Nan, businessman in Sydney and member of the Nationalist Party branch, sues Liang Yunzhou because their have different attitude towards the Nanjing and Wuhan governments. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 | |
46905 | 46905 | 1928-03-31 | 7 | e | A notice by the Wing On Textile Company in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 | |
46906 | 46906 | 1928-03-31 | 7 | e | A notice by the Chinese Presbyterian Church in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098747 | 24098747 |
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]);