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 |
---|---|---|---|---|---|---|---|---|---|
38457 | 38457 | 1922-03-25 | 2 | a-b | Editorial on the transportation in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093912 | 24093912 | |
38459 | 38459 | 1922-03-25 | 2 | c | How much German investment used for the railway construction from Qingdao to Jinan (1904-1911). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093912 | 24093912 | |
38478 | 38478 | 1922-03-25 | 6 | b-c | Third part of the provincial constitution passed by the Guangdong Legislature Assembly. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093916 | 24093916 | |
38480 | 38480 | 1922-03-25 | 7 | a | Sydney city councillor demands payment for defamation following the corruption charge against him lost. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093915 | 24093915 | |
38481 | 38481 | 1922-03-25 | 7 | a | A man in New South Wales is sentenced to 12 months' imprisonment for raping an aboriginal girl. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093915 | 24093915 | |
38482 | 38482 | 1922-03-25 | 7 | a | Two Sydney policemen are attacked while patrolling on the street. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093915 | 24093915 | |
38483 | 38483 | 1922-03-25 | 7 | a | Three Chinese men and two white women are arrested in Lower Campbell Street, Sydney, for smoking opium. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093915 | 24093915 | |
38484 | 38484 | 1922-03-25 | 7 | a | State election in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093915 | 24093915 | |
38485 | 38485 | 1922-03-25 | 7 | b | Lin You, of Adelaide, sues Liu Guangfu, of Sydney, and the court hearing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093915 | 24093915 | |
38486 | 38486 | 1922-03-25 | 7 | b | A robbery at the theatre in Pitt Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093915 | 24093915 | |
38489 | 38489 | 1922-03-25 | 7 | c | A white woman, Alice, is seeking a Chinese husband. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093915 | 24093915 | |
38490 | 38490 | 1922-03-25 | 7 | d | A notice issued by the See Yup Society in Sydney on the transfer of their deceased native fellows' remains back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093915 | 24093915 | |
38491 | 38491 | 1922-03-25 | 7 | e | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093915 | 24093915 | |
38493 | 38493 | 1922-03-25 | 8 | a-d | Guangdong news/ The Guangzhou-Hong Kong strikers are forbidden to sabotage railway transportation. Self-government research institution in Guangzhou and the new regulation. Bandits in the See Yup region may be united together. A woman in Xinhui county attempts to poison her husband and mother-in-law. Xu Chongzhi may have resigned. Some Guangdong people do not support the fundraising and redeem of railway in north China. Educational achievement in Xiangshan county. Cotton production in Xiangshan county. Military police in Guangzhou stop sale of dog meat. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093918 | 24093918 | |
38494 | 38494 | 1922-03-25 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093918 | 24093918 | |
38495 | 38495 | 1922-03-25 | 8 | f | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093918 | 24093918 |
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]);