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 |
---|---|---|---|---|---|---|---|---|---|
47620 | 47620 | 1928-12-01 | 2 | c | Jilin may declare independence. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47621 | 47621 | 1928-12-01 | 2 | c | The Nanjing government to borrow foreign loans. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47622 | 47622 | 1928-12-01 | 2 | c | Bandits and thieves in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47623 | 47623 | 1928-12-01 | 2 | c | Zhang Xueliang to return some vehicles to the south. Zhang Xueliang escapes an assassination. Press censorship in Shanghai. Situation changes suddenly in Shandong. Talks halt between China and Portugal on the treaty review. Others news from China. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47624 | 47624 | 1928-12-01 | 2 | d | First cabinet meeting of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47625 | 47625 | 1928-12-01 | 2 | e | He Jian in Hunan province executes key communist figures and the report. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47626 | 47626 | 1928-12-01 | 2 | f | Zhang Xueliang is reluctant to give up Rehe province. | China | http://trove.nla.gov.au/newspaper/page/24099034 | 24099034 | |
47627 | 47627 | 1928-12-01 | 3 | b | Jiangxi province under the new administration. | China | http://trove.nla.gov.au/newspaper/page/24099033 | 24099033 | |
47629 | 47629 | 1928-12-01 | 3 | d | The Social Security Maintenance Society in Jinan, Shandong, and a report on its true feature. | China | http://trove.nla.gov.au/newspaper/page/24099033 | 24099033 | |
47630 | 47630 | 1928-12-01 | 3 | f | Yan Xishan is going to Nanjing and might be minister of internal affairs. | China | http://trove.nla.gov.au/newspaper/page/24099033 | 24099033 | |
47632 | 47632 | 1928-12-01 | 6-7 | a-d | Guangdong news/ Official inspection on opium smuggling and the obstacles. Li Jishen is returning from Nanjing. Drought in Guangdong and the damages. The Communists never stop making trouble. Businessmen demand the government to repay the bonds. Road construction in Gaoyao and the turbulence. Fire in Xinqiao town, of Gaoyao county. Public security troops in Dongguan on the way to suppress bandits. Peasants in Panyu county appeal for tax reduction. Bandit chieftain Tang Jiannan in Xinhui county is arrested. Street construction in Xinhui county. Bandits in Enping county. Evil gentry punished in Shunde county. | China | http://trove.nla.gov.au/newspaper/page/24099038 | 24099038 | |
47633 | 47633 | 1928-12-01 | 8 | a | Troops in Beiping harass trams. | China | http://trove.nla.gov.au/newspaper/page/24099040 | 24099040 | |
47635 | 47635 | 1928-12-01 | 8 | a | Talks between China and Japan halt again. | China | http://trove.nla.gov.au/newspaper/page/24099040 | 24099040 |
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]);