Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Missing fields latitude and longitude in CSV input files #2

Open
nrouyer opened this issue Oct 7, 2020 · 1 comment
Open

Missing fields latitude and longitude in CSV input files #2

nrouyer opened this issue Oct 7, 2020 · 1 comment

Comments

@nrouyer
Copy link

nrouyer commented Oct 7, 2020 

load csv with headers from "https://raw.githubusercontent.com/jexp/fincen/main/download_bank_connections.csv" as value
WITH value WHERE value.filer_org_lng is not null 
RETURN value LIMIT 10

returns nothing.
Same for filer_org_lat, entity_b_lng, entity_b_lat

Consequence is we don't have latitude and longitude on Entity nodes, which makes it difficult to show them on a map.
@jexp
Copy link
Owner

jexp commented Oct 7, 2020

Yep sorry :( the geodata is missing from the CSV from ICIJ.
So it's only in the JSON.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@jexp @nrouyer