johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
152 rows where confirmed = 4435 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308253 | 308253 | 2022-12-13 | US | Alabama | Crenshaw | 1041 | 4435 | 108 | 0 | 31.72941803 | -86.31593104 | 2022-12-14 04:21:04 | Crenshaw, Alabama, US | |
1149314 | 1149314 | 2022-12-12 | US | Alabama | Crenshaw | 1041 | 4435 | 108 | 0 | 31.72941803 | -86.31593104 | 2022-12-13 04:21:01 | Crenshaw, Alabama, US | |
869168 | 869168 | 2022-12-11 | US | Alabama | Crenshaw | 1041 | 4435 | 108 | 0 | 31.72941803 | -86.31593104 | 2022-12-12 04:21:01 | Crenshaw, Alabama, US | |
257698 | 257698 | 2022-12-10 | US | Alabama | Crenshaw | 1041 | 4435 | 108 | 0 | 31.72941803 | -86.31593104 | 2022-12-11 04:20:50 | Crenshaw, Alabama, US | |
3936412 | 3936412 | 2022-12-09 | US | Alabama | Crenshaw | 1041 | 4435 | 108 | 0 | 31.72941803 | -86.31593104 | 2022-12-10 04:21:02 | Crenshaw, Alabama, US | |
3377744 | 3377744 | 2022-12-08 | US | Alabama | Crenshaw | 1041 | 4435 | 108 | 0 | 31.72941803 | -86.31593104 | 2022-12-09 04:21:05 | Crenshaw, Alabama, US | |
1985015 | 1985015 | 2022-12-07 | US | Alabama | Crenshaw | 1041 | 4435 | 108 | 0 | 31.72941803 | -86.31593104 | 2022-12-08 04:21:07 | Crenshaw, Alabama, US | |
294638 | 294638 | 2022-11-15 | US | Oregon | Hood River | 41027 | 4435 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-16 04:21:09 | Hood River, Oregon, US | |
3599668 | 3599668 | 2022-11-14 | US | Oregon | Hood River | 41027 | 4435 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-15 04:21:16 | Hood River, Oregon, US | |
314526 | 314526 | 2022-11-13 | US | Oregon | Hood River | 41027 | 4435 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-14 04:21:09 | Hood River, Oregon, US | |
65687 | 65687 | 2022-11-12 | US | Oregon | Hood River | 41027 | 4435 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-13 04:21:14 | Hood River, Oregon, US | |
2929849 | 2929849 | 2022-11-11 | US | Oregon | Hood River | 41027 | 4435 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-12 04:20:41 | Hood River, Oregon, US | |
2508685 | 2508685 | 2022-11-10 | US | Oregon | Hood River | 41027 | 4435 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-11 04:21:22 | Hood River, Oregon, US | |
539138 | 539138 | 2022-10-26 | US | Alabama | Lamar | 1075 | 4435 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-10-27 04:22:01 | Lamar, Alabama, US | |
1830539 | 1830539 | 2022-10-25 | US | Alabama | Lamar | 1075 | 4435 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-10-26 04:22:19 | Lamar, Alabama, US | |
794800 | 794800 | 2022-10-24 | US | Alabama | Lamar | 1075 | 4435 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-10-25 04:21:53 | Lamar, Alabama, US | |
3277255 | 3277255 | 2022-10-23 | US | Alabama | Lamar | 1075 | 4435 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-10-24 04:22:29 | Lamar, Alabama, US | |
2268293 | 2268293 | 2022-10-22 | US | Alabama | Lamar | 1075 | 4435 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-10-23 04:22:46 | Lamar, Alabama, US | |
1592593 | 1592593 | 2022-10-21 | US | Alabama | Lamar | 1075 | 4435 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-10-22 04:22:53 | Lamar, Alabama, US | |
2272309 | 2272309 | 2022-10-20 | US | Alabama | Lamar | 1075 | 4435 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-10-21 04:22:23 | Lamar, Alabama, US | |
198857 | 198857 | 2022-10-19 | US | California | Unassigned | 90006 | 4435 | 0 | 0 | 41.74228275 | 0.0 | 2022-10-20 04:22:59 | Unassigned, California, US | |
2757518 | 2757518 | 2022-10-18 | US | California | Unassigned | 90006 | 4435 | 0 | 0 | 41.74228275 | 0.0 | 2022-10-19 04:22:26 | Unassigned, California, US | |
2025352 | 2025352 | 2022-10-17 | US | California | Unassigned | 90006 | 4435 | 0 | 0 | 41.74228275 | 0.0 | 2022-10-18 04:22:42 | Unassigned, California, US | |
2160130 | 2160130 | 2022-10-16 | US | California | Unassigned | 90006 | 4435 | 0 | 0 | 41.74228275 | 0.0 | 2022-10-17 04:20:31 | Unassigned, California, US | |
516327 | 516327 | 2022-10-15 | US | California | Unassigned | 90006 | 4435 | 0 | 0 | 41.74228275 | 0.0 | 2022-10-16 04:22:39 | Unassigned, California, US | |
2033384 | 2033384 | 2022-10-14 | US | California | Unassigned | 90006 | 4435 | 0 | 0 | 41.74228275 | 0.0 | 2022-10-15 04:22:00 | Unassigned, California, US | |
3997584 | 3997584 | 2022-09-27 | US | Tennessee | Grundy | 47061 | 4435 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-09-28 04:23:01 | Grundy, Tennessee, US | |
1892534 | 1892534 | 2022-09-14 | US | Virginia | Patrick | 51141 | 4435 | 98 | 0 | 36.6801638 | -80.2865648 | 2022-09-15 04:21:02 | Patrick, Virginia, US | |
2343946 | 2343946 | 2022-08-31 | US | Arkansas | Polk | 5113 | 4435 | 151 | 0 | 34.48254879 | -94.22728802 | 2022-09-01 04:21:03 | Polk, Arkansas, US | |
2098873 | 2098873 | 2022-08-27 | US | Puerto Rico | Luquillo | 72089 | 4435 | 0 | 0 | 18.342114 | -65.725097 | 2022-08-28 04:21:02 | Luquillo, Puerto Rico, US | |
3651163 | 3651163 | 2022-08-14 | US | Wisconsin | Richland | 55103 | 4435 | 51 | 0 | 43.3762778 | -90.43012729 | 2022-08-15 04:20:59 | Richland, Wisconsin, US | |
1972169 | 1972169 | 2022-08-13 | US | Wisconsin | Richland | 55103 | 4435 | 51 | 0 | 43.3762778 | -90.43012729 | 2022-08-14 04:20:55 | Richland, Wisconsin, US | |
2891978 | 2891978 | 2022-08-12 | US | Wisconsin | Richland | 55103 | 4435 | 51 | 0 | 43.3762778 | -90.43012729 | 2022-08-13 04:20:52 | Richland, Wisconsin, US | |
899497 | 899497 | 2022-07-24 | US | Virginia | Greene | 51079 | 4435 | 62 | 0 | 38.29545894 | -78.46525378 | 2022-07-25 04:20:51 | Greene, Virginia, US | |
94491 | 94491 | 2022-07-23 | US | Virginia | Greene | 51079 | 4435 | 62 | 0 | 38.29545894 | -78.46525378 | 2022-07-24 04:20:47 | Greene, Virginia, US | |
903513 | 903513 | 2022-07-22 | US | Virginia | Greene | 51079 | 4435 | 62 | 0 | 38.29545894 | -78.46525378 | 2022-07-23 04:20:53 | Greene, Virginia, US | |
3890386 | 3890386 | 2022-06-06 | US | Puerto Rico | Naguabo | 72103 | 4435 | 0 | 0 | 18.230637 | -65.753897 | 2022-06-07 04:21:08 | Naguabo, Puerto Rico, US | |
3134196 | 3134196 | 2022-06-03 | US | Colorado | Otero | 8089 | 4435 | 130 | 0 | 37.9014485 | -103.7173385 | 2022-06-04 04:20:58 | Otero, Colorado, US | |
2029757 | 2029757 | 2022-04-24 | US | Illinois | Ford | 17053 | 4435 | 65 | 0 | 40.59706922 | -88.22350769 | 2022-04-25 04:20:56 | Ford, Illinois, US | |
747332 | 747332 | 2022-04-23 | US | Illinois | Ford | 17053 | 4435 | 65 | 0 | 40.59706922 | -88.22350769 | 2022-04-24 04:20:56 | Ford, Illinois, US | |
3437817 | 3437817 | 2022-04-22 | US | Illinois | Ford | 17053 | 4435 | 65 | 0 | 40.59706922 | -88.22350769 | 2022-04-23 04:20:50 | Ford, Illinois, US | |
2893966 | 2893966 | 2022-04-21 | US | Louisiana | Winn | 22127 | 4435 | 63 | 0 | 31.94449367 | -92.63789413 | 2022-04-22 04:20:45 | Winn, Louisiana, US | |
2308838 | 2308838 | 2022-04-20 | US | Louisiana | Winn | 22127 | 4435 | 63 | 0 | 31.94449367 | -92.63789413 | 2022-04-21 04:20:46 | Winn, Louisiana, US | |
1866483 | 1866483 | 2022-03-10 | US | Illinois | Johnson | 17087 | 4435 | 40 | 0 | 37.45939802 | -88.88165419 | 2022-03-11 04:20:50 | Johnson, Illinois, US | |
2141178 | 2141178 | 2022-03-09 | US | Illinois | Johnson | 17087 | 4435 | 40 | 0 | 37.45939802 | -88.88165419 | 2022-03-10 04:20:48 | Johnson, Illinois, US | |
2527089 | 2527089 | 2022-03-02 | US | Minnesota | Houston | 27055 | 4435 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-03-03 04:21:01 | Houston, Minnesota, US | |
1514325 | 1514325 | 2022-02-24 | US | Tennessee | Benton | 47005 | 4435 | 90 | 0 | 36.07110411 | -88.06849355 | 2022-02-25 04:21:11 | Benton, Tennessee, US | |
1364899 | 1364899 | 2022-02-08 | US | Oklahoma | Craig | 40035 | 4435 | 42 | 0 | 36.76268118 | -95.20916602 | 2022-02-09 04:21:04 | Craig, Oklahoma, US | |
73637 | 73637 | 2022-02-07 | US | Oklahoma | Craig | 40035 | 4435 | 42 | 0 | 36.76268118 | -95.20916602 | 2022-02-08 04:21:15 | Craig, Oklahoma, US | |
2015253 | 2015253 | 2022-02-06 | US | Oklahoma | Craig | 40035 | 4435 | 42 | 0 | 36.76268118 | -95.20916602 | 2022-02-07 04:21:05 | Craig, Oklahoma, US | |
2014331 | 2014331 | 2022-02-06 | US | Michigan | Cheboygan | 26031 | 4435 | 91 | 0 | 45.44787015 | -84.50122149 | 2022-02-07 04:21:05 | Cheboygan, Michigan, US | |
1296582 | 1296582 | 2022-02-05 | US | Oklahoma | Craig | 40035 | 4435 | 42 | 0 | 36.76268118 | -95.20916602 | 2022-02-06 04:21:00 | Craig, Oklahoma, US | |
1295660 | 1295660 | 2022-02-05 | US | Michigan | Cheboygan | 26031 | 4435 | 91 | 0 | 45.44787015 | -84.50122149 | 2022-02-06 04:21:00 | Cheboygan, Michigan, US | |
2329910 | 2329910 | 2022-02-04 | US | Oklahoma | Craig | 40035 | 4435 | 42 | 0 | 36.76268118 | -95.20916602 | 2022-02-05 04:21:05 | Craig, Oklahoma, US | |
2328988 | 2328988 | 2022-02-04 | US | Michigan | Cheboygan | 26031 | 4435 | 91 | 0 | 45.44787015 | -84.50122149 | 2022-02-05 04:21:05 | Cheboygan, Michigan, US | |
2476501 | 2476501 | 2022-02-03 | US | Oklahoma | Craig | 40035 | 4435 | 42 | 0 | 36.76268118 | -95.20916602 | 2022-02-04 04:21:10 | Craig, Oklahoma, US | |
461926 | 461926 | 2022-02-02 | US | Oklahoma | Craig | 40035 | 4435 | 42 | 0 | 36.76268118 | -95.20916602 | 2022-02-03 04:21:21 | Craig, Oklahoma, US | |
979747 | 979747 | 2022-02-01 | US | Georgia | Elbert | 13105 | 4435 | 97 | 0 | 34.11302332 | -82.83936148 | 2022-02-02 04:21:09 | Elbert, Georgia, US | |
3300688 | 3300688 | 2022-01-30 | US | Arkansas | Cross | 5037 | 4435 | 73 | 0 | 35.29631396 | -90.77185818 | 2022-01-31 04:21:09 | Cross, Arkansas, US | |
3062479 | 3062479 | 2022-01-29 | US | Arkansas | Cross | 5037 | 4435 | 73 | 0 | 35.29631396 | -90.77185818 | 2022-01-30 04:21:26 | Cross, Arkansas, US | |
3810413 | 3810413 | 2022-01-28 | US | Arkansas | Cross | 5037 | 4435 | 73 | 0 | 35.29631396 | -90.77185818 | 2022-01-29 04:21:10 | Cross, Arkansas, US | |
2835098 | 2835098 | 2022-01-22 | US | New York | Schoharie | 36095 | 4435 | 32 | 0 | 42.58831742 | -74.44339029999998 | 2022-01-23 04:21:13 | Schoharie, New York, US | |
3229670 | 3229670 | 2022-01-19 | US | Texas | Scurry | 48415 | 4435 | 95 | 0 | 32.74613808 | -100.91626640000001 | 2022-01-20 04:21:07 | Scurry, Texas, US | |
3688894 | 3688894 | 2022-01-13 | US | Kentucky | Harrison | 21097 | 4435 | 57 | 0 | 38.44188174 | -84.32869741 | 2022-01-14 04:21:54 | Harrison, Kentucky, US | |
3614973 | 3614973 | 2022-01-12 | US | Missouri | Henry | 29083 | 4435 | 66 | 0 | 38.38482826 | -93.79293734 | 2022-01-13 08:00:09 | Henry, Missouri, US | |
2966323 | 2966323 | 2021-12-24 | US | Tennessee | DeKalb | 47041 | 4435 | 81 | 0 | 35.97616272 | -85.83689361 | 2021-12-25 04:21:37 | DeKalb, Tennessee, US | |
2196093 | 2196093 | 2021-12-03 | US | Arkansas | Carroll | 5015 | 4435 | 77 | 0 | 36.34038560000001 | -93.54270261 | 2021-12-04 04:22:18 | Carroll, Arkansas, US | |
3403115 | 3403115 | 2021-11-30 | US | Michigan | Oceana | 26127 | 4435 | 75 | 0 | 43.64124435 | -86.26726673 | 2021-12-01 04:22:29 | Oceana, Michigan, US | |
151658 | 151658 | 2021-11-29 | US | Michigan | Oceana | 26127 | 4435 | 75 | 0 | 43.64124435 | -86.26726673 | 2021-11-30 04:22:53 | Oceana, Michigan, US | |
449242 | 449242 | 2021-11-17 | US | Missouri | Barry | 29009 | 4435 | 64 | 0 | 36.70978521 | -93.82919888 | 2021-11-18 04:21:33 | Barry, Missouri, US | |
3344492 | 3344492 | 2021-11-16 | US | Missouri | Barry | 29009 | 4435 | 64 | 0 | 36.70978521 | -93.82919888 | 2021-11-17 04:21:48 | Barry, Missouri, US | |
3343696 | 3343696 | 2021-11-16 | US | Indiana | Clay | 18021 | 4435 | 60 | 0 | 39.39561833 | -87.11723506 | 2021-11-17 04:21:48 | Clay, Indiana, US | |
715622 | 715622 | 2021-11-12 | US | Indiana | White | 18181 | 4435 | 66 | 0 | 40.74911165 | -86.86492015 | 2021-11-13 04:21:38 | White, Indiana, US | |
46526 | 46526 | 2021-11-02 | US | South Carolina | Edgefield | 45037 | 4435 | 57 | 0 | 33.77221995 | -81.96231108 | 2021-11-03 06:22:09 | Edgefield, South Carolina, US | |
3514222 | 3514222 | 2021-11-01 | US | South Carolina | Edgefield | 45037 | 4435 | 57 | 0 | 33.77221995 | -81.96231108 | 2021-11-02 04:22:03 | Edgefield, South Carolina, US | |
3513157 | 3513157 | 2021-11-01 | US | Minnesota | Pine | 27115 | 4435 | 33 | 0 | 46.12105238 | -92.74070188 | 2021-11-02 04:22:03 | Pine, Minnesota, US | |
2044435 | 2044435 | 2021-10-18 | US | California | Siskiyou | 6093 | 4435 | 42 | 0 | 41.59198861 | -122.54074340000001 | 2021-10-19 04:20:54 | Siskiyou, California, US | |
3007242 | 3007242 | 2021-10-11 | Germany | Unknown | 4435 | 0 | 0 | 2021-10-12 04:21:09 | Unknown, Germany | |||||
2462201 | 2462201 | 2021-10-06 | US | Virginia | Smyth | 51173 | 4435 | 105 | 0 | 36.84455636 | -81.53344948 | 2021-10-07 04:21:36 | Smyth, Virginia, US | |
707937 | 707937 | 2021-09-29 | US | Louisiana | East Feliciana | 22037 | 4435 | 140 | 0 | 30.84425359 | -91.04976723 | 2021-09-30 04:21:20 | East Feliciana, Louisiana, US | |
2078446 | 2078446 | 2021-09-26 | US | Ohio | Ottawa | 39123 | 4435 | 87 | 0 | 41.53781826 | -83.0940185 | 2021-09-27 04:21:16 | Ottawa, Ohio, US | |
602476 | 602476 | 2021-09-23 | US | Georgia | Dawson | 13085 | 4435 | 55 | 0 | 34.44244079 | -84.16964071 | 2021-09-24 04:21:44 | Dawson, Georgia, US | |
3759920 | 3759920 | 2021-09-21 | US | Ohio | Champaign | 39021 | 4435 | 65 | 0 | 40.13923427 | -83.76875242 | 2021-09-22 04:21:45 | Champaign, Ohio, US | |
812554 | 812554 | 2021-09-20 | US | Tennessee | Overton | 47133 | 4435 | 74 | 0 | 36.34117832 | -85.28989535 | 2021-09-21 04:21:26 | Overton, Tennessee, US | |
35471 | 35471 | 2021-08-25 | US | Texas | Cooke | 48097 | 4435 | 75 | 0 | 33.63979567 | -97.21240912 | 2021-08-26 04:21:28 | Cooke, Texas, US | |
105527 | 105527 | 2021-08-15 | US | New Mexico | Otero | 35035 | 4435 | 88 | 0 | 32.61348406 | -105.7417604 | 2021-08-16 04:21:31 | Otero, New Mexico, US | |
509885 | 509885 | 2021-08-14 | US | New Mexico | Otero | 35035 | 4435 | 88 | 0 | 32.61348406 | -105.7417604 | 2021-08-15 04:21:41 | Otero, New Mexico, US | |
1485757 | 1485757 | 2021-08-13 | US | New Mexico | Otero | 35035 | 4435 | 88 | 0 | 32.61348406 | -105.7417604 | 2021-08-14 04:21:25 | Otero, New Mexico, US | |
3299342 | 3299342 | 2021-07-30 | US | Texas | Matagorda | 48321 | 4435 | 115 | 0 | 28.81955746 | -96.01230294 | 2021-07-31 04:21:35 | Matagorda, Texas, US | |
3137565 | 3137565 | 2021-07-23 | Japan | Ishikawa | 4435 | 116 | 3939 | 380 | 36.769464 | 136.771027 | 2021-07-24 00:21:36 | Ishikawa, Japan | ||
297035 | 297035 | 2021-07-15 | US | Illinois | Monroe | 17133 | 4435 | 94 | 0 | 38.27594376 | -90.17761038 | 2021-07-16 04:21:22 | Monroe, Illinois, US | |
831830 | 831830 | 2021-07-09 | US | New York | Fulton | 36035 | 4435 | 93 | 0 | 43.11363907 | -74.41798804 | 2021-07-10 04:21:25 | Fulton, New York, US | |
3126504 | 3126504 | 2021-06-28 | US | Illinois | Jefferson | 17081 | 4435 | 122 | 0 | 38.29980057 | -88.9240025 | 2021-06-29 04:21:28 | Jefferson, Illinois, US | |
2423961 | 2423961 | 2021-06-23 | US | Indiana | Clinton | 18023 | 4435 | 55 | 0 | 40.30319754 | -86.47277257 | 2021-06-24 04:21:55 | Clinton, Indiana, US | |
3032568 | 3032568 | 2021-06-16 | US | North Carolina | Alexander | 37003 | 4435 | 85 | 0 | 35.922379600000006 | -81.17751948 | 2021-06-17 04:22:36 | Alexander, North Carolina, US | |
1567188 | 1567188 | 2021-06-14 | US | Texas | Grimes | 48185 | 4435 | 72 | 0 | 30.54579585 | -95.98902499 | 2021-06-15 04:22:22 | Grimes, Texas, US | |
3973031 | 3973031 | 2021-06-11 | US | Ohio | Madison | 39097 | 4435 | 65 | 0 | 39.89381073 | -83.40178317 | 2021-06-12 04:22:22 | Madison, Ohio, US | |
523940 | 523940 | 2021-06-09 | US | Indiana | Gibson | 18051 | 4435 | 93 | 0 | 38.30393723 | -87.58054938 | 2021-06-10 04:23:17 | Gibson, Indiana, US | |
2104813 | 2104813 | 2021-06-01 | US | Florida | DeSoto | 12027 | 4435 | 97 | 0 | 27.18677893 | -81.80941373 | 2021-06-02 04:24:34 | DeSoto, Florida, US | |
2392489 | 2392489 | 2021-05-18 | US | Minnesota | Itasca | 27061 | 4435 | 56 | 0 | 47.51009045 | -93.63092229 | 2021-05-19 04:20:42 | Itasca, 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]);