This data as json, CSV (advanced)
Suggested facets: date, column, title, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20779 | 20779 | 1909-03-13 | 6 | c | An Italian duke suggests moving 5,000 earthquake victims from Italy to his farm in Florida, United States. | France | http://trove.nla.gov.au/newspaper/page/26802112 | 26802112 | |
21027 | 21027 | 1909-05-15 | 6 | c | Wright fails again his flying test in France. | France | http://trove.nla.gov.au/newspaper/page/26802186 | 26802186 | |
21081 | 21081 | 1909-05-29 | 6 | b | A newspaper in Paris reports on the death of Emperor Guangxu and Yuan Shikai's plot. | France | http://trove.nla.gov.au/newspaper/page/26802202 | 26802202 | |
21376 | 21376 | 1909-07-24 | 6 | b | French archeologist finds human bones buried 200,000 years ago. | France | http://trove.nla.gov.au/newspaper/page/26802268 | 26802268 | |
22431 | 22431 | 1910-02-26 | 6 | b-c | Esperanto in Paris. | France | http://trove.nla.gov.au/newspaper/page/26802540 | 26802540 | |
25982 | 25982 | 1912-04-06 | 6 | b-c | French women learn boxing | Upper class women in Paris are interested in learning boxing skills as it is fashionable. | France | http://trove.nla.gov.au/newspaper/page/24092196 | 24092196 |
27113 | 27113 | 1913-03-08 | 6 | c | French ambassador to Russia is to meet German king for recovering relations on way to Russia. | France | http://trove.nla.gov.au/newspaper/page/24092605 | 24092605 | |
34399 | 34399 | 1919-04-19 | 6 | b-c | Liang Qichao's suggestions to the Paris Peace Conference. | France | http://trove.nla.gov.au/newspaper/page/24097690 | 24097690 | |
34519 | 34519 | 1919-05-24 | 6 | a-b | Miscellaneous report (protest in Germany against the Treaty of Versailles and their signature, Austrian envoy arrives Paris, anti-American movement in Japan, Japanese newspaper discriminates against Britain). | France | http://trove.nla.gov.au/newspaper/page/24097730 | 24097730 | |
35045 | 35045 | 1919-11-08 | 6 | a | French government officials oppose that French women to marry Chinese labourers. | France | http://trove.nla.gov.au/newspaper/page/24097930 | 24097930 | |
35216 | 35216 | 1920-01-03 | 6 | b | Japanese want to take over Samoa and New Guinea in the south Pacific from German. | France | http://trove.nla.gov.au/newspaper/page/24097996 | 24097996 | |
35229 | 35229 | 1920-01-10 | 6 | a | Revolutionary movement in Korea. | France | http://trove.nla.gov.au/newspaper/page/24098004 | 24098004 | |
35250 | 35250 | 1920-01-17 | 6 | b | Germany has agreed to sign the treaty. | France | http://trove.nla.gov.au/newspaper/page/24098012 | 24098012 | |
35270 | 35270 | 1920-01-24 | 6 | b | Merchant ship Africa sinks near France. | France | http://trove.nla.gov.au/newspaper/page/24098020 | 24098020 | |
37260 | 37260 | 1921-07-02 | 6 | b | Negotiation between China and Germany on a peace treaty. | France | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
37909 | 37909 | 1921-11-26 | 6 | b | A Turkish man marries again at the age of 146. | France | http://trove.nla.gov.au/newspaper/page/24093771 | 24093771 | |
43772 | 43772 | 1925-09-05 | 6 | c | Police in Paris keep working day and night to stop communist propaganda. | France | http://trove.nla.gov.au/newspaper/page/24101270 | 24101270 | |
43932 | 43932 | 1925-10-03 | 6 | a | French authority arrests communist members. | France | http://trove.nla.gov.au/newspaper/page/24101302 | 24101302 | |
53108 | 53108 | 1933-07-22 | 6 | c | French naval forces. | France | http://trove.nla.gov.au/newspaper/page/24091306 | 24091306 | |
53356 | 53356 | 1933-09-30 | 6 | f | Fang Zhenwu seeks to enter Beijing. | France | http://trove.nla.gov.au/newspaper/page/24091386 | 24091386 | |
53864 | 53864 | 1934-02-17 | 6 | a | Demonstration in Paris and the tragedy. | France | |||
54141 | 54141 | 1934-05-12 | 6 | a | Chinese consul-general in Paris talks about Japanese invasion. | France | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
54499 | 54499 | 1934-09-08 | 6 | c | Airforce troops on exercise in France. | France | http://trove.nla.gov.au/newspaper/page/24096154 | 24096154 | |
54660 | 54660 | 1934-11-10 | 6 | c | The power of Germany. | France | http://trove.nla.gov.au/newspaper/page/24096228 | 24096228 | |
54661 | 54661 | 1934-11-10 | 6 | d | French people advocate cooperation with Russian. | France | http://trove.nla.gov.au/newspaper/page/24096228 | 24096228 |
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]);