This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37285 | 37285 | 1921-07-02 | 8 | a-b | Guangdong news/ Chen Jiongming organises a flying unit in his army. Xu Chongzhi and his army. Villagers in Xiangshan and their self-defence. Guangdong army on the way to the west. Amalgamation of a boy and a girl schools. Report on the water projects in Guangdong. Xu Chongzhi has moved. Businessman complains heavy tax. High alert in Xijiang River area. Army plans arrive Guangxi. Guangdong borrows more money for military purpose. Bandits and gambling in Dongguan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 | |
37286 | 37286 | 1921-07-02 | 8 | c | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 | |
37287 | 37287 | 1921-07-02 | 8 | c | Advertisement for the China-Australia Mail S. S. Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 | |
37288 | 37288 | 1921-07-02 | 8 | d | Advertisement for Goldsbrough Optical Pariors, Jewellers & Opticians, 762 George Street, Haymarket, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 | |
37289 | 37289 | 1921-07-02 | 8 | d | Advertisement for Lennon, pharmacy on 216 Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 | |
37290 | 37290 | 1921-07-02 | 8 | e | Advertisement for Hop Lee & Co, Wholesale Fruit and Produces, Merchants and General Commission Agents, 9 Municipal Buildings, Ultimo Road, Haymarket, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 | |
37291 | 37291 | 1921-07-02 | 8 | e | Advertisement for David Dudley, Men's Boots, 474 George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 | |
37292 | 37292 | 1921-07-02 | 8 | f | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 | |
37293 | 37293 | 1921-07-02 | 8 | f | Advertisement for Chinese herbalist Chen Caida, Hing Hi Wah Kee, 309 Thomas Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 | |
37294 | 37294 | 1921-07-02 | 8 | f | Advertisement for Weller & Bostock, Drink Silver King Gen and Old Clan Whisky, 17 Grosvenor Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093603 | 24093603 |
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]);