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 |
---|---|---|---|---|---|---|---|---|---|
38730 | 38730 | 1922-05-20 | 3 | a | Chen Jiongming recalls Ye Ju and his troops from Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/24093977 | 24093977 | |
38731 | 38731 | 1922-05-20 | 3 | a | British ambassador to Beijing suggests that aeroplane should not be used for military purpose. | China | http://trove.nla.gov.au/newspaper/page/24093977 | 24093977 | |
38746 | 38746 | 1922-05-20 | 6 | a | Poems written by Shouzhen and Keyu on returning to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093982 | 24093982 | |
38750 | 38750 | 1922-05-20 | 7 | a | Sydney city council issues new regulation on street cleaning. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093981 | 24093981 | |
38751 | 38751 | 1922-05-20 | 7 | a | New South Wales governments issued new regulation on wage payment. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093981 | 24093981 | |
38752 | 38752 | 1922-05-20 | 7 | a | Many returned servicemen from the World War I are now unemployed in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093981 | 24093981 | |
38753 | 38753 | 1922-05-20 | 7 | a | Family court in Sydney and its expenditure. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093981 | 24093981 | |
38754 | 38754 | 1922-05-20 | 7 | a | A Chinese market gardener in Sydney is injured by his horse. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093981 | 24093981 | |
38755 | 38755 | 1922-05-20 | 7 | a | A hotel owner in Sydney is shot and injured. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093981 | 24093981 |
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]);