This has been heavily affecting at least Colorado users the past several days causing lots of frustration.

Basically the issue is that Walgreens' data will claim to have availability for a specific store. Even if you specifically select that you need "First & Second Dose" it will let you proceed with booking at locations that have appointments in the next several days. However, once you get the step to book the second dose, Walgreens will inform you that there is no availability and therefore you can't book anything.

Many CO users have reported that they've called the pharmacies and the pharmacies have said they are not currently doing any first & second doses in CO, only second doses. However, I know I've heard from some users that have still had success in booking first and second doses at Walgreens (however rare), while I've added warnings, I've been hesitant to yank the data entirely.

So while I sort of consider this an issue on Walgreen's end with providing misleading information on the initial requests until you get further into the process, this is something I'd like to address to prevent more frustration on the part of users. After digging into this, in order to fix this, we need to check for future booking dates to simulate what the Walgreens does when you go to book the 2nd dose. The logic Walgreens seems to use for looking for 2nd dose appointments is:

• Look for appointments starting 28 days ahead of the 1st dose time. This seems to happen regardless of vaccine time (Moderna of Pfizer).
• Each appointment slot API request fetches 3 days in the future of the first date, so there has to be some time slot bookable within that 28 + 3 day window from the original appointment date.

We should then only consider the 1st appointments valid if there's a 2nd dose appointment open in the future according to these rules.

Your WA state list is missing one location.

https://pharmaca.as.me/queenanne

https://www.gooddaypharmacy.com/services/covid-19-vaccination-at-good-day-pharmacy

With the Pharmaca scanning, we're parsing the initial date range that gets returned by default. This seems to maybe be the next month-ish of appointments. But there's a link we could follow to also scan the "next" date range (it's not exactly month based). You can keep clicking "next" seemingly indefinitely, though. But maybe we should at least scan the next 1-2 date ranges to see if any other appointments are further out (right now, nothing seems to be scheduled that far out, so this is more of a hypothetical right now).

Around 4:30 today, the Albertsons scanning broke. As far as I can tell you now need to fill out the captcha before making any requests. They had added a captcha last week (I think), but the endpoints actually didn’t seem protected until today.

So far in trying to get this working again, I have code that can fill out the captcha (using a paid captcha service) in a headless browser, but the authenticated session is then only good for ~25 requests before the captcha is required again. So this could be rather slow and costly to support. I can push the captcha code up anyone’s interested, but I’m going to have to call it a night for today. I’ll see if I can figure anything out or find anyone at Albertsons to reach out to.

https://www.publix.com/covid-vaccine

Could start out by adding something like Google Translate to the page, but if there's demand and interest, I'd certainly be open to properly localizing the tool for other languages.

The current usage of Cosmos DB was sort of an early experiment while I was trying to figure out what cloud offerings could best host everything for free. But with the tasks running in AWS Lambda and the database over in Azure, this is all a bit funky and could use some cleanup.

And nothing necessarily against Cosmos DB, but I'd personally be more productive in PostgreSQL, so now that this tool seems like it's useful and I'd like to do more things in the database, I'd be fine paying a bit for a PostgreSQL service where I'd be more comfortable/productive. And hopefully this would also make everything easier to setup and run for others (so there wouldn't be the odd dependencies split between cloud services).

https://www.costco.com/covid-vaccine.html

https://clearspringrx.com/schedule-cherry-creek.php
https://clearspringrx.com/schedule-littleton.php

I'd like to contribute if I can, but I can't find instructions on how to build/run this locally so I can test my changes. Any help would be appreciated.

This doesn't seem to affect all Rite Aids, but it at least seems to affect several different ones I've checked in Maryland.

• We currently hit the checkSlots API endpoint which returns a boolean for whether or not appointments are available. This seems to be what Rite Aid's site uses to determine whether or not to take the user to the calendar page.

• For several of these locations I've checked, this checkSlots API returns true, indicating appointments should be available. However, if you navigate to Rite Aid's site and try to book an appointment at this location, you run into errors. You are let past the first page after selecting the location, which hits the checkSlots API, but when you land on the calendar page, I just get a spinner that spins forever, along with JavaScript errors being thrown in the console:

  

  In this case checkSlots returns:

  {
    "Data": {
      "slots": {
        "1": true,
          "2": false
      }
    },
    "Status": "SUCCESS",
    "ErrCde": null,
    "ErrMsg": null,
    "ErrMsgDtl": null
  }

  But when on the calendar page, an additional request is made to en.ragetavailableappointmentslots.json, which returns this for these problematic locations:

  {
    "Data": {
      "slots": {
        "1": [],
        "2": []
      }
    },
    "Status": "SUCCESS",
    "ErrCde": null,
    "ErrMsg": null,
    "ErrMsgDtl": null
  }

• When locations are bookable on Rite Aid, this second en.ragetavailableappointmentslots.json API response returns something with data in the slots, like:

  {
    "Data": {
      "slots": {
        "1": [
          "2021-03-09T13:45:00",
          "2021-03-09T14:36:00",
          "2021-03-09T14:39:00",
          "2021-03-09T14:45:00",
          ...
        ],
        "2": []
      }
    },
    "Status": "SUCCESS",
    "ErrCde": null,
    "ErrMsg": null,
    "ErrMsgDtl": null
  }

• Ideally we could hit this en.ragetavailableappointmentslots.json API endpoint to get the seemingly more accurate information as well as getting slot times, but unfortunately this API endpoint is protected by recaptcaha, so this is much more difficult/slower to hit.

• This doesn't affect all locations, so some locations that return true in checkSlots are indeed bookable it would seem. I'm unsure of how many locations this affects, so I'm hesitant to yank any of the data.

So while this seems like maybe more of an issue on Rite Aid's side with a mismatch between checkSlots and en.ragetavailableappointmentslots.json (that even their web app fails to handle gracefully), I just wanted to compile the notes I had so far on this. I'm not really sure there's much that can be done about this without being able to access en.ragetavailableappointmentslots.json (which probably isn't feasible due to recaptcha). In the meantime, hopefully Rite Aid can fix things on their end.

Add documentation on how to run all this and do things like add new scanning services.

Not exactly sure where data will pop up. Possibly on this page, but I've yet to see any appointments pop up, so not really sure: https://covidinfo.reportsonline.com/covidinfo/GiantEagle.html

I've had a number of requests from people looking for this type of service in other states. The code is all open source (albeit in need of cleanup and documentation), so theoretically others could run this stack for other states. However, if we can get things running smoothly in Colorado first and then if there hasn't been any activity from other people running similar things in other states, this is something I could maybe explore. While there's obviously some regional and local chains that will differ in other states, just having CVS, Walgreens, Walmart, Albertsons (and all its sub-brands), and Kroger (and all its sub-brands) could cover a lot of pharmacies in a lot of states right out of the gate. This would obviously be a lot more scraping (which I'm trying to do in a courteous way), so I'd need to think about how to best distribute the scraping (so stuff still gets updated frequently, but still throttling things to try and be courteous).

After the latest updates, the time zone handling appears sporadically broken. I had previously been using time-elements to handle rendering a static time on the page, but having it update to the client's time zone. However, with the switch to Nuxt/Vue for the website, it seems like this doesn't always behave as expected. I suspect this might be fighting with Nuxt or Vue's own template rendering and refreshing. It sometimes works, but after refreshes, I can usually get some of the times on the page to end up being in EST instead of MST.

Currently we just get back whether or not each Walgreens has any appointments in the next several days. But people have found that even if there are appointments available, Walgreens won't let you schedule the appointment unless you can also schedule the second appointment at the same time. But often there are no appointment slots at the right point in the future, so this can still be frustrating. Ideally we'd be able to determine whether just single appointments are available (for the second dose) or whether first and second appointments are available.

From what I recall, the second dose scheduling just looked forward a month in the calendar to see if there were any slots there. It's possible we could do something similar with our lookups, I'd just want to try and verify the logic Walgreens performs for the second doses to see if it's always 4 weeks (or whatever the date range is), or if it varies by vaccine type, etc.

While we're actively refreshing all Walmart locations for vaccine appointments, there's another piece of how Walmart works: each store's metadata (that's not part of the appointment details) declares whether or not each store can possibly carry the vaccine. So in order to catch appointments of new stores that start carrying the vaccine, we need to also refresh this store metadata on some type of regular basis.

I've heard from some users wanting to be able to filter based on pharmacy chain, particularly with the new interface updates.

I think this mostly comes from frustration with some pharmacy chains that seem to have more current issues (eg, Walgreens in Colorado right now), but these issues don't seem to affect everyone, so I'm also not sure how prevalent this need is. I hadn't wanted to clutter up the UI too much, but it is something that we could perhaps consider (I think ideally you'd be able to select multiple pharmacy chains to view, so you could just deselect the ones you didn't want to view). The only corner case that comes to mind is that if you're refreshing this type of page with a filtered pharmacy view and I add a new pharmacy chain, you may miss out on the new ones.

With the addition of ZIP code search, I've heard from one user that I think was rightfully confused that they couldn't search for zip codes in other states and get any results. I think in the error message when a ZIP code isn't found in your state, we could provide better guidance on this and maybe point towards the other states.

This could also perhaps be made better by improving the overall navigation so it's more obvious how to switch between states: #52

There's maybe a broader issue here of whether or not the state-centric search makes sense, but I'm sort of in favor of keeping it that way for the purposes of this tool. I'm doing a sort of dumb client-side ZIP code lookup so I don't have to pay for geocoding services, and while loading an entire state's worth of zip codes is semi-okay (still a bit big), loading the entire US would probably be too much. And given the state-centric nature of vaccinations, I think this state-based approach mostly makes sense, it's maybe just less convenient if you're helping friends in other states and needing to swap between states.

I've heard from several users that the current map colors aren't great for red/green color blindness (which I know should have been obvious given the colors I picked :). I tried to mitigate this slightly by making the green ones bigger, but this could all use some better distinction and coloring to try and better deal with this (maybe just better colors, or also maybe consider different pin shapes).

New Feature request: Add the ability to search for Rapid Covid tests appointments (for example from Walgreens)

In case you want more to add, Cosentino's is a family of stores in Kansas City.

I've implemented it in python in my project: https://github.com/pcarn/vaccine-watch/blob/main/clinics/cosentinos.py

https://www.lewisdrug.com/stores

Each store has its own scheduling page, for example https://www.lewisdrug.com/stores/lewis-family-drug-aberdeen is scheduled on https://lewisdrugc19.as.me/schedule.php?calendarID=4948207.

This is increasingly a request I'm hearing from users. The current approach of dumping all the information in the state into one page obviously isn't too user friendly, particularly in states with lots of locations.

I've started work addressing this and hope to have some improvements on this front soon.

The code is a messy mess right now. I'd at least like to add some basic linting and standardize the formatting.

In case you want more to add, Ball's is a family of stores in Kansas City.

I've implemented it in python in my project: https://github.com/pcarn/vaccine-watch/blob/main/clinics/balls.py

It's pretty gross, having to scrape the page for data, but it's working.

This is difficult due to their anti-bot technology. I sort of have something working for CO, but it's finicky. It might be possible to scale this to other states, though.

This would be a great one. Not the biggest chain, but rather critical in Iowa right now, where things are a mess:

https://www.medicap.com

Also, I'm not sure if they are scraping or found another source, but this site does have Medicap data, FYI:

https://www.brady-software.com/vaccine-hunter

It had been finicky (with anti bot confirmations and captchas), but now it seems more fully broken.

If you land on a state-specific page, it may not be obvious that the site has data for other states. Technically you can click on the header in the navbar (eg, "Colorado COVID-19 Vaccine Spotter"), and you'll land back on the home page, but this is not obvious (or perhaps even the correct action for that title) at all.

Having some better type of global navigation might be useful. Or alternatively, maybe just some state drop down in the nabber to switch between states (although on mobile, this would probably need to be collapsed in a menu due to space).

Now show up as null and clicking the link does not direct to HyVee's website

Currently I'm just hitting /pharmacy/v2/clinical-services/time-slots/{cid} for a specific store. However, it looks like we need to first hit /pharmacy/v2/clinical-services/inventory/store/{store_id}/{cid} to check for inventory first. I think this might be a new step, since I don't remember this inventory step from before (but it's also possible I just missed this ☹️). But this definitely seems to be required now, since otherwise there are stores that do return appointment slots despite having no inventory (in which case the Walmart site doesn't actually ever let you get as far as checking for slots). Oof. :( Hopefully this doesn't affect too many stores, since I hate giving false positives.

This is a smaller regional pharmacy, but they are in a number of other states. As part of this, also need to move this data into The PostgreSQL format to better standardize things.

https://stopandshopsched.rxtouch.com/rbssched/program/covid19/Patient/Advisory

Also need to move it into the new Postgres structure. I think that will also allow for more intelligent scanning with PostGIS to reduce the number of requests due to the number or stores Walgreens has.

The website is currently hosted via GitHub pages. But pushing to the gh-pages branch every minute may not be a particularly viable long-term solution given the number of commits and frequency of pushes (there's also a lot of churn in the files, since all the JSON changes are recorded every minute). I've read about GitHub Pages build limits per day, although I'm not sure that affects us, since we're not actually building the site with GitHub pages (with Jekyll), just pushing an already built site to the branch. I received a couple GitHub Page build failure notifications last night, which is maybe related to all this. In any case, I guess it seems like just pushing to an S3 bucket might be a better plan so we don't abuse GitHub Pages.

I've had requests to track Meijer, but I'm not sure that's possible, since they seem to operate with a registration process (so I'm not sure there's really appointments to scan): https://clinic.meijer.com I'm not sure if it's worth linking to other pharmacies like this that can't be scanned, just so people know what to do (although then that opens up a can of worms in linking to other possible places to get vaccines, which is something I've hoped to defer to official state resources). But anyway, just something to think about.

This is tricky to do, since I'm not sure we have the data necessary to do this right now, but just noting a request I've heard. But if we can reliably normalize the data from pharmacy providers, I know some people are only looking for 1st or 2nd shots and then some people are looking for types of vaccines (eg, Moderna, Pfizer, J&J).

Right now I've started to keep track of the appointment "type" which does include some of this information, but this is usually just based on text we get back from the pharmacy, so it's not standardized across different pharmacies. And we also don't have this information for all chains (some we just have appointment times, and other we don't have any details).

CVS appears to actually have a COVID-19 Vaccine Availability API: https://developer.cvshealth.com/apis 👏 I've applied for a developer account, but haven't been approved yet.

I'm hoping this API could provide better details about the appointments available. Based on the endpoint we're scraping, we just know whether or not any appointments are available, but not details about the appointments. So this doesn't distinguish between first/second dose availability and doesn't tell us how many appointments are available. I'm hoping the API might provide more details.

Example:

{
    "type": "Feature",
    "geometry": {
        "type": "Point",
        "coordinates": [
            -96.8306729,
            33.0430426
        ]
    },
    "properties": {
        "id": 1048028,
        "url": "https://www.albertsons.com/pharmacy/covid-19.html",
        "city": "Plano",
        "name": "Tom thumb 2570",
        "state": "TX",
        "address": "5968 West Parker Rd.",
        "provider": "albertsons",
        "time_zone": "America/Chicago",
        "postal_code": "75093",
        "appointments": null,
        "provider_brand": "tom_thumb",
        "carries_vaccine": true,
        "provider_brand_name": "Tom Thumb",
        "provider_location_id": "1600122449411",
        "appointments_available": null,
        "appointments_last_fetched": "2021-02-24T23:30:38.249+00:00"
    }
}

But checking through the provided URL shows no appointments available.

This is usually just the norm for Open-Source projects like this one (though it might not be necessary with the inclusion of a separate LICENSE.txt).

Hi! I'm one of the maintainers of VaccinatePA, a site that crowd-sources PA vaccine availability. Recently we added VaccineSpotter's to our site and have received glowing feedback for the Realtime Availability.

We recently were introduced to VaccCheck [0], which is similar to what VaccineSpotter does but for the large Northeast chains Wegmans and Weis Markets. However, the way VaccCheck works doesn't fit in our workflow (it requires the program to be run on a local machine).

Do you think it could be possible to integrate what they're currently doing into VaccineSpotter?

[0] https://github.com/dinsmoro/VaccCheck

As a Vaccine Hunter, I want the system to display the days of the week and the times that appointments are typically newly found, so that I can target my vaccine hunting time to those days and times and more likely find an open spot for that location. (maybe right under each location a small message like “ appointments over the last week were typically published on: Monday at 6 PM, Tuesday at midnight, Thursday at 4 AM) (FYI I haven’t programmed in 10 years but I’m an agile coach now, so I can’t help with the programming unfortunately!). Keep up the good work!

Hello all-- I'm on the MN map, and typing in zip code and hitting search does not change anything on the page. On a whim, I tried a random (but real) Zip Code on the WI page as well, and the search did not update as well. I am in Chrome and Safari as well. The MN page was allowing me to search up to an hour ago. Data is still updating.

Requires login account: https://www.samsclub.com/pharmacy/immunization/form?imzType=covid

https://www.winndixie.com/pharmacy/covid-vaccine

When you click on the schedule appointment option, it takes you to a chat bot located on this site:

https://c.ateb.com/c20605cb988e4a18a3eab5f7fd466cf6/?submit=Schedule+my+appointment

Once there, you can schedule a COVID 19 appointment in FL and it provides a list of locations with potential COVID-19 appointments.

Letting people signup for notifications (either e-mail or text) would obviously be even better than making people refresh the page. Already in progress in #1.