This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24670 | 24670 | 1911-07-08 | 2 | a-b | Disguise of Prince Qing is exposed to the world | Various failures, conspiracies and corruptions are exposed during the administration of Prince Qing. | China | http://trove.nla.gov.au/newspaper/page/24091835 | 24091835 |
24681 | 24681 | 1911-07-08 | 3 | a-b | Friendship between Britain and Japan | Two Japanese general came for the coronation. | Britain | http://trove.nla.gov.au/newspaper/page/24091834 | 24091834 |
24689 | 24689 | 1911-07-08 | 6 | a-b | Appeal for donations to those killed in Mexico | An appeal is made for donations to those Chinese killed in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24091839 | 24091839 |
24691 | 24691 | 1911-07-08 | 7 | a-b | Australian news | Sydney Association for Imperial Constitution held its meeting. A bank in New South Wales was robbed. The postponed British prince's birthday celebration is to be held soon. Australia is to negotiate with Japan about Japanese tourists to Australia. Donations are called for the expedition to the South Pole. Donations from Huang Zicheng, Kang Dirong and Wu Shihua are received to Nanqiang School, Guangdong. Private bank notes are collected by the government. The battle of banana market between Queensland and Fiji. Several insult cases happened in Sydney. Prison is a good place for quitting opium smoking. | Other... | http://trove.nla.gov.au/newspaper/page/24091838 | 24091838 |
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]);