crash_reports_fts
3 rows where "datetime" is on date 2021-03-01
This data as json, CSV (advanced)
Suggested facets: dcc, dcc_code, datetime (date), date (date), keywords (array), dcc (array)
| Link | rowid ▼ | case_number | datetime | date | time | address | narrative | keywords | dcc | dcc_code | geocoded_address | crash_reports_fts | rank |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2273 | 2273 | 2100000155 | 2021-03-01T05:54 | 2021-03-01 | 05:54 | CALIFORNIA ST & CRAFTS ST | Vehicle #1 a City of Newton Street Sweeper was traveling east on California St. at the intersection of California and Crafts when it stopped and reversed to go west in the east bound travel lane. At the same time Vehicle #2 was traveling south on Crafts St. and took a right turn to go east on California St. Once Vehicle #2 Made the turn onto California St. Vehicle #1 Reversed into its front end. Vehicle #1 sustained minor damage to its rear end. Vehicle #2 sustained minor damage to its front end. There were no injuries. Photos were taken of the damage and passed along to The Newton Police IT Bureau. | Pictures | Inattention | 19 | California St & Crafts St, Newton, MA 02460, USA | 44364 | |
| 2276 | 2276 | 2100000156 | 2021-03-01T12:40 | 2021-03-01 | 12:40 | 85 CHARLEMONT ST | REPORTING PARTY OF MV1 STATED SHE PARKED HER CAR IN FRONT OF HER HOUSE AT 85 CHARLEMONT STREET FRIDAY NIGHT. SOMETIME SUNDAY MORNING WHEN SHE WENT OUT TO HER CAR SHE NOTICED THE REAR DRIVER'S SIDE PANEL HAD SOME DAMAGE. THE TAIL LIGHT WAS ALSO CRACKED AND SOME DENTS RIGHT BELOW THE GAS TANK. MOST OF THE DAMAGE TO THE VEHICLE WAS MINOR AND DOES NOT INTERFERE WITH THE OPERATION OF THE VEHICLE. I INFORMED THE DRIVER TO CONTACT INSURANCE COMPANY AND REPORT THE DAMAGE. I CHECKED THE SURROUNDING AREA IF I COULD FIND ANY VEHICLE THAT MIGHT HAVE HAD FRESH DAMAGE OR PAINT THAT MATCHED THE COLOR OF MV1. I CAME UP WITH NEGATIVE RESULTS. | Night, Solar | [] | [] | 85 Charlemont St, Newton, MA 02461, USA | 44364 | |
| 2277 | 2277 | 2100000157 | 2021-03-01T19:14 | 2021-03-01 | 19:14 | BEACON ST & HAMMOND ST | MV#1 was stopped on Beacon St for the red light at the intersection of Beacon and Hammond. MV#2 was coming up behind MV#1 and did not stop in time, and crashed into the rear of MV#1. No injuries occurred. Both vehicles were driven off scene. | Crash | Inattention | 19 | Beacon St & Hammond St, Newton, MA 02467, USA | 44364 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [crash_reports_fts] USING FTS5 (
[case_number], [datetime], [date], [time], [address], [narrative], [keywords], [dcc], [dcc_code], [geocoded_address],
content=[crash_reports]
);