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 |
|---|---|---|---|---|---|---|---|---|---|
| 42449 | 42449 | 1924-12-20 | 2 | a-b | Editorial on the proposed peace conference in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100971 | 24100971 | |
| 42450 | 42450 | 1924-12-20 | 2-3 | b-a | China's diplomacy during the political turmoil. | China | http://trove.nla.gov.au/newspaper/page/24100971 | 24100971 | |
| 42451 | 42451 | 1924-12-20 | 3 | a | Foreign missions approve Chinese government to increase the tariff level. | China | http://trove.nla.gov.au/newspaper/page/24100970 | 24100970 | |
| 42452 | 42452 | 1924-12-20 | 3 | a-b | Tang Jiyao talks on the current situation. | China | http://trove.nla.gov.au/newspaper/page/24100970 | 24100970 | |
| 42453 | 42453 | 1924-12-20 | 3 | b-c | Saving Guangdong Association and the Guangdong provincial legislature assembly are trying to drive Sun Yatsen out of Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100970 | 24100970 | |
| 42454 | 42454 | 1924-12-20 | 3 | c-d | Feng Yuxiang leads his army back to Beijing and the report. | China | http://trove.nla.gov.au/newspaper/page/24100970 | 24100970 | |
| 42455 | 42455 | 1924-12-20 | 3 | e | Heavy fog in London. | Britain | http://trove.nla.gov.au/newspaper/page/24100970 | 24100970 | |
| 42456 | 42456 | 1924-12-20 | 3 | e | News about Feng Yuxiang and Zhang Zuolin. Order of appointment issued by the Beijing government. | China | http://trove.nla.gov.au/newspaper/page/24100970 | 24100970 | |
| 42457 | 42457 | 1924-12-20 | 3 | f | A woman tries to assassinate Russian ambassador in France. | Britain | http://trove.nla.gov.au/newspaper/page/24100970 | 24100970 | |
| 42458 | 42458 | 1924-12-20 | 3 | f | A Japanese ship sinks in the storm. | Japan | http://trove.nla.gov.au/newspaper/page/24100970 | 24100970 | |
| 42459 | 42459 | 1924-12-20 | 5 | a-d | Articles written by anonymous authors condemn Huang Laiwang, secretary of the Guomindang group in Sydney, Xu Richu, Liu Boming and other Sydney Nationalist Party members for their radical ideas. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100972 | 24100972 | |
| 42460 | 42460 | 1924-12-20 | 6 | a-b | Self-defence corps of the Guangdong commercial chambers retreat and their declaration. | China | http://trove.nla.gov.au/newspaper/page/24100975 | 24100975 | |
| 42461 | 42461 | 1924-12-20 | 6 | b | A letter from Cao Kun to Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24100975 | 24100975 | |
| 42462 | 42462 | 1924-12-20 | 6 | b-c | Qi Xieyuan supports Duan Qirui in words but is against him in deeds. | China | http://trove.nla.gov.au/newspaper/page/24100975 | 24100975 | |
| 42463 | 42463 | 1924-12-20 | 6 | c-e | Articles written by anonymous authors condemn Huang Laiwang, secretary of the Guomindang group in Sydney, for his radical ideas. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100975 | 24100975 | |
| 42464 | 42464 | 1924-12-20 | 7 | a | A farmer association in New South Wales and its attitude towards Chinese market gardeners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
| 42465 | 42465 | 1924-12-20 | 7 | a | A shop burglary in Sydney and the investigation. | Australia | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
| 42466 | 42466 | 1924-12-20 | 7 | a | A robbery in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
| 42467 | 42467 | 1924-12-20 | 7 | a | Thirty gamblers are arrested in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
| 42468 | 42468 | 1924-12-20 | 7 | a | Fire in Sydney destroys quite a few shops. | Australia | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
| 42469 | 42469 | 1924-12-20 | 7 | b | A bank robbery in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
| 42470 | 42470 | 1924-12-20 | 7 | b | The Chinese Students Association in Melbourne and its restructure. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
| 42471 | 42471 | 1924-12-20 | 7 | c | Sydney Chinese School starts holiday, the examination and sports game. And a letter from the Chinese Consul-General Wei Zijiu from Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
| 42472 | 42472 | 1924-12-20 | 7 | c | French Prime Minister is ill. | France | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
| 42473 | 42473 | 1924-12-20 | 7 | d | Chinese communities in Australia set up an organisation in order to maintain the boycott to Japanese liner service and its first public notice. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
| 42474 | 42474 | 1924-12-20 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
| 42475 | 42475 | 1924-12-20 | 8 | a-d | Guangdong news/ Guangdong people request politicians in the north to condemn Sun Yatsen. Sun Yatsen's government seals up more properties owned by businessmen. Guangdong commercial chambers to elect the chairman. Troops and their looting in Guangzhou. Hunan army in Shaoguan and their pressgang. Chen Jiongming to be the general commander. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100977 | 24100977 | |
| 42476 | 42476 | 1924-12-20 | 8 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100977 | 24100977 | |
| 42477 | 42477 | 1924-12-20 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100977 | 24100977 |
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]);