SELECT SUM(preval1990) AS sclr_0, SUM(preval1991) AS sclr_1, SUM(preval1992) AS sclr_2, SUM(preval1993) AS sclr_3, SUM(preval1994) AS sclr_4, SUM(preval1995) AS sclr_5, SUM(preval1996) AS sclr_6, SUM(preval1997) AS sclr_7, SUM(preval1998) AS sclr_8, SUM(preval1999) AS sclr_9, SUM(preval2000) AS sclr_10, SUM(preval2001) AS sclr_11, SUM(preval2002) AS sclr_12, SUM(preval2003) AS sclr_13, SUM(preval2004) AS sclr_14, SUM(preval2005) AS sclr_15, SUM(preval2006) AS sclr_16, SUM(preval2007) AS sclr_17, SUM(preval2008) AS sclr_18, SUM(preval2009) AS sclr_19, SUM(preval2010) AS sclr_20, SUM(preval2011) AS sclr_21, SUM(preval2012) AS sclr_22, SUM(preval2013) AS sclr_23, SUM(preval2014) AS sclr_24, SUM(preval2015) AS sclr_25, SUM(preval2016) AS sclr_26, SUM(preval2017) AS sclr_27, SUM(preval2018) AS sclr_28, SUM(preval2019) AS sclr_29, SUM(preval2020) AS sclr_30, SUM(preval2021) AS sclr_31, SUM(preval2022) AS sclr_32, SUM(preval2023) AS sclr_33, SUM(preval2024) AS sclr_34
FROM prevalence
WHERE poradi_maligni = 1;
-
Raw data SQL
count_preval1990 count_preval1991 count_preval1992 count_preval1993 count_preval1994 count_preval1995 count_preval1996 count_preval1997 count_preval1998 count_preval1999 count_preval2000 count_preval2001 count_preval2002 count_preval2003 count_preval2004 count_preval2005 count_preval2006 count_preval2007 count_preval2008 count_preval2009 count_preval2010 count_preval2011 count_preval2012 count_preval2013 count_preval2014 count_preval2015 count_preval2016 count_preval2017 count_preval2018 count_preval2019 count_preval2020 count_preval2021 count_preval2022 count_preval2023 count_preval2024 157705 166689 177015 188527 200837 213006 226515 239926 252853 266038 279233 293108 307227 322342 338143 355062 371455 389854 407646 425499 445031 463424 482150 501610 521971 542245 563088 581768 598655 618465 628169 639240 658476 679589 704896
Prevalence. Aplikované filtry:
Typ zhoubného nádoru: ZHOUBNÉ NOVOTVARY (C00–C97)Kraj: celá ČR
| Rozsah: 1990–2024
Výpočetní metoda: Prevalence osob
Zdroj dat: NOR