ETL: Home panel summary for weekly patterns

[SPTKL]

File path:

• new: sg/sg-c19-response/weekly-patterns-delivery/weekly/home_panel_summary
• old: sg/sg-c19-response/weekly-patterns/v2/home_panel_summary

Things to consider:

• should we just save these files in the output/poi/ folder directly as a resource that people can use?
  • stable schema
  • small table size, not that hard to concatenate with python
  • would just need to write a sample notebook
    • load data
    • select tables to load by date range
• or should we store it as a table in Athena?
  • more work
  • not sure if we would be able to join this table to anything (more of a methodology issue)

[SPTKL]

output location: @SteveScott output/home_panel_summary/weekly_nyc_borough_summary/weekly_nyc_borough_summary.csv.zip output/home_panel_summary/weekly_nyc_summary/weekly_nyc_summary.csv.zip