This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36115 | 36115 | 1920-09-11 | 8 | a | Tsar of Russia may still be alive and a report. | Other... | http://trove.nla.gov.au/newspaper/page/24098310 | 24098310 | |
36116 | 36116 | 1920-09-11 | 8 | a | The end of royal family in Austria. | Other... | http://trove.nla.gov.au/newspaper/page/24098310 | 24098310 | |
36117 | 36117 | 1920-09-11 | 8 | a | Yuan Shikai's debt after his death. | China | http://trove.nla.gov.au/newspaper/page/24098310 | 24098310 | |
36118 | 36118 | 1920-09-11 | 8 | b-c | Guangdong news/ Rumours on the revolutionary movement. Gaoyao county magistrate orders to wipe out all revolutionaries. Women in Guangzhou are learning martial arts. Strange sound on the border of Panyu and Zengcheng county. Commercial chambers in Heshan county contribute to disaster relief. Further report on the storm in Nanhai county. Magistrate of Gaoyao county orders to hand over the murderer. | China | http://trove.nla.gov.au/newspaper/page/24098310 | 24098310 |
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]);