documents

Regulatory documents from Regulations.gov including rules, proposed rules, notices, and supporting materials.

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

75 rows where docket_id = "FDA-2016-N-3818" and posted_year = 2019 sorted by posted_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: subtype, posted_date, posted_month, comment_start_date, withdrawn, posted_date (date), comment_start_date (date), comment_end_date (date), last_modified (date)

posted_year 1

  • 2019 · 75 ✖

agency_id 1

id agency_id docket_id title document_type subtype posted_date ▲ posted_year posted_month comment_start_date comment_end_date last_modified fr_doc_num open_for_comment withdrawn object_id
FDA-2016-N-3818-0087 FDA None FDA-2016-N-3818 TAB A 2013-288 SE PRIA as Submitted to OMB re Memorandum to FDA DMS on SE NPRM Supporting & Related Material Background Material 2019-06-28T04:00:00Z 2019 6     2019-06-28T12:31:57Z   0 0 0900006483d4b1f3
FDA-2016-N-3818-0086 FDA None FDA-2016-N-3818 TAB A 2013-288 SE NPRM as Submitted to OMB re Memorandum to FDA DMS on SE NPRM Supporting & Related Material Background Material 2019-06-28T04:00:00Z 2019 6     2019-06-28T12:31:44Z   0 0 0900006483d4b1f2
FDA-2016-N-3818-0089 FDA None FDA-2016-N-3818 TAB B 2013-288 SE PRIA Track Changes re Memorandum to FDA DMS on SE NPRM Supporting & Related Material Background Material 2019-06-28T04:00:00Z 2019 6     2019-06-28T12:32:23Z   0 0 0900006483d4b1f5
FDA-2016-N-3818-0091 FDA None FDA-2016-N-3818 TAB C 2013-288 SE PRIA as Cleared by OMB re Memorandum to FDA DMS on SE NPRM Supporting & Related Material Background Material 2019-06-28T04:00:00Z 2019 6     2019-06-28T12:32:50Z   0 0 0900006483d4b212
FDA-2016-N-3818-0085 FDA None FDA-2016-N-3818 Memorandum to FDA DMS on SE NPRM Other Memorandum 2019-06-28T04:00:00Z 2019 6 2019-06-28T04:00:00Z   2019-06-28T12:19:52Z   0 0 0900006483d4b1f0
FDA-2016-N-3818-0090 FDA None FDA-2016-N-3818 TAB C 2013-288 SE NPRM as Cleared by OMB re Memorandum to FDA DMS on SE NPRM Supporting & Related Material Background Material 2019-06-28T04:00:00Z 2019 6     2019-06-28T12:32:36Z   0 0 0900006483d4b1f6
FDA-2016-N-3818-0088 FDA None FDA-2016-N-3818 TAB B 2013-288 SE NPRM Track Changes re Memorandum to FDA DMS on SE NPRM Supporting & Related Material Background Material 2019-06-28T04:00:00Z 2019 6     2019-06-28T12:32:10Z   0 0 0900006483d4b1f4
FDA-2016-N-3818-0068 FDA None FDA-2016-N-3818 Content and Format of Substantial Equivalence Reports; Food and Drug Administration Actions on Substantial Equivalence Reports; Extension of Comment Period Proposed Rule Extension of Comment Period 2019-06-13T04:00:00Z 2019 6 2019-06-13T04:00:00Z 2019-07-18T03:59:59Z 2019-06-13T21:14:01Z 2019-12478 0 0 0900006483d0d911
FDA-2016-N-3818-0063 FDA None FDA-2016-N-3818 Request for Extension from Pipe Tobacco Council Other Request for Extension 2019-06-04T04:00:00Z 2019 6 2019-06-04T04:00:00Z   2019-06-04T16:02:50Z   0 0 0900006483c5372c
FDA-2016-N-3818-0065 FDA None FDA-2016-N-3818 Request for Extension from Swedish Match North America LLC Other Request for Extension 2019-06-04T04:00:00Z 2019 6 2019-06-04T04:00:00Z   2019-06-04T16:10:18Z   0 0 0900006483cb009c
FDA-2016-N-3818-0064 FDA None FDA-2016-N-3818 Request for Extension from Coalition of Independent Tobacco Manufacturers of America (CITMA) Other Request for Extension 2019-06-04T04:00:00Z 2019 6 2019-06-04T04:00:00Z   2019-06-04T16:05:23Z   0 0 0900006483ca162a
FDA-2016-N-3818-0066 FDA None FDA-2016-N-3818 Request for Extension from Cigar Rights of America Other Request for Extension 2019-06-04T04:00:00Z 2019 6 2019-06-04T04:00:00Z   2019-06-04T16:12:21Z   0 0 0900006483cdbfbc
FDA-2016-N-3818-0067 FDA None FDA-2016-N-3818 Request for Extension from ITG Brands, LLC Other Request for Extension 2019-06-04T04:00:00Z 2019 6 2019-06-04T04:00:00Z   2019-06-04T16:13:55Z   0 0 0900006483cde0fe
FDA-2016-N-3818-0062 FDA None FDA-2016-N-3818 Request for Extension from Cigar Association of America, Inc. Other Request for Extension 2019-06-04T04:00:00Z 2019 6 2019-06-04T04:00:00Z   2019-06-04T16:01:22Z   0 0 0900006483c53a00
FDA-2016-N-3818-0061 FDA None FDA-2016-N-3818 Transcript_All Tribes Call SE Proposed Rule 4-11-19 Other Transcript(s) 2019-04-17T04:00:00Z 2019 4 2019-04-17T04:00:00Z   2019-04-17T16:33:16Z   0 0 0900006483bb4c61
FDA-2016-N-3818-0060 FDA None FDA-2016-N-3818 55 Reference 54 SE PRIA_508c Supporting & Related Material Background Material 2019-04-11T04:00:00Z 2019 4     2019-04-11T17:25:28Z   0 0 0900006483b85ab7
FDA-2016-N-3818-0025 FDA None FDA-2016-N-3818 30 Reference 29 Design, Evaluation and Pharmacokinetic Study of Mucoadhesive Buccal Tablets, Lewis, 2006 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:14Z   0 0 0900006483b57c4b
FDA-2016-N-3818-0021 FDA None FDA-2016-N-3818 34 Reference 33 Determination of 14 Polycyclic Aromatic Hydrocarbons in Mainstream Smoke from Domestic Cigarettes, Ding, 2005 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:10Z   0 0 0900006483b57c4f
FDA-2016-N-3818-0040 FDA None FDA-2016-N-3818 42 Reference 41 The Pyrolysis of Non-Volatile Tobacco Ingredients Using a System that Simulate Cigarette Combustion, Baker, 2005 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:34Z   0 0 0900006483b57c8b
FDA-2016-N-3818-0033 FDA None FDA-2016-N-3818 23 Reference 22 The Role of Filter Technology in Reduced Yield Cigarettes, Taylor, 2004 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:21Z   0 0 0900006483b57c2a
FDA-2016-N-3818-0028 FDA None FDA-2016-N-3818 27 Reference 26 Effects of Product Format on Nicotine and TSNA Extraction from Snus Pouches, Gale, 2013 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:16Z   0 0 0900006483b57c48
FDA-2016-N-3818-0020 FDA None FDA-2016-N-3818 35 Reference 34 Levels of Tobacco-Specific Nitrosamines and Polycyclic Aromatic Hydrocarbons in Mainstream Smoke, Ding, 2008 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:10Z   0 0 0900006483b57c50
FDA-2016-N-3818-0019 FDA None FDA-2016-N-3818 36 Reference 35 The Generation of Formaldehyde in Cigarettes, Baker, 2006 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:09Z   0 0 0900006483b57c51
FDA-2016-N-3818-0016 FDA None FDA-2016-N-3818 05 Reference 4 DRAFT FDA-3964 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:06Z   0 0 0900006483b57be6
FDA-2016-N-3818-0029 FDA None FDA-2016-N-3818 26 Reference 25 Kinetic Modeling on Drug Release from Controlled Drug Delivery Systems, Dash, 2010 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:17Z   0 0 0900006483b5781c
FDA-2016-N-3818-0001 FDA None FDA-2016-N-3818 Content and Format of Substantial Equivalence Reports; Food and Drug Administration Actions on Substantial Equivalence Reports Proposed Rule Notice of Proposed Rulemaking (NPRM) 2019-04-02T04:00:00Z 2019 4 2019-04-02T04:00:00Z 2019-07-18T03:59:59Z 2019-07-19T01:00:36Z 2019-05787 0 0 0900006483b571a6
FDA-2016-N-3818-0006 FDA None FDA-2016-N-3818 15 Reference 14 The Generation of Water in the Tobacco Oven Volatile Test, Bourlas, 1980 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:07:57Z   0 0 0900006483b57c07
FDA-2016-N-3818-0058 FDA None FDA-2016-N-3818 02 Reference 1 Application, function, and effects of menthol in cigarettes a survey of tobacco industry documents, Wayne, 2004 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:09:42Z   0 0 0900006483b57be0
FDA-2016-N-3818-0056 FDA None FDA-2016-N-3818 04 Reference 3 DRAFT FDA-3965 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:09:40Z   0 0 0900006483b57be5
FDA-2016-N-3818-0027 FDA None FDA-2016-N-3818 28 Reference 27 Increased Pouch Sizes and Resulting Changes in the Amounts of Nicotine 2012 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:15Z   0 0 0900006483b57c49
FDA-2016-N-3818-0044 FDA None FDA-2016-N-3818 46 Reference 45 Control and use of Microbes in Tobacco Product Manufacturing, Geiss, 1989 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:37Z   0 0 0900006483b57c91
FDA-2016-N-3818-0054 FDA None FDA-2016-N-3818 56 PRIA Ref 1 Memo_SEApril5 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:45Z   0 0 0900006483b57ccd
FDA-2016-N-3818-0010 FDA None FDA-2016-N-3818 11 Reference 10 Study on Tobacco Components Involved in Pyrolytic Generation of Selected Smoke Constituents, Torikaiu, 2005 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:01Z   0 0 0900006483b57bfa
FDA-2016-N-3818-0024 FDA None FDA-2016-N-3818 31 Reference 30 The Changing Cigarette Chemical Studies and Bioassays, Hoffman, 2001 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:13Z   0 0 0900006483b57c4c
FDA-2016-N-3818-0023 FDA None FDA-2016-N-3818 32 Reference 31 Cigarette Yields and Human Exposure A Comparison of Alternative Testing Regimens, Hammond, 2006 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:12Z   0 0 0900006483b57c4d
FDA-2016-N-3818-0038 FDA None FDA-2016-N-3818 40 Reference 39 Additives in Tobacco Products, Contribution of Carob Bean Extract, Cellulose Fibre, DKFZ, 2012 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:32Z   0 0 0900006483b57880
FDA-2016-N-3818-0057 FDA None FDA-2016-N-3818 03 Reference 2 NNitrosomorpholine and Other Volatile Nnitrosamines in Snuff Tobacco, Brunnemann, 1982 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:09:41Z   0 0 0900006483b57be1
FDA-2016-N-3818-0034 FDA None FDA-2016-N-3818 22 Reference 21 The Scientific Basis of Tobacco Product Regulation, WHO, 2008 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:22Z   0 0 0900006483b57c29
FDA-2016-N-3818-0043 FDA None FDA-2016-N-3818 45 Reference 44 Project Clover Marlboro Roll Your Own Report on the Microbial Analysis, Schulthess, 1984 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:36Z   0 0 0900006483b57c8f
FDA-2016-N-3818-0049 FDA None FDA-2016-N-3818 51 Reference 50 Swedish Snus and the Gothiatek Standard, Rutqvist, 2011 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:42Z   0 0 0900006483b57ca6
FDA-2016-N-3818-0026 FDA None FDA-2016-N-3818 29 Reference 28 Oral Mucosal Drug Delivery Clinical Pharmacokinetics, Zhang 2002 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:14Z   0 0 0900006483b57c4a
FDA-2016-N-3818-0041 FDA None FDA-2016-N-3818 43 Reference 42 A Literature Review of Aging and Fermentation of Tobacco, Smith, 1964 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:35Z   0 0 0900006483b57c8d
FDA-2016-N-3818-0045 FDA None FDA-2016-N-3818 47 Reference 46 pH Changes in Smokeless Tobaccos Undergoing Nitrosation During Prolonged Storage, Andersen, 1993 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:38Z   0 0 0900006483b57ca0
FDA-2016-N-3818-0015 FDA None FDA-2016-N-3818 06 Reference 5 Cigarette Rod Length and Its Impact on Serum Cotinine and Urinary Total NNAL Levels, NHANES 2007 2010, Agaku, 2014 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:06Z   0 0 0900006483b57be7
FDA-2016-N-3818-0013 FDA None FDA-2016-N-3818 08 Reference 7 Trends in Nicotine Yield in Smoke 2007 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:04Z   0 0 0900006483b57be9
FDA-2016-N-3818-0008 FDA None FDA-2016-N-3818 13 Reference 12 Tobacco, Cigarettes and Cigarette Smoke An Overview, Geiss, 2007 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:07:59Z   0 0 0900006483b57bfc
FDA-2016-N-3818-0042 FDA None FDA-2016-N-3818 44 Reference 43 Influence of Microorganisms-Fermentation- on the Chemistry of Tobacco, Cornell, 1979 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:36Z   0 0 0900006483b57c8e
FDA-2016-N-3818-0052 FDA None FDA-2016-N-3818 54 Reference 53 Effects of Storage Conditions on Levels of Tobacco Specific N Nitrosamines, Djordjevic, 1993 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:44Z   0 0 0900006483b57cc1
FDA-2016-N-3818-0004 FDA None FDA-2016-N-3818 17 Reference 16 Effect of Cigarette Paper on Smoke Yield and Composition, Owens, 1978 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:07:56Z   0 0 0900006483b57c0f
FDA-2016-N-3818-0050 FDA None FDA-2016-N-3818 52 Reference 51 Formation and Analysis of Tobacco specific N nitrosamines, Brunnemann, 1996 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:42Z   0 0 0900006483b57cbf
FDA-2016-N-3818-0055 FDA None FDA-2016-N-3818 57 PRIA Ref 2 BLS OES wages Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:46Z   0 0 0900006483b57cce
FDA-2016-N-3818-0014 FDA None FDA-2016-N-3818 07 Reference 6 Dynamic Behavior and Filtration of Mainstream Smoke in the Tobacco Column and Filter, Eaker, 1990 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:05Z   0 0 0900006483b57be8
FDA-2016-N-3818-0012 FDA None FDA-2016-N-3818 09 Reference 8 Cigarette Pressure Drop Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:03Z   0 0 0900006483b57bea
FDA-2016-N-3818-0011 FDA None FDA-2016-N-3818 10 Reference 9 The Health Consequences of Smoking The Changing Cigarette, 1981, Report of the Surgeon General Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:02Z   0 0 0900006483b57bf4
FDA-2016-N-3818-0009 FDA None FDA-2016-N-3818 12 Reference 11 Effect of Manufacturing Variables on Cigarette Smoke Composition, Spears, 1974 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:00Z   0 0 0900006483b57bfb
FDA-2016-N-3818-0018 FDA None FDA-2016-N-3818 37 Reference 36 Preventing Tobacco Use Among Young People, Report of the Surgeon General, 1994 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:08Z   0 0 0900006483b57846
FDA-2016-N-3818-0022 FDA None FDA-2016-N-3818 33 Reference 32 Physical Design Analysis and Mainstream Smoke Constituent Yields 2007 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:11Z   0 0 0900006483b57c4e
FDA-2016-N-3818-0059 FDA None FDA-2016-N-3818 01 List of References Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:09:43Z   0 0 0900006483b57bdf
FDA-2016-N-3818-0005 FDA None FDA-2016-N-3818 16 Reference 15 Tobacco Volatiles Gas Chromatography, Coleman, 2000 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:07:57Z   0 0 0900006483b57c08
FDA-2016-N-3818-0003 FDA None FDA-2016-N-3818 18 Reference 17 Lower Ignition Propensity, British American Tobacco Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:07:55Z   0 0 0900006483b57c10
FDA-2016-N-3818-0047 FDA None FDA-2016-N-3818 49 Reference 48 Reduction of the Water Activity of Wet Snuff 259, St Charles, 1989 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:40Z   0 0 0900006483b57ca3
FDA-2016-N-3818-0017 FDA None FDA-2016-N-3818 38 Reference 37 How Tobacco Smoke Causes Disease-The Biology and Behavioral Basis, Report of the Surgeon General, 2010 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:07Z   0 0 0900006483b5787e
FDA-2016-N-3818-0007 FDA None FDA-2016-N-3818 14 Reference 13 Role of Cigarette Physical Characteristics on Smoke Composition, DeBardeleben, 1978 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:07:58Z   0 0 0900006483b57bfd
FDA-2016-N-3818-0002 FDA None FDA-2016-N-3818 19 Reference 18 Influence of Filter Ventilation on the Chemical Composition of Cigarette Mainstream Smoke, Adam, 2010 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:07:53Z   0 0 0900006483b57c22
FDA-2016-N-3818-0036 FDA None FDA-2016-N-3818 20 Reference 19 Secret Science Tobacco Industry Research on Smoking Behavior, Hammond, 2006 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:24Z   0 0 0900006483b57c23
FDA-2016-N-3818-0046 FDA None FDA-2016-N-3818 48 Reference 47 The water content water activity relationship Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:39Z   0 0 0900006483b57ca1
FDA-2016-N-3818-0051 FDA None FDA-2016-N-3818 53 Reference 52 Sources of and Technical Approaches for the Abatement of Tobacco Specific Nitorsamine Formation, Fisher, 2012 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:43Z   0 0 0900006483b57cc0
FDA-2016-N-3818-0032 FDA None FDA-2016-N-3818 58 PRIA Ref 3 SBA_Size_Standards_Table Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:19Z   0 0 0900006483b57cd0
FDA-2016-N-3818-0035 FDA None FDA-2016-N-3818 21 Reference 20 The Design of Cigarettes, Browne, 1990 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:23Z   0 0 0900006483b57c24
FDA-2016-N-3818-0031 FDA None FDA-2016-N-3818 24 Reference 23 Basic Principles of Cigarette Design and Function, Podraza, 2001 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:18Z   0 0 0900006483b57c2b
FDA-2016-N-3818-0048 FDA None FDA-2016-N-3818 50 Reference 49 Effect of Storage Conditions on Nitrosated, Acylated, and Oxidized Pyridine Alkaloid Derivatives, Andersen, 1989 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:41Z   0 0 0900006483b57ca4
FDA-2016-N-3818-0037 FDA None FDA-2016-N-3818 39 Reference 38 Smokeless Tobacco and Public Health-A Global Perspective, NCI, 2014 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:32Z   0 0 0900006483b5787f
FDA-2016-N-3818-0039 FDA None FDA-2016-N-3818 41 Reference 40 Pyrolysis GC MS Analysis of Guar Gum and Hydroxypropyl Guar at 300 Degrees C and 600 Degrees C, Naworal, 1990 Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:33Z   0 0 0900006483b57881
FDA-2016-N-3818-0030 FDA None FDA-2016-N-3818 25 Reference 24 How Do Different Cigarette Design Features Influence the Standard Tar Yields Supporting & Related Material Background Material 2019-04-02T04:00:00Z 2019 4     2019-04-02T15:08:17Z   0 0 0900006483b5781b
FDA-2016-N-3818-0053 FDA None FDA-2016-N-3818 55 Reference 54 PRIA Supporting & Related Material   2019-04-02T00:00:00Z 2019 4     2019-04-11T17:23:11Z   0 1 0900006483b57cc2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE documents (
    id TEXT PRIMARY KEY,
    agency_id TEXT,
    docket_id TEXT REFERENCES dockets(id),
    title TEXT,
    document_type TEXT,
    subtype TEXT,
    posted_date TEXT,
    posted_year INTEGER,
    posted_month INTEGER,
    comment_start_date TEXT,
    comment_end_date TEXT,
    last_modified TEXT,
    fr_doc_num TEXT,
    open_for_comment INTEGER,
    withdrawn INTEGER,
    object_id TEXT
);
CREATE INDEX idx_docs_agency ON documents(agency_id);
CREATE INDEX idx_docs_docket ON documents(docket_id);
CREATE INDEX idx_docs_date ON documents(posted_date);
CREATE INDEX idx_docs_year ON documents(posted_year);
CREATE INDEX idx_docs_type ON documents(document_type);
CREATE INDEX idx_docs_frnum ON documents(fr_doc_num);
CREATE INDEX idx_docs_comment_end ON documents(comment_end_date) WHERE comment_end_date IS NOT NULL AND withdrawn = 0;