This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36928 | 36928 | 1921-04-30 | 8 | a | A Guangdong folk song, written by anonymous author, on the hardship of the China-Australia Mail Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093531 | 24093531 | |
36929 | 36929 | 1921-04-30 | 8 | a-b | Guangdong news/ Tang Shaoyi visits his hometown. Ye Gongchuo requests his subordinates to save some money for the famine victims. Workers in Shaoguan railway station on strike for safety reason. Street girls disappear in some parts of Guangzhou. Bandits in Luoding county. Kidnap in Dongguan. Wei Rongchang leads his Guangxi army looting some villages in Fengchuan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093531 | 24093531 | |
36930 | 36930 | 1921-04-30 | 8 | c | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093531 | 24093531 |
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]);