This data as json, CSV (advanced)
Suggested facets: column, title, date (date)
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30134 | 30134 | 1915-06-05 | 7 | a-b | Australia has enrolled over 80,000 soldiers. Statistics of Australian soldiers killed and wounded in the Europe War. Ya Qu, a Chinese was murdered in Sydney and four suspects were arrested. Details of the murder case of the Chinese Ya Qu. A Chinese seaman was drawn during fishing. | Australia | http://trove.nla.gov.au/newspaper/page/24094868 | 24094868 | |
17351 | 17351 | 1907-04-27 | 7 | a | Japan is the major threat to Australia, an article translated from the Sydney Sunday Times. | Australia | http://trove.nla.gov.au/newspaper/page/26801311 | 26801311 | |
17352 | 17352 | 1907-04-27 | 7 | a | Australia's foreign trade develops very fast, confirmed by the acting prime minister in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/26801311 | 26801311 | |
23839 | 23839 | 1910-11-19 | 7 | a | Sunday Times in Sydney comments on Australia's relation with China and its future development. | Australia | http://trove.nla.gov.au/newspaper/page/26802845 | 26802845 | |
24134 | 24134 | 1911-01-07 | 7 | a | Australian news | The Commonwealth government released a new legislation to ban opium; the survey on the numbers of naturalisation in Australia; Hanyang steel sells well in Australia; the Minister of Australia Defence requested to establish a Navy College before the British military commander finishes his survey on Australia's national defence; the jurisdiction of Nortern Territory is now transferred from South Australia to the Commonwealth; the numbers of money notes produced by the Commonwealth; Australia implements compulsory military service law; aboriginal crown coronation taking place in Bortmin in NSW ; Murder or suicide in Glanviwlle in South Australia; an American sugar industrialist visited Sydney, warning Australia to keep eyes on Japan which might invade Australia's north. | Australia | http://trove.nla.gov.au/newspaper/page/24091592 | 24091592 |
24348 | 24348 | 1911-02-18 | 7 | a | Australian news | A celebration was held for the Emperor's birthday; Ship Jiyishidun (nnn) was out of risk; some Japaneses had an expedition to the South Pole; Australian Youth Organisation planned to send 30 youths to travel around the world; Geba (ppp) area was flooded; ban of opium in Australia; overseas-Chinese business organisations in South Australia celebrated Chinese New Year; new facilities on German ships. | Australia | http://trove.nla.gov.au/newspaper/page/24091673 | 24091673 |
24629 | 24629 | 1911-06-03 | 7 | a | Notes of Sydney Empire Constitutional Association | Aims of the Association and regulations on memebership. | Australia | http://trove.nla.gov.au/newspaper/page/24091798 | 24091798 |
24809 | 24809 | 1911-08-05 | 7 | a | Australia news | Investigation statistics of New South Wales institutes. Fi She (nnn), Australian premier wants Australia to be independant. More opium smuggles are exposed. Ya Chang, a Chinese merchant, is robbed in Sydney. More Chinese were attacked in Sydney. Proposal of land nationalisation cause debates in parliament. Intensified strike in Tasmania. New commonwealth governor is to take office. A Chinese woman is to be expelled. Attacks on Chinese occurred in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24091870 | 24091870 |
25147 | 25147 | 1911-10-14 | 7 | a | Australia news | Australian businessman is well treated in Japan. Labour Party of south Australia wins its parliament majority. Chief of British opium ban association comes to Australia. Newcastle's coal export in September. Federal Foreign Minister passed away. Labour power increases and leads to loss of both labour and capital. A Chinese shop in Melbourne is found doing gambling business. Memorising Confucius birthday in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24091961 | 24091961 |
25297 | 25297 | 1911-11-18 | 7 | a | Notice of Sydney Empire Constitution Association | A notice calling for donations to Anhui and Liang Hu stricken by flooding. | Australia | http://trove.nla.gov.au/newspaper/page/24092005 | 24092005 |
29166 | 29166 | 1914-08-15 | 7 | a | Australia news/ Fewer merchant ships are arriving in Australia due to the war in Europe. Many young Australians are recruited. Australian federal government commandeer ships in Sydney. Passenger liner St Albans of Gibbs Bright & Co, is stuck in Townsville, Queensland, on its way from Sydney to Hong Kong. German warships in Samoa island. | Australia | http://trove.nla.gov.au/newspaper/page/24093215 | 24093215 | |
29793 | 29793 | 1915-03-20 | 7 | a | Australia news/ An European man Wu Dan Lou (nnn) aged 100 years old died in Sydney. A soldier in Sydney is charged for his swear after being drunk. Greek consul in Melbourne notifies that all previous Greek soldiers in Victoria to register. Australian government is to provide relief funds for poor people from the enemy countries. | Australia | http://trove.nla.gov.au/newspaper/page/24094780 | 24094780 | |
29998 | 29998 | 1915-05-01 | 7 | a | Australia news/ Australian Bank in New South Wales finds a large number of money missing. Speech of China's Buissness and Trade Association in Sydney. Chinese in Bendigo are enthusiastic in buying Chinese public loans. Case of an European man committing suicide and a Chinese girl being murdered. Chinese in Melbourne are competing to buy Chinese public loans, names listed. | Australia | http://trove.nla.gov.au/newspaper/page/24094828 | 24094828 | |
30105 | 30105 | 1915-05-29 | 7 | a | Australia news/People in Sydney competes to donate for refugees in Belgium which is occupied by Germany. General of Australian Far-East troop passes away during trip to Egypt. Funeral of Bu Li Zhi ( nnn), General of Australian Far-East troops. | Australia | http://trove.nla.gov.au/newspaper/page/24094860 | 24094860 | |
30160 | 30160 | 1915-06-13 | 7 | a | Australian news/ Chinese consul general notifies all Chinese in Australia to purchase passports as British government requires. Statistics of Australian soldiers killed and wounded in the Europe War. Twelve illegal immigrants are found in a ship in Brisbane. A German man commits suicide after having killed his wife and children in South Australia. A comet appears in Perth. A British company in Sydney, allegedly believed to be run by German people, is suffered from loss as Chinese refuse to buy goods from it. | Australia | |||
30329 | 30329 | 1915-07-31 | 7 | a | Australia news/ Notice of China's Trade and Business Association in Sydney on donations for Australian Injured Soldiers' funds, names listed. Overseas Chinese in Sydney are competing to donate for Guangdong floods. Statistics show that banks in New South Wales are making good progress on deposits. Statistics of sugar products in Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24094932 | 24094932 | |
30351 | 30351 | 1915-08-07 | 7 | a | Australia news/ Notice of consul general in Australia on issuing public loans of China. Statistics of donations on Australia Day for injured soldiers. Statistics of Australian soldiers killed and wounded in the Europe War. Two people dealing opium in Sydney are fined. A 25-year old European man killed his father during parents' querrelling. | Australia | http://trove.nla.gov.au/newspaper/page/24094940 | 24094940 | |
30414 | 30414 | 1915-08-28 | 7 | a | Notice of Chinese counsil general in New Zealand notifies that all Chinese should abide by law of New Zealand and not bring too much money out of New Zealand. | Australia | http://trove.nla.gov.au/newspaper/page/24094966 | 24094966 | |
30460 | 30460 | 1915-09-11 | 7 | a | Chinese council general in Australia notifies that all Chinese newspapers with a few exceptions are allowed to enter into Australia now. | Australia | http://trove.nla.gov.au/newspaper/page/24094982 | 24094982 | |
30461 | 30461 | 1915-09-11 | 7 | a | Notice of Chinese council general in Australia to China's Business and Trade Association in Sydney on helping Chinese people filling investigation forms required by Australian general prosecutor. | Australia | http://trove.nla.gov.au/newspaper/page/24094982 | 24094982 | |
30482 | 30482 | 1915-09-18 | 7 | a | Australia news/ Australian general prosecutor decides to extend the deadline for people handing in property and individual investigation forms. An European gentleman in Wanly (ppp) is arrested by policemen by mistakes as neighbours report that he and his man broke into a private house. Sydney court convicts that the Chinese woman divorces her husband who married another woman in China. Twenty nine Chinese are arrested in Sydney for gambling. | Australia | http://trove.nla.gov.au/newspaper/page/24094990 | 24094990 | |
30614 | 30614 | 1915-10-23 | 7 | a | Australia news/ Statistics show Australian population is increasing. Australia premier Fi Sa (nnn) and Finance Minister Pi Shi (nnn) charges Shi Shi Pian Li Ya (nnn) for slanting them. Some people in Sydney advocate to donate for refugees in the Ally's countries. Statistics of Australian soldiers killed and wounded in the Europe War. | Australia | http://trove.nla.gov.au/newspaper/page/24095030 | 24095030 | |
30674 | 30674 | 1915-11-06 | 7 | a | Australia news/ A new Australia federal government is set up with Rai (nnn) as premier. The income tax report for all people is to be closed soon. A bank in Sydney lost a post parcel containing 100 pounds of paper money during posting. An European couple in Sydney charge each other for improper activities and want to divorce. An European man is killed by a cow in New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24095046 | 24095046 | |
30925 | 30925 | 1916-01-22 | 7 | a | Australia news/ Notice of Chinese consul general on changing new passports. An European lawyer replies that Australian government can't compel Chinese people to join the army according to international law. Statistics of Australian soldiers killed and wounded in the Europe War. Price of sugar rises in Australia. Bush fire in New South Wales results in heavy loss for agriculture. | Australia | http://trove.nla.gov.au/newspaper/page/24095121 | 24095121 | |
31053 | 31053 | 1916-03-18 | 7 | a | Australia news/German schools in Victoria are banned for their improper teaching. A 4-year old girl is brutally murdered in Melbourne. Some 19 Chinese are arrested for gambling in Sydney. Chinese consul general notifies that government troops defeat Yunnan revolutionary troops. | Australia | http://trove.nla.gov.au/newspaper/page/24095198 | 24095198 | |
31202 | 31202 | 1916-05-06 | 7 | a | A notice issued by Chinese Consul-General in Melbourne Zeng Zongjian says some government bonds can be cashed now. | Australia | http://trove.nla.gov.au/newspaper/page/24095255 | 24095255 | |
34625 | 34625 | 1919-06-28 | 7 | a | Germany has signed the Treaty at the Paris Peace Conference. | Australia | http://trove.nla.gov.au/newspaper/page/24097771 | 24097771 | |
37036 | 37036 | 1921-05-28 | 7 | a | Sydney Morning Herald reports the banking group that to be formed in Beijing. | Australia | http://trove.nla.gov.au/newspaper/page/24093560 | 24093560 | |
37397 | 37397 | 1921-07-30 | 7 | a | Oil deposit found in Western Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24093632 | 24093632 | |
37818 | 37818 | 1921-11-05 | 7 | a | Report on the operation and profit of big companies in Sydney in 1920 and 1921. | Australia | http://trove.nla.gov.au/newspaper/page/24093746 | 24093746 | |
38176 | 38176 | 1922-01-21 | 7 | a | Deficit of the railway operation in the six Australian states. | Australia | http://trove.nla.gov.au/newspaper/page/24093834 | 24093834 | |
39032 | 39032 | 1922-11-18 | 7 | a | Report on the money supply in Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 | |
39034 | 39034 | 1922-11-18 | 7 | a | Import and export of Australia in 1921. | Australia | http://trove.nla.gov.au/newspaper/page/24094191 | 24094191 | |
39095 | 39095 | 1922-12-02 | 7 | a | A Melbourne man is injured in a motorbike accident. | Australia | http://trove.nla.gov.au/newspaper/page/24094207 | 24094207 | |
39096 | 39096 | 1922-12-02 | 7 | a | Thief steals a lot socks from a Melbourne shop on Elizabeth Street. | Australia | http://trove.nla.gov.au/newspaper/page/24094207 | 24094207 | |
39122 | 39122 | 1922-12-09 | 7 | a | Industrial development in Victoria (number of factories, workers and products). | Australia | http://trove.nla.gov.au/newspaper/page/24094215 | 24094215 | |
39123 | 39123 | 1922-12-09 | 7 | a | Prime Minister Billy Hughes is jeered at in Melbourne city town hall. | Australia | http://trove.nla.gov.au/newspaper/page/24094215 | 24094215 | |
39154 | 39154 | 1922-12-16 | 7 | a | Storm in Broken Hill, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24094223 | 24094223 | |
39184 | 39184 | 1922-12-23 | 7 | a | A case of manslaughter in Goulburn, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39239 | 39239 | 1923-01-06 | 7 | a | A department store in Sydney on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 | |
39302 | 39302 | 1923-01-20 | 7 | a | A fisherman in Redfern, Sydney, is punished for the capture of fish that are too small. | Australia | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
39303 | 39303 | 1923-01-20 | 7 | a | A thief suspect is detained in Sydney for burglary. | Australia | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
39304 | 39304 | 1923-01-20 | 7 | a | A Melbourne woman shoots dead her husband for divorce. | Australia | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
39336 | 39336 | 1923-01-27 | 7 | a | Two Chinese students in Melbourne are awarded for their drawing of British royal ship. | Australia | http://trove.nla.gov.au/newspaper/page/24094271 | 24094271 | |
39337 | 39337 | 1923-01-27 | 7 | a | A Chinese warehouse in Little Bourke Street, Melbourne, is on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094271 | 24094271 | |
39338 | 39338 | 1923-01-27 | 7 | a | A Sydney man is punished for showing pornographic pictures to a young girl. | Australia | http://trove.nla.gov.au/newspaper/page/24094271 | 24094271 | |
39367 | 39367 | 1923-02-03 | 7 | a | A shoe shop in Flinders Street, Melbourne, is on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094279 | 24094279 | |
39368 | 39368 | 1923-02-03 | 7 | a | A Chinese man is stabbed and seriously injured in Little Bourke Street, Melbourne, by another Chinese laundry man. | Australia | http://trove.nla.gov.au/newspaper/page/24094279 | 24094279 | |
39370 | 39370 | 1923-02-03 | 7 | a | A drunken man is detained from a Sydney hotel for playing gun. | Australia | http://trove.nla.gov.au/newspaper/page/24094279 | 24094279 | |
39402 | 39402 | 1923-02-10 | 7 | a | Woman's body found under a bridge in the west of Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24094289 | 24094289 | |
39558 | 39558 | 1923-03-03 | 7 | a | A Melbourne factory in Footscray is on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094322 | 24094322 | |
39559 | 39559 | 1923-03-03 | 7 | a | Street cleaners in Melbourne are on strike. | Australia | http://trove.nla.gov.au/newspaper/page/24094322 | 24094322 | |
39707 | 39707 | 1923-04-07 | 7 | a | Earthquake in Port Darwin. | Australia | http://trove.nla.gov.au/newspaper/page/24094363 | 24094363 | |
39708 | 39708 | 1923-04-07 | 7 | a | Bush fire near Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094363 | 24094363 | |
39710 | 39710 | 1923-04-07 | 7 | a | Racing course on fire in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094363 | 24094363 | |
39711 | 39711 | 1923-04-07 | 7 | a | A young mother in Sydney is brought to trial for manslaughter. | Australia | http://trove.nla.gov.au/newspaper/page/24094363 | 24094363 | |
39736 | 39736 | 1923-04-14 | 7 | a | Cotton production in Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24094371 | 24094371 | |
39898 | 39898 | 1923-05-26 | 7 | a | A Sydney missionary has magic skills to cure patients. | Australia | http://trove.nla.gov.au/newspaper/page/24094419 | 24094419 | |
39901 | 39901 | 1923-05-26 | 7 | a | Counterfeit bank notes found in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094419 | 24094419 | |
39925 | 39925 | 1923-06-02 | 7 | a | Decline of the shipping industry in Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24094427 | 24094427 | |
39926 | 39926 | 1923-06-02 | 7 | a | Tram in Sydney will operate for 48 hours a week and some employees will be sacked. | Australia | http://trove.nla.gov.au/newspaper/page/24094427 | 24094427 | |
39928 | 39928 | 1923-06-02 | 7 | a | A slaughterhouse in Parramatta, Sydney, is on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094427 | 24094427 | |
39957 | 39957 | 1923-06-09 | 7 | a | Reserve Bank of Australia issues new bank notes. | Australia | http://trove.nla.gov.au/newspaper/page/24094435 | 24094435 | |
39958 | 39958 | 1923-06-09 | 7 | a | A machine factory explodes in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094435 | 24094435 | |
39984 | 39984 | 1923-06-16 | 7 | a | Japan purchases wool from Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24094443 | 24094443 | |
39985 | 39985 | 1923-06-16 | 7 | a | A convict in Sydney commit crime once again after being released. | Australia | http://trove.nla.gov.au/newspaper/page/24094443 | 24094443 | |
39986 | 39986 | 1923-06-16 | 7 | a | Sugar price is going down in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094443 | 24094443 | |
40050 | 40050 | 1923-06-30 | 7 | a | Development of textile industry in Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24094459 | 24094459 | |
40051 | 40051 | 1923-06-30 | 7 | a | A case of divorce in Melbourne and the story. | Australia | http://trove.nla.gov.au/newspaper/page/24094459 | 24094459 | |
40104 | 40104 | 1923-07-14 | 7 | a | French Consul's residence in Melbourne is burglarised. | Australia | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40105 | 40105 | 1923-07-14 | 7 | a | An old man is found rich after his death in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40107 | 40107 | 1923-07-14 | 7 | a | The biggest department store in Sydney and its profit last year. | Australia | http://trove.nla.gov.au/newspaper/page/24094475 | 24094475 | |
40139 | 40139 | 1923-07-21 | 7 | a | Commonwealth government of Australia raises money to repay the internal bonds. | Australia | http://trove.nla.gov.au/newspaper/page/24094483 | 24094483 | |
40169 | 40169 | 1923-07-28 | 7 | a | Postal service in Australia makes profit. | Australia | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
40170 | 40170 | 1923-07-28 | 7 | a | New South Wales premier returns to Sydney after touring Britain, south Europe, America and Canada. | Australia | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
40172 | 40172 | 1923-07-28 | 7 | a | Husband and wife suffers in Sydney due to unemployment. | Australia | http://trove.nla.gov.au/newspaper/page/24094491 | 24094491 | |
40230 | 40230 | 1923-08-11 | 7 | a | A group of Japanese and American scientists arrives Sydney on their way to Melbourne for a Pacific scientific conference in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24094507 | 24094507 | |
40263 | 40263 | 1923-08-18 | 7 | a | Commonwealth government of Australia increases its military budget. | Australia | http://trove.nla.gov.au/newspaper/page/24094515 | 24094515 | |
40336 | 40336 | 1923-09-01 | 7 | a | Federal treasurer suggests to reduce stamp duty of the postal service. | Australia | http://trove.nla.gov.au/newspaper/page/24094531 | 24094531 | |
40337 | 40337 | 1923-09-01 | 7 | a | Strike in Australia and the loss it caused in the past six months. | Australia | http://trove.nla.gov.au/newspaper/page/24094531 | 24094531 | |
40402 | 40402 | 1923-09-15 | 7 | a | Australia donates to the earthquake victims in Japan. | Australia | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 | |
40403 | 40403 | 1923-09-15 | 7 | a | A policeman in New South Wales shoots dead his colleague. | Australia | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 | |
40404 | 40404 | 1923-09-15 | 7 | a | A Sydney man commits incest and is punished. | Australia | http://trove.nla.gov.au/newspaper/page/24094547 | 24094547 | |
40441 | 40441 | 1923-09-22 | 7 | a | A tram runs out of control in Melbourne and some passengers are injured. | Australia | http://trove.nla.gov.au/newspaper/page/24094555 | 24094555 | |
40605 | 40605 | 1923-10-27 | 7 | a | A federal bank inspector is robbed in a Sydney hotel. | Australia | http://trove.nla.gov.au/newspaper/page/24094595 | 24094595 | |
40685 | 40685 | 1923-11-17 | 7 | a | Statistics on consumption of local products in Australia (wheat, butter, cheese, fruit, milk, spring water, wine, and other). | Australia | http://trove.nla.gov.au/newspaper/page/24094619 | 24094619 | |
40686 | 40686 | 1923-11-17 | 7 | a | A conference in Hobart, Tasmania, on national defence of Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24094619 | 24094619 | |
40688 | 40688 | 1923-11-17 | 7 | a | A young girl commits suicide in Sydney but was saved. | Australia | http://trove.nla.gov.au/newspaper/page/24094619 | 24094619 | |
40779 | 40779 | 1923-12-08 | 7 | a | Women want to serve jury in New South Wales and their fighting. | Australia | http://trove.nla.gov.au/newspaper/page/24094643 | 24094643 | |
40780 | 40780 | 1923-12-08 | 7 | a | Some policemen in Melbourne are awarded for their continuing service during the strike of their colleagues. | Australia | http://trove.nla.gov.au/newspaper/page/24094643 | 24094643 | |
40867 | 40867 | 1923-12-29 | 7 | a | A Sydney woman is punished for baby murder. | Australia | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
40868 | 40868 | 1923-12-29 | 7 | a | A shop in Flinders Street, Melbourne is on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
40869 | 40869 | 1923-12-29 | 7 | a | A young woman in Sydney is found using counterfeit bank notes. | Australia | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
40870 | 40870 | 1923-12-29 | 7 | a | Two illegal Japanese immigrants are detained in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
40901 | 40901 | 1924-01-05 | 7 | a | A warehouse in Sydney is burglarised. | Australia | http://trove.nla.gov.au/newspaper/page/24100561 | 24100561 | |
40902 | 40902 | 1924-01-05 | 7 | a | A skilled bank swindler in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24100561 | 24100561 | |
40903 | 40903 | 1924-01-05 | 7 | a | Shops are reminded of burglary in Newtown area, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100561 | 24100561 | |
40904 | 40904 | 1924-01-05 | 7 | a | Japanese naval fleet has arrived Western Australia for a visit. | Australia | http://trove.nla.gov.au/newspaper/page/24100561 | 24100561 | |
40961 | 40961 | 1924-01-19 | 7 | a | Crocodile swallows a bandit near Brisbane, Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100577 | 24100577 | |
40962 | 40962 | 1924-01-19 | 7 | a | Bakery workers in Sydney are on strike. | Australia | http://trove.nla.gov.au/newspaper/page/24100577 | 24100577 |
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]);