This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40088 | 40088 | 1923-07-14 | 2 | a-b | People's resourcefulness is critical to save China, editorial by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094472 | 24094472 | |
40089 | 40089 | 1923-07-14 | 2 | c-d | Members of the Chinese national parliament Ding Foyan and others recommend for presidential election in accordance with the constitution. | China | http://trove.nla.gov.au/newspaper/page/24094472 | 24094472 | |
40090 | 40090 | 1923-07-14 | 3 | a-b | Gu Zhongxiu suggests to issue bonds in order to redeem the railway from Qingdao to Jinan, Shandong province, and the regulations. | China | http://trove.nla.gov.au/newspaper/page/24094471 | 24094471 | |
40091 | 40091 | 1923-07-14 | 3 | b-c | Agenda for the international education conference that to be held in Chicago. | Other... | http://trove.nla.gov.au/newspaper/page/24094471 | 24094471 | |
40092 | 40092 | 1923-07-14 | 3 | c | Beijing authority has different opinions on the suppression to the bandits in Shandong province who hijacked the train and kidnapped some foreign tourists. | China | http://trove.nla.gov.au/newspaper/page/24094471 | 24094471 | |
40093 | 40093 | 1923-07-14 | 3 | d | Tens of thousands of dockers are on strike in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24094471 | 24094471 | |
40094 | 40094 | 1923-07-14 | 3 | d | Two trains collide in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24094471 | 24094471 | |
40095 | 40095 | 1923-07-14 | 3 | d | Smallpox in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24094471 | 24094471 | |
40096 | 40096 | 1923-07-14 | 3 | d-e | Turkish authority arrests 35 Communist radicals. | Britain | http://trove.nla.gov.au/newspaper/page/24094471 | 24094471 | |
40097 | 40097 | 1923-07-14 | 3 | e | Russia has new political system, new government headed by Lenin, and new national flag. | Britain | http://trove.nla.gov.au/newspaper/page/24094471 | 24094471 | |
40098 | 40098 | 1923-07-14 | 3 | e | Robbery on the railway line from Guangzhou to Kowloon. | China | http://trove.nla.gov.au/newspaper/page/24094471 | 24094471 | |
40099 | 40099 | 1923-07-14 | 6 | a-b | Train hijacked in Guangdong as well, comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094476 | 24094476 | |
40100 | 40100 | 1923-07-14 | 6 | b-c | Military officers in the north such as Wang Chengbin, Wang Huaiqing, Feng Yuxiang and Zhang Fulai oppose to Sun Yatsen's effort to borrow foreign loans. | China | http://trove.nla.gov.au/newspaper/page/24094476 | 24094476 | |
40101 | 40101 | 1923-07-14 | 6 | c | The Nationalist Party (Guomindang) sends telegram to foreign missions in Beijing that condemns Beijing government for the train hijack in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24094476 | 24094476 | |
40102 | 40102 | 1923-07-14 | 6 | c-d | Census and population change in China from 1913 to 1921. | China | http://trove.nla.gov.au/newspaper/page/24094476 | 24094476 | |
40103 | 40103 | 1923-07-14 | 6 | d | An actress is elected member of the House of Commons in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24094476 | 24094476 | |
40104 | 40104 | 1923-07-14 | 7 | a | French Consul's residence in Melbourne is burglarised. | Australia | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40105 | 40105 | 1923-07-14 | 7 | a | An old man is found rich after his death in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40106 | 40106 | 1923-07-14 | 7 | a | Storm in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40107 | 40107 | 1923-07-14 | 7 | a | The biggest department store in Sydney and its profit last year. | Australia | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40108 | 40108 | 1923-07-14 | 7 | a | Sydney police raid a Chinese gambling den in Hay Street, | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40109 | 40109 | 1923-07-14 | 7 | b | A Chinese man in Sydney is detained for opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40110 | 40110 | 1923-07-14 | 7 | b | A train derails in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40111 | 40111 | 1923-07-14 | 7 | b | Shanghai municipal government pleas for help from American Red Cross to the tens of thousands of Russian refugees in China. | China | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40112 | 40112 | 1923-07-14 | 7 | b | Chinese women in Beijing advocate monogamy. | China | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40113 | 40113 | 1923-07-14 | 7 | b | Fourth part of a special report published in the Sydney Morning Herald on the Far Eastern situations (rise of Japan, the future of China and others). | Australia | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40114 | 40114 | 1923-07-14 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40115 | 40115 | 1923-07-14 | 8 | a | Executive Manager of the Tung Wah Times Zhang Maokuan calls for donations to the building of Confucian temple. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094478 | 24094478 | |
40116 | 40116 | 1923-07-14 | 8 | a-b | Chinese communities in Australia donate to building of a hospital in Dongguan. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094478 | 24094478 | |
40117 | 40117 | 1923-07-14 | 8 | b-d | Guangdong news/ A charity hospital in closed in Guangzhou. Government troops can not protect local residents. Guangdong army takes over Chaozhou and Shantou. City wall to be demolished in Zhaoqing for the disaster relief. Li Liejun shoots dead a envoy from Hong Zhaolin. Shen Rongguang escapes to Wuzhou. Ammunition depot near Sun Yatsen's headquarters is destroyed. Li Fulin reports from Shantou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094478 | 24094478 | |
40118 | 40118 | 1923-07-14 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094478 | 24094478 | |
40119 | 40119 | 1923-07-14 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094478 | 24094478 |
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]);