This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 27790 | 27790 | 1913-08-30 | 3 | a | A circular telegram issued by military governor of Shandong province Zhou Ziqi against rebellions in the south. | China | http://trove.nla.gov.au/newspaper/page/24092800 | 24092800 | |
| 27791 | 27791 | 1913-08-30 | 3 | a | German also want to be involved in the Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24092800 | 24092800 | |
| 27792 | 27792 | 1913-08-30 | 3 | a | Sun Yatsen may flee Japan for Canada or somewhere else. | Japan | http://trove.nla.gov.au/newspaper/page/24092800 | 24092800 | |
| 27793 | 27793 | 1913-08-30 | 3 | a | Japan and America purchase new torpedo. | Britain | http://trove.nla.gov.au/newspaper/page/24092800 | 24092800 | |
| 27794 | 27794 | 1913-08-30 | 3 | b | America, Japan and France intervene with the chaos in Mexico. Battle between rebellion and government troops in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24092800 | 24092800 | |
| 27795 | 27795 | 1913-08-30 | 3 | b | The future of radio communications, reported by a British company. | Britain | http://trove.nla.gov.au/newspaper/page/24092800 | 24092800 | |
| 27796 | 27796 | 1913-08-30 | 3 | b | Britain, France and Russia jointly initiate boycott to Turkish effort to borrow foreign loans. Turkish army will not retreat from the Bulgaria. | Britain | http://trove.nla.gov.au/newspaper/page/24092800 | 24092800 | |
| 27797 | 27797 | 1913-08-30 | 3 | b | The war in Balkan peninsula. | Other... | http://trove.nla.gov.au/newspaper/page/24092800 | 24092800 | |
| 27798 | 27798 | 1913-08-30 | 3 | b | International peace conference to be held in Vienna. | Other... | http://trove.nla.gov.au/newspaper/page/24092800 | 24092800 | |
| 27799 | 27799 | 1913-08-30 | 3 | b | A British company is under investigation for purchase of stolen goods. | Britain | http://trove.nla.gov.au/newspaper/page/24092800 | 24092800 | |
| 27800 | 27800 | 1913-08-30 | 3 | b-c | Beijing news/ Preparation for presidential election. Both Xiong Xiling and Xu Shichang decline to the appointment of premiership. Neither republic nor dictatorship exists in China at the moment. Commercial authority in Beijing requires all companies to register. Germany and France will follow America to refund some Boxer Indemnity to China. Munition warehouse on fire in Henan province. Harmony within the Progress Party. | China | http://trove.nla.gov.au/newspaper/page/24092800 | 24092800 | |
| 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 |
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]);