new_0222_0325|NAPA|Short Name|0|0|total_current_assets|cash_on_hand|inventories_net|net_ppe|goodwill_and_intangible|liabilities|total_current_liabilities|total_long_term_liab|total_deposits|book_value_of_equity|retained_earnings|treasury_stock|ev_revenues|ev_earnings|ev_free_cash_flow|ev_assets|ps_ratio|pe_ratio|price_to_book_value|peg_ratio|debt_equity_ratio|dividend_yield|shareholder_yield_ttm|percent_of_shares_outstanding|receivables|payables|capital_stock|return_on_invested_capital|quality_ratio_fractile|momentum_fractile|market_beta_12_month|sustainable_growth_rate|institutional_investor_ownership_percentage|average_shares_outs_diluted|total_employee_number|eps|sga_expense|shares_outstanding|repurchase_of_capital_stock|ordinary_shares_number|payout_ratio|quick_ratio|normalized_eps|stock_buyback|effective_tax_rate|return_on_equity|net_income_ttm|revenues_ttm|dividend_per_share|revenues|gross_profit|pre_tax_income|net_income|interest_income|price|total_return_price|enterprise_value|average_volume_30|one_year_return|short_interest|forward_pe_ratio|forward_pe_ratio_1y|forward_ps_ratio|forward_ps_ratio_1y|quarterly_eps_estimates|quarterly_sales_estimates|quarterly_eps_surprise|quarterly_sales_surprise|quarterly_eps_actual|quarterly_sales_actual|sales_est_0y|sales_est_1y|price_target|consensus_recommendation|price_target_num_est|eps_est_0y|eps_est_1y|r_and_d_expense|reconciled_depreciation|interest_expense_non_operating|land_and_improvements|buildings_and_improvements|other_properties|machinery_furniture_equipment
new_0222_0325|NAPA|Long Name|1|1|The Duckhorn Portfolio Inc Total Current Assets (Quarterly) (USD)|The Duckhorn Portfolio Inc Cash and Short Term Investments (Quarterly) (USD)|The Duckhorn Portfolio Inc Inventories (Quarterly) (USD)|The Duckhorn Portfolio Inc Net PP&E (Quarterly) (USD)|The Duckhorn Portfolio Inc Goodwill and Intangibles (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Liabilities (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Current Liabilities (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Long Term Liabilities (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Deposits (Quarterly) (USD)|The Duckhorn Portfolio Inc Book Value (Quarterly) (USD)|The Duckhorn Portfolio Inc Retained Earnings (Quarterly) (USD)|The Duckhorn Portfolio Inc Treasury Stock (Quarterly) (USD)|The Duckhorn Portfolio Inc EV to Revenues|The Duckhorn Portfolio Inc EV to Earnings|The Duckhorn Portfolio Inc EV to Free Cash Flow|The Duckhorn Portfolio Inc EV to Assets (Quarterly)|The Duckhorn Portfolio Inc PS Ratio|The Duckhorn Portfolio Inc PE Ratio|The Duckhorn Portfolio Inc Price to Book Value|The Duckhorn Portfolio Inc PEG Ratio|The Duckhorn Portfolio Inc Debt to Equity Ratio|The Duckhorn Portfolio Inc Dividend Yield|The Duckhorn Portfolio Inc Shareholder Yield (TTM)|The Duckhorn Portfolio Inc Percent of Shares Outstanding Short|The Duckhorn Portfolio Inc Total Receivables (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Payables (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Capital Stock (Quarterly) (USD)|The Duckhorn Portfolio Inc Return on Invested Capital|The Duckhorn Portfolio Inc Quality Ratio Score|The Duckhorn Portfolio Inc Momentum Score|The Duckhorn Portfolio Inc Beta (1Y)|The Duckhorn Portfolio Inc Sustainable Growth Rate (TTM)|The Duckhorn Portfolio Inc Institutional Investor Ownership Percentage|The Duckhorn Portfolio Inc Average Diluted Shares Outstanding (Quarterly)|The Duckhorn Portfolio Inc Total Employees (Annual)|The Duckhorn Portfolio Inc EPS Diluted (Quarterly) (USD)|The Duckhorn Portfolio Inc SG&A Expense (Quarterly) (USD)|The Duckhorn Portfolio Inc Shares Outstanding|The Duckhorn Portfolio Inc Repurchase of Capital Stock (Quarterly) (USD)|The Duckhorn Portfolio Inc Ordinary Shares Number (Quarterly)|The Duckhorn Portfolio Inc Payout Ratio|The Duckhorn Portfolio Inc Quick Ratio (Quarterly)|The Duckhorn Portfolio Inc Normalized Diluted EPS (Quarterly) (USD)|The Duckhorn Portfolio Inc Stock Buybacks (Quarterly) (USD)|The Duckhorn Portfolio Inc Effective Tax Rate (TTM)|The Duckhorn Portfolio Inc Return on Equity|The Duckhorn Portfolio Inc Net Income (TTM) (USD)|The Duckhorn Portfolio Inc Revenue (TTM) (USD)|The Duckhorn Portfolio Inc Dividend Per Share (Quarterly) (USD)|The Duckhorn Portfolio Inc Revenue (Quarterly) (USD)|The Duckhorn Portfolio Inc Gross Profit (Quarterly) (USD)|The Duckhorn Portfolio Inc Pre-Tax Income (Quarterly) (USD)|The Duckhorn Portfolio Inc Net Income (Quarterly) (USD)|The Duckhorn Portfolio Inc Net Interest Income (Quarterly) (USD)|The Duckhorn Portfolio Inc Price (USD)|The Duckhorn Portfolio Inc Total Return Price (USD)|The Duckhorn Portfolio Inc Enterprise Value (USD)|The Duckhorn Portfolio Inc 30-Day Average Daily Volume|The Duckhorn Portfolio Inc 1 Year Price Returns (Daily)|The Duckhorn Portfolio Inc Short Interest|The Duckhorn Portfolio Inc PE Ratio (Forward)|The Duckhorn Portfolio Inc PE Ratio (Forward 1y)|The Duckhorn Portfolio Inc PS Ratio (Forward)|The Duckhorn Portfolio Inc PS Ratio (Forward 1y)|The Duckhorn Portfolio Inc Quarterly EPS Estimates (USD)|The Duckhorn Portfolio Inc Quarterly Revenue Estimates (USD)|The Duckhorn Portfolio Inc Quarterly EPS Surprise|The Duckhorn Portfolio Inc Quarterly Revenue Surprise|The Duckhorn Portfolio Inc Quarterly Actual EPS (USD)|The Duckhorn Portfolio Inc Quarterly Actual Revenue (USD)|The Duckhorn Portfolio Inc Revenue Estimates for Current Fiscal Year (USD)|The Duckhorn Portfolio Inc Revenue Estimates for Next Fiscal Year (USD)|The Duckhorn Portfolio Inc Price Target (USD)|The Duckhorn Portfolio Inc Consensus Recommendation|The Duckhorn Portfolio Inc Price Target Num Estimates|The Duckhorn Portfolio Inc EPS Estimates for Current Fiscal Year (USD)|The Duckhorn Portfolio Inc EPS Estimates for Next Fiscal Year (USD)|The Duckhorn Portfolio Inc Research and Development Expense (Quarterly) (USD)|The Duckhorn Portfolio Inc Reconciled Depreciation (Quarterly) (USD)|The Duckhorn Portfolio Inc Non-Operating Interest Expense (Quarterly) (USD)|The Duckhorn Portfolio Inc Land and Improvements (Quarterly) (USD)|The Duckhorn Portfolio Inc Buildings and Improvements (Quarterly) (USD)|The Duckhorn Portfolio Inc Other Properties (Quarterly) (USD)|The Duckhorn Portfolio Inc Machine, Furniture & Equipment (Quarterly) (USD)
new_0222_0325|NAPA|Unit|2|2|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|percent_USD_metric|percent_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|percent_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_beta|percent_USD_metric|percent_USD_metric|mil_figure_USD_metric|figure_whole_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_USD_metric|mil_figure_money_USD_metric|mil_figure_USD_metric|percent_USD_metric|figure_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|percent_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_price|figure_money_USD_price|mil_figure_money_USD_metric|figure_USD_metric|percent_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|percent_USD_per_share_metric|percent_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_price|figure_USD_metric|figure_whole_USD_price|figure_money_USD_per_share_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric
new_0222_0325|NAPA||4|4|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|daily|daily|daily|quarterly|daily|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|daily|daily|daily|quarterly|monthly|daily|daily|daily|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|monthly|monthly|monthly|monthly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly
new_0222_0325|NAPA||5|5|114.25|114.25|114.25|114.25|114.25|114.25|114.25|114.25|0|114.25|114.25|0|1.42796610169|92|1.42253521127|92|1.42796610169|1.42796610169|1.42796610169|1.43421052632|91.4|1.44017094017|92|15.3|114.25|114.25|114.25|92|92|0|0|92|30.6|91.2857142857|181|91.2857142857|91.2857142857|33.125|0|114.25|91.25|91.4|91.2857142857|92|91.25|92|91.25|91.25|0|91.2857142857|91.2857142857|91.2857142857|91.2857142857|91.2857142857|1.44017094017|1.44017094017|1.42796610169|1.43902439024|0|15.3|1.41843971631|1.41843971631|1.41843971631|1.41843971631|91.5714285714|91.5714285714|92|92|92|152.333333333|12.5|12.5|14.7058823529|10|14.7058823529|14.7058823529|13.8888888889|0|91.5|91.2857142857|114.25|114.25|114.25|114.25
new_0222_0325|NAPA||6|6|4|4|4|4|4|4|4|4|0|4|4|0|236|2|142|2|236|236|236|76|5|234|2|20|4|4|4|2|2|0|0|2|10|7|1|7|7|8|0|4|4|5|7|1|4|2|4|4|0|7|7|7|7|7|234|234|236|205|0|20|141|141|141|141|7|7|2|2|2|3|20|20|17|25|17|17|18|0|6|7|4|4|4|4
new_0222_0325|NAPA||7|7|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|daily|daily|daily|quarterly|daily|quarterly|daily|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|quarterly|monthly|quarterly|yearly|quarterly|quarterly|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|market_daily|market_daily|daily|market_daily|market_daily|daily|daily|daily|daily|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|daily|daily|daily|daily|daily|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly
new_0222_0325|NAPA|202001|201912|201912||||||||||||||||||||||||||||||||||110.5859||0.1326|18.104||||||0.105|||||||76.993|38.313|19.917|14.665|-4.854||||||||||||||||||||||||||4.854||||
new_0222_0325|NAPA|202004|202003|202003||||||||||||||||||||||||||||||||||110.5859||0.1051|13.156||||||0.1049|||||||68.72|36.342|15.806|11.619|-4.221|||||||||||||||||||||||||6.116|4.221||||
new_0222_0325|NAPA|202007|202006|202006|280.713|6.252|245.311|242.751|633.439|503.987|51.807|452.18||654.047|117.658||||||||||0.5794||||26.464|3.733|1.017|||||||110.5859||-0.0246|16.205|||115.0468||0.6315|0.0535|||||||52.231|25.923|-4.881|-2.723|-4.019||||||||||||||||91.638|||||||||5.334|4.019|120.063|66.057|53.319|44.147
new_0222_0325|NAPA|202010|202009|202009||||||||||||||||||||||||||||||||||110.5859||0.1585|16.805||||0||0.1689||24.633||41.084|289.582||91.638|44.275|23.658|17.523|-3.58|||||||||||||||||||||||||5.116|3.58||||
new_0222_0325|NAPA|202101|202012|202012|321.018|9.274|271.674|242.591|629.597|500.359|59.547|440.812||694.149|157.184||||||||||0.5282||||29.736|8.296|1.017|||||||110.5859|413|0.199|17.471|||115.0468|0|0.6551|0.1474||24.9605||48.422|296.246||83.657|41.757|29.935|22.003|-3.612|||||||||||||||||||||||||5.765|3.612|120.063|66.213|58.057|47.96
new_0222_0325|NAPA|202103|202103|202012|||||||||||||7.7248||||6.2638|38.3192|2.7811|||0||1.0711|||||||||23.7571|||||115.0468|||||||||||||||||16.78|16.78|2288.4443|||1232219||||||||||||||||||||||||
new_0222_0325|NAPA|202104|202103|202103|326.361|5.027|268.825|240.975|627.677|403.494|63.976|339.518||792.957|66.206||7.5508|52.39||2.0056|6.4754|45.321|2.6989||0.3344|0|-2.4781|0.9653|43.955|14.417|1.15|4.3593|3|||-7.5905|23.7954|108.404||0.08|31.142|114.3814||114.3814|218.2215|0.7656|0.0776|-187.5|27.6812|6.4206|45.825|317.951||90.425|46.929|14.645|9.022|-3.755|18.71|18.71|2400.77|644501.3||1104180|||||0.0727|76.1188|133.8377|18.7945|0.17|90.425|307.0361|334.9945|20.625|1.75|8|0.3857|0.4264||5.553|3.755|120.063|68.307|58.055|48.485
new_0222_0325|NAPA|202105|202103|202103|||||||||||||7.3601||||6.292|44.0372|2.6224|||0||0.8627|||||||||23.7092||||||||||||||||||||||18.18|18.18|2340.1479|287519.9333||986804||||||||||||335.9112|20.625|1.75|8||0.4289|||||||
new_0222_0325|NAPA|202106|202106|202103|||||||||||||8.7559||||7.6348|53.4357|3.1821|||0||1.6242|||||||||28.4443|||||114.3814|||||||||||||||||22.06|22.06|2783.9477|550565.7||1857811|||||||||||324.8399|349.7381|23|1.75|8|0.4956|0.5004|||||||
new_0222_0325|NAPA|202107|202106|202106|314.401|4.244|267.737|240.939|625.756|380.879|56.781|324.098||801.687|73.634||8.2325|49.5066|54.7849|2.3423|7.2616|44.1647|||0.3085|0|-1.9568|1.8626|33.253|3.556|1.15|5.3271|4|||-5.9839|28.2281|115.4604|474|0.06|24.398|115.0468||115.0468|178.648|0.6604|0.0606|0|27.2909|7.6084|55.976|336.613||70.893|34.387|8.74|7.428|-2.671|21.97|21.97|2771.1822|521111.3667||2130450|||||0.0153|60.1626|422.1932|17.8357|0.08|70.893|325.1458||23.5|1.75|8|0.4957|||4.909|2.671|120.063|68.616|55.513|49.607
new_0222_0325|NAPA|202108|202106|202106|||||||||||||8.0685||53.6931||7.103|43.1998|3.0839|||0||1.5542|||||||||28.1758||||||||||||||||||||||21.49|21.49|2715.9597|292086.8333||1788084|36.9422|32.2828|6.8246|6.2207||||||||||||||||||||
new_0222_0325|NAPA|202109|202109|202106|||||||||||||8.547||56.8773||7.5657|46.0141|3.2848|||0||1.5727|||||||||29.9685|||||115.0468|||||||||||||||||22.89|22.89|2877.0253|320716.1667||1809352|39.3488|34.3859|7.2692|6.626|||||||||23.625|1.75|8|||||||||
new_0222_0325|NAPA|202110|202109|202109|392.782|5.247|319.224|244.397|623.835|438.084|129.837|308.247||824.419|94.907||7.0232|41.0575|33.7773|1.9414|6.2293|37.264|||0.2812|0|1.3222|1.7723|59.618|56.701|1.15|5.6526|3|||-5.3453|29.9629|115.396||0.18|23.158|115.0468||115.0468|167.4313|0.4996|0.1803||27.1296|7.927|59.726|349.156||104.181|52.41|28.69|21.273|-1.606|19.34|19.34|2452.1991|949709.6667||2038931|||||0.1458|96.9065|37.193|7.5067|0.2|104.181|358.6588|393.7001|25.5|1.75|8|0.5557|0.629||4.829|1.606|120.063|68.638|53.818|50.711
new_0222_0325|NAPA|202111|202109|202109|||||||||||||6.9804||33.5713||6.1875|37.0135|2.6807|0.9324||0||1.2296|||||||||30.3874|||||115.0468|||||||||||||||||19.21|19.21|2437.243|659616||1414651|33.0228|28.8577|6.1006|5.5607|||||||359.6929|394.8527||1.75||0.5559|0.6321|||||||
new_0222_0325|NAPA|202112|202112|202109|||||||||||||8.3412||40.1161||7.5177|44.9711|3.2571|1.1328||0||1.3718|||||||||34.168||||||||||||||||||||||23.34|23.34|2912.3863|588122.6333||1578179|40.1224|35.0619|7.4135|6.7555|||||||362.2051|397.4832|25.5|1.75|8|0.5817|0.6657|||||||
new_0222_0325|NAPA|202201|202112|202112|||||||||||||7.2275||34.7598||6.429|38.4586|2.7854|0.9688||0||1.2926|||||||||32.2657||||||||||||||||||||||19.96|19.96|2523.5281|415218.4||1487068|34.312|29.9844|6.3399|5.7772|0.1456|92.7436||||||||||||||||||
new_0222_0325|NAPA|202202|202112|202112|||||||||||||7.0265||33.7932||6.2325|37.2832|2.7003|0.9391||0|||||||||||||||||||||||||||||||||19.35|19.35|2453.3496|293231.2|||33.2634|29.068|6.1461|5.6006||||||||||||||||||||
new_0222_0325|NAPA|202204|202203|202203|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.1534|90.3507||||||||||||||||||
new_0222_0325|NAPA|202207|202206|202206|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.0799|75.1131||||||||||||||||||
new_0222_0325|NAPA|202210|202209|202209|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.2293|113.443||||||||||||||||||
new_0222_0325|NAPA|202301|202212|202212|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.1533|101.76||||||||||||||||||