This data as json, CSV (advanced)
Link | rowid ▲ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43312 | 43312 | 1925-06-06 | 7 | a | A Sydney girl, 17, disappears. | Australia | http://trove.nla.gov.au/newspaper/page/24101161 | 24101161 | |
43276 | 43276 | 1925-05-30 | 7 | b | Tobacco price is going down in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101153 | 24101153 | |
43275 | 43275 | 1925-05-30 | 7 | b | Sydney customs officer seizes smuggled opium. | Australia | http://trove.nla.gov.au/newspaper/page/24101153 | 24101153 | |
43274 | 43274 | 1925-05-30 | 7 | a-b | Two hundreds unemployed people demonstrate in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24101153 | 24101153 | |
43271 | 43271 | 1925-05-30 | 7 | a | More robberies in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101153 | 24101153 | |
43240 | 43240 | 1925-05-23 | 7 | b | A fire in Lonsdale Street, Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24101145 | 24101145 | |
43239 | 43239 | 1925-05-23 | 7 | b | An illegal Chinese immigrant (former sailor) is arrested in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101145 | 24101145 | |
43237 | 43237 | 1925-05-23 | 7 | a-b | Four Chinese opium addicts are detained in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24101145 | 24101145 | |
43197 | 43197 | 1925-05-16 | 7 | b | Two trams collide in Manly, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101137 | 24101137 | |
43195 | 43195 | 1925-05-16 | 7 | a-b | Chinese gardener in Sydney Li Kang falls from a carriage and gets injured. | Australia | http://trove.nla.gov.au/newspaper/page/24101137 | 24101137 | |
43194 | 43194 | 1925-05-16 | 7 | a | Service trades workers are on strike in Perth, Western Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24101137 | 24101137 | |
43193 | 43193 | 1925-05-16 | 7 | a | Police raid a gambling den in Redfern, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101137 | 24101137 | |
43192 | 43192 | 1925-05-16 | 7 | a | A seven years old girl is raped in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101137 | 24101137 | |
43186 | 43186 | 1925-05-16 | 5 | c | American trade delegation postpones their visit to Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24101135 | 24101135 | |
43156 | 43156 | 1925-05-09 | 7 | a | Leaflets found in Sydney with a purpose to defame leader of the Labour Party. | Australia | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 | |
43155 | 43155 | 1925-05-09 | 7 | a | Three Chinese are arrested from 430 Sussex Street, Sydney, for opium smoking. | Australia | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 | |
43154 | 43154 | 1925-05-09 | 7 | a | Chinese carpenters are arrested in Melbourne for opium smuggling. | Australia | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 | |
43153 | 43153 | 1925-05-09 | 7 | a | A policeman in Port Darwin is sacked for accepting bribery from Chinese merchant. | Australia | http://trove.nla.gov.au/newspaper/page/24101129 | 24101129 | |
43146 | 43146 | 1925-05-09 | 5 | c | Police commissioner of New South Wales visits America. | Australia | http://trove.nla.gov.au/newspaper/page/24101127 | 24101127 | |
43114 | 43114 | 1925-05-02 | 7 | a-b | Chinese man is arrested in Sydney for opium smuggling. Sydney customs officer seizes opium smuggled. | Australia | http://trove.nla.gov.au/newspaper/page/24101121 | 24101121 | |
43113 | 43113 | 1925-05-02 | 7 | a | An old woman in Melbourne dies in the house fire. | Australia | http://trove.nla.gov.au/newspaper/page/24101121 | 24101121 | |
43078 | 43078 | 1925-04-25 | 7 | a | Two thieves are captured in Sydney for burglary. | Australia | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 | |
43077 | 43077 | 1925-04-25 | 7 | a | Counterfeit bank notes found in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101113 | 24101113 | |
43063 | 43063 | 1925-04-25 | 5 | b | Australian Oriental Navigation Company has built another big liner. | Australia | http://trove.nla.gov.au/newspaper/page/24101111 | 24101111 | |
43040 | 43040 | 1925-04-18 | 7 | a-b | King of Britain sends his condolence to the Prime Minister of New Zealand. | Australia | http://trove.nla.gov.au/newspaper/page/24101105 | 24101105 | |
43029 | 43029 | 1925-04-18 | 5 | c | British and Dutch ships collide. | Australia | http://trove.nla.gov.au/newspaper/page/24101103 | 24101103 | |
42998 | 42998 | 1925-04-11 | 7 | a | Two Chinese are insulted in New Castle at mid-night. | Australia | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
42997 | 42997 | 1925-04-11 | 7 | a | A Chinese man in Cairns, Queensland, is penalised for selling opium. | Australia | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
42996 | 42996 | 1925-04-11 | 7 | a | Storm in Adelaide, South Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
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 | |
42960 | 42960 | 1925-04-04 | 7 | b | Unemployed and homeless people in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24101089 | 24101089 | |
42959 | 42959 | 1925-04-04 | 7 | b | A retired policeman in Sydney shoots himself dead in front of his wife. | Australia | http://trove.nla.gov.au/newspaper/page/24101089 | 24101089 | |
42957 | 42957 | 1925-04-04 | 7 | b | Foreign visitors talk about situation in Guangdong. | Australia | http://trove.nla.gov.au/newspaper/page/24101089 | 24101089 | |
42925 | 42925 | 1925-03-28 | 7 | a | Quarrel between Chinese shop owner and white customer in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42924 | 42924 | 1925-03-28 | 7 | a | Italian consul in Australia suggests to accept more immigrants. | Australia | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42923 | 42923 | 1925-03-28 | 7 | a | Population increases in New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42922 | 42922 | 1925-03-28 | 7 | a | Australia's trade with Germany and the statistics on import and export. | Australia | http://trove.nla.gov.au/newspaper/page/24101081 | 24101081 | |
42907 | 42907 | 1925-03-28 | 3 | c | American naval fleet on the way to visit Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
42891 | 42891 | 1925-03-21 | 7 | a | A female bandit in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101073 | 24101073 | |
42889 | 42889 | 1925-03-21 | 7 | a | An accountant in Sydney is found guilty of embezzlement for his racing hobby. | Australia | http://trove.nla.gov.au/newspaper/page/24101073 | 24101073 | |
42856 | 42856 | 1925-03-14 | 7 | a | Methodist church in Adelaide and Sydney oppose dancing party, and some comments by the Tung Wah Times. | Australia | http://trove.nla.gov.au/newspaper/page/24101065 | 24101065 | |
42855 | 42855 | 1925-03-14 | 7 | a | A white woman is crushed to death in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101065 | 24101065 | |
42854 | 42854 | 1925-03-14 | 7 | a | American naval fleet will not visit Hobart, Tasmania. | Australia | http://trove.nla.gov.au/newspaper/page/24101065 | 24101065 | |
42819 | 42819 | 1925-03-07 | 7 | a | Rubber plant workers are on strike in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101057 | 24101057 | |
42818 | 42818 | 1925-03-07 | 7 | a | A Melbourne doctor warns the flu from Britain. | Australia | http://trove.nla.gov.au/newspaper/page/24101057 | 24101057 | |
42817 | 42817 | 1925-03-07 | 7 | a | An Italian immigrant in Sydney commits suicide. | Australia | http://trove.nla.gov.au/newspaper/page/24101057 | 24101057 | |
42816 | 42816 | 1925-03-07 | 7 | a | Leaflets found in Melbourne call for boycott to the visit of American fleet. | Australia | http://trove.nla.gov.au/newspaper/page/24101057 | 24101057 | |
42815 | 42815 | 1925-03-07 | 7 | a | English newspaper in Sydney reports and comments on current situation in China. | Australia | http://trove.nla.gov.au/newspaper/page/24101057 | 24101057 | |
42779 | 42779 | 1925-02-28 | 7 | a | Hot weather in Moree, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24101049 | 24101049 | |
42778 | 42778 | 1925-02-28 | 7 | a | Hot weather in Brisbane. | Australia | http://trove.nla.gov.au/newspaper/page/24101049 | 24101049 | |
42777 | 42777 | 1925-02-28 | 7 | a | A white man is drowned in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24101049 | 24101049 | |
42776 | 42776 | 1925-02-28 | 7 | a | A girl in Melbourne commits suicide but is saved. | Australia | http://trove.nla.gov.au/newspaper/page/24101049 | 24101049 | |
42775 | 42775 | 1925-02-28 | 7 | a | Another gale in Melbourne and the damages. | Australia | http://trove.nla.gov.au/newspaper/page/24101049 | 24101049 | |
42774 | 42774 | 1925-02-28 | 7 | a | Storm in Tasmania and the damages. | Australia | http://trove.nla.gov.au/newspaper/page/24101049 | 24101049 | |
42749 | 42749 | 1925-02-21 | 7 | a | Seven Chinese gamblers are detained in Campbell Street, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24101037 | 24101037 | |
42748 | 42748 | 1925-02-21 | 7 | a | A girl in Melbourne is raped by two men. | Australia | http://trove.nla.gov.au/newspaper/page/24101037 | 24101037 | |
42747 | 42747 | 1925-02-21 | 7 | a | Gale in Melbourne and the damages. | Australia | http://trove.nla.gov.au/newspaper/page/24101037 | 24101037 | |
42717 | 42717 | 1925-02-14 | 7 | a | A newly-married couple flies to Sydney for honeymoon. | Australia | http://trove.nla.gov.au/newspaper/page/24101041 | 24101041 | |
42716 | 42716 | 1925-02-14 | 7 | a | Flood in Adelaide. | Australia | http://trove.nla.gov.au/newspaper/page/24101041 | 24101041 | |
42715 | 42715 | 1925-02-14 | 7 | a | Leader of the dockers' strike is brought to trial in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24101041 | 24101041 | |
42714 | 42714 | 1925-02-14 | 7 | a | Australian federal government to restrict the entry of immigration from south Europe. | Australia | http://trove.nla.gov.au/newspaper/page/24101041 | 24101041 | |
42672 | 42672 | 1925-02-07 | 7 | a | A bank robbery in Caulfield, Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24101024 | 24101024 | |
42643 | 42643 | 1925-01-24 | 7 | b | A sleepwalking man in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42642 | 42642 | 1925-01-24 | 7 | b | A train accident in New South Wales and the tragedy. | Australia | http://trove.nla.gov.au/newspaper/page/24101014 | 24101014 | |
42609 | 42609 | 1925-01-17 | 7 | a | A man in Rockhampton, Queensland, shoots dead his girlfriend. | Australia | http://trove.nla.gov.au/newspaper/page/24101006 | 24101006 | |
42608 | 42608 | 1925-01-17 | 7 | a | Gold found in Rockhampton, Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24101006 | 24101006 | |
42607 | 42607 | 1925-01-17 | 7 | a | Sydney mayor and the road construction. | Australia | http://trove.nla.gov.au/newspaper/page/24101006 | 24101006 | |
42605 | 42605 | 1925-01-17 | 7 | a | Federal Prime Minister talks in Melbourne the immigration issues. | Australia | http://trove.nla.gov.au/newspaper/page/24101006 | 24101006 | |
42577 | 42577 | 1925-01-10 | 7 | c | A woman is drowned in Brisbane and the investigation by police. | Australia | http://trove.nla.gov.au/newspaper/page/24100998 | 24100998 | |
42576 | 42576 | 1925-01-10 | 7 | b-c | Flood in Albury, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24100998 | 24100998 | |
42574 | 42574 | 1925-01-10 | 7 | b | Storm in Brisbane and the damages. | Australia | http://trove.nla.gov.au/newspaper/page/24100998 | 24100998 | |
42573 | 42573 | 1925-01-10 | 7 | b | A Greek house is bombed in Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100998 | 24100998 | |
42572 | 42572 | 1925-01-10 | 7 | b | Australian federal government issues new restriction upon Greek immigrant and the protest of the Greek community in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100998 | 24100998 | |
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 | |
42539 | 42539 | 1925-01-03 | 7 | b | A thief in Caulfield, Melbourne, hurts his fellow. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
42538 | 42538 | 1925-01-03 | 7 | b | Chinese sailors of a Dutch ship win their strike in Fremantle, Western Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
42537 | 42537 | 1925-01-03 | 7 | b | Price of bread is going up in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
42536 | 42536 | 1925-01-03 | 7 | a | A Chinese man in Melbourne injures a white woman with knife and is detained by police. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
42535 | 42535 | 1925-01-03 | 7 | a | A failed robbery in Brisbane, Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
42534 | 42534 | 1925-01-03 | 7 | a | A homicide case in Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
42533 | 42533 | 1925-01-03 | 7 | a | A school in Sydney is burned to ashes during the Christmas holiday. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
42503 | 42503 | 1924-12-27 | 7 | b | A factory in Sydney is burned to ashes. | Australia | http://trove.nla.gov.au/newspaper/page/24100982 | 24100982 | |
42502 | 42502 | 1924-12-27 | 7 | b | Labour Party in New Castle calls to reduce immigration intake. | Australia | http://trove.nla.gov.au/newspaper/page/24100982 | 24100982 | |
42501 | 42501 | 1924-12-27 | 7 | a | Couples are drowned near Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100982 | 24100982 | |
42500 | 42500 | 1924-12-27 | 7 | a | Construction project for the Bondi Beach, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100982 | 24100982 | |
42499 | 42499 | 1924-12-27 | 7 | a | An Australian warship is on fire near Sydney during a training. | Australia | http://trove.nla.gov.au/newspaper/page/24100982 | 24100982 | |
42498 | 42498 | 1924-12-27 | 7 | a | Bank robbery in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100982 | 24100982 | |
42497 | 42497 | 1924-12-27 | 7 | a | Import and export of New South Wales in 1924. | Australia | http://trove.nla.gov.au/newspaper/page/24100982 | 24100982 | |
42496 | 42496 | 1924-12-27 | 7 | a | Two Australian federal ministers to resign. | Australia | http://trove.nla.gov.au/newspaper/page/24100982 | 24100982 | |
42469 | 42469 | 1924-12-20 | 7 | b | A bank robbery in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
42468 | 42468 | 1924-12-20 | 7 | a | Fire in Sydney destroys quite a few shops. | Australia | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
42467 | 42467 | 1924-12-20 | 7 | a | Thirty gamblers are arrested in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
42466 | 42466 | 1924-12-20 | 7 | a | A robbery in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
42465 | 42465 | 1924-12-20 | 7 | a | A shop burglary in Sydney and the investigation. | Australia | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
42438 | 42438 | 1924-12-13 | 7 | b | A child in Melbourne is struck to death by lightening. | Australia | http://trove.nla.gov.au/newspaper/page/24100966 | 24100966 | |
42434 | 42434 | 1924-12-13 | 7 | a | A department store in Sydney is on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24100966 | 24100966 | |
42433 | 42433 | 1924-12-13 | 7 | a | A shop burglary in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100966 | 24100966 | |
42432 | 42432 | 1924-12-13 | 7 | a | Storm in Biloela, Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100966 | 24100966 | |
42407 | 42407 | 1924-12-06 | 7 | b | A bank robber in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24100958 | 24100958 | |
42406 | 42406 | 1924-12-06 | 7 | a-b | An English newspaper in Sydney comments on Sun Yatsen. | Australia | http://trove.nla.gov.au/newspaper/page/24100958 | 24100958 |
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]);