This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46522 | 46522 | 1927-12-03 | 7 | a | A notice issued by the Chinese Chamber of Commerce in Sydney on illegal Chinese immigrants and their deportation from Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098619 | 24098619 | |
46523 | 46523 | 1927-12-03 | 7 | a | Australia news/ The unemployment under the new state government in New South Wales. Ticket prices going up for train and trams in Sydney. Jeweller dies with his treasurer while on board of ferry Greycliffe. A young artist commit suicide in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098619 | 24098619 | |
46524 | 46524 | 1927-12-03 | 7 | b | Guangdong news/ (Song Dynasty national hero) Yue Fei's calligraphy is found in Xinhui county. Train derails in Ningyang. Garrison troops leave Guangzhou to attack Xinhui and Huaxian county. Mediation over the clash between civil corps (min tuan) and peasants' associations (nong min xie hui) in Huaaxian county. | China | http://trove.nla.gov.au/newspaper/page/24098619 | 24098619 |
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]);