"ID","JURISDICTNAME","ISPARTICIPANT","SUBMISSIONINTERVAL","SUBMETHOD","COUNTRY","NUMRECORDS","DTLASTPROCACTION","CURRENTPROCSTATUS","STATUS","LICNUMFORMAT_REGEX","LICNUMFORMAT_DESC","LICNUMFORMAT_PERCENTMATCH"
78,"Saskatchewan","Yes","Monthly     ","FTP       ","Canada",1833,"2018-11-23 08:10:03","Success","Active","^\d+$","Digits only; 1 or more digits without leading zeroes.",100.0
41,"Texas","Yes","Daily","WEB       ","USA",221103,"2018-12-09 08:53:07","Success","Active","^\d{4,}$","Digits only; 4 or more digits without leading zeroes.",99.99954772210236
12,"Guam","No","","NA        ","USA",," ","","Inactive","","",
22,"Missouri","Yes","Daily       ","FTP       ","USA",38956,"2018-12-09 06:20:42","Success","Active","^\d{10}$","Digits only; exactly 10 digits without leading zeroes.",100.0
84,"NAR","Yes","Monthly     ","FTP","NAR",1368957,"2018-11-20 06:49:32","Success","Active","","",0.0
70,"New Brunswick","No","","NA        ","Canada",," ","","Inactive","","",
48,"Wyoming","Yes","Monthly     ","FTP","USA",3369,"2018-11-21 09:30:06","Success","Active","^(RE\-)?\d{3,}$","Mixed; prefix indicating license type (optional), followed by 3 or more digits without leading zeroes.",99.85158800831107
14,"Idaho","Yes","Daily       ","FTP       ","USA",29889,"2018-12-09 05:10:33","Success","Active","^\d+$","Digits only; 1 or more digits without leading zeroes.",100.0
23,"Montana","Yes","Monthly","EMAIL     ","USA",6599,"2018-09-06 06:25:11","Success","Active","^RRE\-(BRO|RBS|RPM)\-LIC\-\d+$","Mixed; prefix indicating license type followed by 1 or more digits without leading zeroes.",100.0
32,"Ohio","Yes","Daily","WEB","USA",100856,"2018-12-09 07:27:15","Success","Active","^(BRK|SAL)\.\d{10}$","Mixed; prefix indicating license type, followed by a dot, followed by exactly 10 digits with leading zeroes.",100.0
52,"Illinois","No","Monthly     ","NA","USA",,"2009-03-02 00:00:00","Data Deleted","Inactive","","",
53,"Indiana","Yes","Weekly","FTP","USA",32559,"2018-12-04 05:20:34","Success","Active","^RB\d{8}$","Mixed; prefix indicating license type followed by exactly 8 digits with leading zeroes.",100.0
25,"Nevada","Yes","Monthly","FTP       ","USA",22503,"2018-11-16 06:41:13","Success","Active","^\d{7}$","Digits only; exactly 7 digits with leading zeroes.",99.99555614806914
1,"Alabama","Yes","Daily  ","FTP       ","USA",77212,"2018-12-08 04:01:16","Success","Active","^\d{9}$","Digits only; exactly 9 digits with leading zeroes.",100.0
30,"North Carolina","Yes","Daily       ","FTP       ","USA",68743,"2018-12-05 07:06:30","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
31,"North Dakota","Yes","Weekly    ","EMAIL     ","USA",2309,"2018-06-23 07:10:06","Error","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
11,"Georgia","Yes","Monthly     ","FTP       ","USA",64026,"2018-12-04 05:01:25","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",99.99843813450785
21,"Mississippi","Yes","Daily       ","FTP       ","USA",10265,"2018-12-09 06:15:17","Success","Active","^(S\-)?\d{3,}$","Mixed; prefix indicating license type (salespersons only) followed by 3 or more digits without leading zeroes.",99.97077447637604
51,"West Virginia","Yes","Daily","FTP       ","USA",5732,"2018-12-09 09:20:11","Success","Active","^WV\d{7}$","Mixed; literal 'WV' followed by exactly 7 digits with leading zeroes.",93.5450104675506
26,"New Hampshire","Yes","Intermittent","EMAIL     ","USA",11255,"2018-12-05 06:45:33","Success","Active","^\d{6}$","Digits only; exactly 6 digits with leading zeroes.",100.0
38,"South Carolina","Yes","Weekly","FTP       ","USA",42750,"2018-12-04 08:20:50","Success","Active","^\d{4,}$","Digits only; 4 or more digits without leading zeroes.",99.9906432748538
40,"Tennessee","Yes","Daily","FTP","USA",29847,"2018-03-26 08:41:25","Error","Inactive","^\d{3,}$","Digits only; 3 or more digits without leading zeroes.",100.0
44,"Virginia","No","","NA        ","USA",," ","","Inactive","","",
43,"Vermont","Yes","Daily    ","MANUAL","USA",2166,"2017-10-27 18:15:33","Success","Inactive","^08(1|2)\.\d{7}$","Mixed; prefix indicating license type, followed by a dot, followed by exactly 7 digits with leading zeroes.",100.0
6,"Colorado","Yes","Intermittent","FTP","USA",46862,"2018-09-07 04:36:02","Success","Active","^(EA|EI|ER|FA|IA|II|IR)\.\d{9}$","Mixed; prefix indicating license type, followed by a dot, followed by exactly 9 digits with leading zeroes.",100.0
45,"Virgin Islands","No","","EMAIL","USA",," ","","Inactive","","",
2,"Alaska","Yes","Daily  ","WEB","USA",3146,"2018-12-09 04:05:32","Success","Active","^(REC(A|B|S))?\d{2,}$","Mixed; optional prefix indicating license type, followed by 2 or more digits without leading zeroes.",100.0
8,"Delaware","Yes","Monthly     ","FTP","USA",9980,"2018-11-10 04:45:45","Success","Active","^(RA|RB|RS|R\d)\-\d{7}$","Mixed; prefix indicating license type, followed by a dash, followed by exactly 7 digits with leading zeroes.",98.3567134268537
13,"Hawaii","Yes","Intermittent","EMAIL     ","USA",19623,"2018-06-19 05:06:09","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
20,"Minnesota","No","","NA        ","USA",," ","","Inactive","","",
39,"South Dakota","Yes","Monthly     ","EMAIL     ","USA",3753,"2018-01-31 12:50:18","Success","Inactive","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
66,"Alberta","Yes","Monthly","FTP","Canada",12092,"2016-07-26 04:10:11","Error","Inactive","^\d{3,}$","Digits only; 3 or more digits without leading zeroes.",100.0
55,"Kentucky","Yes","Monthly","FTP       ","USA",49212,"2017-11-01 05:36:09","Success","Inactive","^\d+$","Digits only; 1 or more digits without leading zeroes.",99.40868080955865
56,"Louisiana","No","Daily","EMAIL     ","USA",16952,"2013-03-26 11:04:39","Data Loaded into DB","Inactive","^\d+$","Digits only; 1 or more digits without leading zeroes.",
68,"Manitoba","Yes","Monthly     ","FTP       ","Canada",5480,"2018-10-23 05:50:15","Error","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
16,"Maine","Yes","Intermittent","EMAIL     ","USA",6374,"2018-12-04 05:45:28","Success","Active","^\d{6,}$","Digits only; 6 or more digits without leading zeroes.",100.0
76,"Prince Edward Island","No","","NA        ","Canada",," ","","Inactive","","",
37,"Rhode Island","Yes","Daily","WEB","USA",7008,"2018-12-09 07:55:24","Success","Active","^RE(B|S)\.\d{7}$","Mixed; prefix indicating license type, followed by a dot, followed by exactly 7 digits with leading zeroes.",100.0
3,"Arizona","Yes","Daily    ","WEB       ","USA",189332,"2018-12-09 04:18:41","Success","Active","^(BR|SA)\d{9}$","Mixed; prefix indicating license type, followed by exactly 9 digits with leading zeroes.",99.83204107071177
28,"New Mexico","No","","NA        ","USA",," ","","Inactive","","",
4,"Arkansas","Yes","Daily","FTP       ","USA",15214,"2018-12-09 04:20:21","Success","Active","^(AB|EB|IB|PB|SA)\d{8}(\-D\d{2})?$","Mixed; prefix indicating license type, followed by exactly 8 digits with leading zeroes; '-Dxx' suffix added to some license numbers, meaning unclear.",99.76994873143158
10,"Florida","Yes","Daily   ","WEB       ","USA",365062,"2018-12-09 05:01:56","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.00246533465548
15,"Kansas","Yes","Daily","FTP       ","USA",17009,"2018-12-05 05:30:32","Success","Active","^\d{8}$","Digits only; exactly 8 digits with leading zeroes.",100.0
18,"Massachusetts","Yes","Monthly","CD        ","USA",74898,"2018-10-04 06:01:30","Success","Active","^\d+\-RE\-(AB|B|C|LC|LP|PC|PG|PL|RB|RS|S|SC)$","Mixed; 1 or more digits without leading zeroes followed by suffix indicating license type.",100.0
74,"Ontario","No","","NA        ","Canada",," ","","Inactive","","",
19,"Michigan","No","Monthly     ","EMAIL     ","USA",49822,"2011-09-03 11:26:29","Data Loaded into DB","Inactive","^650\d{7}$","Digits only; exactly 10 digits total beginning with 650.",
35,"Pennsylvania","No","Monthly     ","NA        ","USA",,"2010-03-26 15:12:13","Data Loaded into DB","Inactive","","",
93,"New Zealand","No","","NA        ","New Zealand",," ","","Inactive","","",
92,"Ajman","No","","NA        ","United Arab Emirates",," ","","Inactive","","",
85,"Dubai","No","","NA        ","United Arab Emirates",," ","","Inactive","","",
67,"British Columbia","Yes","Monthly     ","FTP","Canada",26021,"2018-12-04 14:54:23","Success","Active","^\d+$","Digits only; 1 or more digits without leading zeroes.",100.0
33,"Oklahoma","Yes","Daily       ","FTP       ","USA",18377,"2018-12-09 07:35:27","Success","Active","^\d{6}$","Digits only; exactly 6 digits with leading zeroes.",100.0
49,"Washington","No","","NA        ","USA",," ","","Inactive","","",
77,"Quebec","No","","NA        ","Canada",," ","","Inactive","","",
83,"Bermuda","No","","NA        ","Bermuda",," ","","Inactive","","",
7,"Connecticut","Yes","Daily    ","WEB       ","USA",22186,"2018-12-09 04:40:34","Success","Active","^(REB|RES)\.\d{7}$","Mixed; prefix indicating license type, followed by a dot, followed by exactly 7 digits with leading zeroes.",100.0
54,"Iowa","Yes","Monthly","FTP       ","USA",47506,"2018-12-06 05:26:11","Success","Active","^[BFST]\d{8}$","Mixed; prefix indicating license type followed by exactly 8 digits with leading zeroes.",100.0
17,"Maryland","Yes","Daily","FTP       ","USA",143003,"2018-12-08 05:57:01","Success","Active","^\d+$","Digits only; 1 or more digits without leading zeroes.",100.0
72,"Nova Scotia","No","","NA        ","Canada",," ","","Inactive","","",
71,"Northwest Territories","No","","EMAIL     ","Canada",," ","","Inactive","","",
42,"Utah","Yes","Daily","WEB       ","USA",17955,"2018-12-09 09:00:29","Success","Active","^\d{6,}\-(AB00|BB00|CEI0|DB00|MCEI|PB00|PI00|SA00)$","Mixed; 6 or more digits without leading zeroes followed by suffix indicating license type.",99.9944305207463
5,"California","Yes","Monthly     ","FTP","USA",395212,"2018-10-17 04:36:06","Success","Active","^\d{8}$","Digits only; exactly 8 digits with leading zeroes.",100.0
9,"District of Columbia","Yes","Daily   ","FTP       ","USA",44609,"2018-12-09 04:50:54","Success","Active","^(AB|BO|IB|PB|PM|RM|SP)\d+$","Mixed; prefix indicating license type, followed by 1 or more digits.",87.98897083548162
24,"Nebraska","Yes","Weekly      ","FTP       ","USA",25718,"2018-12-08 06:36:08","Success","Active","^\d{7,}$","Digits only; 7 or more digits with leading zeroes for shorter numbers.",99.7161521113617
27,"New Jersey","Yes","Weekly","FTP","USA",85966,"2018-03-30 06:52:15","Success","Inactive","^\d{7}$","Digits only; exactly 7 digits with leading zeroes.",100.0
29,"New York","No","","NA        ","USA",," ","","Inactive","","",
34,"Oregon","Yes","Monthly","FTP       ","USA",23742,"2018-11-06 07:45:51","Error","Active","^\d{9}$","Digits only; exactly 9 digits without leading zeroes.",100.0
46,"Wisconsin","No","","NA","USA",," ","","Inactive","","",