This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
46553 | 46553 | 1927-12-10 | 7 | b | Guangdong news/ Road construction in Xinhui county. House maids to be liberated. People and gentry in Xinhui county ask for military protection during the harvest time. | China | 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]);