johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,198 rows where deaths = 227 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756348 | 2756348 | 2022-12-29 | US | Washington | Franklin | 53021 | 36431 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-30 04:21:04 | Franklin, Washington, US | |
2755968 | 2755968 | 2022-12-29 | US | Texas | Coryell | 48099 | 20767 | 227 | 0 | 31.39078397 | -97.79936155 | 2022-12-30 04:21:04 | Coryell, Texas, US | |
2753653 | 2753653 | 2022-12-29 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-30 04:21:04 | Walton, Florida, US | |
1077354 | 1077354 | 2022-12-28 | US | Washington | Franklin | 53021 | 36431 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-29 04:21:01 | Franklin, Washington, US | |
1076974 | 1076974 | 2022-12-28 | US | Texas | Coryell | 48099 | 20767 | 227 | 0 | 31.39078397 | -97.79936155 | 2022-12-29 04:21:01 | Coryell, Texas, US | |
1076504 | 1076504 | 2022-12-28 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-29 04:21:01 | Pittsburg, Oklahoma, US | |
1074659 | 1074659 | 2022-12-28 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-29 04:21:01 | Walton, Florida, US | |
331351 | 331351 | 2022-12-27 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-28 04:21:04 | Franklin, Washington, US | |
330501 | 330501 | 2022-12-27 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-28 04:21:04 | Pittsburg, Oklahoma, US | |
328656 | 328656 | 2022-12-27 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-28 04:21:04 | Walton, Florida, US | |
221424 | 221424 | 2022-12-26 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-27 04:21:07 | Franklin, Washington, US | |
220574 | 220574 | 2022-12-26 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-27 04:21:07 | Pittsburg, Oklahoma, US | |
218729 | 218729 | 2022-12-26 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-27 04:21:07 | Walton, Florida, US | |
3225881 | 3225881 | 2022-12-25 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-26 04:21:06 | Franklin, Washington, US | |
3225031 | 3225031 | 2022-12-25 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-26 04:21:06 | Pittsburg, Oklahoma, US | |
3223186 | 3223186 | 2022-12-25 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-26 04:21:06 | Walton, Florida, US | |
1021795 | 1021795 | 2022-12-24 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-25 04:21:04 | Franklin, Washington, US | |
1020945 | 1020945 | 2022-12-24 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-25 04:21:04 | Pittsburg, Oklahoma, US | |
1019100 | 1019100 | 2022-12-24 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-25 04:21:04 | Walton, Florida, US | |
693818 | 693818 | 2022-12-23 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-24 04:21:02 | Franklin, Washington, US | |
692968 | 692968 | 2022-12-23 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-24 04:21:02 | Pittsburg, Oklahoma, US | |
691123 | 691123 | 2022-12-23 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-24 04:21:02 | Walton, Florida, US | |
2183028 | 2183028 | 2022-12-22 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-23 04:21:04 | Franklin, Washington, US | |
2182178 | 2182178 | 2022-12-22 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-23 04:21:04 | Pittsburg, Oklahoma, US | |
2180333 | 2180333 | 2022-12-22 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-23 04:21:04 | Walton, Florida, US | |
454832 | 454832 | 2022-12-21 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-22 04:20:56 | Franklin, Washington, US | |
452137 | 452137 | 2022-12-21 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-22 04:20:56 | Walton, Florida, US | |
2954043 | 2954043 | 2022-12-20 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-21 04:21:03 | Bradford, Pennsylvania, US | |
2952136 | 2952136 | 2022-12-20 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-21 04:21:03 | Walton, Florida, US | |
3176445 | 3176445 | 2022-12-19 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-20 04:21:04 | Bradford, Pennsylvania, US | |
3174538 | 3174538 | 2022-12-19 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-20 04:21:04 | Walton, Florida, US | |
1630962 | 1630962 | 2022-12-18 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-19 04:21:03 | Bradford, Pennsylvania, US | |
1629055 | 1629055 | 2022-12-18 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-19 04:21:03 | Walton, Florida, US | |
506341 | 506341 | 2022-12-17 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-18 04:21:03 | Bradford, Pennsylvania, US | |
504434 | 504434 | 2022-12-17 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-18 04:21:03 | Walton, Florida, US | |
3326913 | 3326913 | 2022-12-16 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-17 04:21:04 | Bradford, Pennsylvania, US | |
3325006 | 3325006 | 2022-12-16 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-17 04:21:04 | Walton, Florida, US | |
545425 | 545425 | 2022-12-15 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-16 04:21:01 | Bradford, Pennsylvania, US | |
545021 | 545021 | 2022-12-15 | US | New York | Montgomery | 36057 | 14597 | 227 | 0 | 42.90123494 | -74.44011632 | 2022-12-16 04:21:01 | Montgomery, New York, US | |
543734 | 543734 | 2022-12-15 | US | Illinois | Adams | 17001 | 27031 | 227 | 0 | 39.98815591 | -91.18786813 | 2022-12-16 04:21:01 | Adams, Illinois, US | |
543518 | 543518 | 2022-12-15 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-16 04:21:01 | Walton, Florida, US | |
350953 | 350953 | 2022-12-14 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-15 04:20:58 | Bradford, Pennsylvania, US | |
350549 | 350549 | 2022-12-14 | US | New York | Montgomery | 36057 | 14592 | 227 | 0 | 42.90123494 | -74.44011632 | 2022-12-15 04:20:58 | Montgomery, New York, US | |
349262 | 349262 | 2022-12-14 | US | Illinois | Adams | 17001 | 26987 | 227 | 0 | 39.98815591 | -91.18786813 | 2022-12-15 04:20:58 | Adams, Illinois, US | |
349046 | 349046 | 2022-12-14 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-15 04:20:58 | Walton, Florida, US | |
310137 | 310137 | 2022-12-13 | US | New York | Montgomery | 36057 | 14581 | 227 | 0 | 42.90123494 | -74.44011632 | 2022-12-14 04:21:04 | Montgomery, New York, US | |
308634 | 308634 | 2022-12-13 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-14 04:21:04 | Walton, Florida, US | |
1149695 | 1149695 | 2022-12-12 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-13 04:21:01 | Walton, Florida, US | |
1148970 | 1148970 | 2022-12-12 | Japan | Tokushima | 114308 | 227 | 0 | 33.919178 | 134.242091 | 2022-12-13 04:21:01 | Tokushima, Japan | |||
870216 | 870216 | 2022-12-11 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-12 04:21:01 | Harlan, Kentucky, US | |
869549 | 869549 | 2022-12-11 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-12 04:21:01 | Walton, Florida, US | |
868824 | 868824 | 2022-12-11 | Japan | Tokushima | 114072 | 227 | 0 | 33.919178 | 134.242091 | 2022-12-12 04:21:01 | Tokushima, Japan | |||
258746 | 258746 | 2022-12-10 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-11 04:20:50 | Harlan, Kentucky, US | |
258079 | 258079 | 2022-12-10 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-11 04:20:50 | Walton, Florida, US | |
3937460 | 3937460 | 2022-12-09 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-10 04:21:02 | Harlan, Kentucky, US | |
3936793 | 3936793 | 2022-12-09 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-10 04:21:02 | Walton, Florida, US | |
3378792 | 3378792 | 2022-12-08 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-09 04:21:05 | Harlan, Kentucky, US | |
3378125 | 3378125 | 2022-12-08 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-09 04:21:05 | Walton, Florida, US | |
1986063 | 1986063 | 2022-12-07 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-08 04:21:07 | Harlan, Kentucky, US | |
1985396 | 1985396 | 2022-12-07 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-08 04:21:07 | Walton, Florida, US | |
3715586 | 3715586 | 2022-12-06 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-07 04:20:58 | Harlan, Kentucky, US | |
3714919 | 3714919 | 2022-12-06 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-07 04:20:58 | Walton, Florida, US | |
2416525 | 2416525 | 2022-12-05 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-12-06 04:21:03 | Isabella, Michigan, US | |
2416291 | 2416291 | 2022-12-05 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-06 04:21:03 | Harlan, Kentucky, US | |
2415624 | 2415624 | 2022-12-05 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-06 04:21:03 | Walton, Florida, US | |
720133 | 720133 | 2022-12-04 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-12-05 04:20:58 | Isabella, Michigan, US | |
719232 | 719232 | 2022-12-04 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-05 04:20:58 | Walton, Florida, US | |
2818422 | 2818422 | 2022-12-03 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-12-04 04:20:56 | Isabella, Michigan, US | |
2817521 | 2817521 | 2022-12-03 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-04 04:20:56 | Walton, Florida, US | |
835278 | 835278 | 2022-12-02 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-12-03 04:21:02 | Isabella, Michigan, US | |
834377 | 834377 | 2022-12-02 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-03 04:21:02 | Walton, Florida, US | |
834125 | 834125 | 2022-12-02 | US | Arkansas | Independence | 5063 | 12396 | 227 | 0 | 35.74242707 | -91.57001641 | 2022-12-03 04:21:02 | Independence, Arkansas, US | |
2137808 | 2137808 | 2022-12-01 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-12-02 04:21:07 | Isabella, Michigan, US | |
2136907 | 2136907 | 2022-12-01 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-02 04:21:07 | Walton, Florida, US | |
2136670 | 2136670 | 2022-12-01 | US | Arkansas | Mississippi | 5093 | 15766 | 227 | 0 | 35.76271485 | -90.0519437 | 2022-12-02 04:21:07 | Mississippi, Arkansas, US | |
2136655 | 2136655 | 2022-12-01 | US | Arkansas | Independence | 5063 | 12389 | 227 | 0 | 35.74242707 | -91.57001641 | 2022-12-02 04:21:07 | Independence, Arkansas, US | |
1966224 | 1966224 | 2022-11-30 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-12-01 04:21:03 | Isabella, Michigan, US | |
1965323 | 1965323 | 2022-11-30 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-01 04:21:03 | Walton, Florida, US | |
1965071 | 1965071 | 2022-11-30 | US | Arkansas | Independence | 5063 | 12379 | 227 | 0 | 35.74242707 | -91.57001641 | 2022-12-01 04:21:03 | Independence, Arkansas, US | |
2558238 | 2558238 | 2022-11-29 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-30 04:21:07 | Isabella, Michigan, US | |
2557337 | 2557337 | 2022-11-29 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-30 04:21:07 | Walton, Florida, US | |
2557085 | 2557085 | 2022-11-29 | US | Arkansas | Independence | 5063 | 12352 | 227 | 0 | 35.74242707 | -91.57001641 | 2022-11-30 04:21:07 | Independence, Arkansas, US | |
1241312 | 1241312 | 2022-11-28 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-29 04:21:05 | Isabella, Michigan, US | |
1240411 | 1240411 | 2022-11-28 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-29 04:21:05 | Walton, Florida, US | |
3553300 | 3553300 | 2022-11-27 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-28 04:21:02 | Isabella, Michigan, US | |
3552399 | 3552399 | 2022-11-27 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-28 04:21:02 | Walton, Florida, US | |
2101780 | 2101780 | 2022-11-26 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-27 04:21:05 | Isabella, Michigan, US | |
2100879 | 2100879 | 2022-11-26 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-27 04:21:05 | Walton, Florida, US | |
489271 | 489271 | 2022-11-25 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-26 04:21:11 | Isabella, Michigan, US | |
488370 | 488370 | 2022-11-25 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-26 04:21:11 | Walton, Florida, US | |
3525100 | 3525100 | 2022-11-24 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-25 04:21:06 | Isabella, Michigan, US | |
3524199 | 3524199 | 2022-11-24 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-25 04:21:06 | Walton, Florida, US | |
3313883 | 3313883 | 2022-11-23 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-24 04:21:09 | Isabella, Michigan, US | |
3312982 | 3312982 | 2022-11-23 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-24 04:21:09 | Walton, Florida, US | |
1621924 | 1621924 | 2022-11-22 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-23 04:21:06 | Isabella, Michigan, US | |
1621023 | 1621023 | 2022-11-22 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-23 04:21:06 | Walton, Florida, US | |
3460911 | 3460911 | 2022-11-21 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-22 04:20:47 | Walton, Florida, US | |
1641096 | 1641096 | 2022-11-20 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-21 04:21:05 | Walton, Florida, US | |
2064653 | 2064653 | 2022-11-19 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-20 04:21:08 | Walton, Florida, US | |
1756047 | 1756047 | 2022-11-18 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-19 04:21:14 | Walton, Florida, 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]);