This data as json, CSV (advanced)
Suggested facets: page, column, description, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31845 | 31845 | 1916-12-30 | 2 | c-d | Second part of Kang Youwei's letter to Fan Jingsheng on the worship to Confucianism. | China | http://trove.nla.gov.au/newspaper/page/24095531 | 24095531 | |
31846 | 31846 | 1916-12-30 | 2 | e-f | Fourth part of the draft of China's constitution. | China | http://trove.nla.gov.au/newspaper/page/24095531 | 24095531 | |
31847 | 31847 | 1916-12-30 | 2-3 | f-a | Second part of Liang Qichao's talks on the political system in China. | China | http://trove.nla.gov.au/newspaper/page/24095531 | 24095531 | |
31848 | 31848 | 1916-12-30 | 3 | a-b | Liang Qichao comments on China's foreign loans. | China | http://trove.nla.gov.au/newspaper/page/24095530 | 24095530 | |
31849 | 31849 | 1916-12-30 | 3 | b-c | Li Genyuan talks to Zhang Xun in Xuzhou, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24095530 | 24095530 | |
31850 | 31850 | 1916-12-30 | 3 | c | Chen Shufan as governor of Shaanxi province and the looting of his troops. | China | http://trove.nla.gov.au/newspaper/page/24095530 | 24095530 | |
31851 | 31851 | 1916-12-30 | 3 | d | Local self-government movement in Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24095530 | 24095530 | |
31853 | 31853 | 1916-12-30 | 3 | e | Budget of Chinese government and the savings policy. Chinese navy and the budget. | China | http://trove.nla.gov.au/newspaper/page/24095530 | 24095530 | |
31856 | 31856 | 1916-12-30 | 6 | c | Miscellaneous report on the Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24095535 | 24095535 | |
31858 | 31858 | 1916-12-30 | 7 | a-c | Miscellaneous report on the Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24095534 | 24095534 | |
31861 | 31861 | 1916-12-30 | 8 | a-b | Beijing news/ New regulations on the qualification assessment of lawyer. Fundraising movement in Shanghai for orphans. Research association on the industry and commerce in Shanghai. Guizhou provincial legislature suggests to rehabilitate county legislature assemblies. French archbishop requests priests not to interfere with local politics in China. Income of salt tax in China this year. News on the railway from Sichuan to Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24095536 | 24095536 | |
31862 | 31862 | 1916-12-30 | 8 | c-e | Guangdong news/ Lu Rongting and Zhu Qinglan jointly ban export of silver dollars. Governor Zhu Qinglan publicises misconducts of evil gentry Cai Nianmo of Nanhai county. Naval school students and their practical drilling in Guangdong. Two followers of Long Jiguang are executed. Former Dongguan county magistrate Liang Wenzhong is wanted for justice. Tobacco shops in Jiangmen protest against heavy taxes. Mutiny of troops in Dianbei county. President Li Yuanhong orders to ban lottery in Guangdong. Provincial legislature welcomes Liang Qichao. | China | http://trove.nla.gov.au/newspaper/page/24095536 | 24095536 |
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]);