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
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 158170 167230 177612 189036 201491 213730 227229 240697 253641 266873 280092 294017 308225 323345 339233 356208 372605 391002 408742 426500 445925 464171 482815 502120 522297 542465 562976 581390 597998 617343 627209 638417 657504 679445
Prevalence. Aplikované filtry:
Typ zhoubného nádoru: ZHOUBNÉ NOVOTVARY (C00–C97)Kraj: celá ČR
| Rozsah: 1990–2023
Výpočetní metoda: Prevalence osob
Zdroj dat: NOR