This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
14866 | 14866 | 1905-10-07 | 5 | a | An article written by anonymous author says that protest against American immigration policy should be combined with business prosperity to save the nation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 | |
14867 | 14867 | 1905-10-07 | 5 | a-b | Total number of Jews and their distribution around the world. No divorce in Mexico. Thailand has no national debt. How rich is the Pope in Vatican. Statistics of newspaper, bank and railway in Japan. Territory of Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 | |
14868 | 14868 | 1905-10-07 | 5 | b | An ammunition storehouse in Hiroshima, Japan, explodes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 | |
14869 | 14869 | 1905-10-07 | 5 | b | A mother in Illinois, United States, murdered her seven children and then committed suicide. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 | |
14870 | 14870 | 1905-10-07 | 5 | b | Report on German business in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 | |
14871 | 14871 | 1905-10-07 | 5 | b | Report on suffering of Chinese labourers in South Africa. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 | |
14872 | 14872 | 1905-10-07 | 5 | b | More Chinese people in Sydney have joined the Chinese Empire Reform Association. Their names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800794 | 26800794 |
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]);