Which tables contain the number of devices and the total population?

Questions & Help
1

Which tables contain the number of devices and the total population? Population from census, no. devices from… I need to convert visitation counts to actual traffic numbers.

2

@Steve_Scott_City_of_New_York_Mayor_s_Office_of_Operations

I think you want the Panel Overview Data
schema

for April monthly patterns, that is located here:
<s3://sg-c19-response/monthly-patterns/home_panel_summary_backfill/2020/05/07/12/2020/04/>

for weekly patterns that is located here:
<s3://sg-c19-response/weekly-patterns/v2/home-summary-file/>

3

But we also have normalization_stats file
schema:

which provides a little more detail about the panel day by day.

4

Thank you Ryan! I will look at it