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-09-15 23:54:44.

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-09-16

219 sources, 1,572 locations, 12,504,159 snapshots, 6,490,875 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 35470 3855 1915 434 2021-07-26 00:03:02 2024-07-02 19:33:07 etermin Landesamt für Mess- und Eichwesen Berlin-Brandenburg
beckum 10 99413 136452 50217 11591 2021-10-04 00:03:14 2024-09-15 23:48:16 tempus Stadt Beckum
beckumschwimm 1 99423 888 53 0 2021-10-04 00:03:09 2024-09-15 23:48:04 tempus Stadt Beckum Schwimmbäder
bergischgladbach 4 99420 150567 68794 56815 2021-10-04 00:03:14 2024-09-15 23:48:08 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 76151 20693 12502 3422 2021-10-04 12:03:10 2024-09-15 23:48:05 tempus Stadt Bielefeld Ausländerbehörde
bielefeldbb 43 99405 1108109 805000 263593 2021-10-04 00:03:46 2024-09-15 23:49:13 tempus Stadt Bielefeld Bürgerberatung
bielefeldfe 6 99417 136146 82166 18349 2021-10-04 00:03:27 2024-09-15 23:48:20 tempus Stadt Bielefeld Fahrerlaubnisbehörde
bielefeldkfz 1 97955 37194 22589 9500 2021-10-04 00:03:10 2024-09-15 23:48:06 tempus Stadt Bielefeld Kfz-Zulassungsbehörde
bielefeldsa 4 95918 21110 8797 2941 2021-10-04 00:03:48 2024-09-15 23:49:16 tempus Stadt Bielefeld Standesamt
billerbeck 2 105963 20131 13420 1077 2021-07-26 00:03:04 2024-09-15 23:48:22 etermin Stadt Billerbeck Verwaltung
blankenburg 2 106059 15705 11505 453 2021-07-26 00:03:04 2024-09-15 23:48:26 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 99148 1042 77 120 2021-10-04 00:03:11 2024-09-15 23:48:07 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 98650 54329 32563 9440 2021-10-04 00:03:53 2024-09-15 23:49:23 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 103941 5714 734 19 2021-07-12 00:03:38 2024-09-15 23:48:09 netappoint Stadt Bonn Bauamt
bonnjob 2 104033 18044 857 1465 2021-07-26 00:03:05 2024-09-15 23:48:27 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 106111 2520 36 2 2021-07-26 00:03:06 2024-09-15 23:48:28 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 106090 32657 23215 1944 2021-07-26 00:03:06 2024-09-15 23:48:34 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 106095 9034 808 85 2021-07-26 00:03:07 2024-09-15 23:48:35 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 106945 12190 5824 1192 2021-07-12 00:03:49 2024-09-15 23:48:08 netappoint Stadt Dresden
dresdenkfz 5 106606 102635 59266 16161 2021-07-12 00:04:05 2024-09-15 23:48:13 netappoint Stadt Dresden Kfz-Zulassungsbehörde
duelmen 9 105955 60427 29993 3370 2021-07-26 00:03:22 2024-09-15 23:49:23 etermin Stadt Dülmen
ebersfeldwsw 2 99421 14174 2535 1391 2021-10-04 00:03:14 2024-09-15 23:48:09 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 98996 16353 3131 2487 2021-10-04 00:03:57 2024-09-15 23:49:25 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 38 93818 620662 294451 265328 2021-10-04 00:19:28 2024-09-02 11:49:10 tempus Stadt Frankfurt am Main Bürgeramt
freiberg 3 99387 34510 22138 8616 2021-10-04 00:03:47 2024-09-15 23:50:27 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 98390 24509 3546 28 2021-07-26 00:03:23 2024-09-13 12:49:52 etermin Stadtwerke Geldern Netz
gelsenkirchen 1 98933 17147 8588 2739 2021-10-04 00:03:58 2024-09-15 23:49:11 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 104103 762194 229367 34319 2021-07-26 00:03:48 2024-09-15 23:51:53 etermin Stadt Graz
grazamt 5 105804 95057 47558 9711 2021-07-26 00:03:53 2024-09-15 23:52:01 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 105968 13142 9054 591 2021-07-26 00:03:54 2024-09-15 23:52:06 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 99416 30886 9506 2963 2021-10-04 00:03:54 2024-09-15 23:50:30 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 98568 25148 18597 3241 2021-10-04 00:03:42 2024-09-15 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 100190 1469 321 36 2021-07-26 00:03:57 2024-09-15 23:52:07 etermin Psychologische Studierendenberatung Innsbruck
itzehoe 3 96581 19740 11606 1254 2021-07-26 15:19:04 2024-09-15 23:52:08 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 106674 0 0 0 2021-07-12 00:04:24 2024-09-15 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 99297 83297 36763 33105 2021-10-04 00:04:00 2024-09-15 23:49:15 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 94041 73819 27033 5518 2021-10-04 00:04:01 2024-09-15 23:50:35 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 99414 22850 7616 3893 2021-10-04 00:04:00 2024-09-15 23:49:16 tempus Landkreis Kronach Zulassungsbehörde
krunnakfz 4 99404 82943 48307 24871 2021-10-04 00:04:23 2024-09-15 23:50:39 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 99411 67988 30649 5558 2021-10-04 00:04:11 2024-09-15 23:49:30 tempus Stadt Ladenburg
lauenburgkfz 1 99419 26831 14811 7769 2021-10-04 00:04:24 2024-09-15 23:50:40 tempus Kreis Lauenburg Fachdienst Straßenverkehr
lehrte 7 105875 87123 63973 5527 2021-07-26 00:04:06 2024-09-15 23:52:57 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 98481 45751 29214 10875 2021-10-04 00:04:13 2024-09-08 23:49:35 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 3 347 109 0 0 2021-10-04 00:08:31 2024-09-11 11:09:38 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 99416 833 20 0 2021-10-04 00:04:13 2024-09-15 23:49:31 tempus Stadt Ludwigshafen Ausländerbehörde
luedenscheid 7 99331 129478 86543 18687 2021-10-04 00:04:26 2024-09-15 23:50:51 tempus Stadt Lüdenscheid
luenen 1 94865 24674 19319 2336 2021-10-04 00:04:30 2024-08-02 09:04:27 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 11 73883 124474 19463 3312 2021-10-04 00:04:33 2024-09-15 23:51:13 tempus Stadtwerke Mannheim
mannheimsa 6 99421 18534 10127 1718 2021-10-04 00:04:36 2024-09-15 23:49:30 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 106040 18487 6298 258 2021-07-26 00:04:06 2024-09-15 23:52:58 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 99413 97416 56391 23143 2021-10-04 00:05:02 2024-09-15 23:49:51 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 57672 5161 3216 230 2021-07-26 11:04:16 2024-09-15 23:53:08 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 90008 23174 12481 3916 2021-10-04 00:05:08 2024-06-09 23:49:59 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 99413 100755 1378 0 2021-10-04 00:04:39 2024-09-15 23:51:19 tempus Landkreis Oldenburg
olfen 1 106047 16555 9537 778 2021-07-26 00:04:18 2024-09-15 23:53:12 etermin Stadt Olfen
ostfildern 10 90016 104383 64242 17915 2021-10-04 00:04:55 2024-06-09 23:49:34 tempus Ostfildern
overath 6 95066 123875 77398 33660 2021-10-04 00:05:14 2024-09-15 23:49:58 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 99420 151668 65175 25951 2021-10-04 00:05:03 2024-09-15 23:49:41 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 94221 155404 84902 40212 2021-10-04 00:04:49 2024-09-15 23:51:26 tempus Stadt Rösrath
rottenburg 24 99416 209139 141868 45010 2021-10-04 00:05:23 2024-09-15 23:50:09 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 52665 3519 545 40 2023-03-16 13:59:35 2024-09-15 23:53:14 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 99416 41442 26584 7168 2021-10-04 00:05:27 2024-09-15 23:50:06 tempus Stadt Schriesheim
schwaebischhall 4 98356 91326 47902 12062 2021-10-04 10:20:07 2024-09-15 23:51:34 tempus Stadt Schwäbisch Hall
schwaebischhallkfz 15 99410 425635 222064 112936 2021-10-04 00:05:43 2024-09-15 23:50:32 tempus Landkreis Schwäbisch Hall Zulassungsstelle
schwieberdingen 8 99417 100937 44448 14931 2021-10-04 00:05:36 2024-09-15 23:50:16 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 104110 2593 262 284 2021-07-26 00:04:20 2024-09-15 23:53:14 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 97601 3313 146 32 2021-07-26 00:06:32 2024-07-09 09:18:06 tevis Stadt Steinburg
teltow 1 42794 2028 1240 280 2021-10-05 00:04:53 2024-08-06 07:36:19 tempus Stadt Teltow
teublitztest 1 105911 19235 5707 1272 2021-07-26 00:04:21 2024-09-15 23:54:26 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 94715 200409 97592 70778 2021-10-04 00:05:56 2024-07-28 23:50:51 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 99252 60958 9656 685 2021-10-04 00:10:26 2024-09-15 23:54:41 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 87582 2163 87 7 2021-12-06 00:09:59 2024-06-06 08:39:24 etermin Bauhaus-Universität Weimar Erdgeschoss Raum 002
weinheim 9 99337 131781 79857 28809 2021-10-04 00:05:40 2024-09-15 23:50:28 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 89336 76563 30098 10978 2021-10-04 00:04:56 2024-06-02 23:51:14 tempus Stadt Werne
werrameissner 4 99414 43193 17865 11064 2021-10-04 00:05:58 2024-09-15 23:50:35 tempus Kreis Werra-Meißner
wiehl 1 99470 4677 2454 237 2021-07-27 09:34:23 2024-09-15 23:54:44 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 19 91537 347565 133965 104496 2021-10-04 00:05:55 2024-09-15 22:05:33 tempus Stadt Wuppertal Einwohnermeldeamt
wuppertalgeo 5 99269 33772 1235 603 2021-10-04 00:03:11 2024-09-15 23:48:13 netappoint Stadt Wuppertal Geodatenzentrum
wuppertalgw 3 99267 62670 27854 8014 2021-10-04 00:03:08 2024-09-15 23:48:09 netappoint Stadt Wuppertal Gewerbecenter
wuppertalsv 3 99207 99738 38783 40124 2021-10-04 00:04:59 2024-09-15 23:51:38 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.