This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26876 | 26876 | 1913-01-18 | 2 | a-c | Liang Qichao's policies for dealing with various political parties. | Other... | http://trove.nla.gov.au/newspaper/page/24092545 | 24092545 | |
26894 | 26894 | 1913-01-18 | 7 | a-c | Australian news/ Celebration of Republic China in Australia. Sydney holds celebration of establishment of Republic China. Establishment of the Chinese Commercial Association of New South Wales. Chinese consul in Australia sad to lose mother. Suspects arrested for killing two old Chinese. Chinese runs away from a ship. New South Wales Bank robbed. Lion found in Brisbane's residential area. Australian relation with China over drug ban issue. Chinese heavily fined for using false certificate for applying for Australian citizenship. Reward for wanted criminal in Melbourne. Australia-born Chinese not granted permanent residency. Melbourne gamblers caught by police on spot and fined. | Other... | http://trove.nla.gov.au/newspaper/page/24092548 | 24092548 |
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]);