COVID-19 Federal Pharmacy Partners Long Term Care Facility Vaccine Clinics Current Health

The long-term care facility clinic data shows the facilities that have clinics scheduled for a certain week. These clinics will be held by either CVS or Walgreens through their work to vaccinate within the Federal Pharmacy Partnership.

The federal pharmacy partners dataset represents the clinics that CVS and Walgreens are holding for a given week at long-term care facilities that are part of the federal pharmacy mission. These are nursing homes, assisted living facilities, and other long-term care facilities receiving vaccinations. <br>

For the Pfizer vaccination the clinics are 3-weeks apart.

For the Moderna vaccination the clinics are 4-weeks apart.<br>

This dataset will be updated Wednesday’s at 12:00pm.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"pa-gov/covid19-federal-pharmacy-partners-long-term-care-iwiy-rwzp\".\"covid19_federal_pharmacy_partners_long_term_care\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.