This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25594 | 25594 | 1912-01-20 | 2 | b-c | Notice of Guangdong military government | Notice of Guangdong military government about no legal actions on any former crimes, appointment of Yang Muru to do fund raising in Nanyang, establishment of overseas Chinese militia to assist local police; appointment of several senior government officials and asking Shanghai governor to send collected donations in Shanghai to Guangdong. | Other... | http://trove.nla.gov.au/newspaper/page/24092075 | 24092075 |
25617 | 25617 | 1912-01-20 | 6 | b-c | Extraordinary teenage in Fujian revolutioary toops | Wang Jiegong, a small-built teenage in Fujian troops, made some extraordinary deeds during battles. | China | http://trove.nla.gov.au/newspaper/page/24092079 | 24092079 |
25627 | 25627 | 1912-01-20 | 7 | b-c | Letter to Wuhan people by representatives from various provinces | A letter praises the deeds of Wuhan people and calls on their consecutive efforts to protect Wuhan. Names of representatives listed. | China | http://trove.nla.gov.au/newspaper/page/24092078 | 24092078 |
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]);