This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
2916 | 2916 | 1899-07-01 | 2 | a-c | The third part of a report submitted by Yu Liansan, Governor of Hunan province. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
2917 | 2917 | 1899-07-01 | 2 | c-e | The number of married men and women in America. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
2918 | 2918 | 1899-07-01 | 2 | e | A Sydney judge commits suicide. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
2919 | 2919 | 1899-07-01 | 2 | e | Quantity and value of coal exported from colonies of Australia. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
2920 | 2920 | 1899-07-01 | 2 | e | Situation in Luzon. Britain sends troops to the Philippines to recover two British men detained by the local forces. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
2921 | 2921 | 1899-07-01 | 2 | f | A man in New South Wales found three diamonds. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
2922 | 2922 | 1899-07-01 | 2 | f | A lawyer in New Zealand has been promoted. The lawyer is known for his kindness to Chinese. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
2923 | 2923 | 1899-07-01 | 2 | f | An old man in New South Wales commits suicide after the federation referendum. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
2924 | 2924 | 1899-07-01 | 2 | f | Total lunar eclipse in Australia. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
2925 | 2925 | 1899-07-01 | 2 | f | Transvaal trains its troops in readiness for a war should one occur. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 | ||
2926 | 2926 | 1899-07-01 | 2 | f | Bandits are still active in Yong'an, Haifeng, Lufeng, Huilai and Jieyang. | http://trove.nla.gov.au/newspaper/page/24102452 | 24102452 |
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]);