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 |
---|---|---|---|---|---|---|---|---|---|
45728 | 45728 | 1927-05-21 | 2 | c-d | The independence of Mongolia and its influence upon China. | China | http://trove.nla.gov.au/newspaper/page/24101992 | 24101992 | |
45730 | 45730 | 1927-05-21 | 2 | e | Chinese communist leader Li Dazhao is arrested in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24101992 | 24101992 | |
45731 | 45731 | 1927-05-21 | 3 | c | Refugees from Shandong and Zhili (Hebei) province flee to the Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
45734 | 45734 | 1927-05-21 | 3 | e | Ye Kaixin is appointed army commander. | China | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
45735 | 45735 | 1927-05-21 | 3 | e | Foreign ministry in Beijing stops the redundancy plan. | China | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
45737 | 45737 | 1927-05-21 | 3 | f | Victory celebration in Nanjing, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
45741 | 45741 | 1927-05-21 | 7 | b | A dead boy walks in Linqing county, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24101995 | 24101995 | |
45743 | 45743 | 1927-05-21 | 8 | a-d | Guangdong news/ Jiang Jieshi praises various social associations for their anti-Communist attitude. Qian Dajun reports the suppression of communists. Russians move out of Guangzhou. British, Japanese and American consuls congratulate the suppress of communists. The Chinese Communist Party members under arrest in Guangzhou. Commercial chambers and the interest of peasants' association. Agricultural and industrial authority and their response to the Communists. Special committee set up in Guangzhou on the rights of workers. Liang Lin is released from the prison. The Communist weekly newspaper Xiangdao (The Guide) is closed in Guangzhou. Public Security in Guangzhou requests to ban entry of newspapers from Hankou. Kidnap and ransom in the Peiying School in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101998 | 24101998 |
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]);