{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":465684895,"defaultBranch":"master","name":"queries-rj-smtr","ownerLogin":"prefeitura-rio","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2022-03-03T11:07:47.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/92761110?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1718298867.0","currentOid":""},"activityList":{"items":[{"before":"f53362ef4e02707377cd3f082c3e80ce2f8a0297","after":"31e2b027d67b655c2a4b19db6f292f57ba9f3737","ref":"refs/heads/devops","pushedAt":"2024-08-20T15:36:33.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Hellcassius","name":"Caio R S dos Santos","path":"/Hellcassius","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/77297729?s=80&v=4"},"commit":{"message":"trigger cd","shortMessageHtmlLink":"trigger cd"}},{"before":"95dff820c9dd03f516990b7ab63c9301329f830c","after":"3b1b063beada76c15a45a0f714fcb5375b857a42","ref":"refs/heads/mit-ipea-trip-chaining","pushedAt":"2024-07-24T21:33:07.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"ashleyvicary","name":"Ashley Vicary","path":"/ashleyvicary","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/85631772?s=80&v=4"},"commit":{"message":"add h3 res9 view and table","shortMessageHtmlLink":"add h3 res9 view and table"}},{"before":"6cc95aef1d8ac81c8ef0347a6907b89ff6e51177","after":"95dff820c9dd03f516990b7ab63c9301329f830c","ref":"refs/heads/mit-ipea-trip-chaining","pushedAt":"2024-07-22T19:36:46.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"ashleyvicary","name":"Ashley Vicary","path":"/ashleyvicary","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/85631772?s=80&v=4"},"commit":{"message":"Update to include buffer","shortMessageHtmlLink":"Update to include buffer"}},{"before":"cecdf29d0fe5b5a01faa8aae918e8331092d61e9","after":"6cc95aef1d8ac81c8ef0347a6907b89ff6e51177","ref":"refs/heads/mit-ipea-trip-chaining","pushedAt":"2024-07-22T19:05:28.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"ashleyvicary","name":"Ashley Vicary","path":"/ashleyvicary","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/85631772?s=80&v=4"},"commit":{"message":"Create h3_stops table, matches stops to h3 tiles\n\nNeeded for od matrix at stop level","shortMessageHtmlLink":"Create h3_stops table, matches stops to h3 tiles"}},{"before":"31a6853cb59b7bd67d2f865fa81c6992ac4e1435","after":"933971ef4769872f2b34a01c0fa8ae22488bdb85","ref":"refs/heads/master","pushedAt":"2024-07-12T14:56:53.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"Ticketing View (#333)\n\n* View contained cleaned ticketing data\r\n\r\n* Fixed bug to work with dbt\r\n\r\n* Update comment\r\n\r\n* Add comment clarifying dropped card types\r\n\r\n* Create CHANGELOG.md","shortMessageHtmlLink":"Ticketing View (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2333722058\" data-permission-text=\"Title is private\" data-url=\"https://github.com/prefeitura-rio/queries-rj-smtr/issues/333\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/prefeitura-rio/queries-rj-smtr/pull/333/hovercard\" href=\"https://github.com/prefeitura-rio/queries-rj-smtr/pull/333\">#333</a>)"}},{"before":"c6c58f6800363d5f7c9d059c25e8b19e4edd9452","after":"cecdf29d0fe5b5a01faa8aae918e8331092d61e9","ref":"refs/heads/mit-ipea-trip-chaining","pushedAt":"2024-07-11T20:12:37.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ashleyvicary","name":"Ashley Vicary","path":"/ashleyvicary","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/85631772?s=80&v=4"},"commit":{"message":"Add comments, clean up file","shortMessageHtmlLink":"Add comments, clean up file"}},{"before":"e69100e40661a9a3d3848a77e6b1e095a4689fe0","after":"c6c58f6800363d5f7c9d059c25e8b19e4edd9452","ref":"refs/heads/mit-ipea-trip-chaining","pushedAt":"2024-07-11T20:05:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ashleyvicary","name":"Ashley Vicary","path":"/ashleyvicary","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/85631772?s=80&v=4"},"commit":{"message":"Capture distance between validation stop and estimate location","shortMessageHtmlLink":"Capture distance between validation stop and estimate location"}},{"before":"02052f65b17ead0514e1b7cb7f30a3842ab8ae95","after":"418d713700585fdaeec6b344b0e4c4a3b52c2079","ref":"refs/heads/mit-ipea-ticketing","pushedAt":"2024-06-20T20:36:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ashleyvicary","name":"Ashley Vicary","path":"/ashleyvicary","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/85631772?s=80&v=4"},"commit":{"message":"Create CHANGELOG.md","shortMessageHtmlLink":"Create CHANGELOG.md"}},{"before":"24ddade2015e6200d281329d755490f6db84f739","after":"e69100e40661a9a3d3848a77e6b1e095a4689fe0","ref":"refs/heads/mit-ipea-trip-chaining","pushedAt":"2024-06-20T20:22:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ashleyvicary","name":"Ashley Vicary","path":"/ashleyvicary","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/85631772?s=80&v=4"},"commit":{"message":"Add utilization view","shortMessageHtmlLink":"Add utilization view"}},{"before":"31f6f12b173800cad76232f00529d9e545284baa","after":"11dd77e53a1d17c25bf3b4ff6abfd88641efc768","ref":"refs/heads/tg","pushedAt":"2024-06-13T18:50:40.000Z","pushType":"push","commitsCount":300,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"Merge branch 'master' into tg","shortMessageHtmlLink":"Merge branch 'master' into tg"}},{"before":"e51426f7edd6f638a5ba7019bead06a2ece36b38","after":"02052f65b17ead0514e1b7cb7f30a3842ab8ae95","ref":"refs/heads/mit-ipea-ticketing","pushedAt":"2024-06-13T17:29:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ashleyvicary","name":"Ashley Vicary","path":"/ashleyvicary","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/85631772?s=80&v=4"},"commit":{"message":"Add comment clarifying dropped card types","shortMessageHtmlLink":"Add comment clarifying dropped card types"}},{"before":"14c23c73c92593b13016791dade9d0a5c970a630","after":"e51426f7edd6f638a5ba7019bead06a2ece36b38","ref":"refs/heads/mit-ipea-ticketing","pushedAt":"2024-06-13T17:27:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ashleyvicary","name":"Ashley Vicary","path":"/ashleyvicary","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/85631772?s=80&v=4"},"commit":{"message":"Update comment","shortMessageHtmlLink":"Update comment"}},{"before":"14c23c73c92593b13016791dade9d0a5c970a630","after":"24ddade2015e6200d281329d755490f6db84f739","ref":"refs/heads/mit-ipea-trip-chaining","pushedAt":"2024-06-13T17:14:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"ashleyvicary","name":"Ashley Vicary","path":"/ashleyvicary","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/85631772?s=80&v=4"},"commit":{"message":"od passenger level view","shortMessageHtmlLink":"od passenger level view"}},{"before":null,"after":"14c23c73c92593b13016791dade9d0a5c970a630","ref":"refs/heads/mit-ipea-trip-chaining","pushedAt":"2024-06-13T17:14:27.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"ashleyvicary","name":"Ashley Vicary","path":"/ashleyvicary","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/85631772?s=80&v=4"},"commit":{"message":"Fixed bug to work with dbt","shortMessageHtmlLink":"Fixed bug to work with dbt"}},{"before":"ebaa572b5321a30678f50676d58386ddbb0a77c0","after":"31a6853cb59b7bd67d2f865fa81c6992ac4e1435","ref":"refs/heads/master","pushedAt":"2024-06-12T17:43:36.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"Altera tratamento nos modelos `viagens_remuneradas.sql` + `subsidio_data_versao_efetiva.sql` (#337)\n\n* commit inicial\r\n\r\n* Atualiza changelog\r\n\r\n* Remove SAFE_CAST","shortMessageHtmlLink":"Altera tratamento nos modelos <code>viagens_remuneradas.sql</code> + `subsidio_d…"}},{"before":"18de9e9fd46d19563e5ef0b56c0a2c2f5880f6b1","after":"236c6a4d5748a57df26fc6f8be6fd70fd83d1f55","ref":"refs/heads/altera-calendario-subsidio","pushedAt":"2024-06-11T21:28:09.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"Remove SAFE_CAST","shortMessageHtmlLink":"Remove SAFE_CAST"}},{"before":"650ae99789dda083029fdf907c882159d7c076a3","after":"18de9e9fd46d19563e5ef0b56c0a2c2f5880f6b1","ref":"refs/heads/altera-calendario-subsidio","pushedAt":"2024-06-11T21:25:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"Atualiza changelog","shortMessageHtmlLink":"Atualiza changelog"}},{"before":null,"after":"650ae99789dda083029fdf907c882159d7c076a3","ref":"refs/heads/altera-calendario-subsidio","pushedAt":"2024-06-11T20:47:59.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"commit inicial","shortMessageHtmlLink":"commit inicial"}},{"before":"0a8f8c0fce6cdca8fd947f593a78dcd7eba64cde","after":"ebaa572b5321a30678f50676d58386ddbb0a77c0","ref":"refs/heads/master","pushedAt":"2024-06-07T13:55:50.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"Altera tratamento do RDO no Encontro de Contas (#332)\n\n* commit inicial\r\n\r\n* Atualiza changelog\r\n\r\n* Altera e corrige tratamento de serviços do RDO no modelo `aux_balanco_rdo_servico_dia.sql`\r\n\r\n* Adiciona espaço no modelo `rdo_correcao_rioonibus_servico_quinzena.sql`\r\n\r\n* Corrige tratamento de serviços do RDO no modelo `aux_balanco_rdo_servico_dia.sql`\r\n\r\n* Revert \"Corrige tratamento de serviços do RDO no modelo `aux_balanco_rdo_servico_dia.sql`\"\r\n\r\nThis reverts commit e95c19b4be659e9b5184ff944146dc6795ea1907.\r\n\r\n* Revert \"Altera e corrige tratamento de serviços do RDO no modelo `aux_balanco_rdo_servico_dia.sql`\"\r\n\r\nThis reverts commit 84af966739ff1260ecb030fcb0f288e5122322c5.\r\n\r\n* Refatora balanco_servico_dia.sql\r\n\r\n* Simplifica `rdo_correcao_rioonibus_servico_quinzena.sql`\r\n\r\n* Adiciona e altera comentários\r\n\r\n* Atualiza comentários\r\n\r\n* Incorpora variável `'encontro_contas_modo'` para alterar nome da tabela, de acordo com o modo de execução\r\n\r\n* Atualiza changelog\r\n\r\n* Adiciona modos de execução `_pre_gt` e `_pos_gt` e as respectivas alterações dos nomes das tabelas\r\n\r\n* Atualiza changelog\r\n\r\n* Refatora modelos, segregando balanco_servico_dia\r\n\r\n* Corrige serviços do RDO com base nos serviços subsidiados (ou seja, apenas serviços planejados no dia)\r\n\r\n* Retorna o modo `_pre_gt` para o nome original\r\n\r\n* Atualiza changelog\r\n\r\n* Corrige modo de execução do modelo `receita_tarifaria_servico_nao_identificado_quinzena.sql`\r\n\r\n* Altera comentário do modelo `rdo_correcao_rioonibus_servico_quinzena.sql`\r\n\r\n* Altera campo `data` para minúsculo no modelo `balanco_servico_dia_pos_gt.sql`\r\n\r\n* Adiciona e altera descrições no schema.yml dos modelos `projeto_subsidio_sppo_encontro_contas`\r\n\r\n* Reverte referências dos modelos `balanco_servico_dia.sql` e `balanco_servico_dia_pos_gt.sql`","shortMessageHtmlLink":"Altera tratamento do RDO no Encontro de Contas (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2333376514\" data-permission-text=\"Title is private\" data-url=\"https://github.com/prefeitura-rio/queries-rj-smtr/issues/332\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/prefeitura-rio/queries-rj-smtr/pull/332/hovercard\" href=\"https://github.com/prefeitura-rio/queries-rj-smtr/pull/332\">#332</a>)"}},{"before":"ab460d1883435ca223a8114bd107980f5f7f14b0","after":"a33496b86543ca911230b00bf53d303c8f717e20","ref":"refs/heads/encontro-contas-corrige-rioonibus","pushedAt":"2024-06-07T13:52:50.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"Merge branch 'master' into encontro-contas-corrige-rioonibus","shortMessageHtmlLink":"Merge branch 'master' into encontro-contas-corrige-rioonibus"}},{"before":"69f06498f0ecc50edfaf82cfc76e7e1fef5ea159","after":"ab460d1883435ca223a8114bd107980f5f7f14b0","ref":"refs/heads/encontro-contas-corrige-rioonibus","pushedAt":"2024-06-07T13:50:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"Reverte referências dos modelos `balanco_servico_dia.sql` e `balanco_servico_dia_pos_gt.sql`","shortMessageHtmlLink":"Reverte referências dos modelos <code>balanco_servico_dia.sql</code> e `balanco_…"}},{"before":"8a574492175b75de04ed14afadc228a8f4338533","after":"69f06498f0ecc50edfaf82cfc76e7e1fef5ea159","ref":"refs/heads/encontro-contas-corrige-rioonibus","pushedAt":"2024-06-07T13:48:28.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"Adiciona e altera descrições no schema.yml dos modelos `projeto_subsidio_sppo_encontro_contas`","shortMessageHtmlLink":"Adiciona e altera descrições no schema.yml dos modelos `projeto_subsi…"}},{"before":"0fb2c6002fb2b933febda1f4239ec54d65648510","after":"8a574492175b75de04ed14afadc228a8f4338533","ref":"refs/heads/encontro-contas-corrige-rioonibus","pushedAt":"2024-06-07T13:26:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"Corrige modo de execução do modelo `receita_tarifaria_servico_nao_identificado_quinzena.sql`","shortMessageHtmlLink":"Corrige modo de execução do modelo `receita_tarifaria_servico_nao_ide…"}},{"before":"019b4089f88ea5ce60286ad5b5f432cb3b3fd021","after":"0fb2c6002fb2b933febda1f4239ec54d65648510","ref":"refs/heads/encontro-contas-corrige-rioonibus","pushedAt":"2024-06-07T13:15:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"Atualiza changelog","shortMessageHtmlLink":"Atualiza changelog"}},{"before":"b7d1cf48256d9ba3bcf0f5aa1c81d0870227047b","after":"019b4089f88ea5ce60286ad5b5f432cb3b3fd021","ref":"refs/heads/encontro-contas-corrige-rioonibus","pushedAt":"2024-06-07T13:12:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"Retorna o modo `_pre_gt` para o nome original","shortMessageHtmlLink":"Retorna o modo <code>_pre_gt</code> para o nome original"}},{"before":"7ee9b89e4c11194700ba392d52b35401f8e01ed1","after":"0a8f8c0fce6cdca8fd947f593a78dcd7eba64cde","ref":"refs/heads/master","pushedAt":"2024-06-06T21:05:22.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"eng-rodrigocunha","name":"Rodrigo Cunha","path":"/eng-rodrigocunha","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/66736583?s=80&v=4"},"commit":{"message":"Subsidio - Materializa tabelas sumario_servico_dia_historico e sumario_servico_dia_tipo (#334)\n\n* materializa sumario_servico_dia_historico e tipo\r\n\r\n* ajusta filtro\r\n\r\n* link pr\r\n\r\n* descomenta refs\r\n\r\n* remove comentario","shortMessageHtmlLink":"Subsidio - Materializa tabelas sumario_servico_dia_historico e sumari…"}},{"before":"cd6430d8ab1a567e5f84540f8c49da557c6dd954","after":"221dd5d10f4b888ad26baa2bb8eb010030502896","ref":"refs/heads/materializa-subsidio-sumario-hist","pushedAt":"2024-06-06T21:04:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"pixuimpou","name":"Rafael Carvalho Pinheiro","path":"/pixuimpou","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74972217?s=80&v=4"},"commit":{"message":"remove comentario","shortMessageHtmlLink":"remove comentario"}},{"before":"a6726d4328c29aa323875fd4b6d9a205f1861c61","after":"cd6430d8ab1a567e5f84540f8c49da557c6dd954","ref":"refs/heads/materializa-subsidio-sumario-hist","pushedAt":"2024-06-06T21:01:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"pixuimpou","name":"Rafael Carvalho Pinheiro","path":"/pixuimpou","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74972217?s=80&v=4"},"commit":{"message":"descomenta refs","shortMessageHtmlLink":"descomenta refs"}},{"before":"65c861a84181b6a52e591a927b4bcc1a0385355a","after":"a6726d4328c29aa323875fd4b6d9a205f1861c61","ref":"refs/heads/materializa-subsidio-sumario-hist","pushedAt":"2024-06-06T20:57:35.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"pixuimpou","name":"Rafael Carvalho Pinheiro","path":"/pixuimpou","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74972217?s=80&v=4"},"commit":{"message":"link pr","shortMessageHtmlLink":"link pr"}},{"before":null,"after":"65c861a84181b6a52e591a927b4bcc1a0385355a","ref":"refs/heads/materializa-subsidio-sumario-hist","pushedAt":"2024-06-06T20:56:07.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"pixuimpou","name":"Rafael Carvalho Pinheiro","path":"/pixuimpou","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/74972217?s=80&v=4"},"commit":{"message":"ajusta filtro","shortMessageHtmlLink":"ajusta filtro"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"Y3Vyc29yOnYyOpK7MjAyNC0wOC0yMFQxNTozNjozMy4wMDAwMDBazwAAAASfRl0v","startCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wOC0yMFQxNTozNjozMy4wMDAwMDBazwAAAASfRl0v","endCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wNi0wNlQyMDo1NjowNy4wMDAwMDBazwAAAARenPd3"}},"title":"Activity · prefeitura-rio/queries-rj-smtr"}