This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 30329 | 30329 | 1915-07-31 | 7 | a | Australia news/ Notice of China's Trade and Business Association in Sydney on donations for Australian Injured Soldiers' funds, names listed. Overseas Chinese in Sydney are competing to donate for Guangdong floods. Statistics show that banks in New South Wales are making good progress on deposits. Statistics of sugar products in Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24094932 | 24094932 | |
| 30330 | 30330 | 1915-07-31 | 7 | b | News miscellany/Lu Zhengqiang requires to resign from Chinese Foreign Ministry after Sino-Japan's treaty. Chinese Legislation Bureau designates severe penalty regulations on traitors. Japanese parties are attacking Japanese foreign and domestic ministers on foreign policies and election corruption. Japanese government orders its troops in Manchu and Shandong return to Japan. Japan wants to cooperate with China to hold an exhibition for its goods in China. Japanese parties are trying to throw down the present government by various ways. Police commander Li in Guangdong orders to arrest Chen Weice, governor of Kaiping county for his corruption. | China | http://trove.nla.gov.au/newspaper/page/24094932 | 24094932 | |
| 30331 | 30331 | 1915-07-31 | 7 | b | Statistics of British war expenses in the Europe War. | Britain | http://trove.nla.gov.au/newspaper/page/24094932 | 24094932 | |
| 30332 | 30332 | 1915-07-31 | 7 | b | An Italian warship is sunken by an enemy submarine in Mediterranean Sea. | Other... | http://trove.nla.gov.au/newspaper/page/24094932 | 24094932 | |
| 30333 | 30333 | 1915-07-31 | 7 | b | Statistics of people from all warring countries killed in the Europe War. | France | http://trove.nla.gov.au/newspaper/page/24094932 | 24094932 | |
| 30334 | 30334 | 1915-07-31 | 7 | b-c | Battle situation in west Europe between French, British and German troops. | France | http://trove.nla.gov.au/newspaper/page/24094932 | 24094932 | |
| 30335 | 30335 | 1915-07-31 | 7 | c | Battle situations in Ge Li Pu Ni (ppp) between the Ally troops and Turkish troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094932 | 24094932 |
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]);