Request for inspection and/or treatment of rodent and/or mosquito issues.
This dataset has the following 26 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
RECORD NUMBER | recordno | number | MARC service request number | 190 191 192 193 194 view top 100 |
TYPE OF REQUEST | type | text | Service request for rodent or mosquito inspection and treatment | MOSQUITO RODENT BOTH view top 100 |
NIGHT SPRAY TRUCK REQUEST | night_spray | checkbox | Service request for the night spray trucks | false true view top 100 |
OK TO TREAT | treat | checkbox | Service request for the night spray trucks | true view top 100 |
CALL IN REQUEST | called_in | checkbox | Service request has been phoned in | true view top 100 |
CALL IN TIME | call_in_time | text | Time service request was phoned in | 10:00 10:03 10:05 10:02 10:04 view top 100 |
CALL IN DATE | call_in_date | calendar_date | Date service request was phoned in | 2024-02-20T00:00:00.000 2024-02-21T00:00:00.000 2023-10-30T00:00:00.000 2024-02-16T00:00:00.000 2024-02-26T00:00:00.000 view top 100 |
OPERATOR LAST NAME | o_last_name | text | Last name of MARC employee who took service request | SCOTT JONES KNIGHTEN SMITH PERRY view top 100 |
OPERATOR FIRST NAME | o_first_name | text | First name of MARC employee who took service request | BARBARA ROSE TIARA SCENTELIA AISHENA view top 100 |
COMPANY NAME | company_name | text | Name of company requesting mosquito service | MONTESSORI SCHOOL OF BATON ROUGE GREATER COMMUNITY BAPTIST CHURCH CHILD DEVELOPMENT COOPERATIVE LIFE POINT CHURCH CENTRAL EARLY LEARNING CENTER view top 100 |
NO SPRAY APPLICATION | no_spray | text | Caller has requested inspection only-no spray application for mosquitoes | Yes view top 100 |
TYPE OF RESIDENCE | residence_type | text | Building type where service is requested | SINGLE FAMILY HOME BUSINESS DUPLEX TOWNHOME CONDO view top 100 |
ADDRESS | address | text | Street address of service request | 5730 LAKE SHADOW DR 16861 MAHONEY RD 148 LINDA AVE 5938 RIVERBEND BLVD 935 MAGNOLIA WOOD AVE view top 100 |
CITY | city_name | text | City where service is requested | BATON ROUGE ZACHARY BAKER GREENWELL SPRINGS CENTRAL view top 100 |
STATE | state | text | State where service is requested | LA view top 100 |
ZIP CODE | zip_code | number | Zip code of service request | 70808 70810 70817 70805 70791 view top 100 |
ZONE AND SECTION | zone_section | text | MARC specific geographic areas | C34 CENTRAL EAST R67B SOUTHEAST C49 CENTRAL WEST R71 SOUTHWEST R74 SOUTHWEST view top 100 |
INSPECTOR LAST NAME | i_last_name | text | Last name of MARC inspector conducting service request | HUDSON ROBINSON GRIER HAWKINS PERKINS view top 100 |
INSPECTOR FIRST NAME | i_first_name | text | First name of MARC inspector conductiong service request | LARRY CHRISTOPHER HAROLD JULIA SEDRICK view top 100 |
ARRIVAL TIME | inspect_timein | text | Time inspector arrived at service address | 09:15 09:00 08:40 09:05 09:25 view top 100 |
DEPARTURE TIME | inspect_timeout | text | Time inspector left service address | 08:48 09:30 09:07 10:00 09:56 view top 100 |
TIME FOR INSPECTION | inspect_time | text | Morning (AM), afternoon (PM) or anytime (AT) | AT AM PM view top 100 |
INSPECTION DATE | inspect_date | calendar_date | Date for service request | 2019-09-06T00:00:00.000 2023-11-07T00:00:00.000 2024-02-26T00:00:00.000 2024-02-22T00:00:00.000 2024-02-23T00:00:00.000 view top 100 |
INSPECTION DAY | inspect_day | text | Day of the week for service request | Friday Thursday Wednesday Tuesday Monday view top 100 |
CANCEL INSPECTION | cancel_inspection | checkbox | Service request has subsequently been cancelled | false true view top 100 |
GEOLOCATION | geolocation | point | Calculated geolocation of incident | {"coordinates":[-91.42641999999995,30.18584616700008],"type":"Point"} {"coordinates":[-90.98289,30.40152],"type":"Point"} {"coordinates":[-91.11322,30.44989],"type":"Point"} {"coordinates":[-91.11927,30.38402],"type":"Point"} {"coordinates":[-91.07496,30.47717],"type":"Point"} view top 100 |