# Ritmogestion feed

Web site: https://www.ritmogestion.es/

This feed provides us "Top 10000 tracks".
This data is used by BI team.

It's weekly feed.

# Week number
The source uses quite unusual week numbering.
Week starts on Friday and ends on Thursday.

The first week of the year from historical:
* 2021-12-31 Fri - 2022-01-06 Thu
* 2021-01-01 Fri - 2021-01-07 Thu
* 2019-12-27 Fri - 2020-01-03 Thu

Let's consider the first week of a year is the week having Thursday in the year.

# CSV Format
Generally speaking the provider produces invalid CSV file
which cannot ge ingested using Snowflake tools.

We do several steps to fix it:
* replace extra-quoted fields with correct quoting
* fix number format from '12.345.678' to '12345678'