This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50542 | 50542 | 1931-07-25 | 5 | a | Hong Kong news/ Guangdong confronts the Nanjing government and their preparation. Zhongshan businessmen in Hong Kong protest against the land bureau director in their home town for land disputes. Street beggars to be collected. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090462 | 24090462 | |
50543 | 50543 | 1931-07-25 | 5 | b | Zhan Tianyou and the bronze statue of Chinese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090462 | 24090462 | |
50544 | 50544 | 1931-07-25 | 5 | d | Dongguan county authority in Guangdong has new method to examine all prostitutes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090462 | 24090462 | |
50545 | 50545 | 1931-07-25 | 5 | e | Japanese women and the waitress. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090462 | 24090462 | |
50546 | 50546 | 1931-07-25 | 5 | e | Comments on the international trade and reciprocities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090462 | 24090462 |
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]);