This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30045 | 30045 | 1915-05-15 | 2 | c-d | Statistics of foreign loans to be refunded in different provinces by the government. | China | http://trove.nla.gov.au/newspaper/page/24094841 | 24094841 | |
30054 | 30054 | 1915-05-15 | 3 | c-d | Battle situation in east Europe between Russian, Austrian and German troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094840 | 24094840 | |
30066 | 30066 | 1915-05-15 | 8 | c-d | Guangdong news/ Guangdong people propose to set up volunteer troops to protect China. Su Gaihua vows to sacrifice for China. Guangdong buys the second-period public loans. Bank of China suffers loss in last year. Governor of Taishang, Guangdong, asks for 2,000 new guns for preventing bandits looting. Navy in Guangdong is asked to be alert as Japan adds its force rapidly. Weapon factories are ordered to make more machine guns. Finance Ministry organises editing a book of Egypt's failure reminding China on foreign loans. | China | http://trove.nla.gov.au/newspaper/page/24094847 | 24094847 |
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]);