This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29598 | 29598 | 1915-01-23 | 2 | b-c | President's orders/ Senator Zhen Tao's resignation is approved. Yuan Shikai orders all officials should devote to the state affairs. | China | http://trove.nla.gov.au/newspaper/page/24094696 | 24094696 | |
29614 | 29614 | 1915-01-23 | 3 | b-c | French troops are fighting severely with enemy troops in Ri Cen Shi (ppp). | France | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29621 | 29621 | 1915-01-23 | 6 | b-c | The conspiracy of illegal party in Zhejiang is exposed and a number of party leaders are arrested. | China | http://trove.nla.gov.au/newspaper/page/24094700 | 24094700 | |
29624 | 29624 | 1915-01-23 | 7 | b-c | Unexpected earthquake in Italy results in huge casualties. | Other... | http://trove.nla.gov.au/newspaper/page/24094699 | 24094699 | |
29631 | 29631 | 1915-01-23 | 8 | b-c | Guangdong news (continued)/ Artillery for shooting planes is installed in Xiou Shan, Guangdong. A womon detective in Guangdong is arrested for illegally breaking in houses. Li Wenfu is leading a troop attacking bandits in Tong Wan, Guangdong. An extraordinary grass is found in Guangdong. A good harvest year is expected for Gaoyao, Guangdong. Some detectives are using strange words to disturb passengers. A man is arrested for illegally own guns in Guangzhou. Guanghua Hospital in Guangzhou has removed a huge tumour in a womon. Two airships from America are transported to Guangzhou. Hong Kong businessnen gather to protest banning Republic Newspaper. | China | http://trove.nla.gov.au/newspaper/page/24094702 | 24094702 |
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]);