johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
981 rows where confirmed = 206 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952051 | 2952051 | 2022-12-20 | US | Colorado | Unassigned | 90008 | 206 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-21 04:21:03 | Unassigned, Colorado, US | |
3174453 | 3174453 | 2022-12-19 | US | Colorado | Unassigned | 90008 | 206 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-20 04:21:04 | Unassigned, Colorado, US | |
1628970 | 1628970 | 2022-12-18 | US | Colorado | Unassigned | 90008 | 206 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-19 04:21:03 | Unassigned, Colorado, US | |
504349 | 504349 | 2022-12-17 | US | Colorado | Unassigned | 90008 | 206 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-18 04:21:03 | Unassigned, Colorado, US | |
3324921 | 3324921 | 2022-12-16 | US | Colorado | Unassigned | 90008 | 206 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-17 04:21:04 | Unassigned, Colorado, US | |
543433 | 543433 | 2022-12-15 | US | Colorado | Unassigned | 90008 | 206 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-16 04:21:01 | Unassigned, Colorado, US | |
348961 | 348961 | 2022-12-14 | US | Colorado | Unassigned | 90008 | 206 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-15 04:20:58 | Unassigned, Colorado, US | |
3081160 | 3081160 | 2022-07-04 | US | Texas | Glasscock | 48173 | 206 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-05 04:20:45 | Glasscock, Texas, US | |
1770442 | 1770442 | 2022-07-03 | US | Texas | Glasscock | 48173 | 206 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-04 04:20:54 | Glasscock, Texas, US | |
3368428 | 3368428 | 2022-07-02 | US | Texas | Glasscock | 48173 | 206 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-03 04:20:59 | Glasscock, Texas, US | |
596757 | 596757 | 2022-07-01 | US | Texas | Glasscock | 48173 | 206 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-02 04:21:16 | Glasscock, Texas, US | |
3943158 | 3943158 | 2022-06-30 | US | Texas | Glasscock | 48173 | 206 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-01 04:21:10 | Glasscock, Texas, US | |
949728 | 949728 | 2022-06-14 | US | South Dakota | Harding | 46063 | 206 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-06-15 04:20:54 | Harding, South Dakota, US | |
2982136 | 2982136 | 2022-06-13 | US | South Dakota | Harding | 46063 | 206 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-06-14 04:20:52 | Harding, South Dakota, US | |
2238262 | 2238262 | 2022-06-12 | US | South Dakota | Harding | 46063 | 206 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-06-13 04:21:14 | Harding, South Dakota, US | |
3144460 | 3144460 | 2022-06-11 | US | South Dakota | Harding | 46063 | 206 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-06-12 04:20:53 | Harding, South Dakota, US | |
1947376 | 1947376 | 2022-06-10 | US | South Dakota | Harding | 46063 | 206 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-06-11 04:21:01 | Harding, South Dakota, US | |
3160515 | 3160515 | 2022-06-09 | US | South Dakota | Harding | 46063 | 206 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-06-10 04:20:55 | Harding, South Dakota, US | |
3159677 | 3159677 | 2022-06-09 | US | Montana | Wibaux | 30109 | 206 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-10 04:20:55 | Wibaux, Montana, US | |
1423982 | 1423982 | 2022-06-08 | US | South Dakota | Harding | 46063 | 206 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-06-09 04:20:54 | Harding, South Dakota, US | |
1423144 | 1423144 | 2022-06-08 | US | Montana | Wibaux | 30109 | 206 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-09 04:20:54 | Wibaux, Montana, US | |
3728258 | 3728258 | 2022-06-07 | US | Montana | Wibaux | 30109 | 206 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-08 04:20:55 | Wibaux, Montana, US | |
2084615 | 2084615 | 2022-05-15 | US | Colorado | San Juan | 8111 | 206 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-16 04:20:47 | San Juan, Colorado, US | |
3355325 | 3355325 | 2022-05-14 | US | Colorado | San Juan | 8111 | 206 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-15 04:20:53 | San Juan, Colorado, US | |
1575225 | 1575225 | 2022-05-03 | US | Texas | Foard | 48155 | 206 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-05-04 04:20:59 | Foard, Texas, US | |
466485 | 466485 | 2022-05-02 | US | Texas | Foard | 48155 | 206 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-05-03 04:21:00 | Foard, Texas, US | |
3919124 | 3919124 | 2022-05-01 | US | Texas | Foard | 48155 | 206 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-05-02 04:21:10 | Foard, Texas, US | |
2843928 | 2843928 | 2022-04-30 | US | Texas | Foard | 48155 | 206 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-05-01 04:20:57 | Foard, Texas, US | |
3350444 | 3350444 | 2022-04-01 | China | Hainan | 206 | 6 | 0 | 19.1959 | 109.7453 | 2022-04-02 04:20:47 | Hainan, China | |||
1471243 | 1471243 | 2022-03-24 | US | Texas | Kent | 48263 | 206 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-03-25 04:20:46 | Kent, Texas, US | |
1865614 | 1865614 | 2022-03-10 | New Zealand | Cook Islands | 206 | 0 | 0 | -21.2367 | -159.7777 | 2022-03-11 04:20:50 | Cook Islands, New Zealand | |||
1363405 | 1363405 | 2022-02-08 | US | Illinois | Unassigned | 90017 | 206 | 3890 | 0 | 42.36542373 | 0.0 | 2022-02-09 04:21:04 | Unassigned, Illinois, US | |
461386 | 461386 | 2022-02-02 | US | Montana | Judith Basin | 30045 | 206 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-03 04:21:21 | Judith Basin, Montana, US | |
980955 | 980955 | 2022-02-01 | US | Montana | Judith Basin | 30045 | 206 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-02 04:21:09 | Judith Basin, Montana, US | |
1961195 | 1961195 | 2022-01-20 | US | Colorado | Mineral | 8079 | 206 | 2 | 0 | 37.66954283 | -106.92816979999999 | 2022-01-21 04:21:09 | Mineral, Colorado, US | |
1115613 | 1115613 | 2022-01-11 | US | Montana | Prairie | 30079 | 206 | 3 | 0 | 46.86048047 | -105.379384 | 2022-01-12 04:21:44 | Prairie, Montana, US | |
129865 | 129865 | 2022-01-09 | US | Texas | Jeff Davis | 48243 | 206 | 6 | 0 | 30.71490589 | -104.1399973 | 2022-01-10 04:22:07 | Jeff Davis, Texas, US | |
1218700 | 1218700 | 2022-01-08 | US | Texas | Jeff Davis | 48243 | 206 | 6 | 0 | 30.71490589 | -104.1399973 | 2022-01-09 04:21:46 | Jeff Davis, Texas, US | |
1288911 | 1288911 | 2022-01-04 | US | South Dakota | Sully | 46119 | 206 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-05 04:21:59 | Sully, South Dakota, US | |
1703255 | 1703255 | 2022-01-03 | US | South Dakota | Sully | 46119 | 206 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-04 04:22:17 | Sully, South Dakota, US | |
3499045 | 3499045 | 2021-12-15 | US | South Dakota | Campbell | 46021 | 206 | 5 | 0 | 45.77074915 | -100.0510181 | 2021-12-16 04:22:11 | Campbell, South Dakota, US | |
1804734 | 1804734 | 2021-11-25 | US | Montana | Carter | 30011 | 206 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-11-26 04:22:33 | Carter, Montana, US | |
906168 | 906168 | 2021-11-24 | US | Montana | Carter | 30011 | 206 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-11-25 04:22:33 | Carter, Montana, US | |
3072018 | 3072018 | 2021-11-23 | US | Montana | Carter | 30011 | 206 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-11-24 04:22:14 | Carter, Montana, US | |
3751116 | 3751116 | 2021-11-22 | US | Montana | Carter | 30011 | 206 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-11-23 04:22:39 | Carter, Montana, US | |
1016323 | 1016323 | 2021-11-21 | US | Montana | Carter | 30011 | 206 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-11-22 04:22:20 | Carter, Montana, US | |
724487 | 724487 | 2021-11-20 | US | Montana | Carter | 30011 | 206 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-11-21 04:22:13 | Carter, Montana, US | |
164017 | 164017 | 2021-11-19 | US | Montana | Carter | 30011 | 206 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-11-20 04:22:17 | Carter, Montana, US | |
3290904 | 3290904 | 2021-11-18 | US | Montana | Carter | 30011 | 206 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-11-19 04:21:40 | Carter, Montana, US | |
449360 | 449360 | 2021-11-17 | US | Montana | Carter | 30011 | 206 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-11-18 04:21:33 | Carter, Montana, US | |
3344610 | 3344610 | 2021-11-16 | US | Montana | Carter | 30011 | 206 | 5 | 0 | 45.5197966 | -104.53955359999999 | 2021-11-17 04:21:48 | Carter, Montana, US | |
2290640 | 2290640 | 2021-11-15 | US | Texas | Motley | 48345 | 206 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-11-16 04:21:10 | Motley, Texas, US | |
2290337 | 2290337 | 2021-11-15 | US | South Dakota | Hyde | 46069 | 206 | 5 | 0 | 44.54747703 | -99.48572582 | 2021-11-16 04:21:10 | Hyde, South Dakota, US | |
1325414 | 1325414 | 2021-11-14 | US | Texas | Motley | 48345 | 206 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-11-15 04:21:36 | Motley, Texas, US | |
689540 | 689540 | 2021-11-13 | US | Texas | Motley | 48345 | 206 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-11-14 04:21:31 | Motley, Texas, US | |
717649 | 717649 | 2021-11-12 | US | Texas | Motley | 48345 | 206 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-11-13 04:21:38 | Motley, Texas, US | |
31599 | 31599 | 2021-11-11 | US | Texas | Motley | 48345 | 206 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-11-12 04:22:01 | Motley, Texas, US | |
6762 | 6762 | 2021-10-28 | US | North Dakota | Oliver | 38065 | 206 | 3 | 0 | 47.11530482 | -101.3406158 | 2021-10-29 04:22:03 | Oliver, North Dakota, US | |
2774251 | 2774251 | 2021-09-30 | US | Kansas | Comanche | 20033 | 206 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-10-01 04:21:35 | Comanche, Kansas, US | |
709874 | 709874 | 2021-09-29 | US | Washington | Garfield | 53023 | 206 | 7 | 0 | 46.43197502 | -117.54540320000001 | 2021-09-30 04:21:20 | Garfield, Washington, US | |
707707 | 707707 | 2021-09-29 | US | Kansas | Comanche | 20033 | 206 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-09-30 04:21:20 | Comanche, Kansas, US | |
1334700 | 1334700 | 2021-09-28 | US | Alaska | Haines | 2100 | 206 | 0 | 0 | 59.09893571 | -135.4679843 | 2021-09-29 04:21:45 | Haines, Alaska, US | |
1236069 | 1236069 | 2021-09-27 | US | Alaska | Haines | 2100 | 206 | 0 | 0 | 59.09893571 | -135.4679843 | 2021-09-28 04:21:28 | Haines, Alaska, US | |
3757170 | 3757170 | 2021-09-21 | Australia | Northern Territory | 206 | 0 | 0 | -12.4634 | 130.8456 | 2021-09-22 04:21:45 | Northern Territory, Australia | |||
809273 | 809273 | 2021-09-20 | Australia | Northern Territory | 206 | 0 | 0 | -12.4634 | 130.8456 | 2021-09-21 04:21:26 | Northern Territory, Australia | |||
1814472 | 1814472 | 2021-09-19 | Australia | Northern Territory | 206 | 0 | 0 | -12.4634 | 130.8456 | 2021-09-20 04:21:22 | Northern Territory, Australia | |||
1376200 | 1376200 | 2021-09-15 | US | Minnesota | Cook | 27031 | 206 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-09-16 04:22:19 | Cook, Minnesota, US | |
2465849 | 2465849 | 2021-09-14 | US | Texas | Cottle | 48101 | 206 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-09-15 03:22:37 | Cottle, Texas, US | |
2464499 | 2464499 | 2021-09-14 | US | Minnesota | Cook | 27031 | 206 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-09-15 03:22:37 | Cook, Minnesota, US | |
1388688 | 1388688 | 2021-09-13 | US | Texas | Cottle | 48101 | 206 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-09-14 04:21:41 | Cottle, Texas, US | |
1388057 | 1388057 | 2021-09-13 | US | North Dakota | Steele | 38091 | 206 | 2 | 0 | 47.45611548 | -97.72728747 | 2021-09-14 04:21:41 | Steele, North Dakota, US | |
1888057 | 1888057 | 2021-09-12 | US | Texas | Cottle | 48101 | 206 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-09-13 04:21:15 | Cottle, Texas, US | |
1887426 | 1887426 | 2021-09-12 | US | North Dakota | Steele | 38091 | 206 | 2 | 0 | 47.45611548 | -97.72728747 | 2021-09-13 04:21:15 | Steele, North Dakota, US | |
1887034 | 1887034 | 2021-09-12 | US | Montana | Wheatland | 30107 | 206 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-09-13 04:21:15 | Wheatland, Montana, US | |
1887008 | 1887008 | 2021-09-12 | US | Montana | McCone | 30055 | 206 | 2 | 0 | 47.64469406 | -105.79449939999999 | 2021-09-13 04:21:15 | McCone, Montana, US | |
3808960 | 3808960 | 2021-09-11 | US | Texas | Cottle | 48101 | 206 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-09-12 04:21:13 | Cottle, Texas, US | |
3808329 | 3808329 | 2021-09-11 | US | North Dakota | Steele | 38091 | 206 | 2 | 0 | 47.45611548 | -97.72728747 | 2021-09-12 04:21:13 | Steele, North Dakota, US | |
3807937 | 3807937 | 2021-09-11 | US | Montana | Wheatland | 30107 | 206 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-09-12 04:21:13 | Wheatland, Montana, US | |
3807911 | 3807911 | 2021-09-11 | US | Montana | McCone | 30055 | 206 | 2 | 0 | 47.64469406 | -105.79449939999999 | 2021-09-12 04:21:13 | McCone, Montana, US | |
3451269 | 3451269 | 2021-09-10 | US | North Dakota | Steele | 38091 | 206 | 2 | 0 | 47.45611548 | -97.72728747 | 2021-09-11 04:21:30 | Steele, North Dakota, US | |
3450877 | 3450877 | 2021-09-10 | US | Montana | Wheatland | 30107 | 206 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-09-11 04:21:30 | Wheatland, Montana, US | |
3450851 | 3450851 | 2021-09-10 | US | Montana | McCone | 30055 | 206 | 2 | 0 | 47.64469406 | -105.79449939999999 | 2021-09-11 04:21:30 | McCone, Montana, US | |
1265215 | 1265215 | 2021-09-09 | US | North Dakota | Steele | 38091 | 206 | 2 | 0 | 47.45611548 | -97.72728747 | 2021-09-10 04:21:20 | Steele, North Dakota, US | |
1264823 | 1264823 | 2021-09-09 | US | Montana | Wheatland | 30107 | 206 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-09-10 04:21:20 | Wheatland, Montana, US | |
1264797 | 1264797 | 2021-09-09 | US | Montana | McCone | 30055 | 206 | 2 | 0 | 47.64469406 | -105.79449939999999 | 2021-09-10 04:21:20 | McCone, Montana, US | |
1264778 | 1264778 | 2021-09-09 | US | Montana | Daniels | 30019 | 206 | 8 | 0 | 48.78420029 | -105.54763429999998 | 2021-09-10 04:21:20 | Daniels, Montana, US | |
1264767 | 1264767 | 2021-09-09 | US | Missouri | Worth | 29227 | 206 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-09-10 04:21:20 | Worth, Missouri, US | |
2281193 | 2281193 | 2021-09-08 | US | Montana | Wheatland | 30107 | 206 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-09-09 04:21:27 | Wheatland, Montana, US | |
2281167 | 2281167 | 2021-09-08 | US | Montana | McCone | 30055 | 206 | 2 | 0 | 47.64469406 | -105.79449939999999 | 2021-09-09 04:21:27 | McCone, Montana, US | |
2280055 | 2280055 | 2021-09-08 | US | Georgia | Webster | 13307 | 206 | 4 | 0 | 32.04066113 | -84.54742852 | 2021-09-09 04:21:27 | Webster, Georgia, US | |
643946 | 643946 | 2021-09-07 | US | Montana | McCone | 30055 | 206 | 2 | 0 | 47.64469406 | -105.79449939999999 | 2021-09-08 04:21:31 | McCone, Montana, US | |
3196393 | 3196393 | 2021-09-06 | US | North Dakota | Divide | 38023 | 206 | 2 | 0 | 48.814938700000006 | -103.48736109999999 | 2021-09-07 04:21:35 | Divide, North Dakota, US | |
3283261 | 3283261 | 2021-09-05 | US | North Dakota | Divide | 38023 | 206 | 2 | 0 | 48.814938700000006 | -103.48736109999999 | 2021-09-06 04:21:22 | Divide, North Dakota, US | |
1778818 | 1778818 | 2021-08-30 | US | Washington | Wahkiakum | 53069 | 206 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2021-08-31 04:21:46 | Wahkiakum, Washington, US | |
1598395 | 1598395 | 2021-08-26 | US | New Mexico | De Baca | 35011 | 206 | 3 | 0 | 34.34274529 | -104.4117842 | 2021-08-27 04:21:37 | De Baca, New Mexico, US | |
3107655 | 3107655 | 2021-08-24 | US | New Mexico | Mora | 35033 | 206 | 8 | 0 | 36.01095101 | -104.9497716 | 2021-08-25 04:21:41 | Mora, New Mexico, US | |
104674 | 104674 | 2021-08-15 | US | Kansas | Stanton | 20187 | 206 | 6 | 0 | 37.56304714 | -101.78435340000001 | 2021-08-16 04:21:31 | Stanton, Kansas, US | |
509032 | 509032 | 2021-08-14 | US | Kansas | Stanton | 20187 | 206 | 6 | 0 | 37.56304714 | -101.78435340000001 | 2021-08-15 04:21:41 | Stanton, Kansas, US | |
1484904 | 1484904 | 2021-08-13 | US | Kansas | Stanton | 20187 | 206 | 6 | 0 | 37.56304714 | -101.78435340000001 | 2021-08-14 04:21:25 | Stanton, Kansas, US | |
652401 | 652401 | 2021-08-09 | US | Northern Mariana Islands | 69 | 206 | 2 | 0 | 15.0979 | 145.6739 | 2021-08-10 04:21:27 | Northern Mariana Islands, 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]);