Category Archives: fracking

Status Update: FracFocus.org CSV transformed/augmented data pushed to S3 bucket (2017-09-05)

FracFocus.org’s CSV data has been imported, transformed, and augmented with chemical toxicities by the author of this blog resulting in the file available at the link below:

Khepry Quixote
2017-09-07

Advertisements

Update: FracFocusCSV data blending with chemical toxicities

The new FracFocusCSV files, found within FracFocus.org’s FracFocusCSV.zip archive, lend themselves to blending with chemical toxicities using the CASNumber column of each row.   I’ve modified the PyZip2Src2Tgt project, on the “toxicities” branch, to blend the appropriate chemical toxicity based upon the CASNumber of the row in question.  The data blending with chemical toxicities has not yet been checked for validity, so if you use the program, you’ll need to verify its results.

Khepry Quixote
2017-08-04

Initiative: FracFocusCSV data blending with chemical toxicities

The new FracFocusCSV files, found within FracFocus.org’s FracFocusCSV.zip archive, lend themselves to blending with chemical toxicities using the CASNumber column of each row with relative ease.  In the near future, I’ll be releasing the combined FracFocusCSV.tsv file with chemical toxicities blended within.  As I already possess the chemical toxicity data, it’ll come down to modifying the PyZip2Src2Tgt program to accommodate blending the FracFocusCSV chemical declaration data with the chemical toxicity data based upon the “CASNumber” key column.

Khepry Quixote
2017-07-28

Status Update 2017-07-27: FracFocusCSV 2017-07 Files Combined and Uploaded

Using the PyZip2Src2Tgt Python 3 program, the 12 FracFocus CSV files contained within FracFocus.org’s FracFocusCSV.zip archive were combined into one CSV file and then compressed into one tab-delimited value file (.tsv) file, to wit:

https://s3.amazonaws.com/frackinganalysis-s3-01/downloads/FracFocusCSV_Combined_201707.7z

Please note that this compressed archive does not contain any chemical toxicities at the present time.  I’ll push a new compressed archive with those in it as well at a date in the near future.

Presently, I’m working on an SQLite database with the new FracFocusCSV file as its source of fracking chemical disclosure information.  It, too, will be available for download in the near future.

Khepry Quixote
2017-07-27

FracFocusCSV_Combined_201707.7z file pushed to S3 bucket

Using the PyZip2Src2Tgt Python 3 program, the 12 FracFocus CSV files contained within the FracFocusCSV.zip archive were combined into one CSV file and then compressed into one tab-delimited value file, i.e. a TSV file, to wit:

https://s3.amazonaws.com/frackinganalysis-s3-01/downloads/FracFocusCSV_Combined_201707.7z

Please note that this compressed archive does not contain any chemical toxicities at the present time.  I’ll push a new compressed archive with those in it as well at a date in the near future.

Presently, I’m working on an SQLite database with the new FracFocusCSV file as its source of fracking chemical disclosure information.  It, too, will be available for download in the near future.

Khepry Quixote
2017-07-26