This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24496 | 24496 | 1911-05-13 | 2 | a-b | On the crimes of the government | The government is accused of 'selling' China to foreigners due to more and more foreign concessions in China. (to be continued) | Other... | http://trove.nla.gov.au/newspaper/page/24091770 | 24091770 |
24497 | 24497 | 1911-05-13 | 2 | b | List of governors in China | A list of governors in China is released. | Other... | http://trove.nla.gov.au/newspaper/page/24091770 | 24091770 |
24498 | 24498 | 1911-05-13 | 2 | b | List of senior officials to foreign countries | A list of senior officials to foreign countries is released. | Other... | http://trove.nla.gov.au/newspaper/page/24091770 | 24091770 |
24499 | 24499 | 1911-05-13 | 2 | b-c | China's land lost in the past | Department of Foreign Affairs investigates China's treaties with other countries so as to find out its land lost to these countries in the past. | Other... | http://trove.nla.gov.au/newspaper/page/24091770 | 24091770 |
24503 | 24503 | 1911-05-13 | 2 | d | The issue of Pianma case | Suggestions about the issue of Pianma case. | Other... | http://trove.nla.gov.au/newspaper/page/24091770 | 24091770 |
24510 | 24510 | 1911-05-13 | 3 | a | Turmoils in Mexico | Several turmoils are happening in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24091769 | 24091769 |
24512 | 24512 | 1911-05-13 | 3 | b | Suicide fashions in Germany | Suicides become popular in German universities. | Other... | http://trove.nla.gov.au/newspaper/page/24091769 | 24091769 |
24514 | 24514 | 1911-05-13 | 3 | B | The Philippines wants to get rid of America | The Philippines wants to be independent. | Other... | http://trove.nla.gov.au/newspaper/page/24091769 | 24091769 |
24516 | 24516 | 1911-05-13 | 3 | b | Japan asked for indemnity | Japan asked for indemnity for the Erchen Incident. | Other... | http://trove.nla.gov.au/newspaper/page/24091769 | 24091769 |
24521 | 24521 | 1911-05-13 | 6 | a | Donations needed for Nanqiang Association | Nanqiang Association in Guangzhou entreats donations in Sydney. | Other... | http://trove.nla.gov.au/newspaper/page/24091774 | 24091774 |
24524 | 24524 | 1911-05-13 | 6 | b | Coronation ceremony of British Emperor | statistics of the army and money spent in the coronation ceremony. | Other... | http://trove.nla.gov.au/newspaper/page/24091774 | 24091774 |
24530 | 24530 | 1911-05-13 | 8 | a | Imperial edicts | Zeng Qizhe is asked to take a position in Beijing. Fu Lun takes the post of minister for agriculture, industry and commerce. New appointments for the state advisory committee. Li Jiaben and Liu Ruzeng were appointed new positions in the department of justice. Each governor was asked to well control its budget. Lin Shaonian was appointed minister assistant for department of civil affairs. Qu Shiqi was appointed a new post and several other edicts. | Other... | http://trove.nla.gov.au/newspaper/page/24091776 | 24091776 |
24533 | 24533 | 1911-05-13 | 8 | b-c | Killing of General Fu | The story of the killing of General Fu was told. | Other... | http://trove.nla.gov.au/newspaper/page/24091776 | 24091776 |
24534 | 24534 | 1911-05-13 | 8 | c | Donations to Jiangsu and Anhui | Donations from Association for Imperial Constitution in Sydney. More than 30 donators' names listed. | Other... | http://trove.nla.gov.au/newspaper/page/24091776 | 24091776 |
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]);