Comment Period Durations

How long agencies give the public to comment, by agency and document type. Useful for understanding whether comment periods are adequate.

Custom SQL query returning 348 rows (hide) 

SELECT d.agency_id, d.document_type, COUNT(*) AS documents, CAST(AVG(julianday(d.comment_end_date) - julianday(d.comment_start_date)) AS INTEGER) AS avg_days, CAST(MIN(julianday(d.comment_end_date) - julianday(d.comment_start_date)) AS INTEGER) AS min_days, CAST(MAX(julianday(d.comment_end_date) - julianday(d.comment_start_date)) AS INTEGER) AS max_days FROM documents d WHERE d.comment_start_date IS NOT NULL AND d.comment_end_date IS NOT NULL AND d.comment_start_date != '' AND d.comment_end_date != '' AND julianday(d.comment_end_date) > julianday(d.comment_start_date) GROUP BY d.agency_id, d.document_type HAVING documents >= 3 ORDER BY avg_days DESC

Edit SQL

This data as json, CSV

agency_iddocument_typedocumentsavg_daysmin_daysmax_days
HHS Other 6 5594 24 29724
FEMA Other 3 1485 31 4383
TSA Other 119 285 0 33694
USCG Other 222 159 0 33694
IRS Other 16 150 31 809
PHMSA Other 21693 125 0 33697
FDA Proposed Rule 746 124 0 8892
FNS Rule 42 106 6 788
EPA Other 1191 104 0 2180
FDA Other 3165 104 0 3631
SEC Rule 35 102 1 2080
ATF Rule 5 92 31 159
USTR Notice 487 91 0 2124
FDA Rule 229 90 1 9056
MSHA Proposed Rule 92 90 7 1102
ATF Proposed Rule 18 87 30 92
FTC Rule 6 86 0 293
IRS Rule 21 85 0 414
NHTSA Supporting & Related Material 3 84 84 84
USDA Proposed Rule 32 84 17 1159
MSHA Rule 12 78 30 242
TTB Proposed Rule 151 78 1 378
BIS Rule 44 76 25 421
SBA Notice 58 76 6 2170
TREAS Proposed Rule 108 76 0 3452
FDA Notice 9060 75 0 12537
IRS Proposed Rule 852 74 0 2824
TSA Proposed Rule 13 74 33 139
FTC Other 61 73 4 214
NLRB Proposed Rule 21 71 1 165
DOE Other 8 70 27 150
ACF Notice 13 69 16 167
FCA Proposed Rule 94 69 17 281
OSHA Proposed Rule 163 68 0 198
EAC Proposed Rule 3 66 30 107
IRS Notice 164 66 0 730
NIH Proposed Rule 14 66 30 122
NRC Other 42 66 2 152
APHIS Proposed Rule 323 65 3 281
FEMA Proposed Rule 32 65 3 119
OCC Notice 19 65 27 123
HRSA Proposed Rule 37 64 3 182
NIST Notice 26 64 26 283
PHMSA Proposed Rule 131 63 14 189
BSEE Proposed Rule 21 62 30 121
MARAD Proposed Rule 11 62 30 90
BOR Proposed Rule 7 61 31 90
DOI Proposed Rule 48 61 1 111
FAR Rule 103 61 4 121
NCUA Proposed Rule 203 61 30 167
NPS Proposed Rule 82 61 0 168
OSHA Other 76 61 0 774
RHS Notice 169 61 15 148
RRB Proposed Rule 12 61 60 62
CFPB Other 54 60 1 90
CPSC Proposed Rule 219 60 9 139
DOD Proposed Rule 197 60 10 92
EBSA Proposed Rule 108 60 0 157
FNS Notice 517 60 1 358
FSIS Proposed Rule 84 60 15 164
MSHA Other 3 60 59 60
OFCCP Notice 33 60 41 64
RATB Proposed Rule 3 60 60 60
STB Proposed Rule 79 60 8 147
TTB Notice 59 60 30 65
ACF Proposed Rule 64 59 10 160
BIA Notice 22 59 48 91
FAR Proposed Rule 220 59 21 123
FHFA Rule 21 59 30 122
FNS Proposed Rule 97 59 2 122
FWS Proposed Rule 1329 59 0 1302
PBGC Proposed Rule 39 59 30 95
APHIS Rule 167 58 15 91
CDC Notice 1306 58 0 279
EEOC Proposed Rule 30 58 30 63
FEMA Rule 15 58 17 182
FRA Proposed Rule 101 58 3 128
FSIS Notice 336 58 7 112
NRC Proposed Rule 613 58 8 365
OFAC Notice 32 58 30 64
SSA Proposed Rule 119 58 15 93
ACF Rule 15 57 9 182
APHIS Notice 1367 57 0 400
CDC Proposed Rule 52 57 0 121
DOD Rule 127 57 30 63
FSA Proposed Rule 22 57 25 91
FSA Rule 35 57 14 91
NARA Proposed Rule 30 57 30 71
RHS Proposed Rule 53 57 22 76
SSA Rule 25 57 0 90
VA Proposed Rule 323 57 12 120
AMS Notice 470 56 0 215
BOEM Proposed Rule 24 56 13 120
DOD Other 13 56 29 62
FDIC Proposed Rule 270 56 7 121
FHFA Proposed Rule 123 56 17 120
FSA Notice 198 56 8 64
HHS Proposed Rule 131 56 2 219
HUD Proposed Rule 267 56 4 95
NMB Proposed Rule 6 56 31 62
OCC Proposed Rule 171 56 0 260
ONRR Proposed Rule 14 56 30 84
BLM Proposed Rule 64 55 0 155
CDC Other 30 55 4 63
CNCS Proposed Rule 18 55 27 63
FSIS Other 83 55 3 364
FTC Proposed Rule 260 55 0 269
GSA Proposed Rule 135 55 5 90
NASA Proposed Rule 62 55 10 91
VA Rule 93 55 30 120
VETS Proposed Rule 7 55 19 90
AMS Rule 227 54 0 91
EBSA Rule 28 54 30 91
FS Proposed Rule 78 54 7 100
IHS Proposed Rule 10 54 21 62
NCUA Notice 1336 54 0 112
SBA Proposed Rule 163 54 0 122
USTR Proposed Rule 4 54 32 61
BIA Proposed Rule 72 53 15 122
ED Other 19 53 0 248
FEMA Notice 782 53 1 2199
FMCS Proposed Rule 8 53 30 91
MCC Proposed Rule 4 53 30 62
SAMHSA Proposed Rule 9 53 29 62
EBSA Other 5 52 0 100
EDA Rule 4 52 37 62
NRCS Rule 36 52 0 90
RHS Rule 16 52 30 62
TREAS Notice 156 52 0 630
CFPB Rule 41 51 15 82
FCC Notice 3712 51 0 580
FDIC Rule 47 51 6 196
FERC Proposed Rule 310 51 2 242
HUD Rule 36 51 31 67
NHTSA Proposed Rule 173 51 0 120
OMB Notice 149 51 1 162
OPM Rule 52 51 0 90
SAMHSA Notice 4 51 21 61
SEC Proposed Rule 403 51 0 142
BIS Proposed Rule 88 50 2 90
CDC Rule 23 50 10 120
CFPB Proposed Rule 151 50 1 154
DNFSB Notice 21 50 26 374
ETA Proposed Rule 66 50 0 144
FMCSA Proposed Rule 151 50 8 154
MSPB Rule 11 50 30 94
NIST Proposed Rule 7 50 30 91
OMB Proposed Rule 16 50 28 121
SSA Notice 609 50 0 90
CFTC Proposed Rule 278 49 5 144
CNCS Notice 386 49 1 93
FCSIC Notice 3 49 32 82
FMCSA Other 8976 49 0 33696
NOAA Other 61 49 7 165
NSF Rule 3 49 31 60
OPIC Notice 13 49 24 62
CEQ Proposed Rule 7 48 30 61
EAC Other 6 48 10 61
FS Notice 656 48 0 305
FS Rule 8 48 28 61
HRSA Rule 5 48 30 75
NSF Proposed Rule 6 48 30 91
OMB Rule 15 48 17 63
USDA Rule 21 48 23 66
CEQ Notice 36 47 14 119
CFTC Rule 13 47 30 62
EEOC Notice 103 47 14 197
EPA Notice 14402 47 0 5479
ETA Rule 25 47 15 62
FAA Proposed Rule 6881 47 0 267
FDIC Notice 690 47 22 90
LSC Proposed Rule 41 47 9 160
NARA Other 1007 47 0 95
NCUA Rule 30 47 10 62
NOAA Notice 561 47 0 184
NPS Rule 4 47 30 63
OPM Proposed Rule 246 47 0 96
PHMSA Rule 2209 47 0 6349
TVA Proposed Rule 8 47 30 90
VA Notice 3440 47 0 183
BOEM Notice 394 46 7 191
BSEE Notice 217 46 2 90
BSEE Rule 4 46 30 62
CFPB Notice 525 46 0 121
DEA Proposed Rule 128 46 15 153
ED Notice 2592 46 0 151
EDA Proposed Rule 11 46 7 91
ETA Notice 27 46 12 119
FAR Notice 865 46 11 64
GSA Rule 32 46 27 85
HHS Rule 39 46 1 90
NMB Notice 11 46 30 61
OPM Notice 803 46 0 64
PBGC Notice 270 46 18 63
PC Notice 203 46 2 64
RRB Rule 8 46 30 90
WHD Proposed Rule 49 46 0 91
AHRQ Notice 389 45 4 82
DEA Rule 34 45 9 63
DOT Proposed Rule 88 45 0 168
EPA Rule 3157 45 0 1187
HHS Notice 85 45 2 627
HRSA Notice 6 45 6 90
HUD Notice 642 45 3 126
ITA Notice 231 45 0 614
NRC Notice 3295 45 3 2538
NSF Notice 827 45 6 105
OFAC Rule 9 45 31 61
OFCCP Proposed Rule 29 45 0 91
STB Notice 362 45 4 240
CFTC Notice 567 44 0 119
DOD Notice 2772 44 0 91
EBSA Notice 202 44 4 177
FCC Rule 41 44 1 226
FHFA Notice 156 44 14 133
FSIS Rule 31 44 30 90
GSA Notice 587 44 0 157
OCC Rule 44 44 30 64
ONRR Notice 113 44 0 62
RRB Notice 15 44 30 63
STB Rule 3 44 27 60
TREAS Rule 57 44 0 120
APHIS Other 174 43 28 116
APHIS Supporting & Related Material 6 43 32 51
DEA Notice 635 43 5 63
MSHA Notice 668 43 14 63
NASA Notice 113 43 0 77
PCLOB Notice 9 43 7 85
AMS Proposed Rule 689 42 4 129
EAC Notice 101 42 1 117
EEOC Other 7 42 30 70
FCC Proposed Rule 1448 42 0 422
FMC Notice 88 42 4 90
FMC Proposed Rule 48 42 7 90
FMCS Notice 53 42 30 63
IHS Notice 80 42 9 133
NTIA Proposed Rule 7 42 15 62
PHMSA Notice 1382 42 0 2462
CIGIE Notice 3 41 30 60
MCC Notice 7 41 7 63
MSPB Proposed Rule 8 41 30 62
NASA Rule 53 41 30 62
RATB Notice 16 41 3 61
SBA Rule 112 41 12 91
USGS Notice 32 41 0 63
USPS Rule 10 41 15 79
DOE Proposed Rule 120 40 7 92
DOI Notice 55 40 22 152
FCA Rule 10 40 30 62
FMC Rule 14 40 28 68
FWS Notice 724 40 0 173
FWS Other 15 40 14 90
NOAA Proposed Rule 2295 40 0 210
TSA Notice 508 40 0 94
TVA Notice 106 40 7 136
CMS Notice 3468 39 0 365
CMS Proposed Rule 709 39 0 300
CPSC Notice 494 39 1 96
EPA Proposed Rule 9111 39 0 3715
USCG Notice 1680 39 0 1196
USCG Proposed Rule 1467 39 4 451
BIS Notice 54 38 10 181
DOE Notice 1449 38 1 197
DOL Other 4 38 21 61
ED Proposed Rule 319 38 0 151
FWS Rule 40 38 0 91
ITA Proposed Rule 46 38 0 151
NHTSA Notice 1444 38 0 2660
NLRB Rule 4 38 30 60
NTIA Notice 78 38 3 90
OSTP Notice 104 38 8 100
ED Rule 34 37 3 124
FTC Notice 1097 37 0 1048
MSPB Notice 39 37 4 63
NARA Notice 269 37 0 63
NRCS Notice 142 37 3 91
BOEM Rule 9 36 15 61
DOI Rule 19 36 0 64
FMCSA Notice 7601 36 0 33745
LSC Notice 75 36 3 100
OSHA Rule 45 36 0 76
OSHRC Notice 23 36 30 64
OSHRC Proposed Rule 10 36 20 60
BLM Rule 42 35 30 62
CNCS Rule 8 35 30 60
DOE Rule 33 35 20 63
DOL Proposed Rule 34 35 0 91
DOL Rule 14 35 15 60
RITA Notice 65 35 0 90
USDA Notice 750 35 1 362
DNFSB Proposed Rule 10 34 29 60
FAA Other 29155 34 0 35606
FRA Notice 1533 34 0 349
MARAD Notice 2617 34 0 1254
PBGC Rule 6 34 18 60
PC Rule 4 34 30 44
DOL Notice 1997 33 0 181
FCA Notice 16 33 30 46
NIH Notice 322 33 5 365
OCC Other 38 33 0 141
USPS Proposed Rule 216 33 10 72
FLRA Proposed Rule 17 32 14 62
ITA Rule 8 32 7 62
NRC Rule 95 32 30 61
USPS Notice 17 32 4 61
WHD Rule 6 32 8 61
CPSC Rule 79 31 8 63
DNFSB Rule 4 31 30 31
NLRB Notice 7 31 30 32
OFAC Proposed Rule 5 31 30 32
OPIC Proposed Rule 4 31 30 32
PC Proposed Rule 5 31 30 33
SIGAR Notice 3 31 30 32
SIGAR Rule 4 31 30 32
CIGIE Rule 3 30 30 30
CMS Rule 288 30 0 367
NARA Rule 25 30 0 61
BIA Rule 13 29 0 60
CMS Other 32 29 0 71
FERC Notice 3395 29 0 395
FERC Rule 3 29 24 32
USCG Rule 1980 29 0 1474
BSEE Other 3 28 21 31
FAA Notice 6850 28 0 2346
MARAD Other 1500 27 0 33697
OSHA Notice 2053 25 0 245
BIS Other 55076 24 0 439
NOAA Rule 620 24 0 282
NPS Notice 3 24 10 32
DOT Rule 682 23 0 4192
FRA Other 5150 23 0 33694
SEC Notice 9402 23 0 368
ONRR Rule 6 21 0 60
FMCSA Rule 1751 20 0 1491
RITA Rule 65 20 0 63
FAA Rule 11894 18 0 2253
OFCCP Rule 5 18 0 59
ITA Other 21 17 14 47
TSA Rule 144 17 0 573
USTR Other 11575 16 0 97
FRA Rule 1259 15 0 1132
NHTSA Rule 2359 14 0 3027
BOEM Other 1002 13 0 61
NHTSA Other 9935 12 0 33697
MARAD Rule 1334 11 0 365
RITA Other 163 7 0 94
DOT Notice 10823 6 0 3989
DOT Other 101777 3 0 4349