This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
43931 | 43931 | 1925-10-03 | 6 | a | Textile workers on strike again in Shanghai in a Japanese factory. | China | http://trove.nla.gov.au/newspaper/page/24101302 | 24101302 | |
43932 | 43932 | 1925-10-03 | 6 | a | French authority arrests communist members. | France | http://trove.nla.gov.au/newspaper/page/24101302 | 24101302 | |
43933 | 43933 | 1925-10-03 | 6 | a | The British doctor, who was kidnapped in north Mongolia by bandits, has been released. | China | http://trove.nla.gov.au/newspaper/page/24101302 | 24101302 | |
43934 | 43934 | 1925-10-03 | 6 | a | Two Japanese military planes collide during an exercise. | Japan | http://trove.nla.gov.au/newspaper/page/24101302 | 24101302 | |
43935 | 43935 | 1925-10-03 | 6 | a | Yellow River dyke bursts and the large flooded area. | China | http://trove.nla.gov.au/newspaper/page/24101302 | 24101302 | |
43936 | 43936 | 1925-10-03 | 6 | a | Workers of telegram bureau are on strike in Shanghai for more pay. | China | http://trove.nla.gov.au/newspaper/page/24101302 | 24101302 | |
43937 | 43937 | 1925-10-03 | 6 | b | Further report on the cholera in the Philippines. | Other... | http://trove.nla.gov.au/newspaper/page/24101302 | 24101302 | |
43938 | 43938 | 1925-10-03 | 6 | b-c | Jiang Jieshi orders to arrest pro-communist activists and government officials. | China | http://trove.nla.gov.au/newspaper/page/24101302 | 24101302 |
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]);