This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27787 | 27787 | 1913-08-30 | 2 | c-d | Budget for the Chinese presidential office will be cut. | China | http://trove.nla.gov.au/newspaper/page/24092801 | 24092801 | |
27801 | 27801 | 1913-08-30 | 3 | c-d | Guangdong news/ No freedom of speech in Guangdong. Chen Jiongming prohibits residents from moving. No freedom for speech, communication and travel in Guangdong. Hong Kong newspapers are banned in Guangdong. Servicemen are not qualified for fare discount for ferry service. Bandits in Zengcheng county. Robbery in Dongguan county. A newspaper is sealed up in Guangzhou. Deng Keng is against the independence of Guangdong. Guangdong army on the way to support Jiangxi. | China | http://trove.nla.gov.au/newspaper/page/24092800 | 24092800 | |
27813 | 27813 | 1913-08-30 | 8 | c-d | Further report on investigation over the assassination of Song Jiaoren. | China | http://trove.nla.gov.au/newspaper/page/24092807 | 24092807 |
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]);