Skip to content

Instantly share code, notes, and snippets.

@syntagmatic
Created June 22, 2018 23:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save syntagmatic/fe65bf514b82e2e4252c3f449c97cf88 to your computer and use it in GitHub Desktop.
Save syntagmatic/fe65bf514b82e2e4252c3f449c97cf88 to your computer and use it in GitHub Desktop.
CDC Compressed Mortality: Age Group by Year
We can make this file beautiful and searchable if this error is corrected: It looks like row 254 should actually have 8 columns, instead of 1. in line 253.
"Notes" "Age Group" "Age Group Code" "Year" "Year Code" Deaths Population Crude Rate
"< 1 year" "1" "1999" "1999" 27937 3795762 736.0
"< 1 year" "1" "2000" "2000" 28035 3805648 736.7
"< 1 year" "1" "2001" "2001" 27568 4012658 687.0
"< 1 year" "1" "2002" "2002" 28034 3951461 709.5
"< 1 year" "1" "2003" "2003" 28025 3975871 704.9
"< 1 year" "1" "2004" "2004" 27936 4014258 695.9
"< 1 year" "1" "2005" "2005" 28440 4004393 710.2
"< 1 year" "1" "2006" "2006" 28527 4041738 705.8
"< 1 year" "1" "2007" "2007" 29138 4147997 702.5
"< 1 year" "1" "2008" "2008" 28059 4132735 678.9
"< 1 year" "1" "2009" "2009" 26412 4003587 659.7
"< 1 year" "1" "2010" "2010" 24586 3944153 623.4
"< 1 year" "1" "2011" "2011" 23985 3996537 600.1
"< 1 year" "1" "2012" "2012" 23629 3943077 599.3
"< 1 year" "1" "2013" "2013" 23440 3941783 594.7
"< 1 year" "1" "2014" "2014" 23215 3948350 588.0
"< 1 year" "1" "2015" "2015" 23455 3978038 589.6
"< 1 year" "1" "2016" "2016" 23161 3970145 583.4
"1-4 years" "1-4" "1999" "1999" 5249 15339782 34.2
"1-4 years" "1-4" "2000" "2000" 4979 15370150 32.4
"1-4 years" "1-4" "2001" "2001" 5107 15285559 33.4
"1-4 years" "1-4" "2002" "2002" 4858 15477731 31.4
"1-4 years" "1-4" "2003" "2003" 4965 15616575 31.8
"1-4 years" "1-4" "2004" "2004" 4785 15771627 30.3
"1-4 years" "1-4" "2005" "2005" 4756 15913007 29.9
"1-4 years" "1-4" "2006" "2006" 4631 15897145 29.1
"1-4 years" "1-4" "2007" "2007" 4703 15977965 29.4
"1-4 years" "1-4" "2008" "2008" 4730 16138392 29.3
"1-4 years" "1-4" "2009" "2009" 4450 16240931 27.4
"1-4 years" "1-4" "2010" "2010" 4316 16257209 26.5
"1-4 years" "1-4" "2011" "2011" 4246 16165521 26.3
"1-4 years" "1-4" "2012" "2012" 4218 16056267 26.3
"1-4 years" "1-4" "2013" "2013" 4068 15926305 25.5
"1-4 years" "1-4" "2014" "2014" 3830 15928533 24.0
"1-4 years" "1-4" "2015" "2015" 3965 15929243 24.9
"1-4 years" "1-4" "2016" "2016" 4045 15956892 25.3
"5-9 years" "5-9" "1999" "1999" 3474 20606460 16.9
"5-9 years" "5-9" "2000" "2000" 3253 20549505 15.8
"5-9 years" "5-9" "2001" "2001" 3093 20173362 15.3
"5-9 years" "5-9" "2002" "2002" 3018 19872417 15.2
"5-9 years" "5-9" "2003" "2003" 2898 19620851 14.8
"5-9 years" "5-9" "2004" "2004" 2888 19454237 14.8
"5-9 years" "5-9" "2005" "2005" 2837 19389067 14.6
"5-9 years" "5-9" "2006" "2006" 2735 19544688 14.0
"5-9 years" "5-9" "2007" "2007" 2711 19714611 13.8
"5-9 years" "5-9" "2008" "2008" 2502 19929602 12.6
"5-9 years" "5-9" "2009" "2009" 2523 20182499 12.5
"5-9 years" "5-9" "2010" "2010" 2330 20348657 11.5
"5-9 years" "5-9" "2011" "2011" 2451 20334196 12.1
"5-9 years" "5-9" "2012" "2012" 2334 20475536 11.4
"5-9 years" "5-9" "2013" "2013" 2427 20570581 11.8
"5-9 years" "5-9" "2014" "2014" 2357 20519566 11.5
"5-9 years" "5-9" "2015" "2015" 2402 20487176 11.7
"5-9 years" "5-9" "2016" "2016" 2490 20429799 12.2
"10-14 years" "10-14" "1999" "1999" 4121 20213364 20.4
"10-14 years" "10-14" "2000" "2000" 4160 20528072 20.3
"10-14 years" "10-14" "2001" "2001" 4002 20978678 19.1
"10-14 years" "10-14" "2002" "2002" 4132 21261421 19.4
"10-14 years" "10-14" "2003" "2003" 4056 21415353 18.9
"10-14 years" "10-14" "2004" "2004" 3946 21411680 18.4
"10-14 years" "10-14" "2005" "2005" 3765 21212579 17.7
"10-14 years" "10-14" "2006" "2006" 3414 21033138 16.2
"10-14 years" "10-14" "2007" "2007" 3436 20841042 16.5
"10-14 years" "10-14" "2008" "2008" 3149 20706655 15.2
"10-14 years" "10-14" "2009" "2009" 3128 20660564 15.1
"10-14 years" "10-14" "2010" "2010" 2949 20677194 14.3
"10-14 years" "10-14" "2011" "2011" 2950 20704852 14.2
"10-14 years" "10-14" "2012" "2012" 2866 20669218 13.9
"10-14 years" "10-14" "2013" "2013" 2913 20650454 14.1
"10-14 years" "10-14" "2014" "2014" 2893 20671506 14.0
"10-14 years" "10-14" "2015" "2015" 3009 20622330 14.6
"10-14 years" "10-14" "2016" "2016" 3013 20618233 14.6
"15-19 years" "15-19" "1999" "1999" 13778 20084602 68.6
"15-19 years" "15-19" "2000" "2000" 13563 20219890 67.1
"15-19 years" "15-19" "2001" "2001" 13555 20456284 66.3
"15-19 years" "15-19" "2002" "2002" 13812 20610370 67.0
"15-19 years" "15-19" "2003" "2003" 13595 20797166 65.4
"15-19 years" "15-19" "2004" "2004" 13706 21102552 64.9
"15-19 years" "15-19" "2005" "2005" 13703 21486214 63.8
"15-19 years" "15-19" "2006" "2006" 13739 21807709 63.0
"15-19 years" "15-19" "2007" "2007" 13299 22067816 60.3
"15-19 years" "15-19" "2008" "2008" 12407 22210880 55.9
"15-19 years" "15-19" "2009" "2009" 11520 22192810 51.9
"15-19 years" "15-19" "2010" "2010" 10887 22040343 49.4
"15-19 years" "15-19" "2011" "2011" 10594 21644043 48.9
"15-19 years" "15-19" "2012" "2012" 10074 21360702 47.2
"15-19 years" "15-19" "2013" "2013" 9480 21158964 44.8
"15-19 years" "15-19" "2014" "2014" 9586 21067647 45.5
"15-19 years" "15-19" "2015" "2015" 10186 21108903 48.3
"15-19 years" "15-19" "2016" "2016" 10812 21129999 51.2
"20-24 years" "20-24" "1999" "1999" 16878 18591429 90.8
"20-24 years" "20-24" "2000" "2000" 17744 18964001 93.6
"20-24 years" "20-24" "2001" "2001" 18697 19757286 94.6
"20-24 years" "20-24" "2002" "2002" 19234 20243765 95.0
"20-24 years" "20-24" "2003" "2003" 19973 20591688 97.0
"20-24 years" "20-24" "2004" "2004" 19715 20845560 94.6
"20-24 years" "20-24" "2005" "2005" 20531 20959955 98.0
"20-24 years" "20-24" "2006" "2006" 21148 21036135 100.5
"20-24 years" "20-24" "2007" "2007" 20683 21077999 98.1
"20-24 years" "20-24" "2008" "2008" 19791 21180612 93.4
"20-24 years" "20-24" "2009" "2009" 18896 21384122 88.4
"20-24 years" "20-24" "2010" "2010" 18664 21585999 86.5
"20-24 years" "20-24" "2011" "2011" 19073 22153832 86.1
"20-24 years" "20-24" "2012" "2012" 19108 22583203 84.6
"20-24 years" "20-24" "2013" "2013" 19006 22795438 83.4
"20-24 years" "20-24" "2014" "2014" 19205 22912174 83.8
"20-24 years" "20-24" "2015" "2015" 20308 22739313 89.3
"20-24 years" "20-24" "2016" "2016" 21763 22381028 97.2
"25-34 years" "25-34" "1999" "1999" 41066 40178406 102.2
"25-34 years" "25-34" "2000" "2000" 40451 39891724 101.4
"25-34 years" "25-34" "2001" "2001" 41683 39471522 105.6
"25-34 years" "25-34" "2002" "2002" 41355 39349646 105.1
"25-34 years" "25-34" "2003" "2003" 41300 39243795 105.2
"25-34 years" "25-34" "2004" "2004" 40868 39266556 104.1
"25-34 years" "25-34" "2005" "2005" 41925 39258647 106.8
"25-34 years" "25-34" "2006" "2006" 42952 39395179 109.0
"25-34 years" "25-34" "2007" "2007" 42572 39713463 107.2
"25-34 years" "25-34" "2008" "2008" 42275 40207473 105.1
"25-34 years" "25-34" "2009" "2009" 42502 40723342 104.4
"25-34 years" "25-34" "2010" "2010" 42259 41063948 102.9
"25-34 years" "25-34" "2011" "2011" 43748 41790498 104.7
"25-34 years" "25-34" "2012" "2012" 44591 42309321 105.4
"25-34 years" "25-34" "2013" "2013" 45463 42844587 106.1
"25-34 years" "25-34" "2014" "2014" 47177 43516504 108.4
"25-34 years" "25-34" "2015" "2015" 51517 44137202 116.7
"25-34 years" "25-34" "2016" "2016" 57616 44677243 129.0
"35-44 years" "35-44" "1999" "1999" 89256 45076677 198.0
"35-44 years" "35-44" "2000" "2000" 89798 45148527 198.9
"35-44 years" "35-44" "2001" "2001" 91674 45051752 203.5
"35-44 years" "35-44" "2002" "2002" 91140 44640649 204.2
"35-44 years" "35-44" "2003" "2003" 89461 44154206 202.6
"35-44 years" "35-44" "2004" "2004" 85362 43800275 194.9
"35-44 years" "35-44" "2005" "2005" 84785 43505538 194.9
"35-44 years" "35-44" "2006" "2006" 83043 43243801 192.0
"35-44 years" "35-44" "2007" "2007" 79606 42796230 186.0
"35-44 years" "35-44" "2008" "2008" 76370 42192486 181.0
"35-44 years" "35-44" "2009" "2009" 74665 41487811 180.0
"35-44 years" "35-44" "2010" "2010" 70033 41070606 170.5
"35-44 years" "35-44" "2011" "2011" 69893 40627954 172.0
"35-44 years" "35-44" "2012" "2012" 69162 40516420 170.7
"35-44 years" "35-44" "2013" "2013" 69573 40452690 172.0
"35-44 years" "35-44" "2014" "2014" 70996 40513133 175.2
"35-44 years" "35-44" "2015" "2015" 73088 40589783 180.1
"35-44 years" "35-44" "2016" "2016" 77792 40470156 192.2
"45-54 years" "45-54" "1999" "1999" 152974 36577819 418.2
"45-54 years" "45-54" "2000" "2000" 160341 37677952 425.6
"45-54 years" "45-54" "2001" "2001" 168065 39386268 426.7
"45-54 years" "45-54" "2002" "2002" 172385 39992194 431.0
"45-54 years" "45-54" "2003" "2003" 176781 40819954 433.1
"45-54 years" "45-54" "2004" "2004" 177697 41629930 426.8
"45-54 years" "45-54" "2005" "2005" 183530 42495904 431.9
"45-54 years" "45-54" "2006" "2006" 185031 43286159 427.5
"45-54 years" "45-54" "2007" "2007" 184686 43939939 420.3
"45-54 years" "45-54" "2008" "2008" 186542 44460447 419.6
"45-54 years" "45-54" "2009" "2009" 187568 44867088 418.1
"45-54 years" "45-54" "2010" "2010" 183207 45006716 407.1
"45-54 years" "45-54" "2011" "2011" 183247 44718203 409.8
"45-54 years" "45-54" "2012" "2012" 179463 44268738 405.4
"45-54 years" "45-54" "2013" "2013" 177724 43767532 406.1
"45-54 years" "45-54" "2014" "2014" 175917 43458851 404.8
"45-54 years" "45-54" "2015" "2015" 174494 43188161 404.0
"45-54 years" "45-54" "2016" "2016" 173516 42786679 405.5
"55-64 years" "55-64" "1999" "1999" 238979 23778026 1005.0
"55-64 years" "55-64" "2000" "2000" 240846 24274684 992.2
"55-64 years" "55-64" "2001" "2001" 244139 25105295 972.5
"55-64 years" "55-64" "2002" "2002" 253342 26703332 948.7
"55-64 years" "55-64" "2003" "2003" 262519 28008945 937.3
"55-64 years" "55-64" "2004" "2004" 264697 29305304 903.2
"55-64 years" "55-64" "2005" "2005" 275301 30641497 898.5
"55-64 years" "55-64" "2006" "2006" 281401 31930113 881.3
"55-64 years" "55-64" "2007" "2007" 287110 33128434 866.7
"55-64 years" "55-64" "2008" "2008" 296182 34157063 867.1
"55-64 years" "55-64" "2009" "2009" 303307 35405600 856.7
"55-64 years" "55-64" "2010" "2010" 310802 36482729 851.9
"55-64 years" "55-64" "2011" "2011" 323315 38062140 849.4
"55-64 years" "55-64" "2012" "2012" 329606 38586202 854.2
"55-64 years" "55-64" "2013" "2013" 338127 39316431 860.0
"55-64 years" "55-64" "2014" "2014" 348808 40077581 870.3
"55-64 years" "55-64" "2015" "2015" 357785 40877819 875.3
"55-64 years" "55-64" "2016" "2016" 366445 41463144 883.8
"65-74 years" "65-74" "1999" "1999" 452600 18418909 2457.3
"65-74 years" "65-74" "2000" "2000" 441209 18390986 2399.1
"65-74 years" "65-74" "2001" "2001" 430960 18384179 2344.2
"65-74 years" "65-74" "2002" "2002" 422990 18388535 2300.3
"65-74 years" "65-74" "2003" "2003" 413497 18500915 2235.0
"65-74 years" "65-74" "2004" "2004" 399666 18667533 2141.0
"65-74 years" "65-74" "2005" "2005" 398355 18881697 2109.7
"65-74 years" "65-74" "2006" "2006" 390093 19203027 2031.4
"65-74 years" "65-74" "2007" "2007" 389238 19698727 1976.0
"65-74 years" "65-74" "2008" "2008" 401579 20505679 1958.4
"65-74 years" "65-74" "2009" "2009" 401032 21233099 1888.7
"65-74 years" "65-74" "2010" "2010" 407151 21713429 1875.1
"65-74 years" "65-74" "2011" "2011" 415052 22481738 1846.2
"65-74 years" "65-74" "2012" "2012" 432346 23985392 1802.5
"65-74 years" "65-74" "2013" "2013" 454429 25216766 1802.1
"65-74 years" "65-74" "2014" "2014" 471541 26398290 1786.3
"65-74 years" "65-74" "2015" "2015" 495016 27550517 1796.8
"65-74 years" "65-74" "2016" "2016" 512080 28630330 1788.6
"75-84 years" "75-84" "1999" "1999" 698590 12224914 5714.5
"75-84 years" "75-84" "2000" "2000" 700445 12361180 5666.5
"75-84 years" "75-84" "2001" "2001" 701929 12593618 5573.7
"75-84 years" "75-84" "2002" "2002" 707654 12764864 5543.8
"75-84 years" "75-84" "2003" "2003" 703024 12896438 5451.3
"75-84 years" "75-84" "2004" "2004" 684230 12989903 5267.4
"75-84 years" "75-84" "2005" "2005" 686665 13074802 5251.8
"75-84 years" "75-84" "2006" "2006" 667338 13095151 5096.1
"75-84 years" "75-84" "2007" "2007" 652682 13087439 4987.1
"75-84 years" "75-84" "2008" "2008" 653560 13076102 4998.1
"75-84 years" "75-84" "2009" "2009" 627727 13022775 4820.2
"75-84 years" "75-84" "2010" "2010" 625651 13061122 4790.2
"75-84 years" "75-84" "2011" "2011" 626225 13175230 4753.0
"75-84 years" "75-84" "2012" "2012" 620428 13272634 4674.5
"75-84 years" "75-84" "2013" "2013" 625013 13446519 4648.1
"75-84 years" "75-84" "2014" "2014" 624504 13682690 4564.2
"75-84 years" "75-84" "2015" "2015" 637566 13923174 4579.2
"75-84 years" "75-84" "2016" "2016" 636916 14233534 4474.8
"85+ years" "85+" "1999" "1999" 646141 4154018 15554.6
"85+ years" "85+" "2000" "2000" 658171 4239587 15524.4
"85+ years" "85+" "2001" "2001" 665531 4312494 15432.6
"85+ years" "85+" "2002" "2002" 681076 4368808 15589.5
"85+ years" "85+" "2003" "2003" 687852 4466176 15401.4
"85+ years" "85+" "2004" "2004" 671773 4545883 14777.6
"85+ years" "85+" "2005" "2005" 703169 4693299 14982.4
"85+ years" "85+" "2006" "2006" 701992 4865929 14426.7
"85+ years" "85+" "2007" "2007" 713647 5039545 14160.9
"85+ years" "85+" "2008" "2008" 744691 5195840 14332.4
"85+ years" "85+" "2009" "2009" 733178 5367301 13660.1
"85+ years" "85+" "2010" "2010" 765474 5493433 13934.3
"85+ years" "85+" "2011" "2011" 790545 5737173 13779.3
"85+ years" "85+" "2012" "2012" 805307 5887330 13678.6
"85+ years" "85+" "2013" "2013" 825198 6040789 13660.4
"85+ years" "85+" "2014" "2014" 826226 6162231 13407.9
"85+ years" "85+" "2015" "2015" 859701 6287161 13673.9
"85+ years" "85+" "2016" "2016" 854462 6380331 13392.1
"Not Stated" "NS" "1999" "1999" 356 Not Applicable Not Applicable
"Not Stated" "NS" "2000" "2000" 356 Not Applicable Not Applicable
"Not Stated" "NS" "2001" "2001" 422 Not Applicable Not Applicable
"Not Stated" "NS" "2002" "2002" 357 Not Applicable Not Applicable
"Not Stated" "NS" "2003" "2003" 342 Not Applicable Not Applicable
"Not Stated" "NS" "2004" "2004" 346 Not Applicable Not Applicable
"Not Stated" "NS" "2005" "2005" 255 Not Applicable Not Applicable
"Not Stated" "NS" "2006" "2006" 220 Not Applicable Not Applicable
"Not Stated" "NS" "2007" "2007" 201 Not Applicable Not Applicable
"Not Stated" "NS" "2008" "2008" 147 Not Applicable Not Applicable
"Not Stated" "NS" "2009" "2009" 255 Not Applicable Not Applicable
"Not Stated" "NS" "2010" "2010" 126 Not Applicable Not Applicable
"Not Stated" "NS" "2011" "2011" 134 Not Applicable Not Applicable
"Not Stated" "NS" "2012" "2012" 147 Not Applicable Not Applicable
"Not Stated" "NS" "2013" "2013" 132 Not Applicable Not Applicable
"Not Stated" "NS" "2014" "2014" 163 Not Applicable Not Applicable
"Not Stated" "NS" "2015" "2015" 138 Not Applicable Not Applicable
"Not Stated" "NS" "2016" "2016" 137 Not Applicable Not Applicable
"---"
"Dataset: Compressed Mortality, 1999-2016"
"Query Parameters:"
"Title:"
"2013 Metro/Nonmetro: All"
"2013 Urbanization: All"
"Age Group: All"
"Gender: All"
"Hispanic Origin: All"
"ICD-10 Codes: All"
"Race: All"
"States: All"
"Year: All, 1999 to 2016"
"Group By: Age Group, Year"
"Show Totals: False"
"Show Zero Values: False"
"Show Suppressed: False"
"Calculate Rates Per: 100,000"
"---"
"Help: See http://wonder.cdc.gov/wonder/help/cmf.html for more information."
"---"
"Query Date: Jun 22, 2018 6:45:08 PM"
"---"
"Suggested Citation: Centers for Disease Control and Prevention, National Center for Health Statistics. Compressed Mortality File"
"1999-2016 on CDC WONDER Online Database, released June 2017. Data are from the Compressed Mortality File 1999-2016 Series 20 No."
"2U, 2016, as compiled from data provided by the 57 vital statistics jurisdictions through the Vital Statistics Cooperative"
"Program. Accessed at http://wonder.cdc.gov/cmf-icd10.html on Jun 22, 2018 6:45:08 PM"
"---"
Caveats:
"1. About national population figures: population figures for 1999 are from the 1990-1999 series of bridged-race intercensal"
"estimates of the July 1 resident population; population figures for 2000 and 2010 are bridged-race April 1 census counts;"
"population figures for 2001-2009 are from the revised 2000-2009 series of bridged-race intercensal estimates of the July 1"
"resident population; population figures for 2011 are bridged-race postcensal estimates of the July 1 resident population, from"
"the Vintage 2011 series released by NCHS on July 18, 2012; population figures for 2012 are bridged-race postcensal estimates of"
"the July 1 resident population, from the Vintage 2012 series released by NCHS on June 13, 2013; population figures for 2013 are"
"bridged-race postcensal estimates of the July 1 resident population, from the Vintage 2013 series released by NCHS on June 26,"
"2014; population figures for 2014 are bridged-race postcensal estimates of the July 1 resident population, from the Vintage 2014"
"series released by NCHS on June 30, 2015. and population figures for 2015 are bridged-race postcensal estimates of the July 1"
"resident population, from the Vintage 2015 series released by NCHS on June 28, 2016. More information:"
"http://wonder.cdc.gov/wonder/help/cmf.html#Population Information."
"2. The population figures used in the calculation of death rates for the age group 'under 1 year' are the estimates of the"
"resident population that is under one year of age. More information: http://wonder.cdc.gov/wonder/help/cmf.html#Age Group."
"3. Deaths of persons with Age ""Not Stated"" are included in ""All"" counts and rates, but are not distributed among age groups,"
"so are not included in age-specific counts, age-specific rates or in any age-adjusted rates. More information:"
"http://wonder.cdc.gov/wonder/help/cmf.html#Not Stated."
"4. 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/cmf.html#2014-Revision."
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment