johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
646 rows where deaths = 499 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752853 | 2752853 | 2022-12-29 | India | Sikkim | 44319 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-30 04:21:04 | Sikkim, India | |||
1073859 | 1073859 | 2022-12-28 | India | Sikkim | 44319 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-29 04:21:01 | Sikkim, India | |||
327856 | 327856 | 2022-12-27 | India | Sikkim | 44319 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-28 04:21:04 | Sikkim, India | |||
217929 | 217929 | 2022-12-26 | India | Sikkim | 44319 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-27 04:21:07 | Sikkim, India | |||
3222386 | 3222386 | 2022-12-25 | India | Sikkim | 44319 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-26 04:21:06 | Sikkim, India | |||
1018300 | 1018300 | 2022-12-24 | India | Sikkim | 44319 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-25 04:21:04 | Sikkim, India | |||
690323 | 690323 | 2022-12-23 | India | Sikkim | 44319 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-24 04:21:02 | Sikkim, India | |||
2179533 | 2179533 | 2022-12-22 | India | Sikkim | 44318 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-23 04:21:04 | Sikkim, India | |||
451337 | 451337 | 2022-12-21 | India | Sikkim | 44318 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-22 04:20:56 | Sikkim, India | |||
2951336 | 2951336 | 2022-12-20 | India | Sikkim | 44318 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-21 04:21:03 | Sikkim, India | |||
3173738 | 3173738 | 2022-12-19 | India | Sikkim | 44318 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-20 04:21:04 | Sikkim, India | |||
1628255 | 1628255 | 2022-12-18 | India | Sikkim | 44318 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-19 04:21:03 | Sikkim, India | |||
503634 | 503634 | 2022-12-17 | India | Sikkim | 44318 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-18 04:21:03 | Sikkim, India | |||
3324206 | 3324206 | 2022-12-16 | India | Sikkim | 44318 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-17 04:21:04 | Sikkim, India | |||
542718 | 542718 | 2022-12-15 | India | Sikkim | 44318 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-16 04:21:01 | Sikkim, India | |||
348620 | 348620 | 2022-12-14 | Sweden | Norrbotten | 51402 | 499 | 0 | 66.8309 | 20.3992 | 2022-12-15 04:20:58 | Norrbotten, Sweden | |||
348246 | 348246 | 2022-12-14 | India | Sikkim | 44318 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-15 04:20:58 | Sikkim, India | |||
308208 | 308208 | 2022-12-13 | Sweden | Norrbotten | 51402 | 499 | 0 | 66.8309 | 20.3992 | 2022-12-14 04:21:04 | Norrbotten, Sweden | |||
307834 | 307834 | 2022-12-13 | India | Sikkim | 44318 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-14 04:21:04 | Sikkim, India | |||
1149269 | 1149269 | 2022-12-12 | Sweden | Norrbotten | 51402 | 499 | 0 | 66.8309 | 20.3992 | 2022-12-13 04:21:01 | Norrbotten, Sweden | |||
1148895 | 1148895 | 2022-12-12 | India | Sikkim | 44317 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-13 04:21:01 | Sikkim, India | |||
869123 | 869123 | 2022-12-11 | Sweden | Norrbotten | 51402 | 499 | 0 | 66.8309 | 20.3992 | 2022-12-12 04:21:01 | Norrbotten, Sweden | |||
868749 | 868749 | 2022-12-11 | India | Sikkim | 44317 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-12 04:21:01 | Sikkim, India | |||
257653 | 257653 | 2022-12-10 | Sweden | Norrbotten | 51402 | 499 | 0 | 66.8309 | 20.3992 | 2022-12-11 04:20:50 | Norrbotten, Sweden | |||
257279 | 257279 | 2022-12-10 | India | Sikkim | 44317 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-11 04:20:50 | Sikkim, India | |||
3936367 | 3936367 | 2022-12-09 | Sweden | Norrbotten | 51402 | 499 | 0 | 66.8309 | 20.3992 | 2022-12-10 04:21:02 | Norrbotten, Sweden | |||
3935993 | 3935993 | 2022-12-09 | India | Sikkim | 44317 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-10 04:21:02 | Sikkim, India | |||
3377699 | 3377699 | 2022-12-08 | Sweden | Norrbotten | 51402 | 499 | 0 | 66.8309 | 20.3992 | 2022-12-09 04:21:05 | Norrbotten, Sweden | |||
3377325 | 3377325 | 2022-12-08 | India | Sikkim | 44317 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-09 04:21:05 | Sikkim, India | |||
1984596 | 1984596 | 2022-12-07 | India | Sikkim | 44317 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-08 04:21:07 | Sikkim, India | |||
3716668 | 3716668 | 2022-12-06 | US | Ohio | Miami | 39109 | 30415 | 499 | 0 | 40.0543329 | -84.22871271 | 2022-12-07 04:20:58 | Miami, Ohio, US | |
3714119 | 3714119 | 2022-12-06 | India | Sikkim | 44317 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-07 04:20:58 | Sikkim, India | |||
2417373 | 2417373 | 2022-12-05 | US | Ohio | Miami | 39109 | 30415 | 499 | 0 | 40.0543329 | -84.22871271 | 2022-12-06 04:21:03 | Miami, Ohio, US | |
2414824 | 2414824 | 2022-12-05 | India | Sikkim | 44317 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-06 04:21:03 | Sikkim, India | |||
720981 | 720981 | 2022-12-04 | US | Ohio | Miami | 39109 | 30415 | 499 | 0 | 40.0543329 | -84.22871271 | 2022-12-05 04:20:58 | Miami, Ohio, US | |
718432 | 718432 | 2022-12-04 | India | Sikkim | 44317 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-05 04:20:58 | Sikkim, India | |||
2816721 | 2816721 | 2022-12-03 | India | Sikkim | 44317 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-04 04:20:56 | Sikkim, India | |||
833577 | 833577 | 2022-12-02 | India | Sikkim | 44317 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-03 04:21:02 | Sikkim, India | |||
2136107 | 2136107 | 2022-12-01 | India | Sikkim | 44317 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-02 04:21:07 | Sikkim, India | |||
1964523 | 1964523 | 2022-11-30 | India | Sikkim | 44316 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-01 04:21:03 | Sikkim, India | |||
2556537 | 2556537 | 2022-11-29 | India | Sikkim | 44314 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-30 04:21:07 | Sikkim, India | |||
1239611 | 1239611 | 2022-11-28 | India | Sikkim | 44314 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-29 04:21:05 | Sikkim, India | |||
3554095 | 3554095 | 2022-11-27 | US | Ohio | Allen | 39003 | 31880 | 499 | 0 | 40.77285242 | -84.10802343 | 2022-11-28 04:21:02 | Allen, Ohio, US | |
3551599 | 3551599 | 2022-11-27 | India | Sikkim | 44314 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-28 04:21:02 | Sikkim, India | |||
2102575 | 2102575 | 2022-11-26 | US | Ohio | Allen | 39003 | 31880 | 499 | 0 | 40.77285242 | -84.10802343 | 2022-11-27 04:21:05 | Allen, Ohio, US | |
2100079 | 2100079 | 2022-11-26 | India | Sikkim | 44314 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-27 04:21:05 | Sikkim, India | |||
490066 | 490066 | 2022-11-25 | US | Ohio | Allen | 39003 | 31880 | 499 | 0 | 40.77285242 | -84.10802343 | 2022-11-26 04:21:11 | Allen, Ohio, US | |
487570 | 487570 | 2022-11-25 | India | Sikkim | 44313 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-26 04:21:11 | Sikkim, India | |||
3525895 | 3525895 | 2022-11-24 | US | Ohio | Allen | 39003 | 31880 | 499 | 0 | 40.77285242 | -84.10802343 | 2022-11-25 04:21:06 | Allen, Ohio, US | |
3523399 | 3523399 | 2022-11-24 | India | Sikkim | 44312 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-25 04:21:06 | Sikkim, India | |||
3314678 | 3314678 | 2022-11-23 | US | Ohio | Allen | 39003 | 31880 | 499 | 0 | 40.77285242 | -84.10802343 | 2022-11-24 04:21:09 | Allen, Ohio, US | |
3312182 | 3312182 | 2022-11-23 | India | Sikkim | 44311 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-24 04:21:09 | Sikkim, India | |||
1620223 | 1620223 | 2022-11-22 | India | Sikkim | 44311 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-23 04:21:06 | Sikkim, India | |||
3460111 | 3460111 | 2022-11-21 | India | Sikkim | 44311 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-22 04:20:47 | Sikkim, India | |||
1640296 | 1640296 | 2022-11-20 | India | Sikkim | 44311 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-21 04:21:05 | Sikkim, India | |||
2063853 | 2063853 | 2022-11-19 | India | Sikkim | 44311 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-20 04:21:08 | Sikkim, India | |||
1755247 | 1755247 | 2022-11-18 | India | Sikkim | 44310 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-19 04:21:14 | Sikkim, India | |||
3026240 | 3026240 | 2022-11-17 | India | Sikkim | 44310 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-18 04:21:15 | Sikkim, India | |||
2485951 | 2485951 | 2022-11-16 | India | Sikkim | 44307 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-17 04:21:11 | Sikkim, India | |||
294501 | 294501 | 2022-11-15 | US | Ohio | Licking | 39089 | 49890 | 499 | 0 | 40.09136236 | -82.48185785 | 2022-11-16 04:21:09 | Licking, Ohio, US | |
291962 | 291962 | 2022-11-15 | India | Sikkim | 44306 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-16 04:21:09 | Sikkim, India | |||
3599531 | 3599531 | 2022-11-14 | US | Ohio | Licking | 39089 | 49890 | 499 | 0 | 40.09136236 | -82.48185785 | 2022-11-15 04:21:16 | Licking, Ohio, US | |
3596992 | 3596992 | 2022-11-14 | India | Sikkim | 44305 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-15 04:21:16 | Sikkim, India | |||
314389 | 314389 | 2022-11-13 | US | Ohio | Licking | 39089 | 49890 | 499 | 0 | 40.09136236 | -82.48185785 | 2022-11-14 04:21:09 | Licking, Ohio, US | |
311850 | 311850 | 2022-11-13 | India | Sikkim | 44305 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-14 04:21:09 | Sikkim, India | |||
65550 | 65550 | 2022-11-12 | US | Ohio | Licking | 39089 | 49890 | 499 | 0 | 40.09136236 | -82.48185785 | 2022-11-13 04:21:14 | Licking, Ohio, US | |
63011 | 63011 | 2022-11-12 | India | Sikkim | 44304 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-13 04:21:14 | Sikkim, India | |||
2929712 | 2929712 | 2022-11-11 | US | Ohio | Licking | 39089 | 49890 | 499 | 0 | 40.09136236 | -82.48185785 | 2022-11-12 04:20:41 | Licking, Ohio, US | |
2927173 | 2927173 | 2022-11-11 | India | Sikkim | 44304 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-12 04:20:41 | Sikkim, India | |||
2508548 | 2508548 | 2022-11-10 | US | Ohio | Licking | 39089 | 49890 | 499 | 0 | 40.09136236 | -82.48185785 | 2022-11-11 04:21:22 | Licking, Ohio, US | |
2506009 | 2506009 | 2022-11-10 | India | Sikkim | 44302 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-11 04:21:22 | Sikkim, India | |||
2433423 | 2433423 | 2022-11-09 | US | Ohio | Licking | 39089 | 49711 | 499 | 0 | 40.09136236 | -82.48185785 | 2022-11-10 04:21:16 | Licking, Ohio, US | |
2430884 | 2430884 | 2022-11-09 | India | Sikkim | 44300 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-10 04:21:16 | Sikkim, India | |||
482079 | 482079 | 2022-11-08 | US | Ohio | Licking | 39089 | 49711 | 499 | 0 | 40.09136236 | -82.48185785 | 2022-11-09 04:21:22 | Licking, Ohio, US | |
479540 | 479540 | 2022-11-08 | India | Sikkim | 44300 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-09 04:21:22 | Sikkim, India | |||
2441229 | 2441229 | 2022-11-07 | US | Ohio | Licking | 39089 | 49711 | 499 | 0 | 40.09136236 | -82.48185785 | 2022-11-08 04:21:21 | Licking, Ohio, US | |
2438690 | 2438690 | 2022-11-07 | India | Sikkim | 44300 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-08 04:21:21 | Sikkim, India | |||
1052327 | 1052327 | 2022-11-06 | US | Ohio | Licking | 39089 | 49711 | 499 | 0 | 40.09136236 | -82.48185785 | 2022-11-07 04:21:26 | Licking, Ohio, US | |
1049788 | 1049788 | 2022-11-06 | India | Sikkim | 44300 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-07 04:21:26 | Sikkim, India | |||
620351 | 620351 | 2022-11-05 | US | Ohio | Licking | 39089 | 49711 | 499 | 0 | 40.09136236 | -82.48185785 | 2022-11-06 04:21:24 | Licking, Ohio, US | |
617812 | 617812 | 2022-11-05 | India | Sikkim | 44299 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-06 04:21:24 | Sikkim, India | |||
1024855 | 1024855 | 2022-11-04 | US | Ohio | Licking | 39089 | 49711 | 499 | 0 | 40.09136236 | -82.48185785 | 2022-11-05 04:21:52 | Licking, Ohio, US | |
1022316 | 1022316 | 2022-11-04 | India | Sikkim | 44298 | 499 | 0 | 27.571671 | 88.472712 | 2022-11-05 04:21:52 | Sikkim, India | |||
433846 | 433846 | 2022-11-03 | US | Ohio | Licking | 39089 | 49711 | 499 | 0 | 40.09136236 | -82.48185785 | 2022-11-04 04:22:11 | Licking, Ohio, US | |
3287358 | 3287358 | 2022-10-31 | US | Ohio | Columbiana | 39029 | 28107 | 499 | 0 | 40.76932373 | -80.78094576 | 2022-11-01 04:22:36 | Columbiana, Ohio, US | |
322391 | 322391 | 2022-10-30 | US | Ohio | Columbiana | 39029 | 28107 | 499 | 0 | 40.76932373 | -80.78094576 | 2022-10-31 04:21:36 | Columbiana, Ohio, US | |
914667 | 914667 | 2022-10-29 | US | Ohio | Columbiana | 39029 | 28107 | 499 | 0 | 40.76932373 | -80.78094576 | 2022-10-30 04:22:14 | Columbiana, Ohio, US | |
1368936 | 1368936 | 2022-10-28 | US | Ohio | Columbiana | 39029 | 28107 | 499 | 0 | 40.76932373 | -80.78094576 | 2022-10-29 04:21:13 | Columbiana, Ohio, US | |
3040791 | 3040791 | 2022-10-27 | US | Ohio | Columbiana | 39029 | 28107 | 499 | 0 | 40.76932373 | -80.78094576 | 2022-10-28 04:22:31 | Columbiana, Ohio, US | |
2267901 | 2267901 | 2022-10-22 | Japan | Gunma | 248645 | 499 | 0 | 36.504479 | 138.985605 | 2022-10-23 04:22:46 | Gunma, Japan | |||
2757371 | 2757371 | 2022-10-18 | US | Arizona | Coconino | 4005 | 49885 | 499 | 0 | 35.83883429 | -111.7707178 | 2022-10-19 04:22:26 | Coconino, Arizona, US | |
2025205 | 2025205 | 2022-10-17 | US | Arizona | Coconino | 4005 | 49885 | 499 | 0 | 35.83883429 | -111.7707178 | 2022-10-18 04:22:42 | Coconino, Arizona, US | |
2159983 | 2159983 | 2022-10-16 | US | Arizona | Coconino | 4005 | 49885 | 499 | 0 | 35.83883429 | -111.7707178 | 2022-10-17 04:20:31 | Coconino, Arizona, US | |
516180 | 516180 | 2022-10-15 | US | Arizona | Coconino | 4005 | 49885 | 499 | 0 | 35.83883429 | -111.7707178 | 2022-10-16 04:22:39 | Coconino, Arizona, US | |
2033237 | 2033237 | 2022-10-14 | US | Arizona | Coconino | 4005 | 49885 | 499 | 0 | 35.83883429 | -111.7707178 | 2022-10-15 04:22:00 | Coconino, Arizona, US | |
3753925 | 3753925 | 2022-10-13 | US | Arizona | Coconino | 4005 | 49885 | 499 | 0 | 35.83883429 | -111.7707178 | 2022-10-14 04:22:28 | Coconino, Arizona, US | |
3214750 | 3214750 | 2022-10-12 | US | Arizona | Coconino | 4005 | 49885 | 499 | 0 | 35.83883429 | -111.7707178 | 2022-10-13 04:22:39 | Coconino, Arizona, US | |
2530409 | 2530409 | 2022-10-06 | US | Illinois | McHenry | 17111 | 91320 | 499 | 0 | 42.32451172 | -88.45248227 | 2022-10-07 04:23:08 | McHenry, Illinois, US | |
1811803 | 1811803 | 2022-10-05 | US | Illinois | McHenry | 17111 | 91266 | 499 | 0 | 42.32451172 | -88.45248227 | 2022-10-06 04:21:22 | McHenry, Illinois, US | |
131777 | 131777 | 2022-10-04 | US | Illinois | McHenry | 17111 | 91225 | 499 | 0 | 42.32451172 | -88.45248227 | 2022-10-05 04:23:06 | McHenry, Illinois, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);