This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24487 | 24487 | 1911-03-25 | 8 | a | Memorial to the throne | A memorial to the throne by the Transport Department about tax-free materials for the Ningbo railway. | Other... | http://trove.nla.gov.au/newspaper/page/24091717 | 24091717 |
24488 | 24488 | 1911-03-25 | 8 | a-b | Events of gambling ban in Guangdong | Official bans were isssued to ban gambling in Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24091717 | 24091717 |
24489 | 24489 | 1911-03-25 | 8 | b | The impact on the future development of Jiaozhou Bay | Due to the development in Jiaozhou, it will show its profound impact . | Other... | http://trove.nla.gov.au/newspaper/page/24091717 | 24091717 |
24490 | 24490 | 1911-03-25 | 8 | b-c | The fourth list of donators to Jiangsu and Anhui from New Zealand | Chinese counsel Huang Rongliang issued the fourth list of donators to Jiangsu and Anhui. They are Xu Zhaokai, Su Bao,Yang Luohe, Yang Yongtian, Zhang dengquan, Zhou Jinyuan, Luoqian Shinai, Wu Jinghong and many others (for details see this page, available in Chinese). | Other... | http://trove.nla.gov.au/newspaper/page/24091717 | 24091717 |
24491 | 24491 | 1911-03-25 | 8 | d | A commentary | A commentary about the stabbling of the senior official who advocates opium ban. | Other... | http://trove.nla.gov.au/newspaper/page/24091717 | 24091717 |
24492 | 24492 | 1911-03-25 | 8 | f | About recent happenings | About the richest who attracts people's respect; Russia's plan to extend its railway to Beijing. | Other... | http://trove.nla.gov.au/newspaper/page/24091717 | 24091717 |
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]);