This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46527 | 46527 | 1927-12-10 | 2 | b-c | Editorial by Tung Wah Times on the economic struggle of the Chinese people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098624 | 24098624 | |
46552 | 46552 | 1927-12-10 | 7 | a | Australia news/ New telephone to be used in Sydney. Potato price going up in Sydney. Burglary in the Sydney post office. Dwarf workers on strike in Sydney and the impacts. Dongqiao (Overseas Zengcheng natives) School to be opened in Kowloon, Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098627 | 24098627 |
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]);