This data as json, CSV (advanced)
Suggested facets: page, column, description, page_url, trove_id
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46182 | 46182 | 1927-09-17 | 5 | a | Feng Yuxiang dispatches troops to attack Shandong. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46183 | 46183 | 1927-09-17 | 5 | a | Anti-Japanese movement in Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46200 | 46200 | 1927-09-17 | 7 | a | Epidemic disease in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24098531 | 24098531 | |
46205 | 46205 | 1927-09-17 | 9 | a-d | Guangdong news/ Qualification requirements for county magistrates. Epidemic disease in Guangzhou and Macao. Matches industry and foreign encroachment. Preliminary training program set up at the Huangpu Military Academy. Bandits and robbery in Xinhui county. Water levels going up in major rivers. New law on divorce. Village looted on the border of Zengcheng and Boluo. Bandits and their fighting in Zhongshan county. | China | |||
46178 | 46178 | 1927-09-17 | 3 | b | Chinese students returned from Russia and their talks on the life in Russian universities. | China | http://trove.nla.gov.au/newspaper/page/24098527 | 24098527 | |
46179 | 46179 | 1927-09-17 | 3 | b | President of Korea is arrested in Harbin, Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24098527 | 24098527 | |
46189 | 46189 | 1927-09-17 | 5 | b | Martial law in Hankou. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46190 | 46190 | 1927-09-17 | 5 | b | Comprise between Nanjing and Wuhan. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46195 | 46195 | 1927-09-17 | 5 | b | Borodin is detained in Xin'an, Henan province. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46201 | 46201 | 1927-09-17 | 7 | b | Anti-Japanese movement in Fengtian. | China | http://trove.nla.gov.au/newspaper/page/24098531 | 24098531 | |
46203 | 46203 | 1927-09-17 | 7 | b | New moves of the Red Army in Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24098531 | 24098531 | |
46173 | 46173 | 1927-09-17 | 2 | b-c | The Wuhan government authority announces the conspiracy of the Chinese Communist Party and the full report. | China | http://trove.nla.gov.au/newspaper/page/24098528 | 24098528 | |
46180 | 46180 | 1927-09-17 | 3 | c | Norweign scientist on field research in China. | China | http://trove.nla.gov.au/newspaper/page/24098527 | 24098527 | |
46191 | 46191 | 1927-09-17 | 5 | c | Liu Zuolong executes his deputy. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46192 | 46192 | 1927-09-17 | 5 | c | Yan Xishan on the current situations. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46193 | 46193 | 1927-09-17 | 5 | c | Jiang Yanxing is drowned. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46194 | 46194 | 1927-09-17 | 5 | c | Economic panic in Hankou. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46196 | 46196 | 1927-09-17 | 5 | c | Peng Hanzhang is executed. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46204 | 46204 | 1927-09-17 | 7 | c | Branch of foreign banks in China and their profit. | China | http://trove.nla.gov.au/newspaper/page/24098531 | 24098531 | |
46174 | 46174 | 1927-09-17 | 2 | d | Chaos in Tianjin due to the different currency units. | China | http://trove.nla.gov.au/newspaper/page/24098528 | 24098528 | |
46181 | 46181 | 1927-09-17 | 3 | d | Zhang Xueliang talks about comprise to Japanese journalists. | China | http://trove.nla.gov.au/newspaper/page/24098527 | 24098527 | |
46197 | 46197 | 1927-09-17 | 5 | d | Liu Zuolong is executed. | China | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
46176 | 46176 | 1927-09-17 | 2 | e | Wu Zhixin is arrested in Qingdao and the report. | China | http://trove.nla.gov.au/newspaper/page/24098528 | 24098528 |
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]);