daily_reports (view)
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
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Pennsylvania | Perry | 42099 | 10182 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-30 04:21:04 | Perry, Pennsylvania, US | |
2022-12-29 | US | Minnesota | Benton | 27009 | 16655 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-30 04:21:04 | Benton, Minnesota, US | |
2022-12-28 | US | Pennsylvania | Perry | 42099 | 10182 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-29 04:21:01 | Perry, Pennsylvania, US | |
2022-12-28 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-29 04:21:01 | Benton, Minnesota, US | |
2022-12-27 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-28 04:21:04 | Perry, Pennsylvania, US | |
2022-12-27 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-28 04:21:04 | Benton, Minnesota, US | |
2022-12-26 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-27 04:21:07 | Perry, Pennsylvania, US | |
2022-12-26 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-27 04:21:07 | Benton, Minnesota, US | |
2022-12-26 | Malaysia | Perlis | 18954 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-27 04:21:07 | Perlis, Malaysia | |||
2022-12-25 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-26 04:21:06 | Perry, Pennsylvania, US | |
2022-12-25 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-26 04:21:06 | Benton, Minnesota, US | |
2022-12-25 | Malaysia | Perlis | 18951 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-26 04:21:06 | Perlis, Malaysia | |||
2022-12-24 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-25 04:21:04 | Perry, Pennsylvania, US | |
2022-12-24 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-25 04:21:04 | Benton, Minnesota, US | |
2022-12-24 | Malaysia | Perlis | 18947 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-25 04:21:04 | Perlis, Malaysia | |||
2022-12-23 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-24 04:21:02 | Perry, Pennsylvania, US | |
2022-12-23 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-24 04:21:02 | Benton, Minnesota, US | |
2022-12-23 | Malaysia | Perlis | 18941 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-24 04:21:02 | Perlis, Malaysia | |||
2022-12-22 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-23 04:21:04 | Perry, Pennsylvania, US | |
2022-12-22 | US | Minnesota | Benton | 27009 | 16596 | 196 | 0 | 45.69804958 | -93.99514135 | 2022-12-23 04:21:04 | Benton, Minnesota, US | |
2022-12-22 | Malaysia | Perlis | 18939 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-23 04:21:04 | Perlis, Malaysia | |||
2022-12-21 | US | Pennsylvania | Perry | 42099 | 10168 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-22 04:20:56 | Perry, Pennsylvania, US | |
2022-12-21 | Malaysia | Perlis | 18935 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-22 04:20:56 | Perlis, Malaysia | |||
2022-12-20 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-21 04:21:03 | Perry, Pennsylvania, US | |
2022-12-20 | Malaysia | Perlis | 18930 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-21 04:21:03 | Perlis, Malaysia | |||
2022-12-19 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-20 04:21:04 | Perry, Pennsylvania, US | |
2022-12-19 | Malaysia | Perlis | 18927 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-20 04:21:04 | Perlis, Malaysia | |||
2022-12-18 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-19 04:21:03 | Perry, Pennsylvania, US | |
2022-12-18 | Malaysia | Perlis | 18923 | 196 | 0 | 6.4449 | 100.2048 | 2022-12-19 04:21:03 | Perlis, Malaysia | |||
2022-12-17 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-18 04:21:03 | Perry, Pennsylvania, US | |
2022-12-16 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-17 04:21:04 | Perry, Pennsylvania, US | |
2022-12-15 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-16 04:21:01 | Perry, Pennsylvania, US | |
2022-12-14 | US | Pennsylvania | Perry | 42099 | 10122 | 196 | 0 | 40.40206612 | -77.26297447 | 2022-12-15 04:20:58 | Perry, Pennsylvania, US | |
2022-12-13 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-14 04:21:04 | Wayne, Pennsylvania, US | |
2022-12-13 | US | Georgia | Catoosa | 13047 | 16647 | 196 | 0 | 34.89872298 | -85.13757014 | 2022-12-14 04:21:04 | Catoosa, Georgia, US | |
2022-12-12 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-13 04:21:01 | Wayne, Pennsylvania, US | |
2022-12-12 | US | Georgia | Catoosa | 13047 | 16647 | 196 | 0 | 34.89872298 | -85.13757014 | 2022-12-13 04:21:01 | Catoosa, Georgia, US | |
2022-12-11 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-12 04:21:01 | Wayne, Pennsylvania, US | |
2022-12-11 | US | Georgia | Catoosa | 13047 | 16647 | 196 | 0 | 34.89872298 | -85.13757014 | 2022-12-12 04:21:01 | Catoosa, Georgia, US | |
2022-12-10 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-11 04:20:50 | Wayne, Pennsylvania, US | |
2022-12-10 | US | Georgia | Catoosa | 13047 | 16647 | 196 | 0 | 34.89872298 | -85.13757014 | 2022-12-11 04:20:50 | Catoosa, Georgia, US | |
2022-12-09 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-10 04:21:02 | Wayne, Pennsylvania, US | |
2022-12-09 | US | Georgia | Catoosa | 13047 | 16647 | 196 | 0 | 34.89872298 | -85.13757014 | 2022-12-10 04:21:02 | Catoosa, Georgia, US | |
2022-12-08 | US | Virginia | Albemarle | 51003 | 23848 | 196 | 0 | 38.02080697 | -78.55481085 | 2022-12-09 04:21:05 | Albemarle, Virginia, US | |
2022-12-08 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-09 04:21:05 | Wayne, Pennsylvania, US | |
2022-12-08 | US | Georgia | Catoosa | 13047 | 16647 | 196 | 0 | 34.89872298 | -85.13757014 | 2022-12-09 04:21:05 | Catoosa, Georgia, US | |
2022-12-07 | US | Pennsylvania | Wayne | 42127 | 12652 | 196 | 0 | 41.64938475 | -75.29956506 | 2022-12-08 04:21:07 | Wayne, Pennsylvania, US | |
2022-12-06 | US | Arkansas | Boone | 5009 | 10906 | 196 | 0 | 36.3084504 | -93.09374925 | 2022-12-07 04:20:58 | Boone, Arkansas, US | |
2022-12-05 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-12-06 04:21:03 | Ionia, Michigan, US | |
2022-12-05 | US | Arkansas | Boone | 5009 | 10892 | 196 | 0 | 36.3084504 | -93.09374925 | 2022-12-06 04:21:03 | Boone, Arkansas, US | |
2022-12-04 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-12-05 04:20:58 | Ionia, Michigan, US | |
2022-12-04 | US | Arkansas | Boone | 5009 | 10883 | 196 | 0 | 36.3084504 | -93.09374925 | 2022-12-05 04:20:58 | Boone, Arkansas, US | |
2022-12-03 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-12-04 04:20:56 | Ionia, Michigan, US | |
2022-12-03 | US | Arkansas | Boone | 5009 | 10881 | 196 | 0 | 36.3084504 | -93.09374925 | 2022-12-04 04:20:56 | Boone, Arkansas, US | |
2022-12-02 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-12-03 04:21:02 | Ionia, Michigan, US | |
2022-12-02 | US | Arkansas | Boone | 5009 | 10874 | 196 | 0 | 36.3084504 | -93.09374925 | 2022-12-03 04:21:02 | Boone, Arkansas, US | |
2022-12-02 | Japan | Yamanashi | 127339 | 196 | 0 | 35.612364 | 138.611489 | 2022-12-03 04:21:02 | Yamanashi, Japan | |||
2022-12-01 | US | Tennessee | Fayette | 47047 | 13362 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-12-02 04:21:07 | Fayette, Tennessee, US | |
2022-12-01 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-12-02 04:21:07 | Ionia, Michigan, US | |
2022-11-30 | US | Tennessee | Fayette | 47047 | 13353 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-12-01 04:21:03 | Fayette, Tennessee, US | |
2022-11-30 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-12-01 04:21:03 | Ionia, Michigan, US | |
2022-11-29 | US | Tennessee | Fayette | 47047 | 13332 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-30 04:21:07 | Fayette, Tennessee, US | |
2022-11-29 | US | Michigan | Ionia | 26067 | 19171 | 196 | 0 | 42.94502238 | -85.07413319 | 2022-11-30 04:21:07 | Ionia, Michigan, US | |
2022-11-29 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-30 04:21:07 | Unassigned, Indiana, US | |
2022-11-29 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-30 04:21:07 | Bonner, Idaho, US | |
2022-11-28 | US | Tennessee | Fayette | 47047 | 13322 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-29 04:21:05 | Fayette, Tennessee, US | |
2022-11-28 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-29 04:21:05 | Unassigned, Indiana, US | |
2022-11-28 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-29 04:21:05 | Bonner, Idaho, US | |
2022-11-27 | US | Tennessee | Fayette | 47047 | 13314 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-28 04:21:02 | Fayette, Tennessee, US | |
2022-11-27 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-28 04:21:02 | Unassigned, Indiana, US | |
2022-11-27 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-28 04:21:02 | Bonner, Idaho, US | |
2022-11-26 | US | Tennessee | Fayette | 47047 | 13302 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-27 04:21:05 | Fayette, Tennessee, US | |
2022-11-26 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-27 04:21:05 | Unassigned, Indiana, US | |
2022-11-26 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-27 04:21:05 | Bonner, Idaho, US | |
2022-11-25 | US | Tennessee | Fayette | 47047 | 13300 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-26 04:21:11 | Fayette, Tennessee, US | |
2022-11-25 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-26 04:21:11 | Unassigned, Indiana, US | |
2022-11-25 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-26 04:21:11 | Bonner, Idaho, US | |
2022-11-24 | US | Tennessee | Fayette | 47047 | 13298 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-25 04:21:06 | Fayette, Tennessee, US | |
2022-11-24 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-25 04:21:06 | Unassigned, Indiana, US | |
2022-11-24 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-25 04:21:06 | Bonner, Idaho, US | |
2022-11-23 | US | Tennessee | Fayette | 47047 | 13295 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-24 04:21:09 | Fayette, Tennessee, US | |
2022-11-23 | US | Indiana | Unassigned | 90018 | 0 | 196 | 0 | 41.64423868 | 0.0 | 2022-11-24 04:21:09 | Unassigned, Indiana, US | |
2022-11-23 | US | Idaho | Bonner | 16017 | 10011 | 196 | 0 | 48.29996017 | -116.6017932 | 2022-11-24 04:21:09 | Bonner, Idaho, US | |
2022-11-22 | US | Vermont | Chittenden | 50007 | 38465 | 196 | 0 | 44.46322849 | -73.08359212 | 2022-11-23 04:21:06 | Chittenden, Vermont, US | |
2022-11-22 | US | Tennessee | Fayette | 47047 | 13285 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-23 04:21:06 | Fayette, Tennessee, US | |
2022-11-22 | US | Minnesota | Rice | 27131 | 20120 | 196 | 0 | 44.3543376 | -93.29658715 | 2022-11-23 04:21:06 | Rice, Minnesota, US | |
2022-11-22 | Japan | Tokushima | 104725 | 196 | 0 | 33.919178 | 134.242091 | 2022-11-23 04:21:06 | Tokushima, Japan | |||
2022-11-21 | US | Vermont | Chittenden | 50007 | 38465 | 196 | 0 | 44.46322849 | -73.08359212 | 2022-11-22 04:20:47 | Chittenden, Vermont, US | |
2022-11-21 | US | Tennessee | Fayette | 47047 | 13279 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-22 04:20:47 | Fayette, Tennessee, US | |
2022-11-21 | US | Minnesota | Rice | 27131 | 20120 | 196 | 0 | 44.3543376 | -93.29658715 | 2022-11-22 04:20:47 | Rice, Minnesota, US | |
2022-11-21 | Japan | Tokushima | 104213 | 196 | 0 | 33.919178 | 134.242091 | 2022-11-22 04:20:47 | Tokushima, Japan | |||
2022-11-20 | US | Wisconsin | Ozaukee | 55089 | 26645 | 196 | 0 | 43.38352225 | -87.94625009 | 2022-11-21 04:21:05 | Ozaukee, Wisconsin, US | |
2022-11-20 | US | Vermont | Chittenden | 50007 | 38465 | 196 | 0 | 44.46322849 | -73.08359212 | 2022-11-21 04:21:05 | Chittenden, Vermont, US | |
2022-11-20 | US | Tennessee | Fayette | 47047 | 13274 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-21 04:21:05 | Fayette, Tennessee, US | |
2022-11-20 | US | Minnesota | Rice | 27131 | 20120 | 196 | 0 | 44.3543376 | -93.29658715 | 2022-11-21 04:21:05 | Rice, Minnesota, US | |
2022-11-20 | Japan | Tokushima | 104102 | 196 | 0 | 33.919178 | 134.242091 | 2022-11-21 04:21:05 | Tokushima, Japan | |||
2022-11-19 | US | Wisconsin | Ozaukee | 55089 | 26645 | 196 | 0 | 43.38352225 | -87.94625009 | 2022-11-20 04:21:08 | Ozaukee, Wisconsin, US | |
2022-11-19 | US | Vermont | Chittenden | 50007 | 38465 | 196 | 0 | 44.46322849 | -73.08359212 | 2022-11-20 04:21:08 | Chittenden, Vermont, US | |
2022-11-19 | US | Tennessee | Fayette | 47047 | 13272 | 196 | 0 | 35.19615831 | -89.41399032 | 2022-11-20 04:21:08 | Fayette, Tennessee, US | |
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;