Concordance Complete
Complete concordance metadata for 1.38M documents: original filenames, authors, custodians, email headers, dates, folder paths, and attachment relationships. Merged from DOJ OGR production concordance load files across all datasets.
Cross References
3 records
id, doc_id_a, doc_id_b, match_type, confidence, notes
Documents
1,385,519 records
One row per document. 1,416,848 total. Use <code>efta_number</code> (Bates number) to look up pages in the <code>pages</code> table.
id, source, bates_begin, bates_end, bates_begin_attach, bates_end_attach, is_attachment, page_count, original_filename, document_extension, file_size, original_folder_path, md5_hash, document_title, author, custodian, date_created, date_last_modified, date_received, date_sent, time_sent, time_zone, email_from, email_to, email_cc, email_bcc, email_subject, parent_document_id, text_link, native_link, efta_number, corpus_doc_id
Email Threads
192 records
id, thread_root_id, doc_id, position_in_thread, is_attachment
Extraction Stats
14 records
id, source, total_documents, total_pages, fields_available, fields_populated, extraction_timestamp
Folder Inventory
15 records
id, folder_path, doc_count, source_device, notes
Document Pages
2,788,208 records
Full text of every page in the EFTA corpus. Use the search box for FTS5 full-text queries.
id, source, bates_number, document_id, page_number, volume, image_path, is_first_page