johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
292 rows where confirmed = 2475 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
221490 | 221490 | 2022-12-26 | US | West Virginia | Pleasants | 54073 | 2475 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-12-27 04:21:07 | Pleasants, West Virginia, US | |
3225947 | 3225947 | 2022-12-25 | US | West Virginia | Pleasants | 54073 | 2475 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-12-26 04:21:06 | Pleasants, West Virginia, US | |
1021861 | 1021861 | 2022-12-24 | US | West Virginia | Pleasants | 54073 | 2475 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-12-25 04:21:04 | Pleasants, West Virginia, US | |
693884 | 693884 | 2022-12-23 | US | West Virginia | Pleasants | 54073 | 2475 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-12-24 04:21:02 | Pleasants, West Virginia, US | |
2183094 | 2183094 | 2022-12-22 | US | West Virginia | Pleasants | 54073 | 2475 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-12-23 04:21:04 | Pleasants, West Virginia, US | |
3551463 | 3551463 | 2022-11-27 | China | Xinjiang | 2475 | 3 | 0 | 41.1129 | 85.2401 | 2022-11-28 04:21:02 | Xinjiang, China | |||
292837 | 292837 | 2022-11-15 | US | Georgia | Heard | 13149 | 2475 | 60 | 0 | 33.29686567 | -85.12886832 | 2022-11-16 04:21:09 | Heard, Georgia, US | |
3597867 | 3597867 | 2022-11-14 | US | Georgia | Heard | 13149 | 2475 | 60 | 0 | 33.29686567 | -85.12886832 | 2022-11-15 04:21:16 | Heard, Georgia, US | |
312725 | 312725 | 2022-11-13 | US | Georgia | Heard | 13149 | 2475 | 60 | 0 | 33.29686567 | -85.12886832 | 2022-11-14 04:21:09 | Heard, Georgia, US | |
63886 | 63886 | 2022-11-12 | US | Georgia | Heard | 13149 | 2475 | 60 | 0 | 33.29686567 | -85.12886832 | 2022-11-13 04:21:14 | Heard, Georgia, US | |
2928048 | 2928048 | 2022-11-11 | US | Georgia | Heard | 13149 | 2475 | 60 | 0 | 33.29686567 | -85.12886832 | 2022-11-12 04:20:41 | Heard, Georgia, US | |
2506884 | 2506884 | 2022-11-10 | US | Georgia | Heard | 13149 | 2475 | 60 | 0 | 33.29686567 | -85.12886832 | 2022-11-11 04:21:22 | Heard, Georgia, US | |
2432757 | 2432757 | 2022-11-09 | US | Mississippi | Kemper | 28069 | 2475 | 51 | 0 | 32.75462946 | -88.64105766 | 2022-11-10 04:21:16 | Kemper, Mississippi, US | |
2431759 | 2431759 | 2022-11-09 | US | Georgia | Heard | 13149 | 2475 | 60 | 0 | 33.29686567 | -85.12886832 | 2022-11-10 04:21:16 | Heard, Georgia, US | |
481413 | 481413 | 2022-11-08 | US | Mississippi | Kemper | 28069 | 2475 | 51 | 0 | 32.75462946 | -88.64105766 | 2022-11-09 04:21:22 | Kemper, Mississippi, US | |
2440563 | 2440563 | 2022-11-07 | US | Mississippi | Kemper | 28069 | 2475 | 51 | 0 | 32.75462946 | -88.64105766 | 2022-11-08 04:21:21 | Kemper, Mississippi, US | |
1051661 | 1051661 | 2022-11-06 | US | Mississippi | Kemper | 28069 | 2475 | 51 | 0 | 32.75462946 | -88.64105766 | 2022-11-07 04:21:26 | Kemper, Mississippi, US | |
619685 | 619685 | 2022-11-05 | US | Mississippi | Kemper | 28069 | 2475 | 51 | 0 | 32.75462946 | -88.64105766 | 2022-11-06 04:21:24 | Kemper, Mississippi, US | |
1024189 | 1024189 | 2022-11-04 | US | Mississippi | Kemper | 28069 | 2475 | 51 | 0 | 32.75462946 | -88.64105766 | 2022-11-05 04:21:52 | Kemper, Mississippi, US | |
433180 | 433180 | 2022-11-03 | US | Mississippi | Kemper | 28069 | 2475 | 51 | 0 | 32.75462946 | -88.64105766 | 2022-11-04 04:22:11 | Kemper, Mississippi, US | |
852551 | 852551 | 2022-11-02 | US | Tennessee | Hancock | 47067 | 2475 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-11-03 04:22:05 | Hancock, Tennessee, US | |
851422 | 851422 | 2022-11-02 | US | Mississippi | Kemper | 28069 | 2475 | 51 | 0 | 32.75462946 | -88.64105766 | 2022-11-03 04:22:05 | Kemper, Mississippi, US | |
851337 | 851337 | 2022-11-02 | US | Minnesota | Lake | 27075 | 2475 | 32 | 0 | 47.64270764 | -91.44557998 | 2022-11-03 04:22:05 | Lake, Minnesota, US | |
712249 | 712249 | 2022-11-01 | US | Mississippi | Claiborne | 28021 | 2475 | 49 | 0 | 31.97061673 | -90.90702196 | 2022-11-02 04:22:09 | Claiborne, Mississippi, US | |
712188 | 712188 | 2022-11-01 | US | Minnesota | Lake | 27075 | 2475 | 32 | 0 | 47.64270764 | -91.44557998 | 2022-11-02 04:22:09 | Lake, Minnesota, US | |
3288384 | 3288384 | 2022-10-31 | US | West Virginia | Gilmer | 54021 | 2475 | 22 | 0 | 38.9251277 | -80.85952723 | 2022-11-01 04:22:36 | Gilmer, West Virginia, US | |
3286698 | 3286698 | 2022-10-31 | US | Mississippi | Claiborne | 28021 | 2475 | 49 | 0 | 31.97061673 | -90.90702196 | 2022-11-01 04:22:36 | Claiborne, Mississippi, US | |
3286637 | 3286637 | 2022-10-31 | US | Minnesota | Lake | 27075 | 2475 | 32 | 0 | 47.64270764 | -91.44557998 | 2022-11-01 04:22:36 | Lake, Minnesota, US | |
321731 | 321731 | 2022-10-30 | US | Mississippi | Claiborne | 28021 | 2475 | 49 | 0 | 31.97061673 | -90.90702196 | 2022-10-31 04:21:36 | Claiborne, Mississippi, US | |
321670 | 321670 | 2022-10-30 | US | Minnesota | Lake | 27075 | 2475 | 32 | 0 | 47.64270764 | -91.44557998 | 2022-10-31 04:21:36 | Lake, Minnesota, US | |
914007 | 914007 | 2022-10-29 | US | Mississippi | Claiborne | 28021 | 2475 | 49 | 0 | 31.97061673 | -90.90702196 | 2022-10-30 04:22:14 | Claiborne, Mississippi, US | |
913946 | 913946 | 2022-10-29 | US | Minnesota | Lake | 27075 | 2475 | 32 | 0 | 47.64270764 | -91.44557998 | 2022-10-30 04:22:14 | Lake, Minnesota, US | |
1368276 | 1368276 | 2022-10-28 | US | Mississippi | Claiborne | 28021 | 2475 | 49 | 0 | 31.97061673 | -90.90702196 | 2022-10-29 04:21:13 | Claiborne, Mississippi, US | |
1368215 | 1368215 | 2022-10-28 | US | Minnesota | Lake | 27075 | 2475 | 32 | 0 | 47.64270764 | -91.44557998 | 2022-10-29 04:21:13 | Lake, Minnesota, US | |
3040131 | 3040131 | 2022-10-27 | US | Mississippi | Claiborne | 28021 | 2475 | 49 | 0 | 31.97061673 | -90.90702196 | 2022-10-28 04:22:31 | Claiborne, Mississippi, US | |
3040070 | 3040070 | 2022-10-27 | US | Minnesota | Lake | 27075 | 2475 | 32 | 0 | 47.64270764 | -91.44557998 | 2022-10-28 04:22:31 | Lake, Minnesota, US | |
540551 | 540551 | 2022-10-26 | US | Mississippi | Claiborne | 28021 | 2475 | 49 | 0 | 31.97061673 | -90.90702196 | 2022-10-27 04:22:01 | Claiborne, Mississippi, US | |
3769264 | 3769264 | 2022-09-11 | US | Virginia | Northumberland | 51133 | 2475 | 43 | 0 | 37.89202088 | -76.41949732 | 2022-09-12 04:20:58 | Northumberland, Virginia, US | |
3827839 | 3827839 | 2022-09-10 | US | Virginia | Northumberland | 51133 | 2475 | 43 | 0 | 37.89202088 | -76.41949732 | 2022-09-11 04:20:50 | Northumberland, Virginia, US | |
966296 | 966296 | 2022-09-09 | US | Virginia | Northumberland | 51133 | 2475 | 43 | 0 | 37.89202088 | -76.41949732 | 2022-09-10 04:21:10 | Northumberland, Virginia, US | |
117638 | 117638 | 2022-09-06 | US | South Dakota | Lake | 46079 | 2475 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-09-07 04:20:59 | Lake, South Dakota, US | |
2636610 | 2636610 | 2022-09-05 | US | South Dakota | Lake | 46079 | 2475 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-09-06 04:21:02 | Lake, South Dakota, US | |
2990174 | 2990174 | 2022-09-04 | US | South Dakota | Lake | 46079 | 2475 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-09-05 04:21:01 | Lake, South Dakota, US | |
2715859 | 2715859 | 2022-09-03 | US | South Dakota | Lake | 46079 | 2475 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-09-04 04:21:22 | Lake, South Dakota, US | |
1396564 | 1396564 | 2022-09-02 | US | South Dakota | Lake | 46079 | 2475 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-09-03 04:21:04 | Lake, South Dakota, US | |
3550393 | 3550393 | 2022-09-01 | US | South Dakota | Lake | 46079 | 2475 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-09-02 04:21:07 | Lake, South Dakota, US | |
2346313 | 2346313 | 2022-08-31 | US | South Dakota | Lake | 46079 | 2475 | 28 | 0 | 44.02193107 | -97.12926365 | 2022-09-01 04:21:03 | Lake, South Dakota, US | |
3774813 | 3774813 | 2022-08-30 | US | Georgia | Wilkes | 13317 | 2475 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-08-31 04:20:57 | Wilkes, Georgia, US | |
1681409 | 1681409 | 2022-08-29 | US | Georgia | Wilkes | 13317 | 2475 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-08-30 04:21:03 | Wilkes, Georgia, US | |
1877893 | 1877893 | 2022-08-28 | US | Georgia | Wilkes | 13317 | 2475 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-08-29 04:21:06 | Wilkes, Georgia, US | |
2097020 | 2097020 | 2022-08-27 | US | Georgia | Wilkes | 13317 | 2475 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-08-28 04:21:02 | Wilkes, Georgia, US | |
1532835 | 1532835 | 2022-08-26 | US | Georgia | Wilkes | 13317 | 2475 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-08-27 04:20:57 | Wilkes, Georgia, US | |
1532404 | 1532404 | 2022-08-26 | US | Arkansas | Cleveland | 5025 | 2475 | 39 | 0 | 33.89723187 | -92.18537045 | 2022-08-27 04:20:57 | Cleveland, Arkansas, US | |
2829722 | 2829722 | 2022-08-25 | US | Georgia | Wilkes | 13317 | 2475 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-08-26 04:21:02 | Wilkes, Georgia, US | |
2324255 | 2324255 | 2022-08-24 | US | Georgia | Wilkes | 13317 | 2475 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-08-25 04:21:13 | Wilkes, Georgia, US | |
991932 | 991932 | 2022-08-16 | US | Idaho | Franklin | 16041 | 2475 | 30 | 0 | 42.18332217 | -111.8149666 | 2022-08-17 04:20:59 | Franklin, Idaho, US | |
2494971 | 2494971 | 2022-08-15 | US | Idaho | Franklin | 16041 | 2475 | 30 | 0 | 42.18332217 | -111.8149666 | 2022-08-16 04:20:58 | Franklin, Idaho, US | |
3874712 | 3874712 | 2022-07-31 | US | Texas | La Salle | 48283 | 2475 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-08-01 04:21:03 | La Salle, Texas, US | |
677466 | 677466 | 2022-07-30 | US | Texas | La Salle | 48283 | 2475 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-07-31 04:21:02 | La Salle, Texas, US | |
1786665 | 1786665 | 2022-07-29 | US | Texas | La Salle | 48283 | 2475 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-07-30 04:20:42 | La Salle, Texas, US | |
1069028 | 1069028 | 2022-07-28 | US | Texas | La Salle | 48283 | 2475 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-07-29 04:20:45 | La Salle, Texas, US | |
2338547 | 2338547 | 2022-07-27 | US | Texas | La Salle | 48283 | 2475 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-07-28 04:20:56 | La Salle, Texas, US | |
959689 | 959689 | 2022-07-19 | US | Georgia | Dooly | 13093 | 2475 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-20 04:20:59 | Dooly, Georgia, US | |
3211076 | 3211076 | 2022-07-18 | US | Georgia | Dooly | 13093 | 2475 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-19 04:20:58 | Dooly, Georgia, US | |
3406251 | 3406251 | 2022-07-17 | US | Georgia | Dooly | 13093 | 2475 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-18 04:20:59 | Dooly, Georgia, US | |
2152451 | 2152451 | 2022-07-16 | US | Georgia | Dooly | 13093 | 2475 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-17 04:21:15 | Dooly, Georgia, US | |
2419684 | 2419684 | 2022-07-15 | US | Georgia | Dooly | 13093 | 2475 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-16 04:21:05 | Dooly, Georgia, US | |
3429759 | 3429759 | 2022-07-14 | US | Georgia | Dooly | 13093 | 2475 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-15 04:20:53 | Dooly, Georgia, US | |
3110279 | 3110279 | 2022-07-13 | US | Georgia | Dooly | 13093 | 2475 | 69 | 0 | 32.15630737 | -83.79746561 | 2022-07-14 04:20:57 | Dooly, Georgia, US | |
1214743 | 1214743 | 2022-07-11 | US | Texas | Ochiltree | 48357 | 2475 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-07-12 04:20:51 | Ochiltree, Texas, US | |
2792225 | 2792225 | 2022-07-10 | US | Texas | Ochiltree | 48357 | 2475 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-07-11 04:20:46 | Ochiltree, Texas, US | |
3161055 | 3161055 | 2022-06-09 | US | Virginia | Sussex | 51183 | 2475 | 42 | 0 | 36.92432914 | -77.25791182 | 2022-06-10 04:20:55 | Sussex, Virginia, US | |
3596398 | 3596398 | 2022-05-23 | US | Virginia | Madison | 51113 | 2475 | 41 | 0 | 38.41531222 | -78.28220331 | 2022-05-24 04:20:57 | Madison, Virginia, US | |
3586156 | 3586156 | 2022-05-17 | US | West Virginia | Ritchie | 54085 | 2475 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-05-18 04:20:50 | Ritchie, West Virginia, US | |
3868761 | 3868761 | 2022-04-05 | US | Iowa | Louisa | 19115 | 2475 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-04-06 04:20:49 | Louisa, Iowa, US | |
2750103 | 2750103 | 2022-04-04 | US | Iowa | Louisa | 19115 | 2475 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-04-05 04:20:48 | Louisa, Iowa, US | |
3731644 | 3731644 | 2022-04-03 | US | Kentucky | Hancock | 21091 | 2475 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-04-04 04:20:51 | Hancock, Kentucky, US | |
3731449 | 3731449 | 2022-04-03 | US | Iowa | Louisa | 19115 | 2475 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-04-04 04:20:51 | Louisa, Iowa, US | |
501079 | 501079 | 2022-04-02 | US | Kentucky | Hancock | 21091 | 2475 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-04-03 04:20:48 | Hancock, Kentucky, US | |
500884 | 500884 | 2022-04-02 | US | Iowa | Louisa | 19115 | 2475 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-04-03 04:20:48 | Louisa, Iowa, US | |
3352064 | 3352064 | 2022-04-01 | US | Kentucky | Hancock | 21091 | 2475 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-04-02 04:20:47 | Hancock, Kentucky, US | |
3351869 | 3351869 | 2022-04-01 | US | Iowa | Louisa | 19115 | 2475 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-04-02 04:20:47 | Louisa, Iowa, US | |
1541369 | 1541369 | 2022-03-31 | US | Kentucky | Hancock | 21091 | 2475 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-04-01 04:20:28 | Hancock, Kentucky, US | |
1541174 | 1541174 | 2022-03-31 | US | Iowa | Louisa | 19115 | 2475 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-04-01 04:20:28 | Louisa, Iowa, US | |
1541027 | 1541027 | 2022-03-31 | US | Indiana | Benton | 18007 | 2475 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-04-01 04:20:28 | Benton, Indiana, US | |
2479382 | 2479382 | 2022-03-30 | US | Kentucky | Hancock | 21091 | 2475 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-03-31 04:20:56 | Hancock, Kentucky, US | |
2479187 | 2479187 | 2022-03-30 | US | Iowa | Louisa | 19115 | 2475 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-03-31 04:20:56 | Louisa, Iowa, US | |
2479040 | 2479040 | 2022-03-30 | US | Indiana | Benton | 18007 | 2475 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-03-31 04:20:56 | Benton, Indiana, US | |
159423 | 159423 | 2022-03-29 | US | Kentucky | Hancock | 21091 | 2475 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-03-30 04:20:45 | Hancock, Kentucky, US | |
159081 | 159081 | 2022-03-29 | US | Indiana | Benton | 18007 | 2475 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-03-30 04:20:45 | Benton, Indiana, US | |
1437994 | 1437994 | 2022-03-28 | US | Kentucky | Hancock | 21091 | 2475 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-03-29 04:20:46 | Hancock, Kentucky, US | |
1437652 | 1437652 | 2022-03-28 | US | Indiana | Benton | 18007 | 2475 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-03-29 04:20:46 | Benton, Indiana, US | |
877333 | 877333 | 2022-03-27 | US | Indiana | Benton | 18007 | 2475 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-03-28 04:20:33 | Benton, Indiana, US | |
2164616 | 2164616 | 2022-03-26 | US | Indiana | Benton | 18007 | 2475 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-03-27 04:20:47 | Benton, Indiana, US | |
1721552 | 1721552 | 2022-03-25 | US | Indiana | Benton | 18007 | 2475 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-03-26 04:20:23 | Benton, Indiana, US | |
1908652 | 1908652 | 2022-03-22 | US | Washington | Pend Oreille | 53051 | 2475 | 36 | 0 | 48.53234021 | -117.2741804 | 2022-03-23 04:20:48 | Pend Oreille, Washington, US | |
1906412 | 1906412 | 2022-03-22 | US | Iowa | Louisa | 19115 | 2475 | 60 | 0 | 41.21842119 | -91.26102611 | 2022-03-23 04:20:48 | Louisa, Iowa, US | |
3241783 | 3241783 | 2022-03-21 | US | Washington | Pend Oreille | 53051 | 2475 | 36 | 0 | 48.53234021 | -117.2741804 | 2022-03-22 04:20:54 | Pend Oreille, Washington, US | |
3239543 | 3239543 | 2022-03-21 | US | Iowa | Louisa | 19115 | 2475 | 60 | 0 | 41.21842119 | -91.26102611 | 2022-03-22 04:20:54 | Louisa, Iowa, US | |
25616 | 25616 | 2022-03-20 | US | Iowa | Louisa | 19115 | 2475 | 60 | 0 | 41.21842119 | -91.26102611 | 2022-03-21 04:20:50 | Louisa, Iowa, 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]);