This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37518 | 37518 | 1921-08-27 | 7 | a | Two burglars are caught in Sydney for stealing from a shoe shop. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093666 | 24093666 | |
37519 | 37519 | 1921-08-27 | 7 | a | Operation and profit of the railway and tram lines. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093666 | 24093666 | |
37520 | 37520 | 1921-08-27 | 7 | a | A man in Sydney pretends to seek job and steal from an office. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093666 | 24093666 | |
37521 | 37521 | 1921-08-27 | 7 | a | Australian federal government sends doctors to New Guinea for smallpox disease. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093666 | 24093666 | |
37522 | 37522 | 1921-08-27 | 7 | a | Zhi gong tang in Sydney to publish Chinese World's News (gong bao) from this month. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093666 | 24093666 | |
37523 | 37523 | 1921-08-27 | 7 | b | Many Chinese labourers in Cuba become unemployed due to the suddenly decline of sugar price and close-down of sugar factories. An open letter written by Huang Tiesheng, on behalf of Chinese labourers in Cuba, asks for help from the Chinese communities, especially their Gaoyao fellows, in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093666 | 24093666 | |
37524 | 37524 | 1921-08-27 | 7 | b | American and British authorities on the peace in the Pacific region. | Canada | http://trove.nla.gov.au/newspaper/page/24093666 | 24093666 | |
37525 | 37525 | 1921-08-27 | 7 | c | An explosion on the street in Belfast and the casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24093666 | 24093666 | |
37526 | 37526 | 1921-08-27 | 7 | c | Advertisement for Tivoli Theatre in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093666 | 24093666 | |
37527 | 37527 | 1921-08-27 | 7 | c | Chinese Speech Society in Sydney (hua qiao yan shuo hui) to gather and the topic will be 'The Unification of China'. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093666 | 24093666 |
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]);