Skip to content

Instantly share code, notes, and snippets.

Crime Count
LARCENY/THEFT 480448
OTHER OFFENSES 309358
NON-CRIMINAL 238323
ASSAULT 194694
VEHICLE THEFT 126602
DRUG/NARCOTIC 119628
VANDALISM 116059
WARRANTS 101379
BURGLARY 91543
Date PdDistrict DISORDERLY CONDUCT DRUNKENNESS Total
2003 BAYVIEW 76 32 399785
2003 CENTRAL 109 118 300076
2003 INGLESIDE 34 44 272713
2003 MISSION 190 82 226255
2003 NORTHERN 181 55 221000
2003 PARK 49 73 194180
2003 RICHMOND 26 25 191746
2003 SOUTHERN 157 134 166971
2003 TARAVAL 25 20 125479
PdDistrict,Total,ASSAULT,BURGLARY,DISORDERLY CONDUCT,DRIVING UNDER THE INFLUENCE,DRUG/NARCOTIC,DRUNKENNESS,LARCENY/THEFT,PROSTITUTION,ROBBERY,STOLEN PROPERTY,TRESPASS,VANDALISM,VEHICLE THEFT,WEAPON LAWS
SOUTHERN,225747,30520,12187,1319,744,20557,2135,110634,691,9437,2586,3807,16952,11249,2929
NORTHERN,171220,20544,13979,1125,596,10518,809,78619,3994,6334,1783,2128,14179,14654,1958
MISSION,163737,28028,9406,2593,897,19081,1791,47143,7387,8714,1562,2909,13682,17111,3433
CENTRAL,138221,17226,10926,1029,401,3988,1194,69494,1869,5063,1418,2340,12134,9857,1282
BAYVIEW,115440,24212,9500,556,450,9737,568,26838,139,6265,943,1595,13759,16650,4228
TENDERLOIN,106447,18550,3465,1752,241,37769,985,24478,1998,5236,827,2663,4124,2351,2008
INGLESIDE,105600,21450,8007,368,510,5155,457,25281,78,6336,871,978,12912,20433,2764
TARAVAL,90329,13411,8612,372,540,3338,660,31271,414,3331,632,1082,11415,13887,1364
PARK,68108,8449,6975,601,417,5816,788,24831,18,2204,482,804,6426,9401,896
PdDistrict,Total,Year,ASSAULT,BURGLARY,DISORDERLY CONDUCT,DRIVING UNDER THE INFLUENCE,DRUG/NARCOTIC,DRUNKENNESS,LARCENY/THEFT,PROSTITUTION,ROBBERY,STOLEN PROPERTY,TRESPASS,VANDALISM,VEHICLE THEFT,WEAPON LAWS
BAYVIEW,8850.0,2003,1778.0,699.0,76.0,25.0,886.0,32.0,1729.0,11.0,364.0,40.0,84.0,780.0,2121.0,225.0
CENTRAL,8327.0,2003,1102.0,757.0,109.0,19.0,324.0,118.0,3480.0,70.0,270.0,82.0,179.0,553.0,1193.0,71.0
INGLESIDE,8281.0,2003,1747.0,573.0,34.0,15.0,364.0,44.0,1549.0,5.0,439.0,87.0,87.0,828.0,2319.0,190.0
MISSION,12125.0,2003,1758.0,691.0,190.0,37.0,2098.0,82.0,2767.0,713.0,491.0,103.0,196.0,763.0,2063.0,173.0
NORTHERN,12105.0,2003,1513.0,866.0,181.0,50.0,774.0,55.0,4548.0,581.0,417.0,107.0,152.0,868.0,1879.0,114.0
PARK,5148.0,2003,683.0,543.0,49.0,24.0,383.0,73.0,1543.0,2.0,140.0,34.0,57.0,338.0,1207.0,72.0
RICHMOND,4719.0,2003,646.0,458.0,26.0,30.0,146.0,25.0,1497.0,15.0,131.0,27.0,56.0,511.0,1081.0,70.0
SOUTHERN,14402.0,2003,1982.0,732.0,157.0,45.0,2052.0,134.0,5867.0,18.0,433.0,199.0,421.0,793.0,1426.0
PdDistrict,Category,Time,avg_crimes
BAYVIEW,ASSAULT,19,0.260110457865669
BAYVIEW,ASSAULT,17,0.259219668626403
BAYVIEW,ASSAULT,16,0.2535186174951007
BAYVIEW,ASSAULT,21,0.25209335471227506
BAYVIEW,ASSAULT,18,0.24763940851594513
BAYVIEW,ASSAULT,15,0.24247283092820238
BAYVIEW,ASSAULT,20,0.24051309460181722
BAYVIEW,ASSAULT,12,0.23641546410119366
BAYVIEW,ASSAULT,14,0.22928915018706575
ID,Date,Time,tweet,of_favorites,of_retweets,source
832016501657968640,2017-02-15,18:59:26,"Venezuela should allow Leopoldo Lopez, a political prisoner & husband of @liliantintori (just met w/ @marcorubio) o… https://t.co/HhgE51dtSN",111061,54251,iPhone
831979921555742720,2017-02-15,16:34:05,"Aetna CEO: Obamacare in 'Death Spiral' #RepealAndReplace
https://t.co/dmHL7xIEQv",59212,14676,iPhone
831952535544070144,2017-02-15,14:45:16,"Join me in Florida this Saturday at 5pm for a rally at the Orlando-Melbourne International Airport!
Tickets:… https://t.co/OigfXFECPp",72767,17978,iPhone
831945670324060160,2017-02-15,14:17:59,"Welcome to the United States, @IsraeliPM Benjamin & Sara!
#ICYMI🇺🇸🇮🇱Joint Press Conference:
https://t.co/GN6ALWUusN https://t.co/bH60nBL5FP",75099,14323,iPhone
831904516316479488,2017-02-15,11:34:27,Great listening session with CEO's of the Retail Industry Leaders Association this morning! https://t.co/sy6xJcWfcF,66648,10775,iPhone
Date Topic
2017-02-15 Venezuela Leopoldo Lopez <br> Aetna CEO Spiral <br> Florida Saturday International Airport <br> United States IsraeliPM Benjamin Sara <br> CEO Industry Leaders Association <br> Crimea Russia Obama Administration Was Obama Russia <br> Thank Eli Lake Bloomberg View NSA FBI USA <br> NSA FBI Russia <br> Hillary Clinton <br> MSNBC CNN
2017-02-14 Obamacare Humana Americans <br> President Trump Signing H.J Resolution <br> VP Pence Secretary BetsyDeVos <br> Washington Will N.Korea
2017-02-13 VASecretary Dr. David Shulkin Veterans <br> Congratulations Treasury Secretary Steven Mnuchin <br> PM JustinTrudeau CEO Canada🇨🇦and <br> WhiteHouse Prime Minister JustinTrudeau <br> Canadian PM Trudeau
2017-02-12 Florida Big FAKE NEWS <br> Stephen Miller- Sunday Great <br> Mark Cuban <br> Prime Minister Abe Japan L <br> FAKE NEWS CNN Bernie Sanders <br> U.S. COURT BREAKDOWN SYRIA IRAQ SOMALIA IRAN SUDAN LIBYA <br> Gang <br> ICYMI Prime Minister Shinzo Abe North Korea
2017-02-11 Prime Minis
Date Lat Lng
2017-02-05 47.605476 -122.332481
2017-02-05 43.648422 -79.375366
2017-02-05 32.714314 -117.166275
2017-02-05 36.117805 -115.06556699999999
2017-02-05 60.168388 24.933098
2017-02-05 51.606640000000006 -0.19833900000000002
2017-02-05 40.416939 -3.70246
2017-02-05 51.505390000000006 -0.107397
2017-02-05 6.472245 3.3398440000000003
ID,Date,Time,tweet,of_favorites,of_retweets,source
832375230274400256,2017-02-16,18:44:54,'Trump signs bill undoing Obama coal mining rule' https://t.co/yMfT5r5RGh,94462,18859,iPhone
832238070460186624,2017-02-16,09:39:52,"The Democrats had to come up with a story as to why they lost the election, and so badly (306), so they made up a story - RUSSIA. Fake news!",122171,27122,Android
832230758299340800,2017-02-16,09:10:49,"FAKE NEWS media, which makes up stories and ""sources,"" is far more effective than the discredited Democrats - but they are fading fast!",100119,20019,Android
832198588201594880,2017-02-16,07:02:59,The spotlight has finally been put on the low-life leakers! They will be caught!,127149,25366,Android
832197515248275456,2017-02-16,06:58:43,"Leaking, and even illegal classified leaking, has been a big problem in Washington for years. Failing @nytimes (and others) must apologize!",90466,17232,Android
832191485701451776,2017-02-16,06:34:46,Stock market hits new high with longest winning streak in
Date,Topic
2017-02-16, Obama <br> Democrats RUSSIA Fake <br> FAKE NEWS Democrats <br> Washington <br> Great
2017-02-15, Venezuela Leopoldo Lopez <br> Aetna CEO Spiral <br> Florida Saturday International Airport <br> United States IsraeliPM Benjamin Sara <br> CEO Industry Leaders Association <br> Crimea Russia Obama Administration Was Obama Russia <br> Thank Eli Lake Bloomberg View NSA FBI USA <br> NSA FBI Russia <br> Hillary Clinton <br> MSNBC CNN
2017-02-14, Obamacare Humana Americans <br> President Trump Signing H.J Resolution <br> VP Pence Secretary BetsyDeVos <br> Washington Will N.Korea
2017-02-13, VASecretary Dr. David Shulkin Veterans <br> Congratulations Treasury Secretary Steven Mnuchin <br> PM JustinTrudeau CEO Canada🇨🇦and <br> WhiteHouse Prime Minister JustinTrudeau <br> Canadian PM Trudeau
2017-02-12, Florida Big FAKE NEWS <br> Stephen Miller- Sunday Great <br> Mark Cuban <br> Prime Minister Abe Japan L <br> FAKE NEWS CNN Bernie Sanders <br> U.S. COURT BREAKDOWN SYRIA IRAQ SOMALIA IR