This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid | date | page | column | title | description | source ▼ | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
55865 | 55865 | 1936-03-07 | 8 | e | Germany seeks a peace treaty with France. | Britain | http://trove.nla.gov.au/newspaper/page/24096774 | 24096774 | |
55850 | 55850 | 1936-03-07 | 2 | c | Japanese have finalised their plan to take over north China. | China | http://trove.nla.gov.au/newspaper/page/24096768 | 24096768 | |
55851 | 55851 | 1936-03-07 | 2 | d | The central government in Nanjing imposes strict restriction upon the students' patriotic movement. | China | http://trove.nla.gov.au/newspaper/page/24096768 | 24096768 | |
55852 | 55852 | 1936-03-07 | 2 | e | Yin Rugeng and the Japanese troops in Changping, a surburb of Beijing. | China | http://trove.nla.gov.au/newspaper/page/24096768 | 24096768 | |
55853 | 55853 | 1936-03-07 | 2 | f | Chu Minyi is going to visit Germany. | China | http://trove.nla.gov.au/newspaper/page/24096768 | 24096768 | |
55854 | 55854 | 1936-03-07 | 2 | f | Japanese and Korean people in Tianjin are involved in smuggling. | China | http://trove.nla.gov.au/newspaper/page/24096768 | 24096768 | |
55855 | 55855 | 1936-03-07 | 3 | a | Chinese military commander Fu Zuoyi arrives Beijing. | China | http://trove.nla.gov.au/newspaper/page/24096767 | 24096767 | |
55858 | 55858 | 1936-03-07 | 3 | c | The Shanghai branch of the National Bank to be reopened. | China | http://trove.nla.gov.au/newspaper/page/24096767 | 24096767 | |
55860 | 55860 | 1936-03-07 | 5 | a | Second part of a speech by Hu Hanmin. | China | http://trove.nla.gov.au/newspaper/page/24096769 | 24096769 | |
55863 | 55863 | 1936-03-07 | 6-7 | a-d | Guangdong news/ Kong Xiangxi, Sun Ke, Dai Jitao and Ma Chaojun come to Guangzhou to urge Hu Hanmin come to Nanjing. Chinese woman pilot Li Xiaqing arrives Hong Kong. Kerosene tax to be collected in Guangdong and the influence upon the people's life. Memorial service for the martyrs of the 19th Route Army. Jiahua Bank resumes operation. Statistics on the import and export of Hong Kong. Two cases of fire in Dongguan. Charity institution in Zhongshan. Villagers in Taishan beat local administrator. Obstacles to the setup of policy bureau in Panyu. | China | http://trove.nla.gov.au/newspaper/page/24096772 | 24096772 | |
55867 | 55867 | 1936-03-07 | 8 | f | Chinese government implements compulsory military training of young citizens. | China | http://trove.nla.gov.au/newspaper/page/24096774 | 24096774 | |
55859 | 55859 | 1936-03-07 | 3 | c | Policy statement of the new French cabinet. | France | http://trove.nla.gov.au/newspaper/page/24096767 | 24096767 | |
55857 | 55857 | 1936-03-07 | 3 | c | Students in Egypt continue their anti-British demonstration. | Other... | http://trove.nla.gov.au/newspaper/page/24096767 | 24096767 | |
55864 | 55864 | 1936-03-07 | 8 | a | Mutiny of Japanese troops and the miscellaneous report. | Other... | http://trove.nla.gov.au/newspaper/page/24096774 | 24096774 | |
55866 | 55866 | 1936-03-07 | 8 | e | French parliament approves the treaty with Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096774 | 24096774 | |
55856 | 55856 | 1936-03-07 | 3 | b | New health policy of the Singaporean authority and the influence upon the Chinese fishing ponds. | Singapore | http://trove.nla.gov.au/newspaper/page/24096767 | 24096767 | |
55846 | 55846 | 1936-03-07 | 2 | a | Advertisement of The Wing On Bank Ltd, Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096768 | 24096768 | |
55847 | 55847 | 1936-03-07 | 2 | a | Advertisement of Hong Sing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096768 | 24096768 | |
55848 | 55848 | 1936-03-07 | 2 | a | Advertisement of solicitor E. Farnham Milverton in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096768 | 24096768 | |
55849 | 55849 | 1936-03-07 | 2 | b | Article written by Huang Yanpei on the fourth anniversary of the 1.28 Incident of Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096768 | 24096768 | |
55861 | 55861 | 1936-03-07 | 5 | c | Monkey in the west of Guizhou province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096769 | 24096769 | |
55862 | 55862 | 1936-03-07 | 5 | c | Advertisement of Wing Yuen Tai in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096769 | 24096769 | |
55868 | 55868 | 1936-03-07 | 8 | f | Australia news/ Federal Health Minister back to his office. Japanese fishing boats in New Guinea. Russia sees a good harvest of wheat. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096774 | 24096774 | |
55869 | 55869 | 1936-03-07 | 8 | g | A notice issued by Li Hanzheng to quit partnership of a Chinese market garden near Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096774 | 24096774 |
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]);