This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30849 | 30849 | 1915-12-25 | 3 | a | Overseas Chinese in Boston, America, oppose imperial system in China. | America | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 | |
30850 | 30850 | 1915-12-25 | 3 | a-b | Xia Ziqi, a leader of Sun Yatsen's party is assassinated in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 | |
30851 | 30851 | 1915-12-25 | 3 | b | Yang Tingui, a leader of Sun Yatsen's party, is arrested in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 | |
30852 | 30852 | 1915-12-25 | 3 | b | The corruption case of five railways companies in China ends up with no serious penalties to any person. | China | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 | |
30853 | 30853 | 1915-12-25 | 3 | b | Bank of China and Transport Bank of China are competing for business, resulting in conflicts. | China | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 | |
30854 | 30854 | 1915-12-25 | 3 | b-c | Statistics of minerals' exports of China during 1913 to 1914. | China | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 | |
30855 | 30855 | 1915-12-25 | 3 | c | German army is to massively attack British troops in west Europe. | Britain | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 | |
30856 | 30856 | 1915-12-25 | 3 | c | Situation of Persia/ Russian troops occupy some area in Persia and German, Turkish troops enter Persia too. | Britain | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 | |
30857 | 30857 | 1915-12-25 | 3 | c | Battle situation in Turkish strait between British and German troops. | Britain | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 | |
30858 | 30858 | 1915-12-25 | 3 | c | Britain changes the general commander of its troops. | Britain | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 | |
30859 | 30859 | 1915-12-25 | 3 | c-d | Battle situation in Balkan Peninsula between the Ally troops and German-Austrian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 | |
30860 | 30860 | 1915-12-25 | 3 | d | Denmark government does not welcome the Peace Encouraging Team from America. | Britain | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 | |
30861 | 30861 | 1915-12-25 | 3 | d | Battle situation in west Europe between the Ally troops and German troops. | Britain | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 |
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]);