postgres=> select 'source' as inv, payload->'ndjson' as ndjson, payload->'csv' as csv from inv.inventory_source_raw union all select 'hashpack', payload->'ndjson', payload->'csv' from inv.inventory_hashpack_raw union all select 'parents', payload->'ndjson', payload->'csv' from inv.inventory_parents_raw union all select 'children', payload->'ndjson', payload->'csv' from inv.inventory_children_raw; inv | ndjson | csv ----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- source | {"top_paths": [{"kind": "object", "path": "source_files", "count": 70}, {"kind": "scalar", "path": "source_files.source_filename", "count": 70}, {"kind": "scalar", "path": "source_files.source_sha256", "count": 70}, {"kind": "scalar", "path": "source_files.evidence_uid", "count": 70}, {"kind": "scalar", "path": "source_files.source_file_size", "count": 70}, {"kind": "scalar", "path": "source_files.source_ots_filename", "count": 70}, {"kind": "scalar", "path": "source_files.ots_receipt_status", "count": 70}, {"kind": "scalar", "path": "source_files.ots_btc_block_height", "count": 70}, {"kind": "scalar", "path": "source_files.ots_btc_block_hash", "count": 70}, {"kind": "scalar", "path": "source_files.ots_btc_earliest_on_chain_time", "count": 70}, {"kind": "scalar", "path": "source_files.ots_btc_earliest_on_chain_time_z", "count": 70}, {"kind": "scalar", "path": "source_files.ots_btc_block_header_time", "count": 70}, {"kind": "scalar", "path": "source_files.ots_btc_block_header_time_z", "count": 70}, {"kind": "scalar", "path": "source_files.source_last_modified_time", "count": 70}, {"kind": "scalar", "path": "source_files.source_last_modified_time_z", "count": 70}, {"kind": "scalar", "path": "source_files.ots_btc_latest_on_chain_time", "count": 70}, {"kind": "scalar", "path": "source_files.ots_btc_latest_on_chain_time_z", "count": 70}, {"kind": "object", "path": "hearings", "count": 65}, {"kind": "scalar", "path": "hearings.hearing_type", "count": 65}, {"kind": "scalar", "path": "hearings.hearing_date", "count": 65}, {"kind": "scalar", "path": "hearings.hearing_time", "count": 65}, {"kind": "scalar", "path": "hearings.hearing_datetime", "count": 65}, {"kind": "scalar", "path": "hearings.hearing_uid", "count": 65}, {"kind": "scalar", "path": "hearings.hearing_judicial_officer", "count": 65}, {"kind": "scalar", "path": "hearings.hearing_judicial_officer_raw", "count": 65}, {"kind": "scalar", "path": "hearings.hearing_judicial_officer_norm", "count": 65}, {"kind": "scalar", "path": "hearings.hearing_judicial_officer_id", "count": 65}, {"kind": "scalar", "path": "hearings.hearing_location", "count": 65}, {"kind": "scalar", "path": "hearings.case_id", "count": 65}, {"kind": "scalar", "path": "hearings.case_uid", "count": 65}, {"kind": "scalar", "path": "hearings.case_title", "count": 65}, {"kind": "scalar", "path": "hearings.case_type", "count": 65}, {"kind": "scalar", "path": "hearings.case_location", "count": 65}, {"kind": "scalar", "path": "hearings.case_active_warrant", "count": 65}, {"kind": "scalar", "path": "hearings.hearing_observation_uid", "count": 65}, {"kind": "object", "path": "hearings.mcro_source", "count": 65}, {"kind": "scalar", "path": "hearings.mcro_source.search_date_from", "count": 65}, {"kind": "scalar", "path": "hearings.mcro_source.search_date_to", "count": 65}, {"kind": "scalar", "path": "hearings.mcro_source.search_executed", "count": 65}, {"kind": "scalar", "path": "hearings.mcro_source.search_executed_string", "count": 65}, {"kind": "scalar", "path": "hearings.mcro_source.search_total_number", "count": 65}, {"kind": "scalar", "path": "hearings.mcro_source.search_result_number", "count": 65}, {"kind": "scalar", "path": "hearings.mcro_source.pdf_filename", "count": 65}, {"kind": "scalar", "path": "hearings.mcro_source.pdf_url", "count": 65}, {"kind": "scalar", "path": "hearings.mcro_source.pdf_evidence_uid", "count": 65}, {"kind": "scalar", "path": "hearings.cluster_name", "count": 51}, {"kind": "scalar", "path": "hearings.cluster_id", "count": 51}, {"kind": "scalar", "path": "hearings.defendant_name", "count": 50}, {"kind": "scalar", "path": "hearings.hearing_result", "count": 30}, {"kind": "scalar", "path": "hearings.hearing_cancelled", "count": 30}, {"kind": "scalar", "path": "hearings.mcro_source.html_filename", "count": 30}, {"kind": "object", "path": "$", "count": 14}, {"kind": "scalar", "path": "me_filename", "count": 14}, {"kind": "scalar", "path": "total_pdf_files", "count": 14}, {"kind": "scalar", "path": "total_html_files", "count": 14}, {"kind": "scalar", "path": "source_set_id", "count": 14}, {"kind": "scalar", "path": "search_type", "count": 14}, {"kind": "scalar", "path": "search_category", "count": 14}, {"kind": "scalar", "path": "search_locations", "count": 14}, {"kind": "array", "path": "source_files[]", "count": 14}, {"kind": "scalar", "path": "total_hearings_unique", "count": 13}, {"kind": "array", "path": "hearings[]", "count": 13}, {"kind": "scalar", "path": "case_set_id", "count": 11}, {"kind": "scalar", "path": "search_judicial_officer", "count": 9}, {"kind": "scalar", "path": "search_judicial_officer_raw", "count": 9}, {"kind": "scalar", "path": "search_judicial_officer_norm", "count": 9}, {"kind": "scalar", "path": "search_judicial_officer_id", "count": 9}, {"kind": "scalar", "path": "search_attorney", "count": 5}, {"kind": "scalar", "path": "search_attorney_raw", "count": 5}, {"kind": "scalar", "path": "search_attorney_norm", "count": 5}, {"kind": "scalar", "path": "search_attorney_id", "count": 5}, {"kind": "object", "path": "cases", "count": 5}, {"kind": "scalar", "path": "cases.case_id", "count": 5}, {"kind": "scalar", "path": "cases.case_uid", "count": 5}, {"kind": "scalar", "path": "cases.date_filed", "count": 5}, {"kind": "scalar", "path": "cases.case_title", "count": 5}, {"kind": "scalar", "path": "cases.case_type", "count": 5}, {"kind": "scalar", "path": "cases.case_status", "count": 5}, {"kind": "scalar", "path": "cases.case_location", "count": 5}, {"kind": "scalar", "path": "cases.case_active_warrant", "count": 5}, {"kind": "scalar", "path": "cases.defendant_name", "count": 5}, {"kind": "scalar", "path": "cases.defendant_dob", "count": 5}, {"kind": "scalar", "path": "cases.cluster_name", "count": 5}, {"kind": "scalar", "path": "cases.cluster_id", "count": 5}, {"kind": "scalar", "path": "cases.case_judicial_officer", "count": 5}, {"kind": "scalar", "path": "cases.case_judicial_officer_raw", "count": 5}, {"kind": "scalar", "path": "cases.case_judicial_officer_norm", "count": 5}, {"kind": "scalar", "path": "cases.case_judicial_officer_id", "count": 5}, {"kind": "object", "path": "cases.criminal_charges", "count": 5}, {"kind": "scalar", "path": "cases.criminal_charges.charge_1", "count": 5}, {"kind": "scalar", "path": "cases.criminal_charges.charge_1_statute", "count": 5}, {"kind": "scalar", "path": "cases.criminal_charges.charge_1_date", "count": 5}, {"kind": "scalar", "path": "cases.criminal_charges.charge_1_disposition", "count": 5}, {"kind": "object", "path": "cases.mcro_source", "count": 5}, {"kind": "scalar", "path": "cases.mcro_source.search_date_from", "count": 5}, {"kind": "scalar", "path": "cases.mcro_source.search_date_to", "count": 5}, {"kind": "scalar", "path": "cases.mcro_source.search_executed", "count": 5}, {"kind": "scalar", "path": "cases.mcro_source.search_executed_string", "count": 5}, {"kind": "scalar", "path": "cases.mcro_source.search_total_number", "count": 5}, {"kind": "scalar", "path": "cases.mcro_source.search_result_number", "count": 5}, {"kind": "scalar", "path": "cases.mcro_source.html_filename", "count": 5}, {"kind": "scalar", "path": "cases.mcro_source.pdf_filename", "count": 5}, {"kind": "scalar", "path": "cases.mcro_source.pdf_url", "count": 5}, {"kind": "scalar", "path": "cases.mcro_source.pdf_evidence_uid", "count": 5}, {"kind": "scalar", "path": "cases.criminal_charges.charge_2", "count": 3}, {"kind": "scalar", "path": "cases.criminal_charges.charge_2_statute", "count": 3}, {"kind": "scalar", "path": "cases.criminal_charges.charge_2_date", "count": 3}, {"kind": "scalar", "path": "cases.criminal_charges.charge_2_disposition", "count": 3}, {"kind": "scalar", "path": "cases.criminal_charges.charge_1_level_of_sentence", "count": 3}, {"kind": "scalar", "path": "cases.criminal_charges.charge_1_level", "count": 2}, {"kind": "scalar", "path": "cases.criminal_charges.charge_2_level", "count": 2}, {"kind": "scalar", "path": "hearings.respondent_name", "count": 1}, {"kind": "scalar", "path": "total_cases_unique", "count": 1}, {"kind": "array", "path": "cases[]", "count": 1}, {"kind": "scalar", "path": "cases.criminal_charges.charge_2_level_of_sentence", "count": 1}], "files_scanned": [{"file": "/home/matt1up/DB/query_ndjson/source_000.ndjson", "lines_scanned": 4}, {"file": "/home/matt1up/DB/query_ndjson/source_001.ndjson", "lines_scanned": 10}], "top_level_keys": [["search_category", 14], ["search_locations", 14], ["source_files", 14], ["total_html_files", 14], ["me_filename", 14], ["total_pdf_files", 14], ["search_type", 14], ["source_set_id", 14], ["total_hearings_unique", 13], ["hearings", 13], ["case_set_id", 11], ["search_judicial_officer_norm", 9], ["search_judicial_officer_id", 9], ["search_judicial_officer", 9], ["search_judicial_officer_raw", 9], ["search_attorney_raw", 5], ["search_attorney_norm", 5], ["search_attorney", 5], ["search_attorney_id", 5], ["total_cases_unique", 1], ["cases", 1]], "top_array_paths": [{"path": "source_files[]", "count": 14}, {"path": "hearings[]", "count": 13}, {"path": "cases[]", "count": 1}]} | {"table_sizes": [{"bytes": 13695479, "ncols": 23, "table": "source_hearings"}, {"bytes": 1390682, "ncols": 43, "table": "source_cases"}, {"bytes": 350197, "ncols": 18, "table": "source_files"}, {"bytes": 4071, "ncols": 18, "table": "source"}], "tables_found": ["source", "source_cases", "source_files", "source_hearings"], "empty_or_noheader_csvs": []} hashpack | {"top_paths": [{"kind": "scalar", "path": "rows.rows.tags", "count": 60114}, {"kind": "object", "path": "fingerprints.streams.rows", "count": 21255}, {"kind": "scalar", "path": "fingerprints.streams.rows.category", "count": 21255}, {"kind": "scalar", "path": "fingerprints.streams.rows.decoded_len", "count": 21255}, {"kind": "scalar", "path": "fingerprints.streams.rows.obj_ref", "count": 21255}, {"kind": "scalar", "path": "fingerprints.streams.rows.decoded_sha256", "count": 20403}, {"kind": "object", "path": "rows.rows", "count": 19575}, {"kind": "scalar", "path": "rows.rows.page_num", "count": 19575}, {"kind": "scalar", "path": "rows.rows.text_clean", "count": 19575}, {"kind": "scalar", "path": "rows.rows.row_sha256", "count": 19575}, {"kind": "array", "path": "rows.rows.tags[]", "count": 19575}, {"kind": "scalar", "path": "rows.rows.row_in_page", "count": 19574}, {"kind": "scalar", "path": "fingerprints.streams.rows.stream_dict_sha256", "count": 19035}, {"kind": "scalar", "path": "fingerprints.streams.rows.filters", "count": 16683}, {"kind": "object", "path": "fingerprints.page_content_streams", "count": 13807}, {"kind": "scalar", "path": "fingerprints.page_content_streams.content_index", "count": 13807}, {"kind": "scalar", "path": "fingerprints.page_content_streams.decoded_len", "count": 13807}, {"kind": "scalar", "path": "fingerprints.page_content_streams.decoded_sha256", "count": 13807}, {"kind": "scalar", "path": "fingerprints.page_content_streams.page_num", "count": 13807}, {"kind": "scalar", "path": "fingerprints.streams.rows.type", "count": 7220}, {"kind": "scalar", "path": "fingerprints.streams.rows.subtype", "count": 5305}, {"kind": "object", "path": "$", "count": 4251}, {"kind": "scalar", "path": "me_filename", "count": 4251}, {"kind": "scalar", "path": "pdf_filename", "count": 4251}, {"kind": "scalar", "path": "file_sha256", "count": 4251}, {"kind": "scalar", "path": "size_bytes", "count": 4251}, {"kind": "scalar", "path": "case_id", "count": 4251}, {"kind": "scalar", "path": "case_uid", "count": 4251}, {"kind": "scalar", "path": "evidence_uid", "count": 4251}, {"kind": "scalar", "path": "filing_type", "count": 4251}, {"kind": "scalar", "path": "filing_date", "count": 4251}, {"kind": "scalar", "path": "n_pages", "count": 4251}, {"kind": "object", "path": "inputs", "count": 4251}, {"kind": "scalar", "path": "inputs.fingerprints_json", "count": 4251}, {"kind": "scalar", "path": "inputs.children_json", "count": 4251}, {"kind": "object", "path": "fingerprints", "count": 4251}, {"kind": "object", "path": "fingerprints.doc", "count": 4251}, {"kind": "scalar", "path": "fingerprints.doc.n_pages", "count": 4251}, {"kind": "scalar", "path": "fingerprints.doc.pdfinfo_rc", "count": 4251}, {"kind": "scalar", "path": "fingerprints.doc.pdfinfo_stdout_sha256", "count": 4251}, {"kind": "scalar", "path": "fingerprints.doc.pdfsig_rc", "count": 4251}, {"kind": "scalar", "path": "fingerprints.doc.pdfsig_stdout_sha256", "count": 4251}, {"kind": "scalar", "path": "fingerprints.eof_count", "count": 4251}, {"kind": "scalar", "path": "fingerprints.extraction_ts", "count": 4251}, {"kind": "array", "path": "fingerprints.page_content_streams[]", "count": 4251}, {"kind": "scalar", "path": "fingerprints.pdf_relpath", "count": 4251}, {"kind": "object", "path": "fingerprints.streams", "count": 4251}, {"kind": "object", "path": "fingerprints.streams.category_counts", "count": 4251}, {"kind": "scalar", "path": "fingerprints.streams.category_counts.other_stream", "count": 4251}, {"kind": "array", "path": "fingerprints.streams.rows[]", "count": 4251}, {"kind": "object", "path": "fingerprints.text", "count": 4251}, {"kind": "scalar", "path": "fingerprints.text.mode", "count": 4251}, {"kind": "scalar", "path": "fingerprints.text.text_sha256", "count": 4251}, {"kind": "object", "path": "fingerprints.tools", "count": 4251}, {"kind": "scalar", "path": "fingerprints.tools.pdfinfo_available", "count": 4251}, {"kind": "scalar", "path": "fingerprints.tools.pdfsig_available", "count": 4251}, {"kind": "object", "path": "fingerprints.xmp", "count": 4251}, {"kind": "scalar", "path": "doc_sha256", "count": 4251}, {"kind": "scalar", "path": "fingerprints.streams.category_counts.xobject_image", "count": 4250}, {"kind": "scalar", "path": "fingerprints.streams.category_counts.xobject_form", "count": 4247}, {"kind": "scalar", "path": "fingerprints.doc.trailer_id_0", "count": 4240}, {"kind": "scalar", "path": "fingerprints.doc.trailer_id_1", "count": 4240}, {"kind": "scalar", "path": "cluster_id", "count": 4222}, {"kind": "scalar", "path": "cluster_name", "count": 4222}, {"kind": "scalar", "path": "case_event_uid", "count": 4220}, {"kind": "scalar", "path": "fingerprints.streams.category_counts.metadata_stream", "count": 4065}, {"kind": "scalar", "path": "fingerprints.xmp.xmp_stream_sha256", "count": 4065}, {"kind": "scalar", "path": "inputs.rows_json", "count": 3934}, {"kind": "object", "path": "rows", "count": 3934}, {"kind": "object", "path": "rows.meta", "count": 3934}, {"kind": "scalar", "path": "rows.meta.pages", "count": 3934}, {"kind": "array", "path": "rows.rows[]", "count": 3934}, {"kind": "object", "path": "rows.stats", "count": 3934}, {"kind": "scalar", "path": "rows.stats.pages_total", "count": 3934}, {"kind": "scalar", "path": "rows.stats.rows_total", "count": 3934}, {"kind": "scalar", "path": "rows.stats.rows_body", "count": 3934}, {"kind": "scalar", "path": "rows.stats.rows_header", "count": 3934}, {"kind": "scalar", "path": "rows.stats.rows_footer", "count": 3934}, {"kind": "scalar", "path": "rows.stats.unique_row_sha256_body", "count": 3934}, {"kind": "scalar", "path": "defendant_name", "count": 3362}, {"kind": "scalar", "path": "rows.meta.case_number", "count": 3362}, {"kind": "scalar", "path": "rows.meta.defendant", "count": 3362}, {"kind": "scalar", "path": "rows.meta.filing_type", "count": 3362}, {"kind": "scalar", "path": "rows.meta.filing_date", "count": 3362}, {"kind": "scalar", "path": "fingerprints.streams.category_counts.object_stream", "count": 2141}, {"kind": "scalar", "path": "fingerprints.streams.rows.error", "count": 852}, {"kind": "object", "path": "fingerprints.outline.outline_lines", "count": 823}, {"kind": "scalar", "path": "fingerprints.outline.outline_lines.outline_level", "count": 823}, {"kind": "scalar", "path": "fingerprints.outline.outline_lines.outline_page_1based", "count": 823}, {"kind": "scalar", "path": "fingerprints.outline.outline_lines.outline_title", "count": 823}, {"kind": "scalar", "path": "rows.meta.name", "count": 572}, {"kind": "scalar", "path": "rows.meta.size_bytes", "count": 572}, {"kind": "scalar", "path": "rows.meta.sha256", "count": 572}, {"kind": "object", "path": "fingerprints.outline", "count": 304}, {"kind": "scalar", "path": "fingerprints.outline.outline_line_count", "count": 304}, {"kind": "array", "path": "fingerprints.outline.outline_lines[]", "count": 304}, {"kind": "scalar", "path": "fingerprints.outline.outline_sha256", "count": 304}, {"kind": "scalar", "path": "fingerprints.doc.pdfsig_stderr", "count": 10}, {"kind": "scalar", "path": "fingerprints.doc.pdfinfo_stderr", "count": 3}], "files_scanned": [{"file": "/home/matt1up/DB/query_ndjson/hashpack_000.ndjson", "lines_scanned": 40}, {"file": "/home/matt1up/DB/query_ndjson/hashpack_001.ndjson", "lines_scanned": 23}, {"file": "/home/matt1up/DB/query_ndjson/hashpack_002.ndjson", "lines_scanned": 8}, {"file": "/home/matt1up/DB/query_ndjson/hashpack_003.ndjson", "lines_scanned": 156}, {"file": "/home/matt1up/DB/query_ndjson/hashpack_004.ndjson", "lines_scanned": 772}, {"file": "/home/matt1up/DB/query_ndjson/hashpack_005.ndjson", "lines_scanned": 677}, {"file": "/home/matt1up/DB/query_ndjson/hashpack_006.ndjson", "lines_scanned": 651}, {"file": "/home/matt1up/DB/query_ndjson/hashpack_007.ndjson", "lines_scanned": 624}, {"file": "/home/matt1up/DB/query_ndjson/hashpack_008.ndjson", "lines_scanned": 628}, {"file": "/home/matt1up/DB/query_ndjson/hashpack_009.ndjson", "lines_scanned": 307}, {"file": "/home/matt1up/DB/query_ndjson/hashpack_010.ndjson", "lines_scanned": 365}], "top_level_keys": [["size_bytes", 4251], ["fingerprints", 4251], ["case_id", 4251], ["me_filename", 4251], ["inputs", 4251], ["filing_type", 4251], ["filing_date", 4251], ["evidence_uid", 4251], ["case_uid", 4251], ["file_sha256", 4251], ["pdf_filename", 4251], ["doc_sha256", 4251], ["n_pages", 4251], ["cluster_name", 4222], ["cluster_id", 4222], ["case_event_uid", 4220], ["rows", 3934], ["defendant_name", 3362]], "top_array_paths": [{"path": "rows.rows.tags[]", "count": 19575}, {"path": "fingerprints.page_content_streams[]", "count": 4251}, {"path": "fingerprints.streams.rows[]", "count": 4251}, {"path": "rows.rows[]", "count": 3934}, {"path": "fingerprints.outline.outline_lines[]", "count": 304}]} | {"table_sizes": [{"bytes": 104425042, "ncols": 6, "table": "hashpack_rows"}, {"bytes": 94284551, "ncols": 19, "table": "hashpack_streams_rows"}, {"bytes": 67692176, "ncols": 4, "table": "hashpack_rows_tags"}, {"bytes": 6230953, "ncols": 10, "table": "hashpack_page_content_streams"}, {"bytes": 4601515, "ncols": 31, "table": "hashpack"}, {"bytes": 180890, "ncols": 5, "table": "hashpack_outline_lines"}], "tables_found": ["hashpack", "hashpack_outline_lines", "hashpack_page_content_streams", "hashpack_rows", "hashpack_rows_tags", "hashpack_streams_rows"], "empty_or_noheader_csvs": []} parents | {"top_paths": [{"kind": "object", "path": "interim_conditions.conditions", "count": 17155}, {"kind": "scalar", "path": "interim_conditions.conditions.text", "count": 17155}, {"kind": "object", "path": "case_events", "count": 14502}, {"kind": "scalar", "path": "case_events.date", "count": 14502}, {"kind": "scalar", "path": "case_events.event_name", "count": 14502}, {"kind": "scalar", "path": "case_events.has_pdf", "count": 14502}, {"kind": "scalar", "path": "case_events.event_index", "count": 14502}, {"kind": "scalar", "path": "case_events.case_event_uid", "count": 14502}, {"kind": "array", "path": "case_events.evidence_uids[]", "count": 14502}, {"kind": "array", "path": "case_events.attorneys[]", "count": 14412}, {"kind": "array", "path": "case_events.judicial_officers[]", "count": 14396}, {"kind": "object", "path": "hearings.previous", "count": 12914}, {"kind": "scalar", "path": "hearings.previous.date", "count": 12914}, {"kind": "scalar", "path": "hearings.previous.time", "count": 12914}, {"kind": "scalar", "path": "hearings.previous.hearing_type", "count": 12914}, {"kind": "scalar", "path": "hearings.previous.hearing_index", "count": 12914}, {"kind": "scalar", "path": "hearings.previous.date_pretty", "count": 12909}, {"kind": "array", "path": "hearings.previous.notes[]", "count": 12909}, {"kind": "scalar", "path": "hearings.previous.notes", "count": 12867}, {"kind": "scalar", "path": "hearings.previous.judicial_officer", "count": 12043}, {"kind": "scalar", "path": "hearings.previous.judicial_officer_raw", "count": 12041}, {"kind": "scalar", "path": "hearings.previous.judicial_officer_norm", "count": 12033}, {"kind": "scalar", "path": "hearings.previous.judicial_officer_id", "count": 12033}, {"kind": "scalar", "path": "hearings.previous.location", "count": 11861}, {"kind": "object", "path": "cluster.cases", "count": 10823}, {"kind": "scalar", "path": "cluster.cases.case_id", "count": 10823}, {"kind": "scalar", "path": "cluster.cases.case_type", "count": 10823}, {"kind": "scalar", "path": "cluster.cases.has_docket", "count": 10823}, {"kind": "scalar", "path": "cluster.cases.has_case_docs", "count": 10823}, {"kind": "scalar", "path": "case_events.docket_index", "count": 10270}, {"kind": "scalar", "path": "hearings.previous.result", "count": 9567}, {"kind": "object", "path": "warrants.statuses", "count": 6718}, {"kind": "scalar", "path": "warrants.statuses.date", "count": 6718}, {"kind": "scalar", "path": "warrants.statuses.status", "count": 6718}, {"kind": "scalar", "path": "warrants.statuses.time", "count": 6716}, {"kind": "object", "path": "attorneys.prosecution.active", "count": 6621}, {"kind": "scalar", "path": "attorneys.prosecution.active.name", "count": 6621}, {"kind": "scalar", "path": "attorneys.prosecution.active.is_lead", "count": 6621}, {"kind": "scalar", "path": "attorneys.prosecution.active.attorney_raw", "count": 6621}, {"kind": "scalar", "path": "attorneys.prosecution.active.attorney_norm", "count": 6621}, {"kind": "scalar", "path": "attorneys.prosecution.active.attorney_id", "count": 6621}, {"kind": "scalar", "path": "case_set", "count": 6219}, {"kind": "object", "path": "interim_conditions", "count": 5728}, {"kind": "scalar", "path": "interim_conditions.date", "count": 5728}, {"kind": "scalar", "path": "interim_conditions.judicial_officer", "count": 5728}, {"kind": "array", "path": "interim_conditions.conditions[]", "count": 5728}, {"kind": "scalar", "path": "interim_conditions.interim_index", "count": 5728}, {"kind": "scalar", "path": "interim_conditions.judicial_officer_raw", "count": 5722}, {"kind": "scalar", "path": "interim_conditions.judicial_officer_norm", "count": 5722}, {"kind": "scalar", "path": "interim_conditions.judicial_officer_id", "count": 5722}, {"kind": "scalar", "path": "interim_conditions.expiration_date", "count": 5450}, {"kind": "object", "path": "dispositions.charges", "count": 5399}, {"kind": "scalar", "path": "dispositions.charges.count", "count": 5399}, {"kind": "scalar", "path": "interim_conditions.conditions.amount", "count": 5342}, {"kind": "scalar", "path": "dispositions.charges.offense_date", "count": 5309}, {"kind": "scalar", "path": "dispositions.charges.statute", "count": 5269}, {"kind": "scalar", "path": "dispositions.charges.level_of_charge", "count": 5269}, {"kind": "scalar", "path": "dispositions.charges.condition_adult", "count": 5161}, {"kind": "object", "path": "case_events.judicial_officers", "count": 4989}, {"kind": "scalar", "path": "case_events.judicial_officers.judicial_officer_raw", "count": 4989}, {"kind": "scalar", "path": "case_events.judicial_officers.judicial_officer_norm", "count": 4989}, {"kind": "scalar", "path": "case_events.judicial_officers.judicial_officer_id", "count": 4989}, {"kind": "scalar", "path": "case_events.judicial_officer", "count": 4985}, {"kind": "object", "path": "dispositions", "count": 4943}, {"kind": "scalar", "path": "dispositions.date", "count": 4943}, {"kind": "scalar", "path": "dispositions.date_pretty", "count": 4943}, {"kind": "scalar", "path": "dispositions.disposition_type", "count": 4943}, {"kind": "scalar", "path": "dispositions.charges.monitoring_adult", "count": 4785}, {"kind": "object", "path": "attorneys.defense.inactive", "count": 4468}, {"kind": "scalar", "path": "attorneys.defense.inactive.name", "count": 4468}, {"kind": "scalar", "path": "attorneys.defense.inactive.attorney_raw", "count": 4468}, {"kind": "scalar", "path": "attorneys.defense.inactive.attorney_norm", "count": 4468}, {"kind": "scalar", "path": "attorneys.defense.inactive.attorney_id", "count": 4468}, {"kind": "scalar", "path": "dispositions.charges.local_confinement", "count": 4179}, {"kind": "scalar", "path": "case_events.page_count", "count": 4104}, {"kind": "scalar", "path": "dispositions.charges.charge_name", "count": 3922}, {"kind": "object", "path": "mcro.case_id_source", "count": 3919}, {"kind": "scalar", "path": "mcro.case_id_source.pdf_filename", "count": 3919}, {"kind": "scalar", "path": "mcro.case_id_source.pdf_url", "count": 3919}, {"kind": "array", "path": "dispositions.charges[]", "count": 3596}, {"kind": "scalar", "path": "dispositions.judicial_officer", "count": 3595}, {"kind": "scalar", "path": "dispositions.judicial_officer_raw", "count": 3595}, {"kind": "scalar", "path": "dispositions.judicial_officer_norm", "count": 3595}, {"kind": "scalar", "path": "dispositions.judicial_officer_id", "count": 3595}, {"kind": "scalar", "path": "dispositions.charges.disposition", "count": 3492}, {"kind": "scalar", "path": "dispositions.charges.community_of_offense", "count": 3492}, {"kind": "scalar", "path": "dispositions.charges.law_enforcement_agency", "count": 3492}, {"kind": "scalar", "path": "dispositions.charges.prosecuting_agency", "count": 3492}, {"kind": "object", "path": "warrants", "count": 3403}, {"kind": "scalar", "path": "warrants.warrant_type", "count": 3403}, {"kind": "scalar", "path": "warrants.judicial_officer", "count": 3403}, {"kind": "array", "path": "warrants.statuses[]", "count": 3403}, {"kind": "scalar", "path": "warrants.judicial_officer_raw", "count": 3398}, {"kind": "scalar", "path": "warrants.judicial_officer_norm", "count": 3398}, {"kind": "scalar", "path": "warrants.judicial_officer_id", "count": 3398}, {"kind": "object", "path": "charges", "count": 3388}, {"kind": "scalar", "path": "charges.statute", "count": 3388}, {"kind": "scalar", "path": "charges.level_of_charge", "count": 3388}, {"kind": "scalar", "path": "charges.count", "count": 3387}, {"kind": "scalar", "path": "charges.offense_date", "count": 3387}, {"kind": "scalar", "path": "charges.community_of_offense", "count": 3387}, {"kind": "scalar", "path": "charges.law_enforcement_agency", "count": 3387}, {"kind": "scalar", "path": "charges.prosecuting_agency", "count": 3387}, {"kind": "object", "path": "attorneys.defense.active", "count": 3378}, {"kind": "scalar", "path": "attorneys.defense.active.name", "count": 3378}, {"kind": "scalar", "path": "attorneys.defense.active.is_lead", "count": 3378}, {"kind": "scalar", "path": "attorneys.defense.active.attorney_raw", "count": 3378}, {"kind": "scalar", "path": "attorneys.defense.active.attorney_norm", "count": 3378}, {"kind": "scalar", "path": "attorneys.defense.active.attorney_id", "count": 3378}, {"kind": "object", "path": "warrants.bond_bail", "count": 3371}, {"kind": "scalar", "path": "related_cases", "count": 3057}, {"kind": "scalar", "path": "charges.charge_name", "count": 2964}, {"kind": "object", "path": "$", "count": 2903}, {"kind": "scalar", "path": "me_filename", "count": 2903}, {"kind": "scalar", "path": "case_id", "count": 2903}, {"kind": "scalar", "path": "case_type", "count": 2903}, {"kind": "scalar", "path": "case_title", "count": 2903}, {"kind": "scalar", "path": "case_location", "count": 2903}, {"kind": "scalar", "path": "case_status", "count": 2903}, {"kind": "scalar", "path": "date_filed", "count": 2903}, {"kind": "scalar", "path": "case_year_filed", "count": 2903}, {"kind": "scalar", "path": "has_case_docs_flag", "count": 2903}, {"kind": "object", "path": "cluster", "count": 2903}, {"kind": "scalar", "path": "cluster.id", "count": 2903}, {"kind": "scalar", "path": "cluster.size", "count": 2903}, {"kind": "scalar", "path": "cluster.name", "count": 2903}, {"kind": "array", "path": "cluster.cases[]", "count": 2903}, {"kind": "array", "path": "case_set[]", "count": 2903}, {"kind": "object", "path": "mcro", "count": 2903}, {"kind": "array", "path": "mcro.search_names[]", "count": 2903}, {"kind": "scalar", "path": "mcro.search_type", "count": 2903}, {"kind": "scalar", "path": "mcro.search_criteria", "count": 2903}, {"kind": "scalar", "path": "mcro.search_executed", "count": 2903}, {"kind": "scalar", "path": "mcro.search_date", "count": 2903}, {"kind": "scalar", "path": "mcro.search_date_time", "count": 2903}, {"kind": "scalar", "path": "mcro.search_date_sort", "count": 2903}, {"kind": "scalar", "path": "mcro.pdf_docket_sha256", "count": 2903}, {"kind": "scalar", "path": "mcro.pdf_docket_size_bytes", "count": 2903}, {"kind": "scalar", "path": "mcro.pdf_docket_last_modified_time", "count": 2903}, {"kind": "array", "path": "mcro.case_id_source[]", "count": 2903}, {"kind": "array", "path": "case_events[]", "count": 2903}, {"kind": "object", "path": "hearings", "count": 2903}, {"kind": "array", "path": "hearings.upcoming[]", "count": 2903}, {"kind": "array", "path": "hearings.previous[]", "count": 2903}, {"kind": "scalar", "path": "case_uid", "count": 2903}, {"kind": "scalar", "path": "cluster_id", "count": 2903}, {"kind": "scalar", "path": "cluster_name", "count": 2903}, {"kind": "scalar", "path": "warrants.bond_bail.bond_type", "count": 2827}, {"kind": "scalar", "path": "warrants.bond_bail.bond_amount", "count": 2827}, {"kind": "array", "path": "dispositions[]", "count": 2814}, {"kind": "scalar", "path": "mcro.search_names", "count": 2521}, {"kind": "object", "path": "financial_information.transactions", "count": 2379}, {"kind": "scalar", "path": "financial_information.transactions.transaction_number", "count": 2379}, {"kind": "scalar", "path": "financial_information.transactions.date_pretty", "count": 2379}, {"kind": "scalar", "path": "financial_information.transactions.type", "count": 2379}, {"kind": "scalar", "path": "financial_information.transactions.amount", "count": 2379}, {"kind": "scalar", "path": "charges.disposition", "count": 2297}, {"kind": "scalar", "path": "charges.disposition_date", "count": 2297}, {"kind": "array", "path": "warrants[]", "count": 2116}, {"kind": "array", "path": "bond_bail_activity[]", "count": 2116}, {"kind": "array", "path": "financial_information[]", "count": 2116}, {"kind": "scalar", "path": "defendant_name", "count": 2078}, {"kind": "object", "path": "attorneys", "count": 2078}, {"kind": "object", "path": "attorneys.prosecution", "count": 2078}, {"kind": "array", "path": "attorneys.prosecution.active[]", "count": 2078}, {"kind": "array", "path": "attorneys.prosecution.inactive[]", "count": 2078}, {"kind": "object", "path": "attorneys.defense", "count": 2078}, {"kind": "array", "path": "attorneys.defense.active[]", "count": 2078}, {"kind": "array", "path": "attorneys.defense.inactive[]", "count": 2078}, {"kind": "object", "path": "attorneys.other"}, {"kind": "array", "path": "attorneys.other.active[]", "count": 2078}, {"kind": "array", "path": "attorneys.other.inactive[]", "count": 2078}, {"kind": "array", "path": "charges[]", "count": 2078}, {"kind": "array", "path": "interim_conditions[]", "count": 2078}, {"kind": "scalar", "path": "defendant_dob", "count": 2077}, {"kind": "scalar", "path": "defendant_location", "count": 2077}, {"kind": "scalar", "path": "dispositions.charges.commit_to_commissioner_of_corrections_adult", "count": 1895}, {"kind": "scalar", "path": "mcro.search_from_date", "count": 1717}, {"kind": "scalar", "path": "mcro.search_to_date", "count": 1717}, {"kind": "array", "path": "related_cases[]", "count": 1668}, {"kind": "scalar", "path": "judicial_officer", "count": 1612}, {"kind": "scalar", "path": "judicial_officer_raw", "count": 1565}, {"kind": "scalar", "path": "judicial_officer_norm", "count": 1565}, {"kind": "scalar", "path": "judicial_officer_id", "count": 1565}, {"kind": "scalar", "path": "charges.additional_statutes", "count": 1177}, {"kind": "scalar", "path": "dispositions.charges.level_of_sentence", "count": 1168}, {"kind": "object", "path": "attorneys.prosecution.inactive", "count": 1159}, {"kind": "scalar", "path": "attorneys.prosecution.inactive.name", "count": 1159}, {"kind": "scalar", "path": "attorneys.prosecution.inactive.attorney_raw", "count": 1159}, {"kind": "scalar", "path": "attorneys.prosecution.inactive.attorney_norm", "count": 1159}, {"kind": "scalar", "path": "attorneys.prosecution.inactive.attorney_id", "count": 1159}, {"kind": "array", "path": "dispositions.charges.condition_adult[]", "count": 1150}, {"kind": "object", "path": "dispositions.commitment", "count": 1094}, {"kind": "scalar", "path": "dispositions.commitment.facility", "count": 1094}, {"kind": "scalar", "path": "dispositions.commitment.condition", "count": 1094}, {"kind": "scalar", "path": "dispositions.commitment.report_date", "count": 1094}, {"kind": "scalar", "path": "dispositions.commitment.report_date_pretty", "count": 1094}, {"kind": "scalar", "path": "petitioner.attorneys_active", "count": 1091}, {"kind": "object", "path": "petitioner.attorneys_active_meta", "count": 1091}, {"kind": "scalar", "path": "petitioner.attorneys_active_meta.attorney_raw", "count": 1091}, {"kind": "scalar", "path": "petitioner.attorneys_active_meta.attorney_norm", "count": 1091}, {"kind": "scalar", "path": "petitioner.attorneys_active_meta.attorney_id", "count": 1091}, {"kind": "scalar", "path": "petitioner.attorneys_active_meta.is_lead", "count": 1091}, {"kind": "scalar", "path": "dispositions.charges.concurrent_consecutive", "count": 1091}, {"kind": "object", "path": "financial_information", "count": 1030}, {"kind": "object", "path": "financial_information.summary", "count": 1030}, {"kind": "scalar", "path": "financial_information.summary.fines_and_fees", "count": 1030}, {"kind": "scalar", "path": "financial_information.summary.restitution", "count": 1030}, {"kind": "scalar", "path": "financial_information.summary.total_payments_and_credits", "count": 1030}, {"kind": "scalar", "path": "financial_information.summary.current_balance_as_of", "count": 1030}, {"kind": "scalar", "path": "financial_information.summary.current_balance", "count": 1030}, {"kind": "array", "path": "financial_information.transactions[]", "count": 1018}, {"kind": "scalar", "path": "dispositions.charges.additional_statutes", "count": 1010}, {"kind": "scalar", "path": "dispositions.charges.amended_charge", "count": 964}, {"kind": "array", "path": "dispositions.charges.monitoring_adult[]", "count": 957}, {"kind": "scalar", "path": "financial_information.account_name", "count": 946}, {"kind": "object", "path": "bond_bail_activity.statuses", "count": 924}, {"kind": "scalar", "path": "bond_bail_activity.statuses.date", "count": 924}, {"kind": "scalar", "path": "bond_bail_activity.statuses.status", "count": 924}, {"kind": "scalar", "path": "bond_bail_activity.statuses.description", "count": 924}, {"kind": "scalar", "path": "financial_information.defendant_name", "count": 917}, {"kind": "array", "path": "dispositions.charges.local_confinement[]", "count": 904}, {"kind": "scalar", "path": "hearings.upcoming.notes", "count": 903}, {"kind": "object", "path": "hearings.upcoming", "count": 863}, {"kind": "scalar", "path": "hearings.upcoming.date", "count": 863}, {"kind": "scalar", "path": "hearings.upcoming.time", "count": 863}, {"kind": "scalar", "path": "hearings.upcoming.hearing_type", "count": 863}, {"kind": "scalar", "path": "hearings.upcoming.hearing_index", "count": 863}, {"kind": "scalar", "path": "hearings.upcoming.date_pretty", "count": 862}, {"kind": "array", "path": "hearings.upcoming.notes[]", "count": 862}, {"kind": "scalar", "path": "case_events.party", "count": 844}, {"kind": "scalar", "path": "respondent_name", "count": 825}, {"kind": "object", "path": "petitioner", "count": 821}, {"kind": "scalar", "path": "petitioner.name", "count": 821}, {"kind": "scalar", "path": "hearings.upcoming.judicial_officer", "count": 820}, {"kind": "scalar", "path": "hearings.upcoming.judicial_officer_raw", "count": 820}, {"kind": "scalar", "path": "hearings.upcoming.judicial_officer_norm", "count": 820}, {"kind": "scalar", "path": "hearings.upcoming.judicial_officer_id", "count": 820}, {"kind": "object", "path": "respondent", "count": 814}, {"kind": "scalar", "path": "respondent.name", "count": 814}, {"kind": "scalar", "path": "respondent.address", "count": 814}, {"kind": "scalar", "path": "respondent.attorneys_active", "count": 810}, {"kind": "object", "path": "respondent.attorneys_active_meta", "count": 810}, {"kind": "scalar", "path": "respondent.attorneys_active_meta.attorney_raw", "count": 810}, {"kind": "scalar", "path": "respondent.attorneys_active_meta.attorney_norm", "count": 810}, {"kind": "scalar", "path": "respondent.attorneys_active_meta.attorney_id", "count": 810}, {"kind": "scalar", "path": "respondent.attorneys_active_meta.is_lead", "count": 810}, {"kind": "array", "path": "respondent.attorneys_inactive[]", "count": 803}, {"kind": "array", "path": "respondent.attorneys_inactive_meta[]", "count": 803}, {"kind": "array", "path": "petitioner.attorneys_active[]", "count": 799}], "files_scanned": [{"file": "/home/matt1up/DB/query_ndjson/parents_000.ndjson", "lines_scanned": 389}, {"file": "/home/matt1up/DB/query_ndjson/parents_001.ndjson", "lines_scanned": 440}, {"file": "/home/matt1up/DB/query_ndjson/parents_002.ndjson", "lines_scanned": 502}, {"file": "/home/matt1up/DB/query_ndjson/parents_003.ndjson", "lines_scanned": 657}, {"file": "/home/matt1up/DB/query_ndjson/parents_004.ndjson", "lines_scanned": 915}], "top_level_keys": [["case_uid", 2903], ["case_id", 2903], ["cluster_name", 2903], ["hearings", 2903], ["case_events", 2903], ["cluster", 2903], ["date_filed", 2903], ["case_location", 2903], ["case_set", 2903], ["case_type", 2903], ["case_title", 2903], ["case_status", 2903], ["has_case_docs_flag", 2903], ["case_year_filed", 2903], ["cluster_id", 2903], ["mcro", 2903], ["me_filename", 2903], ["dispositions", 2814], ["bond_bail_activity", 2116], ["financial_information", 2116], ["warrants", 2116], ["charges", 2078], ["defendant_name", 2078], ["interim_conditions", 2078], ["attorneys", 2078], ["defendant_dob", 2077], ["defendant_location", 2077], ["related_cases", 1668], ["judicial_officer", 1612], ["judicial_officer_norm", 1565], ["judicial_officer_id", 1565], ["judicial_officer_raw", 1565], ["respondent_name", 825], ["petitioner", 821], ["respondent", 814], ["case_type_civil", 787], ["person_subject_to_guardianship", 25], ["guardian", 14], ["case_assignments", 12], ["professional_guardian", 3], ["emergency_guardian", 3], ["professional_successor_guardian", 2], ["person_subject_to_conservatorship", 2], ["successor_guardian", 2], ["demandant", 1], ["testator_decedent", 1], ["doc_set", 1], ["ward", 1], ["conservator", 1], ["professional_conservator", 1], ["decedent", 1], ["personal_representative", 1]], "top_array_paths": [{"path": "case_events.evidence_uids[]", "count": 14502}, {"path": "case_events.attorneys[]", "count": 14412}, {"path": "case_events.judicial_officers[]", "count": 14396}, {"path": "hearings.previous.notes[]", "count": 12909}, {"path": "interim_conditions.conditions[]", "count": 5728}, {"path": "dispositions.charges[]", "count": 3596}, {"path": "warrants.statuses[]", "count": 3403}, {"path": "cluster.cases[]", "count": 2903}, {"path": "case_set[]", "count": 2903}, {"path": "mcro.search_names[]", "count": 2903}, {"path": "mcro.case_id_source[]", "count": 2903}, {"path": "case_events[]", "count": 2903}, {"path": "hearings.upcoming[]", "count": 2903}, {"path": "hearings.previous[]", "count": 2903}, {"path": "dispositions[]", "count": 2814}, {"path": "warrants[]", "count": 2116}, {"path": "bond_bail_activity[]", "count": 2116}, {"path": "financial_information[]", "count": 2116}, {"path": "attorneys.prosecution.active[]", "count": 2078}, {"path": "attorneys.prosecution.inactive[]", "count": 2078}, {"path": "attorneys.defense.active[]", "count": 2078}, {"path": "attorneys.defense.inactive[]", "count": 2078}, {"path": "attorneys.other.active[]", "count": 2078}, {"path": "attorneys.other.inactive[]", "count": 2078}, {"path": "charges[]", "count": 2078}, {"path": "interim_conditions[]", "count": 2078}, {"path": "related_cases[]", "count": 1668}, {"path": "dispositions.charges.condition_adult[]", "count": 1150}, {"path": "financial_information.transactions[]", "count": 1018}, {"path": "dispositions.charges.monitoring_adult[]", "count": 957}, {"path": "dispositions.charges.local_confinement[]", "count": 904}, {"path": "hearings.upcoming.notes[]", "count": 862}, {"path": "respondent.attorneys_inactive[]", "count": 803}, {"path": "respondent.attorneys_inactive_meta[]", "count": 803}, {"path": "petitioner.attorneys_active[]", "count": 799}, {"path": "petitioner.attorneys_active_meta[]", "count": 799}, {"path": "respondent.attorneys_active[]", "count": 797}, {"path": "respondent.attorneys_active_meta[]", "count": 797}, {"path": "petitioner.attorneys_inactive[]", "count": 792}, {"path": "petitioner.attorneys_inactive_meta[]", "count": 792}, {"path": "respondent.aliases[]", "count": 787}, {"path": "dispositions.charges.commit_to_commissioner_of_corrections_adult[]", "count": 656}, {"path": "warrants.bond_bail.options[]", "count": 544}, {"path": "dispositions.charges.concurrent_consecutive[]", "count": 473}, {"path": "bond_bail_activity.statuses[]", "count": 428}, {"path": "dispositions.charges.service_adult[]", "count": 135}, {"path": "dispositions.charges.level_of_sentence[]", "count": 98}, {"path": "person_subject_to_guardianship.attorneys_inactive[]", "count": 19}, {"path": "person_subject_to_guardianship.attorneys_inactive_meta[]", "count": 19}, {"path": "dispositions.charges.diversion_program_adult[]", "count": 18}, {"path": "case_assignments.previous[]", "count": 12}, {"path": "hearings.previous.judicial_officers[]", "count": 8}, {"path": "person_subject_to_guardianship.attorneys_active[]", "count": 7}, {"path": "person_subject_to_guardianship.attorneys_active_meta[]", "count": 7}, {"path": "hearings.previous.additional_actions[]", "count": 5}, {"path": "guardian.attorneys_active[]", "count": 5}, {"path": "guardian.attorneys_active_meta[]", "count": 5}, {"path": "guardian.attorneys_inactive[]", "count": 4}, {"path": "guardian.attorneys_inactive_meta[]", "count": 4}, {"path": "professional_guardian.attorneys_active[]", "count": 2}, {"path": "professional_guardian.attorneys_active_meta[]", "count": 2}, {"path": "person_subject_to_conservatorship.attorneys_active[]", "count": 2}, {"path": "person_subject_to_conservatorship.attorneys_active_meta[]", "count": 2}, {"path": "charges.additional_statutes[]", "count": 1}, {"path": "hearings.upcoming.additional_actions[]", "count": 1}, {"path": "doc_set[]", "count": 1}, {"path": "ward.attorneys_inactive[]", "count": 1}, {"path": "ward.attorneys_inactive_meta[]", "count": 1}, {"path": "conservator.attorneys_active[]", "count": 1}, {"path": "conservator.attorneys_active_meta[]", "count": 1}, {"path": "person_subject_to_conservatorship.attorneys_inactive[]", "count": 1}, {"path": "person_subject_to_conservatorship.attorneys_inactive_meta[]", "count": 1}, {"path": "emergency_guardian.attorneys_active[]", "count": 1}, {"path": "emergency_guardian.attorneys_active_meta[]", "count": 1}, {"path": "successor_guardian.attorneys_active[]", "count": 1}, {"path": "successor_guardian.attorneys_active_meta[]", "count": 1}, {"path": "personal_representative.attorneys_active[]", "count": 1}, {"path": "personal_representative.attorneys_active_meta[]", "count": 1}]} | {"table_sizes": [{"bytes": 30983525, "ncols": 22, "table": "parents_case_events"}, {"bytes": 9252910, "ncols": 19, "table": "parents_hearings_previous"}, {"bytes": 5266357, "ncols": 57, "table": "parents_dispositions_charges_indexed"}, {"bytes": 4873145, "ncols": 6, "table": "parents_case_events_judicial_officers"}, {"bytes": 4476993, "ncols": 4, "table": "parents_case_events_examiners"}, {"bytes": 3633887, "ncols": 23, "table": "parents_dispositions_charges"}, {"bytes": 2289387, "ncols": 5, "table": "parents_dispositions_charges_condition_adult"}, {"bytes": 1804811, "ncols": 45, "table": "parents_dispositions"}, {"bytes": 1451219, "ncols": 11, "table": "parents_interim_conditions"}, {"bytes": 1365067, "ncols": 6, "table": "parents_cluster_cases"}, {"bytes": 1259032, "ncols": 7, "table": "parents_attorneys_prosecution_active"}, {"bytes": 1134950, "ncols": 26, "table": "parents_charges"}, {"bytes": 873414, "ncols": 4, "table": "parents_hearings_previous_judicial_officers"}, {"bytes": 827719, "ncols": 6, "table": "parents_attorneys_defense_inactive"}, {"bytes": 619293, "ncols": 5, "table": "parents_dispositions_charges_local_confinement"}, {"bytes": 579437, "ncols": 7, "table": "parents_attorneys_defense_active"}, {"bytes": 473731, "ncols": 5, "table": "parents_dispositions_charges_monitoring_adult"}, {"bytes": 313410, "ncols": 7, "table": "parents_case_events_attorneys"}, {"bytes": 284152, "ncols": 3, "table": "parents_case_set"}, {"bytes": 278773, "ncols": 5, "table": "parents_dispositions_charges_commit_to_commissioner_of_corrections_adult"}, {"bytes": 273497, "ncols": 4, "table": "parents_case_events_evidence_uids"}, {"bytes": 260447, "ncols": 18, "table": "parents_hearings_upcoming"}, {"bytes": 230259, "ncols": 5, "table": "parents_dispositions_charges_service_adult"}, {"bytes": 216609, "ncols": 5, "table": "parents_dispositions_charges_concurrent_consecutive"}, {"bytes": 204962, "ncols": 5, "table": "parents_dispositions_charges_level_of_sentence"}, {"bytes": 197428, "ncols": 3, "table": "parents_related_cases"}, {"bytes": 194747, "ncols": 6, "table": "parents"}, {"bytes": 192405, "ncols": 6, "table": "parents_attorneys_prosecution_inactive"}, {"bytes": 175647, "ncols": 5, "table": "parents_dispositions_charges_diversion_program_adult"}, {"bytes": 78525, "ncols": 3, "table": "parents_doc_set"}], "tables_found": ["parents", "parents_attorneys_defense_active", "parents_attorneys_defense_inactive", "parents_attorneys_prosecution_active", "parents_attorneys_prosecution_inactive", "parents_case_events", "parents_case_events_attorneys", "parents_case_events_evidence_uids", "parents_case_events_examiners", "parents_case_events_judicial_officers", "parents_case_set", "parents_charges", "parents_cluster_cases", "parents_dispositions", "parents_dispositions_charges", "parents_dispositions_charges_commit_to_commissioner_of_corrections_adult", "parents_dispositions_charges_concurrent_consecutive", "parents_dispositions_charges_condition_adult", "parents_dispositions_charges_diversion_program_adult", "parents_dispositions_charges_indexed", "parents_dispositions_charges_level_of_sentence", "parents_dispositions_charges_local_confinement", "parents_dispositions_charges_monitoring_adult", "parents_dispositions_charges_service_adult", "parents_doc_set", "parents_hearings_previous", "parents_hearings_previous_judicial_officers", "parents_hearings_upcoming", "parents_interim_conditions", "parents_related_cases"], "empty_or_noheader_csvs": []} children | {"top_paths": [{"kind": "scalar", "path": "case_set", "count": 19999}, {"kind": "object", "path": "objects", "count": 16136}, {"kind": "scalar", "path": "objects.object_sha256", "count": 16136}, {"kind": "scalar", "path": "objects.object_url", "count": 16136}, {"kind": "scalar", "path": "objects.object_family", "count": 16136}, {"kind": "scalar", "path": "objects.object_size_bytes", "count": 16136}, {"kind": "scalar", "path": "objects.object_type", "count": 16136}, {"kind": "scalar", "path": "objects.object_id", "count": 16136}, {"kind": "object", "path": "doc", "count": 12410}, {"kind": "scalar", "path": "doc.string_raw", "count": 12410}, {"kind": "scalar", "path": "doc.string_norm", "count": 12410}, {"kind": "scalar", "path": "doc.string_id", "count": 12410}, {"kind": "scalar", "path": "doc.string_group_n", "count": 12410}, {"kind": "scalar", "path": "doc.string_group_type", "count": 12410}, {"kind": "scalar", "path": "doc.string_page_num", "count": 12410}, {"kind": "scalar", "path": "doc.string_num_pages", "count": 12410}, {"kind": "scalar", "path": "doc.string_full_row", "count": 12410}, {"kind": "scalar", "path": "doc.string_full_row_id", "count": 12410}, {"kind": "scalar", "path": "doc.string_source_url", "count": 12410}, {"kind": "scalar", "path": "doc.string_quantity", "count": 12410}, {"kind": "scalar", "path": "doc_set", "count": 11677}, {"kind": "scalar", "path": "objects.object_description", "count": 11280}, {"kind": "scalar", "path": "objects.object_font_name", "count": 8472}, {"kind": "scalar", "path": "objects.object_image_w", "count": 7325}, {"kind": "scalar", "path": "objects.object_image_h", "count": 7325}, {"kind": "object", "path": "signatures.full_report", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.rev_count", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.field_index", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.chrono_rank", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.itv_dss", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.field_name", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.sign_time_raw", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.sign_time_cst_cdt", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.e_file_date", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.v_obj", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.br_o1", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.br_l1", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.br_o2", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.br_l2", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.total_sig_bytes", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.coverage_pct", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.edits_after_sig_flag", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.sig_subfilter", "count": 5319}, {"kind": "scalar", "path": "signatures.full_report.signer_name", "count": 5317}, {"kind": "scalar", "path": "signatures.full_report.days_after_e_file_signed", "count": 4714}, {"kind": "scalar", "path": "signatures.full_report.v_obj_sort", "count": 4562}, {"kind": "object", "path": "$", "count": 4251}, {"kind": "scalar", "path": "me_filename", "count": 4251}, {"kind": "scalar", "path": "case_id", "count": 4251}, {"kind": "scalar", "path": "case_type", "count": 4251}, {"kind": "scalar", "path": "doc_sha256", "count": 4251}, {"kind": "scalar", "path": "doc_type", "count": 4251}, {"kind": "scalar", "path": "filename", "count": 4251}, {"kind": "scalar", "path": "filing_type", "count": 4251}, {"kind": "scalar", "path": "filing_date", "count": 4251}, {"kind": "scalar", "path": "pdf_page_count", "count": 4251}, {"kind": "scalar", "path": "size_bytes", "count": 4251}, {"kind": "object", "path": "case_event", "count": 4251}, {"kind": "scalar", "path": "case_event.date", "count": 4251}, {"kind": "scalar", "path": "case_event.event_name", "count": 4251}, {"kind": "array", "path": "doc_set[]", "count": 4251}, {"kind": "array", "path": "address[]", "count": 4251}, {"kind": "array", "path": "doc[]", "count": 4251}, {"kind": "object", "path": "signatures", "count": 4251}, {"kind": "scalar", "path": "signatures.has_signature", "count": 4251}, {"kind": "object", "path": "metadata", "count": 4251}, {"kind": "scalar", "path": "metadata.xmp_producer", "count": 4251}, {"kind": "scalar", "path": "metadata.derived_create_newer_by_days", "count": 4251}, {"kind": "scalar", "path": "metadata.efile_date", "count": 4251}, {"kind": "scalar", "path": "metadata.last_modified_date", "count": 4251}, {"kind": "object", "path": "tracking", "count": 4251}, {"kind": "scalar", "path": "tracking.tracked_flag", "count": 4251}, {"kind": "array", "path": "tracking.groups[]", "count": 4251}, {"kind": "scalar", "path": "case_uid", "count": 4251}, {"kind": "scalar", "path": "evidence_uid", "count": 4251}, {"kind": "array", "path": "signatures.full_report[]", "count": 4225}, {"kind": "object", "path": "signatures.pdfsig", "count": 4225}, {"kind": "array", "path": "objects[]", "count": 4224}, {"kind": "object", "path": "cluster", "count": 4222}, {"kind": "scalar", "path": "cluster.id", "count": 4222}, {"kind": "scalar", "path": "cluster.size", "count": 4222}, {"kind": "scalar", "path": "cluster.name", "count": 4222}, {"kind": "scalar", "path": "signatures.pdfsig.sig1_name", "count": 4222}, {"kind": "scalar", "path": "signatures.pdfsig.sig1_name_full", "count": 4222}, {"kind": "scalar", "path": "signatures.pdfsig.sig1_sign_time", "count": 4222}, {"kind": "scalar", "path": "signatures.pdfsig.sig1_hash_type", "count": 4222}, {"kind": "scalar", "path": "signatures.pdfsig.sig1_sig_type", "count": 4222}, {"kind": "scalar", "path": "signatures.pdfsig.sig1_signed_ranges", "count": 4222}, {"kind": "scalar", "path": "signatures.pdfsig.sig1_crypto_status", "count": 4222}, {"kind": "scalar", "path": "signatures.pdfsig.sig1_coverage", "count": 4222}, {"kind": "scalar", "path": "cluster_id", "count": 4222}, {"kind": "scalar", "path": "cluster_name", "count": 4222}, {"kind": "scalar", "path": "parent_filename", "count": 4221}, {"kind": "array", "path": "case_set[]", "count": 4221}, {"kind": "scalar", "path": "case_event.docket_index", "count": 4220}, {"kind": "scalar", "path": "case_event.event_index", "count": 4220}, {"kind": "scalar", "path": "metadata.derived_metadata_newer_by_days", "count": 4220}, {"kind": "scalar", "path": "case_event_uid", "count": 4220}, {"kind": "scalar", "path": "cluster_event_key", "count": 4220}, {"kind": "object", "path": "signatures.mcro_authentication", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.rev_count", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.field_index", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.chrono_rank", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.itv_dss", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.field_name", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.signer_name", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.sign_time_cst_cdt", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.v_obj", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.total_sig_bytes", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.coverage_pct", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.edits_after_sig_flag", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.sig_crypto_valid_flag", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.sig_subfilter", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.sig_crypto_status", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.last_modified_date", "count": 4207}, {"kind": "scalar", "path": "signatures.mcro_authentication.signed_ranges", "count": 4207}, {"kind": "scalar", "path": "signatures.full_report.sig_crypto_valid_flag", "count": 4189}, {"kind": "scalar", "path": "signatures.full_report.sig_crypto_status", "count": 4189}, {"kind": "scalar", "path": "metadata.xmp_create_date", "count": 4111}, {"kind": "scalar", "path": "signatures.mcro_authentication.filename_ts", "count": 4099}, {"kind": "scalar", "path": "metadata.filename_ts", "count": 4099}, {"kind": "scalar", "path": "metadata.xmp_toolkit", "count": 4053}, {"kind": "scalar", "path": "metadata.document_id", "count": 4045}, {"kind": "scalar", "path": "metadata.instance_id", "count": 4044}, {"kind": "scalar", "path": "metadata.xmp_metadata_date", "count": 3895}, {"kind": "scalar", "path": "metadata.xmp_creator_tool", "count": 3879}, {"kind": "scalar", "path": "signatures.mcro_authentication.size_bytes", "count": 3601}, {"kind": "scalar", "path": "metadata.derived_create_vs_metadata_days", "count": 3273}, {"kind": "scalar", "path": "objects.object_font_code", "count": 3223}, {"kind": "scalar", "path": "metadata.xmp_creator", "count": 3003}, {"kind": "scalar", "path": "metadata.xmp_creator_raw", "count": 3003}, {"kind": "scalar", "path": "metadata.xmp_author", "count": 2288}, {"kind": "scalar", "path": "metadata.xmp_author_raw", "count": 2288}, {"kind": "scalar", "path": "metadata.xmp_author_norm", "count": 2165}, {"kind": "scalar", "path": "metadata.xmp_author_id", "count": 2165}, {"kind": "scalar", "path": "metadata.xmp_creator_norm", "count": 2158}, {"kind": "scalar", "path": "metadata.xmp_creator_id", "count": 2158}, {"kind": "scalar", "path": "objects.object_person_name", "count": 2023}, {"kind": "scalar", "path": "objects.object_person_role", "count": 2023}, {"kind": "scalar", "path": "objects.judicial_officer_raw", "count": 1947}, {"kind": "scalar", "path": "objects.judicial_officer_norm", "count": 1947}, {"kind": "scalar", "path": "objects.judicial_officer_id", "count": 1947}, {"kind": "object", "path": "tracking.groups", "count": 1942}, {"kind": "scalar", "path": "tracking.groups.pdf_group", "count": 1942}, {"kind": "scalar", "path": "tracking.groups.font_group", "count": 1942}, {"kind": "scalar", "path": "tracking.groups.font_hash_date", "count": 1942}, {"kind": "scalar", "path": "tracking.groups.font1_name", "count": 1942}, {"kind": "scalar", "path": "tracking.groups.font1_type", "count": 1942}, {"kind": "scalar", "path": "case_event.judicial_officer", "count": 1755}, {"kind": "scalar", "path": "case_event.judicial_officer_raw", "count": 1755}, {"kind": "scalar", "path": "case_event.judicial_officer_norm", "count": 1755}, {"kind": "scalar", "path": "case_event.judicial_officer_id", "count": 1755}, {"kind": "scalar", "path": "tracking.groups.font1_sha256", "count": 1750}, {"kind": "object", "path": "address", "count": 1705}, {"kind": "scalar", "path": "address.address_raw", "count": 1705}, {"kind": "scalar", "path": "address.address_norm", "count": 1705}, {"kind": "scalar", "path": "address.address_id", "count": 1705}, {"kind": "scalar", "path": "address.address_page_num", "count": 1705}, {"kind": "scalar", "path": "address.address_num_pages", "count": 1705}, {"kind": "scalar", "path": "address.address_source_url", "count": 1705}, {"kind": "scalar", "path": "tracking.groups.font2_name", "count": 1456}, {"kind": "scalar", "path": "tracking.groups.font2_type", "count": 1456}, {"kind": "scalar", "path": "tracking.groups.font2_sha256", "count": 1330}, {"kind": "scalar", "path": "metadata.xmp_title", "count": 1184}, {"kind": "scalar", "path": "signatures.pdfsig.sig2_name", "count": 720}, {"kind": "scalar", "path": "signatures.pdfsig.sig2_name_full", "count": 720}, {"kind": "scalar", "path": "signatures.pdfsig.sig2_sign_time", "count": 720}, {"kind": "scalar", "path": "signatures.pdfsig.sig2_hash_type", "count": 720}, {"kind": "scalar", "path": "signatures.pdfsig.sig2_sig_type", "count": 720}, {"kind": "scalar", "path": "signatures.pdfsig.sig2_signed_ranges", "count": 720}, {"kind": "scalar", "path": "signatures.pdfsig.sig2_crypto_status", "count": 720}, {"kind": "scalar", "path": "signatures.pdfsig.sig2_coverage", "count": 720}, {"kind": "scalar", "path": "signatures.full_report.signer_name_raw", "count": 710}, {"kind": "scalar", "path": "signatures.full_report.judicial_officer_raw", "count": 710}, {"kind": "scalar", "path": "signatures.full_report.judicial_officer_norm", "count": 710}, {"kind": "scalar", "path": "signatures.full_report.judicial_officer_id", "count": 710}, {"kind": "scalar", "path": "metadata.pdf_version", "count": 650}, {"kind": "scalar", "path": "objects.object_date", "count": 597}, {"kind": "scalar", "path": "objects.object_time", "count": 591}, {"kind": "scalar", "path": "signatures.pdfsig.sig1_judicial_officer_raw", "count": 582}, {"kind": "scalar", "path": "signatures.pdfsig.sig1_judicial_officer_norm", "count": 582}, {"kind": "scalar", "path": "signatures.pdfsig.sig1_judicial_officer_id", "count": 582}, {"kind": "object", "path": "sources", "count": 571}, {"kind": "object", "path": "sources.tables", "count": 571}, {"kind": "scalar", "path": "metadata.xmp_company", "count": 309}, {"kind": "scalar", "path": "metadata.tagged_pdf", "count": 283}, {"kind": "scalar", "path": "signatures.pdfsig.sig3_name", "count": 241}, {"kind": "scalar", "path": "signatures.pdfsig.sig3_name_full", "count": 241}, {"kind": "scalar", "path": "signatures.pdfsig.sig3_sign_time", "count": 241}, {"kind": "scalar", "path": "signatures.pdfsig.sig3_hash_type", "count": 241}, {"kind": "scalar", "path": "signatures.pdfsig.sig3_sig_type", "count": 241}, {"kind": "scalar", "path": "signatures.pdfsig.sig3_signed_ranges", "count": 241}, {"kind": "scalar", "path": "signatures.pdfsig.sig3_crypto_status", "count": 241}, {"kind": "scalar", "path": "signatures.pdfsig.sig3_coverage", "count": 241}, {"kind": "scalar", "path": "case_event.filing_party_role", "count": 199}, {"kind": "scalar", "path": "case_event.filing_party_name", "count": 199}, {"kind": "scalar", "path": "case_event.event_name_pretty", "count": 199}, {"kind": "scalar", "path": "case_event.case_event_uid", "count": 199}, {"kind": "scalar", "path": "case_event.party", "count": 194}, {"kind": "scalar", "path": "tracking.groups.font3_name", "count": 170}, {"kind": "scalar", "path": "tracking.groups.font3_type", "count": 170}, {"kind": "scalar", "path": "tracking.groups.font3_sha256", "count": 128}, {"kind": "scalar", "path": "signatures.pdfsig.sig2_judicial_officer_raw", "count": 122}, {"kind": "scalar", "path": "signatures.pdfsig.sig2_judicial_officer_norm", "count": 122}, {"kind": "scalar", "path": "signatures.pdfsig.sig2_judicial_officer_id", "count": 122}, {"kind": "object", "path": "metadata.msip", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_label_token_primary", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_label_name_primary", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_action_id_primary", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_site_id_primary", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_set_date_primary", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_method_primary", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_enabled_primary", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_content_bits_primary", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_all_action_ids", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_all_content_bits", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_all_enableds", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_all_methods", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_all_names", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_all_set_dates", "count": 34}, {"kind": "scalar", "path": "metadata.msip.msip_all_site_ids", "count": 34}, {"kind": "scalar", "path": "metadata.msip.has_msip_flag", "count": 34}, {"kind": "scalar", "path": "signatures.pdfsig.sig4_name", "count": 19}, {"kind": "scalar", "path": "signatures.pdfsig.sig4_name_full", "count": 19}, {"kind": "scalar", "path": "signatures.pdfsig.sig4_sign_time", "count": 19}, {"kind": "scalar", "path": "signatures.pdfsig.sig4_hash_type", "count": 19}, {"kind": "scalar", "path": "signatures.pdfsig.sig4_sig_type", "count": 19}, {"kind": "scalar", "path": "signatures.pdfsig.sig4_signed_ranges", "count": 19}, {"kind": "scalar", "path": "signatures.pdfsig.sig4_crypto_status", "count": 19}, {"kind": "scalar", "path": "signatures.pdfsig.sig4_coverage", "count": 19}, {"kind": "object", "path": "sources.tables.mcro_objects_sha256_guertin_font_hash_map", "count": 17}, {"kind": "scalar", "path": "sources.tables.mcro_objects_sha256_guertin_font_hash_map.filename", "count": 17}, {"kind": "scalar", "path": "sources.tables.mcro_objects_sha256_guertin_font_hash_map.filing_date", "count": 17}, {"kind": "scalar", "path": "sources.tables.mcro_objects_sha256_guertin_font_hash_map.font_group", "count": 17}, {"kind": "scalar", "path": "sources.tables.mcro_objects_sha256_guertin_font_hash_map.font_sha256", "count": 17}, {"kind": "scalar", "path": "sources.tables.mcro_objects_sha256_guertin_font_hash_map.font_type", "count": 17}, {"kind": "scalar", "path": "sources.tables.mcro_objects_sha256_guertin_font_hash_map.font_name", "count": 17}, {"kind": "object", "path": "sources.tables.mcro_javascript_files_containing_js_scripts", "count": 12}, {"kind": "scalar", "path": "sources.tables.mcro_javascript_files_containing_js_scripts.filename", "count": 12}, {"kind": "scalar", "path": "sources.tables.mcro_javascript_files_containing_js_scripts.pdf_javascript_url", "count": 12}, {"kind": "scalar", "path": "sources.tables.mcro_javascript_files_containing_js_scripts.size_in_bytes", "count": 12}, {"kind": "scalar", "path": "sources.tables.mcro_javascript_files_containing_js_scripts.size_out_bytes", "count": 12}, {"kind": "scalar", "path": "sources.tables.mcro_javascript_files_containing_js_scripts.has_javascript_flag", "count": 12}, {"kind": "scalar", "path": "sources.tables.mcro_javascript_files_containing_js_scripts.has_openaction_aa_flag", "count": 12}, {"kind": "scalar", "path": "sources.tables.mcro_javascript_files_containing_js_scripts.actions_count", "count": 12}, {"kind": "scalar", "path": "sources.tables.mcro_javascript_files_containing_js_scripts.js_entries_count", "count": 12}, {"kind": "scalar", "path": "sources.tables.mcro_javascript_files_containing_js_scripts.action_where_targets", "count": 12}, {"kind": "scalar", "path": "sources.tables.mcro_javascript_files_containing_js_scripts.js_where_targets", "count": 12}, {"kind": "scalar", "path": "sources.tables.mcro_javascript_files_containing_js_scripts.js_1_preview", "count": 12}, {"kind": "scalar", "path": "sources.tables.mcro_javascript_files_containing_js_scripts.js_2_preview", "count": 12}], "files_scanned": [{"file": "/home/matt1up/DB/query_ndjson/children_000.ndjson", "lines_scanned": 37}, {"file": "/home/matt1up/DB/query_ndjson/children_001.ndjson", "lines_scanned": 28}, {"file": "/home/matt1up/DB/query_ndjson/children_002.ndjson", "lines_scanned": 66}, {"file": "/home/matt1up/DB/query_ndjson/children_003.ndjson", "lines_scanned": 1074}, {"file": "/home/matt1up/DB/query_ndjson/children_004.ndjson", "lines_scanned": 953}, {"file": "/home/matt1up/DB/query_ndjson/children_005.ndjson", "lines_scanned": 904}, {"file": "/home/matt1up/DB/query_ndjson/children_006.ndjson", "lines_scanned": 783}, {"file": "/home/matt1up/DB/query_ndjson/children_007.ndjson", "lines_scanned": 406}], "top_level_keys": [["case_id", 4251], ["tracking", 4251], ["doc_set", 4251], ["case_type", 4251], ["me_filename", 4251], ["address", 4251], ["case_event", 4251], ["doc_sha256", 4251], ["filing_type", 4251], ["pdf_page_count", 4251], ["signatures", 4251], ["doc_type", 4251], ["metadata", 4251], ["case_uid", 4251], ["size_bytes", 4251], ["doc", 4251], ["evidence_uid", 4251], ["filename", 4251], ["filing_date", 4251], ["objects", 4224], ["cluster_name", 4222], ["cluster", 4222], ["cluster_id", 4222], ["case_set", 4221], ["parent_filename", 4221], ["cluster_event_key", 4220], ["case_event_uid", 4220], ["sources", 571], ["has_js", 12], ["font_groups", 6], ["pdf_group", 3], ["javascript", 2]], "top_array_paths": [{"path": "doc_set[]", "count": 4251}, {"path": "address[]", "count": 4251}, {"path": "doc[]", "count": 4251}, {"path": "tracking.groups[]", "count": 4251}, {"path": "signatures.full_report[]", "count": 4225}, {"path": "objects[]", "count": 4224}, {"path": "case_set[]", "count": 4221}, {"path": "case_event.attorneys[]", "count": 6}, {"path": "sources.tables.mcro_objects_sha256_guertin_font_hash_map[]", "count": 6}, {"path": "font_groups[]", "count": 6}, {"path": "javascript[]", "count": 2}]} | {"table_sizes": [{"bytes": 127899756, "ncols": 20, "table": "children_doc_strings"}, {"bytes": 21132325, "ncols": 28, "table": "children_objects"}, {"bytes": 3754096, "ncols": 52, "table": "children"}, {"bytes": 3099968, "ncols": 37, "table": "children_signatures_full_report"}, {"bytes": 1435168, "ncols": 2, "table": "children_case_set"}, {"bytes": 1004569, "ncols": 16, "table": "children_address"}, {"bytes": 902672, "ncols": 26, "table": "children_tracking_groups"}, {"bytes": 708061, "ncols": 2, "table": "children_doc_set"}], "tables_found": ["children", "children_address", "children_case_set", "children_doc_set", "children_doc_strings", "children_objects", "children_signatures_full_report", "children_tracking_groups"], "empty_or_noheader_csvs": []} (4 rows) Time: 322.621 ms