johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
477 rows where country_or_region = "US" and deaths = 485 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 477 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753524 | 2753524 | 2022-12-29 | US | Colorado | Douglas | 8035 | 99612 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-30 04:21:04 | Douglas, Colorado, US | |
1074530 | 1074530 | 2022-12-28 | US | Colorado | Douglas | 8035 | 99565 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-29 04:21:01 | Douglas, Colorado, US | |
328527 | 328527 | 2022-12-27 | US | Colorado | Douglas | 8035 | 99532 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-28 04:21:04 | Douglas, Colorado, US | |
218600 | 218600 | 2022-12-26 | US | Colorado | Douglas | 8035 | 99515 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-27 04:21:07 | Douglas, Colorado, US | |
3223057 | 3223057 | 2022-12-25 | US | Colorado | Douglas | 8035 | 99428 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-26 04:21:06 | Douglas, Colorado, US | |
1018971 | 1018971 | 2022-12-24 | US | Colorado | Douglas | 8035 | 99428 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-25 04:21:04 | Douglas, Colorado, US | |
690994 | 690994 | 2022-12-23 | US | Colorado | Douglas | 8035 | 99428 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-24 04:21:02 | Douglas, Colorado, US | |
2180204 | 2180204 | 2022-12-22 | US | Colorado | Douglas | 8035 | 99372 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-23 04:21:04 | Douglas, Colorado, US | |
452008 | 452008 | 2022-12-21 | US | Colorado | Douglas | 8035 | 99341 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-22 04:20:56 | Douglas, Colorado, US | |
2952007 | 2952007 | 2022-12-20 | US | Colorado | Douglas | 8035 | 99280 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-21 04:21:03 | Douglas, Colorado, US | |
3174409 | 3174409 | 2022-12-19 | US | Colorado | Douglas | 8035 | 99238 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-20 04:21:04 | Douglas, Colorado, US | |
1628926 | 1628926 | 2022-12-18 | US | Colorado | Douglas | 8035 | 99122 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-19 04:21:03 | Douglas, Colorado, US | |
504305 | 504305 | 2022-12-17 | US | Colorado | Douglas | 8035 | 99122 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-18 04:21:03 | Douglas, Colorado, US | |
3324877 | 3324877 | 2022-12-16 | US | Colorado | Douglas | 8035 | 99122 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-17 04:21:04 | Douglas, Colorado, US | |
543389 | 543389 | 2022-12-15 | US | Colorado | Douglas | 8035 | 99087 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-16 04:21:01 | Douglas, Colorado, US | |
348917 | 348917 | 2022-12-14 | US | Colorado | Douglas | 8035 | 99036 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-15 04:20:58 | Douglas, Colorado, US | |
351580 | 351580 | 2022-12-14 | US | Utah | Weber-Morgan | 86815 | 485 | 0 | 41.27116049 | -111.9145117 | 2022-12-15 04:20:58 | Weber-Morgan, Utah, US | ||
308505 | 308505 | 2022-12-13 | US | Colorado | Douglas | 8035 | 98964 | 485 | 0 | 39.33133796 | -104.930001 | 2022-12-14 04:21:04 | Douglas, Colorado, US | |
311168 | 311168 | 2022-12-13 | US | Utah | Weber-Morgan | 86815 | 485 | 0 | 41.27116049 | -111.9145117 | 2022-12-14 04:21:04 | Weber-Morgan, Utah, US | ||
1152229 | 1152229 | 2022-12-12 | US | Utah | Weber-Morgan | 86815 | 485 | 0 | 41.27116049 | -111.9145117 | 2022-12-13 04:21:01 | Weber-Morgan, Utah, US | ||
872083 | 872083 | 2022-12-11 | US | Utah | Weber-Morgan | 86815 | 485 | 0 | 41.27116049 | -111.9145117 | 2022-12-12 04:21:01 | Weber-Morgan, Utah, US | ||
260613 | 260613 | 2022-12-10 | US | Utah | Weber-Morgan | 86815 | 485 | 0 | 41.27116049 | -111.9145117 | 2022-12-11 04:20:50 | Weber-Morgan, Utah, US | ||
3939327 | 3939327 | 2022-12-09 | US | Utah | Weber-Morgan | 86815 | 485 | 0 | 41.27116049 | -111.9145117 | 2022-12-10 04:21:02 | Weber-Morgan, Utah, US | ||
3380659 | 3380659 | 2022-12-08 | US | Utah | Weber-Morgan | 86448 | 485 | 0 | 41.27116049 | -111.9145117 | 2022-12-09 04:21:05 | Weber-Morgan, Utah, US | ||
1987930 | 1987930 | 2022-12-07 | US | Utah | Weber-Morgan | 86448 | 485 | 0 | 41.27116049 | -111.9145117 | 2022-12-08 04:21:07 | Weber-Morgan, Utah, US | ||
3717453 | 3717453 | 2022-12-06 | US | Utah | Weber-Morgan | 86448 | 485 | 0 | 41.27116049 | -111.9145117 | 2022-12-07 04:20:58 | Weber-Morgan, Utah, US | ||
2418158 | 2418158 | 2022-12-05 | US | Utah | Weber-Morgan | 86448 | 485 | 0 | 41.27116049 | -111.9145117 | 2022-12-06 04:21:03 | Weber-Morgan, Utah, US | ||
721766 | 721766 | 2022-12-04 | US | Utah | Weber-Morgan | 86448 | 485 | 0 | 41.27116049 | -111.9145117 | 2022-12-05 04:20:58 | Weber-Morgan, Utah, US | ||
2820055 | 2820055 | 2022-12-03 | US | Utah | Weber-Morgan | 86448 | 485 | 0 | 41.27116049 | -111.9145117 | 2022-12-04 04:20:56 | Weber-Morgan, Utah, US | ||
836911 | 836911 | 2022-12-02 | US | Utah | Weber-Morgan | 86448 | 485 | 0 | 41.27116049 | -111.9145117 | 2022-12-03 04:21:02 | Weber-Morgan, Utah, US | ||
3040548 | 3040548 | 2022-10-27 | US | New Mexico | Sandoval | 35043 | 41963 | 485 | 0 | 35.68862401 | -106.8687803 | 2022-10-28 04:22:31 | Sandoval, New Mexico, US | |
540968 | 540968 | 2022-10-26 | US | New Mexico | Sandoval | 35043 | 41929 | 485 | 0 | 35.68862401 | -106.8687803 | 2022-10-27 04:22:01 | Sandoval, New Mexico, US | |
3217221 | 3217221 | 2022-10-12 | US | Tennessee | Blount | 47009 | 45946 | 485 | 0 | 35.68938198 | -83.92847788 | 2022-10-13 04:22:39 | Blount, Tennessee, US | |
3253070 | 3253070 | 2022-10-11 | US | Tennessee | Blount | 47009 | 45930 | 485 | 0 | 35.68938198 | -83.92847788 | 2022-10-12 04:22:51 | Blount, Tennessee, US | |
2970329 | 2970329 | 2022-10-10 | US | Tennessee | Blount | 47009 | 45891 | 485 | 0 | 35.68938198 | -83.92847788 | 2022-10-11 04:23:05 | Blount, Tennessee, US | |
3100365 | 3100365 | 2022-10-09 | US | Tennessee | Blount | 47009 | 45861 | 485 | 0 | 35.68938198 | -83.92847788 | 2022-10-10 04:22:32 | Blount, Tennessee, US | |
4005590 | 4005590 | 2022-10-08 | US | Tennessee | Blount | 47009 | 45844 | 485 | 0 | 35.68938198 | -83.92847788 | 2022-10-09 04:21:16 | Blount, Tennessee, US | |
3996453 | 3996453 | 2022-09-27 | US | Mississippi | Jackson | 28059 | 43536 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-28 04:23:01 | Jackson, Mississippi, US | |
2770781 | 2770781 | 2022-09-26 | US | Mississippi | Jackson | 28059 | 43536 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-27 04:23:01 | Jackson, Mississippi, US | |
1978434 | 1978434 | 2022-09-25 | US | Mississippi | Jackson | 28059 | 43536 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-26 04:20:52 | Jackson, Mississippi, US | |
2651601 | 2651601 | 2022-09-24 | US | Mississippi | Jackson | 28059 | 43536 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-25 04:23:31 | Jackson, Mississippi, US | |
386041 | 386041 | 2022-09-23 | US | Mississippi | Jackson | 28059 | 43536 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-24 04:21:40 | Jackson, Mississippi, US | |
1626107 | 1626107 | 2022-09-22 | US | Mississippi | Jackson | 28059 | 43536 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-23 04:23:13 | Jackson, Mississippi, US | |
1372311 | 1372311 | 2022-09-21 | US | Mississippi | Jackson | 28059 | 43536 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-22 04:22:56 | Jackson, Mississippi, US | |
2018541 | 2018541 | 2022-09-20 | US | Mississippi | Jackson | 28059 | 43536 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-21 04:23:22 | Jackson, Mississippi, US | |
3572414 | 3572414 | 2022-09-19 | US | Mississippi | Jackson | 28059 | 43439 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-20 04:22:48 | Jackson, Mississippi, US | |
421153 | 421153 | 2022-09-18 | US | Mississippi | Jackson | 28059 | 43439 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-19 04:21:49 | Jackson, Mississippi, US | |
3375177 | 3375177 | 2022-09-17 | US | Mississippi | Jackson | 28059 | 43439 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-18 04:22:50 | Jackson, Mississippi, US | |
2357285 | 2357285 | 2022-09-16 | US | Mississippi | Jackson | 28059 | 43439 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-17 04:20:19 | Jackson, Mississippi, US | |
3988442 | 3988442 | 2022-09-15 | US | Mississippi | Jackson | 28059 | 43439 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-16 04:21:19 | Jackson, Mississippi, US | |
1890959 | 1890959 | 2022-09-14 | US | Mississippi | Jackson | 28059 | 43439 | 485 | 0 | 30.54020656 | -88.64184064 | 2022-09-15 04:21:02 | Jackson, Mississippi, US | |
3826897 | 3826897 | 2022-09-10 | US | Ohio | Allen | 39003 | 30597 | 485 | 0 | 40.77285242 | -84.10802343 | 2022-09-11 04:20:50 | Allen, Ohio, US | |
965354 | 965354 | 2022-09-09 | US | Ohio | Allen | 39003 | 30597 | 485 | 0 | 40.77285242 | -84.10802343 | 2022-09-10 04:21:10 | Allen, Ohio, US | |
255756 | 255756 | 2022-09-08 | US | Ohio | Allen | 39003 | 30597 | 485 | 0 | 40.77285242 | -84.10802343 | 2022-09-09 04:21:11 | Allen, Ohio, US | |
3747554 | 3747554 | 2022-09-07 | US | Ohio | Allen | 39003 | 30395 | 485 | 0 | 40.77285242 | -84.10802343 | 2022-09-08 04:21:02 | Allen, Ohio, US | |
117194 | 117194 | 2022-09-06 | US | Ohio | Allen | 39003 | 30395 | 485 | 0 | 40.77285242 | -84.10802343 | 2022-09-07 04:20:59 | Allen, Ohio, US | |
2636166 | 2636166 | 2022-09-05 | US | Ohio | Allen | 39003 | 30395 | 485 | 0 | 40.77285242 | -84.10802343 | 2022-09-06 04:21:02 | Allen, Ohio, US | |
2989730 | 2989730 | 2022-09-04 | US | Ohio | Allen | 39003 | 30395 | 485 | 0 | 40.77285242 | -84.10802343 | 2022-09-05 04:21:01 | Allen, Ohio, US | |
2715415 | 2715415 | 2022-09-03 | US | Ohio | Allen | 39003 | 30395 | 485 | 0 | 40.77285242 | -84.10802343 | 2022-09-04 04:21:22 | Allen, Ohio, US | |
1396120 | 1396120 | 2022-09-02 | US | Ohio | Allen | 39003 | 30395 | 485 | 0 | 40.77285242 | -84.10802343 | 2022-09-03 04:21:04 | Allen, Ohio, US | |
3549949 | 3549949 | 2022-09-01 | US | Ohio | Allen | 39003 | 30395 | 485 | 0 | 40.77285242 | -84.10802343 | 2022-09-02 04:21:07 | Allen, Ohio, US | |
2345869 | 2345869 | 2022-08-31 | US | Ohio | Allen | 39003 | 30193 | 485 | 0 | 40.77285242 | -84.10802343 | 2022-09-01 04:21:03 | Allen, Ohio, US | |
3776349 | 3776349 | 2022-08-30 | US | Ohio | Allen | 39003 | 30193 | 485 | 0 | 40.77285242 | -84.10802343 | 2022-08-31 04:20:57 | Allen, Ohio, US | |
1682945 | 1682945 | 2022-08-29 | US | Ohio | Allen | 39003 | 30193 | 485 | 0 | 40.77285242 | -84.10802343 | 2022-08-30 04:21:03 | Allen, Ohio, US | |
1162221 | 1162221 | 2022-08-18 | US | Illinois | Tazewell | 17179 | 41792 | 485 | 0 | 40.50716185 | -89.51404662 | 2022-08-19 04:20:54 | Tazewell, Illinois, US | |
3951545 | 3951545 | 2022-08-17 | US | Illinois | Tazewell | 17179 | 41761 | 485 | 0 | 40.50716185 | -89.51404662 | 2022-08-18 04:21:11 | Tazewell, Illinois, US | |
992047 | 992047 | 2022-08-16 | US | Illinois | Tazewell | 17179 | 41741 | 485 | 0 | 40.50716185 | -89.51404662 | 2022-08-17 04:20:59 | Tazewell, Illinois, US | |
1100604 | 1100604 | 2022-08-03 | US | Ohio | Licking | 39089 | 45731 | 485 | 0 | 40.09136236 | -82.48185785 | 2022-08-04 04:20:58 | Licking, Ohio, US | |
1405492 | 1405492 | 2022-08-02 | US | Arizona | Coconino | 4005 | 48160 | 485 | 0 | 35.83883429 | -111.7707178 | 2022-08-03 04:20:59 | Coconino, Arizona, US | |
1407529 | 1407529 | 2022-08-02 | US | Ohio | Licking | 39089 | 45731 | 485 | 0 | 40.09136236 | -82.48185785 | 2022-08-03 04:20:59 | Licking, Ohio, US | |
3617530 | 3617530 | 2022-08-01 | US | Arizona | Coconino | 4005 | 48160 | 485 | 0 | 35.83883429 | -111.7707178 | 2022-08-02 04:20:53 | Coconino, Arizona, US | |
3619567 | 3619567 | 2022-08-01 | US | Ohio | Licking | 39089 | 45731 | 485 | 0 | 40.09136236 | -82.48185785 | 2022-08-02 04:20:53 | Licking, Ohio, US | |
3872010 | 3872010 | 2022-07-31 | US | Arizona | Coconino | 4005 | 48160 | 485 | 0 | 35.83883429 | -111.7707178 | 2022-08-01 04:21:03 | Coconino, Arizona, US | |
3874047 | 3874047 | 2022-07-31 | US | Ohio | Licking | 39089 | 45731 | 485 | 0 | 40.09136236 | -82.48185785 | 2022-08-01 04:21:03 | Licking, Ohio, US | |
674764 | 674764 | 2022-07-30 | US | Arizona | Coconino | 4005 | 48160 | 485 | 0 | 35.83883429 | -111.7707178 | 2022-07-31 04:21:02 | Coconino, Arizona, US | |
1783963 | 1783963 | 2022-07-29 | US | Arizona | Coconino | 4005 | 48160 | 485 | 0 | 35.83883429 | -111.7707178 | 2022-07-30 04:20:42 | Coconino, Arizona, US | |
1066326 | 1066326 | 2022-07-28 | US | Arizona | Coconino | 4005 | 48160 | 485 | 0 | 35.83883429 | -111.7707178 | 2022-07-29 04:20:45 | Coconino, Arizona, US | |
2335845 | 2335845 | 2022-07-27 | US | Arizona | Coconino | 4005 | 48160 | 485 | 0 | 35.83883429 | -111.7707178 | 2022-07-28 04:20:56 | Coconino, Arizona, US | |
2338411 | 2338411 | 2022-07-27 | US | Texas | Angelina | 48005 | 16048 | 485 | 0 | 31.25457347 | -94.60901487 | 2022-07-28 04:20:56 | Angelina, Texas, US | |
1490601 | 1490601 | 2022-07-26 | US | Texas | Angelina | 48005 | 16038 | 485 | 0 | 31.25457347 | -94.60901487 | 2022-07-27 04:21:04 | Angelina, Texas, US | |
2597047 | 2597047 | 2022-07-25 | US | Texas | Angelina | 48005 | 16032 | 485 | 0 | 31.25457347 | -94.60901487 | 2022-07-26 04:20:58 | Angelina, Texas, US | |
899162 | 899162 | 2022-07-24 | US | Texas | Angelina | 48005 | 16016 | 485 | 0 | 31.25457347 | -94.60901487 | 2022-07-25 04:20:51 | Angelina, Texas, US | |
94156 | 94156 | 2022-07-23 | US | Texas | Angelina | 48005 | 16009 | 485 | 0 | 31.25457347 | -94.60901487 | 2022-07-24 04:20:47 | Angelina, Texas, US | |
903178 | 903178 | 2022-07-22 | US | Texas | Angelina | 48005 | 15982 | 485 | 0 | 31.25457347 | -94.60901487 | 2022-07-23 04:20:53 | Angelina, Texas, US | |
672560 | 672560 | 2022-07-21 | US | New York | Out of NY | 80036 | 0 | 485 | 0 | 44.74530905 | 0.0 | 2022-07-22 04:21:15 | Out of NY, New York, US | |
1610523 | 1610523 | 2022-07-20 | US | New York | Out of NY | 80036 | 0 | 485 | 0 | 44.74530905 | 0.0 | 2022-07-21 04:21:10 | Out of NY, New York, US | |
961156 | 961156 | 2022-07-19 | US | New York | Out of NY | 80036 | 0 | 485 | 0 | 44.74530905 | 0.0 | 2022-07-20 04:20:59 | Out of NY, New York, US | |
2148221 | 2148221 | 2022-06-27 | US | California | San Luis Obispo | 6079 | 63335 | 485 | 0 | 35.38822029 | -120.4039028 | 2022-06-28 04:20:58 | San Luis Obispo, California, US | |
2148685 | 2148685 | 2022-06-27 | US | Illinois | Rock Island | 17161 | 35488 | 485 | 0 | 41.46613806 | -90.57042164 | 2022-06-28 04:20:58 | Rock Island, Illinois, US | |
476022 | 476022 | 2022-06-26 | US | California | San Luis Obispo | 6079 | 62973 | 485 | 0 | 35.38822029 | -120.4039028 | 2022-06-27 04:21:00 | San Luis Obispo, California, US | |
476486 | 476486 | 2022-06-26 | US | Illinois | Rock Island | 17161 | 35370 | 485 | 0 | 41.46613806 | -90.57042164 | 2022-06-27 04:21:00 | Rock Island, Illinois, US | |
939397 | 939397 | 2022-06-25 | US | California | San Luis Obispo | 6079 | 62963 | 485 | 0 | 35.38822029 | -120.4039028 | 2022-06-26 04:21:02 | San Luis Obispo, California, US | |
939861 | 939861 | 2022-06-25 | US | Illinois | Rock Island | 17161 | 35370 | 485 | 0 | 41.46613806 | -90.57042164 | 2022-06-26 04:21:02 | Rock Island, Illinois, US | |
3347217 | 3347217 | 2022-06-24 | US | California | San Luis Obispo | 6079 | 62958 | 485 | 0 | 35.38822029 | -120.4039028 | 2022-06-25 04:20:57 | San Luis Obispo, California, US | |
3347681 | 3347681 | 2022-06-24 | US | Illinois | Rock Island | 17161 | 35370 | 485 | 0 | 41.46613806 | -90.57042164 | 2022-06-25 04:20:57 | Rock Island, Illinois, US | |
3349133 | 3349133 | 2022-06-24 | US | Ohio | Miami | 39109 | 26653 | 485 | 0 | 40.0543329 | -84.22871271 | 2022-06-25 04:20:57 | Miami, Ohio, US | |
1648958 | 1648958 | 2022-06-23 | US | California | San Luis Obispo | 6079 | 62926 | 485 | 0 | 35.38822029 | -120.4039028 | 2022-06-24 04:20:58 | San Luis Obispo, California, US | |
1649422 | 1649422 | 2022-06-23 | US | Illinois | Rock Island | 17161 | 35298 | 485 | 0 | 41.46613806 | -90.57042164 | 2022-06-24 04:20:58 | Rock Island, Illinois, US | |
1650874 | 1650874 | 2022-06-23 | US | Ohio | Miami | 39109 | 26653 | 485 | 0 | 40.0543329 | -84.22871271 | 2022-06-24 04:20:58 | Miami, Ohio, US | |
2188193 | 2188193 | 2022-06-22 | US | California | San Luis Obispo | 6079 | 62596 | 485 | 0 | 35.38822029 | -120.4039028 | 2022-06-23 04:20:55 | San Luis Obispo, California, 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]);