import pandas as pd
pd.options.display.max_columns = 5200
pd.options.display.max_rows = 5200
inFluCDC = '/Users/danielmsheehan/GitHub/d3-presentation/data/flu/cdc/StateData.csv' #http://www.cdc.gov/flu/weekly/fluactivitysurv.htm
inFluGoo = '/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/data_20150210.txt'
inFluGoo = 'https://www.google.org/flutrends/us/data.txt'
inImmCal = '/Users/danielmsheehan/GitHub/d3-presentation/data/immunization/schools/ca/2014-2015 CA Seventh Grade Data.xls'
dfFluCDC = pd.read_csv(inFluCDC)
dfFluGoo = pd.read_csv(inFluGoo, header=11)
inImmCal = pd.io.excel.read_excel(inImmCal, 'SA1415', header=3)
dfFluCDC.head(2)
STATENAME | URL | WEBSITE | ACTIVITY LEVEL | ACTIVITY LEVEL LABEL | WEEKEND | WEEK | SEASON | |
---|---|---|---|---|---|---|---|---|
0 | Alabama | http://adph.org/influenza/ | Influenza Surveillance | Level 1 | Minimal | Oct-04-2008 | 40 | 2008-09 |
1 | Alabama | http://adph.org/influenza/ | Influenza Surveillance | Level 1 | Minimal | Oct-11-2008 | 41 | 2008-09 |
inImmCal.head(1) #Keep around for Dr. R.
SCHOOL CODE | COUNTY | PUBLIC/ PRIVATE | PUBLIC SCHOOL DISTRICT | CITY | SCHOOL NAME | ENROLLMENT | UP-TO-DATE† | Unnamed: 8 | PME** | Unnamed: 10 | PBE§ | Unnamed: 12 | HEALTH CARE PRACTITIONER COUNSELED PBE§§ | Unnamed: 14 | RELIGIOUS PBE§§§ | Unnamed: 16 | REPORTED§§§§ | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | # | % | # | % | # | % | # | % | # | % | NaN |
dfFluGoo.head(10)
Date | United States | Alabama | Alaska | Arizona | Arkansas | California | Colorado | Connecticut | Delaware | District of Columbia | Florida | Georgia | Hawaii | Idaho | Illinois | Indiana | Iowa | Kansas | Kentucky | Louisiana | Maine | Maryland | Massachusetts | Michigan | Minnesota | Mississippi | Missouri | Montana | Nebraska | Nevada | New Hampshire | New Jersey | New Mexico | New York | North Carolina | North Dakota | Ohio | Oklahoma | Oregon | Pennsylvania | Rhode Island | South Carolina | South Dakota | Tennessee | Texas | Utah | Vermont | Virginia | Washington | West Virginia | Wisconsin | Wyoming | HHS Region 1 (CT, ME, MA, NH, RI, VT) | HHS Region 2 (NJ, NY) | HHS Region 3 (DE, DC, MD, PA, VA, WV) | HHS Region 4 (AL, FL, GA, KY, MS, NC, SC, TN) | HHS Region 5 (IL, IN, MI, MN, OH, WI) | HHS Region 6 (AR, LA, NM, OK, TX) | HHS Region 7 (IA, KS, MO, NE) | HHS Region 8 (CO, MT, ND, SD, UT, WY) | HHS Region 9 (AZ, CA, HI, NV) | HHS Region 10 (AK, ID, OR, WA) | Anchorage, AK | Birmingham, AL | Little Rock, AR | Mesa, AZ | Phoenix, AZ | Scottsdale, AZ | Tempe, AZ | Tucson, AZ | Berkeley, CA | Fresno, CA | Irvine, CA | Los Angeles, CA | Oakland, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Santa Clara, CA | Sunnyvale, CA | Colorado Springs, CO | Denver, CO | Washington, DC | Gainesville, FL | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Roswell, GA | Honolulu, HI | Des Moines, IA | Boise, ID | Chicago, IL | Indianapolis, IN | Wichita, KS | Lexington, KY | Baton Rouge, LA | New Orleans, LA | Boston, MA | Somerville, MA | Baltimore, MD | Grand Rapids, MI | St Paul, MN | Kansas City, MO | Springfield, MO | St Louis, MO | Jackson, MS | Cary, NC | Charlotte, NC | Durham, NC | Greensboro, NC | Raleigh, NC | Lincoln, NE | Omaha, NE | Newark, NJ | Albuquerque, NM | Las Vegas, NV | Reno, NV | Albany, NY | Buffalo, NY | New York, NY | Rochester, NY | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Tulsa, OK | Beaverton, OR | Eugene, OR | Portland, OR | Philadelphia, PA | Pittsburgh, PA | State College, PA | Providence, RI | Columbia, SC | Greenville, SC | Knoxville, TN | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Ft Worth, TX | Houston, TX | Irving, TX | Lubbock, TX | Plano, TX | San Antonio, TX | Salt Lake City, UT | Arlington, VA | Norfolk, VA | Reston, VA | Richmond, VA | Bellevue, WA | Seattle, WA | Spokane, WA | Madison, WI | Milwaukee, WI | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 2003-09-28 | 902 | 477 | NaN | 606 | NaN | 929 | 233 | 223 | NaN | 927 | 587 | 514 | NaN | NaN | 677 | 544 | 303 | 272 | 420 | 1017 | NaN | 1268 | 344 | 685 | 484 | NaN | 349 | NaN | NaN | NaN | NaN | 695 | NaN | 649 | 565 | NaN | 616 | 1040 | 409 | 1186 | NaN | 462 | NaN | 551 | 1398 | NaN | NaN | 1112 | 588 | NaN | 466 | NaN | 322 | 666 | 1366 | 631 | 690 | 1385 | 385 | 266 | 878 | 624 | NaN | 407 | NaN | NaN | 757 | NaN | 585 | 598 | NaN | NaN | NaN | 901 | 848 | 448 | 562 | 1003 | 731 | 990 | 602 | NaN | 235 | 1153 | NaN | NaN | 373 | 609 | 461 | 519 | NaN | 794 | NaN | NaN | 731 | 641 | NaN | NaN | NaN | 1154 | 314 | 332 | 1505 | NaN | 426 | 330 | NaN | 391 | NaN | NaN | 561 | 521 | NaN | 503 | NaN | 314 | 540 | NaN | 843 | NaN | 505 | NaN | 579 | 406 | 466 | 437 | NaN | 924 | 1034 | NaN | NaN | 444 | 1204 | 1122 | NaN | NaN | NaN | NaN | NaN | NaN | 425 | 1150 | 1200 | NaN | 1412 | 1122 | NaN | NaN | 986 | 261 | 1066 | 948 | NaN | 1035 | NaN | 668 | NaN | 622 | 452 |
1 | 2003-10-05 | 952 | 501 | NaN | 663 | NaN | 849 | 251 | 243 | NaN | 993 | 582 | 532 | NaN | NaN | 732 | 607 | 303 | 270 | 442 | 1096 | NaN | 1374 | 362 | 748 | 514 | NaN | 359 | NaN | NaN | NaN | NaN | 716 | NaN | 725 | 660 | NaN | 699 | 1065 | 409 | 1176 | NaN | 478 | NaN | 597 | 1517 | NaN | NaN | 1198 | 624 | NaN | 504 | NaN | 381 | 711 | 1335 | 652 | 775 | 1613 | 400 | 271 | 853 | 688 | NaN | 402 | NaN | NaN | 796 | NaN | 608 | 674 | NaN | NaN | NaN | 891 | 888 | 436 | 840 | 1115 | 740 | 915 | 594 | NaN | 270 | 1310 | NaN | NaN | 386 | 663 | 581 | 484 | NaN | 877 | NaN | NaN | 850 | 657 | NaN | NaN | NaN | 1162 | 323 | 375 | 1535 | NaN | 423 | 316 | NaN | 397 | NaN | NaN | 673 | 536 | NaN | 586 | NaN | 331 | 549 | NaN | 831 | NaN | 508 | NaN | 730 | 483 | 535 | 415 | NaN | 894 | 1042 | NaN | NaN | 471 | 1124 | 1193 | NaN | NaN | NaN | NaN | NaN | NaN | 468 | 1331 | 1487 | NaN | 2057 | 1208 | NaN | NaN | 989 | 249 | 1249 | 963 | NaN | 1135 | NaN | 787 | NaN | 626 | 449 |
2 | 2003-10-12 | 1092 | 492 | NaN | 700 | NaN | 1032 | 283 | 261 | NaN | 1033 | 606 | 557 | NaN | NaN | 799 | 637 | 312 | 280 | 460 | 1144 | NaN | 1445 | 372 | 791 | 588 | NaN | 381 | NaN | NaN | NaN | NaN | 815 | NaN | 739 | 861 | NaN | 729 | 1122 | 428 | 1340 | NaN | 521 | NaN | 670 | 2010 | NaN | NaN | 1343 | 777 | NaN | 538 | NaN | 410 | 819 | 1411 | 735 | 760 | 2089 | 422 | 285 | 1102 | 791 | NaN | 428 | NaN | NaN | 766 | NaN | 629 | 731 | NaN | NaN | NaN | 1165 | 839 | 468 | 938 | 1311 | 826 | 989 | 609 | NaN | 257 | 1309 | 641 | NaN | 370 | 615 | 567 | 497 | NaN | 1030 | NaN | NaN | 799 | 685 | NaN | NaN | NaN | 1274 | 369 | 447 | 1549 | NaN | 457 | 343 | NaN | 408 | NaN | NaN | 738 | 521 | NaN | 838 | NaN | 373 | 575 | 1068 | 824 | NaN | 555 | NaN | 652 | 476 | 671 | 442 | NaN | 922 | 1089 | NaN | NaN | 574 | 1249 | 1306 | NaN | NaN | NaN | NaN | NaN | NaN | 497 | 1492 | 1869 | NaN | 3770 | 1191 | NaN | NaN | 1463 | 295 | 1289 | 970 | NaN | 1170 | NaN | 994 | NaN | 661 | 437 |
3 | 2003-10-19 | 1209 | 533 | NaN | 819 | NaN | 1084 | 310 | 268 | NaN | 1089 | 698 | 608 | NaN | NaN | 841 | 680 | 342 | 292 | 485 | 1308 | NaN | 1432 | 367 | 829 | 692 | NaN | 431 | NaN | NaN | NaN | NaN | 831 | NaN | 874 | 852 | NaN | 759 | 1199 | 467 | 1424 | NaN | 529 | NaN | 666 | 2786 | NaN | NaN | 1448 | 866 | NaN | 595 | NaN | 397 | 839 | 1444 | 822 | 803 | 2583 | 498 | 338 | 1086 | 852 | NaN | 494 | NaN | NaN | 820 | NaN | 649 | 778 | NaN | NaN | NaN | 1158 | 794 | 495 | 1045 | 1429 | 958 | 1020 | 604 | NaN | 314 | 1151 | 680 | NaN | 380 | 679 | 628 | 563 | NaN | 1012 | NaN | NaN | 852 | 697 | NaN | NaN | NaN | 1488 | 321 | 440 | 1466 | NaN | 440 | 358 | NaN | 426 | NaN | NaN | 799 | 563 | NaN | 866 | NaN | 382 | 584 | 1092 | 834 | NaN | 604 | 548 | 831 | 498 | 703 | 485 | NaN | 1024 | 1089 | NaN | NaN | 683 | 1279 | 1343 | NaN | NaN | NaN | NaN | NaN | NaN | 544 | 2696 | 1897 | NaN | 6618 | 1516 | NaN | NaN | 2095 | 292 | 1308 | 1011 | NaN | 1342 | NaN | 999 | NaN | 649 | 487 |
4 | 2003-10-26 | 1249 | 594 | NaN | 959 | NaN | 989 | 344 | 334 | NaN | 1177 | 708 | 745 | NaN | NaN | 978 | 765 | 368 | 313 | 496 | 1936 | NaN | 1426 | 370 | 803 | 701 | NaN | 452 | NaN | NaN | NaN | NaN | 901 | NaN | 865 | 857 | NaN | 847 | 1278 | 510 | 1514 | NaN | 556 | NaN | 717 | 2917 | NaN | NaN | 1556 | 1026 | NaN | 653 | NaN | 444 | 917 | 1608 | 797 | 931 | 2955 | 530 | 387 | 1028 | 1012 | NaN | 531 | NaN | NaN | 908 | NaN | 658 | 1167 | NaN | NaN | NaN | 922 | 908 | 525 | 988 | 1377 | 1123 | 1070 | 640 | NaN | 354 | 1285 | 679 | NaN | 412 | 664 | 593 | 845 | NaN | 910 | NaN | NaN | 1051 | 715 | NaN | NaN | NaN | 2229 | 346 | 464 | 1460 | NaN | 445 | 384 | NaN | 448 | NaN | NaN | 925 | 573 | NaN | 831 | NaN | 421 | 626 | 1089 | 872 | NaN | 629 | 557 | 776 | 662 | 794 | 522 | NaN | 1191 | 1095 | NaN | NaN | 735 | 1537 | 1484 | NaN | NaN | NaN | NaN | NaN | NaN | 554 | 3918 | 2029 | NaN | 6412 | 1559 | NaN | NaN | 3282 | 328 | 1426 | 1009 | NaN | 1354 | NaN | 1297 | NaN | 657 | 499 |
5 | 2003-11-02 | 1374 | 715 | NaN | 1167 | NaN | 1284 | 569 | 394 | NaN | 1270 | 746 | 767 | 936 | NaN | 1102 | 773 | 399 | 323 | 505 | 2791 | NaN | 1495 | 404 | 898 | 708 | NaN | 450 | NaN | NaN | NaN | NaN | 897 | NaN | 1005 | 922 | NaN | 830 | 1437 | 576 | 1448 | NaN | 621 | NaN | 733 | 3177 | NaN | NaN | 1640 | 1053 | NaN | 688 | NaN | 457 | 997 | 1616 | 850 | 938 | 3202 | 509 | 653 | 1394 | 1160 | NaN | 548 | NaN | NaN | 1109 | NaN | 810 | 1584 | NaN | NaN | NaN | 1306 | 930 | 643 | 1021 | 1423 | 1035 | 1322 | 728 | NaN | 845 | 1522 | 736 | NaN | 445 | 797 | 699 | 771 | NaN | 946 | NaN | NaN | 1137 | 681 | NaN | NaN | NaN | 3288 | 395 | 487 | 1501 | NaN | 462 | 405 | NaN | 464 | NaN | NaN | 975 | 601 | NaN | 1065 | NaN | 431 | 658 | 1194 | 1028 | NaN | 678 | 653 | 1030 | 1008 | 928 | 546 | NaN | 1232 | 1187 | NaN | NaN | 866 | 1542 | 1445 | NaN | NaN | NaN | NaN | NaN | NaN | 603 | 3840 | 2647 | NaN | 6046 | 1891 | NaN | NaN | 3554 | 355 | 1419 | 1032 | NaN | 1446 | NaN | 1100 | NaN | 707 | 521 |
6 | 2003-11-09 | 1702 | 840 | NaN | 1655 | NaN | 1741 | 2053 | 459 | NaN | 1377 | 917 | 803 | 993 | NaN | 1091 | 831 | 444 | 360 | 563 | 3975 | NaN | 1653 | 474 | 939 | 776 | NaN | 514 | NaN | 400 | NaN | NaN | 994 | NaN | 1059 | 1135 | NaN | 880 | 2082 | 780 | 1720 | NaN | 758 | NaN | 931 | 3344 | 291 | NaN | 1931 | 1605 | NaN | 813 | NaN | 558 | 1067 | 1995 | 1153 | 1062 | 3581 | 619 | 1692 | 1779 | 2383 | NaN | 579 | NaN | NaN | 1422 | NaN | 908 | 2305 | NaN | NaN | NaN | 1628 | 1044 | 908 | 990 | 2644 | 1084 | 1361 | 1120 | NaN | 2559 | 1705 | 867 | NaN | 486 | 984 | 712 | 705 | NaN | 1159 | NaN | NaN | 1157 | 700 | NaN | NaN | NaN | 3838 | 449 | 539 | 1456 | NaN | 564 | 428 | NaN | 648 | NaN | NaN | 966 | 739 | NaN | 1132 | NaN | 622 | 707 | 1278 | 1096 | NaN | 825 | 694 | 957 | 1099 | 929 | 591 | NaN | 1407 | 2024 | NaN | NaN | 1142 | 1638 | 1734 | NaN | NaN | NaN | NaN | NaN | NaN | 655 | 3064 | 3387 | NaN | 4379 | 2514 | NaN | NaN | 3706 | 482 | 1565 | 1150 | NaN | 1927 | NaN | 1969 | NaN | 821 | 566 |
7 | 2003-11-16 | 2148 | 1064 | NaN | 2662 | NaN | 2110 | 3669 | 538 | NaN | 1538 | 1095 | 1236 | 994 | NaN | 1374 | 1143 | 519 | 449 | 673 | 4796 | NaN | 2156 | 782 | 1061 | 829 | NaN | 684 | NaN | 611 | NaN | NaN | 1281 | NaN | 1559 | 1536 | NaN | 1040 | 3888 | 978 | 2423 | NaN | 844 | NaN | 1152 | 4287 | 438 | NaN | 2575 | 2881 | NaN | 1169 | NaN | 852 | 1543 | 2596 | 1479 | 1427 | 4506 | 1094 | 2633 | 2173 | 2548 | NaN | 856 | NaN | NaN | 3004 | NaN | 1076 | 4575 | NaN | NaN | NaN | 1859 | 1648 | 1350 | 1508 | 2531 | 1187 | 1846 | 1861 | NaN | 3653 | 2182 | 1251 | NaN | 603 | 980 | 912 | 1527 | NaN | 1239 | NaN | NaN | 1493 | 807 | NaN | NaN | NaN | 3874 | 692 | 659 | 1806 | NaN | 602 | 548 | NaN | 724 | NaN | NaN | 986 | 1130 | NaN | 1200 | NaN | 915 | 818 | 1982 | 1408 | NaN | 1003 | 817 | 1639 | 1483 | 1079 | 830 | NaN | 4436 | 3250 | NaN | NaN | 1553 | 1628 | 2653 | NaN | NaN | NaN | NaN | NaN | NaN | 902 | 7201 | 5723 | NaN | 3925 | 3314 | NaN | NaN | 4888 | 973 | 1584 | 1330 | NaN | 2186 | NaN | 2880 | NaN | 1364 | 725 |
8 | 2003-11-23 | 2968 | 1458 | NaN | 4935 | NaN | 3138 | 5731 | 635 | NaN | 1867 | 1404 | 1526 | 1039 | NaN | 2367 | 1560 | 727 | 647 | 928 | 4722 | NaN | 3197 | 1117 | 1340 | 954 | NaN | 1211 | NaN | 1096 | 1058 | NaN | 1731 | NaN | 2246 | 2363 | NaN | 1837 | 8199 | 1480 | 2737 | NaN | 1074 | NaN | 1650 | 4828 | 1055 | NaN | 3290 | 4817 | NaN | 1504 | NaN | 1148 | 2176 | 3341 | 2182 | 2020 | 5272 | 2041 | 4226 | 3382 | 4223 | NaN | 1538 | NaN | NaN | 5004 | NaN | 2674 | 5240 | NaN | NaN | NaN | 2876 | 2351 | 2494 | 2512 | 4837 | 2244 | 3223 | 2990 | NaN | 7435 | 2608 | 1610 | NaN | 634 | 1288 | 1089 | 2198 | 725 | 1448 | NaN | NaN | 2306 | 1098 | NaN | NaN | NaN | 4118 | 852 | 714 | 2466 | NaN | 678 | 953 | NaN | 1183 | NaN | NaN | 1298 | 1436 | NaN | 1884 | NaN | 2691 | 1049 | 3367 | 2071 | NaN | 1253 | 986 | 2519 | 1527 | 1100 | 1060 | 641 | 10155 | 7148 | NaN | NaN | 2452 | 1958 | 3085 | NaN | NaN | NaN | NaN | NaN | NaN | 1098 | 7259 | 7441 | NaN | 4054 | 3417 | NaN | NaN | 6983 | 2594 | 1824 | 1713 | NaN | 2552 | NaN | 4152 | NaN | 1627 | 837 |
9 | 2003-11-30 | 3524 | 3202 | NaN | 8265 | NaN | 5406 | 5741 | 1070 | NaN | 2630 | 1972 | 2922 | 1204 | NaN | 3248 | 2868 | 1304 | 1892 | 1364 | 4756 | NaN | 4095 | 1673 | 2146 | 1768 | NaN | 2593 | NaN | 4633 | 1916 | 426 | 2803 | NaN | 2723 | 4095 | NaN | 2960 | 14183 | 2682 | 3569 | NaN | 1652 | NaN | 3295 | 3747 | 3471 | NaN | 4593 | 7193 | NaN | 2968 | NaN | 1904 | 2631 | 4046 | 3192 | 2554 | 4485 | 2943 | 4864 | 5467 | 5791 | NaN | 3218 | NaN | NaN | 9722 | NaN | 7541 | 6753 | NaN | NaN | NaN | 5390 | 6276 | 3518 | 6873 | 7840 | 5849 | 7470 | 10110 | NaN | 5903 | 3214 | 1960 | NaN | 1031 | 2072 | 1409 | 3417 | 1098 | 1459 | NaN | NaN | 3406 | 5137 | NaN | NaN | NaN | 3970 | 1382 | 1777 | 4309 | NaN | 1367 | 2407 | NaN | 2862 | NaN | NaN | 2439 | 3034 | NaN | 3785 | NaN | 6672 | 1501 | 10548 | 5093 | NaN | 2879 | 1327 | 2831 | 2356 | 2136 | 3419 | 1179 | 13958 | 13264 | NaN | NaN | 4071 | 3074 | 4696 | NaN | NaN | NaN | NaN | NaN | NaN | 2578 | 7392 | 8642 | NaN | 5553 | 5002 | NaN | NaN | 7940 | 4086 | 2860 | 3102 | NaN | 3484 | 1571 | 7445 | NaN | 2969 | 1314 |
#Split into States, HHS Regions and Cities and Rtoate dataframe 90 with Transpose
statesList = ['Alabama','Alaska','Arizona','Arkansas','California','Colorado','Connecticut','Delaware','District of Columbia','Florida','Georgia','Hawaii','Idaho','Illinois','Indiana','Iowa','Kansas','Kentucky','Louisiana','Maine','Maryland','Massachusetts','Michigan','Minnesota','Mississippi','Missouri','Montana','Nebraska','Nevada','New Hampshire','New Jersey','New Mexico','New York','North Carolina','North Dakota','Ohio','Oklahoma','Oregon','Pennsylvania','Rhode Island','South Carolina','South Dakota','Tennessee','Texas','Utah','Vermont','Virginia','Washington','West Virginia','Wisconsin','Wyoming']
hhsList = ['HHS Region 1 (CT, ME, MA, NH, RI, VT)','HHS Region 2 (NJ, NY)','HHS Region 3 (DE, DC, MD, PA, VA, WV)','HHS Region 4 (AL, FL, GA, KY, MS, NC, SC, TN)','HHS Region 5 (IL, IN, MI, MN, OH, WI)','HHS Region 6 (AR, LA, NM, OK, TX)','HHS Region 7 (IA, KS, MO, NE)','HHS Region 8 (CO, MT, ND, SD, UT, WY)','HHS Region 9 (AZ, CA, HI, NV)','HHS Region 10 (AK, ID, OR, WA)']
citiesList = ['Anchorage, AK','Birmingham, AL','Little Rock, AR','Mesa, AZ','Phoenix, AZ','Scottsdale, AZ','Tempe, AZ','Tucson, AZ','Berkeley, CA','Fresno, CA','Irvine, CA','Los Angeles, CA','Oakland, CA','Sacramento, CA','San Diego, CA','San Francisco, CA','San Jose, CA','Santa Clara, CA','Sunnyvale, CA','Colorado Springs, CO','Denver, CO','Washington, DC','Gainesville, FL','Jacksonville, FL','Miami, FL','Orlando, FL','Tampa, FL','Atlanta, GA','Roswell, GA','Honolulu, HI','Des Moines, IA','Boise, ID','Chicago, IL','Indianapolis, IN','Wichita, KS','Lexington, KY','Baton Rouge, LA','New Orleans, LA','Boston, MA','Somerville, MA','Baltimore, MD','Grand Rapids, MI','St Paul, MN','Kansas City, MO','Springfield, MO','St Louis, MO','Jackson, MS','Cary, NC','Charlotte, NC','Durham, NC','Greensboro, NC','Raleigh, NC','Lincoln, NE','Omaha, NE','Newark, NJ','Albuquerque, NM','Las Vegas, NV','Reno, NV','Albany, NY','Buffalo, NY','New York, NY','Rochester, NY','Cleveland, OH','Columbus, OH','Dayton, OH','Oklahoma City, OK','Tulsa, OK','Beaverton, OR','Eugene, OR','Portland, OR','Philadelphia, PA','Pittsburgh, PA','State College, PA','Providence, RI','Columbia, SC','Greenville, SC','Knoxville, TN','Memphis, TN','Nashville, TN','Austin, TX','Dallas, TX','Ft Worth, TX','Houston, TX','Irving, TX','Lubbock, TX','Plano, TX','San Antonio, TX','Salt Lake City, UT','Arlington, VA','Norfolk, VA','Reston, VA','Richmond, VA','Bellevue, WA','Seattle, WA','Spokane, WA','Madison, WI','Milwaukee, WI']
dfS = dfFluGoo[['Date']+statesList]
dfS = dfS.T
dfH = dfFluGoo[['Date']+hhsList]
dfH = dfH.T
dfC = dfFluGoo[['Date']+citiesList]
dfC = dfC.T
StatesFlu = '/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/states_flu_data.csv'
HHSFlu = '/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/hhs_flu_data.csv'
CitiesFlu = '/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/cities_flu_data.csv'
dfS.to_csv(StatesFlu, index=True, header = False)
dfH.to_csv(HHSFlu, index=True, header = False)
dfC.to_csv(CitiesFlu, index=True, header = False)
dfS = pd.read_csv(StatesFlu)
dfC = pd.read_csv(CitiesFlu)
dfS = dfS.rename(columns=lambda x: x.replace('Date', 'state'))
#dfH = dfH.rename(columns=lambda x: x.replace('Date', 'State'))
dfC = dfC.rename(columns=lambda x: x.replace('Date', 'City'))
#print dfS.head(10)
#print dfC.head(10)
dfS.to_csv(StatesFlu, index=False)
dfC.to_csv(CitiesFlu, index=False)
--------------------------------------------------------------------------- NameError Traceback (most recent call last) <ipython-input-1-978256014e2a> in <module>() ----> 1 dfS = pd.read_csv(StatesFlu) 2 dfC = pd.read_csv(CitiesFlu) 3 4 dfS = dfS.rename(columns=lambda x: x.replace('Date', 'state')) 5 #dfH = dfH.rename(columns=lambda x: x.replace('Date', 'State')) NameError: name 'pd' is not defined
#Download Shapefile
import urllib
zipLoc = "/Users/danielmsheehan/GitHub/d3-presentation/data/census/states/cb_2013_us_state_20m.zip"
urllib.urlretrieve ("http://www2.census.gov/geo/tiger/GENZ2013/cb_2013_us_state_20m.zip", zipLoc)
import zipfile
zip = zipfile.ZipFile(zipLoc)
zip.extractall("/Users/danielmsheehan/GitHub/d3-presentation/data/census/states/")
States Shapefile in QGIS
And now the date table associated with the shapefile (in the .dbf). Note: data or columns in GIS files is often referred to as an 'attribute table.'
Using GDAL/OGR convert the Shapefile to JSON.
ogr2ogr -f GeoJSON /Users/danielmsheehan/GitHub/d3-presentation/data/census/states/states.json /Users/danielmsheehan/GitHub/d3-presentation/data/census/states/cb_2013_us_state_20m.shp
Then, after installing node.js, we can create TopoJson
topojson /Users/danielmsheehan/GitHub/d3-presentation/data/census/states/states.topo.json /Users/danielmsheehan/GitHub/d3-presentation/data/census/states/states.json
More simply: topojson states_cln.topo.json states.json
#Need to get US State Population Dataset to create a Flu Rate.
dfPop = pd.io.json.read_json('http://api.census.gov/data/2010/sf1?key=30699f15ab4d04a1e0943715b539d256c9a3ee44&get=P0010001&for=state')
#dfPop = dfPop.header(1)
dfPop = dfPop.ix[1:]
dfPop.columns = ['pop', 'fips']
print dfPop.head(5)
dfFIPS = pd.read_csv('/Users/danielmsheehan/GitHub/data/census/state_fips.csv', dtype={'fips':object})
print dfFIPS.head(5)
pop fips 1 4779736 01 2 710231 02 3 6392017 04 4 2915918 05 5 37253956 06 state abbrev fips info 0 Alabama AL 01 State; counties 1 Alaska AK 02 State; boroughs 2 American Samoa AS 60 Outlying area under U.S. sovereignty 3 American Samoa * NaN 03 (FIPS 5-1 reserved code) 4 Arizona AZ 04 State; counties
df = dfS.merge(dfFIPS, how='left', on='state')
df = df.merge(dfPop, how='left', on='fips')
df.head(10)
df.to_csv('/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/states_pop_week.csv', index=False)
#print list(df.columns.values)
df = pd.read_csv('/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/states_pop_week.csv', dtype={'fips':object})
#df['pop'] = df['pop'].astype(float)
#print df.types
for i in weekList:
df['rate'+i] = df[i]/df['pop'] * 10000
df = df.drop(weekList, axis=1)
df.head(53)
df.to_csv('/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/states_pop_week_rate_state.csv', index=False)
#Get a list of County FIPS
dfCounties = pd.read_csv('http://www2.census.gov/geo/docs/reference/codes/files/national_county.txt', header=None, dtype={1:object,2:object})
dfCounties.columns = ['state_abbrev', 'state_fips','county_fips','fullname','note']
dfCounties['fips'] = dfCounties['state_fips']
dfCounties.head(5)
state_abbrev | state_fips | county_fips | fullname | note | fips | |
---|---|---|---|---|---|---|
0 | AL | 01 | 001 | Autauga County | H1 | 01 |
1 | AL | 01 | 003 | Baldwin County | H1 | 01 |
2 | AL | 01 | 005 | Barbour County | H1 | 01 |
3 | AL | 01 | 007 | Bibb County | H1 | 01 |
4 | AL | 01 | 009 | Blount County | H1 | 01 |
dfAll = dfCounties.merge(df, on='fips', how='left')
dfAll['id'] = dfAll.state_fips.map(str) + dfAll.county_fips.map(str)
dfAll['id'] = dfAll['id'].astype(int)
dfAll.head(10)
dfAll.to_csv('/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/states_pop_week_rates_county.csv', index=False)
weekList = ['2003-09-28','2003-10-05','2003-10-12','2003-10-19','2003-10-26','2003-11-02','2003-11-09','2003-11-16','2003-11-23','2003-11-30','2003-12-07','2003-12-14','2003-12-21','2003-12-28','2004-01-04','2004-01-11','2004-01-18','2004-01-25','2004-02-01','2004-02-08','2004-02-15','2004-02-22','2004-02-29','2004-03-07','2004-03-14','2004-03-21','2004-03-28','2004-04-04','2004-04-11','2004-04-18','2004-04-25','2004-05-02','2004-05-09','2004-05-16','2004-05-23','2004-05-30','2004-06-06','2004-06-13','2004-06-20','2004-06-27','2004-07-04','2004-07-11','2004-07-18','2004-07-25','2004-08-01','2004-08-08','2004-08-15','2004-08-22','2004-08-29','2004-09-05','2004-09-12','2004-09-19','2004-09-26','2004-10-03','2004-10-10','2004-10-17','2004-10-24','2004-10-31','2004-11-07','2004-11-14','2004-11-21','2004-11-28','2004-12-05','2004-12-12','2004-12-19','2004-12-26','2005-01-02','2005-01-09','2005-01-16','2005-01-23','2005-01-30','2005-02-06','2005-02-13','2005-02-20','2005-02-27','2005-03-06','2005-03-13','2005-03-20','2005-03-27','2005-04-03','2005-04-10','2005-04-17','2005-04-24','2005-05-01','2005-05-08','2005-05-15','2005-05-22','2005-05-29','2005-06-05','2005-06-12','2005-06-19','2005-06-26','2005-07-03','2005-07-10','2005-07-17','2005-07-24','2005-07-31','2005-08-07','2005-08-14','2005-08-21','2005-08-28','2005-09-04','2005-09-11','2005-09-18','2005-09-25','2005-10-02','2005-10-09','2005-10-16','2005-10-23','2005-10-30','2005-11-06','2005-11-13','2005-11-20','2005-11-27','2005-12-04','2005-12-11','2005-12-18','2005-12-25','2006-01-01','2006-01-08','2006-01-15','2006-01-22','2006-01-29','2006-02-05','2006-02-12','2006-02-19','2006-02-26','2006-03-05','2006-03-12','2006-03-19','2006-03-26','2006-04-02','2006-04-09','2006-04-16','2006-04-23','2006-04-30','2006-05-07','2006-05-14','2006-05-21','2006-05-28','2006-06-04','2006-06-11','2006-06-18','2006-06-25','2006-07-02','2006-07-09','2006-07-16','2006-07-23','2006-07-30','2006-08-06','2006-08-13','2006-08-20','2006-08-27','2006-09-03','2006-09-10','2006-09-17','2006-09-24','2006-10-01','2006-10-08','2006-10-15','2006-10-22','2006-10-29','2006-11-05','2006-11-12','2006-11-19','2006-11-26','2006-12-03','2006-12-10','2006-12-17','2006-12-24','2006-12-31','2007-01-07','2007-01-14','2007-01-21','2007-01-28','2007-02-04','2007-02-11','2007-02-18','2007-02-25','2007-03-04','2007-03-11','2007-03-18','2007-03-25','2007-04-01','2007-04-08','2007-04-15','2007-04-22','2007-04-29','2007-05-06','2007-05-13','2007-05-20','2007-05-27','2007-06-03','2007-06-10','2007-06-17','2007-06-24','2007-07-01','2007-07-08','2007-07-15','2007-07-22','2007-07-29','2007-08-05','2007-08-12','2007-08-19','2007-08-26','2007-09-02','2007-09-09','2007-09-16','2007-09-23','2007-09-30','2007-10-07','2007-10-14','2007-10-21','2007-10-28','2007-11-04','2007-11-11','2007-11-18','2007-11-25','2007-12-02','2007-12-09','2007-12-16','2007-12-23','2007-12-30','2008-01-06','2008-01-13','2008-01-20','2008-01-27','2008-02-03','2008-02-10','2008-02-17','2008-02-24','2008-03-02','2008-03-09','2008-03-16','2008-03-23','2008-03-30','2008-04-06','2008-04-13','2008-04-20','2008-04-27','2008-05-04','2008-05-11','2008-05-18','2008-05-25','2008-06-01','2008-06-08','2008-06-15','2008-06-22','2008-06-29','2008-07-06','2008-07-13','2008-07-20','2008-07-27','2008-08-03','2008-08-10','2008-08-17','2008-08-24','2008-08-31','2008-09-07','2008-09-14','2008-09-21','2008-09-28','2008-10-05','2008-10-12','2008-10-19','2008-10-26','2008-11-02','2008-11-09','2008-11-16','2008-11-23','2008-11-30','2008-12-07','2008-12-14','2008-12-21','2008-12-28','2009-01-04','2009-01-11','2009-01-18','2009-01-25','2009-02-01','2009-02-08','2009-02-15','2009-02-22','2009-03-01','2009-03-08','2009-03-15','2009-03-22','2009-03-29','2009-04-05','2009-04-12','2009-04-19','2009-04-26','2009-05-03','2009-05-10','2009-05-17','2009-05-24','2009-05-31','2009-06-07','2009-06-14','2009-06-21','2009-06-28','2009-07-05','2009-07-12','2009-07-19','2009-07-26','2009-08-02','2009-08-09','2009-08-16','2009-08-23','2009-08-30','2009-09-06','2009-09-13','2009-09-20','2009-09-27','2009-10-04','2009-10-11','2009-10-18','2009-10-25','2009-11-01','2009-11-08','2009-11-15','2009-11-22','2009-11-29','2009-12-06','2009-12-13','2009-12-20','2009-12-27','2010-01-03','2010-01-10','2010-01-17','2010-01-24','2010-01-31','2010-02-07','2010-02-14','2010-02-21','2010-02-28','2010-03-07','2010-03-14','2010-03-21','2010-03-28','2010-04-04','2010-04-11','2010-04-18','2010-04-25','2010-05-02','2010-05-09','2010-05-16','2010-05-23','2010-05-30','2010-06-06','2010-06-13','2010-06-20','2010-06-27','2010-07-04','2010-07-11','2010-07-18','2010-07-25','2010-08-01','2010-08-08','2010-08-15','2010-08-22','2010-08-29','2010-09-05','2010-09-12','2010-09-19','2010-09-26','2010-10-03','2010-10-10','2010-10-17','2010-10-24','2010-10-31','2010-11-07','2010-11-14','2010-11-21','2010-11-28','2010-12-05','2010-12-12','2010-12-19','2010-12-26','2011-01-02','2011-01-09','2011-01-16','2011-01-23','2011-01-30','2011-02-06','2011-02-13','2011-02-20','2011-02-27','2011-03-06','2011-03-13','2011-03-20','2011-03-27','2011-04-03','2011-04-10','2011-04-17','2011-04-24','2011-05-01','2011-05-08','2011-05-15','2011-05-22','2011-05-29','2011-06-05','2011-06-12','2011-06-19','2011-06-26','2011-07-03','2011-07-10','2011-07-17','2011-07-24','2011-07-31','2011-08-07','2011-08-14','2011-08-21','2011-08-28','2011-09-04','2011-09-11','2011-09-18','2011-09-25','2011-10-02','2011-10-09','2011-10-16','2011-10-23','2011-10-30','2011-11-06','2011-11-13','2011-11-20','2011-11-27','2011-12-04','2011-12-11','2011-12-18','2011-12-25','2012-01-01','2012-01-08','2012-01-15','2012-01-22','2012-01-29','2012-02-05','2012-02-12','2012-02-19','2012-02-26','2012-03-04','2012-03-11','2012-03-18','2012-03-25','2012-04-01','2012-04-08','2012-04-15','2012-04-22','2012-04-29','2012-05-06','2012-05-13','2012-05-20','2012-05-27','2012-06-03','2012-06-10','2012-06-17','2012-06-24','2012-07-01','2012-07-08','2012-07-15','2012-07-22','2012-07-29','2012-08-05','2012-08-12','2012-08-19','2012-08-26','2012-09-02','2012-09-09','2012-09-16','2012-09-23','2012-09-30','2012-10-07','2012-10-14','2012-10-21','2012-10-28','2012-11-04','2012-11-11','2012-11-18','2012-11-25','2012-12-02','2012-12-09','2012-12-16','2012-12-23','2012-12-30','2013-01-06','2013-01-13','2013-01-20','2013-01-27','2013-02-03','2013-02-10','2013-02-17','2013-02-24','2013-03-03','2013-03-10','2013-03-17','2013-03-24','2013-03-31','2013-04-07','2013-04-14','2013-04-21','2013-04-28','2013-05-05','2013-05-12','2013-05-19','2013-05-26','2013-06-02','2013-06-09','2013-06-16','2013-06-23','2013-06-30','2013-07-07','2013-07-14','2013-07-21','2013-07-28','2013-08-04','2013-08-11','2013-08-18','2013-08-25','2013-09-01','2013-09-08','2013-09-15','2013-09-22','2013-09-29','2013-10-06','2013-10-13','2013-10-20','2013-10-27','2013-11-03','2013-11-10','2013-11-17','2013-11-24','2013-12-01','2013-12-08','2013-12-15','2013-12-22','2013-12-29','2014-01-05','2014-01-12','2014-01-19','2014-01-26','2014-02-02','2014-02-09','2014-02-16','2014-02-23','2014-03-02','2014-03-09','2014-03-16','2014-03-23','2014-03-30','2014-04-06','2014-04-13','2014-04-20','2014-04-27','2014-05-04','2014-05-11','2014-05-18','2014-05-25','2014-06-01','2014-06-08','2014-06-15','2014-06-22','2014-06-29','2014-07-06','2014-07-13','2014-07-20','2014-07-27','2014-08-03','2014-08-10','2014-08-17','2014-08-24','2014-08-31','2014-09-07','2014-09-14','2014-09-21','2014-09-28','2014-10-05','2014-10-12','2014-10-19','2014-10-26','2014-11-02','2014-11-09','2014-11-16','2014-11-23','2014-11-30','2014-12-07','2014-12-14','2014-12-21','2014-12-28','2015-01-04','2015-01-11','2015-01-18','2015-01-25','2015-02-01','2015-02-08','2015-02-15','2015-02-22','2015-03-01']
for i in weekList:
#print i
dfSamp = dfAll[['id','rate'+i]]
dfSamp.columns = ['id', 'rate']
dfSamp.to_csv('/Users/danielmsheehan/GitHub/stat4701-edav-d3.github.com/viz/choropleth/pages/data/rate-'+i+'.tsv', index=False, sep='\t')
2003-09-28 2003-10-05 2003-10-12 2003-10-19 2003-10-26 2003-11-02 2003-11-09 2003-11-16 2003-11-23 2003-11-30 2003-12-07 2003-12-14 2003-12-21 2003-12-28 2004-01-04 2004-01-11 2004-01-18 2004-01-25 2004-02-01 2004-02-08 2004-02-15 2004-02-22 2004-02-29 2004-03-07 2004-03-14 2004-03-21 2004-03-28 2004-04-04 2004-04-11 2004-04-18 2004-04-25 2004-05-02 2004-05-09 2004-05-16 2004-05-23 2004-05-30 2004-06-06 2004-06-13 2004-06-20 2004-06-27 2004-07-04 2004-07-11 2004-07-18 2004-07-25 2004-08-01 2004-08-08 2004-08-15 2004-08-22 2004-08-29 2004-09-05 2004-09-12 2004-09-19 2004-09-26 2004-10-03 2004-10-10 2004-10-17 2004-10-24 2004-10-31 2004-11-07 2004-11-14 2004-11-21 2004-11-28 2004-12-05 2004-12-12 2004-12-19 2004-12-26 2005-01-02 2005-01-09 2005-01-16 2005-01-23 2005-01-30 2005-02-06 2005-02-13 2005-02-20 2005-02-27 2005-03-06 2005-03-13 2005-03-20 2005-03-27 2005-04-03 2005-04-10 2005-04-17 2005-04-24 2005-05-01 2005-05-08 2005-05-15 2005-05-22 2005-05-29 2005-06-05 2005-06-12 2005-06-19 2005-06-26 2005-07-03 2005-07-10 2005-07-17 2005-07-24 2005-07-31 2005-08-07 2005-08-14 2005-08-21 2005-08-28 2005-09-04 2005-09-11 2005-09-18 2005-09-25 2005-10-02 2005-10-09 2005-10-16 2005-10-23 2005-10-30 2005-11-06 2005-11-13 2005-11-20 2005-11-27 2005-12-04 2005-12-11 2005-12-18 2005-12-25 2006-01-01 2006-01-08 2006-01-15 2006-01-22 2006-01-29 2006-02-05 2006-02-12 2006-02-19 2006-02-26 2006-03-05 2006-03-12 2006-03-19 2006-03-26 2006-04-02 2006-04-09 2006-04-16 2006-04-23 2006-04-30 2006-05-07 2006-05-14 2006-05-21 2006-05-28 2006-06-04 2006-06-11 2006-06-18 2006-06-25 2006-07-02 2006-07-09 2006-07-16 2006-07-23 2006-07-30 2006-08-06 2006-08-13 2006-08-20 2006-08-27 2006-09-03 2006-09-10 2006-09-17 2006-09-24 2006-10-01 2006-10-08 2006-10-15 2006-10-22 2006-10-29 2006-11-05 2006-11-12 2006-11-19 2006-11-26 2006-12-03 2006-12-10 2006-12-17 2006-12-24 2006-12-31 2007-01-07 2007-01-14 2007-01-21 2007-01-28 2007-02-04 2007-02-11 2007-02-18 2007-02-25 2007-03-04 2007-03-11 2007-03-18 2007-03-25 2007-04-01 2007-04-08 2007-04-15 2007-04-22 2007-04-29 2007-05-06 2007-05-13 2007-05-20 2007-05-27 2007-06-03 2007-06-10 2007-06-17 2007-06-24 2007-07-01 2007-07-08 2007-07-15 2007-07-22 2007-07-29 2007-08-05 2007-08-12 2007-08-19 2007-08-26 2007-09-02 2007-09-09 2007-09-16 2007-09-23 2007-09-30 2007-10-07 2007-10-14 2007-10-21 2007-10-28 2007-11-04 2007-11-11 2007-11-18 2007-11-25 2007-12-02 2007-12-09 2007-12-16 2007-12-23 2007-12-30 2008-01-06 2008-01-13 2008-01-20 2008-01-27 2008-02-03 2008-02-10 2008-02-17 2008-02-24 2008-03-02 2008-03-09 2008-03-16 2008-03-23 2008-03-30 2008-04-06 2008-04-13 2008-04-20 2008-04-27 2008-05-04 2008-05-11 2008-05-18 2008-05-25 2008-06-01 2008-06-08 2008-06-15 2008-06-22 2008-06-29 2008-07-06 2008-07-13 2008-07-20 2008-07-27 2008-08-03 2008-08-10 2008-08-17 2008-08-24 2008-08-31 2008-09-07 2008-09-14 2008-09-21 2008-09-28 2008-10-05 2008-10-12 2008-10-19 2008-10-26 2008-11-02 2008-11-09 2008-11-16 2008-11-23 2008-11-30 2008-12-07 2008-12-14 2008-12-21 2008-12-28 2009-01-04 2009-01-11 2009-01-18 2009-01-25 2009-02-01 2009-02-08 2009-02-15 2009-02-22 2009-03-01 2009-03-08 2009-03-15 2009-03-22 2009-03-29 2009-04-05 2009-04-12 2009-04-19 2009-04-26 2009-05-03 2009-05-10 2009-05-17 2009-05-24 2009-05-31 2009-06-07 2009-06-14 2009-06-21 2009-06-28 2009-07-05 2009-07-12 2009-07-19 2009-07-26 2009-08-02 2009-08-09 2009-08-16 2009-08-23 2009-08-30 2009-09-06 2009-09-13 2009-09-20 2009-09-27 2009-10-04 2009-10-11 2009-10-18 2009-10-25 2009-11-01 2009-11-08 2009-11-15 2009-11-22 2009-11-29 2009-12-06 2009-12-13 2009-12-20 2009-12-27 2010-01-03 2010-01-10 2010-01-17 2010-01-24 2010-01-31 2010-02-07 2010-02-14 2010-02-21 2010-02-28 2010-03-07 2010-03-14 2010-03-21 2010-03-28 2010-04-04 2010-04-11 2010-04-18 2010-04-25 2010-05-02 2010-05-09 2010-05-16 2010-05-23 2010-05-30 2010-06-06 2010-06-13 2010-06-20 2010-06-27 2010-07-04 2010-07-11 2010-07-18 2010-07-25 2010-08-01 2010-08-08 2010-08-15 2010-08-22 2010-08-29 2010-09-05 2010-09-12 2010-09-19 2010-09-26 2010-10-03 2010-10-10 2010-10-17 2010-10-24 2010-10-31 2010-11-07 2010-11-14 2010-11-21 2010-11-28 2010-12-05 2010-12-12 2010-12-19 2010-12-26 2011-01-02 2011-01-09 2011-01-16 2011-01-23 2011-01-30 2011-02-06 2011-02-13 2011-02-20 2011-02-27 2011-03-06 2011-03-13 2011-03-20 2011-03-27 2011-04-03 2011-04-10 2011-04-17 2011-04-24 2011-05-01 2011-05-08 2011-05-15 2011-05-22 2011-05-29 2011-06-05 2011-06-12 2011-06-19 2011-06-26 2011-07-03 2011-07-10 2011-07-17 2011-07-24 2011-07-31 2011-08-07 2011-08-14 2011-08-21 2011-08-28 2011-09-04 2011-09-11 2011-09-18 2011-09-25 2011-10-02 2011-10-09 2011-10-16 2011-10-23 2011-10-30 2011-11-06 2011-11-13 2011-11-20 2011-11-27 2011-12-04 2011-12-11 2011-12-18 2011-12-25 2012-01-01 2012-01-08 2012-01-15 2012-01-22 2012-01-29 2012-02-05 2012-02-12 2012-02-19 2012-02-26 2012-03-04 2012-03-11 2012-03-18 2012-03-25 2012-04-01 2012-04-08 2012-04-15 2012-04-22 2012-04-29 2012-05-06 2012-05-13 2012-05-20 2012-05-27 2012-06-03 2012-06-10 2012-06-17 2012-06-24 2012-07-01 2012-07-08 2012-07-15 2012-07-22 2012-07-29 2012-08-05 2012-08-12 2012-08-19 2012-08-26 2012-09-02 2012-09-09 2012-09-16 2012-09-23 2012-09-30 2012-10-07 2012-10-14 2012-10-21 2012-10-28 2012-11-04 2012-11-11 2012-11-18 2012-11-25 2012-12-02 2012-12-09 2012-12-16 2012-12-23 2012-12-30 2013-01-06 2013-01-13 2013-01-20 2013-01-27 2013-02-03 2013-02-10 2013-02-17 2013-02-24 2013-03-03 2013-03-10 2013-03-17 2013-03-24 2013-03-31 2013-04-07 2013-04-14 2013-04-21 2013-04-28 2013-05-05 2013-05-12 2013-05-19 2013-05-26 2013-06-02 2013-06-09 2013-06-16 2013-06-23 2013-06-30 2013-07-07 2013-07-14 2013-07-21 2013-07-28 2013-08-04 2013-08-11 2013-08-18 2013-08-25 2013-09-01 2013-09-08 2013-09-15 2013-09-22 2013-09-29 2013-10-06 2013-10-13 2013-10-20 2013-10-27 2013-11-03 2013-11-10 2013-11-17 2013-11-24 2013-12-01 2013-12-08 2013-12-15 2013-12-22 2013-12-29 2014-01-05 2014-01-12 2014-01-19 2014-01-26 2014-02-02 2014-02-09 2014-02-16 2014-02-23 2014-03-02 2014-03-09 2014-03-16 2014-03-23 2014-03-30 2014-04-06 2014-04-13 2014-04-20 2014-04-27 2014-05-04 2014-05-11 2014-05-18 2014-05-25 2014-06-01 2014-06-08 2014-06-15 2014-06-22 2014-06-29 2014-07-06 2014-07-13 2014-07-20 2014-07-27 2014-08-03 2014-08-10 2014-08-17 2014-08-24 2014-08-31 2014-09-07 2014-09-14 2014-09-21 2014-09-28 2014-10-05 2014-10-12 2014-10-19 2014-10-26 2014-11-02 2014-11-09 2014-11-16 2014-11-23 2014-11-30 2014-12-07 2014-12-14 2014-12-21 2014-12-28 2015-01-04 2015-01-11 2015-01-18 2015-01-25 2015-02-01 2015-02-08 2015-02-15 2015-02-22 2015-03-01
Lat Long's in Google Source HTML code:
Next step is to grab this html file, regex maybe Albequerue to Z.