This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid | date | page | column | title | description ▼ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47546 | 47546 | 1928-11-03 | 2 | f | A meeting of all Japanese consuls throughout Manchuria and the resolutions. | China | http://trove.nla.gov.au/newspaper/page/24099002 | 24099002 | |
47555 | 47555 | 1928-11-03 | 8 | a-c | Australia news/ Thief arrested in Sydney. Italian consul asks for protection of Italian immigrants in Australia. Bomb explosion in an Italian residence in Sydney. Japanese purchase iron from Australia. White women are charged with wandering. The half-breed woman who murders her Chinese husband in on bail. Fire in Melbourne dockyard. White woman is sentenced for theft. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099008 | 24099008 | |
47556 | 47556 | 1928-11-03 | 8 | c | Book is available from Tung Wah Times on the National Day celebration and the birthday celebration of Confucius. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099008 | 24099008 | |
47550 | 47550 | 1928-11-03 | 3 | f | China sends special envoys to review army parade in Japan. | China | http://trove.nla.gov.au/newspaper/page/24099001 | 24099001 | |
47540 | 47540 | 1928-11-03 | 2 | b | Chinese colony and the comparison with other countries. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099002 | 24099002 | |
47554 | 47554 | 1928-11-03 | 8 | a | Chinese student in London murders his wife. | Britain | http://trove.nla.gov.au/newspaper/page/24099008 | 24099008 | |
47547 | 47547 | 1928-11-03 | 3 | b | Copy of the peace treaty signed in Paris. | Other... | http://trove.nla.gov.au/newspaper/page/24099001 | 24099001 | |
47549 | 47549 | 1928-11-03 | 3 | e | Drought and famine in Gansu province, China. | China | http://trove.nla.gov.au/newspaper/page/24099001 | 24099001 | |
47552 | 47552 | 1928-11-03 | 6-7 | a-d | Guangdong news/ The Communist Party in the Guangzhou Bay. Political turmoil in Guangzhou. Appeal for reform of land tax in Guangzhou. Collection of stamp duties. Thieves in Guangzhou. Taxation authority finds it hard to collect taxes. Local administrators in Zengcheng called to a meeting for the suppression of bandits. Protest by villagers in Zhongshan county. News from Dongguan and Gaoyao county. | China | http://trove.nla.gov.au/newspaper/page/24099006 | 24099006 | |
47541 | 47541 | 1928-11-03 | 2 | c | Japanese political party min zheng dang and their China policy. | Japan | http://trove.nla.gov.au/newspaper/page/24099002 | 24099002 | |
47544 | 47544 | 1928-11-03 | 2 | d | Jiang Jieshi dispatches more troops to Anhui province. | China | http://trove.nla.gov.au/newspaper/page/24099002 | 24099002 | |
47545 | 47545 | 1928-11-03 | 2 | e | Progress of negotiation between China and Japan over the future of Jinan. Japanese ambition. | China | http://trove.nla.gov.au/newspaper/page/24099002 | 24099002 | |
47542 | 47542 | 1928-11-03 | 2 | c | Shanghai in the storm. | China | http://trove.nla.gov.au/newspaper/page/24099002 | 24099002 | |
47551 | 47551 | 1928-11-03 | 3 | f | Shuntian Times (Shuntian shi bao) is forced to close by the Beijing authority. | China | http://trove.nla.gov.au/newspaper/page/24099001 | 24099001 | |
47543 | 47543 | 1928-11-03 | 2 | d | The League of Nations and China's relationship with America. | China | http://trove.nla.gov.au/newspaper/page/24099002 | 24099002 | |
47553 | 47553 | 1928-11-03 | 8 | a | The Nationalist government in Nanjing engages German military adviser. | China | http://trove.nla.gov.au/newspaper/page/24099008 | 24099008 | |
47548 | 47548 | 1928-11-03 | 3 | d | Troops from Henan and Hubei provinces to jointly suppress Fan Zhongxiu. | China | http://trove.nla.gov.au/newspaper/page/24099001 | 24099001 |
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]);