Discussions
Empty compressed files with Advan
I am working with the Advan cell phone location data. When downloading the data, some of the compressed CSVs are empty (only contain 74 bytes):
Neighborhood_Patterns_US-0-DATE_RANGE_START-2022-12-01.csv.gz
Neighborhood_Patterns_US-1-DATE_RANGE_START-2022-12-01.csv.gz
Neighborhood_Patterns_US-13-DATE_RANGE_START-2018-02-01.csv.gz
Neighborhood_Patterns_US-14-DATE_RANGE_START-2018-02-01.csv.gz
Neighborhood_Patterns_US-177-DATE_RANGE_START-2019-08-01.csv.gz
Neighborhood_Patterns_US-188-DATE_RANGE_START-2019-09-01.csv.gz
Neighborhood_Patterns_US-197-DATE_RANGE_START-2019-10-01.csv.gz
Neighborhood_Patterns_US-198-DATE_RANGE_START-2019-10-01.csv.gz
Neighborhood_Patterns_US-199-DATE_RANGE_START-2019-10-01.csv.gz
Neighborhood_Patterns_US-208-DATE_RANGE_START-2019-11-01.csv.gz
Neighborhood_Patterns_US-265-DATE_RANGE_START-2020-07-01.csv.gz
Neighborhood_Patterns_US-266-DATE_RANGE_START-2020-07-01.csv.gz
Neighborhood_Patterns_US-380-DATE_RANGE_START-2021-11-01.csv.gz
Neighborhood_Patterns_US-382-DATE_RANGE_START-2021-12-01.csv.gz
Neighborhood_Patterns_US-383-DATE_RANGE_START-2021-12-01.csv.gz
Neighborhood_Patterns_US-50-DATE_RANGE_START-2023-06-01.csv.gz
Neighborhood_Patterns_US-56-DATE_RANGE_START-2023-06-01.csv.gz
Neighborhood_Patterns_US-93-DATE_RANGE_START-2023-10-01.csv.gz
Link SafeGraph Brand STOCK_SYMBOL to public company ticker
As the guidance (https://github.com/Dewey-Data/SafeGraph-PublicCompanies) claims, neither SafeGraph nor Compustat provide historical ticker information (i.e. the ticker identified by each data source is the ticker as of a particular point in time.), then is there any method that we can use to lower down the mismatch rate when linking SafeGraph with Compustat? Is "Stock Symbol" the only identifier available? Thank you.
Linking Consumer Address History to Total Consumer Insights - Consumer Profiles [Verisk]
Hi Dewey Team,
Clarification on Cases Where ODATE is Earlier Than the Most Recent EFFDATE
Hi Dewey Team,
Placekey lat/long changing across time? (Advan)
Why does the location of some placekeys change over time? For example, the placekey "224-222@5zb-wwd-4qf" changes coordinates 4 times (and changes states 3 times) between 2019 - 2024.