This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26921 | 26921 | 1913-01-25 | 7 | a | The Chinese Commercial Association of New South Wales' notice about its registration with Beijing government and welcoming other commercial organisations to join the Association. | Other... | http://trove.nla.gov.au/newspaper/page/24092556 | 24092556 | |
26922 | 26922 | 1913-01-25 | 7 | a | Chinese consul general to Australia's note about approval of the Chinese Commercial Association of New South Wales by Chinese government. | Other... | http://trove.nla.gov.au/newspaper/page/24092556 | 24092556 | |
26923 | 26923 | 1913-01-25 | 7 | a-b | Australian news/ Australian federation is to build its capital. Australia has another new warship. Australia awards more children. Three mental patients escape from hospital. Chinese woman fined for illegal possession of drugs. Australian ship arrives sound and safe in Hong Kong. Chinese laundry reports to police for finding drugs. Japanese warship arrives in South Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092556 | 24092556 |
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]);