This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16538 | 16538 | 1906-12-08 | 3 | a | A Japanese warship sinks and detailed report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801154 | 26801154 | |
16539 | 16539 | 1906-12-08 | 3 | a | Japanese build a bridge across the Yalu River which will connect Korea and Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801154 | 26801154 | |
16540 | 16540 | 1906-12-08 | 3 | a | Hundreds of Russian soldiers are punished for plotting rebellion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801154 | 26801154 | |
16541 | 16541 | 1906-12-08 | 3 | a | Emperor of Germany encourages navy sailors with patriotism and religious belief. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801154 | 26801154 | |
16542 | 16542 | 1906-12-08 | 3 | a | Hungarian authority seeks to employ some Chinese farmers which has caused strong protest from local residents. And comments by Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801154 | 26801154 | |
16543 | 16543 | 1906-12-08 | 3 | b | Californian authority insists that Japanese and other Asian children should not be co-educated with American children. President Roosevelt to mediate. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801154 | 26801154 | |
16544 | 16544 | 1906-12-08 | 3 | b | Portuguese people are angry with the King for his huge amount of private debt. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801154 | 26801154 | |
16545 | 16545 | 1906-12-08 | 3 | b | Japanese government returns Niuzhuang to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801154 | 26801154 | |
16546 | 16546 | 1906-12-08 | 3 | b | Japanese people boycott American goods because Californian authority has barred Japanese children from being co-educated in American school. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801154 | 26801154 | |
16547 | 16547 | 1906-12-08 | 3 | b | Dutch colonist in Java issues new restriction upon Chinese immigrants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801154 | 26801154 |
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]);