This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25776 | 25776 | 1912-02-24 | 8 | a | Stories of Peng Gangzhi | Peng Gangzhi was strict on his men taking opium but a conspiracy made himself addicted to opium. … | China | http://trove.nla.gov.au/newspaper/page/24092124 | 24092124 |
25778 | 25778 | 1912-02-24 | 9 | a-b | Travel records in Gansu | Gansu is now planting cotton as opium planting is forbidden there. Wool and hides are well-known products in Gansu and Shanxi. | China | http://trove.nla.gov.au/newspaper/page/24092123 | 24092123 |
25796 | 25796 | 1912-02-24 | 19 | a-b | Imperial minister's ideology | Cao Zhenyong, a minister well known for his success in officialdom, believes that modesty and speaking less in official places are the keys to his success. | China | http://trove.nla.gov.au/newspaper/page/24092133 | 24092133 |
25803 | 25803 | 1912-02-24 | 20 | b | Anecdote of Zhang Zidong | Zhang Zidong once played a trick on Yuan Shikai who was later disgraced in the court. | China | http://trove.nla.gov.au/newspaper/page/24092136 | 24092136 |
25804 | 25804 | 1912-02-24 | 21 | a | Anecdote of Luo Shou Tou Zi | Luo Shou Tou Zi, a wise and influential man in Shichun, rescued people in town from a war crisis and disappeared when he was told to be promoted soon. | China | http://trove.nla.gov.au/newspaper/page/24092135 | 24092135 |
25806 | 25806 | 1912-02-24 | 22-23 | a-b | Territory disputes over Northeast China between Russia and China over last two hundred years | Ambitions and conspiracies of Russia over China's territory led to several unequal treaties between China and Russia, further resulting in Russia-Japan War in northeast China for years. | China | http://trove.nla.gov.au/newspaper/page/24092138 | 24092138 |
25809 | 25809 | 1912-02-24 | 29 | a-b | Biography of Li Yuanhong | Li Yuanhong, the general commander of the revolutionary army, is an intelligent man with strong will and profound military knowledge. | China | http://trove.nla.gov.au/newspaper/page/24092143 | 24092143 |
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]);