This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30679 | 30679 | 1915-11-06 | 8 | a | Notice of China's Business and Trade Association in New Zealand on donations to Guangdong floods, with names listed. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095049 | 24095049 | |
30680 | 30680 | 1915-11-06 | 8 | a | Letter of Wang Fengying, a senator, to Yang Du, opposing restoring imperial system ( to be continued). | China | http://trove.nla.gov.au/newspaper/page/24095049 | 24095049 | |
30681 | 30681 | 1915-11-06 | 8 | b-d | Guangdong news/There are too many officials in Guangdong but not enough positions. Guangdong Relieving Department plans to take over business of gambling association. Police in Guangdong is to be divided into several different ranks. Families conflict in Xinghui, Guangdong is still going on, resulting in huge loss to people there. Silk business in Fushan, Guangdong suffers from the floods. Li Jiapin, a troop commander, shoots dead two chief bandits when they are arrested in Guangdong. Governor Zhang orders to watch on the Repulican Party members in education field. Tan Geng conducts his plane flying tests in Macau. Current situation of native people in Hainan Island. | China | http://trove.nla.gov.au/newspaper/page/24095049 | 24095049 |
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]);