Data from Plano's Environmental Health Department. This data set contains information from three programs / departmental functions: Vector Control (VC), Pool Inspections (P), and Food Service Inspections (F).
This dataset has the following 24 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| Date | date | calendar_date | 2021-08-31T00:00:00.000 2021-04-30T00:00:00.000 2017-06-30T00:00:00.000 2018-08-31T00:00:00.000 2016-11-30T00:00:00.000 view top 100 |
| (VC) Liquid Pesticide used | vc_chem_used | number | 0 3.41 5.75 120 4.59 view top 100 |
| (VC) Larvicide (tabs) | vc_larvicide_tabs | number | 0 29 7 28 22 view top 100 |
| (VC) Larvicide granular used | larvicide_granular_used | number | 0 1 2 4 92 view top 100 |
| (VC) Mosquito traps set | mosquito_traps_set | number | 0 99 61 76 73 view top 100 |
| (VC) Number of mosquitoes trapped | number_of_mosquitoes_trapped | number | 0 143 681 304 4600 view top 100 |
| (VC) Mosq. Compl. | vc_mosq_compl | number | 0 2 4 3 1 view top 100 |
| (VC) Rodent Compl. | vc_rodent_compl | number | 0 2 1 3 4 view top 100 |
| (P) Pools under Insp. | p_pools_under_insp | number | 418 425 410 420 419 view top 100 |
| (P) Insps. | p_insps | number | 0 2 1 10 20 view top 100 |
| (P) Follow-up Insps. | p_follow_up_insps | number | 0 1 3 24 2 view top 100 |
| (P) VIO | p_vio | number | 0 2 1 3 5 view top 100 |
| (P) CORRs on Site | p_corrs_on_site | number | 0 2 1 4 6 view top 100 |
| (P) Closures | p_closures | number | 0 2 3 4 7 view top 100 |
| (P) CO Insps. | p_co_insps | number | 1 2 3 4 0 view top 100 |
| (F) Total Ann. Permits | f_total_ann_permits | number | 1703 1480 1737 1726 1732 view top 100 |
| (F) Routine Insps. | f_routine_insps | number | 302 294 315 416 279 view top 100 |
| (F) Follow-up Insps. | f_follow_up_insps | number | 15 29 19 22 17 view top 100 |
| (F) Violations | f_vio | number | 857 840 767 841 661 view top 100 |
| (F) On-site Corrections | f_corr | number | 392 195 268 161 245 view top 100 |
| (F) Closures - Enf. | f_closures_enf | number | 2 3 4 1 5 view top 100 |
| (F) Plan Reviews | f_plan_reviews_kc_mj_dh | number | 2 17 9 20 3 view top 100 |
| (F) CO Inspections | f_co_s_kc_mj_dh | number | 25 28 23 17 15 view top 100 |
| (F) Compl. | f_compl | number | 28 18 31 19 34 view top 100 |