regulatory_pipeline (view)

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

10,638 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: proposed_date (date), comment_start_date (date), comment_end_date (date), final_date (date)

docket_id agency_id docket_title proposed_rule_id proposed_rule_title proposed_date comment_start_date comment_end_date final_rule_id final_rule_title final_date days_proposed_to_final total_comments
APHIS-2005-0027 APHIS Importation of Fruits and Vegetables; 13th Periodic Amendment APHIS-2005-0027-0001 Importation of Fruits and Vegetables 2005-03-31T05:00:00Z 2005-03-31T05:00:00Z 2005-06-01T03:59:59Z APHIS-2005-0027-0036 Importation of Fruits and Vegetables 2005-12-08T12:17:48Z 252.30402777763084 0
APHIS-2005-0027 APHIS Importation of Fruits and Vegetables; 13th Periodic Amendment APHIS-2005-0027-0001 Importation of Fruits and Vegetables 2005-03-31T05:00:00Z 2005-03-31T05:00:00Z 2005-06-01T03:59:59Z APHIS-2005-0027-0038 Importation of Fruits and Vegetables; Untreated Citrus From Mexico 2006-06-08T11:39:36Z 434.277499999851 0
APHIS-2005-0028 APHIS Importation of Swine and Swine Products from the European Union APHIS-2005-0028-0001 Importation of Swine and Swine Prodcuts From the European Union 2005-04-08T04:00:00Z 2005-04-08T04:00:00Z 2005-06-08T03:59:59Z APHIS-2005-0028-0015 Importation of Swine and Swine Products From the European Union 2006-05-19T11:25:06Z 406.3090972225182 0
APHIS-2005-0028 APHIS Importation of Swine and Swine Products from the European Union APHIS-2005-0028-0001 Importation of Swine and Swine Prodcuts From the European Union 2005-04-08T04:00:00Z 2005-04-08T04:00:00Z 2005-06-08T03:59:59Z APHIS-2005-0028-0016 Importation of Swine and Swine Products from the European Union; Correction 2006-06-01T15:36:27Z 419.48364583356306 0
APHIS-2005-0028 APHIS Importation of Swine and Swine Products from the European Union APHIS-2005-0028-0001 Importation of Swine and Swine Prodcuts From the European Union 2005-04-08T04:00:00Z 2005-04-08T04:00:00Z 2005-06-08T03:59:59Z APHIS-2005-0028-0017 Importation of Swine and Swine Products from the European Union; Correction 2006-11-24T05:00:00Z 595.0416666669771 0
APHIS-2005-0040 APHIS Importation of Christmas Cactus and Easter Cactus in Growing Media from the Netherlands and Denmark APHIS-2005-0040-0001 Importation of Christmas Cactus and Easter Cactus in Growing Media From the Netherlands and Denmark 2005-04-27T04:00:00Z 2005-04-27T04:00:00Z 2005-06-28T03:59:59Z APHIS-2005-0040-0011 Importation of Christmas Cactus and Easter Cactus in Growing Media From the Netherlands and Denmark 2006-03-31T14:38:17Z 338.44325231481344 0
APHIS-2005-0046 APHIS Flag Smut; Importation of Wheat and Related Products APHIS-2005-0046-0001 Flag Smut; Importation of Wheat and Related Products 2005-05-20T04:00:00Z 2005-05-20T04:00:00Z 2005-07-20T03:59:59Z APHIS-2005-0046-0005 Flag Smut; Importation of Wheat and Related Products 2005-11-28T12:20:00Z 192.34722222248092 0
APHIS-2005-0051 APHIS Pine Shoot Beetle; Interstate Movement of Pine Bark Products From Quarantined Areas APHIS-2005-0051-0001 Pine Shoot Beetle; Interstate Movement of Pine Bark Products From Quarantined Aread 2005-06-06T04:00:00Z 2005-06-06T04:00:00Z 2005-08-06T03:59:59Z APHIS-2005-0051-0003 Pine Shoot Beetle; Interstate Movement of Pine Bark Products From Quarantined Areas 2006-03-20T12:34:57Z 287.3576041669585 0
APHIS-2005-0052 APHIS Treatments for Fruits and Vegetables APHIS-2005-0052-0001 Treatments for Fruits and Vegetables 2005-06-10T17:28:29Z 2005-06-10T17:28:29Z 2005-08-10T03:59:59Z APHIS-2005-0052-0019 Treatments for Fruits and Vegetables 2006-01-27T13:47:09Z 230.84629629645497 0
APHIS-2005-0052 APHIS Treatments for Fruits and Vegetables APHIS-2005-0052-0004 Correction amending the rule portion of the proposal (document number APHIS-2005-0052-0001) to indicate that the proposed generic dose for most arthropods is 400 gray, as discussed in the preamble, rather than 300 gray 2005-06-20T04:00:00Z     APHIS-2005-0052-0019 Treatments for Fruits and Vegetables 2006-01-27T13:47:09Z 221.4077430558391 0
APHIS-2005-0061 APHIS Cut Flowers from Countries with Chrysanthemum White Rust APHIS-2005-0061-0001 Cut Flowers From Countries With Chysanthemum White Rust 2005-07-07T17:27:08Z 2005-07-07T17:27:08Z 2005-10-22T03:59:59Z APHIS-2005-0061-0014 Plant-related quarantine, foreign: Chrysanthemum white rust 2007-04-03T04:00:00Z 634.4394907406531 0
APHIS-2005-0061 APHIS Cut Flowers from Countries with Chrysanthemum White Rust APHIS-2005-0061-0001 Cut Flowers From Countries With Chysanthemum White Rust 2005-07-07T17:27:08Z 2005-07-07T17:27:08Z 2005-10-22T03:59:59Z APHIS-2005-0061-0015 Cut Flowers From Countries With Chrysanthemum White Rust 2007-05-11T04:00:00Z 672.4394907406531 0
APHIS-2005-0073 APHIS Importation of Whole Cuts of Boneless Beef From Japan APHIS-2005-0073-0053 Importation of Whole Cuts of Boneless Beef from Japan 2005-08-18T17:20:04Z 2005-08-18T17:20:04Z 2005-09-20T03:59:59Z APHIS-2005-0073-0049 Importation of Whole Cuts of Boneless Beef From Japan 2005-12-14T12:15:19Z 117.78836805559695 0
APHIS-2005-0074 APHIS Add Argentina to the List of Regions Considered Free of Exotic Newcastle Disease APHIS-2005-0074-0001 Add Argentina to the List of Regions Considered Free of Exotic Newcastle Disease 2005-08-23T17:18:29Z 2005-08-23T17:18:29Z 2005-10-25T03:59:59Z APHIS-2005-0074-0004 Add Argentina to the List of Regions Considered Free of Exotic Newcastle Disease 2006-01-30T12:19:59Z 159.7927083335817 0
APHIS-2005-0073 APHIS Importation of Whole Cuts of Boneless Beef From Japan APHIS-2005-0073-0012 Corrected Federal Register Notice for original Federal Register which is document APHIS-2005-0073-0001 2005-09-01T04:00:00Z     APHIS-2005-0073-0049 Importation of Whole Cuts of Boneless Beef From Japan 2005-12-14T12:15:19Z 104.34396990761161 0
APHIS-2005-0074 APHIS Add Argentina to the List of Regions Considered Free of Exotic Newcastle Disease APHIS-2005-0074-0003 Add Argentina to the List of Regions Considered Free of Exotic Newcastle Disease; Correction 2005-09-08T04:00:00Z     APHIS-2005-0074-0004 Add Argentina to the List of Regions Considered Free of Exotic Newcastle Disease 2006-01-30T12:19:59Z 144.34721064846963 0
APHIS-2005-0061 APHIS Cut Flowers from Countries with Chrysanthemum White Rust APHIS-2005-0061-0011 Cut Flowers from Countries With Chrysanthemum White Rust; Reopening of Comment Period 2005-09-20T04:00:00Z     APHIS-2005-0061-0014 Plant-related quarantine, foreign: Chrysanthemum white rust 2007-04-03T04:00:00Z 560.0 0
APHIS-2005-0061 APHIS Cut Flowers from Countries with Chrysanthemum White Rust APHIS-2005-0061-0011 Cut Flowers from Countries With Chrysanthemum White Rust; Reopening of Comment Period 2005-09-20T04:00:00Z     APHIS-2005-0061-0015 Cut Flowers From Countries With Chrysanthemum White Rust 2007-05-11T04:00:00Z 598.0 0
APHIS-2005-0079 APHIS Citrus from Peru APHIS-2005-0079-0001 Citrus From Peru 2005-09-30T04:00:00Z 2005-09-30T04:00:00Z 2005-11-30T04:59:59Z APHIS-2005-0079-0031 Citrus From Peru 2006-05-01T11:18:41Z 213.30464120395482 0
APHIS-2005-0080 APHIS Karnal Bunt; Criteria for Releasing Fields from Regulation APHIS-2005-0080-0001 Karnal Bunt; Criteria for Releasing Fields From Regulation 2005-10-05T04:00:00Z 2005-10-05T04:00:00Z 2005-12-06T04:59:59Z APHIS-2005-0080-0008 Karnal Bunt; Criteria for Releasing Fields From Regulation 2006-03-14T12:14:36Z 160.3434722223319 0
APHIS-2005-0086 APHIS Black Stem Rust; Movement Restrictions and Addition of Rust-Resistant Varieties APHIS-2005-0086-0001 Black Stem Rust; Movement Restrictions and Addition of Rust- Resistant Varieties 2005-10-12T04:00:00Z 2005-10-12T04:00:00Z 2005-12-13T04:59:59Z APHIS-2005-0086-0002 Black Stem Rust; Movement Restrictions and Addition of Rust- Resistant Varieties 2006-02-03T12:19:33Z 114.34690972231328 0
APHIS-2005-0095 APHIS Importation of Peppers from Certain Central American Countries APHIS-2005-0095-0001 Importation of Peppers From Certain Central American Countries 2005-10-12T04:00:00Z 2005-10-12T04:00:00Z 2005-12-13T04:59:59Z APHIS-2005-0095-0038 Importation of Peppers From Certain Central American Countries 2006-03-07T12:22:30Z 146.34895833348855 0
APHIS-2005-0095 APHIS Importation of Peppers from Certain Central American Countries APHIS-2005-0095-0004 Importation of Peppers From Certain Central American Countries; Correction 2005-11-07T05:00:00Z 2005-11-07T05:00:00Z   APHIS-2005-0095-0038 Importation of Peppers From Certain Central American Countries 2006-03-07T12:22:30Z 120.30729166651145 0
APHIS-2005-0081 APHIS Importation of Nursery Stock APHIS-2005-0081-0001 Importation of Nursery Stock 2005-12-15T14:39:52Z 2005-12-15T14:39:52Z 2006-04-01T04:59:59Z APHIS-2005-0081-0028 Importation of Nursery Stock 2007-08-06T04:00:00Z 598.5556481480598 0
APHIS-2005-0081 APHIS Importation of Nursery Stock APHIS-2005-0081-0001 Importation of Nursery Stock 2005-12-15T14:39:52Z 2005-12-15T14:39:52Z 2006-04-01T04:59:59Z APHIS-2005-0081-0044 Importation of Nursery Stock; Technical Amendment 2007-11-30T05:00:00Z 714.597314815037 0
APHIS-2005-0107 APHIS Importation of Fruits and Vegetables; 14th Periodic Amendment APHIS-2005-0107-0001 Importation of Fruits and Vegetables 2005-12-22T12:20:25Z 2005-12-22T12:20:25Z 2006-03-11T04:59:59Z APHIS-2005-0107-0018 Importation of Fruits and Vegetables 2006-12-18T05:00:00Z 360.6941550928168 0
APHIS-2005-0112 APHIS Importation of Peppers from the Republic of Korea APHIS-2005-0112-0001 Importation of Peppers From the Republic of Korea 2005-12-29T13:51:37Z 2005-12-29T13:51:37Z 2006-02-28T04:59:59Z APHIS-2005-0112-0007 Importation of Peppers From the Republic of Korea 2006-05-22T11:29:36Z 143.90137731470168 0
APHIS-2005-0111 APHIS Importation of Baby Corn and Baby Carrots from Zambia APHIS-2005-0111-0001 Importation of Baby Corn and Baby Carrots From Zambia 2006-01-11T12:19:40Z 2006-01-11T12:19:40Z 2006-03-14T04:59:59Z APHIS-2005-0111-0009 Importation of Baby Corn and Baby Carrots From Zambia 2006-05-24T15:15:35Z 133.12216435186565 0
APHIS-2005-0119 APHIS Tuberculosis in Captive Cervids; Extend Interval for Conducting Reaccreditation Test APHIS-2005-0119-0001 Tuberculosis in Captive Cervids; Extend Interval for Conducting Reaccreditation Test 2006-01-12T12:09:05Z 2006-01-12T12:09:05Z 2006-03-14T04:59:59Z APHIS-2005-0119-0034 Tuberculosis in Captive Cervids; Extend Interval for Conducting Reaccreditation Test 2006-04-27T11:23:00Z 104.96799768554047 0
APHIS-2006-0009 APHIS Importation of Tomatoes from Certain Central American Countries APHIS-2006-0009-0001 Importation of Tomatoes From Certain Central American Countries 2006-02-06T12:14:41Z 2006-02-06T12:14:41Z 2006-04-08T03:59:59Z APHIS-2006-0009-0021 Importation of Tomatoes From Certain Central American Countries 2006-08-28T15:05:45Z 203.1187962964177 0
APHIS-2005-0081 APHIS Importation of Nursery Stock APHIS-2005-0081-0017 Importation of Nursery Stock 2006-02-28T14:40:24Z     APHIS-2005-0081-0028 Importation of Nursery Stock 2007-08-06T04:00:00Z 523.5552777778357 0
APHIS-2005-0081 APHIS Importation of Nursery Stock APHIS-2005-0081-0017 Importation of Nursery Stock 2006-02-28T14:40:24Z     APHIS-2005-0081-0044 Importation of Nursery Stock; Technical Amendment 2007-11-30T05:00:00Z 639.5969444448128 0
APHIS-2005-0107 APHIS Importation of Fruits and Vegetables; 14th Periodic Amendment APHIS-2005-0107-0016 Importation of Fruits and Vegetables 2006-03-03T12:16:28Z     APHIS-2005-0107-0018 Importation of Fruits and Vegetables 2006-12-18T05:00:00Z 289.6968981483951 0
APHIS-2006-0036 APHIS Exotic Newcastle Disease; Quarantine Restrictions APHIS-2006-0036-0001 Exotic Newcastle Disease; Quarantine Restrictions 2006-03-27T12:12:39Z 2006-03-27T12:12:39Z 2006-05-27T03:59:59Z APHIS-2006-0036-0009 Exotic Newcastle Disease; Quarantine Restrictions 2008-05-27T04:00:00Z 791.6578819444403 0
APHIS-2005-0103 APHIS Special Need Requests Under the Plant Protection Act APHIS-2005-0103-0001 Special Need Requests Under the Plant Protection Act 2006-04-04T11:20:25Z 2006-04-04T11:20:25Z 2006-06-06T03:59:59Z APHIS-2005-0103-0020 Special Need Requests Under the Plant Protection Act 2008-10-23T04:00:00Z 932.6941550923511 0
APHIS-2005-0047 APHIS Interstate Movement of Garbage from Hawaii APHIS-2005-0047-0006 Interstate Movement of Garbage From Hawaii; Municipal Solid Waste 2006-04-20T11:24:37Z 2006-04-20T11:24:37Z 2006-06-06T03:59:59Z APHIS-2005-0047-0022 Interstate Movement of Garbage From Hawaii; Municipal Solid Waste 2006-08-23T13:56:52Z 125.10572916641831 0
APHIS-2005-0106 APHIS Revision of Fruits and Vegetables Import Regulations (Q. 56) APHIS-2005-0106-0001 Revision of Fruits and Vegetables Import Regulations 2006-04-27T19:40:26Z 2006-04-27T19:40:26Z 2006-08-26T03:59:59Z APHIS-2005-0106-0060 Revision of Fruits and Vegetables Import Regulations 2007-07-18T04:00:00Z 446.3469212963246 0
APHIS-2005-0106 APHIS Revision of Fruits and Vegetables Import Regulations (Q. 56) APHIS-2005-0106-0001 Revision of Fruits and Vegetables Import Regulations 2006-04-27T19:40:26Z 2006-04-27T19:40:26Z 2006-08-26T03:59:59Z APHIS-2005-0106-0062 Revision of Fruits and Vegetables Import Regulations; Correction 2007-07-31T04:00:00Z 459.3469212963246 0
APHIS-2005-0106 APHIS Revision of Fruits and Vegetables Import Regulations (Q. 56) APHIS-2005-0106-0001 Revision of Fruits and Vegetables Import Regulations 2006-04-27T19:40:26Z 2006-04-27T19:40:26Z 2006-08-26T03:59:59Z APHIS-2005-0106-0063 Revision of Fruits and Vegetables Import Regulations; Technical Amendment 2007-08-24T04:00:00Z 483.3469212963246 0
APHIS-2005-0047 APHIS Interstate Movement of Garbage from Hawaii APHIS-2005-0047-0017 Interstate Movement of Garbage From Hawaii; Municipal Solid Waste 2006-05-31T12:36:33Z     APHIS-2005-0047-0022 Interstate Movement of Garbage From Hawaii; Municipal Solid Waste 2006-08-23T13:56:52Z 84.05577546264976 0
APHIS-2006-0093 APHIS National Veterinary Accreditation Program APHIS-2006-0093-0001 National Veterinary Accreditation Program 2006-06-01T19:47:40Z 2006-06-01T19:47:40Z 2006-08-01T03:59:59Z APHIS-2006-0093-0041 National Veterinary Accreditation Program 2009-12-09T05:00:00Z 1286.3835648149252 0
APHIS-2006-0093 APHIS National Veterinary Accreditation Program APHIS-2006-0093-0001 National Veterinary Accreditation Program 2006-06-01T19:47:40Z 2006-06-01T19:47:40Z 2006-08-01T03:59:59Z APHIS-2006-0093-0042 National Veterinary Accreditation Program; Correcting Amendment 2010-09-22T04:00:00Z 1573.341898147948 0
APHIS-2006-0093 APHIS National Veterinary Accreditation Program APHIS-2006-0093-0001 National Veterinary Accreditation Program 2006-06-01T19:47:40Z 2006-06-01T19:47:40Z 2006-08-01T03:59:59Z APHIS-2006-0093-0043 National Veterinary Accreditation Program: Currently Accredited Veterinarians Performing Accredited Duties and Electing to Participate 2010-09-28T04:00:00Z 1579.341898147948 0
APHIS-2006-0093 APHIS National Veterinary Accreditation Program APHIS-2006-0093-0001 National Veterinary Accreditation Program 2006-06-01T19:47:40Z 2006-06-01T19:47:40Z 2006-08-01T03:59:59Z APHIS-2006-0093-0044 National Veterinary Accreditation Program: Currently Accredited Veterinarians Performing Accredited Duties and Electing to Participate 2011-08-23T04:00:00Z 1908.341898147948 0
APHIS-2006-0037 APHIS Change in Disease Status of Namibia with Regard to Foot-and-Mouth Disease and Rinderpest APHIS-2006-0037-0001 Change in Disease Status of Namibia With Regard to Foot-and-Mouth Disease and Rinderpest 2006-06-15T11:23:35Z 2006-06-15T11:23:35Z 2006-08-15T03:59:59Z APHIS-2006-0037-0003 Exportation and importation of animals and animal products: Foot-and-mouth disease and rinderpest; disease status change-- 2006-10-24T11:47:13Z 131.01641203742474 0
APHIS-2006-0008 APHIS National Poultry Improvement Plan and Auxiliary Provisions APHIS-2006-0008-0001 National Poultry Improvement Plan and Auxiliary Provisions 2006-06-19T11:18:11Z 2006-06-19T11:18:11Z 2006-08-19T03:59:59Z APHIS-2006-0008-0003 National Poultry Improvement Plan and Auxiliary Provisions 2007-01-12T05:00:00Z 206.73737268522382 0
APHIS-2006-0025 APHIS Importation of Namibian Table Grapes into the United States APHIS-2006-0025-0001 Importation of Table Grapes From Namibia 2006-06-26T12:58:13Z 2006-06-26T12:58:13Z 2006-08-26T03:59:59Z APHIS-2006-0025-0007 Importation of Table Grapes From Namibia 2006-09-21T11:13:31Z 86.9272916666232 0
APHIS-2006-0073 APHIS Importation of Shelled Garden Peas from Kenya APHIS-2006-0073-0001 Importation of Shelled Garden Peas From Kenya 2006-07-06T11:16:55Z 2006-07-06T11:16:55Z 2006-09-06T03:59:59Z APHIS-2006-0073-0004 Plant-related quarantine, foreign: Shelled garden peas from Kenya 2006-10-24T12:18:19Z 110.04263888858259 0
APHIS-2006-0040 APHIS Importation of Fruit from Thailand APHIS-2006-0040-0001 Importation of Fruit From Thailand 2006-07-26T11:31:13Z 2006-07-26T11:31:13Z 2006-09-26T03:59:59Z APHIS-2006-0040-0047 Importation of Fruit From Thailand 2007-06-21T04:00:00Z 329.6866550925188 0
APHIS-2005-0106 APHIS Revision of Fruits and Vegetables Import Regulations (Q. 56) APHIS-2005-0106-0046 Revision of Fruits and Vegetables Import Regulations 2006-08-01T13:27:01Z     APHIS-2005-0106-0060 Revision of Fruits and Vegetables Import Regulations 2007-07-18T04:00:00Z 350.6062384257093 0
APHIS-2005-0106 APHIS Revision of Fruits and Vegetables Import Regulations (Q. 56) APHIS-2005-0106-0046 Revision of Fruits and Vegetables Import Regulations 2006-08-01T13:27:01Z     APHIS-2005-0106-0062 Revision of Fruits and Vegetables Import Regulations; Correction 2007-07-31T04:00:00Z 363.6062384257093 0
APHIS-2005-0106 APHIS Revision of Fruits and Vegetables Import Regulations (Q. 56) APHIS-2005-0106-0046 Revision of Fruits and Vegetables Import Regulations 2006-08-01T13:27:01Z     APHIS-2005-0106-0063 Revision of Fruits and Vegetables Import Regulations; Technical Amendment 2007-08-24T04:00:00Z 387.6062384257093 0
APHIS-2006-0113 APHIS Importation of Swine Hides and Skins, Bird Trophies, and Ruminant Hides and Skins APHIS-2006-0113-0001 Importation of Swine Hides and Skins, Bird Trophies, and Ruminant Hides and Skins 2006-08-04T11:19:19Z 2006-08-04T11:19:19Z 2006-10-04T03:59:59Z APHIS-2006-0113-0006 Importation of Swine Hides and Skins, Bird Trophies, and Ruminant Hides and Skins 2009-12-15T05:00:00Z 1228.7365856482647 0
APHIS-2006-0113 APHIS Importation of Swine Hides and Skins, Bird Trophies, and Ruminant Hides and Skins APHIS-2006-0113-0001 Importation of Swine Hides and Skins, Bird Trophies, and Ruminant Hides and Skins 2006-08-04T11:19:19Z 2006-08-04T11:19:19Z 2006-10-04T03:59:59Z APHIS-2006-0113-0007 Importation of Swine Hides and Skins, Bird Trophies, and Ruminant Hides and Skins; Technical Amendment 2011-05-19T04:00:00Z 1748.6949189812876 0
APHIS-2006-0120 APHIS Importation of Sheep and Goat Semen APHIS-2006-0120-0001 Importation of Sheep and Goat Semen 2006-08-09T11:15:03Z 2006-08-09T11:15:03Z 2006-10-11T03:59:59Z APHIS-2006-0120-0011 Importation of Sheep and Goat Semen 2007-11-15T05:00:00Z 462.73954861145467 0
APHIS-2006-0026 APHIS Bovine Spongiform Encephalopathy; Animal Identification and Importation of Commodities APHIS-2006-0026-0001 Bovine Spongiform Encephalopathy; Minimal-Risk Regions, Identification of Ruminants and Processing and Importation of Commodities 2006-08-09T11:46:23Z 2006-08-09T11:46:23Z 2006-11-25T04:59:59Z APHIS-2006-0026-0013 Bovine Spongiform Encephalopathy; Minimal-Risk Regions; Identification of Ruminants, and Processing and Importation of Commodities 2008-01-18T05:00:00Z 526.7177893519402 0
APHIS-2006-0027 APHIS Interstate Movement of Fruits and Vegetables from Hawaii APHIS-2006-0027-0001 Interstate Movement of Fruits and Vegetables From Hawaii 2006-10-11T11:18:09Z 2006-10-11T11:18:09Z 2006-12-12T04:59:59Z APHIS-2006-0027-0002 Interstate Movement of Fruits and Vegetables From Hawaii 2007-02-23T05:00:00Z 134.73739583371207 0
APHIS-2006-0118 APHIS Chronic Wasting Disease Herd Certification Program APHIS-2006-0118-0004 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose; Petitions and Request for Comments 2006-11-03T12:35:00Z 2006-11-03T12:35:00Z 2007-01-04T04:59:59Z APHIS-2006-0118-0001 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose 2006-07-21T11:23:38Z -105.04956018505618 0
APHIS-2006-0118 APHIS Chronic Wasting Disease Herd Certification Program APHIS-2006-0118-0004 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose; Petitions and Request for Comments 2006-11-03T12:35:00Z 2006-11-03T12:35:00Z 2007-01-04T04:59:59Z APHIS-2006-0118-0003 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose; Delay of Effective Date 2006-09-08T11:21:13Z -56.05123842600733 0
APHIS-2006-0118 APHIS Chronic Wasting Disease Herd Certification Program APHIS-2006-0118-0004 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose; Petitions and Request for Comments 2006-11-03T12:35:00Z 2006-11-03T12:35:00Z 2007-01-04T04:59:59Z APHIS-2006-0118-0199 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose 2012-06-13T04:00:00Z 2048.6423611110076 0
APHIS-2006-0118 APHIS Chronic Wasting Disease Herd Certification Program APHIS-2006-0118-0004 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose; Petitions and Request for Comments 2006-11-03T12:35:00Z 2006-11-03T12:35:00Z 2007-01-04T04:59:59Z APHIS-2006-0118-0237 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose 2012-07-20T04:00:00Z 2085.6423611110076 0
APHIS-2006-0118 APHIS Chronic Wasting Disease Herd Certification Program APHIS-2006-0118-0004 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose; Petitions and Request for Comments 2006-11-03T12:35:00Z 2006-11-03T12:35:00Z 2007-01-04T04:59:59Z APHIS-2006-0118-0741 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose 2014-04-29T04:00:00Z 2733.6423611110076 0
APHIS-2006-0026 APHIS Bovine Spongiform Encephalopathy; Animal Identification and Importation of Commodities APHIS-2006-0026-0010 Bovine Spongiform Encephalopathy; Minimal-Risk Regions, Identification of Ruminants and Processing and Importation of Commodities 2006-11-09T12:44:22Z 2006-11-09T12:44:22Z   APHIS-2006-0026-0013 Bovine Spongiform Encephalopathy; Minimal-Risk Regions; Identification of Ruminants, and Processing and Importation of Commodities 2008-01-18T05:00:00Z 434.6775231482461 0
APHIS-2006-0121 APHIS Importation of Mangos from India APHIS-2006-0121-0001 Importation of Mangoes From India 2006-11-17T05:00:00Z 2006-11-17T05:00:00Z 2007-01-17T04:59:59Z APHIS-2006-0121-0008 Importation of Mangoes From India 2007-03-12T04:00:00Z 114.95833333302289 0
APHIS-2006-0121 APHIS Importation of Mangos from India APHIS-2006-0121-0001 Importation of Mangoes From India 2006-11-17T05:00:00Z 2006-11-17T05:00:00Z 2007-01-17T04:59:59Z APHIS-2006-0121-0011 Importation of Mangoes from India; Technical Amendment 2016-07-14T04:00:00Z 3526.958333333023 0
APHIS-2006-0118 APHIS Chronic Wasting Disease Herd Certification Program APHIS-2006-0118-0013 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose; Petitions and Request for Comments 2006-11-21T05:00:00Z     APHIS-2006-0118-0001 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose 2006-07-21T11:23:38Z -122.73358796304092 0
APHIS-2006-0118 APHIS Chronic Wasting Disease Herd Certification Program APHIS-2006-0118-0013 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose; Petitions and Request for Comments 2006-11-21T05:00:00Z     APHIS-2006-0118-0003 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose; Delay of Effective Date 2006-09-08T11:21:13Z -73.73526620399207 0
APHIS-2006-0118 APHIS Chronic Wasting Disease Herd Certification Program APHIS-2006-0118-0013 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose; Petitions and Request for Comments 2006-11-21T05:00:00Z     APHIS-2006-0118-0199 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose 2012-06-13T04:00:00Z 2030.958333333023 0
APHIS-2006-0118 APHIS Chronic Wasting Disease Herd Certification Program APHIS-2006-0118-0013 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose; Petitions and Request for Comments 2006-11-21T05:00:00Z     APHIS-2006-0118-0237 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose 2012-07-20T04:00:00Z 2067.958333333023 0
APHIS-2006-0118 APHIS Chronic Wasting Disease Herd Certification Program APHIS-2006-0118-0013 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose; Petitions and Request for Comments 2006-11-21T05:00:00Z     APHIS-2006-0118-0741 Chronic Wasting Disease Herd Certification Program and Interstate Movement of Farmed or Captive Deer, Elk, and Moose 2014-04-29T04:00:00Z 2715.958333333023 0
APHIS-2006-0133 APHIS Importation of Unshu Oranges from the Republic of Korea into Alaska APHIS-2006-0133-0001 Importation of Unshu Oranges From the Republic of Korea Into Alaska 2006-12-04T05:00:00Z 2006-12-04T05:00:00Z 2007-02-03T04:59:59Z APHIS-2006-0133-0006 Importation of Unshu Oranges From the Republic of Korea Into Alaska 2007-10-25T04:00:00Z 324.9583333330229 0
APHIS-2006-0013 APHIS Standards for Permanent, Privately Owned Horse Quarantine Facilities APHIS-2006-0013-0001 Standards for Permanent, Privately Owned Horse Quarantine Facilities 2006-12-13T05:00:00Z 2006-12-13T05:00:00Z 2007-02-13T04:59:59Z APHIS-2006-0013-0017 Standards for Permanent, Privately Owned Horse Quarantine Facilities 2009-07-02T04:00:00Z 931.9583333330229 0
APHIS-2006-0183 APHIS Brucellosis in Cattle; Research Facilities APHIS-2006-0183-0001 Brucellosis in Cattle; Research Facilities 2006-12-13T05:00:00Z 2006-12-13T05:00:00Z 2007-02-13T04:59:59Z APHIS-2006-0183-0010 Brucellosis in Cattle; Research Facilities 2008-02-26T05:00:00Z 440.0 0
APHIS-2006-0186 APHIS Importation of Uncooked Pork and Pork Products APHIS-2006-0186-0001 Importation of Uncooked Pork and Pork Products 2007-01-05T05:00:00Z 2007-01-05T05:00:00Z 2007-03-07T04:59:59Z APHIS-2006-0186-0013 Importation of Uncooked Pork and Pork Products 2008-04-02T04:00:00Z 452.9583333330229 0
APHIS-2006-0186 APHIS Importation of Uncooked Pork and Pork Products APHIS-2006-0186-0001 Importation of Uncooked Pork and Pork Products 2007-01-05T05:00:00Z 2007-01-05T05:00:00Z 2007-03-07T04:59:59Z APHIS-2006-0186-0014 Importation of Uncooked Pork and Pork Products; Correction 2008-04-15T04:00:00Z 465.9583333330229 0
APHIS-2006-0041 APHIS Bovine Spongiform Encephalopathy; Minimal-Risk Regions; Importation of Live Bovines and Products Derived from Bovines Commodities APHIS-2006-0041-0001 Bovine Spongiform Encephalopathy; Minimal-Risk Regions; Importation of Live Bovines and Products Derived From Bovines 2007-01-09T05:00:00Z 2007-01-09T05:00:00Z 2007-03-13T03:59:59Z APHIS-2006-0041-0402 Bovine Spongiform Encephalopathy; Minimal-Risk Regions; Importation of Live Bovines and Products Derived From Bovines 2007-09-18T04:00:00Z 251.9583333330229 0
APHIS-2006-0041 APHIS Bovine Spongiform Encephalopathy; Minimal-Risk Regions; Importation of Live Bovines and Products Derived from Bovines Commodities APHIS-2006-0041-0001 Bovine Spongiform Encephalopathy; Minimal-Risk Regions; Importation of Live Bovines and Products Derived From Bovines 2007-01-09T05:00:00Z 2007-01-09T05:00:00Z 2007-03-13T03:59:59Z APHIS-2006-0041-0409 Correction - Bovine Spongiform Encephalopathy; Minimal-Risk Regions; Importation of Live Bovines and Products Derived from Bovines 2007-10-15T04:00:00Z 278.9583333330229 0
APHIS-2006-0147 APHIS Cattle for Export; Removal of Certain Testing Requirements APHIS-2006-0147-0001 Cattle for Export; Removal of Certain Testing Requirements 2007-01-10T05:00:00Z 2007-01-10T05:00:00Z 2007-03-13T03:59:59Z APHIS-2006-0147-0010 Cattle for Export; Removal of Certain Testing Requirements 2007-07-23T04:00:00Z 193.9583333330229 0
APHIS-2006-0104 APHIS Classical Swine Fever Status of the Mexican State of Nayarit APHIS-2006-0104-0001 Classical Swine Fever Status of the Mexican State of Nayarit 2007-01-31T05:00:00Z 2007-01-31T05:00:00Z 2007-04-03T03:59:59Z APHIS-2006-0104-0005 Classical Swine Fever Status of the Mexican State of Nayarit 2007-06-01T04:00:00Z 120.95833333302289 0
APHIS-2006-0079 APHIS Viruses, Serums, Toxins, and Analogous Products; Standard Requirements for Live Vaccines APHIS-2006-0079-0001 Viruses, Serums, Toxins, and Analogous Products; Standard Requirements for Live Vaccines 2007-01-31T05:00:00Z 2007-01-31T05:00:00Z 2007-04-03T03:59:59Z APHIS-2006-0079-0004 Viruses, Serums, Toxins, and Analogous Products; Standard Requirements for Live Vaccines 2007-12-21T05:00:00Z 324.0 0
APHIS-2006-0106 APHIS Importation of Live Swine, Swine Semen, Pork and Pork Products from the Czech Republic, Latvia, Lithuania, and Poland APHIS-2006-0106-0001 Importation of Live Swine, Swine Semen, Pork, and Pork Products From the Czech Republic, Latvia, Lithuania, and Poland 2007-02-12T05:00:00Z 2007-02-12T05:00:00Z 2007-04-14T03:59:59Z APHIS-2006-0106-0017 Importation of Live Swine, Swine Semen, Pork, and Pork Products From the Czech Republic, Latvia, Lithuania, and Poland 2007-11-28T05:00:00Z 289.0 0
APHIS-2006-0104 APHIS Classical Swine Fever Status of the Mexican State of Nayarit APHIS-2006-0104-0004 Classical Swine Fever Status of the Mexican State of Nayarit; Correction 2007-02-22T05:00:00Z     APHIS-2006-0104-0005 Classical Swine Fever Status of the Mexican State of Nayarit 2007-06-01T04:00:00Z 98.95833333302289 0
APHIS-2006-0093 APHIS National Veterinary Accreditation Program APHIS-2006-0093-0025 National Veterinary Accreditation Program 2007-02-27T05:00:00Z 2007-02-27T05:00:00Z 2007-05-01T03:59:59Z APHIS-2006-0093-0041 National Veterinary Accreditation Program 2009-12-09T05:00:00Z 1016.0 0
APHIS-2006-0093 APHIS National Veterinary Accreditation Program APHIS-2006-0093-0025 National Veterinary Accreditation Program 2007-02-27T05:00:00Z 2007-02-27T05:00:00Z 2007-05-01T03:59:59Z APHIS-2006-0093-0042 National Veterinary Accreditation Program; Correcting Amendment 2010-09-22T04:00:00Z 1302.958333333023 0
APHIS-2006-0093 APHIS National Veterinary Accreditation Program APHIS-2006-0093-0025 National Veterinary Accreditation Program 2007-02-27T05:00:00Z 2007-02-27T05:00:00Z 2007-05-01T03:59:59Z APHIS-2006-0093-0043 National Veterinary Accreditation Program: Currently Accredited Veterinarians Performing Accredited Duties and Electing to Participate 2010-09-28T04:00:00Z 1308.958333333023 0
APHIS-2006-0093 APHIS National Veterinary Accreditation Program APHIS-2006-0093-0025 National Veterinary Accreditation Program 2007-02-27T05:00:00Z 2007-02-27T05:00:00Z 2007-05-01T03:59:59Z APHIS-2006-0093-0044 National Veterinary Accreditation Program: Currently Accredited Veterinarians Performing Accredited Duties and Electing to Participate 2011-08-23T04:00:00Z 1637.958333333023 0
APHIS-2006-0089 APHIS Trichinae Certification Program APHIS-2006-0089-0001 Trichinae Certification Program 2007-05-16T04:00:00Z 2007-05-16T04:00:00Z 2007-07-17T03:59:59Z APHIS-2006-0089-0009 Trichinae Certification Program 2008-10-10T04:00:00Z 513.0 0
APHIS-2007-0061 APHIS Importation of Blueberries From South Africa, Uruguay, and Argentina With Cold Treatment APHIS-2007-0061-0001 Importation of Blueberries From South Africa, Uruguay, and Argentina With Cold Treatment 2007-06-05T04:00:00Z 2007-06-05T04:00:00Z 2007-07-21T03:59:59Z APHIS-2007-0061-0012 Importation of Blueberries From South Africa, Uruguay, and Argentina With Cold Treatment 2007-09-17T04:00:00Z 104.0 0
APHIS-2006-0137 APHIS User Fees; Export Certification for Plants and Plant Products APHIS-2006-0137-0001 User Fees; Export Certification for Plants and Plant Products 2007-06-12T04:00:00Z 2007-06-12T04:00:00Z 2007-08-14T03:59:59Z APHIS-2006-0137-0078 User Fees; Export Certification for Plants and Plant Products 2009-07-08T04:00:00Z 757.0 0
APHIS-2007-0061 APHIS Importation of Blueberries From South Africa, Uruguay, and Argentina With Cold Treatment APHIS-2007-0061-0006 Importation of Blueberries From South Africa, Uruguay, and Argentina With Cold Treatment; Correction 2007-06-15T04:00:00Z     APHIS-2007-0061-0012 Importation of Blueberries From South Africa, Uruguay, and Argentina With Cold Treatment 2007-09-17T04:00:00Z 94.0 0
APHIS-2007-0022 APHIS Citrus Canker; Movement of Fruit from Quarantined Areas APHIS-2007-0022-0001 Citrus Canker; Movement of Fruit From Quarantined Areas 2007-06-21T04:00:00Z 2007-06-21T04:00:00Z 2007-08-08T03:59:59Z APHIS-2007-0022-0079 Citrus Canker; Movement of Fruit From Quarantined Areas 2007-11-19T05:00:00Z 151.0416666669771 0
APHIS-2006-0091 APHIS Amendments to Treatments for Plant Pests APHIS-2006-0091-0001 Amendments to Treatments for Plant Pests 2007-07-05T04:00:00Z 2007-07-05T04:00:00Z 2007-09-05T03:59:59Z APHIS-2006-0091-0003 Amendments to Treatments for Plant Pests 2008-05-27T04:00:00Z 327.0 0
APHIS-2006-0075 APHIS Gypsy Moth Regulations; Updates and Clarifications APHIS-2006-0075-0001 Gypsy Moth Regulations; Updates and Clarifications 2007-07-17T04:00:00Z 2007-07-17T04:00:00Z 2007-09-18T03:59:59Z APHIS-2006-0075-0002 Gypsy Moth Regulations; Updates and Clarifications 2007-12-13T05:00:00Z 149.0416666669771 0
APHIS-2006-0028 APHIS User Fees; Updates and Clarifications APHIS-2006-0028-0001 User Fees; Updates and Clarifications 2007-07-17T04:00:00Z 2007-07-17T04:00:00Z 2007-09-18T03:59:59Z APHIS-2006-0028-0003 User Fees; Updates and Clarifications 2007-12-13T05:00:00Z 149.0416666669771 0
APHIS-2006-0161 APHIS Veterinary Diagnostic Services User Fees APHIS-2006-0161-0001 Veterinary Diagnostic Services User Fees 2007-07-23T04:00:00Z 2007-07-23T04:00:00Z 2007-09-22T03:59:59Z APHIS-2006-0161-0004 Veterinary Diagnostic Services User Fees 2007-12-19T05:00:00Z 149.0416666669771 0
APHIS-2007-0022 APHIS Citrus Canker; Movement of Fruit from Quarantined Areas APHIS-2007-0022-0060 Citrus Canker; Movement of Fruit From Quarantined Areas - Reopening of comment period 2007-07-27T04:00:00Z     APHIS-2007-0022-0079 Citrus Canker; Movement of Fruit From Quarantined Areas 2007-11-19T05:00:00Z 115.04166666697711 0
APHIS-2006-0164 APHIS Temporary Importation of Horses; Noncompetitive Entertainment Horses from Countries Affected with Contagious Equine Metritis APHIS-2006-0164-0001 Temporary Importation of Horses; Noncompetitive Entertainment Horses From Countries Affected With Contagious Equine Metritis 2007-08-02T04:00:00Z 2007-08-02T04:00:00Z 2007-10-02T03:59:59Z APHIS-2006-0164-0007 Temporary Importation of Horses; Noncompetitive Entertainment Horses From Countries Affected With Contagious Equine Metritis 2008-06-05T04:00:00Z 308.0 0
APHIS-2005-0081 APHIS Importation of Nursery Stock APHIS-2005-0081-0029 Importation of Nursery Stock; Postentry Quarantine Requirements for Potential Hosts of Chrysanthemum White Rust and Definition of From 2007-08-08T04:00:00Z 2007-08-08T04:00:00Z 2007-11-27T04:59:59Z APHIS-2005-0081-0028 Importation of Nursery Stock 2007-08-06T04:00:00Z -2.0 0
APHIS-2005-0081 APHIS Importation of Nursery Stock APHIS-2005-0081-0029 Importation of Nursery Stock; Postentry Quarantine Requirements for Potential Hosts of Chrysanthemum White Rust and Definition of From 2007-08-08T04:00:00Z 2007-08-08T04:00:00Z 2007-11-27T04:59:59Z APHIS-2005-0081-0044 Importation of Nursery Stock; Technical Amendment 2007-11-30T05:00:00Z 114.04166666697711 0
APHIS-2007-0014 APHIS Importation of Table Eggs from Regions Where Exotic Newcastle Disease Exists APHIS-2007-0014-0001 Importation of Table Eggs From Regions Where Exotic Newcastle Disease Exists 2007-08-13T04:00:00Z 2007-08-13T04:00:00Z 2007-10-13T03:59:59Z APHIS-2007-0014-0008 Importation of Table Eggs from Regions Where Exotic Newcastle Disease Exists 2009-04-22T04:00:00Z 618.0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW regulatory_pipeline AS
SELECT
    d.id AS docket_id,
    d.agency_id,
    d.title AS docket_title,
    proposed.id AS proposed_rule_id,
    proposed.title AS proposed_rule_title,
    proposed.posted_date AS proposed_date,
    proposed.comment_start_date,
    proposed.comment_end_date,
    final.id AS final_rule_id,
    final.title AS final_rule_title,
    final.posted_date AS final_date,
    julianday(final.posted_date) - julianday(proposed.posted_date) AS days_proposed_to_final,
    (SELECT COUNT(*) FROM comments c WHERE c.docket_id = d.id) AS total_comments
FROM dockets d
JOIN documents proposed ON proposed.docket_id = d.id AND proposed.document_type = 'Proposed Rule'
JOIN documents final ON final.docket_id = d.id AND final.document_type = 'Rule'
WHERE d.docket_type = 'Rulemaking';