johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
143 rows where confirmed = 5754 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3026954 | 3026954 | 2022-11-17 | US | Colorado | Teller | 8119 | 5754 | 61 | 0 | 38.88133511 | -105.1614893 | 2022-11-18 04:21:15 | Teller, Colorado, US | |
713491 | 713491 | 2022-11-01 | US | Texas | Burleson | 48051 | 5754 | 68 | 0 | 30.49273808 | -96.62158484 | 2022-11-02 04:22:09 | Burleson, Texas, US | |
3287940 | 3287940 | 2022-10-31 | US | Texas | Burleson | 48051 | 5754 | 68 | 0 | 30.49273808 | -96.62158484 | 2022-11-01 04:22:36 | Burleson, Texas, US | |
3250603 | 3250603 | 2022-10-11 | US | Arizona | La Paz | 4012 | 5754 | 151 | 0 | 33.72854224 | -113.9810029 | 2022-10-12 04:22:51 | La Paz, Arizona, US | |
2967862 | 2967862 | 2022-10-10 | US | Arizona | La Paz | 4012 | 5754 | 151 | 0 | 33.72854224 | -113.9810029 | 2022-10-11 04:23:05 | La Paz, Arizona, US | |
3097898 | 3097898 | 2022-10-09 | US | Arizona | La Paz | 4012 | 5754 | 151 | 0 | 33.72854224 | -113.9810029 | 2022-10-10 04:22:32 | La Paz, Arizona, US | |
4003123 | 4003123 | 2022-10-08 | US | Arizona | La Paz | 4012 | 5754 | 151 | 0 | 33.72854224 | -113.9810029 | 2022-10-09 04:21:16 | La Paz, Arizona, US | |
396720 | 396720 | 2022-10-07 | US | Arizona | La Paz | 4012 | 5754 | 151 | 0 | 33.72854224 | -113.9810029 | 2022-10-08 04:22:56 | La Paz, Arizona, US | |
2529889 | 2529889 | 2022-10-06 | US | Arkansas | Logan | 5083 | 5754 | 82 | 0 | 35.21413234 | -93.71951016 | 2022-10-07 04:23:08 | Logan, Arkansas, US | |
2529837 | 2529837 | 2022-10-06 | US | Arizona | La Paz | 4012 | 5754 | 151 | 0 | 33.72854224 | -113.9810029 | 2022-10-07 04:23:08 | La Paz, Arizona, US | |
1813739 | 1813739 | 2022-10-05 | US | Tennessee | Johnson | 47091 | 5754 | 104 | 0 | 36.4552395 | -81.84886538 | 2022-10-06 04:21:22 | Johnson, Tennessee, US | |
1811231 | 1811231 | 2022-10-05 | US | Arizona | La Paz | 4012 | 5754 | 151 | 0 | 33.72854224 | -113.9810029 | 2022-10-06 04:21:22 | La Paz, Arizona, US | |
133713 | 133713 | 2022-10-04 | US | Tennessee | Johnson | 47091 | 5754 | 104 | 0 | 36.4552395 | -81.84886538 | 2022-10-05 04:23:06 | Johnson, Tennessee, US | |
2688660 | 2688660 | 2022-10-03 | US | Tennessee | Johnson | 47091 | 5754 | 104 | 0 | 36.4552395 | -81.84886538 | 2022-10-04 04:22:55 | Johnson, Tennessee, US | |
3572415 | 3572415 | 2022-09-19 | US | Mississippi | Jasper | 28061 | 5754 | 77 | 0 | 32.01922104 | -89.11786866 | 2022-09-20 04:22:48 | Jasper, Mississippi, US | |
421154 | 421154 | 2022-09-18 | US | Mississippi | Jasper | 28061 | 5754 | 77 | 0 | 32.01922104 | -89.11786866 | 2022-09-19 04:21:49 | Jasper, Mississippi, US | |
3375178 | 3375178 | 2022-09-17 | US | Mississippi | Jasper | 28061 | 5754 | 77 | 0 | 32.01922104 | -89.11786866 | 2022-09-18 04:22:50 | Jasper, Mississippi, US | |
2357286 | 2357286 | 2022-09-16 | US | Mississippi | Jasper | 28061 | 5754 | 77 | 0 | 32.01922104 | -89.11786866 | 2022-09-17 04:20:19 | Jasper, Mississippi, US | |
3988443 | 3988443 | 2022-09-15 | US | Mississippi | Jasper | 28061 | 5754 | 77 | 0 | 32.01922104 | -89.11786866 | 2022-09-16 04:21:19 | Jasper, Mississippi, US | |
1890960 | 1890960 | 2022-09-14 | US | Mississippi | Jasper | 28061 | 5754 | 77 | 0 | 32.01922104 | -89.11786866 | 2022-09-15 04:21:02 | Jasper, Mississippi, US | |
3774949 | 3774949 | 2022-08-30 | US | Illinois | Richland | 17159 | 5754 | 76 | 0 | 38.71240969 | -88.08475366 | 2022-08-31 04:20:57 | Richland, Illinois, US | |
1682092 | 1682092 | 2022-08-29 | US | Maryland | Somerset | 24039 | 5754 | 76 | 0 | 38.1163542 | -75.75118623 | 2022-08-30 04:21:03 | Somerset, Maryland, US | |
3954043 | 3954043 | 2022-08-17 | US | Wisconsin | Green Lake | 55047 | 5754 | 65 | 0 | 43.80025981 | -89.04679553 | 2022-08-18 04:21:11 | Green Lake, Wisconsin, US | |
2012086 | 2012086 | 2022-08-04 | US | Virginia | Powhatan | 51145 | 5754 | 62 | 0 | 37.55016038 | -77.91267882 | 2022-08-05 04:20:52 | Powhatan, Virginia, US | |
959372 | 959372 | 2022-07-19 | US | Arkansas | Columbia | 5027 | 5754 | 98 | 0 | 33.21230701 | -93.22642793 | 2022-07-20 04:20:59 | Columbia, Arkansas, US | |
631111 | 631111 | 2022-07-12 | US | Iowa | Henry | 19087 | 5754 | 76 | 0 | 40.98767962 | -91.54436349 | 2022-07-13 04:20:58 | Henry, Iowa, US | |
1212755 | 1212755 | 2022-07-11 | US | Iowa | Henry | 19087 | 5754 | 76 | 0 | 40.98767962 | -91.54436349 | 2022-07-12 04:20:51 | Henry, Iowa, US | |
2790237 | 2790237 | 2022-07-10 | US | Iowa | Henry | 19087 | 5754 | 76 | 0 | 40.98767962 | -91.54436349 | 2022-07-11 04:20:46 | Henry, Iowa, US | |
143190 | 143190 | 2022-07-09 | US | Iowa | Henry | 19087 | 5754 | 76 | 0 | 40.98767962 | -91.54436349 | 2022-07-10 04:20:54 | Henry, Iowa, US | |
1418290 | 1418290 | 2022-07-08 | US | Iowa | Henry | 19087 | 5754 | 76 | 0 | 40.98767962 | -91.54436349 | 2022-07-09 04:20:59 | Henry, Iowa, US | |
2742215 | 2742215 | 2022-07-07 | US | Iowa | Henry | 19087 | 5754 | 76 | 0 | 40.98767962 | -91.54436349 | 2022-07-08 04:20:56 | Henry, Iowa, US | |
1201010 | 1201010 | 2022-07-06 | US | Iowa | Henry | 19087 | 5754 | 76 | 0 | 40.98767962 | -91.54436349 | 2022-07-07 04:20:55 | Henry, Iowa, US | |
477221 | 477221 | 2022-06-26 | US | Minnesota | Waseca | 27161 | 5754 | 39 | 0 | 44.02211116 | -93.58720034 | 2022-06-27 04:21:00 | Waseca, Minnesota, US | |
940596 | 940596 | 2022-06-25 | US | Minnesota | Waseca | 27161 | 5754 | 39 | 0 | 44.02211116 | -93.58720034 | 2022-06-26 04:21:02 | Waseca, Minnesota, US | |
3348416 | 3348416 | 2022-06-24 | US | Minnesota | Waseca | 27161 | 5754 | 39 | 0 | 44.02211116 | -93.58720034 | 2022-06-25 04:20:57 | Waseca, Minnesota, US | |
3142045 | 3142045 | 2022-06-11 | US | Arkansas | Arkansas | 5001 | 5754 | 78 | 0 | 34.29145151 | -91.37277296 | 2022-06-12 04:20:53 | Arkansas, Arkansas, US | |
1852784 | 1852784 | 2022-05-26 | US | Puerto Rico | Yabucoa | 72151 | 5754 | 0 | 0 | 18.070399 | -65.896289 | 2022-05-27 04:20:56 | Yabucoa, Puerto Rico, US | |
1187685 | 1187685 | 2022-05-18 | US | Tennessee | Fentress | 47049 | 5754 | 128 | 0 | 36.38128818 | -84.92870012 | 2022-05-19 04:20:54 | Fentress, Tennessee, US | |
3446425 | 3446425 | 2022-05-11 | US | Maryland | Garrett | 24023 | 5754 | 116 | 0 | 39.52786077 | -79.27355126 | 2022-05-12 04:20:54 | Garrett, Maryland, US | |
2599382 | 2599382 | 2022-05-05 | US | Kansas | Pottawatomie | 20149 | 5754 | 57 | 0 | 39.37925655 | -96.34564657 | 2022-05-06 04:21:00 | Pottawatomie, Kansas, US | |
3266831 | 3266831 | 2022-05-04 | US | Kansas | Pottawatomie | 20149 | 5754 | 57 | 0 | 39.37925655 | -96.34564657 | 2022-05-05 04:20:55 | Pottawatomie, Kansas, US | |
1573470 | 1573470 | 2022-05-03 | US | Kansas | Pottawatomie | 20149 | 5754 | 57 | 0 | 39.37925655 | -96.34564657 | 2022-05-04 04:20:59 | Pottawatomie, Kansas, US | |
464730 | 464730 | 2022-05-02 | US | Kansas | Pottawatomie | 20149 | 5754 | 57 | 0 | 39.37925655 | -96.34564657 | 2022-05-03 04:21:00 | Pottawatomie, Kansas, US | |
3917369 | 3917369 | 2022-05-01 | US | Kansas | Pottawatomie | 20149 | 5754 | 57 | 0 | 39.37925655 | -96.34564657 | 2022-05-02 04:21:10 | Pottawatomie, Kansas, US | |
2842173 | 2842173 | 2022-04-30 | US | Kansas | Pottawatomie | 20149 | 5754 | 57 | 0 | 39.37925655 | -96.34564657 | 2022-05-01 04:20:57 | Pottawatomie, Kansas, US | |
1158486 | 1158486 | 2022-04-29 | US | Kansas | Pottawatomie | 20149 | 5754 | 57 | 0 | 39.37925655 | -96.34564657 | 2022-04-30 04:21:05 | Pottawatomie, Kansas, US | |
1698050 | 1698050 | 2022-04-28 | US | Minnesota | Dodge | 27039 | 5754 | 21 | 0 | 44.02238415 | -92.86244324 | 2022-04-29 04:20:59 | Dodge, Minnesota, US | |
3725220 | 3725220 | 2022-04-25 | US | Texas | Austin | 48015 | 5754 | 73 | 0 | 29.88548725 | -96.27736949 | 2022-04-26 04:20:51 | Austin, Texas, US | |
2031788 | 2031788 | 2022-04-24 | US | Texas | Austin | 48015 | 5754 | 73 | 0 | 29.88548725 | -96.27736949 | 2022-04-25 04:20:56 | Austin, Texas, US | |
2142497 | 2142497 | 2022-03-09 | US | North Carolina | Greene | 37079 | 5754 | 56 | 0 | 35.48544173 | -77.67578087 | 2022-03-10 04:20:48 | Greene, North Carolina, US | |
2668067 | 2668067 | 2022-03-04 | US | New York | Seneca | 36099 | 5754 | 89 | 0 | 42.78081007 | -76.82497064 | 2022-03-05 04:21:10 | Seneca, New York, US | |
1646632 | 1646632 | 2022-03-03 | US | New York | Seneca | 36099 | 5754 | 89 | 0 | 42.78081007 | -76.82497064 | 2022-03-04 04:21:09 | Seneca, New York, US | |
945759 | 945759 | 2022-02-28 | US | Tennessee | Chester | 47023 | 5754 | 93 | 0 | 35.42527478 | -88.6095842 | 2022-03-01 04:21:09 | Chester, Tennessee, US | |
2447415 | 2447415 | 2022-02-22 | US | Colorado | Morgan | 8087 | 5754 | 137 | 0 | 40.26279810000001 | -103.8093302 | 2022-02-23 04:21:09 | Morgan, Colorado, US | |
1300858 | 1300858 | 2022-02-17 | US | South Carolina | Barnwell | 45011 | 5754 | 93 | 0 | 33.26679302 | -81.43584352 | 2022-02-18 04:21:04 | Barnwell, South Carolina, US | |
2015685 | 2015685 | 2022-02-06 | US | Tennessee | Morgan | 47129 | 5754 | 72 | 0 | 36.13248031 | -84.64880098 | 2022-02-07 04:21:05 | Morgan, Tennessee, US | |
2053924 | 2053924 | 2022-01-25 | US | Nebraska | Adams | 31001 | 5754 | 46 | 0 | 40.52449420000001 | -98.50117804 | 2022-01-26 04:21:07 | Adams, Nebraska, US | |
1141461 | 1141461 | 2022-01-23 | US | California | Glenn | 6021 | 5754 | 39 | 0 | 39.59875897 | -122.3938452 | 2022-01-24 04:21:12 | Glenn, California, US | |
2836318 | 2836318 | 2022-01-22 | US | West Virginia | Jackson | 54035 | 5754 | 113 | 0 | 38.84263974 | -81.68148753 | 2022-01-23 04:21:13 | Jackson, West Virginia, US | |
1473197 | 1473197 | 2022-01-17 | US | Indiana | Decatur | 18031 | 5754 | 118 | 0 | 39.30712658 | -85.50087166 | 2022-01-18 04:21:04 | Decatur, Indiana, US | |
2610684 | 2610684 | 2022-01-06 | US | Colorado | Logan | 8075 | 5754 | 102 | 0 | 40.7249637 | -103.110817 | 2022-01-07 04:22:09 | Logan, Colorado, US | |
1703182 | 1703182 | 2022-01-03 | US | South Carolina | Marion | 45067 | 5754 | 143 | 0 | 34.07859748 | -79.36400756 | 2022-01-04 04:22:17 | Marion, South Carolina, US | |
3522265 | 3522265 | 2022-01-02 | US | South Carolina | Marion | 45067 | 5754 | 143 | 0 | 34.07859748 | -79.36400756 | 2022-01-03 02:22:25 | Marion, South Carolina, US | |
2170395 | 2170395 | 2022-01-01 | US | South Carolina | Marion | 45067 | 5754 | 143 | 0 | 34.07859748 | -79.36400756 | 2022-01-02 04:20:52 | Marion, South Carolina, US | |
2779826 | 2779826 | 2021-12-31 | US | South Carolina | Marion | 45067 | 5754 | 143 | 0 | 34.07859748 | -79.36400756 | 2022-01-01 04:22:14 | Marion, South Carolina, US | |
1669351 | 1669351 | 2021-12-29 | US | Georgia | Upson | 13293 | 5754 | 191 | 0 | 32.87920671 | -84.30024826 | 2021-12-30 04:21:25 | Upson, Georgia, US | |
732271 | 732271 | 2021-12-27 | US | Minnesota | Mille Lacs | 27095 | 5754 | 92 | 0 | 45.93705297 | -93.63236823 | 2021-12-28 04:21:47 | Mille Lacs, Minnesota, US | |
2113651 | 2113651 | 2021-12-26 | US | Missouri | Polk | 29167 | 5754 | 81 | 0 | 37.616229600000004 | -93.39828174 | 2021-12-27 04:21:58 | Polk, Missouri, US | |
3608212 | 3608212 | 2021-12-25 | US | Texas | Kendall | 48259 | 5754 | 102 | 0 | 29.94414155 | -98.7113588 | 2021-12-26 04:21:50 | Kendall, Texas, US | |
3607023 | 3607023 | 2021-12-25 | US | Missouri | Polk | 29167 | 5754 | 81 | 0 | 37.616229600000004 | -93.39828174 | 2021-12-26 04:21:50 | Polk, Missouri, US | |
2965341 | 2965341 | 2021-12-24 | US | Missouri | Polk | 29167 | 5754 | 81 | 0 | 37.616229600000004 | -93.39828174 | 2021-12-25 04:21:37 | Polk, Missouri, US | |
3818373 | 3818373 | 2021-12-23 | US | Missouri | Polk | 29167 | 5754 | 81 | 0 | 37.616229600000004 | -93.39828174 | 2021-12-24 04:21:34 | Polk, Missouri, US | |
1260767 | 1260767 | 2021-12-18 | US | Missouri | Warren | 29219 | 5754 | 75 | 0 | 38.76529479 | -91.16124662 | 2021-12-19 04:21:11 | Warren, Missouri, US | |
1664013 | 1664013 | 2021-12-12 | US | Wisconsin | Trempealeau | 55121 | 5754 | 52 | 0 | 44.30360275 | -91.35893614 | 2021-12-13 04:22:02 | Trempealeau, Wisconsin, US | |
1668029 | 1668029 | 2021-12-11 | US | Wisconsin | Trempealeau | 55121 | 5754 | 52 | 0 | 44.30360275 | -91.35893614 | 2021-12-12 04:22:12 | Trempealeau, Wisconsin, US | |
3659181 | 3659181 | 2021-12-10 | US | Wisconsin | Trempealeau | 55121 | 5754 | 52 | 0 | 44.30360275 | -91.35893614 | 2021-12-11 04:22:45 | Trempealeau, Wisconsin, US | |
1743968 | 1743968 | 2021-12-05 | US | Virginia | York | 51199 | 5754 | 83 | 0 | 37.24374789 | -76.54412815 | 2021-12-06 04:22:34 | York, Virginia, US | |
141400 | 141400 | 2021-12-04 | US | Virginia | York | 51199 | 5754 | 83 | 0 | 37.24374789 | -76.54412815 | 2021-12-05 04:22:25 | York, Virginia, US | |
2199118 | 2199118 | 2021-12-03 | US | West Virginia | Marshall | 54051 | 5754 | 122 | 0 | 39.86064362 | -80.66591062 | 2021-12-04 04:22:18 | Marshall, West Virginia, US | |
2199053 | 2199053 | 2021-12-03 | US | Virginia | York | 51199 | 5754 | 83 | 0 | 37.24374789 | -76.54412815 | 2021-12-04 04:22:18 | York, Virginia, US | |
2846308 | 2846308 | 2021-11-10 | US | Kentucky | Muhlenberg | 21177 | 5754 | 93 | 0 | 37.21425819 | -87.14632053 | 2021-11-11 04:21:45 | Muhlenberg, Kentucky, US | |
3641338 | 3641338 | 2021-11-08 | US | Mississippi | Alcorn | 28003 | 5754 | 104 | 0 | 34.88084463 | -88.57996173 | 2021-11-09 04:21:36 | Alcorn, Mississippi, US | |
495683 | 495683 | 2021-11-06 | Japan | Yamaguchi | 5754 | 93 | 0 | 34.201190000000004 | 131.573293 | 2021-11-07 04:21:53 | Yamaguchi, Japan | |||
699979 | 699979 | 2021-11-04 | US | Maryland | Calvert | 24009 | 5754 | 101 | 0 | 38.53961642 | -76.56820632 | 2021-11-05 04:21:54 | Calvert, Maryland, US | |
3513770 | 3513770 | 2021-11-01 | US | North Carolina | Scotland | 37165 | 5754 | 107 | 0 | 34.8386299 | -79.4757978 | 2021-11-02 04:22:03 | Scotland, North Carolina, US | |
3794426 | 3794426 | 2021-10-25 | US | Arkansas | Union | 5139 | 5754 | 137 | 0 | 33.16887091 | -92.59746952 | 2021-10-26 04:22:09 | Union, Arkansas, US | |
2944486 | 2944486 | 2021-10-15 | US | Indiana | Putnam | 18133 | 5754 | 77 | 0 | 39.66437981 | -86.84517605 | 2021-10-16 04:21:15 | Putnam, Indiana, US | |
3834434 | 3834434 | 2021-10-05 | US | Missouri | Platte | 29165 | 5754 | 59 | 0 | 39.38154439 | -94.77068479 | 2021-10-06 04:21:33 | Platte, Missouri, US | |
2776024 | 2776024 | 2021-09-30 | US | Texas | Cherokee | 48073 | 5754 | 189 | 0 | 31.837258000000002 | -95.16559897 | 2021-10-01 04:21:35 | Cherokee, Texas, US | |
1815890 | 1815890 | 2021-09-19 | US | Indiana | Montgomery | 18107 | 5754 | 102 | 0 | 40.04034823 | -86.89335024 | 2021-09-20 04:21:22 | Montgomery, Indiana, US | |
2811913 | 2811913 | 2021-09-16 | US | Texas | Matagorda | 48321 | 5754 | 137 | 0 | 28.81955746 | -96.01230294 | 2021-09-17 04:21:46 | Matagorda, Texas, US | |
1888564 | 1888564 | 2021-09-12 | US | Wisconsin | Oconto | 55083 | 5754 | 75 | 0 | 45.02715345 | -88.26807503 | 2021-09-13 04:21:15 | Oconto, Wisconsin, US | |
3809467 | 3809467 | 2021-09-11 | US | Wisconsin | Oconto | 55083 | 5754 | 75 | 0 | 45.02715345 | -88.26807503 | 2021-09-12 04:21:13 | Oconto, Wisconsin, US | |
3452407 | 3452407 | 2021-09-10 | US | Wisconsin | Oconto | 55083 | 5754 | 75 | 0 | 45.02715345 | -88.26807503 | 2021-09-11 04:21:30 | Oconto, Wisconsin, US | |
1265026 | 1265026 | 2021-09-09 | US | New York | Herkimer | 36043 | 5754 | 113 | 0 | 43.42034246 | -74.96145307 | 2021-09-10 04:21:20 | Herkimer, New York, US | |
644899 | 644899 | 2021-09-07 | US | Tennessee | Lincoln | 47103 | 5754 | 75 | 0 | 35.13738622 | -86.58910106 | 2021-09-08 04:21:31 | Lincoln, Tennessee, US | |
644313 | 644313 | 2021-09-07 | US | North Carolina | Watauga | 37189 | 5754 | 34 | 0 | 36.23103603 | -81.70033724 | 2021-09-08 04:21:31 | Watauga, North Carolina, US | |
3283279 | 3283279 | 2021-09-05 | US | North Dakota | Morton | 38059 | 5754 | 102 | 0 | 46.71681782 | -101.2822377 | 2021-09-06 04:21:22 | Morton, North Dakota, US | |
3976798 | 3976798 | 2021-09-03 | US | New York | Genesee | 36037 | 5754 | 125 | 0 | 43.0022601 | -78.19135193 | 2021-09-04 04:21:28 | Genesee, New York, US | |
1599055 | 1599055 | 2021-08-26 | US | South Dakota | Brown | 46013 | 5754 | 95 | 0 | 45.58994323 | -98.35165355 | 2021-08-27 04:21:37 | Brown, South Dakota, 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]);