This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37865 | 37865 | 1921-11-19 | 2 | a | Tung Wah Times comments on the Road Transportation Office in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093759 | 24093759 | |
37879 | 37879 | 1921-11-19 | 6 | a | Names listed for new shareholders of the China-Australia Mail Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093763 | 24093763 | |
37882 | 37882 | 1921-11-19 | 7 | a | On the relationship with Portuguese in Macao, written by anonymous author. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093762 | 24093762 | |
37890 | 37890 | 1921-11-19 | 8 | a | Jokes about communist propaganda in China that is instigated by Lenin's Soviet Russian government. | China | http://trove.nla.gov.au/newspaper/page/24093765 | 24093765 |
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]);