This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29597 | 29597 | 1915-01-23 | 2 | a-b | Comment: Policies of protecting people and educating people should be practised. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094696 | 24094696 | |
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 | |
29620 | 29620 | 1915-01-23 | 6 | a-b | Yian Fu's proposal on people's morality and education are foundation of a country. | China | http://trove.nla.gov.au/newspaper/page/24094700 | 24094700 | |
29622 | 29622 | 1915-01-23 | 7 | a-b | Chinese General Counsel notifies that no mail should be brought in according to the military law due to the European War. Australian troop fighting in a German-owned island return to Sydney. German officials captured by Australian troop are allowed to return home through Sydney. Australian coal is sold to Mexico. Sydney shops find some false gold coins. Shi Kuan (ppp) in New South Wales is stricken by a big hail. | Australia | http://trove.nla.gov.au/newspaper/page/24094699 | 24094699 | |
29628 | 29628 | 1915-01-23 | 8 | a-b | Travel records/ tradition and customs in Brazil. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094702 | 24094702 |
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]);