{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/b392941afbc34f09bc7f22261a12b22f\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/os/loom-media-content/loom/51c505c6-c68d-4f82-bb83-c045f2bd8cef/73cd0a82-812f-47af-8315-8486591f7abb/sessions-thumbnails-b392941afbc34f09bc7f22261a12b22f-eb94e68da6a799bf.gif/binary?authToken=eyJraWQiOiJtaWNyb3MtZ3JvdXAvdGRwLW9zLWFyY2hldHlwZS9wbjBxc2lsb2thdWk1ajBzIiwiYWxnIjoiUlMyNTYifQ.eyJicyI6Imxvb20tbWVkaWEtY29udGVudCIsImF1ZCI6InRkcC1vcy1hcmNoZXR5cGUiLCJuYmYiOjE3OTM5NjY3NjksInRpIjoiOGQxNjk1YzQtMTc0YS00MWNiLTkzNmQtNThlMjI0MTA1ZjIzIiwiYWRpIjoibG9vbS9sb29tIiwiaXNzIjoibWljcm9zLWdyb3VwL3RkcC1vcy1hcmNoZXR5cGUiLCJwaWQiOiI2MmU3ZGI1Ny0xYTRmLTQzZDktYWQ0OS1jNmE3OTg4M2RhZjUiLCJ3YSI6ImZhbHNlIiwib2lkIjoic2Vzc2lvbnMtdGh1bWJuYWlscy1iMzkyOTQxYWZiYzM0ZjA5YmM3ZjIyMjYxYTEyYjIyZi1lYjk0ZTY4ZGE2YTc5OWJmLmdpZiIsImV4cCI6MTc5Mzk2NzM2OSwiaWF0IjoxNzkzOTY2NzY5LCJqdGkiOiJmZTIwOGExOC1kMzc3LTQ0MjItYjFkMC1lYWJmNGMxODBhMGMifQ.Vbzrvz0L7QqJewfoodUw9caHIIPENhzfjIiVVhrvMkQU_ExfCVUhdNpbER12ras8XHDA2hX45_HracsJ8IoeT9sodpHAggwu_IcwoBBtjVbbZNd1yLp3ZRrwSo6gHey8Lp31Zw3dIf2dbuZRjbTVQgUP5RZU4qvwej0LzhZhSWrn2J8Ly5KYe3oUEy71JrLO6WwQRb_kYi99WtxVZfY6j-k9ftpjK-SDMBLW0w2WLOhN5AL6sJLVSu2lZq5v-PGOw6vtMBOontuNxgK06hwoJPPfvMv1WOaWB2vlyPURRpKjFB9otunGgGNxTGOeloW9eUX8yEcqAvdYb_svL8tLAw&Expires=1793967370&Signature=CBg6ziUnQsfcwC8uix7L6XL5hh5jdJ7huesERNJRkHeRVz-q757aJkoouwfXd4u6M4voBafG6qv5HvAyCNnSe4nd5saIqLSieulPGkNkCLqul6VhIF9V1JxLKHZEMOkArbo3jgg7kqgFLLyNOmLDLk3HFnpt0GiV5ZGKyiu084-yjRP0lUxF8r1PYWhXQNdJ6BnNQV6uGJ8C-Zd-okEbUCRqO49eNYPdkTph6-ZefWuLeKmomvxnevUY%7ETNft5TuOnISKlGDTVXWgSRlBh3xtD1fkGrWJVDtqjsDQ%7E2W0lDwipy3G-wVUJtppSRIC9Xsa9NmuyoI8avdJwFN7bSlCA__&Key-Pair-Id=KQOSYIR44AIC0","duration":666.432,"title":"Курсовий проєкт - Філик Софія ","description":"This Loom presents a course project analyzing crime data in the Czech Republic using SQL and interactive visualizations. The author’s goal was to study how crime registration data is defined over time, by types of crimes, and by territory, and then publish results in an interactive document using BigQuery and Data Studio. The dashboard shows the dynamics over months in 2017 and highlights the most common registered crime categories, including a category accounting for about 21.2%, with interactive filters for year and crime type. It also includes a map for geographical distribution of registered cases by year, plus SQL findings comparing 2021 to 2025, where Friday has the highest number of cases per week and robberies remain top across years."}