This data as json, CSV (advanced)
Link | rowid | date | page | column | title | description ▼ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
11949 | 11949 | 1903-06-13 | 3 | b | A Scotch man in Perth, Western Australia, has invented a plane. | Australia | http://trove.nla.gov.au/newspaper/page/26800239 | 26800239 | |
19055 | 19055 | 1908-03-21 | 3 | a | A Swedish man tries to assassinate King of Norway. | Australia | http://trove.nla.gov.au/newspaper/page/26801669 | 26801669 | |
10593 | 10593 | 1902-05-14 | 2 | f | A Sydney baby was kicked by a Russian man and seriously injured. | Australia | http://trove.nla.gov.au/newspaper/page/24100424 | 24100424 | |
9027 | 9027 | 1901-11-06 | 3 | d | A Sydney boy was punished for stealing tobacco from a shop. | Australia | http://trove.nla.gov.au/newspaper/page/24100220 | 24100220 | |
10709 | 10709 | 1902-05-24 | 3 | c | A Sydney boy was sentenced for theft. | Australia | http://trove.nla.gov.au/newspaper/page/24100435 | 24100435 | |
8648 | 8648 | 1901-09-25 | 3 | b | A Sydney businessman discussed with a journalist about the proposals to ban entry of Chinese and Japanese into Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
10949 | 10949 | 1902-08-23 | 5 | b | A Sydney businessman was punished for an inappropriate advertisement. | Australia | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
11143 | 11143 | 1902-11-01 | 3 | b | A Sydney company building on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24100523 | 24100523 | |
4877 | 4877 | 1900-03-28 | 3 | b | A Sydney company on Pitt St has new water pump for watering gardens. | Australia | http://trove.nla.gov.au/newspaper/page/24102746 | 24102746 | |
10377 | 10377 | 1902-04-19 | 3 | e | A Sydney company won awards for its high-quality fertiliser. | Australia | http://trove.nla.gov.au/newspaper/page/24100395 | 24100395 | |
11680 | 11680 | 1903-03-28 | 3 | b | A Sydney court has found some witnesses provide false evidence. | Australia | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 | |
9374 | 9374 | 1901-12-18 | 3 | d | A Sydney court hearing on theft . | Australia | http://trove.nla.gov.au/newspaper/page/24100268 | 24100268 | |
40871 | 40871 | 1923-12-29 | 7 | a-b | A Sydney department store is on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
9458 | 9458 | 1902-01-01 | 3 | a | A Sydney died but the cause of her death is not apparent. | Australia | http://trove.nla.gov.au/newspaper/page/24100282 | 24100282 | |
10759 | 10759 | 1902-05-31 | 2 | f | A Sydney factory was penalised for employing child labourer under the age of 16. | Australia | http://trove.nla.gov.au/newspaper/page/24100444 | 24100444 | |
7408 | 7408 | 1901-04-06 | 3 | b | A Sydney girl was seriously injured by a house fire. | Australia | http://trove.nla.gov.au/newspaper/page/24099995 | 24099995 | |
43312 | 43312 | 1925-06-06 | 7 | a | A Sydney girl, 17, disappears. | Australia | http://trove.nla.gov.au/newspaper/page/24101161 | 24101161 | |
41959 | 41959 | 1924-08-16 | 7 | a | A Sydney is arrested for counterfeit bank notes. | Australia | http://trove.nla.gov.au/newspaper/page/24100828 | 24100828 | |
11163 | 11163 | 1902-11-08 | 3 | b | A Sydney man comments on Shanghai and Hong Kong after his tour. | Australia | http://trove.nla.gov.au/newspaper/page/24100527 | 24100527 | |
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 | |
10803 | 10803 | 1902-06-04 | 3 | c | A Sydney man commits suicide; man seriously injured on Sydney street; a trial in New Castle; a Melbourne woman sentenced for cheating. | Australia | http://trove.nla.gov.au/newspaper/page/24100447 | 24100447 | |
8843 | 8843 | 1901-10-16 | 3 | b | A Sydney man committed suicide while travelling by train. | Australia | http://trove.nla.gov.au/newspaper/page/24100196 | 24100196 | |
10867 | 10867 | 1902-06-14 | 3 | c-d | A Sydney man committed suicide; a robbery in Sydney; a couple in Sydney died on the same day. | Australia | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
10567 | 10567 | 1902-05-10 | 3 | a | A Sydney man detained for child abuse; baby abandoned in a Sydney lane; a train accident near Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100419 | 24100419 | |
9905 | 9905 | 1902-02-26 | 3 | d | A Sydney man died near a hospital for no reason. | Australia | http://trove.nla.gov.au/newspaper/page/24100337 | 24100337 | |
11352 | 11352 | 1903-01-03 | 3 | b | A Sydney man drowns during the Christmas holiday. | Australia | http://trove.nla.gov.au/newspaper/page/26800147 | 26800147 | |
8286 | 8286 | 1901-07-31 | 3 | b | A Sydney man faces court hearing for theft. | Australia | http://trove.nla.gov.au/newspaper/page/24100125 | 24100125 | |
9721 | 9721 | 1902-01-29 | 2 | e | A Sydney man imprisoned for stealing ducks. | Australia | http://trove.nla.gov.au/newspaper/page/24100315 | 24100315 | |
44094 | 44094 | 1925-11-07 | 7 | a | A Sydney man is charged with raping. | Australia | http://trove.nla.gov.au/newspaper/page/24101343 | 24101343 | |
42239 | 42239 | 1924-10-25 | 7 | a | A Sydney man is penalised for sexual harassment. | Australia | http://trove.nla.gov.au/newspaper/page/24100908 | 24100908 | |
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 | |
41960 | 41960 | 1924-08-16 | 7 | b | A Sydney man sues his wife for adultery and applies for divorce. | Australia | http://trove.nla.gov.au/newspaper/page/24100828 | 24100828 | |
8142 | 8142 | 1901-07-13 | 3 | a | A Sydney man was charged with rape. | Australia | http://trove.nla.gov.au/newspaper/page/24100105 | 24100105 | |
7918 | 7918 | 1901-06-12 | 2 | f | A Sydney man was charged with raping a young girl; a man was charged with theft in Sussex Street, Sydney; a man in Britain was sentenced for swindling. | Australia | http://trove.nla.gov.au/newspaper/page/24100073 | 24100073 | |
7254 | 7254 | 1901-03-20 | 2 | e | A Sydney man was drowned in Manly beach. | Australia | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
9015 | 9015 | 1901-11-06 | 2 | f | A Sydney man was penalised for cheating. | Australia | http://trove.nla.gov.au/newspaper/page/24100221 | 24100221 | |
11456 | 11456 | 1903-01-24 | 3 | c | A Sydney man was penalised for flying kites in a garden; a couple in New Castle ordered to financially support their daughter; a woman in Parramatta, Sydney, sues her husband. | Australia | http://trove.nla.gov.au/newspaper/page/26800158 | 26800158 | |
9814 | 9814 | 1902-02-19 | 2 | e | A Sydney man was penalised for theft. | Australia | http://trove.nla.gov.au/newspaper/page/24100330 | 24100330 | |
8569 | 8569 | 1901-09-18 | 3 | a | A Sydney man was punished for being rude to a girl. | Australia | http://trove.nla.gov.au/newspaper/page/24100164 | 24100164 | |
9301 | 9301 | 1901-12-11 | 3 | a | A Sydney man was punished for robbery. | Australia | http://trove.nla.gov.au/newspaper/page/24100260 | 24100260 | |
8872 | 8872 | 1901-10-19 | 3 | b | A Sydney man was punished for theft. | Australia | http://trove.nla.gov.au/newspaper/page/24100200 | 24100200 | |
7258 | 7258 | 1901-03-20 | 2 | f | A Sydney man was robbed of his gold. | Australia | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7382 | 7382 | 1901-04-03 | 3 | c | A Sydney man was sentenced for embezzlement. | Australia | http://trove.nla.gov.au/newspaper/page/24099991 | 24099991 | |
8638 | 8638 | 1901-09-25 | 2 | f | A Sydney man was sentenced for fraud. | Australia | http://trove.nla.gov.au/newspaper/page/24100173 | 24100173 | |
8904 | 8904 | 1901-10-23 | 3 | d | A Sydney man was sentenced for theft. | Australia | http://trove.nla.gov.au/newspaper/page/24100204 | 24100204 | |
10268 | 10268 | 1902-04-09 | 3 | a | A Sydney man was trampled to death by a circus horse. | Australia | http://trove.nla.gov.au/newspaper/page/24100383 | 24100383 | |
8523 | 8523 | 1901-09-14 | 2 | d | A Sydney man won championship in a yacht racing in Canada. | Australia | http://trove.nla.gov.au/newspaper/page/24100161 | 24100161 | |
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 | |
22746 | 22746 | 1910-05-07 | 2 | c | A Sydney newspaper reports on an attempt to assassinate Prince Regent in Beijing. | Australia | http://trove.nla.gov.au/newspaper/page/26802615 | 26802615 | |
41581 | 41581 | 1924-05-17 | 7 | b | A Sydney policeman is sentenced for raping. | Australia | http://trove.nla.gov.au/newspaper/page/24100724 | 24100724 | |
41375 | 41375 | 1924-04-05 | 7 | a | A Sydney restaurant is penalised for selling wine without licence. | Australia | http://trove.nla.gov.au/newspaper/page/24100675 | 24100675 | |
41635 | 41635 | 1924-05-31 | 7 | a | A Sydney thief is caught on the spot. | Australia | http://trove.nla.gov.au/newspaper/page/24100740 | 24100740 | |
41605 | 41605 | 1924-05-24 | 7 | b | A Sydney woman is brought to trial for drowning her daughters. | Australia | http://trove.nla.gov.au/newspaper/page/24100732 | 24100732 | |
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 | |
42023 | 42023 | 1924-08-30 | 7 | a | A Sydney woman murders her daughter and then commits suicide. | Australia | http://trove.nla.gov.au/newspaper/page/24100844 | 24100844 | |
44011 | 44011 | 1925-10-17 | 7 | c | A Sydney woman, 51, commits suicide. | Australia | http://trove.nla.gov.au/newspaper/page/24101317 | 24101317 | |
43659 | 43659 | 1925-08-15 | 7 | a | A Sydney woman, disguised as a man, works on a cargo ship to make a living. | Australia | http://trove.nla.gov.au/newspaper/page/24101245 | 24101245 | |
10946 | 10946 | 1902-08-23 | 5 | a | A Tasmania man died in a Sydney hospital after receiving too much anaesthesia. | Australia | http://trove.nla.gov.au/newspaper/page/24100472 | 24100472 | |
7589 | 7589 | 1901-05-01 | 2 | e | A Turkish cargo ship sank into the Red Sea. | Australia | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
25620 | 25620 | 1912-01-20 | 7 | a-b | Australia news | A Victoria senator returning from China says that China is gradually westernised and Australia trade in China is to increase. Statistics of immigrants to Australia over last year. A coal mine accident in New South Wales killed six miners. Two Japanese warships visit Sydney. Statistics of coal output in Newcastle. Xia Tingxiang is returning to China from New Zealand. The case of 16 Chinese seamen riot ends up with the Chinese seamen laid off. | Australia | http://trove.nla.gov.au/newspaper/page/24092078 | 24092078 |
10997 | 10997 | 1902-09-06 | 5 | b | A Wollongong man was awarded for his bravery. | Australia | http://trove.nla.gov.au/newspaper/page/24100484 | 24100484 | |
5675 | 5675 | 1900-07-14 | 2 | e | A baby boy was burned to death in a Sydney fire. | Australia | http://trove.nla.gov.au/newspaper/page/24102874 | 24102874 | |
8601 | 8601 | 1901-09-21 | 2 | e | A baby girl in Sydney was injured in a traffic accident. | Australia | http://trove.nla.gov.au/newspaper/page/24100169 | 24100169 | |
40837 | 40837 | 1923-12-22 | 7 | b | A baby is found dead in St Mary Church, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24094659 | 24094659 | |
10627 | 10627 | 1902-05-17 | 2 | e | A baby was found dead in Sydney railway station; young woman of Sydney committed suicide. | Australia | http://trove.nla.gov.au/newspaper/page/24100428 | 24100428 | |
6792 | 6792 | 1901-01-05 | 2 | e | A baker in Melbourne faces trial for shooting his wife. | Australia | http://trove.nla.gov.au/newspaper/page/24099906 | 24099906 | |
9647 | 9647 | 1902-01-22 | 2 | e | A balloon and four travellers fell into the Mediterranean Sea. | Australia | http://trove.nla.gov.au/newspaper/page/24100307 | 24100307 | |
42163 | 42163 | 1924-10-04 | 7 | a | A bank employee commits suicide in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100884 | 24100884 | |
9929 | 9929 | 1902-03-01 | 2 | f | A bank employee in Britain was imprisoned for embezzlement. | Australia | http://trove.nla.gov.au/newspaper/page/24100342 | 24100342 | |
9212 | 9212 | 1901-11-30 | 2 | f | A bank employee in London gambled money he stole from the bank. | Australia | http://trove.nla.gov.au/newspaper/page/24100249 | 24100249 | |
11548 | 11548 | 1903-02-21 | 3 | b | A bank in Perth, Western Australia, was burgled and some money lost. | Australia | http://trove.nla.gov.au/newspaper/page/26800172 | 26800172 | |
10606 | 10606 | 1902-05-14 | 3 | d | A bank manager in Coonamble, New South Wales, committed suicide by shooting himself. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
42407 | 42407 | 1924-12-06 | 7 | b | A bank robber in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24100958 | 24100958 | |
42672 | 42672 | 1925-02-07 | 7 | a | A bank robbery in Caulfield, Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24101024 | 24101024 | |
42025 | 42025 | 1924-08-30 | 7 | a | A bank robbery in Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24100844 | 24100844 | |
41995 | 41995 | 1924-08-23 | 7 | a | A bank robbery in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100836 | 24100836 | |
42469 | 42469 | 1924-12-20 | 7 | b | A bank robbery in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100974 | 24100974 | |
40639 | 40639 | 1923-11-03 | 7 | b | A banker in Sydney is arrested for embezzlement. | Australia | http://trove.nla.gov.au/newspaper/page/24094603 | 24094603 | |
10300 | 10300 | 1902-04-12 | 2 | f | A big fire in Atlanta, America. | Australia | http://trove.nla.gov.au/newspaper/page/24100388 | 24100388 | |
19352 | 19352 | 1908-05-16 | 3 | c | A big fire in Atlanta, Georgia, and the casualties. | Australia | http://trove.nla.gov.au/newspaper/page/26801733 | 26801733 | |
4388 | 4388 | 1900-01-06 | 3 | c | A big fire in Newland, South Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24102662 | 24102662 | |
9902 | 9902 | 1902-02-26 | 3 | d | A big fire in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100337 | 24100337 | |
8149 | 8149 | 1901-07-13 | 3 | b | A big fire on George St, Sydney, burned many shops to ashes. | Australia | http://trove.nla.gov.au/newspaper/page/24100105 | 24100105 | |
17452 | 17452 | 1907-05-18 | 3 | c | A big passenger liner launched in Liverpool, Britain, is now on the way to New York with 3000 passengers. | Australia | http://trove.nla.gov.au/newspaper/page/26801331 | 26801331 | |
4410 | 4410 | 1900-01-10 | 2 | f | A big shark was stranded in the beach of West Point, Tasmania. | Australia | http://trove.nla.gov.au/newspaper/page/24102667 | 24102667 | |
11382 | 11382 | 1903-01-10 | 3 | b | A big snake was caught in the Presbyterian church, Norah Head, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/26800150 | 26800150 | |
9884 | 9884 | 1902-02-26 | 2 | e | A big strike in Barcelona, Spain. | Australia | http://trove.nla.gov.au/newspaper/page/24100338 | 24100338 | |
4885 | 4885 | 1900-04-04 | 2 | d | A big turtle was seen crawling along the streets of Honolulu. | Australia | http://trove.nla.gov.au/newspaper/page/24102755 | 24102755 | |
11704 | 11704 | 1903-04-04 | 3 | b | A black man in Queensland was brought to trial for murdering a White girl. | Australia | http://trove.nla.gov.au/newspaper/page/26800198 | 26800198 | |
7626 | 7626 | 1901-05-08 | 3 | c | A black man in Sydney was charged with abduction. | Australia | http://trove.nla.gov.au/newspaper/page/24100030 | 24100030 | |
6503 | 6503 | 1900-11-24 | 3 | a | A black man, who killed a white girl in Galong, NSW, was burned to death by the girl's father. | Australia | http://trove.nla.gov.au/newspaper/page/24103024 | 24103024 | |
9702 | 9702 | 1902-01-25 | 3 | e | A blacksmith's shop on Park Street, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100310 | 24100310 | |
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 | |
13943 | 13943 | 1904-10-22 | 3 | a | A book in Russia reveals that Russians want to enslave China. | Australia | http://trove.nla.gov.au/newspaper/page/26800549 | 26800549 | |
7358 | 7358 | 1901-03-30 | 3 | d | A boxing match in France. | Australia | http://trove.nla.gov.au/newspaper/page/24099987 | 24099987 | |
6951 | 6951 | 1901-01-26 | 3 | d | A boy in Brisbane was injured by a shark. | Australia | http://trove.nla.gov.au/newspaper/page/24099929 | 24099929 | |
7543 | 7543 | 1901-04-24 | 3 | b | A boy in Broken Hill drowned when he tried to get some water. | Australia | http://trove.nla.gov.au/newspaper/page/24100015 | 24100015 | |
6961 | 6961 | 1901-01-30 | 2 | c | A boy in Bundoora, Melbourne, was burned to death. | Australia | http://trove.nla.gov.au/newspaper/page/24099934 | 24099934 | |
5676 | 5676 | 1900-07-14 | 2 | e | A boy in Manly, Sydney, was charged with theft. | Australia | http://trove.nla.gov.au/newspaper/page/24102874 | 24102874 | |
6430 | 6430 | 1900-11-10 | 3 | a | A boy in Perth was lost and found later. | Australia | http://trove.nla.gov.au/newspaper/page/24103011 | 24103011 |
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]);