Analysis Spreadsheets & Scripts
Working spreadsheets, CSV data tables, and processing scripts used during the forensic analysis pipeline. Includes both source data tables and the scripts used to transform them.
Expand All
Collapse All
ODS
FRAUD_flags_report.ods
348.5 KB
ODS
MCRO__json_source_data.ods
8.9 MB
ODS
MCRO__json_source_data__NEW_CLUSTER_IDs.ods
8.9 MB
ODS
MCRO__json_source_data__NEW_CLUSTER_IDs_v2.ods
8.9 MB
ODS
MCRO_expanded-cluster-case-set.ods
46.6 KB
ODS
PDF-GROUPS_granular_filing_types.ods
184.6 KB
ODS
PDF-GROUPS_guertin_hash_matches.ods
33.5 KB
ODS
TRACKING_font_hash_report.ods
638.5 KB
TXT
MACRO_output-all-column-widths.txt
3.6 KB
TXT
MACRO_output-all-csv-files.txt
2.0 KB
TXT
Set_All_Column_Widths_MACRO.txt
11.2 KB
PDF
01_Borer.pdf
216.8 KB
PDF
02_Borer.pdf
216.0 KB
PDF
03_Borer.pdf
215.5 KB
PDF
04_Borer.pdf
217.1 KB
PDF
05_Borer.pdf
213.5 KB
PDF
06_Borer.pdf
217.8 KB
PDF
07_Borer.pdf
158.6 KB
PDF
01_Klein.pdf
216.2 KB
PDF
02_Klein.pdf
219.1 KB
PDF
03_Klein.pdf
218.5 KB
PDF
04_Klein.pdf
219.0 KB
PDF
05_Klein.pdf
217.8 KB
PDF
06_Klein.pdf
215.1 KB
PDF
07_Klein.pdf
216.3 KB
PDF
08_Klein.pdf
216.3 KB
PDF
09_Klein.pdf
215.4 KB
PDF
10_Klein.pdf
215.5 KB
PDF
11_Klein.pdf
200.4 KB
PDF
01_Mercurio.pdf
216.6 KB
TXT
01_Mercurio.txt
74.8 KB
PDF
02_Mercurio.pdf
216.1 KB
TXT
02_Mercurio.txt
74.4 KB
PDF
03_Mercurio.pdf
217.8 KB
TXT
03_Mercurio.txt
74.1 KB
PDF
04_Mercurio.pdf
216.5 KB
TXT
04_Mercurio.txt
74.1 KB
PDF
05_Mercurio.pdf
215.9 KB
TXT
05_Mercurio.txt
74.0 KB
PDF
06_Mercurio.pdf
218.0 KB
TXT
06_Mercurio.txt
74.4 KB
PDF
07_Mercurio.pdf
220.2 KB
TXT
07_Mercurio.txt
74.4 KB
PDF
08_Mercurio.pdf
217.6 KB
TXT
08_Mercurio.txt
74.2 KB
PDF
09_Mercurio.pdf
214.9 KB
TXT
09_Mercurio.txt
74.1 KB
PDF
10_Mercurio.pdf
215.4 KB
TXT
10_Mercurio.txt
74.3 KB
PDF
11_Mercurio.pdf
218.2 KB
TXT
11_Mercurio.txt
75.2 KB
PDF
12_Mercurio.pdf
217.5 KB
TXT
12_Mercurio.txt
74.7 KB
PDF
13_Mercurio.pdf
207.3 KB
TXT
13_Mercurio.txt
68.9 KB
PDF
14_Mercurio.pdf
142.1 KB
TXT
14_Mercurio.txt
28.4 KB
CSV
All_CLEANED_TRANSPOSED_clusters.csv
1.0 MB
JSON
All_CLEANED_TRANSPOSED_clusters.json
353.0 KB
CSV
All_CLEANED_TRANSPOSED_noDupCases.csv
244.1 KB
CSV
All_CLEANED_TRANSPOSED_noDupCases_clusters.csv
331.3 KB
JSON
All_CLEANED_TRANSPOSED_noDupCases_clusters.json
362.8 KB
CSV
All_CLEANED_TRANSPOSED_noDupHearings.csv
857.1 KB
CSV
All_CLEANED_TRANSPOSED_noDupHearings_clusters.csv
953.6 KB
JSON
All_CLEANED_TRANSPOSED_noDupHearings_clusters.json
362.9 KB
CSV
Borer_CLEANED.csv
413.9 KB
TXT
Borer_CLEANED.txt
365.7 KB
CSV
Borer_CLEANED_TRANSPOSED.csv
218.5 KB
CSV
Borer_CLEANED_TRANSPOSED__noDupCases.csv
102.3 KB
CSV
Borer_CLEANED_TRANSPOSED__noDupCases_clusters.csv
110.8 KB
JSON
Borer_CLEANED_TRANSPOSED__noDupCases_clusters.json
140.7 KB
CSV
Borer_CLEANED_TRANSPOSED__noDupHearings.csv
199.5 KB
CSV
Borer_CLEANED_TRANSPOSED__noDupHearings_clusters.csv
209.5 KB
JSON
Borer_CLEANED_TRANSPOSED__noDupHearings_clusters.json
445.4 KB
CSV
Borer_CLEANED_TRANSPOSED_noDupCases_clusters.csv
130.6 KB
JSON
Borer_CLEANED_TRANSPOSED_noDupCases_clusters.json
196.4 KB
CSV
Borer_noDupCases.csv
155.6 KB
JSON
Borer_noDupCases.json
137.5 KB
CSV
Borer_noDupCases_clusters.csv
125.2 KB
CSV
Borer_noDupHearings.csv
249.7 KB
JSON
Borer_noDupHearings.json
137.5 KB
CSV
Borer_noDupHearings_clusters.csv
222.6 KB
CSV
Klein_CLEANED.csv
704.9 KB
TXT
Klein_CLEANED.txt
622.3 KB
CSV
Klein_CLEANED_TRANSPOSED.csv
378.2 KB
CSV
Klein_CLEANED_TRANSPOSED__noDupCases.csv
144.0 KB
CSV
Klein_CLEANED_TRANSPOSED__noDupCases_clusters.csv
155.4 KB
JSON
Klein_CLEANED_TRANSPOSED__noDupCases_clusters.json
187.4 KB
CSV
Klein_CLEANED_TRANSPOSED__noDupHearings.csv
303.5 KB
CSV
Klein_CLEANED_TRANSPOSED__noDupHearings_clusters.csv
318.3 KB
JSON
Klein_CLEANED_TRANSPOSED__noDupHearings_clusters.json
653.9 KB
CSV
Klein_CLEANED_TRANSPOSED_noDupCases_clusters.csv
181.6 KB
JSON
Klein_CLEANED_TRANSPOSED_noDupCases_clusters.json
261.1 KB
CSV
Klein_mainDates.csv
333.4 KB
JSON
Klein_mainDates.json
262.0 KB
CSV
Klein_noDupCases.csv
215.2 KB
JSON
Klein_noDupCases.json
182.5 KB
CSV
Klein_noDupCases_clusters.csv
174.3 KB
CSV
Klein_noDupHearings.csv
377.0 KB
JSON
Klein_noDupHearings.json
182.5 KB
CSV
Klein_noDupHearings_clusters.csv
337.3 KB
CSV
Mercurio-Borer-Klein_176-Shared-Cases.csv
37.5 KB
JSON
Mercurio-Borer-Klein_176-Shared-Cases.json
28.7 KB
CSV
Mercurio-Borer-Klein_176-Shared-Cases_clusters.csv
31.6 KB
CSV
Mercurio_Borer_Klein_SHARED-CASES_FULL-176.csv
27.3 KB
CSV
Mercurio_Borer_Klein_SHARED-CASES_FULL-176_clusters.csv
28.9 KB
JSON
Mercurio_Borer_Klein_SHARED-CASES_FULL-176_clusters.json
29.6 KB
CSV
Mercurio_Borer_Klein_SHARED-CASES_MCRO-DATASET-163.csv
25.2 KB
CSV
Mercurio_Borer_Klein_SHARED-CASES_MCRO-DATASET-163_clusters.csv
26.7 KB
CSV
Mercurio_CLEANED.csv
862.7 KB
TXT
Mercurio_CLEANED.txt
759.0 KB
CSV
Mercurio_CLEANED_TRANSPOSED.csv
462.0 KB
CSV
Mercurio_CLEANED_TRANSPOSED__noDupCases.csv
164.4 KB
CSV
Mercurio_CLEANED_TRANSPOSED__noDupCases_clusters.csv
177.6 KB
JSON
Mercurio_CLEANED_TRANSPOSED__noDupCases_clusters.json
212.6 KB
CSV
Mercurio_CLEANED_TRANSPOSED__noDupHearings.csv
393.9 KB
CSV
Mercurio_CLEANED_TRANSPOSED__noDupHearings_clusters.csv
444.2 KB
JSON
Mercurio_CLEANED_TRANSPOSED__noDupHearings_clusters.json
213.0 KB
CSV
Mercurio_noDupCases.csv
248.3 KB
JSON
Mercurio_noDupCases.json
207.2 KB
CSV
Mercurio_noDupCases_clusters.csv
201.2 KB
CSV
Mercurio_noDupHearings.csv
438.8 KB
JSON
Mercurio_noDupHearings.json
207.3 KB
CSV
Mercurio_noDupHearings_clusters.csv
391.9 KB
CSV
Mercurio_noDupHearings_mainDateRanges.csv
393.0 KB
JSON
Mercurio_noDupHearings_mainDateRanges.json
769.3 KB
CSV
These_13_Cases_are_MISSING.csv
2.1 KB
PY
cluster_defendants.py
5.1 KB
PY
cluster_defendants_2.py
7.2 KB
PY
column_stats_to_json.py
7.9 KB
PY
noDupFullRow.py
1.7 KB
PY
no_duplicates_all_columns.py
1.3 KB
PY
pick_first_of_triplets.py
2.3 KB
PY
transpose_hearings.py
3.3 KB
PY
transpose_hearings_2.py
3.1 KB
CSV
01_MCRO_files-downloaded.csv
1.8 MB
CSV
02_MCRO_digital-signatures.csv
1.9 MB
CSV
04_CASE_listed-attorneys.csv
164.3 KB
CSV
06_SHA-256_ttf-font-codes.csv
4.0 MB
CSV
10_SHA-256_returned-mail_duplicates.csv
18.0 KB
CSV
11_CASE_clusters.csv
7.8 KB
CSV
12_CASE_attorney-errors.csv
13.8 KB
ODS
Full_case_breakdowns_meta-sigs-fontCodes.ods
1.7 MB
ODS
HOWARD_HERSI_HASH_RUN_MANIFEST.ods
646.4 KB
ODT
MCRO_Dataset_bg_details_and_stats.odt
69.3 KB
ODS
MCRO_Share_Outputs_v11.ods
9.4 MB
ODS
MCRO_Share_Outputs_v12_search_removed.ods
8.5 MB
ODS
MCRO_cleaned_json_source_data.ods
8.9 MB
ODS
MCRO_cleaned_json_source_data_v2.ods
8.9 MB
CSV
Mercurio-Borer-Klein_163-Shared_MCRO-Dataset.csv
22.0 KB
JSON
Mercurio-Borer-Klein_163-Shared_MCRO-Dataset.json
27.5 KB
CSV
Mercurio-Borer-Klein_163-Shared_MCRO-Dataset_clusters.csv
16.4 KB
ODS
Mercurio_Borer_Klein_MCRO-DATASET_2025.ods
1.5 MB
ODS
Mercurio_Borer_Klein_MCRO-DATASET_SHARE_2025.ods
3.7 MB
ODS
Mercurio_Borer_Klein_MCRO-DATASET_SHARE_2025_v10.ods
9.5 MB
ODS
Mercurio_Borer_Klein_MCRO-DATASET_SHARE_2025_v2.ods
4.9 MB
ODS
Mercurio_Borer_Klein_MCRO-DATASET_SHARE_2025_v3.ods
5.6 MB
ODS
Mercurio_Borer_Klein_MCRO-DATASET_SHARE_2025_v4.ods
5.3 MB
ODS
Mercurio_Borer_Klein_MCRO-DATASET_SHARE_2025_v5.ods
6.7 MB
ODS
Mercurio_Borer_Klein_MCRO-DATASET_SHARE_2025_v6.ods
7.0 MB
ODS
Mercurio_Borer_Klein_MCRO-DATASET_SHARE_2025_v7.ods
7.4 MB
ODS
Mercurio_Borer_Klein_MCRO-DATASET_SHARE_2025_v8.ods
8.2 MB
ODS
Mercurio_Borer_Klein_MCRO-DATASET_SHARE_2025_v9.ods
9.5 MB
ODS
People_Words_Terms.ods
180.6 KB
ODS
TTF Font Codes__ORGANIZED.ods
382.5 KB
CSV
TTF Font Codes__csv_w_links.csv
1.5 MB
PDF
TTF Font Codes__csv_w_links_.pdf
96.1 KB
CSV
digital_sig_report_FULL.csv
1.1 MB
CSV
digital_sig_report_PDFSIG.csv
1.5 MB
CSV
digital_sig_report_SUMMARY.csv
582.9 KB
ODS
flag_report_master.ods
1.0 MB
ODS
flag_report_master_v2.ods
1.0 MB
ODS
focused_terminology_matches.ods
63.6 KB
CSV
metadata_digest.csv
1.5 MB