This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50803 | 50803 | 1931-10-17 | 5 | a | Miscellaneous report on Japanese invasion in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090560 | 24090560 | |
50804 | 50804 | 1931-10-17 | 5 | a | Travel notes to Korea. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090560 | 24090560 | |
50805 | 50805 | 1931-10-17 | 5 | c | Notice by the Sydney Chinese Association to Fight Japan and to Save China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090560 | 24090560 | |
50806 | 50806 | 1931-10-17 | 5 | d | Notice issued by Acting Chinese Consul-General in Australia Chen Weipin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090560 | 24090560 | |
50807 | 50807 | 1931-10-17 | 5 | d | Chinese Consulate-General in Sydney acknowledges receipt of donations to the flooding areas in China and the names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090560 | 24090560 | |
50808 | 50808 | 1931-10-17 | 5 | e | Chinese Chamber of Commerce in Sydney calls for donations to the flooding areas in China and names listed for all donations. And another by this chamber of commerce on the amount of total donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090560 | 24090560 |
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]);