DBHunter
Infinity Member
Golden Member
- Joined
- August 23, 2025
- Messages
- 1,070
- Reaction score
- 1,191
- Points
- 113
- Thread Author
- #1
BRAZIL | DATASUS - 149.000.000 | DENATRAN - 104.000.000
DATASUS: is the IT department of SUS – the Brazilian Unified Health System. They provide data on health establishments, mortality, access to health services and several health indicators nationwide.
CPF (Individual Taxpayer Registry Number): A unique number for each Brazilian citizen used for tax purposes.
Pai (Father): Father's name.
Mae (Mother): Mother's name.
MunicipioNascimento (Birth Municipality): City of birth.
Municipio (Municipality): Current city of residence.
Logradouro (Street): Street address.
Numero (Number): House or building number.
Bairro (Neighborhood): Neighborhood name.
CEP (Postal Code): Postal code.
RgNumero (Identity Number): State identity card number.
RgOrgaoEmisor (Issuing Agency): Agency that issued the identity card.
RgUf (Identity Issuing State): State that issued the identity card.
RgDataEmissao (Issuance Date): Date when the identity card was issued.
CNS (National Health Card Number): A unique health identification number.
Telefone (Phone): Primary phone number.
TelefoneSecundario (Secondary Phone): Secondary phone number.
DENATRAN: also known as the National Traffic Department, is the main Brazilian body responsible for regulating and supervising all matters related to traffic in the country.
ID (Identification): Unique identifier for the record.
Data_Atualizacao (Update Date): Date of the latest update for the record.
Chassi (Chassis): Vehicle chassis number.
Placa (License Plate): Vehicle license plate number.
Faturado (Invoiced): Indicates if the vehicle was invoiced.
Ano_Fabricacao (Manufacture Year): Year the vehicle was manufactured.
Municipio (Municipality): City where the vehicle is registered.
Uf_Placa (License Plate State): State where the license plate was issued.
Marca_Modelo (Brand and Model): Brand and model of the vehicle.
Combustivel (Fuel): Type of fuel the vehicle uses.
Potencia (Power): Vehicle's power, typically in horsepower.
Capacidade_Carga (Load Capacity): Maximum load capacity of the vehicle, usually for trucks.
Nacionalidade (Nationality): Origin of the vehicle (domestic or imported).
Linha (Line): Category or line of the vehicle, e.g., sedan, SUV.
Carroceria (Body): Vehicle body type.
Caixa_Cambio (Gearbox): Type of transmission.
Eixo_Traseiro_Dif (Rear Axle Differential): Information about the rear axle differential.
Terceiro_Eixo (Third Axle): Indicates if the vehicle has a third axle.
Motor (Engine): Engine information or number.
Tipo_Doc_Faturado (Invoiced Document Type): Type of invoice document.
Uf_Faturado (Invoiced State): State where the vehicle was invoiced.
Tipo_Doc_Prop (Owner's Document Type): Type of the vehicle owner's document.
Ano_Modelo (Model Year): Model year of the vehicle.
Tipo_Veiculo (Vehicle Type): General type of the vehicle.
Especie_Veiculo (Vehicle Species): Specific classification of the vehicle, e.g., passenger, cargo.
Tipo_Carroceria (Body Type): Specific body type, e.g., sedan, coupe.
Cor_Veiculo (Vehicle Color): Color of the vehicle.
Quantidade_Passageiro (Passenger Quantity): Maximum number of passengers the vehicle can carry.
Situacao_Chassi (Chassis Situation): Status or condition of the chassis.
Eixos (Axles): Number of axles the vehicle has.
Tipo_Montagem (Assembly Type): How the vehicle was assembled, e.g., locally or imported as a unit.
Tipo_Doc_Importadora (Importer's Document Type): Type of document related to the importer.
Ident_Importadora (Importer's Identification): Identification of the importer.
DI (Import Declaration): Import declaration number.
Registro_DI (DI Registry): Registry related to the import declaration.
Unidade_Local_SRF (Local Tax Service Unit): Local unit of the Federal Revenue Service where the vehicle is registered.
Ultima_Atualizacao (Last Update): Date of the last update for the vehicle's data.
Restricao_1, Restricao_2, Restricao_3, Restricao_4 (Restrictions 1-4): Specific restrictions or annotations related to the vehicle.
Limite_Restricao_Trib (Tax Restriction Limit): Limitation related to tax restrictions.
Cilindradas (Displacement): Engine displacement, typically in cc (cubic centimeters).
Cap_Maxima_Tracao (Maximum Traction Capacity): Maximum traction capacity of the vehicle.
Peso_Bruto_Total (Total Gross Weight): Total allowable gross weight of the vehicle.
Situacao_Veiculo (Vehicle Situation): Current status or condition of the vehicle, e.g., active, stolen.
Placa_Modelo_Antigo (Old Plate Model): Previous license plate number if it was changed.
Placa_Modelo_Novo (New Plate Model): New license plate model or format.
Placa_Nova (New Plate): New license plate number MERCOSUL.
datasus and vehicles columns:
Code:
DATASUS: is the IT department of SUS – the Brazilian Unified Health System. They provide data on health establishments, mortality, access to health services and several health indicators nationwide.
CPF (Individual Taxpayer Registry Number): A unique number for each Brazilian citizen used for tax purposes.
Pai (Father): Father's name.
Mae (Mother): Mother's name.
MunicipioNascimento (Birth Municipality): City of birth.
Municipio (Municipality): Current city of residence.
Logradouro (Street): Street address.
Numero (Number): House or building number.
Bairro (Neighborhood): Neighborhood name.
CEP (Postal Code): Postal code.
RgNumero (Identity Number): State identity card number.
RgOrgaoEmisor (Issuing Agency): Agency that issued the identity card.
RgUf (Identity Issuing State): State that issued the identity card.
RgDataEmissao (Issuance Date): Date when the identity card was issued.
CNS (National Health Card Number): A unique health identification number.
Telefone (Phone): Primary phone number.
TelefoneSecundario (Secondary Phone): Secondary phone number.
DENATRAN: also known as the National Traffic Department, is the main Brazilian body responsible for regulating and supervising all matters related to traffic in the country.
ID (Identification): Unique identifier for the record.
Data_Atualizacao (Update Date): Date of the latest update for the record.
Chassi (Chassis): Vehicle chassis number.
Placa (License Plate): Vehicle license plate number.
Faturado (Invoiced): Indicates if the vehicle was invoiced.
Ano_Fabricacao (Manufacture Year): Year the vehicle was manufactured.
Municipio (Municipality): City where the vehicle is registered.
Uf_Placa (License Plate State): State where the license plate was issued.
Marca_Modelo (Brand and Model): Brand and model of the vehicle.
Combustivel (Fuel): Type of fuel the vehicle uses.
Potencia (Power): Vehicle's power, typically in horsepower.
Capacidade_Carga (Load Capacity): Maximum load capacity of the vehicle, usually for trucks.
Nacionalidade (Nationality): Origin of the vehicle (domestic or imported).
Linha (Line): Category or line of the vehicle, e.g., sedan, SUV.
Carroceria (Body): Vehicle body type.
Caixa_Cambio (Gearbox): Type of transmission.
Eixo_Traseiro_Dif (Rear Axle Differential): Information about the rear axle differential.
Terceiro_Eixo (Third Axle): Indicates if the vehicle has a third axle.
Motor (Engine): Engine information or number.
Tipo_Doc_Faturado (Invoiced Document Type): Type of invoice document.
Uf_Faturado (Invoiced State): State where the vehicle was invoiced.
Tipo_Doc_Prop (Owner's Document Type): Type of the vehicle owner's document.
Ano_Modelo (Model Year): Model year of the vehicle.
Tipo_Veiculo (Vehicle Type): General type of the vehicle.
Especie_Veiculo (Vehicle Species): Specific classification of the vehicle, e.g., passenger, cargo.
Tipo_Carroceria (Body Type): Specific body type, e.g., sedan, coupe.
Cor_Veiculo (Vehicle Color): Color of the vehicle.
Quantidade_Passageiro (Passenger Quantity): Maximum number of passengers the vehicle can carry.
Situacao_Chassi (Chassis Situation): Status or condition of the chassis.
Eixos (Axles): Number of axles the vehicle has.
Tipo_Montagem (Assembly Type): How the vehicle was assembled, e.g., locally or imported as a unit.
Tipo_Doc_Importadora (Importer's Document Type): Type of document related to the importer.
Ident_Importadora (Importer's Identification): Identification of the importer.
DI (Import Declaration): Import declaration number.
Registro_DI (DI Registry): Registry related to the import declaration.
Unidade_Local_SRF (Local Tax Service Unit): Local unit of the Federal Revenue Service where the vehicle is registered.
Ultima_Atualizacao (Last Update): Date of the last update for the vehicle's data.
Restricao_1, Restricao_2, Restricao_3, Restricao_4 (Restrictions 1-4): Specific restrictions or annotations related to the vehicle.
Limite_Restricao_Trib (Tax Restriction Limit): Limitation related to tax restrictions.
Cilindradas (Displacement): Engine displacement, typically in cc (cubic centimeters).
Cap_Maxima_Tracao (Maximum Traction Capacity): Maximum traction capacity of the vehicle.
Peso_Bruto_Total (Total Gross Weight): Total allowable gross weight of the vehicle.
Situacao_Veiculo (Vehicle Situation): Current status or condition of the vehicle, e.g., active, stolen.
Placa_Modelo_Antigo (Old Plate Model): Previous license plate number if it was changed.
Placa_Modelo_Novo (New Plate Model): New license plate model or format.
Placa_Nova (New Plate): New license plate number MERCOSUL.
datasus and vehicles columns:
Code:
Code:
"datasus" ([/B][/CENTER]
[B][CENTER]
"cpf" ,
"pai" ,
"mae" ,
"municipioNascimento" ,
"municipio" ,
"logradouro" ,
"numero" ,
"bairro" ,
"cep" ,
"rgNumero" ,
"rgOrgaoEmisor" ,
"rgUf" ,
"rgDataEmissao" ,
"cns" ,
"telefone" ,
"telefoneSecundario"
)
"vehicles" (
"id" ,
"data_atualiacao" ,
"chassi" ,
"placa" ,
"faturado" ,
"ano_fabricacao" ,
"municipio" ,
"uf_placa" ,
"marca_modelo" ,
"combustivel" ,
"potencia" ,
"capacidade_carga" ,
"nacionalidade" ,
"linha" ,
"carroceria" ,
"caixa_cambio" ,
"eixo_traseiro_dif" ,
"terceiro_eixo" ,
"motor" ,
"tipo_doc_faturado" ,
"uf_faturado" ,
"tipo_doc_prop" ,
"ano_modelo" ,
"tipo_veiculo" ,
"especie_veiculo" ,
"tipo_carroceria" ,
"cor_veiculo" ,
"quantidade_passageiro" ,
"situacao_chassi" ,
"eixos" ,
"tipo_montagem" ,
"tipo_doc_importadora" ,
"ident_importadora" ,
"di" ,
"registro_di" ,
"unidade_local_srf" ,
"ultima_atualizacao" ,
"restricao_1" ,
"restricao_2" ,
"restricao_3" ,
"restricao_4" ,
"limite_restricao_trib" ,
"cilindradas" ,
"cap_maxima_tracao" ,
"peso_bruto_total" ,
"situacao_veiculo" ,
"placa_modelo_antigo" ,
"placa_modelo_novo" ,
"placa_nova"Two samples of table datasus and table vehicles:
Code:
Code:
60070962030|ROGER FERREIRA|GLAUCIA TATIANE REIS CORREA|PORTO ALEGRE - RS|PORTO ALEGRE - RS|HENRIQUE FRAEB|137|PARTENON|90.660-270|||||701701244833270|51:8466-7365|51:99950-7676
01779145560|IRINEU MANOEL FREIRE|EULINA LARANJEIRA DE SOUZA|RUY BARBOSA - BA|UTINGA - BA|PRESIDENTE KENEDY|S/N|PONTE DE TABUA|46.810-000|||||700203449066229|77:99992-7638|
617351155|2012-11-06 00:00:00|9BWCA05X95T079096|KAL6596||2004|9067|MT|115744|2|67|0|1|38352442|||||AZN221073|2|MT|1|2005|6|1|999|4|5|N|2|1|0||0||0000000|1998-05-29 00:00:00|3|0|0|0||999|160|140|S|KAL6596|KAL6F96|f
670334715|2016-05-02 00:00:00|9C2KC1670FR559809|QEM6892|84189950000104|2016|447|PA|2886|16|0|0|1|66054225|||||KC16E7F559819|2|PA|1|2015|4|1|999|4|2|N|0|1|||0||0000000|2016-05-02 00:00:00|3|0|0|0||149|0|29|S|QEM6892|QEM6I92|fUNIQUE records on datasus table: 149.912.930 (persons)
records on table vehicles table: 104.193.161 (cars)
Archive name: database.7z
File name: database.sqlite
Compressed size: 12,8 GiB
Uncompressed size: 63,6 GiB
SHA-512 Checksum for integrity check: 1fa4e80c8c2cb2a9464ede8c6cdfd1c6e272b48a920029974ab001ea46f77545
Download Link :
