This data as json, CSV (advanced)
Suggested facets: page, column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47815 | 47815 | 1929-02-16 | 2 | b | First part of comments by Tung Wah Times on different calendric systems. | Tung Wah | |||
47816 | 47816 | 1929-02-16 | 2 | d | Chinese Consulate-General in New Zealand in shortage of money. | New Zealand | |||
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 | |||
47832 | 47832 | 1929-02-16 | 5 | a | Public notice issued by Yu Enhe, acting Chinese Consul-General in New Zealand, on the entry of Chinese students into New Zealand and his correspondence with the authorities. | New Zealand | |||
47833 | 47833 | 1929-02-16 | 5 | c | Hong Kong news/ Passenger liner Xinhua sinks and the report. | Hong Kong | |||
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 | |||
47835 | 47835 | 1929-02-16 | 8 | a | Rebellions in Mexico bomb trains. | Other... | |||
47836 | 47836 | 1929-02-16 | 8 | a-c | Australia news/ Passenger liner sinks on its way from Sydney to Melbourne. A girl in Sydney sues her father for raping but the case suspended. Whale caught near Sydney. Chinese gardener is robbed in Sydney. A man in Sydney murders his wife and the report. A public notice from the Chinese Chamber of Commerce in Sydney calls for donations to the disaster areas in north China. | Tung Wah | |||
47837 | 47837 | 1929-02-16 | 8 | d | An election notice issued by the Chinese Chamber of Commerce in Sydney. | Tung Wah | |||
47838 | 47838 | 1929-02-16 | 8 | d | Advertisement for Picton Lake's T. B. Art Union, Sydney. | Tung Wah |
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]);