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 |
---|---|---|---|---|---|---|---|---|---|
54646 | 54646 | 1934-11-10 | 2 | a | Editorial on the suggestions of the southwest authority and the freedom of speech. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096224 | 24096224 | |
54647 | 54647 | 1934-11-10 | 2 | c | Jiang Jieshi to appoint Gu Zhutong command the eastern route armies. | China | http://trove.nla.gov.au/newspaper/page/24096224 | 24096224 | |
54648 | 54648 | 1934-11-10 | 2 | d | Feng Yuxiang, Lu Zhonglin and others support Hu Hanmin. | China | http://trove.nla.gov.au/newspaper/page/24096224 | 24096224 | |
54649 | 54649 | 1934-11-10 | 2 | d | The Nationalist government in Nanjing to discuss north China issues. | China | http://trove.nla.gov.au/newspaper/page/24096224 | 24096224 | |
54650 | 54650 | 1934-11-10 | 2 | e | Jiang Jieshi arrives Wuhan. Resistance of Chinese troops to Japanese invaders in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096224 | 24096224 | |
54651 | 54651 | 1934-11-10 | 3 | a | Chinese communities in Boston welcome General Cai Tingkai. | America | http://trove.nla.gov.au/newspaper/page/24096223 | 24096223 | |
54652 | 54652 | 1934-11-10 | 3 | b | Taiwanese people demand autonomy from Japanese rulers. | China | http://trove.nla.gov.au/newspaper/page/24096223 | 24096223 | |
54653 | 54653 | 1934-11-10 | 3 | d | Song Ziwen on the water projects and the unified administration. | China | http://trove.nla.gov.au/newspaper/page/24096223 | 24096223 | |
54654 | 54654 | 1934-11-10 | 3 | e | Japanese authority deports more Chinese immigrants. | China | http://trove.nla.gov.au/newspaper/page/24096223 | 24096223 | |
54655 | 54655 | 1934-11-10 | 7-8 | a-f | Guangdong news/ The central government in Nanjing replies to the southwest for their suggestions. Jiang Jieshi and Wang Jingwei have different comments on Hu Hanmin's suggestions. Press censorship abolished in Guangdong. Provincial legislature assembly suggests the government on social morality. Finance in Guangdong. Matches industry in Macao. Prisoners in Xinhui county and their petitions. Clan fighting in Nanhai county. Protest against the magistrate in Zhongshan county. Typhoon in Zhaoqing and the casualties. | China | http://trove.nla.gov.au/newspaper/page/24096227 | 24096227 | |
54656 | 54656 | 1934-11-10 | 6 | a | Jewish people attacked in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24096228 | 24096228 | |
54657 | 54657 | 1934-11-10 | 6 | a | The King of Thailand. | Britain | http://trove.nla.gov.au/newspaper/page/24096228 | 24096228 | |
54658 | 54658 | 1934-11-10 | 6 | b | Guangdong troops defeat the communist army in south Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24096228 | 24096228 | |
54659 | 54659 | 1934-11-10 | 6 | b | Russian submarines threaten Japanese. | Japan | http://trove.nla.gov.au/newspaper/page/24096228 | 24096228 | |
54660 | 54660 | 1934-11-10 | 6 | c | The power of Germany. | France | http://trove.nla.gov.au/newspaper/page/24096228 | 24096228 | |
54661 | 54661 | 1934-11-10 | 6 | d | French people advocate cooperation with Russian. | France | http://trove.nla.gov.au/newspaper/page/24096228 | 24096228 | |
54662 | 54662 | 1934-11-10 | 6 | d | Chinese labourers smuggled into New York. | America | http://trove.nla.gov.au/newspaper/page/24096228 | 24096228 | |
54663 | 54663 | 1934-11-10 | 6 | e | Australia news/ Italian Chamber of Commerce in Sydney and their dinner party. Counterfeit bank notes found in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096228 | 24096228 |
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]);