johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,199 rows where deaths = 249 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755929 | 2755929 | 2022-12-29 | US | Texas | Bastrop | 48021 | 26564 | 249 | 0 | 30.10370699 | -97.31206354 | 2022-12-30 04:21:04 | Bastrop, Texas, US | |
2755235 | 2755235 | 2022-12-29 | US | North Carolina | Haywood | 37087 | 16529 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-30 04:21:04 | Haywood, North Carolina, US | |
2754005 | 2754005 | 2022-12-29 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-30 04:21:04 | Henry, Indiana, US | |
1076935 | 1076935 | 2022-12-28 | US | Texas | Bastrop | 48021 | 26564 | 249 | 0 | 30.10370699 | -97.31206354 | 2022-12-29 04:21:01 | Bastrop, Texas, US | |
1076241 | 1076241 | 2022-12-28 | US | North Carolina | Haywood | 37087 | 16529 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-29 04:21:01 | Haywood, North Carolina, US | |
1075011 | 1075011 | 2022-12-28 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-29 04:21:01 | Henry, Indiana, US | |
331016 | 331016 | 2022-12-27 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-28 04:21:04 | Hale, Texas, US | |
330932 | 330932 | 2022-12-27 | US | Texas | Bastrop | 48021 | 26453 | 249 | 0 | 30.10370699 | -97.31206354 | 2022-12-28 04:21:04 | Bastrop, Texas, US | |
330238 | 330238 | 2022-12-27 | US | North Carolina | Haywood | 37087 | 16529 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-28 04:21:04 | Haywood, North Carolina, US | |
329008 | 329008 | 2022-12-27 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-28 04:21:04 | Henry, Indiana, US | |
221089 | 221089 | 2022-12-26 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-27 04:21:07 | Hale, Texas, US | |
221005 | 221005 | 2022-12-26 | US | Texas | Bastrop | 48021 | 26453 | 249 | 0 | 30.10370699 | -97.31206354 | 2022-12-27 04:21:07 | Bastrop, Texas, US | |
220311 | 220311 | 2022-12-26 | US | North Carolina | Haywood | 37087 | 16529 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-27 04:21:07 | Haywood, North Carolina, US | |
219081 | 219081 | 2022-12-26 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-27 04:21:07 | Henry, Indiana, US | |
3225546 | 3225546 | 2022-12-25 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-26 04:21:06 | Hale, Texas, US | |
3225462 | 3225462 | 2022-12-25 | US | Texas | Bastrop | 48021 | 26453 | 249 | 0 | 30.10370699 | -97.31206354 | 2022-12-26 04:21:06 | Bastrop, Texas, US | |
3224768 | 3224768 | 2022-12-25 | US | North Carolina | Haywood | 37087 | 16529 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-26 04:21:06 | Haywood, North Carolina, US | |
3223538 | 3223538 | 2022-12-25 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-26 04:21:06 | Henry, Indiana, US | |
1021460 | 1021460 | 2022-12-24 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-25 04:21:04 | Hale, Texas, US | |
1021376 | 1021376 | 2022-12-24 | US | Texas | Bastrop | 48021 | 26453 | 249 | 0 | 30.10370699 | -97.31206354 | 2022-12-25 04:21:04 | Bastrop, Texas, US | |
1020682 | 1020682 | 2022-12-24 | US | North Carolina | Haywood | 37087 | 16529 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-25 04:21:04 | Haywood, North Carolina, US | |
1019452 | 1019452 | 2022-12-24 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-25 04:21:04 | Henry, Indiana, US | |
693483 | 693483 | 2022-12-23 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-24 04:21:02 | Hale, Texas, US | |
693399 | 693399 | 2022-12-23 | US | Texas | Bastrop | 48021 | 26453 | 249 | 0 | 30.10370699 | -97.31206354 | 2022-12-24 04:21:02 | Bastrop, Texas, US | |
692705 | 692705 | 2022-12-23 | US | North Carolina | Haywood | 37087 | 16529 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-24 04:21:02 | Haywood, North Carolina, US | |
691475 | 691475 | 2022-12-23 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-24 04:21:02 | Henry, Indiana, US | |
2182693 | 2182693 | 2022-12-22 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-23 04:21:04 | Hale, Texas, US | |
2182609 | 2182609 | 2022-12-22 | US | Texas | Bastrop | 48021 | 26453 | 249 | 0 | 30.10370699 | -97.31206354 | 2022-12-23 04:21:04 | Bastrop, Texas, US | |
2181915 | 2181915 | 2022-12-22 | US | North Carolina | Haywood | 37087 | 16529 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-23 04:21:04 | Haywood, North Carolina, US | |
2180685 | 2180685 | 2022-12-22 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-23 04:21:04 | Henry, Indiana, US | |
454497 | 454497 | 2022-12-21 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-22 04:20:56 | Hale, Texas, US | |
454413 | 454413 | 2022-12-21 | US | Texas | Bastrop | 48021 | 26453 | 249 | 0 | 30.10370699 | -97.31206354 | 2022-12-22 04:20:56 | Bastrop, Texas, US | |
453719 | 453719 | 2022-12-21 | US | North Carolina | Haywood | 37087 | 16529 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-22 04:20:56 | Haywood, North Carolina, US | |
452489 | 452489 | 2022-12-21 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-22 04:20:56 | Henry, Indiana, US | |
2954496 | 2954496 | 2022-12-20 | US | Texas | Hale | 48189 | 8048 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-21 04:21:03 | Hale, Texas, US | |
2953718 | 2953718 | 2022-12-20 | US | North Carolina | Haywood | 37087 | 16443 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-21 04:21:03 | Haywood, North Carolina, US | |
2952488 | 2952488 | 2022-12-20 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-21 04:21:03 | Henry, Indiana, US | |
2951411 | 2951411 | 2022-12-20 | Japan | Tokushima | 121493 | 249 | 0 | 33.919178 | 134.242091 | 2022-12-21 04:21:03 | Tokushima, Japan | |||
3176898 | 3176898 | 2022-12-19 | US | Texas | Hale | 48189 | 8048 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-20 04:21:04 | Hale, Texas, US | |
3176120 | 3176120 | 2022-12-19 | US | North Carolina | Haywood | 37087 | 16443 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-20 04:21:04 | Haywood, North Carolina, US | |
3174890 | 3174890 | 2022-12-19 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-20 04:21:04 | Henry, Indiana, US | |
1631415 | 1631415 | 2022-12-18 | US | Texas | Hale | 48189 | 8048 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-19 04:21:03 | Hale, Texas, US | |
1630637 | 1630637 | 2022-12-18 | US | North Carolina | Haywood | 37087 | 16443 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-19 04:21:03 | Haywood, North Carolina, US | |
1629407 | 1629407 | 2022-12-18 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-19 04:21:03 | Henry, Indiana, US | |
506794 | 506794 | 2022-12-17 | US | Texas | Hale | 48189 | 8048 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-18 04:21:03 | Hale, Texas, US | |
506016 | 506016 | 2022-12-17 | US | North Carolina | Haywood | 37087 | 16443 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-18 04:21:03 | Haywood, North Carolina, US | |
504786 | 504786 | 2022-12-17 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-18 04:21:03 | Henry, Indiana, US | |
3327366 | 3327366 | 2022-12-16 | US | Texas | Hale | 48189 | 8048 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-17 04:21:04 | Hale, Texas, US | |
3326588 | 3326588 | 2022-12-16 | US | North Carolina | Haywood | 37087 | 16443 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-17 04:21:04 | Haywood, North Carolina, US | |
3325358 | 3325358 | 2022-12-16 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-17 04:21:04 | Henry, Indiana, US | |
545878 | 545878 | 2022-12-15 | US | Texas | Hale | 48189 | 8048 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-16 04:21:01 | Hale, Texas, US | |
545100 | 545100 | 2022-12-15 | US | North Carolina | Haywood | 37087 | 16443 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-16 04:21:01 | Haywood, North Carolina, US | |
543870 | 543870 | 2022-12-15 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-16 04:21:01 | Henry, Indiana, US | |
351406 | 351406 | 2022-12-14 | US | Texas | Hale | 48189 | 8048 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-15 04:20:58 | Hale, Texas, US | |
350628 | 350628 | 2022-12-14 | US | North Carolina | Haywood | 37087 | 16443 | 249 | 0 | 35.55269063 | -82.98196486 | 2022-12-15 04:20:58 | Haywood, North Carolina, US | |
349398 | 349398 | 2022-12-14 | US | Indiana | Henry | 18065 | 15648 | 249 | 0 | 39.93029017 | -85.39625719 | 2022-12-15 04:20:58 | Henry, Indiana, US | |
310994 | 310994 | 2022-12-13 | US | Texas | Hale | 48189 | 7947 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-14 04:21:04 | Hale, Texas, US | |
1152055 | 1152055 | 2022-12-12 | US | Texas | Hale | 48189 | 7947 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-13 04:21:01 | Hale, Texas, US | |
871909 | 871909 | 2022-12-11 | US | Texas | Hale | 48189 | 7947 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-12 04:21:01 | Hale, Texas, US | |
260439 | 260439 | 2022-12-10 | US | Texas | Hale | 48189 | 7947 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-11 04:20:50 | Hale, Texas, US | |
3939153 | 3939153 | 2022-12-09 | US | Texas | Hale | 48189 | 7947 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-10 04:21:02 | Hale, Texas, US | |
3380485 | 3380485 | 2022-12-08 | US | Texas | Hale | 48189 | 7947 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-09 04:21:05 | Hale, Texas, US | |
1987756 | 1987756 | 2022-12-07 | US | Texas | Hale | 48189 | 7947 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-08 04:21:07 | Hale, Texas, US | |
3717583 | 3717583 | 2022-12-06 | US | Virginia | Shenandoah | 51171 | 13210 | 249 | 0 | 38.85905135 | -78.56813762 | 2022-12-07 04:20:58 | Shenandoah, Virginia, US | |
3717279 | 3717279 | 2022-12-06 | US | Texas | Hale | 48189 | 7875 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-07 04:20:58 | Hale, Texas, US | |
2418288 | 2418288 | 2022-12-05 | US | Virginia | Shenandoah | 51171 | 13177 | 249 | 0 | 38.85905135 | -78.56813762 | 2022-12-06 04:21:03 | Shenandoah, Virginia, US | |
2417984 | 2417984 | 2022-12-05 | US | Texas | Hale | 48189 | 7875 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-06 04:21:03 | Hale, Texas, US | |
2416706 | 2416706 | 2022-12-05 | US | Mississippi | Lowndes | 28087 | 20305 | 249 | 0 | 33.47386518 | -88.4419153 | 2022-12-06 04:21:03 | Lowndes, Mississippi, US | |
2416545 | 2416545 | 2022-12-05 | US | Michigan | Midland | 26111 | 22812 | 249 | 0 | 43.64330771 | -84.38804374 | 2022-12-06 04:21:03 | Midland, Michigan, US | |
721896 | 721896 | 2022-12-04 | US | Virginia | Shenandoah | 51171 | 13154 | 249 | 0 | 38.85905135 | -78.56813762 | 2022-12-05 04:20:58 | Shenandoah, Virginia, US | |
721592 | 721592 | 2022-12-04 | US | Texas | Hale | 48189 | 7875 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-05 04:20:58 | Hale, Texas, US | |
720314 | 720314 | 2022-12-04 | US | Mississippi | Lowndes | 28087 | 20305 | 249 | 0 | 33.47386518 | -88.4419153 | 2022-12-05 04:20:58 | Lowndes, Mississippi, US | |
720153 | 720153 | 2022-12-04 | US | Michigan | Midland | 26111 | 22812 | 249 | 0 | 43.64330771 | -84.38804374 | 2022-12-05 04:20:58 | Midland, Michigan, US | |
2820185 | 2820185 | 2022-12-03 | US | Virginia | Shenandoah | 51171 | 13154 | 249 | 0 | 38.85905135 | -78.56813762 | 2022-12-04 04:20:56 | Shenandoah, Virginia, US | |
2819881 | 2819881 | 2022-12-03 | US | Texas | Hale | 48189 | 7875 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-04 04:20:56 | Hale, Texas, US | |
2818603 | 2818603 | 2022-12-03 | US | Mississippi | Lowndes | 28087 | 20305 | 249 | 0 | 33.47386518 | -88.4419153 | 2022-12-04 04:20:56 | Lowndes, Mississippi, US | |
2818442 | 2818442 | 2022-12-03 | US | Michigan | Midland | 26111 | 22812 | 249 | 0 | 43.64330771 | -84.38804374 | 2022-12-04 04:20:56 | Midland, Michigan, US | |
837041 | 837041 | 2022-12-02 | US | Virginia | Shenandoah | 51171 | 13154 | 249 | 0 | 38.85905135 | -78.56813762 | 2022-12-03 04:21:02 | Shenandoah, Virginia, US | |
836737 | 836737 | 2022-12-02 | US | Texas | Hale | 48189 | 7875 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-03 04:21:02 | Hale, Texas, US | |
835459 | 835459 | 2022-12-02 | US | Mississippi | Lowndes | 28087 | 20305 | 249 | 0 | 33.47386518 | -88.4419153 | 2022-12-03 04:21:02 | Lowndes, Mississippi, US | |
835298 | 835298 | 2022-12-02 | US | Michigan | Midland | 26111 | 22812 | 249 | 0 | 43.64330771 | -84.38804374 | 2022-12-03 04:21:02 | Midland, Michigan, US | |
2139267 | 2139267 | 2022-12-01 | US | Texas | Hale | 48189 | 7875 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-02 04:21:07 | Hale, Texas, US | |
2137989 | 2137989 | 2022-12-01 | US | Mississippi | Lowndes | 28087 | 20305 | 249 | 0 | 33.47386518 | -88.4419153 | 2022-12-02 04:21:07 | Lowndes, Mississippi, US | |
2137828 | 2137828 | 2022-12-01 | US | Michigan | Midland | 26111 | 22812 | 249 | 0 | 43.64330771 | -84.38804374 | 2022-12-02 04:21:07 | Midland, Michigan, US | |
1967683 | 1967683 | 2022-11-30 | US | Texas | Hale | 48189 | 7875 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-01 04:21:03 | Hale, Texas, US | |
1966405 | 1966405 | 2022-11-30 | US | Mississippi | Lowndes | 28087 | 20305 | 249 | 0 | 33.47386518 | -88.4419153 | 2022-12-01 04:21:03 | Lowndes, Mississippi, US | |
1966244 | 1966244 | 2022-11-30 | US | Michigan | Midland | 26111 | 22812 | 249 | 0 | 43.64330771 | -84.38804374 | 2022-12-01 04:21:03 | Midland, Michigan, US | |
2559697 | 2559697 | 2022-11-29 | US | Texas | Hale | 48189 | 7855 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-11-30 04:21:07 | Hale, Texas, US | |
2559217 | 2559217 | 2022-11-29 | US | Oregon | Klamath | 41035 | 17253 | 249 | 0 | 42.68762984 | -121.6496461 | 2022-11-30 04:21:07 | Klamath, Oregon, US | |
2558419 | 2558419 | 2022-11-29 | US | Mississippi | Lowndes | 28087 | 20305 | 249 | 0 | 33.47386518 | -88.4419153 | 2022-11-30 04:21:07 | Lowndes, Mississippi, US | |
2558258 | 2558258 | 2022-11-29 | US | Michigan | Midland | 26111 | 22812 | 249 | 0 | 43.64330771 | -84.38804374 | 2022-11-30 04:21:07 | Midland, Michigan, US | |
1242771 | 1242771 | 2022-11-28 | US | Texas | Hale | 48189 | 7855 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-11-29 04:21:05 | Hale, Texas, US | |
1242291 | 1242291 | 2022-11-28 | US | Oregon | Klamath | 41035 | 17253 | 249 | 0 | 42.68762984 | -121.6496461 | 2022-11-29 04:21:05 | Klamath, Oregon, US | |
1241493 | 1241493 | 2022-11-28 | US | Mississippi | Lowndes | 28087 | 20270 | 249 | 0 | 33.47386518 | -88.4419153 | 2022-11-29 04:21:05 | Lowndes, Mississippi, US | |
1241353 | 1241353 | 2022-11-28 | US | Michigan | Shiawassee | 26155 | 21261 | 249 | 0 | 42.953928 | -84.14585902 | 2022-11-29 04:21:05 | Shiawassee, Michigan, US | |
1241332 | 1241332 | 2022-11-28 | US | Michigan | Midland | 26111 | 22756 | 249 | 0 | 43.64330771 | -84.38804374 | 2022-11-29 04:21:05 | Midland, Michigan, US | |
3554759 | 3554759 | 2022-11-27 | US | Texas | Hale | 48189 | 7830 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-11-28 04:21:02 | Hale, Texas, US | |
3554279 | 3554279 | 2022-11-27 | US | Oregon | Klamath | 41035 | 17253 | 249 | 0 | 42.68762984 | -121.6496461 | 2022-11-28 04:21:02 | Klamath, Oregon, US | |
3553481 | 3553481 | 2022-11-27 | US | Mississippi | Lowndes | 28087 | 20228 | 249 | 0 | 33.47386518 | -88.4419153 | 2022-11-28 04:21:02 | Lowndes, Mississippi, US | |
3553341 | 3553341 | 2022-11-27 | US | Michigan | Shiawassee | 26155 | 21261 | 249 | 0 | 42.953928 | -84.14585902 | 2022-11-28 04:21:02 | Shiawassee, Michigan, 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]);