Passenger Transit
Pack file: catalog/industries/passenger_transit in ambient-core.
Workspace demo (screenshots) · Catalog consumption
Industry summary
Industry code
ISIC Rev.4 4922
56 metrics · 6 data options
- NAICS 2022
485111- NACE Rev.2
49.31(also49.10)- GICS 2023
203040
Taxonomy tags from ambient-core pack.yaml / manifest v3 (analysis lens, not legal-entity self-classification). Coverage notes: catalog-industry-coverage.md.
Data options (6)
Accounting Software
Catalog key passenger_transit.core.accounting_software
Fields
date- date
period_start_date- date
period_end_date- date
revenue- decimal
cogs- decimal
cost_of_goods- decimal
operating_expenses- decimal
net_income- decimal
produce_revenue- decimal
total_production_cost- decimal
total_operational_cost- decimal
Financial statements
Catalog key passenger_transit.core.financial_statements
Fields
date- date
statement_type- enum
period_start_date- date
period_end_date- date
HR records
Catalog key passenger_transit.core.hr_records
Fields
date- date
headcount- decimal
Payroll records
Catalog key passenger_transit.core.payroll_records
Fields
date- date
period_start_date- date
period_end_date- date
headcount- decimal
gross_pay- decimal
net_pay- decimal
employer_taxes- decimal
labor_cost- decimal
revenue- decimal
net_income- decimal
total_labor_costs- decimal
total_harvested_kg- decimal
total_production_cost- decimal
total_operational_cost- decimal
drivers_left- decimal
total_drivers- decimal
total_maintenance_costs- decimal
total_miles- decimal
Public transit operations summary
Catalog key passenger_transit.public_transit.operations_summary
Fields
date- date
operating_revenue- decimal
operating_expenses- string
unlinked_trips- string
vehicle_revenue_hours- decimal
on_time_trips- string
total_trips- decimal
Rail passenger operations summary
Catalog key passenger_transit.rail_passenger.operations_summary
Fields
date- date
total_boardings- decimal
train_miles_operated- decimal
fare_revenue- decimal
operating_cost- decimal
Metrics (56)
- Accounts Payable Days
- Accounts Payable Turnover
- Accounts Receivable Days
- Accounts Receivable Turnover
- Monthly Burn Rate
- Cash Days
- Cash Turnover
- Cash Conversion Cycle
- Current Ratio
- Debt to EBITDA
- Debt to Equity
- Debt to Tangible Net Worth
- EBITDA (derived)
- Effective Tax Rate
- Gross Profit (derived)
- Invested Capital
- Net Debt
- Net Operating Profit After Tax (NOPAT)
- Quick Assets (strict)
- Tangible Net Worth
- Days Payable Outstanding (DPO)
- Days Sales Outstanding (DSO)
- EBIT to Interest
- EBITDA Less Capex to Interest
- EBITDA Margin
- EBITDA to Interest (Interest Coverage)
- Effective Interest Rate
- Fixed Charge Coverage
- Gross Profit Margin
- Headcount (FTE)
- Interest Burden
- Inventory Days
- Inventory Turnover (ending balance)
- Net Debt to EBITDA
- Net Profit Margin
- Net Profit Margin (decimal quotient)
- Operating Cash Flow
- Operating Margin (EBIT)
- Operating Profit Margin (EBIT)
- PP&E Turnover
- Quick Ratio (Acid Test)
- Quick Ratio (Quick Assets)
- Return on Assets (ROA)
- Return on Equity (ROE)
- Return on Invested Capital (ROIC)
- Revenue Growth Rate
- Cash Runway
- Tax Burden
- Total Asset Turnover
- Total Assets to Equity (Equity Multiplier)
- Working Capital
- Transit Farebox Recovery Ratio
- On-Time Performance
- Ridership per Vehicle Hour
- Rail Farebox Recovery Ratio
- Ridership per Train-Mile
Accounts Payable Days
- ID: 3278
- Type: Financial
- Unit: Days
- Description: Payables expressed as days of COGS; 365-day convention (Ambient corporate ratio pack). Distinct from catalog DPO.
- Inputs:
cogs,accounts_payable - Methodology: Accounts Payable Days
- Calculation:
accounts_payable * 365 / max(cogs, 0) - Catalog key:
passenger_transit.core.accounts_payable_days
Accounts Payable Turnover
- ID: 3277
- Type: Financial
- Unit: x
- Description: COGS divided by accounts payable
- Inputs:
cogs,accounts_payable - Methodology: Accounts Payable Turnover
- Calculation:
cogs / max(accounts_payable, 0) - Catalog key:
passenger_transit.core.accounts_payable_turnover
Accounts Receivable Days
- ID: 3274
- Type: Financial
- Unit: Days
- Description: Receivable balance in days of revenue; 365-day convention (Ambient corporate ratio pack). Distinct from catalog DSO.
- Inputs:
revenue,accounts_receivable - Methodology: Accounts Receivable Days
- Calculation:
accounts_receivable * 365 / max(revenue, 0) - Catalog key:
passenger_transit.core.accounts_receivable_days
Accounts Receivable Turnover
- ID: 3273
- Type: Financial
- Unit: x
- Description: Revenue divided by accounts receivable Not parameterized DSO.
- Inputs:
revenue,accounts_receivable - Methodology: Accounts Receivable Turnover
- Calculation:
revenue / max(accounts_receivable, 0) - Catalog key:
passenger_transit.core.accounts_receivable_turnover
Monthly Burn Rate
- ID: 2032
- Type: Financial
- Unit: Currency/month
- Description: Net cash consumed per month (negative net operating cash flow).
- Inputs:
cash_out,cash_in - Methodology: Net Burn = Cash Out − Cash In (per month)
- Calculation:
cash_out - cash_in - Catalog key:
passenger_transit.core.burn_rate
Cash Days
- ID: 3272
- Type: Financial
- Unit: Days
- Description: Cash balance expressed as days of revenue at a 365-day year (Ambient corporate ratio pack).
- Inputs:
revenue,cash - Methodology: Cash Days
- Calculation:
cash * 365 / max(revenue, 0) - Catalog key:
passenger_transit.core.cash_days
Cash Turnover
- ID: 3271
- Type: Financial
- Unit: x
- Description: Revenue divided by cash
- Inputs:
revenue,cash - Methodology: Cash Turnover
- Calculation:
revenue / max(cash, 0) - Catalog key:
passenger_transit.core.cash_turnover
Cash Conversion Cycle
- ID: 2030
- Type: Financial
- Unit: Days
- Description: Days to convert investments in inventory and receivables back into cash.
- Inputs:
days_inventory_outstanding - Methodology: CCC = DSO + Days Inventory Outstanding − DPO
- Calculation:
dso + days_inventory_outstanding - dpo - Catalog key:
passenger_transit.core.ccc
Current Ratio
- ID: 2020
- Type: Financial
- Unit: Ratio
- Description: Short-term liquidity: ability to cover current liabilities with current assets.
- Inputs:
current_assets,current_liabilities - Methodology: Current Ratio = Current Assets / Current Liabilities
- Calculation:
current_assets / current_liabilities - Catalog key:
passenger_transit.core.current_ratio
Debt to EBITDA
- ID: 3282
- Type: Financial
- Unit: x
- Description: Gross interest-bearing debt divided by EBITDA
- Inputs:
interest_bearing_liabilities - Methodology: Debt to EBITDA
- Calculation:
interest_bearing_liabilities / max(ebitda_derived, 0) - Catalog key:
passenger_transit.core.debt_to_ebitda
Debt to Equity
- ID: 3280
- Type: Financial
- Unit: x
- Description: Interest-bearing liabilities divided by equity
- Inputs:
interest_bearing_liabilities,total_shareholders_equity - Methodology: Debt to Equity
- Calculation:
interest_bearing_liabilities / max(total_shareholders_equity, 0) - Catalog key:
passenger_transit.core.debt_to_equity
Debt to Tangible Net Worth
- ID: 3281
- Type: Financial
- Unit: x
- Description: Interest-bearing debt divided by tangible net worth (Ambient corporate ratio pack).
- Inputs:
interest_bearing_liabilities - Methodology: Debt to Tangible Net Worth
- Calculation:
interest_bearing_liabilities / max(tangible_net_worth, 0) - Catalog key:
passenger_transit.core.debt_to_tangible_net_worth
EBITDA (derived)
- ID: 3254
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: EBIT plus depreciation and amortization
- Inputs:
operating_income,depreciation,amortization - Methodology: EBITDA (derived)
- Calculation:
operating_income + depreciation + amortization - Catalog key:
passenger_transit.core.derived_ebitda
Effective Tax Rate
- ID: 3255
- Type: Financial
- Unit: %
- Description: Tax expense divided by earnings before tax
- Inputs:
tax_expense,earnings_before_tax - Methodology: Effective Tax Rate = Tax Expense / Earnings Before Tax
- Calculation:
tax_expense / max(earnings_before_tax, 0) - Catalog key:
passenger_transit.core.derived_effective_tax_rate
Gross Profit (derived)
- ID: 3253
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Revenue minus COGS; building block for margins
- Inputs:
revenue,cogs - Methodology: Gross Profit (derived)
- Calculation:
revenue - cogs - Catalog key:
passenger_transit.core.derived_gross_profit
Invested Capital
- ID: 3258
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Net debt plus total shareholders' equity
- Inputs:
total_shareholders_equity - Methodology: Invested Capital
- Calculation:
net_debt + total_shareholders_equity - Catalog key:
passenger_transit.core.derived_invested_capital
Net Debt
- ID: 3257
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Interest-bearing liabilities minus cash
- Inputs:
interest_bearing_liabilities,cash - Methodology: Net Debt
- Calculation:
interest_bearing_liabilities - cash - Catalog key:
passenger_transit.core.derived_net_debt
Net Operating Profit After Tax (NOPAT)
- ID: 3256
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: EBIT adjusted for cash taxes using the effective tax rate (Ambient corporate ratio pack).
- Inputs:
operating_income - Methodology: Net Operating Profit After Tax (NOPAT)
- Calculation:
operating_income * (1 - effective_tax_rate) - Catalog key:
passenger_transit.core.derived_nopat
Quick Assets (strict)
- ID: 3260
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Cash, marketable securities, and accounts receivable (Ambient corporate ratio pack).
- Inputs:
cash,marketable_securities,accounts_receivable - Methodology: Quick Assets (strict)
- Calculation:
cash + marketable_securities + accounts_receivable - Catalog key:
passenger_transit.core.derived_quick_assets
Tangible Net Worth
- ID: 3259
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Shareholders' equity minus intangible assets
- Inputs:
total_shareholders_equity,intangible_assets - Methodology: Tangible Net Worth
- Calculation:
total_shareholders_equity - intangible_assets - Catalog key:
passenger_transit.core.derived_tangible_net_worth
Days Payable Outstanding (DPO)
- ID: 2029
- Type: Financial
- Unit: Days
- Description: Average number of days the business takes to pay its suppliers.
- Inputs:
accounts_payable,cogs,days - Methodology: DPO = (Accounts Payable / COGS) × Number of Days
- Calculation:
accounts_payable / cogs * days - Catalog key:
passenger_transit.core.dpo
Days Sales Outstanding (DSO)
- ID: 2028
- Type: Financial
- Unit: Days
- Description: Average number of days to collect cash after a sale.
- Inputs:
accounts_receivable,total_credit_sales,days - Methodology: DSO = (Accounts Receivable / Total Credit Sales) × Number of Days
- Calculation:
accounts_receivable / total_credit_sales * days - Catalog key:
passenger_transit.core.dso
EBIT to Interest
- ID: 3286
- Type: Financial
- Unit: x
- Description: EBIT divided by gross interest expense
- Inputs:
operating_income,interest_expense - Methodology: EBIT to Interest
- Calculation:
operating_income / max(interest_expense, 0) - Catalog key:
passenger_transit.core.ebit_to_interest
EBITDA Less Capex to Interest
- ID: 3287
- Type: Financial
- Unit: x
- Description: Capex-adjusted EBITDA coverage
- Inputs:
capital_expenditures,interest_expense - Methodology: EBITDA Less Capex to Interest
- Calculation:
(ebitda_derived - capital_expenditures) / max(interest_expense, 0) - Catalog key:
passenger_transit.core.ebitda_less_capex_to_interest
EBITDA Margin
- ID: 2024
- Type: Financial
- Unit: %
- Description: Core operating cash profitability before interest, tax, depreciation and amortization.
- Inputs:
ebitda,revenue - Methodology: EBITDA Margin = (EBITDA / Revenue) × 100
- Calculation:
ebitda / revenue * 100 - Catalog key:
passenger_transit.core.ebitda_margin
EBITDA to Interest (Interest Coverage)
- ID: 3285
- Type: Financial
- Unit: x
- Description: EBITDA divided by gross interest expense
- Inputs:
interest_expense - Methodology: EBITDA to Interest (Interest Coverage)
- Calculation:
ebitda_derived / max(interest_expense, 0) - Catalog key:
passenger_transit.core.ebitda_to_interest
Effective Interest Rate
- ID: 3266
- Type: Financial
- Unit: %
- Description: Gross interest expense divided by interest-bearing liabilities (Ambient corporate ratio pack).
- Inputs:
interest_expense,interest_bearing_liabilities - Methodology: Effective Interest Rate
- Calculation:
interest_expense / max(interest_bearing_liabilities, 0) - Catalog key:
passenger_transit.core.effective_interest_rate
Fixed Charge Coverage
- ID: 3288
- Type: Financial
- Unit: x
- Description: Capex-adjusted EBITDA over interest plus current debt maturities (Ambient corporate ratio pack).
- Inputs:
capital_expenditures,interest_expense,current_portion_long_term_debt - Methodology: Fixed Charge Coverage
- Calculation:
(ebitda_derived - capital_expenditures) / max(interest_expense + current_portion_long_term_debt, 0) - Catalog key:
passenger_transit.core.fixed_charge_coverage
Gross Profit Margin
- ID: 2022
- Type: Financial
- Unit: %
- Description: Share of revenue retained after the direct cost of goods sold.
- Inputs:
revenue,cogs - Methodology: Gross Margin = ((Revenue − COGS) / Revenue) × 100
- Calculation:
(revenue - cogs) / revenue * 100 - Catalog key:
passenger_transit.core.gross_margin
Headcount (FTE)
- ID: 2034
- Type: Operational
- Unit: Count
- Description: Period-end count of active full-time-equivalent employees. A directly measured input, not a derived ratio.
- Methodology: Period-end count of active employees expressed as full-time equivalents (directly measured, not calculated).
- Calculation: No machine-readable calc — directly reported or qualitative.
- Catalog key:
passenger_transit.core.headcount
Interest Burden
- ID: 3267
- Type: Financial
- Unit: %
- Description: EBT relative to EBIT; DuPont lever
- Inputs:
earnings_before_tax,operating_income - Methodology: Interest Burden
- Calculation:
earnings_before_tax / max(operating_income, 0) - Catalog key:
passenger_transit.core.interest_burden
Inventory Days
- ID: 3276
- Type: Financial
- Unit: Days
- Description: Inventory held in days of COGS; 365-day convention (Ambient corporate ratio pack).
- Inputs:
cogs,inventory - Methodology: Inventory Days
- Calculation:
inventory * 365 / max(cogs, 0) - Catalog key:
passenger_transit.core.inventory_days
Inventory Turnover (ending balance)
- ID: 3275
- Type: Financial
- Unit: x
- Description: COGS divided by ending inventory Distinct from average-inventory variants.
- Inputs:
cogs,inventory - Methodology: Inventory Turnover (ending balance)
- Calculation:
cogs / max(inventory, 0) - Catalog key:
passenger_transit.core.inventory_turnover
Net Debt to EBITDA
- ID: 3283
- Type: Financial
- Unit: x
- Description: Net debt divided by EBITDA
- Methodology: Net Debt to EBITDA
- Calculation:
net_debt / max(ebitda_derived, 0) - Catalog key:
passenger_transit.core.net_debt_to_ebitda
Net Profit Margin
- ID: 2025
- Type: Financial
- Unit: %
- Description: Bottom-line profitability after all costs, interest and tax.
- Inputs:
net_income,revenue - Methodology: Net Profit Margin = (Net Income / Revenue) × 100
- Calculation:
net_income / revenue * 100 - Catalog key:
passenger_transit.core.net_margin
Net Profit Margin (decimal quotient)
- ID: 3265
- Type: Financial
- Unit: %
- Description: Net income divided by revenue as a decimal quotient. Alias of net_margin at percent scale; see docs/ratios/corporate-ratios.md.
- Inputs:
net_income,revenue - Methodology: Net Profit Margin = Net Income / Revenue
- Calculation:
net_income / max(revenue, 0) - Catalog key:
passenger_transit.core.net_profit_margin
Operating Cash Flow
- ID: 2031
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Cash generated by core operations during the period.
- Inputs:
net_income,non_cash_charges,increase_in_working_capital - Methodology: Operating Cash Flow = Net Income + Non-Cash Charges − Increase in Working Capital
- Calculation:
net_income + non_cash_charges - increase_in_working_capital - Catalog key:
passenger_transit.core.operating_cash_flow
Operating Margin (EBIT)
- ID: 2023
- Type: Financial
- Unit: %
- Description: Operating profitability after operating expenses (EBIT margin).
- Inputs:
operating_income,revenue - Methodology: Operating Margin = (Operating Income / Revenue) × 100
- Calculation:
operating_income / revenue * 100 - Catalog key:
passenger_transit.core.operating_margin
Operating Profit Margin (EBIT)
- ID: 3264
- Type: Financial
- Unit: %
- Description: EBIT divided by revenue as a decimal quotient. Alias of operating_margin at percent scale; see docs/ratios/corporate-ratios.md. Alias of operating_margin at percent scale.
- Inputs:
operating_income,revenue - Methodology: Operating Profit Margin = EBIT / Revenue
- Calculation:
operating_income / max(revenue, 0) - Catalog key:
passenger_transit.core.operating_profit_margin
PP&E Turnover
- ID: 3270
- Type: Financial
- Unit: x
- Description: Revenue divided by net PP&E
- Inputs:
revenue,ppe_net - Methodology: PP&E Turnover
- Calculation:
revenue / max(ppe_net, 0) - Catalog key:
passenger_transit.core.ppe_turnover
Quick Ratio (Acid Test)
- ID: 2021
- Type: Financial
- Unit: Ratio
- Description: Acid-test liquidity excluding inventory — most conservative short-term solvency view. Default formula: current assets minus inventory. See quick_ratio_quick_assets for the alternate convention (cash + marketable securities + receivables).
- Inputs:
current_assets,inventory,current_liabilities - Methodology: Quick Ratio = (Current Assets − Inventory) / Current Liabilities
- Calculation:
(current_assets - inventory) / current_liabilities - Catalog key:
passenger_transit.core.quick_ratio
Quick Ratio (Quick Assets)
- ID: 3284
- Type: Financial
- Unit: x
- Description: Strict quick assets over current liabilities Formula-box quick_ratio remains default.
- Inputs:
current_liabilities - Methodology: Quick Ratio = (Cash + Marketable Securities + A/R) / Current Liabilities
- Calculation:
quick_assets / max(current_liabilities, 0) - Catalog key:
passenger_transit.core.quick_ratio_quick_assets
Return on Assets (ROA)
- ID: 3262
- Type: Financial
- Unit: %
- Description: Net income divided by total assets
- Inputs:
net_income,total_assets - Methodology: ROA = Net Income / Total Assets
- Calculation:
net_income / max(total_assets, 0) - Catalog key:
passenger_transit.core.return_on_assets
Return on Equity (ROE)
- ID: 3261
- Type: Financial
- Unit: %
- Description: Net income divided by shareholders' equity
- Inputs:
net_income,total_shareholders_equity - Methodology: ROE = Net Income / Total Shareholders' Equity
- Calculation:
net_income / max(total_shareholders_equity, 0) - Catalog key:
passenger_transit.core.return_on_equity
Return on Invested Capital (ROIC)
- ID: 3263
- Type: Financial
- Unit: %
- Description: NOPAT divided by invested capital
- Methodology: ROIC = NOPAT / (Net Debt + Equity)
- Calculation:
nopat / max(invested_capital, 0) - Catalog key:
passenger_transit.core.return_on_invested_capital
Revenue Growth Rate
- ID: 2026
- Type: Financial
- Unit: %
- Description: Period-over-period revenue growth rate.
- Inputs:
revenue,revenue_prior - Methodology: Revenue Growth = ((Current Period Revenue − Prior Period Revenue) / Prior Period Revenue) × 100
- Calculation:
(revenue - revenue_prior) / revenue_prior * 100 - Catalog key:
passenger_transit.core.revenue_growth
Cash Runway
- ID: 2033
- Type: Financial
- Unit: Months
- Description: Number of months of cash remaining at the current net burn rate.
- Inputs:
current_cash_balance - Methodology: Runway (months) = Current Cash Balance / Monthly Net Burn
- Calculation:
current_cash_balance / burn_rate - Catalog key:
passenger_transit.core.runway
Tax Burden
- ID: 3268
- Type: Financial
- Unit: %
- Description: Net income relative to EBT; DuPont lever
- Inputs:
net_income,earnings_before_tax - Methodology: Tax Burden
- Calculation:
net_income / max(earnings_before_tax, 0) - Catalog key:
passenger_transit.core.tax_burden
Total Asset Turnover
- ID: 3269
- Type: Financial
- Unit: x
- Description: Revenue divided by total assets
- Inputs:
revenue,total_assets - Methodology: Total Asset Turnover
- Calculation:
revenue / max(total_assets, 0) - Catalog key:
passenger_transit.core.total_asset_turnover
Total Assets to Equity (Equity Multiplier)
- ID: 3279
- Type: Financial
- Unit: x
- Description: Financial leverage lever in DuPont
- Inputs:
total_assets,total_shareholders_equity - Methodology: Total Assets to Equity (Equity Multiplier)
- Calculation:
total_assets / max(total_shareholders_equity, 0) - Catalog key:
passenger_transit.core.total_assets_to_equity
Working Capital
- ID: 2027
- Type: Financial
- Unit: Currency (e.g., USD)
- Description: Operating liquidity available to fund day-to-day operations.
- Inputs:
current_assets,current_liabilities - Methodology: Working Capital = Current Assets − Current Liabilities
- Calculation:
current_assets - current_liabilities - Catalog key:
passenger_transit.core.working_capital
Transit Farebox Recovery Ratio
- ID: 1868
- Type: Financial
- Unit: %
- Description: Fare and subsidy-eligible revenue as a share of operating expenses (aggregated).
- Inputs:
operating_revenue,operating_expenses - Methodology: Farebox Recovery = (Operating Revenue / Operating Expenses) × 100
- Calculation:
operating_revenue / operating_expenses * 100 - Catalog key:
passenger_transit.public_transit.farebox_recovery_ratio
On-Time Performance
- ID: 1870
- Type: Operational
- Unit: %
- Description: Share of transit trips departing or arriving within agency on-time standard (aggregated).
- Inputs:
on_time_trips,total_trips - Methodology: OTP = (On-Time Trips / Total Trips) × 100
- Calculation:
on_time_trips / total_trips * 100 - Catalog key:
passenger_transit.public_transit.on_time_performance
Ridership per Vehicle Hour
- ID: 1869
- Type: Operational
- Unit: Passengers per vehicle hour
- Description: Unlinked passenger trips per vehicle revenue hour (aggregated).
- Inputs:
unlinked_trips,vehicle_revenue_hours - Methodology: Ridership per Vehicle Hour = Unlinked Trips / Vehicle Revenue Hours
- Calculation:
unlinked_trips / vehicle_revenue_hours - Catalog key:
passenger_transit.public_transit.ridership_per_vehicle_hour
Rail Farebox Recovery Ratio
- ID: 1864
- Type: Financial
- Unit: %
- Description: Passenger fare revenue as a share of fully allocated operating cost (aggregated).
- Inputs:
fare_revenue,operating_cost - Methodology: Farebox Recovery = (Fare Revenue / Operating Cost) × 100
- Calculation:
fare_revenue / operating_cost * 100 - Catalog key:
passenger_transit.rail_passenger.farebox_recovery
Ridership per Train-Mile
- ID: 1863
- Type: Operational
- Unit: Passengers per train-mile
- Description: Passenger boardings per train-mile operated (aggregated).
- Inputs:
total_boardings,train_miles_operated - Methodology: Ridership per Train-Mile = Total Boardings / Train-Miles Operated
- Calculation:
total_boardings / train_miles_operated - Catalog key:
passenger_transit.rail_passenger.ridership_per_train_mile
Data engineering pipeline
Ambient Core ships the catalog (typed data options and metrics) and ambient_pipeline helpers. Lakehouse jobs and schedules live in the application repository that pins a core tag.
Canonical order: map columns → coerce types → unpivot → stamp lineage → (optional Silver validate) → contract assert → write. Gold vertical products evaluate catalog formulas with ambient_calc after Silver.
How this pack feeds the pipeline
- Accounting Software — feeds Gross Profit Margin, Operating Margin (EBIT), Net Profit Margin
- Financial statements — feeds Current Ratio, Quick Ratio (Acid Test), Gross Profit Margin, Operating Margin (EBIT), Net Profit Margin, EBITDA Margin, Operating Cash Flow, Revenue Growth Rate, Working Capital, Days Sales Outstanding (DSO), Days Payable Outstanding (DPO), Cash Conversion Cycle, Monthly Burn Rate, Cash Runway
- HR records — feeds Headcount (FTE)
- Payroll records — feeds Net Profit Margin, Operating Margin (EBIT)
- Public transit operations summary — feeds Transit Farebox Recovery Ratio, Ridership per Vehicle Hour, On-Time Performance
- Rail passenger operations summary — feeds Ridership per Train-Mile, Rail Farebox Recovery Ratio
Further reading: Catalog consumption · Pipeline governance helpers
Generated from ambient-core ref cc3d169 (digest a0e8f2dc8aa708fd). Regenerate: npm run sync:catalog-wiki.