johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
248 rows where deaths = 942 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3554825 | 3554825 | 2022-11-27 | US | Texas | McLennan | 48309 | 71229 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-28 04:21:02 | McLennan, Texas, US | |
2103305 | 2103305 | 2022-11-26 | US | Texas | McLennan | 48309 | 71229 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-27 04:21:05 | McLennan, Texas, US | |
490796 | 490796 | 2022-11-25 | US | Texas | McLennan | 48309 | 71229 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-26 04:21:11 | McLennan, Texas, US | |
3526625 | 3526625 | 2022-11-24 | US | Texas | McLennan | 48309 | 71229 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-25 04:21:06 | McLennan, Texas, US | |
3315408 | 3315408 | 2022-11-23 | US | Texas | McLennan | 48309 | 71229 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-24 04:21:09 | McLennan, Texas, US | |
3312702 | 3312702 | 2022-11-23 | US | Arkansas | Benton | 5007 | 74672 | 942 | 0 | 36.33644656 | -94.25680817 | 2022-11-24 04:21:09 | Benton, Arkansas, US | |
1623449 | 1623449 | 2022-11-22 | US | Texas | McLennan | 48309 | 71181 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-23 04:21:06 | McLennan, Texas, US | |
1620743 | 1620743 | 2022-11-22 | US | Arkansas | Benton | 5007 | 74632 | 942 | 0 | 36.33644656 | -94.25680817 | 2022-11-23 04:21:06 | Benton, Arkansas, US | |
3463337 | 3463337 | 2022-11-21 | US | Texas | McLennan | 48309 | 71181 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-22 04:20:47 | McLennan, Texas, US | |
1643522 | 1643522 | 2022-11-20 | US | Texas | McLennan | 48309 | 71083 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-21 04:21:05 | McLennan, Texas, US | |
2067079 | 2067079 | 2022-11-19 | US | Texas | McLennan | 48309 | 71083 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-20 04:21:08 | McLennan, Texas, US | |
1758473 | 1758473 | 2022-11-18 | US | Texas | McLennan | 48309 | 71083 | 942 | 0 | 31.55255453 | -97.20217694 | 2022-11-19 04:21:14 | McLennan, Texas, US | |
2771957 | 2771957 | 2022-09-26 | US | Tennessee | Rutherford | 47149 | 110047 | 942 | 0 | 35.84591405 | -86.4107263 | 2022-09-27 04:23:01 | Rutherford, Tennessee, US | |
1979610 | 1979610 | 2022-09-25 | US | Tennessee | Rutherford | 47149 | 110027 | 942 | 0 | 35.84591405 | -86.4107263 | 2022-09-26 04:20:52 | Rutherford, Tennessee, US | |
2652777 | 2652777 | 2022-09-24 | US | Tennessee | Rutherford | 47149 | 110003 | 942 | 0 | 35.84591405 | -86.4107263 | 2022-09-25 04:23:31 | Rutherford, Tennessee, US | |
387217 | 387217 | 2022-09-23 | US | Tennessee | Rutherford | 47149 | 109986 | 942 | 0 | 35.84591405 | -86.4107263 | 2022-09-24 04:21:40 | Rutherford, Tennessee, US | |
1627283 | 1627283 | 2022-09-22 | US | Tennessee | Rutherford | 47149 | 109926 | 942 | 0 | 35.84591405 | -86.4107263 | 2022-09-23 04:23:13 | Rutherford, Tennessee, US | |
1373487 | 1373487 | 2022-09-21 | US | Tennessee | Rutherford | 47149 | 109894 | 942 | 0 | 35.84591405 | -86.4107263 | 2022-09-22 04:22:56 | Rutherford, Tennessee, US | |
2494335 | 2494335 | 2022-08-15 | Spain | La Rioja | 108012 | 942 | 0 | 42.2871 | -2.5396 | 2022-08-16 04:20:58 | La Rioja, Spain | |||
3647885 | 3647885 | 2022-08-14 | Spain | La Rioja | 108012 | 942 | 0 | 42.2871 | -2.5396 | 2022-08-15 04:20:59 | La Rioja, Spain | |||
1968891 | 1968891 | 2022-08-13 | Spain | La Rioja | 108012 | 942 | 0 | 42.2871 | -2.5396 | 2022-08-14 04:20:55 | La Rioja, Spain | |||
2888700 | 2888700 | 2022-08-12 | Spain | La Rioja | 108012 | 942 | 0 | 42.2871 | -2.5396 | 2022-08-13 04:20:52 | La Rioja, Spain | |||
1073152 | 1073152 | 2022-08-07 | US | Texas | Williamson | 48491 | 153334 | 942 | 0 | 30.64655664 | -97.6004854 | 2022-08-08 04:21:08 | Williamson, Texas, US | |
1943740 | 1943740 | 2022-08-06 | US | Texas | Williamson | 48491 | 153334 | 942 | 0 | 30.64655664 | -97.6004854 | 2022-08-07 04:20:54 | Williamson, Texas, US | |
883539 | 883539 | 2022-08-05 | US | Texas | Williamson | 48491 | 153334 | 942 | 0 | 30.64655664 | -97.6004854 | 2022-08-06 04:20:56 | Williamson, Texas, US | |
2011950 | 2011950 | 2022-08-04 | US | Texas | Williamson | 48491 | 153334 | 942 | 0 | 30.64655664 | -97.6004854 | 2022-08-05 04:20:52 | Williamson, Texas, US | |
2337556 | 2337556 | 2022-07-27 | US | New Hampshire | Hillsborough | 33011 | 108484 | 942 | 0 | 42.91537785 | -71.7200253 | 2022-07-28 04:20:56 | Hillsborough, New Hampshire, US | |
1489746 | 1489746 | 2022-07-26 | US | New Hampshire | Hillsborough | 33011 | 108396 | 942 | 0 | 42.91537785 | -71.7200253 | 2022-07-27 04:21:04 | Hillsborough, New Hampshire, US | |
2788998 | 2788998 | 2022-07-10 | Italy | Basilicata | 154843 | 942 | 0 | 40.63947052 | 15.80514834 | 2022-07-11 04:20:46 | Basilicata, Italy | |||
141951 | 141951 | 2022-07-09 | Italy | Basilicata | 154156 | 942 | 0 | 40.63947052 | 15.80514834 | 2022-07-10 04:20:54 | Basilicata, Italy | |||
1650345 | 1650345 | 2022-06-23 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-24 04:20:58 | St. Charles, Missouri, US | |
2189580 | 2189580 | 2022-06-22 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-23 04:20:55 | St. Charles, Missouri, US | |
168011 | 168011 | 2022-06-21 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-22 04:20:54 | St. Charles, Missouri, US | |
1765294 | 1765294 | 2022-06-20 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-21 04:20:56 | St. Charles, Missouri, US | |
3271480 | 3271480 | 2022-06-19 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-20 04:21:01 | St. Charles, Missouri, US | |
3399392 | 3399392 | 2022-06-18 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-19 04:20:51 | St. Charles, Missouri, US | |
2313269 | 2313269 | 2022-06-17 | US | Missouri | St. Charles | 29183 | 100164 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-18 04:21:10 | St. Charles, Missouri, US | |
560773 | 560773 | 2022-06-16 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-17 04:20:56 | St. Charles, Missouri, US | |
3984575 | 3984575 | 2022-06-15 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-16 04:20:55 | St. Charles, Missouri, US | |
948816 | 948816 | 2022-06-14 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-15 04:20:54 | St. Charles, Missouri, US | |
2981224 | 2981224 | 2022-06-13 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-14 04:20:52 | St. Charles, Missouri, US | |
2979137 | 2979137 | 2022-06-13 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-14 04:20:52 | Martinique, France | |||
2237350 | 2237350 | 2022-06-12 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-13 04:21:14 | St. Charles, Missouri, US | |
2235263 | 2235263 | 2022-06-12 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-13 04:21:14 | Martinique, France | |||
3143548 | 3143548 | 2022-06-11 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-12 04:20:53 | St. Charles, Missouri, US | |
3141461 | 3141461 | 2022-06-11 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-12 04:20:53 | Martinique, France | |||
1946464 | 1946464 | 2022-06-10 | US | Missouri | St. Charles | 29183 | 99166 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-11 04:21:01 | St. Charles, Missouri, US | |
1944377 | 1944377 | 2022-06-10 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-11 04:21:01 | Martinique, France | |||
3159603 | 3159603 | 2022-06-09 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-10 04:20:55 | St. Charles, Missouri, US | |
3157516 | 3157516 | 2022-06-09 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-10 04:20:55 | Martinique, France | |||
1424459 | 1424459 | 2022-06-08 | US | Virginia | Henrico | 51087 | 70879 | 942 | 0 | 37.53460572 | -77.39326555 | 2022-06-09 04:20:54 | Henrico, Virginia, US | |
1423070 | 1423070 | 2022-06-08 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-09 04:20:54 | St. Charles, Missouri, US | |
1420983 | 1420983 | 2022-06-08 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-09 04:20:54 | Martinique, France | |||
3729573 | 3729573 | 2022-06-07 | US | Virginia | Henrico | 51087 | 70767 | 942 | 0 | 37.53460572 | -77.39326555 | 2022-06-08 04:20:55 | Henrico, Virginia, US | |
3728184 | 3728184 | 2022-06-07 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-08 04:20:55 | St. Charles, Missouri, US | |
3726097 | 3726097 | 2022-06-07 | France | Martinique | 172883 | 942 | 0 | 14.6415 | -61.0242 | 2022-06-08 04:20:55 | Martinique, France | |||
3889586 | 3889586 | 2022-06-06 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-07 04:21:08 | St. Charles, Missouri, US | |
3509355 | 3509355 | 2022-06-05 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-06 04:20:57 | St. Charles, Missouri, US | |
3529432 | 3529432 | 2022-06-04 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-05 04:20:55 | St. Charles, Missouri, US | |
3135518 | 3135518 | 2022-06-03 | US | Missouri | St. Charles | 29183 | 98214 | 942 | 0 | 38.77875681 | -90.66662425 | 2022-06-04 04:20:58 | St. Charles, Missouri, US | |
1573821 | 1573821 | 2022-05-03 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-05-04 04:20:59 | Saginaw, Michigan, US | |
465081 | 465081 | 2022-05-02 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-05-03 04:21:00 | Saginaw, Michigan, US | |
463275 | 463275 | 2022-05-02 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-05-03 04:21:00 | Guadeloupe, France | |||
3917720 | 3917720 | 2022-05-01 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-05-02 04:21:10 | Saginaw, Michigan, US | |
3915914 | 3915914 | 2022-05-01 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-05-02 04:21:10 | Guadeloupe, France | |||
2842524 | 2842524 | 2022-04-30 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-05-01 04:20:57 | Saginaw, Michigan, US | |
2840718 | 2840718 | 2022-04-30 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-05-01 04:20:57 | Guadeloupe, France | |||
1158837 | 1158837 | 2022-04-29 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-04-30 04:21:05 | Saginaw, Michigan, US | |
1157031 | 1157031 | 2022-04-29 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-04-30 04:21:05 | Guadeloupe, France | |||
1698019 | 1698019 | 2022-04-28 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-04-29 04:20:59 | Saginaw, Michigan, US | |
1696213 | 1696213 | 2022-04-28 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-04-29 04:20:59 | Guadeloupe, France | |||
3853502 | 3853502 | 2022-04-27 | US | Michigan | Saginaw | 26145 | 49492 | 942 | 0 | 43.33433923 | -84.0513121 | 2022-04-28 04:20:47 | Saginaw, Michigan, US | |
3851696 | 3851696 | 2022-04-27 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-04-28 04:20:47 | Guadeloupe, France | |||
1326126 | 1326126 | 2022-04-26 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-04-27 04:20:52 | Guadeloupe, France | |||
3722080 | 3722080 | 2022-04-25 | France | Guadeloupe | 147607 | 942 | 0 | 16.265 | -61.551 | 2022-04-26 04:20:51 | Guadeloupe, France | |||
3439347 | 3439347 | 2022-04-22 | US | Ohio | Trumbull | 39155 | 41686 | 942 | 0 | 41.31735028 | -80.76109643 | 2022-04-23 04:20:50 | Trumbull, Ohio, US | |
3350712 | 3350712 | 2022-04-01 | Malaysia | Pahang | 166294 | 942 | 0 | 3.8126 | 103.3256 | 2022-04-02 04:20:47 | Pahang, Malaysia | |||
3350511 | 3350511 | 2022-04-01 | Cyprus | 433217 | 942 | 0 | 35.1264 | 33.4299 | 2022-04-02 04:20:47 | Cyprus | ||||
1437361 | 1437361 | 2022-03-28 | US | Georgia | Clayton | 13063 | 63365 | 942 | 0 | 33.54187245 | -84.35594188 | 2022-03-29 04:20:46 | Clayton, Georgia, US | |
877042 | 877042 | 2022-03-27 | US | Georgia | Clayton | 13063 | 63351 | 942 | 0 | 33.54187245 | -84.35594188 | 2022-03-28 04:20:33 | Clayton, Georgia, US | |
2164325 | 2164325 | 2022-03-26 | US | Georgia | Clayton | 13063 | 63351 | 942 | 0 | 33.54187245 | -84.35594188 | 2022-03-27 04:20:47 | Clayton, Georgia, US | |
1721261 | 1721261 | 2022-03-25 | US | Georgia | Clayton | 13063 | 63351 | 942 | 0 | 33.54187245 | -84.35594188 | 2022-03-26 04:20:23 | Clayton, Georgia, US | |
3022490 | 3022490 | 2022-03-23 | Russia | Kirov Oblast | 148248 | 942 | 0 | 57.9665589 | 49.4074599 | 2022-03-24 04:20:43 | Kirov Oblast, Russia | |||
358498 | 358498 | 2022-03-11 | US | New Jersey | Gloucester | 34015 | 69256 | 942 | 0 | 39.71581067 | -75.13995546 | 2022-03-12 04:20:50 | Gloucester, New Jersey, US | |
236273 | 236273 | 2022-02-11 | US | Texas | Brazoria | 48039 | 91411 | 942 | 0 | 29.18757369 | -95.44563172 | 2022-02-12 04:21:06 | Brazoria, Texas, US | |
461561 | 461561 | 2022-02-02 | US | New Jersey | Somerset | 34035 | 64917 | 942 | 0 | 40.56465737 | -74.61683016 | 2022-02-03 04:21:21 | Somerset, New Jersey, US | |
1962933 | 1962933 | 2022-01-20 | US | North Carolina | Wake | 37183 | 234688 | 942 | 0 | 35.78879266 | -78.65249174 | 2022-01-21 04:21:09 | Wake, North Carolina, US | |
126558 | 126558 | 2022-01-09 | Colombia | Casanare | 36515 | 942 | 0 | 5.7589 | -71.5724 | 2022-01-10 04:22:07 | Casanare, Colombia | |||
1215393 | 1215393 | 2022-01-08 | Colombia | Casanare | 36454 | 942 | 0 | 5.7589 | -71.5724 | 2022-01-09 04:21:46 | Casanare, Colombia | |||
1389486 | 1389486 | 2022-01-07 | Colombia | Casanare | 36401 | 942 | 0 | 5.7589 | -71.5724 | 2022-01-08 04:21:53 | Casanare, Colombia | |||
1286201 | 1286201 | 2022-01-04 | Russia | Chechen Republic | 31130 | 942 | 0 | 43.39761470000001 | 45.6985005 | 2022-01-05 04:21:59 | Chechen Republic, Russia | |||
1254534 | 1254534 | 2021-12-20 | Canada | Saskatchewan | 82267 | 942 | 0 | 52.9399 | -106.4509 | 2021-12-21 03:21:27 | Saskatchewan, Canada | |||
2903477 | 2903477 | 2021-12-19 | Canada | Saskatchewan | 82208 | 942 | 0 | 52.9399 | -106.4509 | 2021-12-20 04:21:43 | Saskatchewan, Canada | |||
1258550 | 1258550 | 2021-12-18 | Canada | Saskatchewan | 82130 | 942 | 0 | 52.9399 | -106.4509 | 2021-12-19 04:21:11 | Saskatchewan, Canada | |||
2398578 | 2398578 | 2021-12-17 | Canada | Saskatchewan | 82069 | 942 | 0 | 52.9399 | -106.4509 | 2021-12-18 02:22:20 | Saskatchewan, Canada | |||
2087798 | 2087798 | 2021-12-14 | Colombia | Caqueta | 23045 | 942 | 0 | 0.8699 | -73.8419 | 2021-12-15 03:22:16 | Caqueta, Colombia | |||
782852 | 782852 | 2021-12-13 | US | Arizona | Yuma | 4027 | 43424 | 942 | 0 | 32.76895712 | -113.90666740000002 | 2021-12-14 04:22:38 | Yuma, Arizona, US | |
782215 | 782215 | 2021-12-13 | Colombia | Caqueta | 23041 | 942 | 0 | 0.8699 | -73.8419 | 2021-12-14 04:22:38 | Caqueta, Colombia | |||
1660887 | 1660887 | 2021-12-12 | US | Arizona | Yuma | 4027 | 43393 | 942 | 0 | 32.76895712 | -113.90666740000002 | 2021-12-13 04:22:02 | Yuma, Arizona, US | |
1660250 | 1660250 | 2021-12-12 | Colombia | Caqueta | 23034 | 942 | 0 | 0.8699 | -73.8419 | 2021-12-13 04:22:02 | Caqueta, Colombia |
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]);