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 | |
55855 | 55855 | 1936-03-07 | 3 | a | Chinese military commander Fu Zuoyi arrives Beijing. | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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]);