This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30351 | 30351 | 1915-08-07 | 7 | a | Australia news/ Notice of consul general in Australia on issuing public loans of China. Statistics of donations on Australia Day for injured soldiers. Statistics of Australian soldiers killed and wounded in the Europe War. Two people dealing opium in Sydney are fined. A 25-year old European man killed his father during parents' querrelling. | Australia | http://trove.nla.gov.au/newspaper/page/24094940 | 24094940 | |
30352 | 30352 | 1915-08-07 | 7 | b | Zhang Mingqi refuses to take office in Guangdong and Yuan Shikai appoints him governor of Guangxi. Shanghai businessmen raises prices of goods for China's Rescuing Deposits. Japanese envoy in Beijing demands Chinese government to pacify movements of Chinese people rejecting Japanese goods. Japanese businessmen are worrying about rejecting Japanese goods movement in China. Teachers and students in a village school in Kaiping, Guangdong are kidnapped by bandits. A riot party organisation is found in Guangdong and two members are arrested. People in Singapore are competing to buy Chinese public loans. Several villages in Kaiping, Guangdong, are looted by bandits. Xu Qin, head of Guangdong branch of the Progress Party, is recommended to central government for his political capabilities. Autonomy Study Association in Guangdong proposes government not levying tax on basic food. | China | http://trove.nla.gov.au/newspaper/page/24094940 | 24094940 | |
30353 | 30353 | 1915-08-07 | 7 | b | Notice of donations to this newspaper, names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094940 | 24094940 | |
30354 | 30354 | 1915-08-07 | 7 | c | Notice of donations to Tongwang floods in Guangdong, names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094940 | 24094940 |
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]);