This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45808 | 45808 | 1927-06-18 | 2 | d | Hu Shi on the current Chinese situation. | China | http://trove.nla.gov.au/newspaper/page/24102027 | 24102027 | |
45809 | 45809 | 1927-06-18 | 2 | d | The Soviet Russian embassy in Beijing after the leave of Russian ambassador. | China | http://trove.nla.gov.au/newspaper/page/24102027 | 24102027 | |
45810 | 45810 | 1927-06-18 | 2 | e | Martial law lifted in the international concession in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24102027 | 24102027 | |
45811 | 45811 | 1927-06-18 | 2 | e | The Far East Sports Game to be held in Dalian, of Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24102027 | 24102027 | |
45812 | 45812 | 1927-06-18 | 2 | f | Progress of the comprise in China between the south and the north. | China | http://trove.nla.gov.au/newspaper/page/24102027 | 24102027 | |
45813 | 45813 | 1927-06-18 | 3 | b | Japanese ambassador in Beijing on the diplomatic relations between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24102026 | 24102026 | |
45814 | 45814 | 1927-06-18 | 3 | c | Military commanders in Henan and Fengtian province condemn Jin Yunpeng. | China | http://trove.nla.gov.au/newspaper/page/24102026 | 24102026 | |
45815 | 45815 | 1927-06-18 | 3 | c | Borodin's wife arrives Beijing under custody. | China | http://trove.nla.gov.au/newspaper/page/24102026 | 24102026 | |
45816 | 45816 | 1927-06-18 | 3 | d | Zeng Xiao'an escapes to Japan. | China | http://trove.nla.gov.au/newspaper/page/24102026 | 24102026 | |
45817 | 45817 | 1927-06-18 | 3 | d | Women in Wuhan apply for naked demonstration but refused. | China | http://trove.nla.gov.au/newspaper/page/24102026 | 24102026 | |
45818 | 45818 | 1927-06-18 | 3 | d | Overseas Chinese missions to be closed due to budget shortage. | China | http://trove.nla.gov.au/newspaper/page/24102026 | 24102026 | |
45819 | 45819 | 1927-06-18 | 3 | e | The failure of the Chinese Communist Party and its influence. | China | http://trove.nla.gov.au/newspaper/page/24102026 | 24102026 | |
45820 | 45820 | 1927-06-18 | 3 | f | French consul in Longzhou is murdered. | China | http://trove.nla.gov.au/newspaper/page/24102026 | 24102026 | |
45821 | 45821 | 1927-06-18 | 3 | f | Chinese immigration to Cuba and the conditions. | China | http://trove.nla.gov.au/newspaper/page/24102026 | 24102026 | |
45826 | 45826 | 1927-06-18 | 7 | a | Envoys from Zhang Zuolin and from Jiang Jieshi meet in Dalian. | China | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 | |
45829 | 45829 | 1927-06-18 | 7 | b | The Nanjing government and its policy. | China | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 | |
45830 | 45830 | 1927-06-18 | 7 | b | Ferry in Shantou capsized. | China | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 | |
45833 | 45833 | 1927-06-18 | 9 | a-d | Guangdong news/ Local security in Guangdong (and the qing xiang). Martial law lifted in Guangzhou. The whereabouts of Tang Shaoyi. A dead man recovers in Guangzhou. Cadets of the Huangpu military academy support to eliminate the Communists. The Communist forces in Haifeng, Lufeng and Zijin county. Passengers die when a ferry capsized. Fireworks industry in Guangdong. Bandits in Heshan county and the ferry hijack. The Xinning railway. Effort to eliminate the communists in Heshan county. Lechang county magistrate is escorted to Guangzhou for a trial. Big bird in Xiangshan county. Order issued by the Nanjing government to execute any communist members. | China | http://trove.nla.gov.au/newspaper/page/24102034 | 24102034 |
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]);