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 |
---|---|---|---|---|---|---|---|---|---|
47308 | 47308 | 1928-08-11 | 2 | b | Second and final part of editorial by Tung Wah Times worries about the rapid spread of Communism in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098906 | 24098906 | |
47315 | 47315 | 1928-08-11 | 3 | b | American legislature on the war treaty involved by many countries including Australia. | America | http://trove.nla.gov.au/newspaper/page/24098905 | 24098905 | |
47321 | 47321 | 1928-08-11 | 5 | b | Second part of the survey on the mercurial mining resources in Guizhou province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098786 | 24098786 | |
47328 | 47328 | 1928-08-11 | 8 | b | French authority arrests Communist members. | Britain | http://trove.nla.gov.au/newspaper/page/24098783 | 24098783 | |
47329 | 47329 | 1928-08-11 | 8 | b | Australia news/ Chinese Chamber of Commerce in Sydney writes to the New South Wales state health authority on the import of rice straws. A man in Melbourne is sentenced to 10 years' imprisonment for forging bank notes. New Chinese consul in Australia Wu Qinfen arrives Sydney. Japanese come to buy cocks in Australia. Chinese Students' Association in Australia (zhong hua liu ao xue sheng hui) organised in Sydney and its declaration. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098783 | 24098783 |
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]);