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 |
---|---|---|---|---|---|---|---|---|---|
45537 | 45537 | 1927-03-12 | 2 | f | The trial of POWs in Jiangxi province, chaired by Guo Moruo. | China | http://trove.nla.gov.au/newspaper/page/24101908 | 24101908 | |
45546 | 45546 | 1927-03-12 | 7 | b-c | The highest building, the oldest man and the biggest boy in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45540 | 45540 | 1927-03-12 | 3 | d | The Soviet Russia and the Nationalist government in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45541 | 45541 | 1927-03-12 | 3 | d | The Nationalist Party sets up local administration in Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45549 | 45549 | 1927-03-12 | 7 | d | Names listed for donations to the Dongguan hospital. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45544 | 45544 | 1927-03-12 | 5 | a-c | Miscellaneous foreign report on the crisis in China. | Other... | http://trove.nla.gov.au/newspaper/page/24101909 | 24101909 | |
45550 | 45550 | 1927-03-12 | 8 | a-d | Guangdong news/ Petitions of the Guangzhou businessmen and Li Jishen. The Huangpu Military Academy and Li Jishen. Li Jishen dispatches troops to take over the Henan area. Old clothes shops in Guangzhou and their business. Strike in Humen area and the solution. Some private schools prefer to stay open. | China | http://trove.nla.gov.au/newspaper/page/24101914 | 24101914 | |
45551 | 45551 | 1927-03-12 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101914 | 24101914 | |
45534 | 45534 | 1927-03-12 | 2 | c | Editorial by Tung Wah Times on the petition presented by the Guangdong businessmen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101908 | 24101908 | |
45535 | 45535 | 1927-03-12 | 2 | c-d | Chinese recent diplomacy with Britain, America and other countries. | China | http://trove.nla.gov.au/newspaper/page/24101908 | 24101908 | |
45538 | 45538 | 1927-03-12 | 3 | c | Chinese foreign ministry in Beijing publicise the correspondence with Japan over the revision of treaties. | China | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45545 | 45545 | 1927-03-12 | 7 | a-b | Australia news/ Cost of haircut for women in Sydney. Liner Zhangde (Changte) arrives Sydney. News from Solomon islands. Investigation on the bomb explosion in Redfern, Sydney. Artist performers come from China organised by Huang Guangzhao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45547 | 45547 | 1927-03-12 | 7 | c | A wonderful advertisement by a French cosmetics company in Paris. | France | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45542 | 45542 | 1927-03-12 | 3 | e-f | A survey on the rich and single women in America. | America | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45539 | 45539 | 1927-03-12 | 3 | d | A speech by Shi Zhaoji in America. | America | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45543 | 45543 | 1927-03-12 | 3 | e-f | A notice on shareholders' meeting of the Zhenguang China Company Ltd in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
45548 | 45548 | 1927-03-12 | 7 | c | A notice by the Oriental Arts Company Ltd, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101911 | 24101911 | |
45536 | 45536 | 1927-03-12 | 2 | d | A meeting between China and Japan to revise the treaties. | China | http://trove.nla.gov.au/newspaper/page/24101908 | 24101908 |
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]);