| id | 
                    NY1830045 | 
                  
                  
                    
                    
                      | boundary_type | 
                      
                        
    
      None  
     | 
                      
                    
                    
                  
                    
                    
                      | centroid_lat | 
                      
                        
    
      None  
     | 
                      
                    
                    
                  
                    
                    
                      | centroid_lon | 
                      
                        
    
      None  
     | 
                      
                    
                    
                  
                    
                    
                      | centroid_quality | 
                      
                        
    
      None  
     | 
                      
                    
                    
                  
                    
                    
                      | city_served | 
                      
                        
    
      None  
     | 
                      
                    
                    
                  
                    
                    
                      | contact_email | 
                      
                        
    
      jess@gosimplelab.com
     | 
                      
                    
                    
                  
                    
                    
                      | contribution_date | 
                      
                        
    
      2022-07-05
     | 
                      
                    
                    
                  
                    
                    
                      | county_served | 
                      
                        
    
      GENESEE
     | 
                      
                    
                    
                  
                    
                    
                      | data_source | 
                      
                        
    
      SimpleLab
     | 
                      
                    
                    
                  
                    
                    
                      | fid | 
                      
                        
    
      38804
     | 
                      
                    
                    
                  
                    
                    
                      | is_wholesaler_ind | 
                      
                        
    
      False
     | 
                      
                    
                    
                  
                    
                    
                      | owner_type_code | 
                      
                        
    
      L
     | 
                      
                    
                    
                  
                    
                    
                      | place_uri | 
                      
                        
    
      https://geoconnex.us/ref/places/
     | 
                      
                    
                    
                  
                    
                    
                      | population_served_count | 
                      
                        
    
      335
     | 
                      
                    
                    
                  
                    
                    
                      | pred_05 | 
                      
                        
    
      None  
     | 
                      
                    
                    
                  
                    
                    
                      | pred_50 | 
                      
                        
    
      None  
     | 
                      
                    
                    
                  
                    
                    
                      | pred_95 | 
                      
                        
    
      None  
     | 
                      
                    
                    
                  
                    
                    
                      | primacy_agency_code | 
                      
                        
    
      NY
     | 
                      
                    
                    
                  
                    
                    
                      | primacy_type | 
                      
                        
    
      State
     | 
                      
                    
                    
                  
                    
                    
                      | primary_source_code | 
                      
                        
    
      None  
     | 
                      
                    
                    
                  
                    
                    
                      | primary_water_source | 
                      
                        
    
      None  
     | 
                      
                    
                    
                  
                    
                    
                      | pws_name | 
                      
                        
    
      ALEXANDER TOWN WD2
     | 
                      
                    
                    
                  
                    
                  
                    
                    
                      | sdwis_link | 
                      
                        
    
      https://enviro.epa.gov/enviro/sdw_report_v3.first_table?pws_id=NY1830045&state=NY&source=0&population=0
     | 
                      
                    
                    
                  
                    
                    
                      | service_area_type | 
                      
                        
    
      nan
     | 
                      
                    
                    
                  
                    
                    
                      | service_connections_count | 
                      
                        
    
      16
     | 
                      
                    
                    
                  
                    
                    
                      | source_date | 
                      
                        
    
      2022-07-05
     | 
                      
                    
                    
                  
                    
                    
                      | source_url | 
                      
                        
    
      https://www.hydroshare.org/resource/b11b8982eebd4843833932f085f71d92/data/contents/temm.geojson
     | 
                      
                    
                    
                  
                    
                    
                      | state_code | 
                      
                        
    
      NY
     | 
                      
                    
                    
                  
                    
                    
                      | state_uri | 
                      
                        
    
      https://geoconnex.us/ref/states/36
     | 
                      
                    
                    
                  
                    
                    
                      | tier | 
                      
                        
    
      None  
     | 
                      
                    
                    
                  
                    
                    
                      | uri | 
                      
                        
    
      https://geoconnex.us/ref/pws/NY1830045
     | 
                      
                    
                    
                  
                    
                    
                      | wholesaler | 
                      
                        
    
      Is not a wholesaler
     |