This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29602 | 29602 | 1915-01-23 | 3 | a | Guangdong people in Beijing welcome Tang Xueheng who is administering Guangdong watering works. | China | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29603 | 29603 | 1915-01-23 | 3 | a | German prepares a great force for wars in next spring. | Other... | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29604 | 29604 | 1915-01-23 | 3 | a | Jie Hao Na (nnn) replies to French official and British official that the end of war is not to be foreseen. | Russia | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29605 | 29605 | 1915-01-23 | 3 | a-b | German troops defeat French troops, capturing many French soldiers. | Other... | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29606 | 29606 | 1915-01-23 | 3 | b | French Public Press reports that enemy troops attack French troops. | France | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29607 | 29607 | 1915-01-23 | 3 | b | Turkey refuse defeats by Russian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29608 | 29608 | 1915-01-23 | 3 | b | Wars cost a lot for all countries involved and Belgium suffers a great loss. | Other... | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29609 | 29609 | 1915-01-23 | 3 | b | Turkish troops enter Parse. | Britain | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29610 | 29610 | 1915-01-23 | 3 | b | Italian people expect to be neutral in the war. | Other... | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29611 | 29611 | 1915-01-23 | 3 | b | Statistics show that German troops suffer a great loss in the war. | Other... | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29612 | 29612 | 1915-01-23 | 3 | b | Submarines attack British seaports again. | Britain | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29613 | 29613 | 1915-01-23 | 3 | b | German troops report that they have won many battles. | Other... | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29614 | 29614 | 1915-01-23 | 3 | b-c | French troops are fighting severely with enemy troops in Ri Cen Shi (ppp). | France | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29615 | 29615 | 1915-01-23 | 3 | c | German troops are attacked in Ri Cen Shi(ppp) and German emperor inspects the troops. | Britain | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29616 | 29616 | 1915-01-23 | 3 | c | French troops suffer a small loss in Ri Cen Shi (ppp) war. | France | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29617 | 29617 | 1915-01-23 | 3 | c | British troops won a battle over German troops. | Britain | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29618 | 29618 | 1915-01-23 | 3 | c-d | Beijing news/ The arbitrary treat between China and America is signed. The case of killing a foreign preacher in Anhui costs a lot for the government. Government is planning to build a railway outside the Great Wall. Government is to train troops and collect military funds. A military official in a certain country tries to contact bandits party in China. A group of women party in Tianjin is found attempting to assassinate government officials. | China | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 | |
29619 | 29619 | 1915-01-23 | 3 | d | Guangdong news/Hong Kong government refuses to let copper enter imported from Japan. Da Sai Tou's construction in Guangdong is affected by bombs. Tang Xuehen is to return to Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24094695 | 24094695 |
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]);