This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25691 | 25691 | 1912-02-03 | 7 | a-b | Australia news | Final examination result of Sydney China's primary school. Construction workers in West Australia propose a shorter working hour. Statistics of income of the railways and buses in New South Wales. The European youngster who killed Xiang Jiang,a Chinese, was brought in a verdict of mistaken killing. Haircut price is to be up in Sydney. An Australian proposes ban on marriage between white women and Chinese men. Workers in Brisbane strike for protecting their working rights. A 19-year old European man was sentenced to death for murdering another European man. China's Red Cross calling on donations for the Republic of China. | Australia | http://trove.nla.gov.au/newspaper/page/24092094 | 24092094 |
25692 | 25692 | 1912-02-03 | 7 | b | The world of bombs | Bomb killings increased rapidly in Beijing, Tianjing and other places. | China | http://trove.nla.gov.au/newspaper/page/24092094 | 24092094 |
25693 | 25693 | 1912-02-03 | 7 | b | Last hopes of Manchu nobles | Emperor appeals to Dowager Cixi to accept republican conditions in order to keep benefits of Manchu aristocrats. | China | http://trove.nla.gov.au/newspaper/page/24092094 | 24092094 |
25694 | 25694 | 1912-02-03 | 7 | b | Qing soldiers reluctant to fight | Qing soldiers reluctant to fight republican soldiers due to their loss of confidence of Qing government. | China | http://trove.nla.gov.au/newspaper/page/24092094 | 24092094 |
25695 | 25695 | 1912-02-03 | 7 | b-c | Beijing news | Yuan Shikai has utmost power over state affairs. Members of State Advisory Committee leave Beijing one after another. Manchu aristocrats worry about their future. | Other... | http://trove.nla.gov.au/newspaper/page/24092094 | 24092094 |
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]);