This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29981 | 29981 | 1915-05-01 | 2 | c-d | The Chinese Border and Land Division Bureau is now investigating land in Jiangsu and Zhejiang, putting its plan into practice. | China | http://trove.nla.gov.au/newspaper/page/24094825 | 24094825 | |
30008 | 30008 | 1915-05-01 | 8 | c-d | Guangdong news/ Military commander Li is to set up training school for Guangdong officials. Naval warships are to unite police force to arrest bandits. Troops in Gao Yao county, Guangdong, do not help in bandits robberies. A detective in Guangdong is slanting an innocent person. A woman in Guangdong charges a Buhda for misleading her. A soldier charges his wife's adultery with another man in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094831 | 24094831 |
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]);