This data as json, CSV (advanced)
Link | rowid | date | page | column ▲ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31140 | 31140 | 1916-04-15 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095227 | 24095227 | |
31261 | 31261 | 1916-05-27 | 3 | f | News on the World War I (the war between Austria and Italy). | Other... | http://trove.nla.gov.au/newspaper/page/24095275 | 24095275 | |
31762 | 31762 | 1916-11-25 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095489 | 24095489 | |
32113 | 32113 | 1917-02-24 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095608 | 24095608 | |
32349 | 32349 | 1917-06-02 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095712 | 24095712 | |
32445 | 32445 | 1917-07-07 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095752 | 24095752 | |
32466 | 32466 | 1917-07-14 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095760 | 24095760 | |
32860 | 32860 | 1918-01-12 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097130 | 24097130 | |
32914 | 32914 | 1918-02-02 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097154 | 24097154 | |
33147 | 33147 | 1918-03-30 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097231 | 24097231 | |
33295 | 33295 | 1918-05-18 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097289 | 24097289 | |
33338 | 33338 | 1918-06-01 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097305 | 24097305 | |
33393 | 33393 | 1918-06-29 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097337 | 24097337 | |
33415 | 33415 | 1918-07-06 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097345 | 24097345 | |
33487 | 33487 | 1918-08-03 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097377 | 24097377 | |
33531 | 33531 | 1918-08-17 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097395 | 24097395 | |
33555 | 33555 | 1918-08-24 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097403 | 24097403 | |
33575 | 33575 | 1918-08-31 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097411 | 24097411 | |
33718 | 33718 | 1918-10-12 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097461 | 24097461 | |
33782 | 33782 | 1918-11-02 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097485 | 24097485 | |
33897 | 33897 | 1918-12-14 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097533 | 24097533 | |
33917 | 33917 | 1918-12-21 | 3 | f | News on the World War I (American President arrives Paris, and others). | Other... | http://trove.nla.gov.au/newspaper/page/24097541 | 24097541 | |
33941 | 33941 | 1918-12-28 | 3 | f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097549 | 24097549 | |
34035 | 34035 | 1919-01-25 | 3 | f | Miscellaneous report on Europe after the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097582 | 24097582 | |
34195 | 34195 | 1919-02-22 | 3 | f | Germany has new chancellor. | Other... | http://trove.nla.gov.au/newspaper/page/24097619 | 24097619 | |
34451 | 34451 | 1919-05-03 | 3 | f | Italy at the Paris Peace Conference. | Other... | http://trove.nla.gov.au/newspaper/page/24097701 | 24097701 | |
34538 | 34538 | 1919-05-31 | 3 | f | Japanese in Korea bury the people alive. Japanese force Korean people to give up their independence appeal. | Other... | http://trove.nla.gov.au/newspaper/page/24097733 | 24097733 | |
34548 | 34548 | 1919-06-07 | 2 | f | Declaration issued by Korean Delegation for Independence. | Other... | http://trove.nla.gov.au/newspaper/page/24097742 | 24097742 | |
34590 | 34590 | 1919-06-14 | 3 | f | A woman pilot in America. French ship on fire in Suez Canal. German delegation to the Paris Peace Conference refuse to sign the treaty. Oil production in Britain. Mission Society in Beijing protests against the resolutions on Shandong. Chinese people in Wuhu start boycott to Japanese goods. | Other... | http://trove.nla.gov.au/newspaper/page/24097751 | 24097751 | |
34677 | 34677 | 1919-07-12 | 3 | f | Hungary and Germany after the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097783 | 24097783 | |
38854 | 38854 | 1922-06-10 | 3 | f | Wu Peifu and Zhang Zuolin resume fighting. | Other... | http://trove.nla.gov.au/newspaper/page/24094001 | 24094001 | |
38893 | 38893 | 1922-06-17 | 3 | f | An expedition to the North Pole. | Other... | http://trove.nla.gov.au/newspaper/page/24094009 | 24094009 | |
39026 | 39026 | 1922-11-18 | 3 | f | A theatre in Switzerland is burned to ashes. | Other... | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 | |
39867 | 39867 | 1923-05-19 | 3 | f | Italian authority detains Irish radicals. | Other... | http://trove.nla.gov.au/newspaper/page/24094407 | 24094407 | |
39952 | 39952 | 1923-06-09 | 3 | f | Earthquake in India. | Other... | http://trove.nla.gov.au/newspaper/page/24094431 | 24094431 | |
41436 | 41436 | 1924-04-19 | 3 | f | Epidemic in India. | Other... | http://trove.nla.gov.au/newspaper/page/24100687 | 24100687 | |
41836 | 41836 | 1924-07-19 | 3 | f | Revolutionary movement in Brazil. | Other... | http://trove.nla.gov.au/newspaper/page/24100792 | 24100792 | |
41892 | 41892 | 1924-08-02 | 3 | f | A Norwegian ship is found smuggling weapons to Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24100808 | 24100808 | |
41988 | 41988 | 1924-08-23 | 3 | f | Bandits in Mexico hijack a train. | Other... | http://trove.nla.gov.au/newspaper/page/24100832 | 24100832 | |
42178 | 42178 | 1924-10-11 | 3 | f | A circular telegram issued by Chen Lianbo. | Other... | http://trove.nla.gov.au/newspaper/page/24100888 | 24100888 | |
42261 | 42261 | 1924-11-01 | 3 | f | Mexican government recalls its ambassadors to British colonies. | Other... | http://trove.nla.gov.au/newspaper/page/24100912 | 24100912 | |
42742 | 42742 | 1925-02-21 | 3 | f | Report from the international conference on opium ban in Switzerland. | Other... | http://trove.nla.gov.au/newspaper/page/24101033 | 24101033 | |
42952 | 42952 | 1925-04-04 | 3 | f | Typhoon in Argentina and the damages. | Other... | http://trove.nla.gov.au/newspaper/page/24101085 | 24101085 | |
45561 | 45561 | 1927-03-19 | 3 | f | Railway construction in Burma. | Other... | http://trove.nla.gov.au/newspaper/page/24101915 | 24101915 | |
46954 | 46954 | 1928-04-21 | 2 | f | The Socialist Party in Europe. | Other... | http://trove.nla.gov.au/newspaper/page/24098768 | 24098768 | |
47161 | 47161 | 1928-06-23 | 2 | f | Independence movement in Korea and their open letter. | Other... | http://trove.nla.gov.au/newspaper/page/24098850 | 24098850 | |
47706 | 47706 | 1928-12-29 | 3 | f | Jewish people start to build their own country. | Other... | http://trove.nla.gov.au/newspaper/page/24099065 | 24099065 | |
47743 | 47743 | 1929-01-12 | 5 | f | Women after the liberation in Soviet Russia. Sexual discrimination in the judicial circle in America. | Other... | http://trove.nla.gov.au/newspaper/page/24099083 | 24099083 | |
49790 | 49790 | 1930-12-13 | 2 | f | South African government arrests employee of the Chinese consulate. | Other... | http://trove.nla.gov.au/newspaper/page/24099878 | 24099878 | |
52590 | 52590 | 1933-02-25 | 2 | f | The Filipino parliament on the independence. | Other... | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
52907 | 52907 | 1933-05-27 | 2 | f | Zhang Fakui still in Paris. | Other... | http://trove.nla.gov.au/newspaper/page/24091236 | 24091236 | |
53489 | 53489 | 1933-11-04 | 3 | f | Conference of the League of Nations examine its past achievements. | Other... | http://trove.nla.gov.au/newspaper/page/24091421 | 24091421 | |
53565 | 53565 | 1933-11-18 | 6 | f | Chinese in Fiji have an internal fighting. | Other... | http://trove.nla.gov.au/newspaper/page/24091442 | 24091442 | |
53872 | 53872 | 1934-02-17 | 6 | f | Internal chaos in Austria. | Other... | |||
54486 | 54486 | 1934-09-08 | 2 | f | Chinese in Macao oppose to Japanese contract of the tap water project. | Other... | http://trove.nla.gov.au/newspaper/page/24096150 | 24096150 | |
54601 | 54601 | 1934-10-13 | 6 | f | Chaos in Spain. | Other... | http://trove.nla.gov.au/newspaper/page/24096194 | 24096194 | |
55046 | 55046 | 1935-04-27 | 2 | f | Japanese ambition in Outer Mongolia. | Other... | http://trove.nla.gov.au/newspaper/page/24096407 | 24096407 | |
4620 | 4620 | 1900-02-24 | 2 | e-f | Reports on the war between Britain and Transvaal. | Other... | http://trove.nla.gov.au/newspaper/page/24102710 | 24102710 | |
6622 | 6622 | 1900-12-12 | 2 | e-f | Military equipment in Zhangjiakou was destroyed by German and Italian soldiers; some German troops on the way to the south of Tianjin; Dong Fuxiang has been removed from his position; clashes between Chinese and German soldiers in the west of Baoding; Russian administrators increase tax in Niuzhuang. | Other... | http://trove.nla.gov.au/newspaper/page/24103045 | 24103045 | |
31066 | 31066 | 1916-03-25 | 3 | e-f | Miscellaneous report on the World War I (military expenses of Britain, Germany, France, Russia, Austria and Italy; loss of Austrian army; war between Italy and Austria, war in Caucasus Mountains). | Other... | http://trove.nla.gov.au/newspaper/page/24095202 | 24095202 | |
31116 | 31116 | 1916-04-08 | 3 | e-f | News about the World War I in Europe. | Other... | http://trove.nla.gov.au/newspaper/page/24095219 | 24095219 | |
31159 | 31159 | 1916-04-22 | 3 | e-f | News on the World War I (Eighty merchant ships sink. German people are saving for the War. Negotiation between America and Germany. The war between Russia and Turkey. And other reports.) | Other... | http://trove.nla.gov.au/newspaper/page/24095235 | 24095235 | |
31178 | 31178 | 1916-04-29 | 3 | e-f | The World War I (Portugal deports German people. Turkish army commander is killed. Triumph of the Italian army. Britain to start compulsory military service. The battles in Eastern Europe. Japan rebuffs American government on the immigration dispute. Italian troops can not go to Western Europe). | Other... | http://trove.nla.gov.au/newspaper/page/24095243 | 24095243 | |
31240 | 31240 | 1916-05-20 | 3 | e-f | News on the World War I in Europe (Australian army in western Europe. Irish revolution leader and his marriage. Financial chaos in Greece. Battles in Russia). | Other... | http://trove.nla.gov.au/newspaper/page/24095267 | 24095267 | |
31284 | 31284 | 1916-06-03 | 3 | e-f | News on the World War I (Bonn under attack, daily military expense for British troops, compulsory service system in Britain, etc). | Other... | http://trove.nla.gov.au/newspaper/page/24095283 | 24095283 | |
31324 | 31324 | 1916-06-17 | 3 | e-f | The news on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095299 | 24095299 | |
31342 | 31342 | 1916-06-24 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095307 | 24095307 | |
31360 | 31360 | 1916-07-01 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095315 | 24095315 | |
31384 | 31384 | 1916-07-08 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095323 | 24095323 | |
31400 | 31400 | 1916-07-15 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095331 | 24095331 | |
31421 | 31421 | 1916-07-22 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095338 | 24095338 | |
31441 | 31441 | 1916-07-29 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095346 | 24095346 | |
31458 | 31458 | 1916-08-05 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095354 | 24095354 | |
31477 | 31477 | 1916-08-12 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095364 | 24095364 | |
31502 | 31502 | 1916-08-19 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095380 | 24095380 | |
31523 | 31523 | 1916-08-26 | 3 | e-f | News on the World War I. | Other... | |||
31558 | 31558 | 1916-09-09 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095397 | 24095397 | |
31594 | 31594 | 1916-09-23 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095413 | 24095413 | |
31612 | 31612 | 1916-09-30 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095421 | 24095421 | |
31629 | 31629 | 1916-10-07 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095429 | 24095429 | |
31650 | 31650 | 1916-10-14 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095437 | 24095437 | |
31671 | 31671 | 1916-10-21 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095445 | 24095445 | |
31689 | 31689 | 1916-10-28 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095453 | 24095453 | |
31709 | 31709 | 1916-11-04 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095461 | 24095461 | |
31724 | 31724 | 1916-11-11 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095469 | 24095469 | |
31743 | 31743 | 1916-11-18 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095477 | 24095477 | |
31780 | 31780 | 1916-12-02 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095498 | 24095498 | |
31797 | 31797 | 1916-12-09 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095506 | 24095506 | |
31833 | 31833 | 1916-12-23 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095522 | 24095522 | |
31854 | 31854 | 1916-12-30 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095530 | 24095530 | |
31871 | 31871 | 1917-01-06 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095538 | 24095538 | |
31894 | 31894 | 1917-01-13 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095546 | 24095546 | |
31910 | 31910 | 1917-01-20 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095554 | 24095554 | |
32072 | 32072 | 1917-02-10 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095591 | 24095591 | |
32093 | 32093 | 1917-02-17 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095600 | 24095600 | |
32133 | 32133 | 1917-03-10 | 3 | e-f | News on the World War I (China declares war with Germany, and others). | Other... | http://trove.nla.gov.au/newspaper/page/24095616 | 24095616 | |
32170 | 32170 | 1917-03-24 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095632 | 24095632 | |
32209 | 32209 | 1917-04-07 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095648 | 24095648 | |
32229 | 32229 | 1917-04-14 | 3 | e-f | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095656 | 24095656 | |
32268 | 32268 | 1917-04-28 | 3 | e-f | News on the World War I (Poland in the War, chaos in Brazil, American government seeks to recruit yellow immigrants for agricultural purpose, and other news on the World War I). | Other... | http://trove.nla.gov.au/newspaper/page/24095672 | 24095672 |
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]);