This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42519 | 42519 | 1925-01-03 | 3 | a | The provisional government in Beijing and its departments. | China | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
42520 | 42520 | 1925-01-03 | 3 | a | Wu Peifu issues a circular telegram to protect the constitution. | China | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
42530 | 42530 | 1925-01-03 | 6 | a | Sun Yatsen is going north and the comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100991 | 24100991 | |
42533 | 42533 | 1925-01-03 | 7 | a | A school in Sydney is burned to ashes during the Christmas holiday. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
42534 | 42534 | 1925-01-03 | 7 | a | A homicide case in Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
42535 | 42535 | 1925-01-03 | 7 | a | A failed robbery in Brisbane, Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 | |
42536 | 42536 | 1925-01-03 | 7 | a | A Chinese man in Melbourne injures a white woman with knife and is detained by police. | Australia | http://trove.nla.gov.au/newspaper/page/24100990 | 24100990 |
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]);