johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,167 rows where confirmed = 214 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328571 | 328571 | 2022-12-27 | US | Colorado | Unassigned | 90008 | 214 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Colorado, US | |
218644 | 218644 | 2022-12-26 | US | Colorado | Unassigned | 90008 | 214 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Colorado, US | |
3223101 | 3223101 | 2022-12-25 | US | Colorado | Unassigned | 90008 | 214 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Colorado, US | |
1019015 | 1019015 | 2022-12-24 | US | Colorado | Unassigned | 90008 | 214 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-25 04:21:04 | Unassigned, Colorado, US | |
691038 | 691038 | 2022-12-23 | US | Colorado | Unassigned | 90008 | 214 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-24 04:21:02 | Unassigned, Colorado, US | |
2180248 | 2180248 | 2022-12-22 | US | Colorado | Unassigned | 90008 | 214 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-23 04:21:04 | Unassigned, Colorado, US | |
452052 | 452052 | 2022-12-21 | US | Colorado | Unassigned | 90008 | 214 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-22 04:20:56 | Unassigned, Colorado, US | |
3950304 | 3950304 | 2022-08-17 | China | Tibet | 214 | 0 | 0 | 31.6927 | 88.0924 | 2022-08-18 04:21:11 | Tibet, China | |||
1101262 | 1101262 | 2022-08-03 | US | Texas | Kent | 48263 | 214 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-08-04 04:20:58 | Kent, Texas, US | |
1408187 | 1408187 | 2022-08-02 | US | Texas | Kent | 48263 | 214 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-08-03 04:20:59 | Kent, Texas, US | |
3620225 | 3620225 | 2022-08-01 | US | Texas | Kent | 48263 | 214 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-08-02 04:20:53 | Kent, Texas, US | |
3874705 | 3874705 | 2022-07-31 | US | Texas | Kent | 48263 | 214 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-08-01 04:21:03 | Kent, Texas, US | |
677459 | 677459 | 2022-07-30 | US | Texas | Kent | 48263 | 214 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-31 04:21:02 | Kent, Texas, US | |
1786658 | 1786658 | 2022-07-29 | US | Texas | Kent | 48263 | 214 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-30 04:20:42 | Kent, Texas, US | |
1069021 | 1069021 | 2022-07-28 | US | Texas | Kent | 48263 | 214 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-29 04:20:45 | Kent, Texas, US | |
94240 | 94240 | 2022-07-23 | US | Texas | Glasscock | 48173 | 214 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-24 04:20:47 | Glasscock, Texas, US | |
903262 | 903262 | 2022-07-22 | US | Texas | Glasscock | 48173 | 214 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-23 04:20:53 | Glasscock, Texas, US | |
673398 | 673398 | 2022-07-21 | US | Texas | Glasscock | 48173 | 214 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-22 04:21:15 | Glasscock, Texas, US | |
1611361 | 1611361 | 2022-07-20 | US | Texas | Glasscock | 48173 | 214 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-21 04:21:10 | Glasscock, Texas, US | |
961994 | 961994 | 2022-07-19 | US | Texas | Glasscock | 48173 | 214 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-20 04:20:59 | Glasscock, Texas, US | |
3213381 | 3213381 | 2022-07-18 | US | Texas | Glasscock | 48173 | 214 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-19 04:20:58 | Glasscock, Texas, US | |
3408556 | 3408556 | 2022-07-17 | US | Texas | Glasscock | 48173 | 214 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-18 04:20:59 | Glasscock, Texas, US | |
2154756 | 2154756 | 2022-07-16 | US | Texas | Glasscock | 48173 | 214 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-17 04:21:15 | Glasscock, Texas, US | |
2421989 | 2421989 | 2022-07-15 | US | Texas | Glasscock | 48173 | 214 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-16 04:21:05 | Glasscock, Texas, US | |
2190703 | 2190703 | 2022-06-22 | US | Texas | Foard | 48155 | 214 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-06-23 04:20:55 | Foard, Texas, US | |
169134 | 169134 | 2022-06-21 | US | Texas | Foard | 48155 | 214 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-06-22 04:20:54 | Foard, Texas, US | |
1424266 | 1424266 | 2022-06-08 | US | Texas | Loving | 48301 | 214 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-09 04:20:54 | Loving, Texas, US | |
3729380 | 3729380 | 2022-06-07 | US | Texas | Loving | 48301 | 214 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-08 04:20:55 | Loving, Texas, US | |
3890782 | 3890782 | 2022-06-06 | US | Texas | Loving | 48301 | 214 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-07 04:21:08 | Loving, Texas, US | |
188077 | 188077 | 2022-02-13 | US | Montana | Judith Basin | 30045 | 214 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-14 04:20:51 | Judith Basin, Montana, US | |
317923 | 317923 | 2022-02-12 | US | Montana | Judith Basin | 30045 | 214 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-13 04:21:00 | Judith Basin, Montana, US | |
235249 | 235249 | 2022-02-11 | US | Montana | Judith Basin | 30045 | 214 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-12 04:21:06 | Judith Basin, Montana, US | |
2475007 | 2475007 | 2022-02-03 | US | Illinois | Unassigned | 90017 | 214 | 3843 | 0 | 42.36542373 | 0.0 | 2022-02-04 04:21:10 | Unassigned, Illinois, US | |
461380 | 461380 | 2022-02-02 | US | Montana | Garfield | 30033 | 214 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-02-03 04:21:21 | Garfield, Montana, US | |
460432 | 460432 | 2022-02-02 | US | Illinois | Unassigned | 90017 | 214 | 3817 | 0 | 42.36542373 | 0.0 | 2022-02-03 04:21:21 | Unassigned, Illinois, US | |
980949 | 980949 | 2022-02-01 | US | Montana | Garfield | 30033 | 214 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-02-02 04:21:09 | Garfield, Montana, US | |
2659791 | 2659791 | 2022-01-31 | US | Montana | Garfield | 30033 | 214 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-02-01 04:21:11 | Garfield, Montana, US | |
1116208 | 1116208 | 2022-01-11 | US | Oregon | Gilliam | 41021 | 214 | 4 | 0 | 45.37160076 | -120.20488689999999 | 2022-01-12 04:21:44 | Gilliam, Oregon, US | |
1694936 | 1694936 | 2022-01-10 | US | Oregon | Gilliam | 41021 | 214 | 4 | 0 | 45.37160076 | -120.20488689999999 | 2022-01-11 04:22:01 | Gilliam, Oregon, US | |
129351 | 129351 | 2022-01-09 | US | Oregon | Gilliam | 41021 | 214 | 4 | 0 | 45.37160076 | -120.20488689999999 | 2022-01-10 04:22:07 | Gilliam, Oregon, US | |
1218186 | 1218186 | 2022-01-08 | US | Oregon | Gilliam | 41021 | 214 | 4 | 0 | 45.37160076 | -120.20488689999999 | 2022-01-09 04:21:46 | Gilliam, Oregon, US | |
1392279 | 1392279 | 2022-01-07 | US | Oregon | Gilliam | 41021 | 214 | 4 | 0 | 45.37160076 | -120.20488689999999 | 2022-01-08 04:21:53 | Gilliam, Oregon, US | |
1288862 | 1288862 | 2022-01-04 | US | South Dakota | Campbell | 46021 | 214 | 6 | 0 | 45.77074915 | -100.0510181 | 2022-01-05 04:21:59 | Campbell, South Dakota, US | |
2170691 | 2170691 | 2022-01-01 | US | Texas | Irion | 48235 | 214 | 2 | 0 | 31.30375559 | -100.982439 | 2022-01-02 04:20:52 | Irion, Texas, US | |
1670735 | 1670735 | 2021-12-29 | US | New York | Unassigned | 90036 | 214 | 1 | 0 | 44.74530905 | 0.0 | 2021-12-30 04:21:25 | Unassigned, New York, US | |
1435750 | 1435750 | 2021-12-28 | US | Texas | Motley | 48345 | 214 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-29 03:21:43 | Motley, Texas, US | |
733711 | 733711 | 2021-12-27 | US | Texas | Motley | 48345 | 214 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-28 04:21:47 | Motley, Texas, US | |
2114883 | 2114883 | 2021-12-26 | US | Texas | Motley | 48345 | 214 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-27 04:21:58 | Motley, Texas, US | |
3608255 | 3608255 | 2021-12-25 | US | Texas | Motley | 48345 | 214 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-26 04:21:50 | Motley, Texas, US | |
2966573 | 2966573 | 2021-12-24 | US | Texas | Motley | 48345 | 214 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-25 04:21:37 | Motley, Texas, US | |
3819605 | 3819605 | 2021-12-23 | US | Texas | Motley | 48345 | 214 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-24 04:21:34 | Motley, Texas, US | |
405602 | 405602 | 2021-12-07 | US | Kansas | Lane | 20101 | 214 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-08 04:22:46 | Lane, Kansas, US | |
1031684 | 1031684 | 2021-12-06 | US | Kansas | Lane | 20101 | 214 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-07 04:22:34 | Lane, Kansas, US | |
3749711 | 3749711 | 2021-11-22 | US | California | Sierra | 6091 | 214 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-11-23 04:22:39 | Sierra, California, US | |
1014918 | 1014918 | 2021-11-21 | US | California | Sierra | 6091 | 214 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-11-22 04:22:20 | Sierra, California, US | |
30833 | 30833 | 2021-11-11 | US | North Dakota | Oliver | 38065 | 214 | 3 | 0 | 47.11530482 | -101.3406158 | 2021-11-12 04:22:01 | Oliver, North Dakota, US | |
29023 | 29023 | 2021-11-11 | US | Colorado | Cheyenne | 8017 | 214 | 7 | 0 | 38.82777431 | -102.6032558 | 2021-11-12 04:22:01 | Cheyenne, Colorado, US | |
2847272 | 2847272 | 2021-11-10 | US | North Dakota | Oliver | 38065 | 214 | 3 | 0 | 47.11530482 | -101.3406158 | 2021-11-11 04:21:45 | Oliver, North Dakota, US | |
3641618 | 3641618 | 2021-11-08 | US | Nebraska | Deuel | 31049 | 214 | 1 | 0 | 41.11168186 | -102.33333309999999 | 2021-11-09 04:21:36 | Deuel, Nebraska, US | |
2124371 | 2124371 | 2021-10-21 | US | Colorado | Kiowa | 8061 | 214 | 4 | 0 | 38.43260896 | -102.7392145 | 2021-10-22 04:21:14 | Kiowa, Colorado, US | |
494862 | 494862 | 2021-10-14 | US | Texas | Stonewall | 48433 | 214 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-10-15 04:21:26 | Stonewall, Texas, US | |
424624 | 424624 | 2021-10-10 | US | Kansas | Comanche | 20033 | 214 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-10-11 04:21:31 | Comanche, Kansas, US | |
2877481 | 2877481 | 2021-10-09 | US | Kansas | Comanche | 20033 | 214 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-10-10 04:21:38 | Comanche, Kansas, US | |
2875889 | 2875889 | 2021-10-09 | Australia | Northern Territory | 214 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-10 04:21:38 | Northern Territory, Australia | |||
2960647 | 2960647 | 2021-10-08 | US | Kansas | Comanche | 20033 | 214 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-10-09 04:21:34 | Comanche, Kansas, US | |
2959055 | 2959055 | 2021-10-08 | Australia | Northern Territory | 214 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-09 04:21:34 | Northern Territory, Australia | |||
990038 | 990038 | 2021-10-04 | US | Texas | Cottle | 48101 | 214 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-10-05 04:21:27 | Cottle, Texas, US | |
1277348 | 1277348 | 2021-10-03 | US | Texas | Cottle | 48101 | 214 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-10-04 04:21:31 | Cottle, Texas, US | |
1274902 | 1274902 | 2021-10-03 | US | Colorado | Dolores | 8033 | 214 | 4 | 0 | 37.75208676 | -108.5211585 | 2021-10-04 04:21:31 | Dolores, Colorado, US | |
3931101 | 3931101 | 2021-10-02 | US | Texas | Cottle | 48101 | 214 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-10-03 04:21:24 | Cottle, Texas, US | |
2135081 | 2135081 | 2021-10-01 | US | Texas | Cottle | 48101 | 214 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-10-02 04:21:25 | Cottle, Texas, US | |
2776038 | 2776038 | 2021-09-30 | US | Texas | Cottle | 48101 | 214 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-10-01 04:21:35 | Cottle, Texas, US | |
2774989 | 2774989 | 2021-09-30 | US | Montana | McCone | 30055 | 214 | 2 | 0 | 47.64469406 | -105.79449939999999 | 2021-10-01 04:21:35 | McCone, Montana, US | |
2774628 | 2774628 | 2021-09-30 | US | Michigan | Keweenaw | 26083 | 214 | 4 | 0 | 47.63197653 | -88.41434263 | 2021-10-01 04:21:35 | Keweenaw, Michigan, US | |
708084 | 708084 | 2021-09-29 | US | Michigan | Keweenaw | 26083 | 214 | 4 | 0 | 47.63197653 | -88.41434263 | 2021-09-30 04:21:20 | Keweenaw, Michigan, US | |
1336257 | 1336257 | 2021-09-28 | US | Missouri | Worth | 29227 | 214 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-09-29 04:21:45 | Worth, Missouri, US | |
1237626 | 1237626 | 2021-09-27 | US | Missouri | Worth | 29227 | 214 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-09-28 04:21:28 | Worth, Missouri, US | |
2077954 | 2077954 | 2021-09-26 | US | Montana | Liberty | 30051 | 214 | 1 | 0 | 48.56084317 | -111.02430700000001 | 2021-09-27 04:21:16 | Liberty, Montana, US | |
2077927 | 2077927 | 2021-09-26 | US | Missouri | Worth | 29227 | 214 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-09-27 04:21:16 | Worth, Missouri, US | |
1726506 | 1726506 | 2021-09-25 | US | Montana | Liberty | 30051 | 214 | 1 | 0 | 48.56084317 | -111.02430700000001 | 2021-09-26 04:21:29 | Liberty, Montana, US | |
1726479 | 1726479 | 2021-09-25 | US | Missouri | Worth | 29227 | 214 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-09-26 04:21:29 | Worth, Missouri, US | |
1923296 | 1923296 | 2021-09-24 | US | Nebraska | Greeley | 31077 | 214 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-09-25 04:21:31 | Greeley, Nebraska, US | |
1923226 | 1923226 | 2021-09-24 | US | Montana | Liberty | 30051 | 214 | 1 | 0 | 48.56084317 | -111.02430700000001 | 2021-09-25 04:21:31 | Liberty, Montana, US | |
1923199 | 1923199 | 2021-09-24 | US | Missouri | Worth | 29227 | 214 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-09-25 04:21:31 | Worth, Missouri, US | |
603767 | 603767 | 2021-09-23 | US | Nebraska | Greeley | 31077 | 214 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-09-24 04:21:44 | Greeley, Nebraska, US | |
603670 | 603670 | 2021-09-23 | US | Missouri | Worth | 29227 | 214 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-09-24 04:21:44 | Worth, Missouri, US | |
3013411 | 3013411 | 2021-09-22 | US | Nebraska | Greeley | 31077 | 214 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-09-23 04:21:43 | Greeley, Nebraska, US | |
3013314 | 3013314 | 2021-09-22 | US | Missouri | Worth | 29227 | 214 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-09-23 04:21:43 | Worth, Missouri, US | |
3013043 | 3013043 | 2021-09-22 | US | Minnesota | Cook | 27031 | 214 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-09-23 04:21:43 | Cook, Minnesota, US | |
3759549 | 3759549 | 2021-09-21 | US | Nebraska | Greeley | 31077 | 214 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-09-22 04:21:45 | Greeley, Nebraska, US | |
3759452 | 3759452 | 2021-09-21 | US | Missouri | Worth | 29227 | 214 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-09-22 04:21:45 | Worth, Missouri, US | |
811652 | 811652 | 2021-09-20 | US | Nebraska | Greeley | 31077 | 214 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-09-21 04:21:26 | Greeley, Nebraska, US | |
811555 | 811555 | 2021-09-20 | US | Missouri | Worth | 29227 | 214 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-09-21 04:21:26 | Worth, Missouri, US | |
811284 | 811284 | 2021-09-20 | US | Minnesota | Cook | 27031 | 214 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-09-21 04:21:26 | Cook, Minnesota, US | |
1816851 | 1816851 | 2021-09-19 | US | Nebraska | Greeley | 31077 | 214 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-09-20 04:21:22 | Greeley, Nebraska, US | |
1816765 | 1816765 | 2021-09-19 | US | Montana | Daniels | 30019 | 214 | 8 | 0 | 48.78420029 | -105.54763429999998 | 2021-09-20 04:21:22 | Daniels, Montana, US | |
18431 | 18431 | 2021-09-18 | US | Nebraska | Greeley | 31077 | 214 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-09-19 04:21:34 | Greeley, Nebraska, US | |
18345 | 18345 | 2021-09-18 | US | Montana | Daniels | 30019 | 214 | 8 | 0 | 48.78420029 | -105.54763429999998 | 2021-09-19 04:21:34 | Daniels, Montana, US | |
2620116 | 2620116 | 2021-09-17 | US | Nebraska | Greeley | 31077 | 214 | 1 | 0 | 41.56742671 | -98.52150266 | 2021-09-18 04:21:24 | Greeley, Nebraska, US | |
2620030 | 2620030 | 2021-09-17 | US | Montana | Daniels | 30019 | 214 | 8 | 0 | 48.78420029 | -105.54763429999998 | 2021-09-18 04:21:24 | Daniels, Montana, 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]);