This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47025 | 47025 | 1928-05-12 | 5 | a | Hong Kong news/ Another private bank collapses. Prince of Japan might visit Guangzhou. Report on English newspaper on the arrival of Japanese warships. Special police forces are being trained in order to eliminate the Communist members. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098803 | 24098803 | |
47026 | 47026 | 1928-05-12 | 5 | b | First part of a survey on the tobacco production in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098803 | 24098803 | |
47027 | 47027 | 1928-05-12 | 5 | c | A fun party for the service men in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24098803 | 24098803 | |
47028 | 47028 | 1928-05-12 | 5 | c | Story of a woman in Taishan county who marries an overseas Chinese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098803 | 24098803 |
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]);