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 |
---|---|---|---|---|---|---|---|---|---|
20614 | 20614 | 1909-02-06 | 6 | b | Chinese labourers in South Africa clash with police for their celebration of Chinese New Year, and report on the casualties. | Britain | http://trove.nla.gov.au/newspaper/page/26802072 | 26802072 | |
20615 | 20615 | 1909-02-06 | 6 | b | Communication between Japan and America regarding Japanese immigrant. | Britain | http://trove.nla.gov.au/newspaper/page/26802072 | 26802072 | |
20616 | 20616 | 1909-02-06 | 6 | b | The son of Prince Qing has arrived in London with other Chinese students. | Britain | http://trove.nla.gov.au/newspaper/page/26802072 | 26802072 | |
20617 | 20617 | 1909-02-06 | 6 | b | Emperor Xuantong has smallpox. | Britain | http://trove.nla.gov.au/newspaper/page/26802072 | 26802072 | |
20627 | 20627 | 1909-02-06 | 7 | b | Seven illegal Chinese immigrants are detained in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802071 | 26802071 | |
20628 | 20628 | 1909-02-06 | 7 | b | Queensland state government imposes strict restrictions upon Chinese shops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802071 | 26802071 | |
20629 | 20629 | 1909-02-06 | 7 | b | Several Chinese in Sydney are punished for illegal opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802071 | 26802071 | |
20637 | 20637 | 1909-02-06 | 8 | b | Fiction/ Tiger died of opium, written by Cai Wangyao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802074 | 26802074 |
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]);