johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
795 rows where confirmed = 394 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3098062 | 3098062 | 2022-10-09 | US | Colorado | Dolores | 8033 | 394 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-10-10 04:22:32 | Dolores, Colorado, US | |
4003287 | 4003287 | 2022-10-08 | US | Colorado | Dolores | 8033 | 394 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-10-09 04:21:16 | Dolores, Colorado, US | |
396884 | 396884 | 2022-10-07 | US | Colorado | Dolores | 8033 | 394 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-10-08 04:22:56 | Dolores, Colorado, US | |
2530001 | 2530001 | 2022-10-06 | US | Colorado | Dolores | 8033 | 394 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-10-07 04:23:08 | Dolores, Colorado, US | |
898579 | 898579 | 2022-07-24 | US | North Dakota | Steele | 38091 | 394 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-25 04:20:51 | Steele, North Dakota, US | |
93573 | 93573 | 2022-07-23 | US | North Dakota | Steele | 38091 | 394 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-24 04:20:47 | Steele, North Dakota, US | |
902595 | 902595 | 2022-07-22 | US | North Dakota | Steele | 38091 | 394 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-23 04:20:53 | Steele, North Dakota, US | |
672731 | 672731 | 2022-07-21 | US | North Dakota | Steele | 38091 | 394 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-22 04:21:15 | Steele, North Dakota, US | |
1610694 | 1610694 | 2022-07-20 | US | North Dakota | Steele | 38091 | 394 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-21 04:21:10 | Steele, North Dakota, US | |
961327 | 961327 | 2022-07-19 | US | North Dakota | Steele | 38091 | 394 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-20 04:20:59 | Steele, North Dakota, US | |
3212714 | 3212714 | 2022-07-18 | US | North Dakota | Steele | 38091 | 394 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-19 04:20:58 | Steele, North Dakota, US | |
3407889 | 3407889 | 2022-07-17 | US | North Dakota | Steele | 38091 | 394 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-18 04:20:59 | Steele, North Dakota, US | |
2154089 | 2154089 | 2022-07-16 | US | North Dakota | Steele | 38091 | 394 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-17 04:21:15 | Steele, North Dakota, US | |
2421322 | 2421322 | 2022-07-15 | US | North Dakota | Steele | 38091 | 394 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-16 04:21:05 | Steele, North Dakota, US | |
3431397 | 3431397 | 2022-07-14 | US | North Dakota | Steele | 38091 | 394 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-15 04:20:53 | Steele, North Dakota, US | |
3430979 | 3430979 | 2022-07-14 | US | Montana | McCone | 30055 | 394 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-07-15 04:20:53 | McCone, Montana, US | |
3111917 | 3111917 | 2022-07-13 | US | North Dakota | Steele | 38091 | 394 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-14 04:20:57 | Steele, North Dakota, US | |
3111499 | 3111499 | 2022-07-13 | US | Montana | McCone | 30055 | 394 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-07-14 04:20:57 | McCone, Montana, US | |
632340 | 632340 | 2022-07-12 | US | North Dakota | Steele | 38091 | 394 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-13 04:20:58 | Steele, North Dakota, US | |
631922 | 631922 | 2022-07-12 | US | Montana | McCone | 30055 | 394 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-07-13 04:20:58 | McCone, Montana, US | |
1213566 | 1213566 | 2022-07-11 | US | Montana | McCone | 30055 | 394 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-07-12 04:20:51 | McCone, Montana, US | |
2791048 | 2791048 | 2022-07-10 | US | Montana | McCone | 30055 | 394 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-07-11 04:20:46 | McCone, Montana, US | |
144001 | 144001 | 2022-07-09 | US | Montana | McCone | 30055 | 394 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-07-10 04:20:54 | McCone, Montana, US | |
1419101 | 1419101 | 2022-07-08 | US | Montana | McCone | 30055 | 394 | 9 | 0 | 47.64469406 | -105.7944994 | 2022-07-09 04:20:59 | McCone, Montana, US | |
3942054 | 3942054 | 2022-06-30 | US | Montana | Daniels | 30019 | 394 | 9 | 0 | 48.78420029 | -105.5476343 | 2022-07-01 04:21:10 | Daniels, Montana, US | |
2492012 | 2492012 | 2022-06-29 | US | Montana | Daniels | 30019 | 394 | 9 | 0 | 48.78420029 | -105.5476343 | 2022-06-30 04:21:01 | Daniels, Montana, US | |
2241394 | 2241394 | 2022-06-28 | US | Montana | Daniels | 30019 | 394 | 9 | 0 | 48.78420029 | -105.5476343 | 2022-06-29 04:20:59 | Daniels, Montana, US | |
2149636 | 2149636 | 2022-06-27 | US | Montana | Daniels | 30019 | 394 | 9 | 0 | 48.78420029 | -105.5476343 | 2022-06-28 04:20:58 | Daniels, Montana, US | |
477437 | 477437 | 2022-06-26 | US | Montana | Daniels | 30019 | 394 | 9 | 0 | 48.78420029 | -105.5476343 | 2022-06-27 04:21:00 | Daniels, Montana, US | |
940812 | 940812 | 2022-06-25 | US | Montana | Daniels | 30019 | 394 | 9 | 0 | 48.78420029 | -105.5476343 | 2022-06-26 04:21:02 | Daniels, Montana, US | |
3348632 | 3348632 | 2022-06-24 | US | Montana | Daniels | 30019 | 394 | 9 | 0 | 48.78420029 | -105.5476343 | 2022-06-25 04:20:57 | Daniels, Montana, US | |
3002663 | 3002663 | 2022-05-24 | US | Virginia | Highland | 51091 | 394 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-05-25 04:20:56 | Highland, Virginia, US | |
3596384 | 3596384 | 2022-05-23 | US | Virginia | Highland | 51091 | 394 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-05-24 04:20:57 | Highland, Virginia, US | |
1112932 | 1112932 | 2022-05-21 | US | Virginia | Highland | 51091 | 394 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-05-22 04:20:52 | Highland, Virginia, US | |
1172556 | 1172556 | 2022-05-20 | US | Virginia | Highland | 51091 | 394 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-05-21 04:20:58 | Highland, Virginia, US | |
1159229 | 1159229 | 2022-04-29 | US | Nebraska | Garfield | 31071 | 394 | 2 | 0 | 41.91428955 | -98.99111827 | 2022-04-30 04:21:05 | Garfield, Nebraska, US | |
1698411 | 1698411 | 2022-04-28 | US | Nebraska | Garfield | 31071 | 394 | 2 | 0 | 41.91428955 | -98.99111827 | 2022-04-29 04:20:59 | Garfield, Nebraska, US | |
3853894 | 3853894 | 2022-04-27 | US | Nebraska | Garfield | 31071 | 394 | 2 | 0 | 41.91428955 | -98.99111827 | 2022-04-28 04:20:47 | Garfield, Nebraska, US | |
1328324 | 1328324 | 2022-04-26 | US | Nebraska | Garfield | 31071 | 394 | 2 | 0 | 41.91428955 | -98.99111827 | 2022-04-27 04:20:52 | Garfield, Nebraska, US | |
1845784 | 1845784 | 2022-04-18 | China | Shanxi | 394 | 0 | 0 | 37.5777 | 112.2922 | 2022-04-19 04:21:00 | Shanxi, China | |||
26410 | 26410 | 2022-03-20 | US | Montana | Liberty | 30051 | 394 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-21 04:20:50 | Liberty, Montana, US | |
1658420 | 1658420 | 2022-03-19 | US | Montana | Liberty | 30051 | 394 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-20 04:20:45 | Liberty, Montana, US | |
337946 | 337946 | 2022-03-18 | US | Montana | Liberty | 30051 | 394 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-19 04:20:47 | Liberty, Montana, US | |
696399 | 696399 | 2022-03-17 | US | Montana | Liberty | 30051 | 394 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-18 04:20:55 | Liberty, Montana, US | |
2321342 | 2321342 | 2022-03-16 | US | Montana | Liberty | 30051 | 394 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-17 04:20:56 | Liberty, Montana, US | |
263542 | 263542 | 2022-03-15 | US | Montana | Liberty | 30051 | 394 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-16 04:20:50 | Liberty, Montana, US | |
2265901 | 2265901 | 2022-03-14 | US | Montana | Liberty | 30051 | 394 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-15 04:20:47 | Liberty, Montana, US | |
3629967 | 3629967 | 2022-03-13 | US | Montana | Liberty | 30051 | 394 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-14 04:20:46 | Liberty, Montana, US | |
952875 | 952875 | 2022-03-12 | US | Montana | Liberty | 30051 | 394 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-13 04:20:49 | Liberty, Montana, US | |
358336 | 358336 | 2022-03-11 | US | Montana | Liberty | 30051 | 394 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-12 04:20:50 | Liberty, Montana, US | |
2142183 | 2142183 | 2022-03-09 | US | Montana | Liberty | 30051 | 394 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-10 04:20:48 | Liberty, Montana, US | |
921694 | 921694 | 2022-03-08 | US | Montana | Liberty | 30051 | 394 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-09 04:20:59 | Liberty, Montana, US | |
1549981 | 1549981 | 2022-03-07 | US | Montana | Liberty | 30051 | 394 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-08 04:20:54 | Liberty, Montana, US | |
1300160 | 1300160 | 2022-02-17 | US | Nebraska | Pawnee | 31133 | 394 | 1 | 0 | 40.13141096 | -96.23705437 | 2022-02-18 04:21:04 | Pawnee, Nebraska, US | |
3822546 | 3822546 | 2022-02-16 | US | Nebraska | Pawnee | 31133 | 394 | 1 | 0 | 40.13141096 | -96.23705437 | 2022-02-17 04:20:56 | Pawnee, Nebraska, US | |
3673760 | 3673760 | 2022-02-15 | US | Nebraska | Pawnee | 31133 | 394 | 1 | 0 | 40.13141096 | -96.23705437 | 2022-02-16 04:21:10 | Pawnee, Nebraska, US | |
2643861 | 2643861 | 2022-02-14 | US | Nebraska | Pawnee | 31133 | 394 | 1 | 0 | 40.13141096 | -96.23705437 | 2022-02-15 04:21:09 | Pawnee, Nebraska, US | |
188142 | 188142 | 2022-02-13 | US | Nebraska | Franklin | 31061 | 394 | 4 | 0 | 40.17636348 | -98.95299073 | 2022-02-14 04:20:51 | Franklin, Nebraska, US | |
317988 | 317988 | 2022-02-12 | US | Nebraska | Franklin | 31061 | 394 | 4 | 0 | 40.17636348 | -98.95299073 | 2022-02-13 04:21:00 | Franklin, Nebraska, US | |
235314 | 235314 | 2022-02-11 | US | Nebraska | Franklin | 31061 | 394 | 4 | 0 | 40.17636348 | -98.95299073 | 2022-02-12 04:21:06 | Franklin, Nebraska, US | |
1466156 | 1466156 | 2022-02-10 | US | Nebraska | Franklin | 31061 | 394 | 4 | 0 | 40.17636348 | -98.95299073 | 2022-02-11 04:21:09 | Franklin, Nebraska, US | |
3076117 | 3076117 | 2022-02-09 | US | Nebraska | Franklin | 31061 | 394 | 4 | 0 | 40.17636348 | -98.95299073 | 2022-02-10 04:21:14 | Franklin, Nebraska, US | |
1364335 | 1364335 | 2022-02-08 | US | Missouri | Worth | 29227 | 394 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-02-09 04:21:04 | Worth, Missouri, US | |
462262 | 462262 | 2022-02-02 | US | South Dakota | Jerauld | 46073 | 394 | 19 | 0 | 44.06637798 | -98.62965972 | 2022-02-03 04:21:21 | Jerauld, South Dakota, US | |
981831 | 981831 | 2022-02-01 | US | South Dakota | Jerauld | 46073 | 394 | 19 | 0 | 44.06637798 | -98.62965972 | 2022-02-02 04:21:09 | Jerauld, South Dakota, US | |
1143321 | 1143321 | 2022-01-23 | US | North Dakota | Logan | 38047 | 394 | 11 | 0 | 46.45729487 | -99.47719806 | 2022-01-24 04:21:12 | Logan, North Dakota, US | |
3428028 | 3428028 | 2022-01-21 | US | Texas | Edwards | 48137 | 394 | 9 | 0 | 29.98202582 | -100.304252 | 2022-01-22 04:21:13 | Edwards, Texas, US | |
1963636 | 1963636 | 2022-01-20 | US | Texas | Edwards | 48137 | 394 | 9 | 0 | 29.98202582 | -100.304252 | 2022-01-21 04:21:09 | Edwards, Texas, US | |
3229343 | 3229343 | 2022-01-19 | US | South Dakota | McPherson | 46089 | 394 | 9 | 0 | 45.76626028 | -99.22118798 | 2022-01-20 04:21:07 | McPherson, South Dakota, US | |
3229212 | 3229212 | 2022-01-19 | US | Puerto Rico | Maricao | 72093 | 394 | 0 | 0 | 18.171795 | -66.942126 | 2022-01-20 04:21:07 | Maricao, Puerto Rico, US | |
2612449 | 2612449 | 2022-01-06 | US | North Dakota | Golden Valley | 38033 | 394 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-01-07 04:22:09 | Golden Valley, North Dakota, US | |
1284391 | 1284391 | 2022-01-05 | US | North Dakota | Golden Valley | 38033 | 394 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-01-06 04:22:09 | Golden Valley, North Dakota, US | |
1288407 | 1288407 | 2022-01-04 | US | North Dakota | Golden Valley | 38033 | 394 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-01-05 04:21:59 | Golden Valley, North Dakota, US | |
1702751 | 1702751 | 2022-01-03 | US | North Dakota | Golden Valley | 38033 | 394 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-01-04 04:22:17 | Golden Valley, North Dakota, US | |
1701100 | 1701100 | 2022-01-03 | US | Georgia | Baker | 13007 | 394 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-01-04 04:22:17 | Baker, Georgia, US | |
3520183 | 3520183 | 2022-01-02 | US | Georgia | Baker | 13007 | 394 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-01-03 02:22:25 | Baker, Georgia, US | |
2170628 | 2170628 | 2022-01-01 | US | Texas | Culberson | 48109 | 394 | 11 | 0 | 31.44506775 | -104.5185739 | 2022-01-02 04:20:52 | Culberson, Texas, US | |
2168313 | 2168313 | 2022-01-01 | US | Georgia | Baker | 13007 | 394 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-01-02 04:20:52 | Baker, Georgia, US | |
2777744 | 2777744 | 2021-12-31 | US | Georgia | Baker | 13007 | 394 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-01-01 04:22:14 | Baker, Georgia, US | |
2090990 | 2090990 | 2021-12-14 | US | Texas | Armstrong | 48011 | 394 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2021-12-15 03:22:16 | Armstrong, Texas, US | |
785407 | 785407 | 2021-12-13 | US | Texas | Armstrong | 48011 | 394 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2021-12-14 04:22:38 | Armstrong, Texas, US | |
784797 | 784797 | 2021-12-13 | US | North Dakota | Kidder | 38043 | 394 | 13 | 0 | 46.97830064 | -99.77507857 | 2021-12-14 04:22:38 | Kidder, North Dakota, US | |
1663442 | 1663442 | 2021-12-12 | US | Texas | Armstrong | 48011 | 394 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2021-12-13 04:22:02 | Armstrong, Texas, US | |
1662832 | 1662832 | 2021-12-12 | US | North Dakota | Kidder | 38043 | 394 | 13 | 0 | 46.97830064 | -99.77507857 | 2021-12-13 04:22:02 | Kidder, North Dakota, US | |
1667458 | 1667458 | 2021-12-11 | US | Texas | Armstrong | 48011 | 394 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2021-12-12 04:22:12 | Armstrong, Texas, US | |
1666848 | 1666848 | 2021-12-11 | US | North Dakota | Kidder | 38043 | 394 | 13 | 0 | 46.97830064 | -99.77507857 | 2021-12-12 04:22:12 | Kidder, North Dakota, US | |
3658000 | 3658000 | 2021-12-10 | US | North Dakota | Kidder | 38043 | 394 | 13 | 0 | 46.97830064 | -99.77507857 | 2021-12-11 04:22:45 | Kidder, North Dakota, US | |
1080331 | 1080331 | 2021-12-09 | US | North Dakota | Kidder | 38043 | 394 | 13 | 0 | 46.97830064 | -99.77507857 | 2021-12-10 04:22:28 | Kidder, North Dakota, US | |
1033812 | 1033812 | 2021-12-06 | US | Washington | Columbia | 53013 | 394 | 9 | 0 | 46.29442881 | -117.9051983 | 2021-12-07 04:22:34 | Columbia, Washington, US | |
1146978 | 1146978 | 2021-12-01 | US | Nebraska | Brown | 31017 | 394 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-12-02 04:22:37 | Brown, Nebraska, US | |
1015268 | 1015268 | 2021-11-21 | US | Idaho | Custer | 16037 | 394 | 6 | 0 | 44.24186819 | -114.2855494 | 2021-11-22 04:22:20 | Custer, Idaho, US | |
723432 | 723432 | 2021-11-20 | US | Idaho | Custer | 16037 | 394 | 6 | 0 | 44.24186819 | -114.2855494 | 2021-11-21 04:22:13 | Custer, Idaho, US | |
162962 | 162962 | 2021-11-19 | US | Idaho | Custer | 16037 | 394 | 6 | 0 | 44.24186819 | -114.2855494 | 2021-11-20 04:22:17 | Custer, Idaho, US | |
3292372 | 3292372 | 2021-11-18 | US | Washington | San Juan | 53055 | 394 | 0 | 0 | 48.60182783 | -122.96745 | 2021-11-19 04:21:40 | San Juan, Washington, US | |
689077 | 689077 | 2021-11-13 | US | Puerto Rico | Arroyo | 72015 | 394 | 0 | 0 | 17.998457000000005 | -66.056546 | 2021-11-14 04:21:31 | Arroyo, Puerto Rico, US | |
717186 | 717186 | 2021-11-12 | US | Puerto Rico | Arroyo | 72015 | 394 | 0 | 0 | 17.998457000000005 | -66.056546 | 2021-11-13 04:21:38 | Arroyo, Puerto Rico, US | |
31136 | 31136 | 2021-11-11 | US | Puerto Rico | Arroyo | 72015 | 394 | 0 | 0 | 17.998457000000005 | -66.056546 | 2021-11-12 04:22:01 | Arroyo, Puerto Rico, US | |
2847575 | 2847575 | 2021-11-10 | US | Puerto Rico | Arroyo | 72015 | 394 | 0 | 0 | 17.998457000000005 | -66.056546 | 2021-11-11 04:21:45 | Arroyo, Puerto Rico, US | |
89845 | 89845 | 2021-11-09 | US | Puerto Rico | Arroyo | 72015 | 394 | 0 | 0 | 17.998457000000005 | -66.056546 | 2021-11-10 04:21:38 | Arroyo, Puerto Rico, US | |
3642273 | 3642273 | 2021-11-08 | US | Puerto Rico | Arroyo | 72015 | 394 | 0 | 0 | 17.998457000000005 | -66.056546 | 2021-11-09 04:21:36 | Arroyo, Puerto Rico, 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]);