EV Battery Passport Degradation and Circularity Analytics Set (EU)
EVBATT999· 2.0M records · 68 tables · v1.0.0 · Updated 2026-09-01
Manufacturing Automotive Dataset API
Overview
An EU electric-vehicle battery passport and circularity model connects mineral origin and pack manufacture with passport revisions, vehicle operation, state of health, maintenance, second life and material recovery. Regulation (EU) 2023/1542, official jurisdictions and published methodology sources provide real context only; all commercial actors, people, products, serialized assets and operational events are synthetic and modelled. Legal applicability is separate from the February 2027 display state, and pending secondary acts remain labelled as pending rather than treated as enacted. Historical rows are synthetic calibrations, rows current at the 2026-09-01 cutoff are synthetic estimates, and later periodic rows are versioned synthetic forecasts; future operational rows are explicitly planned or scheduled. Organization domains and email addresses use .example, transactional identifiers are unregistered demonstration values, and sampled charging, driving and telemetry events represent analytical source events rather than complete raw streams.
Analytics
Four entries from the packaged tables, with the performance the dataset records for them. Every value below is read from the shipped files.
The passport the regulation requiresPASSP14,000 passports over 45,000 packs
14,000Battery passports
45,000Battery packs
State of certified energy, percentState of certified energy, percent
1 / 2
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| evb_calendar_days | 3,653 |
| evb_methodology_sources | 39 |
| evb_jurisdictions | 42 |
| evb_regulatory_instruments | 28 |
| evb_passport_data_catalogue | 71 |
| evb_external_drivers_monthly | 10,080 |
| evb_weather_daily | 29,224 |
| evb_disruption_events | 150 |
| evb_organizations | 450 |
| evb_organization_roles | 780 |
| evb_facilities | 840 |
| evb_people | 4,150 |
| evb_materials | 56 |
| evb_material_prices_monthly | 1,512 |
| evb_battery_chemistries | 9 |
| evb_cell_models | 36 |
| evb_battery_models | 192 |
| evb_model_components | 2,304 |
| evb_model_materials | 1,920 |
| evb_product_media | 48 |
| evb_dismantling_steps | 1,536 |
| evb_sourcing_contracts | 1,200 |
| evb_extraction_sites | 240 |
| evb_material_lots | 18,000 |
| evb_chain_of_custody_events | 30,000 |
| evb_due_diligence_assessments | 2,800 |
| evb_recycled_content_claims | 4,800 |
| evb_production_orders | 4,500 |
| evb_material_consumptions | 18,000 |
| evb_cell_production_lots | 13,500 |
| evb_module_units | 67,500 |
| evb_battery_packs | 45,000 |
| evb_pack_module_assignments | 67,500 |
| evb_manufacturing_events | 45,000 |
| evb_quality_tests | 90,000 |
| evb_nonconformities | 2,700 |
| evb_corrective_actions | 4,050 |
| evb_carbon_footprint_declarations | 4,500 |
| evb_carbon_footprint_stages | 31,500 |
| evb_conformity_declarations | 1,344 |
| evb_passports | 14,000 |
| evb_passport_revisions | 28,000 |
| evb_passport_values | 994,000 |
| evb_passport_access_events | 28,000 |
| evb_vehicle_models | 48 |
| evb_vehicles | 14,000 |
| evb_battery_installations | 15,000 |
| evb_ownership_periods | 18,000 |
| evb_charging_sessions | 28,000 |
| evb_drive_sessions | 28,000 |
| evb_operational_telemetry | 70,000 |
| evb_charge_cycles | 112,000 |
| evb_state_of_health_assessments | 42,000 |
| evb_degradation_forecasts | 14,000 |
| evb_safety_incidents | 700 |
| evb_service_work_orders | 4,200 |
| evb_service_actions | 8,400 |
| evb_second_life_assessments | 5,600 |
| evb_second_life_deployments | 2,800 |
| evb_second_life_performance_monthly | 11,200 |
| evb_collection_events | 7,000 |
| evb_recycling_batches | 700 |
| evb_recycling_inputs | 7,000 |
| evb_recovery_outputs | 4,200 |
| evb_circularity_balances_monthly | 2,688 |
| evb_audits | 900 |
| evb_audit_findings | 2,700 |
| evb_remediation_actions | 3,600 |
Table Relationships
One parent record and seven child tables, each joined back on the same key.
70%
Loading diagram
Schema
Every table ships with typed columns, referential integrity, and documentation.
evb_calendar_days· Rows: 3,653
| Column | Type | Description |
|---|---|---|
| date_id | varchar(24) | Stable synthetic identifier for one calendar day. Primary key; opaque text and never a transactional identifier. |
| calendar_date | date | ISO 8601 calendar date represented by this calendar-spine row. |
| calendar_year | integer | Four-digit calendar year containing the day; used for annual grouping, not a fiscal-year surrogate. |
| month_number | varchar(8) | Calendar month number from 1 through 12 for the day or reporting period. |
| month_name | varchar(16) | English calendar-month name paired with month_number. |
| quarter_number | varchar(8) | Calendar quarter number from 1 through 4, derived from month_number. |
| iso_week_number | varchar(8) | ISO 8601 week number for the calendar day. |
+10 more columns in evb_calendar_days. The full schema ships with the download.
evb_methodology_sources· Rows: 39
| Column | Type | Description |
|---|---|---|
| source_id | varchar(16) | Stable synthetic identifier for one official or primary calibration source. Primary key; opaque text and never a transactional identifier. |
| jurisdiction_id | varchar(8) | Foreign-key identifier of the jurisdiction linked at one official or primary calibration source. A blank value, where permitted, means the relationship does not apply. |
| source_code | varchar(48) | Stable controlled code for source at one official or primary calibration source; where a matching name column exists, both values are asserted as one classification. |
| publisher_name | varchar(128) | Real publisher name for the cited methodology source; the publisher is context and not a synthetic operator. |
| source_title | varchar(200) | Published title of the cited legal, statistical, climate, market or engineering source. |
| source_url | varchar(232) | Public source locator recorded at the release cutoff; retrieval date and source vintage remain separate. |
| source_type_code | varchar(40) | Stable controlled code for source type at one official or primary calibration source; where a matching name column exists, both values are asserted as one classification. |
+12 more columns in evb_methodology_sources. The full schema ships with the download.
evb_jurisdictions· Rows: 42
| Column | Type | Description |
|---|---|---|
| jurisdiction_id | varchar(8) | Stable synthetic identifier for one regulatory or supply-chain jurisdiction. Primary key; opaque text and never a transactional identifier. |
| jurisdiction_code | varchar(8) | Stable controlled code for jurisdiction at one regulatory or supply-chain jurisdiction; where a matching name column exists, both values are asserted as one classification. |
| jurisdiction_name | varchar(40) | Human-readable label for jurisdiction at one regulatory or supply-chain jurisdiction; where a matching code exists, this is its asserted meaning rather than a second classification. |
| region_group_code | varchar(32) | Stable controlled code for region group at one regulatory or supply-chain jurisdiction; where a matching name column exists, both values are asserted as one classification. |
| region_group_name | varchar(56) | Human-readable label for region group at one regulatory or supply-chain jurisdiction; where a matching code exists, this is its asserted meaning rather than a second classification. |
| country_code | varchar(8) | ISO 3166-1 alpha-2 country code applicable to the row. |
| currency_code | varchar(8) | ISO 4217 currency code for monetary values or the jurisdiction context. |
+8 more columns in evb_jurisdictions. The full schema ships with the download.
evb_regulatory_instruments· Rows: 28
| Column | Type | Description |
|---|---|---|
| instrument_id | varchar(16) | Stable synthetic identifier for one effective-dated legal or technical instrument. Primary key; opaque text and never a transactional identifier. |
| source_id | varchar(16) | Foreign-key identifier of the source linked at one effective-dated legal or technical instrument. A blank value, where permitted, means the relationship does not apply. |
| jurisdiction_id | varchar(8) | Foreign-key identifier of the jurisdiction linked at one effective-dated legal or technical instrument. A blank value, where permitted, means the relationship does not apply. |
| instrument_code | varchar(40) | Stable controlled code for instrument at one effective-dated legal or technical instrument; where a matching name column exists, both values are asserted as one classification. |
| instrument_name | varchar(152) | Human-readable label for instrument at one effective-dated legal or technical instrument; where a matching code exists, this is its asserted meaning rather than a second classification. |
| issuing_authority | varchar(128) | Real authority that issued the legal or technical instrument; it appears as regulatory context and is not a synthetic operator. |
| legal_level_code | varchar(40) | Stable controlled code for legal level at one effective-dated legal or technical instrument; where a matching name column exists, both values are asserted as one classification. |
+17 more columns in evb_regulatory_instruments. The full schema ships with the download.
evb_passport_data_catalogue· Rows: 71
| Column | Type | Description |
|---|---|---|
| data_point_id | varchar(8) | Stable synthetic identifier for one normalized battery-passport data point. Primary key; opaque text and never a transactional identifier. |
| instrument_id | varchar(16) | Foreign-key identifier of the instrument linked at one normalized battery-passport data point. A blank value, where permitted, means the relationship does not apply. |
| data_point_number | varchar(8) | Commission catalogue ordinal for the passport data point; it is a legal catalogue number, not a row count. |
| data_point_code | varchar(48) | Stable controlled code for data point at one normalized battery-passport data point; where a matching name column exists, both values are asserted as one classification. |
| data_point_name | varchar(408) | Human-readable label for data point at one normalized battery-passport data point; where a matching code exists, this is its asserted meaning rather than a second classification. |
| legal_reference | varchar(24) | Article, annex, section or guidance reference supporting the normalized passport data point. |
| information_class_code | varchar(16) | Stable controlled code for information class at one normalized battery-passport data point; where a matching name column exists, both values are asserted as one classification. |
+16 more columns in evb_passport_data_catalogue. The full schema ships with the download.
evb_external_drivers_monthly· Rows: 10,080
| Column | Type | Description |
|---|---|---|
| driver_observation_id | varchar(16) | Stable synthetic identifier for one driver, jurisdiction and source month. Primary key; opaque text and never a transactional identifier. |
| month_start_date_id | varchar(24) | Calendar key for month start at one driver, jurisdiction and source month; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
| jurisdiction_id | varchar(8) | Foreign-key identifier of the jurisdiction linked at one driver, jurisdiction and source month. A blank value, where permitted, means the relationship does not apply. |
| source_id | varchar(16) | Foreign-key identifier of the source linked at one driver, jurisdiction and source month. A blank value, where permitted, means the relationship does not apply. |
| driver_code | varchar(40) | Stable controlled code for driver at one driver, jurisdiction and source month; where a matching name column exists, both values are asserted as one classification. |
| driver_name | varchar(64) | Human-readable label for driver at one driver, jurisdiction and source month; where a matching code exists, this is its asserted meaning rather than a second classification. |
| driver_category_code | varchar(32) | Stable controlled code for driver category at one driver, jurisdiction and source month; where a matching name column exists, both values are asserted as one classification. |
+12 more columns in evb_external_drivers_monthly. The full schema ships with the download.
evb_weather_daily· Rows: 29,224
| Column | Type | Description |
|---|---|---|
| weather_observation_id | varchar(16) | Stable synthetic identifier for one jurisdiction and calendar day weather observation. Primary key; opaque text and never a transactional identifier. |
| jurisdiction_id | varchar(8) | Foreign-key identifier of the jurisdiction linked at one jurisdiction and calendar day weather observation. A blank value, where permitted, means the relationship does not apply. |
| date_id | varchar(24) | Foreign-key identifier of the date linked at one jurisdiction and calendar day weather observation. A blank value, where permitted, means the relationship does not apply. |
| source_id | varchar(16) | Foreign-key identifier of the source linked at one jurisdiction and calendar day weather observation. A blank value, where permitted, means the relationship does not apply. |
| mean_temperature_c | numeric(6,2) | Mean temperature, expressed in degrees Celsius, at one jurisdiction and calendar day weather observation. |
| minimum_temperature_c | numeric(6,2) | Minimum temperature, expressed in degrees Celsius, at one jurisdiction and calendar day weather observation. |
| maximum_temperature_c | numeric(6,2) | Maximum temperature, expressed in degrees Celsius, at one jurisdiction and calendar day weather observation. |
+12 more columns in evb_weather_daily. The full schema ships with the download.
evb_disruption_events· Rows: 150
| Column | Type | Description |
|---|---|---|
| disruption_id | varchar(16) | Stable synthetic identifier for one dated causal disruption. Primary key; opaque text and never a transactional identifier. |
| source_id | varchar(16) | Foreign-key identifier of the source linked at one dated causal disruption. A blank value, where permitted, means the relationship does not apply. |
| jurisdiction_id | varchar(8) | Foreign-key identifier of the jurisdiction linked at one dated causal disruption. A blank value, where permitted, means the relationship does not apply. |
| affected_material_id | varchar(40) | Foreign-key identifier of the affected material linked at one dated causal disruption. A blank value, where permitted, means the relationship does not apply. |
| affected_facility_id | varchar(16) | Foreign-key identifier of the affected facility linked at one dated causal disruption. A blank value, where permitted, means the relationship does not apply. |
| start_date_id | varchar(24) | Calendar key for start at one dated causal disruption; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
| end_date_id | varchar(24) | Calendar key for end at one dated causal disruption; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
+14 more columns in evb_disruption_events. The full schema ships with the download.
evb_organizations· Rows: 450
| Column | Type | Description |
|---|---|---|
| organization_id | varchar(16) | Stable synthetic identifier for one synthetic economic operator. Primary key; opaque text and never a transactional identifier. |
| jurisdiction_id | varchar(8) | Foreign-key identifier of the jurisdiction linked at one synthetic economic operator. A blank value, where permitted, means the relationship does not apply. |
| organization_code | varchar(16) | Stable controlled code for organization at one synthetic economic operator; where a matching name column exists, both values are asserted as one classification. |
| organization_name | varchar(48) | Coined synthetic economic-operator name. Accidental resemblance does not identify or affiliate a real organization. |
| legal_form | varchar(16) | Legal or physical form for legal at one synthetic economic operator; the text explains the coded or measured row without changing its status. |
| primary_role_code | varchar(32) | Stable controlled code for primary role at one synthetic economic operator; where a matching name column exists, both values are asserted as one classification. |
| primary_role_name | varchar(40) | Human-readable label for primary role at one synthetic economic operator; where a matching code exists, this is its asserted meaning rather than a second classification. |
+11 more columns in evb_organizations. The full schema ships with the download.
evb_organization_roles· Rows: 780
| Column | Type | Description |
|---|---|---|
| role_assignment_id | varchar(16) | Stable synthetic identifier for one effective-dated organization role assignment. Primary key; opaque text and never a transactional identifier. |
| organization_id | varchar(16) | Foreign-key identifier of the organization linked at one effective-dated organization role assignment. A blank value, where permitted, means the relationship does not apply. |
| instrument_id | varchar(16) | Foreign-key identifier of the instrument linked at one effective-dated organization role assignment. A blank value, where permitted, means the relationship does not apply. |
| role_code | varchar(40) | Stable controlled code for role at one effective-dated organization role assignment; where a matching name column exists, both values are asserted as one classification. |
| role_name | varchar(40) | Human-readable label for role at one effective-dated organization role assignment; where a matching code exists, this is its asserted meaning rather than a second classification. |
| regulated_operator_flag | boolean | Boolean indicator for regulated operator at one effective-dated organization role assignment; true and false describe the effective-time state, and blank is not a third state. |
| passport_responsible_flag | boolean | Boolean indicator for passport responsible at one effective-dated organization role assignment; true and false describe the effective-time state, and blank is not a third state. |
+6 more columns in evb_organization_roles. The full schema ships with the download.
evb_facilities· Rows: 840
| Column | Type | Description |
|---|---|---|
| facility_id | varchar(16) | Stable synthetic identifier for one synthetic operating facility. Primary key; opaque text and never a transactional identifier. |
| organization_id | varchar(16) | Foreign-key identifier of the organization linked at one synthetic operating facility. A blank value, where permitted, means the relationship does not apply. |
| jurisdiction_id | varchar(8) | Foreign-key identifier of the jurisdiction linked at one synthetic operating facility. A blank value, where permitted, means the relationship does not apply. |
| facility_code | varchar(16) | Stable controlled code for facility at one synthetic operating facility; where a matching name column exists, both values are asserted as one classification. |
| facility_name | varchar(104) | Human-readable label for facility at one synthetic operating facility; where a matching code exists, this is its asserted meaning rather than a second classification. |
| facility_type_code | varchar(40) | Stable controlled code for facility type at one synthetic operating facility; where a matching name column exists, both values are asserted as one classification. |
| facility_type_name | varchar(48) | Human-readable label for facility type at one synthetic operating facility; where a matching code exists, this is its asserted meaning rather than a second classification. |
+13 more columns in evb_facilities. The full schema ships with the download.
evb_people· Rows: 4,150
| Column | Type | Description |
|---|---|---|
| person_id | varchar(16) | Stable synthetic identifier for one synthetic responsible person. Primary key; opaque text and never a transactional identifier. |
| organization_id | varchar(16) | Foreign-key identifier of the organization linked at one synthetic responsible person. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one synthetic responsible person. A blank value, where permitted, means the relationship does not apply. |
| person_code | varchar(16) | Stable controlled code for person at one synthetic responsible person; where a matching name column exists, both values are asserted as one classification. |
| person_name | varchar(24) | Coined synthetic person name used only for responsibility lineage; it does not represent a real individual. |
| job_title | varchar(56) | Concise title for job at one synthetic responsible person; the text explains the coded or measured row without changing its status. |
| function_code | varchar(48) | Stable controlled code for function at one synthetic responsible person; where a matching name column exists, both values are asserted as one classification. |
+9 more columns in evb_people. The full schema ships with the download.
evb_materials· Rows: 56
| Column | Type | Description |
|---|---|---|
| material_id | varchar(40) | Stable synthetic identifier for one battery material reference. Primary key; opaque text and never a transactional identifier. |
| source_id | varchar(16) | Foreign-key identifier of the source linked at one battery material reference. A blank value, where permitted, means the relationship does not apply. |
| material_code | varchar(32) | Stable controlled code for material at one battery material reference; where a matching name column exists, both values are asserted as one classification. |
| material_name | varchar(80) | Human-readable label for material at one battery material reference; where a matching code exists, this is its asserted meaning rather than a second classification. |
| material_category_code | varchar(32) | Stable controlled code for material category at one battery material reference; where a matching name column exists, both values are asserted as one classification. |
| material_category_name | varchar(32) | Human-readable label for material category at one battery material reference; where a matching code exists, this is its asserted meaning rather than a second classification. |
| battery_role_code | varchar(40) | Stable controlled code for battery role at one battery material reference; where a matching name column exists, both values are asserted as one classification. |
+10 more columns in evb_materials. The full schema ships with the download.
evb_material_prices_monthly· Rows: 1,512
| Column | Type | Description |
|---|---|---|
| material_price_id | varchar(16) | Stable synthetic identifier for one material and source month price observation. Primary key; opaque text and never a transactional identifier. |
| material_id | varchar(40) | Foreign-key identifier of the material linked at one material and source month price observation. A blank value, where permitted, means the relationship does not apply. |
| month_start_date_id | varchar(24) | Calendar key for month start at one material and source month price observation; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
| source_id | varchar(16) | Foreign-key identifier of the source linked at one material and source month price observation. A blank value, where permitted, means the relationship does not apply. |
| currency_code | varchar(8) | ISO 4217 currency code for monetary values or the jurisdiction context. |
| price_unit_code | varchar(16) | Controlled measurement-unit code for price at one material and source month price observation; numeric values and uncertainty bounds use this same unit. |
| price_unit_name | varchar(24) | Human-readable measurement unit for price at one material and source month price observation; it defines the unit and denominator of the adjacent numeric value. |
+8 more columns in evb_material_prices_monthly. The full schema ships with the download.
evb_battery_chemistries· Rows: 9
| Column | Type | Description |
|---|---|---|
| chemistry_id | varchar(24) | Stable synthetic identifier for one battery chemistry reference. Primary key; opaque text and never a transactional identifier. |
| source_id | varchar(16) | Foreign-key identifier of the source linked at one battery chemistry reference. A blank value, where permitted, means the relationship does not apply. |
| chemistry_code | varchar(16) | Stable controlled code for chemistry at one battery chemistry reference; where a matching name column exists, both values are asserted as one classification. |
| chemistry_name | varchar(40) | Human-readable label for chemistry at one battery chemistry reference; where a matching code exists, this is its asserted meaning rather than a second classification. |
| cathode_family | varchar(40) | Engineering family classification for cathode at one battery chemistry reference; it groups compatible compositions rather than naming a specific product. |
| anode_family | varchar(24) | Engineering family classification for anode at one battery chemistry reference; it groups compatible compositions rather than naming a specific product. |
| electrolyte_family | varchar(32) | Engineering family classification for electrolyte at one battery chemistry reference; it groups compatible compositions rather than naming a specific product. |
+8 more columns in evb_battery_chemistries. The full schema ships with the download.
evb_cell_models· Rows: 36
| Column | Type | Description |
|---|---|---|
| cell_model_id | varchar(24) | Stable synthetic identifier for one synthetic cell model. Primary key; opaque text and never a transactional identifier. |
| manufacturer_organization_id | varchar(16) | Foreign-key identifier of the manufacturer organization linked at one synthetic cell model. A blank value, where permitted, means the relationship does not apply. |
| chemistry_id | varchar(24) | Foreign-key identifier of the chemistry linked at one synthetic cell model. A blank value, where permitted, means the relationship does not apply. |
| cell_model_code | varchar(24) | Stable controlled code for cell model at one synthetic cell model; where a matching name column exists, both values are asserted as one classification. |
| cell_model_name | varchar(96) | Human-readable label for cell model at one synthetic cell model; where a matching code exists, this is its asserted meaning rather than a second classification. |
| form_factor_code | varchar(24) | Stable controlled code for form factor at one synthetic cell model; where a matching name column exists, both values are asserted as one classification. |
| form_factor_name | varchar(32) | Human-readable label for form factor at one synthetic cell model; where a matching code exists, this is its asserted meaning rather than a second classification. |
+12 more columns in evb_cell_models. The full schema ships with the download.
evb_battery_models· Rows: 192
| Column | Type | Description |
|---|---|---|
| battery_model_id | varchar(24) | Stable synthetic identifier for one synthetic EV battery model. Primary key; opaque text and never a transactional identifier. |
| manufacturer_organization_id | varchar(16) | Foreign-key identifier of the manufacturer organization linked at one synthetic EV battery model. A blank value, where permitted, means the relationship does not apply. |
| responsible_organization_id | varchar(16) | Foreign-key identifier of the responsible organization linked at one synthetic EV battery model. A blank value, where permitted, means the relationship does not apply. |
| cell_model_id | varchar(24) | Foreign-key identifier of the cell model linked at one synthetic EV battery model. A blank value, where permitted, means the relationship does not apply. |
| battery_model_code | varchar(24) | Stable controlled code for battery model at one synthetic EV battery model; where a matching name column exists, both values are asserted as one classification. |
| battery_model_name | varchar(104) | Human-readable label for battery model at one synthetic EV battery model; where a matching code exists, this is its asserted meaning rather than a second classification. |
| battery_category_code | varchar(16) | Stable controlled code for battery category at one synthetic EV battery model; where a matching name column exists, both values are asserted as one classification. |
+29 more columns in evb_battery_models. The full schema ships with the download.
evb_model_components· Rows: 2,304
| Column | Type | Description |
|---|---|---|
| model_component_id | varchar(16) | Stable synthetic identifier for one effective-dated component in a battery model bill of materials. Primary key; opaque text and never a transactional identifier. |
| battery_model_id | varchar(24) | Foreign-key identifier of the battery model linked at one effective-dated component in a battery model bill of materials. A blank value, where permitted, means the relationship does not apply. |
| material_id | varchar(32) | Foreign-key identifier of the material linked at one effective-dated component in a battery model bill of materials. A blank value, where permitted, means the relationship does not apply. |
| supplier_organization_id | varchar(16) | Foreign-key identifier of the supplier organization linked at one effective-dated component in a battery model bill of materials. A blank value, where permitted, means the relationship does not apply. |
| component_part_code | varchar(24) | Stable controlled code for component part at one effective-dated component in a battery model bill of materials; where a matching name column exists, both values are asserted as one classification. |
| component_part_name | varchar(48) | Human-readable label for component part at one effective-dated component in a battery model bill of materials; where a matching code exists, this is its asserted meaning rather than a second classification. |
| component_type_code | varchar(32) | Stable controlled code for component type at one effective-dated component in a battery model bill of materials; where a matching name column exists, both values are asserted as one classification. |
+10 more columns in evb_model_components. The full schema ships with the download.
evb_model_materials· Rows: 1,920
| Column | Type | Description |
|---|---|---|
| model_material_id | varchar(16) | Stable synthetic identifier for one material composition line for a battery model. Primary key; opaque text and never a transactional identifier. |
| battery_model_id | varchar(24) | Foreign-key identifier of the battery model linked at one material composition line for a battery model. A blank value, where permitted, means the relationship does not apply. |
| material_id | varchar(40) | Foreign-key identifier of the material linked at one material composition line for a battery model. A blank value, where permitted, means the relationship does not apply. |
| component_zone_code | varchar(24) | Stable controlled code for component zone at one material composition line for a battery model; where a matching name column exists, both values are asserted as one classification. |
| component_zone_name | varchar(24) | Human-readable label for component zone at one material composition line for a battery model; where a matching code exists, this is its asserted meaning rather than a second classification. |
| material_mass_kg | numeric(7,2) | Material mass, expressed in kilograms, at one material composition line for a battery model. |
| material_mass_pct | integer | Material mass percentage, expressed as a percentage of total battery-pack mass for the model, at one material composition line for a battery model. |
+8 more columns in evb_model_materials. The full schema ships with the download.
evb_product_media· Rows: 48
| Column | Type | Description |
|---|---|---|
| media_asset_id | varchar(24) | Stable synthetic identifier for one governed media asset for a battery model. Primary key; opaque text and never a transactional identifier. |
| battery_model_id | varchar(24) | Foreign-key identifier of the battery model linked at one governed media asset for a battery model. A blank value, where permitted, means the relationship does not apply. |
| image_file | varchar(40) | Dataset-relative filename of the governed synthetic product image; blank means no approved file is claimed. |
| image_format | varchar(16) | Raster file format declared for the governed media asset. |
| image_width_px | integer | Image width, expressed in pixels, at one governed media asset for a battery model. |
| image_height_px | integer | Image height, expressed in pixels, at one governed media asset for a battery model. |
| background_mode | varchar(24) | Controlled background treatment for the media asset, including whether transparent isolation is required. |
+11 more columns in evb_product_media. The full schema ships with the download.
evb_dismantling_steps· Rows: 1,536
| Column | Type | Description |
|---|---|---|
| dismantling_step_id | varchar(16) | Stable synthetic identifier for one ordered dismantling step for a battery model. Primary key; opaque text and never a transactional identifier. |
| battery_model_id | varchar(24) | Foreign-key identifier of the battery model linked at one ordered dismantling step for a battery model. A blank value, where permitted, means the relationship does not apply. |
| model_component_id | varchar(16) | Foreign-key identifier of the model component linked at one ordered dismantling step for a battery model. A blank value, where permitted, means the relationship does not apply. |
| step_sequence | integer | Monotonic step ordering within its parent entity; it expresses order, not elapsed time. |
| step_code | varchar(24) | Stable controlled code for step at one ordered dismantling step for a battery model; where a matching name column exists, both values are asserted as one classification. |
| step_title | varchar(48) | Concise title for step at one ordered dismantling step for a battery model; the text explains the coded or measured row without changing its status. |
| tool_code | varchar(32) | Stable controlled code for tool at one ordered dismantling step for a battery model; where a matching name column exists, both values are asserted as one classification. |
+12 more columns in evb_dismantling_steps. The full schema ships with the download.
evb_sourcing_contracts· Rows: 1,200
| Column | Type | Description |
|---|---|---|
| sourcing_contract_id | varchar(16) | Stable synthetic identifier for one effective-dated material sourcing contract. Primary key; opaque text and never a transactional identifier. |
| buyer_organization_id | varchar(16) | Foreign-key identifier of the buyer organization linked at one effective-dated material sourcing contract. A blank value, where permitted, means the relationship does not apply. |
| supplier_organization_id | varchar(16) | Foreign-key identifier of the supplier organization linked at one effective-dated material sourcing contract. A blank value, where permitted, means the relationship does not apply. |
| material_id | varchar(24) | Foreign-key identifier of the material linked at one effective-dated material sourcing contract. A blank value, where permitted, means the relationship does not apply. |
| extraction_site_id | varchar(16) | Foreign-key identifier of the extraction site linked at one effective-dated material sourcing contract. A blank value, where permitted, means the relationship does not apply. |
| contract_code | varchar(24) | Stable controlled code for contract at one effective-dated material sourcing contract; where a matching name column exists, both values are asserted as one classification. |
| contract_type_code | varchar(24) | Stable controlled code for contract type at one effective-dated material sourcing contract; where a matching name column exists, both values are asserted as one classification. |
+15 more columns in evb_sourcing_contracts. The full schema ships with the download.
evb_extraction_sites· Rows: 240
| Column | Type | Description |
|---|---|---|
| extraction_site_id | varchar(16) | Stable synthetic identifier for one modelled mineral extraction site. Primary key; opaque text and never a transactional identifier. |
| operator_organization_id | varchar(16) | Foreign-key identifier of the operator organization linked at one modelled mineral extraction site. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one modelled mineral extraction site. A blank value, where permitted, means the relationship does not apply. |
| jurisdiction_id | varchar(8) | Foreign-key identifier of the jurisdiction linked at one modelled mineral extraction site. A blank value, where permitted, means the relationship does not apply. |
| source_id | varchar(16) | Foreign-key identifier of the source linked at one modelled mineral extraction site. A blank value, where permitted, means the relationship does not apply. |
| primary_material_id | varchar(24) | Foreign-key identifier of the primary material linked at one modelled mineral extraction site. A blank value, where permitted, means the relationship does not apply. |
| extraction_site_code | varchar(16) | Stable controlled code for extraction site at one modelled mineral extraction site; where a matching name column exists, both values are asserted as one classification. |
+13 more columns in evb_extraction_sites. The full schema ships with the download.
evb_material_lots· Rows: 18,000
| Column | Type | Description |
|---|---|---|
| material_lot_id | varchar(24) | Stable synthetic identifier for one traceable material lot. Primary key; opaque text and never a transactional identifier. |
| material_id | varchar(40) | Foreign-key identifier of the material linked at one traceable material lot. A blank value, where permitted, means the relationship does not apply. |
| supplier_organization_id | varchar(16) | Foreign-key identifier of the supplier organization linked at one traceable material lot. A blank value, where permitted, means the relationship does not apply. |
| extraction_site_id | varchar(16) | Foreign-key identifier of the extraction site linked at one traceable material lot. A blank value, where permitted, means the relationship does not apply. |
| sourcing_contract_id | varchar(16) | Foreign-key identifier of the sourcing contract linked at one traceable material lot. A blank value, where permitted, means the relationship does not apply. |
| current_facility_id | varchar(16) | Foreign-key identifier of the current facility linked at one traceable material lot. A blank value, where permitted, means the relationship does not apply. |
| parent_material_lot_id | varchar(24) | Foreign-key identifier of the parent material lot linked at one traceable material lot. A blank value, where permitted, means the relationship does not apply. |
+14 more columns in evb_material_lots. The full schema ships with the download.
evb_chain_of_custody_events· Rows: 30,000
| Column | Type | Description |
|---|---|---|
| custody_event_id | varchar(16) | Stable synthetic identifier for one custody movement or transformation of a material lot. Primary key; opaque text and never a transactional identifier. |
| material_lot_id | varchar(24) | Foreign-key identifier of the material lot linked at one custody movement or transformation of a material lot. A blank value, where permitted, means the relationship does not apply. |
| source_organization_id | varchar(16) | Foreign-key identifier of the source organization linked at one custody movement or transformation of a material lot. A blank value, where permitted, means the relationship does not apply. |
| destination_organization_id | varchar(16) | Foreign-key identifier of the destination organization linked at one custody movement or transformation of a material lot. A blank value, where permitted, means the relationship does not apply. |
| source_facility_id | varchar(16) | Foreign-key identifier of the source facility linked at one custody movement or transformation of a material lot. A blank value, where permitted, means the relationship does not apply. |
| destination_facility_id | varchar(16) | Foreign-key identifier of the destination facility linked at one custody movement or transformation of a material lot. A blank value, where permitted, means the relationship does not apply. |
| event_date_id | varchar(24) | Calendar key for event at one custody movement or transformation of a material lot; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
+16 more columns in evb_chain_of_custody_events. The full schema ships with the download.
evb_due_diligence_assessments· Rows: 2,800
| Column | Type | Description |
|---|---|---|
| due_diligence_id | varchar(16) | Stable synthetic identifier for one responsible-sourcing due-diligence assessment. Primary key; opaque text and never a transactional identifier. |
| assessed_organization_id | varchar(16) | Foreign-key identifier of the assessed organization linked at one responsible-sourcing due-diligence assessment. A blank value, where permitted, means the relationship does not apply. |
| sourcing_contract_id | varchar(16) | Foreign-key identifier of the sourcing contract linked at one responsible-sourcing due-diligence assessment. A blank value, where permitted, means the relationship does not apply. |
| extraction_site_id | varchar(16) | Foreign-key identifier of the extraction site linked at one responsible-sourcing due-diligence assessment. A blank value, where permitted, means the relationship does not apply. |
| material_id | varchar(24) | Foreign-key identifier of the material linked at one responsible-sourcing due-diligence assessment. A blank value, where permitted, means the relationship does not apply. |
| instrument_id | varchar(16) | Foreign-key identifier of the instrument linked at one responsible-sourcing due-diligence assessment. A blank value, where permitted, means the relationship does not apply. |
| assessor_person_id | varchar(16) | Foreign-key identifier of the assessor person linked at one responsible-sourcing due-diligence assessment. A blank value, where permitted, means the relationship does not apply. |
+17 more columns in evb_due_diligence_assessments. The full schema ships with the download.
evb_recycled_content_claims· Rows: 4,800
| Column | Type | Description |
|---|---|---|
| recycled_claim_id | varchar(16) | Stable synthetic identifier for one verified recycled-content claim. Primary key; opaque text and never a transactional identifier. |
| battery_model_id | varchar(24) | Foreign-key identifier of the battery model linked at one verified recycled-content claim. A blank value, where permitted, means the relationship does not apply. |
| production_order_id | varchar(16) | Foreign-key identifier of the production order linked at one verified recycled-content claim. A blank value, where permitted, means the relationship does not apply. |
| material_id | varchar(24) | Foreign-key identifier of the material linked at one verified recycled-content claim. A blank value, where permitted, means the relationship does not apply. |
| supplier_organization_id | varchar(16) | Foreign-key identifier of the supplier organization linked at one verified recycled-content claim. A blank value, where permitted, means the relationship does not apply. |
| verifier_organization_id | varchar(16) | Foreign-key identifier of the verifier organization linked at one verified recycled-content claim. A blank value, where permitted, means the relationship does not apply. |
| claim_code | varchar(24) | Stable controlled code for claim at one verified recycled-content claim; where a matching name column exists, both values are asserted as one classification. |
+14 more columns in evb_recycled_content_claims. The full schema ships with the download.
evb_production_orders· Rows: 4,500
| Column | Type | Description |
|---|---|---|
| production_order_id | varchar(16) | Stable synthetic identifier for one battery-pack production order. Primary key; opaque text and never a transactional identifier. |
| manufacturer_organization_id | varchar(16) | Foreign-key identifier of the manufacturer organization linked at one battery-pack production order. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one battery-pack production order. A blank value, where permitted, means the relationship does not apply. |
| battery_model_id | varchar(24) | Foreign-key identifier of the battery model linked at one battery-pack production order. A blank value, where permitted, means the relationship does not apply. |
| disruption_id | varchar(16) | Foreign-key identifier of the disruption linked at one battery-pack production order. A blank value, where permitted, means the relationship does not apply. |
| production_order_code | varchar(24) | Stable controlled code for production order at one battery-pack production order; where a matching name column exists, both values are asserted as one classification. |
| planned_start_date_id | varchar(24) | Calendar key for planned start at one battery-pack production order; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
+12 more columns in evb_production_orders. The full schema ships with the download.
evb_material_consumptions· Rows: 18,000
| Column | Type | Description |
|---|---|---|
| material_consumption_id | varchar(16) | Stable synthetic identifier for one material-lot consumption line on a production order. Primary key; opaque text and never a transactional identifier. |
| production_order_id | varchar(16) | Foreign-key identifier of the production order linked at one material-lot consumption line on a production order. A blank value, where permitted, means the relationship does not apply. |
| material_lot_id | varchar(24) | Foreign-key identifier of the material lot linked at one material-lot consumption line on a production order. A blank value, where permitted, means the relationship does not apply. |
| material_id | varchar(24) | Foreign-key identifier of the material linked at one material-lot consumption line on a production order. A blank value, where permitted, means the relationship does not apply. |
| line_number | varchar(8) | Sequence number of the material-consumption line within its production order. |
| consumption_timestamp | varchar(32) | ISO 8601 UTC timestamp for consumption at one material-lot consumption line on a production order; ordering and effective-time tests use this value. |
| planned_quantity_kg | numeric(11,5) | Planned quantity, expressed in kilograms, at one material-lot consumption line on a production order. |
+9 more columns in evb_material_consumptions. The full schema ships with the download.
evb_cell_production_lots· Rows: 13,500
| Column | Type | Description |
|---|---|---|
| cell_lot_id | varchar(24) | Stable synthetic identifier for one manufactured cell lot. Primary key; opaque text and never a transactional identifier. |
| production_order_id | varchar(16) | Foreign-key identifier of the production order linked at one manufactured cell lot. A blank value, where permitted, means the relationship does not apply. |
| cell_model_id | varchar(24) | Foreign-key identifier of the cell model linked at one manufactured cell lot. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one manufactured cell lot. A blank value, where permitted, means the relationship does not apply. |
| cathode_material_lot_id | varchar(24) | Foreign-key identifier of the cathode material lot linked at one manufactured cell lot. A blank value, where permitted, means the relationship does not apply. |
| anode_material_lot_id | varchar(24) | Foreign-key identifier of the anode material lot linked at one manufactured cell lot. A blank value, where permitted, means the relationship does not apply. |
| electrolyte_material_lot_id | varchar(24) | Foreign-key identifier of the electrolyte material lot linked at one manufactured cell lot. A blank value, where permitted, means the relationship does not apply. |
+12 more columns in evb_cell_production_lots. The full schema ships with the download.
evb_module_units· Rows: 67,500
| Column | Type | Description |
|---|---|---|
| module_id | varchar(16) | Stable synthetic identifier for one serialized battery module. Primary key; opaque text and never a transactional identifier. |
| cell_lot_id | varchar(24) | Foreign-key identifier of the cell lot linked at one serialized battery module. A blank value, where permitted, means the relationship does not apply. |
| battery_model_id | varchar(24) | Foreign-key identifier of the battery model linked at one serialized battery module. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one serialized battery module. A blank value, where permitted, means the relationship does not apply. |
| module_serial_number | varchar(40) | Synthetic module serial number. It is unregistered and non-transactional. |
| build_date_id | varchar(24) | Calendar key for build at one serialized battery module; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
| cell_quantity | integer | Count of cells assembled into the serialized module. |
+9 more columns in evb_module_units. The full schema ships with the download.
evb_battery_packs· Rows: 45,000
| Column | Type | Description |
|---|---|---|
| battery_pack_id | varchar(16) | Stable synthetic identifier for one serialized EV battery pack. Primary key; opaque text and never a transactional identifier. |
| production_order_id | varchar(16) | Foreign-key identifier of the production order linked at one serialized EV battery pack. A blank value, where permitted, means the relationship does not apply. |
| battery_model_id | varchar(24) | Foreign-key identifier of the battery model linked at one serialized EV battery pack. A blank value, where permitted, means the relationship does not apply. |
| manufacturing_facility_id | varchar(16) | Foreign-key identifier of the manufacturing facility linked at one serialized EV battery pack. A blank value, where permitted, means the relationship does not apply. |
| responsible_organization_id | varchar(16) | Foreign-key identifier of the responsible organization linked at one serialized EV battery pack. A blank value, where permitted, means the relationship does not apply. |
| current_owner_organization_id | varchar(16) | Foreign-key identifier of the current owner organization linked at one serialized EV battery pack. A blank value, where permitted, means the relationship does not apply. |
| carbon_declaration_id | varchar(16) | Foreign-key identifier of the carbon declaration linked at one serialized EV battery pack. A blank value, where permitted, means the relationship does not apply. |
+17 more columns in evb_battery_packs. The full schema ships with the download.
evb_pack_module_assignments· Rows: 67,500
| Column | Type | Description |
|---|---|---|
| pack_module_assignment_id | varchar(16) | Stable synthetic identifier for one effective module position assignment in a battery pack. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one effective module position assignment in a battery pack. A blank value, where permitted, means the relationship does not apply. |
| module_id | varchar(16) | Foreign-key identifier of the module linked at one effective module position assignment in a battery pack. A blank value, where permitted, means the relationship does not apply. |
| assignment_position_code | varchar(8) | Stable controlled code for assignment position at one effective module position assignment in a battery pack; where a matching name column exists, both values are asserted as one classification. |
| assignment_position_name | varchar(24) | Human-readable label for assignment position at one effective module position assignment in a battery pack; where a matching code exists, this is its asserted meaning rather than a second classification. |
| installed_timestamp | varchar(32) | ISO 8601 UTC timestamp for installed at one effective module position assignment in a battery pack; ordering and effective-time tests use this value. |
| removed_timestamp | text | ISO 8601 UTC timestamp for removed at one effective module position assignment in a battery pack; ordering and effective-time tests use this value. |
+6 more columns in evb_pack_module_assignments. The full schema ships with the download.
evb_manufacturing_events· Rows: 45,000
| Column | Type | Description |
|---|---|---|
| manufacturing_event_id | varchar(16) | Stable synthetic identifier for one timestamped manufacturing lineage event. Primary key; opaque text and never a transactional identifier. |
| production_order_id | varchar(16) | Foreign-key identifier of the production order linked at one timestamped manufacturing lineage event. A blank value, where permitted, means the relationship does not apply. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one timestamped manufacturing lineage event. A blank value, where permitted, means the relationship does not apply. |
| module_id | varchar(16) | Foreign-key identifier of the module linked at one timestamped manufacturing lineage event. A blank value, where permitted, means the relationship does not apply. |
| cell_lot_id | varchar(24) | Foreign-key identifier of the cell lot linked at one timestamped manufacturing lineage event. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one timestamped manufacturing lineage event. A blank value, where permitted, means the relationship does not apply. |
| operator_person_id | varchar(16) | Foreign-key identifier of the operator person linked at one timestamped manufacturing lineage event. A blank value, where permitted, means the relationship does not apply. |
+14 more columns in evb_manufacturing_events. The full schema ships with the download.
evb_quality_tests· Rows: 90,000
| Column | Type | Description |
|---|---|---|
| quality_test_id | varchar(16) | Stable synthetic identifier for one quality measurement or release test. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one quality measurement or release test. A blank value, where permitted, means the relationship does not apply. |
| module_id | varchar(16) | Foreign-key identifier of the module linked at one quality measurement or release test. A blank value, where permitted, means the relationship does not apply. |
| cell_lot_id | varchar(24) | Foreign-key identifier of the cell lot linked at one quality measurement or release test. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one quality measurement or release test. A blank value, where permitted, means the relationship does not apply. |
| tester_person_id | varchar(16) | Foreign-key identifier of the tester person linked at one quality measurement or release test. A blank value, where permitted, means the relationship does not apply. |
| test_code | varchar(48) | Stable controlled code for test at one quality measurement or release test; where a matching name column exists, both values are asserted as one classification. |
+15 more columns in evb_quality_tests. The full schema ships with the download.
evb_nonconformities· Rows: 2,700
| Column | Type | Description |
|---|---|---|
| nonconformity_id | varchar(16) | Stable synthetic identifier for one detected manufacturing nonconformity. Primary key; opaque text and never a transactional identifier. |
| quality_test_id | varchar(16) | Foreign-key identifier of the quality test linked at one detected manufacturing nonconformity. A blank value, where permitted, means the relationship does not apply. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one detected manufacturing nonconformity. A blank value, where permitted, means the relationship does not apply. |
| module_id | varchar(16) | Foreign-key identifier of the module linked at one detected manufacturing nonconformity. A blank value, where permitted, means the relationship does not apply. |
| cell_lot_id | varchar(24) | Foreign-key identifier of the cell lot linked at one detected manufacturing nonconformity. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one detected manufacturing nonconformity. A blank value, where permitted, means the relationship does not apply. |
| nonconformity_code | varchar(24) | Stable controlled code for nonconformity at one detected manufacturing nonconformity; where a matching name column exists, both values are asserted as one classification. |
+13 more columns in evb_nonconformities. The full schema ships with the download.
evb_corrective_actions· Rows: 4,050
| Column | Type | Description |
|---|---|---|
| corrective_action_id | varchar(16) | Stable synthetic identifier for one corrective action for a manufacturing nonconformity. Primary key; opaque text and never a transactional identifier. |
| nonconformity_id | varchar(16) | Foreign-key identifier of the nonconformity linked at one corrective action for a manufacturing nonconformity. A blank value, where permitted, means the relationship does not apply. |
| owner_person_id | varchar(16) | Foreign-key identifier of the owner person linked at one corrective action for a manufacturing nonconformity. A blank value, where permitted, means the relationship does not apply. |
| action_code | varchar(48) | Stable controlled code for action at one corrective action for a manufacturing nonconformity; where a matching name column exists, both values are asserted as one classification. |
| root_cause_code | varchar(32) | Stable controlled code for root cause at one corrective action for a manufacturing nonconformity; where a matching name column exists, both values are asserted as one classification. |
| root_cause_name | varchar(32) | Human-readable label for root cause at one corrective action for a manufacturing nonconformity; where a matching code exists, this is its asserted meaning rather than a second classification. |
| action_type_code | varchar(32) | Stable controlled code for action type at one corrective action for a manufacturing nonconformity; where a matching name column exists, both values are asserted as one classification. |
+11 more columns in evb_corrective_actions. The full schema ships with the download.
evb_carbon_footprint_declarations· Rows: 4,500
| Column | Type | Description |
|---|---|---|
| carbon_declaration_id | varchar(16) | Stable synthetic identifier for one verified pack-model carbon-footprint declaration. Primary key; opaque text and never a transactional identifier. |
| production_order_id | varchar(16) | Foreign-key identifier of the production order linked at one verified pack-model carbon-footprint declaration. A blank value, where permitted, means the relationship does not apply. |
| battery_model_id | varchar(24) | Foreign-key identifier of the battery model linked at one verified pack-model carbon-footprint declaration. A blank value, where permitted, means the relationship does not apply. |
| manufacturer_org_id | varchar(16) | Foreign-key identifier of the manufacturer org linked at one verified pack-model carbon-footprint declaration. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one verified pack-model carbon-footprint declaration. A blank value, where permitted, means the relationship does not apply. |
| verifier_org_id | varchar(16) | Foreign-key identifier of the verifier org linked at one verified pack-model carbon-footprint declaration. A blank value, where permitted, means the relationship does not apply. |
| source_id | varchar(16) | Foreign-key identifier of the source linked at one verified pack-model carbon-footprint declaration. A blank value, where permitted, means the relationship does not apply. |
+16 more columns in evb_carbon_footprint_declarations. The full schema ships with the download.
evb_carbon_footprint_stages· Rows: 31,500
| Column | Type | Description |
|---|---|---|
| carbon_stage_id | varchar(16) | Stable synthetic identifier for one life-cycle stage contribution to a carbon declaration. Primary key; opaque text and never a transactional identifier. |
| carbon_declaration_id | varchar(16) | Foreign-key identifier of the carbon declaration linked at one life-cycle stage contribution to a carbon declaration. A blank value, where permitted, means the relationship does not apply. |
| material_id | varchar(40) | Foreign-key identifier of the material linked at one life-cycle stage contribution to a carbon declaration. A blank value, where permitted, means the relationship does not apply. |
| source_id | varchar(16) | Foreign-key identifier of the source linked at one life-cycle stage contribution to a carbon declaration. A blank value, where permitted, means the relationship does not apply. |
| life_cycle_stage_code | varchar(40) | Stable controlled code for life cycle stage at one life-cycle stage contribution to a carbon declaration; where a matching name column exists, both values are asserted as one classification. |
| life_cycle_stage_name | varchar(56) | Human-readable label for life cycle stage at one life-cycle stage contribution to a carbon declaration; where a matching code exists, this is its asserted meaning rather than a second classification. |
| geography_code | varchar(8) | Stable controlled code for geography at one life-cycle stage contribution to a carbon declaration; where a matching name column exists, both values are asserted as one classification. |
+12 more columns in evb_carbon_footprint_stages. The full schema ships with the download.
evb_conformity_declarations· Rows: 1,344
| Column | Type | Description |
|---|---|---|
| conformity_declaration_id | varchar(16) | Stable synthetic identifier for one battery-model conformity declaration. Primary key; opaque text and never a transactional identifier. |
| battery_model_id | varchar(24) | Foreign-key identifier of the battery model linked at one battery-model conformity declaration. A blank value, where permitted, means the relationship does not apply. |
| manufacturer_organization_id | varchar(16) | Foreign-key identifier of the manufacturer organization linked at one battery-model conformity declaration. A blank value, where permitted, means the relationship does not apply. |
| assessor_organization_id | varchar(16) | Foreign-key identifier of the assessor organization linked at one battery-model conformity declaration. A blank value, where permitted, means the relationship does not apply. |
| instrument_id | varchar(16) | Foreign-key identifier of the instrument linked at one battery-model conformity declaration. A blank value, where permitted, means the relationship does not apply. |
| declaration_code | varchar(40) | Stable controlled code for declaration at one battery-model conformity declaration; where a matching name column exists, both values are asserted as one classification. |
| conformity_module_code | varchar(24) | Stable controlled code for conformity module at one battery-model conformity declaration; where a matching name column exists, both values are asserted as one classification. |
+8 more columns in evb_conformity_declarations. The full schema ships with the download.
evb_passports· Rows: 14,000
| Column | Type | Description |
|---|---|---|
| passport_id | varchar(32) | Stable synthetic identifier for one original or successor battery passport. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one original or successor battery passport. A blank value, where permitted, means the relationship does not apply. |
| battery_model_id | varchar(24) | Foreign-key identifier of the battery model linked at one original or successor battery passport. A blank value, where permitted, means the relationship does not apply. |
| responsible_organization_id | varchar(16) | Foreign-key identifier of the responsible organization linked at one original or successor battery passport. A blank value, where permitted, means the relationship does not apply. |
| predecessor_passport_id | varchar(32) | Foreign-key identifier of the predecessor passport linked at one original or successor battery passport. A blank value, where permitted, means the relationship does not apply. |
| passport_unique_identifier | varchar(56) | Synthetic unregistered battery-passport identifier. It must not be submitted to a real registry. |
| qr_payload | varchar(104) | Synthetic non-actionable QR payload for the passport. It must not be encoded, scanned or submitted to a real service. |
+11 more columns in evb_passports. The full schema ships with the download.
evb_passport_revisions· Rows: 28,000
| Column | Type | Description |
|---|---|---|
| passport_revision_id | varchar(24) | Stable synthetic identifier for one signed revision of a battery passport. Primary key; opaque text and never a transactional identifier. |
| passport_id | varchar(32) | Foreign-key identifier of the passport linked at one signed revision of a battery passport. A blank value, where permitted, means the relationship does not apply. |
| previous_revision_id | varchar(24) | Foreign-key identifier of the previous revision linked at one signed revision of a battery passport. A blank value, where permitted, means the relationship does not apply. |
| revision_code | varchar(24) | Stable controlled code for revision at one signed revision of a battery passport; where a matching name column exists, both values are asserted as one classification. |
| revision_sequence | integer | Monotonic revision number within one passport, starting with its baseline revision. |
| published_timestamp | varchar(32) | ISO 8601 UTC timestamp for published at one signed revision of a battery passport; ordering and effective-time tests use this value. |
| valid_from_timestamp | varchar(32) | ISO 8601 UTC timestamp for valid from at one signed revision of a battery passport; ordering and effective-time tests use this value. |
+12 more columns in evb_passport_revisions. The full schema ships with the download.
evb_passport_values· Rows: 994,000
| Column | Type | Description |
|---|---|---|
| passport_value_id | varchar(24) | Stable synthetic identifier for one passport, revision and catalogue data-point value. Primary key; opaque text and never a transactional identifier. |
| passport_id | varchar(32) | Foreign-key identifier of the passport linked at one passport, revision and catalogue data-point value. A blank value, where permitted, means the relationship does not apply. |
| passport_revision_id | varchar(24) | Foreign-key identifier of the passport revision linked at one passport, revision and catalogue data-point value. A blank value, where permitted, means the relationship does not apply. |
| data_point_id | varchar(8) | Foreign-key identifier of the data point linked at one passport, revision and catalogue data-point value. A blank value, where permitted, means the relationship does not apply. |
| value_text | varchar(408) | Text representation of the passport data-point value. Status fields distinguish populated, conditional and EV-inapplicable values. |
| numeric_value | numeric(15,7) | Numeric representation of the passport data-point value when value_type permits it, measured in unit_code and unit_name. |
| unit_code | varchar(40) | Stable controlled code for unit at one passport, revision and catalogue data-point value; where a matching name column exists, both values are asserted as one classification. |
+12 more columns in evb_passport_values. The full schema ships with the download.
evb_passport_access_events· Rows: 28,000
| Column | Type | Description |
|---|---|---|
| access_event_id | varchar(24) | Stable synthetic identifier for one authenticated request for a passport data point. Primary key; opaque text and never a transactional identifier. |
| passport_id | varchar(32) | Foreign-key identifier of the passport linked at one authenticated request for a passport data point. A blank value, where permitted, means the relationship does not apply. |
| data_point_id | varchar(8) | Foreign-key identifier of the data point linked at one authenticated request for a passport data point. A blank value, where permitted, means the relationship does not apply. |
| requester_organization_id | varchar(16) | Foreign-key identifier of the requester organization linked at one authenticated request for a passport data point. A blank value, where permitted, means the relationship does not apply. |
| requester_person_id | varchar(16) | Foreign-key identifier of the requester person linked at one authenticated request for a passport data point. A blank value, where permitted, means the relationship does not apply. |
| event_timestamp | varchar(32) | ISO 8601 UTC timestamp for event at one authenticated request for a passport data point; ordering and effective-time tests use this value. |
| requester_type_code | varchar(32) | Stable controlled code for requester type at one authenticated request for a passport data point; where a matching name column exists, both values are asserted as one classification. |
+12 more columns in evb_passport_access_events. The full schema ships with the download.
evb_vehicle_models· Rows: 48
| Column | Type | Description |
|---|---|---|
| vehicle_model_id | varchar(32) | Stable synthetic identifier for one synthetic electric-vehicle model. Primary key; opaque text and never a transactional identifier. |
| manufacturer_organization_id | varchar(16) | Foreign-key identifier of the manufacturer organization linked at one synthetic electric-vehicle model. A blank value, where permitted, means the relationship does not apply. |
| recommended_battery_model_id | varchar(24) | Foreign-key identifier of the recommended battery model linked at one synthetic electric-vehicle model. A blank value, where permitted, means the relationship does not apply. |
| vehicle_model_code | varchar(32) | Stable controlled code for vehicle model at one synthetic electric-vehicle model; where a matching name column exists, both values are asserted as one classification. |
| vehicle_model_name | varchar(64) | Human-readable label for vehicle model at one synthetic electric-vehicle model; where a matching code exists, this is its asserted meaning rather than a second classification. |
| vehicle_segment_code | varchar(16) | Stable controlled code for vehicle segment at one synthetic electric-vehicle model; where a matching name column exists, both values are asserted as one classification. |
| vehicle_segment_name | varchar(40) | Human-readable label for vehicle segment at one synthetic electric-vehicle model; where a matching code exists, this is its asserted meaning rather than a second classification. |
+11 more columns in evb_vehicle_models. The full schema ships with the download.
evb_vehicles· Rows: 14,000
| Column | Type | Description |
|---|---|---|
| vehicle_id | varchar(24) | Stable synthetic identifier for one synthetic operated vehicle. Primary key; opaque text and never a transactional identifier. |
| vehicle_model_id | varchar(32) | Foreign-key identifier of the vehicle model linked at one synthetic operated vehicle. A blank value, where permitted, means the relationship does not apply. |
| owner_organization_id | varchar(16) | Foreign-key identifier of the owner organization linked at one synthetic operated vehicle. A blank value, where permitted, means the relationship does not apply. |
| operating_facility_id | varchar(16) | Foreign-key identifier of the operating facility linked at one synthetic operated vehicle. A blank value, where permitted, means the relationship does not apply. |
| jurisdiction_id | varchar(8) | Foreign-key identifier of the jurisdiction linked at one synthetic operated vehicle. A blank value, where permitted, means the relationship does not apply. |
| vehicle_code | varchar(24) | Stable controlled code for vehicle at one synthetic operated vehicle; where a matching name column exists, both values are asserted as one classification. |
| synthetic_vin | varchar(24) | Format-shaped synthetic vehicle identifier. It is unregistered and must not be used for registration, service or insurance. |
+9 more columns in evb_vehicles. The full schema ships with the download.
evb_battery_installations· Rows: 15,000
| Column | Type | Description |
|---|---|---|
| installation_id | varchar(24) | Stable synthetic identifier for one pack installation period in a vehicle. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one pack installation period in a vehicle. A blank value, where permitted, means the relationship does not apply. |
| vehicle_id | varchar(24) | Foreign-key identifier of the vehicle linked at one pack installation period in a vehicle. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one pack installation period in a vehicle. A blank value, where permitted, means the relationship does not apply. |
| technician_person_id | varchar(16) | Foreign-key identifier of the technician person linked at one pack installation period in a vehicle. A blank value, where permitted, means the relationship does not apply. |
| installation_code | varchar(24) | Stable controlled code for installation at one pack installation period in a vehicle; where a matching name column exists, both values are asserted as one classification. |
| installed_timestamp | varchar(32) | ISO 8601 UTC timestamp for installed at one pack installation period in a vehicle; ordering and effective-time tests use this value. |
+9 more columns in evb_battery_installations. The full schema ships with the download.
evb_ownership_periods· Rows: 18,000
| Column | Type | Description |
|---|---|---|
| ownership_period_id | varchar(24) | Stable synthetic identifier for one effective vehicle and pack ownership period. Primary key; opaque text and never a transactional identifier. |
| vehicle_id | varchar(24) | Foreign-key identifier of the vehicle linked at one effective vehicle and pack ownership period. A blank value, where permitted, means the relationship does not apply. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one effective vehicle and pack ownership period. A blank value, where permitted, means the relationship does not apply. |
| owner_organization_id | varchar(16) | Foreign-key identifier of the owner organization linked at one effective vehicle and pack ownership period. A blank value, where permitted, means the relationship does not apply. |
| jurisdiction_id | varchar(8) | Foreign-key identifier of the jurisdiction linked at one effective vehicle and pack ownership period. A blank value, where permitted, means the relationship does not apply. |
| ownership_code | varchar(24) | Stable controlled code for ownership at one effective vehicle and pack ownership period; where a matching name column exists, both values are asserted as one classification. |
| start_date_id | varchar(24) | Calendar key for start at one effective vehicle and pack ownership period; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
+9 more columns in evb_ownership_periods. The full schema ships with the download.
evb_charging_sessions· Rows: 28,000
| Column | Type | Description |
|---|---|---|
| charging_session_id | varchar(24) | Stable synthetic identifier for one representative sampled charging session. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one representative sampled charging session. A blank value, where permitted, means the relationship does not apply. |
| vehicle_id | varchar(24) | Foreign-key identifier of the vehicle linked at one representative sampled charging session. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one representative sampled charging session. A blank value, where permitted, means the relationship does not apply. |
| owner_organization_id | varchar(16) | Foreign-key identifier of the owner organization linked at one representative sampled charging session. A blank value, where permitted, means the relationship does not apply. |
| date_id | varchar(24) | Foreign-key identifier of the date linked at one representative sampled charging session. A blank value, where permitted, means the relationship does not apply. |
| weather_observation_id | varchar(16) | Foreign-key identifier of the weather observation linked at one representative sampled charging session. A blank value, where permitted, means the relationship does not apply. |
+19 more columns in evb_charging_sessions. The full schema ships with the download.
evb_drive_sessions· Rows: 28,000
| Column | Type | Description |
|---|---|---|
| drive_session_id | varchar(24) | Stable synthetic identifier for one representative sampled drive session. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one representative sampled drive session. A blank value, where permitted, means the relationship does not apply. |
| vehicle_id | varchar(24) | Foreign-key identifier of the vehicle linked at one representative sampled drive session. A blank value, where permitted, means the relationship does not apply. |
| date_id | varchar(24) | Foreign-key identifier of the date linked at one representative sampled drive session. A blank value, where permitted, means the relationship does not apply. |
| weather_observation_id | varchar(16) | Foreign-key identifier of the weather observation linked at one representative sampled drive session. A blank value, where permitted, means the relationship does not apply. |
| drive_session_code | varchar(32) | Stable controlled code for drive session at one representative sampled drive session; where a matching name column exists, both values are asserted as one classification. |
| start_timestamp | varchar(32) | ISO 8601 UTC timestamp for start at one representative sampled drive session; ordering and effective-time tests use this value. |
+15 more columns in evb_drive_sessions. The full schema ships with the download.
evb_operational_telemetry· Rows: 70,000
| Column | Type | Description |
|---|---|---|
| telemetry_record_id | varchar(24) | Stable synthetic identifier for one representative periodic operating snapshot. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one representative periodic operating snapshot. A blank value, where permitted, means the relationship does not apply. |
| vehicle_id | varchar(24) | Foreign-key identifier of the vehicle linked at one representative periodic operating snapshot. A blank value, where permitted, means the relationship does not apply. |
| charging_session_id | varchar(24) | Foreign-key identifier of the charging session linked at one representative periodic operating snapshot. A blank value, where permitted, means the relationship does not apply. |
| drive_session_id | varchar(24) | Foreign-key identifier of the drive session linked at one representative periodic operating snapshot. A blank value, where permitted, means the relationship does not apply. |
| date_id | varchar(24) | Foreign-key identifier of the date linked at one representative periodic operating snapshot. A blank value, where permitted, means the relationship does not apply. |
| telemetry_timestamp | varchar(32) | ISO 8601 UTC timestamp for telemetry at one representative periodic operating snapshot; ordering and effective-time tests use this value. |
+15 more columns in evb_operational_telemetry. The full schema ships with the download.
evb_charge_cycles· Rows: 112,000
| Column | Type | Description |
|---|---|---|
| charge_cycle_id | varchar(24) | Stable synthetic identifier for one summarized pack usage-cycle period. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one summarized pack usage-cycle period. A blank value, where permitted, means the relationship does not apply. |
| vehicle_id | varchar(24) | Foreign-key identifier of the vehicle linked at one summarized pack usage-cycle period. A blank value, where permitted, means the relationship does not apply. |
| representative_charging_session_id | varchar(24) | Foreign-key identifier of the representative charging session linked at one summarized pack usage-cycle period. A blank value, where permitted, means the relationship does not apply. |
| cycle_code | varchar(24) | Stable controlled code for cycle at one summarized pack usage-cycle period; where a matching name column exists, both values are asserted as one classification. |
| cycle_sequence | integer | Monotonic cycle-summary period number within the battery pack. |
| period_start_date_id | varchar(24) | Calendar key for period start at one summarized pack usage-cycle period; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
+13 more columns in evb_charge_cycles. The full schema ships with the download.
evb_state_of_health_assessments· Rows: 42,000
| Column | Type | Description |
|---|---|---|
| state_of_health_id | varchar(24) | Stable synthetic identifier for one dated battery-pack state-of-health assessment. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one dated battery-pack state-of-health assessment. A blank value, where permitted, means the relationship does not apply. |
| passport_id | varchar(32) | Foreign-key identifier of the passport linked at one dated battery-pack state-of-health assessment. A blank value, where permitted, means the relationship does not apply. |
| assessor_organization_id | varchar(16) | Foreign-key identifier of the assessor organization linked at one dated battery-pack state-of-health assessment. A blank value, where permitted, means the relationship does not apply. |
| assessor_person_id | varchar(16) | Foreign-key identifier of the assessor person linked at one dated battery-pack state-of-health assessment. A blank value, where permitted, means the relationship does not apply. |
| assessment_date_id | varchar(24) | Calendar key for assessment at one dated battery-pack state-of-health assessment; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
| assessment_code | varchar(24) | Stable controlled code for assessment at one dated battery-pack state-of-health assessment; where a matching name column exists, both values are asserted as one classification. |
+20 more columns in evb_state_of_health_assessments. The full schema ships with the download.
evb_degradation_forecasts· Rows: 14,000
| Column | Type | Description |
|---|---|---|
| degradation_forecast_id | varchar(24) | Stable synthetic identifier for one pack, origin, horizon and scenario degradation forecast. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one pack, origin, horizon and scenario degradation forecast. A blank value, where permitted, means the relationship does not apply. |
| state_of_health_id | varchar(24) | Foreign-key identifier of the state of health linked at one pack, origin, horizon and scenario degradation forecast. A blank value, where permitted, means the relationship does not apply. |
| forecast_origin_date_id | varchar(24) | Calendar key for forecast origin at one pack, origin, horizon and scenario degradation forecast; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
| forecast_horizon_date_id | varchar(24) | Calendar key for forecast horizon at one pack, origin, horizon and scenario degradation forecast; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
| forecast_model_code | varchar(40) | Stable controlled code for forecast model at one pack, origin, horizon and scenario degradation forecast; where a matching name column exists, both values are asserted as one classification. |
| forecast_model_name | varchar(64) | Human-readable label for forecast model at one pack, origin, horizon and scenario degradation forecast; where a matching code exists, this is its asserted meaning rather than a second classification. |
+15 more columns in evb_degradation_forecasts. The full schema ships with the download.
evb_safety_incidents· Rows: 700
| Column | Type | Description |
|---|---|---|
| safety_incident_id | varchar(40) | Stable synthetic identifier for one battery safety incident. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one battery safety incident. A blank value, where permitted, means the relationship does not apply. |
| vehicle_id | varchar(24) | Foreign-key identifier of the vehicle linked at one battery safety incident. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one battery safety incident. A blank value, where permitted, means the relationship does not apply. |
| incident_date_id | varchar(24) | Calendar key for incident at one battery safety incident; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
| incident_code | varchar(24) | Stable controlled code for incident at one battery safety incident; where a matching name column exists, both values are asserted as one classification. |
| incident_type_code | varchar(24) | Stable controlled code for incident type at one battery safety incident; where a matching name column exists, both values are asserted as one classification. |
+17 more columns in evb_safety_incidents. The full schema ships with the download.
evb_service_work_orders· Rows: 4,200
| Column | Type | Description |
|---|---|---|
| service_work_order_id | varchar(40) | Stable synthetic identifier for one battery service work order. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one battery service work order. A blank value, where permitted, means the relationship does not apply. |
| vehicle_id | varchar(24) | Foreign-key identifier of the vehicle linked at one battery service work order. A blank value, where permitted, means the relationship does not apply. |
| service_facility_id | varchar(16) | Foreign-key identifier of the service facility linked at one battery service work order. A blank value, where permitted, means the relationship does not apply. |
| customer_organization_id | varchar(16) | Foreign-key identifier of the customer organization linked at one battery service work order. A blank value, where permitted, means the relationship does not apply. |
| owner_person_id | varchar(16) | Foreign-key identifier of the owner person linked at one battery service work order. A blank value, where permitted, means the relationship does not apply. |
| safety_incident_id | varchar(40) | Foreign-key identifier of the safety incident linked at one battery service work order. A blank value, where permitted, means the relationship does not apply. |
+16 more columns in evb_service_work_orders. The full schema ships with the download.
evb_service_actions· Rows: 8,400
| Column | Type | Description |
|---|---|---|
| service_action_id | varchar(24) | Stable synthetic identifier for one technician action within a service work order. Primary key; opaque text and never a transactional identifier. |
| service_work_order_id | varchar(40) | Foreign-key identifier of the service work order linked at one technician action within a service work order. A blank value, where permitted, means the relationship does not apply. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one technician action within a service work order. A blank value, where permitted, means the relationship does not apply. |
| module_id | varchar(16) | Foreign-key identifier of the module linked at one technician action within a service work order. A blank value, where permitted, means the relationship does not apply. |
| model_component_id | varchar(16) | Foreign-key identifier of the model component linked at one technician action within a service work order. A blank value, where permitted, means the relationship does not apply. |
| technician_person_id | varchar(16) | Foreign-key identifier of the technician person linked at one technician action within a service work order. A blank value, where permitted, means the relationship does not apply. |
| action_code | varchar(64) | Stable controlled code for action at one technician action within a service work order; where a matching name column exists, both values are asserted as one classification. |
+11 more columns in evb_service_actions. The full schema ships with the download.
evb_second_life_assessments· Rows: 5,600
| Column | Type | Description |
|---|---|---|
| second_life_assessment_id | varchar(40) | Stable synthetic identifier for one second-life eligibility assessment for a battery pack. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one second-life eligibility assessment for a battery pack. A blank value, where permitted, means the relationship does not apply. |
| state_of_health_id | varchar(24) | Foreign-key identifier of the state of health linked at one second-life eligibility assessment for a battery pack. A blank value, where permitted, means the relationship does not apply. |
| assessor_organization_id | varchar(16) | Foreign-key identifier of the assessor organization linked at one second-life eligibility assessment for a battery pack. A blank value, where permitted, means the relationship does not apply. |
| assessor_person_id | varchar(16) | Foreign-key identifier of the assessor person linked at one second-life eligibility assessment for a battery pack. A blank value, where permitted, means the relationship does not apply. |
| assessment_facility_id | varchar(16) | Foreign-key identifier of the assessment facility linked at one second-life eligibility assessment for a battery pack. A blank value, where permitted, means the relationship does not apply. |
| assessment_date_id | varchar(24) | Calendar key for assessment at one second-life eligibility assessment for a battery pack; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
+14 more columns in evb_second_life_assessments. The full schema ships with the download.
evb_second_life_deployments· Rows: 2,800
| Column | Type | Description |
|---|---|---|
| second_life_deployment_id | varchar(64) | Stable synthetic identifier for one second-life deployment period for a battery pack. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one second-life deployment period for a battery pack. A blank value, where permitted, means the relationship does not apply. |
| second_life_assessment_id | varchar(32) | Foreign-key identifier of the second life assessment linked at one second-life deployment period for a battery pack. A blank value, where permitted, means the relationship does not apply. |
| owner_organization_id | varchar(16) | Foreign-key identifier of the owner organization linked at one second-life deployment period for a battery pack. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one second-life deployment period for a battery pack. A blank value, where permitted, means the relationship does not apply. |
| successor_passport_id | varchar(32) | Foreign-key identifier of the successor passport linked at one second-life deployment period for a battery pack. A blank value, where permitted, means the relationship does not apply. |
| deployment_code | varchar(24) | Stable controlled code for deployment at one second-life deployment period for a battery pack; where a matching name column exists, both values are asserted as one classification. |
+10 more columns in evb_second_life_deployments. The full schema ships with the download.
evb_second_life_performance_monthly· Rows: 11,200
| Column | Type | Description |
|---|---|---|
| second_life_performance_id | varchar(24) | Stable synthetic identifier for one second-life deployment and month performance fact. Primary key; opaque text and never a transactional identifier. |
| deployment_id | varchar(64) | Foreign-key identifier of the deployment linked at one second-life deployment and month performance fact. A blank value, where permitted, means the relationship does not apply. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one second-life deployment and month performance fact. A blank value, where permitted, means the relationship does not apply. |
| month_start_date_id | varchar(24) | Calendar key for month start at one second-life deployment and month performance fact; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
| equivalent_full_cycles | numeric(8,4) | Charge-discharge throughput during the period expressed as equivalent full cycles of rated pack energy. |
| energy_charged_kwh | numeric(10,4) | Energy charged, expressed in kilowatt-hours, at one second-life deployment and month performance fact. |
| energy_delivered_kwh | numeric(10,4) | Electrical energy delivered by a charger or second-life system during the row period, in kilowatt-hours. |
+10 more columns in evb_second_life_performance_monthly. The full schema ships with the download.
evb_collection_events· Rows: 7,000
| Column | Type | Description |
|---|---|---|
| collection_event_id | varchar(40) | Stable synthetic identifier for one end-of-use battery-pack collection event. Primary key; opaque text and never a transactional identifier. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one end-of-use battery-pack collection event. A blank value, where permitted, means the relationship does not apply. |
| passport_id | varchar(32) | Foreign-key identifier of the passport linked at one end-of-use battery-pack collection event. A blank value, where permitted, means the relationship does not apply. |
| collector_organization_id | varchar(16) | Foreign-key identifier of the collector organization linked at one end-of-use battery-pack collection event. A blank value, where permitted, means the relationship does not apply. |
| collection_facility_id | varchar(16) | Foreign-key identifier of the collection facility linked at one end-of-use battery-pack collection event. A blank value, where permitted, means the relationship does not apply. |
| previous_owner_organization_id | varchar(16) | Foreign-key identifier of the previous owner organization linked at one end-of-use battery-pack collection event. A blank value, where permitted, means the relationship does not apply. |
| collection_date_id | varchar(24) | Calendar key for collection at one end-of-use battery-pack collection event; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
+15 more columns in evb_collection_events. The full schema ships with the download.
evb_recycling_batches· Rows: 700
| Column | Type | Description |
|---|---|---|
| recycling_batch_id | varchar(24) | Stable synthetic identifier for one battery recycling process batch. Primary key; opaque text and never a transactional identifier. |
| recycler_organization_id | varchar(16) | Foreign-key identifier of the recycler organization linked at one battery recycling process batch. A blank value, where permitted, means the relationship does not apply. |
| recycling_facility_id | varchar(16) | Foreign-key identifier of the recycling facility linked at one battery recycling process batch. A blank value, where permitted, means the relationship does not apply. |
| batch_code | varchar(40) | Stable controlled code for batch at one battery recycling process batch; where a matching name column exists, both values are asserted as one classification. |
| process_code | varchar(24) | Stable controlled code for process at one battery recycling process batch; where a matching name column exists, both values are asserted as one classification. |
| process_name | varchar(56) | Human-readable label for process at one battery recycling process batch; where a matching code exists, this is its asserted meaning rather than a second classification. |
| start_date_id | varchar(24) | Calendar key for start at one battery recycling process batch; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
+11 more columns in evb_recycling_batches. The full schema ships with the download.
evb_recycling_inputs· Rows: 7,000
| Column | Type | Description |
|---|---|---|
| recycling_input_id | varchar(24) | Stable synthetic identifier for one collected pack allocated to a recycling batch. Primary key; opaque text and never a transactional identifier. |
| recycling_batch_id | varchar(24) | Foreign-key identifier of the recycling batch linked at one collected pack allocated to a recycling batch. A blank value, where permitted, means the relationship does not apply. |
| collection_event_id | varchar(40) | Foreign-key identifier of the collection event linked at one collected pack allocated to a recycling batch. A blank value, where permitted, means the relationship does not apply. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one collected pack allocated to a recycling batch. A blank value, where permitted, means the relationship does not apply. |
| input_line_code | varchar(48) | Stable controlled code for input line at one collected pack allocated to a recycling batch; where a matching name column exists, both values are asserted as one classification. |
| accepted_mass_kg | numeric(10,4) | Accepted mass, expressed in kilograms, at one collected pack allocated to a recycling batch. |
| residual_capacity_kwh | numeric(9,4) | Estimated usable energy remaining in the collected pack at recycling acceptance, in kilowatt-hours. |
+8 more columns in evb_recycling_inputs. The full schema ships with the download.
evb_recovery_outputs· Rows: 4,200
| Column | Type | Description |
|---|---|---|
| recovery_output_id | varchar(32) | Stable synthetic identifier for one recovered material output line from a recycling batch. Primary key; opaque text and never a transactional identifier. |
| recycling_batch_id | varchar(24) | Foreign-key identifier of the recycling batch linked at one recovered material output line from a recycling batch. A blank value, where permitted, means the relationship does not apply. |
| material_id | varchar(24) | Foreign-key identifier of the material linked at one recovered material output line from a recycling batch. A blank value, where permitted, means the relationship does not apply. |
| buyer_organization_id | varchar(16) | Foreign-key identifier of the buyer organization linked at one recovered material output line from a recycling batch. A blank value, where permitted, means the relationship does not apply. |
| output_material_lot_id | varchar(24) | Foreign-key identifier of the output material lot linked at one recovered material output line from a recycling batch. A blank value, where permitted, means the relationship does not apply. |
| output_line_code | varchar(48) | Stable controlled code for output line at one recovered material output line from a recycling batch; where a matching name column exists, both values are asserted as one classification. |
| recovered_quantity_kg | numeric(9,3) | Recovered quantity, expressed in kilograms, at one recovered material output line from a recycling batch. |
+8 more columns in evb_recovery_outputs. The full schema ships with the download.
evb_circularity_balances_monthly· Rows: 2,688
| Column | Type | Description |
|---|---|---|
| circularity_balance_id | varchar(24) | Stable synthetic identifier for one organization, facility, material and month circularity balance. Primary key; opaque text and never a transactional identifier. |
| reporting_organization_id | varchar(16) | Foreign-key identifier of the reporting organization linked at one organization, facility, material and month circularity balance. A blank value, where permitted, means the relationship does not apply. |
| facility_id | varchar(16) | Foreign-key identifier of the facility linked at one organization, facility, material and month circularity balance. A blank value, where permitted, means the relationship does not apply. |
| material_id | varchar(32) | Foreign-key identifier of the material linked at one organization, facility, material and month circularity balance. A blank value, where permitted, means the relationship does not apply. |
| month_start_date_id | varchar(24) | Calendar key for month start at one organization, facility, material and month circularity balance; foreign key to evb_calendar_days.date_id. A blank value, where permitted, means the milestone has not occurred or the interval is open. |
| opening_inventory_kg | numeric(11,4) | Material inventory at the beginning of the reporting month, in kilograms. |
| virgin_input_kg | numeric(7,4) | Virgin input, expressed in kilograms, at one organization, facility, material and month circularity balance. |
+13 more columns in evb_circularity_balances_monthly. The full schema ships with the download.
evb_audits· Rows: 900
| Column | Type | Description |
|---|---|---|
| audit_id | varchar(48) | Stable synthetic identifier for one regulatory, quality or circularity audit. Primary key; opaque text and never a transactional identifier. |
| audited_organization_id | varchar(16) | Foreign-key identifier of the audited organization linked at one regulatory, quality or circularity audit. A blank value, where permitted, means the relationship does not apply. |
| audited_facility_id | varchar(16) | Foreign-key identifier of the audited facility linked at one regulatory, quality or circularity audit. A blank value, where permitted, means the relationship does not apply. |
| auditor_organization_id | varchar(16) | Foreign-key identifier of the auditor organization linked at one regulatory, quality or circularity audit. A blank value, where permitted, means the relationship does not apply. |
| lead_auditor_person_id | varchar(16) | Foreign-key identifier of the lead auditor person linked at one regulatory, quality or circularity audit. A blank value, where permitted, means the relationship does not apply. |
| instrument_id | varchar(16) | Foreign-key identifier of the instrument linked at one regulatory, quality or circularity audit. A blank value, where permitted, means the relationship does not apply. |
| audit_code | varchar(24) | Stable controlled code for audit at one regulatory, quality or circularity audit; where a matching name column exists, both values are asserted as one classification. |
+12 more columns in evb_audits. The full schema ships with the download.
evb_audit_findings· Rows: 2,700
| Column | Type | Description |
|---|---|---|
| audit_finding_id | varchar(56) | Stable synthetic identifier for one evidence-backed finding from an audit. Primary key; opaque text and never a transactional identifier. |
| audit_id | varchar(48) | Foreign-key identifier of the audit linked at one evidence-backed finding from an audit. A blank value, where permitted, means the relationship does not apply. |
| passport_id | varchar(32) | Foreign-key identifier of the passport linked at one evidence-backed finding from an audit. A blank value, where permitted, means the relationship does not apply. |
| battery_pack_id | varchar(16) | Foreign-key identifier of the battery pack linked at one evidence-backed finding from an audit. A blank value, where permitted, means the relationship does not apply. |
| material_lot_id | varchar(24) | Foreign-key identifier of the material lot linked at one evidence-backed finding from an audit. A blank value, where permitted, means the relationship does not apply. |
| data_point_id | varchar(8) | Foreign-key identifier of the data point linked at one evidence-backed finding from an audit. A blank value, where permitted, means the relationship does not apply. |
| finding_code | varchar(32) | Stable controlled code for finding at one evidence-backed finding from an audit; where a matching name column exists, both values are asserted as one classification. |
+11 more columns in evb_audit_findings. The full schema ships with the download.
evb_remediation_actions· Rows: 3,600
| Column | Type | Description |
|---|---|---|
| remediation_action_id | varchar(40) | Stable synthetic identifier for one remediation action linked to a control failure or incident. Primary key; opaque text and never a transactional identifier. |
| audit_finding_id | varchar(56) | Foreign-key identifier of the audit finding linked at one remediation action linked to a control failure or incident. A blank value, where permitted, means the relationship does not apply. |
| nonconformity_id | varchar(16) | Foreign-key identifier of the nonconformity linked at one remediation action linked to a control failure or incident. A blank value, where permitted, means the relationship does not apply. |
| due_diligence_id | varchar(16) | Foreign-key identifier of the due diligence linked at one remediation action linked to a control failure or incident. A blank value, where permitted, means the relationship does not apply. |
| safety_incident_id | varchar(40) | Foreign-key identifier of the safety incident linked at one remediation action linked to a control failure or incident. A blank value, where permitted, means the relationship does not apply. |
| owner_organization_id | varchar(16) | Foreign-key identifier of the owner organization linked at one remediation action linked to a control failure or incident. A blank value, where permitted, means the relationship does not apply. |
| owner_person_id | varchar(16) | Foreign-key identifier of the owner person linked at one remediation action linked to a control failure or incident. A blank value, where permitted, means the relationship does not apply. |
+14 more columns in evb_remediation_actions. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| assessment_code | battery_pack_id | assessment_date_id | assessment_method_name | rated_capacity_ah | remaining_capacity_ah | capacity_fade_pct | remaining_power_kw | state_of_certified_energy_pct | remaining_lifetime_cycles | confidence_pct | assessment_status_name |
|---|---|---|---|---|---|---|---|---|---|---|---|
| SHC-01-ECG2KM7-1 | BPK-013527 | DATE-20260724 | Battery-management-system, impedance and controlled capacity test | 271.0000 | 203.25000 | 25.00000 | 265.20000 | 74.53704 | 930 | 98.200 | Completed |
| SHC-02-YQ3G6N5-6 | BPK-013527 | DATE-20260801 | Battery-management-system, impedance and controlled capacity test | 271.0000 | 192.41000 | 29.00000 | 251.55000 | 70.45216 | 806 | 97.500 | Completed |
| SHC-03-7BN50K1-Q | BPK-013527 | DATE-20260809 | Battery-management-system, impedance and controlled capacity test | 271.0000 | 184.28000 | 32.00000 | 241.80000 | 67.37037 | 713 | 96.800 | Completed |
Version History
| v1.0.0 | 2026-09-01 | Initial enterprise release covering battery passport identity, cell and pack manufacturing genealogy, in-life degradation telemetry, carbon footprint declarations, circularity and second-life routing, regulatory conformity and governed product media. |
Related Datasets
Automotive Manufacturing Sales (EU)
ManufacturingA European automotive sales dataset across the electric transition: 12 brands, 112 models, 20 markets, four channels and five customer segments, monthly from 2016 to mid 2026, in which eight legacy European brands peak, crash, and lose a fifth of the market to battery electric entrants while their net debt climbs.
$149one time
View details Heavy Equipment BOM Structure (WW)
ManufacturingA heavy-equipment service parts catalogue with real bill-of-materials mechanics: six machine families, 39 variants, trees four to six levels deep with materialised paths, over a million item rows across 124,337 parts, serial-number effectivity, supersession chains with one documented loop, and a derived where-used table that reconciles exactly.
$179one time
View details Manufacturing Production and Orders (ASIA)
ManufacturingAn Asian manufacturing panel: 18 sectors, 90 manufacturers, 468 plants across 12 economies, with monthly production at line grain, orders and backlogs, shipments, an exact inventory identity, employment and producer prices from 2016 to mid 2026 across the decade's full cycle.
$129one time
View details