johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
231 rows where confirmed = 2762 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1076104 | 1076104 | 2022-12-28 | US | New Mexico | Colfax | 35007 | 2762 | 68 | 0 | 36.60569702 | -104.6472674 | 2022-12-29 04:21:01 | Colfax, New Mexico, US | |
330101 | 330101 | 2022-12-27 | US | New Mexico | Colfax | 35007 | 2762 | 68 | 0 | 36.60569702 | -104.6472674 | 2022-12-28 04:21:04 | Colfax, New Mexico, US | |
2952235 | 2952235 | 2022-12-20 | US | Georgia | McIntosh | 13191 | 2762 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-12-21 04:21:03 | McIntosh, Georgia, US | |
3174637 | 3174637 | 2022-12-19 | US | Georgia | McIntosh | 13191 | 2762 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-12-20 04:21:04 | McIntosh, Georgia, US | |
1629154 | 1629154 | 2022-12-18 | US | Georgia | McIntosh | 13191 | 2762 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-12-19 04:21:03 | McIntosh, Georgia, US | |
504533 | 504533 | 2022-12-17 | US | Georgia | McIntosh | 13191 | 2762 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-12-18 04:21:03 | McIntosh, Georgia, US | |
3325105 | 3325105 | 2022-12-16 | US | Georgia | McIntosh | 13191 | 2762 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-12-17 04:21:04 | McIntosh, Georgia, US | |
543617 | 543617 | 2022-12-15 | US | Georgia | McIntosh | 13191 | 2762 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-12-16 04:21:01 | McIntosh, Georgia, US | |
349145 | 349145 | 2022-12-14 | US | Georgia | McIntosh | 13191 | 2762 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-12-15 04:20:58 | McIntosh, Georgia, US | |
311271 | 311271 | 2022-12-13 | US | Virginia | Northampton | 51131 | 2762 | 74 | 0 | 37.34062933 | -75.87751591 | 2022-12-14 04:21:04 | Northampton, Virginia, US | |
2560009 | 2560009 | 2022-11-29 | US | Virginia | Sussex | 51183 | 2762 | 45 | 0 | 36.92432914 | -77.25791182 | 2022-11-30 04:21:07 | Sussex, Virginia, US | |
118153 | 118153 | 2022-09-06 | US | Virginia | Richmond | 51159 | 2762 | 26 | 0 | 37.937575 | -76.72920628 | 2022-09-07 04:20:59 | Richmond, Virginia, US | |
2637125 | 2637125 | 2022-09-05 | US | Virginia | Richmond | 51159 | 2762 | 26 | 0 | 37.937575 | -76.72920628 | 2022-09-06 04:21:02 | Richmond, Virginia, US | |
2990689 | 2990689 | 2022-09-04 | US | Virginia | Richmond | 51159 | 2762 | 26 | 0 | 37.937575 | -76.72920628 | 2022-09-05 04:21:01 | Richmond, Virginia, US | |
2716374 | 2716374 | 2022-09-03 | US | Virginia | Richmond | 51159 | 2762 | 26 | 0 | 37.937575 | -76.72920628 | 2022-09-04 04:21:22 | Richmond, Virginia, US | |
1397079 | 1397079 | 2022-09-02 | US | Virginia | Richmond | 51159 | 2762 | 26 | 0 | 37.937575 | -76.72920628 | 2022-09-03 04:21:04 | Richmond, Virginia, US | |
2326862 | 2326862 | 2022-08-24 | US | West Virginia | Ritchie | 54085 | 2762 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-08-25 04:21:13 | Ritchie, West Virginia, US | |
1349063 | 1349063 | 2022-08-10 | US | Puerto Rico | Guanica | 72055 | 2762 | 0 | 0 | 17.982429 | -66.919643 | 2022-08-11 04:20:49 | Guanica, Puerto Rico, US | |
1070972 | 1070972 | 2022-08-07 | US | Indiana | Crawford | 18025 | 2762 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-08-08 04:21:08 | Crawford, Indiana, US | |
1941560 | 1941560 | 2022-08-06 | US | Indiana | Crawford | 18025 | 2762 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-08-07 04:20:54 | Crawford, Indiana, US | |
881359 | 881359 | 2022-08-05 | US | Indiana | Crawford | 18025 | 2762 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-08-06 04:20:56 | Crawford, Indiana, US | |
633247 | 633247 | 2022-07-12 | US | Virginia | Floyd | 51063 | 2762 | 49 | 0 | 36.9302126 | -80.36738849 | 2022-07-13 04:20:58 | Floyd, Virginia, US | |
1200809 | 1200809 | 2022-07-06 | US | Illinois | Jasper | 17079 | 2762 | 31 | 0 | 39.01054275 | -88.15437049 | 2022-07-07 04:20:55 | Jasper, Illinois, US | |
167286 | 167286 | 2022-06-21 | US | Iowa | Shelby | 19165 | 2762 | 51 | 0 | 41.6850066 | -95.31015553 | 2022-06-22 04:20:54 | Shelby, Iowa, US | |
1764569 | 1764569 | 2022-06-20 | US | Iowa | Shelby | 19165 | 2762 | 51 | 0 | 41.6850066 | -95.31015553 | 2022-06-21 04:20:56 | Shelby, Iowa, US | |
3270755 | 3270755 | 2022-06-19 | US | Iowa | Shelby | 19165 | 2762 | 51 | 0 | 41.6850066 | -95.31015553 | 2022-06-20 04:21:01 | Shelby, Iowa, US | |
3398667 | 3398667 | 2022-06-18 | US | Iowa | Shelby | 19165 | 2762 | 51 | 0 | 41.6850066 | -95.31015553 | 2022-06-19 04:20:51 | Shelby, Iowa, US | |
2312544 | 2312544 | 2022-06-17 | US | Iowa | Shelby | 19165 | 2762 | 51 | 0 | 41.6850066 | -95.31015553 | 2022-06-18 04:21:10 | Shelby, Iowa, US | |
560048 | 560048 | 2022-06-16 | US | Iowa | Shelby | 19165 | 2762 | 51 | 0 | 41.6850066 | -95.31015553 | 2022-06-17 04:20:56 | Shelby, Iowa, US | |
3983850 | 3983850 | 2022-06-15 | US | Iowa | Shelby | 19165 | 2762 | 51 | 0 | 41.6850066 | -95.31015553 | 2022-06-16 04:20:55 | Shelby, Iowa, US | |
3726102 | 3726102 | 2022-06-07 | France | Saint Pierre and Miquelon | 2762 | 1 | 0 | 46.8852 | -56.3159 | 2022-06-08 04:20:55 | Saint Pierre and Miquelon, France | |||
3508345 | 3508345 | 2022-06-05 | US | Idaho | Shoshone | 16079 | 2762 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-06-06 04:20:57 | Shoshone, Idaho, US | |
3528422 | 3528422 | 2022-06-04 | US | Idaho | Shoshone | 16079 | 2762 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-06-05 04:20:55 | Shoshone, Idaho, US | |
3134508 | 3134508 | 2022-06-03 | US | Idaho | Shoshone | 16079 | 2762 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-06-04 04:20:58 | Shoshone, Idaho, US | |
1540978 | 1540978 | 2022-03-31 | US | Illinois | Marshall | 17123 | 2762 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-04-01 04:20:28 | Marshall, Illinois, US | |
1540796 | 1540796 | 2022-03-31 | US | Georgia | Long | 13183 | 2762 | 34 | 0 | 31.75218791 | -81.74952375 | 2022-04-01 04:20:28 | Long, Georgia, US | |
2478991 | 2478991 | 2022-03-30 | US | Illinois | Marshall | 17123 | 2762 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-03-31 04:20:56 | Marshall, Illinois, US | |
2202709 | 2202709 | 2022-03-06 | US | Texas | Dawson | 48115 | 2762 | 93 | 0 | 32.74255572 | -101.94772420000001 | 2022-03-07 04:20:47 | Dawson, Texas, US | |
2095166 | 2095166 | 2022-03-05 | US | Texas | Dawson | 48115 | 2762 | 93 | 0 | 32.74255572 | -101.94772420000001 | 2022-03-06 04:20:49 | Dawson, Texas, US | |
1647171 | 1647171 | 2022-03-03 | US | South Carolina | Calhoun | 45017 | 2762 | 58 | 0 | 33.66926881 | -80.77722168 | 2022-03-04 04:21:09 | Calhoun, South Carolina, US | |
2528174 | 2528174 | 2022-03-02 | US | South Carolina | Calhoun | 45017 | 2762 | 58 | 0 | 33.66926881 | -80.77722168 | 2022-03-03 04:21:01 | Calhoun, South Carolina, US | |
945874 | 945874 | 2022-02-28 | US | Texas | Callahan | 48059 | 2762 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-03-01 04:21:09 | Callahan, Texas, US | |
3822311 | 3822311 | 2022-02-16 | US | Missouri | Barton | 29011 | 2762 | 48 | 0 | 37.50207671 | -94.34757022 | 2022-02-17 04:20:56 | Barton, Missouri, US | |
72641 | 72641 | 2022-02-07 | US | Louisiana | West Feliciana | 22125 | 2762 | 42 | 0 | 30.87882871 | -91.41485379999999 | 2022-02-08 04:21:15 | West Feliciana, Louisiana, US | |
2475711 | 2475711 | 2022-02-03 | US | Minnesota | Pope | 27121 | 2762 | 16 | 0 | 45.58606667 | -95.44451209 | 2022-02-04 04:21:10 | Pope, Minnesota, US | |
980202 | 980202 | 2022-02-01 | US | Iowa | Winnebago | 19189 | 2762 | 42 | 0 | 43.37751174 | -93.73407298 | 2022-02-02 04:21:09 | Winnebago, Iowa, US | |
2659044 | 2659044 | 2022-01-31 | US | Iowa | Winnebago | 19189 | 2762 | 42 | 0 | 43.37751174 | -93.73407298 | 2022-02-01 04:21:11 | Winnebago, Iowa, US | |
3301461 | 3301461 | 2022-01-30 | US | Iowa | Winnebago | 19189 | 2762 | 42 | 0 | 43.37751174 | -93.73407298 | 2022-01-31 04:21:09 | Winnebago, Iowa, US | |
3301148 | 3301148 | 2022-01-30 | US | Idaho | Idaho | 16049 | 2762 | 44 | 0 | 45.84721541 | -115.4634436 | 2022-01-31 04:21:09 | Idaho, Idaho, US | |
3063252 | 3063252 | 2022-01-29 | US | Iowa | Winnebago | 19189 | 2762 | 42 | 0 | 43.37751174 | -93.73407298 | 2022-01-30 04:21:26 | Winnebago, Iowa, US | |
3062939 | 3062939 | 2022-01-29 | US | Idaho | Idaho | 16049 | 2762 | 44 | 0 | 45.84721541 | -115.4634436 | 2022-01-30 04:21:26 | Idaho, Idaho, US | |
3811186 | 3811186 | 2022-01-28 | US | Iowa | Winnebago | 19189 | 2762 | 42 | 0 | 43.37751174 | -93.73407298 | 2022-01-29 04:21:10 | Winnebago, Iowa, US | |
1780640 | 1780640 | 2022-01-27 | US | Iowa | Winnebago | 19189 | 2762 | 42 | 0 | 43.37751174 | -93.73407298 | 2022-01-28 04:21:09 | Winnebago, Iowa, US | |
1319468 | 1319468 | 2022-01-26 | US | Iowa | Winnebago | 19189 | 2762 | 42 | 0 | 43.37751174 | -93.73407298 | 2022-01-27 04:21:19 | Winnebago, Iowa, US | |
1141559 | 1141559 | 2022-01-23 | US | Colorado | Park | 8093 | 2762 | 19 | 0 | 39.120926000000004 | -105.7182065 | 2022-01-24 04:21:12 | Park, Colorado, US | |
1475540 | 1475540 | 2022-01-17 | US | Virginia | Westmoreland | 51193 | 2762 | 39 | 0 | 38.11021557 | -76.80213247 | 2022-01-18 04:21:04 | Westmoreland, Virginia, US | |
1115016 | 1115016 | 2022-01-11 | US | Kentucky | Larue | 21123 | 2762 | 57 | 0 | 37.54567114 | -85.70138352 | 2022-01-12 04:21:44 | Larue, Kentucky, US | |
1114826 | 1114826 | 2022-01-11 | US | Iowa | Poweshiek | 19157 | 2762 | 50 | 0 | 41.68625425 | -92.53155731 | 2022-01-12 04:21:44 | Poweshiek, Iowa, US | |
1695662 | 1695662 | 2022-01-10 | US | Virginia | Giles | 51071 | 2762 | 38 | 0 | 37.31234791 | -80.70636931 | 2022-01-11 04:22:01 | Giles, Virginia, US | |
1694246 | 1694246 | 2022-01-10 | US | Missouri | Madison | 29123 | 2762 | 42 | 0 | 37.47865134 | -90.34671429999999 | 2022-01-11 04:22:01 | Madison, Missouri, US | |
1693554 | 1693554 | 2022-01-10 | US | Iowa | Poweshiek | 19157 | 2762 | 50 | 0 | 41.68625425 | -92.53155731 | 2022-01-11 04:22:01 | Poweshiek, Iowa, US | |
127969 | 127969 | 2022-01-09 | US | Iowa | Poweshiek | 19157 | 2762 | 50 | 0 | 41.68625425 | -92.53155731 | 2022-01-10 04:22:07 | Poweshiek, Iowa, US | |
1216804 | 1216804 | 2022-01-08 | US | Iowa | Poweshiek | 19157 | 2762 | 50 | 0 | 41.68625425 | -92.53155731 | 2022-01-09 04:21:46 | Poweshiek, Iowa, US | |
1215373 | 1215373 | 2022-01-08 | China | Shaanxi | 2762 | 3 | 0 | 35.1917 | 108.8701 | 2022-01-09 04:21:46 | Shaanxi, China | |||
1390897 | 1390897 | 2022-01-07 | US | Iowa | Poweshiek | 19157 | 2762 | 50 | 0 | 41.68625425 | -92.53155731 | 2022-01-08 04:21:53 | Poweshiek, Iowa, US | |
2611284 | 2611284 | 2022-01-06 | US | Iowa | Poweshiek | 19157 | 2762 | 50 | 0 | 41.68625425 | -92.53155731 | 2022-01-07 04:22:09 | Poweshiek, Iowa, US | |
1283226 | 1283226 | 2022-01-05 | US | Iowa | Poweshiek | 19157 | 2762 | 50 | 0 | 41.68625425 | -92.53155731 | 2022-01-06 04:22:09 | Poweshiek, Iowa, US | |
1701370 | 1701370 | 2022-01-03 | US | Illinois | Mason | 17125 | 2762 | 53 | 0 | 40.23917274 | -89.91824452 | 2022-01-04 04:22:17 | Mason, Illinois, US | |
3830279 | 3830279 | 2021-12-21 | US | Mississippi | Holmes | 28051 | 2762 | 89 | 0 | 33.12345854 | -90.08923538 | 2021-12-22 04:21:54 | Holmes, Mississippi, US | |
1256582 | 1256582 | 2021-12-20 | US | Mississippi | Holmes | 28051 | 2762 | 89 | 0 | 33.12345854 | -90.08923538 | 2021-12-21 03:21:27 | Holmes, Mississippi, US | |
2401532 | 2401532 | 2021-12-17 | US | Puerto Rico | Aguadilla | 72005 | 2762 | 0 | 0 | 18.459681 | -67.12081500000001 | 2021-12-18 02:22:20 | Aguadilla, Puerto Rico, US | |
1717358 | 1717358 | 2021-12-16 | US | Illinois | Jo Daviess | 17085 | 2762 | 31 | 0 | 42.36542373 | -90.21094405 | 2021-12-17 04:22:14 | Jo Daviess, Illinois, US | |
3498206 | 3498206 | 2021-12-15 | US | Montana | Park | 30067 | 2762 | 30 | 0 | 45.48965095 | -110.52643940000002 | 2021-12-16 04:22:11 | Park, Montana, US | |
1079098 | 1079098 | 2021-12-09 | US | Iowa | Cedar | 19031 | 2762 | 27 | 0 | 41.77233777 | -91.13246684 | 2021-12-10 04:22:28 | Cedar, Iowa, US | |
551947 | 551947 | 2021-12-08 | US | Iowa | Cedar | 19031 | 2762 | 27 | 0 | 41.77233777 | -91.13246684 | 2021-12-09 04:22:49 | Cedar, Iowa, US | |
551761 | 551761 | 2021-12-08 | US | Illinois | Ford | 17053 | 2762 | 59 | 0 | 40.59706922 | -88.22350769 | 2021-12-09 04:22:49 | Ford, Illinois, US | |
1742522 | 1742522 | 2021-12-05 | US | Missouri | Wright | 29229 | 2762 | 64 | 0 | 37.27029221 | -92.46914488 | 2021-12-06 04:22:34 | Wright, Missouri, US | |
3072767 | 3072767 | 2021-11-23 | US | Puerto Rico | Dorado | 72051 | 2762 | 0 | 0 | 18.436115 | -66.278669 | 2021-11-24 04:22:14 | Dorado, Puerto Rico, US | |
3751865 | 3751865 | 2021-11-22 | US | Puerto Rico | Dorado | 72051 | 2762 | 0 | 0 | 18.436115 | -66.278669 | 2021-11-23 04:22:39 | Dorado, Puerto Rico, US | |
1014531 | 1014531 | 2021-11-21 | Russia | Chukotka Autonomous Okrug | 2762 | 23 | 0 | 66.0006475 | 169.4900869 | 2021-11-22 04:22:20 | Chukotka Autonomous Okrug, Russia | |||
3291338 | 3291338 | 2021-11-18 | US | North Dakota | Richland | 38077 | 2762 | 21 | 0 | 46.26440649 | -96.94852979 | 2021-11-19 04:21:40 | Richland, North Dakota, US | |
2288209 | 2288209 | 2021-11-15 | US | Georgia | Banks | 13011 | 2762 | 64 | 0 | 34.35607081 | -83.49644388 | 2021-11-16 04:21:10 | Banks, Georgia, US | |
715538 | 715538 | 2021-11-12 | US | Indiana | Carroll | 18015 | 2762 | 36 | 0 | 40.580783200000006 | -86.56198812 | 2021-11-13 04:21:38 | Carroll, Indiana, US | |
715065 | 715065 | 2021-11-12 | US | Colorado | Alamosa | 8003 | 2762 | 48 | 0 | 37.57250606 | -105.7885451 | 2021-11-13 04:21:38 | Alamosa, Colorado, US | |
278472 | 278472 | 2021-11-03 | US | North Carolina | Avery | 37011 | 2762 | 38 | 0 | 36.07569796 | -81.92308483 | 2021-11-04 04:22:20 | Avery, North Carolina, US | |
3794832 | 3794832 | 2021-10-25 | US | Idaho | Gem | 16045 | 2762 | 57 | 0 | 44.06482372 | -116.398376 | 2021-10-26 04:22:09 | Gem, Idaho, US | |
685771 | 685771 | 2021-10-24 | US | Washington | Asotin | 53003 | 2762 | 50 | 0 | 46.18894415 | -117.2022851 | 2021-10-25 04:22:31 | Asotin, Washington, US | |
773779 | 773779 | 2021-10-23 | US | Washington | Asotin | 53003 | 2762 | 50 | 0 | 46.18894415 | -117.2022851 | 2021-10-24 04:21:22 | Asotin, Washington, US | |
657426 | 657426 | 2021-10-22 | US | Washington | Asotin | 53003 | 2762 | 50 | 0 | 46.18894415 | -117.2022851 | 2021-10-23 04:21:32 | Asotin, Washington, US | |
1493801 | 1493801 | 2021-10-12 | US | New Mexico | Lincoln | 35027 | 2762 | 29 | 0 | 33.74526079 | -105.4586166 | 2021-10-13 04:20:51 | Lincoln, New Mexico, US | |
3008375 | 3008375 | 2021-10-11 | US | Illinois | Richland | 17159 | 2762 | 57 | 0 | 38.71240969 | -88.08475366 | 2021-10-12 04:21:09 | Richland, Illinois, US | |
3007993 | 3007993 | 2021-10-11 | US | Colorado | Teller | 8119 | 2762 | 34 | 0 | 38.88133511 | -105.16148929999999 | 2021-10-12 04:21:09 | Teller, Colorado, US | |
424391 | 424391 | 2021-10-10 | US | Illinois | Richland | 17159 | 2762 | 57 | 0 | 38.71240969 | -88.08475366 | 2021-10-11 04:21:31 | Richland, Illinois, US | |
2877248 | 2877248 | 2021-10-09 | US | Illinois | Richland | 17159 | 2762 | 57 | 0 | 38.71240969 | -88.08475366 | 2021-10-10 04:21:38 | Richland, Illinois, US | |
2960414 | 2960414 | 2021-10-08 | US | Illinois | Richland | 17159 | 2762 | 57 | 0 | 38.71240969 | -88.08475366 | 2021-10-09 04:21:34 | Richland, Illinois, US | |
990258 | 990258 | 2021-10-04 | US | Vermont | Bennington | 50003 | 2762 | 22 | 0 | 43.03519828 | -73.09048868 | 2021-10-05 04:21:27 | Bennington, Vermont, US | |
707885 | 707885 | 2021-09-29 | US | Kentucky | Morgan | 21175 | 2762 | 6 | 0 | 37.92465657 | -83.25558245 | 2021-09-30 04:21:20 | Morgan, Kentucky, US | |
1337834 | 1337834 | 2021-09-28 | US | Wisconsin | Langlade | 55067 | 2762 | 54 | 0 | 45.26271619 | -89.07483625 | 2021-09-29 04:21:45 | Langlade, Wisconsin, US | |
3012455 | 3012455 | 2021-09-22 | US | Indiana | Orange | 18117 | 2762 | 59 | 0 | 38.54118920000001 | -86.49523093 | 2021-09-23 04:21:43 | Orange, Indiana, US | |
19343 | 19343 | 2021-09-18 | US | Tennessee | Sequatchie | 47153 | 2762 | 30 | 0 | 35.36979721 | -85.41022136 | 2021-09-19 04:21:34 | Sequatchie, Tennessee, 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]);