This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41603 | 41603 | 1924-05-24 | 7 | a | Australian federal parliament to revise its regulations on the entry of Chinese students. | Australia | http://trove.nla.gov.au/newspaper/page/24100732 | 24100732 | |
41604 | 41604 | 1924-05-24 | 7 | a | Prisoners on riots in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100732 | 24100732 | |
41605 | 41605 | 1924-05-24 | 7 | b | A Sydney woman is brought to trial for drowning her daughters. | Australia | http://trove.nla.gov.au/newspaper/page/24100732 | 24100732 | |
41606 | 41606 | 1924-05-24 | 7 | b | Sun Yatsen welcomes French pilot in Guangzhou. | America | http://trove.nla.gov.au/newspaper/page/24100732 | 24100732 | |
41607 | 41607 | 1924-05-24 | 7 | b | A London newspaper reporter is deported from Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100732 | 24100732 | |
41608 | 41608 | 1924-05-24 | 7 | b-c | News from Shilong on the battle in Dongjiang area. | China | http://trove.nla.gov.au/newspaper/page/24100732 | 24100732 | |
41609 | 41609 | 1924-05-24 | 7 | c | Dongguan fellows in Australia donate to the building of a hospital in Shilong, their home town. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100732 | 24100732 | |
41610 | 41610 | 1924-05-24 | 7 | e | A notice by the Heng Shan Tang (an association of Chinese fellows from Nanhai, Panyu and Shunde counties) in Sydney on the transfer of remains of their deceased fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100732 | 24100732 |
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]);