This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15880 | 15880 | 1906-07-07 | 3 | a | American government will permit political refugees to enter the nation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801022 | 26801022 | |
15881 | 15881 | 1906-07-07 | 3 | a | Germany's Asia Bank is to issue currency in China next year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801022 | 26801022 | |
15882 | 15882 | 1906-07-07 | 3 | b | A Russian commander is on his way to the Far East and may retaliate against the Japanese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801022 | 26801022 | |
15883 | 15883 | 1906-07-07 | 3 | a | Dozens of Egyptian villagers sentenced to death or prison for murdering British soldier. Comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801022 | 26801022 | |
15884 | 15884 | 1906-07-07 | 3 | a | Russian troops land and try to control Gotland Islands. Comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801022 | 26801022 | |
15885 | 15885 | 1906-07-07 | 3 | a | Earthquake in Wales; casualties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801022 | 26801022 | |
15886 | 15886 | 1906-07-07 | 3 | a | Chaos in German colony in Africa; casualties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801022 | 26801022 | |
15887 | 15887 | 1906-07-07 | 3 | a | Revolutionary movement engulfs Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801022 | 26801022 | |
15888 | 15888 | 1906-07-07 | 3 | a-b | New South Wales' commercial representative to the Far East talks about Australia's relations with Asia on his return. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801022 | 26801022 |
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]);