This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50895 | 50895 | 1931-11-21 | 6 | b | Names listed for donations to the Sydney Chinese Association to Fight Japan and to Save China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090609 | 24090609 | |
50896 | 50896 | 1931-11-21 | 6 | a-d | Guangdong news/ Murderer runs away from Guangzhou. Order to capture Du Xuantai and others. Newspaper is sealed off for publishing dissident opinions. More spies dispatched to protect Japanese nationals. Guangzhou authority check gun licences. Social security in Chaozhou and Meixian county. Troops dispatched to suppress bandits in the Beijiang area. Ministry of Finance issues new currency policy. | China | http://trove.nla.gov.au/newspaper/page/24090609 | 24090609 |
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]);