This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30511 | 30511 | 1915-09-25 | 6 | b | Name list of Chinese in Ta Li Lie Hua(ppp) in Australia donating to Guangdong floods. | Australia | http://trove.nla.gov.au/newspaper/page/24094999 | 24094999 | |
30513 | 30513 | 1915-09-25 | 7 | a-b | Australia news/ Thanks letter from Guangdong government for donations by Chinese in Australia. Zhang Mingqi's reply letter to Chinese council general in Australia on bandits in Guangdong looting and kidnapping Ye Jingliang, brother of president of China's Business and Trade Association in Sydney. A Chinese shop in Townsville is burnt, resulting in heavy loss. A lady's fur scarf is found in the Japanese training warship visiting Australia, and the loser is not yet found. An Australian passenger ship is damaged by an oil transporting ship in Hong Kong and is under repair in Macao. Australia is to implement compulsory military enrolment system due to intensified Europe War. | Australia | http://trove.nla.gov.au/newspaper/page/24094998 | 24094998 | |
30517 | 30517 | 1915-09-25 | 8 | a | Notice of Chinese council general in Australia on awards by Chinese Finance Ministry to Chinese in Australia donating to Chinese government. | Australia | http://trove.nla.gov.au/newspaper/page/24095001 | 24095001 |
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]);