This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
49566 | 49566 | 1930-10-04 | 8 | c | Epidemic disease in north China. | China | http://trove.nla.gov.au/newspaper/page/24099803 | 24099803 | |
49567 | 49567 | 1930-10-04 | 8 | c | Indian people boycott to foreign goods. Floods in India. Police in India injure civilians. | Other... | http://trove.nla.gov.au/newspaper/page/24099803 | 24099803 | |
49568 | 49568 | 1930-10-04 | 8 | c | Zhang Xueliang's attitude still unclear. | China | http://trove.nla.gov.au/newspaper/page/24099803 | 24099803 | |
49569 | 49569 | 1930-10-04 | 8 | c | Britain to return Weihaiwei to China. | China | http://trove.nla.gov.au/newspaper/page/24099803 | 24099803 | |
49570 | 49570 | 1930-10-04 | 8 | d | Australia news/ Murderer of the bank manger arrested in Melbourne. Proposal to reduce salary payment to government employees. New survey on the population of Australia. Motor factory on fire in Sydney. More robberies in Sydney. Dutch warships visit Australia. More report on the strike of the unemployed. Iron factory closed in Newcastle. Expenses for the election of the NSW state parliament. A man in NSW commits incest and the family tragedy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099803 | 24099803 |
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]);