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 |
---|---|---|---|---|---|---|---|---|---|
47139 | 47139 | 1928-06-16 | 2 | c | Report on Japanese invasion in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098842 | 24098842 | |
47141 | 47141 | 1928-06-16 | 2 | f | Associations in Shanghai and their protest gathering against Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24098842 | 24098842 | |
47142 | 47142 | 1928-06-16 | 3 | b | The war between Chinese and Japanese troops before the fall of Jinan, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098841 | 24098841 | |
47143 | 47143 | 1928-06-16 | 3 | d | The conspiracy of Soviet Russia in China. | China | http://trove.nla.gov.au/newspaper/page/24098841 | 24098841 | |
47144 | 47144 | 1928-06-16 | 3 | e | Japanese conscription in the south and north of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098841 | 24098841 | |
47147 | 47147 | 1928-06-16 | 5 | c | Two women in Sichuan province share a husband and the report. | China | http://trove.nla.gov.au/newspaper/page/24098843 | 24098843 | |
47148 | 47148 | 1928-06-16 | 6 | a-d | Guangdong news/ Guangdong is raising funds for the Northern Expedition. Anti-Japanese movement in Guangzhou. Provincial government is purchasing weapons from overseas. Provincial government promotes local products. Municipal government promotes Chinese-style clothes. | China | http://trove.nla.gov.au/newspaper/page/24098846 | 24098846 | |
47149 | 47149 | 1928-06-16 | 7 | a-d | Guangdong news/ Yulin port to be built in the Hainan island. The Chinese Communist Party is to start uprising in Bao'an county. Magistrate of Dianbai county absconds with public funds. Zhongshan county magistrate Liang Hongguang disbands more than 60 trade unions. Civil corps in Zhongshan county. Defence troops in Dongguan county suppress peasant bandits. Sand land in Dongguan county. Robbery in Gaoyao county. The ceramic industry in Nanhai county. Bandits in Shunde hijack cargo ship. | China | http://trove.nla.gov.au/newspaper/page/24098845 | 24098845 | |
47151 | 47151 | 1928-06-16 | 8 | a | Zhang Zongchang demands more payment before retreat. Feng Yuxiang and his defection. | China | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
47154 | 47154 | 1928-06-16 | 8 | b | The Nationalist government in Nanjing and its declaration of foreign policy. | China | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
47155 | 47155 | 1928-06-16 | 8 | b | Japanese residence in Shanghai is bombed. | China | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
47156 | 47156 | 1928-06-16 | 8 | c | Nanjing has become capital of the Nationalist government. | China | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 |
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]);