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|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|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 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 SG&A Expense (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)||
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_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_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|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|daily|daily|daily|daily||
new_0222_0031|RPRX|5|91.1666666667|91.1666666667|0|0|91.1666666667|91.1666666667|91.1666666667|91.1666666667|0|91.1666666667|91.1666666667|91.1666666667|1.44444444444|91.25|1.44444444444|91.25|1.44339622642|1.44473007712|1.44339622642|0|91.1666666667|1.46031746032|0|15.2631578947|91.1666666667|91.1666666667|91.1666666667|91.25|0|30.6666666667|30.7142857143|91.25|0|91.3333333333|366|91.3333333333|28.2666666667|0|91.1666666667|91.1666666667|91.1666666667|91.3333333333|91.375|91.1666666667|91.25|91.1666666667|91.1666666667|91|91.3333333333|0|91.3333333333|91.3333333333|91.3333333333|91.3333333333|1.44339622642|1.44339622642|1.44444444444|1.44416243655|1.43859649123||
new_0222_0031|RPRX|6|6|6|0|0|6|6|6|6|0|6|6|6|423|4|423|4|424|389|424|0|6|63|0|38|6|6|6|4|0|6|7|4|0|9|1|9|15|0|6|6|6|9|8|6|4|6|6|3|9|0|9|9|9|9|424|424|423|394|171||
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|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_0031|RPRX|201903||||||||||||||||||||||||||||||||||354.1756||1.0375||||||0.9587|2.327||||||434.883||24.426|396.094|367.444|-57.239|||||||
new_0222_0031|RPRX|201906||||||||||||||||||||||||||||||||||354.1756||0.4284||||||0.6435|1.901||||||457.608||30.349|178.77|151.713|-64.694|||||||
new_0222_0031|RPRX|201909||||||||||||||||||||||||||||||||||354.1756||1.1547||||||1.2125|0||||||464.277||25.603|440.027|408.982|-64.215|||||||
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|||595.383|31.4782|2.4953|3.4871|0.038|0||2348.535|1814.254||457.486||23.061|1446.528|1420.396|-60.096|||||||
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.2032|||595.383|33.2979|4.0045|0.4331||0||2052.331|1880.25||500.879||38.065|109.096|71.24|-50.726|||||||
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|8.869|8.8946|4.2732||1.4221|||0.5506|35.454|157.137|0.1|17.2231||||33.3428||353.98||0.09|365.899||607.106|26.8316|7.4905|-0.4596|-1918.229|0|45.57|2342.692|1933.574||510.932||42.799|601.976|442.074|-31.465|48.55|43.4372|25571.5275|3116490.9667||41.93|41.78
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|7.6743|7.341|3.6976||1.3055|||1.8699|36.761|159.983|0.1|15.7708||||34.3933|67.1398|370.002||0.79|370.002||607.11|23.1743|10.2579|0.3761|8.578|0|44.7679|2224.342|2007.696|0.15|538.399||50.732|624.254|290.632|-29.857|42.01|37.7327|23178.5564|1024489.5333||37.87|39.58
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|8.8223|9.6669|4.3235||1.2071|||3.4043|39.166|155.741|0.102|6.759||||11.6874||398.517|51|0.4406|388.135||607.111|40.8027|8.7315|0.1248|0.907|0|19.7431|975.04|2122.353|0.15|572.143||50.119|366.628|171.094|-16.632|49.59|44.7056|27673.6757|2519408.2||52.82|46.92
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|7.5707|28.6326|3.5142||1.1923|||4.6179|39.995|135.712|0.102|6.4511||||13.8661||607.148||0.18|392.857||607.112|33.1014|9.4122|0.2584||0|20.727|972.919|2194.501|0.17|573.027||43.156|158.979|69.119|-20.817|43.63|39.4743|25178.7704|4062819.1667||44.67|40.22
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|8.1046|27.4096|3.3096||1.016|1.556||2.1924|44.837|126.771|0.105|6.1872||2|0.9878|14.9846||607.163||1.08|427.006||427.006|25.8385|9.4911|0.9687|0|0|20.2054|971.621|2238.532|0.17|554.963||44.921|806.755|440.776|-23.389|41.13|37.3654|24564.7387|2349049.2667|-15.5716|39.2|38.65
new_0222_0031|RPRX|202109||2693.315||||7345.724|||||||10.3991||10.917||8.1094|14.7035|2.7272||1.224|2.2119||1.9631||||||3|1.695|||||0.24|429.511|||||||||782.918|2285.906||585.773||48.588||101.929||36.62|33.4149|23483.6821|2685336.6333|-14.0956|37.74|39.77
new_0222_0031|RPRX|202112||2803.271||||7267.32|||||||11.1068||11.6599||9.792|20.7826|2.9902||1.2284|1.6861||1.3616||||||4|0.9638|||||-0.661|432.963|||||||||619.728|2289.463||575.7||46.161||7.904||40.33|36.948|26313.0966|2495253.9|-20.3796|39.13|38.54
new_0222_0031|RPRX|202203||2911.222||||7237.009|||||||||||9.5369|46.1747|2.9036||1.2291|1.8069||||||||||||||0.12|435.316|||||||||602.37|2278.485||562.049||51.54||51.761||38.74|35.6586|25537.756|1422821||41.83|41.14
new_0222_0031|RPRX|202206||3401.383||||7332.226|||||||||||10.528|54.6351|3.2067||1.179|1.6917||||||||||||||0.7|437.139|||||||||466.098|2259.477||535.955||51.843||304.504||42.56|39.3594|27081.306|2270554.0333||43|41.85
new_0222_0031|RPRX|202209||2216.758||||7256.202|||||||||||10.2925|100.8304|2.9178||1.1559|1.8394||||||||||||||0.32|441.104|||||||||506.82|2247.167||573.463||50.692||142.651||40.23|37.3636|25671.864|1736660.7||41.42|43.07
new_0222_0031|RPRX|202212||2427.791||||7288.093|||||||||||9.8249|81.9229|2.8135||1.2644|1.9368||||||||||||||-1.4675|443.166|||||||||42.832|2237.215||565.748||73.228||-456.084||39.24|36.6076|26467.7338|1528649.5333||39.19|35.85
new_0222_0031|RPRX|202303||2588.211||||7252.121|||||||||||9.2502|115.3119|2.9189||1.1961|2.0772||||||||||||||0.76|448.287|||||||||331.826|2359.137||683.971||85.695||340.755||37.07|34.7662|25013.9176|2281295.6667||35.6|32.51
new_0222_0031|RPRX|202306||2908.087||||7307.796|||||||||||7.1043|95.5011|2.2464||1.1345|2.6139||||||||||||||0.5|450.352||||||134.442|||254.947|2361.384||538.202||47.634||227.625||29.84|28.1564|21775.6812|2839817.6||31.22|30.37
new_0222_0031|RPRX|202309||1683.908||||6270.427|||||||||||6.4175|237.7798|1.9081||0.9987|2.9588||||||||||||||0.16|445.843||||||140.117|||184.41|2324.234||536.313||57.234||72.114||26.7|25.3644|19772.6303|2355349.4667||27.3|26.9
new_0222_0031|RPRX|202312||1233.748||||6297.562|||||||||||6.8206|11.1468|2.0381||0.9401|2.8561||||||||||||||1.1|446.692||||||30.2|||1134.834|2354.554||596.068||59.185||494.34||28.01|26.8073|20440.9494|2624688.2333||28.39|30.61
new_0222_0031|RPRX|202403||1532.482||||6267.17|||||||||||8.1466|11.996|2.0841||0.9446|2.6601||||||||||||||0.01|450.981|||||||||798.857|2238.561||567.978||57.652||4.778||30.45|29.3529|21667.152|2810630.2667||27.98|26.39
new_0222_0031|RPRX|202406||2553.242||||7904.761|||||||||||7.2158|15.1977|1.8551||1.1738|3.0746||||||||||||||0.23|449.065||||||79.999|||673.236|2237.626||537.267||54.708||102.004||26.67|25.9019|20132.6099|2629499.2667||28.79|29.03
new_0222_0031|RPRX|202409||1764.325||||7783.775|||||||||||7.4085|18.4733|1.952||1.1074|2.9422||||||||||||||1.21|446.038||||||97.045|||1145.109|2266.003||564.69||56.72||543.987||28.21|27.6091|20742.0696|2233054.9333||26.95|26.66
new_0222_0031|RPRX|202412||1770.996||||7880.349|||||||||||6.6957|14.1475|1.6427||1.0959|3.3071||||||||||||||0.3531|445.985||||||52.607|||858.983|2263.576||593.641||67.591||208.214||25.4|25.0647|20614.2924|3413889.1667||31.58|33.64
new_0222_0031|RPRX|202503||1816.379||||7819.599|||||||||||8.8611|18.7229|1.9568||1.1389|2.7096||||||||||||||0.55|425.59||||||708.781|||1092.554|2263.845||568.247||110.705||238.349||31.37|31.1616|23866.2636|4707891.2667||32.54|32.69
new_0222_0031|RPRX|202506|||||||||||||||||9.4073|15.4237|2.2767|||2.3796|||||||||||||||||||||||||||||||||36.14|36.14|24129.4201|5664662.9333||36.37|