This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47861 | 47861 | 1929-03-09 | 2 | b | Editorial by Tung Wah Times mourns the death of Liang Qichao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099138 | 24099138 | |
47862 | 47862 | 1929-03-09 | 2 | c | Japanese troops in Hankou have an exercise. | China | http://trove.nla.gov.au/newspaper/page/24099138 | 24099138 | |
47863 | 47863 | 1929-03-09 | 2 | c | Nanjing government departments fight for the control of radio communication. | China | http://trove.nla.gov.au/newspaper/page/24099138 | 24099138 | |
47864 | 47864 | 1929-03-09 | 2 | c | Bai Chongxi resigns due to illness. | China | http://trove.nla.gov.au/newspaper/page/24099138 | 24099138 | |
47865 | 47865 | 1929-03-09 | 2 | c | China and Japan continue their talk over the Jinan case. | China | http://trove.nla.gov.au/newspaper/page/24099138 | 24099138 | |
47866 | 47866 | 1929-03-09 | 2 | d | Chinese foreign minister Wang Zhengting talks with French ambassador over the Vietnam issues. | China | http://trove.nla.gov.au/newspaper/page/24099138 | 24099138 | |
47867 | 47867 | 1929-03-09 | 2 | d | Zhang Zongchang is plotting a rebellion in Shandong. | China | http://trove.nla.gov.au/newspaper/page/24099138 | 24099138 | |
47868 | 47868 | 1929-03-09 | 2 | e | Funeral of Liang Qichao in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24099138 | 24099138 | |
47869 | 47869 | 1929-03-09 | 2 | f | Memorial service for Lin Zexu and his ban on opium trade and opium smoking. | China | http://trove.nla.gov.au/newspaper/page/24099138 | 24099138 |
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]);