This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47883 | 47883 | 1929-03-16 | 2 | c | The Chinese Constitutionalist Party in the United States of America and their constitution. | America | http://trove.nla.gov.au/newspaper/page/24099146 | 24099146 | |
47891 | 47891 | 1929-03-16 | 3 | c | Survey on the munitions factories in China. | China | http://trove.nla.gov.au/newspaper/page/24099145 | 24099145 | |
47892 | 47892 | 1929-03-16 | 3 | c | The leftists in the power struggle within the Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24099145 | 24099145 | |
47893 | 47893 | 1929-03-16 | 3 | c | Wu Ning to be on trial in Nanjing for his defeat by the Communist forces. | China | http://trove.nla.gov.au/newspaper/page/24099145 | 24099145 | |
47894 | 47894 | 1929-03-16 | 3 | c | The Nanjing government purchase large numbers of weapons from overseas. | China | http://trove.nla.gov.au/newspaper/page/24099145 | 24099145 | |
47895 | 47895 | 1929-03-16 | 3 | c | Report says about 3 million people are murdered by the Bolshevik in Soviet Russia. Celebration of the 10th anniversary of the October Revolution. | Russia | http://trove.nla.gov.au/newspaper/page/24099145 | 24099145 | |
47907 | 47907 | 1929-03-16 | 8 | c | Garden for hire in Bankstown, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47908 | 47908 | 1929-03-16 | 8 | c | Notice by Guo Jianying to resign from the position of executive member of the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 |
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]);