# Queries

These files contain search results for users' search queries. Each line contains one segment of a suggested journey. 

Example: A person travels from A via B to C. The route A to B is divided into individual sections (journey segment): A1, A2, A3, A4, ... A line then appears in the file for each of these journey segments. If the same segment was also displayed in other users' searches, the query counter is incremented by one for each user with the same segment on his route.

## Example

```
line,dep_station_id,arr_station_id,dep_timestamp,arr_timestamp,count_today,count_today_minus_1,count_today_minus_2,count_today_minus_3,count_today_minus_4,count_today_minus_5,count_today_minus_6,count_today_minus_7,data_generation_timestamp,executed
RB43,900311232,900311620,2024-06-30 00:40:00,2024-06-30 00:42:00,1,,,,,2.0,97.0,3.0,2024-07-06 02:51:34.114556+00:00,2024-07-05 00:00:00
RB43,900311620,900311631,2024-06-30 00:43:00,2024-06-30 00:46:00,1,,,,,2.0,98.0,3.0,2024-07-06 02:51:34.114556+00:00,2024-07-05 00:00:00
RB43,900311631,900311307,2024-06-30 00:47:00,2024-06-30 00:51:00,1,,,,,2.0,100.0,3.0,2024-07-06 02:51:34.114556+00:00,2024-07-05 00:00:00
RB43,900311307,900310601,2024-06-30 00:52:00,2024-06-30 00:57:00,1,,,,,2.0,64.0,4.0,2024-07-06 02:51:34.114556+00:00,2024-07-05 00:00:00
RB43,900310601,900311612,2024-06-30 00:57:00,2024-06-30 01:02:00,1,,,,,2.0,53.0,4.0,2024-07-06 02:51:34.114556+00:00,2024-07-05 00:00:00
RB43,900311612,900311250,2024-06-30 01:02:00,2024-06-30 01:06:00,1,,,,,2.0,53.0,3.0,2024-07-06 02:51:34.114556+00:00,2024-07-05 00:00:00
RB43,900311250,900445593,2024-06-30 01:07:00,2024-06-30 01:12:00,1,,,,,1.0,53.0,3.0,2024-07-06 02:51:34.114556+00:00,2024-07-05 00:00:00
```

## Field types

```
line                              alphanumeric
dep_station_id                    uint32
arr_station_id                    uint32
dep_timestamp                     datetime64[ns]
arr_timestamp                     datetime64[ns]
count_today                       uint16
count_today_minus_1               uint16
count_today_minus_2               uint16
count_today_minus_3               uint16
count_today_minus_4               uint16
count_today_minus_5               uint16
count_today_minus_6               uint16
count_today_minus_7               uint16
data_generation_timestamp         datetime64[ns, UTC]
executed                          datetime64[ns]
```
## Field descriptions

```
line                              Line name
dep_station_id                    Departure stop (segment)
arr_station_id                    Arrival stop (segment)
dep_timestamp                     Date + time of departure at dep_station_id
arr_timestamp                     Date + time of arrival at arr_station_id
count_today                       Total number of counted results at 'executed'
count_today_minus_1               Total number of counted results at 'executed' - 1 day
count_today_minus_2               Total number of counted results at 'executed' - 2 days
count_today_minus_3               Total number of counted results at 'executed' - 3 days
count_today_minus_4               Total number of counted results at 'executed' - 4 days
count_today_minus_5               Total number of counted results at 'executed' - 5 days
count_today_minus_6               Total number of counted results at 'executed' - 6 days
count_today_minus_7               Total number of counted results at 'executed' - 7 days
data_generation_timestamp         datetime64[ns, UTC] Date of this data processing
executed                          datetime64[ns] Date without time when query was executed by user
```

## Remarks

Counted queries could be empty when a segment was not queried at this day.