Process to get covid data

[Anonymous]

How can I get the csv file for USA counties from the below ?

https://github.com/nytimes/covid-19-data/blob/master/us-counties.csv

[camargos88]

Hi @Anonymous ,

You can go on Get Data -> Web > paste the url

OR

Just paste this code on Advanced Editor:

let
Source = Csv.Document(Web.Contents("https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-counties.csv"),[Delimiter=",", Columns=6, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"date", type date}, {"county", type text}, {"state", type text}, {"fips", Int64.Type}, {"cases", Int64.Type}, {"deaths", Int64.Type}})
in
#"Changed Type"

Ricardo

[Anonymous]

@camargos88  When I use option 1, I get below screen

[camargos88 · Accepted solution]

Hi @Anonymous ,

Get this file as an example: Sample PBIX 

Ricardo