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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
40626 | 40626 | 1923-11-03 | 3 | e | Bank robbery in America. | Canada | http://trove.nla.gov.au/newspaper/page/24094599 | 24094599 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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]);