[{"id":1,"project_code":"PRJ-2024-001","name":"Lusaka Central Market Rehabilitation","description":"Renovation of Lusaka Central Market sanitation facilities.","constituency_id":"1","ward":"Ward 1","sector":"health","budget":"2400000.00","payment_released":"1680000.00","contractor_name":"Zambia Contractors Ltd","contractor_contact":null,"geo_lat":null,"geo_lng":null,"status":"ongoing","completion_percentage":"70","start_date":"2024-01-14T22:00:00.000000Z","end_date":"2024-12-30T22:00:00.000000Z","photo_url":null,"procurement_method":"open_tender","tender_number":"ZCL\/2024\/001","bid_advertisement_date":"2023-09-30T22:00:00.000000Z","contract_award_date":"2023-11-14T22:00:00.000000Z","contract_number":"ZCL-C\/001\/24","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z","constituency":{"id":1,"name":"Lusaka Central","province":"Lusaka","mp_name":"Hon. Chitalu Chilufya","total_allocation":"3200000.00","disbursed":"2100000.00","infrastructure_budget":"1920000.00","bursaries_budget":"640000.00","empowerment_budget":"480000.00","emergency_budget":"160000.00","utilisation_rate":"65.60","year":"2026","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z"}},{"id":2,"project_code":"PRJ-2024-002","name":"Kitwe Road Resurfacing \u2014 Nkana East","description":"Resurfacing of 5km access road serving 4 wards.","constituency_id":"2","ward":"Ward 1","sector":"roads","budget":"1800000.00","payment_released":"1800000.00","contractor_name":"Copperbelt Roads Ltd","contractor_contact":null,"geo_lat":null,"geo_lng":null,"status":"completed","completion_percentage":"100","start_date":"2024-01-31T22:00:00.000000Z","end_date":"2024-08-30T22:00:00.000000Z","photo_url":null,"procurement_method":"open_tender","tender_number":"CRL\/2024\/007","bid_advertisement_date":"2023-10-31T22:00:00.000000Z","contract_award_date":"2023-12-09T22:00:00.000000Z","contract_number":"CRL-C\/007\/24","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z","constituency":{"id":2,"name":"Kitwe Central","province":"Copperbelt","mp_name":"Hon. Binwell Mpundu","total_allocation":"2800000.00","disbursed":"1750000.00","infrastructure_budget":"1680000.00","bursaries_budget":"560000.00","empowerment_budget":"420000.00","emergency_budget":"140000.00","utilisation_rate":"62.50","year":"2026","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z"}},{"id":3,"project_code":"PRJ-2024-003","name":"Ndola Community Health Post Construction","description":"Construction of a new community health post in Mushili Ward.","constituency_id":"3","ward":"Ward 1","sector":"health","budget":"2200000.00","payment_released":"1100000.00","contractor_name":"Ndola Build Co.","contractor_contact":null,"geo_lat":null,"geo_lng":null,"status":"ongoing","completion_percentage":"50","start_date":"2024-02-29T22:00:00.000000Z","end_date":"2024-12-14T22:00:00.000000Z","photo_url":null,"procurement_method":"restricted_tender","tender_number":"NBC\/2024\/003","bid_advertisement_date":"2024-01-14T22:00:00.000000Z","contract_award_date":"2024-02-19T22:00:00.000000Z","contract_number":"NBC-C\/003\/24","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z","constituency":{"id":3,"name":"Ndola Central","province":"Copperbelt","mp_name":"Hon. Elisha Matambo","total_allocation":"2600000.00","disbursed":"1950000.00","infrastructure_budget":"1560000.00","bursaries_budget":"520000.00","empowerment_budget":"390000.00","emergency_budget":"130000.00","utilisation_rate":"75.00","year":"2026","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z"}},{"id":4,"project_code":"PRJ-2024-004","name":"Livingstone Solar Borehole Programme","description":"Installation of 10 solar-powered boreholes across 5 wards.","constituency_id":"4","ward":"Ward 1","sector":"water_sanitation","budget":"1600000.00","payment_released":"1280000.00","contractor_name":"SunWater Solutions","contractor_contact":null,"geo_lat":null,"geo_lng":null,"status":"ongoing","completion_percentage":"80","start_date":"2024-01-19T22:00:00.000000Z","end_date":"2024-09-29T22:00:00.000000Z","photo_url":null,"procurement_method":"quotation","tender_number":null,"bid_advertisement_date":null,"contract_award_date":null,"contract_number":null,"created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z","constituency":{"id":4,"name":"Livingstone","province":"Southern","mp_name":"Hon. Lawrence Sambo","total_allocation":"2400000.00","disbursed":"1440000.00","infrastructure_budget":"1440000.00","bursaries_budget":"480000.00","empowerment_budget":"360000.00","emergency_budget":"120000.00","utilisation_rate":"60.00","year":"2026","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z"}},{"id":5,"project_code":"PRJ-2024-005","name":"Chawama Primary School Block Extension","description":"Two-classroom extension at Chawama Primary School.","constituency_id":"5","ward":"Ward 1","sector":"education","budget":"1200000.00","payment_released":"840000.00","contractor_name":"Build Zambia Ltd","contractor_contact":null,"geo_lat":null,"geo_lng":null,"status":"ongoing","completion_percentage":"70","start_date":"2024-03-31T22:00:00.000000Z","end_date":"2024-10-30T22:00:00.000000Z","photo_url":null,"procurement_method":"direct_procurement","tender_number":null,"bid_advertisement_date":null,"contract_award_date":null,"contract_number":null,"created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z","constituency":{"id":5,"name":"Chawama","province":"Lusaka","mp_name":"Hon. Tasila Lungu","total_allocation":"2200000.00","disbursed":"1540000.00","infrastructure_budget":"1320000.00","bursaries_budget":"440000.00","empowerment_budget":"330000.00","emergency_budget":"110000.00","utilisation_rate":"70.00","year":"2026","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z"}},{"id":6,"project_code":"PRJ-2024-006","name":"Kabwata Market Stalls Construction","description":"Construction of 40 new market stalls at Kabwata market.","constituency_id":"6","ward":"Ward 1","sector":"markets","budget":"1500000.00","payment_released":"750000.00","contractor_name":"Lusaka Contractors Ltd","contractor_contact":null,"geo_lat":null,"geo_lng":null,"status":"ongoing","completion_percentage":"50","start_date":"2024-02-14T22:00:00.000000Z","end_date":"2024-11-29T22:00:00.000000Z","photo_url":null,"procurement_method":"open_tender","tender_number":"LCL\/2024\/012","bid_advertisement_date":"2023-11-30T22:00:00.000000Z","contract_award_date":"2024-01-09T22:00:00.000000Z","contract_number":"LCL-C\/012\/24","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z","constituency":{"id":6,"name":"Kabwata","province":"Lusaka","mp_name":"Hon. Given Lubinda","total_allocation":"2500000.00","disbursed":"1625000.00","infrastructure_budget":"1500000.00","bursaries_budget":"500000.00","empowerment_budget":"375000.00","emergency_budget":"125000.00","utilisation_rate":"65.00","year":"2026","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z"}},{"id":7,"project_code":"PRJ-2024-007","name":"Mandevu Police Post Construction","description":"Construction of a new police post in Mandevu Ward 3.","constituency_id":"7","ward":"Ward 1","sector":"security","budget":"900000.00","payment_released":"630000.00","contractor_name":"Security Build Co.","contractor_contact":null,"geo_lat":null,"geo_lng":null,"status":"ongoing","completion_percentage":"70","start_date":"2024-03-14T22:00:00.000000Z","end_date":"2024-10-14T22:00:00.000000Z","photo_url":null,"procurement_method":"quotation","tender_number":null,"bid_advertisement_date":null,"contract_award_date":null,"contract_number":null,"created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z","constituency":{"id":7,"name":"Mandevu","province":"Lusaka","mp_name":"Hon. Jean Kapata","total_allocation":"2300000.00","disbursed":"1380000.00","infrastructure_budget":"1380000.00","bursaries_budget":"460000.00","empowerment_budget":"345000.00","emergency_budget":"115000.00","utilisation_rate":"60.00","year":"2026","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z"}},{"id":8,"project_code":"PRJ-2024-008","name":"Kwacha Water Reticulation","description":"Extension of water pipes to serve 3 unserved wards.","constituency_id":"8","ward":"Ward 1","sector":"water_sanitation","budget":"2000000.00","payment_released":"1400000.00","contractor_name":"Copperbelt Water Ltd","contractor_contact":null,"geo_lat":null,"geo_lng":null,"status":"ongoing","completion_percentage":"70","start_date":"2024-01-09T22:00:00.000000Z","end_date":"2024-12-19T22:00:00.000000Z","photo_url":null,"procurement_method":"open_tender","tender_number":"CWL\/2024\/005","bid_advertisement_date":"2023-11-14T22:00:00.000000Z","contract_award_date":"2023-12-19T22:00:00.000000Z","contract_number":"CWL-C\/005\/24","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z","constituency":{"id":8,"name":"Kwacha","province":"Copperbelt","mp_name":"Hon. Joseph Malanji","total_allocation":"2700000.00","disbursed":"1890000.00","infrastructure_budget":"1620000.00","bursaries_budget":"540000.00","empowerment_budget":"405000.00","emergency_budget":"135000.00","utilisation_rate":"70.00","year":"2026","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z"}},{"id":9,"project_code":"PRJ-2024-009","name":"Monze Secondary School Laboratory","description":"Construction of a science laboratory at Monze Secondary.","constituency_id":"9","ward":"Ward 1","sector":"education","budget":"1100000.00","payment_released":"440000.00","contractor_name":"Southern Builders","contractor_contact":null,"geo_lat":null,"geo_lng":null,"status":"ongoing","completion_percentage":"40","start_date":"2024-04-14T22:00:00.000000Z","end_date":"2024-12-30T22:00:00.000000Z","photo_url":null,"procurement_method":"restricted_tender","tender_number":"SB\/2024\/002","bid_advertisement_date":"2024-01-31T22:00:00.000000Z","contract_award_date":"2024-02-29T22:00:00.000000Z","contract_number":"SB-C\/002\/24","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z","constituency":{"id":9,"name":"Monze Central","province":"Southern","mp_name":"Hon. Jack Mwiimbu","total_allocation":"2100000.00","disbursed":"1260000.00","infrastructure_budget":"1260000.00","bursaries_budget":"420000.00","empowerment_budget":"315000.00","emergency_budget":"105000.00","utilisation_rate":"60.00","year":"2026","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z"}},{"id":10,"project_code":"PRJ-2024-010","name":"Kasama Feeder Road Rehabilitation","description":"Rehabilitation of 8km feeder road in Chishimba Ward.","constituency_id":"10","ward":"Ward 1","sector":"roads","budget":"1400000.00","payment_released":"980000.00","contractor_name":"Northern Roads Ltd","contractor_contact":null,"geo_lat":null,"geo_lng":null,"status":"ongoing","completion_percentage":"70","start_date":"2024-02-19T22:00:00.000000Z","end_date":"2024-11-29T22:00:00.000000Z","photo_url":null,"procurement_method":"open_tender","tender_number":"NRL\/2024\/003","bid_advertisement_date":"2023-12-14T22:00:00.000000Z","contract_award_date":"2024-01-24T22:00:00.000000Z","contract_number":"NRL-C\/003\/24","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z","constituency":{"id":10,"name":"Kasama Central","province":"Muchinga","mp_name":"Hon. Kelvin Sampa","total_allocation":"2000000.00","disbursed":"1400000.00","infrastructure_budget":"1200000.00","bursaries_budget":"400000.00","empowerment_budget":"300000.00","emergency_budget":"100000.00","utilisation_rate":"70.00","year":"2026","created_at":"2026-05-23T17:15:15.000000Z","updated_at":"2026-05-23T17:15:15.000000Z"}}]