This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 11475 | 11475 | 1903-02-07 | 3 | a | George Morrison, journalist of The Times based in Beijing, talks China affairs to reporter of the Sydney Morning Herald. | Australia | http://trove.nla.gov.au/newspaper/page/26800164 | 26800164 | |
| 11476 | 11476 | 1903-02-07 | 3 | a | Stories and rumours fabricated by Dong Fuxiang's men. | Australia | http://trove.nla.gov.au/newspaper/page/26800164 | 26800164 | |
| 11479 | 11479 | 1903-02-07 | 3 | b | Ouyang Qing and his family arrive in Hong Kong safely; Chen Shou and Xu Fulin have arrived Townsville, Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/26800164 | 26800164 | |
| 11480 | 11480 | 1903-02-07 | 3 | b | Driver of the governor of New South Wales was drowned. | Australia | http://trove.nla.gov.au/newspaper/page/26800164 | 26800164 | |
| 11481 | 11481 | 1903-02-07 | 3 | b | Wesley, leader of the Australian Opposition Party, supports White Australia in Perth. | Australia | http://trove.nla.gov.au/newspaper/page/26800164 | 26800164 | |
| 11482 | 11482 | 1903-02-07 | 3 | b | More passengers in Sydney are travelling by tram. | Australia | http://trove.nla.gov.au/newspaper/page/26800164 | 26800164 | |
| 11483 | 11483 | 1903-02-07 | 3 | b | A female editor in Paris disguises as a man for many years. | Australia | http://trove.nla.gov.au/newspaper/page/26800164 | 26800164 | |
| 11484 | 11484 | 1903-02-07 | 3 | b | The Netherlands has talking envelope. | Australia | http://trove.nla.gov.au/newspaper/page/26800164 | 26800164 | |
| 11486 | 11486 | 1903-02-07 | 3 | c | Two Chinese, Liu Quan and Chen Ming, beat a boy to death on Waterloo Street, Sydney. The case is on trial. | Australia | http://trove.nla.gov.au/newspaper/page/26800164 | 26800164 |
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]);