This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41554 | 41554 | 1924-05-17 | 2 | a-b | Editorial on the mutiny in Shanxi province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100721 | 24100721 | |
41569 | 41569 | 1924-05-17 | 6 | a | Tung Wah Times comments on Sun Yatsen's communism and the sharing wife policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100725 | 24100725 | |
41570 | 41570 | 1924-05-17 | 6 | a-c | Third part of the report on the anti-Communist movement within the Nationalist Party (Borodin, Liao Zhongkai and overseas Chinese members, Fan Liren, and Sun Yatsen). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100725 | 24100725 | |
41571 | 41571 | 1924-05-17 | 6 | c-d | Some Chinese immigrants are murdered during the disaster relief of Tokyo earthquake, compensation request from the Chinese government, and the negotiation between China and Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100725 | 24100725 | |
41579 | 41579 | 1924-05-17 | 7 | b | A gay is detained in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41580 | 41580 | 1924-05-17 | 7 | b | A woman's body is found in the bushes near Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41585 | 41585 | 1924-05-17 | 7 | e | A notice by the Heng Shan Tang (an association of Chinese fellows from Nanhai, Panyu and Shunde counties) in Sydney on the transfer of remains of their deceased fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41587 | 41587 | 1924-05-17 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100727 | 24100727 | |
41588 | 41588 | 1924-05-17 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100727 | 24100727 |
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]);