cfr_sections
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
19 rows where agency = "RHS" and part_number = 1822 sorted by section_id
This data as json, CSV (advanced)
Suggested facets: amendment_citations
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7:7:12.1.2.2.5.2.1.1 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.261 General. | RHS | [35 FR 16087, July 1, 1970, as amended at 58 FR 224, Jan. 5, 1993; 80 FR 9866, Feb. 24, 2015] | This subpart sets forth the policies and procedures and delegates authority for making Rural Housing Site (RHS) loans under sections 523 and 524 of the Housing Act of 1949. Any processing or servicing activity conducted pursuant to this subpart involving authorized Rural Development (RD) employees, members of their families, known close relatives, or business or close personal associates, is subject to the provisions of subpart D of part 1900 of this chapter. Applicants for this assistance are required to identify any known relationship or association with an RD employee. Section 523 loans are direct loans for the purchase and development of building sites for housing to be built by the self-help method; they have additional requirements which are contained in § 1822.278. | |||
| 7:7:12.1.2.2.5.2.1.10 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.270 Technical, legal, and other services. | RHS | [35 FR 16087, July 1, 1970, as amended at 51 FR 6733, Feb. 26, 1986; 56 FR 67471, Dec. 31, 1991; 80 FR 9866, Feb. 24, 2015] | (a) Appraisals. The property will be appraised by an RD employee authorized to make real estate appraisals. The appraisal will consist of a narrative statement prepared and signed by the authorized employee describing in detail the items considered in arriving at the value of the property. Two values will be established by the appraiser: (1) The fair market value of the total property “as is”. (2) The aggregate fair market value of the building sites after development. (i) In determining the value of the property, the appraiser will consider the value and selling prices of similar building sites in the area. The selling prices of similar sites must be fully documented. (ii) [Reserved] (b) Title clearance and legal services. For a loan to a public nonprofit organization, title clearance and legal services will be obtained in accordance with instructions from the OGC, observing the provisions of subpart B of part 1927 of this chapter to the extent feasible. For a loan to a private nonprofit organization, the provisions of subpart B of part 1927 of this chapter regarding title clearance and legal services will apply. The applicant will be encouraged to have the same approved closing agent, where practical, perform the title clearance work in connection with the purchase of the land and the sale of the individual sites. (c) Contracts for legal services. On projects requiring more legal services than are customarily required for title clearance alone, the applicant will be required to have a written contract when loan funds will be used for legal services. All such contracts will be subject to review and approval by the State director and therefore should be submitted to the State Director before execution by the applicant. Contracts will provide for the types of service to be performed and the amount of fees to be paid either in lump sum on the completion of all services or in installments as services are performed. (d) Engineering services. On projects requiring engineering services, a written contrac… | |||
| 7:7:12.1.2.2.5.2.1.11 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.271 Processing applications. | RHS | [35 FR 16087, July 1, 1970, as amended at 41 FR 7487, Feb. 19, 1976; 41 FR 20392, May 18, 1976; 43 FR 24264, June 5, 1978; 44 FR 4435, Jan. 22, 1979; 50 FR 8583, Mar. 4, 1985; 52 FR 19283, May 22, 1987; 54 FR 29330, July 12, 1989; 69103, Nov. 26, 2004; 80 FR 9866, Feb. 24, 2015] | (a) Application. The application will be in the form of a letter to the county supervisor with the following information included in or attached to the letter: (1) Name and address of applicant. (2) A copy of, or an accurate citation to, the specific provisions of State law under which the applicant is organized; a copy of the applicant's articles of incorporation, bylaws, and other authorizing documents; the names and addresses of the applicant's members, directors, and officers; and if another organization is a member of the applicant organization its name, address, and principal business. (3) A current, dated, and signed financial statement showing assets, and liabilities, together with information on the repayment schedule and status of each debt. (4) Evidence of inability to obtain credit from other sources. (5) General description of the project. (i) Location and size of tract or tracts to be bought and/or developed. (ii) Number and size of individual sites planned together with a detailed plot plan. (iii) Preliminary engineering plans, if available. (6) Estimated cost and amount of loan needed. (7) Explanation of applicant's financial contribution to the project. (8) A map showing the location of and other supporting information on neighborhood and existing facilities such as distance to shopping area, neighborhood churches, available transportation, drainage, sanitation facilities, water supply available or planned, and access to essential services such as doctors, dentists, and hospitals. (9) If facilities such as water and sewage systems, paved streets, and utilities are not currently available, information on when and how they will be provided. (10) Evidence of the need for the proposed sites in the locality by low- and moderate-income families and other qualified applicants that are likely to be able to obtain financing for a home. (11) Written evidence of any State, county, or local planning, zoning, or other ordinances imposing additional restrictions or requirements upon the propose… | |||
| 7:7:12.1.2.2.5.2.1.12 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.272 Approval or disapproval of a loan. | RHS | [69 FR 69103, Nov. 26, 2004] | The provisions of 7 CFR part 3560, subpart B will be followed. | |||
| 7:7:12.1.2.2.5.2.1.13 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.273 Actions subsequent to loan approval. | RHS | [69 FR 69103, Nov. 26, 2004] | After the loan is approved, actions to be taken will be in accordance with 7 CFR part 3560, subpart B. | |||
| 7:7:12.1.2.2.5.2.1.14 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.274 Loan closing. | RHS | [35 FR 16087, July 1, 1970, as amended at 42 FR 4408, Jan. 25, 1977; 50 FR 8584, Mar. 4, 1985; 56 FR 67472, Dec. 31, 1991; 69 FR 69104, Nov. 26, 2004; 80 FR 9866, Feb. 24, 2015] | (a) Applicable instructions. The complete loan docket will be sent to the OGC for loan closing instructions. RHS loans will be closed in accordance with applicable provisions of subpart B of part 1927 of this chapter, and State Instructions which supplement this Instruction, and closing instructions of the OGC, and with the assistance of the approved attorney, representatives of the title insurance company, or local attorney, whichever is appropriate. (b) Mortgage. Unless the OGC determines the Form to be inappropriate, real estate mortgage Form RD 3550-14, “Real Estate Mortgage or Deed of Trust for (state),” will be used for all RHS section 524 loans modified as prescribed by or with the advice of the OGC with respect to the name, address, and other identification of the borrower, the style of execution, and the acknowledgement. Additional paragraphs will be included in the mortgage to read as follows: The borrower agrees not to discriminate in the sale of the dwelling financed under this mortgage due to a prospective purchaser's race, color, national origin, sex, religion, age, marital status, or handicap. The borrower further agrees to comply with all Federal, State, or local laws and ordinances prohibiting discrimination in the sale of housing. The borrower's failure or refusal to comply with this agreement will be a basis for Rural Development to deny future requests for participation in its rural housing programs and activities. This instrument also secures the obligations and covenants of borrower set forth in Borrower's Loan Resolution of __________ (date), which is hereby incorporated herein by reference. The borrower agrees not to discriminate in the sale of the dwelling financed under this mortgage due to a prospective purchaser's race, color, national origin, sex, religion, age, marital status, or handicap. The borrower further agrees to comply with all Federal, State, or local laws and ordinances prohibiting discrimination in the sale of housing. The borrower's failure or refusal to comply… | |||
| 7:7:12.1.2.2.5.2.1.15 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.275 Actions after sites are developed. | RHS | [35 FR 16087, July 1, 1970, as amended at 51 FR 4135, Feb. 3, 1986; 67 FR 78326, Dec. 24, 2002; 80 FR 9866, Feb. 24, 2015] | The building sites will be sold on a nonprofit basis to eligible families or organizations as described in § 1822.266(c). (a) An option, RD 440-34, “Option to Purchase Real Property,” will be executed. The site will be clearly identified by a land survey. (b) The sale price of each individual site will not be more than a sufficient amount to pay a proportionate part of the RHS loan and any other actual costs of buying, developing, and selling the building site. (c) The proceeds from sale of the building sites will be applied on the RHS loan and any prior lien or, with the prior approval of the National Office, used in a manner consistent with the purpose of the loan and the security interest of the Government. The sites will be released from the mortgage in accordance with 7 CFR part 3550, subpart D or otherwise in accordance with prior approval of the National Office. | |||
| 7:7:12.1.2.2.5.2.1.16 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.276 Subsequent RHS loans. | RHS | A subsequent RHS loan is an RHS loan to an applicant indebted for an initial RHS loan. Subsequent RHS loans will be made on the same basis as initial RHS loans. | ||||
| 7:7:12.1.2.2.5.2.1.17 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.277 Complaints regarding discrimination in opportunity to buy developed sites. | RHS | [56 FR 67472, Dec. 31, 1991, as amended at 69 FR 69104, Nov. 26, 2004] | Any applicant wishing to purchase a site financed by an RHS loan who believes he or she has been discriminated against because of race, color, national origin, religion, sex, handicap, or age, may file a complaint with the County Supervisor or State Director. Any such complaint will be handled in accordance with 7 CFR 3560.2. | |||
| 7:7:12.1.2.2.5.2.1.18 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.278 Special requirements for RHS section 523 loans (loans to organizations providing sites for self-help housing). | RHS | [35 FR 16087, July 1, 1970, as amended at 42 FR 4408, Jan. 25, 1977; 50 FR 8584, Mar. 4, 1985; 56 FR 67472, Dec. 31, 1991; 69 FR 69104, Nov. 26, 2004; 80 FR 9866, Feb. 24, 2015] | Loans to organizations which will provide sites for self-help housing (RHS sec. 523 loans) will be made under the provisions of this subpart with the following exceptions: (a) Eligibility. The applicant must be a nonprofit organization engaged in assisting self-help projects. (b) Interest. The interest rate will be 3 percent per annum on the unpaid principal balance. (c) Source of funds. These will be direct loans made from the self-help fund. (d) Evidence of need. Loans to newly formed organizations will be made on the basis of the applicant's providing firm information as to the number of sites to be developed and the names of eligible bona fide prospective purchasers who are assured of available home financing. Loans to organizations currently involved in mutual self-help housing projects may be made without submitting a list of the names of prospective site purchasers. There must, however, be definite evidence that enough families are available who are eligible and who will buy the sites when they are developed. (e) Multiple advances. These loans may be disbursed over a period not to exceed 18 months from the date of the first advance. (f) Note forms. Form RD 3560-52, “Multiple Family Housing Promissory Note,” will be used. See § 1822.274 (c). (g) Mortgage. Unless the OGC determines the Form to be inappropriate, real estate mortgage Form RD 3550-14, “Real Estate Mortgage or Deed of Trust for (state),” will be used modified as prescribed by or with the advice of the OGC with respect to the name, address, and other identification of the borrower, the style of execution, and the acknowledgement. Additional paragraphs will be included in the mortgage to read as follows: The borrower agrees not to discriminate in the sale of the dwelling financed under this mortgage due to a prospective purchaser's race, color, national origin, sex, religion, age, marital status, or handicap. The borrower further agrees to comply with all Federal, State, or local laws and ordinances prohibiting discrimination… | |||
| 7:7:12.1.2.2.5.2.1.19 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.279 Loan supervision and servicing. | RHS | [69 FR 69104, Nov. 26, 2004] | Loan supervision and loan servicing will be provided according to 7 CFR part 3560. | |||
| 7:7:12.1.2.2.5.2.1.2 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.262 Objective. | RHS | The basic objective of RHS loans is to assist public or private nonprofit organizations interested in providing sites for housing, to acquire and develop land in rural areas. This land will be subdivided into adequate building sites and sold on a nonprofit basis to (a) families eligible for low and moderate income section 502 Rural Housing (RH) loans, including self-help housing; (b) cooperative Rural Cooperative Housing (RCH) applicants and broadly based nonprofit Rural Rental Housing (RRH) applicants; and (c) applicants eligible for Housing and Urban Development (HUD) sections 235 and 236 insured mortgages. | ||||
| 7:7:12.1.2.2.5.2.1.3 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.263 Definitions. | RHS | [35 FR 10687, July 1, 1970, as amended at 40 FR 52837, Nov. 13, 1975; 46 FR 61989, Dec. 21, 1981; 67 FR 78326, Dec. 24, 2003] | As used in this subpart: (a) A private nonprofit organization is a corporation which: is owned and controlled by private persons; is organized and operated for purposes other than making gains or profits for the corporation or members; and, is legally precluded from distributing to its members any gains or profits. (b) A public nonprofit organization is a nonprofit corporation other than a private nonprofit corporation, including a municipal corporation or other corporate agency of a State or local government. (c) Rural area is open country or rural places as defined in 7 CFR part 3550, subpart A. (d) Development cost means the cost of purchasing and developing the sites including engineering and legal fees, streets, roads, utilities, minimum essential administrative costs, necessary equipment and estimated interest which the borrower cannot pay from other sources. (e) RHS section 523 loan means a loan to an organization which will provide sites for housing to be built by the self-help method. (f) RHS section 524 loan means a loan to an organization which will provide sites for housing to be built with no limitation as to the method of construction that will be used. (g) OGC means the Office of the General Counsel, including the regional attorney or attorney in charge serving the State in which the RHS project is located. | |||
| 7:7:12.1.2.2.5.2.1.4 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.264 Eligibility requirements. | RHS | [35 FR 16087, July 1, 1970, as amended at 80 FR 9866, Feb. 24, 2015] | (a) Eligibility of applicant. To be eligible for an RHS loan, the applicant must be a private or public nonprofit organization as defined in § 1822.263 (a) or (b) which is authorized to provide housing sites on a nonprofit basis. (1) If it is a private nonprofit organization as defined in § 1822.263(a), it should also: (i) Have a membership of at least 10 community leaders. (ii) Plan to adopt, if it is being newly organized, articles of incorporation and bylaws that generally conform to model articles and bylaws provided by the State director which will be consistent with State law and with changes appropriate to the purposes and powers of an eligible applicant under this subpart. (2) [Reserved] (b) Authorized representative of applicant. RHS will deal only with the applicant or bona fide representative or the applicant or the representative's technical advisors. An authorized representative of the applicant must have no pecuniary interest in the award of the engineering, architectural or construction contracts, necessary equipment, or the purchase or development of the land. | |||
| 7:7:12.1.2.2.5.2.1.5 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.265 Loan purposes. | RHS | [35 FR 16087, July 1, 1970, as amended at 43 FR 24264, June 5, 1978; 80 FR 9866, Feb. 24, 2015] | RHS loans may be made to qualified applicants: (a) For the purchase and development of adequate sites, including the construction of essential access roads, streets, utility lines, and necessary equipment which will become a permanent part of the development. If public water and waste disposal facilities are not available and cannot reasonably be provided on a community basis with other financing, including Water and Waste Disposal Association loans, funds may be included for this purpose. (b) For the payment of necessary engineering fees, legal fees, and closing costs. (c) For the payment of actual cash cost of incidental administrative expenses such as postage, telephone, advertising, and temporary secretarial help, if funds to pay these expenses are not otherwise available. The estimated cost of these items should be identified and shown in the budget. (d) To provide for needed landscaping, planting, seeding, or sodding, or other necessary facilities related to buildings such as walks, parking areas, and driveways. (e) When legally required by proper local, county, and State Governmental bodies as a condition for subdivision approval, RHS loan funds may be used to provide common areas playgrounds and tot lots, provided such facilities are dedicated to, and maintained by, a public body. | |||
| 7:7:12.1.2.2.5.2.1.6 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.266 Limitations. | RHS | [35 FR 10687, July 1, 1970, as amended at 40 FR 6951, Feb. 18, 1975; 80 FR 9866, Feb. 24, 2015] | (a) Loan limits. No RHS loan(s) will be made to any applicant which will result in the applicant's owning an unpaid principal balance of more than $100,000 on such loan(s) unless prior authorization for a larger loan is obtained from the national office. No such loan will exceed the development cost as defined in § 1822.263(d), or the value of the property as improved with the loan. These limitations also apply to cases in which the same persons hold a majority of the membership interests or constitute a majority of the directors of two or more applicants. (b) Limitations of use of loan funds. Loans will not be made for: (1) The purchase of land in excess of the immediate and identified needs in the locality. (2) The purchase of land from a member of an applicant-organization, or from another organization in which any member of the applicant-organization has an interest, without prior consent of the national office. (3) Refinancing of debts, except in accordance with paragraph (e) of this section. (4) Payment of any fee, charge, or commission to any broker, negotiator, or other person for the referral of a prospective applicant or solicitation of a loan. (5) Payment of any fee, salary, commission, profit, or compensation to an applicant, or to any officer, director, trustee, stockholder, member or agent of an applicant, except as provided in § 1822.265(b). No contract or agreement for services to be paid for with loan funds should be executed by the applicant without prior approval by the State director. (c) Sale of developed sites. The sites developed with a section 524 loan must be for housing low- and moderate-income families and may be sold to families, nonprofit organizations, public agencies, and cooperatives eligible for assistance under any section of title V of the Housing Act of 1949, or under any other law which provides financial assistance. For example, this may include: (1) Individuals with low and moderate incomes eligible for HUD mortgages. (2) Individuals with low and moderate inco… | |||
| 7:7:12.1.2.2.5.2.1.7 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.267 Special conditions. | RHS | [35 FR 16087, July 1, 1970, as amended at 41 FR 47460, Oct. 29, 1976; 42 FR 44669, Sept. 6, 1977; 43 FR 24264, June 5, 1978; 44 FR 1702, Jan. 8, 1979; 45 FR 39793, June 12, 1980; 46 FR 36106, July 14, 1981; 46 FR 61989, Dec. 21, 1981; 52 FR 8002, Mar. 13, 1987; 52 FR 19283, May 22, 1987; 67 FR 78326, Dec. 24, 2002; 80 FR 9866, Feb. 24, 2015] | (a) Evidence of need. Loans will be made on the basis of the applicant providing firm information as to the number of sites to be developed and evidence of a need for the proposed building sites in the locality. (b) Nondiscrimination. The borrower will be required to agree not to discriminate or permit discrimination, in accordance with section 3 of the loan resolution form “(‘Rural Housing Site’ Loan to Nonprofit Corporation),” available at all RD offices. (c) Supervisory assistance. Supervision will be provided borrowers to the extent necessary to achieve the objectives of the loan and to protect the interests of the Government. County supervisors will counsel with applicants in selecting locations that will provide essential services and facilities and will result in the development of desirable residential communities. (d) Loan resolution. A Loan Resolution will be adopted by the applicant's Board of Directors or similar governing body. If any provisions are not appropriate to a particular case, proposed substitute language should be submitted to the national office with the recommendations of the State director. (e) Development policies. Development will be planned and performed in accordance with subparts A and C of part 1924 of this chapter. (f) Water and waste disposal facilities. If public water and waste disposal facilities are not available and these facilities will be provided on a community basis with funds included in the RHS loan or with other financing, provision should be made to form an organization with members who will provide continuing maintenance and management of facilities. The cost of the facilities should be considered as a cost of developing the sites and included in the price charged for the lots when they are sold. (g) Compliance with local codes and regulations. Planning and development of sites will comply with all State, county, and local planning and zoning requirements, and will be for housing that will conform with any applicable laws, ordinances, codes, and… | |||
| 7:7:12.1.2.2.5.2.1.8 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.268 Rates, terms, and source of funds. | RHS | [35 FR 10687, July 1, 1970, as amended at 51 FR 6733, Feb. 26, 1986; 80 FR 9866, Feb. 24, 2015] | (a) Interest rate. Upon request of the applicant, the interest rate charged by Rural Development will be the lower of the interest rates in effect at the time of loan approval or loan closing. If an applicant does not indicate a choice, the loan will be closed at the interest rate in effect at the time of loan approval. Interest rates are specified in exhibit B of RD Instruction 440.1 (available in any RD office) for the type assistance involved. (b) Repayment period. Final payment will be due 2 years after the date of the loan. When necessary to carry out the loan purposes, the national office may authorize extension of maturity dates. As lots are sold before the final due date of the note, the proceeds of the sales will be applied on the account or any prior lien, or, with the prior approval of the national office, used in a manner consistent with the purposes of the loan and the security interest of the Government. (c) Source of funds. Loans under this subpart will be made as insured loans, except that loans under § 1822.278 to develop building sites for sale in connection with self-help projects will be made as direct loans. | |||
| 7:7:12.1.2.2.5.2.1.9 | 7 | Agriculture | XVIII | B | 1822 | PART 1822—RURAL HOUSING LOANS AND GRANTS | G | Subpart G—Rural Housing Site Loan Policies, Procedures, and Authorizations | § 1822.269 Security. | RHS | Each loan will be secured by a mortgage on the property purchased or improved with the loan, and a security interest in the funds held by the corporation in trust for the Government, in accordance with the provisions of the required Loan Resolution. |
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);