This data as json, CSV (advanced)
Link | rowid | date | page | column | title | description | source | page_url ▼ | trove_id |
---|---|---|---|---|---|---|---|---|---|
37262 | 37262 | 1921-07-02 | 6 | c | War breaks out between Guangdong and Guangxi. | China | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37263 | 37263 | 1921-07-02 | 6 | c | Advertisement for Sun Tuey Wah Chockson & Co, 71-79 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37264 | 37264 | 1921-07-02 | 6 | c | Business for sale by Chern Lee in Norrowmine, New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37265 | 37265 | 1921-07-02 | 6 | d | Advertisement for Dr Williams' Pink Pill for pale people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37266 | 37266 | 1921-07-02 | 6 | d | Advertisement for Chinese doctor Sue Fong, Emmaville, specialist for sexually transmitted diseases. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37267 | 37267 | 1921-07-02 | 6 | d | Advertisement for The Commonwealth Studio, 337 Castlereagh Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37268 | 37268 | 1921-07-02 | 6 | d | Advertisement for Tillook & Co Ltd, Merchants and Manufacturers, Kent and Liverpool Streets, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37269 | 37269 | 1921-07-02 | 6 | e | Advertisement for Sun Man Lee & Co, 16 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37270 | 37270 | 1921-07-02 | 6 | e | Advertisement for Tiy Loy & Co, Botany Road, Alexandria, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37271 | 37271 | 1921-07-02 | 6 | e | Advertisement for Gibbs Brights & Co, Insurance Department, 41 Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37272 | 37272 | 1921-07-02 | 6 | f | Sydney market report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
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]);