Skip to content

COVID 19 impact project #110

Open
Open
COVID 19 impact project#110
Labels
In ProgressTo Update !No update has been providedcomplexity: missingepicfeature: guideAll issues related to guidemilestone: missingproject duration: one timeproject: 311 Dataready for productrole: data analysissize: epicsize: missing

Description

@ryanmswan
ryanmswan
opened on Apr 8, 2020

Dependency

Access to clean 311 data from 311-data-org team
Project one sheet (can continue issue w/o completion of one sheet template)

Overview

Investigate methods for mapping COVID-19 data for LA County to the 311-data tool and assess additional data that can be mapped using the 311-data tool

Action Items

  • Find available data sources and add to Resources section below
  • Determine is this is one-time or ongoing project (and assign appropriate label)
  • Write one-sheet
    • Define stakeholder (Access the data and 311 teams used for educational puposes)
    • Summarize project including value add
    • Define project 6 month roadmap
    • Detail history (if any)
  • Define tools to be used to visualize combined data
  • Create issues for the following
    • EDA Tasks
      • Combine data from years into one data set and see differences
      • Data Dictionary
      • Data Cleaning
    • Identify data sets with COVID-19 data linked to location or GPS coordinates
    • Assess statistically significant changes in 311-reports by area due to quarantine actions
    • Assess differential impact on communities related to request type and request volume
    • Generate web document/Jupyter notebook report
    • Assess with frontend/backend feasibility and value of adding visualizations to main tool

Resources

http://publichealth.lacounty.gov/media/Coronavirus/locations.htm
https://occovid19.ochealthinfo.com/coronavirus-in-oc
https://csungis.maps.arcgis.com/apps/webappviewer/index.html
https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data/csse_covid_19_time_series
https://covidtracking.com/data
https://data.lacity.org/browse?q=covid&sortBy=relevance
https://geohub.lacity.org/search?q=covid%2019
https://huggingface.co/311-data

Data needed from 311 project

all data from three years before covid shutdown and all data during
will not need an ongoing pipeline but probably we be revised to update it the shutdowns ever end.
We have got Data during Covid lockdowns from March 2020 till June 2021 but we don't have the data from prior to lockdown.

Activity

  1. ryanmswan
    assigned
    nikpap123
    on Apr 29, 2020
  2. nikpap123
    removed their assignment
    on May 8, 2020
  3. ryanmswan
    assigned
    andy-vh
    on Jul 8, 2020
  4. ExperimentsInHonesty
    unassigned
    andy-vh
    on Sep 17, 2021

  5. ExperimentsInHonesty commented on Sep 18, 2021

    @ExperimentsInHonesty
    ExperimentsInHonesty
    on Sep 18, 2021
    Member

    Identify

    • what the value to doing this is
    • if there is already a resource
    • the reliability of the data sources
  6. ExperimentsInHonesty
    transferred this issue fromhackforla/311-dataon Sep 18, 2021
  7. akhaleghi
    added
    epic
    project duration: unknown
    size: epic
    on Oct 1, 2021
  8. akhaleghi
    added
    project: 311 Data
    role: missing
    feature: guideAll issues related to guide
    feature: missingthis tags is mutually exclusive with project: missing. Please use the correct label
    and removed
    feature: missingthis tags is mutually exclusive with project: missing. Please use the correct label
    role: missing
    on Nov 2, 2021

  9. 42 remaining items

  10. akhaleghi
    added
    role: data analysis
    and removed
    role: product
    on May 19, 2025

  11. ExperimentsInHonesty commented on Jun 15, 2025

    @ExperimentsInHonesty
    ExperimentsInHonesty
    on Jun 15, 2025
    Member

    @jefryk18 Please provide update by 9am PST Monday, June 16th. So that I can review and respond if you are having any blockers or need anything else. I won't be able to attend the Data Science Community of Practice this Monday because I have onboarding, but I will be there on the 29th.

    Instructions
    1. Progress: "What is the current status of your project? What have you completed and what is left to do?"
    2. Blockers: "Difficulties or errors encountered."
    3. Availability: "How much time will you have this week to work on this issue?"
    4. ETA: "When do you expect this issue to be completed?"
    5. Pictures (if necessary): "Add any pictures that will help illustrate what you are working on."

    You can use this template

    1. Progress: 
2. Blockers: 
3. Availability:
4. ETA:
5. Pictures (if necessary):
  12. ExperimentsInHonesty
    added
    To Update !No update has been provided
    on Jun 15, 2025

  13. Kphalguni commented on Jun 15, 2025

    @Kphalguni
    Kphalguni
    on Jun 15, 2025
    Member

    Hi @PretheeshS , @SaiPranaswi23 , @VamsiB11 , @darth-franky - All of you have been assigned to this issue along with @jefryk18. Please confirm if you are working on it, or need to be removed from the issue otherwise.

  14. ExperimentsInHonesty
    moved this from In progress (actively working) to New Issue Approval in CoP: Data Science: Project Boardon Jun 24, 2025
  15. ExperimentsInHonesty
    unassigned
    darth-franky
    ,
    VamsiB11
    ,
    PretheeshS
    ,
    SaiPranaswi23
    and
    jefryk18
    on Jun 24, 2025
  16. gauthamisreenivas
    added
    complexity: missing
    milestone: missing
    on Jul 10, 2025
  17. ExperimentsInHonesty
    added
    size: missing
    on Oct 9, 2025

  18. Rabia2219 commented on Nov 14, 2025

    @Rabia2219
    Rabia2219
    on Nov 14, 2025
    Member

    Note

    As part of the OPT audit on behalf of Jefry, these pdfs were provided by him. The have been added to the Data Science drive under the #110 Covid 19 impact project folder.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    In ProgressTo Update !No update has been providedcomplexity: missingepicfeature: guideAll issues related to guidemilestone: missingproject duration: one timeproject: 311 Dataready for productrole: data analysissize: epicsize: missing

    Type

    No type

    Projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions