Cases.csv parsing errors

[kennyklee]

https://github.com/jakobzhao/virus/blob/master/assets/cases.csv

Hello, starting record # 1004, there are double quotes that cause errors.

[lolakang]

Hello Kenny,
Thank you for your concern and support for our map. When I went to check the problem in cases.csv, there were no double quotes from my side. If it still shows the errors from your side, please let me know.

[chrismevans16]

Hello, I am having the same issue with a parsing error starting at record 1004. Here is the text from that line copied directly:
1004,"NO.2532","2020/3/14","James City","VA",-76.773353,37.313274,"Virginia reported its first death due to the coronavirus on Saturday. The patient was a man in his 70s who contracted the virus from an unknown source","according to a press release from the Virginia Department of Health. The man’s cause of death was respiratory failure. The man was one of eight patients diagnosed so far in James City County. [Death]""

I think the issue is there is no comma following the note to indicate the start of the reference column.

[chrismevans16]

More specifically, after downloading the csv, there are errors in parsing found in various records from 1005-1326.

[lolakang]

Hello, I am having the same issue with a parsing error starting at record 1004. Here is the text from that line copied directly:
1004,"NO.2532","2020/3/14","James City","VA",-76.773353,37.313274,"Virginia reported its first death due to the coronavirus on Saturday. The patient was a man in his 70s who contracted the virus from an unknown source","according to a press release from the Virginia Department of Health. The man’s cause of death was respiratory failure. The man was one of eight patients diagnosed so far in James City County. [Death]""

I think the issue is there is no comma following the note to indicate the start of the reference column.

Thank you, Chris! Today I uploaded a new version of the .xlsx and .csv for all of the cases and fix some errors there. Hopefully, it also covered the problem that you pointed out. Please let me know if it works for you.

[lolakang]

Hello, I am having the same issue with a parsing error starting at record 1004. Here is the text from that line copied directly:
1004,"NO.2532","2020/3/14","James City","VA",-76.773353,37.313274,"Virginia reported its first death due to the coronavirus on Saturday. The patient was a man in his 70s who contracted the virus from an unknown source","according to a press release from the Virginia Department of Health. The man’s cause of death was respiratory failure. The man was one of eight patients diagnosed so far in James City County. [Death]""
I think the issue is there is no comma following the note to indicate the start of the reference column.

Thank you, Chris! Today I uploaded a new version of the .xlsx and .csv for all of the cases and fix some errors there. Hopefully, it also covered the problem that you pointed out. Please let me know if it works for you.

I have just seen it with my friend's PC, it looks good now! Thank you for your support!