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|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|sga_expense|pre_tax_income|net_income|interest_income|price|total_return_price|enterprise_value|average_volume_30|one_year_return
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 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 SG&A Expense (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)
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_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|mil_figure_money_USD_metric|figure_money_USD_price|figure_money_USD_price|mil_figure_money_USD_metric|figure_USD_metric|percent_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|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|daily|daily|daily|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.42978723404|92|1.42553191489|92|1.42796610169|1.42796610169|1.42796610169|1.43421052632|91.4|1.44206008584|92|15.3|114.25|114.25|114.25|92|92|0|0|92|30.6|91.2857142857|181|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|91.2857142857|1.44017094017|1.44017094017|1.42978723404|1.44117647059|0
new_0222_0325|NAPA||6|6|4|4|4|4|4|4|4|4|0|4|4|0|235|2|141|2|236|236|236|76|5|233|2|20|4|4|4|2|2|0|0|2|10|7|1|7|8|0|4|4|5|7|1|4|2|4|4|0|7|7|7|7|7|7|234|234|235|204|0
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|daily|quarterly|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
new_0222_0325|NAPA|202001|201912|201912||||||||||||||||||||||||||||||||||110.5859||0.1326||||||0.105|||||||76.993|38.313|18.104|19.917|14.665|-4.854|||||
new_0222_0325|NAPA|202004|202003|202003||||||||||||||||||||||||||||||||||110.5859||0.1051||||||0.1049|||||||68.72|36.342|13.156|15.806|11.619|-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|||115.0468||0.6315|0.0535|||||||52.231|25.923|16.205|-4.881|-2.723|-4.019|||||
new_0222_0325|NAPA|202010|202009|202009||||||||||||||||||||||||||||||||||110.5859||0.1585||||0||0.1689||24.633||41.084|289.582||91.638|44.275|16.805|23.658|17.523|-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|||115.0468|0|0.6551|0.1474||24.9605||48.422|296.246||83.657|41.757|17.471|29.935|22.003|-3.612|||||
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||
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|114.3814||114.3814|218.2215|0.7656|0.0776|-187.5|27.6812|6.4206|45.825|317.951||90.425|46.929|31.142|14.645|9.022|-3.755|18.71|18.71|2400.77|644501.3|
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|
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|
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|115.0468||115.0468|178.648|0.6604|0.0606|0|27.2909|7.6084|55.976|336.613||70.893|34.387|24.398|8.74|7.428|-2.671|21.97|21.97|2771.1822|521111.3667|
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|
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|
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|115.0468||115.0468|167.4313|0.4996|0.1803||27.1296|7.927|59.726|349.156||104.181|52.41|23.158|28.69|21.273|-1.606|19.34|19.34|2452.1991|949709.6667|
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|
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|
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|
new_0222_0325|NAPA|202202|202112|202112|||||||||||||7.0595||33.9516||6.1972|37.0713|2.6849|0.9338||0|||||||||||||||||||||||||||||||||19.24|19.24|2464.8543|293945.1667|