This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47207 | 47207 | 1928-07-07 | 6 | a-d | Guangdong news/ A meeting of the Guangdong branch of the Central Political Council and the resolutions. Municipal government promotes thrifty life style. The provincial government reshuffled and the new faces. Chen Mingshu is appointed to chair the special committee to deal with the aftermath. A telegram from Hankou lists crimes of Cheng Qian. | China | http://trove.nla.gov.au/newspaper/page/24098870 | 24098870 | |
47208 | 47208 | 1928-07-07 | 7 | a-d | Guangdong news/ Military officer is executed for plotting a rebellion. Communist adviser is arrested in Haifeng county. Failure of the silk industry in the past few years. Border demarcated between Taishan and Heshan county. A woman forces her widow daughter-in-law to remarry. Employee of a private bank in Taishan county ascends with bank's money. Bandits in Zengcheng. Communist activist Feng Cheng is arrested in Macao. Magistrate of Chaoyang county reports the corruption of the government departments. | China | http://trove.nla.gov.au/newspaper/page/24098869 | 24098869 |
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]);