SQL Officer DB

[Dark1001]

gh

 

[N9XDZ]

Данные с сайта города rockwall / сайт http://rockwall.com/ / строк внутри 90 000

Спойлер: поля

Registrationsid,FormTimeStamp,FirstName,LastName,Address1,Address2,State,ZipCode,AlternatePhone,FaxNumber,EmailAddress,EmailAddressConfirm,AlternateEmail,EventFormName,EventFormNameCancelled,ConfirmationNumber,Cancelled,Meals,SSNumber,DOB,SwornLawEnforcement,CriminalAnalyst,OtherOrgType,OtherOrgDescription,Submit,IPAddress,InternalNotes,CellPhone,VerifyEmailAddress,HIDTA,Certificate,RegistrationIDOld,TrainingOfficerPhone,POC,SubmitReg,DidNotAttend,LEAgency,CriminalAnalystType,Dispatcher,MilitaryBranch,Lodging,LodgingNightBeforeClass,LodgingNightAfterClass,HIDTAName,TrainingOfficerName,RespondByStart,fullname,EventFormNameWaitingList,NSBounceSoft,NSBounceHard,guid,RegFormType,DoNotSend,AgencyOrganization,EventCost,Blacklisted,BlacklistedComments,PhoneWork,IncludeNameOnRoster,SupervisorPhoneWork,Salutation,JobResponsiblity,AreaOfResponsibility,AgencyType,AgencyStaff,Subordinates,Title,Job,Experience,PrimaryResponsiblity,AreaOfResponsiblity,FacilityPopulation,SupervisorEmailAddress,DateCancelled,SentCertificate,SupervisorFullName,AuthorizationCode,CCFirstName,CCLastName,CCAddress,CCNumber,CCExpire,CCSecurityCode,CCZip,CCCountry,EventBuilderApprovalLevelID,CurrentArmedForces,PhoneWorkExt,PhoneSupervisorExt,PhoneTrainingExt,City,AssignedTaskForce,CDState,YearsOfExperience,PreReqDate,Agency2,ZipMailingAddress,StreetAdress,AptStreetOther,CityMailingAddress,StateMailingAddress,PositionTitleRank,OtherAgency,TrainingOfficerEmail,SurveyCompleted,ActiveMembership,AssociateMembership,INOAMEMBERTYPE,DFCGrantee,SPF-SIGgrantee,PartnershipSuccessgrantee,ForeseeapplyingforDFCgrantinnext2years,NOCICEmail,AgencyStreetAddress,SupervisorTitle,AssignmentPartTime,NPLExaccount,MemberofIowaNarcoticsAssocation,YearsOnTaskForce,YearswithLawEnforcement,YearsassignedtoNarcotics,NumberofControlledBuysUCon,NumberofConfidentialSourcesworked,NumberofSeachWarrantsAuthored,AssignedtoTaskForce,AssignmentFullTime,Processed,Organization,Address,HIDTATaskForceName,EmailAttachmentsOnly,PreeventSurveyCompleted,FollowUpSurveyCompleted,PreeventSurveyCompleteDataField,Custom 1,Custom

Спойлер: семпл

256510,"12/06/19 00:00:00","David","Johnson",,,"TX","75202",,,"djohnson165@gmail.com",,,"ILEFY200218-0220",,,0,0,,,0,0,0,,,"2600:1700:1e30:10f0:2d55:f576:eff5:8c0f",,"214 263 8043",,0,0,,,0,"Submit Registration",0,,,,,0,0,0,"No HIDTA",,,"David Johnson",,0,0,"179faab2-5d9f-4d77-b961-5f4e1d6bbcb6",,0,"Dallas County Sheriff's Office (TX)","0",0,,"214 749 8641",0,"214 751 4580",,,,"Local",,,,,,,,,"Charlie.Tyner@DallasCounty.org",,1,"Charlie Tyner",,,,,,,,,,,,,,,"Dallas",,,,,,,,,,,"Retired/Deputy Sheriff",,,1,,,,,,,,,,,,,,,,,,,,,,0,,,,0,1,0,0,,,"No",,,,,,,,,
1256511,"12/06/19 19:15:45","Monique","Figueroa",,,"Tx","75087",,,"mfigueroa@rockwall.com",,,,"ILEFY200218-0220",,1,0,,,0,0,0,,,"2600:387:1:811::81",,"2149231798",,0,0,,,0,"Submit Registration",0,,,,,0,0,0,"No HIDTA",,,"Monique  Figueroa",,0,0,"6086f8e9-ae25-4849-be24-4d1b060ee2f0",,0,"Rockwall Police Department","0",0,,"4695962770",0,"9727717724",,,,"Local",,,,,,,,,"jlutes@rockwall.com","12/9/2019 9:10:50 AM",0,"Jeff Lutes",,,,,,,,,,,,,,,"Rockwall",,,,,,,,,,,"Detective",,,0,,,,,,,,,,,,,,,,,,,,,,0,,,,0,0,0,0,,,"No",,,,,,,,,
1256512,"12/06/19 00:00:00","Joshua","Martin",,,"TX","75126",,,"jmartin@forneytx.gov",,,"ILEFY200218-0220",,,0,0,,,0,0,0,,,"107.77.196.209",,"6196726705",,0,0,,,0,"Submit Registration",0,,,,,0,0,0,"No HIDTA",,,"Joshua Martin",,0,0,"0291d8f2-dcfd-423c-8832-c82100414850",,0,"Forney Police Department (TX)","0",0,,"9725647600",0,"9725647600",,,,"Local",,,,,,,,,"sball@forneytx.gov",,1,"Shane Ball",,,,,,,,,,,,,,,"Forney",,,,,,,,,,,"Police Officer",,,1,,,,,,,,,,,,,,,,,,,,,,0,,,,0,0,0,0,,,"No",,,,,,,,,
1256513,"12/06/19 00:00:00","Salvatore","Maiorano",,,"TX","75203",,,"salvatore.officer@gmail.com",,,,"ILEFY200218-0220",,1,0,,,0,0,0,,,"192.104.49.64",,"8174038200",,0,0,,,0,"Submit Registration",0,,,,,0,0,0,"No HIDTA",,,"Salvatore Maiorano",,0,0,"81610401-5a1b-48c8-bf8e-f942f8b0b63a",,0,"Methodist Health System Police Department (TX)","0",0,,"2149478816",0,"2149478816",,,,"Local",,,,,,,,,"JosephCherry@mhd.com","2/10/2020 8:48:59 PM",0,"Joseph Cherry",,,,,,,,,,,,,,,"Dallas",,,,,,,,,,,"POLICE SERGEANT",,,0,,,,,,,,,,,,,,,,,,,,,,0,,,,0,0,0,0,,,"No",,,,,,,,,
1256514,"12/06/19 00:00:00","Thomas","Clements",,,"TX","75034",,,"tclements@friscotexas.gov",,,"ILEFY200218-0220",,,0,0,,,0,0,0,,,"72.48.236.11",,"480-639-7788",,0,0,,,0,"Submit Registration",0,,,,,0,0,0,"No HIDTA",,,"Thomas Clements",,0,0,"513b8fc9-d1ee-4ccd-9df1-d06e9a6512c9",,0,"Frisco Police Department (TX)","0",0,,"972-292-6010",0,"972-292-6110",,,,"Local",,,,,,,,,"ccogan@friscotexas.gov",,1,"Officer Chris Cogan",,,,,,,,,,,,,,,"Frisco",,,,,,,,,,,"Officer",,,0,,,,,,,,,,,,,,,,,,,,,,0,,,,0,0,0,0,,,"No",,,,,,,,,

 

[Federal]

appreciate this share