This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48074 | 48074 | 1929-05-04 | 8 | a | Rickshaw pullers in Hangzhou attack and set fire on a car factory because of interest conflict. | China | http://trove.nla.gov.au/newspaper/page/24099208 | 24099208 | |
48075 | 48075 | 1929-05-04 | 8 | a | Agreement signed between China and America on the aviation from Guangzhou to Shanghai and Hankou. | China | http://trove.nla.gov.au/newspaper/page/24099208 | 24099208 | |
48076 | 48076 | 1929-05-04 | 8 | a | Two aeroplane accidents in China. | China | http://trove.nla.gov.au/newspaper/page/24099208 | 24099208 | |
48077 | 48077 | 1929-05-04 | 8 | a | Prince of Britain arrives Hong Kong on his way to visit Japan. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099208 | 24099208 | |
48078 | 48078 | 1929-05-04 | 8 | a | Three American missionaries attacked and injured in the west of Hunan province, China. | China | http://trove.nla.gov.au/newspaper/page/24099208 | 24099208 | |
48079 | 48079 | 1929-05-04 | 8 | b | The international ban on arms export to China will be lifted after the national unification. | Britain | http://trove.nla.gov.au/newspaper/page/24099208 | 24099208 | |
48080 | 48080 | 1929-05-04 | 8 | b | Australia news/ New Chinese Consul-General Song Faxiang is arriving Sydney. A New Zealander helps the famine relief in north China. A white employee in Sydney sues his Chinese gardener boss for low wages and is compensated. A white woman in Darlinghurst commits suicide due to the shortage of money. Chinese shop owner is penalised. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099208 | 24099208 | |
48081 | 48081 | 1929-05-04 | 8 | c | A notice issued by the Chinese Students' Association in Melbourne on the welcome of Song Faxiang, first Chinese consul-general appointed by the Nationalist government to Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099208 | 24099208 | |
48082 | 48082 | 1929-05-04 | 8 | e | Church service notice by the Chinese Presbyterian Church in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099208 | 24099208 | |
48083 | 48083 | 1929-05-04 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099208 | 24099208 |
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]);