This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 30537 | 30537 | 1915-10-02 | 7 | a | Notice of China's Business and Trade Association to Chinese people in Australia that interests of public loans can be obtained by buyers now from the Association. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095006 | 24095006 | |
| 30538 | 30538 | 1915-10-02 | 7 | a-b | Australia news/ Chinese people in Australia are to hold celebrating ceremonies for Confucius' birthday. A new warship made in Australia is to join the navy in Sydney. A British man in Sydney commits suicide due to his fear of joining the army. Ya Ji, a Chinese in Sydney, is fined for his opening an opium-taking shop. Jin Mao, a Chinese in Sydney, charges Liu Lian, another Chinese, for making rumours on his informing police about Chinese gambling. Australian Audit Official notifies that any one not filling in investigation forms properly is to be fined. The banks in New South Wales raise deposit interests. A number of people are found suffering small pox in Newcastle. | Australia | http://trove.nla.gov.au/newspaper/page/24095006 | 24095006 | |
| 30539 | 30539 | 1915-10-02 | 7 | b | Battle situation in east Europe between Russian and German troops. | Britain | http://trove.nla.gov.au/newspaper/page/24095006 | 24095006 | |
| 30540 | 30540 | 1915-10-02 | 7 | b | The Ally army in west Europe won a big triumph over German troops. | Britain | http://trove.nla.gov.au/newspaper/page/24095006 | 24095006 |
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]);