Subnets should be searched in subnet_all view with normalized IP's converted to binary form like this:
sqlite> select country_code, country_name, continent_code, continent_name from subnet_all where start <= X'291324F3' and `end` >= X'291324F3';`
ZA|South Africa|AF|Africa