This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
83 | 83 | 1898-07-06 | 2 | a | Crime. Twin brothers in Zengcheng, Guangdong, were awarded for catching three robbers. | http://trove.nla.gov.au/newspaper/page/24102051 | 24102051 | ||
84 | 84 | 1898-07-06 | 2 | a-b | rich woman in Guangzhou, mad, hangs herself. Suicide. | http://trove.nla.gov.au/newspaper/page/24102051 | 24102051 | ||
85 | 85 | 1898-07-06 | 2 | b | Crime. Group of bandits robbed village in Xiangshan, Guangdong province. | http://trove.nla.gov.au/newspaper/page/24102051 | 24102051 | ||
86 | 86 | 1898-07-06 | 2 | b-c | Man in Guangzhou, Guangdong province, leads good and long life. | http://trove.nla.gov.au/newspaper/page/24102051 | 24102051 | ||
87 | 87 | 1898-07-06 | 2 | c-d | Politics. New South Wales is to elect new Members of Parliament, qualifications, procedures. | http://trove.nla.gov.au/newspaper/page/24102051 | 24102051 | ||
88 | 88 | 1898-07-06 | 2 | d-e | Wealth cures illness of old man in Guangzhou | http://trove.nla.gov.au/newspaper/page/24102051 | 24102051 | ||
89 | 89 | 1898-07-06 | 2 | e | Statistics of imports and exports in New South Wales from January to June, 1898. | http://trove.nla.gov.au/newspaper/page/24102051 | 24102051 | ||
90 | 90 | 1898-07-06 | 2 | e | War. Entry of Russian troops causes panic and chaos in Lushun, Philippines. | http://trove.nla.gov.au/newspaper/page/24102051 | 24102051 | ||
91 | 91 | 1898-07-06 | 2 | e-f | Rich woman marries smart man in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102051 | 24102051 | ||
92 | 92 | 1898-07-06 | 2 | f | A boy in Guangzhou found to be genius. | http://trove.nla.gov.au/newspaper/page/24102051 | 24102051 | ||
93 | 93 | 1898-07-06 | 2 | f | Fire in Guangzhou destroys 40 shops. | http://trove.nla.gov.au/newspaper/page/24102051 | 24102051 |
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]);