This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29827 | 29827 | 1915-03-27 | 7 | a-b | Australia news/ Li Sheng, a Chinese in Sydney stabbed a police on street and was arrested. A number of smuggled opium is found in Sydney port. New regulations of public transport in Sydney. Statistics of new currency issued by the commonwealth government. | Australia | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29828 | 29828 | 1915-03-27 | 7 | b | Women police are enrolled in New Zealand for protecting youngsters. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29829 | 29829 | 1915-03-27 | 7 | b | People in Shanghai urge Chinese government to fight against Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29830 | 29830 | 1915-03-27 | 7 | b | Japanese troops have come to Shandong and Manchu. | China | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29831 | 29831 | 1915-03-27 | 7 | b-c | Germany begins to use money of its secret war funds now. | Britain | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29832 | 29832 | 1915-03-27 | 7 | c | Many lawyers in Britain join the army. | Britain | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29833 | 29833 | 1915-03-27 | 7 | c | Situation of Turkish troops in Suez Canal. | Other... | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29834 | 29834 | 1915-03-27 | 7 | c | Battle situation in Africa between British and German troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29835 | 29835 | 1915-03-27 | 7 | c | Some German airships attack Paris at night. | France | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29836 | 29836 | 1915-03-27 | 7 | c | Russian troops has occupied Pi Chang Mei Lu (ppp) city of Austria. | Russia | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29837 | 29837 | 1915-03-27 | 7 | c | German troops are farming now for raising food. | Other... | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 |
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]);