Discussions
Using DuckDB to download Advan Weekly Patterns
Hello, I was following the instructions of using DuckDB to download foot traffic/ weekly patterns from the Avdan Research. I was able to get the file list and define the date partition range. However, I kept getting the following error message when generating a data preview and querying relevant data for downloading:
Issue Accessing and Filtering LinkUp Job Records Dataset on Dewey Platform
Hi Dewey Team,
Similarweb / Desktop Search Keywords
Hi, I noticed that the dataset "Similarweb / Desktop Search Keywords"
does not have a partition column.
Would it be possible to add a partition column (e.g., DATE) so that we can
use --partition-key-after/before to download specific time ranges?
That would greatly improve usability and bandwidth efficiency.
Advan Weekly Patterns Plus: Sharp drop in evening visits Jan 2023 -- change in how hours are recorded?
I had a few questions about the new Advan Weekly Patterns Plus data.
Daily spending and report timing in Safegraph Spend data
In the Safegraph Spend documentation, it states:
Having trouble believing the listings in Listing Data By REsimplifi
For example, how does a lot at 735 N Dunton Ave, Arlington Heights, IL 60004, which a google search shows publicly listed in 2021 for $1million before being taken off the market, show up in the Dewey data as a 1/24/2024 sale for $111,000,000. This does not seem believable. Another example, 9855 Woods Drive, Skokie, Illinois 60077 shows a sale online of $4.9 million 4 years ago, listed on the dewey data as a sale 12/9/2023 for $6 million. Another property, 1460 Manning Pkwy Powell OH 43065, shows on dewey data with a listing sale on 10/1/2023 for $1.5 million, but on the county auditor site its last transfer / sale was 5/31/2022 for $1.18 million , see the link https://delaware-auditor-ohio.manatron.com/ValueandTransferHistory.aspx?mpropertynumber=319-444-05-041-504&p=31944405041504
Country of Origin
Is there a way to know the country of origin for every "PERSON_ID"? I want to classify PERSON_IDs US born workers and foreign-born workers.