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 |
---|---|---|---|---|---|---|---|---|---|
53817 | 53817 | 1934-02-03 | 2 | b | Battles between Fujian troops and the armies of the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24091519 | 24091519 | |
53818 | 53818 | 1934-02-03 | 2 | c | Liu Guitang and his troops commit banditry again. | China | http://trove.nla.gov.au/newspaper/page/24091519 | 24091519 | |
53819 | 53819 | 1934-02-03 | 2 | e | Japanese seek to invade Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091519 | 24091519 | |
53820 | 53820 | 1934-02-03 | 2 | f | Plan of autonomous administration in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24091519 | 24091519 | |
53821 | 53821 | 1934-02-03 | 3 | a | News on the war between Fujian troops and Jiang Jieshi's army. | China | http://trove.nla.gov.au/newspaper/page/24091518 | 24091518 | |
53824 | 53824 | 1934-02-03 | 3 | e | Japan has agreed to protect the puppet Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24091518 | 24091518 | |
53827 | 53827 | 1934-02-03 | 5 | f | Tianjin customs detains smuggled antiques. | China | http://trove.nla.gov.au/newspaper/page/24091520 | 24091520 | |
53828 | 53828 | 1934-02-03 | 7-8 | a-f | Guangdong news/ Sun Ke arrives Guangzhou. Military officers from the north welcome Zhang Xueliang in Hong Kong. Zhang Renmin arrives Guangzhou from Guangxi. Xiang Hanpin resigns from the position of appeasement commissioner. Effort to promote trade between Australia, Hong Kong and the Nanyang area. Guangzhou commercial chamber to help local paper industry. Gambling in Taishan. A man returned from overseas is defrauded in Xinhui. | China | http://trove.nla.gov.au/newspaper/page/24091522 | 24091522 | |
53829 | 53829 | 1934-02-03 | 6 | f | The Nationalist government in Nanjing adopts Western calendar. | China | http://trove.nla.gov.au/newspaper/page/24091523 | 24091523 |
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]);