Secondary Stamps
Secondary Bates stamp analysis across 835K documents. Maps EFTA numbers to parallel numbering systems: R1 (FBI device extraction), JPM-SDNY (JPMorgan production), DB-SDNY (Deutsche Bank production), and SDNY-GM (grand jury material). Includes per-page stamp details for 1.19M pages.
Document Stamps
784,353 records
efta_number, dataset, total_pages, primary_stamp_type, r1_number, jpm_sdny_number, db_sdny_number, sdny_gm_number, efta_plain_number, ubs_number, td_doj_number, efta_underscore, sdny_case_number, usao_number, discovery_ref, remote_id, conversation_id, gmail_flags, date_received, gmail_labels, gmail_read, fbi_serial
Fbi Case Serials
534 records
id, efta_number, case_id, case_label, serial, doc_prefix
Page Stamps
1,232,173 records
id, final_efta, dataset, total_pages, page_number, r1_number, efta_underscore, sdny_case_number, jpm_sdny_number, db_sdny_number, sdny_gm_number, discovery_ref, ubs_number, td_doj_number, usao_number, remote_id, fbi_serial
Plist Stamps
145,302 records
id, efta_number, page_number, remote_id, conversation_id, gmail_flags, date_received, gmail_labels, gmail_read
Serial Efta Map
2,920 records
efta_number, serial, subdoc_count
Serial Index
1,246 records
serial, prefix, number, description, efta_count, subdoc_count, eftas_json
Serial Nav
2,861 records
id, efta_number, serial, discovery_ref
Sqlite Sequence
3 records
name, seq