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 |
---|---|---|---|---|---|---|---|---|---|
49492 | 49492 | 1930-09-13 | 2 | b | Second part of comments on the world economic depression, the reason and the prescriptions. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099773 | 24099773 | |
49493 | 49493 | 1930-09-13 | 2 | c | Wang Jingwei and Yan Xishan on the Party affairs. Organisation of the Beijing government. Communist forces in Anhui. Wu Peifu is ill. Yan Mengyu and the Beijing University. Zhang Huizan in Nanxun. Lu Xingbang stages another counterattack. Battles along the Tianjin-Pukou railway. Zhu Hexiang on the Communist disasters. More report on the wars in China. | China | http://trove.nla.gov.au/newspaper/page/24099773 | 24099773 | |
49494 | 49494 | 1930-09-13 | 3 | a | Communist members in Sichuan province and their activities in schools. | China | http://trove.nla.gov.au/newspaper/page/24099772 | 24099772 | |
49495 | 49495 | 1930-09-13 | 3 | a | Foreign threats in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099772 | 24099772 | |
49496 | 49496 | 1930-09-13 | 3 | b | Japanese plan to invade Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24099772 | 24099772 | |
49497 | 49497 | 1930-09-13 | 3 | c | Soviet Russia import Chinese tea. | China | http://trove.nla.gov.au/newspaper/page/24099772 | 24099772 | |
49498 | 49498 | 1930-09-13 | 3 | c | Japan in economic depression. | Japan | http://trove.nla.gov.au/newspaper/page/24099772 | 24099772 | |
49499 | 49499 | 1930-09-13 | 3 | d | Jiang Jieshi's army leave Qingdao for the west. | China | http://trove.nla.gov.au/newspaper/page/24099772 | 24099772 | |
49500 | 49500 | 1930-09-13 | 5 | b | Hong Kong news/ A case of defraud. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099774 | 24099774 | |
49501 | 49501 | 1930-09-13 | 5 | c | Japanese archaeologists are digging ancient graves in south Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24099774 | 24099774 | |
49502 | 49502 | 1930-09-13 | 5 | d | Bomb explosion in the south of Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24099774 | 24099774 | |
49503 | 49503 | 1930-09-13 | 6-7 | a-d | Guangdong news/ Yunnan army invade Nanning, Guangxi, for twice. Rice shops request to abolish the stamp duties. Leather shops oppose to tax increase. Complaints of the Shunde people. Commercial port to be built in Huangpu. Floods in Shantou. A lawsuit between father and daughter in Dongguan county. Joint defence plan in Zhongshan. Xinhui county increase levy for police forces. | China | http://trove.nla.gov.au/newspaper/page/24099778 | 24099778 | |
49504 | 49504 | 1930-09-13 | 8 | c | A notice issued by the Chinese Chamber of Commerce in Sydney on the payment of personal income tax before departure Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099779 | 24099779 | |
49505 | 49505 | 1930-09-13 | 8 | c | Floods in India. | Other... | http://trove.nla.gov.au/newspaper/page/24099779 | 24099779 | |
49506 | 49506 | 1930-09-13 | 8 | c | Hurricane in central America. | America | http://trove.nla.gov.au/newspaper/page/24099779 | 24099779 | |
49507 | 49507 | 1930-09-13 | 8 | d | Train derails in India. | Other... | http://trove.nla.gov.au/newspaper/page/24099779 | 24099779 | |
49508 | 49508 | 1930-09-13 | 8 | d | New government organised in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24099779 | 24099779 | |
49509 | 49509 | 1930-09-13 | 8 | e | Indian police dismiss public gathering. | Other... | http://trove.nla.gov.au/newspaper/page/24099779 | 24099779 | |
49510 | 49510 | 1930-09-13 | 8 | e | Australia news/ A shop robbery in Sydney. Chinese imprisoned in Sydney for gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099779 | 24099779 |
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]);