This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29529 | 29529 | 1915-01-02 | 7 | a-c | Australia news/ Sydney China's School have made a great progress these years. Statistics of qualified soldiers in various states in Australia. Statistics show that Sydney business is declining due to the affects of European War. House of Yuan Mei, a Chinese in Sydney is stolen. Bat Hurst is flooding due to heavy rain there. | Australia | http://trove.nla.gov.au/newspaper/page/24094675 | 24094675 | |
29531 | 29531 | 1915-01-02 | 8 | a-c | Guangdong news/ Bombs in Guangzhou city have killed and injured many people and police arrest some suspects. Guangdong and Guangxi are to unite to fight against bandits. A man came to the police station in Guangzhou, admitting his bombing police station. General Long Jiguang proposes to build a power station in Guangdong. Shenda Religion in Chenhua county, Guangdong is active and its members have killed some policemen who are on duty. Central government send officials investigate salt business in Guangdong. Some false detectives in Guangdong are cheating and robbing people. Wang Mingjin, the previous governor in Dongwan, Guangdong, is charged with a number of crimes. Guangdong government orders all counties to hand in tax within a month. Li Caoxing, a commander of Qianshan troop, refuses to blackmail Chen Gengyu. Ai Di (nnn), American philosopher, visits China and is welcomed by Chinese officials and people. | China | http://trove.nla.gov.au/newspaper/page/24094677 | 24094677 |
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]);