johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
773 rows where active = 235 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
487245 | 487245 | 2021-07-19 | United Kingdom | Gibraltar | 4628 | 94 | 4299 | 235 | 36.1408 | -5.3536 | 2021-07-20 04:21:48 | Gibraltar, United Kingdom | ||
3706164 | 3706164 | 2021-07-17 | Japan | Tochigi | 7385 | 83 | 7067 | 235 | 36.689912 | 139.819213 | 2021-07-18 04:22:07 | Tochigi, Japan | ||
2947311 | 2947311 | 2021-07-16 | India | Madhya Pradesh | 791629 | 10510 | 780884 | 235 | 23.541513 | 78.289633 | 2021-07-17 04:22:22 | Madhya Pradesh, India | ||
833285 | 833285 | 2021-07-09 | Malaysia | W.P. Putrajaya | 2510 | 16 | 2259 | 235 | 2.9264 | 101.6964 | 2021-07-10 04:21:25 | W.P. Putrajaya, Malaysia | ||
1165453 | 1165453 | 2021-07-04 | South Sudan | 10866 | 117 | 10514 | 235 | 6.877000000000002 | 31.307 | 2021-07-05 04:21:28 | South Sudan | |||
1495887 | 1495887 | 2021-07-03 | South Sudan | 10866 | 117 | 10514 | 235 | 6.877000000000002 | 31.307 | 2021-07-04 04:21:38 | South Sudan | |||
2072202 | 2072202 | 2021-07-02 | South Sudan | 10866 | 117 | 10514 | 235 | 6.877000000000002 | 31.307 | 2021-07-03 04:21:37 | South Sudan | |||
3958645 | 3958645 | 2021-06-26 | North Macedonia | 155669 | 5484 | 149950 | 235 | 41.6086 | 21.7453 | 2021-06-27 04:21:39 | North Macedonia | |||
1712308 | 1712308 | 2021-06-25 | Italy | Friuli Venezia Giulia | 106886 | 3787 | 102864 | 235 | 45.6494354 | 13.76813649 | 2021-06-26 04:21:43 | Friuli Venezia Giulia, Italy | ||
562956 | 562956 | 2021-06-22 | Italy | P.A. Bolzano | 73260 | 1180 | 71845 | 235 | 46.49933453 | 11.35662422 | 2021-06-23 04:21:46 | P.A. Bolzano, Italy | ||
107788 | 107788 | 2021-06-19 | Togo | 13715 | 127 | 13353 | 235 | 8.6195 | 0.8248 | 2021-06-20 04:21:48 | Togo | |||
3145778 | 3145778 | 2021-06-07 | Russia | Ingushetia Republic | 15852 | 190 | 15427 | 235 | 43.11542075 | 45.01713552 | 2021-06-08 04:22:35 | Ingushetia Republic, Russia | ||
1711999 | 1711999 | 2021-06-02 | Malaysia | W.P. Putrajaya | 1910 | 12 | 1663 | 235 | 2.9264 | 101.6964 | 2021-06-03 04:23:32 | W.P. Putrajaya, Malaysia | ||
3089308 | 3089308 | 2021-05-30 | Eritrea | 4061 | 14 | 3812 | 235 | 15.1794 | 39.7823 | 2021-05-31 03:08:59 | Eritrea | |||
50677 | 50677 | 2021-05-29 | Eritrea | 4061 | 14 | 3812 | 235 | 15.1794 | 39.7823 | 2021-05-30 04:20:55 | Eritrea | |||
1806742 | 1806742 | 2021-05-27 | Italy | Valle d'Aosta | 11541 | 472 | 10834 | 235 | 45.73750286 | 7.320149366 | 2021-05-28 04:20:36 | Valle d'Aosta, Italy | ||
726698 | 726698 | 2021-05-22 | Russia | Kabardino-Balkarian Republic | 24193 | 465 | 23493 | 235 | 43.4806048 | 43.5978976 | 2021-05-23 04:20:51 | Kabardino-Balkarian Republic, Russia | ||
1913255 | 1913255 | 2021-05-20 | Japan | Toyama | 1613 | 34 | 1344 | 235 | 36.637464 | 137.26934599999998 | 2021-05-21 04:20:43 | Toyama, Japan | ||
2548719 | 2548719 | 2021-04-15 | Colombia | Choco | 7126 | 209 | 6682 | 235 | 5.2528 | -76.82600000000002 | 2021-04-16 04:20:46 | Choco, Colombia | ||
2571718 | 2571718 | 2021-04-13 | Japan | Tochigi | 4954 | 70 | 4649 | 235 | 36.689912 | 139.819213 | 2021-04-14 04:20:41 | Tochigi, Japan | ||
388232 | 388232 | 2021-04-04 | Japan | Gunma | 5111 | 99 | 4777 | 235 | 36.504479 | 138.985605 | 2021-04-05 04:20:35 | Gunma, Japan | ||
3709919 | 3709919 | 2021-04-03 | Chad | 4589 | 164 | 4190 | 235 | 15.4542 | 18.7322 | 2021-04-04 04:20:49 | Chad | |||
241464 | 241464 | 2021-04-02 | Russia | Khakassia Republic | 21882 | 506 | 21141 | 235 | 53.72258845 | 91.44293627 | 2021-04-03 04:20:44 | Khakassia Republic, Russia | ||
1535708 | 1535708 | 2021-03-28 | Chad | 4506 | 162 | 4109 | 235 | 15.4542 | 18.7322 | 2021-03-29 04:28:35 | Chad | |||
3620983 | 3620983 | 2021-03-17 | France | Wallis and Futuna | 242 | 0 | 7 | 235 | -14.2938 | -178.1165 | 2021-03-18 05:26:22 | Wallis and Futuna, France | ||
3670996 | 3670996 | 2021-03-06 | US | Virginia | Norton | 51720 | 241 | 6 | 0 | 235 | 36.93357076 | -82.62750411 | 2021-03-07 05:21:54 | Norton, Virginia, US |
3670917 | 3670917 | 2021-03-06 | US | Virginia | Bath | 51017 | 246 | 11 | 0 | 235 | 38.05852573 | -79.73912095 | 2021-03-07 05:21:54 | Bath, Virginia, US |
1619617 | 1619617 | 2021-03-05 | US | Virginia | Norton | 51720 | 241 | 6 | 0 | 235 | 36.93357076 | -82.62750411 | 2021-03-06 04:23:41 | Norton, Virginia, US |
1619538 | 1619538 | 2021-03-05 | US | Virginia | Bath | 51017 | 245 | 10 | 0 | 235 | 38.05852573 | -79.73912095 | 2021-03-06 04:23:41 | Bath, Virginia, US |
2210949 | 2210949 | 2021-03-04 | US | Virginia | Bath | 51017 | 245 | 10 | 0 | 235 | 38.05852573 | -79.73912095 | 2021-03-05 05:26:29 | Bath, Virginia, US |
1093370 | 1093370 | 2021-03-03 | US | Virginia | Bath | 51017 | 245 | 10 | 0 | 235 | 38.05852573 | -79.73912095 | 2021-03-04 05:24:24 | Bath, Virginia, US |
1092956 | 1092956 | 2021-03-03 | US | South Dakota | McPherson | 46089 | 239 | 4 | 0 | 235 | 45.76626028 | -99.22118798 | 2021-03-04 05:24:24 | McPherson, South Dakota, US |
3257442 | 3257442 | 2021-03-02 | US | Virginia | Bath | 51017 | 245 | 10 | 0 | 235 | 38.05852573 | -79.73912095 | 2021-03-03 05:23:28 | Bath, Virginia, US |
3257028 | 3257028 | 2021-03-02 | US | South Dakota | McPherson | 46089 | 239 | 4 | 0 | 235 | 45.76626028 | -99.22118798 | 2021-03-03 05:23:28 | McPherson, South Dakota, US |
3255407 | 3255407 | 2021-03-02 | US | Kansas | Clark | 20025 | 242 | 7 | 0 | 235 | 37.23577007 | -99.81883015 | 2021-03-03 05:23:28 | Clark, Kansas, US |
1001734 | 1001734 | 2021-03-01 | US | Virginia | Bath | 51017 | 245 | 10 | 0 | 235 | 38.05852573 | -79.73912095 | 2021-03-02 05:23:30 | Bath, Virginia, US |
1001320 | 1001320 | 2021-03-01 | US | South Dakota | McPherson | 46089 | 239 | 4 | 0 | 235 | 45.76626028 | -99.22118798 | 2021-03-02 05:23:30 | McPherson, South Dakota, US |
999699 | 999699 | 2021-03-01 | US | Kansas | Clark | 20025 | 242 | 7 | 0 | 235 | 37.23577007 | -99.81883015 | 2021-03-02 05:23:30 | Clark, Kansas, US |
2370792 | 2370792 | 2021-02-28 | US | Virginia | Bath | 51017 | 245 | 10 | 0 | 235 | 38.05852573 | -79.73912095 | 2021-03-01 05:23:01 | Bath, Virginia, US |
2370378 | 2370378 | 2021-02-28 | US | South Dakota | McPherson | 46089 | 239 | 4 | 0 | 235 | 45.76626028 | -99.22118798 | 2021-03-01 05:23:01 | McPherson, South Dakota, US |
3069294 | 3069294 | 2021-02-27 | US | Virginia | Bath | 51017 | 245 | 10 | 0 | 235 | 38.05852573 | -79.73912095 | 2021-02-28 05:22:20 | Bath, Virginia, US |
3068880 | 3068880 | 2021-02-27 | US | South Dakota | McPherson | 46089 | 239 | 4 | 0 | 235 | 45.76626028 | -99.22118798 | 2021-02-28 05:22:20 | McPherson, South Dakota, US |
1860763 | 1860763 | 2021-02-25 | US | Puerto Rico | Out of PR | 72888 | 235 | 0 | 0 | 235 | 18.459681 | -67.336525 | 2021-02-26 05:22:40 | Out of PR, Puerto Rico, US |
1939184 | 1939184 | 2021-02-23 | US | Puerto Rico | Guayanilla | 72059 | 235 | 0 | 0 | 235 | 18.039942 | -66.79186 | 2021-02-24 05:29:16 | Guayanilla, Puerto Rico, US |
533439 | 533439 | 2021-02-22 | US | Puerto Rico | Guayanilla | 72059 | 235 | 0 | 0 | 235 | 18.039942 | -66.79186 | 2021-02-23 05:23:41 | Guayanilla, Puerto Rico, US |
184773 | 184773 | 2021-02-21 | US | Puerto Rico | Guayanilla | 72059 | 235 | 0 | 0 | 235 | 18.039942 | -66.79186 | 2021-02-22 05:24:21 | Guayanilla, Puerto Rico, US |
3601675 | 3601675 | 2021-02-17 | US | Colorado | Ouray | 8091 | 256 | 3 | 0 | 235 | 38.14717457 | -107.7675136 | 2021-02-18 05:22:58 | Ouray, Colorado, US |
3980130 | 3980130 | 2021-02-10 | US | Maine | Piscataquis | 23021 | 236 | 1 | 0 | 235 | 45.83839062 | -69.2860223 | 2021-02-11 05:23:55 | Piscataquis, Maine, US |
616551 | 616551 | 2021-02-08 | US | South Dakota | Haakon | 46055 | 244 | 9 | 0 | 235 | 44.29299053 | -101.539099 | 2021-02-09 05:23:30 | Haakon, South Dakota, US |
1675320 | 1675320 | 2021-02-07 | US | South Dakota | Haakon | 46055 | 244 | 9 | 0 | 235 | 44.29299053 | -101.539099 | 2021-02-08 05:22:39 | Haakon, South Dakota, US |
977781 | 977781 | 2021-02-06 | US | South Dakota | Haakon | 46055 | 244 | 9 | 0 | 235 | 44.29299053 | -101.539099 | 2021-02-07 05:23:00 | Haakon, South Dakota, US |
1591385 | 1591385 | 2021-02-05 | US | Texas | Shackelford | 48417 | 228 | 2 | 0 | 235 | 32.73587756 | -99.35401337 | 2021-02-06 05:23:55 | Shackelford, Texas, US |
793517 | 793517 | 2021-02-04 | US | Texas | Kimble | 48267 | 224 | 6 | 0 | 235 | 30.48678918 | -99.74856473 | 2021-02-05 05:22:38 | Kimble, Texas, US |
1676740 | 1676740 | 2021-02-01 | San Marino | 3025 | 67 | 2723 | 235 | 43.9424 | 12.4578 | 2021-02-02 05:22:49 | San Marino | |||
1460028 | 1460028 | 2021-01-31 | San Marino | 3025 | 67 | 2723 | 235 | 43.9424 | 12.4578 | 2021-02-01 05:22:53 | San Marino | |||
2214313 | 2214313 | 2021-01-30 | US | Pennsylvania | Cameron | 42023 | 242 | 7 | 0 | 235 | 41.43625568 | -78.20376845 | 2021-01-31 05:22:42 | Cameron, Pennsylvania, US |
2213618 | 2213618 | 2021-01-30 | US | Missouri | Scotland | 29199 | 238 | 3 | 0 | 235 | 40.45214695 | -92.14709064 | 2021-01-31 05:22:42 | Scotland, Missouri, US |
3154036 | 3154036 | 2021-01-27 | US | Alaska | Unassigned | 90002 | 235 | 0 | 0 | 235 | 69.31479216 | 0.0 | 2021-01-28 05:22:24 | Unassigned, Alaska, US |
15223 | 15223 | 2021-01-26 | US | South Dakota | Mellette | 46095 | 237 | 2 | 0 | 235 | 43.58078848 | -100.7563186 | 2021-01-27 05:23:41 | Mellette, South Dakota, US |
2570547 | 2570547 | 2021-01-25 | US | South Dakota | Mellette | 46095 | 237 | 2 | 0 | 235 | 43.58078848 | -100.7563186 | 2021-01-26 05:22:02 | Mellette, South Dakota, US |
1762745 | 1762745 | 2021-01-24 | US | Washington | Skamania | 53059 | 236 | 1 | 0 | 235 | 46.02408726 | -121.9164403 | 2021-01-25 05:22:16 | Skamania, Washington, US |
1762648 | 1762648 | 2021-01-24 | US | Virginia | King and Queen | 51097 | 238 | 3 | 0 | 235 | 37.71044922 | -76.88689628 | 2021-01-25 05:22:16 | King and Queen, Virginia, US |
1762179 | 1762179 | 2021-01-24 | US | South Dakota | Mellette | 46095 | 237 | 2 | 0 | 235 | 43.58078848 | -100.7563186 | 2021-01-25 05:22:16 | Mellette, South Dakota, US |
2430352 | 2430352 | 2021-01-23 | US | Washington | Skamania | 53059 | 236 | 1 | 0 | 235 | 46.02408726 | -121.9164403 | 2021-01-24 05:22:35 | Skamania, Washington, US |
2429786 | 2429786 | 2021-01-23 | US | South Dakota | Mellette | 46095 | 237 | 2 | 0 | 235 | 43.58078848 | -100.7563186 | 2021-01-24 05:22:35 | Mellette, South Dakota, US |
2469421 | 2469421 | 2021-01-22 | US | Oregon | Lake | 41037 | 240 | 5 | 0 | 235 | 42.79246693 | -120.3850163 | 2021-01-23 05:22:03 | Lake, Oregon, US |
908212 | 908212 | 2021-01-19 | Japan | Saga | 812 | 4 | 573 | 235 | 33.286977 | 130.115738 | 2021-01-20 05:21:54 | Saga, Japan | ||
908135 | 908135 | 2021-01-19 | India | Manipur | 28900 | 367 | 28298 | 235 | 24.738975 | 93.882541 | 2021-01-20 05:21:54 | Manipur, India | ||
240388 | 240388 | 2021-01-18 | US | Texas | Lipscomb | 48295 | 296 | 10 | 0 | 235 | 36.27783108 | -100.2733151 | 2021-01-19 05:22:15 | Lipscomb, Texas, US |
3506505 | 3506505 | 2021-01-17 | US | Texas | Lipscomb | 48295 | 296 | 10 | 0 | 235 | 36.27783108 | -100.2733151 | 2021-01-18 05:22:34 | Lipscomb, Texas, US |
3104588 | 3104588 | 2021-01-16 | US | Texas | Lipscomb | 48295 | 296 | 10 | 0 | 235 | 36.27783108 | -100.2733151 | 2021-01-17 05:22:17 | Lipscomb, Texas, US |
3517793 | 3517793 | 2021-01-15 | US | North Dakota | Golden Valley | 38033 | 237 | 1 | 0 | 235 | 46.94022281 | -103.8465421 | 2021-01-16 05:22:40 | Golden Valley, North Dakota, US |
3882722 | 3882722 | 2021-01-14 | US | Texas | Lipscomb | 48295 | 295 | 9 | 0 | 235 | 36.27783108 | -100.2733151 | 2021-01-15 05:22:24 | Lipscomb, Texas, US |
3881524 | 3881524 | 2021-01-14 | US | Missouri | Schuyler | 29197 | 236 | 1 | 0 | 235 | 40.46921489 | -92.52311943 | 2021-01-15 05:22:24 | Schuyler, Missouri, US |
3880602 | 3880602 | 2021-01-14 | US | Illinois | Pope | 17151 | 237 | 2 | 0 | 235 | 37.41391284 | -88.56152109 | 2021-01-15 05:22:24 | Pope, Illinois, US |
3311349 | 3311349 | 2021-01-13 | US | Texas | Lipscomb | 48295 | 295 | 9 | 0 | 235 | 36.27783108 | -100.2733151 | 2021-01-14 05:22:32 | Lipscomb, Texas, US |
3308610 | 3308610 | 2021-01-13 | US | Alaska | Aleutians West | 2016 | 235 | 0 | 0 | 235 | 52.3233 | -174.1596 | 2021-01-14 05:22:32 | Aleutians West, Alaska, US |
777539 | 777539 | 2021-01-12 | US | Texas | Real | 48385 | 265 | 12 | 0 | 235 | 29.83321503 | -99.82018052 | 2021-01-13 05:22:15 | Real, Texas, US |
776109 | 776109 | 2021-01-12 | US | Minnesota | Traverse | 27155 | 238 | 3 | 0 | 235 | 45.77298854 | -96.47062949 | 2021-01-13 05:22:15 | Traverse, Minnesota, US |
193260 | 193260 | 2021-01-11 | US | Texas | Real | 48385 | 265 | 12 | 0 | 235 | 29.83321503 | -99.82018052 | 2021-01-12 05:22:15 | Real, Texas, US |
2629063 | 2629063 | 2021-01-10 | US | Texas | Real | 48385 | 265 | 12 | 0 | 235 | 29.83321503 | -99.82018052 | 2021-01-11 05:21:50 | Real, Texas, US |
3903151 | 3903151 | 2021-01-09 | US | Texas | Real | 48385 | 265 | 12 | 0 | 235 | 29.83321503 | -99.82018052 | 2021-01-10 05:22:12 | Real, Texas, US |
157057 | 157057 | 2021-01-08 | US | Texas | Fisher | 48151 | 269 | 10 | 0 | 235 | 32.74281316 | -100.4019302 | 2021-01-09 05:22:18 | Fisher, Texas, US |
155657 | 155657 | 2021-01-08 | US | Michigan | Schoolcraft | 26153 | 239 | 4 | 0 | 235 | 46.19235734 | -86.19972234 | 2021-01-09 05:22:18 | Schoolcraft, Michigan, US |
2544168 | 2544168 | 2021-01-07 | US | Puerto Rico | Rincon | 72117 | 235 | 0 | 0 | 235 | 18.335443 | -67.23174 | 2021-01-08 05:22:42 | Rincon, Puerto Rico, US |
2543081 | 2543081 | 2021-01-07 | US | Michigan | Schoolcraft | 26153 | 239 | 4 | 0 | 235 | 46.19235734 | -86.19972234 | 2021-01-08 05:22:42 | Schoolcraft, Michigan, US |
2542391 | 2542391 | 2021-01-07 | US | Illinois | Hardin | 17069 | 243 | 8 | 0 | 235 | 37.51810645 | -88.26873022 | 2021-01-08 05:22:42 | Hardin, Illinois, US |
2541547 | 2541547 | 2021-01-07 | Pakistan | Balochistan | 18314 | 186 | 17893 | 235 | 28.328492 | 65.898403 | 2021-01-08 05:22:42 | Balochistan, Pakistan | ||
2867477 | 2867477 | 2021-01-06 | US | Puerto Rico | Rincon | 72117 | 235 | 0 | 0 | 235 | 18.335443 | -67.23174 | 2021-01-07 05:22:03 | Rincon, Puerto Rico, US |
3034256 | 3034256 | 2021-01-05 | India | Ladakh | 9577 | 127 | 9215 | 235 | 34.1526 | 77.5771 | 2021-01-06 05:22:16 | Ladakh, India | ||
1063283 | 1063283 | 2021-01-04 | US | Kentucky | Menifee | 21165 | 237 | 2 | 0 | 235 | 37.94090733 | -83.59985712 | 2021-01-05 05:21:49 | Menifee, Kentucky, US |
1063103 | 1063103 | 2021-01-04 | US | Kansas | Chase | 20017 | 238 | 3 | 0 | 235 | 38.30292938 | -96.59563862 | 2021-01-05 05:21:49 | Chase, Kansas, US |
3234046 | 3234046 | 2021-01-03 | US | Wyoming | Hot Springs | 56017 | 236 | 1 | 0 | 235 | 43.71930657 | -108.4423174 | 2021-01-04 05:22:02 | Hot Springs, Wyoming, US |
3231706 | 3231706 | 2021-01-03 | US | Kansas | Chase | 20017 | 238 | 3 | 0 | 235 | 38.30292938 | -96.59563862 | 2021-01-04 05:22:02 | Chase, Kansas, US |
2229706 | 2229706 | 2021-01-02 | US | New Mexico | Hidalgo | 35023 | 243 | 8 | 0 | 235 | 31.91383467 | -108.7151824 | 2021-01-03 05:22:52 | Hidalgo, New Mexico, US |
2228775 | 2228775 | 2021-01-02 | US | Kansas | Chase | 20017 | 238 | 3 | 0 | 235 | 38.30292938 | -96.59563862 | 2021-01-03 05:22:52 | Chase, Kansas, US |
1138139 | 1138139 | 2021-01-01 | US | Kansas | Chase | 20017 | 238 | 3 | 0 | 235 | 38.30292938 | -96.59563862 | 2021-01-02 05:22:33 | Chase, Kansas, US |
3696745 | 3696745 | 2020-12-31 | US | Kansas | Chase | 20017 | 238 | 3 | 0 | 235 | 38.30292938 | -96.59563862 | 2021-01-01 05:23:07 | Chase, Kansas, US |
1011560 | 1011560 | 2020-12-30 | US | Kansas | Chase | 20017 | 238 | 3 | 0 | 235 | 38.30292938 | -96.59563862 | 2020-12-31 05:22:49 | Chase, Kansas, US |
769786 | 769786 | 2020-12-29 | US | West Virginia | Doddridge | 54017 | 238 | 3 | 0 | 235 | 39.27057157 | -80.70671527 | 2020-12-30 05:22:34 | Doddridge, West 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]);