insert into {geo_states} (name, code, shortname, country_id) VALUES('Are'                  ,12 ,'AC', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Alagoas'	           ,27 ,'AL', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Amapá'                ,16 ,'AP', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Amazonas'             ,13 ,'AM', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Bahia'                ,29 ,'BA', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Ceará'                ,23 ,'CE', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Distrito Federal'     ,53 ,'DF', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Espírito Santo'       ,32 ,'ES', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Goiás'                ,52 ,'GO', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Maranhão'             ,21 ,'MA', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Mato Grosso'          ,51 ,'MT', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Mato Grosso do Sul'   ,50 ,'MS', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Minas Gerais'         ,31 ,'MG', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Pará'                 ,15 ,'PA', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Paraíba'	           ,25 ,'PB', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Paraná'               ,41 ,'PR', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Pernambuco'           ,26 ,'PE', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Piauí'                ,22 ,'PI', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Rio Grande do Norte'  ,24 ,'RN', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Rio Grande do Sul'    ,43 ,'RS', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Rio de Janeiro'       ,33 ,'RJ', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Rondônia'             ,11 ,'RO', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Roraima'              ,14 ,'RR', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Santa Catarina'       ,42 ,'SC', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('São Paulo'            ,35 ,'SP', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Sergipe'	           ,28 ,'SE', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
insert into {geo_states} (name, code, shortname, country_id) VALUES('Tocantins'            ,17 ,'TO', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));