This data as json, CSV (advanced)
Suggested facets: page, column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47817 | 47817 | 1929-02-16 | 2 | d | Jiang Jieshi suggests to move the capital to Beijing. | China | |||
47818 | 47818 | 1929-02-16 | 2 | d | Bai Chongxi requests to move the capital to Beijing. | China | |||
47819 | 47819 | 1929-02-16 | 2 | d | Zhang Xueliang lists crimes of Yang Chang. | China | |||
47820 | 47820 | 1929-02-16 | 2 | e | Sun Chuanfang leaves Fengtian for Dalian. | China | |||
47821 | 47821 | 1929-02-16 | 2 | e | Bandits found everywhere in Shandong. | China | |||
47822 | 47822 | 1929-02-16 | 2 | f | Famine in Shaanxi province. | China | |||
47823 | 47823 | 1929-02-16 | 2 | f | Yang Sen is dismissed and under investigation. | China | |||
47824 | 47824 | 1929-02-16 | 3 | b | Liang Qichao dies in Beijing. | China | |||
47825 | 47825 | 1929-02-16 | 3 | b | Anti-Japanese movement worsening in Hankou, of Hubei province. | China | |||
47826 | 47826 | 1929-02-16 | 3 | c | Japanese invasion in Manchuria and their expenses. | China | |||
47827 | 47827 | 1929-02-16 | 3 | d | Chinese national chamber of commerce asks for the abolition of likin. | China | |||
47828 | 47828 | 1929-02-16 | 3 | e | American authority refuses to lend China loans for disaster relief in the north. | China | |||
47829 | 47829 | 1929-02-16 | 3 | f | The conclusion of investigation on opium smuggling in Shanghai. | China | |||
47830 | 47830 | 1929-02-16 | 3 | f | Wuhan authority moves troops to be against Anhui faction. | China | |||
47831 | 47831 | 1929-02-16 | 3 | f | Jiang Jieshi moves Xu Yuanquan's troops to the south into Anhui province. | China | |||
47834 | 47834 | 1929-02-16 | 6-7 | a-d | Guangdong news/ Competition in the election of the municipal branch of the Nationalist Party. Number of opium smokers in Guangdong. Efforts to wipe out the Communists in Xinhui. Zhang Fakui and his troops in Guangdong. Large numbers of German rifles arrive Guangzhou. Municipal authority takes over the tap water company and report on the truth. Road construction in Zhongshan. Political training in Zhongshan. Joint self-government movement in Xinhui. Whereabouts of the bandit chieftain in Dongjiang area. Shipping industry in Taishan, Kaiping and Enping oppose to the surtax. Bandits loot in Zengcheng. | China |
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]);