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 |
---|---|---|---|---|---|---|---|---|---|
24644 | 24644 | 1911-07-01 | 2 | a | Editorial | An editorial comments on the staff of the new Cabinet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091827 | 24091827 |
24652 | 24652 | 1911-07-01 | 3 | a | Coronation ceremony of King of Britain | Report on the coronation ceremony of King George V of Britain. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091826 | 24091826 |
24653 | 24653 | 1911-07-01 | 3 | a | Proposal to set up a united South America country | Five South American countries are going to discuss the possibilities of setting up a united South American country | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091826 | 24091826 |
24654 | 24654 | 1911-07-01 | 3 | a | Tornado in Japan | Tornado and casualties in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24091826 | 24091826 |
24655 | 24655 | 1911-07-01 | 3 | a | Riots in Turkey | Thousands of soldiers died in riots in Turkey. | Other... | http://trove.nla.gov.au/newspaper/page/24091826 | 24091826 |
24666 | 24666 | 1911-07-01 | 7 | a | Australia news | Census of Australia and New Zealand. Statistics of foreign immigrants to Australia. Huang Zhichang, Chinese consul in Australia writes a congratulation letter to Australia governor. Memento of South Australia Register. New Australia governor is to replace the previous one. Scores of mid-term examination of Sydney Chinese Primary School. Lu Yiaqi, an overseas Chinese in Sydney was robbed and attracted. | http://trove.nla.gov.au/newspaper/page/24091830 | 24091830 | |
24667 | 24667 | 1911-07-01 | 8 | a | Draft of new cabinet system | Regulations and others concerning the new cabinet system. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091833 | 24091833 |
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]);