This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
874 | 874 | 1898-10-05 | 3 | a-b | International diplomacy, visit from the Congo, nations negotiate to reach agreement. | http://trove.nla.gov.au/newspaper/page/24102152 | 24102152 | ||
875 | 875 | 1898-10-05 | 3 | b-c-d | Second part of article on the strength of China, and need for reform. | http://trove.nla.gov.au/newspaper/page/24102152 | 24102152 | ||
876 | 876 | 1898-10-05 | 3 | d | Sydney residents write to Parliament requesting changes to public transport system. Others oppose move. | http://trove.nla.gov.au/newspaper/page/24102152 | 24102152 | ||
877 | 877 | 1898-10-05 | 3 | d | Government policy inadvertently encourages bandits in Guangxi. | http://trove.nla.gov.au/newspaper/page/24102152 | 24102152 | ||
878 | 878 | 1898-10-05 | 3 | d | More milk expected as higher-quality cow imported from England. | http://trove.nla.gov.au/newspaper/page/24102152 | 24102152 | ||
879 | 879 | 1898-10-05 | 3 | e | Telephone line planned connecting Sydney to Bathurst. | http://trove.nla.gov.au/newspaper/page/24102152 | 24102152 | ||
880 | 880 | 1898-10-05 | 3 | e | Angered man in Dongguan kills friends. | http://trove.nla.gov.au/newspaper/page/24102152 | 24102152 | ||
881 | 881 | 1898-10-05 | 3 | e-f | Mad woman in Zhaoqing hangs herself. | http://trove.nla.gov.au/newspaper/page/24102152 | 24102152 | ||
882 | 882 | 1898-10-05 | 3 | f | In Bangkok, difficult to distinguish between real and artificial ivory products. | http://trove.nla.gov.au/newspaper/page/24102152 | 24102152 |
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]);