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 |
---|---|---|---|---|---|---|---|---|---|
47419 | 47419 | 1928-09-15 | 2 | c | A reply from the Japanese government to China's request to abrogate treaties. | China | http://trove.nla.gov.au/newspaper/page/24098946 | 24098946 | |
47420 | 47420 | 1928-09-15 | 2 | e | A meeting of the Central Executive Committee of the Nationalist Party, attendants and the resolutions. | China | http://trove.nla.gov.au/newspaper/page/24098946 | 24098946 | |
47421 | 47421 | 1928-09-15 | 2 | f | Shandong people appeal for help and their organisations in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24098946 | 24098946 | |
47422 | 47422 | 1928-09-15 | 2 | f | Japanese have different policy in Manchuria, Mongolia and inland China. | China | http://trove.nla.gov.au/newspaper/page/24098946 | 24098946 | |
47423 | 47423 | 1928-09-15 | 3 | b | A public gathering in Shanghai and their appeals to the Nationalist government in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098945 | 24098945 | |
47424 | 47424 | 1928-09-15 | 3 | c | Japanese troops in Jinan, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098945 | 24098945 | |
47425 | 47425 | 1928-09-15 | 3 | e | The Communist Party is still very active in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24098945 | 24098945 | |
47427 | 47427 | 1928-09-15 | 6-7 | a-d | Guangdong news/ Recent labour movement in Guangzhou. Communist forces arrive Guangdong from Hunan province. Key Communist activists arrested in Guangzhou for inciting strike. Director of the Guangzhou railway bureau Lao Mian and the comments by journalism. Smuggled submarine mines detected in Guangzhou. Ban on gambling might be lifted soon in Guangzhou. Wang Qingyu and his plan for afforestation in the north of Guangdong. Gentry from Guangning, Zengcheng and Fogang counties appeal for help for the suppression of bandits. Bandits in Dongguan county. Illegal prostitutes executed in Zhaoqing. News from Taishan. Bandits in Shunde. Minority peoples in Hainan island and their civilisations. Yao minority people oppose to the appointment of new director of the Yao People Affairs Bureau in Guangzhou. Bandits in Gaoming. | China | http://trove.nla.gov.au/newspaper/page/24098950 | 24098950 |
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]);