This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
36751 | 36751 | 1921-03-19 | 7 | c | A French widow now living in Sydney seeks a knowledgeable Chinese partner/ husband. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093480 | 24093480 | |
36752 | 36752 | 1921-03-19 | 7 | c | Board of the Unemployed Workers Association in Sydney acknowledges and thanks Chinese market gardeners for supplying them free vegetables. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093480 | 24093480 | |
36755 | 36755 | 1921-03-19 | 8 | c | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093483 | 24093483 |
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]);