This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20647 | 20647 | 1909-02-13 | 6 | a-b | A letter, written by British businessman and published in a Hong Kong newspaper, comments on the effort of British authority to drive out Chinese dissidents there. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26802080 | 26802080 | |
20648 | 20648 | 1909-02-13 | 6 | b | Spanish government cooperates with bank in arms manufacture. | Britain | http://trove.nla.gov.au/newspaper/page/26802080 | 26802080 | |
20649 | 20649 | 1909-02-13 | 6 | b | Pension system in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/26802080 | 26802080 | |
20650 | 20650 | 1909-02-13 | 6 | b | Indian authority borrows foreign loans. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802080 | 26802080 | |
20651 | 20651 | 1909-02-13 | 6 | b | British authority to build more warships. | Britain | http://trove.nla.gov.au/newspaper/page/26802080 | 26802080 | |
20652 | 20652 | 1909-02-13 | 6 | b | Report in French newspaper on the recent changes in Beijing court is incorrect. | Britain | http://trove.nla.gov.au/newspaper/page/26802080 | 26802080 | |
20653 | 20653 | 1909-02-13 | 6 | c | A state parliament in the United States of America debates restrictions upon Japanese immigrants. | America | http://trove.nla.gov.au/newspaper/page/26802080 | 26802080 | |
20654 | 20654 | 1909-02-13 | 6 | c | A man in Britain is sentenced for swindling and bigamy. | Britain | http://trove.nla.gov.au/newspaper/page/26802080 | 26802080 | |
20655 | 20655 | 1909-02-13 | 6 | c | The market is dull in the capital of Belgium. | Other... | http://trove.nla.gov.au/newspaper/page/26802080 | 26802080 | |
20656 | 20656 | 1909-02-13 | 6 | c | An effective way to preserve fresh eggs. | Britain | http://trove.nla.gov.au/newspaper/page/26802080 | 26802080 |
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]);