new_0222_0031|RPRX|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|price_next_month|price_second_month
new_0222_0031|RPRX|1|Royalty Pharma PLC Total Current Assets (Quarterly) (USD)|Royalty Pharma PLC Cash and Short Term Investments (Quarterly) (USD)|Royalty Pharma PLC Inventories (Quarterly) (USD)|Royalty Pharma PLC Net PP&E (Quarterly) (USD)|Royalty Pharma PLC Goodwill and Intangibles (Quarterly) (USD)|Royalty Pharma PLC Total Liabilities (Quarterly) (USD)|Royalty Pharma PLC Total Current Liabilities (Quarterly) (USD)|Royalty Pharma PLC Total Long Term Liabilities (Quarterly) (USD)|Royalty Pharma PLC Total Deposits (Quarterly) (USD)|Royalty Pharma PLC Book Value (Quarterly) (USD)|Royalty Pharma PLC Retained Earnings (Quarterly) (USD)|Royalty Pharma PLC Treasury Stock (Quarterly) (USD)|Royalty Pharma PLC EV to Revenues|Royalty Pharma PLC EV to Earnings|Royalty Pharma PLC EV to Free Cash Flow|Royalty Pharma PLC EV to Assets (Quarterly)|Royalty Pharma PLC PS Ratio|Royalty Pharma PLC PE Ratio|Royalty Pharma PLC Price to Book Value|Royalty Pharma PLC PEG Ratio|Royalty Pharma PLC Debt to Equity Ratio|Royalty Pharma PLC Dividend Yield|Royalty Pharma PLC Shareholder Yield (TTM)|Royalty Pharma PLC Percent of Shares Outstanding Short|Royalty Pharma PLC Total Receivables (Quarterly) (USD)|Royalty Pharma PLC Total Payables (Quarterly) (USD)|Royalty Pharma PLC Total Capital Stock (Quarterly) (USD)|Royalty Pharma PLC Return on Invested Capital|Royalty Pharma PLC Quality Ratio Score|Royalty Pharma PLC Momentum Score|Royalty Pharma PLC Beta (1Y)|Royalty Pharma PLC Sustainable Growth Rate (TTM)|Royalty Pharma PLC Institutional Investor Ownership Percentage|Royalty Pharma PLC Average Diluted Shares Outstanding (Quarterly)|Royalty Pharma PLC Total Employees (Annual)|Royalty Pharma PLC EPS Diluted (Quarterly) (USD)|Royalty Pharma PLC SG&A Expense (Quarterly) (USD)|Royalty Pharma PLC Shares Outstanding|Royalty Pharma PLC Repurchase of Capital Stock (Quarterly) (USD)|Royalty Pharma PLC Ordinary Shares Number (Quarterly)|Royalty Pharma PLC Payout Ratio|Royalty Pharma PLC Quick Ratio (Quarterly)|Royalty Pharma PLC Normalized Diluted EPS (Quarterly) (USD)|Royalty Pharma PLC Stock Buybacks (Quarterly) (USD)|Royalty Pharma PLC Effective Tax Rate (TTM)|Royalty Pharma PLC Return on Equity|Royalty Pharma PLC Net Income (TTM) (USD)|Royalty Pharma PLC Revenue (TTM) (USD)|Royalty Pharma PLC Dividend Per Share (Quarterly) (USD)|Royalty Pharma PLC Revenue (Quarterly) (USD)|Royalty Pharma PLC Gross Profit (Quarterly) (USD)|Royalty Pharma PLC Pre-Tax Income (Quarterly) (USD)|Royalty Pharma PLC Net Income (Quarterly) (USD)|Royalty Pharma PLC Net Interest Income (Quarterly) (USD)|Royalty Pharma PLC Price (USD)|Royalty Pharma PLC Total Return Price (USD)|Royalty Pharma PLC Enterprise Value (USD)|Royalty Pharma PLC 30-Day Average Daily Volume|Royalty Pharma PLC 1 Year Price Returns (Daily)|Royalty Pharma PLC Short Interest|Royalty Pharma PLC PE Ratio (Forward)|Royalty Pharma PLC PE Ratio (Forward 1y)|Royalty Pharma PLC PS Ratio (Forward)|Royalty Pharma PLC PS Ratio (Forward 1y)|Royalty Pharma PLC Quarterly EPS Estimates (USD)|Royalty Pharma PLC Quarterly Revenue Estimates (USD)|Royalty Pharma PLC Quarterly EPS Surprise|Royalty Pharma PLC Quarterly Revenue Surprise|Royalty Pharma PLC Quarterly Actual EPS (USD)|Royalty Pharma PLC Quarterly Actual Revenue (USD)|Royalty Pharma PLC Revenue Estimates for Current Fiscal Year (USD)|Royalty Pharma PLC Revenue Estimates for Next Fiscal Year (USD)|Royalty Pharma PLC Price Target (USD)|Royalty Pharma PLC Consensus Recommendation|Royalty Pharma PLC Price Target Num Estimates|Royalty Pharma PLC EPS Estimates for Current Fiscal Year (USD)|Royalty Pharma PLC EPS Estimates for Next Fiscal Year (USD)|Royalty Pharma PLC Research and Development Expense (Quarterly) (USD)|Royalty Pharma PLC Reconciled Depreciation (Quarterly) (USD)|Royalty Pharma PLC Non-Operating Interest Expense (Quarterly) (USD)|Royalty Pharma PLC Land and Improvements (Quarterly) (USD)|Royalty Pharma PLC Buildings and Improvements (Quarterly) (USD)|Royalty Pharma PLC Other Properties (Quarterly) (USD)|Royalty Pharma PLC Machine, Furniture & Equipment (Quarterly) (USD)||
new_0222_0031|RPRX|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_0031|RPRX|4|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|daily|daily|quarterly|quarterly|daily|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|quarterly|quarterly|quarterly|yearly|quarterly|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|daily|daily|daily|daily|monthly|daily|daily|daily|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|monthly|daily|monthly|monthly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly||
new_0222_0031|RPRX|5|91.1666666667|91.1666666667|||91.1666666667|91.1666666667|91.1666666667|91.1666666667||91.1666666667|91.1666666667|91.1666666667|1.44339622642|91.25|1.44339622642|91.25|1.44339622642|1.44473007712|1.44339622642||91.1666666667|1.46031746032||15.2631578947|91.1666666667|91.1666666667|91.1666666667|91.25||30.6666666667|30.7142857143|91.25||91.3333333333|366|91.3333333333|91.3333333333|28.2666666667||91.1666666667|91.1666666667|91.1666666667|91.3333333333|91.375|91.1666666667|91.25|91.1666666667|91.1666666667|91|91.3333333333||91.3333333333|91.3333333333|91.3333333333|1.44339622642|1.44339622642|1.44339622642|1.44303797468|1.43604651163|15.2631578947|1.44755244755|1.44755244755|1.44755244755|1.44755244755|91.4|91.4|91.5|91.5|91.5|91.5|9.89830508475|10.4285714286|15.7837837838|6.56179775281|15.7837837838|8.71641791045|9.26984126984|91.3333333333|91.3333333333|91.3333333333||||||
new_0222_0031|RPRX|6|6|6|||6|6|6|6||6|6|6|424|4|424|4|424|389|424||6|63||38|6|6|6|4||6|7|4||9|1|9|9|15||6|6|6|9|8|6|4|6|6|3|9||9|9|9|424|424|424|395|172|38|286|286|286|286|10|10|6|6|6|6|59|56|37|89|37|67|63|9|9|9||||||
new_0222_0031|RPRX|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_0031|RPRX|201903||||||||||||||||||||||||||||||||||354.1756||1.0375|24.426||||||0.9587|||||||434.883||396.094|367.444|-57.239||||||||||||||||||||||||22.991|6.599|67.266||||||
new_0222_0031|RPRX|201906||||||||||||||||||||||||||||||||||354.1756||0.4284|30.349||||||0.6435|||||||457.608||178.77|151.713|-64.694||||||||||||||||||||||||21.457|5.733|69.168||||||
new_0222_0031|RPRX|201909||||||||||||||||||||||||||||||||||354.1756||1.1547|25.603||||||1.2125|||||||464.277||440.027|408.982|-64.215||||||||||||||||||||||||22.718|5.796|68.796||||||
new_0222_0031|RPRX|201912|832.072|793.214|||51.724|6308.457|333.417|5975.04||6105.555|2825.212|4.266|||||||||1.0217||||38.766|42.218|3282.516|||||||354.1756|35|4.0104|23.061|||595.383|31.4782|2.4953|3.4871||||2348.535|1814.254||457.486||1446.528|1420.396|-60.096||||||||||||||||||||||||15.87|5.796|63.343||||||
new_0222_0031|RPRX|202003|1737.837|1696.204|||45.991|6208.919|433.961|5774.958||5159.918|2561.971|4.266|||||||||1.1545||||41.581|141.833|2553.001|||||||595.383||0.1197|38.065|||595.383|33.2979|4.0045|0.4331||||2052.331|1880.25||500.879||109.096|71.24|-50.726||||||||||||||||||||||||7.639|5.733|53.584||||||
new_0222_0031|RPRX|202006|3390.789|3342.546|||40.258|6290.595|450.973|5839.622||4157.132|1571.399|2.119|19.2815|15.9142|20.0704|2.3768|10.4059|9.0328|7.0902||1.4221|||0.5506|35.454|157.137|0.1|17.2231||||33.3428||353.98||0.09|42.799|607.106||607.106|26.8316|7.4905|-0.4596|-1918.229||45.57|2342.692|1933.574||510.932||601.976|442.074|-31.465|48.55|47.1907|37282.1273|1593161.9667||2014531|||||0.6047|508.3115|0.8831|0.5289|0.61|511|1963.7587|2139.7248|52|2.3333|8|2.3301|2.6457|5.776|5.733|34.189|||||43.05|41.38
new_0222_0031|RPRX|202009|2783.851|2732.692|||34.462|6192.03|269.983|5922.047||4451.813|1807.146|2.155|16.9186|15.2707|20.3734|2.1242|8.767|8.3971|5.7372||1.3055|||1.8699|36.761|159.983|0.1|15.7708||||34.3933|67.1398|370.002||0.79|50.732|607.11||607.11|23.1743|10.2579|0.3761|8.578||44.7679|2224.342|2007.696|0.15|538.399||624.254|290.632|-29.857|42.07|41.0518|33967.3077|1028687.1||6918713|||||0.5897|498.2758|10.0787|7.9723|0.6491|538|1991.7164|2154.8872|52|2.3333|8|2.2851|2.6405|5.096|5.796|31.444|||||36.7|42.6
new_0222_0031|RPRX|202012|2696.898|2649.136|||28.666|6124.471|307.887|5816.584||4818.779|1920.635|2.317|18.2017|39.6193|18.9865|2.4113|10.1279|39.0614|6.3057||1.2071|||3.4043|39.166|155.741|0.102|6.759||||11.6874||398.517|51|0.2817|50.119|607.111||607.111|40.8027|8.7315|0.1248|0.907||19.7431|975.04|2122.353|0.15|572.143||366.628|171.094|-16.632|50.05|49.0193|38630.3896|2674242.4||13213471|17.5998|15.7651|14.2855|13.4774|0.7015|523.6913|-0.6657|9.2247|0.6969|572|1961.1489|2249.4388|51.875|2|8|2.4458|3.0753|7.779|5.796|37.842|||||47.01|46.57
new_0222_0031|RPRX|202103|2416.024|2369.372|||22.995|6077.055|255.983|5821.072||4882.215|1923.771|2.359|15.8983|35.8599|16.6962|2.1923|8.595|32.5119|5.4242||1.1923|||4.6179|39.995|135.712|0.102|6.4511||||13.8661||607.148||0.18|43.156|607.112||607.112|33.1014|9.4122|0.2584|||20.727|972.919|2194.501|0.17|573.027||158.979|69.119|-20.817|43.62|42.8755|34888.7434|4046193.5||18141681|15.3387|13.7398|12.4502|11.7459|0.6498|508.4854|3.6918|12.6876|0.6738|573|1960.8977|2160.3972|52|2|8|2.6485|2.9658|2.641|5.671|37.415|||||44|40.12
new_0222_0031|RPRX|202106|2707.454|2650.519|||17.262|6109.548|283.989|5825.559||5733.679|2291.966|2.662|11.3243|26.0901|11.8882|1.535|9.077|17.5797|3.0527||1.016|||2.1924|44.837|126.771|0.105|6.1872||2|0.9878|14.9846||607.163||1.08|44.921|427.006||427.006|25.8385|9.4911|0.9687|||20.2054|971.621|2238.532|0.17|554.963||806.755|440.776|-23.389|40.99|40.456|25349.7019|2386661.5|-15.5716|9361810|14.4139|12.9113|8.2288|7.7633|0.7054|490.9912|0.1673|13.0367|0.7066|555|1992.5374|2204.1541|52.1111|2.1111|9|2.7588|3.0538|3.122|5.733|37.426|||||38.2|38.65
new_0222_0031|RPRX|202109|||||||||||||10.3991||10.917||8.003|15.4997|2.6915|||1.7098||1.9631||||||3|1.695||||||||||||||||||||||||36.14|35.8265|23278.7192|2706086.4333|-14.0956|8431834|12.7084|11.3836|7.2551|6.8447|0.6958|573.8012|4.4122|2.126|0.7265|586|2152.0044|2231.6679|51.25|2|8|2.8555|3.1057||||||||39.53|39.77
new_0222_0031|RPRX|202112|||||||||||||11.1068||11.6599||8.8245|17.1895|2.9678|||1.7064||1.3616||||||4|0.9638||||||||||||||||||||||||39.85|39.663|24862.9111|2107268.9667|-20.3796|5848170|12.5522|11.4741|7.5474|6.9255|0.7754|543.3741|3.6898|6.0043|0.804|576|2127.2884|2254.5845|51.5|1.625|8|2.8639|3.1747||||||||40.01|39.41
new_0222_0031|RPRX|202203|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.7228|591||||||||||||||||||||
new_0222_0031|RPRX|202206|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.8251|553||||||||||||||||||||
new_0222_0031|RPRX|202209|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.7305|618||||||||||||||||||||
new_0222_0031|RPRX|202212|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.8703|593||||||||||||||||||||