johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
472 rows where confirmed = 1224 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
453811 | 453811 | 2022-12-21 | US | North Dakota | Pierce | 38069 | 1224 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-12-22 04:20:56 | Pierce, North Dakota, US | |
852029 | 852029 | 2022-11-02 | US | North Dakota | Sargent | 38081 | 1224 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-11-03 04:22:05 | Sargent, North Dakota, US | |
133860 | 133860 | 2022-10-04 | US | Texas | Hall | 48191 | 1224 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-10-05 04:23:06 | Hall, Texas, US | |
2688807 | 2688807 | 2022-10-03 | US | Texas | Hall | 48191 | 1224 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-10-04 04:22:55 | Hall, Texas, US | |
3988169 | 3988169 | 2022-09-15 | US | Louisiana | Tensas | 22107 | 1224 | 13 | 0 | 32.00760749 | -91.32915234 | 2022-09-16 04:21:19 | Tensas, Louisiana, US | |
2990688 | 2990688 | 2022-09-04 | US | Virginia | Rappahannock | 51157 | 1224 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-09-05 04:21:01 | Rappahannock, Virginia, US | |
2716373 | 2716373 | 2022-09-03 | US | Virginia | Rappahannock | 51157 | 1224 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-09-04 04:21:22 | Rappahannock, Virginia, US | |
1397078 | 1397078 | 2022-09-02 | US | Virginia | Rappahannock | 51157 | 1224 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-09-03 04:21:04 | Rappahannock, Virginia, US | |
3548431 | 3548431 | 2022-09-01 | US | Idaho | Boise | 16015 | 1224 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-09-02 04:21:07 | Boise, Idaho, US | |
2344351 | 2344351 | 2022-08-31 | US | Idaho | Boise | 16015 | 1224 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-09-01 04:21:03 | Boise, Idaho, US | |
3776106 | 3776106 | 2022-08-30 | US | New Mexico | Hidalgo | 35023 | 1224 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-08-31 04:20:57 | Hidalgo, New Mexico, US | |
1253460 | 1253460 | 2022-08-23 | US | Pennsylvania | Sullivan | 42113 | 1224 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-08-24 04:20:46 | Sullivan, Pennsylvania, US | |
2855564 | 2855564 | 2022-08-22 | US | Pennsylvania | Sullivan | 42113 | 1224 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-08-23 04:20:56 | Sullivan, Pennsylvania, US | |
2405536 | 2405536 | 2022-08-21 | US | Pennsylvania | Sullivan | 42113 | 1224 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-08-22 04:20:38 | Sullivan, Pennsylvania, US | |
3800614 | 3800614 | 2022-08-20 | US | Pennsylvania | Sullivan | 42113 | 1224 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-08-21 04:20:44 | Sullivan, Pennsylvania, US | |
2366200 | 2366200 | 2022-08-19 | US | Pennsylvania | Sullivan | 42113 | 1224 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-08-20 04:21:01 | Sullivan, Pennsylvania, US | |
1163871 | 1163871 | 2022-08-18 | US | Pennsylvania | Sullivan | 42113 | 1224 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-08-19 04:20:54 | Sullivan, Pennsylvania, US | |
1073311 | 1073311 | 2022-08-07 | US | Virginia | Surry | 51181 | 1224 | 20 | 0 | 37.11781893 | -76.88450012 | 2022-08-08 04:21:08 | Surry, Virginia, US | |
1943899 | 1943899 | 2022-08-06 | US | Virginia | Surry | 51181 | 1224 | 20 | 0 | 37.11781893 | -76.88450012 | 2022-08-07 04:20:54 | Surry, Virginia, US | |
883698 | 883698 | 2022-08-05 | US | Virginia | Surry | 51181 | 1224 | 20 | 0 | 37.11781893 | -76.88450012 | 2022-08-06 04:20:56 | Surry, Virginia, US | |
1650400 | 1650400 | 2022-06-23 | US | Montana | Pondera | 30073 | 1224 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-06-24 04:20:58 | Pondera, Montana, US | |
2189635 | 2189635 | 2022-06-22 | US | Montana | Pondera | 30073 | 1224 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-06-23 04:20:55 | Pondera, Montana, US | |
168066 | 168066 | 2022-06-21 | US | Montana | Pondera | 30073 | 1224 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-06-22 04:20:54 | Pondera, Montana, US | |
1765349 | 1765349 | 2022-06-20 | US | Montana | Pondera | 30073 | 1224 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-06-21 04:20:56 | Pondera, Montana, US | |
1764325 | 1764325 | 2022-06-20 | US | Illinois | Henderson | 17071 | 1224 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-06-21 04:20:56 | Henderson, Illinois, US | |
3271535 | 3271535 | 2022-06-19 | US | Montana | Pondera | 30073 | 1224 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-06-20 04:21:01 | Pondera, Montana, US | |
3270511 | 3270511 | 2022-06-19 | US | Illinois | Henderson | 17071 | 1224 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-06-20 04:21:01 | Henderson, Illinois, US | |
3399447 | 3399447 | 2022-06-18 | US | Montana | Pondera | 30073 | 1224 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-06-19 04:20:51 | Pondera, Montana, US | |
3398423 | 3398423 | 2022-06-18 | US | Illinois | Henderson | 17071 | 1224 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-06-19 04:20:51 | Henderson, Illinois, US | |
2313324 | 2313324 | 2022-06-17 | US | Montana | Pondera | 30073 | 1224 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-06-18 04:21:10 | Pondera, Montana, US | |
2312300 | 2312300 | 2022-06-17 | US | Illinois | Henderson | 17071 | 1224 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-06-18 04:21:10 | Henderson, Illinois, US | |
1424436 | 1424436 | 2022-06-08 | US | Virginia | Emporia | 51595 | 1224 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-06-09 04:20:54 | Emporia, Virginia, US | |
1424271 | 1424271 | 2022-06-08 | US | Texas | Martin | 48317 | 1224 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-06-09 04:20:54 | Martin, Texas, US | |
3729550 | 3729550 | 2022-06-07 | US | Virginia | Emporia | 51595 | 1224 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-06-08 04:20:55 | Emporia, Virginia, US | |
3729385 | 3729385 | 2022-06-07 | US | Texas | Martin | 48317 | 1224 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-06-08 04:20:55 | Martin, Texas, US | |
3890952 | 3890952 | 2022-06-06 | US | Virginia | Emporia | 51595 | 1224 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-06-07 04:21:08 | Emporia, Virginia, US | |
2999961 | 2999961 | 2022-05-24 | US | Colorado | Saguache | 8109 | 1224 | 12 | 0 | 38.08054629 | -106.282466 | 2022-05-25 04:20:56 | Saguache, Colorado, US | |
3594764 | 3594764 | 2022-05-23 | US | Minnesota | Lincoln | 27081 | 1224 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-05-24 04:20:57 | Lincoln, Minnesota, US | |
1111312 | 1111312 | 2022-05-21 | US | Minnesota | Lincoln | 27081 | 1224 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-05-22 04:20:52 | Lincoln, Minnesota, US | |
1170936 | 1170936 | 2022-05-20 | US | Minnesota | Lincoln | 27081 | 1224 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-05-21 04:20:58 | Lincoln, Minnesota, US | |
696502 | 696502 | 2022-03-17 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-18 04:20:55 | Polk, Nebraska, US | |
2321445 | 2321445 | 2022-03-16 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-17 04:20:56 | Polk, Nebraska, US | |
264817 | 264817 | 2022-03-15 | US | Vermont | Essex | 50009 | 1224 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-03-16 04:20:50 | Essex, Vermont, US | |
263645 | 263645 | 2022-03-15 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-16 04:20:50 | Polk, Nebraska, US | |
2267176 | 2267176 | 2022-03-14 | US | Vermont | Essex | 50009 | 1224 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-03-15 04:20:47 | Essex, Vermont, US | |
2266004 | 2266004 | 2022-03-14 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-15 04:20:47 | Polk, Nebraska, US | |
3630070 | 3630070 | 2022-03-13 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-14 04:20:46 | Polk, Nebraska, US | |
952978 | 952978 | 2022-03-12 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-13 04:20:49 | Polk, Nebraska, US | |
358439 | 358439 | 2022-03-11 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-12 04:20:50 | Polk, Nebraska, US | |
1867591 | 1867591 | 2022-03-10 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-11 04:20:50 | Polk, Nebraska, US | |
2142286 | 2142286 | 2022-03-09 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-10 04:20:48 | Polk, Nebraska, US | |
921797 | 921797 | 2022-03-08 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-09 04:20:59 | Polk, Nebraska, US | |
1550084 | 1550084 | 2022-03-07 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-08 04:20:54 | Polk, Nebraska, US | |
2201753 | 2201753 | 2022-03-06 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-07 04:20:47 | Polk, Nebraska, US | |
2094210 | 2094210 | 2022-03-05 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-06 04:20:49 | Polk, Nebraska, US | |
2667910 | 2667910 | 2022-03-04 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-05 04:21:10 | Polk, Nebraska, US | |
1646475 | 1646475 | 2022-03-03 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-04 04:21:09 | Polk, Nebraska, US | |
2527478 | 2527478 | 2022-03-02 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-03 04:21:01 | Polk, Nebraska, US | |
1994772 | 1994772 | 2022-03-01 | US | Nebraska | Polk | 31143 | 1224 | 9 | 0 | 41.18813488 | -97.56630712 | 2022-03-02 04:21:07 | Polk, Nebraska, US | |
1514621 | 1514621 | 2022-02-24 | US | Texas | Sabine | 48403 | 1224 | 83 | 0 | 31.34318809 | -93.85440451 | 2022-02-25 04:21:11 | Sabine, Texas, US | |
1061062 | 1061062 | 2022-02-23 | US | Texas | Sabine | 48403 | 1224 | 83 | 0 | 31.34318809 | -93.85440451 | 2022-02-24 04:21:14 | Sabine, Texas, US | |
73201 | 73201 | 2022-02-07 | US | Nebraska | Pierce | 31139 | 1224 | 20 | 0 | 42.26434853 | -97.60122773 | 2022-02-08 04:21:15 | Pierce, Nebraska, US | |
73124 | 73124 | 2022-02-07 | US | Montana | Teton | 30099 | 1224 | 19 | 0 | 47.83741052 | -112.24106880000001 | 2022-02-08 04:21:15 | Teton, Montana, US | |
72036 | 72036 | 2022-02-07 | US | Idaho | Lemhi | 16059 | 1224 | 25 | 0 | 44.9438088 | -113.9309747 | 2022-02-08 04:21:15 | Lemhi, Idaho, US | |
2477125 | 2477125 | 2022-02-03 | US | Texas | McCulloch | 48307 | 1224 | 42 | 0 | 31.1925468 | -99.34682807 | 2022-02-04 04:21:10 | McCulloch, Texas, US | |
982388 | 982388 | 2022-02-01 | US | Washington | Ferry | 53019 | 1224 | 20 | 0 | 48.471143100000006 | -118.5154041 | 2022-02-02 04:21:09 | Ferry, Washington, US | |
979911 | 979911 | 2022-02-01 | US | Illinois | Alexander | 17003 | 1224 | 13 | 0 | 37.18049267 | -89.32910838 | 2022-02-02 04:21:09 | Alexander, Illinois, US | |
2661230 | 2661230 | 2022-01-31 | US | Washington | Ferry | 53019 | 1224 | 20 | 0 | 48.471143100000006 | -118.5154041 | 2022-02-01 04:21:11 | Ferry, Washington, US | |
3301909 | 3301909 | 2022-01-30 | US | Minnesota | Big Stone | 27011 | 1224 | 7 | 0 | 45.42712824 | -96.41403739 | 2022-01-31 04:21:09 | Big Stone, Minnesota, US | |
3063700 | 3063700 | 2022-01-29 | US | Minnesota | Big Stone | 27011 | 1224 | 7 | 0 | 45.42712824 | -96.41403739 | 2022-01-30 04:21:26 | Big Stone, Minnesota, US | |
3811634 | 3811634 | 2022-01-28 | US | Minnesota | Big Stone | 27011 | 1224 | 7 | 0 | 45.42712824 | -96.41403739 | 2022-01-29 04:21:10 | Big Stone, Minnesota, US | |
1321099 | 1321099 | 2022-01-26 | US | South Dakota | Kingsbury | 46077 | 1224 | 20 | 0 | 44.36956169 | -97.4913945 | 2022-01-27 04:21:19 | Kingsbury, South Dakota, US | |
1319674 | 1319674 | 2022-01-26 | US | Kentucky | Owsley | 21189 | 1224 | 23 | 0 | 37.42823949 | -83.68811419 | 2022-01-27 04:21:19 | Owsley, Kentucky, US | |
1143809 | 1143809 | 2022-01-23 | US | South Dakota | Moody | 46101 | 1224 | 26 | 0 | 44.02266214 | -96.67081159 | 2022-01-24 04:21:12 | Moody, South Dakota, US | |
2835727 | 2835727 | 2022-01-22 | US | South Dakota | Moody | 46101 | 1224 | 26 | 0 | 44.02266214 | -96.67081159 | 2022-01-23 04:21:13 | Moody, South Dakota, US | |
3427845 | 3427845 | 2022-01-21 | US | South Dakota | Moody | 46101 | 1224 | 26 | 0 | 44.02266214 | -96.67081159 | 2022-01-22 04:21:13 | Moody, South Dakota, US | |
1473854 | 1473854 | 2022-01-17 | US | Minnesota | Mahnomen | 27087 | 1224 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-01-18 04:21:04 | Mahnomen, Minnesota, US | |
556528 | 556528 | 2022-01-16 | US | Minnesota | Mahnomen | 27087 | 1224 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-01-17 04:21:08 | Mahnomen, Minnesota, US | |
3842249 | 3842249 | 2022-01-15 | US | Minnesota | Mahnomen | 27087 | 1224 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-01-16 04:21:12 | Mahnomen, Minnesota, US | |
101064 | 101064 | 2022-01-14 | US | Minnesota | Mahnomen | 27087 | 1224 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-01-15 04:21:07 | Mahnomen, Minnesota, US | |
3615968 | 3615968 | 2022-01-12 | US | South Dakota | Spink | 46115 | 1224 | 31 | 0 | 44.93837606 | -98.34626602 | 2022-01-13 08:00:09 | Spink, South Dakota, US | |
3614949 | 3614949 | 2022-01-12 | US | Missouri | Carter | 29035 | 1224 | 19 | 0 | 36.94160441 | -90.96051322 | 2022-01-13 08:00:09 | Carter, Missouri, US | |
1115694 | 1115694 | 2022-01-11 | US | Nebraska | Nemaha | 31127 | 1224 | 15 | 0 | 40.38514847 | -95.85433992 | 2022-01-12 04:21:44 | Nemaha, Nebraska, US | |
128881 | 128881 | 2022-01-09 | US | Nevada | Pershing | 32027 | 1224 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-01-10 04:22:07 | Pershing, Nevada, US | |
128662 | 128662 | 2022-01-09 | US | Missouri | Maries | 29125 | 1224 | 25 | 0 | 38.16193985 | -91.92249662 | 2022-01-10 04:22:07 | Maries, Missouri, US | |
127243 | 127243 | 2022-01-09 | US | Arkansas | Montgomery | 5097 | 1224 | 53 | 0 | 34.53704874 | -93.65824478 | 2022-01-10 04:22:07 | Montgomery, Arkansas, US | |
1217716 | 1217716 | 2022-01-08 | US | Nevada | Pershing | 32027 | 1224 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-01-09 04:21:46 | Pershing, Nevada, US | |
1217497 | 1217497 | 2022-01-08 | US | Missouri | Maries | 29125 | 1224 | 25 | 0 | 38.16193985 | -91.92249662 | 2022-01-09 04:21:46 | Maries, Missouri, US | |
1216078 | 1216078 | 2022-01-08 | US | Arkansas | Montgomery | 5097 | 1224 | 53 | 0 | 34.53704874 | -93.65824478 | 2022-01-09 04:21:46 | Montgomery, Arkansas, US | |
1391809 | 1391809 | 2022-01-07 | US | Nevada | Pershing | 32027 | 1224 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-01-08 04:21:53 | Pershing, Nevada, US | |
2611397 | 2611397 | 2022-01-06 | US | Kansas | Sherman | 20181 | 1224 | 15 | 0 | 39.35147699 | -101.71976240000001 | 2022-01-07 04:22:09 | Sherman, Kansas, US | |
1283339 | 1283339 | 2022-01-05 | US | Kansas | Sherman | 20181 | 1224 | 15 | 0 | 39.35147699 | -101.71976240000001 | 2022-01-06 04:22:09 | Sherman, Kansas, US | |
2777603 | 2777603 | 2021-12-31 | US | Colorado | Conejos | 8021 | 1224 | 47 | 0 | 37.201606 | -106.19174879999998 | 2022-01-01 04:22:14 | Conejos, Colorado, US | |
2115082 | 2115082 | 2021-12-26 | US | Virginia | Northampton | 51131 | 1224 | 48 | 0 | 37.34062933 | -75.87751591 | 2021-12-27 04:21:58 | Northampton, Virginia, US | |
3608454 | 3608454 | 2021-12-25 | US | Virginia | Northampton | 51131 | 1224 | 48 | 0 | 37.34062933 | -75.87751591 | 2021-12-26 04:21:50 | Northampton, Virginia, US | |
2966772 | 2966772 | 2021-12-24 | US | Virginia | Northampton | 51131 | 1224 | 48 | 0 | 37.34062933 | -75.87751591 | 2021-12-25 04:21:37 | Northampton, Virginia, US | |
2966182 | 2966182 | 2021-12-24 | US | Puerto Rico | Yauco | 72153 | 1224 | 0 | 0 | 18.080374 | -66.858814 | 2021-12-25 04:21:37 | Yauco, Puerto Rico, US | |
3819214 | 3819214 | 2021-12-23 | US | Puerto Rico | Yauco | 72153 | 1224 | 0 | 0 | 18.080374 | -66.858814 | 2021-12-24 04:21:34 | Yauco, Puerto Rico, US | |
3831256 | 3831256 | 2021-12-21 | US | Puerto Rico | Utuado | 72141 | 1224 | 0 | 0 | 18.271214 | -66.702984 | 2021-12-22 04:21:54 | Utuado, Puerto Rico, US | |
2906458 | 2906458 | 2021-12-19 | US | Puerto Rico | Guayama | 72057 | 1224 | 0 | 0 | 18.007516 | -66.13390799999999 | 2021-12-20 04:21:43 | Guayama, Puerto Rico, 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]);