Forum Discussion
Process to get covid data
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
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