This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7506 | 7506 | 1901-04-20 | 3 | a | A welcome ceremony is being prepared in Singapore for the visit of a British prince. | Singapore | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7507 | 7507 | 1901-04-20 | 3 | a | Amount of compensation demanded by foreign governments. | Australia | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7508 | 7508 | 1901-04-20 | 3 | a | Russian foreign minister has been promoted for his contributions to the nation. | Russia | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7509 | 7509 | 1901-04-20 | 3 | b | Zhao Shuqiao, a minister, asks for a long period of leave from the court in order to avoid a power struggle. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7510 | 7510 | 1901-04-20 | 3 | b | New governor of Guangdong, Tao Mo, starts his rearrangement plan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7511 | 7511 | 1901-04-20 | 3 | b | A big fire in Zhaoqing and donations to the victims. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7512 | 7512 | 1901-04-20 | 3 | b | A complicated case in Panyu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7513 | 7513 | 1901-04-20 | 3 | b | A gambling house in Guangzhou, the difficulties surrounding it. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7514 | 7514 | 1901-04-20 | 3 | c | Japan urges China to sent troops to Manchuria; Liu Kunyi and Li Hongzhang talk to British diplomats; cabinet prepares to move to Xiangyang of Hubei province; people who murdered a German soldier have been captured. | China | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7515 | 7515 | 1901-04-20 | 3 | c | A report on Gang Yi's son. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7516 | 7516 | 1901-04-20 | 3 | c | Gentry in Shanghai hold a meeting to debate the pros and cons of China's treaty with Russia. Attendants include Wang Yunzhong, Wang Zhiqing, Wen Qinfu, Jiang Zhiyou, and hundreds of others. | China | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7517 | 7517 | 1901-04-20 | 3 | d | Chong Wenshan and his whole family committed suicide after the entry of international troops into Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7518 | 7518 | 1901-04-20 | 3 | d | International troops in Beijing provided Zhao Shuqiao's crime. | China | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7519 | 7519 | 1901-04-20 | 3 | d | A court hearing in Tamarama, Sydney, on a rape case. | Australia | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7520 | 7520 | 1901-04-20 | 3 | d | A man in Sydney was sentenced to prison for rudeness. | Australia | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7521 | 7521 | 1901-04-20 | 3 | d | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 | |
7522 | 7522 | 1901-04-20 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100011 | 24100011 |
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]);