This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
656 | 656 | 1898-08-31 | 3 | a | Removal of Wong Tonghe enables His Imperial Majesty to read world news. Beijing blamed for slow progress of railway construction. | http://trove.nla.gov.au/newspaper/page/24102116 | 24102116 | ||
657 | 657 | 1898-08-31 | 3 | a-b | Religious clashes in Shandong, Sichuan, Tianjin, Jiangxi, and other areas. | http://trove.nla.gov.au/newspaper/page/24102116 | 24102116 | ||
658 | 658 | 1898-08-31 | 3 | b-c | Chinese man who killed his friend and seriously injured a White woman was sentenced recently. | http://trove.nla.gov.au/newspaper/page/24102116 | 24102116 | ||
659 | 659 | 1898-08-31 | 3 | c | Famine in Russia. | http://trove.nla.gov.au/newspaper/page/24102116 | 24102116 | ||
660 | 660 | 1898-08-31 | 3 | c-d | Man in Guangzhou robbed of his trousers. | http://trove.nla.gov.au/newspaper/page/24102116 | 24102116 | ||
661 | 661 | 1898-08-31 | 3 | d | Britain, infectious disease kills hundreds. | http://trove.nla.gov.au/newspaper/page/24102116 | 24102116 | ||
662 | 662 | 1898-08-31 | 3 | d | Paintings sold in London recieve very high price. | http://trove.nla.gov.au/newspaper/page/24102116 | 24102116 | ||
663 | 663 | 1898-08-31 | 3 | d-e | Importance of self-examination from time to time. | http://trove.nla.gov.au/newspaper/page/24102116 | 24102116 | ||
664 | 664 | 1898-08-31 | 3 | e | Japan issues new marriage law preventing Japanese women from marrying foreign men. | http://trove.nla.gov.au/newspaper/page/24102116 | 24102116 | ||
665 | 665 | 1898-08-31 | 3 | e-f | Guangxi bandit chieftain, Li Keting, issues notice to reassure public after taking over Beiliu county. | http://trove.nla.gov.au/newspaper/page/24102116 | 24102116 |
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]);