This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
763 | 763 | 1898-09-17 | 2 | a | Korean army adopts Western suits and cut soldiers' hair. | http://trove.nla.gov.au/newspaper/page/24102131 | 24102131 | ||
764 | 764 | 1898-09-17 | 2 | a-b | Egypt and Britain prepare for another war. | http://trove.nla.gov.au/newspaper/page/24102131 | 24102131 | ||
765 | 765 | 1898-09-17 | 2 | b | Story of a maid in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102131 | 24102131 | ||
766 | 766 | 1898-09-17 | 2 | b-c | Greed of French businessman working in Saigon disadvantages Vietnamese employees. | http://trove.nla.gov.au/newspaper/page/24102131 | 24102131 | ||
767 | 767 | 1898-09-17 | 2 | c | Religious conflicts erupt in Turkey between Christians and local people. | http://trove.nla.gov.au/newspaper/page/24102131 | 24102131 | ||
768 | 768 | 1898-09-17 | 2 | c-d | Some people attribute China's current decline to Confucius. | http://trove.nla.gov.au/newspaper/page/24102131 | 24102131 | ||
769 | 769 | 1898-09-17 | 2 | d | London, doctor rapes female patient. | http://trove.nla.gov.au/newspaper/page/24102131 | 24102131 | ||
770 | 770 | 1898-09-17 | 2 | d-e | High-minded dog in Wuhu, Anhui province, shows gratitude to master. | http://trove.nla.gov.au/newspaper/page/24102131 | 24102131 | ||
771 | 771 | 1898-09-17 | 2 | e-f | Girl in London killed by dog. | http://trove.nla.gov.au/newspaper/page/24102131 | 24102131 | ||
772 | 772 | 1898-09-17 | 2 | f | Restaurant owners fined for selling wine diluted with water; visitor from Sweden detained for begging. | http://trove.nla.gov.au/newspaper/page/24102131 | 24102131 |
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]);