This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19114 | 19114 | 1908-03-28 | 7 | b | Chinese are penalised in Brisbane for opium smuggling. Australia to punish opium smuggler without leniency. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801681 | 26801681 | |
19115 | 19115 | 1908-03-28 | 7 | b | A report from Thursday Island (Japanese immigrants and Australian administration there). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801681 | 26801681 | |
19116 | 19116 | 1908-03-28 | 7 | b | Signatures solicited among overseas Chinese communities for a petition to the Chinese government. A copy of the petition. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801681 | 26801681 | |
19117 | 19117 | 1908-03-28 | 7 | b | Advertisement for Fred W. Landou, merchant tailor and outfitter at 331 George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801681 | 26801681 | |
19118 | 19118 | 1908-03-28 | 7 | b | Advertisement for Palace Theatre in Sydney | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801681 | 26801681 | |
19119 | 19119 | 1908-03-28 | 7 | b | Tung Wah column. On the boycott to Japanese goods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801681 | 26801681 |
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]);