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 |
---|---|---|---|---|---|---|---|---|---|
53983 | 53983 | 1934-03-24 | 2 | b | Zhang Xueliang arrives Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091573 | 24091573 | |
53984 | 53984 | 1934-03-24 | 2 | c | Bank of Anhui is closed down. | China | http://trove.nla.gov.au/newspaper/page/24091573 | 24091573 | |
53985 | 53985 | 1934-03-24 | 2 | c | Murderer of Li Minzhou, manager of the Sun Sun Company in Shanghai, is sentenced to life imprisonment. | China | http://trove.nla.gov.au/newspaper/page/24091573 | 24091573 | |
53986 | 53986 | 1934-03-24 | 2 | c | China news/ Sichuan troops join to suppress the communists. Battle in the south of Xinjiang. Guangxi provincial authority trains county magistrates. The autonomous administration in Mongolia. Japanese ambassador meets Wang Jingwei. | China | http://trove.nla.gov.au/newspaper/page/24091573 | 24091573 | |
53987 | 53987 | 1934-03-24 | 3 | a | Fu Zuoyi returns to commander his troops in Suiyuan. | China | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53988 | 53988 | 1934-03-24 | 3 | a | Japanese goods on the Beijing market. | China | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53989 | 53989 | 1934-03-24 | 3 | b | Yan Huiqing talks on his arrival in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53990 | 53990 | 1934-03-24 | 3 | c | Japanese administration of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53992 | 53992 | 1934-03-24 | 3 | e | China and Britain sign nonaggression treaty. | China | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53995 | 53995 | 1934-03-24 | 3 | f | Japanese are building airports in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
53997 | 53997 | 1934-03-24 | 5 | a | Feng Yuxiang and his hobby. | China | http://trove.nla.gov.au/newspaper/page/24091574 | 24091574 | |
54001 | 54001 | 1934-03-24 | 7-8 | a-f | Guangdong news/ Reform of the provincial administration and the candidates for governor. The whereabouts of Cai Tingkai. Reform of provincial administration and the Party affairs. The Guangzhou market during the Chinese New Year. All civilians are required to register. The business in Guangzhou last year. Grain supply in the coming Spring. Bandit chieftain arrested in Enping. Clan clashes in Shunde. | China | http://trove.nla.gov.au/newspaper/page/24091576 | 24091576 |
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]);