This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47090 | 47090 | 1928-06-02 | 2 | f | Pagoda to be built in Jiangxi province for the dead servicemen. | China | http://trove.nla.gov.au/newspaper/page/24098826 | 24098826 | |
47091 | 47091 | 1928-06-02 | 3 | b | The Communist bandits set fire in Jiading, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24098825 | 24098825 | |
47092 | 47092 | 1928-06-02 | 3 | d | The movement in Hunan province to wipe out Communists. | China | http://trove.nla.gov.au/newspaper/page/24098825 | 24098825 | |
47093 | 47093 | 1928-06-02 | 3 | e | Lu Diping is appointed army commander on the recommendation of Li Zongren. | China | http://trove.nla.gov.au/newspaper/page/24098825 | 24098825 | |
47099 | 47099 | 1928-06-02 | 6 | a-d | Guangdong news/ Guangzhou authority on the harm of students' movement. Land authority explains the land tax. Bandits hijack train from Guangzhou to Kowloon. Businessmen in Guangzhou organise various associations. Internal fighting in the Shantou Branch of the Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24098830 | 24098830 | |
47100 | 47100 | 1928-06-02 | 7 | a | A military conference of Guangdong and Guangxi and speech by Li Jishen. | China | http://trove.nla.gov.au/newspaper/page/24098829 | 24098829 | |
47101 | 47101 | 1928-06-02 | 7 | b | Guangdong agricultural and industrial administration issues temporary regulations on the labour movement, relations between employers and employees, and others. | China | http://trove.nla.gov.au/newspaper/page/24098829 | 24098829 | |
47102 | 47102 | 1928-06-02 | 7 | d | Public protest gathering in Guangzhou against Japanese troops in north China. | China | http://trove.nla.gov.au/newspaper/page/24098829 | 24098829 | |
47105 | 47105 | 1928-06-02 | 8 | a | Battle on the Beijing-Hankou railway between Feng Yuxiang and Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47109 | 47109 | 1928-06-02 | 8 | a | Communist office smashed in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 |
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]);