This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38897 | 38897 | 1922-06-17 | 7 | a | A hairdresser in King Street, Sydney, is brought to court for over charge. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094013 | 24094013 | |
38898 | 38898 | 1922-06-17 | 7 | a-b | A robbery in Geelong, Victoria, and the young bandit is arrested later. | Australia | http://trove.nla.gov.au/newspaper/page/24094013 | 24094013 | |
38899 | 38899 | 1922-06-17 | 7 | b | A Chinese passenger in Sydney is detained for carrying too much money. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094013 | 24094013 | |
38900 | 38900 | 1922-06-17 | 7 | b | Burglary of a warehouse in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094013 | 24094013 | |
38901 | 38901 | 1922-06-17 | 7 | b | Cotton production in Rockhampton, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094013 | 24094013 | |
38902 | 38902 | 1922-06-17 | 7 | b | Earthquake in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094013 | 24094013 | |
38903 | 38903 | 1922-06-17 | 7 | b | Li Yuanhong becomes the President of China. | China | http://trove.nla.gov.au/newspaper/page/24094013 | 24094013 | |
38904 | 38904 | 1922-06-17 | 7 | b | Hurricane in New York and the flood. | America | http://trove.nla.gov.au/newspaper/page/24094013 | 24094013 | |
38905 | 38905 | 1922-06-17 | 7 | c | Wu Tingfang might become Chinese President. | America | http://trove.nla.gov.au/newspaper/page/24094013 | 24094013 | |
38906 | 38906 | 1922-06-17 | 7 | b | Guangdong situation after the return of Guangdong army from Guangxi. | China | http://trove.nla.gov.au/newspaper/page/24094013 | 24094013 | |
38907 | 38907 | 1922-06-17 | 7 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094013 | 24094013 | |
38908 | 38908 | 1922-06-17 | 7 | c | A notice issued by Lian Fu Tang, an association of Zengcheng fellows in Sydney, on transfer of remains of the deceased fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094013 | 24094013 |
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]);