This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
35709 | 35709 | 1920-05-22 | 2 | a-b | Editorial by Tung Wah Times on the current situations in the southwest of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098169 | 24098169 | |
35729 | 35729 | 1920-05-22 | 7 | a-b | Australia news/ Gibbs Bright steamship company has purchased new liner. Drought in New South Wales. Chinese opium addicts are detained in Sydney. Chinese woman from America talks about Christian and Confucianism in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098172 | 24098172 |
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]);