This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28908 | 28908 | 1914-06-06 | 3 | a | China to have new national anthem. | China | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 | |
28909 | 28909 | 1914-06-06 | 3 | a-b | Central auditing office in China reduces budget for local provincial governments. | China | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 | |
28910 | 28910 | 1914-06-06 | 3 | b | Yuan Shikai may centralise power in his own hands. | Britain | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 | |
28911 | 28911 | 1914-06-06 | 3 | b | British navy commander in China seeks cooperation from the Chinese government to suppress pirates in Guangdong area. | Britain | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 | |
28912 | 28912 | 1914-06-06 | 3 | b | Epidemic in the Dutch colony Java. | Britain | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 | |
28913 | 28913 | 1914-06-06 | 3 | b | German journalists are welcomed in London. | Britain | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 | |
28914 | 28914 | 1914-06-06 | 3 | b | Financial deficit in France. | France | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 | |
28915 | 28915 | 1914-06-06 | 3 | b | An American rich man tries to arrange his niece's marriage. | America | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 | |
28916 | 28916 | 1914-06-06 | 3 | b | Prince of Germany wants to have freedom of marriage. | Britain | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 | |
28917 | 28917 | 1914-06-06 | 3 | b | British woman is penalised when fighting for the rights to vote. | Britain | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 | |
28918 | 28918 | 1914-06-06 | 3 | b-c | Some foreign governments want to mediate the chaos in Mexico. | Britain | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 | |
28919 | 28919 | 1914-06-06 | 3 | c | A Canadian passenger liner has accident near America. | America | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 | |
28920 | 28920 | 1914-06-06 | 3 | c-d | Beijing news/ Chinese government to organise a business delegation to visit America. Financial authority to increase tax. Chinese government is required to protect Japanese officer who is investigating Japanese immigrants in Shanghai. American government initiates extradition talks with China. Lu Zhengxiang sues Swiss bank for misconduct. Li Zhun and Zhang Woquan in recent days. | China | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 | |
28921 | 28921 | 1914-06-06 | 3 | d | Guangdong news/ Provincial governor replies on self-government association in Shunde county on the local security there. Local resident in Yingde county Xie Jinju sues government officials for collaboration with bandits. Assets to be returned to the descendants of the Eight Banners. Letter from the Guangzhou-Hankou railway company to the charity institutions in Guangzhou. Five people are arrested in Guangzhou for spurious coins. | China | http://trove.nla.gov.au/newspaper/page/24093133 | 24093133 |
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]);