This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47034 | 47034 | 1928-05-19 | 2 | b | First part of an article written by He Peiyu on Confucianism and its relations with the current world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098810 | 24098810 | |
47035 | 47035 | 1928-05-19 | 2 | c | American authority denies the entry of Song Qingling. | America | http://trove.nla.gov.au/newspaper/page/24098810 | 24098810 | |
47036 | 47036 | 1928-05-19 | 2 | d | Many white Russian refugees commit suicide in Harbin, Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24098810 | 24098810 | |
47037 | 47037 | 1928-05-19 | 2 | d | The autonomy of Chinese tariff and the transitional tariff. | China | http://trove.nla.gov.au/newspaper/page/24098810 | 24098810 | |
47038 | 47038 | 1928-05-19 | 2 | e | Feng Yuxiang assists Ma Fuxiang to take over Xinjiang, north-west of China. | China | http://trove.nla.gov.au/newspaper/page/24098810 | 24098810 | |
47039 | 47039 | 1928-05-19 | 2 | f | Guo Taiqi is dismissed and the reason. | China | http://trove.nla.gov.au/newspaper/page/24098810 | 24098810 | |
47040 | 47040 | 1928-05-19 | 2 | f | Seal of General Commander Sun Yatsen is found in a Japanese museum. | Japan | http://trove.nla.gov.au/newspaper/page/24098810 | 24098810 | |
47041 | 47041 | 1928-05-19 | 3 | b | Communist leader Guo Liang is executed in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24098809 | 24098809 | |
47042 | 47042 | 1928-05-19 | 3 | d | The war in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24098809 | 24098809 | |
47043 | 47043 | 1928-05-19 | 3 | e | The war between Yan Xishan of Shanxi and Zhang Zuolin of Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24098809 | 24098809 | |
47044 | 47044 | 1928-05-19 | 3 | e | Beijing government protests against Soviet Russia for the deportation of Chinese immigrants. | China | http://trove.nla.gov.au/newspaper/page/24098809 | 24098809 | |
47045 | 47045 | 1928-05-19 | 5 | a | Second part of the survey on the tobacco production in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098811 | 24098811 | |
47046 | 47046 | 1928-05-19 | 5 | b | Polyandry in Tibet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098811 | 24098811 | |
47047 | 47047 | 1928-05-19 | 5 | b | Different social custom in a barbarian mountain in Yunnan province. A poor but happy life. Concubine and sons. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098811 | 24098811 | |
47048 | 47048 | 1928-05-19 | 6 | a-d | Guangdong news/ The Chaozhou and Meixian county after the elimination of the Communist Party. The 11th Army will move to the south. Epidemic disease in Guangzhou. The Communist movement in the Dongjiang area. Service men kill people in Qingyuan in broad day light. Portuguese consul in Guangzhou returns the assets of Zhenguang Company in Guangzhou. Chen Jitang seeks to recruit some bandits and the report. | China | http://trove.nla.gov.au/newspaper/page/24098814 | 24098814 | |
47049 | 47049 | 1928-05-19 | 7 | a | Japanese army reports their victory in Jinan, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098813 | 24098813 | |
47050 | 47050 | 1928-05-19 | 7 | a | Huang Fu, foreign minister of the Nationalist government in Nanjing, seeks help from American government. | China | http://trove.nla.gov.au/newspaper/page/24098813 | 24098813 | |
47051 | 47051 | 1928-05-19 | 7 | a | The reason for the clash between Chinese and Japanese troops in Jinan, Shandong. | China | http://trove.nla.gov.au/newspaper/page/24098813 | 24098813 | |
47052 | 47052 | 1928-05-19 | 7 | a | Japanese consul in Hong Kong denies that Japanese are leaving. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098813 | 24098813 | |
47053 | 47053 | 1928-05-19 | 7 | b | The Nationalist government in Nanjing appoints delegate to the international peace conference. | Britain | http://trove.nla.gov.au/newspaper/page/24098813 | 24098813 | |
47054 | 47054 | 1928-05-19 | 7 | b | Strike in India and the involvement of the Communist Party. | Other... | http://trove.nla.gov.au/newspaper/page/24098813 | 24098813 | |
47055 | 47055 | 1928-05-19 | 7 | b | American government offers to mediate the conflict between China and Japan. | America | http://trove.nla.gov.au/newspaper/page/24098813 | 24098813 | |
47056 | 47056 | 1928-05-19 | 7 | b | Jinan after the battle between Chinese and Japanese troops. | Britain | http://trove.nla.gov.au/newspaper/page/24098813 | 24098813 | |
47057 | 47057 | 1928-05-19 | 7 | c | Japan seeks to occupy Manchuria thoroughly. | Japan | http://trove.nla.gov.au/newspaper/page/24098813 | 24098813 | |
47058 | 47058 | 1928-05-19 | 8 | a-d | Guangdong news/ General Chamber of Commerce in Guangzhou demands payment of debts. Cruelty of the Communists in Hainan island. Bandits in Xijiang area. Ferries in Nanhai county make detours in order to avoid bandits. Bandits' robbery in Gaoyao and Zengcheng. Number of unemployed workers in Taishan county. Rice shortage in Shixing county. Spring found in Luofu county. Clan feud and fighting in Panyu and Zengcheng. Martial law enforced suddenly in Xinhui county. | China | http://trove.nla.gov.au/newspaper/page/24098816 | 24098816 |
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]);