ftp://ftp.ibge.gov.br/Censos/Censo_Demografico_2010/Resultados_do_Universo/Agregados_por_Setores_Censitarios/
unzip -jn resultados\ do\ universo/agregados\ por\ setor\ censitário/*.zip *.csv -d .
cat Basico_AC.csv > basico.csv
tail -n+1 Basico_AL.csv >> basico.csv
tail -n+1 Basico_AM.csv >> basico.csv
tail -n+1 Basico_AP.csv >> basico.csv
tail -n+1 Basico_BA.csv >> basico.csv
tail -n+1 Basico_CE.csv >> basico.csv
tail -n+1 Basico_DF.csv >> basico.csv
tail -n+1 Basico_ES.csv >> basico.csv
tail -n+1 Basico_GO.csv >> basico.csv
tail -n+1 Basico_MA.csv >> basico.csv
tail -n+1 Basico_MG.csv >> basico.csv
tail -n+1 Basico_MS.csv >> basico.csv
tail -n+1 Basico_MT.csv >> basico.csv
tail -n+1 Basico_PA.csv >> basico.csv
tail -n+1 Basico_PB.csv >> basico.csv
tail -n+1 Basico_PE.csv >> basico.csv
tail -n+1 Basico_PI.csv >> basico.csv
tail -n+1 Basico_PR.csv >> basico.csv
tail -n+1 Basico_RJ.csv >> basico.csv
tail -n+1 Basico_RN.csv >> basico.csv
tail -n+1 Basico_RO.csv >> basico.csv
tail -n+1 Basico_RR.csv >> basico.csv
tail -n+1 Basico_RS.csv >> basico.csv
tail -n+1 Basico_SC.csv >> basico.csv
tail -n+1 Basico_SE.csv >> basico.csv
tail -n+1 Basico_SP1.csv >> basico.csv
tail -n+1 Basico_SP2.csv >> basico.csv
tail -n+1 Basico_TO.csv >> basico.csv
cat Domicilio01_AC.csv > domicilio01.csv
tail -n+1 Domicilio01_AL.csv >> domicilio01.csv
tail -n+1 Domicilio01_AM.csv >> domicilio01.csv
tail -n+1 Domicilio01_AP.csv >> domicilio01.csv
tail -n+1 Domicilio01_BA.csv >> domicilio01.csv
tail -n+1 Domicilio01_CE.csv >> domicilio01.csv
tail -n+1 Domicilio01_DF.csv >> domicilio01.csv
tail -n+1 Domicilio01_ES.csv >> domicilio01.csv
tail -n+1 Domicilio01_GO.csv >> domicilio01.csv
tail -n+1 Domicilio01_MA.csv >> domicilio01.csv
tail -n+1 Domicilio01_MG.csv >> domicilio01.csv
tail -n+1 Domicilio01_MS.csv >> domicilio01.csv
tail -n+1 Domicilio01_MT.csv >> domicilio01.csv
tail -n+1 Domicilio01_PA.csv >> domicilio01.csv
tail -n+1 Domicilio01_PB.csv >> domicilio01.csv
tail -n+1 Domicilio01_PE.csv >> domicilio01.csv
tail -n+1 Domicilio01_PI.csv >> domicilio01.csv
tail -n+1 Domicilio01_PR.csv >> domicilio01.csv
tail -n+1 Domicilio01_RJ.csv >> domicilio01.csv
tail -n+1 Domicilio01_RN.csv >> domicilio01.csv
tail -n+1 Domicilio01_RO.csv >> domicilio01.csv
tail -n+1 Domicilio01_RR.csv >> domicilio01.csv
tail -n+1 Domicilio01_RS.csv >> domicilio01.csv
tail -n+1 Domicilio01_SC.csv >> domicilio01.csv
tail -n+1 Domicilio01_SE.csv >> domicilio01.csv
tail -n+1 Domicilio01_SP1.csv >> domicilio01.csv
tail -n+1 Domicilio01_SP2.csv >> domicilio01.csv
tail -n+1 Domicilio01_TO.csv >> domicilio01.csv
- "basico":
create table basico (Cod_setor text primary key,Cod_Grandes Regiões text ,Nome_Grande_Regiao text ,Cod_UF text ,Nome_da_UF text ,Cod_meso text ,Nome_da_meso text ,Cod_micro text ,Nome_da_micro text ,Cod_RM text ,Nome_da_RM text ,Cod_municipio text ,Nome_do_municipio text ,Cod_distrito text ,Nome_do_distrito text ,Cod_subdistrito text ,Nome_do_subdistrito text ,Cod_bairro text ,Nome_do_bairro text ,Situacao_setor text ,Tipo_setor text ,V001 number ,V002 number ,V003 number ,V004 number ,V005 number ,V006 number ,V007 number ,V008 number ,V009 number ,V010 number ,V011 number ,V012 number )