This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36351 | 36351 | 1920-12-04 | 2 | a-c | American banker comments on the situations in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098403 | 24098403 | |
36362 | 36362 | 1920-12-04 | 6 | a-c | Two notices by the China-Australia Mail Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098407 | 24098407 | |
36364 | 36364 | 1920-12-04 | 7 | a-c | Australia news/ Chinese Consul-General Wei Zijing and the fundraising in Australia for the famine victims in north China. Two trams collide in Sydney. Chinese Kuang Shude in Melbourne is robbed. New South Wales parliament debates the increase of income tax and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098406 | 24098406 |
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]);