This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25121 | 25121 | 1911-10-14 | 2 | a | Notice for celebration of Confucius's birthday | Celebration of Confucius's birthday is to be held in Sydney. | Other... | http://trove.nla.gov.au/newspaper/page/24091956 | 24091956 |
25131 | 25131 | 1911-10-14 | 3 | a | War between Italy and Turkey | Description of battles between Italian troops and Turkish soilders. | Other... | http://trove.nla.gov.au/newspaper/page/24091955 | 24091955 |
25132 | 25132 | 1911-10-14 | 3 | a-b | Attempts of Portugal imperial party | Portugal imperial party attempts to overthrow the republic government. | Other... | http://trove.nla.gov.au/newspaper/page/24091955 | 24091955 |
25136 | 25136 | 1911-10-14 | 3 | b | Transport of Korean Railways | Transporting capabilities of railways in Korea increase. | Other... | http://trove.nla.gov.au/newspaper/page/24091955 | 24091955 |
25150 | 25150 | 1911-10-14 | 7 | b | Announcement of Chinese warship visiting Mexico | Mexico government announces Chinese warship visit is not interfering Mexico internal affairs. | Other... | http://trove.nla.gov.au/newspaper/page/24091961 | 24091961 |
25152 | 25152 | 1911-10-14 | 7 | b-c | Britain and America attempt to control education in China | Britain and America plan to set up a university in Han Kou, Hunan province. | Other... | http://trove.nla.gov.au/newspaper/page/24091961 | 24091961 |
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]);