johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
839 rows where deaths = 419 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1075516 | 1075516 | 2022-12-28 | US | Massachusetts | Hampshire | 25015 | 38415 | 419 | 0 | 42.33997957 | -72.65898478 | 2022-12-29 04:21:01 | Hampshire, Massachusetts, US | |
331015 | 331015 | 2022-12-27 | US | Texas | Guadalupe | 48187 | 44571 | 419 | 0 | 29.58165339 | -97.94786822 | 2022-12-28 04:21:04 | Guadalupe, Texas, US | |
329513 | 329513 | 2022-12-27 | US | Massachusetts | Hampshire | 25015 | 38415 | 419 | 0 | 42.33997957 | -72.65898478 | 2022-12-28 04:21:04 | Hampshire, Massachusetts, US | |
221088 | 221088 | 2022-12-26 | US | Texas | Guadalupe | 48187 | 44571 | 419 | 0 | 29.58165339 | -97.94786822 | 2022-12-27 04:21:07 | Guadalupe, Texas, US | |
219586 | 219586 | 2022-12-26 | US | Massachusetts | Hampshire | 25015 | 38415 | 419 | 0 | 42.33997957 | -72.65898478 | 2022-12-27 04:21:07 | Hampshire, Massachusetts, US | |
3225545 | 3225545 | 2022-12-25 | US | Texas | Guadalupe | 48187 | 44571 | 419 | 0 | 29.58165339 | -97.94786822 | 2022-12-26 04:21:06 | Guadalupe, Texas, US | |
3224043 | 3224043 | 2022-12-25 | US | Massachusetts | Hampshire | 25015 | 38415 | 419 | 0 | 42.33997957 | -72.65898478 | 2022-12-26 04:21:06 | Hampshire, Massachusetts, US | |
1021459 | 1021459 | 2022-12-24 | US | Texas | Guadalupe | 48187 | 44571 | 419 | 0 | 29.58165339 | -97.94786822 | 2022-12-25 04:21:04 | Guadalupe, Texas, US | |
1019957 | 1019957 | 2022-12-24 | US | Massachusetts | Hampshire | 25015 | 38415 | 419 | 0 | 42.33997957 | -72.65898478 | 2022-12-25 04:21:04 | Hampshire, Massachusetts, US | |
693482 | 693482 | 2022-12-23 | US | Texas | Guadalupe | 48187 | 44571 | 419 | 0 | 29.58165339 | -97.94786822 | 2022-12-24 04:21:02 | Guadalupe, Texas, US | |
691980 | 691980 | 2022-12-23 | US | Massachusetts | Hampshire | 25015 | 38415 | 419 | 0 | 42.33997957 | -72.65898478 | 2022-12-24 04:21:02 | Hampshire, Massachusetts, US | |
2182692 | 2182692 | 2022-12-22 | US | Texas | Guadalupe | 48187 | 44571 | 419 | 0 | 29.58165339 | -97.94786822 | 2022-12-23 04:21:04 | Guadalupe, Texas, US | |
2181190 | 2181190 | 2022-12-22 | US | Massachusetts | Hampshire | 25015 | 38415 | 419 | 0 | 42.33997957 | -72.65898478 | 2022-12-23 04:21:04 | Hampshire, Massachusetts, US | |
454496 | 454496 | 2022-12-21 | US | Texas | Guadalupe | 48187 | 44571 | 419 | 0 | 29.58165339 | -97.94786822 | 2022-12-22 04:20:56 | Guadalupe, Texas, US | |
453929 | 453929 | 2022-12-21 | US | Oklahoma | Canadian | 40017 | 46764 | 419 | 0 | 35.5426055 | -97.98465569 | 2022-12-22 04:20:56 | Canadian, Oklahoma, US | |
2953928 | 2953928 | 2022-12-20 | US | Oklahoma | Canadian | 40017 | 46764 | 419 | 0 | 35.5426055 | -97.98465569 | 2022-12-21 04:21:03 | Canadian, Oklahoma, US | |
3177196 | 3177196 | 2022-12-19 | US | Virginia | Roanoke City | 51770 | 26944 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-20 04:21:04 | Roanoke City, Virginia, US | |
3176330 | 3176330 | 2022-12-19 | US | Oklahoma | Canadian | 40017 | 46764 | 419 | 0 | 35.5426055 | -97.98465569 | 2022-12-20 04:21:04 | Canadian, Oklahoma, US | |
1631713 | 1631713 | 2022-12-18 | US | Virginia | Roanoke City | 51770 | 26884 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-19 04:21:03 | Roanoke City, Virginia, US | |
1630847 | 1630847 | 2022-12-18 | US | Oklahoma | Canadian | 40017 | 46764 | 419 | 0 | 35.5426055 | -97.98465569 | 2022-12-19 04:21:03 | Canadian, Oklahoma, US | |
507092 | 507092 | 2022-12-17 | US | Virginia | Roanoke City | 51770 | 26884 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-18 04:21:03 | Roanoke City, Virginia, US | |
506226 | 506226 | 2022-12-17 | US | Oklahoma | Canadian | 40017 | 46764 | 419 | 0 | 35.5426055 | -97.98465569 | 2022-12-18 04:21:03 | Canadian, Oklahoma, US | |
3327664 | 3327664 | 2022-12-16 | US | Virginia | Roanoke City | 51770 | 26884 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-17 04:21:04 | Roanoke City, Virginia, US | |
3326798 | 3326798 | 2022-12-16 | US | Oklahoma | Canadian | 40017 | 46764 | 419 | 0 | 35.5426055 | -97.98465569 | 2022-12-17 04:21:04 | Canadian, Oklahoma, US | |
546176 | 546176 | 2022-12-15 | US | Virginia | Roanoke City | 51770 | 26856 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-16 04:21:01 | Roanoke City, Virginia, US | |
545310 | 545310 | 2022-12-15 | US | Oklahoma | Canadian | 40017 | 46764 | 419 | 0 | 35.5426055 | -97.98465569 | 2022-12-16 04:21:01 | Canadian, Oklahoma, US | |
351704 | 351704 | 2022-12-14 | US | Virginia | Roanoke City | 51770 | 26830 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-15 04:20:58 | Roanoke City, Virginia, US | |
348619 | 348619 | 2022-12-14 | Sweden | Kronoberg | 52255 | 419 | 0 | 56.7183 | 14.4115 | 2022-12-15 04:20:58 | Kronoberg, Sweden | |||
311292 | 311292 | 2022-12-13 | US | Virginia | Roanoke City | 51770 | 26808 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-14 04:21:04 | Roanoke City, Virginia, US | |
308963 | 308963 | 2022-12-13 | US | Indiana | Clark | 18019 | 39067 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-14 04:21:04 | Clark, Indiana, US | |
308207 | 308207 | 2022-12-13 | Sweden | Kronoberg | 52255 | 419 | 0 | 56.7183 | 14.4115 | 2022-12-14 04:21:04 | Kronoberg, Sweden | |||
307893 | 307893 | 2022-12-13 | Japan | Miyazaki | 227192 | 419 | 0 | 32.193204 | 131.299374 | 2022-12-14 04:21:04 | Miyazaki, Japan | |||
1152353 | 1152353 | 2022-12-12 | US | Virginia | Roanoke City | 51770 | 26803 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-13 04:21:01 | Roanoke City, Virginia, US | |
1151792 | 1151792 | 2022-12-12 | US | South Carolina | Sumter | 45085 | 33481 | 419 | 0 | 33.91826534 | -80.37942316 | 2022-12-13 04:21:01 | Sumter, South Carolina, US | |
1150024 | 1150024 | 2022-12-12 | US | Indiana | Clark | 18019 | 39067 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-13 04:21:01 | Clark, Indiana, US | |
1149268 | 1149268 | 2022-12-12 | Sweden | Kronoberg | 52255 | 419 | 0 | 56.7183 | 14.4115 | 2022-12-13 04:21:01 | Kronoberg, Sweden | |||
872207 | 872207 | 2022-12-11 | US | Virginia | Roanoke City | 51770 | 26748 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-12 04:21:01 | Roanoke City, Virginia, US | |
871646 | 871646 | 2022-12-11 | US | South Carolina | Sumter | 45085 | 33481 | 419 | 0 | 33.91826534 | -80.37942316 | 2022-12-12 04:21:01 | Sumter, South Carolina, US | |
869878 | 869878 | 2022-12-11 | US | Indiana | Clark | 18019 | 39067 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-12 04:21:01 | Clark, Indiana, US | |
869408 | 869408 | 2022-12-11 | US | Colorado | Boulder | 8013 | 88625 | 419 | 0 | 40.09313619 | -105.3546767 | 2022-12-12 04:21:01 | Boulder, Colorado, US | |
869122 | 869122 | 2022-12-11 | Sweden | Kronoberg | 52255 | 419 | 0 | 56.7183 | 14.4115 | 2022-12-12 04:21:01 | Kronoberg, Sweden | |||
260737 | 260737 | 2022-12-10 | US | Virginia | Roanoke City | 51770 | 26748 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-11 04:20:50 | Roanoke City, Virginia, US | |
260176 | 260176 | 2022-12-10 | US | South Carolina | Sumter | 45085 | 33481 | 419 | 0 | 33.91826534 | -80.37942316 | 2022-12-11 04:20:50 | Sumter, South Carolina, US | |
258408 | 258408 | 2022-12-10 | US | Indiana | Clark | 18019 | 39067 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-11 04:20:50 | Clark, Indiana, US | |
257938 | 257938 | 2022-12-10 | US | Colorado | Boulder | 8013 | 88625 | 419 | 0 | 40.09313619 | -105.3546767 | 2022-12-11 04:20:50 | Boulder, Colorado, US | |
257652 | 257652 | 2022-12-10 | Sweden | Kronoberg | 52255 | 419 | 0 | 56.7183 | 14.4115 | 2022-12-11 04:20:50 | Kronoberg, Sweden | |||
3939451 | 3939451 | 2022-12-09 | US | Virginia | Roanoke City | 51770 | 26748 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-10 04:21:02 | Roanoke City, Virginia, US | |
3938890 | 3938890 | 2022-12-09 | US | South Carolina | Sumter | 45085 | 33481 | 419 | 0 | 33.91826534 | -80.37942316 | 2022-12-10 04:21:02 | Sumter, South Carolina, US | |
3937122 | 3937122 | 2022-12-09 | US | Indiana | Clark | 18019 | 39067 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-10 04:21:02 | Clark, Indiana, US | |
3936652 | 3936652 | 2022-12-09 | US | Colorado | Boulder | 8013 | 88625 | 419 | 0 | 40.09313619 | -105.3546767 | 2022-12-10 04:21:02 | Boulder, Colorado, US | |
3936366 | 3936366 | 2022-12-09 | Sweden | Kronoberg | 52255 | 419 | 0 | 56.7183 | 14.4115 | 2022-12-10 04:21:02 | Kronoberg, Sweden | |||
3380783 | 3380783 | 2022-12-08 | US | Virginia | Roanoke City | 51770 | 26731 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-09 04:21:05 | Roanoke City, Virginia, US | |
3380222 | 3380222 | 2022-12-08 | US | South Carolina | Sumter | 45085 | 33481 | 419 | 0 | 33.91826534 | -80.37942316 | 2022-12-09 04:21:05 | Sumter, South Carolina, US | |
3378454 | 3378454 | 2022-12-08 | US | Indiana | Clark | 18019 | 39067 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-09 04:21:05 | Clark, Indiana, US | |
3377984 | 3377984 | 2022-12-08 | US | Colorado | Boulder | 8013 | 88568 | 419 | 0 | 40.09313619 | -105.3546767 | 2022-12-09 04:21:05 | Boulder, Colorado, US | |
3377698 | 3377698 | 2022-12-08 | Sweden | Kronoberg | 52255 | 419 | 0 | 56.7183 | 14.4115 | 2022-12-09 04:21:05 | Kronoberg, Sweden | |||
1988054 | 1988054 | 2022-12-07 | US | Virginia | Roanoke City | 51770 | 26696 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-08 04:21:07 | Roanoke City, Virginia, US | |
1987493 | 1987493 | 2022-12-07 | US | South Carolina | Sumter | 45085 | 33481 | 419 | 0 | 33.91826534 | -80.37942316 | 2022-12-08 04:21:07 | Sumter, South Carolina, US | |
1985725 | 1985725 | 2022-12-07 | US | Indiana | Clark | 18019 | 39067 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-08 04:21:07 | Clark, Indiana, US | |
3717577 | 3717577 | 2022-12-06 | US | Virginia | Roanoke City | 51770 | 26672 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-07 04:20:58 | Roanoke City, Virginia, US | |
3717016 | 3717016 | 2022-12-06 | US | South Carolina | Sumter | 45085 | 33481 | 419 | 0 | 33.91826534 | -80.37942316 | 2022-12-07 04:20:58 | Sumter, South Carolina, US | |
3715248 | 3715248 | 2022-12-06 | US | Indiana | Clark | 18019 | 38658 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-07 04:20:58 | Clark, Indiana, US | |
2415953 | 2415953 | 2022-12-05 | US | Indiana | Clark | 18019 | 38658 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-06 04:21:03 | Clark, Indiana, US | |
719561 | 719561 | 2022-12-04 | US | Indiana | Clark | 18019 | 38658 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-05 04:20:58 | Clark, Indiana, US | |
2817850 | 2817850 | 2022-12-03 | US | Indiana | Clark | 18019 | 38658 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-04 04:20:56 | Clark, Indiana, US | |
834706 | 834706 | 2022-12-02 | US | Indiana | Clark | 18019 | 38658 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-03 04:21:02 | Clark, Indiana, US | |
2139565 | 2139565 | 2022-12-01 | US | Virginia | Roanoke City | 51770 | 26611 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-02 04:21:07 | Roanoke City, Virginia, US | |
2137236 | 2137236 | 2022-12-01 | US | Indiana | Clark | 18019 | 38658 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-02 04:21:07 | Clark, Indiana, US | |
1967981 | 1967981 | 2022-11-30 | US | Virginia | Roanoke City | 51770 | 26595 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-12-01 04:21:03 | Roanoke City, Virginia, US | |
1965652 | 1965652 | 2022-11-30 | US | Indiana | Clark | 18019 | 38658 | 419 | 0 | 38.48015445 | -85.70510334 | 2022-12-01 04:21:03 | Clark, Indiana, US | |
2559995 | 2559995 | 2022-11-29 | US | Virginia | Roanoke City | 51770 | 26581 | 419 | 0 | 37.27791025 | -79.96189766 | 2022-11-30 04:21:07 | Roanoke City, Virginia, US | |
2557374 | 2557374 | 2022-11-29 | US | Georgia | Columbia | 13073 | 41571 | 419 | 0 | 33.54534185 | -82.263524 | 2022-11-30 04:21:07 | Columbia, Georgia, US | |
1240448 | 1240448 | 2022-11-28 | US | Georgia | Columbia | 13073 | 41571 | 419 | 0 | 33.54534185 | -82.263524 | 2022-11-29 04:21:05 | Columbia, Georgia, US | |
3552436 | 3552436 | 2022-11-27 | US | Georgia | Columbia | 13073 | 41571 | 419 | 0 | 33.54534185 | -82.263524 | 2022-11-28 04:21:02 | Columbia, Georgia, US | |
2100916 | 2100916 | 2022-11-26 | US | Georgia | Columbia | 13073 | 41571 | 419 | 0 | 33.54534185 | -82.263524 | 2022-11-27 04:21:05 | Columbia, Georgia, US | |
488407 | 488407 | 2022-11-25 | US | Georgia | Columbia | 13073 | 41571 | 419 | 0 | 33.54534185 | -82.263524 | 2022-11-26 04:21:11 | Columbia, Georgia, US | |
3524236 | 3524236 | 2022-11-24 | US | Georgia | Columbia | 13073 | 41571 | 419 | 0 | 33.54534185 | -82.263524 | 2022-11-25 04:21:06 | Columbia, Georgia, US | |
3313019 | 3313019 | 2022-11-23 | US | Georgia | Columbia | 13073 | 41571 | 419 | 0 | 33.54534185 | -82.263524 | 2022-11-24 04:21:09 | Columbia, Georgia, US | |
3312563 | 3312563 | 2022-11-23 | Sweden | Varmland | 69637 | 419 | 0 | 59.7294 | 13.2354 | 2022-11-24 04:21:09 | Varmland, Sweden | |||
1623753 | 1623753 | 2022-11-22 | US | West Virginia | Cabell | 54011 | 32830 | 419 | 0 | 38.42424062 | -82.23855912 | 2022-11-23 04:21:06 | Cabell, West Virginia, US | |
1620604 | 1620604 | 2022-11-22 | Sweden | Varmland | 69637 | 419 | 0 | 59.7294 | 13.2354 | 2022-11-23 04:21:06 | Varmland, Sweden | |||
3463641 | 3463641 | 2022-11-21 | US | West Virginia | Cabell | 54011 | 32823 | 419 | 0 | 38.42424062 | -82.23855912 | 2022-11-22 04:20:47 | Cabell, West Virginia, US | |
3460492 | 3460492 | 2022-11-21 | Sweden | Varmland | 69637 | 419 | 0 | 59.7294 | 13.2354 | 2022-11-22 04:20:47 | Varmland, Sweden | |||
1643826 | 1643826 | 2022-11-20 | US | West Virginia | Cabell | 54011 | 32809 | 419 | 0 | 38.42424062 | -82.23855912 | 2022-11-21 04:21:05 | Cabell, West Virginia, US | |
1640677 | 1640677 | 2022-11-20 | Sweden | Varmland | 69637 | 419 | 0 | 59.7294 | 13.2354 | 2022-11-21 04:21:05 | Varmland, Sweden | |||
2067383 | 2067383 | 2022-11-19 | US | West Virginia | Cabell | 54011 | 32809 | 419 | 0 | 38.42424062 | -82.23855912 | 2022-11-20 04:21:08 | Cabell, West Virginia, US | |
2064234 | 2064234 | 2022-11-19 | Sweden | Varmland | 69637 | 419 | 0 | 59.7294 | 13.2354 | 2022-11-20 04:21:08 | Varmland, Sweden | |||
1758777 | 1758777 | 2022-11-18 | US | West Virginia | Cabell | 54011 | 32809 | 419 | 0 | 38.42424062 | -82.23855912 | 2022-11-19 04:21:14 | Cabell, West Virginia, US | |
1755628 | 1755628 | 2022-11-18 | Sweden | Varmland | 69637 | 419 | 0 | 59.7294 | 13.2354 | 2022-11-19 04:21:14 | Varmland, Sweden | |||
3026621 | 3026621 | 2022-11-17 | Sweden | Varmland | 69637 | 419 | 0 | 59.7294 | 13.2354 | 2022-11-18 04:21:15 | Varmland, Sweden | |||
294381 | 294381 | 2022-11-15 | US | North Carolina | Rutherford | 37161 | 20417 | 419 | 0 | 35.40114178 | -81.92112099 | 2022-11-16 04:21:09 | Rutherford, North Carolina, US | |
293600 | 293600 | 2022-11-15 | US | Maryland | Howard | 24027 | 59634 | 419 | 0 | 39.25305293 | -76.93126208 | 2022-11-16 04:21:09 | Howard, Maryland, US | |
3599411 | 3599411 | 2022-11-14 | US | North Carolina | Rutherford | 37161 | 20417 | 419 | 0 | 35.40114178 | -81.92112099 | 2022-11-15 04:21:16 | Rutherford, North Carolina, US | |
314269 | 314269 | 2022-11-13 | US | North Carolina | Rutherford | 37161 | 20417 | 419 | 0 | 35.40114178 | -81.92112099 | 2022-11-14 04:21:09 | Rutherford, North Carolina, US | |
65430 | 65430 | 2022-11-12 | US | North Carolina | Rutherford | 37161 | 20417 | 419 | 0 | 35.40114178 | -81.92112099 | 2022-11-13 04:21:14 | Rutherford, North Carolina, US | |
2929592 | 2929592 | 2022-11-11 | US | North Carolina | Rutherford | 37161 | 20417 | 419 | 0 | 35.40114178 | -81.92112099 | 2022-11-12 04:20:41 | Rutherford, North Carolina, US | |
2508428 | 2508428 | 2022-11-10 | US | North Carolina | Rutherford | 37161 | 20417 | 419 | 0 | 35.40114178 | -81.92112099 | 2022-11-11 04:21:22 | Rutherford, North Carolina, US | |
2433303 | 2433303 | 2022-11-09 | US | North Carolina | Rutherford | 37161 | 20417 | 419 | 0 | 35.40114178 | -81.92112099 | 2022-11-10 04:21:16 | Rutherford, North Carolina, US | |
481959 | 481959 | 2022-11-08 | US | North Carolina | Rutherford | 37161 | 20347 | 419 | 0 | 35.40114178 | -81.92112099 | 2022-11-09 04:21:22 | Rutherford, North Carolina, US | |
2441109 | 2441109 | 2022-11-07 | US | North Carolina | Rutherford | 37161 | 20347 | 419 | 0 | 35.40114178 | -81.92112099 | 2022-11-08 04:21:21 | Rutherford, North Carolina, 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]);