tables/list_columns.md

In voltdatalab/crossfire: Extract data of Fogo Cruzado's repository of shootings in Brazil

Occurrences - columns names and description

In the following table, the user can find a description for each column of the API request from the get_fogocruzado function.

| | COLUMN | DESCRIPTION | |:---:|:---------------------------------------:|:----------------------------------------------------------------------------------------------------------------------------------------------------------------:| | 1 | id_ocorrencia | Occurrence's ID | | 2 | local_ocorrencia | Occurrence's address | | 3 | latitude_ocorrencia | Occurrence's latitude | | 4 | longitude_ocorrencia | Occurrence's longitude | | 5 | data_ocorrencia | Occurrence's date | | 6 | hora_ocorrencia | Occurrence's time | | 7 | presen_agen_segur_ocorrencia | Shows if there were or security forces in the area or not at the occurrence | | 8 | qtd_morto_civil_ocorrencia | N. of civilians killed in the occurence | | 9 | qtd_morto_agen_segur_ocorrencia | N. of security forces personnel killed in the occurence | | 10 | qtd_ferido_civil_ocorrencia | N. of civilians injured in the occurrence | | 11 | qtd_ferido_agen_segur_ocorrencia | N. of security forces personnel injured in the occurence | | 12 | estado_id | State's ID | | 13 | cidade_id | Municipality's ID | | 14 | nome_cidade | Municipality's name | | 15 | cod_ibge_cidade | Municipality's IBGE code | | 16 | gentilico_cidade | Municipality's gentilic | | 17 | populacao_cidade | Municipality's population | | 18 | area_cidade | Municipality's area | | 19 | densidade_demo_cidade | Municipality's population density | | 20 | nome_estado | State's name | | 21 | uf_estado | State's name abbreviation | | 22 | cod_ibge_estado | State's IBGE code | | 23 | homem_qtd_mortos_oc | N. of men killed | | 24 | homem_qtd_feridos_oc | N. of men injured | | 25 | mulher_qtd_mortos_oc | N. of women killed | | 26 | mulher_qtd_feridos_oc | N. of women injured | | 27 | chacina_oc | Is the occurrence related to a slaughter ("chacina")? | | 28 | chacina_qtd_mortos_oc | N. of civilians killed in the slaughter ("chacina") | | 29 | chacina_unidades_policiais_oc | N. of police units involved in the slaughter ("chacina"), if there are any | | 30 | ag_seguranca_vitima_oc | Whether any security forces agents were shot | | 31 | ag_seguranca_mortos_status_oc | Whether the security forces killed were on duty, out of service or retired/fired | | 32 | ag_seguranca_feridos_status_oc | Whether the security forces injured were on duty, out of service or retired/fired | | 33 | bala_perdida_oc | Is the occurrence related to a stray bullet case? | | 34 | bala_perdida_qtd_mortos_oc | N. of people killed by this stray bullet case | | 35 | bala_perdida_qtd_feridos_oc | N. of people injured by this stray bullet case | | 36 | interior_residencia_oc | Were the gunfires shot inside houses or in backyards? Were they shot from outside the house but hit inside them? | | 37 | interior_residencia_qtd_mortos_oc | N. of people killed by gunfires inside residences | | 38 | interior_residencia_qtd_feridos_oc | N. of people injured by gunfires inside residences | | 39 | imediacao_ensino_oc | Were the gunfires shot from inside educational units (day care centers, schools and universities) or in their surroundings. | | 40 | imediacao_ensino_qtd_mortos_oc | N. of people killed in educational units or their surroundings. | | 41 | imediacao_ensino_qtd_feridos_oc | N. of people injured in educational units or their surroundings. | | 42 | vitima_crianca_oc | Were there any children (0 to 12 incomplete years old) among the people who were shot? | | 43 | vitima_crianca_qtd_mortos_oc | N. of children killed | | 44 | info_adicional_crianca_morto | Other characteristics from the occurrence in which the victim was shot | | 45 | vitima_crianca_qtd_feridos_oc | N. of children injured | | 46 | info_adicional_crianca_ferido | Other characteristics from the occurrence in which the injured victim was shot | | 47 | vitima_adolescente_oc | Were there any teenagers (12 to 18 incomplete years old) among the people who were shot? | | 48 | vitima_adolescente_qtd_mortos_oc | N. of teenagers killed | | 49 | info_adicional_adolescente_morto | Other characteristics from the occurrence in which the victim was shot | | 50 | vitima_adolescente_qtd_feridos_oc | N. of teenagers injured | | 51 | info_adicional_adolescente_ferido | Other characteristics from the occurrence in which the injured victim was shot | | 52 | vitima_idoso_oc | Were there any elderly people (over 60 years old) among the people who were shot? | | 53 | vitima_idoso_qtd_mortos_oc | N. of elderly killed | | 54 | info_adicional_idoso_morto | Other characteristics from the occurrence in which the victim was shot | | 55 | vitima_idoso_qtd_feridos_oc | N. of elderly injured | | 56 | info_adicional_idoso_ferido_oc | Other characteristics from the occurrence in which the injured victim was shot | | 57 | informacao_transporte_oc | Was there a full interruption or partial suspension on the circulation of public transportation? | | 58 | descricao_transporte_interrompido_oc | Name of the public transportation which was suspended | | 59 | data_interrupcao_transporte_oc | Time of the interruption | | 60 | data_liberacao_transporte_oc | Time when the services where restarted | | 61 | informacao_via_oc | Was there a full interruption or partial suspension on the circulation of streets? | | 62 | descricao_via_interrompida_oc | Name of the street which was closed | | 63 | data_interrupcao_via_oc | Time of the interruption | | 64 | data_liberacao_via_oc | Time when the services where restarted | | 65 | outros_recortes | Others - List of cases' categorizations, which are followed by Fogo Cruzado's staff, which do not have specific columns | | 66 | motivo_principal | Probable reason for the gunshots - based on information from the press, police or trustworthy sources | | 67 | motivo_complementar | Probable reason for the gunshots (if there's more than one) - based on information from the press, police or trustworthy sources |

voltdatalab/crossfire documentation built on Oct. 30, 2023, 7:11 p.m.