Skip to content

Instantly share code, notes, and snippets.

@jtrive84
Created December 24, 2016 02:16
Show Gist options
  • Save jtrive84/49f8a147956b88136e60e363c2a4b5b9 to your computer and use it in GitHub Desktop.
Save jtrive84/49f8a147956b88136e60e363c2a4b5b9 to your computer and use it in GitHub Desktop.
Sample Fire Claims table for DeMorgan's Laws blog post
CLAIM_ID EXPOSURE_ID STATE BLD_VALUE BLD_AGE CLAIM_AMT
695433 POL0004653 IL 1337609 7 1337609
621498 POL0002262 TN 509477 35 509477
818474 POL0009754 CT 953878 38 953878
785806 POL0002506 OR 106964 55 106964
799534 POL0002989 IL 469804 108 469804
729094 POL0005797 TN 894399 35 100000
610517 POL0005640 CT 532730 60 532730
888963 POL0005099 OR 1255253 34 1255253
607409 POL0003997 IL 688008 64 100000
888770 POL0005686 TN 927309 92 100000
877039 POL0005219 CT 77279 96 77279
606788 POL0001623 OR 764231 49 764231
604515 POL0009969 IL 735073 16 735073
620837 POL0003621 TN 830511 25 100000
843701 POL0002288 CT 1205030 35 1205030
844428 POL0001089 OR 114732 39 100000
823063 POL0003093 IL 869460 20 100000
890346 POL0009859 TN 431497 33 431497
605142 POL0005745 CT 1497641 40 1497641
818738 POL0005836 OR 262035 102 100000
824920 POL0004629 IL 247142 47 247142
739639 POL0008756 TN 748617 85 100000
836627 POL0008189 CT 1414577 99 1414577
627762 POL0007526 OR 1133024 79 1133024
750735 POL0004189 IL 282867 89 100000
781642 POL0006967 TN 1310043 84 100000
767931 POL0007908 CT 347268 22 100000
823195 POL0007986 OR 1154363 79 1154363
750538 POL0001735 IL 197206 35 197206
680346 POL0004264 TN 134624 107 134624
858170 POL0002671 CT 952792 19 952792
614633 POL0008219 OR 97820 29 97820
693308 POL0009752 IL 641651 114 641651
631695 POL0004005 TN 1154293 72 1154293
806339 POL0008581 CT 1283370 60 100000
693673 POL0001712 OR 1027399 88 1027399
799714 POL0006349 IL 1433762 48 1433762
635485 POL0004468 TN 206180 34 206180
753229 POL0001959 CT 1036632 105 100000
736171 POL0002684 OR 636510 25 100000
782967 POL0002551 IL 343811 90 343811
841135 POL0008433 TN 614533 39 614533
705447 POL0002447 CT 94938 100 94938
882439 POL0006095 OR 270521 77 270521
878576 POL0007638 IL 1018663 69 1018663
779478 POL0004930 TN 1257542 9 1257542
840446 POL0006135 CT 1417885 88 1417885
644318 POL0006144 OR 243516 116 100000
857803 POL0007543 IL 901877 41 901877
821459 POL0005489 TN 766251 21 100000
643555 POL0009681 CT 664181 65 664181
725641 POL0005261 OR 1459240 5 1459240
894446 POL0001336 IL 1191244 109 1191244
864618 POL0001979 TN 1168928 116 1168928
863593 POL0008292 CT 1315796 77 1315796
701564 POL0005593 OR 1052354 53 1052354
880017 POL0004672 IL 367783 9 367783
770451 POL0008171 TN 285283 17 285283
635416 POL0006582 CT 125796 23 100000
744323 POL0009284 OR 375071 47 375071
808305 POL0004216 IL 1385233 21 1385233
845957 POL0001374 TN 1376641 21 1376641
828391 POL0009897 CT 314909 60 314909
820831 POL0009955 OR 89589 62 89589
648524 POL0009647 IL 920393 77 920393
665926 POL0004289 TN 86629 23 86629
857414 POL0007723 CT 1483745 59 1483745
751390 POL0002384 OR 1066147 34 1066147
886161 POL0009248 IL 430333 77 430333
880660 POL0003092 TN 1459628 90 1459628
745702 POL0002862 CT 706098 111 100000
742734 POL0003039 OR 576287 33 576287
851775 POL0002470 IL 132007 112 132007
829237 POL0009432 TN 1384747 38 1384747
731824 POL0001847 CT 794257 37 794257
658527 POL0004244 OR 284187 93 100000
777119 POL0005494 IL 274557 42 100000
746169 POL0007932 TN 1109262 98 100000
855434 POL0008473 CT 1214808 24 100000
716737 POL0004389 OR 1379189 110 1379189
891685 POL0004530 IL 919957 84 919957
671605 POL0006993 TN 1337575 21 1337575
899868 POL0003035 CT 758507 112 758507
602086 POL0002094 OR 433883 19 433883
675398 POL0004182 IL 1035434 103 1035434
613394 POL0007199 TN 776124 34 100000
734922 POL0003415 CT 1349610 16 100000
672210 POL0005681 OR 707879 34 707879
628230 POL0004824 IL 914306 117 914306
655131 POL0001178 TN 841907 83 841907
847131 POL0009738 CT 852178 59 852178
894427 POL0001432 OR 106161 98 100000
894521 POL0005015 IL 702441 71 100000
891156 POL0001742 TN 912279 90 100000
708033 POL0009379 CT 118377 79 100000
815716 POL0006899 OR 1163155 108 1163155
795467 POL0004572 IL 161087 59 161087
859999 POL0003060 TN 631512 45 100000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment