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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
55859 | 55859 | 1936-03-07 | 3 | c | Policy statement of the new French cabinet. | France | 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 | |
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 | |
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 | |
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 | |
55865 | 55865 | 1936-03-07 | 8 | e | Germany seeks a peace treaty with France. | Britain | 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 | |
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 | |
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]);