Forum Discussion

3 Replies

  • camargos88's avatar
    camargos88
    Community Champion

    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