DuckDB Database & Assembly Pipeline
The complete database assembly pipeline that preceded the current Supabase PostgreSQL database. Contains raw source data, transformation scripts, schema definitions, SQL queries, and export artifacts. This represents the provenance chain from raw court data to structured database.
Expand All
Collapse All
ZIP
assembly-pipeline.zip
316.1 MB
NDJSO
children_000.ndjson
18.3 MB
NDJSO
children_001.ndjson
17.6 MB
NDJSO
children_002.ndjson
18.9 MB
NDJSO
children_003.ndjson
18.9 MB
NDJSO
children_004.ndjson
18.9 MB
NDJSO
children_005.ndjson
18.9 MB
NDJSO
children_006.ndjson
18.9 MB
NDJSO
children_007.ndjson
18.2 MB
NDJSO
hashpack_000.ndjson
18.9 MB
NDJSO
hashpack_001.ndjson
16.7 MB
NDJSO
hashpack_002.ndjson
18.9 MB
NDJSO
hashpack_003.ndjson
18.9 MB
NDJSO
hashpack_004.ndjson
18.9 MB
NDJSO
hashpack_005.ndjson
18.9 MB
NDJSO
hashpack_006.ndjson
18.9 MB
NDJSO
hashpack_007.ndjson
18.9 MB
NDJSO
hashpack_008.ndjson
18.9 MB
NDJSO
hashpack_009.ndjson
18.3 MB
NDJSO
hashpack_010.ndjson
18.8 MB
NDJSO
parents_000.ndjson
16.6 MB
NDJSO
parents_001.ndjson
16.6 MB
NDJSO
parents_002.ndjson
16.6 MB
NDJSO
parents_003.ndjson
16.6 MB
NDJSO
parents_004.ndjson
16.5 MB
NDJSO
source_000.ndjson
10.1 MB
NDJSO
source_001.ndjson
10.2 MB
CSV
children__address__by_cluster_top_norm.csv
28.6 KB
CSV
children__address__occurrences.csv
974.8 KB
CSV
children__address__overview.csv
73 B
CSV
children__address__top_norm.csv
22.5 KB
CSV
children__address_clustering.csv
4.1 KB
CSV
children__case_set_tag__distribution.csv
448 B
CSV
children__clusters.csv
3.7 KB
CSV
children__doc_set_tag__distribution.csv
2.5 KB
CSV
children__doc_strings__by_group_n.csv
423 B
CSV
children__doc_strings__by_group_type.csv
542 B
CSV
children__doc_strings__overview.csv
114 B
CSV
children__doc_strings__per_doc.csv
999.6 KB
CSV
children__docs_by_case_type.csv
208 B
CSV
children__identical_msip_metadata__counts.csv
370 B
CSV
children__identical_msip_metadata__occurrences.csv
10.8 KB
CSV
children__objects__by_object_family.csv
445 B
CSV
children__objects__by_object_type.csv
203 B
CSV
children__objects__by_type_family.csv
798 B
CSV
children__objects__overview.csv
71 B
CSV
children__overview.csv
196 B
CSV
children__pdf_create_date_after_efile_date__occurrences.csv
149.7 KB
CSV
children__pdf_create_date_after_efile_date__stats.csv
81 B
CSV
children__pdf_document_title__occurrences.csv
315.5 KB
CSV
children__pdf_document_title__stats.csv
45 B
XLSX
parents__attorney_stats.xlsx
133.2 KB
XLSX
parents__case_event_name_counts.xlsx
51.1 KB
XLSX
parents__judicial_stats.xlsx
50.4 KB
CSV
parents__attorneys_by_role_status.csv
180.9 KB
CSV
parents__case_events_CR__attorney_counts.csv
45.2 KB
CSV
parents__case_events_CR__event_name_counts.csv
28.9 KB
CSV
parents__case_events_CR__judicial_officer_counts.csv
26.7 KB
CSV
parents__case_events_CR__party_counts.csv
97.6 KB
CSV
parents__case_events_GC__attorney_counts.csv
5.3 KB
CSV
parents__case_events_GC__event_name_counts.csv
11.9 KB
CSV
parents__case_events_GC__judicial_officer_counts.csv
3.7 KB
CSV
parents__case_events_GC__party_counts.csv
14.5 KB
CSV
parents__case_events_MH__attorney_counts.csv
8.5 KB
CSV
parents__case_events_MH__event_name_counts.csv
16.0 KB
CSV
parents__case_events_MH__judicial_officer_counts.csv
12.7 KB
CSV
parents__case_events_MH__party_counts.csv
16.0 KB
CSV
parents__case_events__overview_by_case_type.csv
404 B
CSV
parents__case_level_judicial_officers.csv
8.6 KB
CSV
parents__case_level_v_event_level_judicial_officers.csv
680 B
CSV
parents__case_set_distribution.csv
691 B
CSV
parents__cases_by_case_status.csv
305 B
CSV
parents__cases_by_case_type.csv
158 B
CSV
parents__cluster_expansion.csv
38.9 KB
CSV
parents__clusters.csv
49.2 KB
CSV
parents__date_ranges.csv
460 B
CSV
parents__doc_set_distribution.csv
59 B
CSV
parents__event_level_judicial_officers.csv
31.8 KB
CSV
parents__event_names_top.csv
15.2 KB
CSV
parents__overview.csv
114 B
CSV
source__all__attorneys.csv
66 B
CSV
source__all__cases_by_set.csv
254 B
CSV
source__all__clusters.csv
99.1 KB
CSV
source__all__clusters_top200.csv
10.4 KB
CSV
source__all__hearing_results.csv
380 B
CSV
source__all__hearing_types.csv
846 B
CSV
source__all__hearings__cases_by_case_type.csv
438 B
CSV
source__all__hearings_by_case_type.csv
7.8 KB
CSV
source__all__hearings_by_set.csv
1.6 KB
CSV
source__all__judicial_officers.csv
4.4 KB
CSV
source__cases__active_warrant_flag.csv
150 B
CSV
source__cases__case_location.csv
359 B
CSV
source__cases__case_status.csv
294 B
CSV
source__cases__charge_dispositions.csv
343 B
CSV
source__cases__charge_levels.csv
78 B
CSV
source__cases__charge_names.csv
23.9 KB
CSV
source__cases__charge_statutes.csv
3.5 KB
CSV
source__cases__charges_per_case.csv
95.5 KB
CSV
source__cases__cluster_size_histogram.csv
662 B
CSV
source__cases__clusters.csv
57.5 KB
CSV
source__cases__date_filed_by_month.csv
4.6 KB
CSV
source__cases__date_filed_by_year.csv
472 B
CSV
source__cases__judicial_officers.csv
5.6 KB
CSV
source__cases__overview.csv
264 B
CSV
source__cases__statute_by_disposition.csv
9.2 KB
CSV
source__hearings__conflicts_case_double_booked.csv
7.3 KB
CSV
source__hearings__conflicts_judge_double_booked.csv
2.0 KB
CSV
source__hearings__conflicts_jury_trials.csv
1.1 KB
CSV
source__hearings__conflicts_major_rows.csv
1.3 MB
CSV
source__hearings__conflicts_time_location_any.csv
71.3 KB
CSV
source__hearings__conflicts_time_location_major.csv
8.2 KB
CSV
source__hearings__conflicts_time_location_type.csv
39.1 KB
CSV
source__hearings__hearing_date_by_case_type.csv
75.9 KB
CSV
source__hearings__hearing_date_location_peaks.csv
32.6 KB
CSV
source__hearings__hearing_date_summary.csv
13.5 KB
CSV
source__hearings__hearing_date_top_judges.csv
120.0 KB
XLSX
02_event_alignment__occurrences.xlsx
1.2 MB
XLSX
02_event_alignment__stats.xlsx
120.8 KB
XLSX
michael_howard__aligned_docs_sorted.xlsx
55.8 KB
CSV
02_event_alignment__cluster_count_distribution.csv
102 B
CSV
02_event_alignment__mcro_vs_non_overview.csv
189 B
CSV
02_event_alignment__occurrences.csv
3.6 MB
CSV
02_event_alignment__stats.csv
487.0 KB
CSV
MICHAEL_HOWARD__aligned_docs.csv
171.2 KB
CSV
MICHAEL_HOWARD__judicial_objects.csv
100.0 KB
CSV
MICHAEL_HOWARD__sigs_meta.csv
171.2 KB
CSV
dup_within_cluster__MCRO_163.csv
238.0 KB
CSV
event_name_stats_CR__case_set__B.csv
10.8 KB
CSV
event_name_stats_CR__case_set__C.csv
11.2 KB
CSV
event_name_stats_CR__case_set__First-50.csv
11.3 KB
CSV
event_name_stats_CR__case_set__MCRO.csv
9.0 KB
CSV
extra_cases__case_timelines.csv
4.2 KB
CSV
extra_cases__dup_by_date_event__min5_cases.csv
333 B
CSV
extra_cases__dup_within_cluster__top5000.csv
66.5 KB
CSV
extra_cases__event_name_stats__CR.csv
10.2 KB
CSV
extra_cases__event_name_stats__GC.csv
4.6 KB
CSV
extra_cases__event_name_stats__MH.csv
8.4 KB
CSV
extra_cases__events_summary_by_case_type.csv
205 B
CSV
extra_cases__judicial_officers.csv
635 B
CSV
extra_cases__keyword_headlines.csv
659 B
CSV
extra_cases__summary_by_case_type.csv
206 B
CSV
mcro_children_manifest.csv
1.6 MB
CSV
mcro_cluster_extra_cases_list.csv
5.9 KB
CSV
mcro_cluster_extra_parents_manifest.csv
38.1 KB
CSV
mcro_parents_manifest.csv
21.6 KB
CSV
timelines__ALL_497.csv
30.3 KB
CSV
timelines__MCRO_163.csv
12.1 KB
XLSX
04_doc_clone_group_pack.xlsx
257.3 KB
XLSX
pdf_bookmarks.xlsx
18.5 KB
CSV
discovery__cluster_stats.csv
3.8 KB
CSV
discovery__doc_occurrences.csv
39.0 KB
CSV
discovery__doc_pair_similarity_top.csv
166.7 KB
CSV
discovery__rowhash_long_span.csv
76.6 KB
CSV
discovery__rowhash_stats_dupe.csv
116.9 KB
CSV
discovery__rowhash_tag_stats.csv
108.8 KB
CSV
discovery__top_rowhash_text.csv
84.9 KB
CSV
discovery__year_stats.csv
622 B
CSV
pdf_bookmarks__clone_groups__occurrences.csv
85.7 KB
CSV
pdf_bookmarks__clone_groups__stats.csv
4.9 KB
CSV
pdf_bookmarks__coverage_summary.csv
255 B
CSV
sig_revcount__occurrences.csv
1001.2 KB
CSV
sig_revcount__stats.csv
406 B
CSV
tracking_font_anomalies__doc_overview.csv
5.6 KB
CSV
tracking_font_anomalies__font_objects.csv
109.1 KB
CSV
tracking_font_anomalies__key_font_presence.csv
1.2 KB
CSV
tracking_font_anomalies__pairwise_diffs.csv
2.1 KB
CSV
tracking_font_anomalies__signatures_full_report.csv
10.5 KB
CSV
tracking_font_anomalies__tracking_groups.csv
932 B
CSV
usps_mail_scan__clone_groups__occurrences.csv
25.4 KB
CSV
usps_mail_scan__clone_groups__stats.csv
3.0 KB
CSV
usps_mail_scan__coverage_summary.csv
200 B
CSV
date_parse_healthcheck.csv
180 B
CSV
samp_summary__non_mcro.csv
514 B
CSV
sampling_trials__non_mcro.csv
23.1 KB
CSV
summary_normalized.csv
553 B
CSV
summary_raw.csv
538 B
CSV
top_cases_by_disp_lines.csv
3.7 KB
CSV
top_cases_by_interim_lines.csv
3.3 KB
CSV
top_reused_disp_lines.csv
10.6 KB
PNG
01_doc_concentration_top25.png
134.4 KB
PNG
02_top_tracking_font_hashes_by_docs.png
267.5 KB
PNG
03_exclusive_terms_presence_heatmap.png
114.9 KB
PNG
04_graph_cluster_to_font_edges.png
1.1 MB
PNG
05_graph_cluster_to_term_edges.png
2.7 MB
ODS
06_clusters_aligned.ods
62.3 KB
XLSX
06_clusters_aligned.xlsx
28.8 KB
CSV
06_doc_tracking_fonts.csv
94.8 KB
CSV
06_docs_with_adrian_in_xmp_title.csv
639 B
CSV
06_exclusive_terms_doc_concentration.csv
15.0 KB
CSV
06_exclusive_terms_with_tracking_fonts.csv
29.7 KB
ODS
06_first_run_pack.ods
157.4 KB
XLSX
06_first_run_pack.xlsx
96.6 KB
ODS
06_language_and_terms_connectors.ods
593.9 KB
XLSX
06_language_and_terms_connectors.xlsx
563.0 KB
CSV
06_term_cluster_presence_matrix.csv
61.9 KB
CSV
06_terms_exclusive_to_focal_plus_3.csv
7.2 KB
CSV
06x_adrian_xmp_docs_enriched.csv
900 B
CSV
06x_case_events_for_top_docs.csv
2.1 MB
CSV
06x_edges_cluster_font.csv
2.8 KB
CSV
06x_edges_cluster_term.csv
13.8 KB
CSV
06x_event_name_term_hits.csv
266 B
CSV
06x_font_bridges_from_1570.csv
804 B
CSV
06x_font_hash_cluster_counts.csv
1.0 KB
CSV
06x_top_docs.csv
7.0 KB
CSV
07_msip_docs__occurrences.csv
27.3 KB
CSV
07_msip_focal_cluster_1570__docs.csv
35.3 KB
CSV
07_msip_group_stats__by_site_action_label_case_type.csv
5.3 KB
ODS
07_msip_metadata.ods
53.1 KB
XLSX
07_msip_metadata.xlsx
34.5 KB
ODS
07_msip_metadata__run02_fonts_terms.ods
171.6 KB
XLSX
07_msip_metadata__run02_fonts_terms.xlsx
161.1 KB
CSV
07_msip_signature_anomalies__docs.csv
10.4 KB
CSV
07_msip_signer_validity__summary.csv
478 B
CSV
07_msip_site_id__jurisdiction_matrix.csv
112 B
CSV
07_msip_timeline__by_site_id.csv
232 B
CSV
07r2_msip_compound_anomalies.csv
9.8 KB
CSV
07r2_msip_font_objects__docs_long.csv
224.2 KB
CSV
07r2_msip_shared_fonts__cross_focal.csv
1.8 KB
CSV
07r2_msip_shared_fonts__hash_stats.csv
41.0 KB
CSV
07r2_msip_shared_terms__stats.csv
12.3 KB
CSV
07r2_msip_terms__docs_long.csv
514.3 KB
CSV
07r2_msip_terms__focal_vs_others.csv
5.8 KB
CSV
08_by_watermark_status.csv
317 B
ODS
08_created_after_efile.ods
170.1 KB
XLSX
08_created_after_efile.xlsx
230.2 KB
CSV
08_created_after_efile__docs.csv
738.1 KB
CSV
08_created_after_efile__focal_1570.csv
26.6 KB
CSV
08_timeline_by_efile_date.csv
6.8 KB
ODS
09_esolutions_digital_sig.ods
259.6 KB
XLSX
09_esolutions_digital_sig.xlsx
216.6 KB
CSV
09_esolutions_docs__FOCAL_1570.csv
73.6 KB
CSV
09_esolutions_docs_enriched.csv
1.1 MB
CSV
09_esolutions_esolutions_sigs_long.csv
531.3 KB
XLSX
09_esolutions_sig_v_obj.xlsx
186.4 KB
CSV
09_esolutions_stats_by_case_type.csv
208 B
CSV
09_esolutions_stats_by_cluster.csv
2.2 KB
CSV
09_esolutions_stats_by_signer.csv
1.9 KB
ODS
09_r2_esolutions_digital_sig_v_obj.ods
220.1 KB
CSV
09r2_esolutions_docs.csv
78.7 KB
CSV
09r2_esolutions_duplication__per_doc.csv
60.3 KB
CSV
09r2_esolutions_full_report__long.csv
463.9 KB
CSV
09r2_esolutions_hidden_widget__rollup.csv
21.2 KB
CSV
09r2_esolutions_signature_templates.csv
23.5 KB
PNG
10r1_01_pdf_group_doc_counts.png
54.7 KB
PNG
10r1_02_pdf_group_create_after_pct.png
60.3 KB
PNG
10r1_03_graph_cluster_to_pdf_group.png
1.3 MB
CSV
10r1_edges.csv
42.5 KB
PNG
10r1_graph_bipartite.png
1.0 MB
SVG
10r1_graph_bipartite.svg
101.4 KB
CSV
10r1_graph_bipartite__edges.csv
31.1 KB
CSV
10r1_graph_bipartite__nodes.csv
4.5 KB
JSON
10r1_graph_bipartite__summary.json
1.1 KB
HTML
10r1_graph_bipartite_interactive.html
82.3 KB
SVG
10r1_graph_focal_MATTHEW_GUERTIN.svg
4.3 KB
ODS
10_r1_font_tracking.ods
821.0 KB
XLSX
10_r1_font_tracking.xlsx
770.3 KB
ODS
10_r1_temporal_font_tracking.ods
48.2 KB
XLSX
10_r1_temporal_font_tracking.xlsx
21.6 KB
CSV
10r1_focal_tracking_font_hashes.csv
1.0 KB
CSV
10r1_pdf_group_inventory.csv
18.4 KB
CSV
10r1_tracked_docs__summary.csv
1.0 MB
CSV
10r1_tracked_groups__long.csv
1.2 MB
CSV
10r1_tracking_font_objects__long.csv
2.1 MB
PNG
10r2_plot_group_timespan_ranges.png
58.6 KB
PNG
10r2_plot_hash_gap_days.png
85.7 KB
PNG
10r2_plot_yearly_docs_focal_vs_nonfocal.png
73.4 KB
CSV
10r2_temporal_cluster_ranges.csv
5.1 KB
CSV
10r2_temporal_group_ranges.csv
3.0 KB
CSV
10r2_temporal_hash_ranges.csv
3.8 KB
MD
10r2_temporal_report.md
6.8 KB
JSON
10r2_temporal_summary.json
1.1 KB
CSV
10r2_temporal_top_signals.csv
2.2 KB
CSV
10r2_temporal_yearly_focal_vs_nonfocal.csv
163 B
XLSX
01_dataset_stats__children.xlsx
587.2 KB
XLSX
01_dataset_stats__parents.xlsx
198.5 KB
XLSX
01_dataset_stats__parents__case_events.xlsx
238.3 KB
XLSX
01_dataset_stats__source__all.xlsx
124.6 KB
XLSX
01_dataset_stats__source__cases.xlsx
121.2 KB
XLSX
01_dataset_stats__source__hearings.xlsx
130.9 KB
XLSX
01_dataset_stats__source__hearings__conflicts.xlsx
311.4 KB
XLSX
02_cluster_alignment__event_align.xlsx
1.5 MB
XLSX
02_cluster_alignment__event_align__MICHAEL_HOWARD.xlsx
84.7 KB
XLSX
03_mcro_dataset_origin.xlsx
756.5 KB
XLSX
03_mcro_dataset_origin__added_cases.xlsx
74.7 KB
XLSX
03_mcro_dataset_origin__event_stats.xlsx
35.8 KB
XLSX
03_mcro_dataset_origin__source_hearings.xlsx
7.8 KB
XLSX
04_clone_matching__demand_discovery_filings.xlsx
187.8 KB
XLSX
04_clone_matching__pdf_bookmarks.xlsx
27.7 KB
XLSX
04_clone_matching__sig_revcount.xlsx
225.3 KB
XLSX
04_clone_matching__tracking_font_anomalies.xlsx
39.1 KB
XLSX
04_clone_matching__usps_mail_scan.xlsx
16.9 KB
XLSX
05_narrative.xlsx
37.4 KB
ZIP
original_csv_reports.zip
4.0 MB
CSV
all_sets__annotated__GRAIN.csv
117.2 KB
XLSX
all_sets__annotated__GRAIN.xlsx
41.6 KB
CSV
all_sets__array_mapping__GRAIN.csv
26.5 KB
XLSX
all_sets__array_mapping__GRAIN.xlsx
12.3 KB
XLSX
all_sets__schema.xlsx
88.8 KB
XLSX
all_sets__schema__REQUIRED.xlsx
21.2 KB
CSV
all_sets__schema_lists.csv
13.3 KB
CSV
all_sets__schema_lists__REQUIRED.csv
3.0 KB
CSV
all_sets__schema_paths.csv
13.3 KB
CSV
all_sets__schema_paths__REQUIRED.csv
23.2 KB
XLSX
children__schema.xlsx
32.4 KB
XLSX
children__schema__REQUIRED.xlsx
16.5 KB
CSV
children__schema_lists.csv
2.2 KB
CSV
children__schema_lists__REQUIRED.csv
968 B
CSV
children__schema_paths.csv
42.6 KB
CSV
children__schema_paths__REQUIRED.csv
4.6 KB
CSV
children__validation_summary__REQUIRED.csv
1.2 KB
XLSX
hashpack__schema.xlsx
19.9 KB
XLSX
hashpack__schema__REQUIRED.xlsx
15.4 KB
CSV
hashpack__schema_lists.csv
892 B
CSV
hashpack__schema_lists__REQUIRED.csv
563 B
CSV
hashpack__schema_paths.csv
931 B
CSV
hashpack__schema_paths__REQUIRED.csv
8.1 KB
CSV
hashpack__validation_summary__REQUIRED.csv
1.9 KB
XLSX
parents__schema.xlsx
50.1 KB
XLSX
parents__schema__REQUIRED.xlsx
136.2 KB
CSV
parents__schema_lists.csv
10.2 KB
CSV
parents__schema_lists__REQUIRED.csv
1.5 KB
CSV
parents__schema_paths.csv
69.9 KB
CSV
parents__schema_paths__REQUIRED.csv
5.8 KB
CSV
parents__validation_summary__REQUIRED.csv
1.6 KB
XLSX
source__schema.xlsx
20.9 KB
XLSX
source__schema__REQUIRED.xlsx
9.8 KB
CSV
source__schema_lists.csv
663 B
CSV
source__schema_lists__REQUIRED.csv
663 B
CSV
source__schema_paths.csv
20.6 KB
CSV
source__schema_paths__REQUIRED.csv
4.7 KB
CSV
source__validation_summary__REQUIRED.csv
449 B
SQL
starter_views__v3_provenance.sql
13.3 KB
SQL
supabase__children_v1__exports.sql
2.3 KB
SQL
supabase__children_v1__views.sql
8.3 KB
SQL
supabase__hashpack_v1__exports.sql
2.1 KB
SQL
supabase__hashpack_v1__views.sql
7.1 KB
SQL
supabase__parents_v1__exports.sql
10.2 KB
SQL
supabase__parents_v1__views.sql
10.4 KB
SQL
supabase__source_v1__exports.sql
1.4 KB
SQL
supabase__source_v1__views.sql
7.9 KB
SQL
01_children__exports.sql
2.8 KB
SQL
01_children__metadata_stats__exports.sql
2.4 KB
SQL
01_children__metadata_stats__views.sql
11.6 KB
SQL
01_children__views.sql
10.1 KB
SQL
01_parents__case_events__exports.sql
2.5 KB
SQL
01_parents__case_events__views.sql
10.5 KB
SQL
01_parents__exports.sql
2.2 KB
SQL
01_parents__views.sql
14.3 KB
SQL
01_source__case_search_stats__exports.sql
2.8 KB
SQL
01_source__case_search_stats__views.sql
3.3 KB
SQL
01_source__exports.sql
1.6 KB
SQL
01_source__hearing_datetime_stats__exports.sql
2.2 KB
SQL
01_source__hearing_datetime_stats__views.sql
7.0 KB
SQL
01_source__views.sql
7.5 KB
MD
README__01_dataset_stats__source.md
10.0 KB
SQL
02_cluster_alignment__exports.sql
802 B
SQL
02_cluster_alignment__judicial_objects__exports.sql
306 B
SQL
02_cluster_alignment__judicial_objects__views.sql
7.6 KB
SQL
02_cluster_alignment__sigmeta__exports.sql
279 B
SQL
02_cluster_alignment__sigmeta__views.sql
3.5 KB
SQL
02_cluster_alignment__views.sql
3.8 KB
SQL
02_event_alignment__exports.sql
1.1 KB
SQL
02_event_alignment__views.sql
14.2 KB
SQL
02_top50_clusters_dump__exports.sql
519 B
SQL
02_top50_clusters_dump__views.sql
17.5 KB
MD
README__02_cluster_alignment__top50_clusters_dump.md
3.7 KB
MD
README__02_event_alignment.md
2.5 KB
SQL
03_mcro_dataset_origin__children_manifest__exports.sql
593 B
SQL
03_mcro_dataset_origin__children_manifest__views.sql
2.2 KB
SQL
03_mcro_dataset_origin__cluster_expanded_parents_manifest__exports.sql
610 B
SQL
03_mcro_dataset_origin__cluster_expanded_parents_manifest__views.sql
2.2 KB
SQL
03_mcro_dataset_origin__extra_cases_event_name_stats__exports.sql
2.3 KB
SQL
03_mcro_dataset_origin__extra_cases_event_name_stats__views.sql
9.8 KB
SQL
03_mcro_dataset_origin__parents_manifest__exports.sql
585 B
SQL
03_mcro_dataset_origin__parents_manifest__views.sql
963 B
SQL
03_mcro_dataset_origin__part05__cohort_reuse__exports.sql
1.9 KB
SQL
03_mcro_dataset_origin__part05__cohort_reuse__views.sql
7.2 KB
SQL
04_clone_matching__discovery_demand_rows__exports.sql
2.2 KB
SQL
04_clone_matching__discovery_demand_rows__views.sql
10.6 KB
SQL
04_clone_matching__exports.sql
2.5 KB
SQL
04_clone_matching__tracking_font_anomalies__exports.sql
1.5 KB
SQL
04_clone_matching__tracking_font_anomalies__views.sql
13.1 KB
SQL
04_clone_matching__views.sql
9.4 KB
MD
README__04_clone_matching__core_clone_matching.md
2.2 KB
MD
README__discovery_demand_rows.md
2.3 KB
MD
README__tracking_font_anomalies.md
3.6 KB
SQL
05_narrative__cr_upcoming_and_status__exports.sql
1.5 KB
SQL
05_narrative__cr_upcoming_and_status__views.sql
4.9 KB
SQL
05_narrative__exports.sql
1.3 KB
SQL
05_narrative__views.sql
15.9 KB
SQL
06_language_and_terms__connectors__exports.sql
1.6 KB
SQL
06_language_and_terms__connectors__views.sql
7.1 KB
SQL
06_language_and_terms__exports.sql
2.3 KB
SQL
06_language_and_terms__views.sql
9.8 KB
PY
06_language_and_terms__visuals.py
12.0 KB
MD
README__06_language_and_terms.md
4.2 KB
MD
README__06_language_and_terms__connectors.md
4.7 KB
MD
README__06_language_and_terms__visuals.md
2.8 KB
SQL
07_msip_metadata__exports.sql
3.6 KB
SQL
07_msip_metadata__run02_fonts_terms__exports.sql
2.8 KB
SQL
07_msip_metadata__run02_fonts_terms__views.sql
13.0 KB
SQL
07_msip_metadata__views.sql
8.8 KB
MD
README__07_msip_metadata.md
5.5 KB
MD
README__07_msip_metadata__run02_fonts_terms.md
2.2 KB
SQL
08_created_after_efile__exports.sql
1.9 KB
SQL
08_created_after_efile__views.sql
6.4 KB
MD
README__08_created_after_efile.md
2.4 KB
SQL
09_esolutions_digital_sig__exports.sql
1.6 KB
SQL
09_esolutions_digital_sig__run02_duplication__exports.sql
1.1 KB
SQL
09_esolutions_digital_sig__run02_duplication__views.sql
9.5 KB
SQL
09_esolutions_digital_sig__views.sql
7.9 KB
MD
README__09_esolutions_digital_sig.md
4.1 KB
MD
README__09_esolutions_digital_sig__run02_duplication.md
4.2 KB
SQL
10_font_tracking__run01__exports.sql
1.2 KB
PY
10_font_tracking__run01__graph_plus.py
11.2 KB
SQL
10_font_tracking__run01__views.sql
9.1 KB
PY
10_font_tracking__run01__visuals.py
18.9 KB
PY
10_font_tracking__run02__temporal_hypothesis.py
19.9 KB
MD
README__10_font_tracking__run01.md
3.4 KB
PY
make_10r1_edges_csv.py
2.3 KB
CSV
case_registry_rows.csv
512.8 KB
TXT
file_list__bin.txt
2.1 MB
TXT
file_list__c.txt
6.5 MB
TXT
file_list__charlottesville.txt
952 B
TXT
file_list__eml.txt
32.6 KB
TXT
file_list__judicial_roster.txt
14.9 KB
TXT
file_list__patent.txt
25.7 KB
TXT
file_list__source.txt
76.2 KB
PY
make_filename_pretty_all.py
6.4 KB
CSV
master_case_list.csv
136.7 KB
CSV
master_case_list_snippet.csv
284 B
ODS
matched_files_v1.ods
816.3 KB
CSV
output_example.csv
2.2 KB
CSV
output_pretty.csv
109.5 KB
XLSX
pdf_provenance_list.xlsx
25.1 KB
CSV
pretty_make_all_1.csv
54.3 KB
CSV
pretty_maker.csv
10.0 KB
CSV
pretty_maker_.csv
10.0 KB
CSV
pretty_maker_with_pretty.csv
21.4 KB
TXT
shape_probe.txt
158.3 KB
XLSX
supabase__children__schema.xlsx
33.8 KB
XLSX
supabase__hashpack__schema.xlsx
22.7 KB
XLSX
supabase__parents__schema.xlsx
33.4 KB
XLSX
supabase__source__schema.xlsx
24.8 KB
CSV
children_address.csv
981.0 KB
PARQU
children_address.parquet
248.7 KB
CSV
children_case_set.csv
1.4 MB
PARQU
children_case_set.parquet
133.2 KB
CSV
children_doc_set.csv
691.5 KB
PARQU
children_doc_set.parquet
226.8 KB
CSV
children_doc_strings.csv
122.0 MB
PARQU
children_doc_strings.parquet
9.2 MB
CSV
children_docs.csv
3.6 MB
PARQU
children_docs.parquet
991.4 KB
CSV
children_objects.csv
20.2 MB
PARQU
children_objects.parquet
6.3 MB
CSV
children_pdf_signatures_full_report.csv
3.0 MB
PARQU
children_pdf_signatures_full_report.parquet
933.6 KB
CSV
children_tracking_groups.csv
881.5 KB
PARQU
children_tracking_groups.parquet
213.9 KB
PARQU
hashpack.parquet
1.9 MB
CSV
hashpack_outline_lines.csv
176.7 KB
PARQU
hashpack_outline_lines.parquet
60.3 KB
CSV
hashpack_page_content_streams.csv
5.9 MB
PARQU
hashpack_page_content_streams.parquet
4.1 MB
CSV
hashpack_rows.csv
99.6 MB
PARQU
hashpack_rows.parquet
17.3 MB
CSV
hashpack_rows_tags.csv
64.6 MB
PARQU
hashpack_rows_tags.parquet
1.8 MB
CSV
hashpack_streams_rows.csv
89.9 MB
PARQU
hashpack_streams_rows.parquet
0 B
CSV
parents_attorneys_defense_active.csv
565.9 KB
PARQU
parents_attorneys_defense_active.parquet
74.1 KB
CSV
parents_attorneys_defense_inactive.csv
808.3 KB
PARQU
parents_attorneys_defense_inactive.parquet
69.2 KB
CSV
parents_attorneys_prosecution_active.csv
1.2 MB
PARQU
parents_attorneys_prosecution_active.parquet
92.3 KB
CSV
parents_attorneys_prosecution_inactive.csv
187.9 KB
PARQU
parents_attorneys_prosecution_inactive.parquet
27.6 KB
PARQU
parents_case_event_attorneys.parquet
136.6 KB
CSV
parents_case_events.csv
29.5 MB
PARQU
parents_case_events.parquet
9.7 MB
CSV
parents_case_events_attorneys.csv
306.1 KB
CSV
parents_case_events_evidence_uids.csv
267.1 KB
PARQU
parents_case_events_evidence_uids.parquet
52.3 KB
CSV
parents_case_events_examiners.csv
4.3 MB
PARQU
parents_case_events_examiners.parquet
327.7 KB
CSV
parents_case_events_judicial_officers.csv
4.6 MB
PARQU
parents_case_events_judicial_officers.parquet
184.5 KB
CSV
parents_case_set.csv
277.5 KB
PARQU
parents_case_set.parquet
35.6 KB
PARQU
parents_cases.parquet
70.1 KB
CSV
parents_charges.csv
1.1 MB
PARQU
parents_charges.parquet
380.9 KB
CSV
parents_cluster_cases.csv
1.3 MB
PARQU
parents_cluster_cases.parquet
150.3 KB
CSV
parents_dispositions.csv
1.7 MB
PARQU
parents_dispositions.parquet
1.4 MB
CSV
parents_dispositions_charges.csv
3.5 MB
PARQU
parents_dispositions_charges.parquet
1.2 MB
CSV
parents_dispositions_charges_commit_commissioner_corrections.csv
272.2 KB
PARQU
parents_dispositions_charges_commit_commissioner_corrections.parquet
42.4 KB
CSV
parents_dispositions_charges_concurrent_consecutive.csv
211.5 KB
PARQU
parents_dispositions_charges_concurrent_consecutive.parquet
36.4 KB
CSV
parents_dispositions_charges_condition_adult.csv
2.2 MB
PARQU
parents_dispositions_charges_condition_adult.parquet
358.3 KB
CSV
parents_dispositions_charges_diversion_program_adult.csv
171.5 KB
PARQU
parents_dispositions_charges_diversion_program_adult.parquet
29.7 KB
CSV
parents_dispositions_charges_indexed.csv
5.0 MB
PARQU
parents_dispositions_charges_indexed.parquet
3.9 MB
CSV
parents_dispositions_charges_level_of_sentence.csv
200.2 KB
PARQU
parents_dispositions_charges_level_of_sentence.parquet
30.1 KB
CSV
parents_dispositions_charges_local_confinement.csv
604.8 KB
PARQU
parents_dispositions_charges_local_confinement.parquet
70.7 KB
CSV
parents_dispositions_charges_monitoring_adult.csv
462.6 KB
PARQU
parents_dispositions_charges_monitoring_adult.parquet
50.3 KB
CSV
parents_dispositions_charges_service_adult.csv
224.9 KB
PARQU
parents_dispositions_charges_service_adult.parquet
35.2 KB
CSV
parents_doc_set.csv
76.7 KB
PARQU
parents_doc_set.parquet
18.8 KB
CSV
parents_hearings_previous.csv
8.8 MB
PARQU
parents_hearings_previous.parquet
2.7 MB
CSV
parents_hearings_previous_judicial_officers.csv
852.9 KB
PARQU
parents_hearings_previous_judicial_officers.parquet
74.3 KB
CSV
parents_hearings_upcoming.csv
254.3 KB
PARQU
parents_hearings_upcoming.parquet
76.7 KB
CSV
parents_interim_conditions.csv
1.4 MB
PARQU
parents_interim_conditions.parquet
760.1 KB
CSV
parents_related_cases.csv
192.8 KB
PARQU
parents_related_cases.parquet
51.1 KB
PARQU
source.parquet
6.3 KB
CSV
source__hearings__snippet.csv
11.9 KB
CSV
source_cases.csv
1.3 MB
PARQU
source_cases.parquet
271.4 KB
CSV
source_files.csv
342.0 KB
PARQU
source_files.parquet
111.2 KB
CSV
source_hearings.csv
13.1 MB
PARQU
source_hearings.parquet
1.4 MB
CSV
children_address.csv
981.0 KB
CSV
children_case_set.csv
1.4 MB
CSV
children_doc_set.csv
691.5 KB
CSV
children_doc_strings.csv
122.0 MB
CSV
children_objects.csv
20.2 MB
CSV
children_signatures_full_report.csv
3.0 MB
CSV
children_tracking_groups.csv
881.5 KB
CSV
hashpack_outline_lines.csv
176.7 KB
CSV
hashpack_page_content_streams.csv
5.9 MB
CSV
hashpack_rows.csv
99.6 MB
CSV
hashpack_rows_tags.csv
64.6 MB
CSV
hashpack_streams_rows.csv
89.9 MB
CSV
parents_attorneys_defense_active.csv
565.9 KB
CSV
parents_attorneys_defense_inactive.csv
808.3 KB
CSV
parents_attorneys_prosecution_active.csv
1.2 MB
CSV
parents_attorneys_prosecution_inactive.csv
187.9 KB
CSV
parents_case_events.csv
29.5 MB
CSV
parents_case_events_attorneys.csv
306.1 KB
CSV
parents_case_events_evidence_uids.csv
267.1 KB
CSV
parents_case_events_examiners.csv
4.3 MB
CSV
parents_case_events_judicial_officers.csv
4.6 MB
CSV
parents_case_set.csv
277.5 KB
CSV
parents_charges.csv
1.1 MB
CSV
parents_cluster_cases.csv
1.3 MB
CSV
parents_dispositions.csv
1.7 MB
CSV
parents_dispositions_charges.csv
3.5 MB
CSV
parents_dispositions_charges_commit_commissioner_corrections.csv
272.2 KB
CSV
parents_dispositions_charges_concurrent_consecutive.csv
211.5 KB
CSV
parents_dispositions_charges_condition_adult.csv
2.2 MB
CSV
parents_dispositions_charges_diversion_program_adult.csv
171.5 KB
CSV
parents_dispositions_charges_indexed.csv
5.0 MB
CSV
parents_dispositions_charges_level_of_sentence.csv
200.2 KB
CSV
parents_dispositions_charges_local_confinement.csv
604.8 KB
CSV
parents_dispositions_charges_monitoring_adult.csv
462.6 KB
CSV
parents_dispositions_charges_service_adult.csv
224.9 KB
CSV
parents_doc_set.csv
76.7 KB
CSV
parents_hearings_previous.csv
8.8 MB
CSV
parents_hearings_previous_judicial_officers.csv
852.9 KB
CSV
parents_hearings_upcoming.csv
254.3 KB
CSV
parents_interim_conditions.csv
1.4 MB
CSV
parents_related_cases.csv
192.8 KB
CSV
source_cases.csv
1.3 MB
CSV
source_files.csv
342.0 KB
CSV
source_hearings.csv
13.1 MB
