Torah Units Database Template - Updated

Excel Template Download

Click the button below to download a CSV template with all 38 field headers (no sample data):

Genesis Three-Ring Structure

Outer Ring (A↔F): Kingship - Divine Kingship (Creation) pairs with Human Kingship (Joseph)
Middle Ring (B↔E): Covenants - Covenants with deity and rulers, altars and sacred places
Inner Ring (C↔D): Family - Brothers' children (C) pairs with Brothers (D)

Key Connection: Genesis Unit 1 (Triad A) → Unit 17 (Triad F): Day 1 light creation connects to Joseph's dreams of sun, moon, stars

Database Update: Streamlined to 38 fields by removing redundant cross-unit relationships

Instructions

Download the CSV template using the button above
The template includes all 38 field headers organized by category
Column headers match the database schema exactly
Use this for your horizontal thread books: Genesis, Leviticus, Deuteronomy
Begin entering your fully analyzed units
Focus on literary/structural analysis, not theological interpretation

Category	Field Name	Type	Commentary
CORE IDENTIFICATION
	unit_id	string	Standardized identifier (e.g., "GEN-1", "LEV-13", "DEU-7")
	book	string	Genesis/Leviticus/Deuteronomy only for horizontal thread
	unit_number	integer	Sequential number within book (1-19 for Genesis, 1-22 for Leviticus, 1-13 for Deuteronomy)
	verse_range	string	Complete chapter:verse range (e.g., "Genesis 1:1-2:3")
	opening_formula	string	Key words or phrases that begin the unit and may define boundaries
	structure_type	string	regular/irregular - describes internal organization
	dimensions	string	Grid format (e.g., "3×2", "23332") or "standalone" for independent units
	analysis_status	string	complete/partial/placeholder - tracks how fully analyzed this unit is
INTERNAL STRUCTURE
	rows	integer	Number of horizontal divisions (weft threads) in the unit
	columns	integer	Number of vertical divisions (warp threads) in the unit
	warp_pole_1	text	First pole thematic description (A in dyads/triads)
	warp_middle	text	Middle column thematic description (only exists in triads - B column)
	warp_pole_2	text	Second pole thematic description (B in dyads, C in triads)
	weft_thread_1	text	Top row thematic description
	weft_thread_2	text	Second row thematic description
	weft_thread_3	text	Third row thematic description (if exists)
	weft_thread_4	text	Fourth row thematic description (if exists)
	weft_thread_5	text	Fifth row thematic description (if exists)
	has_subdivisions	boolean	Whether unit contains internal A/B/C subdivisions
	subdivision_pattern	string	Type of internal division: A,B,C / parallel_indicators / framework / none
TORAH-WIDE ORGANIZATION
	unit_triad_membership	string	Which triad group: A, B, C, D, E, F, G, H. Genesis: A/F=Kingship, B/E=Covenants, C/D=Family rings
	warp_thread_number	integer	1, 2, or 3 - position within the three horizontal threads spanning Genesis-Leviticus-Deuteronomy
	creation_paradigm_position	string	God-oriented/people-oriented/mediating - the consistent internal triad structure
	anomalous_status	boolean	True for units that break expected patterns (like unpaired triads)
LEVITICUS SPECIAL FEATURES
	ring_identifier_type	string	place/time/person/none - distinctive markers unique to Leviticus rings (other books use different ring systems)
THEMATIC CONTENT
	primary_theme	text	One-line summary of unit's main subject
	movement_type	string	unity_to_separation/separation_to_unity/intensification/circular/static
	divine_names_pattern	text	Distribution patterns of YHWH/Elohim usage
	key_intersection	text	Most structurally significant cell in the unit's matrix
	emergent_meaning	text	Insights only visible through two-dimensional reading
	literary_techniques	array	chiasm, envelope, triadic, concentric_rings, etc.
	visual_hierarchy	text	How spatial arrangement creates meaning
	supernatural_content	boolean	Contains miracles, divine appearances, or supernatural elements
CROSS-UNIT RELATIONSHIPS
	inverted_units	array	Units with opposite meaning but similar structure
	structural_family	string	Grouping based on internal organization (e.g., "3×2_group", "creation_triad")
	triad_pair_partner	string	Which triad this one pairs with (e.g., Genesis A↔F, B↔E, C↔D through ring structure)
	thematic_chain	array	Connected units across books sharing common themes
ANALYSIS METADATA
	confidence_level	string	high/medium/low - how certain we are about this analysis
	primary_source	string	Which scholarly work this analysis derives from
	color_coding_verified	boolean	Whether visual patterns have been confirmed
	notes	text	Additional observations, uncertainties, or special cases