This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50054 | 50054 | 1931-03-07 | 2 | c | Many Chinese in New York are unemployed and the statistics | America | http://trove.nla.gov.au/newspaper/page/24090300 | 24090300 | |
50055 | 50055 | 1931-03-07 | 2 | c | Chinese communities in Mexico fight discrimination. | Other... | http://trove.nla.gov.au/newspaper/page/24090300 | 24090300 | |
50063 | 50063 | 1931-03-07 | 3 | c | A survey on the Chinese students in Belgium. | China | http://trove.nla.gov.au/newspaper/page/24090299 | 24090299 | |
50064 | 50064 | 1931-03-07 | 3 | c | Hangzhou government, Zhejiang, plans to dredge the West Lake. | China | http://trove.nla.gov.au/newspaper/page/24090299 | 24090299 | |
50065 | 50065 | 1931-03-07 | 3 | c | Communist troops under He Long in the west Hunan province occupy Huarong for three times. | China | http://trove.nla.gov.au/newspaper/page/24090299 | 24090299 | |
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 | |
50080 | 50080 | 1931-03-07 | 8 | c | British ambassador arrives in Nanjing for a talk on the consular jurisdiction. | China | http://trove.nla.gov.au/newspaper/page/24090306 | 24090306 | |
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]);