Skip to content

Akash-chowrasia/Baltimore-City-Crime-Analysis

Repository files navigation

A case study on crime dataset of

“city of Baltimore, Maryland(USA)”

using Big Data Analytics with pig



Abstract:- In the information era, enormous amounts of data have become available on hand of data analysts to analyze in the form of datasets which are not only big, but also high in variety and velocity, using these analysis reports Now, human society is making many types of counter measures in the field of medical, weather, crime and many more. The case study on “crime dataset” found on keggle.com specifying some threats and wanted places in “city of Baltimore, Maryland(USA)” where, there is a need of some extra counter measures against some criminal activity.

Dataset Name: Baltimore.csv
  • This is the dataset of the city "BALTIMORE" and its nearest places of state "Maryland" in United-State.
  • Total records : 276530
  • Total columns: 15
  • Column Names:(sno, crime_date, crime_time, crime_code, address, description, Indoor/Outdoor, weapon, post, district, neighbourhood, longitude, attitude, premesis, totalIncidents)
  • This dataset contains crime record from 2012-10- 01 to 2017-09-02.
  • There are total 18 different categories of crime description according to USA rules is involved in the dataset. some of them are as follows:-
    • Homicide:- act of one human killing other or the volitional act by any people leads to death of any people. This may result from accident, reckless or negligent acts even if there is no intent to cause harm.
    • Auto-theft:- robbery of any vehicle.
    • Assault by threat:- A person commits assault by threat if he or she intentionally threatens another person with imminent bodily injury.
    • Burglary:- Entering any building against the law intentionally for the act of any crime( even if the crime is not performed) is called burglary.
    • Common assault:- unlawful violence by any people to apprehend( catching pr arresting) any criminal or a person who violated the law.
    • Larceny:- Taking of the personal property of any other person or business.
    • Arson:- Arson means intentionally burning of other things like building, motor vehicles, forest or any property.
    • Rape:-physical harassment given to any female.
  • Go to the original Dataset:
  • Go to the updated Dataset:
Sample Dataset
1,2017-09-02,1111-11-11 23:30:00,3JK,4200 AUDREY AVE,ROBBERY-RESIDENCE,I,KNIFE,913,SOUTHERN,Brooklyn,-76.60541,39.22951,ROW/TOWNHO,1


2,2017-09-02,1111-11-11 23:00:00,7A,800 NEWINGTONAVE,AUTO THEFT, O,, 133, CENTRAL, Reservoir Hill,-76.63217,39.3136,STREET,1


3,2017-09-02,1111-11-11 22:53:00,9S,600 RADNOR AV,SHOOTING,Outside,FIREARM,524,NORTHERN,Winston-Govans,-76.60697,39.34768,Street,1


4,2017-09-02,1111-11-11 22:50:00,4C,1800 RAMSAYST,AGG. ASSAULT,I,OTHER,934, SOUTHERN,Carrollton Ridge,-76.64526,39.28315,ROW/TOWNHO,1


5,2017-09-02,1111-11-11 22:31:00,4E,100 LIGHTST,COMMON ASSAULT, O, HANDS,113,CENTRAL,Downtown West,-76.61365,39.28756,STREET,1


6,2017-09-02,1111-11-11 22:00:00,5A,CHERRYCRESTRD, BURGLARY, I,, 922, SOUTHERN, Cherry Hill,-76.62131,39.24867,ROW/TOWNHO,1


7,2017-09-02,1111-11-11 21:15:00,1F,3400 HARMONYCT, HOMICIDE, Outside,FIREARM,232,SOUTHEASTERN,Canton,-76.56827,39.28202,Street,1


8,2017-09-02,1111-11-11 21:35:00,3B,400 W LANVALEST,ROBBERY - STREET,O,,123,CENTRAL,Upton,-76.62789,39.30254,STREET,1



Thank you

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published