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 |
---|---|---|---|---|---|---|---|---|---|
47243 | 47243 | 1928-07-21 | 2 | d | The assassination of Zhang Zuolin and recent development in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24098882 | 24098882 | |
47244 | 47244 | 1928-07-21 | 2 | e | An internal declaration issued by the Nanjing government on its policies. | China | http://trove.nla.gov.au/newspaper/page/24098882 | 24098882 | |
47246 | 47246 | 1928-07-21 | 3 | b | Qi Xieyuan is intended to command Sun Chuanfang's army. | China | http://trove.nla.gov.au/newspaper/page/24098881 | 24098881 | |
47247 | 47247 | 1928-07-21 | 3 | d | Treasury of the Nanjing government to raise some more funds by issue of bonds. | China | http://trove.nla.gov.au/newspaper/page/24098881 | 24098881 | |
47251 | 47251 | 1928-07-21 | 6 | a-d | Guangdong news/ Circular telegram issued by Li Zongren on the current situations. Gan Naiguang absconds with public funds and the report by the provincial government. Professional regulations for court judges issued. Chen Jiongming's followers to be cleared up and the slogans. Martial laws enforced again in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24098886 | 24098886 | |
47252 | 47252 | 1928-07-21 | 7 | a-d | Guangdong news/ Weighing equipment to be checked in Guangzhou. Road construction in the west of Guangzhou. A man in Guangzhou serves the imprisonment for his son. A case of life while searching smuggled opium. Clan feud and fighting in Taishan and Kaiping county. Fighting of two clans in Chixi county. Official publication by Li Jishen to discipline the army. | China | http://trove.nla.gov.au/newspaper/page/24098885 | 24098885 | |
47254 | 47254 | 1928-07-21 | 8 | a | Nanjing government demands foreign gunboats to leave China. | China | http://trove.nla.gov.au/newspaper/page/24098888 | 24098888 |
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]);