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 |
---|---|---|---|---|---|---|---|---|---|
75 | 75 | 1898-07-06 | 3 | d | British Prime Minister says that Britain should extract more profit from trade with China. | http://trove.nla.gov.au/newspaper/page/24102052 | 24102052 | ||
76 | 76 | 1898-07-06 | 3 | d | French church in Guangxi province destroyed by bandits, French protest. | http://trove.nla.gov.au/newspaper/page/24102052 | 24102052 | ||
100 | 100 | 1898-07-06 | 4 | d | Crime. Sydney, robbery | http://trove.nla.gov.au/newspaper/page/24102049 | 24102049 | ||
101 | 101 | 1898-07-06 | 4 | d | Earthquake in Albury last week. | http://trove.nla.gov.au/newspaper/page/24102049 | 24102049 | ||
102 | 102 | 1898-07-06 | 4 | d | Chinese man arrested for illegal gold fossicking in New South Wales. | http://trove.nla.gov.au/newspaper/page/24102049 | 24102049 | ||
103 | 103 | 1898-07-06 | 4 | d | Heavy fog in Melbourne last Friday. | http://trove.nla.gov.au/newspaper/page/24102049 | 24102049 | ||
104 | 104 | 1898-07-06 | 4 | d | War. American troops in Luzon, Philippines, used balloon for military purpose. | http://trove.nla.gov.au/newspaper/page/24102049 | 24102049 |
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]);