This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
26740 | 26740 | 1912-09-14 | 6 | a | Vice president's comments on current China's situation. | Other... | http://trove.nla.gov.au/newspaper/page/24092380 | 24092380 | |
26741 | 26741 | 1912-09-14 | 6 | a-b | Report about how Tongmeng Hui members smashing Guomin Gongbao (People's Newspaper) office. Beijing Guomin (People's) Association asks heavy punishment of Tongmeng Hui members who damaged People's Newspaper office. Shanghai People's Association appeals to government to punish those who damaged People's Newspaper office. Shanghai Social Party calls vice president to allow people's gathering freedom. Vice president returns to Shanghai Social Party stating gathering freedom legal. | Other... | http://trove.nla.gov.au/newspaper/page/24092380 | 24092380 | |
26742 | 26742 | 1912-09-14 | 6 | b-c | Republic Construction Association appeals to president and state council to make decision to solve current problems. | Other... | http://trove.nla.gov.au/newspaper/page/24092380 | 24092380 |
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]);