This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30304 | 30304 | 1915-07-24 | 3 | b-c | Battle situation in east Europe between Russian, Germany, and Austrian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094920 | 24094920 | |
30316 | 30316 | 1915-07-24 | 7 | b-c | Battle situation in east Europe between Austrian, German and Russian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094924 | 24094924 | |
30319 | 30319 | 1915-07-24 | 8 | b-c | Guangdong news/The Progress Party cables Guangdong and other provincial governments on establishing congress and provincial senates to deal with diplomatic issues. Long Jiguang is to inspect Dongjiang areas in Guangdong. Chinese Finance Ministry cables Guangdong on revising regulations of levying tax. Lian County in Guangdong is calling for relief funds from the government. Xu Binzhen writes a couplet praising Liang Qicao. Police uniform is to use local materials. Pitch wood in Hainan province can be used for making guns. | China | http://trove.nla.gov.au/newspaper/page/24094927 | 24094927 |
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]);