johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,673 rows where deaths = 196 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755602 | 2755602 | 2022-12-29 | US | Pennsylvania | Perry | 42099 | 10182 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-30 04:21:04 | Perry, Pennsylvania, US | |
2754608 | 2754608 | 2022-12-29 | US | Minnesota | Benton | 27009 | 16655 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-30 04:21:04 | Benton, Minnesota, US | |
1076608 | 1076608 | 2022-12-28 | US | Pennsylvania | Perry | 42099 | 10182 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-29 04:21:01 | Perry, Pennsylvania, US | |
1075614 | 1075614 | 2022-12-28 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-29 04:21:01 | Benton, Minnesota, US | |
330605 | 330605 | 2022-12-27 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-28 04:21:04 | Perry, Pennsylvania, US | |
329611 | 329611 | 2022-12-27 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-28 04:21:04 | Benton, Minnesota, US | |
220678 | 220678 | 2022-12-26 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-27 04:21:07 | Perry, Pennsylvania, US | |
219684 | 219684 | 2022-12-26 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-27 04:21:07 | Benton, Minnesota, US | |
218041 | 218041 | 2022-12-26 | Malaysia | Perlis | 18954 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-27 04:21:07 | Perlis, Malaysia | |||
3225135 | 3225135 | 2022-12-25 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-26 04:21:06 | Perry, Pennsylvania, US | |
3224141 | 3224141 | 2022-12-25 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-26 04:21:06 | Benton, Minnesota, US | |
3222498 | 3222498 | 2022-12-25 | Malaysia | Perlis | 18951 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-26 04:21:06 | Perlis, Malaysia | |||
1021049 | 1021049 | 2022-12-24 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-25 04:21:04 | Perry, Pennsylvania, US | |
1020055 | 1020055 | 2022-12-24 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-25 04:21:04 | Benton, Minnesota, US | |
1018412 | 1018412 | 2022-12-24 | Malaysia | Perlis | 18947 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-25 04:21:04 | Perlis, Malaysia | |||
693072 | 693072 | 2022-12-23 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-24 04:21:02 | Perry, Pennsylvania, US | |
692078 | 692078 | 2022-12-23 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-24 04:21:02 | Benton, Minnesota, US | |
690435 | 690435 | 2022-12-23 | Malaysia | Perlis | 18941 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-24 04:21:02 | Perlis, Malaysia | |||
2182282 | 2182282 | 2022-12-22 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-23 04:21:04 | Perry, Pennsylvania, US | |
2181288 | 2181288 | 2022-12-22 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-23 04:21:04 | Benton, Minnesota, US | |
2179645 | 2179645 | 2022-12-22 | Malaysia | Perlis | 18939 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-23 04:21:04 | Perlis, Malaysia | |||
454086 | 454086 | 2022-12-21 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-22 04:20:56 | Perry, Pennsylvania, US | |
451449 | 451449 | 2022-12-21 | Malaysia | Perlis | 18935 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-22 04:20:56 | Perlis, Malaysia | |||
2954085 | 2954085 | 2022-12-20 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-21 04:21:03 | Perry, Pennsylvania, US | |
2951448 | 2951448 | 2022-12-20 | Malaysia | Perlis | 18930 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-21 04:21:03 | Perlis, Malaysia | |||
3176487 | 3176487 | 2022-12-19 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-20 04:21:04 | Perry, Pennsylvania, US | |
3173850 | 3173850 | 2022-12-19 | Malaysia | Perlis | 18927 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-20 04:21:04 | Perlis, Malaysia | |||
1631004 | 1631004 | 2022-12-18 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-19 04:21:03 | Perry, Pennsylvania, US | |
1628367 | 1628367 | 2022-12-18 | Malaysia | Perlis | 18923 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-19 04:21:03 | Perlis, Malaysia | |||
506383 | 506383 | 2022-12-17 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-18 04:21:03 | Perry, Pennsylvania, US | |
3326955 | 3326955 | 2022-12-16 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-17 04:21:04 | Perry, Pennsylvania, US | |
545467 | 545467 | 2022-12-15 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-16 04:21:01 | Perry, Pennsylvania, US | |
350995 | 350995 | 2022-12-14 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-15 04:20:58 | Perry, Pennsylvania, US | |
310598 | 310598 | 2022-12-13 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-14 04:21:04 | Wayne, Pennsylvania, US | |
308658 | 308658 | 2022-12-13 | US | Georgia | Catoosa | 13047 | 16647 | 196 | 0 | 34.89872298 | -85.13757014 | 2022-12-14 04:21:04 | Catoosa, Georgia, US | |
1151659 | 1151659 | 2022-12-12 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-13 04:21:01 | Wayne, Pennsylvania, US | |
1149719 | 1149719 | 2022-12-12 | US | Georgia | Catoosa | 13047 | 16647 | 196 | 0 | 34.89872298 | -85.13757014 | 2022-12-13 04:21:01 | Catoosa, Georgia, US | |
871513 | 871513 | 2022-12-11 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-12 04:21:01 | Wayne, Pennsylvania, US | |
869573 | 869573 | 2022-12-11 | US | Georgia | Catoosa | 13047 | 16647 | 196 | 0 | 34.89872298 | -85.13757014 | 2022-12-12 04:21:01 | Catoosa, Georgia, US | |
260043 | 260043 | 2022-12-10 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-11 04:20:50 | Wayne, Pennsylvania, US | |
258103 | 258103 | 2022-12-10 | US | Georgia | Catoosa | 13047 | 16647 | 196 | 0 | 34.89872298 | -85.13757014 | 2022-12-11 04:20:50 | Catoosa, Georgia, US | |
3938757 | 3938757 | 2022-12-09 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-10 04:21:02 | Wayne, Pennsylvania, US | |
3936817 | 3936817 | 2022-12-09 | US | Georgia | Catoosa | 13047 | 16647 | 196 | 0 | 34.89872298 | -85.13757014 | 2022-12-10 04:21:02 | Catoosa, Georgia, US | |
3380677 | 3380677 | 2022-12-08 | US | Virginia | Albemarle | 51003 | 23848 | 196 | 0 | 38.02080697 | -78.55481085 | 2022-12-09 04:21:05 | Albemarle, Virginia, US | |
3380089 | 3380089 | 2022-12-08 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-09 04:21:05 | Wayne, Pennsylvania, US | |
3378149 | 3378149 | 2022-12-08 | US | Georgia | Catoosa | 13047 | 16647 | 196 | 0 | 34.89872298 | -85.13757014 | 2022-12-09 04:21:05 | Catoosa, Georgia, US | |
1987360 | 1987360 | 2022-12-07 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-08 04:21:07 | Wayne, Pennsylvania, US | |
3714640 | 3714640 | 2022-12-06 | US | Arkansas | Boone | 5009 | 10906 | 196 | 0 | 36.3084504 | -93.09374925 | 2022-12-07 04:20:58 | Boone, Arkansas, US | |
2416522 | 2416522 | 2022-12-05 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-12-06 04:21:03 | Ionia, Michigan, US | |
2415345 | 2415345 | 2022-12-05 | US | Arkansas | Boone | 5009 | 10892 | 196 | 0 | 36.3084504 | -93.09374925 | 2022-12-06 04:21:03 | Boone, Arkansas, US | |
720130 | 720130 | 2022-12-04 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-12-05 04:20:58 | Ionia, Michigan, US | |
718953 | 718953 | 2022-12-04 | US | Arkansas | Boone | 5009 | 10883 | 196 | 0 | 36.3084504 | -93.09374925 | 2022-12-05 04:20:58 | Boone, Arkansas, US | |
2818419 | 2818419 | 2022-12-03 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-12-04 04:20:56 | Ionia, Michigan, US | |
2817242 | 2817242 | 2022-12-03 | US | Arkansas | Boone | 5009 | 10881 | 196 | 0 | 36.3084504 | -93.09374925 | 2022-12-04 04:20:56 | Boone, Arkansas, US | |
835275 | 835275 | 2022-12-02 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-12-03 04:21:02 | Ionia, Michigan, US | |
834098 | 834098 | 2022-12-02 | US | Arkansas | Boone | 5009 | 10874 | 196 | 0 | 36.3084504 | -93.09374925 | 2022-12-03 04:21:02 | Boone, Arkansas, US | |
833660 | 833660 | 2022-12-02 | Japan | Yamanashi | 127339 | 196 | 0 | 35.612364 | 138.611489 | 2022-12-03 04:21:02 | Yamanashi, Japan | |||
2139099 | 2139099 | 2022-12-01 | US | Tennessee | Fayette | 47047 | 13362 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-12-02 04:21:07 | Fayette, Tennessee, US | |
2137805 | 2137805 | 2022-12-01 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-12-02 04:21:07 | Ionia, Michigan, US | |
1967515 | 1967515 | 2022-11-30 | US | Tennessee | Fayette | 47047 | 13353 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-12-01 04:21:03 | Fayette, Tennessee, US | |
1966221 | 1966221 | 2022-11-30 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-12-01 04:21:03 | Ionia, Michigan, US | |
2559529 | 2559529 | 2022-11-29 | US | Tennessee | Fayette | 47047 | 13332 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-30 04:21:07 | Fayette, Tennessee, US | |
2558235 | 2558235 | 2022-11-29 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-11-30 04:21:07 | Ionia, Michigan, US | |
2557737 | 2557737 | 2022-11-29 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-30 04:21:07 | Unassigned, Indiana, US | |
2557516 | 2557516 | 2022-11-29 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-30 04:21:07 | Bonner, Idaho, US | |
1242603 | 1242603 | 2022-11-28 | US | Tennessee | Fayette | 47047 | 13322 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-29 04:21:05 | Fayette, Tennessee, US | |
1240811 | 1240811 | 2022-11-28 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-29 04:21:05 | Unassigned, Indiana, US | |
1240590 | 1240590 | 2022-11-28 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-29 04:21:05 | Bonner, Idaho, US | |
3554591 | 3554591 | 2022-11-27 | US | Tennessee | Fayette | 47047 | 13314 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-28 04:21:02 | Fayette, Tennessee, US | |
3552799 | 3552799 | 2022-11-27 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-28 04:21:02 | Unassigned, Indiana, US | |
3552578 | 3552578 | 2022-11-27 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-28 04:21:02 | Bonner, Idaho, US | |
2103071 | 2103071 | 2022-11-26 | US | Tennessee | Fayette | 47047 | 13302 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-27 04:21:05 | Fayette, Tennessee, US | |
2101279 | 2101279 | 2022-11-26 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-27 04:21:05 | Unassigned, Indiana, US | |
2101058 | 2101058 | 2022-11-26 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-27 04:21:05 | Bonner, Idaho, US | |
490562 | 490562 | 2022-11-25 | US | Tennessee | Fayette | 47047 | 13300 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-26 04:21:11 | Fayette, Tennessee, US | |
488770 | 488770 | 2022-11-25 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-26 04:21:11 | Unassigned, Indiana, US | |
488549 | 488549 | 2022-11-25 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-26 04:21:11 | Bonner, Idaho, US | |
3526391 | 3526391 | 2022-11-24 | US | Tennessee | Fayette | 47047 | 13298 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-25 04:21:06 | Fayette, Tennessee, US | |
3524599 | 3524599 | 2022-11-24 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-25 04:21:06 | Unassigned, Indiana, US | |
3524378 | 3524378 | 2022-11-24 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-25 04:21:06 | Bonner, Idaho, US | |
3315174 | 3315174 | 2022-11-23 | US | Tennessee | Fayette | 47047 | 13295 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-24 04:21:09 | Fayette, Tennessee, US | |
3313382 | 3313382 | 2022-11-23 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-24 04:21:09 | Unassigned, Indiana, US | |
3313161 | 3313161 | 2022-11-23 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-24 04:21:09 | Bonner, Idaho, US | |
1623561 | 1623561 | 2022-11-22 | US | Vermont | Chittenden | 50007 | 38465 | 196 | 0 | 44.46322849 | -73.08359212 | 2022-11-23 04:21:06 | Chittenden, Vermont, US | |
1623215 | 1623215 | 2022-11-22 | US | Tennessee | Fayette | 47047 | 13285 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-23 04:21:06 | Fayette, Tennessee, US | |
1622039 | 1622039 | 2022-11-22 | US | Minnesota | Rice | 27131 | 20120 | 196 | 0 | 44.3543376 | -93.29658715 | 2022-11-23 04:21:06 | Rice, Minnesota, US | |
1620298 | 1620298 | 2022-11-22 | Japan | Tokushima | 104725 | 196 | 0 | 33.919178 | 134.242091 | 2022-11-23 04:21:06 | Tokushima, Japan | |||
3463449 | 3463449 | 2022-11-21 | US | Vermont | Chittenden | 50007 | 38465 | 196 | 0 | 44.46322849 | -73.08359212 | 2022-11-22 04:20:47 | Chittenden, Vermont, US | |
3463103 | 3463103 | 2022-11-21 | US | Tennessee | Fayette | 47047 | 13279 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-22 04:20:47 | Fayette, Tennessee, US | |
3461927 | 3461927 | 2022-11-21 | US | Minnesota | Rice | 27131 | 20120 | 196 | 0 | 44.3543376 | -93.29658715 | 2022-11-22 04:20:47 | Rice, Minnesota, US | |
3460186 | 3460186 | 2022-11-21 | Japan | Tokushima | 104213 | 196 | 0 | 33.919178 | 134.242091 | 2022-11-22 04:20:47 | Tokushima, Japan | |||
1643922 | 1643922 | 2022-11-20 | US | Wisconsin | Ozaukee | 55089 | 26645 | 196 | 0 | 43.38352225 | -87.94625009 | 2022-11-21 04:21:05 | Ozaukee, Wisconsin, US | |
1643634 | 1643634 | 2022-11-20 | US | Vermont | Chittenden | 50007 | 38465 | 196 | 0 | 44.46322849 | -73.08359212 | 2022-11-21 04:21:05 | Chittenden, Vermont, US | |
1643288 | 1643288 | 2022-11-20 | US | Tennessee | Fayette | 47047 | 13274 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-21 04:21:05 | Fayette, Tennessee, US | |
1642112 | 1642112 | 2022-11-20 | US | Minnesota | Rice | 27131 | 20120 | 196 | 0 | 44.3543376 | -93.29658715 | 2022-11-21 04:21:05 | Rice, Minnesota, US | |
1640371 | 1640371 | 2022-11-20 | Japan | Tokushima | 104102 | 196 | 0 | 33.919178 | 134.242091 | 2022-11-21 04:21:05 | Tokushima, Japan | |||
2067479 | 2067479 | 2022-11-19 | US | Wisconsin | Ozaukee | 55089 | 26645 | 196 | 0 | 43.38352225 | -87.94625009 | 2022-11-20 04:21:08 | Ozaukee, Wisconsin, US | |
2067191 | 2067191 | 2022-11-19 | US | Vermont | Chittenden | 50007 | 38465 | 196 | 0 | 44.46322849 | -73.08359212 | 2022-11-20 04:21:08 | Chittenden, Vermont, US | |
2066845 | 2066845 | 2022-11-19 | US | Tennessee | Fayette | 47047 | 13272 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-20 04:21:08 | Fayette, Tennessee, US | |
2065669 | 2065669 | 2022-11-19 | US | Minnesota | Rice | 27131 | 20120 | 196 | 0 | 44.3543376 | -93.29658715 | 2022-11-20 04:21:08 | Rice, Minnesota, 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]);