new_report_list = ['Agriculture Cluster Development Project IDA Credit 56110-UG  2023',
 'Agriculture Value Chain Development Project (AVCDP)  2023',
 'Albertine Region Sustainable Development Project (ARSDP) 2023',
 'Alebtong District Local Government  2023',
 'Amuru District Local Government  2023',
 'Annual Consolidated OAG 2018',
 'Annual Consolidated OAG 2019',
 'Apac District Local Government  2023',
 'Budaka District Local Government   2023',
 'Bugdet Performance Thematic  Report 2023',
 'Bugiri District Local Government  2022',
 'Bugweri District Local Government  2022',
 'Buhweju District Local Government  2023',
 'Bukomansimbi District Local Government  2022',
 'Bukwo District Local Government  2023',
 'Bulambuli District Local Government  2023',
 'Buliisa District Local Government  2023',
 'Bundibugyo District Local Government  2023',
 'Bunyangabu District Local Government  2023',
 'Busia District Local Government  2023',
 'Butambala District Local Government  2023',
 'Buyende District Local Government  2022',
 'East Africas Centers of Excellence for Skills and Tertiary Education in Biomedical Sciences Phase1 2023',
 'Entebbe Regional Referral Hospital 2023',
 'GAVI the Vaccine Alliance  Health Systems Strengthening Coverage & Equity  2023',
 'GAVI the Vaccine Alliance COVID-19 Vaccine Delivery Support Early Access Window  2023',
 'Gomba District Local Government  2022',
 'Gulu District Local Government  2018',
 'Gulu District Local Government  2019',
 'Gulu District Local Government  2020',
 'Gulu District Local Government  2021',
 'Gulu District Local Government  2022',
 'Gulu District Local Government  2023',
 'Gulu Regional Referral Hospital 2023',
 'Hoima District Local Government  2023',
 'Ibanda District Local Government  2023',
 'Iganga District Local Government  2022',
 'Isingiro District Local Government  2023',
 'Kaabong District Local Government  2023',
 'Kabale District Local Government  2023',
 'Kabarole District Local Government  2023',
 'Kaberamaido District Local Government  2022',
 'Kalaki District Local Government  2023',
 'Kalangala District Local Government  2018',
 'Kalangala District Local Government  2019',
 'Kalangala District Local Government  2020',
 'Kalangala District Local Government  2021',
 'Kalangala District Local Government  2022',
 'Kalungu District Local Government  2022',
 'Kamuli District Local Government  2022',
 'Kamwenge District Local Government  2023',
 'Kanungu District Local Government  2023',
 'Kapchorwa District Local Government  2023',
 'Kasese District Local Government  2023',
 'Kasese Municipal Council  2023',
 'Kassanda District Local Government  2023',
 'Katakwi District Local Government  2023',
 'Kawempe National Referral Hospital 2023',
 'Kazo District Local Government  2023',
 'KCCA  2018',
 'KCCA  2019',
 'KCCA  2020',
 'KCCA  2021',
 'KCCA  2022',
 'Kibaale District Local Government  2023',
 'Kiboga District Local Government  2023',
 'Kibuku District Local Government  2023',
 'Kikuube District Local Government   2023',
 'Kiruddu National Referral Hospital 2023',
 'Kiruhura District Local Government  2023',
 'Kiryandongo District Local Government  2023',
 'Kisoro District Local Government  2023',
 'Kitagwenda District Local Government  2023',
 'Kitgum District Local Government  2023',
 'Kole District Local Government  2023',
 'Kwania District Local Government  2023',
 'Kween District Local Government  2023',
 'Kyankwanzi District Local Government  2023',
 'Kyegegwa District Local Government  2023',
 'Kyenjojo District Local Government  2023',
 'Kyotera District Local Government  2023',
 'Lamwo District Local Government  2023',
 'Lira District Local Government 2023',
 'Lira Regional Referral Hospital 2023',
 'Luuka District Local Government  2022',
 'Lwengo District Local Government  2022',
 'Lyantonde District Local Government  2022',
 'Manafwa District Local Government  2023',
 'Masaka District Local Government  2022',
 'Masaka Regional Referral Hospital 2022',
 'Masindi District Local Government  2023',
 'Mayuge District Local Government  2022',
 'Mbale District Local Government   2023',
 'Mbale Regional Referral Hospital 2023',
 'Mbarara District Local Government  2023',
 'Mbarara Regional Referral Hospital 2023',
 'Ministry of Agriculture, Animal Industry and Fisheries 2019',
 'Ministry of Agriculture, Animal Industry and Fisheries 2021',
 'Ministry of Agriculture, Animal Industry and Fisheries 2022',
 'Ministry of Defence and Veteran Affairs (MoDVA) 2023',
 'Ministry of Health 2023',
 'Ministry of Internal Affairs 2023',
 'Ministry of Justice and Constitutional Affairs 2023',
 'Ministry of Lands, Housing and Urban Development (MOLHUD) 2023',
 'Ministry of Works and Transport (MoWT)   2021',
 'Ministry of Works and Transport (MoWT)   2022',
 'Ministry of Works and Transport (MoWT)  2019',
 'Ministry of Works and Transport (MoWT)  2020',
 'Mitooma District Local Government  2023',
 'Moroto Regional Referral Hospital 2023',
 'Moyo District Local Government 2023',
 'Mubende District Local Government  2022',
 'Mubende Regional Referral Hospital 2022',
 'Mulago National Referral Hospital 2023',
 'Mulago Specialized Women and Neonatal Hospital 2023',
 'Nakaseke District Local Government  2023',
 'Namayingo District Local Government  2022',
 'Namutumba District Local Government  2022',
 'Napak District Local Government 2023',
 'National Animal Genetic Resource Centre and Data Bank   2023',
 'National Oil Palm Project (NOPP) IFAD  2023',
 'Ntoroko District Local Government  2023',
 'Ntungamo District Local Government 2023',
 'Nwoya District Local Government  2023',
 'Obongi District Local Government  2023',
 'Office of the President  2023',
 'Omoro District Local Government  2023',
 'Pallisa District Local Government  2023',
 'Parish Development Model Thematic Report 2023',
 'Public Financial Management System Thematic Report 2023',
 'Rakai District Local Government  2022',
 'Rubanda District Local Government  2023',
 'Rubirizi District Local Government 2023',
 'Rukiga District Local Government  2023',
 'Rukungiri District Local Government  2023',
 'Rwampara District Local Government ,2023',
 'Sample of Selected Urban Infrastructure Projects implemented by Gulu City Council 2021',
 'Sheema District Local Government  2023',
 'Sironko District Local Government  2023',
 'Soroti Regional Referral Hospital 2023',
 'Terego District Local Government  2023',
 'Tororo District Local Government   2023',
 'Uganda Coffee Development Authority (UCDA) 2023',
 'Uganda Cotton Development Organization  2023',
 'Uganda Country Coordinating Mechanism (UCCM)  2022',
 'Uganda Police Force 2023',
 'Uganda Prisons Service (UPS)  2023',
 'Uganda Registration Services Bureau - Liquidation 2023',
 'Uganda Spain Debt SWAP (USDP)  2023',
 'Bugiri District Local Government  2023',
 'Bugweri District Local Government  2023',
 'Bukomansimbi District Local Government  2023',
 'Buyende District Local Government  2023',
 'Delivery of Universal Primary Education Value for money Audit Report 2023',
 'Education Services for Learners with Special Needs Value for money Audit Report 2023',
 'GAVI the Vaccine Alliance Cash Grant to Uganda- Health Systems Strengthening Coverage and Equity 2023',
 'Gomba District Local Government  2023',
 'Iganga District Local Government  2023',
 'Kaberamiado District Local Government  2023',
 'Kalangala District Local Government  2023',
 'Kalungu District Local Government 2023',
 'Kamuli District Local Governmnent 2023',
 'Koboko District Local Government  2023',
 'Luuka District Local Government  2023',
 'Lwengo District Local Government 2023',
 'Lyantonde District Local Government  2023',
 'Madi Okollo District Local Government  2023',
 'Maracha District Local Government  2023',
 'Masaka District Local Government  2023',
 'Masaka Regional Referral Hospital 2023',
 'Mayuge District Local Government  2023',
 'Ministry of Agriculture, Animal Industry and Fisheries 2020',
 'Ministry of Local Government (MoLG)  2023',
 'Ministry of Works and Transport (MoWT)  2023',
 'Mubende District Local Government 2023',
 'Mubende Regional Referral Hospital 2023',
 'Namayingo District Local Government  2023',
 'Namisindwa District Local Government  2023',
 'Namutumba District Local Government  2023',
 'Napak District Local Government  2023',
 'Nebbi District Local Government  2023',
 'Ntoroko District Local Government 2023',
 'Packwach District Local Government  2023',
 'Pader District Local Government  2023',
 'Rakai District Local Government 2023',
 'Uganda Civil Aviation Authority (UCAA)  2023',
 'Uganda National Roads Authority (UNRA)  2023',
 'Uganda Railway Corporation (URC)  2023',
 'Uganda Road Fund (URF)  2023',
 'Yumbe District Local Government  2023',
 'Zombo District Local Government  2023',
 'Annual Consolidated OAG 2020',
 'Annual Consolidated OAG 2021',
 'Annual Consolidated OAG 2022',
 'Annual Consolidated OAG 2023',
 'Annual Consolidated OAG 2024']
report_list = ['Annual Consolidated OAG audit reports 2018',
 'Annual Consolidated OAG audit reports 2019',
 'Annual Consolidated OAG audit reports 2020',
 'Annual Consolidated OAG audit reports 2021',
 'Annual Consolidated OAG audit reports 2022',
 'Gulu DLG Report of Auditor General 2018',
 'Gulu DLG Report of Auditor General 2019',
 'Gulu DLG Report of Auditor General 2020',
 'Gulu DLG Report of Auditor General 2021',
 'Gulu DLG Report of Auditor General 2022',
 'Kalangala DLG Report of Auditor General 2018',
 'Kalangala DLG Report of Auditor General 2019',
 'Kalangala DLG Report of Auditor General 2020',
 'Kalangala DLG Report of Auditor General 2021',
 'Kalangala DLG Report of Auditor General 2022',
 'KCCA Report of Auditor General 2018',
 'KCCA Report of Auditor General 2019',
 'KCCA Report of Auditor General 2020',
 'KCCA Report of Auditor General 2021',
 'KCCA Report of Auditor General 2022',
 'MAAIF Report of Auditor General 2019',
 'MAAIF Report of Auditor General 2021',
 'MAAIF Report of Auditor General 2022',
 'MAAIF Report of Auditor General 2020',
 'MWTS Report of Auditor General 2019',
 'MWTS Report of Auditor General 2020',
 'MWTS Report of Auditor General 2021',
 'MWTS Report of Auditor General 2022']

files = {'Consolidated':{'Consolidated Annnual Report':['Annual Consolidated OAG audit reports 2018',
                                                        'Annual Consolidated OAG audit reports 2019',
                                                        'Annual Consolidated OAG audit reports 2020',
                                                        'Annual Consolidated OAG audit reports 2021',
                                                        'Annual Consolidated OAG audit reports 2022']},
        'District':{'Gulu':['Gulu DLG Report of Auditor General 2018',
                            'Gulu DLG Report of Auditor General 2019',
                            'Gulu DLG Report of Auditor General 2020',
                            'Gulu DLG Report of Auditor General 2021',
                            'Gulu DLG Report of Auditor General 2022'],
                    'Kalangala':['Kalangala DLG Report of Auditor General 2018',
                                 'Kalangala DLG Report of Auditor General 2019',
                                 'Kalangala DLG Report of Auditor General 2020',
                                 'Kalangala DLG Report of Auditor General 2021',
                                 'Kalangala DLG Report of Auditor General 2022'],
                    'Kampala':['KCCA Report of Auditor General 2018',
                               'KCCA Report of Auditor General 2019',
                               'KCCA Report of Auditor General 2020',
                               'KCCA Report of Auditor General 2021',
                               'KCCA Report of Auditor General 2022']},
        'Ministry':{'Agriculture, Animal Industry and Fisheries':['MAAIF Report of Auditor General 2019',
                                                                  'MAAIF Report of Auditor General 2020',
                                                                  'MAAIF Report of Auditor General 2021',
                                                                  'MAAIF Report of Auditor General 2022'],
                    'Works and Transport':['MWTS Report of Auditor General 2019',
                                           'MWTS Report of Auditor General 2020',
                                           'MWTS Report of Auditor General 2021',
                                           'MWTS Report of Auditor General 2022']
                                           }
        }
new_files = {'Consolidated': ['Annual Consolidated OAG 2024',
 'Annual Consolidated OAG 2023',
 'Annual Consolidated OAG 2022',
 'Annual Consolidated OAG 2021',
 'Annual Consolidated OAG 2020',
 'Annual Consolidated OAG 2019',
 'Annual Consolidated OAG 2018'],
 'Local Government': ['Alebtong District Local Government  2023',
 'Amuru District Local Government  2023',
 'Apac District Local Government  2023',
 'Budaka District Local Government   2023',
 'Bugiri District Local Government  2022',
 'Bugweri District Local Government  2022',
 'Buhweju District Local Government  2023',
 'Bukomansimbi District Local Government  2022',
 'Bukwo District Local Government  2023',
 'Bulambuli District Local Government  2023',
 'Buliisa District Local Government  2023',
 'Bundibugyo District Local Government  2023',
 'Bunyangabu District Local Government  2023',
 'Busia District Local Government  2023',
 'Butambala District Local Government  2023',
 'Buyende District Local Government  2022',
 'Gomba District Local Government  2022',
 'Gulu District Local Government  2018',
 'Gulu District Local Government  2019',
 'Gulu District Local Government  2020',
 'Gulu District Local Government  2021',
 'Gulu District Local Government  2022',
 'Gulu District Local Government  2023',
 'Hoima District Local Government  2023',
 'Ibanda District Local Government  2023',
 'Iganga District Local Government  2022',
 'Isingiro District Local Government  2023',
 'Kaabong District Local Government  2023',
 'Kabale District Local Government  2023',
 'Kabarole District Local Government  2023',
 'Kaberamaido District Local Government  2022',
 'Kalaki District Local Government  2023',
 'Kalangala District Local Government  2018',
 'Kalangala District Local Government  2019',
 'Kalangala District Local Government  2020',
 'Kalangala District Local Government  2021',
 'Kalangala District Local Government  2022',
 'Kalungu District Local Government  2022',
 'Kamuli District Local Government  2022',
 'Kamwenge District Local Government  2023',
 'Kanungu District Local Government  2023',
 'Kapchorwa District Local Government  2023',
 'Kasese District Local Government  2023',
 'Kasese Municipal Council  2023',
 'Kassanda District Local Government  2023',
 'Katakwi District Local Government  2023',
 'Kazo District Local Government  2023',
 'KCCA  2018',
 'KCCA  2019',
 'KCCA  2020',
 'KCCA  2021',
 'KCCA  2022',
 'Kibaale District Local Government  2023',
 'Kiboga District Local Government  2023',
 'Kibuku District Local Government  2023',
 'Kikuube District Local Government   2023',
 'Kiruhura District Local Government  2023',
 'Kiryandongo District Local Government  2023',
 'Kisoro District Local Government  2023',
 'Kitagwenda District Local Government  2023',
 'Kitgum District Local Government  2023',
 'Kole District Local Government  2023',
 'Kwania District Local Government  2023',
 'Kween District Local Government  2023',
 'Kyankwanzi District Local Government  2023',
 'Kyegegwa District Local Government  2023',
 'Kyenjojo District Local Government  2023',
 'Kyotera District Local Government  2023',
 'Lamwo District Local Government  2023',
 'Lira District Local Government 2023',
 'Luuka District Local Government  2022',
 'Lwengo District Local Government  2022',
 'Lyantonde District Local Government  2022',
 'Manafwa District Local Government  2023',
 'Masaka District Local Government  2022',
 'Masindi District Local Government  2023',
 'Mayuge District Local Government  2022',
 'Mbale District Local Government   2023',
 'Mbarara District Local Government  2023',
 'Mitooma District Local Government  2023',
 'Moyo District Local Government 2023',
 'Mubende District Local Government  2022',
 'Nakaseke District Local Government  2023',
 'Namayingo District Local Government  2022',
 'Namutumba District Local Government  2022',
 'Napak District Local Government 2023',
 'Ntoroko District Local Government  2023',
 'Ntungamo District Local Government 2023',
 'Nwoya District Local Government  2023',
 'Obongi District Local Government  2023',
 'Omoro District Local Government  2023',
 'Pallisa District Local Government  2023',
 'Rakai District Local Government  2022',
 'Rubanda District Local Government  2023',
 'Rubirizi District Local Government 2023',
 'Rukiga District Local Government  2023',
 'Rukungiri District Local Government  2023',
 'Rwampara District Local Government ,2023',
 'Sheema District Local Government  2023',
 'Sironko District Local Government  2023',
 'Terego District Local Government  2023',
 'Tororo District Local Government   2023',
 'Bugiri District Local Government  2023',
 'Bugweri District Local Government  2023',
 'Bukomansimbi District Local Government  2023',
 'Buyende District Local Government  2023',
 'Gomba District Local Government  2023',
 'Iganga District Local Government  2023',
 'Kaberamiado District Local Government  2023',
 'Kalangala District Local Government  2023',
 'Kalungu District Local Government 2023',
 'Kamuli District Local Governmnent 2023',
 'Koboko District Local Government  2023',
 'Luuka District Local Government  2023',
 'Lwengo District Local Government 2023',
 'Lyantonde District Local Government  2023',
 'Madi Okollo District Local Government  2023',
 'Maracha District Local Government  2023',
 'Masaka District Local Government  2023',
 'Mayuge District Local Government  2023',
 'Mubende District Local Government 2023',
 'Namayingo District Local Government  2023',
 'Namisindwa District Local Government  2023',
 'Namutumba District Local Government  2023',
 'Napak District Local Government  2023',
 'Nebbi District Local Government  2023',
 'Ntoroko District Local Government 2023',
 'Packwach District Local Government  2023',
 'Pader District Local Government  2023',
 'Rakai District Local Government 2023',
 'Yumbe District Local Government  2023',
 'Zombo District Local Government  2023'],
 'Ministry, Department and Agency': ['Ministry of Agriculture, Animal Industry and Fisheries 2019',
 'Ministry of Agriculture, Animal Industry and Fisheries 2021',
 'Ministry of Agriculture, Animal Industry and Fisheries 2022',
 'Ministry of Defence and Veteran Affairs (MoDVA) 2023',
 'Ministry of Health 2023',
 'Ministry of Internal Affairs 2023',
 'Ministry of Justice and Constitutional Affairs 2023',
 'Ministry of Lands, Housing and Urban Development (MOLHUD) 2023',
 'Ministry of Works and Transport (MoWT)   2021',
 'Ministry of Works and Transport (MoWT)   2022',
 'Ministry of Works and Transport (MoWT)  2019',
 'Ministry of Works and Transport (MoWT)  2020',
 'National Animal Genetic Resource Centre and Data Bank   2023',
 'Office of the President  2023',
 'Uganda Coffee Development Authority (UCDA) 2023',
 'Uganda Cotton Development Organization  2023',
 'Uganda Country Coordinating Mechanism (UCCM)  2022',
 'Uganda Police Force 2023',
 'Uganda Prisons Service (UPS)  2023',
 'Uganda Registration Services Bureau - Liquidation 2023',
 'Ministry of Agriculture, Animal Industry and Fisheries 2020',
 'Ministry of Local Government (MoLG)  2023',
 'Ministry of Works and Transport (MoWT)  2023',
 'Uganda Civil Aviation Authority (UCAA)  2023',
 'Uganda National Roads Authority (UNRA)  2023',
 'Uganda Railway Corporation (URC)  2023',
 'Uganda Road Fund (URF)  2023'],
 'Project':['Agriculture Cluster Development Project IDA Credit 56110-UG  2023',
 'Agriculture Value Chain Development Project (AVCDP)  2023',
 'Albertine Region Sustainable Development Project (ARSDP) 2023',
 'East Africas Centers of Excellence for Skills and Tertiary Education in Biomedical Sciences Phase1 2023',
 'GAVI the Vaccine Alliance  Health Systems Strengthening Coverage & Equity  2023',
 'GAVI the Vaccine Alliance COVID-19 Vaccine Delivery Support Early Access Window  2023',
 'National Oil Palm Project (NOPP) IFAD  2023',
 'Uganda Spain Debt SWAP (USDP)  2023',
 'GAVI the Vaccine Alliance Cash Grant to Uganda- Health Systems Strengthening Coverage and Equity 2023'],
 'Hospital':['Entebbe Regional Referral Hospital 2023',
 'Gulu Regional Referral Hospital 2023',
 'Kawempe National Referral Hospital 2023',
 'Kiruddu National Referral Hospital 2023',
 'Lira Regional Referral Hospital 2023',
 'Masaka Regional Referral Hospital 2022',
 'Mbale Regional Referral Hospital 2023',
 'Mbarara Regional Referral Hospital 2023',
 'Moroto Regional Referral Hospital 2023',
 'Mubende Regional Referral Hospital 2022',
 'Mulago National Referral Hospital 2023',
 'Mulago Specialized Women and Neonatal Hospital 2023',
 'Soroti Regional Referral Hospital 2023',
 'Masaka Regional Referral Hospital 2023',
 'Mubende Regional Referral Hospital 2023'],
 'Thematic': ['Bugdet Performance Thematic  Report 2023',
 'Parish Development Model Thematic Report 2023',
 'Public Financial Management System Thematic Report 2023'],
 'Value for Money': ['Sample of Selected Urban Infrastructure Projects implemented by Gulu City Council 2021',
 'Delivery of Universal Primary Education Value for money Audit Report 2023',
 'Education Services for Learners with Special Needs Value for money Audit Report 2023']}