Created
November 19, 2014 17:16
-
-
Save datadave/c9b95cdd022fea1b5006 to your computer and use it in GitHub Desktop.
Sample Loan Data
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| the_geom | addr_state | funded_amnt | emp_length_clean | annual_inc | grade_clean | loan_status_clean | count | cartodb_georef_status | cartodb_id | created_at | updated_at | stategeo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0101000020E6100000928C9C853D9355C01B47ACC5A7304040 | AL | 13758.83721 | 6.176744 | 64568.61067 | 5.07907 | 0.737984 | 645 | 1 | 2 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000000F45813E911157C064E94317D45F4140 | AR | 12055.41775 | 5.955614 | 59565.5623 | 5.250653 | 0.780679 | 383 | 1 | 3 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000005A423EE8D9045CC06E0D6C9560B94040 | AZ | 13198.65455 | 5.428364 | 66668.05911 | 5.184 | 0.782545 | 1375 | 1 | 4 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000CF66D5E76A5F5EC0E0A128D0274A4340 | CA | 13938.36698 | 5.712629 | 74739.95478 | 5.174948 | 0.795238 | 9660 | 1 | 5 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E610000088F4DBD7813F5AC0415BCEA5B8DE4340 | CO | 14271.60633 | 5.504072 | 69765.42934 | 5.159276 | 0.80543 | 1105 | 1 | 6 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000006536C824232B52C07D3F355EBAE14440 | CT | 13879.20702 | 5.705811 | 76104.40374 | 5.106538 | 0.783293 | 826 | 1 | 7 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000EEB1F4A10B4253C075ABE7A4F7714340 | DC | 14222.10366 | 4.152439 | 80732.03634 | 5.237805 | 0.865854 | 164 | 1 | 8 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000BA4E232D95E152C0DCBA9BA73A944340 | DE | 14388.17829 | 5.48062 | 78010.64798 | 5.170543 | 0.767442 | 129 | 1 | 9 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000D5E76A2BF61155C00EC347C494703E40 | FL | 13070.91377 | 5.386873 | 67399.68257 | 5.157272 | 0.747233 | 3885 | 1 | 10 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000DEC83CF2071955C0AB7823F3C8DF4040 | GA | 14413.28458 | 5.730652 | 76099.28876 | 5.199878 | 0.783668 | 1641 | 1 | 11 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000009CC420B072BB63C0CBDB114E0B4E3540 | HI | 14926.90355 | 6.553299 | 68352.50868 | 4.936548 | 0.78934 | 394 | 1 | 12 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E610000028ED0DBE306956C01F11532289E64340 | IL | 14311.32501 | 5.686139 | 72000.41836 | 5.132767 | 0.794477 | 1883 | 1 | 13 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E610000052EDD3F1988955C0D87C5C1B2AE24340 | IN | 14337.06897 | 6.241379 | 66594.67099 | 4.929006 | 0.791075 | 493 | 1 | 14 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000AD6EF59CF4EA57C0672C9ACE4E864340 | KS | 13945.05495 | 6.195604 | 65889.95767 | 5.182418 | 0.795604 | 455 | 1 | 15 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000A054FB743C3855C02137C30DF8184340 | KY | 13626.82556 | 6.21501 | 65874.03572 | 5.111562 | 0.776876 | 493 | 1 | 16 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000008143A852B38F5DC0DE54A4C2D8064140 | LA | 14195.25602 | 5.810241 | 71820.84233 | 5.060241 | 0.777108 | 664 | 1 | 17 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000001283C0CAA1C351C012312592E82D4540 | MA | 15493.68607 | 5.671125 | 76100.02851 | 5.243116 | 0.780488 | 1271 | 1 | 18 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000471630815B1F53C0FE7DC685037D4340 | MD | 14728.9759 | 5.80241 | 82321.09431 | 5.059438 | 0.791165 | 1245 | 1 | 19 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000D34D6210582355C02F51BD35B05D4540 | MI | 13937.84054 | 6.076122 | 65026.07985 | 5.182692 | 0.751603 | 1248 | 1 | 20 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000146F641EF94557C0E97DE36BCF784640 | MN | 13799.18172 | 6.107223 | 67473.64944 | 5.128668 | 0.79684 | 886 | 1 | 21 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000ECFA05BB610B57C09964E42CEC494340 | MO | 13285.39823 | 5.816688 | 64287.70312 | 5.175727 | 0.767383 | 791 | 1 | 22 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E610000053D0ED258D8B56C035D252793B264040 | MS | 29975 | 10 | 75000 | 2 | 1 | 1 | 1 | 23 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E610000036AB3E575B015CC0963E74417D4B4740 | MT | 13211.875 | 6.31875 | 59750.18375 | 5.25625 | 0.81875 | 160 | 1 | 24 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000B3075A8121A953C0295778978BE44140 | NC | 13544.1105 | 5.793564 | 67272.38523 | 5.104432 | 0.777778 | 1647 | 1 | 25 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000008C84B69C4B2D58C08EAF3DB324684440 | NE | 11200 | 4 | 160000 | 7 | 1 | 1 | 1 | 26 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000382D78D157E251C04A0C022B879A4540 | NH | 13387.40458 | 5.977099 | 68512.49542 | 5.251908 | 0.816794 | 262 | 1 | 27 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000462575029AB052C0EB39E97DE31B4440 | NJ | 14229.57508 | 5.745534 | 79411.87196 | 5.074843 | 0.740705 | 2071 | 1 | 28 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000323D6189077C5AC00DA661F888D84140 | NM | 14847.49071 | 5.944238 | 72367.12364 | 5.185874 | 0.747212 | 269 | 1 | 29 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000D7C0560916F15DC0DAE1AFC91A954340 | NV | 13425.7622 | 5.6 | 67001.02407 | 5.113415 | 0.728049 | 820 | 1 | 30 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E610000071C971A7748052C0ACADD85F765B4440 | NY | 14017.6748 | 5.573713 | 75372.13566 | 5.105188 | 0.758868 | 4877 | 1 | 31 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000002A6F47382DC054C01E8A027D22FB4340 | OH | 13586.7278 | 6.104247 | 64950.11369 | 5.008366 | 0.779923 | 1554 | 1 | 32 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000004E3BFC35596158C0B13385CE6BBC4140 | OK | 13216.63067 | 5.723542 | 65057.02605 | 5.228942 | 0.75162 | 463 | 1 | 33 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000384F75C8CDC25EC01D554D1075774640 | OR | 12636.64736 | 5.635779 | 61501.9079 | 5.239382 | 0.803089 | 777 | 1 | 34 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000003563D174763853C0139B8F6B43214440 | PA | 13483.41628 | 5.929157 | 68773.80909 | 5.124122 | 0.763466 | 1708 | 1 | 35 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000DC114E0B5EDA51C00CEA5BE674E94440 | RI | 13174.33036 | 6.267857 | 68603.42411 | 5.160714 | 0.732143 | 224 | 1 | 36 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000000D8E9257E74254C09C4B7155D9FF4040 | SC | 13693.6747 | 5.724613 | 67095.72995 | 5.113597 | 0.781411 | 581 | 1 | 37 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E610000083177D05691659C0906B43C5382F4640 | SD | 13380.80357 | 5.839286 | 56325.01321 | 5.160714 | 0.839286 | 112 | 1 | 38 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000008BC3995FCDB155C01A51DA1B7C154240 | TN | 12546.9186 | 5.806977 | 63113.67765 | 4.897674 | 0.732558 | 430 | 1 | 39 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E610000053D0ED258D6F58C094BC3AC780443E40 | TX | 14449.8045 | 5.597263 | 76891.05924 | 5.117546 | 0.800587 | 4092 | 1 | 40 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000CCE9B298D8F85BC02F698CD651614440 | UT | 13858.56436 | 6.223762 | 69778.19729 | 5.225743 | 0.821782 | 505 | 1 | 41 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E610000043FAEDEBC05B53C03D7958A835C54240 | VA | 14683.03101 | 5.610298 | 77641.5993 | 5.06261 | 0.801053 | 1709 | 1 | 42 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000009EEA909BE12452C00C93A98251214640 | VT | 12179.65116 | 6.406977 | 60903.25581 | 5.22093 | 0.790698 | 86 | 1 | 43 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000ABA8C1340CB95EC0D482177D05854740 | WA | 13994.80198 | 5.744859 | 72008.5136 | 5.131759 | 0.772277 | 1313 | 1 | 44 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E61000002CEC6987BF5856C0211FF46C56894540 | WI | 13507.24522 | 6.208599 | 62361.41368 | 5.191083 | 0.792994 | 628 | 1 | 45 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000F0DC7BB8E46854C0062FFA0AD22C4340 | WV | 14388.12217 | 6.226244 | 68115.65041 | 5.131222 | 0.850679 | 221 | 1 | 46 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000C616821C94345AC0616C21C841914440 | WY | 15045.08547 | 5.794872 | 67273.19521 | 5.128205 | 0.837607 | 117 | 1 | 47 | 2014-11-16 03:10:57+00 | 2014-11-16 03:11:08+00 | ||
| 0101000020E6100000E04A766C04CD60C0A6D0798D5D264D40 | AK | 14897.18543 | 5.596026 | 70933.51656 | 5.07947 | 0.821192 | 151 | 1 | 1 | 2014-11-16 03:10:57+00 | 2014-11-19 16:28:36.5153+00 | USA |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment