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 |
---|---|---|---|---|---|---|---|---|---|
53441 | 53441 | 1933-10-28 | 2 | c | Memorial gathering in China on September 18. | China | http://trove.nla.gov.au/newspaper/page/24091414 | 24091414 | |
53442 | 53442 | 1933-10-28 | 2 | d | Fang Zhenwu and his troops occupy Huairou, south suburb of Beijing. | China | http://trove.nla.gov.au/newspaper/page/24091414 | 24091414 | |
53443 | 53443 | 1933-10-28 | 2 | d | Liu Wenhui in Sichuan refuses to join to suppress the communists. | China | http://trove.nla.gov.au/newspaper/page/24091414 | 24091414 | |
53444 | 53444 | 1933-10-28 | 2 | e | Chaos return in Guizhou province. | China | http://trove.nla.gov.au/newspaper/page/24091414 | 24091414 | |
53445 | 53445 | 1933-10-28 | 2 | e | New appointment by the Council of Administration in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091414 | 24091414 | |
53446 | 53446 | 1933-10-28 | 2 | f | Wu Peifu is active again in north China. | China | http://trove.nla.gov.au/newspaper/page/24091414 | 24091414 | |
53447 | 53447 | 1933-10-28 | 2 | f | Jiang Zuobin to be back to his office in Nanjing. Ministry of Finance to collect special levy on imported rice. Ma Zhanshan's representative office in Shanghai is closed. | China | http://trove.nla.gov.au/newspaper/page/24091414 | 24091414 | |
53449 | 53449 | 1933-10-28 | 3 | a | Soviet Russia dispatches more troops to the Far East. | China | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53454 | 53454 | 1933-10-28 | 3 | d | Candidates of Japanese ambassador to China. | China | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53457 | 53457 | 1933-10-28 | 3 | e | Russian's plan for warship building. | China | http://trove.nla.gov.au/newspaper/page/24091413 | 24091413 | |
53459 | 53459 | 1933-10-28 | 5 | b | Song Meiling to reform the education system. | China | http://trove.nla.gov.au/newspaper/page/24091415 | 24091415 | |
53460 | 53460 | 1933-10-28 | 5 | c | Whereabouts of Wang Delin. | China | http://trove.nla.gov.au/newspaper/page/24091415 | 24091415 | |
53464 | 53464 | 1933-10-28 | 7-8 | a-f | Guangdong news/ Public gathering in Guangzhou on September 18. Zou Lu and Deng Zeru return to work. Terror in Guangzhou. Chen Jiongming dies in Hong Kong. Guangdong troops enter west Fujian province. Zou Lu is to tour overseas again. Rice businessmen stop shipping of rice into Guangzhou. Finance in Guangzhou before the Mid-Autumn Festival. Female doctor is robbed in Taishan county. Sericulture in decline in Zhongshan county and its influence upon education. A man returns to life 18 years after his death. | China | http://trove.nla.gov.au/newspaper/page/24091417 | 24091417 | |
53465 | 53465 | 1933-10-28 | 6 | a | Royalties in Mongolia seek for self-administration. | China | http://trove.nla.gov.au/newspaper/page/24091418 | 24091418 | |
53468 | 53468 | 1933-10-28 | 6 | c | Japanese goods enter north China. Japanese ambassador to Beijing. | China | http://trove.nla.gov.au/newspaper/page/24091418 | 24091418 |
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]);