This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 47473 | 47473 | 1928-10-06 | 6-7 | a-d | Guangdong news/ A Soviet Bolshevik office raided in a Guangzhou bar. A Guangzhou newspaper xian xiang bao (Phenomenon Newspaper) is punished for slandering Jiang Jieshi. A case of manslaughter in Guangzhou claims five lives. Bandits and the Communists in Zhongshan county. Shantou government authority ban naked performance. Bandits in Zengcheng county. Road projects in Qingyuan county. Grain exempted for some villagers in Dongguan due to the banditry. New town in Zhongshan county. Bandits in Shilong town. New levies for road construction in Xinhui county. | China | http://trove.nla.gov.au/newspaper/page/24098974 | 24098974 | |
| 47474 | 47474 | 1928-10-06 | 8 | a | American scholar on the current situations in Manchuria. | America | http://trove.nla.gov.au/newspaper/page/24098976 | 24098976 | |
| 47475 | 47475 | 1928-10-06 | 8 | b | Australia news/ Further report on the woman who murders her husband in Sydney. Poor man from Melbourne suddenly becomes rich. Dockers on strike in Adelaide. A white woman is detained for theft. Advertisement for The Primary Producers' Bank of Australia Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098976 | 24098976 | |
| 47476 | 47476 | 1928-10-06 | 8 | d | A public notice issued by Yu Enhe, acting Chinese Consul-General in New Zealand, on the immigration restrictions upon Chinese and other matters. | New Zealand | http://trove.nla.gov.au/newspaper/page/24098976 | 24098976 |
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]);