This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16022 | 16022 | 1906-08-11 | 3 | a | Japan's new army commander. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801052 | 26801052 | |
16023 | 16023 | 1906-08-11 | 3 | a | Military rebellion in Finland and other areas controlled by Russian. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801052 | 26801052 | |
16024 | 16024 | 1906-08-11 | 3 | a | London residents flee for cool areas this summer. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801052 | 26801052 | |
16025 | 16025 | 1906-08-11 | 3 | a | Germany is building a submarine. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801052 | 26801052 | |
16026 | 16026 | 1906-08-11 | 3 | a | Fire at the international fair in Milan, Italy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801052 | 26801052 | |
16027 | 16027 | 1906-08-11 | 3 | a | Strike waves paralyse St Petersburg and turn it into a Paris of eighteenth century. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801052 | 26801052 | |
16028 | 16028 | 1906-08-11 | 3 | a | Chinese students in Tokyo gather and donate to flooding provinces (Guangdong, Hunan and Jiangxi) in China. Report on the gathering. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801052 | 26801052 |
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]);