This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17601 | 17601 | 1907-06-15 | 2 | a | Sydney Chinese Empire Reform Association and Tung Wah Times call for donations to flooding victims in China. Donations can be sent to On Chong & Co on 223 George Street, Wing Sang & Co on 22 Campbell Street, Tiy Loy & Co on Botany Road, or Sun Suey Wah & Co on 75-77 Campbell Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801360 | 26801360 | |
17622 | 17622 | 1907-06-15 | 7 | a | Dr Gordon from Stanford University talks Japan problems in the University of Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801367 | 26801367 | |
17623 | 17623 | 1907-06-15 | 7 | a | A jeweller in Melbourne is murdered in his office on Collins Street. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801367 | 26801367 | |
17624 | 17624 | 1907-06-15 | 7 | a | Chinese and Western communities in Brisbane donate to flooding victims in north Jiangsu province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801367 | 26801367 | |
17625 | 17625 | 1907-06-15 | 7 | a | Leader of British Labour Party comes to visit Australia. | Britain | http://trove.nla.gov.au/newspaper/page/26801367 | 26801367 | |
17626 | 17626 | 1907-06-15 | 7 | a | A Chinese carpenter shop in Oxford Street, Sydney, is on fire and several neighbouring shops also burned to ashes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801367 | 26801367 | |
17627 | 17627 | 1907-06-15 | 7 | a | 676 Australian citizens are back to Melbourne from South Africa. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801367 | 26801367 | |
17628 | 17628 | 1907-06-15 | 7 | a | Sydney customs officer finds opium smuggled in cargo liner Manila. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801367 | 26801367 | |
17629 | 17629 | 1907-06-15 | 7 | a | A newspaper in Adelaide, Trust, is penalised for publishing pornographic article. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801367 | 26801367 |
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]);