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 2025-06-08 23:53:13.

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 2025-06-09

219 sources, 1,573 locations, 14,113,565 snapshots, 7,189,273 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 35768 3933 1926 438 2021-07-26 00:03:02 2025-05-26 08:18:05 etermin Landesamt für Mess- und Eichwesen Berlin-Brandenburg
beckum 10 124944 169494 61324 14100 2021-10-04 00:03:14 2025-06-08 23:48:15 tempus Stadt Beckum
beckumschwimm 1 124955 1115 53 0 2021-10-04 00:03:09 2025-06-08 23:48:03 tempus Stadt Beckum Schwimmbäder
bergischgladbach 4 124950 189429 85834 70035 2021-10-04 00:03:14 2025-06-08 23:48:07 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 101549 28732 18321 4948 2021-10-04 12:03:10 2025-06-07 19:03:04 tempus Stadt Bielefeld Ausländerbehörde
bielefeldbb 46 124934 1408696 1017758 329017 2021-10-04 00:03:46 2025-06-08 23:48:59 tempus Stadt Bielefeld Bürgerberatung
bielefeldfe 6 124907 172694 102356 23090 2021-10-04 00:03:27 2025-06-08 23:48:16 tempus Stadt Bielefeld Fahrerlaubnisbehörde
bielefeldkfz 1 123486 47268 28876 12632 2021-10-04 00:03:10 2025-06-08 23:48:04 tempus Stadt Bielefeld Kfz-Zulassungsbehörde
bielefeldsa 4 120014 27971 11386 4110 2021-10-04 00:03:48 2025-06-08 23:49:00 tempus Stadt Bielefeld Standesamt
billerbeck 2 131460 24258 16013 1322 2021-07-26 00:03:04 2025-06-08 23:48:26 etermin Stadt Billerbeck Verwaltung
blankenburg 2 131569 20160 14030 564 2021-07-26 00:03:04 2025-06-08 23:48:34 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 124678 1296 93 145 2021-10-04 00:03:11 2025-06-08 23:48:05 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 124180 68354 41050 12320 2021-10-04 00:03:53 2025-06-08 23:49:08 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 128520 7257 943 21 2021-07-12 00:03:38 2025-05-30 12:18:06 netappoint Stadt Bonn Bauamt
bonnjob 2 122983 20838 946 1478 2021-07-26 00:03:05 2025-04-01 14:48:24 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 124241 2952 36 2 2021-07-26 00:03:06 2025-03-23 23:48:24 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 131604 42236 29205 2706 2021-07-26 00:03:06 2025-06-08 23:48:46 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 130264 10243 813 85 2021-07-26 00:03:07 2025-05-25 23:48:40 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 5 31104 8007 2737 210 2021-07-26 08:18:09 2025-06-08 23:48:55 etermin Stadt Dormagen
dresden 3 114299 12818 6110 1249 2021-07-12 00:03:49 2024-12-01 23:48:02 netappoint Stadt Dresden
dresdenkfz 5 113939 107128 61772 16810 2021-07-12 00:04:05 2024-12-01 23:48:02 netappoint Stadt Dresden Kfz-Zulassungsbehörde
duelmen 9 131447 71364 34525 3719 2021-07-26 00:03:22 2025-06-08 23:49:25 etermin Stadt Dülmen
ebersfeldwsw 2 124952 16814 2989 1680 2021-10-04 00:03:14 2025-06-08 23:48:07 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 124528 19154 3426 2976 2021-10-04 00:03:57 2025-06-08 23:49:12 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 124187 42320 27078 10494 2021-10-04 00:03:47 2025-06-05 22:05: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 112723 24705 3601 28 2021-07-26 00:03:23 2025-06-05 14:49:40 etermin Stadtwerke Geldern Netz
gelsenkirchen 1 124465 20659 10214 3443 2021-10-04 00:03:58 2025-06-08 23:49:09 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 38 129467 917299 279545 41495 2021-07-26 00:03:48 2025-06-08 23:50:53 etermin Stadt Graz
grazamt 5 131288 106150 52885 10584 2021-07-26 00:03:53 2025-06-08 23:51:00 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 131464 16465 11328 760 2021-07-26 00:03:54 2025-06-08 23:51:05 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 124949 39175 12110 3814 2021-10-04 00:03:54 2025-06-08 23:50:16 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 123188 31102 22891 3967 2021-10-04 00:03:42 2025-06-08 23:49:22 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 125692 2014 485 49 2021-07-26 00:03:57 2025-06-08 23:51:06 etermin Psychologische Studierendenberatung Innsbruck
itzehoe 3 122085 25774 15118 1615 2021-07-26 15:19:04 2025-06-08 23:51:07 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 132050 0 0 0 2021-07-12 00:04:24 2025-06-08 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 124793 106138 46958 43145 2021-10-04 00:04:00 2025-06-08 23:49:13 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 5 119574 84742 33614 6993 2021-10-04 00:04:01 2025-06-08 23:50:20 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 124946 28893 9608 5024 2021-10-04 00:04:00 2025-06-08 23:49:14 tempus Landkreis Kronach Zulassungsbehörde
krunnakfz 4 124701 110782 64515 36918 2021-10-04 00:04:23 2025-06-08 20:35:20 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 103444 70452 31790 5796 2021-10-04 00:04:11 2024-10-27 23:49:30 tempus Stadt Ladenburg
lauenburgkfz 1 124953 33624 18740 9733 2021-10-04 00:04:24 2025-06-08 23:50:22 tempus Kreis Lauenburg Fachdienst Straßenverkehr
lehrte 7 131353 109204 80134 6920 2021-07-26 00:04:06 2025-06-08 23:51:38 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 2 410 109 0 0 2021-10-04 00:08:31 2025-04-02 08:22:01 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 124949 1051 20 0 2021-10-04 00:04:13 2025-06-08 23:49:16 tempus Stadt Ludwigshafen Ausländerbehörde
luedenscheid 7 124864 177701 120293 26501 2021-10-04 00:04:26 2025-06-08 23:50:29 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 12 99417 174250 28173 5118 2021-10-04 00:04:33 2025-06-08 23:50:53 tempus Stadtwerke Mannheim
mannheimsa 6 124952 22659 12096 2107 2021-10-04 00:04:36 2025-06-08 23:49:26 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 131536 22357 7773 309 2021-07-26 00:04:06 2025-06-08 23:51:39 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 124946 126172 71735 30505 2021-10-04 00:05:02 2025-06-08 23:49:31 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 1 79102 5389 3301 242 2021-07-26 11:04:16 2025-06-08 23:51:43 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 124946 125962 1378 0 2021-10-04 00:04:39 2025-06-08 23:50:59 tempus Landkreis Oldenburg
olfen 1 131552 20453 11894 944 2021-07-26 00:04:18 2025-06-08 23:51:46 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 113878 153771 98588 40352 2021-10-04 00:05:14 2025-03-30 23:49:36 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 124952 190481 80479 32337 2021-10-04 00:05:03 2025-06-08 23:49:35 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 98257 163175 89784 42109 2021-10-04 00:04:49 2024-10-27 23:51:28 tempus Stadt Rösrath
rottenburg 23 124948 261466 177534 55909 2021-10-04 00:05:23 2025-06-08 23:50:05 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 78173 4833 791 65 2023-03-16 13:59:35 2025-06-08 23:51: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 124950 50568 32316 8498 2021-10-04 00:05:27 2025-06-08 23:49:38 tempus Stadt Schriesheim
schwaebischhall 4 119186 111194 59284 14569 2021-10-04 10:20:07 2025-04-20 23:51:07 tempus Stadt Schwäbisch Hall
schwaebischhallkfz 15 107474 465352 242243 123703 2021-10-04 00:05:43 2024-12-08 23:50:24 tempus Landkreis Schwäbisch Hall Zulassungsstelle
schwieberdingen 8 124476 126818 57133 19279 2021-10-04 00:05:36 2025-06-08 23:49:45 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 114842 2959 262 284 2021-07-26 00:04:20 2025-01-05 23:51:26 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 59257 2317 1291 321 2021-10-05 00:04:53 2025-06-08 23:51:00 tempus Stadt Teltow
teublitztest 1 131391 21658 5707 1272 2021-07-26 00:04:21 2025-06-08 23:52:59 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 124733 77086 11581 813 2021-10-04 00:10:26 2025-06-08 23:53:11 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 124870 169771 101200 37143 2021-10-04 00:05:40 2025-06-08 23:49:54 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 3 124948 54258 22161 14142 2021-10-04 00:05:58 2025-06-08 23:50:07 tempus Kreis Werra-Meißner
wiehl 1 124968 5835 3126 288 2021-07-27 09:34:23 2025-06-08 23:53:13 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 113694 407039 158342 124812 2021-10-04 00:05:55 2025-06-08 17:34:59 tempus Stadt Wuppertal Einwohnermeldeamt
wuppertalgeo 5 124757 42035 1544 748 2021-10-04 00:03:11 2025-06-08 23:48:12 netappoint Stadt Wuppertal Geodatenzentrum
wuppertalgw 3 124773 79250 35009 10365 2021-10-04 00:03:08 2025-06-08 23:48:07 netappoint Stadt Wuppertal Gewerbecenter
wuppertalsv 3 123293 122024 48572 48042 2021-10-04 00:04:59 2025-06-08 23:51:01 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.

About

historic data of free office appointment dates

Topics

Resources

Stars

Watchers

Forks