This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29142 | 29142 | 1914-08-08 | 3 | b-c | The coming large-scale war (World War I) in Europe and different response of various countries (Austria, Russia, Italy, Germany, France, Britain,), market in panic and other social & political influence. | Other... | http://trove.nla.gov.au/newspaper/page/24093203 | 24093203 | |
29149 | 29149 | 1914-08-08 | 6 | b-c | There are more than 200 Chinese in Noumea, New Caledonia. Their life in Noumea, names and original villages & counties in Guangdong. All names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093208 | 24093208 | |
29151 | 29151 | 1914-08-08 | 7 | b-c | The war (World War I) breaks out in Europe (war between Germany and France, Britain declares war with Germany, Australian army in Queensland fire at fleeing German ship) and report on the battles. | Other... | http://trove.nla.gov.au/newspaper/page/24093207 | 24093207 | |
29155 | 29155 | 1914-08-08 | 8 | b-c | Guangdong news/ Provincial authority employs students returned from Japan. New general inspector (xun an shi) in Guangdong Li Guojun is arriving. Opium and gambling den in Guangzhou. Qionghua flower in full bloom in Jiangxi province which is an omen of war. President Yuan Shikai appropriates funds for disaster relief in Guangdong province. Fundraising in Guangzhou for the flood relief and involvement of government officials. Flood and tragedy in Songlong town, of Gaoyao county. | China | http://trove.nla.gov.au/newspaper/page/24093210 | 24093210 |
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]);