{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Input","Database","Instructions","InputLinks","SelRecordLinks","LookupLists"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":2,"defined_names":100,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":85,"n_cols":45,"rows_kept":85,"cut":false,"hidden":false,"merged":[[70,1,70,7],[70,8,70,14],[70,15,70,21],[70,22,70,31],[68,15,68,21],[65,1,65,7],[66,1,66,7],[67,1,67,7],[68,1,68,7],[69,1,69,7],[69,8,69,14],[69,15,69,21],[69,22,69,31],[71,1,71,7],[71,8,71,14],[71,15,71,21],[71,22,71,31],[72,1,72,7],[72,8,72,14],[72,15,72,21],[84,8,84,31],[73,1,73,7],[74,1,74,7],[75,1,75,7],[73,8,73,14],[74,8,74,14],[75,8,75,14],[76,2,76,7],[73,15,73,21],[74,15,74,21],[75,15,75,21],[72,22,72,31],[73,22,73,31],[74,22,74,31],[77,1,77,7],[75,22,75,31],[76,15,76,21],[59,8,59,14],[56,22,56,31],[57,22,57,31],[58,22,58,31],[54,32,58,34],[54,22,54,31],[55,22,55,31],[56,8,56,14],[77,32,84,34],[77,15,77,31],[68,22,68,31],[76,22,76,31],[76,8,76,14],[65,32,76,34],[65,22,65,31],[66,22,66,31],[67,22,67,31],[65,15,65,21],[66,15,66,21],[67,15,67,21],[65,8,65,14],[66,8,66,14],[67,8,67,14],[68,8,68,14],[56,2,56,7],[57,2,57,7],[58,2,58,7],[58,8,58,14],[57,8,57,14],[56,15,56,21],[57,15,57,21],[54,1,54,7],[54,8,54,14],[55,1,55,7],[54,15,54,21],[55,15,55,21],[55,8,55,14],[58,15,58,21],[47,22,47,31],[48,22,48,31],[49,22,49,31],[50,22,50,31],[51,22,51,31],[53,16,53,21],[53,22,53,31],[53,2,53,7],[52,16,52,21],[47,8,47,14],[48,8,48,14],[49,8,49,14],[50,8,50,14],[51,8,51,14],[52,8,52,14],[53,8,53,14],[51,16,51,21],[47,16,47,21],[48,16,48,21],[49,16,49,21],[50,16,50,21],[47,2,47,7],[48,2,48,7],[49,2,49,7],[50,2,50,7],[52,2,52,7],[51,2,51,7],[52,22,52,31],[47,32,53,34],[41,32,46,34],[45,1,45,7],[45,8,45,14],[45,15,45,21],[45,22,45,31],[46,1,46,7],[46,8,46,14],[46,15,46,21],[46,22,46,31],[43,1,43,7],[43,8,43,14],[43,15,43,21],[43,22,43,31],[44,1,44,7],[44,8,44,14],[44,15,44,21],[44,22,44,31],[41,1,41,7],[41,8,41,14],[39,8,39,14],[27,15,27,21],[27,22,27,31],[41,15,41,21],[41,22,41,31],[42,1,42,7],[42,8,42,14],[42,15,42,21],[42,22,42,31],[40,1,40,7],[40,8,40,14],[40,15,40,21],[40,22,40,31],[37,8,37,14],[29,1,29,7],[29,8,29,14],[33,1,33,7],[33,8,33,14],[34,1,34,7],[34,8,34,14],[35,1,35,7],[35,8,35,14],[30,1,30,7],[30,8,30,14],[26,32,40,34],[2,1,2,34],[37,15,37,21],[37,22,37,31],[38,15,38,21],[38,22,38,31],[39,15,39,21],[39,22,39,31],[34,15,34,21],[34,22,34,31],[35,15,35,21],[35,22,35,31],[36,15,36,21],[36,22,36,31],[31,15,31,21],[31,22,31,31],[32,15,32,21],[32,22,32,31],[33,15,33,21],[33,22,33,31],[39,1,39,7],[25,22,25,31],[38,1,38,7],[38,8,38,14],[7,1,7,3],[31,1,31,7],[31,8,31,14],[32,1,32,7],[32,8,32,14],[28,15,28,21],[28,22,28,31],[29,15,29,21],[29,22,29,31],[30,15,30,21],[30,22,30,31],[7,15,7,21],[7,4,7,7],[7,11,7,14],[8,1,8,7],[23,15,23,21],[36,1,36,7],[36,8,36,14],[37,1,37,7],[9,8,9,14],[10,8,10,14],[11,8,11,14],[5,3,5,7],[27,1,27,7],[27,8,27,14],[28,1,28,7],[28,8,28,14],[9,1,9,7],[10,1,10,7],[21,1,21,7],[21,8,21,14],[22,1,22,7],[22,8,22,14],[19,1,19,7],[19,8,19,14],[11,1,11,7],[12,1,12,7],[20,1,20,7],[20,8,20,14],[7,8,7,10],[1,1,1,34],[26,1,26,7],[26,8,26,14],[26,15,26,21],[26,22,26,31],[8,32,25,34],[10,15,10,21],[10,22,10,31],[19,15,19,21],[21,15,21,21],[18,22,18,31],[20,22,20,31],[21,22,21,31],[23,22,23,31],[24,22,24,31],[25,1,25,7],[6,10,6,12],[8,15,8,21],[9,15,9,21],[8,8,8,14],[4,22,4,27],[18,1,18,7],[6,8,6,9],[15,15,15,21],[5,26,5,27],[5,24,5,25],[5,22,5,23],[5,8,5,14],[16,22,16,31],[17,22,17,31],[18,15,18,21],[15,8,15,14],[16,8,16,14],[17,8,17,14],[18,8,18,14],[8,22,8,31],[9,22,9,31],[11,22,11,31],[14,22,14,31],[15,22,15,31],[11,15,11,21],[12,15,12,21],[13,22,13,31],[12,8,12,14],[13,8,13,14],[14,8,14,14],[63,1,63,7],[63,8,63,14],[59,32,64,34],[20,15,20,21],[22,22,22,31],[19,22,19,31],[12,22,12,31],[22,15,22,21],[25,15,25,21],[25,8,25,14],[17,1,17,7],[13,1,13,7],[14,1,14,7],[15,1,15,7],[13,15,13,21],[16,1,16,7],[16,15,16,21],[17,15,17,21],[23,1,23,7],[23,8,23,14],[24,1,24,7],[24,8,24,14],[24,15,24,21],[14,15,14,21],[77,8,77,14],[78,1,78,7],[78,8,78,31],[64,1,64,7],[64,8,64,14],[59,15,59,21],[60,15,60,21],[61,15,61,21],[62,15,62,21],[63,15,63,21],[64,15,64,21],[59,22,59,31],[60,22,60,31],[61,22,61,31],[62,22,62,31],[63,22,63,31],[64,22,64,31],[59,1,59,7],[60,1,60,7],[60,8,60,14],[61,1,61,7],[61,8,61,14],[62,1,62,7],[62,8,62,14],[84,1,84,7],[79,1,79,7],[79,8,79,31],[80,1,80,7],[80,8,80,31],[81,1,81,7],[81,8,81,31],[82,1,82,7],[82,8,82,31],[83,1,83,7],[83,8,83,31]]}
[]
[null,"Bay Agricultural Inspection Log"]
[null,"DEP SCRO"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"View Records"]
[null,null,null,"Select Farm ID:",null,null,null,null,"67-999999",null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"of ",null,{"$f":"COUNTA(Database!A:A)-1","v":1}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(MATCH(OrderSel,OrderIDList,0)),0,MATCH(OrderSel,OrderIDList,0))","v":1},null,{"$f":"IF(OrderSel=\"\",FALSE,AND(OrderID<>\"\",COUNTIF(Database!C:C,OrderID)>0))","v":true}]
[null,{"$f":"IF(MMP_Satisfied=\"No\",\"MMP Due:\",\"\")","v":"MMP Due:"},null,null,{"$f":"IF(MMP_Satisfied=\"No\",IF(Extended_MMP_Due_Date<>\"\",Extended_MMP_Due_Date,IF(Original_MMP_Due_Date<>\"\",Original_MMP_Due_Date,\"\")),\"\")","v":"2017-01-28"},null,null,null,{"$f":"IF(ES_Satisfied=\"No\",\"E&S Due:\",\"\")","v":""},null,null,{"$f":"IF(ES_Satisfied=\"No\",IF(Extended_ES_Due_Date<>\"\",Extended_ES_Due_Date,IF(Original_ES_Due_Date<>\"\",Original_ES_Due_Date,\"\")),\"\")","v":""},null,null,null,{"$f":"IF(I77=TRUE,\"Referral Made to DEP\",\"\")","v":""}]
[null,"Farm ID",null,null,null,null,null,null,"67-999999",null,null,null,null,null,null,"Operation Name",null,null,null,null,null,null,"Test Farm",null,null,null,null,null,null,null,null,null,"GENERAL INFORMATION"]
[null,"County",null,null,null,null,null,null,"York",null,null,null,null,null,null,"Inspection Date",null,null,null,null,null,null,"2016-08-01"]
[null,"Municipality",null,null,null,null,null,null,"Fairview Township",null,null,null,null,null,null,"Inspection Type",null,null,null,null,null,null,"Initial Inspection"]
[null,"Total Acres of Operation",null,null,null,null,null,null,100,null,null,null,null,null,null,"Latitude",null,null,null,null,null,null,40.255000000000003]
[null,"Mailing Address",null,null,null,null,null,null,"555 Test Road",null,null,null,null,null,null,"Longitude",null,null,null,null,null,null,76.111000000000004]
[null,"Mailing Address City",null,null,null,null,null,null,"Lewisberry",null,null,null,null,null,null,"Home Farm?",null,null,null,null,null,null,"Yes"]
[null,"Mailing Address State",null,null,null,null,null,null,"PA",null,null,null,null,null,null,"Satellite Farm?",null,null,null,null,null,null,"No"]
[null,"Mailing Address Zip",null,null,null,null,null,null,17339,null,null,null,null,null,null,"Rented Fields?",null,null,null,null,null,null,"No"]
[null,"Location Address",null,null,null,null,null,null,"555 Test Road",null,null,null,null,null,null,"Animals On-Site?",null,null,null,null,null,null,"Yes"]
[null,"Location Address City",null,null,null,null,null,null,"Lewisberry",null,null,null,null,null,null,"Animal Type 1",null,null,null,null,null,null,"Dairy - Holstein/Brown Swiss Cow"]
[null,"Location Address State",null,null,null,null,null,null,"PA",null,null,null,null,null,null,"Number - Animal Type 1",null,null,null,null,null,null,100]
[null,"Location Address Zip",null,null,null,null,null,null,17339,null,null,null,null,null,null,"Animal Type 2",null,null,null,null,null,null,"Dairy - Holstein/Brown Swiss Heifer: 1-2 yr"]
[null,"Inspection Scheduled",null,null,null,null,null,null,"Yes",null,null,null,null,null,null,"Number - Animal Type 2",null,null,null,null,null,null,50]
[null,"Owner/Op Not Available",null,null,null,null,null,null,"No",null,null,null,null,null,null,"Animal Type 3"]
[null,"No Insp. - Biosecurity",null,null,null,null,null,null,"No",null,null,null,null,null,null,"Number - Animal Type 3"]
[null,"Refused Access",null,null,null,null,null,null,"No",null,null,null,null,null,null,"AEUs",null,null,null,null,null,null,135]
[null,"Interviewed",null,null,null,null,null,null,"Owner",null,null,null,null,null,null,"Crops Only?",null,null,null,null,null,null,"No"]
[null,"Owner Name",null,null,null,null,null,null,"John Smith",null,null,null,null,null,null,"Operator Name",null,null,null,null,null,null,"John Smith"]
[null,"Manure Gen/App On-Site?",null,null,null,null,null,null,"Yes",null,null,null,null,null,null,"Written MMP?",null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,"MANURE MANAGEMENT PLAN"]
[null,"MMP Developed By",null,null,null,null,null,null,null,null,null,null,null,null,null,"MMP Admin Complete?",null,null,null,null,null,null,"N/A"]
[null,"Acres Available for Manure",null,null,null,null,null,null,null,null,null,null,null,null,null,"MMP Planner Name"]
[null,"Includes Home Farm?",null,null,null,null,null,null,null,null,null,null,null,null,null,"MMP Date"]
[null,"Includes Satellite Farm(s)?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Manure Exported?",null,null,null,null,null,null,"No"]
[null,"Includes Rented Fields?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Manure Imported?",null,null,null,null,null,null,"No"]
[null,"Manure Storage 1 Type",null,null,null,null,null,null,"Aboveground Concrete",null,null,null,null,null,null,"Nutrient Balance Sheets?",null,null,null,null,null,null,"N/A"]
[null,"Manure Storage 1 Cap (MG)",null,null,null,null,null,null,0.4,null,null,null,null,null,null,"Sewage Sludge Imported?",null,null,null,null,null,null,"Yes"]
[null,"Manure Storage 1 Year",null,null,null,null,null,null,1971,null,null,null,null,null,null,"Manure Stacking?",null,null,null,null,null,null,"Yes"]
[null,"Manure Storage 2 Type",null,null,null,null,null,null,null,null,null,null,null,null,null,"Process Wastewater?",null,null,null,null,null,null,"No"]
[null,"Manure Storage 2 Cap (MG)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Outdoor Feed Storage?",null,null,null,null,null,null,"Yes"]
[null,"Manure Storage 2 Year",null,null,null,null,null,null,null,null,null,null,null,null,null,"AHUA(s) / ACA(s)?",null,null,null,null,null,null,"Yes"]
[null,"Manure Storage 3 Type",null,null,null,null,null,null,null,null,null,null,null,null,null,"MMP Implemented?",null,null,null,null,null,null,"N/A"]
[null,"Manure Storage 3 Cap (MG)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Setbacks Followed?",null,null,null,null,null,null,"Yes"]
[null,"Manure Storage 3 Year",null,null,null,null,null,null,null,null,null,null,null,null,null,"Manure Records Kept?",null,null,null,null,null,null,"No"]
[null,"Plowing/AHUA(s) On-Site?",null,null,null,null,null,null,"Yes",null,null,null,null,null,null,"Written E&S Plan?",null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,null,null,"AG E&S PLAN"]
[null,"E&S Plan Developed By",null,null,null,null,null,null,"Agency",null,null,null,null,null,null,"E&S Admin Complete?",null,null,null,null,null,null,"No"]
[null,"Acres Covered by E&S Plan",null,null,null,null,null,null,125,null,null,null,null,null,null,"E&S Planner Name",null,null,null,null,null,null,"NRCS"]
[null,"Includes Home Farm?",null,null,null,null,null,null,"Yes",null,null,null,null,null,null,"E&S Plan Date",null,null,null,null,null,null,"2005-10-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Includes Satellite Farm(s)?",null,null,null,null,null,null,"No",null,null,null,null,null,null,"E&S Plan Implemented?",null,null,null,null,null,null,"Yes"]
[null,"Includes Rented Fields?",null,null,null,null,null,null,"Yes",null,null,null,null,null,null,"No-Till?",null,null,null,null,null,null,"No"]
[null,null,"Stream Fencing",null,null,null,null,null,false,null,null,null,null,null,null,null,"Precision Feeding",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NON-COST SHARE BMPs"]
[null,null,"Barnyard Runoff Control",null,null,null,null,null,false,null,null,null,null,null,null,null,"Phytase"]
[null,null,"Cover Crops",null,null,null,null,null,true,null,null,null,null,null,null,null,"Rotational Grazing"]
[null,null,"Streamside Grass Buffers",null,null,null,null,null,null,null,null,null,null,null,null,null,"Retired Lands"]
[null,null,"Forest Buffers",null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Control Structure"]
[null,null,"Conservation Tillage",null,null,null,null,null,true,null,null,null,null,null,null,null,"Other Description"]
[null,null,"Other",null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Description"]
[null,"Water Quality Evaluation",null,null,null,null,null,null,"Other Water Quality Concerns",null,null,null,null,null,null,"WQ Concern",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WQ / VIOLATIONS"]
[null,"WQ Concern",null,null,null,null,null,null,"Stacking Near Stream",null,null,null,null,null,null,"WQ Concern"]
[null,null,"25 Pa. Code 91.36(b) Viol",null,null,null,null,null,true,null,null,null,null,null,null,"MMP No. Days to Submit",null,null,null,null,null,null,90]
[null,null,"25 Pa. Code 102.4(b) Viol",null,null,null,null,null,null,null,null,null,null,null,null,"E&S No. Days to Submit"]
[null,null,"Other Violation",null,null,null,null,null,null,null,null,null,null,null,null,"Other Violation Citation"]
[null,"Person Interviewed",null,null,null,null,null,null,"John Smith",null,null,null,null,null,null,"Inspector Name",null,null,null,null,null,null,"Chuck Schadel",null,null,null,null,null,null,null,null,null,"INTERVIEWER / INTERVIEWEE"]
[null,"Cell Phone",null,null,null,null,null,null,"717.571.0000",null,null,null,null,null,null,"Cell Phone",null,null,null,null,null,null,"717.999.9999"]
[null,"Other Phone",null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Phone"]
[null,"Organization",null,null,null,null,null,null,"Test Farm",null,null,null,null,null,null,"Organization",null,null,null,null,null,null,"DEP SCRO"]
[null,"Title",null,null,null,null,null,null,"Owner",null,null,null,null,null,null,"Title",null,null,null,null,null,null,"WQS"]
[null,"Email",null,null,null,null,null,null,"johnsmith99@hotmail.com",null,null,null,null,null,null,"Date Report Provided",null,null,null,null,null,null,"2016-08-01"]
[null,"Original MMP Due Date",null,null,null,null,null,null,"2016-10-30",null,null,null,null,null,null,"MMP Received?",null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,"FOLLOW-UP TRACKING",null,null,null,null,null,null,null,null,null,null,"MMP Satisfied?",{"$f":"IF(W27=\"No\",IF(AND(I57=TRUE,OR(Original_MMP_Received=\"Yes\",Extended_MMP_Received=\"Yes\")),\"Yes\",\"No\"),\"Yes\")","v":"No"}]
[null,"MMP Received Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"More Time to Submit MMP",null,null,null,null,null,null,true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E&S Satisfied?",{"$f":"IF(W42=\"No\",IF(AND(I58=TRUE,OR(Original_ES_Received=\"Yes\",Extended_ES_Received=\"Yes\")),\"Yes\",\"No\"),\"Yes\")","v":"Yes"}]
[null,"Additional No. Days for MMP",null,null,null,null,null,null,90,null,null,null,null,null,null,"Extended MMP Due Date",null,null,null,null,null,null,"2017-01-28"]
[null,"MMP Received Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"MMP Received?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Original MMP Due Date",{"$f":"IF(AND(Inspection_Date<>\"\",MMP_No_Days<>\"\"),Inspection_Date+MMP_No_Days,\"\")","v":"2016-10-30"}]
[null,"Original E&S Due Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"E&S Received?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extended MMP Due Date",{"$f":"IF(MMP_Additional_Days<>\"\",Original_MMP_Due_Date+MMP_Additional_Days,\"\")","v":"2017-01-28"}]
[null,"E&S Received Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"More Time to Submit E&S"]
[null,"Additional No. Days for E&S",null,null,null,null,null,null,null,null,null,null,null,null,null,"Extended E&S Due Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Original ES Due Date",{"$f":"IF(AND(Inspection_Date<>\"\",ES_No_Days<>\"\"),Inspection_Date+ES_No_Days,\"\")","v":""}]
[null,"E&S Received Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"E&S Received?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extended ES Due Date",{"$f":"IF(ES_Additional_Days<>\"\",Original_ES_Due_Date+ES_Additional_Days,\"\")","v":""}]
[null,"Follow-Up Action 1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Follow-Up Action 2"]
[null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null,"Completed By",null,null,null,null,null,null,null,null,null,null,null,null,null,"Completed By"]
[null,null,"Referral Made to DEP",null,null,null,null,null,null,null,null,null,null,null,null,"Referral Date"]
[null,"NRCS Form Provided",null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMMENTS"]
[null,"General Comments",null,null,null,null,null,null,"This inspection was rescheduled twice due to owner unavailability."]
[null,"MMP Comments",null,null,null,null,null,null,"No MMP or application records.  Sewage sludge imported and land applied on ground separate from manure."]
[null,"E&S Comments",null,null,null,null,null,null,"Conservation plan in place.  Owner indicates it is being followed.  It is however missing maps."]
[null,"BMP Comments"]
[null,"Water Quality Comments",null,null,null,null,null,null,"Manure stacked within 5 feet of a sinkhole."]
[null,"Additional Comments",null,null,null,null,null,null,"Owner was advised to check with NRCS for a complete copy of conservation plan with maps."]
[null,"Follow-Up Comments",null,null,null,null,null,null,"Inspector will revisit farm to check on status of MMP."]

{"sheet":"Database","index":1,"n_rows":2,"n_cols":148,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Date Entered","Entered By","Farm ID","Operation Name","County","Municipality","Inspection Date","Inspection Type","Total Acres of Operation","Latitude","Longitude","Mailing Address","Mailing Address City","Mailing Address State","Mailing Address Zip","Location Address","Location Address City","Location Address State","Location Address Zip","Home Farm?","Satellite Farm?","Rented Fields?","Animals On-Site?","Animal Type 1","Number - Animal Type 1","Animal Type 2","Number - Animal Type 2","Animal Type 3","Number - Animal Type 3","AEUs","Crops Only?","Inspection Scheduled","Owner/Op Not Available","No Insp. - Biosecurity","Refused Access","Interviewed","Owner Name","Operator Name","Manure Gen/App On-Site?","Written MMP?","MMP Developed By","MMP Admin Complete?","Acres Available for Manure","MMP Planner Name","MMP Includes Home Farm?","MMP Includes Satellite Farm(s)?","MMP Includes Rented Fields?","MMP Date","Manure Storage 1 Type","Manure Storage 1 Cap (MG)","Manure Storage 1 Year","Manure Storage 2 Type","Manure Storage 2 Cap (MG)","Manure Storage 2 Year","Manure Storage 3 Type","Manure Storage 3 Cap (MG)","Manure Storage 3 Year","Manure Exported?","Manure Imported?","Nutrient Balance Sheets?","Sewage Sludge Imported?","Manure Stacking?","Process Wastewater?","Outdoor Feed Storage?","AHUA(s) / ACA(s)?","MMP Implemented?","Setbacks Followed?","Manure Records Kept?","Plowing/AHUA(s) On-Site?","Written E&S Plan?","E&S Plan Developed By","E&S Admin Complete?","Acres Covered by E&S Plan","E&S Planner Name","E&S Includes Home Farm?","E&S Includes Satellite Farm(s)?","E&S Includes Rented Fields?","E&S Plan Date","E&S Plan Implemented?","No-Till?","Stream Fencing","Barnyard Runoff Control","Cover Crops","Streamside Grass Buffers","Forest Buffers","Conservation Tillage","Precision Feeding","Phytase","Rotational Grazing","Retired Lands","Water Control Structure","Other","Other BMP Description 1","Other BMP Description 2","Water Quality Evaluation","WQ Concern 1","WQ Concern 2","WQ Concern 3","25 Pa Code 91.36(b) Viol","MMP No. Days to Submit","25 Pa Code 102.4(a) Viol","E&S No. Days to Submit","Other Violation","Other Violation Citation","Person Interviewed","Interviewee Cell Phone","Interviewee Other Phone","Interviewee Organization","Interviewee Title","Interviewee Email","Inspector Name","Inspector Cell Phone","Inspector Other Phone","Inspector Organization","Inspector Title","Date Report Provided","Original MMP Due Date","MMP Received?","MMP Received Date","More Time to Submit MMP","Additional No. Days for MMP","Extended MMP Due Date","MMP Received Date (Extended)","MMP Received (Extended)?","Original E&S Due Date","E&S Received?","E&S Received Date","More Time to Submit E&S","Additional No. Days for E&S","Extended E&S Due Date","E&S Received Date (Extended)","E&S Received (Extended)?","Follow-Up Action 1","Follow-Up Action 1 Date","Follow-Up Action 1 Completed By","Follow-Up Action 2","Follow-Up Action 2 Date","Follow-Up Action 2 Completed By","Referral Made to DEP","Referral Date","NRCS Form Provided","General Comments","MMP Comments","E&S Comments","BMP Comments","Water Quality Comments","Additional Comments","Follow-Up Comments"]
["2017-01-05T08:32:14","Windows User","67-999999","Test Farm","York","Fairview Township","2016-08-01","Initial Inspection",100,40.255000000000003,76.111000000000004,"555 Test Road","Lewisberry","PA",17339,"555 Test Road","Lewisberry","PA",17339,"Yes","No","No","Yes","Dairy - Holstein/Brown Swiss Cow",100,"Dairy - Holstein/Brown Swiss Heifer: 1-2 yr",50,"","",135,"No","Yes","No","No","No","Owner","John Smith","John Smith","Yes","No","","N/A","","","","","","","Aboveground Concrete",0.4,1971,"","","","","","","No","No","N/A","Yes","Yes","No","Yes","Yes","N/A","Yes","No","Yes","Yes","Agency","No",125,"NRCS","Yes","No","Yes","2005-10-01","Yes","No",false,false,true,"","",true,"","","","","","","","","Other Water Quality Concerns","Stacking Near Stream","","",true,90,"","","","","John Smith","717.571.0000","","Test Farm","Owner","johnsmith99@hotmail.com","Chuck Schadel","717.999.9999","","DEP SCRO","WQS","2016-08-01","2016-10-30","No","",true,90,"2017-01-28","","","","","","","","","","","","","","","","","","","No","This inspection was rescheduled twice due to owner unavailability.","No MMP or application records.  Sewage sludge imported and land applied on ground separate from manure.","Conservation plan in place.  Owner indicates it is being followed.  It is however missing maps.","","Manure stacked within 5 feet of a sinkhole.","Owner was advised to check with NRCS for a complete copy of conservation plan with maps.","Inspector will revisit farm to check on status of MMP."]

{"sheet":"Instructions","index":2,"n_rows":61,"n_cols":2,"rows_kept":61,"cut":false,"hidden":false,"merged":[[16,1,17,9],[0,1,1,9],[3,1,6,9],[10,1,14,9],[19,1,21,9],[24,1,26,9],[33,1,37,9],[41,1,43,9],[44,1,55,9],[60,1,63,9],[57,1,58,9]]}
[null,"Instructions for Using Bay Agricultural Inspection Log"]
[]
[]
[null,"This spreadsheet is intended for use by DEP regional offices and County Conservation Districts (CCDs) for documenting inspections of agricultural operations under SOP No. BCW-INSP-018.  Questions on the use of this spreadsheet should be directed to DEP's Bureau of Clean Water at 717-787-5017."]
[]
[]
[]
[]
[null,"Instructions:"]
[]
[null,"This spreadsheet consists of two worksheets: Input and Database.  The Input worksheet is used for data entry.  Results are recorded in the Database worksheet.  While the Database worksheet can be searched for records and copied, no changes may be made.  If an update is desired, the update should be made to the Input worksheet.  The spreadsheet template includes one test record as an example.  As you add new inspections through the Input worksheet, new rows will be added to the Database worksheet."]
[]
[]
[]
[]
[]
[null,"Selecting Organization: Click on the cell below the title \"Bay Agricultural Inspection Log\" to reveal a dropdown list.  Select the appropriate organization from the list."]
[]
[]
[null,"Creating a New Inspection Record: Start by clicking on the \"Clear Form\" button at the top right of the Input worksheet.  Then enter the Farm ID (required), complete as much information as possible in the worksheet, and click on the \"Add\" button."]
[]
[]
[]
[]
[null,"Updating an Existing Inspection Record:  Navigate to the record you wish to update by either using the \"Select Farm ID\" dropdown menu or the navigation buttons in the Input worksheet.  After making changes, click on the \"Update\" button."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Completing Input Worksheet: The worksheet is generally ordered in the same manner as the Inspection Report, except for the Comments sections, which are at the bottom of the worksheet.  In addition, a section for Follow-Up Actions is included for tracking purposes.  The names of fields do not match the names of corresponding fields on the Inspection Report in all cases.  Click the icon below to open a document that explains differences.  Note that there is validation in most cells to reduce mistakes in data entry."]
[]
[]
[]
[]
[]
[]
[]
[null,"Checkboxes: There are a number of checkboxes available in the Input worksheet.  Click the checkboxes where applicable, but DO NOT enter data into the blank cells to the right of the checkbox text, otherwise the checkbox entries may not be saved."]
[]
[]
[null,"Follow-Up Tracking: If an MMP and/or Ag E&S Plan is required but is not available, check the appropriate violation box in the WQ / Violations Section (25 Pa. Code 91.36(b) Viol for MMP, 25 Pa. Code 102.4(a) Viol for Ag E&S) and enter the number of days provided to submit the plan (MMP No. Days to Submit and/or E&S No. Days to Submit).  This will calculate a due date that will be highlighted in red at the top of the form.  This date is not populated into the form; if the user would like to store the due date, the user must enter it into the Follow-Up Tracking section (Original MMP Due Date / Original E&S Due Date), and then click the Add or Update buttons.  If the plan(s) are not received by these Original Due Dates, the user should select \"No\" for the MMP Received? / E&S Received? questions, select the \"More Time to Submit MMP\" or \"More Time to Submit E&S\" box, and enter an additional number of days provided (Additional No. Days for MMP / E&S).  This will update the calculated due date at the top of the form, but will not populate in the form itself.  If the user would like to store the extended due date(s), the user must enter the dates into the Extended MMP / E&S Due Date fields."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Other Navigation: Use the \"View Database\" and \"Go to Input Screen\" buttons to toggle between the Input and Database worksheets."]
[]
[]
[null,"CCDs should submit an updated spreadsheet via email to all DEP points of contact on a quarterly basis (i.e., by October 15, January 15, April 15 and July 15).  Regional offices will compile and submit this spreadsheet for all of its inspections and those of CCDs in their territories by July 31 each year."]

{"sheet":"InputLinks","index":3,"n_rows":6,"n_cols":146,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Start Column"]
[{"$f":"MATCH(A5,Database!1:1,0)","v":3}]
[]
["I9","W9","I10","I11","W10","W11","I12","W12","W13","I13","I14","I15","I16","I17","I18","I19","I20","W14","W15","W16","W17","W18","W19","W20","W21","W22","W23","W24","W25","I21","I22","I23","I24","I25","I26","W26","I27","W27","I28","W28","I29","W29","I30","I31","I32","W30","I33","I34","I35","I36","I37","I38","I39","I40","I41","W31","W32","W33","W34","W35","W36","W37","W38","W39","W40","W41","I42","W42","I43","W43","I44","W44","I45","I46","I47","W45","W46","W47","I48","I49","I50","I51","I52","I53","W48","W49","W50","W51","W52","I54","W53","W54","I55","I56","W55","W56","I57","W57","I58","W58","I59","W59","I60","I61","I62","I63","I64","I65","W60","W61","W62","W63","W64","W65","I66","W66","I67","W67","I68","W68","I69","W69","I70","W70","I71","W71","I72","W72","I73","W73","I74","I75","I76","W74","W75","W76","I77","W77","I78","I79","I80","I81","I82","I83","I84","I85"]
[{"$f":"Database!C1","v":"Farm ID"},{"$f":"Database!D1","v":"Operation Name"},{"$f":"Database!E1","v":"County"},{"$f":"Database!F1","v":"Municipality"},{"$f":"Database!G1","v":"Inspection Date"},{"$f":"Database!H1","v":"Inspection Type"},{"$f":"Database!I1","v":"Total Acres of Operation"},{"$f":"Database!J1","v":"Latitude"},{"$f":"Database!K1","v":"Longitude"},{"$f":"Database!L1","v":"Mailing Address"},{"$f":"Database!M1","v":"Mailing Address City"},{"$f":"Database!N1","v":"Mailing Address State"},{"$f":"Database!O1","v":"Mailing Address Zip"},{"$f":"Database!P1","v":"Location Address"},{"$f":"Database!Q1","v":"Location Address City"},{"$f":"Database!R1","v":"Location Address State"},{"$f":"Database!S1","v":"Location Address Zip"},{"$f":"Database!T1","v":"Home Farm?"},{"$f":"Database!U1","v":"Satellite Farm?"},{"$f":"Database!V1","v":"Rented Fields?"},{"$f":"Database!W1","v":"Animals On-Site?"},{"$f":"Database!X1","v":"Animal Type 1"},{"$f":"Database!Y1","v":"Number - Animal Type 1"},{"$f":"Database!Z1","v":"Animal Type 2"},{"$f":"Database!AA1","v":"Number - Animal Type 2"},"Animal Type 3","Number - Animal Type 3","AEUs","Crops Only?","Inspection Scheduled","Owner/Op Not Available","No Insp. - Biosecurity","Refused Access","Interviewed","Owner Name","Operator Name","Manure Gen/App On-Site?","Written MMP?","MMP Developed By","MMP Admin Complete?","Acres Available for Manure","MMP Planner Name","MMP Includes Home Farm?","MMP Includes Satellite Farm(s)?","MMP Includes Rented Fields?","MMP Date","Manure Storage 1 Type","Manure Storage 1 Cap (MG)","Manure Storage 1 Year","Manure Storage 2 Type","Manure Storage 2 Cap (MG)","Manure Storage 2 Year","Manure Storage 3 Type","Manure Storage 3 Cap (MG)","Manure Storage 3 Year","Manure Exported?","Manure Imported?","Nutrient Balance Sheets?","Sewage Sludge Imported?","Manure Stacking?","Process Wastewater?","Outdoor Feed Storage?","AHUA(s) / ACA(s)?","MMP Implemented?","Setbacks Followed?","Manure Records Kept?","Plowing/AHUA(s) On-Site?","Written E&S Plan?","E&S Plan Developed By","E&S Admin Complete?","Acres Covered by E&S Plan","E&S Planner Name","E&S Includes Home Farm?","E&S Includes Satellite Farm(s)?","E&S Includes Rented Fields?","E&S Plan Date","E&S Plan Implemented?","No-Till?","Stream Fencing","Barnyard Runoff Control","Cover Crops","Streamside Grass Buffers","Forest Buffers","Conservation Tillage","Precision Feeding","Phytase","Rotational Grazing","Retired Lands","Water Control Structure","Other","Other BMP Description 1","Other BMP Description 2","Water Quality Evaluation","WQ Concern 1","WQ Concern 2","WQ Concern 3","25 Pa Code 91.36(b) Viol","MMP No. Days to Submit","25 Pa Code 102.4(a) Viol","E&S No. Days to Submit","Other Violation","Other Violation Citation","Person Interviewed","Interviewee Cell Phone","Interviewee Other Phone","Interviewee Organization","Interviewee Title","Interviewee Email","Inspector Name","Inspector Cell Phone","Inspector Other Phone","Inspector Organization","Inspector Title","Date Report Provided","Original MMP Due Date","MMP Received?","MMP Received Date","More Time to Submit MMP","Additional No. Days for MMP","Extended MMP Due Date","MMP Received Date (Extended)","MMP Received (Extended)?","Original E&S Due Date","E&S Received?","E&S Received Date","More Time to Submit E&S","Additional No. Days for E&S","Extended E&S Due Date","E&S Received Date (Extended)","E&S Received (Extended)?","Follow-Up Action 1","Follow-Up Action 1 Date","Follow-Up Action 1 Completed By","Follow-Up Action 2","Follow-Up Action 2 Date","Follow-Up Action 2 Completed By","Referral Made to DEP","Referral Date","NRCS Form Provided","General Comments","MMP Comments","E&S Comments","BMP Comments","Water Quality Comments","Additional Comments","Follow-Up Comments"]
[{"$f":"IF(Input!I9<>\"\",Input!I9,\"\")","v":"67-999999"},{"$f":"IF(Input!W9<>\"\",Input!W9,\"\")","v":"Test Farm"},{"$f":"IF(Input!I10<>\"\",Input!I10,\"\")","v":"York"},{"$f":"IF(Input!I11<>\"\",Input!I11,\"\")","v":"Fairview Township"},{"$f":"IF(Input!W10<>\"\",Input!W10,\"\")","v":"2016-08-01"},{"$f":"IF(Input!W11<>\"\",Input!W11,\"\")","v":"Initial Inspection"},{"$f":"IF(Input!I12<>\"\",Input!I12,\"\")","v":100},{"$f":"IF(Input!W12<>\"\",Input!W12,\"\")","v":40.255000000000003},{"$f":"IF(Input!W13<>\"\",Input!W13,\"\")","v":76.111000000000004},{"$f":"IF(Input!I13<>\"\",Input!I13,\"\")","v":"555 Test Road"},{"$f":"IF(Input!I14<>\"\",Input!I14,\"\")","v":"Lewisberry"},{"$f":"IF(Input!I15<>\"\",Input!I15,\"\")","v":"PA"},{"$f":"IF(Input!I16<>\"\",Input!I16,\"\")","v":17339},{"$f":"IF(Input!I17<>\"\",Input!I17,\"\")","v":"555 Test Road"},{"$f":"IF(Input!I18<>\"\",Input!I18,\"\")","v":"Lewisberry"},{"$f":"IF(Input!I19<>\"\",Input!I19,\"\")","v":"PA"},{"$f":"IF(Input!I20<>\"\",Input!I20,\"\")","v":17339},{"$f":"IF(Input!W14<>\"\",Input!W14,\"\")","v":"Yes"},{"$f":"IF(Input!W15<>\"\",Input!W15,\"\")","v":"No"},{"$f":"IF(Input!W16<>\"\",Input!W16,\"\")","v":"No"},{"$f":"IF(Input!W17<>\"\",Input!W17,\"\")","v":"Yes"},{"$f":"IF(Input!W18<>\"\",Input!W18,\"\")","v":"Dairy - Holstein/Brown Swiss Cow"},{"$f":"IF(Input!W19<>\"\",Input!W19,\"\")","v":100},{"$f":"IF(Input!W20<>\"\",Input!W20,\"\")","v":"Dairy - Holstein/Brown Swiss Heifer: 1-2 yr"},{"$f":"IF(Input!W21<>\"\",Input!W21,\"\")","v":50},{"$f":"IF(Input!W22<>\"\",Input!W22,\"\")","v":""},{"$f":"IF(Input!W23<>\"\",Input!W23,\"\")","v":""},{"$f":"IF(Input!W24<>\"\",Input!W24,\"\")","v":135},{"$f":"IF(Input!W25<>\"\",Input!W25,\"\")","v":"No"},{"$f":"IF(Input!I21<>\"\",Input!I21,\"\")","v":"Yes"},{"$f":"IF(Input!I22<>\"\",Input!I22,\"\")","v":"No"},{"$f":"IF(Input!I23<>\"\",Input!I23,\"\")","v":"No"},{"$f":"IF(Input!I24<>\"\",Input!I24,\"\")","v":"No"},{"$f":"IF(Input!I25<>\"\",Input!I25,\"\")","v":"Owner"},{"$f":"IF(Input!I26<>\"\",Input!I26,\"\")","v":"John Smith"},{"$f":"IF(Input!W26<>\"\",Input!W26,\"\")","v":"John Smith"},{"$f":"IF(Input!I27<>\"\",Input!I27,\"\")","v":"Yes"},{"$f":"IF(Input!W27<>\"\",Input!W27,\"\")","v":"No"},{"$f":"IF(Input!I28<>\"\",Input!I28,\"\")","v":""},{"$f":"IF(Input!W28<>\"\",Input!W28,\"\")","v":"N/A"},{"$f":"IF(Input!I29<>\"\",Input!I29,\"\")","v":""},{"$f":"IF(Input!W29<>\"\",Input!W29,\"\")","v":""},{"$f":"IF(Input!I30<>\"\",Input!I30,\"\")","v":""},{"$f":"IF(Input!I31<>\"\",Input!I31,\"\")","v":""},{"$f":"IF(Input!I32<>\"\",Input!I32,\"\")","v":""},{"$f":"IF(Input!W30<>\"\",Input!W30,\"\")","v":""},{"$f":"IF(Input!I33<>\"\",Input!I33,\"\")","v":"Aboveground Concrete"},{"$f":"IF(Input!I34<>\"\",Input!I34,\"\")","v":0.4},{"$f":"IF(Input!I35<>\"\",Input!I35,\"\")","v":1971},{"$f":"IF(Input!I36<>\"\",Input!I36,\"\")","v":""},{"$f":"IF(Input!I37<>\"\",Input!I37,\"\")","v":""},{"$f":"IF(Input!I38<>\"\",Input!I38,\"\")","v":""},{"$f":"IF(Input!I39<>\"\",Input!I39,\"\")","v":""},{"$f":"IF(Input!I40<>\"\",Input!I40,\"\")","v":""},{"$f":"IF(Input!I41<>\"\",Input!I41,\"\")","v":""},{"$f":"IF(Input!W31<>\"\",Input!W31,\"\")","v":"No"},{"$f":"IF(Input!W32<>\"\",Input!W32,\"\")","v":"No"},{"$f":"IF(Input!W33<>\"\",Input!W33,\"\")","v":"N/A"},{"$f":"IF(Input!W34<>\"\",Input!W34,\"\")","v":"Yes"},{"$f":"IF(Input!W35<>\"\",Input!W35,\"\")","v":"Yes"},{"$f":"IF(Input!W36<>\"\",Input!W36,\"\")","v":"No"},{"$f":"IF(Input!W37<>\"\",Input!W37,\"\")","v":"Yes"},{"$f":"IF(Input!W38<>\"\",Input!W38,\"\")","v":"Yes"},{"$f":"IF(Input!W39<>\"\",Input!W39,\"\")","v":"N/A"},{"$f":"IF(Input!W40<>\"\",Input!W40,\"\")","v":"Yes"},{"$f":"IF(Input!W41<>\"\",Input!W41,\"\")","v":"No"},{"$f":"IF(Input!I42<>\"\",Input!I42,\"\")","v":"Yes"},{"$f":"IF(Input!W42<>\"\",Input!W42,\"\")","v":"Yes"},{"$f":"IF(Input!I43<>\"\",Input!I43,\"\")","v":"Agency"},{"$f":"IF(Input!W43<>\"\",Input!W43,\"\")","v":"No"},{"$f":"IF(Input!I44<>\"\",Input!I44,\"\")","v":125},{"$f":"IF(Input!W44<>\"\",Input!W44,\"\")","v":"NRCS"},{"$f":"IF(Input!I45<>\"\",Input!I45,\"\")","v":"Yes"},{"$f":"IF(Input!I46<>\"\",Input!I46,\"\")","v":"No"},{"$f":"IF(Input!I47<>\"\",Input!I47,\"\")","v":"Yes"},{"$f":"IF(Input!W45<>\"\",Input!W45,\"\")","v":"2005-10-01"},{"$f":"IF(Input!W46<>\"\",Input!W46,\"\")","v":"Yes"},{"$f":"IF(Input!W47<>\"\",Input!W47,\"\")","v":"No"},{"$f":"IF(Input!I48<>\"\",Input!I48,\"\")","v":false},{"$f":"IF(Input!I49<>\"\",Input!I49,\"\")","v":false},{"$f":"IF(Input!I50<>\"\",Input!I50,\"\")","v":true},{"$f":"IF(Input!I51<>\"\",Input!I51,\"\")","v":""},{"$f":"IF(Input!I52<>\"\",Input!I52,\"\")","v":""},{"$f":"IF(Input!I53<>\"\",Input!I53,\"\")","v":true},{"$f":"IF(Input!W48<>\"\",Input!W48,\"\")","v":""},{"$f":"IF(Input!W49<>\"\",Input!W49,\"\")","v":""},{"$f":"IF(Input!W50<>\"\",Input!W50,\"\")","v":""},{"$f":"IF(Input!W51<>\"\",Input!W51,\"\")","v":""},{"$f":"IF(Input!W52<>\"\",Input!W52,\"\")","v":""},{"$f":"IF(Input!I54<>\"\",Input!I54,\"\")","v":""},{"$f":"IF(Input!W53<>\"\",Input!W53,\"\")","v":""},{"$f":"IF(Input!W54<>\"\",Input!W54,\"\")","v":""},{"$f":"IF(Input!I55<>\"\",Input!I55,\"\")","v":"Other Water Quality Concerns"},{"$f":"IF(Input!I56<>\"\",Input!I56,\"\")","v":"Stacking Near Stream"},{"$f":"IF(Input!W55<>\"\",Input!W55,\"\")","v":""},{"$f":"IF(Input!W56<>\"\",Input!W56,\"\")","v":""},{"$f":"IF(Input!I57<>\"\",Input!I57,\"\")","v":true},{"$f":"IF(Input!W57<>\"\",Input!W57,\"\")","v":90},{"$f":"IF(Input!I58<>\"\",Input!I58,\"\")","v":""},{"$f":"IF(Input!W58<>\"\",Input!W58,\"\")","v":""},{"$f":"IF(Input!I59<>\"\",Input!I59,\"\")","v":""},{"$f":"IF(Input!W59<>\"\",Input!W59,\"\")","v":""},{"$f":"IF(Input!I60<>\"\",Input!I60,\"\")","v":"John Smith"},{"$f":"IF(Input!I61<>\"\",Input!I61,\"\")","v":"717.571.0000"},{"$f":"IF(Input!I62<>\"\",Input!I62,\"\")","v":""},{"$f":"IF(Input!I63<>\"\",Input!I63,\"\")","v":"Test Farm"},{"$f":"IF(Input!I64<>\"\",Input!I64,\"\")","v":"Owner"},{"$f":"IF(Input!I65<>\"\",Input!I65,\"\")","v":"johnsmith99@hotmail.com"},{"$f":"IF(Input!W60<>\"\",Input!W60,\"\")","v":"Chuck Schadel"},{"$f":"IF(Input!W61<>\"\",Input!W61,\"\")","v":"717.999.9999"},{"$f":"IF(Input!W62<>\"\",Input!W62,\"\")","v":""},{"$f":"IF(Input!W63<>\"\",Input!W63,\"\")","v":"DEP SCRO"},{"$f":"IF(Input!W64<>\"\",Input!W64,\"\")","v":"WQS"},{"$f":"IF(Input!W65<>\"\",Input!W65,\"\")","v":"2016-08-01"},{"$f":"IF(Input!I66<>\"\",Input!I66,\"\")","v":"2016-10-30"},{"$f":"IF(Input!W66<>\"\",Input!W66,\"\")","v":"No"},{"$f":"IF(Input!I67<>\"\",Input!I67,\"\")","v":""},{"$f":"IF(Input!W67<>\"\",Input!W67,\"\")","v":true},{"$f":"IF(Input!I68<>\"\",Input!I68,\"\")","v":90},{"$f":"IF(Input!W68<>\"\",Input!W68,\"\")","v":"2017-01-28"},{"$f":"IF(Input!I69<>\"\",Input!I69,\"\")","v":""},{"$f":"IF(Input!W69<>\"\",Input!W69,\"\")","v":""},{"$f":"IF(Input!I70<>\"\",Input!I70,\"\")","v":""},{"$f":"IF(Input!W70<>\"\",Input!W70,\"\")","v":""},{"$f":"IF(Input!I71<>\"\",Input!I71,\"\")","v":""},{"$f":"IF(Input!W71<>\"\",Input!W71,\"\")","v":""},{"$f":"IF(Input!I72<>\"\",Input!I72,\"\")","v":""},{"$f":"IF(Input!W72<>\"\",Input!W72,\"\")","v":""},{"$f":"IF(Input!I73<>\"\",Input!I73,\"\")","v":""},{"$f":"IF(Input!W73<>\"\",Input!W73,\"\")","v":""},{"$f":"IF(Input!I74<>\"\",Input!I74,\"\")","v":""},{"$f":"IF(Input!I75<>\"\",Input!I75,\"\")","v":""},{"$f":"IF(Input!I76<>\"\",Input!I76,\"\")","v":""},{"$f":"IF(Input!W74<>\"\",Input!W74,\"\")","v":""},{"$f":"IF(Input!W75<>\"\",Input!W75,\"\")","v":""},{"$f":"IF(Input!W76<>\"\",Input!W76,\"\")","v":""},{"$f":"IF(Input!I77<>\"\",Input!I77,\"\")","v":""},{"$f":"IF(Input!W77<>\"\",Input!W77,\"\")","v":""},{"$f":"IF(Input!I78<>\"\",Input!I78,\"\")","v":"No"},{"$f":"IF(Input!I79<>\"\",Input!I79,\"\")","v":"This inspection was rescheduled twice due to owner unavailability."},{"$f":"IF(Input!I80<>\"\",Input!I80,\"\")","v":"No MMP or application records.  Sewage sludge imported and land applied on ground separate from manure."},{"$f":"IF(Input!I81<>\"\",Input!I81,\"\")","v":"Conservation plan in place.  Owner indicates it is being followed.  It is however missing maps."},{"$f":"IF(Input!I82<>\"\",Input!I82,\"\")","v":""},{"$f":"IF(Input!I83<>\"\",Input!I83,\"\")","v":"Manure stacked within 5 feet of a sinkhole."},{"$f":"IF(Input!I84<>\"\",Input!I84,\"\")","v":"Owner was advised to check with NRCS for a complete copy of conservation plan with maps."},{"$f":"IF(Input!I85<>\"\",Input!I85,\"\")","v":"Inspector will revisit farm to check on status of MMP."}]

{"sheet":"SelRecordLinks","index":4,"n_rows":80,"n_cols":10,"rows_kept":80,"cut":false,"hidden":true,"merged":[]}
[null,"DB Row",{"$f":"CurrRec+1","v":2}]
[]
[null,"Field","Column","Value",null,null,null,"Field","Column","Value"]
[null,{"$f":"Input!B9","v":"Farm ID"},{"$f":"MATCH(B4,Database!$1:$1,0)","v":3},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,C4)=\"\",\"\",INDEX(PartsDatabase,DB_Row,C4)))","v":"67-999999"},null,null,null,{"$f":"Input!P9","v":"Operation Name"},{"$f":"MATCH(H4,Database!$1:$1,0)","v":4},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,I4)=\"\",\"\",INDEX(PartsDatabase,DB_Row,I4)))","v":"Test Farm"}]
[null,{"$f":"Input!B10","v":"County"},{"$f":"MATCH(B5,Database!$1:$1,0)","v":5},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,C5)=\"\",\"\",INDEX(PartsDatabase,DB_Row,C5)))","v":"York"},null,null,null,{"$f":"Input!P10","v":"Inspection Date"},{"$f":"MATCH(H5,Database!$1:$1,0)","v":7},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,I5)=\"\",\"\",INDEX(PartsDatabase,DB_Row,I5)))","v":"2016-08-01"}]
[null,{"$f":"Input!B11","v":"Municipality"},{"$f":"MATCH(B6,Database!$1:$1,0)","v":6},"Fairview Township",null,null,null,{"$f":"Input!P11","v":"Inspection Type"},{"$f":"MATCH(H6,Database!$1:$1,0)","v":8},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,I6)=\"\",\"\",INDEX(PartsDatabase,DB_Row,I6)))","v":"Initial Inspection"}]
[null,{"$f":"Input!B12","v":"Total Acres of Operation"},{"$f":"MATCH(B7,Database!$1:$1,0)","v":9},100,null,null,null,{"$f":"Input!P12","v":"Latitude"},{"$f":"MATCH(H7,Database!$1:$1,0)","v":10},40.255000000000003]
[null,{"$f":"Input!B13","v":"Mailing Address"},{"$f":"MATCH(B8,Database!$1:$1,0)","v":12},"555 Test Road",null,null,null,{"$f":"Input!P13","v":"Longitude"},{"$f":"MATCH(H8,Database!$1:$1,0)","v":11},76.111000000000004]
[null,{"$f":"Input!B14","v":"Mailing Address City"},{"$f":"MATCH(B9,Database!$1:$1,0)","v":13},"Lewisberry",null,null,null,{"$f":"Input!P14","v":"Home Farm?"},{"$f":"MATCH(H9,Database!$1:$1,0)","v":20},"Yes"]
[null,{"$f":"Input!B15","v":"Mailing Address State"},{"$f":"MATCH(B10,Database!$1:$1,0)","v":14},"PA",null,null,null,{"$f":"Input!P15","v":"Satellite Farm?"},{"$f":"MATCH(H10,Database!$1:$1,0)","v":21},"No"]
[null,{"$f":"Input!B16","v":"Mailing Address Zip"},{"$f":"MATCH(B11,Database!$1:$1,0)","v":15},17339,null,null,null,{"$f":"Input!P16","v":"Rented Fields?"},{"$f":"MATCH(H11,Database!$1:$1,0)","v":22},"No"]
[null,{"$f":"Input!B17","v":"Location Address"},{"$f":"MATCH(B12,Database!$1:$1,0)","v":16},"555 Test Road",null,null,null,{"$f":"Input!P17","v":"Animals On-Site?"},{"$f":"MATCH(H12,Database!$1:$1,0)","v":23},"Yes"]
[null,{"$f":"Input!B18","v":"Location Address City"},{"$f":"MATCH(B13,Database!$1:$1,0)","v":17},"Lewisberry",null,null,null,{"$f":"Input!P18","v":"Animal Type 1"},{"$f":"MATCH(H13,Database!$1:$1,0)","v":24},"Dairy - Holstein/Brown Swiss Cow"]
[null,{"$f":"Input!B19","v":"Location Address State"},{"$f":"MATCH(B14,Database!$1:$1,0)","v":18},"PA",null,null,null,{"$f":"Input!P19","v":"Number - Animal Type 1"},{"$f":"MATCH(H14,Database!$1:$1,0)","v":25},100]
[null,{"$f":"Input!B20","v":"Location Address Zip"},{"$f":"MATCH(B15,Database!$1:$1,0)","v":19},17339,null,null,null,{"$f":"Input!P20","v":"Animal Type 2"},{"$f":"MATCH(H15,Database!$1:$1,0)","v":26},"Dairy - Holstein/Brown Swiss Heifer: 1-2 yr"]
[null,{"$f":"Input!B21","v":"Inspection Scheduled"},{"$f":"MATCH(B16,Database!$1:$1,0)","v":32},"Yes",null,null,null,{"$f":"Input!P21","v":"Number - Animal Type 2"},{"$f":"MATCH(H16,Database!$1:$1,0)","v":27},50]
[null,{"$f":"Input!B22","v":"Owner/Op Not Available"},{"$f":"MATCH(B17,Database!$1:$1,0)","v":33},"No",null,null,null,{"$f":"Input!P22","v":"Animal Type 3"},{"$f":"MATCH(H17,Database!$1:$1,0)","v":28},""]
[null,{"$f":"Input!B23","v":"No Insp. - Biosecurity"},{"$f":"MATCH(B18,Database!$1:$1,0)","v":34},"No",null,null,null,{"$f":"Input!P23","v":"Number - Animal Type 3"},{"$f":"MATCH(H18,Database!$1:$1,0)","v":29},""]
[null,{"$f":"Input!B24","v":"Refused Access"},{"$f":"MATCH(B19,Database!$1:$1,0)","v":35},"No",null,null,null,{"$f":"Input!P24","v":"AEUs"},{"$f":"MATCH(H19,Database!$1:$1,0)","v":30},135]
[null,{"$f":"Input!B25","v":"Interviewed"},{"$f":"MATCH(B20,Database!$1:$1,0)","v":36},"Owner",null,null,null,{"$f":"Input!P25","v":"Crops Only?"},{"$f":"MATCH(H20,Database!$1:$1,0)","v":31},"No"]
[null,{"$f":"Input!B26","v":"Owner Name"},{"$f":"MATCH(B21,Database!$1:$1,0)","v":37},"John Smith",null,null,null,{"$f":"Input!P26","v":"Operator Name"},{"$f":"MATCH(H21,Database!$1:$1,0)","v":38},"John Smith"]
[null,{"$f":"Input!B27","v":"Manure Gen/App On-Site?"},{"$f":"MATCH(B22,Database!$1:$1,0)","v":39},"Yes",null,null,null,{"$f":"Input!P27","v":"Written MMP?"},{"$f":"MATCH(H22,Database!$1:$1,0)","v":40},"No"]
[null,{"$f":"Input!B28","v":"MMP Developed By"},{"$f":"MATCH(B23,Database!$1:$1,0)","v":41},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,C23)=\"\",\"\",INDEX(PartsDatabase,DB_Row,C23)))","v":""},null,null,null,{"$f":"Input!P28","v":"MMP Admin Complete?"},{"$f":"MATCH(H23,Database!$1:$1,0)","v":42},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,I23)=\"\",\"\",INDEX(PartsDatabase,DB_Row,I23)))","v":"N/A"}]
[null,{"$f":"Input!B29","v":"Acres Available for Manure"},{"$f":"MATCH(B24,Database!$1:$1,0)","v":43},"",null,null,null,{"$f":"Input!P29","v":"MMP Planner Name"},{"$f":"MATCH(H24,Database!$1:$1,0)","v":44},""]
[null,"MMP Includes Home Farm?",{"$f":"MATCH(B25,Database!$1:$1,0)","v":45},"",null,null,null,{"$f":"Input!P30","v":"MMP Date"},{"$f":"MATCH(H25,Database!$1:$1,0)","v":48},""]
[null,"MMP Includes Satellite Farm(s)?",{"$f":"MATCH(B26,Database!$1:$1,0)","v":46},"",null,null,null,{"$f":"Input!P31","v":"Manure Exported?"},{"$f":"MATCH(H26,Database!$1:$1,0)","v":58},"No"]
[null,"MMP Includes Rented Fields?",{"$f":"MATCH(B27,Database!$1:$1,0)","v":47},"",null,null,null,{"$f":"Input!P32","v":"Manure Imported?"},{"$f":"MATCH(H27,Database!$1:$1,0)","v":59},"No"]
[null,{"$f":"Input!B33","v":"Manure Storage 1 Type"},{"$f":"MATCH(B28,Database!$1:$1,0)","v":49},"Aboveground Concrete",null,null,null,{"$f":"Input!P33","v":"Nutrient Balance Sheets?"},{"$f":"MATCH(H28,Database!$1:$1,0)","v":60},"N/A"]
[null,{"$f":"Input!B34","v":"Manure Storage 1 Cap (MG)"},{"$f":"MATCH(B29,Database!$1:$1,0)","v":50},0.4,null,null,null,{"$f":"Input!P34","v":"Sewage Sludge Imported?"},{"$f":"MATCH(H29,Database!$1:$1,0)","v":61},"Yes"]
[null,{"$f":"Input!B35","v":"Manure Storage 1 Year"},{"$f":"MATCH(B30,Database!$1:$1,0)","v":51},1971,null,null,null,{"$f":"Input!P35","v":"Manure Stacking?"},{"$f":"MATCH(H30,Database!$1:$1,0)","v":62},"Yes"]
[null,{"$f":"Input!B36","v":"Manure Storage 2 Type"},{"$f":"MATCH(B31,Database!$1:$1,0)","v":52},"",null,null,null,{"$f":"Input!P36","v":"Process Wastewater?"},{"$f":"MATCH(H31,Database!$1:$1,0)","v":63},"No"]
[null,{"$f":"Input!B37","v":"Manure Storage 2 Cap (MG)"},{"$f":"MATCH(B32,Database!$1:$1,0)","v":53},"",null,null,null,{"$f":"Input!P37","v":"Outdoor Feed Storage?"},{"$f":"MATCH(H32,Database!$1:$1,0)","v":64},"Yes"]
[null,{"$f":"Input!B38","v":"Manure Storage 2 Year"},{"$f":"MATCH(B33,Database!$1:$1,0)","v":54},"",null,null,null,{"$f":"Input!P38","v":"AHUA(s) / ACA(s)?"},{"$f":"MATCH(H33,Database!$1:$1,0)","v":65},"Yes"]
[null,{"$f":"Input!B39","v":"Manure Storage 3 Type"},{"$f":"MATCH(B34,Database!$1:$1,0)","v":55},"",null,null,null,{"$f":"Input!P39","v":"MMP Implemented?"},{"$f":"MATCH(H34,Database!$1:$1,0)","v":66},"N/A"]
[null,{"$f":"Input!B40","v":"Manure Storage 3 Cap (MG)"},{"$f":"MATCH(B35,Database!$1:$1,0)","v":56},"",null,null,null,{"$f":"Input!P40","v":"Setbacks Followed?"},{"$f":"MATCH(H35,Database!$1:$1,0)","v":67},"Yes"]
[null,{"$f":"Input!B41","v":"Manure Storage 3 Year"},{"$f":"MATCH(B36,Database!$1:$1,0)","v":57},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,C36)=\"\",\"\",INDEX(PartsDatabase,DB_Row,C36)))","v":""},null,null,null,{"$f":"Input!P41","v":"Manure Records Kept?"},{"$f":"MATCH(H36,Database!$1:$1,0)","v":68},"No"]
[null,{"$f":"Input!B42","v":"Plowing/AHUA(s) On-Site?"},{"$f":"MATCH(B37,Database!$1:$1,0)","v":69},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,C37)=\"\",\"\",INDEX(PartsDatabase,DB_Row,C37)))","v":"Yes"},null,null,null,{"$f":"Input!P42","v":"Written E&S Plan?"},{"$f":"MATCH(H37,Database!$1:$1,0)","v":70},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,I37)=\"\",\"\",INDEX(PartsDatabase,DB_Row,I37)))","v":"Yes"}]
[null,{"$f":"Input!B43","v":"E&S Plan Developed By"},{"$f":"MATCH(B38,Database!$1:$1,0)","v":71},"Agency",null,null,null,{"$f":"Input!P43","v":"E&S Admin Complete?"},{"$f":"MATCH(H38,Database!$1:$1,0)","v":72},"No"]
[null,{"$f":"Input!B44","v":"Acres Covered by E&S Plan"},{"$f":"MATCH(B39,Database!$1:$1,0)","v":73},125,null,null,null,{"$f":"Input!P44","v":"E&S Planner Name"},{"$f":"MATCH(H39,Database!$1:$1,0)","v":74},"NRCS"]
[null,"E&S Includes Home Farm?",{"$f":"MATCH(B40,Database!$1:$1,0)","v":75},"Yes",null,null,null,{"$f":"Input!P45","v":"E&S Plan Date"},{"$f":"MATCH(H40,Database!$1:$1,0)","v":78},"2005-10-01"]
[null,"E&S Includes Satellite Farm(s)?",{"$f":"MATCH(B41,Database!$1:$1,0)","v":76},"No",null,null,null,{"$f":"Input!P46","v":"E&S Plan Implemented?"},{"$f":"MATCH(H41,Database!$1:$1,0)","v":79},"Yes"]
[null,"E&S Includes Rented Fields?",{"$f":"MATCH(B42,Database!$1:$1,0)","v":77},"Yes",null,null,null,{"$f":"Input!P47","v":"No-Till?"},{"$f":"MATCH(H42,Database!$1:$1,0)","v":80},"No"]
[null,"Stream Fencing",{"$f":"MATCH(B43,Database!$1:$1,0)","v":81},false,null,null,null,"Precision Feeding",{"$f":"MATCH(H43,Database!$1:$1,0)","v":87},""]
[null,"Barnyard Runoff Control",{"$f":"MATCH(B44,Database!$1:$1,0)","v":82},false,null,null,null,"Phytase",{"$f":"MATCH(H44,Database!$1:$1,0)","v":88},""]
[null,"Cover Crops",{"$f":"MATCH(B45,Database!$1:$1,0)","v":83},true,null,null,null,"Rotational Grazing",{"$f":"MATCH(H45,Database!$1:$1,0)","v":89},""]
[null,"Streamside Grass Buffers",{"$f":"MATCH(B46,Database!$1:$1,0)","v":84},"",null,null,null,"Retired Lands",{"$f":"MATCH(H46,Database!$1:$1,0)","v":90},""]
[null,"Forest Buffers",{"$f":"MATCH(B47,Database!$1:$1,0)","v":85},"",null,null,null,"Water Control Structure",{"$f":"MATCH(H47,Database!$1:$1,0)","v":91},""]
[null,"Conservation Tillage",{"$f":"MATCH(B48,Database!$1:$1,0)","v":86},true,null,null,null,"Other BMP Description 1",{"$f":"MATCH(H48,Database!$1:$1,0)","v":93},""]
[null,"Other",{"$f":"MATCH(B49,Database!$1:$1,0)","v":92},"",null,null,null,"Other BMP Description 2",{"$f":"MATCH(H49,Database!$1:$1,0)","v":94},""]
[null,"Water Quality Evaluation",{"$f":"MATCH(B50,Database!$1:$1,0)","v":95},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,C50)=\"\",\"\",INDEX(PartsDatabase,DB_Row,C50)))","v":"Other Water Quality Concerns"},null,null,null,"WQ Concern 2",{"$f":"MATCH(H50,Database!$1:$1,0)","v":97},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,I50)=\"\",\"\",INDEX(PartsDatabase,DB_Row,I50)))","v":""}]
[null,"WQ Concern 1",{"$f":"MATCH(B51,Database!$1:$1,0)","v":96},"Stacking Near Stream",null,null,null,"WQ Concern 3",{"$f":"MATCH(H51,Database!$1:$1,0)","v":98},""]
[null,"25 Pa Code 91.36(b) Viol",{"$f":"MATCH(B52,Database!$1:$1,0)","v":99},true,null,null,null,"MMP No. Days to Submit",{"$f":"MATCH(H52,Database!$1:$1,0)","v":100},90]
[null,"25 Pa Code 102.4(a) Viol",{"$f":"MATCH(B53,Database!$1:$1,0)","v":101},"",null,null,null,"E&S No. Days to Submit",{"$f":"MATCH(H53,Database!$1:$1,0)","v":102},""]
[null,"Other Violation",{"$f":"MATCH(B54,Database!$1:$1,0)","v":103},"",null,null,null,"Other Violation Citation",{"$f":"MATCH(H54,Database!$1:$1,0)","v":104},""]
[null,{"$f":"Input!B60","v":"Person Interviewed"},{"$f":"MATCH(B55,Database!$1:$1,0)","v":105},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,C55)=\"\",\"\",INDEX(PartsDatabase,DB_Row,C55)))","v":"John Smith"},null,null,null,{"$f":"Input!P60","v":"Inspector Name"},{"$f":"MATCH(H55,Database!$1:$1,0)","v":111},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,I55)=\"\",\"\",INDEX(PartsDatabase,DB_Row,I55)))","v":"Chuck Schadel"}]
[null,"Interviewee Cell Phone",{"$f":"MATCH(B56,Database!$1:$1,0)","v":106},"717.571.0000",null,null,null,"Inspector Cell Phone",{"$f":"MATCH(H56,Database!$1:$1,0)","v":112},"717.999.9999"]
[null,"Interviewee Other Phone",{"$f":"MATCH(B57,Database!$1:$1,0)","v":107},"",null,null,null,"Inspector Other Phone",{"$f":"MATCH(H57,Database!$1:$1,0)","v":113},""]
[null,"Interviewee Organization",{"$f":"MATCH(B58,Database!$1:$1,0)","v":108},"Test Farm",null,null,null,"Inspector Organization",{"$f":"MATCH(H58,Database!$1:$1,0)","v":114},"DEP SCRO"]
[null,"Interviewee Title",{"$f":"MATCH(B59,Database!$1:$1,0)","v":109},"Owner",null,null,null,"Inspector Title",{"$f":"MATCH(H59,Database!$1:$1,0)","v":115},"WQS"]
[null,"Interviewee Email",{"$f":"MATCH(B60,Database!$1:$1,0)","v":110},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,C60)=\"\",\"\",INDEX(PartsDatabase,DB_Row,C60)))","v":"johnsmith99@hotmail.com"},null,null,null,{"$f":"Input!P65","v":"Date Report Provided"},{"$f":"MATCH(H60,Database!$1:$1,0)","v":116},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,I60)=\"\",\"\",INDEX(PartsDatabase,DB_Row,I60)))","v":42583}]
[null,{"$f":"Input!B66","v":"Original MMP Due Date"},{"$f":"MATCH(B61,Database!$1:$1,0)","v":117},"2016-10-30",null,null,null,{"$f":"Input!P66","v":"MMP Received?"},{"$f":"MATCH(H61,Database!$1:$1,0)","v":118},{"$f":"IF(DB_Row=1,\"\",IF(INDEX(PartsDatabase,DB_Row,I61)=\"\",\"\",INDEX(PartsDatabase,DB_Row,I61)))","v":"No"}]
[null,{"$f":"Input!B67","v":"MMP Received Date"},{"$f":"MATCH(B62,Database!$1:$1,0)","v":119},"",null,null,null,{"$f":"Input!P67","v":"More Time to Submit MMP"},{"$f":"MATCH(H62,Database!$1:$1,0)","v":120},true]
[null,{"$f":"Input!B68","v":"Additional No. Days for MMP"},{"$f":"MATCH(B63,Database!$1:$1,0)","v":121},90,null,null,null,{"$f":"Input!P68","v":"Extended MMP Due Date"},{"$f":"MATCH(H63,Database!$1:$1,0)","v":122},"2017-01-28"]
[null,"MMP Received Date (Extended)",{"$f":"MATCH(B64,Database!$1:$1,0)","v":123},"",null,null,null,"MMP Received (Extended)?",{"$f":"MATCH(H64,Database!$1:$1,0)","v":124},""]
[null,{"$f":"Input!B70","v":"Original E&S Due Date"},{"$f":"MATCH(B65,Database!$1:$1,0)","v":125},"",null,null,null,{"$f":"Input!P70","v":"E&S Received?"},{"$f":"MATCH(H65,Database!$1:$1,0)","v":126},""]
[null,{"$f":"Input!B71","v":"E&S Received Date"},{"$f":"MATCH(B66,Database!$1:$1,0)","v":127},"",null,null,null,{"$f":"Input!P71","v":"More Time to Submit E&S"},{"$f":"MATCH(H66,Database!$1:$1,0)","v":128},""]
[null,{"$f":"Input!B72","v":"Additional No. Days for E&S"},{"$f":"MATCH(B67,Database!$1:$1,0)","v":129},"",null,null,null,{"$f":"Input!P72","v":"Extended E&S Due Date"},{"$f":"MATCH(H67,Database!$1:$1,0)","v":130},""]
[null,"E&S Received Date (Extended)",{"$f":"MATCH(B68,Database!$1:$1,0)","v":131},"",null,null,null,"E&S Received (Extended)?",{"$f":"MATCH(H68,Database!$1:$1,0)","v":132},""]
[null,{"$f":"Input!B74","v":"Follow-Up Action 1"},{"$f":"MATCH(B69,Database!$1:$1,0)","v":133},"",null,null,null,{"$f":"Input!P74","v":"Follow-Up Action 2"},{"$f":"MATCH(H69,Database!$1:$1,0)","v":136},""]
[null,"Follow-Up Action 1 Date",{"$f":"MATCH(B70,Database!$1:$1,0)","v":134},"",null,null,null,"Follow-Up Action 2 Date",{"$f":"MATCH(H70,Database!$1:$1,0)","v":137},""]
[null,"Follow-Up Action 1 Completed By",{"$f":"MATCH(B71,Database!$1:$1,0)","v":135},"",null,null,null,"Follow-Up Action 2 Completed By",{"$f":"MATCH(H71,Database!$1:$1,0)","v":138},""]
[null,"Referral Made to DEP",{"$f":"MATCH(B72,Database!$1:$1,0)","v":139},"",null,null,null,{"$f":"Input!P77","v":"Referral Date"},{"$f":"MATCH(H72,Database!$1:$1,0)","v":140},""]
[null,{"$f":"Input!B78","v":"NRCS Form Provided"},{"$f":"MATCH(B73,Database!$1:$1,0)","v":141},"No"]
[null,{"$f":"Input!B79","v":"General Comments"},{"$f":"MATCH(B74,Database!$1:$1,0)","v":142},"This inspection was rescheduled twice due to owner unavailability."]
[null,{"$f":"Input!B80","v":"MMP Comments"},{"$f":"MATCH(B75,Database!$1:$1,0)","v":143},"No MMP or application records.  Sewage sludge imported and land applied on ground separate from manure."]
[null,{"$f":"Input!B81","v":"E&S Comments"},{"$f":"MATCH(B76,Database!$1:$1,0)","v":144},"Conservation plan in place.  Owner indicates it is being followed.  It is however missing maps."]
[null,{"$f":"Input!B82","v":"BMP Comments"},{"$f":"MATCH(B77,Database!$1:$1,0)","v":145},""]
[null,{"$f":"Input!B83","v":"Water Quality Comments"},{"$f":"MATCH(B78,Database!$1:$1,0)","v":146},"Manure stacked within 5 feet of a sinkhole."]
[null,{"$f":"Input!B84","v":"Additional Comments"},{"$f":"MATCH(B79,Database!$1:$1,0)","v":147},"Owner was advised to check with NRCS for a complete copy of conservation plan with maps."]
[null,{"$f":"Input!B85","v":"Follow-Up Comments"},{"$f":"MATCH(B80,Database!$1:$1,0)","v":148},"Inspector will revisit farm to check on status of MMP."]

{"sheet":"LookupLists","index":5,"n_rows":1380,"n_cols":15,"rows_kept":1380,"cut":false,"hidden":true,"merged":[]}
["Organizations","Counties","County","Municipality","Water_Quality_Evaluation","WQ_Concerns","Follow_Up_Actions","YesNo","YesNoNA","Interviewed","MMP_Planner","ES_Planner","MS_Type","Animal_Types","Inspection_Type"]
["DEP SERO","Adams","Adams","Abbottstown Borough","Pollution Incident","Manure Storage Freeboard","Emailed Owner/Operator","Yes","Yes","Owner","Certified Planner","Consultant","Earthen Impoundment","Dairy - Holstein/Brown Swiss Cow","Initial Inspection"]
["DEP NERO","Bedford","Adams","Arendtsville Borough","Other Water Quality Concerns","Stacking Near Stream","Phone Conversation","No","No","Operator","Owner/Op (w/o assistance)","Owner/Op (w/o assistance)","Lined Impoundment","Dairy - Holstein/Brown Swiss Heifer: 1-2 yr","Follow-Up Inspection"]
["DEP SCRO","Berks","Adams","Bendersville Borough","Not Determined","Silage Leachate Runoff","Left Phone Message",null,"N/A","Other","Owner/Op (w assistance)","Owner/Op (w assistance)","Aboveground Concrete","Dairy - Holstein/Brown Swiss Calf: 0-1 yr"]
["DEP NCRO","Blair","Adams","Berwick Township",null,"Barnyard Runoff","Visited Operation",null,null,null,"Agency","Agency","Aboveground Steel","Dairy - Holstein/Brown Swiss Bull"]
["DEP SWRO","Bradford","Adams","Biglerville Borough",null,"Manure Storage Integrity","Follow-Up Inspection",null,null,null,null,null,"Underbarn Concrete","Dairy - Ayrshire/Guernsey Cow"]
["DEP NWRO","Cambria","Adams","Bonneauville Borough",null,"Animals in Stream","Issued Letter",null,null,null,null,null,"Other","Dairy - Ayrshire/Guernsey Heifer: 1-2 yr"]
["Adams CCD","Cameron","Adams","Butler Township",null,"Wastewater Discharge","Issued NOV",null,null,null,null,null,null,"Dairy - Ayrshire/Guernsey Calf:  0-1 yr"]
["Bedford CCD","Centre","Adams","Carroll Valley Borough",null,"Setbacks Not Observed","Other",null,null,null,null,null,null,"Dairy - Ayrshire/Guernsey Bull"]
["Berks CCD","Chester","Adams","Conewago Township",null,"Other",null,null,null,null,null,null,null,"Dairy - Jersey Cow"]
["Blair CCD","Clearfield","Adams","Cumberland Township",null,null,null,null,null,null," ",null,null,"Dairy - Jersey Heifer: 1-2 yr"]
["Bradford CCD","Clinton","Adams","East Berlin Borough",null,null,null,null,null,null,null,null,null,"Dairy - Jersey Calf:  0-1 yr"]
["Cambria CCD","Columbia","Adams","Fairfield Borough",null,null,null,null,null,null,null,null,null,"Dairy - Jersey Bull"]
["Cameron CCD","Cumberland","Adams","Franklin Township",null,null,null,null,null,null,null,null,null,"Swine Nursery pig"]
["Centre CCD","Dauphin","Adams","Freedom Township",null,null,null,null,null,null,null,null,null,"Swine Wean to finish"]
["Chester CCD","Franklin","Adams","Germany Township",null,null,null,null,null,null,null,null,null,"Swine Grow finish"]
["Clearfield CCD","Fulton","Adams","Gettysburg Borough",null,null,null,null,null,null,null,null,null,"Swine Gestating sow"]
["Clinton CCD","Huntingdon","Adams","Hamilton Township",null,null,null,null,null,null,null,null,null,"Swine Sow and litter"]
["Columbia CCD","Juniata","Adams","Hamiltonban Township",null,null,null,null,null,null,null,null,null,"Swine Boar"]
["Cumberland CCD","Lackawanna","Adams","Highland Township",null,null,null,null,null,null,null,null,null,"Poultry Layer: 18–65 wk"]
["Dauphin CCD","Lancaster","Adams","Huntington Township",null,null,null,null,null,null,null,null,null,"Poultry Layer: 18–105 wk"]
["Franklin CCD","Lebanon","Adams","Latimore Township",null,null,null,null,null,null,null,null,null,"Poultry Layer, brown egg: 20–65 wk"]
["Fulton CCD","Luzerne","Adams","Liberty Township",null,null,null,null,null,null,null,null,null,"Poultry Layer, brown egg: 20–105 wk"]
["Huntingdon CCD","Lycoming","Adams","Littlestown Borough",null,null,null,null,null,null,null,null,null,"Poultry Pullet: 0–18 wk"]
["Juniata CCD","Mifflin","Adams","McSherrystown Borough",null,null,null,null,null,null,null,null,null,"Poultry Broiler, large: 0–53 days"]
["Lackawanna CCD","Montour","Adams","Menallen Township",null,null,null,null,null,null,null,null,null,"Poultry Broiler, medium: 0–35 days"]
["Lancaster CCD","Northumberland","Adams","Mount Joy Township",null,null,null,null,null,null,null,null,null,"Poultry Roaster - Male: 0–7 wk"]
["Lebanon CCD","Perry","Adams","Mount Pleasant Township",null,null,null,null,null,null,null,null,null,"Poultry Roaster - Female: 0–9 wk"]
["Luzerne CCD","Potter","Adams","New Oxford Borough",null,null,null,null,null,null,null,null,null,"Poultry Turkey, tom: 0–18 wk"]
["Lycoming CCD","Schuylkill","Adams","Oxford Township",null,null,null,null,null,null,null,null,null,"Poultry Turkey, hen: 0–12 wk"]
["Mifflin CCD","Snyder","Adams","Reading Township",null,null,null,null,null,null,null,null,null,"Poultry Duck: 0–43 days"]
["Montour CCD","Somerset","Adams","Straban Township",null,null,null,null,null,null,null,null,null,"Poultry Guinea: 0–14 to 24 wk"]
["Northumberland CCD","Sullivan","Adams","Tyrone Township",null,null,null,null,null,null,null,null,null,"Poultry Pheasant: 0–13 to 43 wk"]
["Perry CCD","Susquehanna","Adams","Union Township",null,null,null,null,null,null,null,null,null,"Poultry Chukar: 0–13 to 43 wk"]
["Potter CCD","Tioga","Adams","York Springs Borough",null,null,null,null,null,null,null,null,null,"Poultry Quail: 0–13 to 43 wk"]
["Schuylkill CCD","Union","Bedford","Bedford Borough",null,null,null,null,null,null,null,null,null,"Beef Calf: 0–8 mo"]
["Snyder CCD","Wyoming","Bedford","Bedford Township",null,null,null,null,null,null,null,null,null,"Beef Finishing: 8–24 mo"]
["Somerset CCD","York","Bedford","Bloomfield Township",null,null,null,null,null,null,null,null,null,"Beef Cow"]
["Sullivan CCD",null,"Bedford","Broad Top Township",null,null,null,null,null,null,null,null,null,"Beef Bull"]
["Susquehanna CCD",null,"Bedford","Coaldale Borough",null,null,null,null,null,null,null,null,null,"Veal Calf: 0–20 wk"]
["Tioga CCD",null,"Bedford","Colerain Township",null,null,null,null,null,null,null,null,null,"Larger Breed Sheep Lamb: 0–1 yr"]
["Union CCD",null,"Bedford","Cumberland Valley Township",null,null,null,null,null,null,null,null,null,"Larger Breed Sheep Ewe"]
["Wyoming CCD",null,"Bedford","East Providence Township",null,null,null,null,null,null,null,null,null,"Larger Breed Sheep Ram"]
["York CCD",null,"Bedford","East Saint Clair Township",null,null,null,null,null,null,null,null,null,"Smaller Breed Sheep Lamb: 0–1 yr"]
[null,null,"Bedford","Everett Borough",null,null,null,null,null,null,null,null,null,"Smaller Breed Sheep Ewe"]
[null,null,"Bedford","Harrison Township",null,null,null,null,null,null,null,null,null,"Smaller Breed Sheep Ram"]
[null,null,"Bedford","Hopewell Borough",null,null,null,null,null,null,null,null,null,"Meat Goats Kid: 0–1 yr"]
[null,null,"Bedford","Hopewell Township",null,null,null,null,null,null,null,null,null,"Meat Goats Doe"]
[null,null,"Bedford","Hyndman Borough",null,null,null,null,null,null,null,null,null,"Meat Goats Buck"]
[null,null,"Bedford","Juniata Township",null,null,null,null,null,null,null,null,null,"Dairy GoatsKid: 0–1 yr"]
[null,null,"Bedford","Kimmel Township",null,null,null,null,null,null,null,null,null,"Dairy GoatsDoe"]
[null,null,"Bedford","King Township",null,null,null,null,null,null,null,null,null,"Dairy GoatsBuck"]
[null,null,"Bedford","Liberty Township",null,null,null,null,null,null,null,null,null,"Miniature Horses and Miniature Donkeys Foal: 0–6 mo"]
[null,null,"Bedford","Lincoln Township",null,null,null,null,null,null,null,null,null,"Miniature Horses and Miniature Donkeys Weanling: 6–12 mo"]
[null,null,"Bedford","Londonderry Township",null,null,null,null,null,null,null,null,null,"Miniature Horses and Miniature Donkeys Yearling: 12–24 mo"]
[null,null,"Bedford","Mann Township",null,null,null,null,null,null,null,null,null,"Miniature Horses and Miniature Donkeys Two-Year-Old: 24–36 mo"]
[null,null,"Bedford","Manns Choice Borough",null,null,null,null,null,null,null,null,null,"Miniature Horses and Miniature Donkeys Mature"]
["Stream Fencing",null,"Bedford","Monroe Township",null,null,null,null,null,null,null,null,null,"Ponies and Donkeys Foal: 0–6 mo"]
["Barnyard Runoff",null,"Bedford","Napier Township",null,null,null,null,null,null,null,null,null,"Ponies and Donkeys Weanling: 6–12 mo"]
["Cover Crops",null,"Bedford","New Paris Borough",null,null,null,null,null,null,null,null,null,"Ponies and Donkeys Yearling: 12–24 mo"]
["Grass Buffers",null,"Bedford","Pavia Township",null,null,null,null,null,null,null,null,null,"Ponies and Donkeys Two-Year-Old: 24–36 mo"]
["Forest Buffers",null,"Bedford","Pleasantville Borough",null,null,null,null,null,null,null,null,null,"Ponies and Donkeys Mature"]
["Conservation Tillage",null,"Bedford","Rainsburg Borough",null,null,null,null,null,null,null,null,null,"Light Horses and Mules Foal: 0–6 mo"]
["Precision Feeding",null,"Bedford","Saint Clairsville Borough",null,null,null,null,null,null,null,null,null,"Light Horses and Mules Weanling: 6–12 mo"]
["Phytase",null,"Bedford","Saxton Borough",null,null,null,null,null,null,null,null,null,"Light Horses and Mules Yearling: 12–24 mo"]
["Rotational Grazing",null,"Bedford","Schellsburg Borough",null,null,null,null,null,null,null,null,null,"Light Horses and Mules Two Year Old: 24–36 mo"]
["Retired Lands",null,"Bedford","Snake Spring Township",null,null,null,null,null,null,null,null,null,"Light Horses and Mules Mature"]
["Water Control Structure",null,"Bedford","South Woodbury Township",null,null,null,null,null,null,null,null,null,"Draft Horses Foal: 0–6 mo"]
["Other",null,"Bedford","Southampton Township",null,null,null,null,null,null,null,null,null,"Draft Horses Weanling: 6–12 mo"]
[null,null,"Bedford","West Providence Township",null,null,null,null,null,null,null,null,null,"Draft Horses Yearling: 12–24 mo"]
["Water Quality",null,"Bedford","West Saint Clair Township",null,null,null,null,null,null,null,null,null,"Draft Horses Two Year Old: 24–36 mo"]
[null,null,"Bedford","Woodbury Borough",null,null,null,null,null,null,null,null,null,"Draft Horses Mature"]
["91.36(b)",null,"Bedford","Woodbury Township",null,null,null,null,null,null,null,null,null,"Bison Calf: 0–1 yr"]
["102.4(a)",null,"Berks","Adamstown Borough",null,null,null,null,null,null,null,null,null,"Bison Cow"]
["Other",null,"Berks","Albany Township",null,null,null,null,null,null,null,null,null,"Bison Bull"]
["Submit MMP",null,"Berks","Alsace Township",null,null,null,null,null,null,null,null,null,"Deer Fawn: 0–6 mo"]
["Submit Ag E&S",null,"Berks","Amity Township",null,null,null,null,null,null,null,null,null,"Deer Yearling Doe: 6–18 mo"]
["Other",null,"Berks","Bally Borough",null,null,null,null,null,null,null,null,null,"Deer Yearling Buck: 6–18 mo"]
[null,null,"Berks","Bechtelsville Borough",null,null,null,null,null,null,null,null,null,"Deer Mature Doe"]
["Referral to DEP",null,"Berks","Bern Township",null,null,null,null,null,null,null,null,null,"Deer Mature Buck"]
["NRCS Form",null,"Berks","Bernville Borough",null,null,null,null,null,null,null,null,null,"Alpaca Young"]
[null,null,"Berks","Bethel Township",null,null,null,null,null,null,null,null,null,"Alpaca Mature Female"]
["Add Time for MMP",null,"Berks","Birdsboro Borough",null,null,null,null,null,null,null,null,null,"Alpaca Mature Male"]
["Add Time for E&S",null,"Berks","Boyertown Borough",null,null,null,null,null,null,null,null,null,"Llama Cria: 0–1 yr"]
[null,null,"Berks","Brecknock Township",null,null,null,null,null,null,null,null,null,"Llama Yearling: 1–3 yr"]
[null,null,"Berks","Caernarvon Township",null,null,null,null,null,null,null,null,null,"Llama Mature"]
[null,null,"Berks","Centerport Borough",null,null,null,null,null,null,null,null,null,"Other"]
[null,null,"Berks","Centre Township"]
[null,null,"Berks","Colebrookdale Township"]
[null,null,"Berks","Cumru Township"]
[null,null,"Berks","District Township"]
[null,null,"Berks","Douglass Township"]
[null,null,"Berks","Earl Township"]
[null,null,"Berks","Exeter Township"]
[null,null,"Berks","Fleetwood Borough"]
[null,null,"Berks","Greenwich Township"]
[null,null,"Berks","Hamburg Borough"]
[null,null,"Berks","Heidelberg Township"]
[null,null,"Berks","Hereford Township"]
[null,null,"Berks","Jefferson Township"]
[null,null,"Berks","Kenhorst Borough"]
[null,null,"Berks","Kutztown Borough"]
[null,null,"Berks","Laureldale Borough"]
[null,null,"Berks","Leesport Borough"]
[null,null,"Berks","Lenhartsville Borough"]
[null,null,"Berks","Longswamp Township"]
[null,null,"Berks","Lower Alsace Township"]
[null,null,"Berks","Lower Heidelberg Township"]
[null,null,"Berks","Lyons Borough"]
[null,null,"Berks","Maidencreek Township"]
[null,null,"Berks","Marion Township"]
[null,null,"Berks","Maxatawny Township"]
[null,null,"Berks","Mohnton Borough"]
[null,null,"Berks","Mount Penn Borough"]
[null,null,"Berks","Muhlenberg Township"]
[null,null,"Berks","New Morgan Borough"]
[null,null,"Berks","North Heidelberg Township"]
[null,null,"Berks","Oley Township"]
[null,null,"Berks","Ontelaunee Township"]
[null,null,"Berks","Penn Township"]
[null,null,"Berks","Perry Township"]
[null,null,"Berks","Pike Township"]
[null,null,"Berks","Reading City"]
[null,null,"Berks","Richmond Township"]
[null,null,"Berks","Robeson Township"]
[null,null,"Berks","Robesonia Borough"]
[null,null,"Berks","Rockland Township"]
[null,null,"Berks","Ruscombmanor Township"]
[null,null,"Berks","Saint Lawrence Borough"]
[null,null,"Berks","Shillington Borough"]
[null,null,"Berks","Shoemakersville Borough"]
[null,null,"Berks","Sinking Spring Borough"]
[null,null,"Berks","South Heidelberg Township"]
[null,null,"Berks","Spring Township"]
[null,null,"Berks","Strausstown Borough"]
[null,null,"Berks","Tilden Township"]
[null,null,"Berks","Topton Borough"]
[null,null,"Berks","Tulpehocken Township"]
[null,null,"Berks","Union Township"]
[null,null,"Berks","Upper Bern Township"]
[null,null,"Berks","Upper Tulpehocken Township"]
[null,null,"Berks","Washington Township"]
[null,null,"Berks","Wernersville Borough"]
[null,null,"Berks","West Reading Borough"]
[null,null,"Berks","Windsor Township"]
[null,null,"Berks","Womelsdorf Borough"]
[null,null,"Berks","Wyomissing Borough"]
[null,null,"Blair","Allegheny Township"]
[null,null,"Blair","Altoona City"]
[null,null,"Blair","Antis Township"]
[null,null,"Blair","Bellwood Borough"]
[null,null,"Blair","Blair Township"]
[null,null,"Blair","Catharine Township"]
[null,null,"Blair","Duncansville Borough"]
[null,null,"Blair","Frankstown Township"]
[null,null,"Blair","Freedom Township"]
[null,null,"Blair","Greenfield Township"]
[null,null,"Blair","Hollidaysburg Borough"]
[null,null,"Blair","Huston Township"]
[null,null,"Blair","Juniata Township"]
[null,null,"Blair","Logan Township"]
[null,null,"Blair","Martinsburg Borough"]
[null,null,"Blair","Newry Borough"]
[null,null,"Blair","North Woodbury Township"]
[null,null,"Blair","Roaring Spring Borough"]
[null,null,"Blair","Snyder Township"]
[null,null,"Blair","Taylor Township"]
[null,null,"Blair","Tunnelhill Borough"]
[null,null,"Blair","Tyrone Borough"]
[null,null,"Blair","Tyrone Township"]
[null,null,"Blair","Williamsburg Borough"]
[null,null,"Blair","Woodbury Township"]
[null,null,"Bradford","Alba Borough"]
[null,null,"Bradford","Albany Township"]
[null,null,"Bradford","Armenia Township"]
[null,null,"Bradford","Asylum Township"]
[null,null,"Bradford","Athens Borough"]
[null,null,"Bradford","Athens Township"]
[null,null,"Bradford","Burlington Borough"]
[null,null,"Bradford","Burlington Township"]
[null,null,"Bradford","Canton Borough"]
[null,null,"Bradford","Canton Township"]
[null,null,"Bradford","Columbia Township"]
[null,null,"Bradford","Franklin Township"]
[null,null,"Bradford","Granville Township"]
[null,null,"Bradford","Herrick Township"]
[null,null,"Bradford","LeRaysville Borough"]
[null,null,"Bradford","Leroy Township"]
[null,null,"Bradford","Litchfield Township"]
[null,null,"Bradford","Monroe Borough"]
[null,null,"Bradford","Monroe Township"]
[null,null,"Bradford","New Albany Borough"]
[null,null,"Bradford","North Towanda Township"]
[null,null,"Bradford","Orwell Township"]
[null,null,"Bradford","Overton Township"]
[null,null,"Bradford","Pike Township"]
[null,null,"Bradford","Ridgebury Township"]
[null,null,"Bradford","Rome Borough"]
[null,null,"Bradford","Rome Township"]
[null,null,"Bradford","Sayre Borough"]
[null,null,"Bradford","Sheshequin Township"]
[null,null,"Bradford","Smithfield Township"]
[null,null,"Bradford","South Creek Township"]
[null,null,"Bradford","South Waverly Borough"]
[null,null,"Bradford","Springfield Township"]
[null,null,"Bradford","Standing Stone Township"]
[null,null,"Bradford","Stevens Township"]
[null,null,"Bradford","Sylvania Borough"]
[null,null,"Bradford","Terry Township"]
[null,null,"Bradford","Towanda Borough"]
[null,null,"Bradford","Towanda Township"]
[null,null,"Bradford","Troy Borough"]
[null,null,"Bradford","Troy Township"]
[null,null,"Bradford","Tuscarora Township"]
[null,null,"Bradford","Ulster Township"]
[null,null,"Bradford","Warren Township"]
[null,null,"Bradford","Wells Township"]
[null,null,"Bradford","West Burlington Township"]
[null,null,"Bradford","Wilmot Township"]
[null,null,"Bradford","Windham Township"]
[null,null,"Bradford","Wyalusing Borough"]
[null,null,"Bradford","Wyalusing Township"]
[null,null,"Bradford","Wysox Township"]
[null,null,"Cambria","Johnstown  City"]
[null,null,"Cambria","Cresson Borough"]
[null,null,"Cambria","Dale Borough"]
[null,null,"Cambria","Ebensburg Borough"]
[null,null,"Cambria","Ferndale Borough"]
[null,null,"Cambria","Gallitzin Borough"]
[null,null,"Cambria","Geistown Borough"]
[null,null,"Cambria","Patton Borough"]
[null,null,"Cambria","Portage Borough"]
[null,null,"Cambria","Southmont Borough"]
[null,null,"Cambria","Stonycreek Township"]
[null,null,"Cambria","Westmont Borough"]
[null,null,"Cambria","Adams Township"]
[null,null,"Cambria","Ashville Borough"]
[null,null,"Cambria","Barr Township"]
[null,null,"Cambria","Blacklick Township"]
[null,null,"Cambria","Brownstown Borough"]
[null,null,"Cambria","Cambria Township"]
[null,null,"Cambria","Carrolltown Borough"]
[null,null,"Cambria","Cassandra Borough"]
[null,null,"Cambria","Chest Springs Borough"]
[null,null,"Cambria","Chest Township"]
[null,null,"Cambria","Clearfield Township"]
[null,null,"Cambria","Conemaugh Township"]
[null,null,"Cambria","Cresson Township"]
[null,null,"Cambria","Croyle Township"]
[null,null,"Cambria","Daisytown Borough"]
[null,null,"Cambria","Dean Township"]
[null,null,"Cambria","East Carroll Township"]
[null,null,"Cambria","East Taylor Township"]
[null,null,"Cambria","Ehrenfeld Borough"]
[null,null,"Cambria","Elder Township"]
[null,null,"Cambria","Franklin Borough"]
[null,null,"Cambria","Gallitzin Township"]
[null,null,"Cambria","Hastings Borough"]
[null,null,"Cambria","Jackson Township"]
[null,null,"Cambria","Lilly Borough"]
[null,null,"Cambria","Lorain Borough"]
[null,null,"Cambria","Loretto Borough"]
[null,null,"Cambria","Lower Yoder Township"]
[null,null,"Cambria","Middle Taylor Township"]
[null,null,"Cambria","Munster Township"]
[null,null,"Cambria","Reade Township"]
[null,null,"Cambria","Richland Township"]
[null,null,"Cambria","Sankertown Borough"]
[null,null,"Cambria","South Fork Borough"]
[null,null,"Cambria","Summerhill Borough"]
[null,null,"Cambria","Summerhill Township"]
[null,null,"Cambria","Upper Yoder Township"]
[null,null,"Cambria","Vintondale Borough"]
[null,null,"Cambria","Washington Township"]
[null,null,"Cambria","West Carroll Township"]
[null,null,"Cambria","White Township"]
[null,null,"Cambria","Wilmore Borough"]
[null,null,"Cameron","Driftwood Borough"]
[null,null,"Cameron","Emporium Borough"]
[null,null,"Cameron","Gibson Township"]
[null,null,"Cameron","Grove Township"]
[null,null,"Cameron","Lumber Township"]
[null,null,"Cameron","Portage Township"]
[null,null,"Cameron","Shippen Township"]
[null,null,"Centre","Bellefonte Borough"]
[null,null,"Centre","Benner Township"]
[null,null,"Centre","Boggs Township"]
[null,null,"Centre","Burnside Township"]
[null,null,"Centre","Centre Hall Borough"]
[null,null,"Centre","College Township"]
[null,null,"Centre","Curtin Township"]
[null,null,"Centre","Ferguson Township"]
[null,null,"Centre","Gregg Township"]
[null,null,"Centre","Haines Township"]
[null,null,"Centre","Halfmoon Township"]
[null,null,"Centre","Harris Township"]
[null,null,"Centre","Howard Borough"]
[null,null,"Centre","Howard Township"]
[null,null,"Centre","Huston Township"]
[null,null,"Centre","Liberty Township"]
[null,null,"Centre","Marion Township"]
[null,null,"Centre","Miles Township"]
[null,null,"Centre","Milesburg Borough"]
[null,null,"Centre","Millheim Borough"]
[null,null,"Centre","Patton Township"]
[null,null,"Centre","Penn Township"]
[null,null,"Centre","Philipsburg Borough"]
[null,null,"Centre","Port Matilda Borough"]
[null,null,"Centre","Potter Township"]
[null,null,"Centre","Rush Township"]
[null,null,"Centre","Snow Shoe Borough"]
[null,null,"Centre","Snow Shoe Township"]
[null,null,"Centre","Spring Township"]
[null,null,"Centre","State College Borough"]
[null,null,"Centre","Taylor Township"]
[null,null,"Centre","Union Township"]
[null,null,"Centre","Unionville Borough"]
[null,null,"Centre","Walker Township"]
[null,null,"Centre","Worth Township"]
[null,null,"Chester","Coatesville City"]
[null,null,"Chester","Phoenixville Borough"]
[null,null,"Chester","West Chester Borough"]
[null,null,"Chester","Downingtown Borough"]
[null,null,"Chester","Kennett Square Borough"]
[null,null,"Chester","Oxford Borough"]
[null,null,"Chester","Parkesburg Borough"]
[null,null,"Chester","Spring City Borough"]
[null,null,"Chester","Atglen Borough"]
[null,null,"Chester","Avondale Borough"]
[null,null,"Chester","Birmingham Township"]
[null,null,"Chester","Caln Township"]
[null,null,"Chester","Charlestown Township"]
[null,null,"Chester","East Bradford Township"]
[null,null,"Chester","East Brandywine Township"]
[null,null,"Chester","East Caln Township"]
[null,null,"Chester","East Fallowfield Township"]
[null,null,"Chester","East Goshen Township"]
[null,null,"Chester","East Marlborough Township"]
[null,null,"Chester","East Nantmeal Township"]
[null,null,"Chester","East Pikeland Township"]
[null,null,"Chester","East Vincent Township"]
[null,null,"Chester","East Whiteland Township"]
[null,null,"Chester","Easttown Township"]
[null,null,"Chester","Elverson Borough"]
[null,null,"Chester","Franklin Township"]
[null,null,"Chester","Honey Brook Borough"]
[null,null,"Chester","Honey Brook Township"]
[null,null,"Chester","Kennett Township"]
[null,null,"Chester","London Grove Township"]
[null,null,"Chester","Londonderry Township"]
[null,null,"Chester","Lower Oxford Township"]
[null,null,"Chester","Malvern Borough"]
[null,null,"Chester","Modena Borough"]
[null,null,"Chester","New Garden Township"]
[null,null,"Chester","New London Township"]
[null,null,"Chester","Newlin Township"]
[null,null,"Chester","North Coventry Township"]
[null,null,"Chester","Penn Township"]
[null,null,"Chester","Pennsbury Township"]
[null,null,"Chester","Pocopson Township"]
[null,null,"Chester","Sadsbury Township"]
[null,null,"Chester","Schuylkill Township"]
[null,null,"Chester","South Coatesville Borough"]
[null,null,"Chester","South Coventry Township"]
[null,null,"Chester","Thornbury Township"]
[null,null,"Chester","Tredyffrin Township"]
[null,null,"Chester","Upper Oxford Township"]
[null,null,"Chester","Upper Uwchlan Township"]
[null,null,"Chester","Uwchlan Township"]
[null,null,"Chester","Valley Township"]
[null,null,"Chester","Wallace Township"]
[null,null,"Chester","Warwick Township"]
[null,null,"Chester","West Bradford Township"]
[null,null,"Chester","West Brandywine Township"]
[null,null,"Chester","West Caln Township"]
[null,null,"Chester","West Fallowfield Township"]
[null,null,"Chester","West Goshen Township"]
[null,null,"Chester","West Marlborough Township"]
[null,null,"Chester","West Nantmeal Township"]
[null,null,"Chester","West Nottingham Township"]
[null,null,"Chester","West Pikeland Township"]
[null,null,"Chester","West Vincent Township"]
[null,null,"Chester","West Whiteland Township"]
[null,null,"Chester","Westtown Township"]
[null,null,"Clearfield","Beccaria Township"]
[null,null,"Clearfield","Bell Township"]
[null,null,"Clearfield","Bigler Township"]
[null,null,"Clearfield","Bloom Township"]
[null,null,"Clearfield","Boggs Township"]
[null,null,"Clearfield","Bradford Township"]
[null,null,"Clearfield","Brady Township"]
[null,null,"Clearfield","Brisbin Borough"]
[null,null,"Clearfield","Burnside Township"]
[null,null,"Clearfield","Burnside Borough"]
[null,null,"Clearfield","Chest Township"]
[null,null,"Clearfield","Chester Hill Borough"]
[null,null,"Clearfield","Clearfield Borough"]
[null,null,"Clearfield","Coalport Borough"]
[null,null,"Clearfield","Cooper Township"]
[null,null,"Clearfield","Covington Township"]
[null,null,"Clearfield","Curwensville Borough"]
[null,null,"Clearfield","Decatur Township"]
[null,null,"Clearfield","DuBois City"]
[null,null,"Clearfield","Falls Creek Borough"]
[null,null,"Clearfield","Ferguson Township"]
[null,null,"Clearfield","Girard Township"]
[null,null,"Clearfield","Glen Hope Borough"]
[null,null,"Clearfield","Goshen Township"]
[null,null,"Clearfield","Graham Township"]
[null,null,"Clearfield","Grampian Borough"]
[null,null,"Clearfield","Greenwood Township"]
[null,null,"Clearfield","Gulich Township"]
[null,null,"Clearfield","Houtzdale Borough"]
[null,null,"Clearfield","Huston Township"]
[null,null,"Clearfield","Irvona Borough"]
[null,null,"Clearfield","Jordan Township"]
[null,null,"Clearfield","Karthaus Township"]
[null,null,"Clearfield","Knox Township"]
[null,null,"Clearfield","Lawrence Township"]
[null,null,"Clearfield","Lumber City Borough"]
[null,null,"Clearfield","Mahaffey Borough"]
[null,null,"Clearfield","Morris Township"]
[null,null,"Clearfield","New Washington Borough"]
[null,null,"Clearfield","Newburg Borough"]
[null,null,"Clearfield","Osceola Mills Borough"]
[null,null,"Clearfield","Penn Township"]
[null,null,"Clearfield","Pike Township"]
[null,null,"Clearfield","Pine Township"]
[null,null,"Clearfield","Ramey Borough"]
[null,null,"Clearfield","Sandy Township"]
[null,null,"Clearfield","Troutville Borough"]
[null,null,"Clearfield","Union Township"]
[null,null,"Clearfield","Wallaceton Borough"]
[null,null,"Clearfield","Westover Borough"]
[null,null,"Clearfield","Woodward Township"]
[null,null,"Clinton","Allison Township"]
[null,null,"Clinton","Avis Borough"]
[null,null,"Clinton","Bald Eagle Township"]
[null,null,"Clinton","Beech Creek Borough"]
[null,null,"Clinton","Beech Creek Township"]
[null,null,"Clinton","Castanea Township"]
[null,null,"Clinton","Chapman Township"]
[null,null,"Clinton","Colebrook Township"]
[null,null,"Clinton","Crawford Township"]
[null,null,"Clinton","Dunnstable Township"]
[null,null,"Clinton","East Keating Township"]
[null,null,"Clinton","Flemington Borough"]
[null,null,"Clinton","Gallagher Township"]
[null,null,"Clinton","Greene Township"]
[null,null,"Clinton","Grugan Township"]
[null,null,"Clinton","Lamar Township"]
[null,null,"Clinton","Leidy Township"]
[null,null,"Clinton","Lock Haven City"]
[null,null,"Clinton","Logan Township"]
[null,null,"Clinton","Loganton Borough"]
[null,null,"Clinton","Mill Hall Borough"]
[null,null,"Clinton","Noyes Township"]
[null,null,"Clinton","Pine Creek Township"]
[null,null,"Clinton","Porter Township"]
[null,null,"Clinton","Renovo Borough"]
[null,null,"Clinton","South Renovo Borough"]
[null,null,"Clinton","Wayne Township"]
[null,null,"Clinton","West Keating Township"]
[null,null,"Clinton","Woodward Township"]
[null,null,"Columbia","Ashland Borough"]
[null,null,"Columbia","Beaver Township"]
[null,null,"Columbia","Benton Borough"]
[null,null,"Columbia","Benton Township"]
[null,null,"Columbia","Berwick Borough"]
[null,null,"Columbia","Bloomsburg Town"]
[null,null,"Columbia","Briar Creek Borough"]
[null,null,"Columbia","Briar Creek Township"]
[null,null,"Columbia","Catawissa Borough"]
[null,null,"Columbia","Catawissa Township"]
[null,null,"Columbia","Centralia Borough"]
[null,null,"Columbia","Cleveland Township"]
[null,null,"Columbia","Conyngham Township"]
[null,null,"Columbia","Fishing Creek Township"]
[null,null,"Columbia","Franklin Township"]
[null,null,"Columbia","Greenwood Township"]
[null,null,"Columbia","Hemlock Township"]
[null,null,"Columbia","Jackson Township"]
[null,null,"Columbia","Locust Township"]
[null,null,"Columbia","Madison Township"]
[null,null,"Columbia","Main Township"]
[null,null,"Columbia","Mifflin Township"]
[null,null,"Columbia","Millville Borough"]
[null,null,"Columbia","Montour Township"]
[null,null,"Columbia","Mount Pleasant Township"]
[null,null,"Columbia","North Centre Township"]
[null,null,"Columbia","Orange Township"]
[null,null,"Columbia","Orangeville Borough"]
[null,null,"Columbia","Pine Township"]
[null,null,"Columbia","Roaring Creek Township"]
[null,null,"Columbia","Scott Township"]
[null,null,"Columbia","South Centre Township"]
[null,null,"Columbia","Stillwater Borough"]
[null,null,"Columbia","Sugarloaf Township"]
[null,null,"Cumberland","Camp Hill Borough"]
[null,null,"Cumberland","Carlisle Borough"]
[null,null,"Cumberland","Cooke Township"]
[null,null,"Cumberland","Dickinson Township"]
[null,null,"Cumberland","East Pennsboro Township"]
[null,null,"Cumberland","Hampden Township"]
[null,null,"Cumberland","Hopewell Township"]
[null,null,"Cumberland","Lemoyne Borough"]
[null,null,"Cumberland","Lower Allen Township"]
[null,null,"Cumberland","Lower Frankford Township"]
[null,null,"Cumberland","Lower Mifflin Township"]
[null,null,"Cumberland","Mechanicsburg Borough"]
[null,null,"Cumberland","Middlesex Township"]
[null,null,"Cumberland","Monroe Township"]
[null,null,"Cumberland","Mount Holly Springs Borough"]
[null,null,"Cumberland","New Cumberland Borough"]
[null,null,"Cumberland","Newburg Borough"]
[null,null,"Cumberland","Newville Borough"]
[null,null,"Cumberland","North Middleton Township"]
[null,null,"Cumberland","North Newton Township"]
[null,null,"Cumberland","Penn Township"]
[null,null,"Cumberland","Shippensburg Borough"]
[null,null,"Cumberland","Shippensburg Township"]
[null,null,"Cumberland","Shiremanstown Borough"]
[null,null,"Cumberland","Silver Spring Township"]
[null,null,"Cumberland","South Middleton Township"]
[null,null,"Cumberland","South Newton Township"]
[null,null,"Cumberland","Southampton Township"]
[null,null,"Cumberland","Upper Allen Township"]
[null,null,"Cumberland","Upper Frankford Township"]
[null,null,"Cumberland","Upper Mifflin Township"]
[null,null,"Cumberland","West Pennsboro Township"]
[null,null,"Cumberland","Wormleysburg Borough"]
[null,null,"Dauphin","Berrysburg Borough"]
[null,null,"Dauphin","Conewago Township"]
[null,null,"Dauphin","Dauphin Borough"]
[null,null,"Dauphin","Derry Township"]
[null,null,"Dauphin","East Hanover Township"]
[null,null,"Dauphin","Elizabethville Borough"]
[null,null,"Dauphin","Gratz Borough"]
[null,null,"Dauphin","Halifax Township"]
[null,null,"Dauphin","Halifax Borough"]
[null,null,"Dauphin","Harrisburg City"]
[null,null,"Dauphin","Highspire Borough"]
[null,null,"Dauphin","Hummelstown Borough"]
[null,null,"Dauphin","Jackson Township"]
[null,null,"Dauphin","Jefferson Township"]
[null,null,"Dauphin","Londonderry Township"]
[null,null,"Dauphin","Lower Paxton Township"]
[null,null,"Dauphin","Lower Swatara Township"]
[null,null,"Dauphin","Lykens Borough"]
[null,null,"Dauphin","Lykens Township"]
[null,null,"Dauphin","Middle Paxton Township"]
[null,null,"Dauphin","Middletown Borough"]
[null,null,"Dauphin","Mifflin Township"]
[null,null,"Dauphin","Millersburg Borough"]
[null,null,"Dauphin","Paxtang Borough"]
[null,null,"Dauphin","Penbrook Borough"]
[null,null,"Dauphin","Pillow Borough"]
[null,null,"Dauphin","Reed Township"]
[null,null,"Dauphin","Royalton Borough"]
[null,null,"Dauphin","Rush Township"]
[null,null,"Dauphin","South Hanover Township"]
[null,null,"Dauphin","Steelton Borough"]
[null,null,"Dauphin","Susquehanna Township"]
[null,null,"Dauphin","Swatara Township"]
[null,null,"Dauphin","Upper Paxton Township"]
[null,null,"Dauphin","Washington Township"]
[null,null,"Dauphin","Wayne Township"]
[null,null,"Dauphin","West Hanover Township"]
[null,null,"Dauphin","Wiconisco Township"]
[null,null,"Dauphin","Williams Township"]
[null,null,"Dauphin","Williamstown Borough"]
[null,null,"Franklin","Antrim Township"]
[null,null,"Franklin","Chambersburg Borough"]
[null,null,"Franklin","Fannett Township"]
[null,null,"Franklin","Greencastle Borough"]
[null,null,"Franklin","Greene Township"]
[null,null,"Franklin","Guilford Township"]
[null,null,"Franklin","Hamilton Township"]
[null,null,"Franklin","Letterkenny Township"]
[null,null,"Franklin","Lurgan Township"]
[null,null,"Franklin","Mercersburg Borough"]
[null,null,"Franklin","Metal Township"]
[null,null,"Franklin","Mont Alto Borough"]
[null,null,"Franklin","Montgomery Township"]
[null,null,"Franklin","Orrstown Borough"]
[null,null,"Franklin","Peters Township"]
[null,null,"Franklin","Quincy Township"]
[null,null,"Franklin","Saint Thomas Township"]
[null,null,"Franklin","Shippensburg Borough"]
[null,null,"Franklin","Southampton Township"]
[null,null,"Franklin","Warren Township"]
[null,null,"Franklin","Washington Township"]
[null,null,"Franklin","Waynesboro Borough"]
[null,null,"Fulton","Ayr Township"]
[null,null,"Fulton","Belfast Township"]
[null,null,"Fulton","Bethel Township"]
[null,null,"Fulton","Brush Creek Township"]
[null,null,"Fulton","Dublin Township"]
[null,null,"Fulton","Licking Creek Township"]
[null,null,"Fulton","McConnellsburg Borough"]
[null,null,"Fulton","Taylor Township"]
[null,null,"Fulton","Thompson Township"]
[null,null,"Fulton","Todd Township"]
[null,null,"Fulton","Union Township"]
[null,null,"Fulton","Valley-Hi Borough"]
[null,null,"Fulton","Wells Township"]
[null,null,"Huntingdon","Alexandria Borough"]
[null,null,"Huntingdon","Barree Township"]
[null,null,"Huntingdon","Birmingham Borough"]
[null,null,"Huntingdon","Brady Township"]
[null,null,"Huntingdon","Broad Top City Borough"]
[null,null,"Huntingdon","Carbon Township"]
[null,null,"Huntingdon","Cass Township"]
[null,null,"Huntingdon","Cassville Borough"]
[null,null,"Huntingdon","Clay Township"]
[null,null,"Huntingdon","Coalmont Borough"]
[null,null,"Huntingdon","Cromwell Township"]
[null,null,"Huntingdon","Dublin Township"]
[null,null,"Huntingdon","Dudley Borough"]
[null,null,"Huntingdon","Franklin Township"]
[null,null,"Huntingdon","Henderson Township"]
[null,null,"Huntingdon","Hopewell Township"]
[null,null,"Huntingdon","Huntingdon Borough"]
[null,null,"Huntingdon","Jackson Township"]
[null,null,"Huntingdon","Juniata Township"]
[null,null,"Huntingdon","Lincoln Township"]
[null,null,"Huntingdon","Logan Township"]
[null,null,"Huntingdon","Mapleton Borough"]
[null,null,"Huntingdon","Marklesburg Borough"]
[null,null,"Huntingdon","Mill Creek Borough"]
[null,null,"Huntingdon","Miller Township"]
[null,null,"Huntingdon","Morris Township"]
[null,null,"Huntingdon","Mount Union Borough"]
[null,null,"Huntingdon","Oneida Township"]
[null,null,"Huntingdon","Orbisonia Borough"]
[null,null,"Huntingdon","Penn Township"]
[null,null,"Huntingdon","Petersburg Borough"]
[null,null,"Huntingdon","Porter Township"]
[null,null,"Huntingdon","Rockhill Borough"]
[null,null,"Huntingdon","Saltillo Borough"]
[null,null,"Huntingdon","Shade Gap Borough"]
[null,null,"Huntingdon","Shirley Township"]
[null,null,"Huntingdon","Shirleysburg Borough"]
[null,null,"Huntingdon","Smithfield Township"]
[null,null,"Huntingdon","Springfield Township"]
[null,null,"Huntingdon","Spruce Creek Township"]
[null,null,"Huntingdon","Tell Township"]
[null,null,"Huntingdon","Three Springs Borough"]
[null,null,"Huntingdon","Todd Township"]
[null,null,"Huntingdon","Union Township"]
[null,null,"Huntingdon","Walker Township"]
[null,null,"Huntingdon","Warriors Mark Township"]
[null,null,"Huntingdon","West Township"]
[null,null,"Huntingdon","Wood Township"]
[null,null,"Juniata","Beale Township"]
[null,null,"Juniata","Delaware Township"]
[null,null,"Juniata","Fayette Township"]
[null,null,"Juniata","Fermanagh Township"]
[null,null,"Juniata","Greenwood Township"]
[null,null,"Juniata","Lack Township"]
[null,null,"Juniata","Mifflin Borough"]
[null,null,"Juniata","Mifflintown Borough"]
[null,null,"Juniata","Milford Township"]
[null,null,"Juniata","Monroe Township"]
[null,null,"Juniata","Port Royal Borough"]
[null,null,"Juniata","Spruce Hill Township"]
[null,null,"Juniata","Susquehanna Township"]
[null,null,"Juniata","Thompsontown Borough"]
[null,null,"Juniata","Turbett Township"]
[null,null,"Juniata","Tuscarora Township"]
[null,null,"Juniata","Walker Township"]
[null,null,"Lackawanna","Archbald Borough"]
[null,null,"Lackawanna","Benton Township"]
[null,null,"Lackawanna","Blakely Borough"]
[null,null,"Lackawanna","Carbondale Township"]
[null,null,"Lackawanna","Carbondale City"]
[null,null,"Lackawanna","Clarks Green Borough"]
[null,null,"Lackawanna","Clarks Summit Borough"]
[null,null,"Lackawanna","Clifton Township"]
[null,null,"Lackawanna","Covington Township"]
[null,null,"Lackawanna","Dalton Borough"]
[null,null,"Lackawanna","Dickson City Borough"]
[null,null,"Lackawanna","Dunmore Borough"]
[null,null,"Lackawanna","Elmhurst Township"]
[null,null,"Lackawanna","Fell Township"]
[null,null,"Lackawanna","Glenburn Township"]
[null,null,"Lackawanna","Greenfield Township"]
[null,null,"Lackawanna","Jefferson Township"]
[null,null,"Lackawanna","Jermyn Borough"]
[null,null,"Lackawanna","Jessup Borough"]
[null,null,"Lackawanna","La Plume Township"]
[null,null,"Lackawanna","Madison Township"]
[null,null,"Lackawanna","Mayfield Borough"]
[null,null,"Lackawanna","Moosic Borough"]
[null,null,"Lackawanna","Moscow Borough"]
[null,null,"Lackawanna","Newton Township"]
[null,null,"Lackawanna","North Abington Township"]
[null,null,"Lackawanna","Old Forge Borough"]
[null,null,"Lackawanna","Olyphant Borough"]
[null,null,"Lackawanna","Ransom Township"]
[null,null,"Lackawanna","Roaring Brook Township"]
[null,null,"Lackawanna","Scott Township"]
[null,null,"Lackawanna","Scranton City"]
[null,null,"Lackawanna","South Abington Township"]
[null,null,"Lackawanna","Spring Brook Township"]
[null,null,"Lackawanna","Taylor Borough"]
[null,null,"Lackawanna","Thornhurst Township"]
[null,null,"Lackawanna","Throop Borough"]
[null,null,"Lackawanna","Vandling Borough"]
[null,null,"Lackawanna","Waverly Township"]
[null,null,"Lackawanna","West Abington Township"]
[null,null,"Lancaster","Adamstown Borough"]
[null,null,"Lancaster","Akron Borough"]
[null,null,"Lancaster","Bart Township"]
[null,null,"Lancaster","Brecknock Township"]
[null,null,"Lancaster","Caernarvon Township"]
[null,null,"Lancaster","Christiana Borough"]
[null,null,"Lancaster","Clay Township"]
[null,null,"Lancaster","Colerain Township"]
[null,null,"Lancaster","Columbia Borough"]
[null,null,"Lancaster","Conestoga Township"]
[null,null,"Lancaster","Conoy Township"]
[null,null,"Lancaster","Denver Borough"]
[null,null,"Lancaster","Drumore Township"]
[null,null,"Lancaster","Earl Township"]
[null,null,"Lancaster","East Cocalico Township"]
[null,null,"Lancaster","East Donegal Township"]
[null,null,"Lancaster","East Drumore Township"]
[null,null,"Lancaster","East Earl Township"]
[null,null,"Lancaster","East Hempfield Township"]
[null,null,"Lancaster","East Lampeter Township"]
[null,null,"Lancaster","East Petersburg Borough"]
[null,null,"Lancaster","Eden Township"]
[null,null,"Lancaster","Elizabeth Township"]
[null,null,"Lancaster","Elizabethtown Borough"]
[null,null,"Lancaster","Ephrata Borough"]
[null,null,"Lancaster","Ephrata Township"]
[null,null,"Lancaster","Fulton Township"]
[null,null,"Lancaster","Lancaster City"]
[null,null,"Lancaster","Lancaster Township"]
[null,null,"Lancaster","Leacock Township"]
[null,null,"Lancaster","Lititz Borough"]
[null,null,"Lancaster","Little Britain Township"]
[null,null,"Lancaster","Manheim Borough"]
[null,null,"Lancaster","Manheim Township"]
[null,null,"Lancaster","Manor Township"]
[null,null,"Lancaster","Marietta Borough"]
[null,null,"Lancaster","Martic Township"]
[null,null,"Lancaster","Millersville Borough"]
[null,null,"Lancaster","Mount Joy Borough"]
[null,null,"Lancaster","Mount Joy Township"]
[null,null,"Lancaster","Mountville Borough"]
[null,null,"Lancaster","New Holland Borough"]
[null,null,"Lancaster","Paradise Township"]
[null,null,"Lancaster","Penn Township"]
[null,null,"Lancaster","Pequea Township"]
[null,null,"Lancaster","Providence Township"]
[null,null,"Lancaster","Quarryville Borough"]
[null,null,"Lancaster","Rapho Township"]
[null,null,"Lancaster","Sadsbury Township"]
[null,null,"Lancaster","Salisbury Township"]
[null,null,"Lancaster","Strasburg Borough"]
[null,null,"Lancaster","Strasburg Township"]
[null,null,"Lancaster","Terre Hill Borough"]
[null,null,"Lancaster","Upper Leacock Township"]
[null,null,"Lancaster","Warwick Township"]
[null,null,"Lancaster","West Cocalico Township"]
[null,null,"Lancaster","West Donegal Township"]
[null,null,"Lancaster","West Earl Township"]
[null,null,"Lancaster","West Hempfield Township"]
[null,null,"Lancaster","West Lampeter Township"]
[null,null,"Lebanon","Annville Township"]
[null,null,"Lebanon","Bethel Township"]
[null,null,"Lebanon","Cleona Borough"]
[null,null,"Lebanon","Cold Spring Township"]
[null,null,"Lebanon","Cornwall Borough"]
[null,null,"Lebanon","East Hanover Township"]
[null,null,"Lebanon","Heidelberg Township"]
[null,null,"Lebanon","Jackson Township"]
[null,null,"Lebanon","Jonestown Borough"]
[null,null,"Lebanon","Lebanon City"]
[null,null,"Lebanon","Millcreek Township"]
[null,null,"Lebanon","Mount Gretna Borough"]
[null,null,"Lebanon","Myerstown Borough"]
[null,null,"Lebanon","North Annville Township"]
[null,null,"Lebanon","North Cornwall Township"]
[null,null,"Lebanon","North Lebanon Township"]
[null,null,"Lebanon","North Londonderry Township"]
[null,null,"Lebanon","Palmyra Borough"]
[null,null,"Lebanon","Richland Borough"]
[null,null,"Lebanon","South Annville Township"]
[null,null,"Lebanon","South Lebanon Township"]
[null,null,"Lebanon","South Londonderry Township"]
[null,null,"Lebanon","Swatara Township"]
[null,null,"Lebanon","Union Township"]
[null,null,"Lebanon","West Cornwall Township"]
[null,null,"Lebanon","West Lebanon Township"]
[null,null,"Luzerne","Ashley Borough"]
[null,null,"Luzerne","Avoca Borough"]
[null,null,"Luzerne","Bear Creek Township"]
[null,null,"Luzerne","Bear Creek Village Borough"]
[null,null,"Luzerne","Black Creek Township"]
[null,null,"Luzerne","Buck Township"]
[null,null,"Luzerne","Butler Township"]
[null,null,"Luzerne","Conyngham Borough"]
[null,null,"Luzerne","Conyngham Township"]
[null,null,"Luzerne","Courtdale Borough"]
[null,null,"Luzerne","Dallas Borough"]
[null,null,"Luzerne","Dallas Township"]
[null,null,"Luzerne","Dennison Township"]
[null,null,"Luzerne","Dorrance Township"]
[null,null,"Luzerne","Dupont Borough"]
[null,null,"Luzerne","Duryea Borough"]
[null,null,"Luzerne","Edwardsville Borough"]
[null,null,"Luzerne","Exeter Borough"]
[null,null,"Luzerne","Exeter Township"]
[null,null,"Luzerne","Fairmount Township"]
[null,null,"Luzerne","Fairview Township"]
[null,null,"Luzerne","Forty Fort Borough"]
[null,null,"Luzerne","Foster Township"]
[null,null,"Luzerne","Franklin Township"]
[null,null,"Luzerne","Freeland Borough"]
[null,null,"Luzerne","Hanover Township"]
[null,null,"Luzerne","Harveys Lake Borough"]
[null,null,"Luzerne","Hazle Township"]
[null,null,"Luzerne","Hazleton City"]
[null,null,"Luzerne","Hollenback Township"]
[null,null,"Luzerne","Hughestown Borough"]
[null,null,"Luzerne","Hunlock Township"]
[null,null,"Luzerne","Huntington Township"]
[null,null,"Luzerne","Jackson Township"]
[null,null,"Luzerne","Jeddo Borough"]
[null,null,"Luzerne","Jenkins Township"]
[null,null,"Luzerne","Kingston Borough"]
[null,null,"Luzerne","Kingston Township"]
[null,null,"Luzerne","Laflin Borough"]
[null,null,"Luzerne","Lake Township"]
[null,null,"Luzerne","Larksville Borough"]
[null,null,"Luzerne","Laurel Run Borough"]
[null,null,"Luzerne","Lehman Township"]
[null,null,"Luzerne","Luzerne Borough"]
[null,null,"Luzerne","Nanticoke City"]
[null,null,"Luzerne","Nescopeck Borough"]
[null,null,"Luzerne","Nescopeck Township"]
[null,null,"Luzerne","New Columbus Borough"]
[null,null,"Luzerne","Newport Township"]
[null,null,"Luzerne","Nuangola Borough"]
[null,null,"Luzerne","Penn Lake Park Borough"]
[null,null,"Luzerne","Pittston City"]
[null,null,"Luzerne","Pittston Township"]
[null,null,"Luzerne","Plains Township"]
[null,null,"Luzerne","Plymouth Borough"]
[null,null,"Luzerne","Plymouth Township"]
[null,null,"Luzerne","Pringle Borough"]
[null,null,"Luzerne","Rice Township"]
[null,null,"Luzerne","Ross Township"]
[null,null,"Luzerne","Salem Township"]
[null,null,"Luzerne","Shickshinny Borough"]
[null,null,"Luzerne","Slocum Township"]
[null,null,"Luzerne","Sugar Notch Borough"]
[null,null,"Luzerne","Sugarloaf Township"]
[null,null,"Luzerne","Swoyersville Borough"]
[null,null,"Luzerne","Union Township"]
[null,null,"Luzerne","Warrior Run Borough"]
[null,null,"Luzerne","West Hazleton Borough"]
[null,null,"Luzerne","West Pittston Borough"]
[null,null,"Luzerne","West Wyoming Borough"]
[null,null,"Luzerne","White Haven Borough"]
[null,null,"Luzerne","Wilkes-Barre City"]
[null,null,"Luzerne","Wilkes-Barre Township"]
[null,null,"Luzerne","Wright Township"]
[null,null,"Luzerne","Wyoming Borough"]
[null,null,"Luzerne","Yatesville Borough"]
[null,null,"Lycoming","Anthony Township"]
[null,null,"Lycoming","Armstrong Township"]
[null,null,"Lycoming","Bastress Township"]
[null,null,"Lycoming","Brady Township"]
[null,null,"Lycoming","Brown Township"]
[null,null,"Lycoming","Cascade Township"]
[null,null,"Lycoming","Clinton Township"]
[null,null,"Lycoming","Cogan House Township"]
[null,null,"Lycoming","Cummings Township"]
[null,null,"Lycoming","Duboistown Borough"]
[null,null,"Lycoming","Eldred Township"]
[null,null,"Lycoming","Fairfield Township"]
[null,null,"Lycoming","Franklin Township"]
[null,null,"Lycoming","Gamble Township"]
[null,null,"Lycoming","Hepburn Township"]
[null,null,"Lycoming","Hughesville Borough"]
[null,null,"Lycoming","Jackson Township"]
[null,null,"Lycoming","Jersey Shore Borough"]
[null,null,"Lycoming","Jordan Township"]
[null,null,"Lycoming","Lewis Township"]
[null,null,"Lycoming","Limestone Township"]
[null,null,"Lycoming","Loyalsock Township"]
[null,null,"Lycoming","Lycoming Township"]
[null,null,"Lycoming","McHenry Township"]
[null,null,"Lycoming","McIntyre Township"]
[null,null,"Lycoming","McNett Township"]
[null,null,"Lycoming","Mifflin Township"]
[null,null,"Lycoming","Mill Creek Township"]
[null,null,"Lycoming","Montgomery Borough"]
[null,null,"Lycoming","Montoursville Borough"]
[null,null,"Lycoming","Moreland Township"]
[null,null,"Lycoming","Muncy Township"]
[null,null,"Lycoming","Muncy Borough"]
[null,null,"Lycoming","Muncy Creek Township"]
[null,null,"Lycoming","Nippenose Township"]
[null,null,"Lycoming","Old Lycoming Township"]
[null,null,"Lycoming","Penn Township"]
[null,null,"Lycoming","Piatt Township"]
[null,null,"Lycoming","Picture Rocks Borough"]
[null,null,"Lycoming","Pine Township"]
[null,null,"Lycoming","Plunketts Creek Township"]
[null,null,"Lycoming","Porter Township"]
[null,null,"Lycoming","Salladasburg Borough"]
[null,null,"Lycoming","Shrewsbury Township"]
[null,null,"Lycoming","South Williamsport Borough"]
[null,null,"Lycoming","Susquehanna Township"]
[null,null,"Lycoming","Upper Fairfield Township"]
[null,null,"Lycoming","Washington Township"]
[null,null,"Lycoming","Watson Township"]
[null,null,"Lycoming","Williamsport City"]
[null,null,"Lycoming","Wolf Township"]
[null,null,"Lycoming","Woodward Township"]
[null,null,"Mifflin","Armagh Township"]
[null,null,"Mifflin","Bratton Township"]
[null,null,"Mifflin","Brown Township"]
[null,null,"Mifflin","Burnham Borough"]
[null,null,"Mifflin","Decatur Township"]
[null,null,"Mifflin","Derry Township"]
[null,null,"Mifflin","Granville Township"]
[null,null,"Mifflin","Juniata Terrace Borough"]
[null,null,"Mifflin","Kistler Borough"]
[null,null,"Mifflin","Lewistown Borough"]
[null,null,"Mifflin","McVeytown Borough"]
[null,null,"Mifflin","Menno Township"]
[null,null,"Mifflin","Newton Hamilton Borough"]
[null,null,"Mifflin","Oliver Township"]
[null,null,"Mifflin","Union Township"]
[null,null,"Mifflin","Wayne Township"]
[null,null,"Montour","Anthony Township"]
[null,null,"Montour","Cooper Township"]
[null,null,"Montour","Danville Borough"]
[null,null,"Montour","Derry Township"]
[null,null,"Montour","Liberty Township"]
[null,null,"Montour","Limestone Township"]
[null,null,"Montour","Mahoning Township"]
[null,null,"Montour","Mayberry Township"]
[null,null,"Montour","Valley Township"]
[null,null,"Montour","Washingtonville Borough"]
[null,null,"Montour","West Hemlock Township"]
[null,null,"Northumberland","Coal Township"]
[null,null,"Northumberland","Delaware Township"]
[null,null,"Northumberland","East Cameron Township"]
[null,null,"Northumberland","East Chillisquaque Township"]
[null,null,"Northumberland","Herndon Borough"]
[null,null,"Northumberland","Jackson Township"]
[null,null,"Northumberland","Jordan Township"]
[null,null,"Northumberland","Kulpmont Borough"]
[null,null,"Northumberland","Lewis Township"]
[null,null,"Northumberland","Little Mahanoy Township"]
[null,null,"Northumberland","Lower Augusta Township"]
[null,null,"Northumberland","Lower Mahanoy Township"]
[null,null,"Northumberland","Marion Heights Borough"]
[null,null,"Northumberland","McEwensville Borough"]
[null,null,"Northumberland","Milton Borough"]
[null,null,"Northumberland","Mount Carmel Borough"]
[null,null,"Northumberland","Mount Carmel Township"]
[null,null,"Northumberland","Northumberland Borough"]
[null,null,"Northumberland","Point Township"]
[null,null,"Northumberland","Ralpho Township"]
[null,null,"Northumberland","Riverside Borough"]
[null,null,"Northumberland","Rockefeller Township"]
[null,null,"Northumberland","Rush Township"]
[null,null,"Northumberland","Shamokin City"]
[null,null,"Northumberland","Shamokin Township"]
[null,null,"Northumberland","Snydertown Borough"]
[null,null,"Northumberland","Sunbury City"]
[null,null,"Northumberland","Turbot Township"]
[null,null,"Northumberland","Turbotville Borough"]
[null,null,"Northumberland","Upper Augusta Township"]
[null,null,"Northumberland","Upper Mahanoy Township"]
[null,null,"Northumberland","Washington Township"]
[null,null,"Northumberland","Watsontown Borough"]
[null,null,"Northumberland","West Cameron Township"]
[null,null,"Northumberland","West Chillisquaque Township"]
[null,null,"Northumberland","Zerbe Township"]
[null,null,"Perry","Blain Borough"]
[null,null,"Perry","Bloomfield Borough"]
[null,null,"Perry","Buffalo Township"]
[null,null,"Perry","Carroll Township"]
[null,null,"Perry","Centre Township"]
[null,null,"Perry","Duncannon Borough"]
[null,null,"Perry","Greenwood Township"]
[null,null,"Perry","Howe Township"]
[null,null,"Perry","Jackson Township"]
[null,null,"Perry","Juniata Township"]
[null,null,"Perry","Landisburg Borough"]
[null,null,"Perry","Liverpool Borough"]
[null,null,"Perry","Liverpool Township"]
[null,null,"Perry","Marysville Borough"]
[null,null,"Perry","Miller Township"]
[null,null,"Perry","Millerstown Borough"]
[null,null,"Perry","New Buffalo Borough"]
[null,null,"Perry","Newport Borough"]
[null,null,"Perry","Northeast Madison Township"]
[null,null,"Perry","Oliver Township"]
[null,null,"Perry","Penn Township"]
[null,null,"Perry","Rye Township"]
[null,null,"Perry","Saville Township"]
[null,null,"Perry","Southwest Madison Township"]
[null,null,"Perry","Spring Township"]
[null,null,"Perry","Toboyne Township"]
[null,null,"Perry","Tuscarora Township"]
[null,null,"Perry","Tyrone Township"]
[null,null,"Perry","Watts Township"]
[null,null,"Perry","Wheatfield Township"]
[null,null,"Potter","Abbott Township"]
[null,null,"Potter","Allegany Township"]
[null,null,"Potter","Austin Borough"]
[null,null,"Potter","Bingham Township"]
[null,null,"Potter","Clara Township"]
[null,null,"Potter","Coudersport Borough"]
[null,null,"Potter","Eulalia Township"]
[null,null,"Potter","Galeton Borough"]
[null,null,"Potter","Genesee Township"]
[null,null,"Potter","Harrison Township"]
[null,null,"Potter","Hebron Township"]
[null,null,"Potter","Hector Township"]
[null,null,"Potter","Homer Township"]
[null,null,"Potter","Keating Township"]
[null,null,"Potter","Oswayo Borough"]
[null,null,"Potter","Oswayo Township"]
[null,null,"Potter","Pike Township"]
[null,null,"Potter","Pleasant Valley Township"]
[null,null,"Potter","Portage Township"]
[null,null,"Potter","Roulette Township"]
[null,null,"Potter","Sharon Township"]
[null,null,"Potter","Shinglehouse Borough"]
[null,null,"Potter","Stewardson Township"]
[null,null,"Potter","Summit Township"]
[null,null,"Potter","Sweden Township"]
[null,null,"Potter","Sylvania Township"]
[null,null,"Potter","Ulysses Borough"]
[null,null,"Potter","Ulysses Township"]
[null,null,"Potter","West Branch Township"]
[null,null,"Potter","Wharton Township"]
[null,null,"Schuylkill","Ashland Borough"]
[null,null,"Schuylkill","Auburn Borough"]
[null,null,"Schuylkill","Barry Township"]
[null,null,"Schuylkill","Blythe Township"]
[null,null,"Schuylkill","Branch Township"]
[null,null,"Schuylkill","Butler Township"]
[null,null,"Schuylkill","Cass Township"]
[null,null,"Schuylkill","Coaldale Borough"]
[null,null,"Schuylkill","Cressona Borough"]
[null,null,"Schuylkill","Deer Lake Borough"]
[null,null,"Schuylkill","Delano Township"]
[null,null,"Schuylkill","East Brunswick Township"]
[null,null,"Schuylkill","East Norwegian Township"]
[null,null,"Schuylkill","East Union Township"]
[null,null,"Schuylkill","Eldred Township"]
[null,null,"Schuylkill","Foster Township"]
[null,null,"Schuylkill","Frackville Borough"]
[null,null,"Schuylkill","Frailey Township"]
[null,null,"Schuylkill","Gilberton Borough"]
[null,null,"Schuylkill","Girardville Borough"]
[null,null,"Schuylkill","Gordon Borough"]
[null,null,"Schuylkill","Hegins Township"]
[null,null,"Schuylkill","Hubley Township"]
[null,null,"Schuylkill","Kline Township"]
[null,null,"Schuylkill","Landingville Borough"]
[null,null,"Schuylkill","Mahanoy Township"]
[null,null,"Schuylkill","Mahanoy City Borough"]
[null,null,"Schuylkill","McAdoo Borough"]
[null,null,"Schuylkill","Mechanicsville Borough"]
[null,null,"Schuylkill","Middleport Borough"]
[null,null,"Schuylkill","Minersville Borough"]
[null,null,"Schuylkill","Mount Carbon Borough"]
[null,null,"Schuylkill","New Castle Township"]
[null,null,"Schuylkill","New Philadelphia Borough"]
[null,null,"Schuylkill","New Ringgold Borough"]
[null,null,"Schuylkill","North Manheim Township"]
[null,null,"Schuylkill","North Union Township"]
[null,null,"Schuylkill","Norwegian Township"]
[null,null,"Schuylkill","Orwigsburg Borough"]
[null,null,"Schuylkill","Palo Alto Borough"]
[null,null,"Schuylkill","Pine Grove Borough"]
[null,null,"Schuylkill","Pine Grove Township"]
[null,null,"Schuylkill","Port Carbon Borough"]
[null,null,"Schuylkill","Port Clinton Borough"]
[null,null,"Schuylkill","Porter Township"]
[null,null,"Schuylkill","Pottsville City"]
[null,null,"Schuylkill","Reilly Township"]
[null,null,"Schuylkill","Ringtown Borough"]
[null,null,"Schuylkill","Rush Township"]
[null,null,"Schuylkill","Ryan Township"]
[null,null,"Schuylkill","Saint Clair Borough"]
[null,null,"Schuylkill","Schuylkill Township"]
[null,null,"Schuylkill","Schuylkill Haven Borough"]
[null,null,"Schuylkill","Shenandoah Borough"]
[null,null,"Schuylkill","South Manheim Township"]
[null,null,"Schuylkill","Tamaqua Borough"]
[null,null,"Schuylkill","Tower City Borough"]
[null,null,"Schuylkill","Tremont Borough"]
[null,null,"Schuylkill","Tremont Township"]
[null,null,"Schuylkill","Union Township"]
[null,null,"Schuylkill","Upper Mahantango Township"]
[null,null,"Schuylkill","Walker Township"]
[null,null,"Schuylkill","Washington Township"]
[null,null,"Schuylkill","Wayne Township"]
[null,null,"Schuylkill","West Brunswick Township"]
[null,null,"Schuylkill","West Mahanoy Township"]
[null,null,"Schuylkill","West Penn Township"]
[null,null,"Snyder","Adams Township"]
[null,null,"Snyder","Beaver Township"]
[null,null,"Snyder","Beavertown Borough"]
[null,null,"Snyder","Center Township"]
[null,null,"Snyder","Chapman Township"]
[null,null,"Snyder","Franklin Township"]
[null,null,"Snyder","Freeburg Borough"]
[null,null,"Snyder","Jackson Township"]
[null,null,"Snyder","McClure Borough"]
[null,null,"Snyder","Middleburg Borough"]
[null,null,"Snyder","Middlecreek Township"]
[null,null,"Snyder","Monroe Township"]
[null,null,"Snyder","Penn Township"]
[null,null,"Snyder","Perry Township"]
[null,null,"Snyder","Selinsgrove Borough"]
[null,null,"Snyder","Shamokin Dam Borough"]
[null,null,"Snyder","Spring Township"]
[null,null,"Snyder","Union Township"]
[null,null,"Snyder","Washington Township"]
[null,null,"Snyder","West Beaver Township"]
[null,null,"Snyder","West Perry Township"]
[null,null,"Somerset","Meyersdale Borough"]
[null,null,"Somerset","Somerset Borough"]
[null,null,"Somerset","Windber Borough"]
[null,null,"Somerset","Indian Lake Borough"]
[null,null,"Somerset","Callimont Borough"]
[null,null,"Somerset","Addison Borough"]
[null,null,"Somerset","Addison Township"]
[null,null,"Somerset","Allegheny Township"]
[null,null,"Somerset","Benson Borough"]
[null,null,"Somerset","Berlin Borough"]
[null,null,"Somerset","Black Township"]
[null,null,"Somerset","Boswell Borough"]
[null,null,"Somerset","Brothersvalley Township"]
[null,null,"Somerset","Casselman Borough"]
[null,null,"Somerset","Conemaugh Township"]
[null,null,"Somerset","Confluence Borough"]
[null,null,"Somerset","Elk Lick Township"]
[null,null,"Somerset","Garrett Borough"]
[null,null,"Somerset","Greenville Township"]
[null,null,"Somerset","Hooversville Borough"]
[null,null,"Somerset","Jenner Township"]
[null,null,"Somerset","Jennerstown Borough"]
[null,null,"Somerset","Larimer Township"]
[null,null,"Somerset","Lower Turkeyfoot Township"]
[null,null,"Somerset","Middlecreek Township"]
[null,null,"Somerset","Milford Township"]
[null,null,"Somerset","New Centerville Borough"]
[null,null,"Somerset","Northampton Township"]
[null,null,"Somerset","Ogle Township"]
[null,null,"Somerset","Paint Borough"]
[null,null,"Somerset","Quemahoning Township"]
[null,null,"Somerset","Rockwood Borough"]
[null,null,"Somerset","Salisbury Borough"]
[null,null,"Somerset","Shade Township"]
[null,null,"Somerset","Shanksville Borough"]
[null,null,"Somerset","Somerset Township"]
[null,null,"Somerset","Southampton Township"]
[null,null,"Somerset","Stonycreek Township"]
[null,null,"Somerset","Stoystown Borough"]
[null,null,"Somerset","Summit Township"]
[null,null,"Somerset","Upper Turkeyfoot Township"]
[null,null,"Somerset","Ursina Borough"]
[null,null,"Somerset","Wellersburg Borough"]
[null,null,"Sullivan","Cherry Township"]
[null,null,"Sullivan","Colley Township"]
[null,null,"Sullivan","Davidson Township"]
[null,null,"Sullivan","Dushore Borough"]
[null,null,"Sullivan","Eagles Mere Borough"]
[null,null,"Sullivan","Elkland Township"]
[null,null,"Sullivan","Forks Township"]
[null,null,"Sullivan","Forksville Borough"]
[null,null,"Sullivan","Fox Township"]
[null,null,"Sullivan","Hillsgrove Township"]
[null,null,"Sullivan","Laporte Borough"]
[null,null,"Sullivan","Laporte Township"]
[null,null,"Sullivan","Shrewsbury Township"]
[null,null,"Susquehanna","Apolacon Township"]
[null,null,"Susquehanna","Ararat Township"]
[null,null,"Susquehanna","Auburn Township"]
[null,null,"Susquehanna","Bridgewater Township"]
[null,null,"Susquehanna","Brooklyn Township"]
[null,null,"Susquehanna","Choconut Township"]
[null,null,"Susquehanna","Clifford Township"]
[null,null,"Susquehanna","Dimock Township"]
[null,null,"Susquehanna","Forest City Borough"]
[null,null,"Susquehanna","Forest Lake Township"]
[null,null,"Susquehanna","Franklin Township"]
[null,null,"Susquehanna","Friendsville Borough"]
[null,null,"Susquehanna","Gibson Township"]
[null,null,"Susquehanna","Great Bend Township"]
[null,null,"Susquehanna","Great Bend Borough"]
[null,null,"Susquehanna","Hallstead Borough"]
[null,null,"Susquehanna","Harford Township"]
[null,null,"Susquehanna","Harmony Township"]
[null,null,"Susquehanna","Herrick Township"]
[null,null,"Susquehanna","Hop Bottom Borough"]
[null,null,"Susquehanna","Jackson Township"]
[null,null,"Susquehanna","Jessup Township"]
[null,null,"Susquehanna","Lanesboro Borough"]
[null,null,"Susquehanna","Lathrop Township"]
[null,null,"Susquehanna","Lenox Township"]
[null,null,"Susquehanna","Liberty Township"]
[null,null,"Susquehanna","Little Meadows Borough"]
[null,null,"Susquehanna","Middletown Township"]
[null,null,"Susquehanna","Montrose Borough"]
[null,null,"Susquehanna","New Milford Borough"]
[null,null,"Susquehanna","New Milford Township"]
[null,null,"Susquehanna","Oakland Borough"]
[null,null,"Susquehanna","Oakland Township"]
[null,null,"Susquehanna","Rush Township"]
[null,null,"Susquehanna","Silver Lake Township"]
[null,null,"Susquehanna","Springville Township"]
[null,null,"Susquehanna","Susquehanna Depot Borough"]
[null,null,"Susquehanna","Thompson Borough"]
[null,null,"Susquehanna","Thompson Township"]
[null,null,"Susquehanna","Union Dale Borough"]
[null,null,"Tioga","Bloss Township"]
[null,null,"Tioga","Blossburg Borough"]
[null,null,"Tioga","Brookfield Township"]
[null,null,"Tioga","Charleston Township"]
[null,null,"Tioga","Chatham Township"]
[null,null,"Tioga","Clymer Township"]
[null,null,"Tioga","Covington Township"]
[null,null,"Tioga","Deerfield Township"]
[null,null,"Tioga","Delmar Township"]
[null,null,"Tioga","Duncan Township"]
[null,null,"Tioga","Elk Township"]
[null,null,"Tioga","Elkland Borough"]
[null,null,"Tioga","Farmington Township"]
[null,null,"Tioga","Gaines Township"]
[null,null,"Tioga","Hamilton Township"]
[null,null,"Tioga","Jackson Township"]
[null,null,"Tioga","Knoxville Borough"]
[null,null,"Tioga","Lawrence Township"]
[null,null,"Tioga","Lawrenceville Borough"]
[null,null,"Tioga","Liberty Borough"]
[null,null,"Tioga","Liberty Township"]
[null,null,"Tioga","Mansfield Borough"]
[null,null,"Tioga","Middlebury Township"]
[null,null,"Tioga","Morris Township"]
[null,null,"Tioga","Nelson Township"]
[null,null,"Tioga","Osceola Township"]
[null,null,"Tioga","Putnam Township"]
[null,null,"Tioga","Richmond Township"]
[null,null,"Tioga","Roseville Borough"]
[null,null,"Tioga","Rutland Township"]
[null,null,"Tioga","Shippen Township"]
[null,null,"Tioga","Sullivan Township"]
[null,null,"Tioga","Tioga Borough"]
[null,null,"Tioga","Tioga Township"]
[null,null,"Tioga","Union Township"]
[null,null,"Tioga","Ward Township"]
[null,null,"Tioga","Wellsboro Borough"]
[null,null,"Tioga","Westfield Borough"]
[null,null,"Tioga","Westfield Township"]
[null,null,"Union","Buffalo Township"]
[null,null,"Union","East Buffalo Township"]
[null,null,"Union","Gregg Township"]
[null,null,"Union","Hartleton Borough"]
[null,null,"Union","Hartley Township"]
[null,null,"Union","Kelly Township"]
[null,null,"Union","Lewis Township"]
[null,null,"Union","Lewisburg Borough"]
[null,null,"Union","Limestone Township"]
[null,null,"Union","Mifflinburg Borough"]
[null,null,"Union","New Berlin Borough"]
[null,null,"Union","Union Township"]
[null,null,"Union","West Buffalo Township"]
[null,null,"Union","White Deer Township"]
[null,null,"Wyoming","Braintrim Township"]
[null,null,"Wyoming","Clinton Township"]
[null,null,"Wyoming","Eaton Township"]
[null,null,"Wyoming","Exeter Township"]
[null,null,"Wyoming","Factoryville Borough"]
[null,null,"Wyoming","Falls Township"]
[null,null,"Wyoming","Forkston Township"]
[null,null,"Wyoming","Laceyville Borough"]
[null,null,"Wyoming","Lemon Township"]
[null,null,"Wyoming","Mehoopany Township"]
[null,null,"Wyoming","Meshoppen Borough"]
[null,null,"Wyoming","Meshoppen Township"]
[null,null,"Wyoming","Monroe Township"]
[null,null,"Wyoming","Nicholson Borough"]
[null,null,"Wyoming","Nicholson Township"]
[null,null,"Wyoming","North Branch Township"]
[null,null,"Wyoming","Northmoreland Township"]
[null,null,"Wyoming","Noxen Township"]
[null,null,"Wyoming","Overfield Township"]
[null,null,"Wyoming","Tunkhannock Borough"]
[null,null,"Wyoming","Tunkhannock Township"]
[null,null,"Wyoming","Washington Township"]
[null,null,"Wyoming","Windham Township"]
[null,null,"York","Carroll Township"]
[null,null,"York","Chanceford Township"]
[null,null,"York","Codorus Township"]
[null,null,"York","Conewago Township"]
[null,null,"York","Cross Roads Borough"]
[null,null,"York","Dallastown Borough"]
[null,null,"York","Delta Borough"]
[null,null,"York","Dillsburg Borough"]
[null,null,"York","Dover Borough"]
[null,null,"York","Dover Township"]
[null,null,"York","East Hopewell Township"]
[null,null,"York","East Manchester Township"]
[null,null,"York","East Prospect Borough"]
[null,null,"York","Fairview Township"]
[null,null,"York","Fawn Township"]
[null,null,"York","Fawn Grove Borough"]
[null,null,"York","Felton Borough"]
[null,null,"York","Franklin Township"]
[null,null,"York","Franklintown Borough"]
[null,null,"York","Glen Rock Borough"]
[null,null,"York","Goldsboro Borough"]
[null,null,"York","Hallam Borough"]
[null,null,"York","Hanover Borough"]
[null,null,"York","Heidelberg Township"]
[null,null,"York","Hellam Township"]
[null,null,"York","Hopewell Township"]
[null,null,"York","Jackson Township"]
[null,null,"York","Jacobus Borough"]
[null,null,"York","Jefferson Borough"]
[null,null,"York","Lewisberry Borough"]
[null,null,"York","Loganville Borough"]
[null,null,"York","Lower Chanceford Township"]
[null,null,"York","Lower Windsor Township"]
[null,null,"York","Manchester Borough"]
[null,null,"York","Manchester Township"]
[null,null,"York","Manheim Township"]
[null,null,"York","Monaghan Township"]
[null,null,"York","Mount Wolf Borough"]
[null,null,"York","New Freedom Borough"]
[null,null,"York","New Salem Borough"]
[null,null,"York","Newberry Township"]
[null,null,"York","North Codorus Township"]
[null,null,"York","North Hopewell Township"]
[null,null,"York","North York Borough"]
[null,null,"York","Paradise Township"]
[null,null,"York","Peach Bottom Township"]
[null,null,"York","Penn Township"]
[null,null,"York","Railroad Borough"]
[null,null,"York","Red Lion Borough"]
[null,null,"York","Seven Valleys Borough"]
[null,null,"York","Shrewsbury Borough"]
[null,null,"York","Shrewsbury Township"]
[null,null,"York","Spring Garden Township"]
[null,null,"York","Spring Grove Borough"]
[null,null,"York","Springettsbury Township"]
[null,null,"York","Springfield Township"]
[null,null,"York","Stewartstown Borough"]
[null,null,"York","Warrington Township"]
[null,null,"York","Washington Township"]
[null,null,"York","Wellsville Borough"]
[null,null,"York","West Manchester Township"]
[null,null,"York","West Manheim Township"]
[null,null,"York","West York Borough"]
[null,null,"York","Windsor Borough"]
[null,null,"York","Windsor Township"]
[null,null,"York","Winterstown Borough"]
[null,null,"York","Wrightsville Borough"]
[null,null,"York","Yoe Borough"]
[null,null,"York","York City"]
[null,null,"York","York Township"]
[null,null,"York","York Haven Borough"]
[null,null,"York","Yorkana Borough"]