This data as json, CSV (advanced)
Suggested facets: date, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21683 | 21683 | 1909-09-18 | 8 | c | Translation/ French magazine on what men and women want from each other. | France | http://trove.nla.gov.au/newspaper/page/26802334 | 26802334 | |
22014 | 22014 | 1909-11-20 | 8 | c | French government submits its budget report and debate in the Parliament. | France | http://trove.nla.gov.au/newspaper/page/26802406 | 26802406 | |
48488 | 48488 | 1929-09-21 | 8 | d | Two French missionaries are murdered in Hubei province, China. | France | http://trove.nla.gov.au/newspaper/page/24099371 | 24099371 | |
49108 | 49108 | 1930-04-26 | 8 | d | A plane crashes on its way from Paris to Sydney. | France | http://trove.nla.gov.au/newspaper/page/24099617 | 24099617 | |
49190 | 49190 | 1930-05-24 | 8 | d | France proposes that the European continent to form one federal country. | France | http://trove.nla.gov.au/newspaper/page/24099649 | 24099649 | |
49955 | 49955 | 1931-01-31 | 8 | b | More unemployed workers in France. | France | http://trove.nla.gov.au/newspaper/page/24090262 | 24090262 | |
50001 | 50001 | 1931-02-14 | 8 | b | Bank collapses in Paris. | France | http://trove.nla.gov.au/newspaper/page/24090278 | 24090278 | |
50146 | 50146 | 1931-03-28 | 8 | b | French navy to build new warship. | France | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
50334 | 50334 | 1931-05-23 | 8 | c | Textile workers on strike in France. | France | http://trove.nla.gov.au/newspaper/page/24090395 | 24090395 | |
50430 | 50430 | 1931-06-20 | 8 | b | Police in France stop the Communist demonstration. | France | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
51528 | 51528 | 1932-05-14 | 8 | d | Russian man attempts to assassinate French President. | France | http://trove.nla.gov.au/newspaper/page/24090805 | 24090805 | |
51547 | 51547 | 1932-05-21 | 8 | b | New president elected in France. | France | http://trove.nla.gov.au/newspaper/page/24090813 | 24090813 | |
51779 | 51779 | 1932-08-06 | 8 | a | A Russian man is to be executed for assassination of French President. | France | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
55079 | 55079 | 1935-05-04 | 8 | c | French people pray for the world peace. | France | http://trove.nla.gov.au/newspaper/page/24096423 | 24096423 | |
55109 | 55109 | 1935-05-11 | 8 | a | New military weapons invented in Germany. | France | http://trove.nla.gov.au/newspaper/page/24096431 | 24096431 | |
55190 | 55190 | 1935-06-08 | 8 | a | Typhoon swaps France and the floods. | France | http://trove.nla.gov.au/newspaper/page/24096463 | 24096463 | |
55455 | 55455 | 1935-09-21 | 8 | a | Beautiful Swiss woman is actually a spy. | France | http://trove.nla.gov.au/newspaper/page/24096585 | 24096585 | |
55457 | 55457 | 1935-09-21 | 8 | c | France supports the League of Nations. | France | http://trove.nla.gov.au/newspaper/page/24096585 | 24096585 | |
55474 | 55474 | 1935-09-28 | 8 | d | Farmers in France to have a revolution. | France | http://trove.nla.gov.au/newspaper/page/24096592 | 24096592 |
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]);