This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 47018 | 47018 | 1928-05-12 | 2 | b | Editorial on the three disasters in China this year: famine refugees, corrupt officials and the political parties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098802 | 24098802 | |
| 47019 | 47019 | 1928-05-12 | 2 | c | The Comintern or Third International outlines its new policy for the communist movement in China. | Russia | http://trove.nla.gov.au/newspaper/page/24098802 | 24098802 | |
| 47020 | 47020 | 1928-05-12 | 2 | e | The Nationalist government in Nanjing is not free from the past obstacles when finalising its foreign policy. | China | http://trove.nla.gov.au/newspaper/page/24098802 | 24098802 | |
| 47021 | 47021 | 1928-05-12 | 2 | f | The railway construction in China and the response of the international community. | China | http://trove.nla.gov.au/newspaper/page/24098802 | 24098802 | |
| 47022 | 47022 | 1928-05-12 | 3 | b | Ku Klux Klan in America and their recent activities. | America | http://trove.nla.gov.au/newspaper/page/24098801 | 24098801 | |
| 47023 | 47023 | 1928-05-12 | 3 | c | Fierce battles between Fengtian's Zhang Zuolin, Shanxi's Yan Xishan and Henan's Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24098801 | 24098801 | |
| 47024 | 47024 | 1928-05-12 | 3 | d | Japanese cabinet and its new policy. | China | http://trove.nla.gov.au/newspaper/page/24098801 | 24098801 | |
| 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 | |
| 47029 | 47029 | 1928-05-12 | 6 | a-d | Guangdong news/ Guangzhou in extreme nervousness and the panic. Bandits in Guangzhou hijack bicyclers in the broad daylight. Another proposal to develop the Xisha islands in the South China Sea. | China | http://trove.nla.gov.au/newspaper/page/24098806 | 24098806 | |
| 47030 | 47030 | 1928-05-12 | 7 | a | Clash between Chinese and Japanese troops in Jinan, Shandong province, and other relevant reports. | Japan | http://trove.nla.gov.au/newspaper/page/24098805 | 24098805 | |
| 47031 | 47031 | 1928-05-12 | 7 | b | Japanese cabinet to dispatch more troops to Shandong. Another boycott to Japanese goods in Guangdong. More report on the battle between Chinese and Japanese troops along the Jiaozho-Jinan railway. | China | http://trove.nla.gov.au/newspaper/page/24098805 | 24098805 | |
| 47032 | 47032 | 1928-05-12 | 7 | c | Australia news/ Chairman of the New South Wales Gardening Association requests to limit working hours for the Chinese gardeners. New bank opened in Sydney. Further report on the case of rape in Sydney. Booth collapses during a horse racing in Sydney. A female cashier in Brisbane is found embezzlement. Chinese gardener in New South Wales sues builder for irresponsibility. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098805 | 24098805 | |
| 47033 | 47033 | 1928-05-12 | 8 | a-d | Guangdong news/ The Communist members are preparing for another uprising in Yunnan province. Branch of the Nationalist Party in Yangjiang county restrict freedom of speech. The Communists want to make trouble in Jiangmen. Soviet Russian office detected in Haifeng county. Battle in Zhongshan county between government troops and bandits. Graves of Jin Dynasty found along the Guangzhou-Kowloon railway line. Bank notes devalue in Foshan. Vegetable peddlers are on strike in Shilong Town. | China | http://trove.nla.gov.au/newspaper/page/24098808 | 24098808 |
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]);