This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 11580 | 11580 | 1903-03-07 | 2 | a | New regulations for Guangzhi translation and publishing company in Shanghai expands business and raises capital by floating shares. | China | http://trove.nla.gov.au/newspaper/page/26800181 | 26800181 | |
| 11581 | 11581 | 1903-03-07 | 2 | a | An imperial scholar asks the Empress to return power to Emperor Guangxu; Rong Lu has leg trouble; China sends special envoy to invite investment in America; Yuan Shikai stopped donations to Nanyang school; Zhang Zhidong will replace Lu Chuanlin in the cabinet. | China | http://trove.nla.gov.au/newspaper/page/26800181 | 26800181 | |
| 11582 | 11582 | 1903-03-07 | 2 | b | No Chinese traffic allowed in the diplomatic quarter of Beijing. | China | http://trove.nla.gov.au/newspaper/page/26800181 | 26800181 | |
| 11583 | 11583 | 1903-03-07 | 2 | b | Recent incidents in Beijing University. | China | http://trove.nla.gov.au/newspaper/page/26800181 | 26800181 | |
| 11584 | 11584 | 1903-03-07 | 2 | b | Chinese government is to purchase the Beijing telephone company owned by a Dutch businessman. | China | http://trove.nla.gov.au/newspaper/page/26800181 | 26800181 | |
| 11585 | 11585 | 1903-03-07 | 2 | b | Chinese government purchases the Dagu dockyard from Russian. | China | http://trove.nla.gov.au/newspaper/page/26800181 | 26800181 | |
| 11586 | 11586 | 1903-03-07 | 2 | b | Russia's motives in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/26800181 | 26800181 | |
| 11587 | 11587 | 1903-03-07 | 2 | c | De Shou wants to take the governorship of Guangdong and Guangxi provinces. | China | http://trove.nla.gov.au/newspaper/page/26800181 | 26800181 | |
| 11588 | 11588 | 1903-03-07 | 2 | c | Progress of railway building from Hankou to Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/26800181 | 26800181 | |
| 11589 | 11589 | 1903-03-07 | 2 | c | Deng Huaxi, imperial commissioner of Guizhou province, seeks to resign. | China | http://trove.nla.gov.au/newspaper/page/26800181 | 26800181 | |
| 11590 | 11590 | 1903-03-07 | 2 | c | Drought, flooding, epidemics and banditry in Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/26800181 | 26800181 | |
| 11591 | 11591 | 1903-03-07 | 2 | c | Secret society in Nanhai county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/26800181 | 26800181 | |
| 11592 | 11592 | 1903-03-07 | 3 | a | Territory statistics of each country in the world. | China | http://trove.nla.gov.au/newspaper/page/26800180 | 26800180 | |
| 11593 | 11593 | 1903-03-07 | 3 | a | Population of each country of the world. | China | http://trove.nla.gov.au/newspaper/page/26800180 | 26800180 | |
| 11594 | 11594 | 1903-03-07 | 3 | a | A women's bank in New York. | China | http://trove.nla.gov.au/newspaper/page/26800180 | 26800180 | |
| 11595 | 11595 | 1903-03-07 | 3 | b | A Japanese doctor was infected with an epidemic disease while visiting patients in Tokyo. | Japan | http://trove.nla.gov.au/newspaper/page/26800180 | 26800180 | |
| 11596 | 11596 | 1903-03-07 | 3 | b | Compensations from American government to the Chinese residents in Honolulu for burning down their houses during the epidemic period. | America | http://trove.nla.gov.au/newspaper/page/26800180 | 26800180 | |
| 11597 | 11597 | 1903-03-07 | 3 | b | The Hanoi fair and its origin. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26800180 | 26800180 | |
| 11598 | 11598 | 1903-03-07 | 3 | c | Britain is making preparation for the possible shortage of coal in the future. | Britain | http://trove.nla.gov.au/newspaper/page/26800180 | 26800180 | |
| 11599 | 11599 | 1903-03-07 | 3 | c | A rich man in America left a lot money for his horses. | Australia | http://trove.nla.gov.au/newspaper/page/26800180 | 26800180 | |
| 11600 | 11600 | 1903-03-07 | 3 | c | A liner of Gibbs Bright & Co collided with a transportation ship in Japanese port. | Australia | http://trove.nla.gov.au/newspaper/page/26800180 | 26800180 | |
| 11601 | 11601 | 1903-03-07 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800180 | 26800180 |
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]);