Tables of data 11 Graphs of data 25 News posts 8 Tag Browser 4 Category List 4 About the project Key to abbreviations Bibliography Analyzed prime gaps
Prime gap list project

Data format conversion

Convert prime gap record data in Nicely or CSV format to SQL

In-browser conversion of CSV- or Nicely-formatted prime gap data

Javascript-implemented, in-browser conversion of record prime gap data formatted either in Dr. Thomas R. Nicely or CSV format, rendered as SQL statements compatible with the current data representation scheme

Convert CSV format to SQL
Examples of prime gap record data using comma-separated value (CSV) format

Example prime gap record data in CSV format with fields conforming to the current data representation scheme.

Faked example data for testing
1. No change, all gaps known and no bettered merits
136098,0,C,?,P,Toni_Key,2016,16.37,3610,1500031*8431#/41910 - 97126
136100,0,C,?,P,Toni_Key,2016,15.39,3842,10000091*8963#/2221230 - 115554
136104,0,C,?,P,Jacobsen,2017,16.61,3560,5105*8297#/30 - 61266
2. All gaps known but one with bettered merit
136098,0,C,?,P,Toni_Key,2016,16.37,3610,1500031*8431#/41910 - 97126
136100,0,C,?,P,Toni_Key,2016,15.39,3842,10000091*8963#/2221230 - 115554
136104,0,C,?,P,Jacobsen,2017,17.61,3560,5105*8297#/30 - 61266
3. New gap found, otherwise no bettered merits
136100,0,C,?,P,Toni_Key,2016,15.39,3842,10000091*8963#/2221230 - 115554
136102,0,C,?,P,Jacobsen,2019,17.61,3560,5105*8324#/30 - 60965
136104,0,C,?,P,Jacobsen,2017,16.61,3560,5105*8297#/30 - 61266
4. New gap found, also one with bettered merit
136100,0,C,?,P,Toni_Key,2016,15.39,3842,10000091*8963#/2221230 - 115554
136102,0,C,?,P,Jacobsen,2019,17.61,3560,5105*8324#/30 - 60965
136104,0,C,?,P,Jacobsen,2017,18.61,3560,5105*8297#/30 - 61266
Convert Nicely format to SQL
Examples of prime gap record data using Dr. Thomas R. Nicely’s spatial format

Example prime gap record data formatted as published by Dr. Thomas R. Nicely ( and ¹) mandatory spaces are rendered as “·”, note the difference in formatting when the gap size overflows the 6 digits initially allocated.

···916*·CFC·TRNicely·1998··26.39····16··1189459969825483
··1474··C?C·Spielaur·2014··25.93····25··4911005025345628280826739
··1476*·CFC·TOeSilva·2009··35.31····19··1425172824437699411
··8756··C?C·Jacobsen·2016··25.78···148··344995157*349#/30 - 5862
·51026··C?P·Jacobsen·2015··15.63··1419··988571*3331#/30 - 30776
·51028··C?C·Jacobsen·2015··21.71··1021··1927*2399#/470190 - 26590
102604··C?P·Rosnthal·2015··10.56··4219··1111111111111111111*9781#/(30*6373) - 25486
106752··C?C·PierCami·2009··20.24··2291··107*(5393#)/6 - 46834
··1113106··C?C·MJPC&JKA·2013··25.9045···18662··587*43103#/2310& - 455704
··4680156··C??·MrtnRaab·2016··20.3767···99750··230077#/2229464046810 - 3131794
Faked example data for testing
1. No change, all gaps known and no bettered merits
136098  C?P Toni_Key 2016  16.37  3610  1500031*8431#/41910 - 97126
136100  C?P Toni_Key 2016  15.39  3842  10000091*8963#/2221230 - 115554
136104  C?P Jacobsen 2017  16.61  3560  5105*8297#/30 - 61266
2. All gaps known but one with bettered merit
136098  C?P Toni_Key 2016  16.37  3610  1500031*8431#/41910 - 97126
136100  C?P Toni_Key 2016  15.39  3842  10000091*8963#/2221230 - 115554
136104  C?P Jacobsen 2017  17.61  3560  5105*8297#/30 - 61266
3. New gap found, otherwise no bettered merits
136100  C?P Toni_Key 2016  15.39  3842  10000091*8963#/2221230 - 115554
136102  C?P Jacobsen 2019  17.61  3560  5105*8324#/30 - 60965
136104  C?P Jacobsen 2017  16.61  3560  5105*8297#/30 - 61266
4. New gap found, also one with bettered merits
136100  C?P Toni_Key 2016  15.39  3842  10000091*8963#/2221230 - 115554
136102  C?P Jacobsen 2019  17.61  3560  5105*8324#/30 - 60965
136104  C?P Jacobsen 2017  18.61  3560  5105*8297#/30 - 61266
Copyright © 2023, The prime gap list community. Enhanced by Opentheme