"ID","JURISDICTNAME","ISPARTICIPANT","SUBMISSIONINTERVAL","SUBMETHOD","COUNTRY","NUMRECORDS","DTLASTPROCACTION","CURRENTPROCSTATUS","STATUS","LICNUMFORMAT_REGEX","LICNUMFORMAT_DESC","LICNUMFORMAT_PERCENTMATCH"
52,"Illinois","No","Monthly     ","NA","USA",,"2009-03-02 00:00:00","Data Deleted","Inactive","","",
53,"Indiana","Yes","Weekly","FTP","USA",34671,"2019-10-02 05:20:45","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",24841,"2019-10-16 06:40:35","Success","Active","^\d{7}$","Digits only; exactly 7 digits with leading zeroes.",99.99597439716598
4,"Arkansas","Yes","Daily","FTP       ","USA",13968,"2019-10-04 04:20:14","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.67067583046965
10,"Florida","Yes","Daily   ","WEB       ","USA",373350,"2019-10-17 04:58:23","Error","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.00241060666934
15,"Kansas","Yes","Daily","FTP       ","USA",17426,"2019-10-02 05:30:17","Success","Active","^\d{8}$","Digits only; exactly 8 digits with leading zeroes.",100.0
18,"Massachusetts","Yes","Monthly","CD        ","USA",73287,"2019-09-13 06:01:20","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",25850,"2019-10-02 04:25:39","Success","Active","^\d+$","Digits only; 1 or more digits without leading zeroes.",100.0
33,"Oklahoma","Yes","Daily       ","FTP       ","USA",18607,"2019-10-21 07:35:20","Success","Active","^\d{6}$","Digits only; exactly 6 digits with leading zeroes.",100.0
49,"Washington","No","","NA        ","USA",," ","","Inactive","","",
1,"Alabama","Yes","Daily  ","FTP       ","USA",79882,"2019-10-19 04:00:35","Success","Active","^\d{9}$","Digits only; exactly 9 digits with leading zeroes.",100.0
30,"North Carolina","Yes","Daily       ","FTP       ","USA",71788,"2019-10-19 07:05:27","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
31,"North Dakota","Yes","Weekly    ","EMAIL     ","USA",2467,"2019-10-17 07:10:06","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
6,"Colorado","Yes","Intermittent","FTP","USA",48004,"2019-09-04 04:35:31","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",3269,"2019-10-21 04:05:24","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
11,"Georgia","Yes","Monthly     ","FTP       ","USA",64783,"2019-10-02 05:00:41","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",99.99845638516277
21,"Mississippi","Yes","Daily       ","FTP       ","USA",10484,"2019-10-21 06:15:09","Success","Active","^(S\-)?\d{3,}$","Mixed; prefix indicating license type (salespersons only) followed by 3 or more digits without leading zeroes.",99.97138496756963
51,"West Virginia","Yes","Daily","FTP       ","USA",5697,"2019-10-21 09:20:13","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
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",194269,"2019-10-21 04:16:46","Success","Active","^(BR|SA)\d{9}$","Mixed; prefix indicating license type, followed by exactly 9 digits with leading zeroes.",99.8368241973758
28,"New Mexico","No","","NA        ","USA",," ","","Inactive","","",
8,"Delaware","Yes","Monthly     ","FTP","USA",9938,"2019-10-11 04:45:35","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.34976856510364
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
12,"Guam","No","","NA        ","USA",," ","","Inactive","","",
22,"Missouri","Yes","Daily       ","FTP       ","USA",38672,"2019-10-21 06:20:27","Success","Active","^\d{10}$","Digits only; exactly 10 digits without leading zeroes.",100.0
84,"NAR","Yes","Monthly     ","FTP","NAR",1405363,"2019-10-20 06:37:44","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
77,"Quebec","No","","NA        ","Canada",," ","","Inactive","","",
83,"Bermuda","No","","NA        ","Bermuda",," ","","Inactive","","",
7,"Connecticut","Yes","Daily    ","WEB       ","USA",22591,"2019-10-21 04:40:21","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",48341,"2019-10-10 05:26:15","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",146886,"2019-10-19 05:55:48","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",27277,"2019-10-21 09:00:24","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.9926678153756
78,"Saskatchewan","Yes","Monthly     ","FTP       ","Canada",1805,"2019-09-24 08:10:02","Success","Active","^\d+$","Digits only; 1 or more digits without leading zeroes.",100.0
41,"Texas","Yes","Daily","WEB       ","USA",230859,"2019-10-21 08:52:04","Success","Active","^\d{4,}$","Digits only; 4 or more digits without leading zeroes.",100.1403454056372
5,"California","Yes","Monthly     ","WEB","USA",399766,"2019-10-21 04:32:31","Success","Active","^\d{8}$","Digits only; exactly 8 digits with leading zeroes.",100.0
9,"District of Columbia","Yes","Daily   ","FTP       ","USA",45883,"2019-10-21 04:50:21","Success","Active","^(AB|BO|IB|PB|PM|RM|SP)\d+$","Mixed; prefix indicating license type, followed by 1 or more digits.",88.07837325371052
24,"Nebraska","Yes","Weekly      ","FTP       ","USA",26587,"2019-10-19 06:35:16","Success","Active","^\d{7,}$","Digits only; 7 or more digits with leading zeroes for shorter numbers.",99.75175837815473
27,"New Jersey","Yes","Weekly","FTP","USA",61898,"2019-10-18 06:50:54","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",24126,"2019-10-18 07:45:24","Success","Active","^\d{9}$","Digits only; exactly 9 digits without leading zeroes.",100.0
46,"Wisconsin","No","","NA","USA",," ","","Inactive","","",
26,"New Hampshire","Yes","Intermittent","EMAIL     ","USA",11562,"2019-10-02 06:45:38","Success","Active","^\d{6}$","Digits only; exactly 6 digits with leading zeroes.",100.0
38,"South Carolina","Yes","Weekly","FTP       ","USA",44201,"2019-10-15 08:20:34","Success","Active","^\d{4,}$","Digits only; 4 or more digits without leading zeroes.",99.99321282323929
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","Yes","Monthly","MANUAL","USA",13910,"2019-10-03 15:54:09","Success","Active","^08(1|2)\.\d{7}$","Mixed; prefix indicating license type, followed by a dot, followed by exactly 7 digits with leading zeroes.",100.0
14,"Idaho","Yes","Daily       ","FTP       ","USA",31330,"2019-10-21 05:10:13","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",112716,"2019-10-21 07:26:04","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
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",2893,"2019-09-25 05:50:06","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
16,"Maine","Yes","Intermittent","EMAIL     ","USA",6559,"2019-10-05 05:45:23","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",7846,"2019-10-21 07:55:16","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