This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50053 | 50053 | 1931-03-07 | 2 | b | Second and final part of editorial on the American loans to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090300 | 24090300 | |
50069 | 50069 | 1931-03-07 | 5 | b | Competition of Miss Britain and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090301 | 24090301 | |
50070 | 50070 | 1931-03-07 | 5 | c | A love letter. A girl tests her love. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090301 | 24090301 | |
50071 | 50071 | 1931-03-07 | 5 | e | A notice by the Dongguan gong yi tang in Sydney on the transfer of remains of their deceased fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090301 | 24090301 | |
50072 | 50072 | 1931-03-07 | 5 | e | A notice by the Chinese consulate in Melbourne on the registration of overseas Chinese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090301 | 24090301 | |
50081 | 50081 | 1931-03-07 | 8 | c | Australia news/ A court hearing in Sydney on bank robbery. Arsenal explodes in Melbourne. A man murders his wife on the street. Car thief arrested in Sydney. Acting Chinese consul-general in Australia Li Mingyan is returning while Yu Enhe from New Zealand becomes deputy consul-general in Australia. Unprecedented storm in Fiji. Taxi driver in Sydney is imprisoned for helping robbers. Federal treasury to issue new bank notes. Man arrested for forging bank notes. Two men die in a test flight in Melbourne. Number of earthquake in New Zealand. Train on fire in New Zealand. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090306 | 24090306 |
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]);