This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47200 | 47200 | 1928-07-07 | 3 | b | Feng Yuxiang resists Jiang Jieshi's army from going north. | China | http://trove.nla.gov.au/newspaper/page/24098865 | 24098865 | |
47201 | 47201 | 1928-07-07 | 3 | b | Cheng Qian is arrested in Hankou and reason for such punishment. | China | http://trove.nla.gov.au/newspaper/page/24098865 | 24098865 | |
47213 | 47213 | 1928-07-07 | 8 | b | Revolution in Tibet. | Other... | http://trove.nla.gov.au/newspaper/page/24098872 | 24098872 | |
47214 | 47214 | 1928-07-07 | 8 | b | Epidemic disease in Lushun. | China | http://trove.nla.gov.au/newspaper/page/24098872 | 24098872 | |
47215 | 47215 | 1928-07-07 | 8 | b | Anti-Japanese movement and the boycott to Japanese goods in China. | Japan | http://trove.nla.gov.au/newspaper/page/24098872 | 24098872 | |
47216 | 47216 | 1928-07-07 | 8 | b | Australia news/ Woman in New South Wales shoots dead her husband. Old Chinese man is free of charge in Sydney for cohabiting with white girl. Illegal Chinese immigrant is free of charge in Wagga Wagga. Japanese fleet arrives Melbourne. A man in New South Wales dies of gas poisoning. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098872 | 24098872 |
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]);