This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44386 | 44386 | 1926-02-06 | 2 | a-b | Editorial by Tung Wah Times on Zhang Zuolin in Manchuria and his independence movement. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101447 | 24101447 | |
44396 | 44396 | 1926-02-06 | 5 | c | Advertisement for the W. E. Ward & Co Ltd on 47 York Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101448 | 24101448 | |
44397 | 44397 | 1926-02-06 | 6 | b-c | Third part of report on cotton production in Shaanxi province, China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101451 | 24101451 | |
44400 | 44400 | 1926-02-06 | 7 | b-d | Australia news/ Federal government responds to the illegal entry of some Chinese immigrants to the Northern Territory. Many Chinese are returning to Australia after a visit to their hometown in China. Heat waves in Sydney. Competition of furniture and cabinet making between the white and yellow men. Fire in Tingha claims dozens of shops. An old Chinese dies in his house fire in New South Wales. A meeting of the China-Australia Mail Line tries to raise some more funds by shares and the attendants include Wu Zhaoquan, Zhan Fu, Chan Zanhua, Huang Zhu, Ma Qi, Ma Xinsi, Guo Chao, Ye Tonggui, Chen Yin, Liu Guangfu, Huang Bingzhang, Chen Lin, Ye Guo'en, Sun Zhaoji, Lei Ji, Li Chun, Wu Gen, Yuan Zhaolin, Situ Kun, and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101450 | 24101450 |
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]);