This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47009 | 47009 | 1928-05-05 | 7 | a | Rumours on the coming uprisings of workers and peasants in Guangdong and Guangxi. | China | http://trove.nla.gov.au/newspaper/page/24098797 | 24098797 | |
47010 | 47010 | 1928-05-05 | 7 | a | British nationals are fleeing Jinan, Shandong province. Troops from the north take over Jinan. | China | http://trove.nla.gov.au/newspaper/page/24098797 | 24098797 | |
47011 | 47011 | 1928-05-05 | 7 | a | King of Britain sends his condolences to the earthquake victims in Greece. | Other... | http://trove.nla.gov.au/newspaper/page/24098797 | 24098797 | |
47012 | 47012 | 1928-05-05 | 7 | a | Typhoon in American and the damages. | America | http://trove.nla.gov.au/newspaper/page/24098797 | 24098797 | |
47013 | 47013 | 1928-05-05 | 7 | b | British government issues ultimate to the Egyptian authorities. | Other... | http://trove.nla.gov.au/newspaper/page/24098797 | 24098797 | |
47014 | 47014 | 1928-05-05 | 7 | b | Japan is dispatching more troops to China. Troops from the south once again take over Jinan, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098797 | 24098797 | |
47015 | 47015 | 1928-05-05 | 7 | b | Strike in India. | Other... | http://trove.nla.gov.au/newspaper/page/24098797 | 24098797 | |
47016 | 47016 | 1928-05-05 | 7 | c | Australia news/ People arrested in Sydney for the forging bank notes. A gardener finds gold coins while ploughing his farm. A young girl is detained for theft. Advertisement for Assurance Homes of Australia Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098797 | 24098797 |
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]);