This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 21170 | 21170 | 1909-06-19 | 3 | a-b | Guangdong news/ Gambling is prosperous in Guangzhou and many government officials are involved. Opium ban in Guangdong and the effect. Qualification of overseas Chinese for the rights to vote. Some government officials continue to smoke opium secretly. Portuguese people in Macao and their attitude towards the border demarcation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 | |
| 21171 | 21171 | 1909-06-19 | 3 | b | The officialdom in Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 | |
| 21172 | 21172 | 1909-06-19 | 3 | b-c | Chinese student in Japan Hu Xueshen is arrested and sentenced into prison. | Japan | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 | |
| 21173 | 21173 | 1909-06-19 | 3 | c | French and German governments issue new naval budget. | Britain | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 | |
| 21174 | 21174 | 1909-06-19 | 3 | c | The power of parliament in Persia. | Britain | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 | |
| 21175 | 21175 | 1909-06-19 | 3 | c | Earthquake in Sumatra and southern France. | Britain | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 | |
| 21176 | 21176 | 1909-06-19 | 3 | c | British parliamentarians comment their visit to Germany. British missionaries visit Germany. Russian parliamentarians visit Britain. | Britain | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 | |
| 21177 | 21177 | 1909-06-19 | 3 | c | America's ambition in China. | Britain | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 | |
| 21178 | 21178 | 1909-06-19 | 3 | d | Coal production in the world (particularly in Britain, Germany, France, Belgium and America). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 | |
| 21179 | 21179 | 1909-06-19 | 3 | d | The secret treaty signed between Japan and France last September and the contents about China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 | |
| 21180 | 21180 | 1909-06-19 | 3 | d | Salary income of presidents and monarchs in America, France, Germany, Britain and Turkey. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 | |
| 21181 | 21181 | 1909-06-19 | 3 | d | Tung Wah editorial: Where is China's sovereignty? | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802221 | 26802221 |
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]);