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 |
---|---|---|---|---|---|---|---|---|---|
53111 | 53111 | 1933-07-29 | 2 | c | China and Japan start their second meeting in Tianjin for truce issues. | China | http://trove.nla.gov.au/newspaper/page/24091310 | 24091310 | |
53112 | 53112 | 1933-07-29 | 2 | d | Chinese army commanders demand Shen Honglie to step down. | China | http://trove.nla.gov.au/newspaper/page/24091310 | 24091310 | |
53113 | 53113 | 1933-07-29 | 2 | e | Feng Yuxiang on the crisis in Chaha'er, north China. | China | http://trove.nla.gov.au/newspaper/page/24091310 | 24091310 | |
53114 | 53114 | 1933-07-29 | 2 | e | Jiang Jieshi repeatedly orders to ban banquets, gambling and similar things. | China | http://trove.nla.gov.au/newspaper/page/24091310 | 24091310 | |
53115 | 53115 | 1933-07-29 | 2 | f | Circular telegram issued by Fang Zhenwu against the loans from America. | China | http://trove.nla.gov.au/newspaper/page/24091310 | 24091310 | |
53116 | 53116 | 1933-07-29 | 3 | a | Japanese troops give their territories to the Manchurian army. | China | http://trove.nla.gov.au/newspaper/page/24091309 | 24091309 | |
53117 | 53117 | 1933-07-29 | 3 | b | Railways in north Manchuria stop operation. | China | http://trove.nla.gov.au/newspaper/page/24091309 | 24091309 | |
53118 | 53118 | 1933-07-29 | 3 | b | Yan Huiqing, Gu Weijun and Guo Taiqi condemn the southwest authority. | China | http://trove.nla.gov.au/newspaper/page/24091309 | 24091309 | |
53119 | 53119 | 1933-07-29 | 3 | b | Another report on the loans from America for the cotton growing in China. | China | http://trove.nla.gov.au/newspaper/page/24091309 | 24091309 | |
53120 | 53120 | 1933-07-29 | 3 | c | Japan seeks to occupy Sakhalin island. | China | http://trove.nla.gov.au/newspaper/page/24091309 | 24091309 | |
53122 | 53122 | 1933-07-29 | 3 | d | Overseas Chinese Commission of the Nanjing government to help the Chinese overseas. | China | http://trove.nla.gov.au/newspaper/page/24091309 | 24091309 | |
53123 | 53123 | 1933-07-29 | 3 | e | Japan to propose joint defence alliance with China. | China | http://trove.nla.gov.au/newspaper/page/24091309 | 24091309 | |
53126 | 53126 | 1933-07-29 | 5 | a | Poems by Yang Xingfo who is assassinated in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091311 | 24091311 | |
53130 | 53130 | 1933-07-29 | 7-8 | a-f | Guangdong news/ The southwest authority condemns the compromise with Japanese invaders. Armies in Chaha'er support Feng Yuxiang and against the compromise. Zou Lu on the fighting Japanese and the Chinese politics. New warplanes arrive Guangzhou. Business in Guangzhou. A school principal in Guangzhou suicides for love. Bandits in Dongguan. | China | http://trove.nla.gov.au/newspaper/page/24091313 | 24091313 | |
53131 | 53131 | 1933-07-29 | 6 | a | Japanese are searching gold mines in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091314 | 24091314 | |
53133 | 53133 | 1933-07-29 | 6 | b | Feng Yuxiang and his victory. | China | http://trove.nla.gov.au/newspaper/page/24091314 | 24091314 |
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]);