"ID","JURISDICTNAME","ISPARTICIPANT","SUBMISSIONINTERVAL","SUBMETHOD","COUNTRY","NUMRECORDS","DTLASTPROCACTION","CURRENTPROCSTATUS","STATUS","LICNUMFORMAT_REGEX","LICNUMFORMAT_DESC","LICNUMFORMAT_PERCENTMATCH"
85,"Dubai","No","","NA        ","United Arab Emirates",," ","","Inactive","","",
92,"Ajman","No","","NA        ","United Arab Emirates",," ","","Inactive","","",
93,"New Zealand","No","","NA        ","New Zealand",," ","","Inactive","","",
6,"Colorado","Yes","Daily","WEB","USA",50905,"2025-09-18 04:35:15","Success","Active","^(EA|EI|ER|FA|IA|II|IR)\d+$","Mixed; prefix indicating license type, followed by 1 or more digits without leading zeroes.",100.0
12,"Guam","No","","NA        ","USA",," ","","Inactive","","",
22,"Missouri","Yes","Daily","FTP       ","USA",41857,"2025-09-18 06:20:07","Success","Active","^\d{10}$","Digits only; exactly 10 digits without leading zeroes.",100.0
26,"New Hampshire","No","Intermittent","EMAIL     ","USA",12498,"2022-07-02 06:45:22","Success","Inactive","^\d{6}$","Digits only; exactly 6 digits with leading zeroes.",99.98399743959034
27,"New Jersey","Yes","Weekly","FTP","USA",62031,"2025-09-12 06:50:11","Success","Active","^\d{7}$","Digits only; exactly 7 digits with leading zeroes.",100.0
35,"Pennsylvania","No","Monthly     ","NA        ","USA",,"2010-03-26 15:12:13","Data Loaded into DB","Inactive","","",
78,"Saskatchewan","No","Intermittent","FTP       ","Canada",1992,"2024-05-22 08:10:02","Success","Inactive","^\d+$","Digits only; 1 or more digits without leading zeroes.",100.0
40,"Tennessee","Yes","Daily","FTP","USA",151133,"2025-09-18 08:40:24","Success","Active","^\d{3,}$","Digits only; 3 or more digits without leading zeroes.",99.98875162935957
44,"Virginia","No","","NA        ","USA",," ","","Inactive","","",
49,"Washington","No","","NA        ","USA",," ","","Inactive","","",
3,"Arizona","Yes","Daily","WEB       ","USA",220908,"2025-09-18 04:15:53","Success","Active","^(BR|SA)\d{9}$","Mixed; prefix indicating license type, followed by exactly 9 digits with leading zeroes.",99.85921741177323
52,"Illinois","No","Monthly     ","NA","USA",,"2009-03-02 00:00:00","Data Deleted","Inactive","","",
18,"Massachusetts","No","Intermittent","CD        ","USA",68240,"2024-09-10 06:00:19","Success","Inactive","^\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.",99.99853458382181
68,"Manitoba","No","Intermittent","FTP       ","Canada",3174,"2021-10-22 05:50:01","Error","Inactive","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
17,"Maryland","Yes","Daily","FTP       ","USA",169268,"2025-09-18 05:55:26","Success","Active","^\d+$","Digits only; 1 or more digits without leading zeroes.",100.0
16,"Maine","Yes","Intermittent","EMAIL     ","USA",7108,"2025-07-22 05:45:18","Success","Active","^\d{6,}$","Digits only; 6 or more digits without leading zeroes.",100.0
21,"Mississippi","Yes","Daily","FTP       ","USA",12228,"2025-09-18 07:15:03","Success","Active","^(S\-)?\d{3,}$","Mixed; prefix indicating license type (salespersons only) followed by 3 or more digits without leading zeroes.",99.98364409551849
23,"Montana","No","Intermittent","EMAIL     ","USA",6426,"2019-01-18 06:25:28","Error","Inactive","^RRE\-(BRO|RBS|RPM)\-LIC\-\d+$","Mixed; prefix indicating license type followed by 1 or more digits without leading zeroes.",100.0
28,"New Mexico","No","","NA        ","USA",," ","","Inactive","","",
32,"Ohio","Yes","Daily","WEB","USA",148789,"2025-09-18 07:25:51","Success","Active","^(BRK|SAL)[AMP]*\.\d{10}$","Mixed; prefix indicating license type, followed by a dot, followed by exactly 10 digits with leading zeroes.",99.99865581460995
51,"West Virginia","Yes","Daily","FTP       ","USA",6681,"2025-09-18 09:20:02","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
77,"Quebec","No","","NA        ","Canada",," ","","Inactive","","",
83,"Bermuda","No","","NA        ","Bermuda",," ","","Inactive","","",
66,"Alberta","No","Intermittent","FTP","Canada",,"2016-07-26 04:10:11","Error","Inactive","^\d{3,}$","Digits only; 3 or more digits without leading zeroes.",100.0
1,"Alabama","Yes","Monthly","FTP       ","USA",41049,"2025-09-17 04:00:26","Success","Active","^\d{9}$","Digits only; exactly 9 digits with leading zeroes.",100.0
4,"Arkansas","Yes","Daily","FTP       ","USA",16978,"2025-09-18 04:20:05","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.34032277064436
7,"Connecticut","Yes","Daily","WEB       ","USA",26312,"2025-09-18 04:40:09","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
10,"Florida","Yes","Daily","WEB       ","USA",455974,"2025-09-18 04:56:43","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
11,"Georgia","Yes","Monthly","FTP       ","USA",89533,"2025-09-02 05:00:19","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",99.99776618676913
54,"Iowa","No","Intermittent","EMAIL","USA",53093,"2024-08-05 15:02:19","Error","Inactive","^[BFST]\d{8}$","Mixed; prefix indicating license type followed by exactly 8 digits with leading zeroes.",100.0
14,"Idaho","Yes","Daily","FTP       ","USA",39763,"2025-09-18 05:10:07","Success","Active","^\d+$","Digits only; 1 or more digits without leading zeroes.",100.0
53,"Indiana","Yes","Weekly","FTP","USA",37504,"2025-09-12 05:20:08","Success","Active","^RB\d{8}$","Mixed; prefix indicating license type followed by exactly 8 digits with leading zeroes.",100.0
15,"Kansas","Yes","Monthly","FTP       ","USA",18332,"2025-09-06 05:30:04","Success","Active","^\d{8}$","Digits only; exactly 8 digits with leading zeroes.",99.98909011564477
55,"Kentucky","No","Intermittent","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","Yes","Intermittent","FTP","USA",24507,"2025-04-08 05:40:06","Error","Active","^\d+$","Digits only; 1 or more digits without leading zeroes.",0.0
30,"North Carolina","Yes","Daily","FTP","USA",81462,"2025-09-18 07:05:38","Success","Active","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
31,"North Dakota","No","Intermittent","FTP","USA",6852,"2024-08-01 13:08:47","Error","Inactive","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",99.7227086981903
72,"Nova Scotia","No","","NA        ","Canada",," ","","Inactive","","",
71,"Northwest Territories","No","","EMAIL     ","Canada",," ","","Inactive","","",
25,"Nevada","Yes","Monthly","FTP       ","USA",26190,"2025-09-16 06:40:10","Success","Active","^\d{7}$","Digits only; exactly 7 digits with leading zeroes.",99.99618174875907
74,"Ontario","No","","NA        ","Canada",," ","","Inactive","","",
76,"Prince Edward Island","No","","NA        ","Canada",," ","","Inactive","","",
37,"Rhode Island","Yes","Daily","WEB","USA",9326,"2025-09-18 07:55:04","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
42,"Utah","Yes","Daily","WEB       ","USA",30596,"2025-09-18 09:00:11","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.",100.0
2,"Alaska","Yes","Daily","WEB","USA",3321,"2025-09-18 04:05:31","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
67,"British Columbia","No","Intermittent","FTP","Canada",29486,"2023-11-03 04:25:17","Success","Inactive","^\d+$","Digits only; 1 or more digits without leading zeroes.",93.74957606999932
5,"California","Yes","Daily","WEB","USA",395101,"2025-09-18 04:31:12","Success","Active","^\d{8}$","Digits only; exactly 8 digits with leading zeroes.",100.0
9,"District of Columbia","Yes","Weekly","EMAIL","USA",14393,"2025-09-16 04:50:18","Success","Active","^(AB|BO|IB|PB|PM|RM|SP)\d+$","Mixed; prefix indicating license type, followed by 1 or more digits.",85.79865212255957
8,"Delaware","Yes","Daily","WEB","USA",29357,"2025-09-18 04:45:30","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.",99.76155601730422
13,"Hawaii","No","Intermittent","EMAIL     ","USA",18419,"2019-05-16 05:05:43","Error","Inactive","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",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.",
20,"Minnesota","No","","NA        ","USA",," ","","Inactive","","",
84,"NAR","No","Intermittent","FTP","NAR",1408421,"2019-12-20 06:39:55","Success","Inactive","","",0.0
70,"New Brunswick","No","","NA        ","Canada",," ","","Inactive","","",
24,"Nebraska","Yes","Daily","FTP       ","USA",29301,"2025-09-18 06:35:07","Success","Active","^\d{7,}$","Digits only; 7 or more digits with leading zeroes for shorter numbers.",99.98976144158902
29,"New York","No","","NA        ","USA",," ","","Inactive","","",
33,"Oklahoma","No","Intermittent","FTP       ","USA",18085,"2021-04-06 07:35:09","Success","Inactive","^\d{6}$","Digits only; exactly 6 digits with leading zeroes.",100.0
34,"Oregon","Yes","Intermittent","FTP       ","USA",24381,"2025-07-31 07:45:06","Error","Active","^\d{9}$","Digits only; exactly 9 digits without leading zeroes.",0.0
38,"South Carolina","Yes","Weekly","FTP       ","USA",46860,"2025-09-16 08:20:10","Success","Active","^\d{4,}$","Digits only; 4 or more digits without leading zeroes.",99.9914639351259
39,"South Dakota","No","Intermittent","EMAIL     ","USA",3685,"2021-10-27 14:07:49","Error","Inactive","^\d{2,}$","Digits only; 2 or more digits without leading zeroes.",100.0
41,"Texas","Yes","Daily","WEB       ","USA",289867,"2025-09-18 08:50:54","Success","Active","^\d{4,}$","Digits only; 4 or more digits without leading zeroes.",100.08831636578155
45,"Virgin Islands","No","","EMAIL","USA",," ","","Inactive","","",
43,"Vermont","No","Intermittent","MANUAL","USA",15126,"2024-10-02 09:10:31","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
46,"Wisconsin","No","","NA","USA",," ","","Inactive","","",
48,"Wyoming","No","Intermittent","FTP","USA",3357,"2019-07-10 09:30:05","Success","Inactive","^(RE\-)?\d{3,}$","Mixed; prefix indicating license type (optional), followed by 3 or more digits without leading zeroes.",99.91063449508489