This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 23779 | 23779 | 1910-11-12 | 3 | a-b | Guangdong news/ Celebrations in Guangzhou on the birthday of Confucius. Road map surveyed for Guangdong province. Map of Shantou prepared. Army recruitment in Gaoyao county. Plan for prison reform initiated. Roadside land in Guangdong will lease out for cultivation. Staff of the self-government office in Xinning county are not allowed to have another job. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23780 | 23780 | 1910-11-12 | 3 | b | Chinese government requires its diplomatic officers overseas to cut their pigtails. | China | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23781 | 23781 | 1910-11-12 | 3 | b | National parliament of China, both the Lower and Upper houses, will be opened in 1915. | China | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23782 | 23782 | 1910-11-12 | 3 | b | Greek foreign minister meets Emperor of Turkey to improve their relations. | Britain | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23783 | 23783 | 1910-11-12 | 3 | b | Turkish people protest against Britain's involvement of the Persian crisis. Muslims countries respond to the crisis in Persia. | Other... | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23784 | 23784 | 1910-11-12 | 3 | b | Prince of Germany starts his tour to the Far East. | Germany | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23785 | 23785 | 1910-11-12 | 3 | b-c | Report on the British-Japanese exhibition. | Britain | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23786 | 23786 | 1910-11-12 | 3 | c | Railway in Singapore under British administration. | Singapore | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23787 | 23787 | 1910-11-12 | 3 | c | Duke of Kent opens the parliament of South Africa on behalf of King George V of Britain. | Britain | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23788 | 23788 | 1910-11-12 | 3 | c | Tsar of Russia meets the Emperor of Germany. | Britain | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23789 | 23789 | 1910-11-12 | 3 | c | Chinese government is seeking an alliance with America. | Britain | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23790 | 23790 | 1910-11-12 | 3 | c | Population increases in New York and the future prediction. | America | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23791 | 23791 | 1910-11-12 | 3 | c | United States of America becomes the richest country in the world. | America | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23792 | 23792 | 1910-11-12 | 3 | d | Regulations of the Health Society, drafted by Wu Tingfang and Li Yuying. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 |
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]);