Skip to content

Instantly share code, notes, and snippets.

View jalbertbowden's full-sized avatar

albert jalbertbowden

View GitHub Profile
@jalbertbowden
jalbertbowden / covid-19-virginia-ltcf-data.py
Last active February 9, 2021 01:57
COVID-19 Virginia LTCF Dataops - Python script for cleaning up Virginia LTCF COVID-19 data.
from csv import DictReader, DictWriter
import csv
file_name_base = 'vdh-covid-19-public-use-dataset-outbreaks-in-selected-exposure-settings-'
file_date = '2021-01-29'
file_row_report_date = '01/29/2021'
file_format = '.csv'
file_dataset = '-ltcf'
file_step_1 = '-fixed'
file_step_2 = '-updated'
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jalbertbowden
jalbertbowden / longwood-covid-19.csv
Last active December 16, 2020 18:16
scrape longwood covid data
Active Cases Total Cumulative Cases Total Students Total Faculty Date
@jalbertbowden
jalbertbowden / index.js
Created November 27, 2020 07:36 — forked from bcks/index.js
tableau-covid-scraping
// Works with Node v12.0 and puppeteer 4.0
const URL = 'https://public.tableau.com/views/PPV_15924847800480/ppv_db?%3Aembed=y&%3AshowVizHome=no&%3Adisplay_count=y&%3Adisplay_static_image=n&%3AbootstrapWhenNotified=true&%3Alanguage=en&:embed=y&:showVizHome=n&:apiID=host0';
const puppeteer = require('puppeteer');
function parseDataDictionary(jsonParsed) {
@jalbertbowden
jalbertbowden / nevada-facilities-bi.json
Created November 20, 2020 07:06
Nevada Facilities with Reported COVID-19 Cases Power BI Dashboard CURL export
{
"models": [
{
"id": 274097,
"vsName": "sobe_wowvirtualserver",
"dbName": "10a1e28c-bfcb-4358-bb18-0cb39b08a031",
"currentRefreshStartingTime": "",
"refreshSchedule": {
"importAndRefreshBehavior": 0,
"executionTime": null,
@jalbertbowden
jalbertbowden / get-cms-nursing.py
Created November 14, 2020 22:50
get-cms-nursing.py - automating accessing cms.gov's weekly nursing home dataset and chopping it up into digestable csvs: by state, and by state + date.
import requests
import os
import csv
nursing_home_dataset_csv_url = 'https://data.cms.gov/api/views/s2uc-8wxp/rows.csv?accessType=DOWNLOAD'
nursing_home_dataset_csv_file = 'COVID-19_Nursing_Home_Dataset.csv'
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@jalbertbowden
jalbertbowden / map.geojson
Last active October 17, 2020 07:31
Voter Precincts - Richmond, VA
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.