johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
78 rows where confirmed = 11866 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1242477 | 1242477 | 2022-11-28 | US | South Carolina | Chester | 45023 | 11866 | 157 | 0 | 34.69249168 | -81.1583216 | 2022-11-29 04:21:05 | Chester, South Carolina, US | |
3554465 | 3554465 | 2022-11-27 | US | South Carolina | Chester | 45023 | 11866 | 157 | 0 | 34.69249168 | -81.1583216 | 2022-11-28 04:21:02 | Chester, South Carolina, US | |
2102945 | 2102945 | 2022-11-26 | US | South Carolina | Chester | 45023 | 11866 | 157 | 0 | 34.69249168 | -81.1583216 | 2022-11-27 04:21:05 | Chester, South Carolina, US | |
490436 | 490436 | 2022-11-25 | US | South Carolina | Chester | 45023 | 11866 | 157 | 0 | 34.69249168 | -81.1583216 | 2022-11-26 04:21:11 | Chester, South Carolina, US | |
3526265 | 3526265 | 2022-11-24 | US | South Carolina | Chester | 45023 | 11866 | 157 | 0 | 34.69249168 | -81.1583216 | 2022-11-25 04:21:06 | Chester, South Carolina, US | |
3315048 | 3315048 | 2022-11-23 | US | South Carolina | Chester | 45023 | 11866 | 157 | 0 | 34.69249168 | -81.1583216 | 2022-11-24 04:21:09 | Chester, South Carolina, US | |
1623089 | 1623089 | 2022-11-22 | US | South Carolina | Chester | 45023 | 11866 | 157 | 0 | 34.69249168 | -81.1583216 | 2022-11-23 04:21:06 | Chester, South Carolina, US | |
2160600 | 2160600 | 2022-10-16 | US | Illinois | Woodford | 17203 | 11866 | 116 | 0 | 40.78579374 | -89.20973757 | 2022-10-17 04:20:31 | Woodford, Illinois, US | |
516797 | 516797 | 2022-10-15 | US | Illinois | Woodford | 17203 | 11866 | 116 | 0 | 40.78579374 | -89.20973757 | 2022-10-16 04:22:39 | Woodford, Illinois, US | |
2033854 | 2033854 | 2022-10-14 | US | Illinois | Woodford | 17203 | 11866 | 116 | 0 | 40.78579374 | -89.20973757 | 2022-10-15 04:22:00 | Woodford, Illinois, US | |
3996477 | 3996477 | 2022-09-27 | US | Mississippi | Panola | 28107 | 11866 | 173 | 0 | 34.36398677 | -89.95064249 | 2022-09-28 04:23:01 | Panola, Mississippi, US | |
2770805 | 2770805 | 2022-09-26 | US | Mississippi | Panola | 28107 | 11866 | 173 | 0 | 34.36398677 | -89.95064249 | 2022-09-27 04:23:01 | Panola, Mississippi, US | |
1978458 | 1978458 | 2022-09-25 | US | Mississippi | Panola | 28107 | 11866 | 173 | 0 | 34.36398677 | -89.95064249 | 2022-09-26 04:20:52 | Panola, Mississippi, US | |
2651625 | 2651625 | 2022-09-24 | US | Mississippi | Panola | 28107 | 11866 | 173 | 0 | 34.36398677 | -89.95064249 | 2022-09-25 04:23:31 | Panola, Mississippi, US | |
386065 | 386065 | 2022-09-23 | US | Mississippi | Panola | 28107 | 11866 | 173 | 0 | 34.36398677 | -89.95064249 | 2022-09-24 04:21:40 | Panola, Mississippi, US | |
1626131 | 1626131 | 2022-09-22 | US | Mississippi | Panola | 28107 | 11866 | 173 | 0 | 34.36398677 | -89.95064249 | 2022-09-23 04:23:13 | Panola, Mississippi, US | |
1372335 | 1372335 | 2022-09-21 | US | Mississippi | Panola | 28107 | 11866 | 173 | 0 | 34.36398677 | -89.95064249 | 2022-09-22 04:22:56 | Panola, Mississippi, US | |
2018565 | 2018565 | 2022-09-20 | US | Mississippi | Panola | 28107 | 11866 | 173 | 0 | 34.36398677 | -89.95064249 | 2022-09-21 04:23:22 | Panola, Mississippi, US | |
420311 | 420311 | 2022-09-18 | US | Illinois | Christian | 17021 | 11866 | 115 | 0 | 39.54581621 | -89.27780482 | 2022-09-19 04:21:49 | Christian, Illinois, US | |
3374335 | 3374335 | 2022-09-17 | US | Illinois | Christian | 17021 | 11866 | 115 | 0 | 39.54581621 | -89.27780482 | 2022-09-18 04:22:50 | Christian, Illinois, US | |
2356443 | 2356443 | 2022-09-16 | US | Illinois | Christian | 17021 | 11866 | 115 | 0 | 39.54581621 | -89.27780482 | 2022-09-17 04:20:19 | Christian, Illinois, US | |
375412 | 375412 | 2022-09-13 | US | Texas | Rusk | 48401 | 11866 | 236 | 0 | 32.10773545 | -94.76176432 | 2022-09-14 04:20:44 | Rusk, Texas, US | |
2398014 | 2398014 | 2022-09-12 | US | Texas | Rusk | 48401 | 11866 | 236 | 0 | 32.10773545 | -94.76176432 | 2022-09-13 04:20:57 | Rusk, Texas, US | |
3548001 | 3548001 | 2022-09-01 | US | Arkansas | Independence | 5063 | 11866 | 216 | 0 | 35.74242707 | -91.57001641 | 2022-09-02 04:21:07 | Independence, Arkansas, US | |
1087090 | 1087090 | 2022-08-09 | US | Illinois | Livingston | 17105 | 11866 | 137 | 0 | 40.89188292 | -88.55784752 | 2022-08-10 04:20:57 | Livingston, Illinois, US | |
2595654 | 2595654 | 2022-07-25 | US | Michigan | Branch | 26023 | 11866 | 188 | 0 | 41.91600556 | -85.05929476 | 2022-07-26 04:20:58 | Branch, Michigan, US | |
897769 | 897769 | 2022-07-24 | US | Michigan | Branch | 26023 | 11866 | 188 | 0 | 41.91600556 | -85.05929476 | 2022-07-25 04:20:51 | Branch, Michigan, US | |
93557 | 93557 | 2022-07-23 | US | North Dakota | Morton | 38059 | 11866 | 142 | 0 | 46.71681782 | -101.2822377 | 2022-07-24 04:20:47 | Morton, North Dakota, US | |
92763 | 92763 | 2022-07-23 | US | Michigan | Branch | 26023 | 11866 | 188 | 0 | 41.91600556 | -85.05929476 | 2022-07-24 04:20:47 | Branch, Michigan, US | |
901785 | 901785 | 2022-07-22 | US | Michigan | Branch | 26023 | 11866 | 188 | 0 | 41.91600556 | -85.05929476 | 2022-07-23 04:20:53 | Branch, Michigan, US | |
671921 | 671921 | 2022-07-21 | US | Michigan | Branch | 26023 | 11866 | 188 | 0 | 41.91600556 | -85.05929476 | 2022-07-22 04:21:15 | Branch, Michigan, US | |
1609884 | 1609884 | 2022-07-20 | US | Michigan | Branch | 26023 | 11866 | 188 | 0 | 41.91600556 | -85.05929476 | 2022-07-21 04:21:10 | Branch, Michigan, US | |
960517 | 960517 | 2022-07-19 | US | Michigan | Branch | 26023 | 11866 | 188 | 0 | 41.91600556 | -85.05929476 | 2022-07-20 04:20:59 | Branch, Michigan, US | |
3432306 | 3432306 | 2022-07-14 | US | Virginia | Franklin | 51067 | 11866 | 200 | 0 | 36.99536167 | -79.88023649 | 2022-07-15 04:20:53 | Franklin, Virginia, US | |
1764819 | 1764819 | 2022-06-20 | US | Louisiana | Avoyelles | 22009 | 11866 | 211 | 0 | 31.07796211 | -92.00079449 | 2022-06-21 04:20:56 | Avoyelles, Louisiana, US | |
3272443 | 3272443 | 2022-06-19 | US | Tennessee | Cocke | 47029 | 11866 | 223 | 0 | 35.9278914 | -83.11828725 | 2022-06-20 04:21:01 | Cocke, Tennessee, US | |
1574512 | 1574512 | 2022-05-03 | US | North Carolina | Vance | 37181 | 11866 | 113 | 0 | 36.36880673 | -78.40670845 | 2022-05-04 04:20:59 | Vance, North Carolina, US | |
465772 | 465772 | 2022-05-02 | US | North Carolina | Vance | 37181 | 11866 | 113 | 0 | 36.36880673 | -78.40670845 | 2022-05-03 04:21:00 | Vance, North Carolina, US | |
3918411 | 3918411 | 2022-05-01 | US | North Carolina | Vance | 37181 | 11866 | 113 | 0 | 36.36880673 | -78.40670845 | 2022-05-02 04:21:10 | Vance, North Carolina, US | |
2843215 | 2843215 | 2022-04-30 | US | North Carolina | Vance | 37181 | 11866 | 113 | 0 | 36.36880673 | -78.40670845 | 2022-05-01 04:20:57 | Vance, North Carolina, US | |
1159528 | 1159528 | 2022-04-29 | US | North Carolina | Vance | 37181 | 11866 | 113 | 0 | 36.36880673 | -78.40670845 | 2022-04-30 04:21:05 | Vance, North Carolina, US | |
1698710 | 1698710 | 2022-04-28 | US | North Carolina | Vance | 37181 | 11866 | 113 | 0 | 36.36880673 | -78.40670845 | 2022-04-29 04:20:59 | Vance, North Carolina, US | |
3854193 | 3854193 | 2022-04-27 | US | North Carolina | Vance | 37181 | 11866 | 113 | 0 | 36.36880673 | -78.40670845 | 2022-04-28 04:20:47 | Vance, North Carolina, US | |
2252537 | 2252537 | 2022-04-19 | US | Indiana | Lawrence | 18093 | 11866 | 259 | 0 | 38.84112637 | -86.48361629 | 2022-04-20 04:20:45 | Lawrence, Indiana, US | |
1847087 | 1847087 | 2022-04-18 | US | Indiana | Lawrence | 18093 | 11866 | 259 | 0 | 38.84112637 | -86.48361629 | 2022-04-19 04:21:00 | Lawrence, Indiana, US | |
3321517 | 3321517 | 2022-04-07 | US | Kansas | Crawford | 20037 | 11866 | 128 | 0 | 37.50675523 | -94.85245778 | 2022-04-08 04:20:48 | Crawford, Kansas, US | |
2802053 | 2802053 | 2022-04-06 | US | Kansas | Crawford | 20037 | 11866 | 128 | 0 | 37.50675523 | -94.85245778 | 2022-04-07 04:20:53 | Crawford, Kansas, US | |
3868822 | 3868822 | 2022-04-05 | US | Kansas | Crawford | 20037 | 11866 | 128 | 0 | 37.50675523 | -94.85245778 | 2022-04-06 04:20:49 | Crawford, Kansas, US | |
2750164 | 2750164 | 2022-04-04 | US | Kansas | Crawford | 20037 | 11866 | 128 | 0 | 37.50675523 | -94.85245778 | 2022-04-05 04:20:48 | Crawford, Kansas, US | |
3731510 | 3731510 | 2022-04-03 | US | Kansas | Crawford | 20037 | 11866 | 128 | 0 | 37.50675523 | -94.85245778 | 2022-04-04 04:20:51 | Crawford, Kansas, US | |
500945 | 500945 | 2022-04-02 | US | Kansas | Crawford | 20037 | 11866 | 128 | 0 | 37.50675523 | -94.85245778 | 2022-04-03 04:20:48 | Crawford, Kansas, US | |
3351930 | 3351930 | 2022-04-01 | US | Kansas | Crawford | 20037 | 11866 | 128 | 0 | 37.50675523 | -94.85245778 | 2022-04-02 04:20:47 | Crawford, Kansas, US | |
3023293 | 3023293 | 2022-03-23 | US | Illinois | Marion | 17121 | 11866 | 209 | 0 | 38.64963204 | -88.91899208 | 2022-03-24 04:20:43 | Marion, Illinois, US | |
3239302 | 3239302 | 2022-03-21 | US | Illinois | Clinton | 17027 | 11866 | 113 | 0 | 38.60704876 | -89.42385254 | 2022-03-22 04:20:54 | Clinton, Illinois, US | |
1061034 | 1061034 | 2022-02-23 | US | Texas | Nacogdoches | 48347 | 11866 | 252 | 0 | 31.62017125 | -94.61803994 | 2022-02-24 04:21:14 | Nacogdoches, Texas, US | |
2584 | 2584 | 2021-12-02 | US | New York | Ontario | 36069 | 11866 | 119 | 0 | 42.85145728 | -77.30874425 | 2021-12-03 04:23:05 | Ontario, New York, US | |
1887 | 1887 | 2021-12-02 | US | Maine | Kennebec | 23011 | 11866 | 123 | 0 | 44.40759555 | -69.76738544 | 2021-12-03 04:23:05 | Kennebec, Maine, US | |
31785 | 31785 | 2021-11-11 | US | Virginia | Lynchburg | 51680 | 11866 | 191 | 0 | 37.40021399 | -79.19888138 | 2021-11-12 04:22:01 | Lynchburg, Virginia, US | |
3009155 | 3009155 | 2021-10-11 | US | Mississippi | Lauderdale | 28075 | 11866 | 310 | 0 | 32.40419769 | -88.66229662 | 2021-10-12 04:21:09 | Lauderdale, Mississippi, US | |
3808844 | 3808844 | 2021-09-11 | US | Tennessee | Hamblen | 47063 | 11866 | 183 | 0 | 36.21990035 | -83.26586179 | 2021-09-12 04:21:13 | Hamblen, Tennessee, US | |
3194563 | 3194563 | 2021-09-06 | US | California | Napa | 6055 | 11866 | 90 | 0 | 38.50735751 | -122.33283899999999 | 2021-09-07 04:21:35 | Napa, California, US | |
2178900 | 2178900 | 2021-08-22 | US | Virginia | Hampton | 51650 | 11866 | 184 | 0 | 37.03513786 | -76.35879121 | 2021-08-23 04:21:27 | Hampton, Virginia, US | |
3558996 | 3558996 | 2021-08-21 | US | Virginia | Hampton | 51650 | 11866 | 184 | 0 | 37.03513786 | -76.35879121 | 2021-08-22 04:21:29 | Hampton, Virginia, US | |
1857338 | 1857338 | 2021-08-20 | US | Virginia | Hampton | 51650 | 11866 | 184 | 0 | 37.03513786 | -76.35879121 | 2021-08-21 04:21:38 | Hampton, Virginia, US | |
1555506 | 1555506 | 2021-05-08 | US | Wisconsin | Eau Claire | 55035 | 11866 | 119 | 0 | 44.726614 | -91.28609183 | 2021-05-09 04:20:35 | Eau Claire, Wisconsin, US | |
646043 | 646043 | 2021-05-05 | Mexico | Nayarit | 11866 | 1798 | 0 | 10068 | 21.7514 | -104.8455 | 2021-05-06 04:20:38 | Nayarit, Mexico | ||
888915 | 888915 | 2021-04-26 | US | Georgia | Floyd | 13115 | 11866 | 220 | 0 | 34.26268279 | -85.21577392 | 2021-04-27 04:20:52 | Floyd, Georgia, US | |
3645231 | 3645231 | 2021-03-30 | US | Michigan | St. Clair | 26147 | 11866 | 278 | 0 | 42.92655373 | -82.67937954 | 2021-03-31 04:26:25 | St. Clair, Michigan, US | |
1745678 | 1745678 | 2021-03-20 | US | Indiana | Vigo | 18167 | 11866 | 239 | 0 | 39.42944561 | -87.39169027 | 2021-03-21 05:25:44 | Vigo, Indiana, US | |
2285619 | 2285619 | 2021-02-14 | US | New Mexico | McKinley | 35031 | 11866 | 431 | 0 | 11435 | 35.58007720000001 | -108.262245 | 2021-02-15 05:24:49 | McKinley, New Mexico, US |
437956 | 437956 | 2021-01-21 | US | Oregon | Clackamas | 41005 | 11866 | 139 | 0 | 11727 | 45.18787398 | -122.2179634 | 2021-01-22 05:22:10 | Clackamas, Oregon, US |
1139541 | 1139541 | 2021-01-01 | US | Pennsylvania | Erie | 42049 | 11866 | 227 | 0 | 11639 | 41.99253829 | -80.03301954 | 2021-01-02 05:22:33 | Erie, Pennsylvania, US |
3769837 | 3769837 | 2020-12-22 | India | Nagaland | 11866 | 76 | 11373 | 417 | 26.06702 | 94.470302 | 2020-12-23 05:22:03 | Nagaland, India | ||
2131657 | 2131657 | 2020-12-17 | Zimbabwe | 11866 | 314 | 9836 | 1716 | -19.015438 | 29.154857 | 2020-12-18 05:28:18 | Zimbabwe | |||
3849584 | 3849584 | 2020-12-13 | US | Mississippi | Hinds | 28049 | 11866 | 222 | 0 | 11644 | 32.2656285 | -90.44435448 | 2020-12-14 05:26:27 | Hinds, Mississippi, US |
923886 | 923886 | 2020-11-26 | Russia | Karachay-Cherkess Republic | 11866 | 34 | 8195 | 3637 | 43.7368326 | 41.7267991 | 2020-11-27 05:26:53 | Karachay-Cherkess Republic, Russia | ||
3338461 | 3338461 | 2020-11-17 | Congo (Kinshasa) | 11866 | 322 | 11180 | 364 | -4.0383 | 21.7587 | 2020-11-18 05:40:31 | Congo (Kinshasa) | |||
1003333 | 1003333 | 2020-07-09 | US | Connecticut | Hartford | 9003 | 11866 | 1385 | 0 | 10481 | 41.80283011 | -72.73103891 | 2020-07-10 04:34:24 | Hartford, Connecticut, 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]);