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 |
|---|---|---|---|---|---|---|---|---|---|
| 47138 | 47138 | 1928-06-16 | 2 | b | First part of an editorial by Tung Wah Times on the population increase and its relationship to the war. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098842 | 24098842 | |
| 47139 | 47139 | 1928-06-16 | 2 | c | Report on Japanese invasion in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098842 | 24098842 | |
| 47140 | 47140 | 1928-06-16 | 2 | e | New York has more widow than widower. | America | http://trove.nla.gov.au/newspaper/page/24098842 | 24098842 | |
| 47141 | 47141 | 1928-06-16 | 2 | f | Associations in Shanghai and their protest gathering against Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24098842 | 24098842 | |
| 47142 | 47142 | 1928-06-16 | 3 | b | The war between Chinese and Japanese troops before the fall of Jinan, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24098841 | 24098841 | |
| 47143 | 47143 | 1928-06-16 | 3 | d | The conspiracy of Soviet Russia in China. | China | http://trove.nla.gov.au/newspaper/page/24098841 | 24098841 | |
| 47144 | 47144 | 1928-06-16 | 3 | e | Japanese conscription in the south and north of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098841 | 24098841 | |
| 47145 | 47145 | 1928-06-16 | 5 | a | Hong Kong news/ The Sun Company in Hong Kong to have a new building. A robbery in Hong Kong. Hong Kong governor is leaving for holiday. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098843 | 24098843 | |
| 47146 | 47146 | 1928-06-16 | 5 | b | Sixth and final part of the survey on the tobacco production in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098843 | 24098843 | |
| 47147 | 47147 | 1928-06-16 | 5 | c | Two women in Sichuan province share a husband and the report. | China | http://trove.nla.gov.au/newspaper/page/24098843 | 24098843 | |
| 47148 | 47148 | 1928-06-16 | 6 | a-d | Guangdong news/ Guangdong is raising funds for the Northern Expedition. Anti-Japanese movement in Guangzhou. Provincial government is purchasing weapons from overseas. Provincial government promotes local products. Municipal government promotes Chinese-style clothes. | China | http://trove.nla.gov.au/newspaper/page/24098846 | 24098846 | |
| 47149 | 47149 | 1928-06-16 | 7 | a-d | Guangdong news/ Yulin port to be built in the Hainan island. The Chinese Communist Party is to start uprising in Bao'an county. Magistrate of Dianbai county absconds with public funds. Zhongshan county magistrate Liang Hongguang disbands more than 60 trade unions. Civil corps in Zhongshan county. Defence troops in Dongguan county suppress peasant bandits. Sand land in Dongguan county. Robbery in Gaoyao county. The ceramic industry in Nanhai county. Bandits in Shunde hijack cargo ship. | China | http://trove.nla.gov.au/newspaper/page/24098845 | 24098845 | |
| 47150 | 47150 | 1928-06-16 | 8 | a | A failed attempt to assassinate Japanese prime minister. | Japan | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
| 47151 | 47151 | 1928-06-16 | 8 | a | Zhang Zongchang demands more payment before retreat. Feng Yuxiang and his defection. | China | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
| 47152 | 47152 | 1928-06-16 | 8 | a | A passenger ship is stranded on its way from Hong Kong to Wuzhou. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
| 47153 | 47153 | 1928-06-16 | 8 | a | Report says Beijing is quiet at the moment. | Britain | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
| 47154 | 47154 | 1928-06-16 | 8 | b | The Nationalist government in Nanjing and its declaration of foreign policy. | China | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
| 47155 | 47155 | 1928-06-16 | 8 | b | Japanese residence in Shanghai is bombed. | China | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
| 47156 | 47156 | 1928-06-16 | 8 | c | Nanjing has become capital of the Nationalist government. | China | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
| 47157 | 47157 | 1928-06-16 | 8 | c | The death of Zhang Zuolin is confirmed. | Japan | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 | |
| 47158 | 47158 | 1928-06-16 | 8 | c | Australia news/ A man in Sydney is punished for illegal wine. Young woman dies of abortion in Sydney hospital. Further report on the direct flight from North America to Australia. Further report on the strike of chefs on board of passenger liners in Sydney. Investigation on the murder of Chinese father and son in Brisbane. Long distance telephone call will be better. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098848 | 24098848 |
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]);