johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
83 rows where active = 2380 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385098 | 3385098 | 2021-07-29 | Belarus | 443864 | 3434 | 438050 | 2380 | 53.7098 | 27.9534 | 2021-07-30 04:21:34 | Belarus | |||
20152 | 20152 | 2021-05-28 | Chile | Araucania | 81766 | 1038 | 78348 | 2380 | -38.9489 | -72.3311 | 2021-05-29 04:20:41 | Araucania, Chile | ||
3003360 | 3003360 | 2021-04-06 | Kyrgyzstan | 89277 | 1509 | 85388 | 2380 | 41.20438 | 74.766098 | 2021-04-07 04:20:53 | Kyrgyzstan | |||
3257551 | 3257551 | 2021-03-02 | US | Virginia | Staunton | 51790 | 2446 | 66 | 0 | 2380 | 38.15965544 | -79.05979937 | 2021-03-03 05:23:28 | Staunton, Virginia, US |
2370998 | 2370998 | 2021-02-28 | US | West Virginia | Randolph | 54083 | 2390 | 10 | 0 | 2380 | 38.769899 | -79.87919615 | 2021-03-01 05:23:01 | Randolph, West Virginia, US |
3069500 | 3069500 | 2021-02-27 | US | West Virginia | Randolph | 54083 | 2390 | 10 | 0 | 2380 | 38.769899 | -79.87919615 | 2021-02-28 05:22:20 | Randolph, West Virginia, US |
3067379 | 3067379 | 2021-02-27 | US | Kentucky | Clay | 21051 | 2406 | 26 | 0 | 2380 | 37.16451126 | -83.712575 | 2021-02-28 05:22:20 | Clay, Kentucky, US |
1936834 | 1936834 | 2021-02-23 | US | Alabama | Marengo | 1091 | 2434 | 54 | 0 | 2380 | 32.24767634 | -87.78796182 | 2021-02-24 05:29:16 | Marengo, Alabama, US |
183989 | 183989 | 2021-02-21 | US | Missouri | Saline | 29195 | 2415 | 35 | 0 | 2380 | 39.13734288 | -93.20259964 | 2021-02-22 05:24:21 | Saline, Missouri, US |
471600 | 471600 | 2021-02-19 | Russia | Belgorod Oblast | 30476 | 464 | 27632 | 2380 | 50.7080119 | 37.5837615 | 2021-02-20 05:22:51 | Belgorod Oblast, Russia | ||
2283758 | 2283758 | 2021-02-14 | Thailand | 24571 | 80 | 22111 | 2380 | 15.870032 | 100.992541 | 2021-02-15 05:24:49 | Thailand | |||
2641138 | 2641138 | 2021-02-11 | US | Virginia | Winchester | 51840 | 2402 | 22 | 0 | 2380 | 39.17054517 | -78.17325058 | 2021-02-12 05:23:29 | Winchester, Virginia, US |
978007 | 978007 | 2021-02-06 | US | Texas | Gonzales | 48177 | 2447 | 41 | 0 | 2380 | 29.45634206 | -97.49424032 | 2021-02-07 05:23:00 | Gonzales, Texas, US |
977726 | 977726 | 2021-02-06 | US | South Carolina | Edgefield | 45037 | 2413 | 33 | 0 | 2380 | 33.77221995 | -81.96231108 | 2021-02-07 05:23:00 | Edgefield, South Carolina, US |
343234 | 343234 | 2021-02-03 | US | Tennessee | Marion | 47115 | 2784 | 38 | 0 | 2380 | 35.12997174 | -85.62265895 | 2021-02-04 05:22:26 | Marion, Tennessee, US |
342186 | 342186 | 2021-02-03 | US | Missouri | Lafayette | 29107 | 2428 | 48 | 0 | 2380 | 39.06986886 | -93.78076396 | 2021-02-04 05:22:26 | Lafayette, Missouri, US |
342088 | 342088 | 2021-02-03 | US | Mississippi | Leake | 28079 | 2448 | 68 | 0 | 2380 | 32.7536828 | -89.52402044 | 2021-02-04 05:22:26 | Leake, Mississippi, US |
1677962 | 1677962 | 2021-02-01 | US | Louisiana | De Soto | 22031 | 2445 | 65 | 0 | 2380 | 32.05457447 | -93.74130302 | 2021-02-02 05:22:49 | De Soto, Louisiana, US |
2485458 | 2485458 | 2021-01-28 | US | West Virginia | Mineral | 54057 | 2455 | 75 | 0 | 2380 | 39.41561583 | -78.94104895 | 2021-01-29 05:22:23 | Mineral, West Virginia, US |
2568783 | 2568783 | 2021-01-25 | US | Indiana | Posey | 18129 | 2410 | 30 | 0 | 2380 | 38.02097333 | -87.86480429 | 2021-01-26 05:22:02 | Posey, Indiana, US |
2427835 | 2427835 | 2021-01-23 | US | Idaho | Jerome | 16053 | 2398 | 18 | 0 | 2380 | 42.68891267 | -114.2655033 | 2021-01-24 05:22:35 | Jerome, Idaho, US |
438465 | 438465 | 2021-01-21 | US | Texas | Hill | 48217 | 3182 | 52 | 0 | 2380 | 31.99045053 | -97.13423143 | 2021-01-22 05:22:10 | Hill, Texas, US |
438179 | 438179 | 2021-01-21 | US | South Carolina | Marlboro | 45069 | 2417 | 37 | 0 | 2380 | 34.59905577 | -79.67561152 | 2021-01-22 05:22:10 | Marlboro, South Carolina, US |
437699 | 437699 | 2021-01-21 | US | North Carolina | Pasquotank | 37139 | 2445 | 65 | 0 | 2380 | 36.26723798 | -76.25134778 | 2021-01-22 05:22:10 | Pasquotank, North Carolina, US |
1097633 | 1097633 | 2021-01-20 | US | Wisconsin | Kewaunee | 55061 | 2407 | 27 | 0 | 2380 | 44.51727459 | -87.61468386 | 2021-01-21 05:22:01 | Kewaunee, Wisconsin, US |
1097050 | 1097050 | 2021-01-20 | US | Tennessee | McNairy | 47109 | 2392 | 42 | 0 | 2380 | 35.17468549 | -88.5647812 | 2021-01-21 05:22:01 | McNairy, Tennessee, US |
910020 | 910020 | 2021-01-19 | US | Mississippi | Tippah | 28139 | 2430 | 50 | 0 | 2380 | 34.76872156 | -88.90988194 | 2021-01-20 05:21:54 | Tippah, Mississippi, US |
3519005 | 3519005 | 2021-01-15 | US | Wyoming | Park | 56029 | 2396 | 16 | 0 | 2380 | 44.52157546 | -109.5852825 | 2021-01-16 05:22:40 | Park, Wyoming, US |
2626502 | 2626502 | 2021-01-10 | US | Colorado | Montrose | 8085 | 2766 | 43 | 0 | 2380 | 38.40214114 | -108.26390220000002 | 2021-01-11 05:21:50 | Montrose, Colorado, US |
2866634 | 2866634 | 2021-01-06 | US | Missouri | Marion | 29127 | 2410 | 30 | 0 | 2380 | 39.80601912 | -91.62203062 | 2021-01-07 05:22:03 | Marion, Missouri, US |
2866616 | 2866616 | 2021-01-06 | US | Missouri | Howell | 29091 | 2418 | 38 | 0 | 2380 | 36.77383887 | -91.88683935 | 2021-01-07 05:22:03 | Howell, Missouri, US |
2866278 | 2866278 | 2021-01-06 | US | Maryland | Calvert | 24009 | 2427 | 47 | 0 | 2380 | 38.53961642 | -76.56820632 | 2021-01-07 05:22:03 | Calvert, Maryland, US |
1137411 | 1137411 | 2021-01-01 | US | Arkansas | Yell | 5149 | 2423 | 43 | 0 | 2380 | 35.00292371 | -93.41171338 | 2021-01-02 05:22:33 | Yell, Arkansas, US |
3699026 | 3699026 | 2020-12-31 | US | Wisconsin | Green | 55045 | 2392 | 12 | 0 | 2380 | 42.6794956 | -89.60243287 | 2021-01-01 05:23:07 | Green, Wisconsin, US |
2130306 | 2130306 | 2020-12-17 | US | North Carolina | Halifax | 37083 | 2424 | 44 | 0 | 2380 | 36.25669272 | -77.6556109 | 2020-12-18 05:28:18 | Halifax, North Carolina, US |
1603155 | 1603155 | 2020-12-10 | US | Tennessee | Hardeman | 47069 | 2392 | 40 | 0 | 2380 | 35.20772017 | -88.99161161 | 2020-12-11 05:26:59 | Hardeman, Tennessee, US |
3863360 | 3863360 | 2020-12-04 | US | Wisconsin | Douglas | 55031 | 2386 | 6 | 0 | 2380 | 46.43222285 | -91.91595768 | 2020-12-05 05:27:36 | Douglas, Wisconsin, US |
3861560 | 3861560 | 2020-12-04 | US | Minnesota | McLeod | 27085 | 2401 | 21 | 0 | 2380 | 44.82367677 | -94.27287017 | 2020-12-05 05:27:36 | McLeod, Minnesota, US |
75892 | 75892 | 2020-12-03 | US | Georgia | Habersham | 13137 | 2463 | 83 | 0 | 2380 | 34.63331566 | -83.53094677 | 2020-12-04 05:27:27 | Habersham, Georgia, US |
2938224 | 2938224 | 2020-11-28 | US | Tennessee | Warren | 47177 | 2371 | 20 | 0 | 2380 | 35.6728299 | -85.77969117 | 2020-11-29 05:25:55 | Warren, Tennessee, US |
1350809 | 1350809 | 2020-11-24 | US | Arkansas | Lincoln | 5079 | 2398 | 18 | 0 | 2380 | 33.95317155 | -91.74002806 | 2020-11-25 05:27:20 | Lincoln, Arkansas, US |
821826 | 821826 | 2020-11-19 | Russia | Vladimir Oblast | 11799 | 281 | 9138 | 2380 | 56.0503336 | 40.6561633 | 2020-11-20 05:26:28 | Vladimir Oblast, Russia | ||
3339813 | 3339813 | 2020-11-17 | US | Iowa | Plymouth | 19149 | 2414 | 34 | 0 | 2380 | 42.737633 | -96.21366621 | 2020-11-18 05:40:31 | Plymouth, Iowa, US |
3339013 | 3339013 | 2020-11-17 | US | Alaska | Matanuska-Susitna | 2170 | 2385 | 5 | 0 | 2380 | 62.31305045 | -149.5741743 | 2020-11-18 05:40:31 | Matanuska-Susitna, Alaska, US |
3442419 | 3442419 | 2020-11-11 | US | Michigan | Bay | 26017 | 2453 | 73 | 0 | 2380 | 43.70639106 | -83.98731479 | 2020-11-12 05:25:55 | Bay, Michigan, US |
379190 | 379190 | 2020-11-06 | US | Texas | Bastrop | 48021 | 2092 | 33 | 0 | 2380 | 30.10370699 | -97.31206354 | 2020-11-07 05:24:52 | Bastrop, Texas, US |
892859 | 892859 | 2020-11-05 | US | Georgia | Baldwin | 13009 | 2447 | 67 | 0 | 2380 | 33.06882326 | -83.24701748 | 2020-11-06 05:24:55 | Baldwin, Georgia, US |
892203 | 892203 | 2020-11-05 | Mexico | Durango | 15610 | 861 | 12369 | 2380 | 24.5593 | -104.6588 | 2020-11-06 05:24:55 | Durango, Mexico | ||
2500826 | 2500826 | 2020-11-03 | US | South Carolina | Georgetown | 45043 | 2436 | 56 | 0 | 2380 | 33.43443342 | -79.33202141 | 2020-11-04 05:25:09 | Georgetown, South Carolina, US |
2500677 | 2500677 | 2020-11-03 | US | Pennsylvania | Franklin | 42055 | 2437 | 57 | 0 | 2380 | 39.92956518 | -77.72157791 | 2020-11-04 05:25:09 | Franklin, Pennsylvania, US |
3304105 | 3304105 | 2020-11-02 | Germany | Bremen | 5673 | 73 | 3444 | 2380 | 53.0793 | 8.8017 | 2020-11-03 06:00:16 | Bremen, Germany | ||
210467 | 210467 | 2020-10-29 | Russia | Novgorod Oblast | 7187 | 87 | 4720 | 2380 | 58.2843833 | 32.5169757 | 2020-10-30 04:24:49 | Novgorod Oblast, Russia | ||
10614 | 10614 | 2020-10-25 | US | North Carolina | Caldwell | 37027 | 2399 | 19 | 0 | 2380 | 35.95204977 | -81.54799522 | 2020-10-26 04:25:02 | Caldwell, North Carolina, US |
9430 | 9430 | 2020-10-25 | US | Indiana | Madison | 18095 | 2480 | 100 | 0 | 2380 | 40.16143691 | -85.71964711 | 2020-10-26 04:25:02 | Madison, Indiana, US |
3653990 | 3653990 | 2020-10-24 | US | North Dakota | Ward | 38101 | 2531 | 33 | 0 | 2380 | 48.22390169 | -101.5436763 | 2020-10-25 04:24:36 | Ward, North Dakota, US |
3652796 | 3652796 | 2020-10-24 | US | Iowa | Sioux | 19167 | 2396 | 16 | 0 | 2380 | 43.08221074 | -96.1767568 | 2020-10-25 04:24:36 | Sioux, Iowa, US |
1797438 | 1797438 | 2020-10-19 | US | South Carolina | Greenwood | 45047 | 2454 | 74 | 0 | 2380 | 34.15272415 | -82.12715789 | 2020-10-20 04:24:22 | Greenwood, South Carolina, US |
765126 | 765126 | 2020-10-18 | US | South Carolina | Lancaster | 45057 | 2436 | 56 | 0 | 2380 | 34.68270843 | -80.70513032 | 2020-10-19 04:24:16 | Lancaster, South Carolina, US |
1028334 | 1028334 | 2020-10-17 | US | Montana | Flathead | 30029 | 2403 | 23 | 0 | 2380 | 48.29575866 | -114.0520569 | 2020-10-18 04:24:25 | Flathead, Montana, US |
789348 | 789348 | 2020-10-15 | US | Tennessee | Robertson | 47147 | 2446 | 39 | 0 | 2380 | 36.52454807 | -86.87346725 | 2020-10-16 04:24:01 | Robertson, Tennessee, US |
786693 | 786693 | 2020-10-15 | Sweden | Sormland | 2635 | 255 | 0 | 2380 | 59.0336 | 16.7519 | 2020-10-16 04:24:01 | Sormland, Sweden | ||
1042881 | 1042881 | 2020-10-07 | US | Indiana | Clark | 18019 | 2439 | 59 | 0 | 2380 | 38.48015445 | -85.70510334 | 2020-10-08 04:23:56 | Clark, Indiana, US |
3118573 | 3118573 | 2020-10-06 | US | Indiana | Johnson | 18081 | 2516 | 136 | 0 | 2380 | 39.48994426 | -86.10149107 | 2020-10-07 04:23:40 | Johnson, Indiana, US |
2852463 | 2852463 | 2020-09-18 | Ukraine | Rivne Oblast | 10917 | 149 | 8388 | 2380 | 50.6199 | 26.2516 | 2020-09-19 04:22:00 | Rivne Oblast, Ukraine | ||
669651 | 669651 | 2020-09-16 | US | Virginia | Portsmouth | 51740 | 2427 | 47 | 0 | 2380 | 36.85914825 | -76.35971629 | 2020-09-17 04:22:00 | Portsmouth, Virginia, US |
1447555 | 1447555 | 2020-09-11 | US | Tennessee | Sevier | 47155 | 2378 | 13 | 0 | 2380 | 35.78077323 | -83.52244332 | 2020-09-12 04:25:05 | Sevier, Tennessee, US |
1176220 | 1176220 | 2020-09-10 | US | Texas | Comal | 48091 | 2837 | 101 | 0 | 2380 | 29.80811278 | -98.27647225 | 2020-09-11 04:46:23 | Comal, Texas, US |
1173464 | 1173464 | 2020-09-10 | Spain | Asturias | 3781 | 338 | 1063 | 2380 | 43.3614 | -5.8593 | 2020-09-11 04:46:23 | Asturias, Spain | ||
2174585 | 2174585 | 2020-09-09 | US | Texas | Comal | 48091 | 2801 | 101 | 0 | 2380 | 29.80811278 | -98.27647225 | 2020-09-10 04:29:01 | Comal, Texas, US |
2171547 | 2171547 | 2020-09-09 | Jamaica | 3437 | 38 | 1019 | 2380 | 18.1096 | -77.2975 | 2020-09-10 04:29:01 | Jamaica | |||
3162208 | 3162208 | 2020-09-06 | US | Colorado | Boulder | 8013 | 2682 | 71 | 0 | 2380 | 40.09313619 | -105.3546767 | 2020-09-07 04:28:30 | Boulder, Colorado, US |
1557442 | 1557442 | 2020-08-16 | US | Louisiana | Bossier | 22015 | 2464 | 84 | 0 | 2380 | 32.67932307 | -93.60460152 | 2020-08-17 04:27:20 | Bossier, Louisiana, US |
662018 | 662018 | 2020-08-11 | Azerbaijan | 33731 | 495 | 30856 | 2380 | 40.1431 | 47.5769 | 2020-08-12 04:27:29 | Azerbaijan | |||
369245 | 369245 | 2020-08-08 | US | Louisiana | Iberia | 22045 | 2450 | 70 | 0 | 2380 | 29.86803617 | -91.75871777 | 2020-08-09 04:34:54 | Iberia, Louisiana, US |
456429 | 456429 | 2020-08-07 | US | Louisiana | Iberia | 22045 | 2450 | 70 | 0 | 2380 | 29.86803617 | -91.75871777 | 2020-08-08 04:34:53 | Iberia, Louisiana, US |
3609831 | 3609831 | 2020-08-06 | US | Georgia | Glynn | 13127 | 2422 | 42 | 0 | 2380 | 31.23279254 | -81.53811412 | 2020-08-07 04:35:11 | Glynn, Georgia, US |
1500699 | 1500699 | 2020-07-25 | US | Missouri | Jackson | 29095 | 2433 | 53 | 0 | 2380 | 39.01002188 | -94.34724536 | 2020-07-26 04:35:00 | Jackson, Missouri, US |
61066 | 61066 | 2020-07-23 | US | Arizona | Santa Cruz | 4023 | 2424 | 44 | 0 | 2380 | 31.52508998 | -110.8479088 | 2020-07-24 05:30:40 | Santa Cruz, Arizona, US |
3736633 | 3736633 | 2020-07-12 | US | Virginia | Richmond City | 51760 | 2415 | 35 | 0 | 2380 | 37.53255773 | -77.47966921 | 2020-07-13 04:43:04 | Richmond City, Virginia, US |
2553777 | 2553777 | 2020-06-02 | US | New Hampshire | Hillsborough | 33011 | 2528 | 148 | 0 | 2380 | 42.91537785 | -71.7200253 | 2020-06-03 02:33:13 | Hillsborough, New Hampshire, US |
2546189 | 2546189 | 2020-05-27 | US | Georgia | Hall | 13139 | 2422 | 42 | 0 | 2380 | 34.32207823 | -83.81896936 | 2020-05-28 02:32:31 | Hall, Georgia, US |
2545298 | 2545298 | 2020-05-27 | US | Texas | Bexar | 48029 | 2618 | 69 | 0 | 2380 | 29.44928723 | -98.52019748 | 2020-05-28 02:32:31 | Bexar, Texas, US |
1038264 | 1038264 | 2020-05-26 | US | Texas | Bexar | 48029 | 2564 | 69 | 0 | 2380 | 29.44928723 | -98.52019748 | 2020-05-27 02:32:31 | Bexar, Texas, 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]);