openregs: cfr_sections: 3 rows where part_number = 2014 sorted by section

Current Code of Federal Regulations (eCFR) — the actual text of federal regulations in force. Covers 19 CFR titles with 123,000+ regulatory sections and full-text search.

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

3 rows where part_number = 2014 sorted by section_id

descending

✎ View and edit SQL

This data as json, CSV (advanced)

section_id ▼	title_number	title_name	chapter	part_number	part_name	section_heading	agency	full_text
15:15:4.2.1.9.12.0.43.1	15	Commerce and Foreign Trade	XX	2014	PART 2014—IMPLEMENTATION OF TARIFF-RATE QUOTA FOR IMPORTS OF LAMB MEAT	§ 2014.1 Purpose.	NIST	The purpose of this part is to provide for the implementation of the tariff-rate quota for imports of lamb meat established in Proclamation 7208 (64 FR 37387) (July 9, 1999) and modified in Proclamation 7214 (64 FR 42265) (Aug. 4, 1999). In particular, this part provides for the administration of export certificates where a country that has an allocation of the in-quota quantity under the tariff-rate quota has chosen to use export certificates.
15:15:4.2.1.9.12.0.43.2	15	Commerce and Foreign Trade	XX	2014	PART 2014—IMPLEMENTATION OF TARIFF-RATE QUOTA FOR IMPORTS OF LAMB MEAT	§ 2014.2 Definitions.	NIST	Unless the context otherwise requires, for the purpose of this part, the following terms shall have the meanings assigned as follows: (a) Lamb meat means fresh, chilled, or frozen lamb meat, provided for in subheadings 0204.10.00, 0204.22.20, 0204.23.20, 0204.30.00, 0204.42.20, and 0204.43.20 of the HTS. (b) In-quota lamb meat means lamb meat that is entered under the in-quota rate of duty. (c) Participating country means any country to which an allocation of a particular quantity of lamb meat has been assigned under Proclamation 7208 that USTR has determined is, and has notified to the United States Customs Service as being, eligible to use export certificates. (d) Enter or Entered means to enter or withdraw from warehouse for consumption. (e) HTS means the Harmonized Tariff schedule of the United States. (f) USTR means the United States Trade Representative or the designee of the United States Trade Representative. (g) Quota Year means the period between July 22, 1999 and July 21, 2000, inclusive, and such subsequent periods as set forth in Presidential Proclamations 7208 and 7214 during which lamb meat is exported.
15:15:4.2.1.9.12.0.43.3	15	Commerce and Foreign Trade	XX	2014	PART 2014—IMPLEMENTATION OF TARIFF-RATE QUOTA FOR IMPORTS OF LAMB MEAT	§ 2014.3 Export certificates.	NIST	(a) In-quota lamb meat may only be entered as a product of a participating country if the United States importer makes a declaration to the United States Customs Service, in the form and manner determined by the United States Customs Service, that a valid export certificate is in effect with respect to that lamb meat product. (b) To be valid, an export certificate shall: (1) Be issued by or under the supervision of the government of the participating country; (2) Specify the name of the exporter, the product description and quantity, and the quota year for which the export certificate is in effect; (3) Be distinct and uniquely identifiable; and (4) Be used for the quota year for which it is in effect.

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);