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-05-26 23:54:12.

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-05-27

219 sources, 1,571 locations, 11,742,294 snapshots, 6,116,680 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 88665 122092 45179 10478 2021-10-04 00:03:14 2024-05-26 23:48:15 tempus Stadt Beckum
beckumschwimm 1 88673 792 53 0 2021-10-04 00:03:09 2024-05-26 23:48:03 tempus Stadt Beckum Schwimmbäder
bergischgladbach 4 88671 133556 61358 50351 2021-10-04 00:03:14 2024-05-26 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 65401 17020 9720 2720 2021-10-04 12:03:10 2024-05-26 23:48:04 tempus Stadt Bielefeld Ausländerbehörde
bielefeldbb 42 88660 975087 711077 232059 2021-10-04 00:03:46 2024-05-26 23:48:56 tempus Stadt Bielefeld Bürgerberatung
bielefeldfe 6 88669 121530 73897 16626 2021-10-04 00:03:27 2024-05-26 23:48:19 tempus Stadt Bielefeld Fahrerlaubnisbehörde
bielefeldkfz 1 87375 33229 20146 8428 2021-10-04 00:03:10 2024-05-26 23:48:05 tempus Stadt Bielefeld Kfz-Zulassungsbehörde
bielefeldsa 4 85172 17242 6984 2291 2021-10-04 00:03:48 2024-05-26 23:48:57 tempus Stadt Bielefeld Standesamt
billerbeck 2 95244 18311 12266 970 2021-07-26 00:03:04 2024-05-26 23:48:21 etermin Stadt Billerbeck Verwaltung
blankenburg 2 95333 13694 10281 397 2021-07-26 00:03:04 2024-05-26 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 88399 909 75 102 2021-10-04 00:03:11 2024-05-26 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 87905 48554 28827 8407 2021-10-04 00:03:53 2024-05-26 23:49:05 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 93195 4997 641 18 2021-07-12 00:03:38 2024-05-26 23:48:07 netappoint Stadt Bonn Bauamt
bonnjob 2 93304 16473 830 1461 2021-07-26 00:03:05 2024-05-26 23:48:28 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 95378 2264 36 2 2021-07-26 00:03:06 2024-05-26 23:48:29 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 95361 28747 20833 1691 2021-07-26 00:03:06 2024-05-26 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 95366 8498 804 84 2021-07-26 00:03:07 2024-05-26 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 96238 11109 5303 1114 2021-07-12 00:03:49 2024-05-26 23:48:06 netappoint Stadt Dresden
dresdenkfz 5 95931 92118 53560 14427 2021-07-12 00:04:05 2024-05-26 23:48:13 netappoint Stadt Dresden Kfz-Zulassungsbehörde
duelmen 8 95237 55907 28276 3216 2021-07-26 00:03:22 2024-05-26 23:49:17 etermin Stadt Dülmen
ebersfeldwsw 2 88672 13072 2347 1262 2021-10-04 00:03:14 2024-05-26 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 88251 15017 2910 2294 2021-10-04 00:03:57 2024-05-26 23:49:08 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 84426 581916 275865 247720 2021-10-04 00:19:28 2024-05-26 23:49:11 tempus Stadt Frankfurt am Main Bürgeramt
freiberg 3 88639 30911 19846 7700 2021-10-04 00:03:47 2024-05-26 23:50:11 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 95344 24469 3524 28 2021-07-26 00:03:23 2024-05-26 23:49:18 etermin Stadtwerke Geldern Netz
gelsenkirchen 1 88185 16258 7893 2582 2021-10-04 00:03:58 2024-05-26 23:49:13 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 93770 699199 210829 32134 2021-07-26 00:03:48 2024-05-26 23:51:14 etermin Stadt Graz
grazamt 5 95141 86895 43607 9117 2021-07-26 00:03:53 2024-05-26 23:51:23 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 95281 11793 8170 543 2021-07-26 00:03:54 2024-05-26 23:51:28 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 88667 27358 8627 2629 2021-10-04 00:03:54 2024-05-26 23:50:13 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 87819 22393 16576 2900 2021-10-04 00:03:42 2024-05-26 23:49:24 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 89485 1277 254 31 2021-07-26 00:03:57 2024-05-26 23:51:29 etermin Psychologische Studierendenberatung Innsbruck
itzehoe 3 85865 17267 10135 1137 2021-07-26 15:19:04 2024-05-26 23:51:31 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 95963 0 0 0 2021-07-12 00:04:24 2024-05-26 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 88552 73746 32416 28888 2021-10-04 00:04:00 2024-05-26 23:49:17 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 83291 68544 24405 5025 2021-10-04 00:04:01 2024-05-26 23:50:18 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 88666 20244 6754 3419 2021-10-04 00:04:00 2024-05-26 23:49:19 tempus Landkreis Kronach Zulassungsbehörde
krunnakfz 4 88654 73152 42716 21625 2021-10-04 00:04:23 2024-05-26 23:50:21 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 88663 60471 27074 4913 2021-10-04 00:04:11 2024-05-26 23:49:32 tempus Stadt Ladenburg
lauenburgkfz 1 88669 23859 13076 6913 2021-10-04 00:04:24 2024-05-26 23:50:23 tempus Kreis Lauenburg Fachdienst Straßenverkehr
lehrte 7 95191 77282 57215 4899 2021-07-26 00:04:06 2024-05-26 23:52:29 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 88405 40951 26092 9735 2021-10-04 00:04:13 2024-05-26 23:49:36 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 88668 738 20 0 2021-10-04 00:04:13 2024-05-26 23:49:37 tempus Stadt Ludwigshafen Ausländerbehörde
luedenscheid 7 88583 111168 74939 16157 2021-10-04 00:04:26 2024-05-26 23:50:26 tempus Stadt Lüdenscheid
luenen 1 88673 22803 17921 2132 2021-10-04 00:04:30 2024-05-26 23:49:25 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 63135 104506 15872 2683 2021-10-04 00:04:33 2024-05-26 23:50:45 tempus Stadtwerke Mannheim
mannheimsa 6 88673 16739 9294 1543 2021-10-04 00:04:36 2024-05-26 23:49:29 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 95328 16764 5633 236 2021-07-26 00:04:06 2024-05-26 23:52:31 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 88666 85139 49970 20182 2021-10-04 00:05:02 2024-05-26 23:49:53 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 48551 5056 3178 223 2021-07-26 11:04:16 2024-05-23 17:22:44 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 88664 22868 12293 3854 2021-10-04 00:05:08 2024-05-26 23:49:56 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 88665 89650 1378 0 2021-10-04 00:04:39 2024-05-26 23:50:52 tempus Landkreis Oldenburg
olfen 1 95332 14881 8446 707 2021-07-26 00:04:18 2024-05-26 23:52:46 etermin Stadt Olfen
ostfildern 10 88672 102957 63458 17627 2021-10-04 00:04:55 2024-05-26 23:49:35 tempus Ostfildern
overath 6 84318 107975 66736 29527 2021-10-04 00:05:14 2024-05-26 23:50:02 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 88671 135190 58234 23058 2021-10-04 00:05:03 2024-05-26 23:49:44 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 83472 134510 71299 35542 2021-10-04 00:04:49 2024-05-26 23:51:00 tempus Stadt Rösrath
rottenburg 24 88669 185591 126380 39495 2021-10-04 00:05:23 2024-05-26 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 41948 2857 442 32 2023-03-16 13:59:35 2024-05-26 23:52:47 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 88668 37185 23762 6436 2021-10-04 00:05:27 2024-05-26 23:50:09 tempus Stadt Schriesheim
schwaebischhall 4 87608 81050 41761 10605 2021-10-04 10:20:07 2024-05-26 23:51:06 tempus Stadt Schwäbisch Hall
schwaebischhallkfz 15 88664 370700 191749 96795 2021-10-04 00:05:43 2024-05-26 23:50:30 tempus Landkreis Schwäbisch Hall Zulassungsstelle
schwieberdingen 8 88669 89869 40278 13193 2021-10-04 00:05:36 2024-05-26 23:50:18 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 93391 2396 262 284 2021-07-26 00:04:20 2024-05-26 23:52:48 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 93437 3183 146 32 2021-07-26 00:06:32 2024-05-26 23:48:06 tevis Stadt Steinburg
teltow 1 39679 1937 1215 263 2021-10-05 00:04:53 2024-05-15 09:36:12 tempus Stadt Teltow
teublitztest 1 95232 18220 5707 1272 2021-07-26 00:04:21 2024-05-26 23:53:56 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 88667 188404 91449 66077 2021-10-04 00:05:56 2024-05-26 23:50:38 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 8 88561 54213 8746 617 2021-10-04 00:10:26 2024-05-26 23:54:09 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 86590 2116 87 7 2021-12-06 00:09:59 2024-05-26 23:54:09 etermin Bauhaus-Universität Weimar Erdgeschoss Raum 002
weinheim 8 88590 115552 69856 24792 2021-10-04 00:05:40 2024-05-26 23:50:29 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 88664 76228 29946 10910 2021-10-04 00:04:56 2024-05-26 23:51:12 tempus Stadt Werne
werrameissner 4 88666 38044 15882 9589 2021-10-04 00:05:58 2024-05-26 23:50:41 tempus Kreis Werra-Meißner
wiehl 1 88762 4135 2162 208 2021-07-27 09:34:23 2024-05-26 23:54:12 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 82392 315503 120151 92779 2021-10-04 00:05:55 2024-05-26 23:35:34 tempus Stadt Wuppertal Einwohnermeldeamt
wuppertalgeo 5 88518 30119 1120 543 2021-10-04 00:03:11 2024-05-26 23:48:10 netappoint Stadt Wuppertal Geodatenzentrum
wuppertalgw 3 88516 55629 24802 7121 2021-10-04 00:03:08 2024-05-26 23:48:08 netappoint Stadt Wuppertal Gewerbecenter
wuppertalsv 3 88458 88236 34640 36037 2021-10-04 00:04:59 2024-05-26 23:51:15 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.