2e:null 2f:["$","title",null,{"children":"U.S. Train Accident Data 2009–2022 | Michael Bricknell | Observable"}] 34:T967,- "INCDTNO", // railroad assigned number - "STATE", // FIPS state code - "CNTYCD", // FIPS county code - //"STCNTY", // FIPS State & County code - "Latitude", // Latitude in decimal degrees, explicit decimal, explicit +/- (WGS84) - "Longitud", // Longitude in decimal degrees, explicit decimal, explicit +/- (WGS84) - "RAILROAD", // railroad code (Reporting RR) - "RR2", // railroad code (Other RR involved) - "RR3", // railroad code (RR responsible for track maintenance) - "SIGNAL", // Type of territory – signalization, 1 = signaled 2 = not signaled - "TYPE", // Type of accident: see function accidentTypeLookup(type) - "TONS", // Gross tonnage, excluding power units - "TRKDMG", // Track, signal, way & structure damage in $ - "EQPDMG", // Reportable equipment damage in $ - "ACCDMG", // Total reportable damage on all reports in $ - "CAUSE", // Primary cause of incident (refer to Appendix C) see function causesLookup(cause) - "CAUSE2", // Contributing cause of incident (refer to Appendix C) see function causesLookup(cause) - "DRUG", // # of positive drug tests - "ALCOHOL", // # of positive alcohol tests - "TRNDIR", // Train direction: 1=north 2=south 3=east 4=west - "TRNSPD", // Speed of train in miles per hour: Blank=unknown - "TYPSPD", // Train speed type: E=estimated R=recorded Blank=unknown - "TRKCLAS", // FRA track class: 1-9, X - "TRKDNSTY", // Annual track density-gross tonnage in millions note:(not consistent) - "CARS", // # of cars carrying hazmat - "CARSDMG", // # of hazmat cars damaged or derailed - "CARSHZD", // # of cars that released hazmat - "EVACUATE", // # of persons evacuated - "POSITON1", // Car position in train (first involved) - "POSITON2", // Car position in train (causing) - "LOADF1", // # of loaded freight cars - "LOADF2", // # of derailed loaded freight cars - "EMPTYF1", // # of empty freight cars - "EMPTYF2", // # of derailed empty freight cars - "LOADP1", // # of loaded passenger cars - "LOADP2", // # of derailed loaded passenger cars - "EMPTYP1", // # of empty passenger cars - "EMPTYP2", // # of derailted empty passenger cars - "DAY", // day of incident - "MONTH", // month of incident - "YEAR", // year of incident - "TIMEHR", // hour of incident - "TIMEMIN", // minute of incident - "AMPM", // AM or PM - "VISIBLTY", // Daylight period: 1=dawn 2=day 3=dusk 4=dark - "WEATHER" // Weather conditions: 1=clear 2=cloudy 3=rain 4=fog 5=sleet 6=snow35:Tdc8,accSelect = accidentsOriginal .select( "INCDTNO", // railroad assigned number "STATE", // FIPS state code "CNTYCD", // FIPS county code //"STCNTY", // FIPS State & County code "Latitude", // Latitude in decimal degrees, explicit decimal, explicit +/- (WGS84) "Longitud", // Longitude in decimal degrees, explicit decimal, explicit +/- (WGS84) "RAILROAD", // railroad code (Reporting RR) "RR2", // railroad code (Other RR involved) "RR3", // railroad code (RR responsible for track maintenance) "SIGNAL", // Type of territory – signalization, 1 = signaled 2 = not signaled "TYPE", // Type of accident: see function accidentTypeLookup(type) "TONS", // Gross tonnage, excluding power units "TRKDMG", // Track, signal, way & structure damage in $ "EQPDMG", // Reportable equipment damage in $ "ACCDMG", // Total reportable damage on all reports in $ "CAUSE", // Primary cause of incident (refer to Appendix C) see function causesLookup(cause) "CAUSE2", // Contributing cause of incident (refer to Appendix C) see function causesLookup(cause) "DRUG", // # of positive drug tests "ALCOHOL", // # of positive alcohol tests "TRNDIR", // Train direction: 1=north 2=south 3=east 4=west "TRNSPD", // Speed of train in miles per hour: Blank=unknown "TYPSPD", // Train speed type: E=estimated R=recorded Blank=unknown "TRKCLAS", // FRA track class: 1-9, X "TRKDNSTY", // Annual track density-gross tonnage in millions note:(not consistent) "CARS", // # of cars carrying hazmat "CARSDMG", // # of hazmat cars damaged or derailed "CARSHZD", // # of cars that released hazmat "EVACUATE", // # of persons evacuated "POSITON1", // Car position in train (first involved) "POSITON2", // Car position in train (causing) "LOADF1", // # of loaded freight cars "LOADF2", // # of derailed loaded freight cars "EMPTYF1", // # of empty freight cars "EMPTYF2", // # of derailed empty freight cars "LOADP1", // # of loaded passenger cars "LOADP2", // # of derailed loaded passenger cars "EMPTYP1", // # of empty passenger cars "EMPTYP2", // # of derailted empty passenger cars "DAY", // day of incident "MONTH", // month of incident "YEAR", // year of incident "TIMEHR", // hour of incident "TIMEMIN", // minute of incident "AMPM", // AM or PM "VISIBLTY", // Daylight period: 1=dawn 2=day 3=dusk 4=dark "WEATHER" // Weather conditions: 1=clear 2=cloudy 3=rain 4=fog 5=sleet 6=snow ) .derive({ TRKDMG: (d) => +d.TRKDMG }) .derive({ EQPDMG: (d) => +d.EQPDMG }) .derive({ ACCDMG: (d) => +d.ACCDMG }) //.derive({ Latitude: (d) => +d.Latitude }) //.derive({ Longitud: (d) => +d.Longitud }) .derive({ TONS: (d) => +d.TONS }) .derive({ STCNTY: (d) => d.STATE + d.CNTYCD }, { after: "CNTYCD" }) .derive({ VISIBLTY: aq.escape((d) => vis[+d.VISIBLTY]) }) .derive({ WEATHER: aq.escape((d) => weather[+d.WEATHER]) }) .derive({ TYPE: (d) => d.TYPE }) .derive( { TYPEDESC: aq.escape((d) => accidentTypeLookup[d.TYPE]) }, { after: "TYPE" } ) .derive({ DATESIMPLE: aq.escape((d) => new Date("20" + d.YEAR)) }) .derive({ DATETIME: aq.escape((d) => parseDateTime( d.MONTH + " " + d.DAY + " " + d.YEAR + " " + d.TIMEHR + " " + d.TIMEMIN + " " + d.AMPM ) ) }) .join_full(cntyLookup, ["STCNTY", "uid"]) .reify()36:Td80,accSelectAntiJoin = accidentsOriginal .select( "INCDTNO", // railroad assigned number "STATE", // FIPS state code "CNTYCD", // FIPS county code //"STCNTY", // FIPS State & County code "Latitude", // Latitude in decimal degrees, explicit decimal, explicit +/- (WGS84) "Longitud", // Longitude in decimal degrees, explicit decimal, explicit +/- (WGS84) "RAILROAD", // railroad code (Reporting RR) "RR2", // railroad code (Other RR involved) "RR3", // railroad code (RR responsible for track maintenance) "SIGNAL", // Type of territory – signalization, 1 = signaled 2 = not signaled "TYPE", // Type of accident: see function accidentTypeLookup(type) "TONS", // Gross tonnage, excluding power units "TRKDMG", // Track, signal, way & structure damage in $ "EQPDMG", // Reportable equipment damage in $ "ACCDMG", // Total reportable damage on all reports in $ "CAUSE", // Primary cause of incident (refer to Appendix C) see function causesLookup(cause) "CAUSE2", // Contributing cause of incident (refer to Appendix C) see function causesLookup(cause) "DRUG", // # of positive drug tests "ALCOHOL", // # of positive alcohol tests "TRNDIR", // Train direction: 1=north 2=south 3=east 4=west "TRNSPD", // Speed of train in miles per hour: Blank=unknown "TYPSPD", // Train speed type: E=estimated R=recorded Blank=unknown "TRKCLAS", // FRA track class: 1-9, X "TRKDNSTY", // Annual track density-gross tonnage in millions note:(not consistent) "CARS", // # of cars carrying hazmat "CARSDMG", // # of hazmat cars damaged or derailed "CARSHZD", // # of cars that released hazmat "EVACUATE", // # of persons evacuated "POSITON1", // Car position in train (first involved) "POSITON2", // Car position in train (causing) "LOADF1", // # of loaded freight cars "LOADF2", // # of derailed loaded freight cars "EMPTYF1", // # of empty freight cars "EMPTYF2", // # of derailed empty freight cars "LOADP1", // # of loaded passenger cars "LOADP2", // # of derailed loaded passenger cars "EMPTYP1", // # of empty passenger cars "EMPTYP2", // # of derailted empty passenger cars "DAY", // day of incident "MONTH", // month of incident "YEAR", // year of incident "TIMEHR", // hour of incident "TIMEMIN", // minute of incident "AMPM", // AM or PM "VISIBLTY", // Daylight period: 1=dawn 2=day 3=dusk 4=dark "WEATHER" // Weather conditions: 1=clear 2=cloudy 3=rain 4=fog 5=sleet 6=snow ) .derive({ TRKDMG: (d) => +d.TRKDMG }) .derive({ EQPDMG: (d) => +d.EQPDMG }) .derive({ ACCDMG: (d) => +d.ACCDMG }) //.derive({ Latitude: (d) => +d.Latitude }) //.derive({ Longitud: (d) => +d.Longitud }) .derive({ TONS: (d) => +d.TONS }) .derive({ STCNTY: (d) => d.STATE + d.CNTYCD }, { after: "CNTYCD" }) .derive({ VISIBLTY: aq.escape((d) => vis[+d.VISIBLTY]) }) .derive({ WEATHER: aq.escape((d) => weather[+d.WEATHER]) }) .derive({ TYPE: (d) => d.TYPE }) .derive( { TYPEDESC: aq.escape((d) => accidentTypeLookup[d.TYPE]) }, { after: "TYPE" } ) .derive({ DATETIME: aq.escape((d) => parseDate( d.MONTH + " " + d.DAY + " " + d.YEAR + " " + d.TIMEHR + " " + d.TIMEMIN + " " + d.AMPM ) ) }) .antijoin(cntyLookup, ["STCNTY", "uid"]) .reify()37:T507,hazardOvertime = accidentsOriginal .derive({ date: (d) => "20" + d.YEAR }) .groupby("date") .derive({ percar: aq.escape((d) => isFinite(d.CARSDMG / d.CARS) ? d.CARSDMG / d.CARS : 0 ) }) // damaged or derailed vs number of cars carrying hazmat .derive({ perhaz: aq.escape((d) => isFinite(d.CARSDMG / d.CARSHZD) ? d.CARSDMG / d.CARSHZD : 0 ) }) // release of hazmat vs number of cars damaged or hazmat .derive({ perdmg: aq.escape((d) => isFinite(d.CARSHZD / d.CARS) ? d.CARSHZD / d.CARS : 0 ) }) // release of hazmat vs number of cars carrying hazmat .rollup({ accidents: op.count(), cars: op.sum("CARS"), carsdmg: op.sum("CARSDMG"), avgcarshzd: op.average("percar"), aveperhaz: op.average("perhaz"), aveperdmg: op.average("perdmg"), evacuate: op.sum("EVACUATE"), damage: op.sum("ACCDMG"), damage_avg: op.average("ACCDMG"), evacuate_avg: op.average("EVACUATE") /* "CARS", // # of cars carrying hazmat "CARSDMG", // # of hazmat cars damaged or derailed "CARSHZD", // # of cars that released hazmat "EVACUATE", // # of persons evacuated */ }) //.impute({ avgcarshzd: () => 0 }) //.impute({ aveperhaz: () => 0 }) //.impute({ aveperdmg: () => 0 }) .reify()38:[{"id":"fa8c031d9160bed73ed48cb2bf7e26a34c5bf423463b9cf11054f9e7f7cca879926df7d58b8025f5fd9c809035a6858993a4dad5c9baa0adf6201ad279f3dfaf","href":"https://static.observableusercontent.com/files/fa8c031d9160bed73ed48cb2bf7e26a34c5bf423463b9cf11054f9e7f7cca879926df7d58b8025f5fd9c809035a6858993a4dad5c9baa0adf6201ad279f3dfaf","name":"Screenshot 2023-03-07 at 8.37.09 AM.png","type":"image/png","lastModified":1678196293207.181,"size":425271},{"id":"9dec8a8590ba324b9afef1db53b74dc037d40ce6bf04520750d8b692b998d3243fc4f68064ea87c43d0c83c226f3f654dcc2384bd1a7f477df43bb612a5175ef","href":"https://static.observableusercontent.com/files/9dec8a8590ba324b9afef1db53b74dc037d40ce6bf04520750d8b692b998d3243fc4f68064ea87c43d0c83c226f3f654dcc2384bd1a7f477df43bb612a5175ef","name":"accfile_EFFECTIVE_060111.pdf","type":"application/pdf","lastModified":1677517087750.676,"size":81541},{"id":"ec41287d47ad13618ea079ccbe92f68af79106be68c0c25c9b6dd86bf78d41f5210fb851675c4c95cc906f96f2ae43cf13312c6887af22757ea51817581ccc73","href":"https://static.observableusercontent.com/files/ec41287d47ad13618ea079ccbe92f68af79106be68c0c25c9b6dd86bf78d41f5210fb851675c4c95cc906f96f2ae43cf13312c6887af22757ea51817581ccc73","name":"Appendix C - Train Accident Cause Codes (1).csv","type":"text/csv","lastModified":1677603873223.295,"size":44339},{"id":"3d347e377e8d79b3a818b9a3da45f1f55e95518154c8b326fa7ee7db46ab6a2488cbf3f4839e37f67c5d5a688950470a8e8d9dabdcf75a5d5ddfb65c73f1e486","href":"https://static.observableusercontent.com/files/3d347e377e8d79b3a818b9a3da45f1f55e95518154c8b326fa7ee7db46ab6a2488cbf3f4839e37f67c5d5a688950470a8e8d9dabdcf75a5d5ddfb65c73f1e486","name":"Cars_On_Line.csv","type":"text/csv","lastModified":1677759026558.331,"size":1105696},{"id":"6b342fd24ebd589c0364deef621f885c5b58b1197fb0ea968782610c6bcb66e4befb3a9332d5ad5f508cafb5d21c9d08da192c9fdadca413213baf183c92c301","href":"https://static.observableusercontent.com/files/6b342fd24ebd589c0364deef621f885c5b58b1197fb0ea968782610c6bcb66e4befb3a9332d5ad5f508cafb5d21c9d08da192c9fdadca413213baf183c92c301","name":"Rail_Carloadings.csv","type":"text/csv","lastModified":1677759028431.236,"size":5682896},{"id":"afe61f20e9bfa5def81429bd93e221c957ea7aa8349d20900cee745913d91fd74b8b0c36d92d9b7bcffbf3bc9571c9206e8fbd5d8d7eacd83440ea5cc7d204ea","href":"https://static.observableusercontent.com/files/afe61f20e9bfa5def81429bd93e221c957ea7aa8349d20900cee745913d91fd74b8b0c36d92d9b7bcffbf3bc9571c9206e8fbd5d8d7eacd83440ea5cc7d204ea","name":"cntyCenters.json","type":"application/json","lastModified":1677766481475.336,"size":179451}] 32:{"id":"2dc1512ca7ddd46a","slug":"us-train-accident-data","title":"U.S. Train Accident Data 2009–2022","thumbnail":"20aa02fc2ee23506e865c5112a71f20afbdd904c3c202b54ee94c77e50920001","access_level":"public","create_time":"$D2023-02-27T00:09:10.542Z","update_time":"$D2023-03-11T14:25:26.164Z","view_time":null,"first_public_time":"$D2023-03-03T13:09:31.461Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"aa36944c9e64c088","login":"mbrickmaps","name":"Michael Bricknell","avatar_url":"https://avatars-next.observableusercontent.com/2f0578a8eeb34ee1c8a3bd6be41477c4bc13989c0c53551154178a64c9f2945f","tier":"pro_2024"},"version":4095,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"8a8aec8a4dd1da2d","login":"mbrickmaps","name":"Michael Bricknell","avatar_url":"https://avatars-next.observableusercontent.com/669d4a33f00b7dbf619507bedb374f580b5457ee3c0717ba47d37e4869518958","tier":null}],"members":[{"type":"individual","id":"8a8aec8a4dd1da2d","login":"mbrickmaps","name":"Michael Bricknell","avatar_url":"https://avatars-next.observableusercontent.com/669d4a33f00b7dbf619507bedb374f580b5457ee3c0717ba47d37e4869518958","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"2f71d064e45acb0b","slug":"carto","title":"Carto","owner":{"id":"aa36944c9e64c088","login":"mbrickmaps","name":"Michael Bricknell"}},"type":"notebook","body":{"title":"U.S. Train Accident Data 2009–2022","cells":[{"id":1943,"value":"# U.S. Train Accident Data 2009–2022","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3757,"value":"*See TOC below*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3751,"value":"rawData = accidentsOriginal.objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3878,"value":"data","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2903,"value":"screenshot20230307At83709Am = FileAttachment(\"Screenshot 2023-03-07 at 8.37.09 AM.png\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":897,"value":"toc()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2004,"value":"# Process\n - Collect data ✅\n - FRA \n - STB\n - Revenue and Earnings (to do)\n - [Data collection process FRA](https://observablehq.com/@mbrickmaps/dot-accidentreport)\n - [Data collection process STB](https://observablehq.com/@mbrickmaps/stb-economic)\n - [Railroad company names](https://observablehq.com/@mbrickmaps/dot-railroad-company)\n - Clean/Validate 👈\n - Ask Questions? 👈\n - Analyze 👈\n - What/Who stands out\n - What are the limitations\n - What looks interesting\n - Story concept\n - Design wireframe\n - More data, new data to update?\n - Revisit Design\n - Design Mockup\n - Build\n - Test\n ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2927,"value":"---\n# Helpers\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2934,"value":"accidentTypeLookup","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2943,"value":"accidentTypeLookup[\"01\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2953,"value":"causesLookup","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2938,"value":"causesLookup(\"T301\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":339,"value":"vis = ({ 1: \"dawn\", 2: \"day\", 3: \"dusk\", 4: \"dark\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":347,"value":"weather = ({\n 1: \"clear\",\n 2: \"cloudy\",\n 3: \"rain\",\n 4: \"fog\",\n 5: \"sleet\",\n 6: \"snow\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"parseDate = d3.timeParse(\"%m %d %Y\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1027,"value":"parseDateTime = d3.timeParse(\"%m %d %y %I %M %p\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4072,"value":"d3.utcYear(\"2022-01-01\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2932,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":902,"value":"# County Codes and Centroids","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1954,"value":"After mapping out the original dataset there are inconsistencies in the data 'Longitud' and 'Latitude', to counteract this uncertainty I've remapped each event to the County FIPS code and extracted the centroid of the county. I am wanting to make all the data points consistent to a minimal standard, in doing so we are giving up some accuracy, but still keeping the original data if so desired.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":817,"value":"cntyLookup = aq.from(cntyCenters)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":830,"value":"cnty = cntyLookup","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":956,"value":"cnty.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":904,"value":"# Accident Causes","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":410,"value":"causesCSV = await FileAttachment(\n \"Appendix C - Train Accident Cause Codes (1).csv\"\n).csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":417,"value":"causes.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":414,"value":"causes = aq.from(causesCSV)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":601,"value":"causes.dedupe(\"Title\").array(\"Title\").sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":910,"value":"# Accident Attributes\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":276,"value":"I've reviewed and selected columns to keep. I've selected 46 columns (145 => 46) based on documentation found [here](${await accfile_effective_060111.url()})","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1248,"value":"$34","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1207,"value":"# **\\* The Data **","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1216,"value":"👇","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1983,"value":"The most recent dataset as of Dec. 2022","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":18,"value":"accidentsOriginal = aq.from(rawAll)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":934,"value":"$35","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":914,"value":"46 columns (selected from 145), with county centroids (6 columns added), datetime, centroids(lat,lng), added Accident Type Code description, Visiblty and Weather codes","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":931,"value":"accSelect.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1246,"value":"☝️","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2060,"value":"viewof byRailroadAccident = accSelect\n .orderby(aq.desc(\"DATETIME\"))\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .groupby(\"RAILROAD\")\n .rollup({\n count: op.count(),\n sum: op.sum(\"ACCDMG\"),\n avg: op.average(\"ACCDMG\"),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"sum\"))\n .ungroup()\n .view(10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2387,"value":"viewof byAccidentType = accSelect\n .orderby(aq.desc(\"DATETIME\"))\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .groupby(\"TYPEDESC\")\n .rollup({\n count: op.count(),\n dmg_sum: op.sum(\"ACCDMG\"),\n dmg_avg: op.average(\"ACCDMG\"),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"dmg_sum\"))\n .ungroup()\n .view(10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3520,"value":"# Main Causes","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3529,"value":"viewof byAccidentCausebyTitle = accSelect\n .filter((d) => d.TYPE == \"01\")\n .orderby(aq.desc(\"DATETIME\"))\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .derive({ title: aq.escape((d) => causesLookupType(d.CAUSE, \"Title\")) })\n .groupby(\"title\")\n .rollup({\n count: op.count(),\n dmg_sum: op.sum(\"ACCDMG\"),\n dmg_avg: op.average(\"ACCDMG\"),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"count\"))\n .ungroup()\n .view(10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3533,"value":"viewof byAccidentCausebyCategory = accSelect\n .filter((d) => d.TYPE == \"01\")\n .orderby(aq.desc(\"DATETIME\"))\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .derive({ category: aq.escape((d) => causesLookupType(d.CAUSE, \"Category\")) })\n .groupby(\"category\")\n .rollup({\n count: op.count(),\n dmg_sum: op.sum(\"ACCDMG\"),\n dmg_avg: op.average(\"ACCDMG\"),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"count\"))\n .ungroup()\n .view(10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2977,"value":"# Top primary cause of derailments","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2958,"value":"viewof byAccidentCause = accSelect\n .filter((d) => d.TYPE == \"01\")\n .orderby(aq.desc(\"DATETIME\"))\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .groupby(\"CAUSE\")\n .rollup({\n count: op.count(),\n dmg_sum: op.sum(\"ACCDMG\"),\n dmg_avg: op.average(\"ACCDMG\"),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"count\"))\n .ungroup()\n .view(10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2964,"value":"causesLookup(\"T110\").Code + \" - \" + causesLookup(\"T110\").Description","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2962,"value":"causesLookup(\"H702\").Code + \" - \" + causesLookup(\"H702\").Description","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2966,"value":"causesLookup(\"T207\").Code + \" - \" + causesLookup(\"T207\").Description","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3466,"value":"# Top causes by total damage","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3464,"value":"viewof byAccidentCause1 = accSelect\n .filter((d) => d.TYPE == \"01\")\n .orderby(aq.desc(\"DATETIME\"))\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .groupby(\"CAUSE\")\n .rollup({\n count: op.count(),\n dmg_sum: op.sum(\"ACCDMG\"),\n dmg_avg: op.average(\"ACCDMG\"),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"dmg_sum\"))\n .ungroup()\n .view(10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3486,"value":"causesLookup(\"T207\").Code + \" - \" + causesLookup(\"T207\").Description","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3489,"value":"causesLookup(\"T109\").Code + \" - \" + causesLookup(\"T109\").Description","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3492,"value":"causesLookup(\"E61C\").Code + \" - \" + causesLookup(\"E61C\").Description","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3495,"value":"causesLookup(\"M105\").Code + \" - \" + causesLookup(\"M105\").Description","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3498,"value":"causesLookup(\"T110\").Code + \" - \" + causesLookup(\"T110\").Description","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3472,"value":"# Top causes by ave damage per accident","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3470,"value":"viewof byAccidentCause2 = accSelect\n .filter((d) => d.TYPE == \"01\")\n .orderby(aq.desc(\"DATETIME\"))\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .groupby(\"CAUSE\")\n .rollup({\n count: op.count(),\n dmg_sum: op.sum(\"ACCDMG\"),\n dmg_avg: op.average(\"ACCDMG\"),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"dmg_avg\"))\n .ungroup()\n .view(10)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3503,"value":"causesLookup(\"H604\").Code + \" - \" + causesLookup(\"H604\").Description","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3506,"value":"causesLookup(\"M406\").Code + \" - \" + causesLookup(\"M406\").Description","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3508,"value":"causesLookup(\"E68L\").Code + \" - \" + causesLookup(\"E68L\").Description","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3511,"value":"causesLookup(\"T213\").Code + \" - \" + causesLookup(\"T213\").Description","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3515,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3764,"value":"# Total evacuated by railroad","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2396,"value":"viewof byEvacuate = accSelect\n .orderby(aq.desc(\"DATETIME\"))\n .filter((d) => d.EVACUATE > 0)\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .groupby(\"RAILROAD\")\n .rollup({\n count: op.count(),\n dmg_sum: op.sum(\"ACCDMG\"),\n dmg_avg: op.average(\"ACCDMG\"),\n evacuated_avg: op.average(\"EVACUATE\"),\n evacuated: op.sum(\"EVACUATE\"),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"evacuated\"))\n .ungroup()\n .view(10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3766,"value":"viewof byEvacuateAve = accSelect\n .orderby(aq.desc(\"DATETIME\"))\n .filter((d) => d.EVACUATE > 0)\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .groupby(\"RAILROAD\")\n .rollup({\n count: op.count(),\n dmg_sum: op.sum(\"ACCDMG\"),\n dmg_avg: op.average(\"ACCDMG\"),\n evacuated_avg: op.average(\"EVACUATE\"),\n evacuated: op.sum(\"EVACUATE\"),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n //.filter((d) => d.count > 10)\n .orderby(aq.desc(\"evacuated_avg\"))\n .ungroup()\n .view(10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2404,"value":"viewof byHazardReleased = accSelect\n .orderby(aq.desc(\"DATETIME\"))\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .groupby(\"RAILROAD\")\n .rollup({\n count: op.count(),\n dmg_sum: op.sum(\"ACCDMG\"),\n dmg_avg: op.average(\"ACCDMG\"),\n evacuated: op.sum(\"EVACUATE\"),\n hazard: op.sum(\"CARSHZD\"),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"hazard\"))\n .ungroup()\n .view(10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2125,"value":"iUP = byRailroadAccident.filter((d) => d.RAILROAD == \"UP\").get(\"rows\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2232,"value":"iBNSF = byRailroadAccident.filter((d) => d.RAILROAD == \"BNSF\").get(\"rows\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2235,"value":"iCSX = byRailroadAccident.filter((d) => d.RAILROAD == \"CSX\").get(\"rows\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2238,"value":"iNS = byRailroadAccident.filter((d) => d.RAILROAD == \"NS\").get(\"rows\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2240,"value":"iATK = byRailroadAccident.filter((d) => d.RAILROAD == \"ATK\").get(\"rows\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2149,"value":"data = accSelect.objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2195,"value":"Plot.plot({\n x: { tickFormat: null, type: \"band\" },\n marks: [\n Plot.barY(\n accSelect,\n Plot.binX(\n {\n y: \"count\"\n },\n { x: \"DATETIME\", fill: \"RAILROAD\", transform: customTransform }\n )\n ),\n Plot.ruleY([0])\n ],\n color: {\n legend: true\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2213,"value":"Plot.plot({\n x: { tickFormat: \"%Y\", type: \"band\" },\n marks: [\n Plot.barY(\n data,\n Plot.binX(\n { y: \"count\" },\n {\n x: (d) => new Date(\"20\" + d[\"YEAR\"]),\n fill: \"RAILROAD\",\n transform: customTransform\n }\n )\n ),\n\n Plot.ruleY([0])\n ],\n color: {\n legend: true\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2275,"value":"function customTransform(data, facets) {\n return {\n data,\n facets: facets.map((facet) => {\n return facet.filter((i) => {\n return [\"UP\", \"BNSF\", \"CSX\", \"NS\"].indexOf(data[i].RAILROAD) > -1;\n });\n })\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2078,"value":"viewof byRailroadDerailment = accSelect\n .orderby(aq.desc(\"DATETIME\"))\n .filter((d) => d.TYPE == \"01\")\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .groupby(\"RAILROAD\")\n .rollup({\n count: op.count(),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"count\"))\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2118,"value":"viewof byCountyDerailment = accSelect\n .orderby(aq.desc(\"DATETIME\"))\n .filter((d) => d.TYPE == \"01\")\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .groupby(\"label\")\n .rollup({\n count: op.count(),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"count\"))\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2113,"value":"viewof byOwnershipDerailment = accSelect\n .orderby(aq.desc(\"DATETIME\"))\n .filter((d) => d.TYPE == \"01\")\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .groupby(\"RR3\")\n .rollup({\n count: op.count(),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"count\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2085,"value":"viewof byRailroadDerailment1 = accSelect\n .orderby(aq.desc(\"DATETIME\"))\n .filter((d) => d.TYPE == \"11\")\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .groupby(\"RAILROAD\")\n .rollup({\n count: op.count(),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"count\"))\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2088,"value":"viewof byRailroadDerailment2 = accSelect\n .orderby(aq.desc(\"DATETIME\"))\n .filter((d) => d.TYPE == \"10\")\n .derive({ index: (d) => op.row_number() - 1 }) // <-- add row indices before grouping\n .groupby(\"RAILROAD\")\n .rollup({\n count: op.count(),\n rows: op.array_agg(\"index\") // <-- aggregate row indices\n })\n .orderby(aq.desc(\"count\"))\n .view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2081,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2071,"value":"viewof byIncdtno = accSelect\n .orderby(aq.desc(\"DATETIME\"))\n .derive({ index: (d) => op.row_number() - 1 })\n .groupby(\"INCDTNO\")\n .rollup({\n count: op.count(),\n rows: op.array_agg(\"index\")\n })\n .orderby(aq.desc(\"count\"))\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2064,"value":"viewof railroadTables = byRailroadAccident\n .columnArray(\"rows\")\n .map((indices) => accSelect.reify(indices))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":926,"value":"Antijoin to see which data that do not match counties data set.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":613,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1733,"value":"Need to fix these records","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":248,"value":"accSelectAntiJoin.dedupe(\"STCNTY\").array(\"STCNTY\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":979,"value":"accSelectAntiJoin.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":491,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1752,"value":"# Data domain","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":495,"value":"Review each column for missing data.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":620,"value":"35188 entires based on INCDTNO, unique entries.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":617,"value":"accidentsOriginal.array(\"INCDTNO\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":623,"value":"30577 unique events based on removing duplicate INCDTNO","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":142,"value":"accidentsOriginal.dedupe(\"INCDTNO\").array(\"INCDTNO\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":625,"value":"520 Railroad entities have recorded accidents","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":88,"value":"railroad = accidentsOriginal.dedupe(\"RAILROAD\").array(\"RAILROAD\").sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":656,"value":"347 secondary railroad entities have recorded accidents","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":628,"value":"rr2 = accidentsOriginal.dedupe(\"RR2\").array(\"RR2\").sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":650,"value":"648 total primary and secondary entities if multiple involved in accident","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":642,"value":"Array.from(new Set([].concat(railroad).concat(rr2)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":648,"value":"1363 Entities responsible for maintaining rails","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":630,"value":"rr3 = accidentsOriginal.dedupe(\"RR3\").array(\"RR3\").sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":660,"value":"1453 Entities if any involvement as the primary, secondary, or maintainer","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":644,"value":"Array.from(new Set([].concat(railroad).concat(rr2).concat(rr3)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"accidentsOriginal.dedupe(\"YEAR\").array(\"YEAR\").sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":572,"value":"accidentsOriginal.dedupe(\"DAY\").array(\"DAY\").sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":576,"value":"accidentsOriginal.dedupe(\"MONTH\").array(\"MONTH\").sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":258,"value":"aq.agg(accSelect, op.max(\"TRKDMG\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":250,"value":"aq.agg(accSelect, op.max(\"EQPDMG\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":256,"value":"aq.agg(accSelect, op.max(\"ACCDMG\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":570,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1754,"value":"# Temporal Derailments","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3541,"value":"dataDailyAccidentFrequency = accidentsOriginal\n .derive({\n date: aq.escape((d) =>\n d3.utcFormat(d.MONTH + \"/\" + d.DAY + \"/20\" + d.YEAR)()\n )\n })\n .groupby(\"date\")\n .rollup({\n accidents: op.count(),\n cars: op.sum(\"CARS\"),\n carsdmg: op.sum(\"CARSDMG\"),\n damage: op.sum(\"ACCDMG\"),\n damage_avg: op.average(\"ACCDMG\")\n /*\n \"CARS\", // # of cars carrying hazmat\n \"CARSDMG\", // # of hazmat cars damaged or derailed\n \"CARSHZD\", // # of cars that released hazmat\n \"EVACUATE\", // # of persons evacuated\n*/\n })\n .objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1058,"value":"dataDailyDerailmentFrequency = accidentsOriginal\n .filter((d) => d.TYPE == \"01\")\n .derive({\n date: aq.escape((d) =>\n d3.utcFormat(d.MONTH + \"/\" + d.DAY + \"/20\" + d.YEAR)()\n )\n })\n .groupby(\"date\")\n .rollup({\n accidents: op.count(),\n damage: op.sum(\"ACCDMG\"),\n damage_avg: op.average(\"ACCDMG\")\n })\n .objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2914,"value":"dataCountYearly = accidentsOriginal\n .filter((d) => d.TYPE == \"01\")\n .derive({\n date: aq.escape((d) => \"20\" + d.YEAR)\n })\n .groupby(\"date\")\n .rollup({\n accidents: op.count(),\n damage: op.sum(\"ACCDMG\"),\n damage_avg: op.average(\"ACCDMG\")\n })\n .orderby(aq.desc(\"date\"))\n .objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2843,"value":"dataAccidentFrequencyGreaterThan1M = accidentsOriginal\n .filter((d) => d.TYPE == \"01\")\n .derive({\n date: aq.escape((d) =>\n d3.utcFormat(d.MONTH + \"/\" + d.DAY + \"/20\" + d.YEAR)()\n )\n })\n .groupby(\"date\")\n .rollup({\n accidents: op.count(),\n damage: op.sum(\"ACCDMG\"),\n damage_avg: op.average(\"ACCDMG\")\n })\n .filter((d) => d.accidents > 1)\n .objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3576,"value":"$37","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3944,"value":"hazardOvertime","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3713,"value":"byEvacuation = accidentsOriginal\n .filter((d) => d.EVACUATE > 0)\n .derive({\n date: (d) => d.YEAR\n })\n .groupby(\"date\")\n .derive({ percar: (d) => +d.CARSDMG / +d.CARS }) // damaged or derailed by number of cars carrying hazmat\n .derive({ perhaz: (d) => +d.CARSHZD / +d.CARSDMG }) // release of hazmat by number of cars damaged or hazmat\n .derive({ perdmg: (d) => +d.CARSHZD / +d.CARS }) // release of hazmat by number of cars carrying hazmat\n .rollup({\n accidents: op.count(),\n cars: op.sum(\"CARS\"),\n carsdmg: op.sum(\"CARSDMG\"),\n avgcarshzd: op.average(\"percar\"),\n aveperhaz: op.average(\"perhaz\"),\n aveperdmg: op.average(\"perdmg\"),\n evacuate: op.sum(\"EVACUATE\"),\n damage: op.sum(\"ACCDMG\"),\n damage_avg: op.average(\"ACCDMG\"),\n evacuate_avg: op.average(\"EVACUATE\")\n /*\n \"CARS\", // # of cars carrying hazmat\n \"CARSDMG\", // # of hazmat cars damaged or derailed\n \"CARSHZD\", // # of cars that released hazmat\n \"EVACUATE\", // # of persons evacuated\n*/\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3614,"value":"hazardOvertime.objects().map((d) => ({ value: d.accidents, date: d.date }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3606,"value":"hazardOvertime.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3669,"value":"Plot.plot({\n height: 300,\n y: { label: \"Number of accidents\" },\n x: { tickFormat: \"%Y\", type: \"band\" },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(\n hazardOvertime\n .objects()\n .map((d) => ({ value: d.accidents, date: new Date(\"20\" + d.date) })),\n { x: \"date\", y: \"value\", fill: \"steelblue\" }\n ),\n Plot.text(\n [`Train accidents where trains were transporting hazardous materials.`],\n {\n dy: 45,\n frameAnchor: \"bottom-left\"\n }\n )\n ],\n marginBottom: 75\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3698,"value":"Plot.plot({\n height: 300,\n y: { label: \"People evacuated\" },\n x: { tickFormat: \"%Y\", type: \"band\" },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(\n byEvacuation\n .objects()\n .map((d) => ({ value: d.evacuate, date: new Date(\"20\" + d.date) })),\n { x: \"date\", y: \"value\", fill: \"steelblue\" }\n ),\n Plot.text(\n [\n `Total number of people evacuated \\n due to a reported train accident.`\n ],\n {\n dy: 45,\n frameAnchor: \"bottom-left\"\n }\n )\n ],\n marginBottom: 75\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3701,"value":"Plot.plot({\n height: 300,\n y: {\n label: \"Average number of people evacuated per accident\"\n },\n x: { tickFormat: \"%Y\", type: \"band\" },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(\n byEvacuation\n .objects()\n .map((d) => ({ value: d.evacuate_avg, date: new Date(\"20\" + d.date) })),\n { x: \"date\", y: \"value\", fill: \"steelblue\" }\n ),\n Plot.text(\n [`Average number of people evacuated due to any train accident.`],\n {\n dy: 45,\n frameAnchor: \"bottom-left\"\n }\n )\n ],\n marginBottom: 75\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3672,"value":"Plot.plot({\n height: 300,\n x: { tickFormat: \"%Y\", type: \"band\" },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(\n dataCountYearly.map((d) => ({\n value: d.accidents,\n date: new Date(\"20\" + d.date)\n })),\n { x: \"date\", y: \"value\", fill: \"steelblue\" }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3632,"value":"Plot.plot({\n height: 300,\n x: { tickFormat: \"%Y\", type: \"band\" },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(\n hazardOvertime\n .objects()\n .map((d) => ({ value: d.accidents, date: new Date(\"20\" + d.date) })),\n { x: \"date\", y: \"value\", fill: \"steelblue\" }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3637,"value":"Plot.plot({\n height: 300,\n x: { tickFormat: \"%Y\", type: \"band\" },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(\n hazardOvertime\n .objects()\n .map((d) => ({ value: d.cars, date: new Date(\"20\" + d.date) })),\n { x: \"date\", y: \"value\", fill: \"steelblue\" }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3640,"value":"Plot.plot({\n height: 300,\n x: { tickFormat: \"%Y\", type: \"band\" },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(\n hazardOvertime\n .objects()\n .map((d) => ({ value: d.carsdmg, date: new Date(\"20\" + d.date) })),\n { x: \"date\", y: \"value\", fill: \"steelblue\" }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3643,"value":"Plot.plot({\n height: 300,\n y: { tickFormat: \"%\" },\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(\n hazardOvertime\n .objects()\n .map((d) => ({ value: d.avgcarshzd, date: new Date(\"20\" + d.date) })),\n { x: \"date\", y: \"value\" }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3913,"value":"hazardOvertime.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3645,"value":"Plot.plot({\n height: 300,\n //damaged or derailed hazmat vs number of cars carrying hazmat (not leaking)\n y: { tickFormat: \"%\" },\n x: { type: \"point\" },\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(\n hazardOvertime\n .objects()\n .map((d) => ({ value: d.aveperhaz, date: d.date })),\n { x: \"date\", y: \"value\" }\n //\"CARS\", # of cars carrying hazmat\n //\"CARSDMG\", # of hazmat cars damaged or derailed\n //\"CARSHZD\", # of cars that released hazmat\n //percar: (d) => +d.CARSDMG / +d.CARS }) // damaged or derailed vs number of cars carrying hazmat\n //perhaz: (d) => +d.CARSHZD / +d.CARSDMG }) // release of hazmat vs number of cars damaged or hazmat\n //perdmg: (d) => +d.CARSHZD / +d.CARS }) // release of hazmat vs number of cars carrying hazmat\n //avgcarshzd: op.average(\"percar\"),\n //aveperhaz: op.average(\"perhaz\"),\n //aveperdmg: op.average(\"perdmg\"),\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3650,"value":"Plot.plot({\n height: 300,\n y: { tickFormat: \"%\" },\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(\n hazardOvertime\n .objects()\n .map((d) => ({ value: d.aveperdmg, date: new Date(\"20\" + d.date) })),\n { x: \"date\", y: \"value\" }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3655,"value":"Plot.plot({\n height: 300,\n y: { tickFormat: \"~s\" },\n x: { tickFormat: \"%Y\", type: \"band\" },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(\n hazardOvertime\n .objects()\n .map((d) => ({ value: d.damage, date: new Date(\"20\" + d.date) })),\n { x: \"date\", y: \"value\", fill: \"steelblue\" }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3659,"value":"Plot.plot({\n height: 300,\n y: { tickFormat: \"~s\" },\n x: { tickFormat: \"%Y\", type: \"band\" },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(\n hazardOvertime\n .objects()\n .map((d) => ({ value: d.damage_avg, date: new Date(\"20\" + d.date) })),\n { x: \"date\", y: \"value\", fill: \"steelblue\" }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1168,"value":"Array.from(\n new Set(\n dataDailyDerailmentFrequency.map((d) => {\n return Number(d.accidents);\n })\n )\n).sort((a, b) => {\n return b - a;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1225,"value":"# Number of Derailments Calendar","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1972,"value":"Thank you for this lovely work [Fil](https://observablehq.com/@fil)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2444,"value":"Number of Derailments on a given day.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2432,"value":"Calendar(dataDailyDerailmentFrequency, {\n fill: \"accidents\",\n weekNumber: true,\n textFill: \"none\",\n title: (d) => `${d.accidents} derailments`,\n color: {\n scheme: \"OrRd\",\n domain: [0, 15],\n type: \"linear\",\n reverse: false,\n legend: true\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2446,"value":"\nThe above is difficult to see if there is anything of interest. I think an interesting place to start is to view the days with most damage caused, and most average damaged per event. Let's see, who and where these outliers are, if they are part of the top operators, then another reason to dig deeper.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2592,"value":"/*Calendar(dataAccidentFrequency, {\n fill: \"damage_avg\",\n weekNumber: true,\n textFill: \"none\",\n title: (d) =>\n `${d3.format(\"($.2~s\")(d.damage_avg)} ave dmg,\\n${d.accidents} derailments`,\n color: {\n scheme: \"OrRd\",\n domain: [1e10, 10e3],\n type: \"log\",\n reverse: false\n }\n})*/","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2525,"value":"Train derailments have occurred at least once a day (85% of the year) during 2022.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1056,"value":"Calendar(\n dataAccidentFrequencyGreaterThan1M.map((d) => d.date),\n {\n textFill: \"none\",\n weekNumber: true\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2469,"value":"Plot.dot(dataDailyDerailmentFrequency, {\n marginTop: 50,\n marginBottom: 50,\n y: \"damage_avg\",\n x: \"accidents\",\n title: (d) =>\n `${d.date}\\n${d3.format(\"($.2~s\")(d.damage)} in average damage,\\n ${\n d.accidents\n } derailments`\n}).plot({\n x: {\n label: \"Number of Derailments\"\n },\n y: {\n label: \"Average Damage per Derailment\",\n tickFormat: \"~s\"\n },\n marks: [\n Plot.text(\n dataDailyDerailmentFrequency\n .sort((a, b) => b[\"damage_avg\"] - a[\"damage_avg\"])\n .slice(0, 5),\n {\n x: \"accidents\",\n y: \"damage_avg\",\n text: (d) => `${d.date}`,\n dy: -8,\n dx: 30\n }\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2491,"value":"Plot.dot(dataDailyDerailmentFrequency, {\n marginTop: 50,\n marginBottom: 50,\n y: \"damage\",\n x: \"accidents\",\n title: (d) =>\n `${d.date}\\n${d3.format(\"($.2~s\")(d.damage)} in total damage,\\n ${\n d.accidents\n } derailments`\n}).plot({\n x: {\n label: \"Number of Derailments\"\n },\n y: {\n label: \"Total Damage caused on a single day by train derailments (log)\",\n type: \"log\",\n tickFormat: \"~s\"\n },\n marks: [\n Plot.text(\n dataDailyDerailmentFrequency\n .sort((a, b) => b[\"damage\"] - a[\"damage\"])\n .slice(0, 5),\n {\n x: \"accidents\",\n y: \"damage\",\n text: (d) => `${d.date}`,\n dy: -8,\n dx: 30\n }\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2482,"value":"Plot.dot(dataDailyDerailmentFrequency, {\n marginTop: 50,\n marginBottom: 50,\n y: \"damage_avg\",\n x: \"accidents\",\n title: (d) =>\n `${d.date}\\n${d3.format(\"($.2~s\")(d.damage)} in averaged damage,\\n ${\n d.accidents\n } derailments`\n}).plot({\n x: {\n label: \"Number of Derailments\"\n },\n y: {\n label: \"Average Damage per Derailment (log)\",\n type: \"log\",\n tickFormat: \"~s\"\n },\n marks: [\n Plot.text(\n dataDailyDerailmentFrequency\n .sort((a, b) => b[\"damage_avg\"] - a[\"damage_avg\"])\n .slice(0, 5),\n {\n x: \"accidents\",\n y: \"damage_avg\",\n text: (d) => `${d.date}`,\n dy: -8,\n dx: 30\n }\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":493,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2558,"value":"dataDailyDerailmentFrequency\n .sort((a, b) => b[\"damage_avg\"] - a[\"damage_avg\"])\n .slice(0, 25)\n .map((d) => new Date(d.date))\n .sort((a, b) => a - b)\n .map((d) => d3.timeFormat(\"%d/%m/%Y\")(d))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2461,"value":"top25total_dmg = dataDailyDerailmentFrequency\n .sort((a, b) => b[\"damage\"] - a[\"damage\"])\n .slice(0, 25)\n .map((d) => new Date(d.date))\n .sort((a, b) => a - b)\n//.map((d) => d3.timeFormat(\"%d/%m/%Y\")(d))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2632,"value":"Plot.plot({\n marks: [\n Plot.tickX(top25total_dmg, {\n stroke: \"#544f4f\",\n strokeWidth: 1\n })\n ],\n x: { ticks: 10 },\n marginLeft: 50\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2451,"value":"top25damage_avg = dataDailyDerailmentFrequency\n .sort((a, b) => b[\"damage_avg\"] - a[\"damage_avg\"])\n .slice(0, 25)\n .map((d) => new Date(d.date))\n .sort((a, b) => a - b)\n//.map((d) => d3.timeFormat(\"%d/%m/%Y\")(d))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2648,"value":"Plot.plot({\n marks: [\n Plot.tickX(top25damage_avg, {\n stroke: \"#544f4f\",\n strokeWidth: 1\n })\n ],\n x: { ticks: 10 },\n marginLeft: 50\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2746,"value":"/*Plot.plot({\n marks: [\n Plot.rectY(dataAccidentFrequency, {\n x: (d) => new Date(d[\"date\"]),\n y: (d) => d.accidents,\n fill: \"blue\",\n fillOpacity: 0.5,\n thresholds: d3.utcDay\n })\n ]\n})*/","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1757,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":860,"value":"---\n# Cars On Line\ndata as of Feb 16 2023","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":863,"value":"carsOnline = await FileAttachment(\"Cars_On_Line.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":873,"value":"\"...\nWeekly \"cars on line\" data from the Surface Transportation Board's (STB) Rail Service Metrics. The STB began collecting service metrics from railroads in October 2014. As part of their submission to the STB, **railroads provide data on the average (daily) number of cars on line, broken out by car type such as \"box,\" \"covered hopper,\" \"gondola,\" \"intermodal,\" \"multilevel (automotive),\" \"open hopper,\" \"tank,\" and \"other.\"** According to the STB, \"each railroad shall average its daily on-line inventory of freight cars. Articulated cars should be counted as a single unit. Cars on private tracks (e.g., at a customer’s facility) should be counted on the last railroad on which they were located. Maintenance-of-way cars and other cars in railroad service should be excluded.\"\n...\"","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":879,"value":"cars = aq.from(carsOnline)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":882,"value":"cars.view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1003,"value":"cars.dedupe(\"Type\").array(\"Type\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2058,"value":"cars.dedupe(\"Railroad\").array(\"Railroad\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1205,"value":"How frequent were the reports released? All records were reported on a Wednesday, if data is week 20 of 2022 the data is reported on reporting weeks end on 18th. 12th-18th
\n
\"...Week number calculated from the reported week ending date (Date field). Week 1 is the first week of the year with a week ending date falling on or after January 4. In other words, it is the first reported week of data which includes four days in the new year. Values range from 1 to 52 or 53, depending on the year...\"

\ndata is marked as \"Week ending dates\"
\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1006,"value":"datacarFrequency = cars\n .dedupe(\"Date\")\n .array(\"Date\")\n .map((d) => d3.utcFormat(d)())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1040,"value":"Calendar(datacarFrequency)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":868,"value":"----\n# Railcar loadings","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":870,"value":"railcarLoadings = await FileAttachment(\"Rail_Carloadings.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":875,"value":"\"...\nWeekly carloads from the Surface Transportation Board’s (STB) Rail Service Metrics. Each week, the seven Class I railroads submit originated and received carloads by 23 major commodity groups, such as grain, grain mill, primary forest products, chemicals, coal, containers, trailers, etc.\n\nWhile the STB began collecting some service metrics from railroads (e.g., trains speeds, origin dwell, and terminal dwell) in October 2014, it did not start collecting carload data until March 2017 through a new rulemaking.\n\n...\"","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":884,"value":"loadings = aq.from(railcarLoadings)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":886,"value":"loadings.view()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":986,"value":"What do the trains carry and in what amounts?\n
\"Originated\" to begin a scheduled run\n
\"Received\" to end a scheduled run","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2052,"value":"dataloadingsFrequency = loadings\n .dedupe(\"Date\")\n .array(\"Date\")\n .map((d) => d3.utcFormat(d)())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2055,"value":"Calendar(dataloadingsFrequency)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":982,"value":"loadings.dedupe(\"Commodity\").array(\"Commodity\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":992,"value":"loadings.dedupe(\"Railroad\").array(\"Railroad\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1726,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":893,"value":"import { toc } from \"@mbostock/toc\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1034,"value":"import { Calendar } from \"@observablehq/calendar-component\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"import {\n rawAll,\n causesLookup,\n causesLookupType,\n accidentTypeLookup\n} from \"@mbrickmaps/dot-accidentreport\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":782,"value":"cntyCenters = FileAttachment(\"cntyCenters.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":271,"value":"accfile_effective_060111 = FileAttachment(\"accfile_EFFECTIVE_060111.pdf\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W38","stdlib":"1","titling":"auto"}} 33:"$32:body"