open-data-visualization/debug_run.log at main · bettergovph/open-data-visualization · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
ƒöº Loading historical district data from districts.json...
Ô£à Loaded 283 historical representative terms into district_history
Loading Unified Location Database from static/data/unified_locations.parquet...
Ô£à Location DB loaded. Indexed 40699 locations.
Ô£à Found 1428 unique municipalities/cities.
Ô£à Loaded 38947 location entries from unified_locations.parquet
Ôä╣´©Å  Normal mode: Skipping projects that are already fully classified
ƒÜÇ Starting dynasty-projects cache generation (DuckDB version - Parquet only)...
ƒÜÇ Building Inverted Index for Locations...
Ô£à Indexed 38947 locations.
Ô£à Loaded config with 432 congressmen
Ô£à Found political_dynasties.parquet at /home/joebert/open-data-visualization/data/parquet/political_dynasties.parquet
ƒöì politician_contractors.parquet columns: ['id', 'politician_id', 'contractor_name', 'match_confidence', 'notes', 'source', 'created_at', 'updated_at']
   ƒöä Joining with /home/joebert/open-data-visualization/data/parquet/political_dynasties.parquet to resolve politician IDs...
Ô£à Loaded 288 verified contractor matches (with sources) from politician_contractors.parquet
ÔÜá´©Å  Failed to load party members from Parquet: Binder Error: Referenced column "first_name" not found in FROM clause!
Candidate bindings: "party_name", "party_list_number", "party_code", "id", "created_at"

LINE 1: SELECT person_id, party_list_number, first_name, last_name FROM read_parquet('/home/joebert/open...
                                             ^
Ô£à Loaded 59 party list members from DuckDB
Ô£à Abraham Tolentino: Loaded 8 municipalities for 8th District: ['Naic', 'Alfonso', 'Ternate']...
Ô£à Arnie Teves: Loaded 8 municipalities for 3rd District: ['Basay', 'Dauin', 'Bacong']...
Ô£à Arthur C. Yap: Loaded 19 municipalities for 3rd District: ['Anda', 'Lila', 'Loay']...
Ô£à Aurelio Due├▒as Gonzales Jr.: Loaded 4 municipalities for 3rd District: ['Arayat', 'Mexico', 'Bacolor']...
Ô£à Bai Sandra Sema: Loaded 12 municipalities for 1st District: ['Upi', 'Barira', 'Buldon']...
Ô£à Bernadette Herrera: Loaded 1 municipalities for Nationwide: ['Nationwide']...
Ô£à Bojie Dy: Loaded 4 municipalities for 6th District: ['Echague', 'San Isidro', 'Cauayan City']...
Ô£à Camille Villar: Loaded 20 municipalities for Lone District: ['Ilaya', 'Pilar', 'Zapote']...
Ô£à Conrado Estrella III: Loaded 1 municipalities for Nationwide: ['Nationwide']...
Ô£à Dan Fernandez: Loaded 1 municipalities for 1st District: ['City of San Pedro']...
Ô£à David Catarina Suarez: Loaded 7 municipalities for 2nd District: ['Lucena', 'Tiaong', 'Dolores']...
Ô£à Deogracias Victor Savellano: Loaded 11 municipalities for 1st District: ['Bantay', 'Sinait', 'Cabugao']...
Ô£à Divina Grace Yu: Loaded 12 municipalities for 1st District: ['Aurora', 'Molave', 'Mahayag']...
Ô£à Duke Frasco: Loaded 4 municipalities for 5th District: ['Liloan', 'Compostela', 'Danao City']...
Ô£à Eddie Villanueva: Loaded 1 municipalities for Nationwide: ['Nationwide']...
Ô£à Elizaldy Salcedo Co: Loaded 1 municipalities for Nationwide: ['Nationwide']...
Ô£à Eric Singson: Loaded 23 municipalities for 2nd District: ['Suyo', 'Santa', 'Sigay']...
Ô£à Evelina Escudero: Loaded 7 municipalities for 1st District: ['Pilar', 'Donsol', 'Castilla']...
Ô£à Ferdinand Hernandez: Loaded 3 municipalities for 2nd District: ['Banga', 'Tantangan', 'Koronadal City']...
Ô£à Ferdinand Martin Gomez Romualdez: Loaded 2 municipalities for 1st District: ['Tacloban', 'Tacloban City']...
Ô£à Ferjenel Biron: Loaded 21 municipalities for 4th District: ['Ajuy', 'Mina', 'Sara']...
Ô£à Fredenil Castro: Loaded 10 municipalities for 2nd District: ['Dao', 'Sigma', 'Tapaz']...
Ô£à Frederick Abueg: Loaded 7 municipalities for 2nd District: ['Narra', 'Rizal', 'Quezon']...
Ô£à Gloria Macapagal Arroyo: Loaded 6 municipalities for 2nd District: ['Lubao', 'Porac', 'Guagua']...
Ô£à Gwendolyn Garcia: Loaded 7 municipalities for 3rd District: ['Barili', 'Sibonga', 'Asturias']...
Ô£à Henry Oaminal: Loaded 7 municipalities for 2nd District: ['Clarin', 'Tudela', 'Bonifacio']...
Ô£à Janette Garin: Loaded 8 municipalities for 2nd District: ['Pavia', 'Jordan', 'Leganes']...
Ô£à Jay Khonghun: Loaded 4 municipalities for 1st District: ['Subic', 'Castillejos', 'Olongapo City']...
Ô£à Johnny Pimentel: Loaded 5 municipalities for 2nd District: ['Barobo', 'Lingig', 'Tagbina']...
Ô£à Juan Pablo Bondoc: Loaded 9 municipalities for 4th District: ['Apalit', 'Candaba', 'Minalin']...
Ô£à Kristine Singson-Meehan: Loaded 23 municipalities for 2nd District: ['Suyo', 'Santa', 'Sigay']...
Ô£à Len Alonte: Loaded 24 municipalities for Lone District: ['Loma', 'Bi├▒an', 'Casile']...
Ô£à Linabelle Villarica: Loaded 8 municipalities for 4th District: ['Angat', 'Norzagaray', 'San Miguel']...
Ô£à Lito Atienza: Loaded 1 municipalities for Nationwide: ['Nationwide']...
Ô£à Loren Legarda: Loaded 17 municipalities for Lone District: ['Caluya', 'Culasi', 'Hamtic']...
Ô£à Luis Raymund Villafuerte: Loaded 7 municipalities for 2nd District: ['Gainza', 'Milaor', 'Pasacao']...
Ô£à Mercedes Alvarez: Loaded 6 municipalities for 6th District: ['Ilog', 'Candoni', 'Cauayan']...
Ô£à Mikee Romero: Loaded 1 municipalities for Nationwide: ['Nationwide']...
Ô£à Mujiv Hataman: Loaded 12 municipalities for At-large District: ['Akbar', 'Maluso', 'Sumisip']...
Ô£à Pablo John Garcia: Loaded 7 municipalities for 3rd District: ['Barili', 'Sibonga', 'Asturias']...
Ô£à Paolo Ortega: Loaded 9 municipalities for 1st District: ['Luna', 'Bangar', 'Santol']...
Ô£à Paulino Salvador C. Leachon: Loaded 8 municipalities for 1st District: ['Baco', 'Pola', 'Naujan']...
Ô£à Pia Cayetano: Loaded 1 municipalities for 2nd District: ['Taguig City']...
Ô£à Prospero Pichay Jr.: Loaded 14 municipalities for 1st District: ['Tago', 'Carmen', 'Cortes']...
Ô£à Ralph Recto: Loaded 8 municipalities for 6th District: ['Malvar', 'Taysan', 'Rosario']...
Ô£à Randolph Ting: Loaded 7 municipalities for 3rd District: ['Tuao', 'Iguig', 'Enrile']...
Ô£à Raneo Abu: Loaded 4 municipalities for 2nd District: ['Lobo', 'Mabini', 'Tingloy']...
Ô£à Raymond Mendoza: Loaded 1 municipalities for Nationwide: ['Nationwide']...
Ô£à Rodante Marcoleta: Loaded 1 municipalities for Nationwide: ['Nationwide']...
Ô£à Rogelio Pacquiao: Loaded 7 municipalities for At-large District: ['Glan', 'Alabel', 'Kiamba']...
Ô£à Rolando Andaya Jr.: Loaded 5 municipalities for 1st District: ['Lupi', 'Ragay', 'Cabusao']...
Ô£à Rose Marie Arenas: Loaded 6 municipalities for 3rd District: ['Calasiao', 'Mapandan', 'Bayambang']...
Ô£à Sharon Garin: Loaded 1 municipalities for Nationwide: ['Nationwide']...
Ô£à Strike Revilla: Loaded 1 municipalities for 2nd District: ['Bacoor City']...
Ôä╣´©Å  Processing Tirso Edwin Loleng Gardiola via contractors only (no district data)
Ô£à Tonypet Albano: Loaded 9 municipalities for 1st District: ['Cabagan', 'Tumauini', 'Divilacan']...
Ô£à Vilma Santos: Loaded 8 municipalities for 6th District: ['Malvar', 'Taysan', 'Rosario']...
Ô£à Yasser Balindong: Loaded 22 municipalities for 2nd District: ['Butig', 'Bayang', 'Picong']...
Ô£à Yevgeny Emano: Loaded 14 municipalities for 2nd District: ['Opol', 'Initao', 'Jasaan']...
Ô£à Gerald Anthony V. Gullas Jr.: Loaded 2 municipalities for 1st District: ['Minglanilla', 'Talisay City']...
Ô£à Eduardo R. Gullas: Loaded 2 municipalities for 1st District: ['Minglanilla', 'Talisay City']...
Ô£à Rhea Mae Daluz Gullas: Loaded 2 municipalities for 1st District: ['Minglanilla', 'Talisay City']...
Ô£à Wilfredo S. Caminero: Loaded 7 municipalities for 2nd District: ['Argao', 'Cebu City', 'Dalaguete']...
Ô£à Edsel Galeos: Loaded 7 municipalities for 2nd District: ['Argao', 'Cebu City', 'Dalaguete']...
Ô£à Benhur L. Salimbangon: Loaded 14 municipalities for 4th District: ['Pilar', 'Sogod', 'Borbon']...
Ô£à Janice Zamora Salimbangon: Loaded 14 municipalities for 4th District: ['Pilar', 'Sogod', 'Borbon']...
Ô£à Ramon Durano VI: Loaded 4 municipalities for 5th District: ['Liloan', 'Compostela', 'Danao City']...
Ô£à Emmarie Ouano-Dizon: Loaded 2 municipalities for 6th District: ['Mandaue City', 'Lapu-Lapu City']...
Ô£à Jonas Cortes: Loaded 2 municipalities for 6th District: ['Mandaue City', 'Lapu-Lapu City']...
Ô£à Peter John Calderon: Loaded 12 municipalities for 7th District: ['Alcoy', 'Oslob', 'Ronda']...
Ô£à Daphne Lagon: Loaded 2 municipalities for 6th District: ['Mandaue City', 'Lapu-Lapu City']...
Ô£à Danilo Domingo: Loaded 6 municipalities for 1st District: ['Bulakan', 'Hagonoy', 'Pulilan']...
Ô£à Marlo Bancoro: Loaded 9 municipalities for 1st District: ['Buug', 'Payao', 'Alicia']...
Ô£à Marlyn Hofer-Hasim: Loaded 7 municipalities for 2nd District: ['Ipil', 'Naga', 'Siay']...
Ô£à Roberto Uy Jr.: Loaded 8 municipalities for 1st District: ['Mutia', 'Rizal', 'Pi├▒an']...
Ô£à Gloria Irene Labadlabad: Loaded 7 municipalities for 2nd District: ['Siayan', 'Manukan', 'Katipunan']...
Ô£à Ian Amatong: Loaded 12 municipalities for 3rd District: ['Godod', 'Liloy', 'Salug']...
Ô£à Lawrence Lemuel Fortun: Loaded 2 municipalities for 1st District: ['Las Nieves', 'Butuan City']...
Ô£à Dale Corvera: Loaded 10 municipalities for 2nd District: ['Tubay', 'Carmen', 'Jabonga']...
Ô£à Rene Relampagos: Loaded 13 municipalities for 1st District: ['Loon', 'Dauis', 'Calape']...
Ô£à Edgar Chatto: Loaded 13 municipalities for 1st District: ['Loon', 'Dauis', 'Calape']...
Ô£à Erico Aristotle Aumentado: Loaded 13 municipalities for 2nd District: ['Ubay', 'Danao', 'Clarin']...
Ô£à Vanessa Aumentado: Loaded 13 municipalities for 2nd District: ['Ubay', 'Danao', 'Clarin']...
Ô£à Kristine Alexie Besas-Tutor: Loaded 19 municipalities for 3rd District: ['Anda', 'Lila', 'Loay']...
Ô£à Lani Mercado-Revilla: Loaded 1 municipalities for 2nd District: ['Bacoor City']...
Ô£à Bryan Revilla: Loaded 1 municipalities for Nationwide: ['Nationwide']...
Ô£à Ramon Rodrigo Gutierrez: Loaded 1 municipalities for Nationwide: ['Nationwide']...
Ô£à Jernie Jett Nisay: Loaded 1 municipalities for Nationwide: ['Nationwide']...
Ô£à Caroline Agyao: Loaded 8 municipalities for Lone District: ['Pasil', 'Rizal', 'Tanudan']...
Ô£à Allen Jesse Mangaoang: Loaded 8 municipalities for Lone District: ['Pasil', 'Rizal', 'Tanudan']...
Ô£à Carlos Loria: Loaded 10 municipalities for 2nd District: ['Oas', 'Libon', 'Daraga']...
Ô£à Eulogio Rodriguez: Loaded 11 municipalities for Lone District: ['Bato', 'Viga', 'Baras']...
Ô£à De Carlo Uy: Loaded 8 municipalities for 1st District: ['Carmen', 'Asuncion', 'Kapalong']...
Ô£à Ronald Singson: Loaded 11 municipalities for 1st District: ['Bantay', 'Sinait', 'Cabugao']...
Ô£à Jojo Lara: Loaded 7 municipalities for 3rd District: ['Tuao', 'Iguig', 'Enrile']...
Ô£à Francisco Jose Matugas II: Loaded 9 municipalities for 1st District: ['Dapa', 'Pilar', 'Burgos']...
Ô£à Anna York Bondoc: Loaded 9 municipalities for 4th District: ['Apalit', 'Candaba', 'Minalin']...
Ô£à Romeo Momo: Loaded 14 municipalities for 1st District: ['Tago', 'Carmen', 'Cortes']...
Ô£à Leonel Domo-ong Ceniza: Loaded 4 municipalities for 2nd District: ['Monkayo', 'Pantukan', 'Montevista']...
Ô£à Marie Bernadette Escudero: Loaded 7 municipalities for 1st District: ['Pilar', 'Donsol', 'Castilla']...
Ô£à Ramon Nolasco Sr.: Loaded 10 municipalities for 1st District: ['Alcala', 'Aparri', 'Baggao']...
Ô£à Ramon Nolasco Jr.: Loaded 10 municipalities for 1st District: ['Alcala', 'Aparri', 'Baggao']...
Ô£à Samantha Louise Vargas-Alfonso: Loaded 12 municipalities for 2nd District: ['Piat', 'Lasam', 'Rizal']...
Ô£à Baby Aline Vargas-Alfonso: Loaded 12 municipalities for 2nd District: ['Piat', 'Lasam', 'Rizal']...
Ô£à Gabriel Bordado Jr.: Loaded 6 municipalities for 3rd District: ['Bombon', 'Canaman', 'Magarao']...
Ô£à Arnulf Bryan Fuentebella: Loaded 8 municipalities for 4th District: ['Goa', 'Siruma', 'Tigaon']...
Ô£à Salvio Fortuno: Loaded 7 municipalities for 5th District: ['Baao', 'Bato', 'Buhi']...
Ô£à Miguel Luis Villafuerte: Loaded 7 municipalities for 5th District: ['Baao', 'Bato', 'Buhi']...
Ô£à Emmanuel Billones: Loaded 7 municipalities for 1st District: ['Panay', 'Pilar', 'Maayon']...
Ô£à Dante S. Garcia: Loaded 11 municipalities for 2nd District: ['Agoo', 'Caba', 'Pugo']...
Ô£à Ramil Hernandez: Loaded 3 municipalities for 2nd District: ['Bay', 'Los Ba├▒os', 'Cabuyao City']...
Ô£à Loreto S. Amante: Loaded 7 municipalities for 3rd District: ['Liliw', 'Rizal', 'Calauan']...
Ô£à Benjamin Agarao Jr.: Loaded 16 municipalities for 4th District: ['Famy', 'Pila', 'Paete']...
Ô£à Ziaur-Rahman A. Adiong: Loaded 18 municipalities for 1st District: ['Wao', 'Kapai', 'Masiu']...
Ô£à Jason P. Almonte: Loaded 10 municipalities for 1st District: ['Aloran', 'Panaon', 'Calamba']...
Ô£à Christian Unabia: Loaded 11 municipalities for 1st District: ['Salay', 'Medina', 'Balingoan']...
Ô£à Geraldine Joan Reyes Rosales: Loaded 5 municipalities for 1st District: ['Toboso', 'Calatrava', 'Escalante City']...
Ô£à Alfredo Mara├▒on III: Loaded 3 municipalities for 2nd District: ['Manapla', 'Cadiz City', 'Sagay City']...
Ô£à Javier Miguel L. Benitez: Loaded 5 municipalities for 3rd District: ['Murcia', 'Silay City', 'Talisay City']...
Ô£à Jeffrey P. Ferrer: Loaded 6 municipalities for 4th District: ['Bago City', 'Pontevedra', 'Pulupandan']...
Ô£à Emilio Bernardino Yulo III: Loaded 6 municipalities for 5th District: ['Isabela', 'Hinigaran', 'Binalbagan']...
Ô£à Ed Christopher S. Go: Loaded 6 municipalities for 2nd District: ['Gamu', 'Palanan', 'Naguilian']...
Ô£à Faustino A. Dy V: Loaded 5 municipalities for 3rd District: ['Ramon', 'Alicia', 'Cabatuan']...
Ô£à Joseph S. Tan: Loaded 5 municipalities for 4th District: ['Jones', 'Cordon', 'Dinapigue']...
Ô£à Ma. Lourdes P. Aggabao: Loaded 8 municipalities for 5th District: ['Luna', 'Roxas', 'Aurora']...
Ô£à Emmanuel Iway: Loaded 9 municipalities for 1st District: ['Bindoy', 'Ayungon', 'Tayasan']...
Ô£à Ma. Isabel L. Sagarbarria: Loaded 8 municipalities for 2nd District: ['Amlan', 'Mabinay', 'Sibulan']...
Ô£à Alfonso V. Umali Jr.: Loaded 7 municipalities for 2nd District: ['Roxas', 'Bansud', 'Gloria']...
Ô£à Rose Salvame: Loaded 15 municipalities for 1st District: ['Cuyo', 'Coron', 'Roxas']...
Ô£à Gil Acosta Jr.: Loaded 2 municipalities for 3rd District: ['Aborlan', 'Puerto Princesa City']...
Ô£à Zajid Mangudadatu: Loaded 25 municipalities for 2nd District: ['Buluan', 'Paglat', 'Pandag']...
Ô£à Mohamad Paglas: Loaded 25 municipalities for 2nd District: ['Buluan', 'Paglat', 'Pandag']...
Ô£à Arthur F. Celeste: Loaded 10 municipalities for 1st District: ['Agno', 'Anda', 'Bani']...
Ô£à Mark Cojuangco: Loaded 8 municipalities for 2nd District: ['Aguilar', 'Basista', 'Binmaley']...
Ô£à Gina de Venecia: Loaded 5 municipalities for 4th District: ['Manaoag', 'Mangaldan', 'San Fabian']...
Ô£à Marlyn Primicias-Agabas: Loaded 10 municipalities for 6th District: ['Tayug', 'Asingan', 'Rosales']...
Ô£à Isidro Lumayag: Loaded 3 municipalities for 1st District: ['Tupi', 'Tampakan', 'Polomolok']...
Ô£à Dibu Tuan: Loaded 6 municipalities for 3rd District: ['Norala', "T'boli", 'Surallah']...
Ô£à Doris E. Maniquiz: Loaded 10 municipalities for 2nd District: ['Iba', 'Botolan', 'Palauig']...
Ô£à Ricardo S. Cruz Jr.: Loaded 1 municipalities for 1st District: ['Pateros']...
Ô£à Jeyzel Victoria Yu: Loaded 15 municipalities for 2nd District: ['Bayog', 'Dinas', 'Guipos']...
Ô£à Alan Dujali: Loaded 3 municipalities for 2nd District: ['Tagum City', 'Panabo City', 'Braulio E. Dujali']...
Ô£à Raul Tupas: Loaded 7 municipalities for 5th District: ['Jaro', 'Molo', 'Lapuz']...
Ô£à Julienne Baronda: Loaded 1 municipalities for Lone District: ['Iloilo City']...
Ô£à Maria Carmen Zamora: Loaded 7 municipalities for 1st District: ['Laak', 'Maco', 'Mawab']...
Ô£à Lolita Javier: Loaded 14 municipalities for 2nd District: ['Jaro', 'Dulag', 'Tunga']...
Ô£à Maria Victoria Aumentado: Loaded 4 municipalities for 3rd District: ['Abuyog', 'Javier', 'Silago']...
Ô£à Richard Gomez: Loaded 5 municipalities for 4th District: ['Palo', 'Tabango', 'Santa Fe']...
Ô£à Carl Nicolas Cari: Loaded 3 municipalities for 5th District: ['Tolosa', 'Albuera', 'Tanauan']...
Ô£à Vicente S. Veloso III: Loaded 3 municipalities for 6th District: ['Leyte', 'Kananga', 'Babatngon']...
Ô£à Carmelo Lazatin II: Loaded 3 municipalities for 1st District: ['Magalang', 'Angeles City', 'Mabalacat City']...
Ô£à Augusto Sy-Alvarado: Loaded 1 municipalities for 2nd District: ['Obando']...
Ô£à Lorna Silverio: Loaded 2 municipalities for 3rd District: ['Bustos', 'Plaridel']...
Ô£à Ambrosio Cruz Jr.: Loaded 1 municipalities for 5th District: ['San Jose del Monte City']...
Ô£à Salvador Pleyto: Loaded 7 municipalities for 6th District: ['Pandi', 'Bocaue', 'Marilao']...
Ô£à Francis Gerald A. Abaya: Loaded 4 municipalities for 1st District: ['Kawit', 'Rosario', 'Noveleta']...
Ô£à Alex L. Advincula: Loaded 1 municipalities for 3rd District: ['Imus City']...
Ô£à Elpidio F. Barzaga Jr.: Loaded 1 municipalities for 4th District: ['Dasmari├▒as City']...
Ô£à Roy M. Loyola: Loaded 3 municipalities for 5th District: ['Silang', 'Carmona', 'General Mariano Alvarez']...
Ô£à Antonio A. Ferrer: Loaded 1 municipalities for 6th District: ['General Trias City']...
Ô£à Dania A. Loyola: Loaded 4 municipalities for 7th District: ['Tanza', 'Amadeo', 'Indang']...
Ô£à Jesus Crispin Remulla: Loaded 4 municipalities for 7th District: ['Tanza', 'Amadeo', 'Indang']...
Ô£à Wilfrido Mark Enverga: Loaded 5 municipalities for 1st District: ['Baler', 'Dingalan', 'San Luis']...
Ô£à Reynaldo Uy: Loaded 10 municipalities for 1st District: ['Almagro', 'Gandara', 'Calbayog']...
Ô£à Keith Micah Tan: Loaded 13 municipalities for 4th District: ['Real', 'Alabat', 'Infanta']...
Ô£à John Tracy Cagas: Loaded 6 municipalities for 2nd District: ['Sulop', 'Padada', 'Hagonoy']...
Ô£à Manuel Wowo Fortes Jr.: Loaded 8 municipalities for 2nd District: ['Bulan', 'Gubat', 'Juban']...
Ô£à Edcel Lagman: Loaded 3 municipalities for 1st District: ['Tiwi', 'Manito', 'Bacacay']...
Ô£à Fernando Cabredo: Loaded 7 municipalities for 3rd District: ['Ligao', 'Legazpi', 'Pio Duran']...
Ô£à Eileen Ermita-Buhain: Loaded 3 municipalities for 1st District: ['Lipa City', 'Tanauan City', 'Batangas City']...
Ô£à Ma. Theresa Collantes: Loaded 8 municipalities for 3rd District: ['Tuy', 'Lian', 'Taal']...
Ô£à Lianda Bolilia: Loaded 2 municipalities for 4th District: ['Bauan', 'Ibaan']...
Ô£à Mario Vittorio Mari├▒o: Loaded 9 municipalities for 5th District: ['Balete', 'Cuenca', 'Laurel']...
Ô£à Bernadette S. Barbers: Loaded 12 municipalities for 2nd District: ['Sison', 'Tubod', 'Bacuag']...
Ô£à Ching Bernos: Loaded 27 municipalities for Lone District: ['Luba', 'Tubo', 'Bucay']...
Ô£à Eleanor Begtang: Loaded 7 municipalities for Lone District: ['Luna', 'Flora', 'Conner']...
Ô£à Lord Allan Jay Velasco: Loaded 6 municipalities for Lone District: ['Boac', 'Gasan', 'Mogpog']...
Ô£à Odie Tarriela: Loaded 11 municipalities for Lone District: ['Looc', 'Rizal', 'Lubang']...
Ô£à Eleandro Jesus Madrona: Loaded 17 municipalities for Lone District: ['Looc', 'Banton', 'Ferrol']...
Ô£à Alan Ecleo: Loaded 7 municipalities for Lone District: ['Libjo', 'Loreto', 'Dinagat']...
Ô£à Dimszar Sali: Loaded 11 municipalities for Lone District: ['Mapun', 'Bongao', 'Sibutu']...
Ô£à Jun Gato: Loaded 6 municipalities for Lone District: ['Basco', 'Ivana', 'Uyugan']...
Ô£à Midy Cua: Loaded 6 municipalities for Lone District: ['Diffun', 'Aglipay', 'Maddela']...
Ô£à Rommel Rico Angara: Loaded 8 municipalities for Lone District: ['Baler', 'Dilasag', 'Dingalan']...
Ô£à Lucille Nava: Loaded 5 municipalities for Lone District: ['Jordan', 'Sibunag', 'Buenavista']...
Ô£à Zaldy Villa: Loaded 6 municipalities for Lone District: ['Lazi', 'Maria', 'Larena']...
Ô£à Gerardo J. Espina Jr.: Loaded 8 municipalities for Lone District: ['Naval', 'Culaba', 'Almeria']...
Ô£à Maria Fe Abunda: Loaded 23 municipalities for Lone District: ['Oras', 'Taft', 'Sulat']...
Ô£à Claude Bautista: Loaded 5 municipalities for Lone District: ['Malita', 'Sarangani', 'Santa Maria']...
Ô£à Jurdin Jesus Romualdo: Loaded 5 municipalities for Lone District: ['Sagay', 'Mahinog', 'Catarman']...
Ô£à Solomon Chungalao: Loaded 11 municipalities for Lone District: ['Lamut', 'Tinoc', 'Banaue']...
Ô£à Maximo Dalog Jr.: Loaded 10 municipalities for Lone District: ['Bauko', 'Besao', 'Barlig']...
Ô£à Luisa Lloren Cuaresma: Loaded 15 municipalities for Lone District: ['Diadi', 'Aritao', 'Kasibu']...
Ô£à Eric Yap: Loaded 13 municipalities for Lone District: ['Atok', 'Tuba', 'Bakun']...
Ô£à Sandro Marcos: Loaded 12 municipalities for 1st District: ['Adams', 'Laoag', 'Bangui']...
Ô£à Eugenio Angelo Barba: Loaded 11 municipalities for 2nd District: ['Badoc', 'Banna', 'Batac']...
Ô£à Geraldine Roman: Loaded 4 municipalities for 1st District: ['Orani', 'Samal', 'Abucay']...
Ô£à Albert Garcia: Loaded 4 municipalities for 2nd District: ['Limay', 'Orion', 'Pilar']...
Ô£à Maria Angela Garcia: Loaded 4 municipalities for 3rd District: ['Bagac', 'Morong', 'Mariveles']...
Ô£à Mika Suansing: Loaded 9 municipalities for 1st District: ['Licab', 'Aliaga', 'Cuyapo']...
Ô£à Joseph Gilbert Violago: Loaded 8 municipalities for 2nd District: ['Lupao', 'Rizal', 'Mu├▒oz']...
Ô£à Rosanna Vergara: Loaded 7 municipalities for 3rd District: ['Laur', 'Palayan', 'Bongabon']...
Ô£à Emeng Pascual: Loaded 8 municipalities for 4th District: ['Jaen', 'Gapan', 'Cabiao']...
Ô£à Jaime Cojuangco: Loaded 10 municipalities for 1st District: ['Anao', 'Pura', 'Ramos']...
Ô£à Christian Yap: Loaded 4 municipalities for 2nd District: ['Gerona', 'San Jose', 'Victoria']...
Ô£à Bong Rivera: Loaded 4 municipalities for 3rd District: ['Capas', 'Bamban', 'La Paz']...
Ô£à Jack Duavit: Loaded 4 municipalities for 1st District: ['Angono', 'Cainta', 'Taytay']...
Ô£à Dino Tanjuatco: Loaded 7 municipalities for 2nd District: ['Baras', 'Tanay', 'Morong']...
Ô£à Jose Arturo Garcia Jr.: Loaded 1 municipalities for 3rd District: ['San Mateo']...
Ô£à Fidel Nograles: Loaded 1 municipalities for 4th District: ['Rodriguez']...
Ô£à Josefina Tallado: Loaded 5 municipalities for 1st District: ['Labo', 'Paracale', 'Capalonga']...
Ô£à Rosemarie Panotes: Loaded 7 municipalities for 2nd District: ['Daet', 'Basud', 'Talisay']...
Ô£à Richard Kho: Loaded 6 municipalities for 1st District: ['Batuan', 'Monreal', 'Claveria']...
Ô£à Ara Kho: Loaded 7 municipalities for 2nd District: ['Mobo', 'Balud', 'Aroroy']...
Ô£à Wilton Kho: Loaded 8 municipalities for 3rd District: ['Uson', 'Placer', 'Cawayan']...
Ô£à Carlito Marquez: Loaded 8 municipalities for 1st District: ['Banga', 'Batan', 'Balete']...
Ô£à Teodorico Haresco Jr.: Loaded 9 municipalities for 2nd District: ['Lezo', 'Malay', 'Nabas']...
Ô£à Paul Daza: Loaded 14 municipalities for 1st District: ['Biri', 'Allen', 'Bobon']...
Ô£à Harris Ongchuan: Loaded 10 municipalities for 2nd District: ['Gamay', 'Laoang', 'Catubig']...
Ô£à Stephen James Tan: Loaded 10 municipalities for 1st District: ['Almagro', 'Gandara', 'Calbayog']...
Ô£à Reynolds Michael Tan: Loaded 16 municipalities for 2nd District: ['Basey', 'Daram', 'Calbiga']...
Ô£à Luz Mercado: Loaded 7 municipalities for 1st District: ['Bontoc', 'Maasin', 'Limasawa']...
Ô£à Christopherson Yap: Loaded 12 municipalities for 2nd District: ['Sogod', 'Liloan', 'Silago']...
Ô£à Jose Manuel Alba: Loaded 6 municipalities for 1st District: ['Libona', 'Baungon', 'Sumilao']...
Ô£à Jonathan Keith Flores: Loaded 5 municipalities for 2nd District: ['Lantapan', 'Impasugong', 'Malaybalay']...
Ô£à Laarni Roque: Loaded 3 municipalities for 4th District: ['Valencia', 'Kalilangan', 'Pangantucan']...
Ô£à Mohamad Khalid Quibranza-Dimaporo: Loaded 11 municipalities for 1st District: ['Baroy', 'Maigo', 'Tubod']...
Ô£à Aminah Dimaporo: Loaded 11 municipalities for 2nd District: ['Lala', 'Munai', 'Sapad']...
Ô£à Joselito Sacdalan: Loaded 6 municipalities for 1st District: ['Pikit', 'Alamada', 'Aleosan']...
Ô£à Rudy Caoagdan: Loaded 6 municipalities for 2nd District: ['Arakan', 'Magpet', 'Antipas']...
Ô£à Maria Alana Samantha Santos: Loaded 6 municipalities for 3rd District: ['Carmen', "M'lang", 'Kabacan']...
Ô£à Nelson Dayanghirang: Loaded 6 municipalities for 1st District: ['Manay', 'Boston', 'Caraga']...
Ô£à Cheeno Almario: Loaded 5 municipalities for 2nd District: ['Mati', 'Lupon', 'Banaybanay']...
Ô£à Rihan Sakaluran: Loaded 6 municipalities for 1st District: ['Isulan', 'Lutayan', 'Columbio']...
Ô£à Horacio Suansing Jr.: Loaded 6 municipalities for 2nd District: ['Lebak', 'Esperanza', 'Palimbang']...
Ô£à Alfel Bascug: Loaded 7 municipalities for 1st District: ['Bayugan', 'Sibagat', 'San Luis']...
Ô£à Eddiebong Plaza: Loaded 8 municipalities for 2nd District: ['La Paz', 'Loreto', 'Trento']...
Ô£à Samier Tan: Loaded 8 municipalities for 1st District: ['Jolo', 'Parang', 'Indanan']...
Ô£à Munir Arbison Jr.: Loaded 11 municipalities for 2nd District: ['Luuk', 'Omar', 'Pata']...
Ô£à Pantaleon Alvarez: Loaded 8 municipalities for 1st District: ['Carmen', 'Asuncion', 'Kapalong']...
Ô£à Sam Vargas-Alfonso: Loaded 12 municipalities for 2nd District: ['Piat', 'Lasam', 'Rizal']...
Ô£à Marissa Andaya: Loaded 5 municipalities for 1st District: ['Lupi', 'Ragay', 'Cabusao']...
Ô£à Luis Raymund Villafuerte Jr.: Loaded 7 municipalities for 2nd District: ['Gainza', 'Milaor', 'Pasacao']...
Ô£à Josal Fortuno: Loaded 7 municipalities for 5th District: ['Baao', 'Bato', 'Buhi']...
Ô£à Joseph Bernos: Loaded 27 municipalities for Lone District: ['Luba', 'Tubo', 'Bucay']...
Ô£à Joel Sacdalan: Loaded 6 municipalities for 1st District: ['Pikit', 'Alamada', 'Aleosan']...
Ô£à Jose Tejada: Loaded 6 municipalities for 3rd District: ['Carmen', "M'lang", 'Kabacan']...
Ô£à Corazon Malanyaon: Loaded 6 municipalities for 1st District: ['Manay', 'Boston', 'Caraga']...
Ô£à Joel Almario: Loaded 5 municipalities for 2nd District: ['Mati', 'Lupon', 'Banaybanay']...
Ô£à Elias Bulut Jr.: Loaded 7 municipalities for Lone District: ['Luna', 'Flora', 'Conner']...
Ô£à Michael Goricetta: Loaded 8 municipalities for 2nd District: ['Pavia', 'Jordan', 'Leganes']...
Ô£à Lorenz Defensor: Loaded 8 municipalities for 3rd District: ['Anilao', 'Banate', 'Dingle']...
Ô£à Braeden Joseph Biron: Loaded 21 municipalities for 4th District: ['Ajuy', 'Mina', 'Sara']...
Ô£à Pablo C. Ortega: Loaded 9 municipalities for 1st District: ['Luna', 'Bangar', 'Santol']...
Ô£à Sandra Y. Eriguel MD: Loaded 11 municipalities for 2nd District: ['Agoo', 'Caba', 'Pugo']...
Ô£à Josephine Y. Ramirez-Sato: Loaded 11 municipalities for Lone District: ['Looc', 'Rizal', 'Lubang']...
Ô£à Ruth Mariano-Hernandez: Loaded 3 municipalities for 2nd District: ['Bay', 'Los Ba├▒os', 'Cabuyao City']...
Ô£à Marisol Aragones-Sampelo: Loaded 7 municipalities for 3rd District: ['Liliw', 'Rizal', 'Calauan']...
Ô£à Ansaruddin Alonto Adiong: Loaded 18 municipalities for 1st District: ['Wao', 'Kapai', 'Masiu']...
Ô£à Farouk Macarambon: Loaded 22 municipalities for 2nd District: ['Butig', 'Bayang', 'Picong']...
Ô£à Emmanuel Madrona: Loaded 17 municipalities for Lone District: ['Looc', 'Banton', 'Ferrol']...
Ô£à Lucy Torres-Gomez: Loaded 5 municipalities for 4th District: ['Palo', 'Tabango', 'Santa Fe']...
Ô£à Diego Ty: Loaded 10 municipalities for 1st District: ['Aloran', 'Panaon', 'Calamba']...
Ô£à Juliette Uy: Loaded 14 municipalities for 2nd District: ['Opol', 'Initao', 'Jasaan']...
Ô£à Gerardo Valmayor: Loaded 5 municipalities for 1st District: ['Toboso', 'Calatrava', 'Escalante City']...
Ô£à Leo Rafael Cueva: Loaded 3 municipalities for 2nd District: ['Manapla', 'Cadiz City', 'Sagay City']...
Ô£à Jose Francisco Benitez: Loaded 5 municipalities for 3rd District: ['Murcia', 'Silay City', 'Talisay City']...
Ô£à Juliet Marie Ferrer: Loaded 6 municipalities for 4th District: ['Bago City', 'Pontevedra', 'Pulupandan']...
Ô£à Maria Lourdes Arroyo: Loaded 6 municipalities for 5th District: ['Isabela', 'Hinigaran', 'Binalbagan']...
Ô£à Genaro Alvarez: Loaded 6 municipalities for 6th District: ['Ilog', 'Candoni', 'Cauayan']...
Ô£à Antonio T. Albano: Loaded 9 municipalities for 1st District: ['Cabagan', 'Tumauini', 'Divilacan']...
Ô£à Ian Dy: Loaded 5 municipalities for 3rd District: ['Ramon', 'Alicia', 'Cabatuan']...
Ô£à Sheena Tan: Loaded 5 municipalities for 4th District: ['Jones', 'Cordon', 'Dinapigue']...
Ô£à Faustino Dy III: Loaded 8 municipalities for 5th District: ['Luna', 'Roxas', 'Aurora']...
Ô£à Jocelyn Limkaichong: Loaded 9 municipalities for 1st District: ['Bindoy', 'Ayungon', 'Tayasan']...
Ô£à Manuel Sagarbarria: Loaded 8 municipalities for 2nd District: ['Amlan', 'Mabinay', 'Sibulan']...
Ô£à Arnulfo Teves: Loaded 8 municipalities for 3rd District: ['Basay', 'Dauin', 'Bacong']...
Ô£à Paulino Salvador C. Leachon: Loaded 8 municipalities for 1st District: ['Baco', 'Pola', 'Naujan']...
Ô£à Alfonso V. Umali Jr.: Loaded 7 municipalities for 2nd District: ['Roxas', 'Bansud', 'Gloria']...
Ô£à Franz Josef George E. Alvarez: Loaded 15 municipalities for 1st District: ['Cuyo', 'Coron', 'Roxas']...
Ô£à Cyrille Abueg: Loaded 7 municipalities for 2nd District: ['Narra', 'Rizal', 'Quezon']...
Ô£à Gil Acosta: Loaded 2 municipalities for 3rd District: ['Aborlan', 'Puerto Princesa City']...
Ô£à Bai Rihan Sakaluran: Loaded 6 municipalities for 1st District: ['Isulan', 'Lutayan', 'Columbio']...
Ô£à Mikey Arroyo: Loaded 6 municipalities for 2nd District: ['Lubao', 'Porac', 'Guagua']...
Ô£à Aurelio Due├▒as Gonzales Jr.: Loaded 4 municipalities for 3rd District: ['Arayat', 'Mexico', 'Bacolor']...
Ô£à Rashidin Matba: Loaded 11 municipalities for Lone District: ['Mapun', 'Bongao', 'Sibutu']...
Ô£à Jose Antonio Sy-Alvarado: Loaded 6 municipalities for 1st District: ['Bulakan', 'Hagonoy', 'Pulilan']...
Ô£à Apolonio Pancho: Loaded 1 municipalities for 2nd District: ['Obando']...
Ô£à Henry Villarica: Loaded 8 municipalities for 4th District: ['Angat', 'Norzagaray', 'San Miguel']...
Ô£à Datu Roonie Sinsuat Sr.: Loaded 12 municipalities for 1st District: ['Upi', 'Barira', 'Buldon']...
Ô£à Esmael Mangudadatu: Loaded 25 municipalities for 2nd District: ['Buluan', 'Paglat', 'Pandag']...
Ô£à Ciriaco Gato Jr.: Loaded 6 municipalities for Lone District: ['Basco', 'Ivana', 'Uyugan']...
Ô£à Junie Cua: Loaded 6 municipalities for Lone District: ['Diffun', 'Aglipay', 'Maddela']...
Ô£à Ma. Lucille Nava: Loaded 5 municipalities for Lone District: ['Jordan', 'Sibunag', 'Buenavista']...
Ô£à Jec-Jec Villa II: Loaded 6 municipalities for Lone District: ['Lazi', 'Maria', 'Larena']...
Ô£à Elpidio F. Barzaga Jr.: Loaded 1 municipalities for 4th District: ['Dasmari├▒as City']...
Ô£à Dahlia Loyola: Loaded 3 municipalities for 5th District: ['Silang', 'Carmona', 'General Mariano Alvarez']...
Ô£à Luis A. Ferrer IV: Loaded 1 municipalities for 6th District: ['General Trias City']...
Ô£à Wilfredo Mark Enverga: Loaded 5 municipalities for 1st District: ['Baler', 'Dingalan', 'San Luis']...
Ô£à Aleta Suarez: Loaded 11 municipalities for 3rd District: ['Lopez', 'Gumaca', 'Pitogo']...
Ô£à Angelina Tan: Loaded 13 municipalities for 4th District: ['Real', 'Alabat', 'Infanta']...
Ô£à Ditas Ramos: Loaded 8 municipalities for 2nd District: ['Bulan', 'Gubat', 'Juban']...
Ô£à Shirlyn Ba├▒as-Nograles: Loaded 3 municipalities for 1st District: ['Tupi', 'Tampakan', 'Polomolok']...
Ô£à Jeffrey Khonghun: Loaded 4 municipalities for 1st District: ['Subic', 'Castillejos', 'Olongapo City']...
Ô£à Cherry Deloso-Montalla: Loaded 10 municipalities for 2nd District: ['Iba', 'Botolan', 'Palauig']...
Ô£à Lorna Bautista-Bandigan: Loaded 5 municipalities for Lone District: ['Malita', 'Sarangani', 'Santa Maria']...
Ô£à Xavier Jesus Romualdo: Loaded 5 municipalities for Lone District: ['Sagay', 'Mahinog', 'Catarman']...
Ô£à Sameir Tan: Loaded 8 municipalities for 1st District: ['Jolo', 'Parang', 'Indanan']...
Ô£à Abdulmunir Mundoc Arbison: Loaded 11 municipalities for 2nd District: ['Luuk', 'Omar', 'Pata']...
Ô£à Joey Salceda: Loaded 10 municipalities for 2nd District: ['Oas', 'Libon', 'Daraga']...
Ô£à Maria Theresa Collantes: Loaded 8 municipalities for 3rd District: ['Tuy', 'Lian', 'Taal']...
Ô£à Marvey Mari├▒o: Loaded 9 municipalities for 5th District: ['Balete', 'Cuenca', 'Laurel']...
Ô£à Vilma Santos-Recto: Loaded 8 municipalities for 6th District: ['Malvar', 'Taysan', 'Rosario']...
Ô£à Wilter Palma II: Loaded 9 municipalities for 1st District: ['Buug', 'Payao', 'Alicia']...
Ô£à Dulce Ann Hofer: Loaded 7 municipalities for 2nd District: ['Ipil', 'Naga', 'Siay']...
wsl : Traceback (most recent call last):
At line:1 char:1
+ wsl -d Ubuntu-22.04 python3 /home/joebert/open-data-visualization/scr ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (Traceback (most recent call last)::String) [], RemoteException
    + FullyQualifiedErrorId : NativeCommandError

  File "/home/joebert/open-data-visualization/scripts/generate_dynasty_projects_cache_duckdb.py", line 8425, in generat
e_cache
    print(f"   Amount column type: {df_all['amount'].dtype}")
  File "/home/joebert/.local/lib/python3.10/site-packages/pandas/core/frame.py", line 4107, in __getitem__
    indexer = self.columns.get_loc(key)
  File "/home/joebert/.local/lib/python3.10/site-packages/pandas/core/indexes/range.py", line 417, in get_loc
    raise KeyError(key)
KeyError: 'amount'
Traceback (most recent call last):
  File "/home/joebert/open-data-visualization/scripts/generate_dynasty_projects_cache_duckdb.py", line 8797, in generat
e_cache
    print(f"   Classified Amount column type: {df['amount'].dtype}")
  File "/home/joebert/.local/lib/python3.10/site-packages/pandas/core/frame.py", line 4107, in __getitem__
    indexer = self.columns.get_loc(key)
  File "/home/joebert/.local/lib/python3.10/site-packages/pandas/core/indexes/range.py", line 417, in get_loc
    raise KeyError(key)
KeyError: 'amount'
Ô£à Nestor Fongwan: Loaded 13 municipalities for Lone District: ['Atok', 'Tuba', 'Bakun']...
Ô£à Romeo Jalosjos Jr.: Loaded 8 municipalities for 1st District: ['Mutia', 'Rizal', 'Pi├▒an']...
Ô£à Glona Labadlabad: Loaded 7 municipalities for 2nd District: ['Siayan', 'Manukan', 'Katipunan']...
Ô£à Isagani Amatong: Loaded 12 municipalities for 3rd District: ['Godod', 'Liloy', 'Salug']...
Ô£à Ria Christina Fari├▒as: Loaded 12 municipalities for 1st District: ['Adams', 'Laoag', 'Bangui']...
Ô£à Kristine Singson: Loaded 23 municipalities for 2nd District: ['Suyo', 'Santa', 'Sigay']...
Ô£à Angelica Amante-Matba: Loaded 10 municipalities for 2nd District: ['Tubay', 'Carmen', 'Jabonga']...
Ô£à Joet Garcia: Loaded 4 municipalities for 2nd District: ['Limay', 'Orion', 'Pilar']...
Ô£à Estrelita Suansing: Loaded 9 municipalities for 1st District: ['Licab', 'Aliaga', 'Cuyapo']...
Ô£à Mikki Violago: Loaded 8 municipalities for 2nd District: ['Lupao', 'Rizal', 'Mu├▒oz']...
Ô£à Ria Vergara: Loaded 7 municipalities for 3rd District: ['Laur', 'Palayan', 'Bongabon']...
Ô£à Maricel Natividad: Loaded 8 municipalities for 4th District: ['Jaen', 'Gapan', 'Cabiao']...
Ô£à Carlos Charlie Cojuangco: Loaded 10 municipalities for 1st District: ['Anao', 'Pura', 'Ramos']...
Ô£à Victor Yap: Loaded 4 municipalities for 2nd District: ['Gerona', 'San Jose', 'Victoria']...
Ô£à Noel Villanueva: Loaded 4 municipalities for 3rd District: ['Capas', 'Bamban', 'La Paz']...
Ô£à Michael John Duavit: Loaded 4 municipalities for 1st District: ['Angono', 'Cainta', 'Taytay']...
Ô£à Marisol Panotes: Loaded 7 municipalities for 2nd District: ['Daet', 'Basud', 'Talisay']...
Ô£à Robert Barbers: Loaded 12 municipalities for 2nd District: ['Sison', 'Tubod', 'Bacuag']...
Ô£à Narciso Bravo Jr.: Loaded 6 municipalities for 1st District: ['Batuan', 'Monreal', 'Claveria']...
Ô£à Elisa Olga Kho: Loaded 7 municipalities for 2nd District: ['Mobo', 'Balud', 'Aroroy']...
Ô£à Edgar Mary Sarmiento: Loaded 10 municipalities for 1st District: ['Almagro', 'Gandara', 'Calbayog']...
Ô£à Sharee Ann Tan: Loaded 16 municipalities for 2nd District: ['Basey', 'Daram', 'Calbiga']...
Ô£à Malou Acosta: Loaded 6 municipalities for 1st District: ['Libona', 'Baungon', 'Sumilao']...
Ô£à John Flores: Loaded 5 municipalities for 2nd District: ['Lantapan', 'Impasugong', 'Malaybalay']...
Ô£à Manuel Zubiri: Loaded 8 municipalities for 3rd District: ['Kibawe', 'Quezon', 'Damulog']...
Ô£à Rogelio Roque: Loaded 3 municipalities for 4th District: ['Valencia', 'Kalilangan', 'Pangantucan']...
Ô£à Hector Sanchez: Loaded 11 municipalities for Lone District: ['Bato', 'Viga', 'Baras']...
Ô£à Jun Babasa: Loaded 15 municipalities for 2nd District: ['Bayog', 'Dinas', 'Guipos']...
Ô£à Abdullah Dimaporo: Loaded 11 municipalities for 2nd District: ['Lala', 'Munai', 'Sapad']...
Ô£à Loaded 399 congressmen

ƒöì DEBUG: Mikee Romero
   Provinces: ['1-PACMAN Party-list']
   District: Nationwide
   Contractors: ['St Matthew Gen Contractor Development Corp']
ƒöº Building lookup dictionaries...
ƒöº Applying district corrections...
  - Fixing Davao City barangays...
    Removed 0 barangays from Isidro Ungab
    Added 9 barangays to Paolo Duterte and cleaned up incorrect entries
  - Fixing Leyte 1st District municipalities...
    Removed 4 municipalities from Richard Gomez
    Removed 2 municipalities from Carl Nicolas Cari
    Removed 1 municipalities from Vicente S. Veloso III
    Removed 4 municipalities from Lucy Torres-Gomez
DEBUG: Finished building inverted index with 131 tokens.
Ô£à Received contractor index from helper (size: 131)
ƒöº Building name normalization map...
Ô£à Built name normalization map: 399 name variations mapped
ƒöº Building O(1) lookup dictionaries for optimized matching...
ƒöº Applying district corrections...
  - Fixing Davao City barangays...
    Removed 0 barangays from Isidro Ungab
    Added 9 barangays to Paolo Duterte and cleaned up incorrect entries
  - Fixing Leyte 1st District municipalities...
DEBUG: Finished building inverted index with 131 tokens.
Ô£à Built lookup dictionaries: 4233 district keys, 496 contractor keys
Ô£à Built inverted index: 131 tokens
ƒöº Building location dictionaries from data...
Ô£à Loaded comprehensive location database into location_dicts: 83 provinces, 193 cities
Ô£à Built location dictionaries:
   - 122 provinces
   - 204 cities
   - 1389 municipalities
   - 2526 barangays
   - 131 directional variants
   - 3838 location contexts
ƒîì Preparing shared data for worker processes...
ƒôè Using CLASSIFIED Parquet file: /home/joebert/open-data-visualization/data/parquet/integrated_projects_classified.parquet
ƒÆ¥ Loading ALL classified projects into memory...
ÔÜá´©Å  Error loading from Parquet: Invalid Input Error: File '/home/joebert/open-data-visualization/data/parquet/integrated_projects_classified.parquet' too small to be a Parquet file
Ô£à Loaded 0 classified projects into memory
ƒôè Processing 0 total projects (Unified Pipeline)
Ô£à Processed 0 projects
ƒÆ¥ Saving ALL projects (before deduplication) to /home/joebert/open-data-visualization/data/parquet/integrated_projects.parquet...
ÔÜá´©Å  Failed to save all projects to Parquet: 'amount'

ƒôè Final Processing Summary:
   Total projects processed: 0
   Ô£à Districts matched: 0
      - City districts: 0
      - Province districts: 0
   ƒôì Location matches:
      - Municipalities: 0
      - Barangays: 0
   ƒæÀ Contractors matched: 0
   ƒæñ Unique congressmen: 0
   ÔØî Unmatched: 0

ƒÆ¥ Saving deduplicated classified projects to /home/joebert/open-data-visualization/data/parquet/integrated_projects_classified.parquet...
   Preparing 0 unique projects for saving...
   Created DataFrame with 0 rows and 0 columns
ÔÜá´©Å  Failed to save classified projects to Parquet: 'amount'
Ôä╣´©Å  Combined cache file generation skipped (file too large and unused)

ƒôü Creating individual cache files for each congressman...
Ôä╣´©Å  Skipping cache directory clearing (use --force to clear existing caches)
ƒöº Building name normalization map...
   Ô£à Abdullah Dimaporo: 0 projects (empty cache created)
   Ô£à Abdulmunir Mundoc Arbison: 0 projects (empty cache created)
   Ô£à Abraham Tolentino: 0 projects (empty cache created)
   Ô£à Alan Dujali: 0 projects (empty cache created)
   Ô£à Alan Ecleo: 0 projects (empty cache created)
   Ô£à Albert Garcia: 0 projects (empty cache created)
   Ô£à Aleta Suarez: 0 projects (empty cache created)
   Ô£à Alex L. Advincula: 0 projects (empty cache created)
   Ô£à Alfel Bascug: 0 projects (empty cache created)
   Ô£à Alfonso V. Umali Jr.: 0 projects (empty cache created)
   Ô£à Alfredo Mara├▒on III: 0 projects (empty cache created)
   Ô£à Allen Jesse Mangaoang: 0 projects (empty cache created)
   Ô£à Amanda Christina Bagatsing: 0 projects (empty cache created)
   Ô£à Ambrosio Cruz Jr.: 0 projects (empty cache created)
   Ô£à Aminah Dimaporo: 0 projects (empty cache created)
   Ô£à Angelica Amante-Matba: 0 projects (empty cache created)
   Ô£à Angelina Tan: 0 projects (empty cache created)
   Ô£à Anna York Bondoc: 0 projects (empty cache created)
   Ô£à Ansaruddin Alonto Adiong: 0 projects (empty cache created)
   Ô£à Antonino Calixto: 0 projects (empty cache created)
   Ô£à Antonio A. Ferrer: 0 projects (empty cache created)
   Ô£à Antonio T. Albano: 0 projects (empty cache created)
   Ô£à Apolonio Pancho: 0 projects (empty cache created)
   Ô£à Ara Kho: 0 projects (empty cache created)
   Ô£à Arjo Atayde: 0 projects (empty cache created)
   Ô£à Arnie Teves: 0 projects (empty cache created)
   Ô£à Arnulf Bryan Fuentebella: 0 projects (empty cache created)
   Ô£à Arnulfo Teves: 0 projects (empty cache created)
   Ô£à Arthur C. Yap: 0 projects (empty cache created)
   Ô£à Arthur F. Celeste: 0 projects (empty cache created)
   Ô£à Augusto Sy-Alvarado: 0 projects (empty cache created)
   Ô£à Aurelio Due├▒as Gonzales Jr.: 0 projects (empty cache created)
   Ô£à Aurelio Gonzales Jr.: 0 projects (empty cache created)
   Ô£à Baby Aline Vargas-Alfonso: 0 projects (empty cache created)
   Ô£à Bai Rihan Sakaluran: 0 projects (empty cache created)
   Ô£à Bai Sandra Sema: 0 projects (empty cache created)
   Ô£à Benhur L. Salimbangon: 0 projects (empty cache created)
   Ô£à Benjamin Agarao Jr.: 0 projects (empty cache created)
   Ô£à Benny Abante: 0 projects (empty cache created)
   Ô£à Bernadette Herrera: 0 projects (empty cache created)
   Ô£à Bernadette S. Barbers: 0 projects (empty cache created)
   Ô£à Bienvenido Abante: 0 projects (empty cache created)
   Ô£à Bienvenido Abante Jr.: 0 projects (empty cache created)
   Ô£à Bojie Dy: 0 projects (empty cache created)
   Ô£à Bong Rivera: 0 projects (empty cache created)
   Ô£à Braeden Joseph Biron: 0 projects (empty cache created)
   Ô£à Bryan Revilla: 0 projects (empty cache created)
   Ô£à Camille Villar: 0 projects (empty cache created)
   Ô£à Carl Nicolas Cari: 0 projects (empty cache created)
   Ô£à Carlito Marquez: 0 projects (empty cache created)
   Ô£à Carlos Charlie Cojuangco: 0 projects (empty cache created)
   Ô£à Carlos Loria: 0 projects (empty cache created)
   Ô£à Carmelo Lazatin II: 0 projects (empty cache created)
   Ô£à Caroline Agyao: 0 projects (empty cache created)
   Ô£à Cesar Jimenez Jr.: 0 projects (empty cache created)
   Ô£à Cheeno Almario: 0 projects (empty cache created)
   Ô£à Cherry Deloso-Montalla: 0 projects (empty cache created)
   Ô£à Ching Bernos: 0 projects (empty cache created)
   Ô£à Christian Unabia: 0 projects (empty cache created)
   Ô£à Christian Yap: 0 projects (empty cache created)
   Ô£à Christopherson Yap: 0 projects (empty cache created)
   Ô£à Ciriaco Gato Jr.: 0 projects (empty cache created)
   Ô£à Claude Bautista: 0 projects (empty cache created)
   Ô£à Conrado Estrella III: 0 projects (empty cache created)
   Ô£à Corazon Malanyaon: 0 projects (empty cache created)
   Ô£à Cyrille Abueg: 0 projects (empty cache created)
   Ô£à Dahlia Loyola: 0 projects (empty cache created)
   Ô£à Dale Corvera: 0 projects (empty cache created)
   Ô£à Dale Gonzalo Malapitan: 0 projects (empty cache created)
   Ô£à Dan Fernandez: 0 projects (empty cache created)
   Ô£à Dania A. Loyola: 0 projects (empty cache created)
   Ô£à Danilo Domingo: 0 projects (empty cache created)
   Ô£à Dante S. Garcia: 0 projects (empty cache created)
   Ô£à Daphne Lagon: 0 projects (empty cache created)
   Ô£à Datu Roonie Sinsuat Sr.: 0 projects (empty cache created)
   Ô£à David Catarina Suarez: 0 projects (empty cache created)
   Ô£à David Suarez: 0 projects (empty cache created)
   Ô£à De Carlo Uy: 0 projects (empty cache created)
   Ô£à Dean Asistio: 0 projects (empty cache created)
   Ô£à Deogracias Victor Savellano: 0 projects (empty cache created)
   Ô£à Dibu Tuan: 0 projects (empty cache created)
   Ô£à Diego Ty: 0 projects (empty cache created)
   Ô£à Dimszar Sali: 0 projects (empty cache created)
   Ô£à Dino Tanjuatco: 0 projects (empty cache created)
   Ô£à Ditas Ramos: 0 projects (empty cache created)
   Ô£à Divina Grace Yu: 0 projects (empty cache created)
   Ô£à Doris E. Maniquiz: 0 projects (empty cache created)
   Ô£à Duke Frasco: 0 projects (empty cache created)
   Ô£à Dulce Ann Hofer: 0 projects (empty cache created)
   Ô£à Ed Christopher S. Go: 0 projects (empty cache created)
   Ô£à Edcel Lagman: 0 projects (empty cache created)
   Ô£à Eddie Villanueva: 0 projects (empty cache created)
   Ô£à Eddiebong Plaza: 0 projects (empty cache created)
   Ô£à Edgar Chatto: 0 projects (empty cache created)
   Ô£à Edgar Erice: 0 projects (empty cache created)
   Ô£à Edgar Mary Sarmiento: 0 projects (empty cache created)
   Ô£à Edsel Galeos: 0 projects (empty cache created)
   Ô£à Eduardo R. Gullas: 0 projects (empty cache created)
   Ô£à Eduardo Rama Jr.: 0 projects (empty cache created)
   Ô£à Edward M. Maceda: 0 projects (empty cache created)
   Ô£à Edwin Olivarez: 0 projects (empty cache created)
   Ô£à Eileen Ermita-Buhain: 0 projects (empty cache created)
   Ô£à Eleandro Jesus Madrona: 0 projects (empty cache created)
   Ô£à Eleanor Begtang: 0 projects (empty cache created)
   Ô£à Elias Bulut Jr.: 0 projects (empty cache created)
   Ô£à Elisa Olga Kho: 0 projects (empty cache created)
   Ô£à Elizaldy Salcedo Co: 0 projects (empty cache created)
   Ô£à Elpidio F. Barzaga Jr.: 0 projects (empty cache created)
   Ô£à Emeng Pascual: 0 projects (empty cache created)
   Ô£à Emilio Bernardino Yulo III: 0 projects (empty cache created)
   Ô£à Emmanuel Billones: 0 projects (empty cache created)
   Ô£à Emmanuel Iway: 0 projects (empty cache created)
   Ô£à Emmanuel Madrona: 0 projects (empty cache created)
   Ô£à Emmarie Ouano-Dizon: 0 projects (empty cache created)
   Ô£à Eric Martinez: 0 projects (empty cache created)
   Ô£à Eric Olivarez: 0 projects (empty cache created)
   Ô£à Eric Singson: 0 projects (empty cache created)
   Ô£à Eric Yap: 0 projects (empty cache created)
   Ô£à Erico Aristotle Aumentado: 0 projects (empty cache created)
   Ô£à Ernesto M. Dionisio Jr.: 0 projects (empty cache created)
   Ô£à Esmael Mangudadatu: 0 projects (empty cache created)
   Ô£à Estrelita Suansing: 0 projects (empty cache created)
   Ô£à Eugenio Angelo Barba: 0 projects (empty cache created)
   Ô£à Eulogio Rodriguez: 0 projects (empty cache created)
   Ô£à Evelina Escudero: 0 projects (empty cache created)
   Ô£à Farouk Macarambon: 0 projects (empty cache created)
   Ô£à Faustino A. Dy V: 0 projects (empty cache created)
   Ô£à Faustino Dy III: 0 projects (empty cache created)
   Ô£à Ferdinand Hernandez: 0 projects (empty cache created)
   Ô£à Ferdinand Martin Gomez Romualdez: 0 projects (empty cache created)
   Ô£à Ferjenel Biron: 0 projects (empty cache created)
   Ô£à Fernando Cabredo: 0 projects (empty cache created)
   Ô£à Fidel Nograles: 0 projects (empty cache created)
   Ô£à Francis Gerald A. Abaya: 0 projects (empty cache created)
   Ô£à Francisco Jose Matugas II: 0 projects (empty cache created)
   Ô£à Franz Josef George E. Alvarez: 0 projects (empty cache created)
   Ô£à Franz Pumaren: 0 projects (empty cache created)
   Ô£à Fredenil Castro: 0 projects (empty cache created)
   Ô£à Frederick Abueg: 0 projects (empty cache created)
   Ô£à Gabriel Bordado Jr.: 0 projects (empty cache created)
   Ô£à Genaro Alvarez: 0 projects (empty cache created)
   Ô£à Gerald Anthony V. Gullas Jr.: 0 projects (empty cache created)
   Ô£à Geraldine Joan Reyes Rosales: 0 projects (empty cache created)
   Ô£à Geraldine Roman: 0 projects (empty cache created)
   Ô£à Gerardo J. Espina Jr.: 0 projects (empty cache created)
   Ô£à Gerardo Valmayor: 0 projects (empty cache created)
   Ô£à Gil Acosta: 0 projects (empty cache created)
   Ô£à Gil Acosta Jr.: 0 projects (empty cache created)
   Ô£à Gina de Venecia: 0 projects (empty cache created)
   Ô£à Glona Labadlabad: 0 projects (empty cache created)
   Ô£à Gloria Irene Labadlabad: 0 projects (empty cache created)
   Ô£à Gloria Macapagal Arroyo: 0 projects (empty cache created)
   Ô£à Gustavo Tambunting: 0 projects (empty cache created)
   Ô£à Gwendolyn Garcia: 0 projects (empty cache created)
   Ô£à Harris Ongchuan: 0 projects (empty cache created)
   Ô£à Hector Sanchez: 0 projects (empty cache created)
   Ô£à Henry Oaminal: 0 projects (empty cache created)
   Ô£à Henry Villarica: 0 projects (empty cache created)
   Ô£à Horacio Suansing Jr.: 0 projects (empty cache created)
   Ô£à Ian Amatong: 0 projects (empty cache created)
   Ô£à Ian Dy: 0 projects (empty cache created)
   Ô£à Isagani Amatong: 0 projects (empty cache created)
   Ô£à Isidro Lumayag: 0 projects (empty cache created)
   Ô£à Isidro Ungab: 0 projects (empty cache created)
   Ô£à Jack Duavit: 0 projects (empty cache created)
   Ô£à Jaime Cojuangco: 0 projects (empty cache created)
   Ô£à Jaime Fresnedi: 0 projects (empty cache created)
   Ô£à Janette Garin: 0 projects (empty cache created)
   Ô£à Janice Zamora Salimbangon: 0 projects (empty cache created)
   Ô£à Jason P. Almonte: 0 projects (empty cache created)
   Ô£à Javier Miguel L. Benitez: 0 projects (empty cache created)
   Ô£à Jay Khonghun: 0 projects (empty cache created)
   Ô£à Jec-Jec Villa II: 0 projects (empty cache created)
   Ô£à Jeffrey Khonghun: 0 projects (empty cache created)
   Ô£à Jeffrey P. Ferrer: 0 projects (empty cache created)
   Ô£à Jernie Jett Nisay: 0 projects (empty cache created)
   Ô£à Jesus Crispin Remulla: 0 projects (empty cache created)
   Ô£à Jeyzel Victoria Yu: 0 projects (empty cache created)
   Ô£à Jocelyn Limkaichong: 0 projects (empty cache created)
   Ô£à Joel Almario: 0 projects (empty cache created)
   Ô£à Joel R. Chua: 0 projects (empty cache created)
   Ô£à Joel Sacdalan: 0 projects (empty cache created)
   Ô£à Joet Garcia: 0 projects (empty cache created)
   Ô£à Joey Salceda: 0 projects (empty cache created)
   Ô£à John Flores: 0 projects (empty cache created)
   Ô£à John Marvin Nieto: 0 projects (empty cache created)
   Ô£à John Rey Tiangco: 0 projects (empty cache created)
   Ô£à John Tracy Cagas: 0 projects (empty cache created)
   Ô£à Johnny Pimentel: 0 projects (empty cache created)
   Ô£à Jojo Lara: 0 projects (empty cache created)
   Ô£à Jonas Cortes: 0 projects (empty cache created)
   Ô£à Jonathan Keith Flores: 0 projects (empty cache created)
   Ô£à Josal Fortuno: 0 projects (empty cache created)
   Ô£à Jose Alvarez: 0 projects (empty cache created)
   Ô£à Jose Antonio Sy-Alvarado: 0 projects (empty cache created)
   Ô£à Jose Arturo Garcia Jr.: 0 projects (empty cache created)
   Ô£à Jose Francisco Benitez: 0 projects (empty cache created)
   Ô£à Jose Manuel Alba: 0 projects (empty cache created)
   Ô£à Jose Maria Zubiri Jr.: 0 projects (empty cache created)
   Ô£à Jose Ong Jr.: 0 projects (empty cache created)
   Ô£à Jose Tejada: 0 projects (empty cache created)
   Ô£à Josefina Tallado: 0 projects (empty cache created)
   Ô£à Joselito Sacdalan: 0 projects (empty cache created)
   Ô£à Joseph Bernos: 0 projects (empty cache created)
   Ô£à Joseph Gilbert Violago: 0 projects (empty cache created)
   Ô£à Joseph Lara: 0 projects (empty cache created)
   Ô£à Joseph S. Tan: 0 projects (empty cache created)
   Ô£à Josephine Lacson-Noel: 0 projects (empty cache created)
   Ô£à Josephine Y. Ramirez-Sato: 0 projects (empty cache created)
   Ô£à Joy Tambuting: 0 projects (empty cache created)
   Ô£à Juan Pablo Bondoc: 0 projects (empty cache created)
   Ô£à Julienne Baronda: 0 projects (empty cache created)
   Ô£à Juliet Marie Ferrer: 0 projects (empty cache created)
   Ô£à Juliette Uy: 0 projects (empty cache created)
   Ô£à Jun Babasa: 0 projects (empty cache created)
   Ô£à Jun Gato: 0 projects (empty cache created)
   Ô£à Junie Cua: 0 projects (empty cache created)
   Ô£à Jurdin Jesus Romualdo: 0 projects (empty cache created)
   Ô£à Keith Micah Tan: 0 projects (empty cache created)
   Ô£à Khymer Adan Olaso: 0 projects (empty cache created)
   Ô£à Kid Pe├▒a: 0 projects (empty cache created)
   Ô£à Kristine Alexie Besas-Tutor: 0 projects (empty cache created)
   Ô£à Kristine Singson: 0 projects (empty cache created)
   Ô£à Kristine Singson-Meehan: 0 projects (empty cache created)
   Ô£à Laarni Roque: 0 projects (empty cache created)
   Ô£à Lani Mercado-Revilla: 0 projects (empty cache created)
   Ô£à Lawrence Lemuel Fortun: 0 projects (empty cache created)
   Ô£à Len Alonte: 0 projects (empty cache created)
   Ô£à Leo Rafael Cueva: 0 projects (empty cache created)
   Ô£à Leonel Domo-ong Ceniza: 0 projects (empty cache created)
   Ô£à Lianda Bolilia: 0 projects (empty cache created)
   Ô£à Linabelle Villarica: 0 projects (empty cache created)
   Ô£à Lito Atienza: 0 projects (empty cache created)
   Ô£à Lolita Javier: 0 projects (empty cache created)
   Ô£à Lord Allan Jay Velasco: 0 projects (empty cache created)
   Ô£à Loren Legarda: 0 projects (empty cache created)
   Ô£à Lorenz Defensor: 0 projects (empty cache created)
   Ô£à Loreto S. Amante: 0 projects (empty cache created)
   Ô£à Lorna Bautista-Bandigan: 0 projects (empty cache created)
   Ô£à Lorna Silverio: 0 projects (empty cache created)
   Ô£à Lucille Nava: 0 projects (empty cache created)
   Ô£à Lucy Torres-Gomez: 0 projects (empty cache created)
   Ô£à Luis A. Ferrer IV: 0 projects (empty cache created)
   Ô£à Luis Campos: 0 projects (empty cache created)
   Ô£à Luis Raymund Villafuerte: 0 projects (empty cache created)
   Ô£à Luis Raymund Villafuerte Jr.: 0 projects (empty cache created)
   Ô£à Luisa Lloren Cuaresma: 0 projects (empty cache created)
   Ô£à Luz Mercado: 0 projects (empty cache created)
   Ô£à Ma. Isabel L. Sagarbarria: 0 projects (empty cache created)
   Ô£à Ma. Lourdes P. Aggabao: 0 projects (empty cache created)
   Ô£à Ma. Lucille Nava: 0 projects (empty cache created)
   Ô£à Ma. Theresa Collantes: 0 projects (empty cache created)
   Ô£à Maan Teodoro: 0 projects (empty cache created)
   Ô£à Malou Acosta: 0 projects (empty cache created)
   Ô£à Manny Lopez: 0 projects (empty cache created)
   Ô£à Manuel Jose Mendoza Dalipe: 0 projects (empty cache created)
   Ô£à Manuel Sagarbarria: 0 projects (empty cache created)
   Ô£à Manuel Wowo Fortes Jr.: 0 projects (empty cache created)
   Ô£à Manuel Zubiri: 0 projects (empty cache created)
   Ô£à Marcy Teodoro: 0 projects (empty cache created)
   Ô£à Maria Alana Samantha Santos: 0 projects (empty cache created)
   Ô£à Maria Angela Garcia: 0 projects (empty cache created)
   Ô£à Maria Carmen Zamora: 0 projects (empty cache created)
   Ô£à Maria Fe Abunda: 0 projects (empty cache created)
   Ô£à Maria Lourdes Arroyo: 0 projects (empty cache created)
   Ô£à Maria Theresa Collantes: 0 projects (empty cache created)
   Ô£à Maria Victoria Aumentado: 0 projects (empty cache created)
   Ô£à Maricel Natividad: 0 projects (empty cache created)
   Ô£à Marie Bernadette Escudero: 0 projects (empty cache created)
   Ô£à Mario Vittorio Mari├▒o: 0 projects (empty cache created)
   Ô£à Marisol Aragones-Sampelo: 0 projects (empty cache created)
   Ô£à Marisol Panotes: 0 projects (empty cache created)
   Ô£à Marissa Andaya: 0 projects (empty cache created)
   Ô£à Mark Cojuangco: 0 projects (empty cache created)
   Ô£à Marlo Bancoro: 0 projects (empty cache created)
   Ô£à Marlyn Hofer-Hasim: 0 projects (empty cache created)
   Ô£à Marlyn Primicias-Agabas: 0 projects (empty cache created)
   Ô£à Marvey Mari├▒o: 0 projects (empty cache created)
   Ô£à Marvin Rillo: 0 projects (empty cache created)
   Ô£à Maximo Dalog Jr.: 0 projects (empty cache created)
   Ô£à Mercedes Alvarez: 0 projects (empty cache created)
   Ô£à Michael Goricetta: 0 projects (empty cache created)
   Ô£à Michael John Duavit: 0 projects (empty cache created)
   Ô£à Midy Cua: 0 projects (empty cache created)
   Ô£à Miguel Luis Villafuerte: 0 projects (empty cache created)
   Ô£à Mika Suansing: 0 projects (empty cache created)
   Ô£à Mikee Romero: 0 projects (empty cache created)
   Ô£à Mikey Arroyo: 0 projects (empty cache created)
   Ô£à Mikki Violago: 0 projects (empty cache created)
   Ô£à Miro Quimbo: 0 projects (empty cache created)
   Ô£à Mitzi Cajayon: 0 projects (empty cache created)
   Ô£à Mohamad Khalid Quibranza-Dimaporo: 0 projects (empty cache created)
   Ô£à Mohamad Paglas: 0 projects (empty cache created)
   Ô£à Mujiv Hataman: 0 projects (empty cache created)
   Ô£à Munir Arbison Jr.: 0 projects (empty cache created)
   Ô£à Mylene Garcia-Albano: 0 projects (empty cache created)
   Ô£à Narciso Bravo Jr.: 0 projects (empty cache created)
   Ô£à Nelson Dayanghirang: 0 projects (empty cache created)
   Ô£à Neptali Gonzales II: 0 projects (empty cache created)
   Ô£à Nestor Fongwan: 0 projects (empty cache created)
   Ô£à Noel Villanueva: 0 projects (empty cache created)
   Ô£à Odie Tarriela: 0 projects (empty cache created)
   Ô£à Oscar Malapitan: 0 projects (empty cache created)
   Ô£à Pablo C. Ortega: 0 projects (empty cache created)
   Ô£à Pablo John Garcia: 0 projects (empty cache created)
   Ô£à Pantaleon Alvarez: 0 projects (empty cache created)
   Ô£à Paolo Duterte: 0 projects (empty cache created)
   Ô£à Paolo Ortega: 0 projects (empty cache created)
   Ô£à Patrick Michael Vargas: 0 projects (empty cache created)
   Ô£à Paul Daza: 0 projects (empty cache created)
   Ô£à Paulino Salvador C. Leachon: 0 projects (empty cache created)
   Ô£à Paulino Salvador Leachon: 0 projects (empty cache created)
   Ô£à Peter John Calderon: 0 projects (empty cache created)
   Ô£à Pia Cayetano: 0 projects (empty cache created)
   Ô£à Prospero Pichay Jr.: 0 projects (empty cache created)
ƒÜÇ Generating congressman-ranking.json cache...
ƒôü Found 407 congressman caches

ƒôê Top 10 Congressmen by Project Count (preview):
   1. Dale Gonzalo Malapitan: 0 projects, Ôé▒0.00
   2. Ramon Nolasco Jr.: 0 projects, Ôé▒0.00
   3. Jun Babasa: 0 projects, Ôé▒0.00
   4. Jose Arturo Garcia Jr.: 0 projects, Ôé▒0.00
   5. Edgar Chatto: 0 projects, Ôé▒0.00
   6. Emilio Bernardino Yulo III: 0 projects, Ôé▒0.00
   7. Stephen James Tan: 0 projects, Ôé▒0.00
   8. Aleta Suarez: 0 projects, Ôé▒0.00
   9. Vicente S. Veloso III: 0 projects, Ôé▒0.00
   10. Marvey Mari├▒o: 0 projects, Ôé▒0.00

ƒÆ░ Top 10 Congressmen by Total Cost (preview):
   1. Dale Gonzalo Malapitan: Ôé▒0.00 (0 projects)
   2. Ramon Nolasco Jr.: Ôé▒0.00 (0 projects)
   3. Jun Babasa: Ôé▒0.00 (0 projects)
   4. Jose Arturo Garcia Jr.: Ôé▒0.00 (0 projects)
   5. Edgar Chatto: Ôé▒0.00 (0 projects)
   6. Emilio Bernardino Yulo III: Ôé▒0.00 (0 projects)
   7. Stephen James Tan: Ôé▒0.00 (0 projects)
   8. Aleta Suarez: Ôé▒0.00 (0 projects)
   9. Vicente S. Veloso III: Ôé▒0.00 (0 projects)
   10. Marvey Mari├▒o: Ôé▒0.00 (0 projects)

Ô£à Saved to /home/joebert/open-data-visualization/static/data/congressman-ranking.json
   Total projects (summary): 0
   District matches: 0 (Ôé▒0.00)
   Contractor matches: 0 (Ôé▒0.00)
   ƒîè Flood-related projects: 0 (Ôé▒0.00)
   Total congressmen covered: 407
   Ô£à Rachel Del Mar: 0 projects (empty cache created)
   Ô£à Ralph Recto: 0 projects (empty cache created)
   Ô£à Ralph Wendel Tulfo: 0 projects (empty cache created)
   Ô£à Ramil Hernandez: 0 projects (empty cache created)
   Ô£à Ramon Durano VI: 0 projects (empty cache created)
   Ô£à Ramon Guico Jr.: 0 projects (empty cache created)
   Ô£à Ramon Nolasco Jr.: 0 projects (empty cache created)
   Ô£à Ramon Nolasco Sr.: 0 projects (empty cache created)
   Ô£à Ramon Rodrigo Gutierrez: 0 projects (empty cache created)
   Ô£à Randolph Ting: 0 projects (empty cache created)
   Ô£à Raneo Abu: 0 projects (empty cache created)
   Ô£à Rashidin Matba: 0 projects (empty cache created)
   Ô£à Raul Tupas: 0 projects (empty cache created)
   Ô£à Raul V. Del Mar: 0 projects (empty cache created)
   Ô£à Raymond Mendoza: 0 projects (empty cache created)
   Ô£à Rene Relampagos: 0 projects (empty cache created)
   Ô£à Reynaldo Uy: 0 projects (empty cache created)
   Ô£à Reynolds Michael Tan: 0 projects (empty cache created)
   Ô£à Rhea Mae Daluz Gullas: 0 projects (empty cache created)
   Ô£à Ria Christina Fari├▒as: 0 projects (empty cache created)
   Ô£à Ria Vergara: 0 projects (empty cache created)
   Ô£à Ricardo S. Cruz Jr.: 0 projects (empty cache created)
   Ô£à Richard Gomez: 0 projects (empty cache created)
   Ô£à Richard Kho: 0 projects (empty cache created)
   Ô£à Rihan Sakaluran: 0 projects (empty cache created)
   Ô£à Robert Barbers: 0 projects (empty cache created)
   Ô£à Roberto Puno: 0 projects (empty cache created)
   Ô£à Roberto Uy Jr.: 0 projects (empty cache created)
   Ô£à Rodante Marcoleta: 0 projects (empty cache created)
   Ô£à Rodrigo Abellanosa: 0 projects (empty cache created)
   Ô£à Rogelio Pacquiao: 0 projects (empty cache created)
   Ô£à Rogelio Roque: 0 projects (empty cache created)
   Ô£à Rolan Valeriano: 0 projects (empty cache created)
   Ô£à Rolando Andaya Jr.: 0 projects (empty cache created)
   Ô£à Rolando M. Valeriano: 0 projects (empty cache created)
   Ô£à Roman Romulo: 0 projects (empty cache created)
   Ô£à Romeo Jalosjos Jr.: 0 projects (empty cache created)
   Ô£à Romeo Momo: 0 projects (empty cache created)
   Ô£à Rommel Rico Angara: 0 projects (empty cache created)
   Ô£à Romulo Pe├▒a Jr.: 0 projects (empty cache created)
   Ô£à Ronald Singson: 0 projects (empty cache created)
   Ô£à Ronaldo Puno: 0 projects (empty cache created)
   Ô£à Ronaldo Zamora: 0 projects (empty cache created)
   Ô£à Rosanna Vergara: 0 projects (empty cache created)
   Ô£à Rose Marie Arenas: 0 projects (empty cache created)
   Ô£à Rose Salvame: 0 projects (empty cache created)
   Ô£à Rosemarie Panotes: 0 projects (empty cache created)
   Ô£à Roy M. Loyola: 0 projects (empty cache created)
   Ô£à Rozzano Rufino Biazon: 0 projects (empty cache created)
   Ô£à Rudy Caoagdan: 0 projects (empty cache created)
   Ô£à Rufus Rodriguez: 0 projects (empty cache created)
   Ô£à Ruth Mariano-Hernandez: 0 projects (empty cache created)
   Ô£à Salvador Pleyto: 0 projects (empty cache created)
   Ô£à Salvio Fortuno: 0 projects (empty cache created)
   Ô£à Sam Vargas-Alfonso: 0 projects (empty cache created)
   Ô£à Samantha Louise Vargas-Alfonso: 0 projects (empty cache created)
   Ô£à Sameir Tan: 0 projects (empty cache created)
   Ô£à Samier Tan: 0 projects (empty cache created)
   Ô£à Sandra Y. Eriguel MD: 0 projects (empty cache created)
   Ô£à Sandro Marcos: 0 projects (empty cache created)
   Ô£à Sharee Ann Tan: 0 projects (empty cache created)
   Ô£à Sharon Garin: 0 projects (empty cache created)
   Ô£à Sheena Tan: 0 projects (empty cache created)
   Ô£à Shirlyn Ba├▒as-Nograles: 0 projects (empty cache created)
   Ô£à Solomon Chungalao: 0 projects (empty cache created)
   Ô£à Stella Quimbo: 0 projects (empty cache created)
   Ô£à Stephen James Tan: 0 projects (empty cache created)
   Ô£à Strike Revilla: 0 projects (empty cache created)
   Ô£à Teodorico Haresco Jr.: 0 projects (empty cache created)
   Ô£à Tirso Edwin Loleng Gardiola: 0 projects (empty cache created)
   Ô£à Toby Tiangco: 0 projects (empty cache created)
   Ô£à Tonypet Albano: 0 projects (empty cache created)
   Ô£à Vanessa Aumentado: 0 projects (empty cache created)
   Ô£à Vicente S. Veloso III: 0 projects (empty cache created)
   Ô£à Victor Yap: 0 projects (empty cache created)
   Ô£à Vilma Santos: 0 projects (empty cache created)
   Ô£à Vilma Santos-Recto: 0 projects (empty cache created)
   Ô£à Vincent Garcia: 0 projects (empty cache created)
   Ô£à Wes Gatchalian: 0 projects (empty cache created)
   Ô£à Wilfredo Mark Enverga: 0 projects (empty cache created)
   Ô£à Wilfredo S. Caminero: 0 projects (empty cache created)
   Ô£à Wilfrido Mark Enverga: 0 projects (empty cache created)
   Ô£à William Irwin C. Tieng: 0 projects (empty cache created)
   Ô£à Wilter Palma II: 0 projects (empty cache created)
   Ô£à Wilton Kho: 0 projects (empty cache created)
   Ô£à Xavier Jesus Romualdo: 0 projects (empty cache created)
   Ô£à Yasser Balindong: 0 projects (empty cache created)
   Ô£à Yevgeny Emano: 0 projects (empty cache created)
   Ô£à Ysabel Zamora: 0 projects (empty cache created)
   Ô£à Zajid Mangudadatu: 0 projects (empty cache created)
   Ô£à Zaldy Villa: 0 projects (empty cache created)
   Ô£à Ziaur-Rahman A. Adiong: 0 projects (empty cache created)

Ô£à Individual cache files created for 407 congressmen

ƒôè Final Summary (Total projects):
   Total projects: 0
   DIME: 0
   PhilGEPS: 0
   SSP: 0
   Microsite: 0
   Transparency: 0
   District projects: 0
   Contractor projects: 0
   ƒîè Flood-related projects: 0 (Ôé▒0.00)
   Total congressmen covered: 0
   ÔÅ¡´©Å  Skipped (already classified): 0
Ô£à Refreshed congressman-ranking.json cache
Ô£à Cache generation complete