This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 23056 | 23056 | 1910-07-02 | 3 | a-b | Guangdong news/ Guangdong raises money to build a technical university. Budget share of Guangdong province for the naval development. Radio to be set up in Dongsha island. Overseas Chinese communities on the repayment of foreign debt. Xiangzhou in Xiangshan county may turn into a free trade port. Triad societies in Maqi, of Shunde county, harass local communities. Local officials and residents in Zhaoqing pray for rain. Smuggled rifles seized in a church of Dongguan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802681 | 26802681 | |
| 23057 | 23057 | 1910-07-02 | 3 | b | American House of Representatives proposes to organise an international peace organisation. President William Taft appoints former president Theodore Roosevelt to lead the organisation. | Britain | http://trove.nla.gov.au/newspaper/page/26802681 | 26802681 | |
| 23058 | 23058 | 1910-07-02 | 3 | b | Chinese government compensates Japan and Britain for their loss in the chaos in Changsha, capital of Hunan province. | Britain | http://trove.nla.gov.au/newspaper/page/26802681 | 26802681 | |
| 23059 | 23059 | 1910-07-02 | 3 | b | French parliament proposes holding an international exhibition in Paris by 1912. | Britain | http://trove.nla.gov.au/newspaper/page/26802681 | 26802681 | |
| 23060 | 23060 | 1910-07-02 | 3 | b | Canadian navy to build ten more warships. | Britain | http://trove.nla.gov.au/newspaper/page/26802681 | 26802681 | |
| 23061 | 23061 | 1910-07-02 | 3 | c | A car in Mexico turns over, claiming more than 37 soldiers' lives. | Britain | http://trove.nla.gov.au/newspaper/page/26802681 | 26802681 | |
| 23062 | 23062 | 1910-07-02 | 3 | c | Germans and the flying plane. | Britain | http://trove.nla.gov.au/newspaper/page/26802681 | 26802681 | |
| 23063 | 23063 | 1910-07-02 | 3 | c | Royal Navy of Britain seeks more budget. | Britain | http://trove.nla.gov.au/newspaper/page/26802681 | 26802681 | |
| 23064 | 23064 | 1910-07-02 | 3 | c | Population growth in America from 1810 to 1910. | America | http://trove.nla.gov.au/newspaper/page/26802681 | 26802681 | |
| 23065 | 23065 | 1910-07-02 | 3 | c | Correspondence from America. Chinese community in New York appeals to cut their pigtails. Chinese iron on American market. China purchases railway construction materials. | America | http://trove.nla.gov.au/newspaper/page/26802681 | 26802681 | |
| 23066 | 23066 | 1910-07-02 | 3 | d | Russian spy Zhao Yuqing and his background in Shandong province. | Other... | http://trove.nla.gov.au/newspaper/page/26802681 | 26802681 |
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]);