cfr_sections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
20 rows where part_number = 147 and title_number = 9 sorted by section_id
This data as json, CSV (advanced)
Suggested facets: subpart, subpart_name, amendment_citations, full_text
| section_id ▼ | title_number | title_name | chapter | subchapter | part_number | part_name | subpart | subpart_name | section_number | section_heading | agency | authority | source_citation | amendment_citations | full_text |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9:9:1.0.1.7.64.1.83.1 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | A | Subpart A—Blood Testing Procedures | § 147.1 Blood testing procedures. | APHIS | [79 FR 38766, July 9, 2014] | Blood testing must be conducted in a manner approved by the Administrator. Approved blood testing procedures are listed in the NPIP Program Standards, as defined in § 147.51. Blood testing procedures may also be approved by the Administrator in accordance with § 147.53(d)(1). | |||
| 9:9:1.0.1.7.64.1.83.2 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | A | Subpart A—Blood Testing Procedures | §§ 147.2-147.9 [Reserved] | APHIS | |||||
| 9:9:1.0.1.7.64.2.83.1 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | B | Subpart B—Bacteriological Examination Procedure | § 147.10 Bacteriological examination procedures. | APHIS | [79 FR 38766, July 9, 2014] | Bacteriological examination must be conducted in a manner approved by the Administrator. Approved bacteriological examination procedures are listed in the NPIP Program Standards, as defined in § 147.51. Bacteriological examination procedures may also be approved by the Administrator in accordance with § 147.53(d)(1). | |||
| 9:9:1.0.1.7.64.2.83.2 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | B | Subpart B—Bacteriological Examination Procedure | §§ 147.11-147.17 [Reserved] | APHIS | |||||
| 9:9:1.0.1.7.64.3.83.1 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | C | Subpart C—Sanitation Procedures | § 147.21 Sanitation procedures. | APHIS | [79 FR 38766, July 9, 2014; 79 FR 44263, July 31, 2014] | Sanitation must be maintained in a manner approved by the Administrator. Approved procedures for maintaining sanitation are listed in the NPIP Program Standards, as defined in § 147.51. Sanitation procedures may also be approved by the Administrator in accordance with § 147.53(d)(2). | |||
| 9:9:1.0.1.7.64.3.83.2 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | C | Subpart C—Sanitation Procedures | §§ 147.22-147.27 [Reserved] | APHIS | |||||
| 9:9:1.0.1.7.64.4.83.1 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | D | Subpart D—Molecular Examination Procedures | § 147.30 Molecular examination procedures. | APHIS | [79 FR 38766, July 9, 2014] | Molecular examination must be conducted in a manner approved by the Administrator. Approved molecular examination procedures are listed in the NPIP Program Standards, as defined in § 147.51. Molecular examination procedures may also be approved by the Administrator in accordance with § 147.53(d)(1). | |||
| 9:9:1.0.1.7.64.4.83.2 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | D | Subpart D—Molecular Examination Procedures | § 147.31 [Reserved] | APHIS | |||||
| 9:9:1.0.1.7.64.5.83.1 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | E | Subpart E—Procedure for Changing National Poultry Improvement Plan | § 147.41 Definitions. | APHIS | [36 FR 23121, Dec. 3, 1971, as amended at 38 FR 3038, Feb. 1, 1973. Redesignated at 44 FR 61586, Oct. 26, 1979; 59 FR 12805, Mar. 18, 1994, as amended at 79 FR 38766, July 9, 2014; 83 FR 28355, June 19, 2018] | Except where the context otherwise requires, for the purposes of this subpart the following terms shall be construed, respectively, to mean: Department. The U.S. Department of Agriculture. Egg type chickens. Chickens bred for the primary purpose of producing eggs for human consumption. Exhibition Poultry. Domesticated fowl which are bred for the combined purposes of meat or egg production and competitive showing. Game birds. Domesticated fowl, such as pheasants, partridge, quail, grouse, and guineas, but not doves and pigeons. Meat type chickens. Chickens bred for the primary purpose of producing meat. NPIP Technical Committee. A committee made up of technical experts on poultry health, biosecurity, surveillance, and diagnostics. The committee consists of representatives from the poultry and egg industries, universities, and State and Federal governments and is appointed by the Senior Coordinator and approved by the General Conference Committee. The NPIP Technical Committee is divided into three subcommittees (Mycoplasma, Salmonella, and Avian Influenza). NPIP Technical Committee Members may serve on one, two, or all three subcommittees. The committee will evaluate proposed changes to the Provisions and Program Standards of the Plan which include, but are not limited to, tests and sanitation procedures, and provide recommendations to the Delegates of the National Plan Conference as to whether they are scientifically or technically sound. Plan Conference. A meeting convened for the purpose of recommending changes in the provisions of the Plan. Plan or NPIP. The National Poultry Improvement Plan. Service. The Animal and Plant Health Inspection Service, Veterinary Services, of the Department. State. Any State, the District of Columbia, or Puerto Rico. Waterfowl. Domesticated fowl that normally swim, such as ducks and geese. | |||
| 9:9:1.0.1.7.64.5.83.2 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | E | Subpart E—Procedure for Changing National Poultry Improvement Plan | § 147.42 General. | APHIS | Changes in this subchapter shall be made in accordance with the procedure described in this subpart: Provided, That the Department reserves the right to make changes in this subchapter without observance of such procedure when such action is deemed necessary in the public interest. | ||||
| 9:9:1.0.1.7.64.5.83.3 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | E | Subpart E—Procedure for Changing National Poultry Improvement Plan | § 147.43 General Conference Committee. | APHIS | [36 FR 23121, Dec. 3, 1971, as amended at 40 FR 1505, Jan. 8, 1975. Redesignated at 44 FR 61586, Oct. 26, 1979, and amended at 45 FR 10316, Feb. 15, 1980; 47 FR 21996, May 20, 1982; 50 FR 19900, May 13, 1985; 59 FR 12805, Mar. 18, 1994; 61 FR 11525, Mar. 21, 1996; 65 FR 8023, Feb. 17, 2000; 67 FR 8475, Feb. 25, 2002; 74 FR 14718, Apr. 1, 2009; 83 FR 28355, June 19, 2018] | (a) The General Conference Committee Chairperson and the Vice Chairperson shall be elected by the members of the General Conference Committee. A representative of the Animal and Plant Health Inspection Service will serve as Executive Secretary and will provide the necessary staff support for the General Conference Committee. The General Conference Committee shall consist of one member-at-large who is a participant in the National Poultry Improvement Plan and one member to be elected, as provided in paragraph (b) of this section, from each of the following regions: (1) North Atlantic: Maine, New Hampshire, Vermont, Massachusetts, Rhode Island, Connecticut, New York, New Jersey, and Pennsylvania. (2) East North Central: Ohio, Indiana, Illinois, Michigan, and Wisconsin. (3) West North Central: Minnesota, Iowa, Missouri, North Dakota, South Dakota, Nebraska, and Kansas. (4) South Atlantic: Delaware, District of Columbia, Maryland, Virginia, West Virginia, North Carolina, South Carolina, Georgia, Florida, and Puerto Rico. (5) South Central: Kentucky, Tennessee, Alabama, Mississippi, Arkansas, Louisiana, Oklahoma, and Texas. (6) Western: Montana, Idaho, Wyoming, Colorado, New Mexico, Arizona, Utah, Nevada, Washington, Oregon, California, Alaska, and Hawaii. (b) The regional committee members and their alternates will be elected by the official delegates of their respective regions, and the member-at-large will be elected by all official delegates. There must be at least two nominees for each position, the voting will be by secret ballot, and the results will be recorded. The ballots for electing regional committee members and their alternates will be printed in such a way as to allow the specific selection of one nominee for member, and one nominee for alternate from the remaining nominees. At least one nominee from each region must be from an underrepresented group (minorities, women, or persons with disabilities). The process for soliciting nominations for regional committee members will include, but not be li… | |||
| 9:9:1.0.1.7.64.5.83.4 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | E | Subpart E—Procedure for Changing National Poultry Improvement Plan | § 147.44 Submitting, compiling, and distributing proposed changes. | APHIS | [36 FR 23121, Dec. 3, 1971. Redesignated at 44 FR 61586, Oct. 26, 1979, and amended at 49 FR 19807, May 10, 1984; 79 FR 38766, July 9, 2014] | (a) Changes in this subchapter may be proposed by any participant, Official State Agency, the Department, or other interested person or industry organization. (b) Except as provided in § 147.43(d)(4), proposed changes shall be submitted in writing so as to reach the Service not later than 150 days prior to the opening date of the Plan Conference, and participants in the Plan shall submit their proposed changes through their Official State Agency. (c) The name of the proponent shall be indicated on each proposed change when submitted. Each proposal should be accompanied by a brief supporting statement. (d) The Service will notify all persons on the NPIP mailing lists concerning the dates and general procedure of the conference. Hatchery and dealer participants will be reminded of their privilege to submit proposed changes and to request copies of all the published proposed changes. (e) The proposed changes, together with the names of the proponents and supporting statements, will be compiled by the Service and issued in processed form. When two or more similar changes are submitted, the Service will endeavor to unify them into one proposal acceptable to each proponent. Copies will be distributed to officials of the Official State Agencies cooperating in the NPIP. Additional copies will be made available for meeting individual requests. | |||
| 9:9:1.0.1.7.64.5.83.5 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | E | Subpart E—Procedure for Changing National Poultry Improvement Plan | § 147.45 Official delegates. | APHIS | [85 FR 62572, Oct. 5, 2020] | Each cooperating State shall be entitled to one official delegate for each of the programs prescribed in parts 145 and 146 of this subchapter in which it has one or more participants at the time of the Conference. The official delegates shall be elected by a representative group of participating industry members and be certified by the Official State Agency. It is recommended but not required that the official delegates be Plan participants. Individuals may be allowed to be an official delegate or alternate delegate for up to three States in which that delegate has flocks or is a plan participant with acknowledgement and approval of the Official State Agencies. Each official delegate shall endeavor to obtain, prior to the Conference, the recommendations of industry members of their State with respect to each proposed change. | |||
| 9:9:1.0.1.7.64.5.83.6 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | E | Subpart E—Procedure for Changing National Poultry Improvement Plan | § 147.46 Committee consideration of proposed changes. | APHIS | [36 FR 23121, Dec. 3, 1971, as amended at 41 FR 48727, Nov. 5, 1976. Redesignated at 44 FR 61586, Oct. 26, 1979, as amended at 65 FR 8023, Feb. 17, 2000; 71 FR 56333, Sept. 26, 2006; 74 FR 14718, Apr. 1, 2009; 83 FR 28355, June 19, 2018; 90 FR 46748, Sept. 30, 2025] | (a) The following committees shall be established to give preliminary consideration to the proposed changes falling in their respective fields: (1) Egg-type breeding chickens. (2) Meat-type breeding chickens. (3) Breeding turkeys. (4) Breeding waterfowl, exhibition poultry, and game birds. (5) Breeding ostriches, emus, rheas, and cassowaries. (6) Egg-type commercial chickens. (7) Meat-type commercial chickens. (8) Meat-type commercial turkeys. (9) Egg/meat-type game birds and waterfowl. (b) Each official delegate shall be appointed a voting member in one of the committees specified in paragraph (a) of this section. (c) Since several of the proposals may be interrelated, the committees shall consider them as they may relate to others, and feel free to discuss related proposals with other committees. (d) The committees shall make recommendations to the conference as a whole concerning each proposal. The committee report shall show any proposed change in wording and the record of the vote on each proposal, and suggest an effective date for each proposal recommended for adoption. The individual committee reports shall be submitted to the chairman of the conference, who will combine them into one report showing, in numerical sequence, the committee recommendations on each proposal. Once completed, the combined committee report will be distributed electronically to the Official State Agencies prior to the delegates voting on the final day of the biennial conference. (e) The committee meetings shall be open to any interested person. Advocates for or against any proposal should feel free to appear before the appropriate committee and present their views. | |||
| 9:9:1.0.1.7.64.5.83.7 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | E | Subpart E—Procedure for Changing National Poultry Improvement Plan | § 147.47 Conference consideration of proposed changes. | APHIS | [36 FR 23121, Dec. 3, 1971, as amended at 41 FR 48727, Nov. 5, 1976. Redesignated at 44 FR 61586, Oct. 26, 1979] | (a) The chairman of the conference shall be a representative of the Department. (b) At the time designated for voting on proposed changes by the official delegates, the chairman of the General Conference Committee and the four committee chairmen shall sit at the speaker's table and assist the chairman of the conference. (c) Each committee chairman shall present the proposals which his committee approves or recommends for adoption as follows: “Mr. Chairman. The committee for Egg-type chickens recommends the adoption of Proposal No. ______, for the following reasons (stating the reasons): I move the adoption of Proposal No. ______.” A second will then be called for. If the recommendation is seconded, discussion and a formal vote will follow. (d) Each committee chairman shall present the proposals which his committee does not approve as follows: “Mr. Chairman. The Committee for Egg-type chickens does not approve Proposal No. ______.” The chairman will then ask if any official delegate wishes to move for the adoption of the proposal. If moved and seconded, the proposal is subject to discussion and voted. If there is no motion for approval, or if moved but not seconded, there can be no discussion or vote. (e) Discussion on any motion must be withheld until the motion has been properly seconded, except that the delegate making the motion is privileged, if he desires, to give reasons for his motion at the time of making it. To gain the floor for a motion or for discussion on a motion, the official delegate in the case of a motion, or anyone in case of discussion on a motion, shall rise, address the chair, give his name and State, and be recognized by the chair before proceeding further. While it is proper to accept motions only from official delegates and to limit voting only to such delegates, it is, however, equally proper to accept discussion from anyone interested. To conserve time, discussion should be pointed and limited to the pertinent features of the motion. (f) Proposals that have not been submitted in ac… | |||
| 9:9:1.0.1.7.64.5.83.8 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | E | Subpart E—Procedure for Changing National Poultry Improvement Plan | § 147.48 Approval of conference recommendations by the Department. | APHIS | [85 FR 62572, Oct. 5, 2020] | Proposals adopted by the official delegates will be recommended to the Department for incorporation into the provisions of the National Poultry Improvement Plan (NPIP) in parts 56, 145, and 146 of this chapter and this subpart. The Department reserves the right to approve or disapprove the recommendations of the conference as an integral part of its sponsorship of the National Poultry Improvement Plan. The Department will publish the recommendations in the Federal Register within 14 months following the NPIP Biennial Conference. | |||
| 9:9:1.0.1.7.64.6.83.1 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | F | Subpart F—Authorized Laboratories and Approved Tests and Sanitation Procedures | § 147.51 Definitions. | APHIS | [79 FR 38766, July 9, 2014, as amended at 83 FR 28355, June 19, 2018] | The following definitions apply in this subpart: Administrator. The Administrator, Animal and Plant Health Inspection Service, or any other employee of the Animal and Plant Health Inspection Service delegated to act in the Administrator's stead. Animal and Plant Health Inspection Service (APHIS, the Service). The Animal and Plant Health Inspection Service of the U.S. Department of Agriculture. NPIP or Plan. The National Poultry Improvement Plan. NPIP Program Standards. A document that contains tests and sanitation procedures approved by the Administrator under § 147.53 for use under this subchapter. This document may be obtained from the NPIP Web site at http://www.poultryimprovement.org/ or by writing to the Service at National Poultry Improvement Plan, APHIS, USDA, 1506 Klondike Road, Suite 101, Conyers, GA 30094. NPIP Technical Committee. A committee made up of technical experts on poultry health, biosecurity, surveillance, and diagnostics. The committee consists of representatives from the poultry and egg industries, universities, and State and Federal governments and is appointed by the Senior Coordinator and approved by the General Conference Committee. The NPIP Technical Committee is divided into three subcommittees (Mycoplasma, Salmonella, and Avian Influenza). NPIP Technical Committee Members may serve on one, two, or all three subcommittees. The committee will evaluate proposed changes to the Provisions and Program Standards of the Plan which include, but are not limited to, tests and sanitation procedures, and provide recommendations to the Delegates of the National Plan Conference as to whether they are scientifically or technically sound. | |||
| 9:9:1.0.1.7.64.6.83.2 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | F | Subpart F—Authorized Laboratories and Approved Tests and Sanitation Procedures | § 147.52 Authorized laboratories. | APHIS | [79 FR 38766, July 9, 2014, as amended at 81 FR 53251, Aug. 12, 2016; 83 FR 28355, June 19, 2018; 85 FR 62572, Oct. 5, 2020; 90 FR 46748, Sept. 30, 2025] | These minimum requirements are intended to be the basis on which an authorized laboratory of the Plan can be evaluated to ensure that official Plan assays are performed in accordance with the NPIP Program Standards or other procedures approved by the Administrator in accordance with § 147.53(d)(1) and reported as described in paragraph (f) of this section. A satisfactory evaluation will result in the laboratory being recognized by the NPIP office of the Service as an authorized laboratory qualified to perform the assays provided for in this part. (a) Check-test proficiency. The NPIP will serve as the lead agency for the coordination of available check tests from the National Veterinary Services Laboratories. Further, the NPIP may approve and authorize additional laboratories to produce and distribute a check test as needed. The authorized laboratory must use the next available check test for each assay that it performs. (b) Trained technicians. Testing procedures at all authorized laboratories must be run or overseen by a laboratory technician who every 4 years has attended, and satisfactorily completed, Service-approved laboratory workshops for Plan-specific diseases. (c) Laboratory protocol. Official Plan assays must be performed and reported as described in the NPIP Program Standards or in accordance with other procedures approved by the Administrator in accordance with § 147.53(d)(1). Assays must be performed using control reagents approved by the Plan or the reagent manufacturer. (d) State site visit. The Official State Agency will conduct a site visit and recordkeeping audit at least once every 2 years. This will include, but may not be limited to, review of technician training records, check test proficiency, and test results. The information from the site visit and recordkeeping audit will be made available to the NPIP upon request. (e) Service review. Authorized laboratories will be reviewed by the Service (NPIP staff) every 3 years. The Service's review may include, but will not necessari… | |||
| 9:9:1.0.1.7.64.6.83.3 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | F | Subpart F—Authorized Laboratories and Approved Tests and Sanitation Procedures | § 147.53 Approved tests and sanitation procedures. | APHIS | (a)(1) All tests that are used to qualify flocks for NPIP classifications must be approved by the Administrator as effective and accurate at determining whether a disease is present in a poultry flock or in the environment. (2) All sanitation procedures performed as part of qualifying for an NPIP classification must be approved by the Administrator as effective at reducing the risk of incidence of disease in a poultry flock or hatchery. (b) Tests and sanitation procedures that have been approved by the Administrator may be found in the NPIP Program Standards. In addition, all tests that use veterinary biologics (e.g., antiserum and other products of biological origin) that are licensed or produced by the Service and used as described in the NPIP Program Standards are approved for use in the NPIP. (c) New tests and sanitation procedures, or changes to existing tests and sanitation procedures, that have been approved by the NPIP in accordance with the process described in subpart E of this part are subject to approval by the Administrator. NPIP participants may submit new tests and sanitation procedures, or changes to current tests and sanitation procedures, through that process. (d)(1) Persons who wish to have a test approved by the Administrator as effective and accurate at determining whether a disease is present in a flock or in the environment may apply for approval by submitting the test, along with any supporting information and data, to the National Poultry Improvement Plan, APHIS, USDA, 1506 Klondike Road, Suite 101, Conyers, GA 30094. Upon receipt of such an application, the NPIP Technical Committee will review the test and any supporting information and data supplied with the application. If the NPIP Technical Committee determines the test to be of potential general use, the test will be submitted for consideration by the General Conference Committee of the NPIP in accordance with subpart E of this part, and the Administrator will respond with approval or denial of the test. (2) Persons who wish to … | ||||
| 9:9:1.0.1.7.64.6.83.4 | 9 | Animals and Animal Products | I | G | 147 | PART 147—AUXILIARY PROVISIONS ON NATIONAL POULTRY IMPROVEMENT PLAN | F | Subpart F—Authorized Laboratories and Approved Tests and Sanitation Procedures | § 147.54 Approval of diagnostic test kits not licensed by the Service. | APHIS | [81 FR 53251, Aug. 12, 2016, as amended at 83 FR 28356, June 19, 2018] | (a) Diagnostic test kits that are not licensed by the Service (e.g., bacteriological culturing kits) may be approved through the following procedure: (1) The sensitivity of the kit will be evaluated in at least three NPIP authorized laboratories by testing known positive samples, as determined by the official NPIP procedures found in the NPIP Program Standards or through other procedures approved by the Administrator. Field samples, for which the presence or absence of the target organism or analyte has been determined by the current NPIP test, are the preferred samples and should be used when possible. Samples from a variety of field cases representing a range of low, medium, and high analyte concentrations should be used. In some cases it may be necessary to utilize samples from experimentally infected animals. Spiked samples (clinical sample matrix with a known amount of pure culture added) should only be used in the event that no other sample types are available. When the use of spiked samples may be necessary, prior approval from the NPIP Technical Committee is required. Pure cultures should never be used. Additionally, laboratories should be selected for their experience with testing for the target organism or analyte with the current NPIP approved test. ( e.g., a Salmonella test should be evaluated by NPIP authorized laboratories that test for Salmonella routinely). If certain conditions or interfering substances are known to affect the performance of the kit, appropriate samples will be included so that the magnitude and significance of the effect(s) can be evaluated. (2) The specificity of the kit will be evaluated in at least three NPIP authorized laboratories by testing known negative samples, as determined by tests conducted in accordance with the NPIP Program Standards or other procedures approved by the Administrator in accordance with § 147.53(d)(1). If certain conditions or interfering substances are known to affect the performance of the kit, appropriate samples will be included so that the ma… |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE cfr_sections (
section_id TEXT PRIMARY KEY,
title_number INTEGER,
title_name TEXT,
chapter TEXT,
subchapter TEXT,
part_number TEXT,
part_name TEXT,
subpart TEXT,
subpart_name TEXT,
section_number TEXT,
section_heading TEXT,
agency TEXT,
authority TEXT,
source_citation TEXT,
amendment_citations TEXT,
full_text TEXT
);
CREATE INDEX idx_cfr_title ON cfr_sections(title_number);
CREATE INDEX idx_cfr_part ON cfr_sections(part_number);
CREATE INDEX idx_cfr_agency ON cfr_sections(agency);