johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
745 rows where confirmed = 461 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3717056 | 3717056 | 2022-12-06 | US | South Dakota | Jerauld | 46073 | 461 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-07 04:20:58 | Jerauld, South Dakota, US | |
2417761 | 2417761 | 2022-12-05 | US | South Dakota | Jerauld | 46073 | 461 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-06 04:21:03 | Jerauld, South Dakota, US | |
721369 | 721369 | 2022-12-04 | US | South Dakota | Jerauld | 46073 | 461 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-05 04:20:58 | Jerauld, South Dakota, US | |
718287 | 718287 | 2022-12-04 | China | Qinghai | 461 | 0 | 0 | 35.7452 | 95.9956 | 2022-12-05 04:20:58 | Qinghai, China | |||
2819658 | 2819658 | 2022-12-03 | US | South Dakota | Jerauld | 46073 | 461 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-04 04:20:56 | Jerauld, South Dakota, US | |
2816576 | 2816576 | 2022-12-03 | China | Qinghai | 461 | 0 | 0 | 35.7452 | 95.9956 | 2022-12-04 04:20:56 | Qinghai, China | |||
836514 | 836514 | 2022-12-02 | US | South Dakota | Jerauld | 46073 | 461 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-03 04:21:02 | Jerauld, South Dakota, US | |
2139044 | 2139044 | 2022-12-01 | US | South Dakota | Jerauld | 46073 | 461 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-02 04:21:07 | Jerauld, South Dakota, US | |
1967460 | 1967460 | 2022-11-30 | US | South Dakota | Jerauld | 46073 | 461 | 20 | 0 | 44.06637798 | -98.62965972 | 2022-12-01 04:21:03 | Jerauld, South Dakota, US | |
2759661 | 2759661 | 2022-10-18 | US | Puerto Rico | Culebra | 72049 | 461 | 0 | 0 | 18.31586 | -65.28813 | 2022-10-19 04:22:26 | Culebra, Puerto Rico, US | |
2027495 | 2027495 | 2022-10-17 | US | Puerto Rico | Culebra | 72049 | 461 | 0 | 0 | 18.31586 | -65.28813 | 2022-10-18 04:22:42 | Culebra, Puerto Rico, US | |
3253043 | 3253043 | 2022-10-11 | US | South Dakota | McPherson | 46089 | 461 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-12 04:22:51 | McPherson, South Dakota, US | |
2970302 | 2970302 | 2022-10-10 | US | South Dakota | McPherson | 46089 | 461 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-11 04:23:05 | McPherson, South Dakota, US | |
3100338 | 3100338 | 2022-10-09 | US | South Dakota | McPherson | 46089 | 461 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-10 04:22:32 | McPherson, South Dakota, US | |
4005563 | 4005563 | 2022-10-08 | US | South Dakota | McPherson | 46089 | 461 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-09 04:21:16 | McPherson, South Dakota, US | |
399160 | 399160 | 2022-10-07 | US | South Dakota | McPherson | 46089 | 461 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-08 04:22:56 | McPherson, South Dakota, US | |
2532742 | 2532742 | 2022-10-06 | US | Virginia | Highland | 51091 | 461 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-10-07 04:23:08 | Highland, Virginia, US | |
2532277 | 2532277 | 2022-10-06 | US | South Dakota | McPherson | 46089 | 461 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-07 04:23:08 | McPherson, South Dakota, US | |
1813671 | 1813671 | 2022-10-05 | US | South Dakota | McPherson | 46089 | 461 | 11 | 0 | 45.76626028 | -99.22118798 | 2022-10-06 04:21:22 | McPherson, South Dakota, US | |
3998081 | 3998081 | 2022-09-27 | US | Washington | Garfield | 53023 | 461 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-09-28 04:23:01 | Garfield, Washington, US | |
2772409 | 2772409 | 2022-09-26 | US | Washington | Garfield | 53023 | 461 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-09-27 04:23:01 | Garfield, Washington, US | |
1980062 | 1980062 | 2022-09-25 | US | Washington | Garfield | 53023 | 461 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-09-26 04:20:52 | Garfield, Washington, US | |
2653229 | 2653229 | 2022-09-24 | US | Washington | Garfield | 53023 | 461 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-09-25 04:23:31 | Garfield, Washington, US | |
387669 | 387669 | 2022-09-23 | US | Washington | Garfield | 53023 | 461 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-09-24 04:21:40 | Garfield, Washington, US | |
116027 | 116027 | 2022-09-06 | US | Kansas | Comanche | 20033 | 461 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-09-07 04:20:59 | Comanche, Kansas, US | |
2634999 | 2634999 | 2022-09-05 | US | Kansas | Comanche | 20033 | 461 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-09-06 04:21:02 | Comanche, Kansas, US | |
2988563 | 2988563 | 2022-09-04 | US | Kansas | Comanche | 20033 | 461 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-09-05 04:21:01 | Comanche, Kansas, US | |
2714248 | 2714248 | 2022-09-03 | US | Kansas | Comanche | 20033 | 461 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-09-04 04:21:22 | Comanche, Kansas, US | |
1394953 | 1394953 | 2022-09-02 | US | Kansas | Comanche | 20033 | 461 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-09-03 04:21:04 | Comanche, Kansas, US | |
3548782 | 3548782 | 2022-09-01 | US | Kansas | Comanche | 20033 | 461 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-09-02 04:21:07 | Comanche, Kansas, US | |
2344702 | 2344702 | 2022-08-31 | US | Kansas | Comanche | 20033 | 461 | 17 | 0 | 37.1911452 | -99.27113247 | 2022-09-01 04:21:03 | Comanche, Kansas, US | |
2325741 | 2325741 | 2022-08-24 | US | North Dakota | Burke | 38013 | 461 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-08-25 04:21:13 | Burke, North Dakota, US | |
1253150 | 1253150 | 2022-08-23 | US | North Dakota | Burke | 38013 | 461 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-08-24 04:20:46 | Burke, North Dakota, US | |
2855254 | 2855254 | 2022-08-22 | US | North Dakota | Burke | 38013 | 461 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-08-23 04:20:56 | Burke, North Dakota, US | |
992355 | 992355 | 2022-08-16 | US | Kansas | Wallace | 20199 | 461 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-08-17 04:20:59 | Wallace, Kansas, US | |
2495394 | 2495394 | 2022-08-15 | US | Kansas | Wallace | 20199 | 461 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-08-16 04:20:58 | Wallace, Kansas, US | |
3648944 | 3648944 | 2022-08-14 | US | Kansas | Wallace | 20199 | 461 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-08-15 04:20:59 | Wallace, Kansas, US | |
1969950 | 1969950 | 2022-08-13 | US | Kansas | Wallace | 20199 | 461 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-08-14 04:20:55 | Wallace, Kansas, US | |
2889759 | 2889759 | 2022-08-12 | US | Kansas | Wallace | 20199 | 461 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-08-13 04:20:52 | Wallace, Kansas, US | |
3909364 | 3909364 | 2022-08-11 | US | Kansas | Wallace | 20199 | 461 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-08-12 04:20:54 | Wallace, Kansas, US | |
1347681 | 1347681 | 2022-08-10 | US | Kansas | Wallace | 20199 | 461 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-08-11 04:20:49 | Wallace, Kansas, US | |
1407453 | 1407453 | 2022-08-02 | US | North Dakota | Logan | 38047 | 461 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-08-03 04:20:59 | Logan, North Dakota, US | |
1199610 | 1199610 | 2022-07-06 | China | Macau | 461 | 2 | 0 | 22.1667 | 113.55 | 2022-07-07 04:20:55 | Macau, China | |||
3966353 | 3966353 | 2022-07-05 | China | Macau | 461 | 2 | 0 | 22.1667 | 113.55 | 2022-07-06 04:20:58 | Macau, China | |||
3136681 | 3136681 | 2022-06-03 | US | Texas | Irion | 48235 | 461 | 3 | 0 | 31.30375559 | -100.982439 | 2022-06-04 04:20:58 | Irion, Texas, US | |
3581756 | 3581756 | 2022-06-02 | US | Texas | Irion | 48235 | 461 | 3 | 0 | 31.30375559 | -100.982439 | 2022-06-03 04:20:58 | Irion, Texas, US | |
1505997 | 1505997 | 2022-05-16 | US | North Dakota | Divide | 38023 | 461 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-17 04:20:59 | Divide, North Dakota, US | |
2086356 | 2086356 | 2022-05-15 | US | North Dakota | Divide | 38023 | 461 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-16 04:20:47 | Divide, North Dakota, US | |
3357066 | 3357066 | 2022-05-14 | US | North Dakota | Divide | 38023 | 461 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-15 04:20:53 | Divide, North Dakota, US | |
660711 | 660711 | 2022-05-13 | US | North Dakota | Divide | 38023 | 461 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-14 04:20:48 | Divide, North Dakota, US | |
2535794 | 2535794 | 2022-05-12 | US | North Dakota | Divide | 38023 | 461 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-13 04:20:51 | Divide, North Dakota, US | |
3447240 | 3447240 | 2022-05-11 | US | North Dakota | Divide | 38023 | 461 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-12 04:20:54 | Divide, North Dakota, US | |
3537857 | 3537857 | 2022-05-10 | US | North Dakota | Divide | 38023 | 461 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-11 04:20:48 | Divide, North Dakota, US | |
224392 | 224392 | 2022-05-09 | US | North Dakota | Divide | 38023 | 461 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-10 04:20:50 | Divide, North Dakota, US | |
2333777 | 2333777 | 2022-05-08 | US | North Dakota | Divide | 38023 | 461 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-09 04:20:54 | Divide, North Dakota, US | |
362739 | 362739 | 2022-05-07 | US | North Dakota | Divide | 38023 | 461 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-08 04:20:49 | Divide, North Dakota, US | |
1400090 | 1400090 | 2022-05-06 | US | North Dakota | Divide | 38023 | 461 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-07 04:21:09 | Divide, North Dakota, US | |
2600445 | 2600445 | 2022-05-05 | US | North Dakota | Divide | 38023 | 461 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-06 04:21:00 | Divide, North Dakota, US | |
2803810 | 2803810 | 2022-04-06 | US | Texas | Briscoe | 48045 | 461 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-04-07 04:20:53 | Briscoe, Texas, US | |
3870579 | 3870579 | 2022-04-05 | US | Texas | Briscoe | 48045 | 461 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-04-06 04:20:49 | Briscoe, Texas, US | |
2751921 | 2751921 | 2022-04-04 | US | Texas | Briscoe | 48045 | 461 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-04-05 04:20:48 | Briscoe, Texas, US | |
1993955 | 1993955 | 2022-03-01 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-03-02 04:21:07 | Hamilton, Kansas, US | |
944129 | 944129 | 2022-02-28 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-03-01 04:21:09 | Hamilton, Kansas, US | |
2734320 | 2734320 | 2022-02-27 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-28 04:21:05 | Hamilton, Kansas, US | |
3047473 | 3047473 | 2022-02-26 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-27 04:21:04 | Hamilton, Kansas, US | |
576128 | 576128 | 2022-02-25 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-26 04:21:12 | Hamilton, Kansas, US | |
1512704 | 1512704 | 2022-02-24 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-25 04:21:11 | Hamilton, Kansas, US | |
1059145 | 1059145 | 2022-02-23 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-24 04:21:14 | Hamilton, Kansas, US | |
2448068 | 2448068 | 2022-02-22 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-23 04:21:09 | Hamilton, Kansas, US | |
3719481 | 3719481 | 2022-02-21 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-22 04:21:01 | Hamilton, Kansas, US | |
3913315 | 3913315 | 2022-02-20 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-21 04:21:05 | Hamilton, Kansas, US | |
3876873 | 3876873 | 2022-02-19 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-20 04:21:00 | Hamilton, Kansas, US | |
3857129 | 3857129 | 2022-02-18 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-19 04:21:11 | Hamilton, Kansas, US | |
1299348 | 1299348 | 2022-02-17 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-18 04:21:04 | Hamilton, Kansas, US | |
3821734 | 3821734 | 2022-02-16 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-17 04:20:56 | Hamilton, Kansas, US | |
3672948 | 3672948 | 2022-02-15 | US | Kansas | Hamilton | 20075 | 461 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-02-16 04:21:10 | Hamilton, Kansas, US | |
188348 | 188348 | 2022-02-13 | US | New York | Unassigned | 90036 | 461 | 1 | 0 | 44.74530905 | 0.0 | 2022-02-14 04:20:51 | Unassigned, New York, US | |
2476715 | 2476715 | 2022-02-03 | US | Puerto Rico | Maricao | 72093 | 461 | 0 | 0 | 18.171795 | -66.942126 | 2022-02-04 04:21:10 | Maricao, Puerto Rico, US | |
2476356 | 2476356 | 2022-02-03 | US | North Dakota | Golden Valley | 38033 | 461 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-02-04 04:21:10 | Golden Valley, North Dakota, US | |
461781 | 461781 | 2022-02-02 | US | North Dakota | Golden Valley | 38033 | 461 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-02-03 04:21:21 | Golden Valley, North Dakota, US | |
460307 | 460307 | 2022-02-02 | US | Idaho | Butte | 16023 | 461 | 7 | 0 | 43.72592209 | -113.1735463 | 2022-02-03 04:21:21 | Butte, Idaho, US | |
1961839 | 1961839 | 2022-01-20 | US | Kansas | Elk | 20049 | 461 | 7 | 0 | 37.45338105 | -96.24369667 | 2022-01-21 04:21:09 | Elk, Kansas, US | |
3227734 | 3227734 | 2022-01-19 | US | Kansas | Elk | 20049 | 461 | 7 | 0 | 37.45338105 | -96.24369667 | 2022-01-20 04:21:07 | Elk, Kansas, US | |
1392083 | 1392083 | 2022-01-07 | US | North Dakota | Renville | 38075 | 461 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-01-08 04:21:53 | Renville, North Dakota, US | |
2613157 | 2613157 | 2022-01-06 | US | Texas | Hardeman | 48197 | 461 | 14 | 0 | 34.28944521 | -99.74632408 | 2022-01-07 04:22:09 | Hardeman, Texas, US | |
2612470 | 2612470 | 2022-01-06 | US | North Dakota | Renville | 38075 | 461 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-01-07 04:22:09 | Renville, North Dakota, US | |
1285099 | 1285099 | 2022-01-05 | US | Texas | Hardeman | 48197 | 461 | 14 | 0 | 34.28944521 | -99.74632408 | 2022-01-06 04:22:09 | Hardeman, Texas, US | |
1288410 | 1288410 | 2022-01-04 | US | North Dakota | Griggs | 38039 | 461 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-01-05 04:21:59 | Griggs, North Dakota, US | |
1433873 | 1433873 | 2021-12-28 | US | Kansas | Kiowa | 20097 | 461 | 6 | 0 | 37.55848695 | -99.2856537 | 2021-12-29 03:21:43 | Kiowa, Kansas, US | |
731834 | 731834 | 2021-12-27 | US | Kansas | Kiowa | 20097 | 461 | 6 | 0 | 37.55848695 | -99.2856537 | 2021-12-28 04:21:47 | Kiowa, Kansas, US | |
3831220 | 3831220 | 2021-12-21 | US | Puerto Rico | Jayuya | 72073 | 461 | 0 | 0 | 18.211446 | -66.58878 | 2021-12-22 04:21:54 | Jayuya, Puerto Rico, US | |
1257643 | 1257643 | 2021-12-20 | US | South Dakota | Faulk | 46049 | 461 | 15 | 0 | 45.07082625 | -99.14535601 | 2021-12-21 03:21:27 | Faulk, South Dakota, US | |
3498574 | 3498574 | 2021-12-15 | US | North Dakota | Adams | 38001 | 461 | 8 | 0 | 46.09686891 | -102.5285397 | 2021-12-16 04:22:11 | Adams, North Dakota, US | |
2090735 | 2090735 | 2021-12-14 | US | Puerto Rico | Maunabo | 72095 | 461 | 0 | 0 | 18.017889 | -65.922235 | 2021-12-15 03:22:16 | Maunabo, Puerto Rico, US | |
785152 | 785152 | 2021-12-13 | US | Puerto Rico | Maunabo | 72095 | 461 | 0 | 0 | 18.017889 | -65.922235 | 2021-12-14 04:22:38 | Maunabo, Puerto Rico, US | |
1663187 | 1663187 | 2021-12-12 | US | Puerto Rico | Maunabo | 72095 | 461 | 0 | 0 | 18.017889 | -65.922235 | 2021-12-13 04:22:02 | Maunabo, Puerto Rico, US | |
1079247 | 1079247 | 2021-12-09 | US | Kansas | Morton | 20129 | 461 | 10 | 0 | 37.19141121 | -101.79925190000002 | 2021-12-10 04:22:28 | Morton, Kansas, US | |
552096 | 552096 | 2021-12-08 | US | Kansas | Morton | 20129 | 461 | 10 | 0 | 37.19141121 | -101.79925190000002 | 2021-12-09 04:22:49 | Morton, Kansas, US | |
1233562 | 1233562 | 2021-11-28 | US | Missouri | Mercer | 29129 | 461 | 3 | 0 | 40.42212303 | -93.56829590000001 | 2021-11-29 04:22:30 | Mercer, Missouri, US | |
1360269 | 1360269 | 2021-11-27 | US | Missouri | Mercer | 29129 | 461 | 3 | 0 | 40.42212303 | -93.56829590000001 | 2021-11-28 04:22:43 | Mercer, Missouri, 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]);