This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38155 | 38155 | 1922-01-14 | 8 | a-b | Eighth part of the true report to the overseas Chinese communities on the current situations in China, written by Liu Shimu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093829 | 24093829 | |
38156 | 38156 | 1922-01-14 | 8 | b-d | Guangdong news/ Further report on the backgrounds of the new county magistrates recently elected by the people in Guangdong. Ma Yingbiao and other residents from Xiangshan county report to provincial authority the banditry in their hometown. Census in Guangdong and its obstacles. Negotiation between China and Portugal over the Macao dispute is suspended. Guangdong provincial authorities sue Mo Rongxin. Construction of Huangsha Road in Guangzhou. Bandits in Sanshui sells woman's meat. Bandits in Songlong Town, of Xiangshan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093829 | 24093829 | |
38157 | 38157 | 1922-01-14 | 8 | d | Chinese Chamber of Commerce in New South Wales calls for donations to the flood victims in China. Names listed for the donations. All donations are required to address to: Wing On & Co, Fruit Merchants, Ultimo Road, Sydney; On Chong & Co, Merchants, 223 George Street, Sydney; Yuen Tiy Tong Kee, 54 Campbell Street, Sydney; Tiy Loy & co, Botany Road, Alexandria; Sun Suey War Store, 75 Campbell Street, Sydney; or the Chinese Chamber of Commerce in New South Wales, 52 Dixon Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093829 | 24093829 | |
38158 | 38158 | 1922-01-14 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093829 | 24093829 |
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]);