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 |
---|---|---|---|---|---|---|---|---|---|
40615 | 40615 | 1923-11-03 | 2 | a-b | Editorial by the Tung Wah Times on Cao Kun and Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094600 | 24094600 | |
40616 | 40616 | 1923-11-03 | 2 | b-c | Li Yuanhong after his arrival in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094600 | 24094600 | |
40617 | 40617 | 1923-11-03 | 2 | c-d | Astronomical observatory in Shanghai refutes a rumour on earthquake disaster. | China | http://trove.nla.gov.au/newspaper/page/24094600 | 24094600 | |
40618 | 40618 | 1923-11-03 | 2 | d | Recent talks by Li Yuanhong in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094600 | 24094600 | |
40619 | 40619 | 1923-11-03 | 2-3 | d-a | Beijing meteorological observatory explains why there are hails in Summer time. | China | http://trove.nla.gov.au/newspaper/page/24094600 | 24094600 | |
40620 | 40620 | 1923-11-03 | 3 | a-b | Foreign warships (British, American, French and Japanese) are to organise a united fleet. | China | http://trove.nla.gov.au/newspaper/page/24094599 | 24094599 | |
40621 | 40621 | 1923-11-03 | 3 | b | Beijing cabinet meets and decides to reorganise local armies in the south. | China | http://trove.nla.gov.au/newspaper/page/24094599 | 24094599 | |
40622 | 40622 | 1923-11-03 | 3 | b-c | Business communities throughout China oppose to collection of disaster relief tax. | China | http://trove.nla.gov.au/newspaper/page/24094599 | 24094599 | |
40623 | 40623 | 1923-11-03 | 3 | c-d | Wu Peifu talks on industrial development. | China | http://trove.nla.gov.au/newspaper/page/24094599 | 24094599 | |
40624 | 40624 | 1923-11-03 | 3 | d | Military conflict in Changsha, capital of Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24094599 | 24094599 | |
40625 | 40625 | 1923-11-03 | 3 | e | Bandit in America is sentenced to 30 years' imprison for hijacking a train. | America | http://trove.nla.gov.au/newspaper/page/24094599 | 24094599 | |
40626 | 40626 | 1923-11-03 | 3 | e | Bank robbery in America. | Canada | http://trove.nla.gov.au/newspaper/page/24094599 | 24094599 | |
40627 | 40627 | 1923-11-03 | 3 | e | Chinese authority approves American company to build radio communication in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094599 | 24094599 | |
40628 | 40628 | 1923-11-03 | 6 | a-b | See Yup (si yi) people write an open letter to Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24094604 | 24094604 | |
40629 | 40629 | 1923-11-03 | 6 | b-c | Commercial chamber in Guangzhou and the sale of public properties. | China | http://trove.nla.gov.au/newspaper/page/24094604 | 24094604 | |
40630 | 40630 | 1923-11-03 | 6 | c | Liu Dequan in Beijing applies to set up a technical training school for prostitutes. | China | http://trove.nla.gov.au/newspaper/page/24094604 | 24094604 | |
40631 | 40631 | 1923-11-03 | 6 | c | A woman in Beijing marries two brothers. | China | http://trove.nla.gov.au/newspaper/page/24094604 | 24094604 | |
40632 | 40632 | 1923-11-03 | 6 | c-d | Fish can talk in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24094604 | 24094604 | |
40633 | 40633 | 1923-11-03 | 6 | d | Rats bite an old man in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24094604 | 24094604 | |
40634 | 40634 | 1923-11-03 | 7 | a-b | A group of Australian federal parliamentarians visits New Guinea and the report. Chinese community in New Guinea. | Australia | http://trove.nla.gov.au/newspaper/page/24094603 | 24094603 | |
40635 | 40635 | 1923-11-03 | 7 | b | A tool shop in Sydney on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094603 | 24094603 | |
40636 | 40636 | 1923-11-03 | 7 | b | Australian federal government revises regulations on income tax. | Australia | http://trove.nla.gov.au/newspaper/page/24094603 | 24094603 | |
40637 | 40637 | 1923-11-03 | 7 | b | A furniture shop in Sydney on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094603 | 24094603 | |
40638 | 40638 | 1923-11-03 | 7 | b | A socks shop is burglarised in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24094603 | 24094603 | |
40639 | 40639 | 1923-11-03 | 7 | b | A banker in Sydney is arrested for embezzlement. | Australia | http://trove.nla.gov.au/newspaper/page/24094603 | 24094603 | |
40640 | 40640 | 1923-11-03 | 7 | b | Chinese football team has match in Tasmania and the results. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094603 | 24094603 | |
40641 | 40641 | 1923-11-03 | 7 | c | A wool factory in New Zealand on fire. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094603 | 24094603 | |
40642 | 40642 | 1923-11-03 | 7 | c-d | Battles in the south of Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094603 | 24094603 | |
40643 | 40643 | 1923-11-03 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094603 | 24094603 | |
40644 | 40644 | 1923-11-03 | 7 | d-e | Melbourne Chinese communities donate to the building of Confucian temple. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094603 | 24094603 | |
40645 | 40645 | 1923-11-03 | 8 | a | Chinese communities in Australia donate to the Lingnan University, Guangzhou, and to the Chinese Nanhua (South China) Sports Association. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094606 | 24094606 | |
40646 | 40646 | 1923-11-03 | 8 | a-d | Guangdong news/ Ningyang railway company is ordered to re-elect general manager. Chen Tiandou writes to Sun Yatsen. Complaints on the looting of Xu Shurong's army. Army from the north might attack Guangdong again. Guangdong army on the way to back up Huizhou. War clouds in Wuzhou. Xu Chongzhi's army is besieged by civil corps. Ten thousand people are unemployed in Guangzhou. Sign of famine in Gaoyao county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094606 | 24094606 | |
40647 | 40647 | 1923-11-03 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094606 | 24094606 | |
40648 | 40648 | 1923-11-03 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094606 | 24094606 |
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]);