Skip to content

defgsus/office-schedule-data

Repository files navigation

History of free office appointment dates (in Germany)

This is the data export of office-schedule-scraper.

The data contains the free dates where one can make an appointment at a public office at a snapshot interval of 15 minutes, starting on 2021-07-12.

This data repository is updated weekly and the most recent timestamp is 2024-04-21 23:54:20.

Data layout

The raw/ folder contains tar.gz files for each calendar week wherein are csv files for each scraped website. Those have the following format:

date source_id location_id 2021-07-12 08:00:00 2021-07-12 08:05:00 ...
2021-07-12 00:04:23 jena 197 1 ...
2021-07-12 00:04:23 jena 198 1 ...
2021-07-12 00:04:23 jena 199 1 ...
2021-07-12 00:04:23 jena 200 1 ...
2021-07-12 00:19:27 jena 197 1 ...
2021-07-12 00:19:27 jena 198 1 ...
2021-07-12 00:19:27 jena 199 1 ...
2021-07-12 00:19:27 jena 200 1 ...
... ... ... ... ... ...
  • The date column represents the timestamp of the snapshot
    • All dates are (very probably) in Europe/Berlin timezone.
  • The source_id columns contains the id of the website scraper
  • location_id is the id of the office/calendar available on the website
    • Both source_id and location_id together identify the unique calendar within the dataset. The actual names can be looked up in the meta data.
  • All other columns represent the availability of each date.
    • The spacing between dates is 5 to 30 minutes, depending on the website.
    • For space reasons, dates that are not available just have an empty value, available dates contain a 1.
    • Usually the free dates columns show the upcoming 4 weeks from the point of the snapshot date.

The actual data is quite redundant and gigantic in size but the zipped weekly bundles are currently between 6 to 8 megabytes each.

Data access

For a pythonian way read the data access documentation.

Meta data

Some metadata is found in raw/metadata.json and contains an object of the following format:

{
  "*source_id*": {
    "name": "full name of source/website",
    "url": "url of website",
    "locations": {
      "*location_id*": {
        "name": "name of office/building",
        "services": [
          "things you can do there"
        ]    
      }
    } 
  }
}

source_id and location_id can be looked up via:

location_info = metadata[source_id]["locations"][location_id]

Within python, it can be queried via:

from src.data import Data

# returns the plain dict
Data.meta()

# returns a value (e.g. "name") for the given source_id 
#   get_meta() does not raise KeyError, but returns the `default` value 
Data.get_meta("source_id", "value")  

# returns a value (e.g. "name") for the given source_id/location_id
Data.get_meta("source_id", "location_id", "value")  

Metrics

Metrics have been updated at 2024-04-22

219 sources, 1,569 locations, 11,488,416 snapshots, 5,998,725 estimated appointments

  • summary.csv (below table) contains the sum of all weeks per source.
  • summary-weekly.csv contains the number of snapshots and changes per calendar week and source.
source_id num_locations num_snapshots num_changes num_appointments num_cancellations min_date max_date scraper name
amberg 11 38788 21148 7371 1549 2021-07-26 00:03:02 2022-09-23 11:33:09 tevis Stadt Amberg
ansbach 4 64667 43535 29622 8996 2021-10-04 00:03:08 2023-12-03 23:48:12 tempus Stadt Ansbach
badkreuznach 4 48997 32022 15991 5536 2021-07-26 00:03:10 2023-02-27 12:48:04 tevis Stadt Bad-Kreuznach
badwaldsee 5 63818 55280 16976 2952 2021-10-04 00:03:08 2023-09-10 23:48:07 tempus Stadt Bad Waldsee
bbmess 2 35414 3844 1911 434 2021-07-26 00:03:02 2024-02-01 06:48:06 etermin Landesamt für Mess- und Eichwesen Berlin-Brandenburg
beckum 10 85306 117335 43299 10013 2021-10-04 00:03:14 2024-04-21 23:48:15 tempus Stadt Beckum
beckumschwimm 1 85314 762 53 0 2021-10-04 00:03:09 2024-04-21 23:48:03 tempus Stadt Beckum Schwimmbäder
bergischgladbach 4 85312 128215 58872 48226 2021-10-04 00:03:14 2024-04-21 23:48:06 tempus Stadt Bergisch Gladbach
bergkamen 7 62853 126380 56447 33500 2021-10-04 00:03:23 2023-09-03 23:48:24 tempus Stadt Bergkamen
bernkastelwittlich 3 33384 20312 12976 5679 2021-07-26 00:03:17 2022-09-14 13:48:06 tevis Landkreis Bernkastel-Wittlich
bielefeldaus 1 63327 16518 9358 2636 2021-10-04 12:03:10 2024-04-21 23:48:04 tempus Stadt Bielefeld Ausländerbehörde
bielefeldbb 41 85301 932654 680286 221557 2021-10-04 00:03:46 2024-04-21 23:49:04 tempus Stadt Bielefeld Bürgerberatung
bielefeldfe 6 85310 116648 71174 16041 2021-10-04 00:03:27 2024-04-21 23:48:20 tempus Stadt Bielefeld Fahrerlaubnisbehörde
bielefeldkfz 1 85317 32459 19705 8228 2021-10-04 00:03:10 2024-04-21 23:48:05 tempus Stadt Bielefeld Kfz-Zulassungsbehörde
bielefeldsa 4 81831 16269 6601 2131 2021-10-04 00:03:48 2024-04-21 23:49:04 tempus Stadt Bielefeld Standesamt
billerbeck 2 91887 17841 11918 949 2021-07-26 00:03:04 2024-04-21 23:48:17 etermin Stadt Billerbeck Verwaltung
blankenburg 2 91975 13134 9931 381 2021-07-26 00:03:04 2024-04-21 23:48:20 etermin Stadt Blankenburg (Harz)
bochum 7 2016 1035 0 0 2021-10-04 00:03:35 2021-11-07 23:48:37 tempus Stadt Bochum
bochumbau 1 14225 564 204 91 2021-10-04 00:03:13 2022-04-24 23:48:02 netappoint Stadt Bochum Baubürgeramt
bochumkfz 1 6481 4106 3720 1650 2021-10-04 00:03:26 2022-01-30 23:48:20 netappoint Stadt Bochum Büro für Kfz-Angelegenheiten
bochumsw 1 85040 889 75 102 2021-10-04 00:03:11 2024-04-21 23:48:06 tempus Stadtwerke Bochum
bochumzl 1 9158 611 372 195 2021-10-04 00:03:03 2022-02-27 23:48:04 netappoint Stadt Bochum Zulassungsstelle
bochumzl2 1 9156 547 258 29 2021-10-04 00:03:03 2022-02-27 23:48:16 netappoint Stadt Bochum Zulassungsstelle Umtausch
boenen 6 84546 46597 27570 7919 2021-10-04 00:03:53 2024-04-21 23:49:12 tempus Gemeinde Bönen
bonn 3 86491 85994 63459 24556 2021-07-12 00:03:33 2024-02-26 15:18:30 netappoint Stadt Bonn
bonnbau 1 89843 4788 612 16 2021-07-12 00:03:38 2024-04-21 23:48:06 netappoint Stadt Bonn Bauamt
bonnjob 2 89945 16003 819 1459 2021-07-26 00:03:05 2024-04-21 23:48:22 etermin Jobcenter Bonn
braunschweig 16 67834 170053 96440 47540 2021-10-04 00:03:49 2023-10-29 23:48:53 netappoint Stadt Braunschweig
braunschweigtest 1 637 59 20 1 2021-07-26 00:03:05 2021-08-01 15:03:18 etermin Corona Test Braunschweig
bremen 52 23907 107124 65431 30544 2021-10-04 00:04:35 2022-07-24 23:51:02 tevis Stadt Bremen / Bremerhaven
burgendlandkaa 1 92018 2184 36 2 2021-07-26 00:03:06 2024-04-21 23:48:23 etermin Kammer für Arbeiter und Angestellte für das Burgenland
burscheid 5 68677 77622 36582 16060 2021-10-04 00:03:40 2023-10-31 15:03:27 tempus Stadt Burscheid
butzbach 2 92001 27789 20169 1635 2021-07-26 00:03:06 2024-04-21 23:48:27 etermin Magistrat der Stadt Butzbach
cochemzell 12 42346 29830 9925 4574 2021-07-26 00:03:27 2022-12-19 09:03:08 tevis Landkreis Cochem-Zell
coesfeld 2 92006 8372 803 84 2021-07-26 00:03:07 2024-04-21 23:48:27 etermin Stadt Coesfeld
dachau 4 27790 20130 12582 6469 2021-10-04 00:03:02 2022-09-01 16:03:03 tevis Landratsamt Dachau
daunvg 1 14110 474 272 23 2021-07-26 00:03:07 2022-04-05 08:48:35 etermin Verbandsgemeindeverwaltung Daun
deggendorf 6 32299 32263 21409 3502 2021-10-04 00:03:30 2022-10-27 07:48:47 etermin Landratsamt Deggendorf
dormagen 2 10287 500 181 10 2021-07-26 08:18:09 2022-09-21 15:48:49 etermin Stadt Dormagen
dresden 3 92886 10809 5166 1096 2021-07-12 00:03:49 2024-04-21 23:48:06 netappoint Stadt Dresden
dresdenkfz 5 92588 89100 51743 13921 2021-07-12 00:04:05 2024-04-21 23:48:14 netappoint Stadt Dresden Kfz-Zulassungsbehörde
duelmen 8 91882 54967 28058 3198 2021-07-26 00:03:22 2024-04-21 23:48:59 etermin Stadt Dülmen
ebersfeldwsw 2 85313 12801 2291 1216 2021-10-04 00:03:14 2024-04-21 23:48:08 tempus Stadtwerke Ebersfeld
egelsbach 3 3503 575 80 37 2021-07-12 00:04:06 2021-08-17 14:33:04 tevis Stadt Egelsbach
eislingen 6 84631 34250 6555 3782 2021-07-26 00:03:50 2024-03-06 16:33:04 tevis Stadt Eislingen
elitheratest 1 458 47 10 9 2021-07-26 00:03:22 2021-07-31 10:03:50 etermin Corona TESTZENTRUM im Elithera
eschwege 4 84892 14587 2853 2222 2021-10-04 00:03:57 2024-04-21 23:49:14 tempus Stadt Eschwege
essen 22 73140 347841 147459 126773 2021-10-04 00:04:18 2024-02-11 23:48:45 tempus Stadt Essen Bürgeramt
essenborbeckkfz 5 9204 10123 6276 2208 2021-10-04 00:03:44 2023-08-23 11:33:27 tempus Kfz.-Zulassungs- u. Fahrerlaubnisbehörde Essen-Borbeck
essenfa 5 38608 31271 19461 5636 2021-10-04 00:04:03 2024-02-02 11:19:07 tempus Stadt Essen Fahrerlaubnisbehörde
essenkfz 6 37154 56355 36622 23964 2021-10-04 00:03:59 2024-02-09 11:33:58 tempus Stadt Essen Kfz.-Zulassungsbehörde
essensoze 1 78376 8532 4503 855 2021-10-04 00:04:20 2024-02-11 23:48:09 tempus Stadt Essen Elterngeld
essensozw 1 78175 6664 3524 1028 2021-10-04 00:04:04 2024-02-11 23:49:16 tempus Stadt Essen Wohngeld
evo 16 71883 10164 1707 275 2021-10-04 00:03:30 2023-12-03 23:48:54 tempus EVO ServicePunkt
frankenthal 4 28199 9700 5129 2259 2021-07-26 00:03:57 2022-07-14 10:19:14 tevis Stadt Frankenthal
frankfurt 15 3507 9012 3608 2897 2021-07-12 00:04:11 2021-08-17 14:33:14 tevis Stadt Frankfurt
frankfurtba 40 81067 570588 270397 243204 2021-10-04 00:19:28 2024-04-21 23:49:14 tempus Stadt Frankfurt am Main Bürgeramt
freiberg 3 85282 29800 19201 7400 2021-10-04 00:03:47 2024-04-21 23:50:17 tempus Stadt Freiberg
freising 3 48364 35267 22243 5561 2021-10-04 00:03:32 2023-04-02 23:48:54 tempus Stadt Freising
friedrichsdorf 11 3507 2509 462 129 2021-07-12 00:04:13 2021-08-17 14:33:19 tevis Stadt Friedrichsdorf
friesland 4 37430 19480 12648 6226 2021-10-04 00:03:05 2022-12-10 09:48:10 tevis Landkreis Friesland
fuerstenfeldbruck 3 29875 11401 6139 3191 2021-10-04 00:03:57 2022-10-13 11:03:29 tevis Landratsamt Fürstenfeldbruck
fuerthtest 1 18789 6250 1203 1010 2021-07-26 00:03:22 2022-03-20 23:50:03 etermin SARS-CoV-2 Testzentrum der Stadt Fürth
fulda 8 59172 45912 19179 9170 2021-10-04 00:04:03 2023-08-24 10:18:06 tevis Stadt Fulda
geldernsw 2 91987 23867 3494 27 2021-07-26 00:03:23 2024-04-21 23:49:03 etermin Stadtwerke Geldern Netz
gelsenkirchen 1 84825 15873 7678 2521 2021-10-04 00:03:58 2024-04-21 23:49:15 tempus Stadt Gelsenkirchen
giessen 3 12763 609 27 0 2021-10-04 00:03:51 2022-03-27 23:48:59 tempus Stadt Gießen
goeppingen 4 25513 23648 13308 5907 2021-10-04 00:03:04 2022-08-10 14:03:05 tevis Landkreis Goeppingen
goettingen 9 29036 56821 29529 19934 2021-10-04 00:03:05 2022-09-14 13:33:03 tevis Stadt Göttingen
goslartest 1 42901 16672 11362 2274 2021-07-26 00:03:24 2022-11-27 23:49:15 etermin Testzentrum Goslar
gottmadingen 1 54636 4751 3048 396 2021-10-04 00:04:05 2023-06-28 14:48:18 tevis Gemeinde Gottmadingen
graz 39 90471 678039 205492 31487 2021-07-26 00:03:48 2024-04-21 23:51:59 etermin Stadt Graz
grazamt 5 91788 84040 42352 8906 2021-07-26 00:03:53 2024-04-21 23:52:05 etermin BürgerInnenamt Stadt Graz
grazuni 1 61415 7485 162 6 2021-08-12 02:19:47 2023-06-25 23:51:34 etermin Universität Graz
greifswald 9 42900 56000 24468 9545 2021-10-04 00:03:09 2023-02-23 19:18:09 tevis Stadt Greifswald
gronau 8 63769 38351 18036 4927 2021-07-26 00:04:01 2023-08-03 12:03:09 tevis Stadt Gronau
grossumstadt 3 3508 1471 550 198 2021-07-12 00:04:14 2021-08-17 14:33:21 tevis Stadt Groß-Umstadt
hahnenkleetest 1 33206 4944 1573 173 2021-12-06 00:08:15 2022-11-27 23:51:23 etermin Testzentrum Hahnenklee
halbersadt 2 91925 11361 7880 525 2021-07-26 00:03:54 2024-04-21 23:52:10 etermin Stadt Halberstadt
halle 22 90534 78806 48068 15240 2021-07-26 00:03:31 2024-04-07 23:48:10 netappoint Stadt Halle
hammersbachtest 2 46175 43735 21223 1108 2021-07-26 00:03:55 2022-12-31 13:25:17 etermin Schnelltestzentrum Hammersbach
heidelberg 8 36934 35808 16902 7801 2021-07-12 00:04:15 2022-09-11 23:48:05 tevis Stadt Heidelberg
herborn 4 55078 38256 15977 5454 2021-10-04 00:03:36 2023-06-30 12:19:19 tempus Stadt Herborn
hersfeldtest 1 39757 9127 2249 1348 2021-07-26 00:03:56 2023-02-06 14:07:14 etermin Corona-Testcenter Hersfeld-Rotenburg
hof 5 31490 19816 10641 2210 2021-07-26 00:04:07 2022-09-13 15:18:19 tevis Stadt Hof
holtestukenbrock 2 85310 26321 8276 2508 2021-10-04 00:03:54 2024-04-21 23:50:19 tempus Stadt Schloß Holte-Stukenbrock
hornberg 1 3508 543 193 95 2021-07-12 00:04:16 2021-08-17 14:33:21 tevis Stadt Hornberg
hsktest 1 51556 12932 2105 572 2021-07-26 00:03:57 2023-02-26 12:36:52 etermin Hochsauerlandkreis
huenstetten 4 3508 675 233 61 2021-07-12 00:04:17 2021-08-17 14:33:24 tevis Stadt Hünstetten
huettenberg 9 3508 851 112 35 2021-07-12 00:04:21 2021-08-17 14:33:30 tevis Stadt Hüttenberg
ilmkreis 1 34300 51 1 0 2021-07-12 00:04:22 2022-11-09 08:33:02 tevis Ilm-Kreis
ilvesheim 5 84459 21633 16023 2818 2021-10-04 00:03:42 2024-04-21 23:49:26 tempus Gemeinde Ilvesheim
impfthueringen 69 15449 555563 362090 380709 2021-07-12 00:00:00 2022-01-30 23:45:00 custom Impftermin Thüringen
ingelheim 2 55994 15273 8289 4753 2021-07-26 00:04:09 2023-05-05 08:33:12 tevis Stadt Ingelheim
innsbruckpsych 1 86126 1241 247 30 2021-07-26 00:03:57 2024-04-21 23:52:10 etermin Psychologische Studierendenberatung Innsbruck
itzehoe 3 82506 16565 9754 1100 2021-07-26 15:19:04 2024-04-21 23:52:12 etermin Stadt Itzehoe Einwohnermeldeamt
jena 7 48082 54622 30521 15532 2021-07-12 00:04:23 2023-01-06 08:18:04 tevis Stadt Jena
kaiserslauternausl 2 92603 0 0 0 2021-07-12 00:04:24 2024-04-21 23:48:02 netappoint Stadt Kaiserslautern Ausländerbehörde
kassel 14 3508 7544 4065 1804 2021-07-12 00:04:29 2021-08-17 14:33:36 tevis Stadt Kassel
kelsterbach 1 3508 575 114 61 2021-07-12 00:04:30 2021-08-17 14:33:37 tevis Stadt Kelsterbach
kfzgrasbrunn 2 21491 9016 4999 3240 2021-10-04 00:04:28 2022-07-12 17:05:26 tevis Kfz Zulassungstelle Grasbrunn
kherfordkfz 3 85192 71004 31200 27791 2021-10-04 00:04:00 2024-04-21 23:49:20 tempus Kreis Herford Straßenverkehrsamt
kielema 7 46431 24342 12296 4153 2021-10-04 00:03:06 2023-03-15 14:33:10 tevis Kiel Einwohnermeldeamt
kielsw 6 79934 67031 23517 4806 2021-10-04 00:04:01 2024-04-21 23:50:24 tempus Stadtwerke Kiel
kluetzerwinkel 1 26509 2667 1958 388 2021-10-04 00:03:11 2022-09-01 19:48:10 tevis Amt Kluetzer Winkel
koeln 8 61126 5892 3819 2593 2021-10-04 00:04:33 2023-08-13 23:48:03 netappoint Stadt Koeln
kreisbergstrasse 2 15182 6732 4028 1677 2021-07-12 00:04:53 2022-01-30 23:48:10 netappoint Kreis Bergstraße
kreisgermersheimkfz 1 15389 2187 831 194 2021-07-12 00:04:55 2022-01-30 23:48:01 netappoint Kreis Germersheim Kfz-Zulassungsbehörde
kreisgrossgerau 12 3321 4437 1138 917 2021-07-12 00:04:59 2021-08-17 13:48:44 tevis Kreis Groß-Gerau
kreisolpe 11 68526 227458 131493 85878 2021-10-04 00:03:53 2023-10-29 23:49:28 tempus Kreis Olpe
kreissoest 3 26917 22116 14224 8619 2021-10-04 00:03:06 2022-08-23 23:18:08 tevis Kreis Soest
kreissteinfurt 1 1577 260 181 15 2021-07-26 00:03:58 2021-08-11 10:05:11 etermin Kreis Steinfurt
kreiswesel 5 41079 54377 32096 16866 2021-07-12 00:05:02 2022-10-26 08:48:06 tevis Kreis Wesel
kronachkfz 1 85306 19474 6478 3261 2021-10-04 00:04:00 2024-04-21 23:49:21 tempus Landkreis Kronach Zulassungsbehörde
krunnakfz 4 85297 70110 40998 20713 2021-10-04 00:04:23 2024-04-21 23:50:27 tempus Kreis Unna Kfz
kuerten 4 13434 3402 2066 400 2021-10-04 00:04:07 2022-04-03 23:49:10 tempus Stadt Kürten
kvmayenkoblenz 7 39450 42901 24810 8536 2021-07-26 00:04:22 2022-11-23 14:48:16 tevis Landkreis Mayen-Koblenz
ladenburg 9 85304 58356 26085 4760 2021-10-04 00:04:11 2024-04-21 23:49:33 tempus Stadt Ladenburg
lauenburgkfz 1 85312 23076 12669 6719 2021-10-04 00:04:24 2024-04-21 23:50:28 tempus Kreis Lauenburg Fachdienst Straßenverkehr
lehrte 7 91832 74309 54997 4709 2021-07-26 00:04:06 2024-04-21 23:52:47 etermin Stadt Lehrte
leichlingen 12 74572 85871 52252 15320 2021-10-04 00:04:21 2023-12-31 23:49:15 tempus Stadt Leichlingen
leimen 5 85047 39246 25019 9261 2021-10-04 00:04:13 2024-04-21 23:49:38 tempus Stadt Leimen
leipzig 10 62377 33555 22639 2716 2021-07-26 00:03:13 2023-07-23 23:48:03 custom Stadt Leipzig
leipzigstandesamt 3 11419 1254 695 234 2021-07-12 00:05:04 2021-12-19 23:48:03 netappoint Stadt Leipzig Standesamt
leun 6 1590 592 56 11 2021-07-12 00:05:05 2021-08-17 00:22:10 tevis Stadt Leun
leverkusen 1 59120 9344 3737 1941 2021-10-04 00:03:02 2023-07-23 23:48:03 netappoint Zulassungsstelle Leverkusen
linsengericht 1 1461 220 34 18 2021-07-12 00:05:05 2021-08-17 00:22:11 tevis Stadt Linsengericht
lippstadtew 4 54927 65861 38303 14586 2021-10-04 08:04:37 2023-10-30 11:19:43 tempus Stadt Lippstadt Fachdienst Einwohnerwesen
lkbhkfz 2 4580 961 564 296 2021-10-04 00:03:21 2022-01-02 23:48:04 netappoint Landkreis Breisgau-Hochschwarzwald Kfz-Zulassungsbehörde
lkbhlw 1 4593 0 0 0 2021-10-04 00:03:02 2022-01-02 23:48:03 netappoint Landkreis Breisgau-Hochschwarzwald Landwitschaft
lkcoesfeld 4 345 109 0 0 2021-10-04 00:08:31 2021-10-07 14:24:02 etermin Kreis Coesfeld
lkortenau 24 26730 73115 143 168 2021-10-04 00:03:11 2022-08-23 14:03:08 tevis Landkreis Ortenau
lkzwickau 10 39828 52199 27824 11152 2021-10-04 00:04:49 2023-02-08 15:03:21 tevis Landkreis Zwickau
loehne 17 32647 42417 7398 2670 2021-07-26 00:04:53 2022-09-20 11:03:32 tevis Stadt Löhne
lramiesbach 3 41019 18882 10665 5829 2021-07-26 00:04:57 2022-12-01 11:03:25 tevis Landratsamt Miesbach
lramuenchenausl 21 23119 16338 6917 4097 2021-10-04 00:05:31 2022-08-24 08:20:47 tevis Landkreis München Ausländerbehörde
lramuenchenefa 11 81629 104841 33825 11044 2021-07-26 00:05:01 2024-02-12 11:18:10 tevis Landratsamt München
lramuenchenjob 32 2011 4063 4 0 2021-10-04 00:03:13 2021-11-07 23:48:13 tevis Landkreis München Jobcenter
ludwigsburg 16 63148 141932 68156 45482 2021-10-04 00:04:29 2023-09-03 23:49:45 tempus Stadt Ludwigsburg
ludwigshafen 13 75341 101972 61885 22584 2021-10-04 00:03:08 2024-01-12 13:33:13 tevis Kreis Ludwigshfen
ludwigshafenaus 1 85310 710 20 0 2021-10-04 00:04:13 2024-04-21 23:49:39 tempus Stadt Ludwigshafen Ausländerbehörde
luedenscheid 7 85227 107548 72638 15640 2021-10-04 00:04:26 2024-04-21 23:50:35 tempus Stadt Lüdenscheid
luenen 1 85317 21744 17067 2029 2021-10-04 00:04:30 2024-04-21 23:49:28 tempus Stadt Lünen
maerkischerkreis 9 52090 75247 44981 16857 2021-10-04 00:03:07 2023-05-12 12:33:08 tevis Märkischer Kreis
magdeburg 28 45863 59425 11852 2440 2021-07-12 00:05:32 2022-12-18 23:48:12 netappoint Stadt Magdeburg
mainz 17 39177 97768 63922 20100 2021-07-26 00:03:22 2022-10-19 13:48:22 tevis Stadt Mainz
mannheimbs 67 40466 342710 191441 96667 2021-10-04 00:04:58 2023-01-29 23:49:38 tempus Stadt Mannheim Bürgerservice
mannheimmvv 10 59779 98793 14485 2426 2021-10-04 00:04:33 2024-04-21 23:50:52 tempus Stadtwerke Mannheim
mannheimsa 6 85313 16233 9067 1495 2021-10-04 00:04:36 2024-04-21 23:49:32 tempus Stadt Mannheim Fachbereich Sicherheit und Ordnung
mechernich 2 21881 4952 2069 453 2021-10-04 00:03:15 2022-07-17 23:48:08 tevis Stadt Mechernich
minden 3 57169 40295 27002 12022 2021-07-26 00:05:06 2023-05-22 08:03:20 tevis Stadt Minden
mittenwalde 3 91969 16256 5434 228 2021-07-26 00:04:06 2024-04-21 23:52:48 etermin Stadt Mittenwalde
moerlenbach 1 1375 257 20 9 2021-07-12 00:05:32 2021-08-17 00:22:12 tevis Stadt Mörlenbach
muelheim 9 37309 64285 40060 15584 2021-10-04 00:03:06 2022-12-09 13:03:11 tevis Stadt Mülheim an der Ruhr
muenster 20 42251 136732 87508 41696 2021-10-04 00:03:10 2023-01-29 18:03:14 tevis Stadt Muenster
neuisenburg 1 1334 238 24 22 2021-07-12 00:05:33 2021-08-17 00:22:13 tevis Stadt Neu-Isenburg
neuulm 5 85309 81023 47936 19066 2021-10-04 00:05:02 2024-04-21 23:49:55 tempus Stadt Neu-Ulm
niedenstein 1 1294 204 17 4 2021-07-12 00:05:33 2021-08-17 00:22:13 tevis Stadt Niedenstein
nordhausen 2 83908 19295 12280 6088 2021-07-12 00:05:35 2024-01-15 13:03:05 tevis Stadt Nordhausen
nuernberg 51 32936 117205 59618 24600 2021-10-04 00:06:01 2022-10-24 10:03:41 tevis Stadt Nürnberg
nusloch 4 69826 28849 3105 852 2021-10-04 00:04:34 2023-11-30 15:49:57 tempus Gemeinde Nußloch
oberasbach 2 47287 5040 3175 223 2021-07-26 11:04:16 2024-04-18 11:40:14 etermin Stadt Oberasbach
oberbergisch 11 82387 205594 120999 87753 2021-10-04 00:04:46 2024-03-22 11:19:36 tempus Straßenverkehrsamt Oberbergischer Kreis
oberding 3 85307 22273 11946 3738 2021-10-04 00:05:08 2024-04-21 23:49:58 tempus Stadt Oberding
oberramstadt 6 1196 1191 140 117 2021-07-12 00:05:38 2021-08-17 00:22:17 tevis Stadt Ober-Ramstadt
oesterreichgk 9 30021 47 2 2 2021-09-02 00:06:35 2023-05-15 17:22:25 etermin Österreichische Gesundheitskasse
offenbach 9 1185 1522 23 3 2021-07-12 00:05:41 2021-08-17 00:22:22 tevis Stadt Offenbach
oldenburg 4 85309 86560 1378 0 2021-10-04 00:04:39 2024-04-21 23:50:59 tempus Landkreis Oldenburg
olfen 1 91973 14416 8089 679 2021-07-26 00:04:18 2024-04-21 23:53:02 etermin Stadt Olfen
ostfildern 10 85313 99671 61439 17053 2021-10-04 00:04:55 2024-04-21 23:49:39 tempus Ostfildern
overath 6 80961 103279 63850 28535 2021-10-04 00:05:14 2024-04-21 23:50:00 tempus Stadt Overath
paderborn 19 34412 72633 26929 17127 2021-07-26 00:05:36 2022-10-10 14:03:59 tevis Stadt Paderborn
pfungstadt 2 1170 520 89 55 2021-07-12 00:05:43 2021-08-13 23:34:33 tevis Stadt Pfungstadt
radolfzell 4 23399 15983 6158 1490 2021-10-04 00:03:21 2022-07-17 23:48:13 tevis Stadt Radolfzell
rastatt 11 27968 16530 1215 333 2021-10-04 00:06:40 2022-10-07 10:19:17 tevis Stadt Rastatt
ravensburg 4 73898 60610 23306 10740 2021-10-04 00:04:43 2023-12-24 23:50:04 tempus Stadt Ravensburg
rhedawiedenbrueck 7 85312 130176 56057 22239 2021-10-04 00:05:03 2024-04-21 23:49:48 tempus Stadt Rheda-Wiedenbrück
rheingautaunus 5 79276 37716 14719 11588 2021-10-04 00:05:18 2024-02-18 23:50:19 tempus Rheingau-Taunus-Kreis
roesrath 6 80117 128442 67122 33914 2021-10-04 00:04:49 2024-04-21 23:51:07 tempus Stadt Rösrath
rottenburg 24 85312 178143 121407 37810 2021-10-04 00:05:23 2024-04-21 23:50:15 tempus Stadt Rottenburg
saarbruecken 10 31043 72560 43496 21402 2021-10-04 00:03:09 2022-10-05 12:33:09 tevis Stadt Saarbrücken
saluburggbr 3 38589 2689 425 32 2023-03-16 13:59:35 2024-04-21 23:53:03 etermin Gesundheitsberuferegister Arbeiterkammer Salzburg
salzgitter 28 48210 80920 27752 13936 2021-07-26 00:06:21 2023-03-07 10:48:36 tevis Stadt Salzgitter
salzlandkreis 8 24631 34156 17802 8127 2021-10-04 00:03:09 2022-07-29 18:03:12 tevis Salzlandkreis
schoenebeckelbe 1 73814 619 311 115 2021-07-26 00:06:23 2023-11-07 11:48:11 tevis Stadt Schönebeck (Elbe)
schriesheim 7 85311 35937 23036 6274 2021-10-04 00:05:27 2024-04-21 23:50:07 tempus Stadt Schriesheim
schwaebischhall 4 84253 78293 39969 10286 2021-10-04 10:20:07 2024-04-21 23:51:15 tempus Stadt Schwäbisch Hall
schwaebischhallkfz 15 85308 355355 183649 92394 2021-10-04 00:05:43 2024-04-21 23:50:38 tempus Landkreis Schwäbisch Hall Zulassungsstelle
schwieberdingen 8 85312 86890 38996 12588 2021-10-04 00:05:36 2024-04-21 23:50:15 tempus Stadt Schwieberdingen
selm 3 80558 14717 8284 696 2021-07-26 09:49:51 2024-02-16 10:54:40 etermin Stadt Selm
speyer 5 9946 2405 1384 321 2021-07-26 00:06:26 2022-08-23 14:04:26 tevis Stadt Speyer
sraachen 2 13397 11988 9409 4700 2021-10-04 00:03:24 2022-04-03 23:48:03 netappoint Städteregion Aachen
stade 4 19145 15192 8094 2840 2021-10-04 00:07:28 2022-06-19 23:54:59 tevis Landkreis Stade
stadtbergen 1 90031 2336 262 284 2021-07-26 00:04:20 2024-04-21 23:53:04 etermin Stadt Stadtbergen
stadtsoest 1 69473 23909 16591 8431 2021-07-26 00:06:28 2023-09-22 12:33:14 tevis Stadt Söst
steinburg 1 90084 3085 146 32 2021-07-26 00:06:32 2024-04-21 23:48:06 tevis Stadt Steinburg
teltow 1 38496 1893 1189 259 2021-10-05 00:04:53 2024-04-20 15:21:16 tempus Stadt Teltow
teublitztest 1 91881 17901 5707 1272 2021-07-26 00:04:21 2024-04-21 23:54:04 etermin Corona-Schnellteststelle Teublitz
trier 8 31616 26182 13389 6511 2021-07-26 00:06:43 2022-09-06 14:49:11 tevis Stadt Trier
tuebingen 19 85311 181480 87547 63485 2021-10-04 00:05:56 2024-04-21 23:50:46 tempus Stadt Tübingen
unna 3 36731 10678 6032 2746 2021-07-26 00:06:46 2022-10-17 15:03:59 tevis Stadt Unna
verden 2 30587 18814 11311 7329 2021-10-04 00:03:04 2022-10-12 15:03:06 tevis Landkreis Verden
viernheim 1 1169 315 52 31 2021-07-12 00:05:43 2021-08-13 23:34:34 tevis Stadt Viernheim
walldorf 7 85205 52032 8435 594 2021-10-04 00:10:26 2024-04-21 23:54:17 etermin Stadt Walldorf
weilheimschongau 4 28958 15477 8424 5022 2021-07-26 00:06:51 2022-07-22 08:57:23 tevis Landkreis Weilheim-Schongau
weimar 3 38322 18081 8744 5295 2021-07-12 00:05:44 2022-09-26 14:48:04 tevis Stadt Weimar
weimarunioffice 1 83233 1996 87 7 2021-12-06 00:09:59 2024-04-21 23:54:18 etermin Bauhaus-Universität Weimar Erdgeschoss Raum 002
weinheim 8 85233 110808 66686 23582 2021-10-04 00:05:40 2024-04-21 23:50:27 tempus Stadt Weinheim
weiterstadt 2 1135 581 51 19 2021-07-12 00:05:45 2021-08-09 15:34:56 tevis Stadt Weiterstadt
werne 5 85309 73578 29000 10429 2021-10-04 00:04:56 2024-04-21 23:51:21 tempus Stadt Werne
werrameissner 4 85310 36634 15362 9204 2021-10-04 00:05:58 2024-04-21 23:50:48 tempus Kreis Werra-Meißner
wiehl 1 85406 3991 2079 206 2021-07-27 09:34:23 2024-04-21 23:54:20 etermin Stadt Wiehl
wismar 8 26510 21592 9113 2011 2021-10-04 00:03:19 2022-09-01 19:48:20 tevis Hansestadt Wismar
wittmund 3 29529 9042 3926 2531 2021-07-26 00:06:56 2022-07-28 11:47:59 tevis Stadt Wittmund
worms 7 40799 37596 22506 11468 2021-07-26 00:07:06 2023-01-04 16:18:50 tevis Stadt Worms
wuppertalewm 18 80099 307525 116860 90045 2021-10-04 00:05:55 2024-04-21 23:50:32 tempus Stadt Wuppertal Einwohnermeldeamt
wuppertalgeo 5 85159 28998 1090 518 2021-10-04 00:03:11 2024-04-21 23:48:12 netappoint Stadt Wuppertal Geodatenzentrum
wuppertalgw 3 85157 53730 23953 7074 2021-10-04 00:03:08 2024-04-21 23:48:08 netappoint Stadt Wuppertal Gewerbecenter
wuppertalsv 3 85103 84565 32999 34746 2021-10-04 00:04:59 2024-04-21 23:51:24 tempus Stadt Wuppertal Staßenverkehrsamt

Where the columns are:

  • source_id, name, scraper: The source of the scraped data. See office-schedule-scraper for details.
  • num_locations: The average number of locations or different offices that are found for the source.
  • num_snapshots: The number of successful snapshots of the website data.
  • num_changes: The number of changes in the schedule data, summed over all locations. That means, whenever a location shows a different schedule compared to the previous snapshot, the number is increased by 1.
  • num_appointments: The estimated number of appointments that have been made, summed over all locations. Please read below note!
  • num_cancellations: Similar to num_appointments but this shows the number of free dates that have reappeared on the schedule.

The summary-weekly.csv table is similar but contains a row for each calendar week as well.

There are some problems estimating the actual number of appointments and cancellations. Including strange data from the websites at some points in time. In the above tables, the numbers for appointments and cancellations are summed over the estimated numbers per snapshot, limited to 1. That means that no location can contribute more than 1 appointment/cancellation per 15 minutes. That mitigates one of the problems, where a sequence of free 5-minute slots disappears, probably because they are occupied by one longer appointment.