Monday, January 27, 2020

Kobe Bryant Crash Data and Some Conclusions


I have concluded by examining the Kobe Bryant crash data that the Sikorsky N72EX transporting Kobe Bryant and his guests took a violent tumble out of the sky inside a narrow 13 second window spanning about a half mile of descent. During that time, the aircraft plummeted at least 750' with increasing downward vertical acceleration typical of an object under mechanical failure approaching terminal velocity or 'free fall'. Given the described experience of the pilot, the pilot's knowledge of the terrain and the reputed 'bulletproof' (link now private and also here) reputation of this particular helicopter, my best guess is that plane was shot down with a shoulder armed missile (e.g. 'manpad') equipped with data link and/or infrared tracking,  a proximity fuse and a large field fragmentation warhead. For some examples and information on how shoulder armed missiles are deployed and have been used against civilian aircraft see (1, 2, 3, 4, 5 ,6, 7, 8). 

I have little or no domain knowledge for my supposition. I understand that I am looking at ADS data. I  understand that ADS data uses "pressure altitude" readings that can need correction for true altitudeBelow are some data and graphs from  data from Flight Radar 24 on the Kobe Bryant crash. Please make a comment if you see an inaccurate statement. The granular data looks like this in rdata.table:

Friday, January 17, 2020

Some notes on using Greek Symbols in R for variables and inserting Unicode symbols as text

From SO https://stackoverflow.com/questions/59105619/insert-specific-unicode-symbols-inside-values-of-data-frame-variable/59763650#59763650

"If you are on Windows 10 recently updated with as of April 2018 Update: Use the Windows key + '.' (e.g. hold together Windows Key plus period) in your text editor. This brings up Microsoft Emoji keyboard. Select the Greek letters variable for your script. The R Console will not accept the Greek letters as variables directly but only the from the editor script. Some of the Greek letters don't translate to English (like "µ" or "ß".) You can paste and copy them from ls() output to access. You may be able to use some math symbols as well for variable names. I can't however, get this to work with source(). That must be a text encoding problem." Click to enlarge chart.



Sunday, September 29, 2019

Google geo-location data: rdata.table code and Google Earth screen shots

Below are some R console pictures from some work I have being doing with my five years for Google data location history. I have looked for other open source routines that analyze this type of data with rdata.table but had no luck.  I have placed my code here: https://github.com/rferrisx/Surveillance_Capitalism.  Code development is ongoing.

I am bit gob-smacked at the frequency and accuracy of Google's geo-location data logging. But on a technical level, I don't know why I should be. There is a lot of discussion about this regarding law enforcement, intelligence community and commercial use of this data. (There is also a simultaneous discussion of hacked cellular routing protocols like ss7.)  I am still trying to decide if this is good or bad or just the world as it is now and will be forevermore. For now, "comprehensive" is my best description of Google's location data. Click to enlarge charts and screenshots. Plotting your positions on Google Earth Pro requires the aggregation or subsetting appropriate to a 2500 lat/lon position limit.

Thursday, August 8, 2019

Ballot Returns by Status Date for 2018 Primary for BE,KP,TH,WM,YA


Election date for the charts below is 08/07/2018. In the "stampless ballot" era, the largest returns are often the day after the election. Drop boxes are probably fully collected but certainly locked by 8PM on election day.  Mail in ballots sent Monday and Tuesday flow to postal collection centers (e.g. Seattle), receive a postmark in the evening and return the next day or the day after as mail is not necessarily delivered to County Elections offices on Tuesday. County election departments can 'process and then tabulate' a fixed amount each day at given labor/machine capacities. Thus, two days after the election is over, some counties are still processing ballots that are part of classical election returns  and not part of certification period "curing" of previously rejected (e.g. challenged) ballots. Click to enlarge charts.

2018 Primary Ballot Returns  by StatusDate for BE, KP, TH, WM, YA. Election Date was 08/07/2018.

2018 Primary Return Data came from multiple voting systems. Click to Enlarge.

Saturday, July 27, 2019

Some PDC Contribution queries: Lovelett vs Blackwood 40th LD as of July 27 2019

 Some (limited) PDC Contribution queries: Lovelett vs Blackwood 40th LD as of July 27 2019 . Data from  https://data.wa.gov/Politics/Contributions-to-Candidates-and-Political-Committe/kv7h-kjye  below the break. These numbers can change quickly with new reporting. Make sure to understand how I have limited the queries. -RMF

Sunday, July 14, 2019

Divining come and gone voters from two different data slices four months apart

# Divining come and gone voters from two different data slices four months apart
# Set proper paths for your data and data sets
# fread chokes on too many columns thus a workaround with rbind
# RMF 07/14/2019
# This is designed to be memory efficient non SQL

library(data.table)
library(lubridate)
library(lattice)