This data as json, CSV (advanced)
Suggested facets: page, title, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 9656 | 9656 | 1902-01-22 | 3 | b-c | A man of Manly, Sydney, drowned while trying to save another woman. | Australia | http://trove.nla.gov.au/newspaper/page/24100306 | 24100306 | |
| 11932 | 11932 | 1903-06-06 | 3 | b-c | A cargo ship sinks into the ocean near Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/26800235 | 26800235 | |
| 16247 | 16247 | 1906-09-29 | 2 | b-c | Translation of an article published in Sydney Daily Telegraph on New China and White Australia. | Australia | http://trove.nla.gov.au/newspaper/page/26801095 | 26801095 | |
| 17040 | 17040 | 1907-03-09 | 3 | b-c | Italian women submit petition to the parliament and demand the right to vote. | Australia | http://trove.nla.gov.au/newspaper/page/26801250 | 26801250 | |
| 17209 | 17209 | 1907-04-06 | 3 | b-c | Wife of Prince of Britain agrees to contribute to the Australian Women's Exhibition that will be held in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/26801282 | 26801282 | |
| 17499 | 17499 | 1907-05-25 | 3 | b-c | Epidemic diseases in India claims tens of thousands of lives. Report on epidemics and casualties in India from 1896 to 1906. | Australia | http://trove.nla.gov.au/newspaper/page/26801339 | 26801339 | |
| 17536 | 17536 | 1907-06-01 | 3 | b-c | A bomb blast in Russia. A suspect has been detained. | Australia | http://trove.nla.gov.au/newspaper/page/26801347 | 26801347 | |
| 18614 | 18614 | 1907-12-14 | 3 | b-c | A woman in Moscow tries to assassinate governor of the city. Comments by Tung Wah Times. | Australia | http://trove.nla.gov.au/newspaper/page/26801571 | 26801571 | |
| 19249 | 19249 | 1908-04-25 | 3 | b-c | Russia raises funds to build railway in Heilongjiang and the far east. | Australia | http://trove.nla.gov.au/newspaper/page/26801709 | 26801709 | |
| 19829 | 19829 | 1908-08-15 | 3 | b-c | Turkey starts constitutional reform. | Australia | http://trove.nla.gov.au/newspaper/page/26801842 | 26801842 | |
| 24239 | 24239 | 1911-01-28 | 7 | b-c | Notice from the Association of Business Protection, Sydney | The Association of Business Protection, Sydney asked for donations to people suffering from famines in Jiangsu and Anhui provinces in China. | Australia | http://trove.nla.gov.au/newspaper/page/24091616 | 24091616 |
| 24812 | 24812 | 1911-08-05 | 8 | b-c | New provisions of immigration policies | Melbourne Counsel issues new regulations immigrants from Singapore and Malaysia. | Australia | http://trove.nla.gov.au/newspaper/page/24091873 | 24091873 |
| 24940 | 24940 | 1911-09-02 | 7 | b-c | Notice of General Counsel | Huang apologises for being unable to meet needs of some Chinese. | Australia | http://trove.nla.gov.au/newspaper/page/24091902 | 24091902 |
| 25179 | 25179 | 1911-10-21 | 8 | b-c | Anecdotes of Australian politician | Xian Li Bo (nnn) , the previous premier of the cabinet, went through many hardships before he realised his political aims of making Australia a federal government. | Australia | http://trove.nla.gov.au/newspaper/page/24091973 | 24091973 |
| 30291 | 30291 | 1915-07-17 | 7 | b-c | Australia news/Hong Kong Tung Wah Hospital calls for donations for Guangdong floods. Regulations of recruiting soldiers in New South Wales. Agriculture Exhibition is to be held for collecting money in Australia Day for wounded soldiers. Ya Rui, a Chinese in Sydney, is released after being charged as illegal immigrant. | Australia | http://trove.nla.gov.au/newspaper/page/24094916 | 24094916 | |
| 31220 | 31220 | 1916-05-13 | 7 | b-c | Australia news/ Premier of New South Wales replies to Zeng Zongjian, Chinese Consul-General in Melbourne. Victoria Market in Sydney is for sale. A white man is on trial for injuring a Chinese man. Two women are detained from an opium den in Waterloo, Sydney. A biscuits factory in Sydney is burgled. | Australia | http://trove.nla.gov.au/newspaper/page/24095263 | 24095263 | |
| 39993 | 39993 | 1923-06-16 | 7 | b-c | A farm in on fire near Hobart, Tasmania. | Australia | http://trove.nla.gov.au/newspaper/page/24094443 | 24094443 | |
| 40027 | 40027 | 1923-06-23 | 7 | b-c | First part of a special report published in the Sydney Morning Herald on the Far Eastern situations (rise of Japan, the future of China and others). | Australia | http://trove.nla.gov.au/newspaper/page/24094451 | 24094451 | |
| 40056 | 40056 | 1923-06-30 | 7 | b-c | Second part of a special report published in the Sydney Morning Herald on the Far Eastern situations (rise of Japan, the future of China and others). | Australia | http://trove.nla.gov.au/newspaper/page/24094459 | 24094459 | |
| 40080 | 40080 | 1923-07-07 | 7 | b-c | Third part of a special report published in the Sydney Morning Herald on the Far Eastern situations (rise of Japan, the future of China and others). | Australia | http://trove.nla.gov.au/newspaper/page/24094467 | 24094467 | |
| 40546 | 40546 | 1923-10-13 | 7 | b-c | Robbery in Glen Waverley railway station, Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24094579 | 24094579 | |
| 40667 | 40667 | 1923-11-10 | 7 | b-c | Delegation of Australian Federal parliamentarians visit New Guinea. | Australia | http://trove.nla.gov.au/newspaper/page/24094611 | 24094611 | |
| 40722 | 40722 | 1923-11-24 | 7 | b-c | A child's body found in Sydney beach. | Australia | http://trove.nla.gov.au/newspaper/page/24094627 | 24094627 | |
| 40756 | 40756 | 1923-12-01 | 7 | b-c | Sydney English newspaper reports the underground opium smuggling network. | Australia | http://trove.nla.gov.au/newspaper/page/24094635 | 24094635 | |
| 41306 | 41306 | 1924-03-22 | 7 | b-c | Royal British naval fleet has arrived in Melbourne and the welcome. | Australia | http://trove.nla.gov.au/newspaper/page/24100659 | 24100659 | |
| 42541 | 42541 | 1925-01-03 | 7 | b-c | American industrialists come to visit Australia with their naval fleet. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
| 42576 | 42576 | 1925-01-10 | 7 | b-c | Flood in Albury, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100998 | 24100998 | |
| 42961 | 42961 | 1925-04-04 | 7 | b-c | A Chinese man in Sydney is seriously injured by a white woman. | Australia | http://trove.nla.gov.au/newspaper/page/24101089 | 24101089 | |
| 43901 | 43901 | 1925-09-26 | 7 | b-c | Member of federal parliament speaks in Melbourne on social security. | Australia | http://trove.nla.gov.au/newspaper/page/24101293 | 24101293 | |
| 49848 | 49848 | 1966-06-10 | 2 | b-c | Open letter of Yie Biannan, Li Chun and others on Chinese rescuing their country | Yie Biannan and Li Chun, the managers of Australian Overseas Chinese Trade Protection Association, call on Chinese to stop the government from trading people's interest and to rescue the troubled country. | Australia |
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]);