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 |
---|---|---|---|---|---|---|---|---|---|
53280 | 53280 | 1933-09-16 | 2 | c | A circular telegram issued by Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24091366 | 24091366 | |
53281 | 53281 | 1933-09-16 | 2 | d | The communist troops attack Shanghang and Liancheng in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091366 | 24091366 | |
53282 | 53282 | 1933-09-16 | 2 | d | Black list prepared by the Blue Clothes Society in Shanghai for the purpose of assassination. | China | http://trove.nla.gov.au/newspaper/page/24091366 | 24091366 | |
53283 | 53283 | 1933-09-16 | 2 | e | Volunteer Chinese armies in Jilin province and their resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091366 | 24091366 | |
53284 | 53284 | 1933-09-16 | 2 | f | Donations to Ma Zhanshan's army are misused. | China | http://trove.nla.gov.au/newspaper/page/24091366 | 24091366 | |
53285 | 53285 | 1933-09-16 | 2 | f | Wang Jingwei on the current situation. | China | http://trove.nla.gov.au/newspaper/page/24091366 | 24091366 | |
53286 | 53286 | 1933-09-16 | 2 | f | Communist bandits leave north Sichuan province for the south Shaanxi. | China | http://trove.nla.gov.au/newspaper/page/24091366 | 24091366 | |
53287 | 53287 | 1933-09-16 | 3 | a | Japanese invasion of Chaha'er, north China. | China | http://trove.nla.gov.au/newspaper/page/24091365 | 24091365 | |
53288 | 53288 | 1933-09-16 | 3 | b | The war clouds over the Pacific Ocean. | China | http://trove.nla.gov.au/newspaper/page/24091365 | 24091365 | |
53291 | 53291 | 1933-09-16 | 3 | e | Ji Hongchang is injured in an assassination. | China | http://trove.nla.gov.au/newspaper/page/24091365 | 24091365 | |
53293 | 53293 | 1933-09-16 | 5 | e | Ma Zhanshan lists all donations he has received, part I. | China | http://trove.nla.gov.au/newspaper/page/24091367 | 24091367 | |
53295 | 53295 | 1933-09-16 | 7-8 | a-f | Guangdong news/ Guangdong authority issues a circular telegram and refuses to acknowledge the Plenary Session in Nanjing. Guangdong military officers on the border of Fujian and Guangdong. Li Zongren appoints some officers who are removed in the past. The 19th Route Army to reduce salary payment in order to purchase more weapons. A ferry is bombed in Guangzhou. The communist troops in Jieyang and Chaozhou area. Village life in Chaozhou and Meixian county. Bandits in Panyu. | China | http://trove.nla.gov.au/newspaper/page/24091369 | 24091369 |
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]);