This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36730 | 36730 | 1921-03-19 | 3 | a | Zhang Qian and Nie Qijie send telegram to Beijing government on tariff reform. | China | http://trove.nla.gov.au/newspaper/page/24093476 | 24093476 | |
36731 | 36731 | 1921-03-19 | 3 | a | China prepares to send delegate to the international trade convention in Paris. | China | http://trove.nla.gov.au/newspaper/page/24093476 | 24093476 | |
36732 | 36732 | 1921-03-19 | 3 | b | Japanese police detain Chinese student Huang Yibo and bring him to trial the next day in a Yokohama court. | Japan | http://trove.nla.gov.au/newspaper/page/24093476 | 24093476 | |
36733 | 36733 | 1921-03-19 | 3 | b | Arrogant Japanese in Shandong province show their muscles. | China | http://trove.nla.gov.au/newspaper/page/24093476 | 24093476 | |
36734 | 36734 | 1921-03-19 | 3 | b-c | Japanese interfere with China's military transportation in Heilongjiang area. | China | http://trove.nla.gov.au/newspaper/page/24093476 | 24093476 | |
36735 | 36735 | 1921-03-19 | 3 | c | French authority dispatches troops to the German border. | Britain | http://trove.nla.gov.au/newspaper/page/24093476 | 24093476 | |
36736 | 36736 | 1921-03-19 | 3 | c | A British ship sinks opposite to Shantou and 800 Chinese are drowned. | Britain | http://trove.nla.gov.au/newspaper/page/24093476 | 24093476 | |
36737 | 36737 | 1921-03-19 | 3 | c | Japanese government increases its military budget significantly. | America | http://trove.nla.gov.au/newspaper/page/24093476 | 24093476 | |
36738 | 36738 | 1921-03-19 | 3 | c | Allies troops take over German ports without any resistance. | Britain | http://trove.nla.gov.au/newspaper/page/24093476 | 24093476 | |
36739 | 36739 | 1921-03-19 | 3 | c | Revolutionary movement in Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24093476 | 24093476 | |
36740 | 36740 | 1921-03-19 | 3 | c | Prime Minister of Spain is assassinated. | Britain | http://trove.nla.gov.au/newspaper/page/24093476 | 24093476 |
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]);