Skip to content

Instantly share code, notes, and snippets.

@RoboDonut

RoboDonut/geo_test.csv

Last active March 25, 2021 15:57
Show Gist options
  • Save RoboDonut/6876d91f79813a254b9d8016beeccf4a to your computer and use it in GitHub Desktop.
Save RoboDonut/6876d91f79813a254b9d8016beeccf4a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
geo_test.csv
date smsa_name id x y longitude latitude z death_interval time_of_onset
2020-02-29 Other, Alabama 1 973830.5625930182 -385910.0365281413 -85.416322747473 33.56694949920062 0 1440 2020-02-29 00:00:00.000000
2020-03-01 Other, Alabama 2 916301.3726971925 -667279.5138475613 -86.34651430654918 31.112041234467707 0 1440 2020-03-01 00:00:00.000000
2020-03-02 Other, Alabama 3 949536.0082880756 -592849.6876284727 -85.9160385509501 31.74621451341501 0 1440 2020-03-02 00:00:00.000000
2020-03-03 Other, Alabama 4 812546.8106928112 -680251.0424732385 -87.44558838237093 31.085179100730482 0 1440 2020-03-03 00:00:00.000000
2020-03-04 Other, Alabama 5 816509.7356431917 -347691.03829442064 -87.0762691649133 34.05149282966826 0 1440 2020-03-04 00:00:00.000000
2020-03-05 Other, Alabama 6 754297.1845343699 -440542.22799689707 -87.83960863416344 33.27363778650419 0 1440 2020-03-05 00:00:00.000000
2020-03-06 Other, Alabama 7 944837.0910469124 -312752.6556362087 -85.64260644970159 34.246195283079544 0 1440 2020-03-06 00:00:00.000000
2020-03-07 Other, Alabama 8 742947.1767873063 -443021.2508684552 -87.96407244685975 33.26016653078043 0 1440 2020-03-07 00:00:00.000000
2020-03-08 Other, Alabama 9 726742.9204542539 -666210.5488232728 -88.33288570740827 31.27667797500049 0 1440 2020-03-08 00:00:00.000000
2020-03-09 Other, Alabama 10 954060.6856160384 -499189.7094081039 -85.76160346745995 32.577466833470375 0 1440 2020-03-09 00:00:00.000000
2020-03-10 Other, Alabama 11 860863.9562050905 -656690.0062848665 -86.91627149115801 31.255813901861824 0 1440 2020-03-10 00:00:00.000000
2020-03-11 Other, Alabama 12 811546.5138266963 -560888.2565415011 -87.34188655980489 32.15365587973401 0 1440 2020-03-11 00:00:00.000000
2020-03-12 Other, Alabama 13 753054.0923933599 -755174.8255940218 -88.13406683708754 30.45982730720414 0 1440 2020-03-12 00:00:00.000000
2020-03-13 Other, Alabama 14 744716.9846490994 -661910.9571693148 -88.1403697066654 31.30200854088113 0 720 2020-03-13 00:00:00.000000
2020-03-13 Other, Alabama 15 978613.0003485953 -503070.8122590803 -85.50481556393244 32.51890419196553 0 720 2020-03-13 12:00:00.000000
2020-03-14 Other, Alabama 16 743675.6908235092 -414954.7314158868 -87.93051472944347 33.51005723752195 0 720 2020-03-14 00:00:00.000000
2020-03-14 Other, Alabama 17 917672.8380391445 -339800.7641509082 -85.96931703406821 34.03162271540114 0 720 2020-03-14 12:00:00.000000
2020-03-15 Other, Alabama 18 946985.4232062502 -600160.2484395561 -85.95110244066805 31.68335651983498 0 720 2020-03-15 00:00:00.000000
2020-03-15 Other, Alabama 19 861015.0995510666 -325079.0024073658 -86.56851685907206 34.21445525306228 0 720 2020-03-15 12:00:00.000000
2020-03-16 Other, Alabama 20 830255.9093201528 -355161.99532762857 -86.93470376742029 33.97331991649558 0 720 2020-03-16 00:00:00.000000
2020-03-16 Other, Alabama 21 794773.0241294934 -704770.1193190266 -87.65434573522037 30.87975502686202 0 720 2020-03-16 12:00:00.000000
2020-03-17 Other, Alabama 22 791713.6603416647 -421306.37730152474 -87.41821653247023 33.41576425883109 0 720 2020-03-17 00:00:00.000000
2020-03-17 Other, Alabama 23 784689.1935872359 -550122.0969355099 -87.61680465713201 32.271436049781244 0 720 2020-03-17 12:00:00.000000
2020-03-18 Other, Alabama 24 927799.1268777155 -480058.8567096207 -86.01985335591388 32.77300238794915 0 720 2020-03-18 00:00:00.000000
2020-03-18 Other, Alabama 25 996576.4043081594 -470312.28413310775 -85.2742939801478 32.79282069394881 0 720 2020-03-18 12:00:00.000000
2020-03-19 Other, Alabama 26 828945.8739020985 -488150.90566125675 -87.08473832985517 32.78877114680728 0 480 2020-03-19 00:00:00.000000
2020-03-19 Other, Alabama 27 823271.2739092 -656799.0000823775 -87.31079255842829 31.286385551617883 0 480 2020-03-19 08:00:00.000000
2020-03-19 Other, Alabama 28 844729.8788471122 -592206.9020424394 -87.02140752379249 31.8461770864637 0 480 2020-03-19 16:00:00.000000
2020-03-20 Other, Alabama 29 818161.5356364195 -291029.7549135408 -86.99985037569047 34.5546609574068 0 480 2020-03-20 00:00:00.000000
2020-03-20 Other, Alabama 30 826900.8114831052 -262811.1992424083 -86.87458311975045 34.79836950358249 0 480 2020-03-20 08:00:00.000000
2020-03-20 Other, Alabama 31 815820.7262548702 -532897.2885882774 -87.26918284424337 32.400206264178706 0 480 2020-03-20 16:00:00.000000
2020-03-21 Other, Alabama 32 797799.2037947201 -717487.7230555342 -87.63445775503571 30.76340610889089 0 480 2020-03-21 00:00:00.000000
2020-03-21 Other, Alabama 33 855664.0548294421 -606553.0791447574 -86.92041553825314 31.708633110702095 0 480 2020-03-21 08:00:00.000000
2020-03-21 Other, Alabama 34 726683.0413762875 -420382.9238218148 -88.11891762849856 33.474378188895926 0 480 2020-03-21 16:00:00.000000
2020-03-22 Other, Alabama 35 944329.6578540723 -532395.5465622366 -85.90295784369434 32.29068244944238 0 480 2020-03-22 00:00:00.000000
2020-03-22 Other, Alabama 36 730673.0577129557 -730347.4127499498 -88.34598123022154 30.69895862066093 0 480 2020-03-22 08:00:00.000000
2020-03-22 Other, Alabama 37 765532.967181678 -588908.9236000305 -87.85586608941111 31.93962454786419 0 480 2020-03-22 16:00:00.000000
2020-03-23 Other, Alabama 38 801982.7443431565 -770337.3156531076 -87.6394435056365 30.286236497980234 0 480 2020-03-23 00:00:00.000000
2020-03-23 Other, Alabama 39 820946.0191926418 -524546.7401748786 -87.20639815389762 32.47054775689107 0 480 2020-03-23 08:00:00.000000
2020-03-23 Other, Alabama 40 860990.8794438086 -310897.9715004198 -86.55339005132114 34.34069842501094 0 480 2020-03-23 16:00:00.000000
2020-03-24 Other, Alabama 41 821243.6542557124 -668047.2725474081 -87.34285952894983 31.187368158388914 0 480 2020-03-24 00:00:00.000000
2020-03-24 Other, Alabama 42 1017118.3148969634 -514106.99855299515 -85.10891152173626 32.3817802956292 0 480 2020-03-24 08:00:00.000000
2020-03-24 Other, Alabama 43 782910.6139191566 -406036.22363495437 -87.49835889540907 33.55901677139807 0 480 2020-03-24 16:00:00.000000
2020-03-25 Other, Alabama 44 997060.26505169 -597643.824985848 -85.42104410052244 31.657112289328285 0 480 2020-03-25 00:00:00.000000
2020-03-25 Other, Alabama 45 907957.5255824873 -621658.0195225235 -86.38535904686394 31.52750358760191 0 480 2020-03-25 08:00:00.000000
2020-03-25 Other, Alabama 46 781787.1607720114 -489136.14017812454 -87.59013950921351 32.81845323990863 0 480 2020-03-25 16:00:00.000000
2020-03-26 Other, Alabama 47 930637.6138647426 -308091.6201100532 -85.79159196538745 34.3013601640415 0 480 2020-03-26 00:00:00.000000
2020-03-26 Other, Alabama 48 709972.0010979696 -550878.4350966929 -88.41212104840585 32.320930315889136 0 480 2020-03-26 08:00:00.000000
2020-03-26 Other, Alabama 49 892388.7709227961 -276427.85137983895 -86.17232564011273 34.61894693235585 0 480 2020-03-26 16:00:00.000000
2020-03-27 Other, Alabama 50 965418.9138452639 -393069.5910702721 -85.51554711224874 33.51157177633466 0 480 2020-03-27 00:00:00.000000
2020-03-27 Other, Alabama 51 1035969.0518043217 -650131.3401609791 -85.07553180134146 31.14905308009785 0 480 2020-03-27 08:00:00.000000
2020-03-27 Other, Alabama 52 781638.4128077909 -750399.0860148905 -87.83265685807882 30.48098533222158 0 480 2020-03-27 16:00:00.000000
2020-03-28 Other, Alabama 53 841587.4940847962 -588770.8287207371 -87.05118145821548 31.879543869815308 0 480 2020-03-28 00:00:00.000000
2020-03-28 Other, Alabama 54 917615.7097133833 -366159.5957512806 -86.00014187372297 33.7971032758917 0 480 2020-03-28 08:00:00.000000
2020-03-28 Other, Alabama 55 727091.382381252 -478253.9542654684 -88.16612858939013 32.957465173337376 0 480 2020-03-28 16:00:00.000000
2020-03-29 Other, Alabama 56 801029.8331078723 -558134.9278586725 -87.4508419603697 32.18679013128007 0 480 2020-03-29 00:00:00.000000
2020-03-29 Other, Alabama 57 972785.2615467524 -510248.2369788212 -85.57522336330355 32.46066949142965 0 480 2020-03-29 08:00:00.000000
2020-03-29 Other, Alabama 58 794278.075108842 -319999.51462907944 -87.2902088212782 34.316576532855855 0 480 2020-03-29 16:00:00.000000
2020-03-30 Other, Alabama 59 914165.5959362132 -240631.2098613106 -85.89250726124759 34.91682395899847 0 480 2020-03-30 00:00:00.000000
2020-03-30 Other, Alabama 60 994901.0583567009 -664450.2171231066 -85.52160363158961 31.062625663419844 0 480 2020-03-30 08:00:00.000000
2020-03-30 Other, Alabama 61 778741.8389757103 -580377.0742236528 -87.70814926754119 32.005677613853614 0 480 2020-03-30 16:00:00.000000
2020-03-31 Other, Alabama 62 721207.6807926674 -283436.11121822667 -88.05412888833418 34.699477870654924 0 480 2020-03-31 00:00:00.000000
2020-03-31 Other, Alabama 63 799146.3818084195 -644834.2660543285 -87.5528659847586 31.412982938140043 0 480 2020-03-31 08:00:00.000000
2020-03-31 Other, Alabama 64 906445.3005994264 -586342.6971108355 -86.36347187339884 31.844393628533485 0 480 2020-03-31 16:00:00.000000
2020-04-01 Other, Alabama 65 931359.5639171333 -665357.0488008929 -86.18690422660816 31.115393004795784 0 480 2020-04-01 00:00:00.000000
2020-04-01 Other, Alabama 66 832721.6478830216 -302728.8258386026 -86.85301136419648 34.438105262640086 0 480 2020-04-01 08:00:00.000000
2020-04-01 Other, Alabama 67 898200.3868836313 -549771.0475662918 -86.41143447483097 32.178419432538824 0 480 2020-04-01 16:00:00.000000
2020-04-02 Other, Alabama 68 763028.4357996084 -685236.4691571625 -87.96877811186634 31.079327466316524 0 480 2020-04-02 00:00:00.000000
2020-04-02 Other, Alabama 69 924643.550266358 -607742.107706273 -86.19475349740593 31.636558243387874 0 480 2020-04-02 08:00:00.000000
2020-04-02 Other, Alabama 70 821819.0379419076 -682225.2816649053 -87.35039314924789 31.059966027685096 0 480 2020-04-02 16:00:00.000000
2020-04-03 Other, Alabama 71 908992.2915927867 -455432.5273175086 -86.19347235731976 33.010021089485086 0 480 2020-04-03 00:00:00.000000
2020-04-03 Other, Alabama 72 774159.6871222216 -303166.05637359084 -87.49315148011902 34.482786205284675 0 480 2020-04-03 08:00:00.000000
2020-04-03 Other, Alabama 73 949589.011637225 -586835.7886825192 -85.90872348933806 31.799858109383095 0 480 2020-04-03 16:00:00.000000
2020-04-04 Other, Alabama 74 919330.9558024586 -463436.0541601662 -86.09170784167097 32.929096081616535 0 480 2020-04-04 00:00:00.000000
2020-04-04 Other, Alabama 75 920270.2668376984 -433712.005425959 -86.04823234322079 33.19308089621824 0 480 2020-04-04 08:00:00.000000
2020-04-04 Other, Alabama 76 712252.9478032619 -610782.4850011914 -88.43867827078031 31.78340478118064 0 480 2020-04-04 16:00:00.000000
2020-04-05 Other, Alabama 77 937837.8535409082 -618845.5596075366 -86.06810790273113 31.525079124498816 0 480 2020-04-05 00:00:00.000000
2020-04-05 Other, Alabama 78 922888.4648473192 -328861.6795965995 -85.9000738968799 34.12401326544323 0 480 2020-04-05 08:00:00.000000
2020-04-05 Other, Alabama 79 790056.432836669 -345511.6518229694 -87.36160540025212 34.092746917055344 0 480 2020-04-05 16:00:00.000000
2020-04-06 Other, Alabama 80 852293.7383737188 -255965.3851851064 -86.58869771944754 34.83717269067094 0 480 2020-04-06 00:00:00.000000
2020-04-06 Other, Alabama 81 810597.7411801127 -648745.2919496987 -87.43618805301769 31.36878520991726 0 480 2020-04-06 08:00:00.000000
2020-04-06 Other, Alabama 82 894830.4088102598 -479921.0825155393 -86.37187566982625 32.804663136427095 0 480 2020-04-06 16:00:00.000000
2020-04-07 Other, Alabama 83 788031.7324337584 -666705.9674716032 -87.68991082769271 31.22599048839559 0 480 2020-04-07 00:00:00.000000
2020-04-07 Other, Alabama 84 878095.8440849443 -275924.816689114 -86.32807517727082 34.636509117066424 0 480 2020-04-07 08:00:00.000000
2020-04-07 Other, Alabama 85 903741.1435471115 -267215.53493719845 -86.03761530971587 34.6903183828622 0 480 2020-04-07 16:00:00.000000
2020-04-08 Other, Alabama 86 830103.3279718795 -617638.6960334074 -87.20093166277154 31.631078914263487 0 480 2020-04-08 00:00:00.000000
2020-04-08 Other, Alabama 87 947802.0574901734 -331970.46009370853 -85.63325116240308 34.072405202214405 0 480 2020-04-08 08:00:00.000000
2020-04-08 Other, Alabama 88 931858.508718152 -610567.9019239184 -86.1218950436791 31.604615919190934 0 480 2020-04-08 16:00:00.000000
2020-04-09 Other, Alabama 89 965420.7483829972 -494324.19843215006 -85.63498030923488 32.60981596507734 0 720 2020-04-09 00:00:00.000000
2020-04-09 Other, Alabama 90 965566.5184584478 -399389.3149184225 -85.52149394883342 33.455182885269316 0 720 2020-04-09 12:00:00.000000
2020-04-10 Other, Alabama 91 711904.1517080028 -519219.0511753957 -88.36443146254334 32.60255807128544 0 720 2020-04-10 00:00:00.000000
2020-04-10 Other, Alabama 92 788350.8855661025 -608365.846302517 -87.63253277865083 31.747830843665774 0 720 2020-04-10 12:00:00.000000
2020-04-11 Other, Alabama 93 782076.9143515673 -707269.1625981799 -87.78925709892208 30.867297416572754 0 720 2020-04-11 00:00:00.000000
2020-04-11 Other, Alabama 94 772670.0289209307 -295182.5341589403 -87.50160929830025 34.555082016152326 0 720 2020-04-11 12:00:00.000000
2020-04-12 Other, Alabama 95 938730.6820193996 -487595.4521620201 -85.91171559094651 32.695492294308124 0 720 2020-04-12 00:00:00.000000
2020-04-12 Other, Alabama 96 786318.4633434251 -607361.1166040142 -87.65305953605478 31.758420425043244 0 720 2020-04-12 12:00:00.000000
2020-04-13 Other, Alabama 97 992860.2989175292 -671813.1996266153 -85.55141578176 30.998837641662515 0 720 2020-04-13 00:00:00.000000
2020-04-13 Other, Alabama 98 765027.1623404537 -344439.58137064084 -87.63280860865335 34.12230865726113 0 720 2020-04-13 12:00:00.000000
2020-04-14 Other, Alabama 99 958513.8121346515 -675575.6416529345 -85.91429795831279 30.998504806317992 0 720 2020-04-14 00:00:00.000000
2020-04-14 Other, Alabama 100 858665.9131324328 -646796.9181139168 -86.92939077695482 31.346200153916612 0 720 2020-04-14 12:00:00.000000
2020-04-15 Other, Alabama 101 829641.1538637184 -526092.1211510481 -87.11534192882182 32.44950606176609 0 720 2020-04-15 00:00:00.000000
2020-04-15 Other, Alabama 102 960970.0376254619 -592473.5651392022 -85.79510900936367 31.738633775570964 0 720 2020-04-15 12:00:00.000000
2020-04-16 Other, Alabama 103 798589.0806927092 -570514.3046278268 -87.48855344574753 32.078119083029755 0 720 2020-04-16 00:00:00.000000
2020-04-16 Other, Alabama 104 765753.2135711059 -269183.44212438795 -87.55193100656254 34.792117225911824 0 720 2020-04-16 12:00:00.000000
2020-04-17 Other, Alabama 105 719692.5850392965 -274714.1479141873 -88.06273663933425 34.7783119017903 0 720 2020-04-17 00:00:00.000000
2020-04-17 Other, Alabama 106 744890.0191938643 -606626.0845719961 -88.09009943274827 31.796773410818396 0 720 2020-04-17 12:00:00.000000
2020-04-18 Other, Alabama 107 901390.9998639991 -614959.0085893087 -86.44731854971762 31.593309128170038 0 720 2020-04-18 00:00:00.000000
2020-04-18 Other, Alabama 108 768638.3705824433 -332627.15884283645 -87.58210397949246 34.22472097322997 0 720 2020-04-18 12:00:00.000000
2020-04-19 Other, Alabama 109 879853.3115686595 -498767.1811262724 -86.55204736095669 32.650024920770726 0 720 2020-04-19 00:00:00.000000
2020-04-19 Other, Alabama 110 729116.2701316298 -293051.1533873613 -87.97633081221652 34.60787922123186 0 720 2020-04-19 12:00:00.000000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment