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 |
---|---|---|---|---|---|---|---|---|---|
47463 | 47463 | 1928-09-29 | 8 | a | Feng Yuxiang and the national unification of China. | China | http://trove.nla.gov.au/newspaper/page/24098968 | 24098968 | |
47464 | 47464 | 1928-09-29 | 8 | a | Unemployment in the Soviet Union. | Britain | http://trove.nla.gov.au/newspaper/page/24098968 | 24098968 | |
47465 | 47465 | 1928-09-29 | 8 | a | Bandits in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24098968 | 24098968 | |
47466 | 47466 | 1928-09-29 | 8 | a | Changes of social custom in China. | China | http://trove.nla.gov.au/newspaper/page/24098968 | 24098968 | |
47472 | 47472 | 1928-09-29 | 5 | a | Notice issued by the Special Committee of the Chinese Chamber of Commerce in NSW for the National Day celebration and the birthday celebration for Confucius. Photographs of the Special Committee members: Mrs A. Sarsin, Fang Yahua (Fred Fong) and Chen Shunyao (Edward Kaw). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098963 | 24098963 |
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]);