johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
163 rows where confirmed = 4752 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328416 | 328416 | 2022-12-27 | US | Arkansas | Madison | 5087 | 4752 | 67 | 0 | 36.01038185 | -93.72524943 | 2022-12-28 04:21:04 | Madison, Arkansas, US | |
218489 | 218489 | 2022-12-26 | US | Arkansas | Madison | 5087 | 4752 | 67 | 0 | 36.01038185 | -93.72524943 | 2022-12-27 04:21:07 | Madison, Arkansas, US | |
3222946 | 3222946 | 2022-12-25 | US | Arkansas | Madison | 5087 | 4752 | 67 | 0 | 36.01038185 | -93.72524943 | 2022-12-26 04:21:06 | Madison, Arkansas, US | |
1018860 | 1018860 | 2022-12-24 | US | Arkansas | Madison | 5087 | 4752 | 67 | 0 | 36.01038185 | -93.72524943 | 2022-12-25 04:21:04 | Madison, Arkansas, US | |
2180093 | 2180093 | 2022-12-22 | US | Arkansas | Madison | 5087 | 4752 | 67 | 0 | 36.01038185 | -93.72524943 | 2022-12-23 04:21:04 | Madison, Arkansas, US | |
3038809 | 3038809 | 2022-10-27 | US | Arkansas | Clay | 5021 | 4752 | 99 | 0 | 36.36826212 | -90.4148172 | 2022-10-28 04:22:31 | Clay, Arkansas, US | |
542161 | 542161 | 2022-10-26 | US | Virginia | Rockbridge | 51163 | 4752 | 90 | 0 | 37.81204314 | -79.44605905 | 2022-10-27 04:22:01 | Rockbridge, Virginia, US | |
798029 | 798029 | 2022-10-24 | US | Wyoming | Lincoln | 56023 | 4752 | 32 | 0 | 42.26376367 | -110.6563997 | 2022-10-25 04:21:53 | Lincoln, Wyoming, US | |
3280484 | 3280484 | 2022-10-23 | US | Wyoming | Lincoln | 56023 | 4752 | 32 | 0 | 42.26376367 | -110.6563997 | 2022-10-24 04:22:29 | Lincoln, Wyoming, US | |
2271522 | 2271522 | 2022-10-22 | US | Wyoming | Lincoln | 56023 | 4752 | 32 | 0 | 42.26376367 | -110.6563997 | 2022-10-23 04:22:46 | Lincoln, Wyoming, US | |
1595822 | 1595822 | 2022-10-21 | US | Wyoming | Lincoln | 56023 | 4752 | 32 | 0 | 42.26376367 | -110.6563997 | 2022-10-22 04:22:53 | Lincoln, Wyoming, US | |
2275538 | 2275538 | 2022-10-20 | US | Wyoming | Lincoln | 56023 | 4752 | 32 | 0 | 42.26376367 | -110.6563997 | 2022-10-21 04:22:23 | Lincoln, Wyoming, US | |
2275051 | 2275051 | 2022-10-20 | US | Texas | Houston | 48225 | 4752 | 114 | 0 | 31.31925973 | -95.42226208 | 2022-10-21 04:22:23 | Houston, Texas, US | |
201873 | 201873 | 2022-10-19 | US | Wyoming | Lincoln | 56023 | 4752 | 32 | 0 | 42.26376367 | -110.6563997 | 2022-10-20 04:22:59 | Lincoln, Wyoming, US | |
201386 | 201386 | 2022-10-19 | US | Texas | Houston | 48225 | 4752 | 114 | 0 | 31.31925973 | -95.42226208 | 2022-10-20 04:22:59 | Houston, Texas, US | |
2760534 | 2760534 | 2022-10-18 | US | Wyoming | Lincoln | 56023 | 4752 | 32 | 0 | 42.26376367 | -110.6563997 | 2022-10-19 04:22:26 | Lincoln, Wyoming, US | |
2758097 | 2758097 | 2022-10-18 | US | Iowa | Cedar | 19031 | 4752 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-19 04:22:26 | Cedar, Iowa, US | |
2025931 | 2025931 | 2022-10-17 | US | Iowa | Cedar | 19031 | 4752 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-18 04:22:42 | Cedar, Iowa, US | |
2160709 | 2160709 | 2022-10-16 | US | Iowa | Cedar | 19031 | 4752 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-17 04:20:31 | Cedar, Iowa, US | |
516906 | 516906 | 2022-10-15 | US | Iowa | Cedar | 19031 | 4752 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-16 04:22:39 | Cedar, Iowa, US | |
2033963 | 2033963 | 2022-10-14 | US | Iowa | Cedar | 19031 | 4752 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-15 04:22:00 | Cedar, Iowa, US | |
3754651 | 3754651 | 2022-10-13 | US | Iowa | Cedar | 19031 | 4752 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-14 04:22:28 | Cedar, Iowa, US | |
3215476 | 3215476 | 2022-10-12 | US | Iowa | Cedar | 19031 | 4752 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-13 04:22:39 | Cedar, Iowa, US | |
3777252 | 3777252 | 2022-08-30 | US | Virginia | Giles | 51071 | 4752 | 51 | 0 | 37.31234791 | -80.70636931 | 2022-08-31 04:20:57 | Giles, Virginia, US | |
1683851 | 1683851 | 2022-08-29 | US | Virginia | Grayson | 51077 | 4752 | 83 | 0 | 36.65677234 | -81.23215889 | 2022-08-30 04:21:03 | Grayson, Virginia, US | |
2831808 | 2831808 | 2022-08-25 | US | Tennessee | Sequatchie | 47153 | 4752 | 71 | 0 | 35.36979721 | -85.41022136 | 2022-08-26 04:21:02 | Sequatchie, Tennessee, US | |
2403923 | 2403923 | 2022-08-21 | US | Indiana | Franklin | 18047 | 4752 | 67 | 0 | 39.4142482 | -85.06062647 | 2022-08-22 04:20:38 | Franklin, Indiana, US | |
3799001 | 3799001 | 2022-08-20 | US | Indiana | Franklin | 18047 | 4752 | 67 | 0 | 39.4142482 | -85.06062647 | 2022-08-21 04:20:44 | Franklin, Indiana, US | |
2364587 | 2364587 | 2022-08-19 | US | Indiana | Franklin | 18047 | 4752 | 67 | 0 | 39.4142482 | -85.06062647 | 2022-08-20 04:21:01 | Franklin, Indiana, US | |
1349542 | 1349542 | 2022-08-10 | US | Texas | Shelby | 48419 | 4752 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-08-11 04:20:49 | Shelby, Texas, US | |
1406008 | 1406008 | 2022-08-02 | US | Illinois | Bond | 17005 | 4752 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-08-03 04:20:59 | Bond, Illinois, US | |
2597048 | 2597048 | 2022-07-25 | US | Texas | Aransas | 48007 | 4752 | 88 | 0 | 28.10556197 | -96.9995047 | 2022-07-26 04:20:58 | Aransas, Texas, US | |
2595647 | 2595647 | 2022-07-25 | US | Michigan | Antrim | 26009 | 4752 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-07-26 04:20:58 | Antrim, Michigan, US | |
897762 | 897762 | 2022-07-24 | US | Michigan | Antrim | 26009 | 4752 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-07-25 04:20:51 | Antrim, Michigan, US | |
92756 | 92756 | 2022-07-23 | US | Michigan | Antrim | 26009 | 4752 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-07-24 04:20:47 | Antrim, Michigan, US | |
901778 | 901778 | 2022-07-22 | US | Michigan | Antrim | 26009 | 4752 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-07-23 04:20:53 | Antrim, Michigan, US | |
671914 | 671914 | 2022-07-21 | US | Michigan | Antrim | 26009 | 4752 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-07-22 04:21:15 | Antrim, Michigan, US | |
1609877 | 1609877 | 2022-07-20 | US | Michigan | Antrim | 26009 | 4752 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-07-21 04:21:10 | Antrim, Michigan, US | |
960510 | 960510 | 2022-07-19 | US | Michigan | Antrim | 26009 | 4752 | 70 | 0 | 44.99690221 | -85.15503082 | 2022-07-20 04:20:59 | Antrim, Michigan, US | |
3408768 | 3408768 | 2022-07-17 | US | Virginia | Bristol | 51520 | 4752 | 83 | 0 | 36.6163024 | -82.16359122 | 2022-07-18 04:20:59 | Bristol, Virginia, US | |
2154968 | 2154968 | 2022-07-16 | US | Virginia | Bristol | 51520 | 4752 | 83 | 0 | 36.6163024 | -82.16359122 | 2022-07-17 04:21:15 | Bristol, Virginia, US | |
2422201 | 2422201 | 2022-07-15 | US | Virginia | Bristol | 51520 | 4752 | 83 | 0 | 36.6163024 | -82.16359122 | 2022-07-16 04:21:05 | Bristol, Virginia, US | |
1212541 | 1212541 | 2022-07-11 | US | Illinois | Ford | 17053 | 4752 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-07-12 04:20:51 | Ford, Illinois, US | |
2151245 | 2151245 | 2022-06-27 | US | Wyoming | Carbon | 56007 | 4752 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-06-28 04:20:58 | Carbon, Wyoming, US | |
479046 | 479046 | 2022-06-26 | US | Wyoming | Carbon | 56007 | 4752 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-06-27 04:21:00 | Carbon, Wyoming, US | |
478649 | 478649 | 2022-06-26 | US | Texas | Reeves | 48389 | 4752 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-06-27 04:21:00 | Reeves, Texas, US | |
942421 | 942421 | 2022-06-25 | US | Wyoming | Carbon | 56007 | 4752 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-06-26 04:21:02 | Carbon, Wyoming, US | |
3350241 | 3350241 | 2022-06-24 | US | Wyoming | Carbon | 56007 | 4752 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-06-25 04:20:57 | Carbon, Wyoming, US | |
1651982 | 1651982 | 2022-06-23 | US | Wyoming | Carbon | 56007 | 4752 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-06-24 04:20:58 | Carbon, Wyoming, US | |
2191217 | 2191217 | 2022-06-22 | US | Wyoming | Carbon | 56007 | 4752 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-06-23 04:20:55 | Carbon, Wyoming, US | |
169648 | 169648 | 2022-06-21 | US | Wyoming | Carbon | 56007 | 4752 | 52 | 0 | 41.69357844 | -106.9326084 | 2022-06-22 04:20:54 | Carbon, Wyoming, US | |
3888220 | 3888220 | 2022-06-06 | US | Colorado | Alamosa | 8003 | 4752 | 62 | 0 | 37.57250606 | -105.7885451 | 2022-06-07 04:21:08 | Alamosa, Colorado, US | |
3581727 | 3581727 | 2022-06-02 | US | Texas | Gonzales | 48177 | 4752 | 99 | 0 | 29.45634206 | -97.49424032 | 2022-06-03 04:20:58 | Gonzales, Texas, US | |
974020 | 974020 | 2022-06-01 | US | Texas | Gonzales | 48177 | 4752 | 99 | 0 | 29.45634206 | -97.49424032 | 2022-06-02 05:20:39 | Gonzales, Texas, US | |
2536382 | 2536382 | 2022-05-12 | US | Tennessee | Polk | 47139 | 4752 | 74 | 0 | 35.12245443 | -84.52075859 | 2022-05-13 04:20:51 | Polk, Tennessee, US | |
2252565 | 2252565 | 2022-04-19 | US | Indiana | Starke | 18149 | 4752 | 98 | 0 | 41.27890281 | -86.64686895 | 2022-04-20 04:20:45 | Starke, Indiana, US | |
1847115 | 1847115 | 2022-04-18 | US | Indiana | Starke | 18149 | 4752 | 98 | 0 | 41.27890281 | -86.64686895 | 2022-04-19 04:21:00 | Starke, Indiana, US | |
1577616 | 1577616 | 2022-04-10 | US | Kentucky | Powell | 21197 | 4752 | 42 | 0 | 37.83218794 | -83.82553961 | 2022-04-11 04:21:02 | Powell, Kentucky, US | |
1653858 | 1653858 | 2022-04-09 | US | Kentucky | Powell | 21197 | 4752 | 42 | 0 | 37.83218794 | -83.82553961 | 2022-04-10 04:20:52 | Powell, Kentucky, US | |
2117180 | 2117180 | 2022-04-08 | US | Kentucky | Powell | 21197 | 4752 | 42 | 0 | 37.83218794 | -83.82553961 | 2022-04-09 04:20:42 | Powell, Kentucky, US | |
3321704 | 3321704 | 2022-04-07 | US | Kentucky | Powell | 21197 | 4752 | 42 | 0 | 37.83218794 | -83.82553961 | 2022-04-08 04:20:48 | Powell, Kentucky, US | |
2802240 | 2802240 | 2022-04-06 | US | Kentucky | Powell | 21197 | 4752 | 42 | 0 | 37.83218794 | -83.82553961 | 2022-04-07 04:20:53 | Powell, Kentucky, US | |
3869009 | 3869009 | 2022-04-05 | US | Kentucky | Powell | 21197 | 4752 | 42 | 0 | 37.83218794 | -83.82553961 | 2022-04-06 04:20:49 | Powell, Kentucky, US | |
2750351 | 2750351 | 2022-04-04 | US | Kentucky | Powell | 21197 | 4752 | 42 | 0 | 37.83218794 | -83.82553961 | 2022-04-05 04:20:48 | Powell, Kentucky, US | |
2478719 | 2478719 | 2022-03-30 | US | Georgia | Appling | 13001 | 4752 | 123 | 0 | 31.74847232 | -82.28909114 | 2022-03-31 04:20:56 | Appling, Georgia, US | |
356842 | 356842 | 2022-03-11 | US | Arkansas | Phillips | 5107 | 4752 | 95 | 0 | 34.43268455 | -90.84800154 | 2022-03-12 04:20:50 | Phillips, Arkansas, US | |
1868157 | 1868157 | 2022-03-10 | US | Pennsylvania | Juniata | 42067 | 4752 | 174 | 0 | 40.53358749 | -77.39975129999998 | 2022-03-11 04:20:50 | Juniata, Pennsylvania, US | |
2142852 | 2142852 | 2022-03-09 | US | Pennsylvania | Juniata | 42067 | 4752 | 174 | 0 | 40.53358749 | -77.39975129999998 | 2022-03-10 04:20:48 | Juniata, Pennsylvania, US | |
3810333 | 3810333 | 2022-01-28 | US | Alabama | Randolph | 1111 | 4752 | 69 | 0 | 33.29526734 | -85.45708831 | 2022-01-29 04:21:10 | Randolph, Alabama, US | |
3229377 | 3229377 | 2022-01-19 | US | Tennessee | Chester | 47023 | 4752 | 83 | 0 | 35.42527478 | -88.6095842 | 2022-01-20 04:21:07 | Chester, Tennessee, US | |
3614197 | 3614197 | 2022-01-12 | US | Indiana | Randolph | 18135 | 4752 | 126 | 0 | 40.15734772 | -85.01139319 | 2022-01-13 08:00:09 | Randolph, Indiana, US | |
2090176 | 2090176 | 2021-12-14 | US | New Mexico | Luna | 35029 | 4752 | 99 | 0 | 32.18179341 | -107.75088259999998 | 2021-12-15 03:22:16 | Luna, New Mexico, US | |
1741857 | 1741857 | 2021-12-05 | US | Kansas | Miami | 20121 | 4752 | 70 | 0 | 38.56383358 | -94.83832189 | 2021-12-06 04:22:34 | Miami, Kansas, US | |
139289 | 139289 | 2021-12-04 | US | Kansas | Miami | 20121 | 4752 | 70 | 0 | 38.56383358 | -94.83832189 | 2021-12-05 04:22:25 | Miami, Kansas, US | |
2196942 | 2196942 | 2021-12-03 | US | Kansas | Miami | 20121 | 4752 | 70 | 0 | 38.56383358 | -94.83832189 | 2021-12-04 04:22:18 | Miami, Kansas, US | |
1145717 | 1145717 | 2021-12-01 | US | Georgia | Dawson | 13085 | 4752 | 77 | 0 | 34.44244079 | -84.16964071 | 2021-12-02 04:22:37 | Dawson, Georgia, US | |
1361005 | 1361005 | 2021-11-27 | US | Pennsylvania | Elk | 42047 | 4752 | 65 | 0 | 41.42822061 | -78.64524744 | 2021-11-28 04:22:43 | Elk, Pennsylvania, US | |
449183 | 449183 | 2021-11-17 | US | Mississippi | Itawamba | 28057 | 4752 | 107 | 0 | 34.27993475 | -88.3606733 | 2021-11-18 04:21:33 | Itawamba, Mississippi, US | |
2288291 | 2288291 | 2021-11-15 | US | Georgia | Lee | 13177 | 4752 | 80 | 0 | 31.779330600000005 | -84.14324253 | 2021-11-16 04:21:10 | Lee, Georgia, US | |
3124005 | 3124005 | 2021-11-05 | US | Ohio | Morrow | 39117 | 4752 | 63 | 0 | 40.52363560000001 | -82.7892599 | 2021-11-06 04:21:51 | Morrow, Ohio, US | |
278036 | 278036 | 2021-11-03 | US | Mississippi | Tippah | 28139 | 4752 | 81 | 0 | 34.76872156 | -88.90988194 | 2021-11-04 04:22:20 | Tippah, Mississippi, US | |
634452 | 634452 | 2021-10-13 | US | Arkansas | St. Francis | 5123 | 4752 | 66 | 0 | 35.02201976 | -90.74828138 | 2021-10-14 04:21:29 | St. Francis, Arkansas, US | |
1493286 | 1493286 | 2021-10-12 | US | Michigan | Sanilac | 26151 | 4752 | 131 | 0 | 43.42406072 | -82.82055898 | 2021-10-13 04:20:51 | Sanilac, Michigan, US | |
3009019 | 3009019 | 2021-10-11 | US | Michigan | Sanilac | 26151 | 4752 | 131 | 0 | 43.42406072 | -82.82055898 | 2021-10-12 04:21:09 | Sanilac, Michigan, US | |
3834837 | 3834837 | 2021-10-05 | US | North Carolina | Pasquotank | 37139 | 4752 | 98 | 0 | 36.26723798 | -76.25134778 | 2021-10-06 04:21:33 | Pasquotank, North Carolina, US | |
2774675 | 2774675 | 2021-09-30 | US | Minnesota | Becker | 27005 | 4752 | 61 | 0 | 46.93479392 | -95.67158144 | 2021-10-01 04:21:35 | Becker, Minnesota, US | |
1923495 | 1923495 | 2021-09-24 | US | New York | Warren | 36113 | 4752 | 76 | 0 | 43.56173026 | -73.8433699 | 2021-09-25 04:21:31 | Warren, New York, US | |
602329 | 602329 | 2021-09-23 | US | Colorado | Montrose | 8085 | 4752 | 81 | 0 | 38.40214114 | -108.26390220000002 | 2021-09-24 04:21:44 | Montrose, Colorado, US | |
2466217 | 2466217 | 2021-09-14 | US | Virginia | York | 51199 | 4752 | 62 | 0 | 37.24374789 | -76.54412815 | 2021-09-15 03:22:37 | York, Virginia, US | |
1886136 | 1886136 | 2021-09-12 | US | Indiana | Steuben | 18151 | 4752 | 64 | 0 | 41.64423868 | -85.00101094 | 2021-09-13 04:21:15 | Steuben, Indiana, US | |
3449380 | 3449380 | 2021-09-10 | US | California | Amador | 6005 | 4752 | 56 | 0 | 38.44583082 | -120.65696000000001 | 2021-09-11 04:21:30 | Amador, California, US | |
643147 | 643147 | 2021-09-07 | US | Iowa | Lee | 19111 | 4752 | 69 | 0 | 40.64181461 | -91.48183025 | 2021-09-08 04:21:31 | Lee, Iowa, US | |
3195210 | 3195210 | 2021-09-06 | US | Iowa | Lee | 19111 | 4752 | 69 | 0 | 40.64181461 | -91.48183025 | 2021-09-07 04:21:35 | Lee, Iowa, US | |
3282078 | 3282078 | 2021-09-05 | US | Iowa | Lee | 19111 | 4752 | 69 | 0 | 40.64181461 | -91.48183025 | 2021-09-06 04:21:22 | Lee, Iowa, US | |
250492 | 250492 | 2021-09-04 | US | Iowa | Lee | 19111 | 4752 | 69 | 0 | 40.64181461 | -91.48183025 | 2021-09-05 04:21:33 | Lee, Iowa, US | |
3975773 | 3975773 | 2021-09-03 | US | Iowa | Lee | 19111 | 4752 | 69 | 0 | 40.64181461 | -91.48183025 | 2021-09-04 04:21:28 | Lee, Iowa, US | |
180388 | 180388 | 2021-09-02 | US | North Carolina | Scotland | 37165 | 4752 | 97 | 0 | 34.8386299 | -79.4757978 | 2021-09-03 04:21:20 | Scotland, North Carolina, US | |
179235 | 179235 | 2021-09-02 | US | Iowa | Lee | 19111 | 4752 | 69 | 0 | 40.64181461 | -91.48183025 | 2021-09-03 04:21:20 | Lee, Iowa, US | |
68270 | 68270 | 2021-09-01 | US | Iowa | Lee | 19111 | 4752 | 69 | 0 | 40.64181461 | -91.48183025 | 2021-09-02 04:21:15 | Lee, Iowa, US | |
2071238 | 2071238 | 2021-08-31 | US | Virginia | Franklin | 51067 | 4752 | 84 | 0 | 36.99536167 | -79.88023649 | 2021-09-01 04:21:38 | Franklin, Virginia, 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]);