This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21766 | 21766 | 1909-10-09 | 3 | b | Population in Canada increases significantly in the past year. | Britain | http://trove.nla.gov.au/newspaper/page/26802351 | 26802351 | |
21767 | 21767 | 1909-10-09 | 3 | b | Advocate for boycott to British goods in Jiujiang, Jiangxi province, | Britain | http://trove.nla.gov.au/newspaper/page/26802351 | 26802351 | |
21768 | 21768 | 1909-10-09 | 3 | b | Crops are destroyed by the severe winter in Mexico. | Britain | http://trove.nla.gov.au/newspaper/page/26802351 | 26802351 | |
21769 | 21769 | 1909-10-09 | 3 | b | North Steamship Company in Germany makes profit in the past half year. | Britain | http://trove.nla.gov.au/newspaper/page/26802351 | 26802351 | |
21770 | 21770 | 1909-10-09 | 3 | b | Britain builds a new warship. | Britain | http://trove.nla.gov.au/newspaper/page/26802351 | 26802351 | |
21771 | 21771 | 1909-10-09 | 3 | b | Germany to build a naval port in Wilhelmshaven. | Britain | http://trove.nla.gov.au/newspaper/page/26802351 | 26802351 | |
21772 | 21772 | 1909-10-09 | 3 | b-c | A young anarchist is arrested in Portland for trying to assassinate American President William Taft. | Britain | http://trove.nla.gov.au/newspaper/page/26802351 | 26802351 | |
21788 | 21788 | 1909-10-09 | 7 | b | Zhang Zhidong dies in Beijing. | Britain | http://trove.nla.gov.au/newspaper/page/26802355 | 26802355 | |
21789 | 21789 | 1909-10-09 | 7 | b | China builds a railway without foreign intervention. | Britain | http://trove.nla.gov.au/newspaper/page/26802355 | 26802355 |
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]);