This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
2869 | 2869 | 1899-06-28 | 2 | a | Imperial edicts on prayer ceremony and other issues. | http://trove.nla.gov.au/newspaper/page/24102448 | 24102448 | ||
2888 | 2888 | 1899-06-28 | 3 | a | Indian people chose to cremate their dead. | http://trove.nla.gov.au/newspaper/page/24102447 | 24102447 | ||
2889 | 2889 | 1899-06-28 | 3 | a | Italy threatens Turkey with military action if Turkey refuses to return two ships. | http://trove.nla.gov.au/newspaper/page/24102447 | 24102447 | ||
2890 | 2890 | 1899-06-28 | 3 | a | Recent developments in the war in Luzon. | http://trove.nla.gov.au/newspaper/page/24102447 | 24102447 | ||
2891 | 2891 | 1899-06-28 | 3 | a | A brave and skillful swindler in Melbourne. | http://trove.nla.gov.au/newspaper/page/24102447 | 24102447 | ||
2892 | 2892 | 1899-06-28 | 3 | a | Two Indians were thought to be ghosts in Sydney. | http://trove.nla.gov.au/newspaper/page/24102447 | 24102447 | ||
2893 | 2893 | 1899-06-28 | 3 | a | A girl in Castlemain, Victoria, died in a fire. | http://trove.nla.gov.au/newspaper/page/24102447 | 24102447 | ||
2915 | 2915 | 1899-06-28 | 4 | a | An old man in Melbourne was arrested for harassment. | http://trove.nla.gov.au/newspaper/page/24102450 | 24102450 |
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]);