This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 11222 | 11222 | 1902-11-29 | 3 | a | A list of Guangdong candidates who have successfully passed the imperial examination. | China | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11223 | 11223 | 1902-11-29 | 3 | a | Japan, Britain and other foreign governments send their condolences to Liu Kunyi's family; condolences also for the death of Tao Mo, former governor of Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11224 | 11224 | 1902-11-29 | 3 | a | A girls' school will be set up in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11225 | 11225 | 1902-11-29 | 3 | a | Prince Duan and Dong Fuxiang are in Ningxia province; magistrate of Changsha is to be punished for a missionary case; German troops moved from Shanghai to Jiaozhou, of Shandong province; Russian navy near China's coast. | Other... | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11226 | 11226 | 1902-11-29 | 3 | a | New South Wales parliament considers ways to deal with the drought. | Australia | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11227 | 11227 | 1902-11-29 | 3 | a | A fire ball was seen in the Cargo sky, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11228 | 11228 | 1902-11-29 | 3 | b | Russians prepare to build a railway in the north of Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11229 | 11229 | 1902-11-29 | 3 | b | Investigation has completed on the ocean liner accident that carries 500 coffins from Westport to Hong Kong. | Australia | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11230 | 11230 | 1902-11-29 | 3 | b | Sixty Russian missionaries on their way to Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11231 | 11231 | 1902-11-29 | 3 | b | A Russian school in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11232 | 11232 | 1902-11-29 | 3 | b | Two Japanese businessmen were arrested by Russian soldiers in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11233 | 11233 | 1902-11-29 | 3 | b | Hawaii is relaxing its immigration restriction on the arrival of Chinese farmers. | America | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11234 | 11234 | 1902-11-29 | 3 | b | Earthquake in Algeria and America. | Other... | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11235 | 11235 | 1902-11-29 | 3 | c | Adelaide experienced high tide recently. | Australia | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11236 | 11236 | 1902-11-29 | 3 | c | The first daughter of Zeng Zhi, a returned Chinese businessman from Sydney, marries a Briton in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11237 | 11237 | 1902-11-29 | 3 | c | Xu Shiqin, Kang Youwei's student, receives respect on his arrival of America. | America | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11238 | 11238 | 1902-11-29 | 3 | c | Six hundred Chinese students in Japan had a meeting. | Japan | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11239 | 11239 | 1902-11-29 | 3 | c | Chen Qiuju is visiting Japan for his reform plan. | Japan | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11240 | 11240 | 1902-11-29 | 3 | c | Riots in Cuba. | America | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11241 | 11241 | 1902-11-29 | 3 | c | Mail from China awaits collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11242 | 11242 | 1902-11-29 | 3 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
| 11243 | 11243 | 1902-11-29 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 |
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]);