This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47888 | 47888 | 1929-03-16 | 3 | a | Soviet Russian Bolsheviks organise rebellion in Shanghai suburb. | China | http://trove.nla.gov.au/newspaper/page/24099145 | 24099145 | |
47889 | 47889 | 1929-03-16 | 3 | b | National customs authority takes over the tariff offices. | China | http://trove.nla.gov.au/newspaper/page/24099145 | 24099145 | |
47890 | 47890 | 1929-03-16 | 3 | b | Chinese ministry of transportation to dredge the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24099145 | 24099145 | |
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 | |
47896 | 47896 | 1929-03-16 | 3 | e | Chinese language to be used for traffic signs in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24099145 | 24099145 |
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]);