from Hacker News

Health Statistics of 500 US Cities – Map and Sortable Table

by hrodriguez on 3/4/17, 3:06 PM with 25 comments

• by rodionos on 3/4/17, 9:36 PM

  CDC 500 Stats in tabular format. Top-25 by each metric:

  https://apps.axibase.com/chartlab/1e6f3425

  As for obesity, Philadelphia no longer keeps the crown:

    | city         | state        | metric | population | 
    |--------------|--------------|--------|------------| 
    | Dallas       | Texas        | 27.6   | 1197816    | 
    | Houston      | Texas        | 27.3   | 2099451    | 
    | Philadelphia | Pennsylvania | 27.2   | 1526006    | 
    | San Antonio  | Texas        | 26.1   | 1327407    | 
    | Chicago      | Illinois     | 25.4   | 2695598    | 
    | Phoenix      | Arizona      | 23.8   | 1445632    | 
    | Los Angeles  | California   | 21.1   | 3792621    | 
    | New York     | New York     | 21.1   | 8175133    | 
    | San Diego    | California   | 18.0   | 1307402    | 
  
    > SELECT t1.tags.cityname as 'city', t1.tags.statedesc as 'state', t1.value as   'metric', t2.value as 'population'
      FROM 'cdc.nccd.data_value' t1
      JOIN 'cdc.nccd.populationcount' t2
    WHERE t1.tags.short_question_text = 'Obesity' AND t1.tags.datavaluetypeid = 'CrdPrv'
      AND t2.value > 1000000
      ORDER BY t1.value DESC

• by notadoc on 3/4/17, 6:25 PM

  Obesity is through the roof, people over eat like crazy and don't move around enough.

  How much of our nations skyrocketing health care costs are directly and indirectly related to obesity? Probably a stunningly high percentage.

• by digitalzombie on 3/4/17, 7:10 PM

  Ugh... ESRI, is the one reason why I didn't get into Geography. I wanted get into datascience that lean toward maps but seeing the monopoly that ESRI has and no open source alternative it was clear, in my opinion, that that market growth is will be slow and the potential will not be as great.

  I'm leaning toward medical data and NLP now.

• by Exuma on 3/4/17, 9:29 PM

  I always wonder how it's humanly possible to make a website so hideous, ugly, and janky.

  I mean really... I think it would actually be difficult to make something as nasty as this site. It's a special skill to find the worst looking gif in existence, icons, text, colors, margins, 1% JPG images...........

• by snowpanda on 3/4/17, 6:18 PM

  Wow the bay area scores pretty bad on all of them.

• by gregshap on 3/4/17, 8:20 PM

  that spinner...