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 |
---|---|---|---|---|---|---|---|---|---|
56049 | 56049 | 1936-07-11 | 3 | e | A notice issued by the Chinese Chamber of Commerce in New South Wales on the immigration and other trade issues. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 | |
56055 | 56055 | 1936-07-11 | 5 | d | Advertisement and picture of the Simpson Lee's shop in Sydney. | Other... | http://trove.nla.gov.au/newspaper/page/24096915 | 24096915 | |
56054 | 56054 | 1936-07-11 | 5 | c | Advertisement of the British American Assurance Company in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096915 | 24096915 | |
56050 | 56050 | 1936-07-11 | 3 | f | Advertisement of the Hop Lee & Company in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 | |
56060 | 56060 | 1936-07-11 | 8 | f | Australia news/ Australian government suspends trade talks with Japan. Australian exports sandalwood to China. Australia to supply wheat, meet and rice to Britain. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096920 | 24096920 | |
56053 | 56053 | 1936-07-11 | 5 | c | Chinese communities in New Zealand and Australia donate to the Lingnan University in Guangzhou and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096915 | 24096915 | |
56037 | 56037 | 1936-07-11 | 2 | b | Circular telegrams issued by the Southwest authorities to protest against more Japanese troops in north China. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56038 | 56038 | 1936-07-11 | 2 | c | Dispute between Guangzhou and Nanjing over the resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56056 | 56056 | 1936-07-11 | 6-7 | a-d | Guangdong news/ The Southwest authority and their plan to fight Japanese invasion. The new notes issued by Guangdong banks. Buddhists in Guangzhou pray for peace. The Nanjing government may have military conflict with Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24096918 | 24096918 | |
56057 | 56057 | 1936-07-11 | 8 | a | Heavy rains and floods in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096920 | 24096920 | |
56040 | 56040 | 1936-07-11 | 2 | f | Japanese argues for their military existence in north China. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56043 | 56043 | 1936-07-11 | 3 | a | Japanese cabinet and their new military budget. | Japan | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 | |
56042 | 56042 | 1936-07-11 | 3 | a | Japanese economic invasion of China. | China | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 | |
56058 | 56058 | 1936-07-11 | 8 | a | Japanese newspaper reports that Germany sells weapons to China. | Japan | http://trove.nla.gov.au/newspaper/page/24096920 | 24096920 | |
56046 | 56046 | 1936-07-11 | 3 | d | Japanese organise self-government authority in Inner Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 | |
56047 | 56047 | 1936-07-11 | 3 | e | Japanese send more airforce troops to Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 | |
56045 | 56045 | 1936-07-11 | 3 | a | Japanese smuggling in north China. | China | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 | |
56059 | 56059 | 1936-07-11 | 8 | b | King of Algeria speaks to the League of Nations. | Britain | http://trove.nla.gov.au/newspaper/page/24096920 | 24096920 | |
56051 | 56051 | 1936-07-11 | 5 | a | Lover in the picture. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096915 | 24096915 | |
56041 | 56041 | 1936-07-11 | 2 | f | Many students are leaving Tianjin for the south. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56039 | 56039 | 1936-07-11 | 2 | e | New deals between the Nanjing government and Japan. | China | http://trove.nla.gov.au/newspaper/page/24096912 | 24096912 | |
56052 | 56052 | 1936-07-11 | 5 | b | Story of Mu Guiying, heroine of the Song Dynasty. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096915 | 24096915 | |
56044 | 56044 | 1936-07-11 | 3 | a | The war clouds over north China. | China | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 | |
56048 | 56048 | 1936-07-11 | 3 | e | Zou Lu talks in Manila. | Other... | http://trove.nla.gov.au/newspaper/page/24096913 | 24096913 |
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]);