HN user

cprk83

1 karma
Posts4
Comments5
View on HN

Hi all, we thought it might be interesting to point our spreadsheet integration tool at some of the COVID-19 data repos on GitHub. So, basically you get all the data from these repos with a single function in Excel/Google Sheets. For example:

    =FLEX("covid-19-cases-jhu", "country_region, province_state, date, confirmed, active", "+Illinois", "limit=500")
Here’s a short overview video that shows it in action: https://www.youtube.com/watch?v=MxeP0wFqcqc

We have integrations for the GitHub repos for Johns Hopkins [1], New York Times [2] and Our World in Data [3].

Everything is (nearly) instantly filterable using Lucene Query Syntax [4].

We'd love to get your feedback; let us know if you have any questions. Thnx!

[1] https://github.com/CSSEGISandData/COVID-19

[2] https://github.com/nytimes/covid-19-data

[3] https://github.com/owid/covid-19-data

[4] https://lucene.apache.org/core/2_9_4/queryparsersyntax.html

Hi all, we thought it might be interesting to point our spreadsheet integration tool at some of the COVID-19 data repos on GitHub. So, basically you get all the data from these repos with a single function in Excel/Google Sheets. For example:

    =FLEX("covid-19-cases-jhu", "country_region, province_state, date, confirmed, active", "+Illinois", "limit=500")
Here’s a short overview video that shows it in action: https://www.youtube.com/watch?v=MxeP0wFqcqc

We have integrations for the GitHub repos for Johns Hopkins [1], New York Times [2] and Our World in Data [3].

Everything is (nearly) instantly filterable using Lucene Query Syntax [4].

We'd love to get your feedback; let us know if you have any questions. Thnx!

[1] https://github.com/CSSEGISandData/COVID-19

[2] https://github.com/nytimes/covid-19-data

[3] https://github.com/owid/covid-19-data

[4] https://lucene.apache.org/core/2_9_4/queryparsersyntax.html

I think it's important to take your time. Learning to code software require patience and perseverance. It's important to experiment on your own and learn where the pitfalls are.

Another problem junior coders have is not knowing what to name things. Coding is just as much about writing code others understand as it is about writing correct code.

Finally, I'd consider self-doubt as one of the big obstacles. Your colleagues may seem so much better simply because they've worked on a large code base longer. This ties into my first point-- if you are patient, you will also learn the code base and become proficient at it.