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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
55847 | 55847 | 1936-03-07 | 2 | a | Advertisement of Hong Sing & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096768 | 24096768 | |
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 | |
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 | |
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 | |
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 | |
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 | |
55855 | 55855 | 1936-03-07 | 3 | a | Chinese military commander Fu Zuoyi arrives Beijing. | China | http://trove.nla.gov.au/newspaper/page/24096767 | 24096767 | |
55853 | 55853 | 1936-03-07 | 2 | f | Chu Minyi is going to visit Germany. | China | http://trove.nla.gov.au/newspaper/page/24096768 | 24096768 | |
55866 | 55866 | 1936-03-07 | 8 | e | French parliament approves the treaty with Russia. | Russia | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);