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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
47057 | 47057 | 1928-05-19 | 7 | c | Japan seeks to occupy Manchuria thoroughly. | Japan | 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 | |
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 | |
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 |
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]);