"ID","JURISDICTNAME","ISPARTICIPANT","SUBMISSIONINTERVAL","SUBMETHOD","COUNTRY","NUMRECORDS","DTLASTPROCACTION","CURRENTPROCSTATUS","STATUS","LICNUMFORMAT_REGEX","LICNUMFORMAT_DESC","LICNUMFORMAT_PERCENTMATCH"
26,"New Hampshire","Yes","Intermittent","EMAIL     ","USA",11508,"2019-08-02 06:45:17","Success","Active","^\d{6}$","Digits only; exactly 6 digits with leading zeroes.",100.0
38,"South Carolina","Yes","Weekly","FTP       ","USA",43629,"2019-08-13 08:20:29","Success","Active","^\d{4,}$","Digits only; 4 or more digits without leading zeroes.",99.99312383964794
40,"Tennessee","Yes","Daily","FTP","USA",32764,"2019-07-02 08:40:22","Error","Active","^\d{3,}$","Digits only; 3 or more digits without leading zeroes.",100.0
44,"Virginia","No","","NA        ","USA",," ","","Inactive","","",
43,"Vermont","No","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
2,"Alaska","Yes","Daily  ","WEB","USA",3252,"2019-08-17 04:05:28","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
52,"Illinois","No","Monthly     ","NA","USA",,"2009-03-02 00:00:00","Data Deleted","Inactive","","",
53,"Indiana","Yes","Weekly","FTP","USA",34317,"2019-08-02 05:20:38","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",24660,"2019-08-16 06:40:47","Success","Active","^\d{7}$","Digits only; exactly 7 digits with leading zeroes.",99.99594484995944
1,"Alabama","Yes","Daily  ","FTP       ","USA",79296,"2019-08-16 04:00:39","Success","Active","^\d{9}$","Digits only; exactly 9 digits with leading zeroes.",100.0
30,"North Carolina","Yes","Daily       ","FTP       ","USA",70361,"2019-08-16 07:05:28","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
31,"North Dakota","Yes","Weekly    ","EMAIL     ","USA",2441,"2019-08-17 07:10:05","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
11,"Georgia","Yes","Monthly     ","FTP       ","USA",64675,"2019-08-02 05:00:37","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",99.99845380749903
21,"Mississippi","Yes","Daily       ","FTP       ","USA",10448,"2019-08-17 06:15:06","Success","Active","^(S\-)?\d{3,}$","Mixed; prefix indicating license type (salespersons only) followed by 3 or more digits without leading zeroes.",99.98085758039817
51,"West Virginia","Yes","Daily","FTP       ","USA",5564,"2019-08-17 09:20:06","Success","Active","^(WV\d{7}|WV[ABS]\d{9})$","Mixed; 2 possible formats: (1) 'WV' followed by exactly 7 digits with leading zeroes, OR (2) 'WV', followed by letter indicating license type, followed by exactly 9 digits.",100.0
78,"Saskatchewan","Yes","Monthly     ","FTP       ","Canada",1787,"2019-07-20 08:10:03","Success","Active","^\d+$","Digits only; 1 or more digits without leading zeroes.",100.0
41,"Texas","Yes","Daily","WEB       ","USA",228653,"2019-08-17 08:51:34","Success","Active","^\d{4,}$","Digits only; 4 or more digits without leading zeroes.",100.14257411886133
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","","",
3,"Arizona","Yes","Daily    ","WEB       ","USA",193328,"2019-08-17 04:16:50","Success","Active","^(BR|SA)\d{9}$","Mixed; prefix indicating license type, followed by exactly 9 digits with leading zeroes.",99.83602995944716
28,"New Mexico","No","","NA        ","USA",," ","","Inactive","","",
77,"Quebec","No","","NA        ","Canada",," ","","Inactive","","",
83,"Bermuda","No","","NA        ","Bermuda",," ","","Inactive","","",
7,"Connecticut","Yes","Daily    ","WEB       ","USA",22138,"2019-08-17 04:40:24","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","EMAIL","USA",48174,"2019-08-09 05:25:53","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",146137,"2019-08-17 05:55:43","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",27163,"2019-08-17 09:00:16","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.99263704303648
5,"California","Yes","Monthly     ","WEB","USA",399032,"2019-08-17 04:33:03","Success","Active","^\d{8}$","Digits only; exactly 8 digits with leading zeroes.",100.0
9,"District of Columbia","Yes","Daily   ","FTP       ","USA",45652,"2019-08-17 04:50:29","Success","Active","^(AB|BO|IB|PB|PM|RM|SP)\d+$","Mixed; prefix indicating license type, followed by 1 or more digits.",88.07281170594936
24,"Nebraska","Yes","Weekly      ","FTP       ","USA",26417,"2019-08-16 06:35:24","Success","Active","^\d{7,}$","Digits only; 7 or more digits with leading zeroes for shorter numbers.",99.75773176363705
27,"New Jersey","Yes","Weekly","FTP","USA",60778,"2019-08-16 06:50:24","Success","Active","^\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",24043,"2019-07-09 07:45:20","Success","Active","^\d{9}$","Digits only; exactly 9 digits without leading zeroes.",100.0
46,"Wisconsin","No","","NA","USA",," ","","Inactive","","",
6,"Colorado","Yes","Intermittent","FTP","USA",47851,"2019-07-02 04:36:19","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","","",
14,"Idaho","Yes","Daily       ","FTP       ","USA",31041,"2019-08-17 05:10:14","Success","Active","^\d+$","Digits only; 1 or more digits without leading zeroes.",100.0
23,"Montana","Yes","Monthly","EMAIL     ","USA",6426,"2019-01-18 06:25:28","Success","Inactive","^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",111787,"2019-08-17 07:26:22","Success","Active","^(BRK|SAL)[AMP]*\.\d{10}$","Mixed; prefix indicating license type, followed by a dot, followed by exactly 10 digits with leading zeroes.",100.0
12,"Guam","No","","NA        ","USA",," ","","Inactive","","",
22,"Missouri","Yes","Daily       ","FTP       ","USA",38268,"2019-08-17 06:20:34","Success","Active","^\d{10}$","Digits only; exactly 10 digits without leading zeroes.",100.0
84,"NAR","Yes","Monthly     ","FTP","NAR",1379718,"2019-07-20 06:39:14","Success","Active","","",0.0
70,"New Brunswick","No","","NA        ","Canada",," ","","Inactive","","",
48,"Wyoming","Yes","Monthly     ","FTP","USA",3357,"2019-07-10 09:30:05","Success","Active","^(RE\-)?\d{3,}$","Mixed; prefix indicating license type (optional), followed by 3 or more digits without leading zeroes.",99.91063449508489
66,"Alberta","No","Monthly","FTP","Canada",,"2016-07-26 04:10:11","Error","Inactive","^\d{3,}$","Digits only; 3 or more digits without leading zeroes.",100.0
55,"Kentucky","No","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",5386,"2019-02-21 05:50:13","Error","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
16,"Maine","Yes","Intermittent","EMAIL     ","USA",6534,"2019-08-06 05:45:26","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",7682,"2019-08-17 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
4,"Arkansas","Yes","Daily","FTP       ","USA",14507,"2019-07-27 04:20:12","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.76563038533122
10,"Florida","Yes","Daily   ","WEB       ","USA",375035,"2019-08-17 04:57:38","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.00239977602091
15,"Kansas","Yes","Daily","FTP       ","USA",17398,"2019-08-17 05:30:20","Success","Active","^\d{8}$","Digits only; exactly 8 digits with leading zeroes.",100.0
18,"Massachusetts","Yes","Monthly","CD        ","USA",73498,"2019-08-03 06:01:16","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","","",
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",25964,"2019-07-03 04:25:42","Success","Active","^\d+$","Digits only; 1 or more digits without leading zeroes.",100.0
33,"Oklahoma","Yes","Daily       ","FTP       ","USA",18414,"2019-08-17 07:35:14","Success","Active","^\d{6}$","Digits only; exactly 6 digits with leading zeroes.",100.0
49,"Washington","No","","NA        ","USA",," ","","Inactive","","",
8,"Delaware","Yes","Monthly     ","FTP","USA",9854,"2019-08-10 04:45:18","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.33570123807591
13,"Hawaii","Yes","Intermittent","EMAIL     ","USA",18419,"2019-05-16 05:05:43","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
20,"Minnesota","No","","NA        ","USA",," ","","Inactive","","",
39,"South Dakota","No","Monthly     ","EMAIL     ","USA",3753,"2018-01-31 12:50:18","Error","Inactive","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0