{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":177021918,"defaultBranch":"main","name":"pulse-data","ownerLogin":"Recidiviz","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2019-03-21T20:51:04.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/35868122?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1649886148.0278652","currentOid":""},"activityList":{"items":[{"before":"422d7747503bce2215815cc37a3fa378cebe8a69","after":"48ecca18b6f46c0a8a51d629dee0db478d000f0e","ref":"refs/heads/main","pushedAt":"2024-05-11T09:03:36.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"turn supervision_officer_attribute_sessions into supervision_staff_attribute_sessions (Recidiviz/recidiviz-data#29335)\n\n## Description of the change\n\nRenamed the file and view, and added WHERE clauses to downstream views\nto do the `role_type` filtering that\n`supervision_officer_attribute_sessions` was doing. This allows us to\nmore easily query staff information for users who don't have an ingested\nrole_type (for example, getting information for specialists who are not\ntechnically officers into the workflows supervision_staff_record).\n\nWill post the sandbox prefix once it's done loading!\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses https://github.com/Recidiviz/recidiviz-data/issues/29066\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 0fd8c4ae7e5b19e95705af59e7ac9f57393a81cf","shortMessageHtmlLink":"turn supervision_officer_attribute_sessions into supervision_staff_at…"}},{"before":"d8d0d741b63854a41ac3667680608c9df240a4fe","after":"422d7747503bce2215815cc37a3fa378cebe8a69","ref":"refs/heads/main","pushedAt":"2024-05-11T09:03:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[BigQuery] Fix AR location metadata query (Recidiviz/recidiviz-data#29410)\n\n## Description of the change\n\nFix syntax errors in the AR location metadata view\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nN/A\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [x] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 2573c8ee79c9c644a07311d8d7ac178ccc549ee3","shortMessageHtmlLink":"[BigQuery] Fix AR location metadata query (Recidiviz/recidiviz-data#2…"}},{"before":"2f8615674603801f5f5ee96d999202712efd0601","after":"d8d0d741b63854a41ac3667680608c9df240a4fe","ref":"refs/heads/main","pushedAt":"2024-05-11T09:03:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[Justice Counts] Convert all column names to lowercase during spreadsheet upload. (Recidiviz/recidiviz-data#29389)\n\n## Description of the change\n\nConvert all column names to lowercase during spreadsheet upload.\n\nIt turns out that the reason we were running into this\nmysterious/misleading unexpected error for Carrol County (see Recidiviz/recidiviz-data#29303) is\nbecause we are converting columns to lowercase when looking for\nunexpected column names, but then NOT using case-insensitive logic when\nactually parsing the columns later on. This puts us in a weird state\nwhere we aren't catching the unexpected \"Year\" column during sheet\nvalidation, but the later parsing steps don't recognize the \"Year\"\ncolumn and throw an unexpected error.\n\nOne solution here would be to make the parsing logic case-insensitive,\nhowever this will lead us into issues later if we miss spots or forget\nto make case-insensitive parsing later down the road.\n\nInstead, let's convert all column names to lowercase as an initial step\nduring workbook upload.\n\nWe have a place in the workbook uploader code where we drop all rows\nthat contain Nans. Let's do another spreadsheet cleaning step here and\nconvert all the column names to lowercase.\n\n## Testing\n\nI tested this change locally by submitting a bulk upload sheet with a\n\"Year\" column instead of the lowercase \"year\" column.\n\nHere is the errors that we are getting _without_ any changes.\n![\"Screenshot]()
\n\nHere is the improved error once we fix the expected-columns check (by\nnot making that process case insensitive).\n![\"Screenshot]()
\n\nAnd here is the final fix - when we convert all column names to\nlowercase, making the uploaded spreadsheet a valid one.\n\n![\"Screenshot]()
\nGitOrigin-RevId: c5401416da9877603636ff45e451129b603fc5aa","shortMessageHtmlLink":"[Justice Counts] Convert all column names to lowercase during spreads…"}},{"before":"f07582b999c306c1a75756e4dcc4079407e858f1","after":"2f8615674603801f5f5ee96d999202712efd0601","ref":"refs/heads/main","pushedAt":"2024-05-11T09:03:19.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_CA] Add missing locations to location metadata (Recidiviz/recidiviz-data#29142)\n\n## Description of the change\nSome units only appear in AgentParole, and we want these in our\nlocation_metadata table. Also, I try to select the most recent\nParoleUnit information with the least `nulls` if there are multiple\nchoices on the most recent date.\n\nConfirmed this fixes the validation in [this\nquery](https://console.cloud.google.com/bigquery?ws=!1m7!1m6!12m5!1m3!1srecidiviz-staging!2sus-central1!3s9bb0b997-bc31-4b96-b9eb-a678b06f7a11!2e1),\nwhich shows all rows missing in the validation are present in the\nupdated view.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses Recidiviz/recidiviz-data#29021\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [ ] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 174a6533dfeeee4c28539bfee2c35e949bea1ed3","shortMessageHtmlLink":"[US_CA] Add missing locations to location metadata (Recidiviz/recidiv…"}},{"before":"00517e936edacaa399e7f01b55a6d28a68fb0f49","after":"f07582b999c306c1a75756e4dcc4079407e858f1","ref":"refs/heads/main","pushedAt":"2024-05-11T09:03:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_IX] Update cadence change for hsn_FacilityLevel (Recidiviz/recidiviz-data#29402)\n\n## Description of the change\n\nThis table is a ref table that isn't updated regularly, so we changed\nthe cadence to be Irregular so that the us_ix_stale_raw_data_tables\ndoesn't fail on it.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses Recidiviz/recidiviz-data#29296\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [x] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 2ae43cb44ce07f454376a4264f187948f485016e","shortMessageHtmlLink":"[US_IX] Update cadence change for hsn_FacilityLevel (Recidiviz/recidi…"}},{"before":"6c99814bf8ac006ab83b21dce4a6a9bf7a366b01","after":"00517e936edacaa399e7f01b55a6d28a68fb0f49","ref":"refs/heads/main","pushedAt":"2024-05-11T09:03:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[Justice Counts] Add an Admin Panel API endpoint for deleting an agency (Recidiviz/recidiviz-data#29355)\n\n## Description of the change\n\nAdd an Admin Panel API endpoint for deleting an agency.\n\nTo reduce redundant logic, we extract out the existing delete_agency\nscript and import it into a util file.\n\nNote: I first tried importing it into the admin API straight from\nrecidiviz/tools/justice_counts/delete_agency.py but this caused a\ncircular dependency:\nhttps://github.com/Recidiviz/recidiviz-data/actions/runs/8838706773/job/24270463398\n\n## Super/Child agencies\n\nIt looks like our existing delete agency script actually does not handle\nsuperagencies/child agencies properly. My fix for this is:\n\n# If the agency is a superagency, nullify the super_agency_id field from\nall of its\n# children. Nullifying a child agency's super_agency_id field causes the\nchild\n # agency to no longer be considered a child agency.\n\nI tested locally that this behavior works properly and that the child\nagencies are correctly \"uncoupled\" from their superagencies.\n\nBut would love someone else to verify that nullifying\nAgency.super_agency_id for child agencies is the right approach!\n\n## Testing\n\n### Unit testing\nAdd a comprehensive unit test to the admin panel test suite.\n\n### Testing the Admin Panel Endpoint Locally\n\nI ran the admin panel endpoint via the request_api for a local agency\nand manually verified that the endpoint works.\n```\npython -m recidiviz.tools.justice_counts.control_panel.request_api admin/agency/XXX '{}' delete\n```\n\nI also verified this on a superagency and it correctly:\n* Deleted the superagency.\n* Turned the superagency's child agencies into regular agencies.\n\nI ran it on a child agency and it correctly:\n* Deleted the child agency\n* The child agency no longer showed up as a child for the superagency in\nthe admin panel.\n\n### Testing the Util Command\nSuccessfully ran the existing delete agency tool against a staging\nagency to confirm that the modification of the delete agency tool file\ndoes not break it.\n```\npython -m recidiviz.tools.justice_counts.delete_agency \\\n --project-id=justice-counts-staging \\\n --agency-id=361 \\\n --dry-run=false\n```\n![\"Screenshot]()
\n\n## Related issues\n\nCloses Recidiviz/recidiviz-data#28832\n\nGitOrigin-RevId: e68e4e78cd94c3ede4d1d3a826c5807b7c0675de","shortMessageHtmlLink":"[Justice Counts] Add an Admin Panel API endpoint for deleting an agen…"}},{"before":"281ebabc16970e3195276aa98d3d63198f712756","after":"6c99814bf8ac006ab83b21dce4a6a9bf7a366b01","ref":"refs/heads/main","pushedAt":"2024-05-11T09:03:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_IX][Workflows] Remove zero day spans from new criteria (Recidiviz/recidiviz-data#29396)\n\n## Description of the change\n\n> Description here\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses Recidiviz/recidiviz-data#29375\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: f941001d023456488fee770e59c3a4e0cb07d3d9","shortMessageHtmlLink":"[US_IX][Workflows] Remove zero day spans from new criteria (Recidiviz…"}},{"before":"b363f4710d5e1d95bc3d8d05284e0d4c4926dd61","after":"281ebabc16970e3195276aa98d3d63198f712756","ref":"refs/heads/main","pushedAt":"2024-05-11T09:02:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[Justice Counts] Replace INVALID_CHILD_AGENCY error with UNEXPECTED_ERROR (Recidiviz/recidiviz-data#29387)\n\n## Description of the change\n\nReplace INVALID_CHILD_AGENCY error with UNEXPECTED_ERROR.\n\nThe codebase is configured right now to send a INVALID_CHILD_AGENCY\nerror when we experience an error that we don't know how to handle.\n\nThis INVALID_CHILD_AGENCY is misleading, and it seems like it's an\naccident where it is. Let's replace it with a more straightforward\nUNEXPECTED_ERROR error. This is an improvement because it tells us more\ndirectly that we are not handling the error properly - instead of\nleading us down the wrong path by suggesting something is up with our\nchild agency logic.\n\n## Testing\nI tested this locally and got the unexpected error message below.\n\n![\"Screenshot]()
\n\nZenhub Ticket Recidiviz/recidiviz-data#29303\n\nGitOrigin-RevId: 10ac0975afe116189831f9129b4ef98a4f775703","shortMessageHtmlLink":"[Justice Counts] Replace INVALID_CHILD_AGENCY error with UNEXPECTED_E…"}},{"before":"c95a02b4a424958f9e099361a771949f2c8f71f4","after":"b363f4710d5e1d95bc3d8d05284e0d4c4926dd61","ref":"refs/heads/main","pushedAt":"2024-05-11T09:02:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[Platformization] Create POST endpoint to add new config (Recidiviz/recidiviz-data#29373)\n\n## Description of the change\n\nThis PR enables `POST` on the\n`/opportunities//configurations`\nendpoint. It is mostly a wrapper around the querier `add_config()`\nmethod. The endpoint uses the current timestamp as well as the\nauthenticated user information to populated the creation fields.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses Recidiviz/recidiviz-data#29090\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [x] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: c4199edf0445740bb17677185f833dc14dd551c3","shortMessageHtmlLink":"[Platformization] Create POST endpoint to add new config (Recidiviz/r…"}},{"before":"40650d331aa6a09a0f5516d27c4c69778a738650","after":"c95a02b4a424958f9e099361a771949f2c8f71f4","ref":"refs/heads/main","pushedAt":"2024-05-11T09:02:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_AR] Location metadata reference view (Recidiviz/recidiviz-data#28452)\n\n## Description of the change\n\nAdds a location metadata reference view for US_AR, using location data\nfrom the raw ORGANIZATIONPROF table.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 3cba9de6555f4e5b151a7435348154f66719790a","shortMessageHtmlLink":"[US_AR] Location metadata reference view (Recidiviz/recidiviz-data#28452"}},{"before":"ed4e2b6b80d5195f59ab205f263782e58ce5cd74","after":"40650d331aa6a09a0f5516d27c4c69778a738650","ref":"refs/heads/main","pushedAt":"2024-05-11T09:02:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_OR] Switching some supervision and incarceration periods (Recidiviz/recidiviz-data#28530)\n\n## Description of the change\n\nOriginally we used location type to determine if a period is a\nsupervision or incarceration period because they use the same tables and\nthe CURRENT_STATUS does not have the same level of information/accuracy.\nHowever, some periods in Oregon have a CURRENT_STATUS of IN (adult in\ncustody/facility) or LC (local jail) with a location that is not a\nprison or jail (usually a community location). OR says these should\nstill be counted as Incarceration Periods if the CURRENT_STATUS is IN or\nLC, so this change removed those periods from supervision periods and\nadded them to incarceration periods.\n\nThe supervision period results went from 2448054 to 2447002 and the\nincarceration period results went from 2356469 to 2368316.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses #XXXX\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [x] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [x] This pull request has a descriptive title and information useful\nto a reviewer\n- [x] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: c908e9ba8d75e38f4d771afc6d0008b81981f04c","shortMessageHtmlLink":"[US_OR] Switching some supervision and incarceration periods (Recidiv…"}},{"before":"b6e65ebe67571199ec373f12074c52091d8fc76e","after":"ed4e2b6b80d5195f59ab205f263782e58ce5cd74","ref":"refs/heads/main","pushedAt":"2024-05-11T09:02:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_IX] Remove folks with sex offender alerts and violent charges from CRC opps (Recidiviz/recidiviz-data#29170)\n\n## Description of the change\n\n- Sex offenders: I created new state-specific criteria and added it to\nall CRC opps.\n- Violent offenses: I used a general criteria view and added it to all\nCRC opps.\n\nI uploaded this to sandbox (`_hsalas`), and it does slightly reduce the\nnumber of people eligible:\n- CRC resident worker: from 2,536 to 1,833\n- CRC work-release: 1,768 to 1,248\n- XCRC: 277 to 222\n\n## Related issues\n\nCloses Recidiviz/recidiviz-data#5299\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [ ] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: f155107ea2ae89af76c242d1c01f1cfe648b3948","shortMessageHtmlLink":"[US_IX] Remove folks with sex offender alerts and violent charges fro…"}},{"before":"0e4b03cccd33cc9df499a893dce2610fb87061f4","after":"b6e65ebe67571199ec373f12074c52091d8fc76e","ref":"refs/heads/main","pushedAt":"2024-05-11T09:02:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_AZ] Add early discharge sessions to analyst_data views for AZ (Recidiviz/recidiviz-data#29354)\n\n## Description of the change\n\nAdd early discharge sessions to analyst_data views for AZ. I uploaded it\ninto a sandbox (_hsalas) and it all looks well.\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [ ] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 4d21145fa8c7303580ea4b6afde2e1c93b9e3d34","shortMessageHtmlLink":"[US_AZ] Add early discharge sessions to analyst_data views for AZ (Re…"}},{"before":"65b0034ca6801ed467b475ee9fe8e1aea14f4bc7","after":"0e4b03cccd33cc9df499a893dce2610fb87061f4","ref":"refs/heads/main","pushedAt":"2024-05-11T09:02:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[Insights] Add WHERE clause so that only metrics from last 6 year periods are returned (Recidiviz/recidiviz-data#29378)\n\n## Description of the change\n\nImporting data to the `metric_benchmarks` table in CA failed because we\nrequire `threshold` column to be non-nullable, but some entries in the\nview were NULL. These rows were for periods prior to the earliest period\nwe care about (the period ending in the first of the month six months\nago). So this PR updates the metric-related view helper to include a\nfilter to only include the latest six year periods. Loaded to\n`alexa_29366` and you can confirm there are no unexpected NULLS with\n```\nSELECT *\nFROM `recidiviz-staging.alexa_29366_outliers_views.metric_benchmarks_materialized`\nWHERE\n threshold IS NULL\n```\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses Recidiviz/recidiviz-data#29366\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [ ] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: f943546e98aeb32034bf2c4fef862d45249996f6","shortMessageHtmlLink":"[Insights] Add WHERE clause so that only metrics from last 6 year per…"}},{"before":"f7855320d128d99c200406017f79da9e743e0f44","after":"65b0034ca6801ed467b475ee9fe8e1aea14f4bc7","ref":"refs/heads/main","pushedAt":"2024-05-10T09:04:06.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[Bugfix] Fix crash in run_sandbox_ingest_pipeline (Recidiviz/recidiviz-data#29381)\n\n## Description of the change\n\nThe `output_sandbox_prefix` is no longer parsed by the first part of arg\nparsing and needs to now be accessed via the `params` object.\n\nRefactors slightly so most of the logic is inside a function that only\nhas access to the `PipelineParameters`, not the raw command line args.\n\nTested locally to confirm the fix.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nSee this thread:\nhttps://recidiviz.slack.com/archives/C01J3JV7962/p1714086820404379\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [x] This pull request has a descriptive title and information useful\nto a reviewer\n- [x] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 4467ab25e03729384020672eff9f824cab9796f7","shortMessageHtmlLink":"[Bugfix] Fix crash in run_sandbox_ingest_pipeline (Recidiviz/recidivi…"}},{"before":"de6f7712107de916eaafde10b09257452b363222","after":"f7855320d128d99c200406017f79da9e743e0f44","ref":"refs/heads/main","pushedAt":"2024-05-10T09:04:00.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_IX] Adding raw data configs for jail credit time (Recidiviz/recidiviz-data#29371)\n\n## Description of the change\n\nthis adds raw data configs for four tables:\n\n- `scl_Credit`\n- `scl_CreditBase`\n- `scl_CreditDetail`\n- `scl_CreditDetailType`\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses #XXXX\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [x] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 47afb935f6920626b06549daeb39ee6866ad66a4","shortMessageHtmlLink":"[US_IX] Adding raw data configs for jail credit time (Recidiviz/recid…"}},{"before":"b838304656b4b2b3a68da1217096178a29a39680","after":"de6f7712107de916eaafde10b09257452b363222","ref":"refs/heads/main","pushedAt":"2024-05-10T09:03:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_ND] Add `PROL` to supervision delegate (Recidiviz/recidiviz-data#29365)\n\n## Description of the change\n\nAdds `PROL` as an expected release reason raw text value for the\nsupervision normalization delegate to run.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses #XXXX\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [ ] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 8854ebe3477dd3e01a92949ae1cef6e23ced6e5d","shortMessageHtmlLink":"[US_ND] Add PROL to supervision delegate (Recidiviz/recidiviz-data#…"}},{"before":"ca05752684fec15734e2d2262ab0de48cdba0abc","after":"b838304656b4b2b3a68da1217096178a29a39680","ref":"refs/heads/main","pushedAt":"2024-05-10T09:03:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"Add downstream referencing views to raw data gitbook documentation (Recidiviz/recidiviz-data#29334)\n\n## Description of the change\n\n- Update the gitbook state raw data page to rename the “Referencing\nViews” column to “Referencing Ingest Views” and add a second column,\n“Referencing Downstream Views” which is hydrated with the contents of\nraw_data_reference_reasons.yaml to list any downstream views that\nreference each raw data table.\n\n- Refactor raw_data_reference_reasons.yaml parsing to a separate class\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses Recidiviz/recidiviz-data#29124\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [x] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [x] This pull request has a descriptive title and information useful\nto a reviewer\n- [x] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 3377905846046554656398d68823f23135dcc2fe","shortMessageHtmlLink":"Add downstream referencing views to raw data gitbook documentation (R…"}},{"before":"11fa787dc7fe4762143c40e5dea8383c2a0a1406","after":"ca05752684fec15734e2d2262ab0de48cdba0abc","ref":"refs/heads/main","pushedAt":"2024-05-10T09:03:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_AZ] Refactor incarceration periods view based on initial validation (Recidiviz/recidiviz-data#29313)\n\n## Description of the change\n\nSee full notes from validation process\n[here](https://docs.google.com/document/d/135KIzywjfdxt-3S1qEDCtWneAnOtsMclY01P30EQR80/edit).\n\nThere were two main issues with the incarceration periods view that\narose while I was comparing the set of people who we believed were\nincarcerated on 6/15 of the last 5 years with the set of people ADCRR\nbelieved were incarcerated on those same dates.\n\n1. Recidiviz is not properly closing “periods” that were opened and\nclosed on the same day, particularly when there are an odd number of\nmovements tracked on that one day.\n2. Recidiviz is not always correctly tracking movements that happen\nafter an escorted leave of any kind. These escorted leaves include trips\nto court and the hospital.\n\nThere are a number of examples of each of these situations in the notes\ndocument that I have confirmed are fixed by this change. This change\nalso greatly simplifies the logic of the view so that further tightening\nof this validation will be easier.\n\nOne thing that became clear after this change is that the process for\nrevocations in AZ often goes like this: a person is out on supervision,\nand is involved in some sort of incident that results in a `Temporary\nPlacement` in a facility, presumably while the incident is reviewed.\nAfter that initial placement, there can be another movement signifying\nthat the person's supervision was revoked. For this reason, we see\n`Parole Revoked`-type movements as \"releases\" not infrequently. This\ninitial period of `Temporary Placement` should possibly be mapped to\nsome investigative status when it is followed by a revocation.\n\nTests:\n\n- [x] external ID fields are unique\n- [x] run_mappings script passes\n- [x] ingest view query is deterministic (in progress!)\n- [x] sandbox ingest\n[pipeline](https://console.cloud.google.com/dataflow/jobs/us-west1/2024-04-24_11_53_36-10222558064572225174?project=recidiviz-staging)\nsucceeds (in progress)\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nRelated to Recidiviz/recidiviz-data#28522\nRelated to Recidiviz/recidiviz-data#28906\nRelated to Recidiviz/recidiviz-data#28907\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [ ] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 34d6eb6d828aafe6e7ed99154526baef79d34a1f","shortMessageHtmlLink":"[US_AZ] Refactor incarceration periods view based on initial validati…"}},{"before":"bac21f37904d32aaf660e2298a16f29af317ef42","after":"11fa787dc7fe4762143c40e5dea8383c2a0a1406","ref":"refs/heads/main","pushedAt":"2024-05-10T09:03:39.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_PA] Add raw data config for reference file (Recidiviz/recidiviz-data#29358)\n\n## Description of the change\n\nAdd raw data config for reference file mapping offense codes to\ndescriptions\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses #XXXX\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [x] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: e6002f4ae6d36d757b210e4f01b3536770ac8c88","shortMessageHtmlLink":"[US_PA] Add raw data config for reference file (Recidiviz/recidiviz-d…"}},{"before":"6b5d8fa0c5fc81c6d60c6d2fc9a423c0840ee8c4","after":"bac21f37904d32aaf660e2298a16f29af317ef42","ref":"refs/heads/main","pushedAt":"2024-05-10T09:03:33.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_TN] Adding back RED to SentencesChargesAndCourtCases (Recidiviz/recidiviz-data#29315)\n\n## Description of the change\n\nIngest RED as Parole Eligibility Date\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nRelated to Recidiviz/recidiviz-data#23069\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [x] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [x] This pull request has a descriptive title and information useful\nto a reviewer\n- [x] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: b0d5a2c9d29c03c721f06167e21c1345c727a2c5","shortMessageHtmlLink":"[US_TN] Adding back RED to SentencesChargesAndCourtCases (Recidiviz/r…"}},{"before":"e390f09c8aa8fba66fa80f7fb9b0398c46b6e060","after":"6b5d8fa0c5fc81c6d60c6d2fc9a423c0840ee8c4","ref":"refs/heads/main","pushedAt":"2024-05-10T09:03:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_IX][Workflows] Add criteria to exclude clients serving their first year for a dui if risk level is low (Recidiviz/recidiviz-data#29320)\n\n## Description of the change\n\nAccording to [IDOC\npolicy](https://drive.google.com/file/d/1YbNrkaTwNX3tfdeDoH2f09Y7_8LOlMa7/view?usp=sharing),\nclients who are serving for a DUI in their first year on supervision\nshould be supervised at MODERATE if their risk level is LOW. In this PR,\nI add that as a criteria for the `supervision_level_downgrade`\nopportunity.\n\nTested in `shuff_m`, 95/399 clients are no longer eligible.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses Recidiviz/recidiviz-data#29044\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 729b0a142e0ff3596f815f680dab5ed53c6fd38d","shortMessageHtmlLink":"[US_IX][Workflows] Add criteria to exclude clients serving their firs…"}},{"before":"477569904e8c0d3fe1ac91dabfe98fc6e1dd01e1","after":"e390f09c8aa8fba66fa80f7fb9b0398c46b6e060","ref":"refs/heads/main","pushedAt":"2024-05-10T09:03:21.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_MI][Workflows] Take the greatest of sentencing length for early discharge from parole criteria (Recidiviz/recidiviz-data#29250)\n\n## Description of the change\n\nWe got feedback from trusted testers that clients were ineligible based\non having a current offense with `(statute LIKE \"750.110\" OR statute\nLIKE \"750.110A%\")` and a sentence length > 15 years. Here we were\ncalculating the date based on the difference between the\n`DATE_DIFF(projected_completion_date_max,effective_date,DAY)` which was\ngiving us just under 15 years, despite the\n`max_sentence_length_days_calculated` being over 15 years.\n\nTo resolve this issue we take the `GREATEST` of these fields.\n\nTested in `shuff`. This change results in 14 fewer clients eligible for\nearly discharge from parole out of 1187 clients.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses #https://github.com/Recidiviz/recidiviz-dashboards/issues/5201\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: e4428f8fad8e6debc64e259faeba4e068c5a3e81","shortMessageHtmlLink":"[US_MI][Workflows] Take the greatest of sentencing length for early d…"}},{"before":"bc6a95a8d6ebca283ff572a6070a678b718e06dc","after":"477569904e8c0d3fe1ac91dabfe98fc6e1dd01e1","ref":"refs/heads/main","pushedAt":"2024-05-10T09:03:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_IX][Insights] Remove informal probation from supervision population (Recidiviz/recidiviz-data#29338)\n\n## Description of the change\n\nGiven that\n[gitbook](https://app.gitbook.com/o/-MS0FZPVqDyJ1aem018G/s/-MRvK9sMirb5JcYHAkjo-887967055/schema-catalog/enums/statesupervisionperiodsupervisiontype)\ndefines INFORMAL_PROBATION as:\n\n> A type of supervision where the person is not formally supervised and\ndoes not have to regularly report to a supervision officer. The person\ndoes have certain conditions associated with their supervision, that\nwhen violated can lead to revocations. Might also be called “Court\nProbation“.\n\nwe should exclude this supervision type from the supervision population\ndefinition for aggregated metrics, as these compartments are supposed to\nindicate active supervision\n\nThis supervision type is currently only hydrated in Idaho, and varies\nwidely year to year\n```\nSELECT state_code, DATE_TRUNC(start_date, YEAR), COUNT(*)\nFROM normalized_state.state_supervision_period\nWHERE supervision_type = 'INFORMAL_PROBATION'\nGROUP BY 1,2\nORDER BY 2\n```\n\nWhen removing this `compartment_level_2` value from the supervision\npopulation, we find ([results\nhere](https://docs.google.com/spreadsheets/d/1YSKaAvBhLk-PjQcfMhSBngOXngkkEQlnmDx_bLtIA2o/edit#gid=628286862)):\n- For officer yearly aggregated metrics from 2020 until now (15 months\nper officer)...\n 1. 12% (1547/12016) of metrics had changed avg daily populations.\n - These changes fall into three categories.\n - Officers whose `avg_daily_popultion` changed by < 1 (1207)\n- Officers with very few (between 1-4) clients on informal probation\n(~150)\n- “Officers with” > 4 clients on informal probation (170). These\nofficers are exclusively COURT or DRUG, or UNKNOWN officers\n2. There are only 53 changes for `incarceration_starts`. All of these\nbelong under COURT or DRUG, or UNKNOWN officers.\n 3. No changes to `violations_absconsion`\n\nTherefore, excluding these clients will not impact true officers, but we\nshould make sure to exclude these COURT or DRUG, or UNKNOWN officers,\nsince removing `INFORMAL_PROBATION` clients does not always mean these\nofficers will be excluded based on `avg_daily_population` size.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses Recidiviz/recidiviz-data#29330\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 119f6d4659bae0d1cdab432a9d548a63e3bfa7d1","shortMessageHtmlLink":"[US_IX][Insights] Remove informal probation from supervision populati…"}},{"before":"7f9e8ffd6c26cbf22df62b06891a3d18cbdce331","after":"bc6a95a8d6ebca283ff572a6070a678b718e06dc","ref":"refs/heads/main","pushedAt":"2024-05-10T09:03:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_AZ] Add missing column to raw data config (Recidiviz/recidiviz-data#29350)\n\n## Description of the change\n\nI missed the `CREATE_DTM` column in a raw data config, so raw data\nimport is failing for a single (not currently in use) file in AZ\nstaging. This adds the column, and adds a `datetime_sql_parser` to\nanother field that needs one.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses https://github.com/Recidiviz/recidiviz-data/issues/29348\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [x] This pull request has a descriptive title and information useful\nto a reviewer\n- [x] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 947904b4dbdd0958f6d53497133923f128b9a9ae","shortMessageHtmlLink":"[US_AZ] Add missing column to raw data config (Recidiviz/recidiviz-da…"}},{"before":"102530d2658ded86bea26f8cb01edd6cdb1c38c2","after":"7f9e8ffd6c26cbf22df62b06891a3d18cbdce331","ref":"refs/heads/main","pushedAt":"2024-05-10T09:03:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[Justice Counts] Disable the VPN while running the JC prod deploy. (Recidiviz/recidiviz-data#29337)\n\n## Description of the change\n\nDisable the VPN while running the prod deploy.\n\n## Testing\n\nRan this on Mahmoud's side (since he was the VPN) and the prod deploy\nsucceeded.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses #XXXX\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [ ] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 80c693be02196b6c93a51b53ba5e4f5900b65901","shortMessageHtmlLink":"[Justice Counts] Disable the VPN while running the JC prod deploy. (R…"}},{"before":"67c9b8214c80861c1fc70bbf02801c9d1b24c834","after":"102530d2658ded86bea26f8cb01edd6cdb1c38c2","ref":"refs/heads/main","pushedAt":"2024-05-09T09:03:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[Justice Counts] Update JC README.md with an overview of continuous deployment and database migrations for staging. (Recidiviz/recidiviz-data#29222)\n\n## Description of the change\n\nAdd an overview in the JC README of continuous deployment.\n\nWe will also have additional documentation in go/jc-oncall that pieces\nthe steps together (see screenshot below). But checking in an overview\nto the README would be good to do as well.\n\n![\"Screenshot]()
\n\nZenhub Ticket Recidiviz/recidiviz-data#29011\n\nGitOrigin-RevId: 6d9a2972568e1314192e54e673b20d21d2c594e7","shortMessageHtmlLink":"[Justice Counts] Update JC README.md with an overview of continuous d…"}},{"before":"98c1d2cf57b9ff9e7db003d865ccc7e933e40e98","after":"67c9b8214c80861c1fc70bbf02801c9d1b24c834","ref":"refs/heads/main","pushedAt":"2024-05-09T09:03:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[Dataflow] Derive job_name from other parameters (Recidiviz/recidiviz-data#29244)\n\n## Description of the change\n\nMoment of zen cleanup. Dataflow pipeline job names can be fully derived\nfrom other parameters - there is no reason we should be building these\nand passing them to the `PipelineParameters` objects. This PR makes the\n`job_name` property a function with a helper that base classes override\nto provide a job name.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nFollow-up to Recidiviz/recidiviz-data#22528\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [x] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [x] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [x] This pull request has a descriptive title and information useful\nto a reviewer\n- [x] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: b74facf114a9432fd303ba5559583e1ad6eb62a1","shortMessageHtmlLink":"[Dataflow] Derive job_name from other parameters (Recidiviz/recidiviz…"}},{"before":"29b6ba86937b25348a15633b6c42da5421d85f4b","after":"98c1d2cf57b9ff9e7db003d865ccc7e933e40e98","ref":"refs/heads/main","pushedAt":"2024-05-09T09:03:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_AZ] Ingest StateStaff (Recidiviz/recidiviz-data#29240)\n\n## Description of the change\n\nBasic ingest of StateStaff and StateStaffExternalId for DOC staff in\nfacilities and community corrections. There are no email addresses\navailable in the raw data available at this time, so that field is not\nhydrated.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses Recidiviz/recidiviz-data#27768\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [ ] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 28cc56b000c3a98bf9b4761bd01e2c42651acb6f","shortMessageHtmlLink":"[US_AZ] Ingest StateStaff (Recidiviz/recidiviz-data#29240)"}},{"before":"de081c071d7c6e13980fdfc87cd65fc6eb3f4899","after":"29b6ba86937b25348a15633b6c42da5421d85f4b","ref":"refs/heads/main","pushedAt":"2024-05-09T09:03:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"helperbot-recidiviz","name":"Helper Bot","path":"/helperbot-recidiviz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/48495666?s=80&v=4"},"commit":{"message":"[US_AZ] Add raw data configs for new files (Recidiviz/recidiviz-data#29329)\n\n## Description of the change\n\nWe got a lot of new data from AZ! This adds raw data configs for all of\nthe new files.\n\n## Type of change\n\n> All pull requests must have at least one of the following labels\napplied (otherwise the PR will fail):\n\n| Label | Description |\n|-----------------------------\n|-----------------------------------------------------------------------------------------------------------\n|\n| Type: Bug | non-breaking change that fixes an issue |\n| Type: Feature | non-breaking change that adds functionality |\n| Type: Breaking Change | fix or feature that would cause existing\nfunctionality to not work as expected |\n| Type: Non-breaking refactor | change addresses some tech debt item or\nprepares for a later change, but does not change functionality |\n| Type: Configuration Change | adjusts configuration to achieve some end\nrelated to functionality, development, performance, or security |\n| Type: Dependency Upgrade | upgrades a project dependency - these\nchanges are not included in release notes |\n\n## Related issues\n\nCloses #XXXX\n\n## Checklists\n\n### Development\n\n**This box MUST be checked by the submitter prior to merging**:\n- [ ] **Double- and triple-checked that there is no Personally\nIdentifiable Information (PII) being mistakenly added in this pull\nrequest**\n\nThese boxes should be checked by the submitter prior to merging:\n- [ ] Tests have been written to cover the code changed/added as part of\nthis pull request\n\n### Code review\n\nThese boxes should be checked by reviewers prior to merging:\n\n- [ ] This pull request has a descriptive title and information useful\nto a reviewer\n- [ ] Potential security implications or infrastructural changes have\nbeen considered, if relevant\n\nGitOrigin-RevId: 8106ad89b3caa2e1524b7c55b445d98d63e7bcf4","shortMessageHtmlLink":"[US_AZ] Add raw data configs for new files (Recidiviz/recidiviz-data#…"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAERyppFQA","startCursor":null,"endCursor":null}},"title":"Activity · Recidiviz/pulse-data"}