This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26260 | 26260 | 1912-06-08 | 3 | b | Guangdong news | Chief Governor Hu Hanming notifies that troops should abide by law and all people follow government orders. Various associations and parties are ordered to dissolved. Governor Hu orders to arrest heads of bandits parties and gamblers. Previous official beat the new official at a meeting in Yangjiang county, Guangdong. Huang Xiayi, governor of Tongwan was arrested in Guangdong for embezzling public funds. Bandits robbed in Xingan county and the governor fled. Sun Yatsen has built a new house in Macau. Long Jiguang is to move to Guangzhou military government building. Official resignations and promotions are repeatedly heard these days. Governor of Hainan county has arrested a group of gamblers with help of troops. A village in Hainan county, Guangdong, was robbed. A girl in Guangzhou refused the marriage arranged by her parents. | China | http://trove.nla.gov.au/newspaper/page/24092263 | 24092263 |
26269 | 26269 | 1912-06-08 | 8 | a-c | Guangdong news | Guangdong government has too many redundant officials and pay for officials is too high. Many government officials are placing their relatives in important positions. Officials and businessmen are fattening themselves by trading paper money. Policemen are doing nothing to deal with bandits robberies. Huang Shizhong was sentenced to death by Chen Junming on various accuses. | China | http://trove.nla.gov.au/newspaper/page/24092270 | 24092270 |
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]);