This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7480 | 7480 | 1901-04-17 | 3 | a-b | A photograph of Liang Qichao, the second leader of the Chinese Empire Reform Association. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100007 | 24100007 | |
7481 | 7481 | 1901-04-17 | 3 | a | Jewish businessman Jia Dao Li (nnn) donated a big sum of money to build a modern school in China. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100007 | 24100007 | |
7482 | 7482 | 1901-04-17 | 3 | a | A thief was caught in Geelong, Victoria. | Australia | http://trove.nla.gov.au/newspaper/page/24100007 | 24100007 | |
7483 | 7483 | 1901-04-17 | 3 | b | A young Chinese man from Honolulu visits his home village in Kowloon, Xi'an county of Guangdong province. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100007 | 24100007 | |
7484 | 7484 | 1901-04-17 | 3 | b | Russian ambassador to Beijing blames Li Hongzhang; Prince Duan and Dong Fuxiang quartered their troops in Mongolia and Shaanxi; the Emperor considers a new policy after returning to Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100007 | 24100007 | |
7485 | 7485 | 1901-04-17 | 3 | c | Li Hongzhang and Prince Qing both praised Yuan Shikai for his well-trained army. | Japan | http://trove.nla.gov.au/newspaper/page/24100007 | 24100007 | |
7486 | 7486 | 1901-04-17 | 3 | c | Beijing is busy making icehouse to store food. | China | http://trove.nla.gov.au/newspaper/page/24100007 | 24100007 | |
7487 | 7487 | 1901-04-17 | 3 | c | A house in Sydney on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24100007 | 24100007 | |
7488 | 7488 | 1901-04-17 | 3 | d | Liang Qichao talks at The Tung Wah News about his new book, Chinese history in the past ten years. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100007 | 24100007 | |
7489 | 7489 | 1901-04-17 | 3 | d | Russian soldiers ordered to kill all Chinese on Heilongjiang River; a German commander was murdered outside of Beijing. | Other... | http://trove.nla.gov.au/newspaper/page/24100007 | 24100007 | |
7490 | 7490 | 1901-04-17 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100007 | 24100007 |
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]);