johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
233 rows where confirmed = 3888 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
221294 | 221294 | 2022-12-26 | US | Virginia | Brunswick | 51025 | 3888 | 53 | 0 | 36.76366949 | -77.8593436 | 2022-12-27 04:21:07 | Brunswick, Virginia, US | |
3555230 | 3555230 | 2022-11-27 | US | Wisconsin | Price | 55099 | 3888 | 35 | 0 | 45.68051754 | -90.3609888 | 2022-11-28 04:21:02 | Price, Wisconsin, US | |
2103710 | 2103710 | 2022-11-26 | US | Wisconsin | Price | 55099 | 3888 | 35 | 0 | 45.68051754 | -90.3609888 | 2022-11-27 04:21:05 | Price, Wisconsin, US | |
491201 | 491201 | 2022-11-25 | US | Wisconsin | Price | 55099 | 3888 | 35 | 0 | 45.68051754 | -90.3609888 | 2022-11-26 04:21:11 | Price, Wisconsin, US | |
2025381 | 2025381 | 2022-10-17 | US | Colorado | Grand | 8049 | 3888 | 30 | 0 | 40.10603347 | -106.1178042 | 2022-10-18 04:22:42 | Grand, Colorado, US | |
1811286 | 1811286 | 2022-10-05 | US | Arkansas | Marion | 5089 | 3888 | 93 | 0 | 36.26844485 | -92.68451899 | 2022-10-06 04:21:22 | Marion, Arkansas, US | |
2398383 | 2398383 | 2022-09-12 | US | Wisconsin | Rusk | 55107 | 3888 | 59 | 0 | 45.47498854 | -91.1333012 | 2022-09-13 04:20:57 | Rusk, Wisconsin, US | |
118008 | 118008 | 2022-09-06 | US | Texas | Wilbarger | 48487 | 3888 | 89 | 0 | 34.07945812 | -99.24178437 | 2022-09-07 04:20:59 | Wilbarger, Texas, US | |
2323883 | 2323883 | 2022-08-24 | US | Arkansas | Van Buren | 5141 | 3888 | 63 | 0 | 35.58095779 | -92.51295036 | 2022-08-25 04:21:13 | Van Buren, Arkansas, US | |
1251625 | 1251625 | 2022-08-23 | US | Georgia | Rabun | 13241 | 3888 | 102 | 0 | 34.88389445 | -83.40304637 | 2022-08-24 04:20:46 | Rabun, Georgia, US | |
2856192 | 2856192 | 2022-08-22 | US | Virginia | Dickenson | 51051 | 3888 | 53 | 0 | 37.12560977 | -82.35124171 | 2022-08-23 04:20:56 | Dickenson, Virginia, US | |
2853729 | 2853729 | 2022-08-22 | US | Georgia | Rabun | 13241 | 3888 | 102 | 0 | 34.88389445 | -83.40304637 | 2022-08-23 04:20:56 | Rabun, Georgia, US | |
2403701 | 2403701 | 2022-08-21 | US | Georgia | Rabun | 13241 | 3888 | 102 | 0 | 34.88389445 | -83.40304637 | 2022-08-22 04:20:38 | Rabun, Georgia, US | |
3798779 | 3798779 | 2022-08-20 | US | Georgia | Rabun | 13241 | 3888 | 102 | 0 | 34.88389445 | -83.40304637 | 2022-08-21 04:20:44 | Rabun, Georgia, US | |
2364365 | 2364365 | 2022-08-19 | US | Georgia | Rabun | 13241 | 3888 | 102 | 0 | 34.88389445 | -83.40304637 | 2022-08-20 04:21:01 | Rabun, Georgia, US | |
1162036 | 1162036 | 2022-08-18 | US | Georgia | Rabun | 13241 | 3888 | 102 | 0 | 34.88389445 | -83.40304637 | 2022-08-19 04:20:54 | Rabun, Georgia, US | |
3951360 | 3951360 | 2022-08-17 | US | Georgia | Rabun | 13241 | 3888 | 102 | 0 | 34.88389445 | -83.40304637 | 2022-08-18 04:21:11 | Rabun, Georgia, US | |
2493819 | 2493819 | 2022-08-15 | China | Fujian | 3888 | 1 | 0 | 26.0789 | 117.9874 | 2022-08-16 04:20:58 | Fujian, China | |||
1488222 | 1488222 | 2022-07-26 | US | Colorado | Las Animas | 8071 | 3888 | 45 | 0 | 37.3153406 | -104.0376458 | 2022-07-27 04:21:04 | Las Animas, Colorado, US | |
2597189 | 2597189 | 2022-07-25 | US | Texas | Leon | 48289 | 3888 | 93 | 0 | 31.29872538 | -95.9936328 | 2022-07-26 04:20:58 | Leon, Texas, US | |
896719 | 896719 | 2022-07-24 | US | California | Plumas | 6063 | 3888 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-07-25 04:20:51 | Plumas, California, US | |
91713 | 91713 | 2022-07-23 | US | California | Plumas | 6063 | 3888 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-07-24 04:20:47 | Plumas, California, US | |
900735 | 900735 | 2022-07-22 | US | California | Plumas | 6063 | 3888 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-07-23 04:20:53 | Plumas, California, US | |
670871 | 670871 | 2022-07-21 | US | California | Plumas | 6063 | 3888 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-07-22 04:21:15 | Plumas, California, US | |
3432231 | 3432231 | 2022-07-14 | US | Texas | Zapata | 48505 | 3888 | 55 | 0 | 27.00156391 | -99.16987152 | 2022-07-15 04:20:53 | Zapata, Texas, US | |
2741424 | 2741424 | 2022-07-07 | US | Alabama | Washington | 1129 | 3888 | 59 | 0 | 31.4092794 | -88.20689944 | 2022-07-08 04:20:56 | Washington, Alabama, US | |
3968820 | 3968820 | 2022-07-05 | US | New York | Schuyler | 36097 | 3888 | 28 | 0 | 42.39184015 | -76.8773299 | 2022-07-06 04:20:58 | Schuyler, New York, US | |
3080331 | 3080331 | 2022-07-04 | US | New York | Schuyler | 36097 | 3888 | 28 | 0 | 42.39184015 | -76.8773299 | 2022-07-05 04:20:45 | Schuyler, New York, US | |
3579329 | 3579329 | 2022-06-02 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-06-03 04:20:58 | Hamilton, Florida, US | |
971622 | 971622 | 2022-06-01 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-06-02 05:20:39 | Hamilton, Florida, US | |
232319 | 232319 | 2022-05-31 | US | Texas | Freestone | 48161 | 3888 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-06-01 04:20:55 | Freestone, Texas, US | |
229929 | 229929 | 2022-05-31 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-06-01 04:20:55 | Hamilton, Florida, US | |
3186694 | 3186694 | 2022-05-30 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-05-31 04:20:51 | Hamilton, Florida, US | |
3198843 | 3198843 | 2022-05-29 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-05-30 04:20:50 | Hamilton, Florida, US | |
2725721 | 2725721 | 2022-05-28 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-05-29 04:20:53 | Hamilton, Florida, US | |
1314902 | 1314902 | 2022-05-27 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-05-28 04:21:07 | Hamilton, Florida, US | |
1850694 | 1850694 | 2022-05-26 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-05-27 04:20:56 | Hamilton, Florida, US | |
2048570 | 2048570 | 2022-05-25 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-05-26 04:20:50 | Hamilton, Florida, US | |
3000008 | 3000008 | 2022-05-24 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-05-25 04:20:56 | Hamilton, Florida, US | |
3593729 | 3593729 | 2022-05-23 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-05-24 04:20:57 | Hamilton, Florida, US | |
622581 | 622581 | 2022-05-22 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-05-26 04:20:50 | Hamilton, Florida, US | |
1110277 | 1110277 | 2022-05-21 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-05-22 04:20:52 | Hamilton, Florida, US | |
1169901 | 1169901 | 2022-05-20 | US | Florida | Hamilton | 12047 | 3888 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-05-21 04:20:58 | Hamilton, Florida, US | |
1327491 | 1327491 | 2022-04-26 | US | Iowa | Tama | 19171 | 3888 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-27 04:20:52 | Tama, Iowa, US | |
3723445 | 3723445 | 2022-04-25 | US | Iowa | Tama | 19171 | 3888 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-26 04:20:51 | Tama, Iowa, US | |
2030013 | 2030013 | 2022-04-24 | US | Iowa | Tama | 19171 | 3888 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-25 04:20:56 | Tama, Iowa, US | |
747588 | 747588 | 2022-04-23 | US | Iowa | Tama | 19171 | 3888 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-24 04:20:56 | Tama, Iowa, US | |
3438073 | 3438073 | 2022-04-22 | US | Iowa | Tama | 19171 | 3888 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-23 04:20:50 | Tama, Iowa, US | |
2893715 | 2893715 | 2022-04-21 | US | Kansas | Jackson | 20085 | 3888 | 30 | 0 | 39.41673394 | -95.79356799 | 2022-04-22 04:20:45 | Jackson, Kansas, US | |
2893658 | 2893658 | 2022-04-21 | US | Iowa | Tama | 19171 | 3888 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-22 04:20:45 | Tama, Iowa, US | |
2308587 | 2308587 | 2022-04-20 | US | Kansas | Jackson | 20085 | 3888 | 30 | 0 | 39.41673394 | -95.79356799 | 2022-04-21 04:20:46 | Jackson, Kansas, US | |
2308530 | 2308530 | 2022-04-20 | US | Iowa | Tama | 19171 | 3888 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-21 04:20:46 | Tama, Iowa, US | |
2252726 | 2252726 | 2022-04-19 | US | Kansas | Jackson | 20085 | 3888 | 30 | 0 | 39.41673394 | -95.79356799 | 2022-04-20 04:20:45 | Jackson, Kansas, US | |
1847276 | 1847276 | 2022-04-18 | US | Kansas | Jackson | 20085 | 3888 | 30 | 0 | 39.41673394 | -95.79356799 | 2022-04-19 04:21:00 | Jackson, Kansas, US | |
3418220 | 3418220 | 2022-04-17 | US | Kansas | Jackson | 20085 | 3888 | 30 | 0 | 39.41673394 | -95.79356799 | 2022-04-18 04:21:12 | Jackson, Kansas, US | |
305169 | 305169 | 2022-04-16 | US | Kansas | Jackson | 20085 | 3888 | 30 | 0 | 39.41673394 | -95.79356799 | 2022-04-17 04:20:59 | Jackson, Kansas, US | |
2671114 | 2671114 | 2022-04-15 | US | Kansas | Jackson | 20085 | 3888 | 30 | 0 | 39.41673394 | -95.79356799 | 2022-04-16 04:20:48 | Jackson, Kansas, US | |
1226886 | 1226886 | 2022-04-14 | US | Vermont | Lamoille | 50015 | 3888 | 17 | 0 | 44.60353043 | -72.64356694 | 2022-04-15 04:20:57 | Lamoille, Vermont, US | |
1950872 | 1950872 | 2022-04-12 | US | North Carolina | Polk | 37149 | 3888 | 54 | 0 | 35.27820615 | -82.16812354 | 2022-04-13 04:21:03 | Polk, North Carolina, US | |
3208625 | 3208625 | 2022-04-11 | US | North Carolina | Polk | 37149 | 3888 | 54 | 0 | 35.27820615 | -82.16812354 | 2022-04-12 04:20:49 | Polk, North Carolina, US | |
1578511 | 1578511 | 2022-04-10 | US | North Carolina | Polk | 37149 | 3888 | 54 | 0 | 35.27820615 | -82.16812354 | 2022-04-11 04:21:02 | Polk, North Carolina, US | |
1654753 | 1654753 | 2022-04-09 | US | North Carolina | Polk | 37149 | 3888 | 54 | 0 | 35.27820615 | -82.16812354 | 2022-04-10 04:20:52 | Polk, North Carolina, US | |
2118075 | 2118075 | 2022-04-08 | US | North Carolina | Polk | 37149 | 3888 | 54 | 0 | 35.27820615 | -82.16812354 | 2022-04-09 04:20:42 | Polk, North Carolina, US | |
3322599 | 3322599 | 2022-04-07 | US | North Carolina | Polk | 37149 | 3888 | 54 | 0 | 35.27820615 | -82.16812354 | 2022-04-08 04:20:48 | Polk, North Carolina, US | |
3320735 | 3320735 | 2022-04-07 | US | Arkansas | Izard | 5065 | 3888 | 69 | 0 | 36.09604046 | -91.90847954 | 2022-04-08 04:20:48 | Izard, Arkansas, US | |
2803135 | 2803135 | 2022-04-06 | US | North Carolina | Polk | 37149 | 3888 | 54 | 0 | 35.27820615 | -82.16812354 | 2022-04-07 04:20:53 | Polk, North Carolina, US | |
3869305 | 3869305 | 2022-04-05 | US | Minnesota | Redwood | 27127 | 3888 | 53 | 0 | 44.40555844 | -95.25207021 | 2022-04-06 04:20:49 | Redwood, Minnesota, US | |
3868040 | 3868040 | 2022-04-05 | US | Arkansas | Izard | 5065 | 3888 | 69 | 0 | 36.09604046 | -91.90847954 | 2022-04-06 04:20:49 | Izard, Arkansas, US | |
2749382 | 2749382 | 2022-04-04 | US | Arkansas | Izard | 5065 | 3888 | 69 | 0 | 36.09604046 | -91.90847954 | 2022-04-05 04:20:48 | Izard, Arkansas, US | |
3730728 | 3730728 | 2022-04-03 | US | Arkansas | Izard | 5065 | 3888 | 69 | 0 | 36.09604046 | -91.90847954 | 2022-04-04 04:20:51 | Izard, Arkansas, US | |
500163 | 500163 | 2022-04-02 | US | Arkansas | Izard | 5065 | 3888 | 69 | 0 | 36.09604046 | -91.90847954 | 2022-04-03 04:20:48 | Izard, Arkansas, US | |
2481132 | 2481132 | 2022-03-30 | US | Texas | Llano | 48299 | 3888 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-03-31 04:20:56 | Llano, Texas, US | |
3241801 | 3241801 | 2022-03-21 | US | West Virginia | Braxton | 54007 | 3888 | 42 | 0 | 38.70036159 | -80.72011184 | 2022-03-22 04:20:54 | Braxton, West Virginia, US | |
1865629 | 1865629 | 2022-03-10 | Palau | 3888 | 6 | 0 | 7.515 | 134.5825 | 2022-03-11 04:20:50 | Palau | ||||
2140324 | 2140324 | 2022-03-09 | Palau | 3888 | 6 | 0 | 7.515 | 134.5825 | 2022-03-10 04:20:48 | Palau | ||||
921012 | 921012 | 2022-03-08 | US | Kansas | Osage | 20139 | 3888 | 44 | 0 | 38.65235984 | -95.72707998 | 2022-03-09 04:20:59 | Osage, Kansas, US | |
920497 | 920497 | 2022-03-08 | US | Georgia | Greene | 13133 | 3888 | 80 | 0 | 33.5769205 | -83.17139104 | 2022-03-09 04:20:59 | Greene, Georgia, US | |
1549299 | 1549299 | 2022-03-07 | US | Kansas | Osage | 20139 | 3888 | 44 | 0 | 38.65235984 | -95.72707998 | 2022-03-08 04:20:54 | Osage, Kansas, US | |
1548784 | 1548784 | 2022-03-07 | US | Georgia | Greene | 13133 | 3888 | 80 | 0 | 33.5769205 | -83.17139104 | 2022-03-08 04:20:54 | Greene, Georgia, US | |
2200968 | 2200968 | 2022-03-06 | US | Kansas | Osage | 20139 | 3888 | 43 | 0 | 38.65235984 | -95.72707998 | 2022-03-07 04:20:47 | Osage, Kansas, US | |
2093425 | 2093425 | 2022-03-05 | US | Kansas | Osage | 20139 | 3888 | 43 | 0 | 38.65235984 | -95.72707998 | 2022-03-06 04:20:49 | Osage, Kansas, US | |
2667125 | 2667125 | 2022-03-04 | US | Kansas | Osage | 20139 | 3888 | 43 | 0 | 38.65235984 | -95.72707998 | 2022-03-05 04:21:10 | Osage, Kansas, US | |
1647260 | 1647260 | 2022-03-03 | US | South Dakota | Oglala Lakota | 46102 | 3888 | 60 | 0 | 43.33749164 | -102.55554980000001 | 2022-03-04 04:21:09 | Oglala Lakota, South Dakota, US | |
1993987 | 1993987 | 2022-03-01 | US | Kansas | Osage | 20139 | 3888 | 43 | 0 | 38.65235984 | -95.72707998 | 2022-03-02 04:21:07 | Osage, Kansas, US | |
944161 | 944161 | 2022-02-28 | US | Kansas | Osage | 20139 | 3888 | 43 | 0 | 38.65235984 | -95.72707998 | 2022-03-01 04:21:09 | Osage, Kansas, US | |
3858957 | 3858957 | 2022-02-18 | US | Texas | Houston | 48225 | 3888 | 103 | 0 | 31.31925973 | -95.42226208 | 2022-02-19 04:21:11 | Houston, Texas, US | |
2645346 | 2645346 | 2022-02-14 | US | Wisconsin | Washburn | 55129 | 3888 | 43 | 0 | 45.89838588 | -91.79050449 | 2022-02-15 04:21:09 | Washburn, Wisconsin, US | |
2645034 | 2645034 | 2022-02-14 | US | Vermont | Addison | 50001 | 3888 | 15 | 0 | 44.03217337 | -73.14130877 | 2022-02-15 04:21:09 | Addison, Vermont, US | |
1363409 | 1363409 | 2022-02-08 | US | Illinois | Warren | 17187 | 3888 | 79 | 0 | 40.84925021 | -90.6147432 | 2022-02-09 04:21:04 | Warren, Illinois, US | |
73029 | 73029 | 2022-02-07 | US | Missouri | Morgan | 29141 | 3888 | 93 | 0 | 38.4181765 | -92.88791859 | 2022-02-08 04:21:15 | Morgan, Missouri, US | |
461508 | 461508 | 2022-02-02 | US | Nebraska | Unassigned | 90031 | 3888 | 1475 | 0 | 42.8997274 | 0.0 | 2022-02-03 04:21:21 | Unassigned, Nebraska, US | |
3300438 | 3300438 | 2022-01-30 | Russia | Nenets Autonomous Okrug | 3888 | 90 | 0 | 68.27557185 | 57.1686375 | 2022-01-31 04:21:09 | Nenets Autonomous Okrug, Russia | |||
1320506 | 1320506 | 2022-01-26 | US | North Carolina | Bertie | 37015 | 3888 | 59 | 0 | 36.0688473 | -76.96545943 | 2022-01-27 04:21:19 | Bertie, North Carolina, US | |
2833374 | 2833374 | 2022-01-22 | US | California | Colusa | 6011 | 3888 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-01-23 04:21:13 | Colusa, California, US | |
3226942 | 3226942 | 2022-01-19 | US | Arkansas | Hempstead | 5057 | 3888 | 51 | 0 | 33.73325583 | -93.66935133 | 2022-01-20 04:21:07 | Hempstead, Arkansas, US | |
3616164 | 3616164 | 2022-01-12 | US | Texas | Gonzales | 48177 | 3888 | 90 | 0 | 29.45634206 | -97.49424032 | 2022-01-13 08:00:09 | Gonzales, Texas, US | |
129735 | 129735 | 2022-01-09 | US | Tennessee | Union | 47173 | 3888 | 62 | 0 | 36.28590426 | -83.83651902 | 2022-01-10 04:22:07 | Union, Tennessee, US | |
1286519 | 1286519 | 2022-01-04 | US | Arkansas | Ouachita | 5103 | 3888 | 91 | 0 | 33.58839816 | -92.87795984 | 2022-01-05 04:21:59 | Ouachita, Arkansas, US | |
3497007 | 3497007 | 2021-12-15 | US | Georgia | Harris | 13145 | 3888 | 96 | 0 | 32.73709786 | -84.90538572 | 2021-12-16 04:22:11 | Harris, Georgia, US | |
3497006 | 3497006 | 2021-12-15 | US | Georgia | Haralson | 13143 | 3888 | 130 | 0 | 33.79602175 | -85.21005667 | 2021-12-16 04:22:11 | Haralson, Georgia, 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]);