Friday, February 22, 2019

Grad Cafe Results Search

Grad Cafe Entries : Admission Results pulled from GradCafe

This reports shows admission results pulled from GradCafe for the last month. It has three tabs :

  • Results By Institution/Program/Status/Date
  • A Sankey Diagram of Status By Institution
  • Distribution Of Results By Institution
The report has filters for Institution/Program/Status/Student Type and so on. To search for a particular Institution/Program , Type in the search box above the filter box and hit enter , (eg type "Texas" to search for all Institutions with Texas in the name)

Because most of the fields for entry are free text, there is a lot of variation in Institution and Program Names, I haven't done any work to merge the duplicates for now. So there will be duplicates and you'll need to use the search box and select from the resulting list, my apologies.

Data Source : Grad Cafe Results
Scraper : Python
Visualization : PowerBI
Last Update : 5:30 PM MST , 21-Mar-2019

Monday, February 11, 2019

Income Taxes - How they fall into the brackets

People are often confused about how their income is taxed. The tax slabs that one falls into is sometimes wrongly thought to be as absolute (as in I make X$ , and I fall into 25% bracket, so my taxes will be X * 0.25 ).Sometimes people mistakenly think making a little bit of more money will result in a larger tax burden, and hence refuse to get that promotion/bonus etc(this admittedly could be an urban legend). This plot illustrates how the taxes are actually distributed into the slabs for 2018 and 2019, and shows the effective tax rate and each Income Point.

Monday, December 10, 2018

Federal Firearms License (FFL) Registration Per Capita('000) by State

Federal Firearms License (FFL) Registration Per Capita('000) by State





The Bureau of Alcohol, Tobacco, Firearms and Explosives(ATF) defines a Federal Firearms License (FFL) as "an individual who is licensed to engage in the business of manufacturing, importing and/or dealing in firearms. Persons must be licensed by ATF to engage in the business of firearms". An FFL is classified further into 4 categories and several codes:


Type Code Description
Dealer 1 Dealer in Firearms Other Than Destructive Devices (Includes Gunsmiths)
2 Pawnbroker in Firearms Other Than Destructive Devices
9 Dealer in Destructive Devices
Manufacturer 6 Manufacturer of Ammunition for Firearms
7 Manufacturer of Firearms Other Than Destructive Devices
10 Manufacturer of Destructive Devices
Importer 8 Importer of Firearms Other Than Destructive Devices
11 Importer of Destructive Devices
Other 3 Collector of Curios and Relics




Data Source : Bureau of Alcohol, Tobacco, Firearms and Explosives
Dataset : Federal Firearms Listings by U.S. State / Territory

Friday, December 7, 2018

US Migration by Source and State

US Migration by Source and State - 2017





Dataset : 
US Migration Flows: 2017
Dataset: 2017 American Community Survey 1-Year Estimates

Source: U.S. Census Bureau, 2017 American Community Survey - https://census.gov/acs

Tuesday, December 4, 2018

US Presidencies


US Presidents by Presidency Starts, Terms and Post Presidency Years


George H.W. Bush, who died 30 Nov 2018 at age 94, was the longest-lived president in US history. Here's a look at the lifespans on all US presidents by Presidency Starts, Terms and Post Presidency Years.



John F. Kennedy was the youngest president to die at 46 years and 177 days. In fact JFK died before anyone his age at death has ever become president barring Theodore Roosevelt who became president at 42 years and 322 days.

The average life expectancy of the US Presidents is 71.44 years now , up from 70.86 after George H.W. Bush died. Republican presidents have 3 yr advantage over Democrat Presidents[ 71.80 years vs 68.82 years] .Life expectancy has been increasing dramatically for the presidents since LBJ died at 64. The last four deceased presidents(Nixon, Ford, Reagan and Bush 41) had an average age of 90.6 years at death.At this rate, Clinton , Bush 43 and Trump will probably be around for two more decades and Obama for a 3 and a half decades more.So much for it being a stressful job.

Here's a look at the States(State of Origin) that Presidents are from in a flow map in chronological order :




We need someone from the Non-California West or Mid-West to run in 2020. Vote for Pedro!



DataSource : 
Wikipedia  - https://en.wikipedia.org/wiki/List_of_presidents_of_the_United_States_by_age

Monday, December 3, 2018

Mortality By Weekday by State - 1999-2016





I downloaded the mortality data from the CDC website and plotted the data by state and by day of week the death was reported. I did the same for Deaths Of Despair[ Alcohol/Drug Related deaths, Self Inflicted Firearm related deaths, Depression related deaths]. There were no clear trends to be seen. Nevertheless, there are some interesting observations that can be made. Very few states have  Tuesdays , Wednesdays or Thursdays as leading days of mortality(Both All Cause and Deaths of Despair) which could be people "holding on" till the weekend before passing on. There are clusters of geographical areas which all have the same day of week as the leading day of mortality - for instance the contiguous cluster of  Oregon, Nevada, Utah, Colorado Wyoming, South Dakota and Minnesota all have Saturday as the leading day of all cause mortality and Utah, Colorado, Arizona, New Mexico and Texas have Sunday as the leading weekday for deaths of despair mortality.

Even though I have the leading days of mortality depicted on the maps, there is no significant difference in the numbers for each of the days when all causes are rolled up, as can be seen from the bar graph below :




There is slight increase in the number of deaths in the weekends , most of it is attributable to vehicular accidents :



California shows a noticeable uptick in deaths from vehicle accidents on Wednesdays :



So , if you live in California , stay home on the weekends and on Wednesdays.

Data Source and References :

Dataset: Underlying Cause of Death, 1999-2016
Citation: Centers for Disease Control and Prevention, National Center for Health Statistics. Underlying Cause of Death
1999-2016 on CDC WONDER Online Database, released December, 2017. Data are from the Multiple Cause of Death Files, 1999-2016, as
compiled from data provided by the 57 vital statistics jurisdictions through the Vital Statistics Cooperative Program.

Caveats:
1. Population and rates are labeled 'Not Applicable' when Autopsy, Place of Death, Weekday or Month are grouped by or limited,
due to lack of a valid population. More information: http://wonder.cdc.gov/wonder/help/ucd.html#NotApplicableRates.
2. As of April 3, 2017, the underlying cause of death has been revised for 125 deaths in 2014. More information:
http://wonder.cdc.gov/wonder/help/ucd.html#2014-Revision.
3. Death rates are flagged as Unreliable when the rate is calculated with a numerator of 20 or less. More information:
http://wonder.cdc.gov/wonder/help/ucd.html#Unreliable.
4. Changes to cause of death classification affect reporting trends. More information:
http://wonder.cdc.gov/wonder/help/ucd.html#ICD-10 Changes.

Grad Cafe Results Search

Grad Cafe Entries : Admission Results pulled from GradCafe This reports shows admission results pulled from GradCafe for the last month....