This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47897 | 47897 | 1929-03-16 | 5 | a | Hong Kong news/ Returned Chinese is detained for carrying bullets. Trade between Hong Kong and the inland. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099147 | 24099147 | |
47898 | 47898 | 1929-03-16 | 5 | b | New weapons invented in Europe. | Other... | http://trove.nla.gov.au/newspaper/page/24099147 | 24099147 | |
47899 | 47899 | 1929-03-16 | 5 | c-f | Notice issued by the Overseas Chinese Commission of the Nationalist government in Nanjing collecting sample producers among the overseas Chinese communities. And specified explanation of the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099147 | 24099147 |
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]);