johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
200 rows where confirmed = 3090 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
690848 | 690848 | 2022-12-23 | US | Arkansas | Chicot | 5017 | 3090 | 63 | 0 | 33.26458973 | -91.29539209 | 2022-12-24 04:21:02 | Chicot, Arkansas, US | |
2954417 | 2954417 | 2022-12-20 | US | Texas | Blanco | 48031 | 3090 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-21 04:21:03 | Blanco, Texas, US | |
3176819 | 3176819 | 2022-12-19 | US | Texas | Blanco | 48031 | 3090 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-20 04:21:04 | Blanco, Texas, US | |
1631336 | 1631336 | 2022-12-18 | US | Texas | Blanco | 48031 | 3090 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-19 04:21:03 | Blanco, Texas, US | |
506715 | 506715 | 2022-12-17 | US | Texas | Blanco | 48031 | 3090 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-18 04:21:03 | Blanco, Texas, US | |
3327287 | 3327287 | 2022-12-16 | US | Texas | Blanco | 48031 | 3090 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-17 04:21:04 | Blanco, Texas, US | |
545799 | 545799 | 2022-12-15 | US | Texas | Blanco | 48031 | 3090 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-16 04:21:01 | Blanco, Texas, US | |
351327 | 351327 | 2022-12-14 | US | Texas | Blanco | 48031 | 3090 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-12-15 04:20:58 | Blanco, Texas, US | |
720899 | 720899 | 2022-12-04 | US | North Dakota | McLean | 38055 | 3090 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-12-05 04:20:58 | McLean, North Dakota, US | |
2488599 | 2488599 | 2022-11-16 | US | Oklahoma | Pushmataha | 40127 | 3090 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-11-17 04:21:11 | Pushmataha, Oklahoma, US | |
295395 | 295395 | 2022-11-15 | US | Virginia | Nelson | 51125 | 3090 | 38 | 0 | 37.78790447 | -78.88498513 | 2022-11-16 04:21:09 | Nelson, Virginia, US | |
294610 | 294610 | 2022-11-15 | US | Oklahoma | Pushmataha | 40127 | 3090 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-11-16 04:21:09 | Pushmataha, Oklahoma, US | |
3599640 | 3599640 | 2022-11-14 | US | Oklahoma | Pushmataha | 40127 | 3090 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-11-15 04:21:16 | Pushmataha, Oklahoma, US | |
314498 | 314498 | 2022-11-13 | US | Oklahoma | Pushmataha | 40127 | 3090 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-11-14 04:21:09 | Pushmataha, Oklahoma, US | |
65659 | 65659 | 2022-11-12 | US | Oklahoma | Pushmataha | 40127 | 3090 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-11-13 04:21:14 | Pushmataha, Oklahoma, US | |
2929821 | 2929821 | 2022-11-11 | US | Oklahoma | Pushmataha | 40127 | 3090 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-11-12 04:20:41 | Pushmataha, Oklahoma, US | |
2508657 | 2508657 | 2022-11-10 | US | Oklahoma | Pushmataha | 40127 | 3090 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-11-11 04:21:22 | Pushmataha, Oklahoma, US | |
3995800 | 3995800 | 2022-09-27 | US | Iowa | Allamakee | 19005 | 3090 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-09-28 04:23:01 | Allamakee, Iowa, US | |
3994442 | 3994442 | 2022-09-27 | China | Shandong | 3090 | 7 | 0 | 36.3427 | 118.1498 | 2022-09-28 04:23:01 | Shandong, China | |||
2770128 | 2770128 | 2022-09-26 | US | Iowa | Allamakee | 19005 | 3090 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-09-27 04:23:01 | Allamakee, Iowa, US | |
1977781 | 1977781 | 2022-09-25 | US | Iowa | Allamakee | 19005 | 3090 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-09-26 04:20:52 | Allamakee, Iowa, US | |
2650948 | 2650948 | 2022-09-24 | US | Iowa | Allamakee | 19005 | 3090 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-09-25 04:23:31 | Allamakee, Iowa, US | |
385388 | 385388 | 2022-09-23 | US | Iowa | Allamakee | 19005 | 3090 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-09-24 04:21:40 | Allamakee, Iowa, US | |
1625454 | 1625454 | 2022-09-22 | US | Iowa | Allamakee | 19005 | 3090 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-09-23 04:23:13 | Allamakee, Iowa, US | |
1371658 | 1371658 | 2022-09-21 | US | Iowa | Allamakee | 19005 | 3090 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-09-22 04:22:56 | Allamakee, Iowa, US | |
3550757 | 3550757 | 2022-09-01 | US | Texas | Ward | 48475 | 3090 | 48 | 0 | 31.50999644 | -103.0927909 | 2022-09-02 04:21:07 | Ward, Texas, US | |
3968938 | 3968938 | 2022-07-05 | US | North Dakota | Barnes | 38003 | 3090 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-07-06 04:20:58 | Barnes, North Dakota, US | |
2190802 | 2190802 | 2022-06-22 | US | Texas | Nolan | 48353 | 3090 | 99 | 0 | 32.30365282 | -100.4060208 | 2022-06-23 04:20:55 | Nolan, Texas, US | |
3158284 | 3158284 | 2022-06-09 | US | Colorado | Park | 8093 | 3090 | 21 | 0 | 39.120926 | -105.7182065 | 2022-06-10 04:20:55 | Park, Colorado, US | |
3897093 | 3897093 | 2022-05-19 | US | Indiana | Pulaski | 18131 | 3090 | 86 | 0 | 41.04166107 | -86.69890683 | 2022-05-20 04:20:57 | Pulaski, Indiana, US | |
1185877 | 1185877 | 2022-05-18 | US | Indiana | Pulaski | 18131 | 3090 | 86 | 0 | 41.04166107 | -86.69890683 | 2022-05-19 04:20:54 | Pulaski, Indiana, US | |
3538196 | 3538196 | 2022-05-10 | US | Puerto Rico | Comerio | 72045 | 3090 | 0 | 0 | 18.224687 | -66.221622 | 2022-05-11 04:20:48 | Comerio, Puerto Rico, US | |
3853525 | 3853525 | 2022-04-27 | US | Minnesota | Chippewa | 27023 | 3090 | 48 | 0 | 45.02343421 | -95.56403693 | 2022-04-28 04:20:47 | Chippewa, Minnesota, US | |
2445328 | 2445328 | 2022-04-13 | US | Oklahoma | Love | 40085 | 3090 | 38 | 0 | 33.95273467 | -97.23906784 | 2022-04-13 23:21:06 | Love, Oklahoma, US | |
1951085 | 1951085 | 2022-04-12 | US | Oklahoma | Love | 40085 | 3090 | 38 | 0 | 33.95273467 | -97.23906784 | 2022-04-13 04:21:03 | Love, Oklahoma, US | |
3208838 | 3208838 | 2022-04-11 | US | Oklahoma | Love | 40085 | 3090 | 38 | 0 | 33.95273467 | -97.23906784 | 2022-04-12 04:20:49 | Love, Oklahoma, US | |
3206830 | 3206830 | 2022-04-11 | US | California | Mono | 6051 | 3090 | 6 | 0 | 37.93899289 | -118.8872409 | 2022-04-12 04:20:49 | Mono, California, US | |
1578874 | 1578874 | 2022-04-10 | US | Puerto Rico | Barceloneta | 72017 | 3090 | 0 | 0 | 18.445532999999998 | -66.56053100000001 | 2022-04-11 04:21:02 | Barceloneta, Puerto Rico, US | |
1578724 | 1578724 | 2022-04-10 | US | Oklahoma | Love | 40085 | 3090 | 38 | 0 | 33.95273467 | -97.23906784 | 2022-04-11 04:21:02 | Love, Oklahoma, US | |
1576716 | 1576716 | 2022-04-10 | US | California | Mono | 6051 | 3090 | 6 | 0 | 37.93899289 | -118.8872409 | 2022-04-11 04:21:02 | Mono, California, US | |
1654966 | 1654966 | 2022-04-09 | US | Oklahoma | Love | 40085 | 3090 | 38 | 0 | 33.95273467 | -97.23906784 | 2022-04-10 04:20:52 | Love, Oklahoma, US | |
2118288 | 2118288 | 2022-04-08 | US | Oklahoma | Love | 40085 | 3090 | 38 | 0 | 33.95273467 | -97.23906784 | 2022-04-09 04:20:42 | Love, Oklahoma, US | |
3322812 | 3322812 | 2022-04-07 | US | Oklahoma | Love | 40085 | 3090 | 38 | 0 | 33.95273467 | -97.23906784 | 2022-04-08 04:20:48 | Love, Oklahoma, US | |
2480758 | 2480758 | 2022-03-30 | US | Puerto Rico | Utuado | 72141 | 3090 | 0 | 0 | 18.271214 | -66.702984 | 2022-03-31 04:20:56 | Utuado, Puerto Rico, US | |
2447991 | 2447991 | 2022-02-22 | US | Iowa | Madison | 19121 | 3090 | 34 | 0 | 41.33081904 | -94.01554631 | 2022-02-23 04:21:09 | Madison, Iowa, US | |
3719404 | 3719404 | 2022-02-21 | US | Iowa | Madison | 19121 | 3090 | 34 | 0 | 41.33081904 | -94.01554631 | 2022-02-22 04:21:01 | Madison, Iowa, US | |
3913238 | 3913238 | 2022-02-20 | US | Iowa | Madison | 19121 | 3090 | 34 | 0 | 41.33081904 | -94.01554631 | 2022-02-21 04:21:05 | Madison, Iowa, US | |
3876796 | 3876796 | 2022-02-19 | US | Iowa | Madison | 19121 | 3090 | 34 | 0 | 41.33081904 | -94.01554631 | 2022-02-20 04:21:00 | Madison, Iowa, US | |
3857052 | 3857052 | 2022-02-18 | US | Iowa | Madison | 19121 | 3090 | 34 | 0 | 41.33081904 | -94.01554631 | 2022-02-19 04:21:11 | Madison, Iowa, US | |
1299271 | 1299271 | 2022-02-17 | US | Iowa | Madison | 19121 | 3090 | 34 | 0 | 41.33081904 | -94.01554631 | 2022-02-18 04:21:04 | Madison, Iowa, US | |
3821657 | 3821657 | 2022-02-16 | US | Iowa | Madison | 19121 | 3090 | 34 | 0 | 41.33081904 | -94.01554631 | 2022-02-17 04:20:56 | Madison, Iowa, US | |
462375 | 462375 | 2022-02-02 | US | Tennessee | Stewart | 47161 | 3090 | 47 | 0 | 36.50235092 | -87.83920548 | 2022-02-03 04:21:21 | Stewart, Tennessee, US | |
460771 | 460771 | 2022-02-02 | US | Kentucky | Clinton | 21053 | 3090 | 41 | 0 | 36.72581156 | -85.13377529 | 2022-02-03 04:21:21 | Clinton, Kentucky, US | |
3302209 | 3302209 | 2022-01-30 | US | Montana | Glacier | 30035 | 3090 | 65 | 0 | 48.70513576 | -112.9934235 | 2022-01-31 04:21:09 | Glacier, Montana, US | |
3065129 | 3065129 | 2022-01-29 | US | Texas | Jackson | 48239 | 3090 | 55 | 0 | 28.95472367 | -96.57749563 | 2022-01-30 04:21:26 | Jackson, Texas, US | |
3064000 | 3064000 | 2022-01-29 | US | Montana | Glacier | 30035 | 3090 | 65 | 0 | 48.70513576 | -112.9934235 | 2022-01-30 04:21:26 | Glacier, Montana, US | |
3811934 | 3811934 | 2022-01-28 | US | Montana | Glacier | 30035 | 3090 | 65 | 0 | 48.70513576 | -112.9934235 | 2022-01-29 04:21:10 | Glacier, Montana, US | |
1781290 | 1781290 | 2022-01-27 | US | Missouri | Gasconade | 29073 | 3090 | 90 | 0 | 38.43947277 | -91.50847147 | 2022-01-28 04:21:09 | Gasconade, Missouri, US | |
1319612 | 1319612 | 2022-01-26 | US | Kentucky | Estill | 21065 | 3090 | 39 | 0 | 37.69241417 | -83.95956369 | 2022-01-27 04:21:19 | Estill, Kentucky, US | |
2833364 | 2833364 | 2022-01-22 | US | Arkansas | Van Buren | 5141 | 3090 | 46 | 0 | 35.58095779 | -92.51295036 | 2022-01-23 04:21:13 | Van Buren, Arkansas, US | |
3427369 | 3427369 | 2022-01-21 | US | North Dakota | Ramsey | 38071 | 3090 | 47 | 0 | 48.26886249 | -98.72223879 | 2022-01-22 04:21:13 | Ramsey, North Dakota, US | |
3228169 | 3228169 | 2022-01-19 | US | Minnesota | Faribault | 27043 | 3090 | 44 | 0 | 43.67381499 | -93.94787458 | 2022-01-20 04:21:07 | Faribault, Minnesota, US | |
99950 | 99950 | 2022-01-14 | US | Colorado | Gunnison | 8051 | 3090 | 13 | 0 | 38.66611652 | -107.0320729 | 2022-01-15 04:21:07 | Gunnison, Colorado, US | |
130118 | 130118 | 2022-01-09 | US | Virginia | Nottoway | 51135 | 3090 | 71 | 0 | 37.1435975 | -78.05065922 | 2022-01-10 04:22:07 | Nottoway, Virginia, US | |
1218953 | 1218953 | 2022-01-08 | US | Virginia | Nottoway | 51135 | 3090 | 71 | 0 | 37.1435975 | -78.05065922 | 2022-01-09 04:21:46 | Nottoway, Virginia, US | |
1393046 | 1393046 | 2022-01-07 | US | Virginia | Nottoway | 51135 | 3090 | 71 | 0 | 37.1435975 | -78.05065922 | 2022-01-08 04:21:53 | Nottoway, Virginia, US | |
1703473 | 1703473 | 2022-01-03 | US | Texas | Houston | 48225 | 3090 | 90 | 0 | 31.31925973 | -95.42226208 | 2022-01-04 04:22:17 | Houston, Texas, US | |
1702288 | 1702288 | 2022-01-03 | US | Missouri | Morgan | 29141 | 3090 | 75 | 0 | 38.4181765 | -92.88791859 | 2022-01-04 04:22:17 | Morgan, Missouri, US | |
3521371 | 3521371 | 2022-01-02 | US | Missouri | Morgan | 29141 | 3090 | 75 | 0 | 38.4181765 | -92.88791859 | 2022-01-03 02:22:25 | Morgan, Missouri, US | |
2169501 | 2169501 | 2022-01-01 | US | Missouri | Morgan | 29141 | 3090 | 75 | 0 | 38.4181765 | -92.88791859 | 2022-01-02 04:20:52 | Morgan, Missouri, US | |
2778932 | 2778932 | 2021-12-31 | US | Missouri | Morgan | 29141 | 3090 | 75 | 0 | 38.4181765 | -92.88791859 | 2022-01-01 04:22:14 | Morgan, Missouri, US | |
2777512 | 2777512 | 2021-12-31 | US | Arkansas | Polk | 5113 | 3090 | 126 | 0 | 34.48254879 | -94.22728802 | 2022-01-01 04:22:14 | Polk, Arkansas, US | |
4001962 | 4001962 | 2021-12-30 | US | Virginia | Buchanan | 51027 | 3090 | 86 | 0 | 37.26818323 | -82.03749726 | 2021-12-31 04:21:50 | Buchanan, Virginia, US | |
4000589 | 4000589 | 2021-12-30 | US | Missouri | Morgan | 29141 | 3090 | 75 | 0 | 38.4181765 | -92.88791859 | 2021-12-31 04:21:50 | Morgan, Missouri, US | |
731587 | 731587 | 2021-12-27 | US | Illinois | White | 17193 | 3090 | 34 | 0 | 38.08706198 | -88.17657461 | 2021-12-28 04:21:47 | White, Illinois, US | |
2906936 | 2906936 | 2021-12-19 | US | Texas | Shelby | 48419 | 3090 | 113 | 0 | 31.79211404 | -94.14550696 | 2021-12-20 04:21:43 | Shelby, Texas, US | |
1719693 | 1719693 | 2021-12-16 | US | Virginia | Fluvanna | 51065 | 3090 | 29 | 0 | 37.84157909 | -78.27715475 | 2021-12-17 04:22:14 | Fluvanna, Virginia, US | |
2091367 | 2091367 | 2021-12-14 | US | Virginia | Powhatan | 51145 | 3090 | 31 | 0 | 37.55016038 | -77.91267882 | 2021-12-15 03:22:16 | Powhatan, Virginia, US | |
1661398 | 1661398 | 2021-12-12 | US | Illinois | Clark | 17023 | 3090 | 44 | 0 | 39.33425789 | -87.78705622 | 2021-12-13 04:22:02 | Clark, Illinois, US | |
1665414 | 1665414 | 2021-12-11 | US | Illinois | Clark | 17023 | 3090 | 44 | 0 | 39.33425789 | -87.78705622 | 2021-12-12 04:22:12 | Clark, Illinois, US | |
3658585 | 3658585 | 2021-12-10 | US | Tennessee | Sequatchie | 47153 | 3090 | 40 | 0 | 35.36979721 | -85.41022136 | 2021-12-11 04:22:45 | Sequatchie, Tennessee, US | |
3656566 | 3656566 | 2021-12-10 | US | Illinois | Clark | 17023 | 3090 | 44 | 0 | 39.33425789 | -87.78705622 | 2021-12-11 04:22:45 | Clark, Illinois, US | |
3288774 | 3288774 | 2021-11-18 | Denmark | Faroe Islands | 3090 | 11 | 0 | 61.8926 | -6.9118 | 2021-11-19 04:21:40 | Faroe Islands, Denmark | |||
715589 | 715589 | 2021-11-12 | US | Indiana | Orange | 18117 | 3090 | 68 | 0 | 38.54118920000001 | -86.49523093 | 2021-11-13 04:21:38 | Orange, Indiana, US | |
3642431 | 3642431 | 2021-11-08 | US | South Dakota | Hughes | 46065 | 3090 | 46 | 0 | 44.39091534 | -99.99661148 | 2021-11-09 04:21:36 | Hughes, South Dakota, US | |
279525 | 279525 | 2021-11-03 | US | Virginia | Fredericksburg | 51630 | 3090 | 26 | 0 | 38.2977863 | -77.4922454 | 2021-11-04 04:22:20 | Fredericksburg, Virginia, US | |
3493968 | 3493968 | 2021-10-26 | US | Mississippi | Clay | 28025 | 3090 | 77 | 0 | 33.65358105 | -88.77784255 | 2021-10-27 04:22:32 | Clay, Mississippi, US | |
446684 | 446684 | 2021-10-20 | US | Virginia | Dinwiddie | 51053 | 3090 | 51 | 0 | 37.07544585 | -77.63451754 | 2021-10-21 04:21:18 | Dinwiddie, Virginia, US | |
3007711 | 3007711 | 2021-10-11 | US | Alabama | Henry | 1067 | 3090 | 63 | 0 | 31.51148016 | -85.24267944 | 2021-10-12 04:21:09 | Henry, Alabama, US | |
423998 | 423998 | 2021-10-10 | US | Colorado | Pitkin | 8097 | 3090 | 5 | 0 | 39.21720112 | -106.9310027 | 2021-10-11 04:21:31 | Pitkin, Colorado, US | |
3835483 | 3835483 | 2021-10-05 | US | Tennessee | Trousdale | 47169 | 3090 | 24 | 0 | 36.39026213 | -86.16087954 | 2021-10-06 04:21:33 | Trousdale, Tennessee, US | |
1334676 | 1334676 | 2021-09-28 | US | Alabama | Randolph | 1111 | 3090 | 56 | 0 | 33.29526734 | -85.45708831 | 2021-09-29 04:21:45 | Randolph, Alabama, US | |
1239019 | 1239019 | 2021-09-27 | US | Virginia | Mecklenburg | 51117 | 3090 | 74 | 0 | 36.67882005 | -78.36131056 | 2021-09-28 04:21:28 | Mecklenburg, Virginia, US | |
1236625 | 1236625 | 2021-09-27 | US | Illinois | Douglas | 17041 | 3090 | 36 | 0 | 39.76768052 | -88.21854195 | 2021-09-28 04:21:28 | Douglas, Illinois, US | |
603920 | 603920 | 2021-09-23 | US | New York | Delaware | 36025 | 3090 | 41 | 0 | 42.19837623 | -74.96709306 | 2021-09-24 04:21:44 | Delaware, New York, US | |
3759758 | 3759758 | 2021-09-21 | US | North Carolina | Ashe | 37009 | 3090 | 46 | 0 | 36.43296207 | -81.49862729 | 2021-09-22 04:21:45 | Ashe, North Carolina, US | |
1817474 | 1817474 | 2021-09-19 | US | Pennsylvania | Susquehanna | 42115 | 3090 | 62 | 0 | 41.82147784 | -75.80071959 | 2021-09-20 04:21:22 | Susquehanna, Pennsylvania, US | |
2621107 | 2621107 | 2021-09-17 | US | Texas | Deaf Smith | 48117 | 3090 | 69 | 0 | 34.96522957 | -102.6054267 | 2021-09-18 04:21:24 | Deaf Smith, Texas, US | |
2809832 | 2809832 | 2021-09-16 | US | Indiana | Fountain | 18045 | 3090 | 53 | 0 | 40.12361933 | -87.24217689 | 2021-09-17 04:21:46 | Fountain, Indiana, US | |
1377337 | 1377337 | 2021-09-15 | US | South Dakota | Beadle | 46005 | 3090 | 43 | 0 | 44.41464384 | -98.27858469 | 2021-09-16 04:22:19 | Beadle, 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]);