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 |
---|---|---|---|---|---|---|---|---|---|
24609 | 24609 | 1911-06-03 | 3 | a | South Polar adventure | Dr Maison bought a ship for South Polar adventure. | Other... | http://trove.nla.gov.au/newspaper/page/24091794 | 24091794 |
24610 | 24610 | 1911-06-03 | 3 | a | Mexican riots | 250 Chinese were killed in Mexican riots. | Other... | http://trove.nla.gov.au/newspaper/page/24091794 | 24091794 |
24611 | 24611 | 1911-06-03 | 3 | a | Village riots in India | Some Indian villagers fought with guns for religious disagreement. | Other... | http://trove.nla.gov.au/newspaper/page/24091794 | 24091794 |
24612 | 24612 | 1911-06-03 | 3 | a | Political and religious clash in Portugal | Religious leaders oppose the government decision to seperate religion from politics. | Other... | http://trove.nla.gov.au/newspaper/page/24091794 | 24091794 |
24613 | 24613 | 1911-06-03 | 3 | a | German aircraft crash | A German pilot was killed in the air crash. | Other... | http://trove.nla.gov.au/newspaper/page/24091794 | 24091794 |
24614 | 24614 | 1911-06-03 | 3 | a | Britain is to set up a pilot training school | The British Pilot Association meets to set up a pilot training school. | Britain | http://trove.nla.gov.au/newspaper/page/24091794 | 24091794 |
24615 | 24615 | 1911-06-03 | 3 | a | Women workers upset Portugal government | Textile women workers protest for pay rise. | Other... | http://trove.nla.gov.au/newspaper/page/24091794 | 24091794 |
24616 | 24616 | 1911-06-03 | 3 | a | Strikes in Canada | Various strikes occur in Canada for pay rise. | Canada | http://trove.nla.gov.au/newspaper/page/24091794 | 24091794 |
24624 | 24624 | 1911-06-03 | 6 | a | Information of governors' changes | Na Tong and Chen Linlong take offices of Zhili and Lianjiang respectively. | China | http://trove.nla.gov.au/newspaper/page/24091799 | 24091799 |
24625 | 24625 | 1911-06-03 | 6 | a | The conference of the Petition Bureau of Guangdong | Conference of the Petition Bureau discuss various issues on gambling, labourer exports, and corruption. | China | http://trove.nla.gov.au/newspaper/page/24091799 | 24091799 |
24629 | 24629 | 1911-06-03 | 7 | a | Notes of Sydney Empire Constitutional Association | Aims of the Association and regulations on memebership. | Australia | http://trove.nla.gov.au/newspaper/page/24091798 | 24091798 |
24630 | 24630 | 1911-06-03 | 7 | a | Australian news | Some Chinese were treated well in a foreign ship. The Jewish people tell sad stories of Jews ill-treated in Russia. Warships come to Australia for military exercise. Notes on shareholders to refund their shares from Guangdong railway. New governor of Australia is coming. Plan of immigrating Europeans for the sake of white Australia. Ceremony and holidays on British King's birthday. Smuggling opium was discovered. | Other... | http://trove.nla.gov.au/newspaper/page/24091798 | 24091798 |
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]);