johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
531 rows where confirmed = 1030 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1621074 | 1621074 | 2022-11-22 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-23 04:21:06 | Echols, Georgia, US | |
3460962 | 3460962 | 2022-11-21 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-22 04:20:47 | Echols, Georgia, US | |
1641147 | 1641147 | 2022-11-20 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-21 04:21:05 | Echols, Georgia, US | |
2064704 | 2064704 | 2022-11-19 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-20 04:21:08 | Echols, Georgia, US | |
1756098 | 1756098 | 2022-11-18 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-19 04:21:14 | Echols, Georgia, US | |
3027091 | 3027091 | 2022-11-17 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-18 04:21:15 | Echols, Georgia, US | |
2486802 | 2486802 | 2022-11-16 | US | Georgia | Echols | 13101 | 1030 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-11-17 04:21:11 | Echols, Georgia, US | |
2506711 | 2506711 | 2022-11-10 | US | Colorado | Phillips | 8095 | 1030 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-11-11 04:21:22 | Phillips, Colorado, US | |
2431586 | 2431586 | 2022-11-09 | US | Colorado | Phillips | 8095 | 1030 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-11-10 04:21:16 | Phillips, Colorado, US | |
323051 | 323051 | 2022-10-30 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-31 04:21:36 | Haskell, Texas, US | |
915327 | 915327 | 2022-10-29 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-30 04:22:14 | Haskell, Texas, US | |
914453 | 914453 | 2022-10-29 | US | New York | Hamilton | 36041 | 1030 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-10-30 04:22:14 | Hamilton, New York, US | |
1369596 | 1369596 | 2022-10-28 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-29 04:21:13 | Haskell, Texas, US | |
3041451 | 3041451 | 2022-10-27 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-28 04:22:31 | Haskell, Texas, US | |
541871 | 541871 | 2022-10-26 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-27 04:22:01 | Haskell, Texas, US | |
1833272 | 1833272 | 2022-10-25 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-26 04:22:19 | Haskell, Texas, US | |
797533 | 797533 | 2022-10-24 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-25 04:21:53 | Haskell, Texas, US | |
3279988 | 3279988 | 2022-10-23 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-24 04:22:29 | Haskell, Texas, US | |
2271026 | 2271026 | 2022-10-22 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-23 04:22:46 | Haskell, Texas, US | |
1595326 | 1595326 | 2022-10-21 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-22 04:22:53 | Haskell, Texas, US | |
2275042 | 2275042 | 2022-10-20 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-21 04:22:23 | Haskell, Texas, US | |
201377 | 201377 | 2022-10-19 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-20 04:22:59 | Haskell, Texas, US | |
2760038 | 2760038 | 2022-10-18 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-19 04:22:26 | Haskell, Texas, US | |
2027872 | 2027872 | 2022-10-17 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-18 04:22:42 | Haskell, Texas, US | |
2162755 | 2162755 | 2022-10-16 | US | Texas | Shackelford | 48417 | 1030 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-10-17 04:20:31 | Shackelford, Texas, US | |
2162650 | 2162650 | 2022-10-16 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-17 04:20:31 | Haskell, Texas, US | |
518952 | 518952 | 2022-10-15 | US | Texas | Shackelford | 48417 | 1030 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-10-16 04:22:39 | Shackelford, Texas, US | |
518847 | 518847 | 2022-10-15 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-16 04:22:39 | Haskell, Texas, US | |
2036009 | 2036009 | 2022-10-14 | US | Texas | Shackelford | 48417 | 1030 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-10-15 04:22:00 | Shackelford, Texas, US | |
2035904 | 2035904 | 2022-10-14 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-15 04:22:00 | Haskell, Texas, US | |
3756592 | 3756592 | 2022-10-13 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-14 04:22:28 | Haskell, Texas, US | |
3217417 | 3217417 | 2022-10-12 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-13 04:22:39 | Haskell, Texas, US | |
3253266 | 3253266 | 2022-10-11 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-12 04:22:51 | Haskell, Texas, US | |
2970525 | 2970525 | 2022-10-10 | US | Texas | Haskell | 48207 | 1030 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-10-11 04:23:05 | Haskell, Texas, US | |
1624074 | 1624074 | 2022-09-22 | China | Chongqing | 1030 | 6 | 0 | 30.0572 | 107.874 | 2022-09-23 04:23:13 | Chongqing, China | |||
254234 | 254234 | 2022-09-08 | US | Idaho | Bear Lake | 16007 | 1030 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-09-09 04:21:11 | Bear Lake, Idaho, US | |
3746032 | 3746032 | 2022-09-07 | US | Idaho | Bear Lake | 16007 | 1030 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-09-08 04:21:02 | Bear Lake, Idaho, US | |
2990594 | 2990594 | 2022-09-04 | US | Virginia | Bath | 51017 | 1030 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-05 04:21:01 | Bath, Virginia, US | |
2716279 | 2716279 | 2022-09-03 | US | Virginia | Bath | 51017 | 1030 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-04 04:21:22 | Bath, Virginia, US | |
1396984 | 1396984 | 2022-09-02 | US | Virginia | Bath | 51017 | 1030 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-03 04:21:04 | Bath, Virginia, US | |
2346733 | 2346733 | 2022-08-31 | US | Virginia | Bath | 51017 | 1030 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-01 04:21:03 | Bath, Virginia, US | |
2595071 | 2595071 | 2022-07-25 | US | Illinois | Pope | 17151 | 1030 | 9 | 0 | 37.41391284 | -88.56152109 | 2022-07-26 04:20:58 | Pope, Illinois, US | |
961297 | 961297 | 2022-07-19 | US | North Dakota | Foster | 38031 | 1030 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-07-20 04:20:59 | Foster, North Dakota, US | |
632282 | 632282 | 2022-07-12 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-13 04:20:58 | Tyrrell, North Carolina, US | |
1213926 | 1213926 | 2022-07-11 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-12 04:20:51 | Tyrrell, North Carolina, US | |
2791408 | 2791408 | 2022-07-10 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-11 04:20:46 | Tyrrell, North Carolina, US | |
144361 | 144361 | 2022-07-09 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-10 04:20:54 | Tyrrell, North Carolina, US | |
1419461 | 1419461 | 2022-07-08 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-09 04:20:59 | Tyrrell, North Carolina, US | |
2743386 | 2743386 | 2022-07-07 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-08 04:20:56 | Tyrrell, North Carolina, US | |
1202181 | 1202181 | 2022-07-06 | US | North Carolina | Tyrrell | 37177 | 1030 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-07-07 04:20:55 | Tyrrell, North Carolina, US | |
2492426 | 2492426 | 2022-06-29 | US | North Dakota | LaMoure | 38045 | 1030 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-06-30 04:21:01 | LaMoure, North Dakota, US | |
2241808 | 2241808 | 2022-06-28 | US | North Dakota | LaMoure | 38045 | 1030 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-06-29 04:20:59 | LaMoure, North Dakota, US | |
2150050 | 2150050 | 2022-06-27 | US | North Dakota | LaMoure | 38045 | 1030 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-06-28 04:20:58 | LaMoure, North Dakota, US | |
2235947 | 2235947 | 2022-06-12 | US | California | Modoc | 6049 | 1030 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-06-13 04:21:14 | Modoc, California, US | |
3142145 | 3142145 | 2022-06-11 | US | California | Modoc | 6049 | 1030 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-06-12 04:20:53 | Modoc, California, US | |
1945061 | 1945061 | 2022-06-10 | US | California | Modoc | 6049 | 1030 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-06-11 04:21:01 | Modoc, California, US | |
3158200 | 3158200 | 2022-06-09 | US | California | Modoc | 6049 | 1030 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-06-10 04:20:55 | Modoc, California, US | |
622502 | 622502 | 2022-05-22 | US | Colorado | Gilpin | 8047 | 1030 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-05-26 04:20:50 | Gilpin, Colorado, US | |
224421 | 224421 | 2022-05-09 | US | North Dakota | Sargent | 38081 | 1030 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-05-10 04:20:50 | Sargent, North Dakota, US | |
2032169 | 2032169 | 2022-04-24 | US | Virginia | Rappahannock | 51157 | 1030 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-04-25 04:20:56 | Rappahannock, Virginia, US | |
749744 | 749744 | 2022-04-23 | US | Virginia | Rappahannock | 51157 | 1030 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-04-24 04:20:56 | Rappahannock, Virginia, US | |
3440229 | 3440229 | 2022-04-22 | US | Virginia | Rappahannock | 51157 | 1030 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-04-23 04:20:50 | Rappahannock, Virginia, US | |
3419675 | 3419675 | 2022-04-17 | US | Puerto Rico | Las Marias | 72083 | 1030 | 0 | 0 | 18.23679 | -66.98362 | 2022-04-18 04:21:12 | Las Marias, Puerto Rico, US | |
1720283 | 1720283 | 2022-03-25 | China | Jiangxi | 1030 | 1 | 0 | 27.614 | 115.7221 | 2022-03-26 04:20:23 | Jiangxi, China | |||
3631282 | 3631282 | 2022-03-13 | US | Virginia | Covington | 51580 | 1030 | 25 | 0 | 37.7824656 | -79.98631446 | 2022-03-14 04:20:46 | Covington, Virginia, US | |
954190 | 954190 | 2022-03-12 | US | Virginia | Covington | 51580 | 1030 | 25 | 0 | 37.7824656 | -79.98631446 | 2022-03-13 04:20:49 | Covington, Virginia, US | |
359651 | 359651 | 2022-03-11 | US | Virginia | Covington | 51580 | 1030 | 25 | 0 | 37.7824656 | -79.98631446 | 2022-03-12 04:20:50 | Covington, Virginia, US | |
1993073 | 1993073 | 2022-03-01 | US | Alaska | Aleutians East | 2013 | 1030 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-03-02 04:21:07 | Aleutians East, Alaska, US | |
943247 | 943247 | 2022-02-28 | US | Alaska | Aleutians East | 2013 | 1030 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-03-01 04:21:09 | Aleutians East, Alaska, US | |
2449638 | 2449638 | 2022-02-22 | US | South Dakota | Deuel | 46039 | 1030 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-02-23 04:21:09 | Deuel, South Dakota, US | |
2446561 | 2446561 | 2022-02-22 | China | Guangxi | 1030 | 2 | 0 | 23.8298 | 108.7881 | 2022-02-23 04:21:09 | Guangxi, China | |||
3673695 | 3673695 | 2022-02-15 | US | Nebraska | Antelope | 31003 | 1030 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2022-02-16 04:21:10 | Antelope, Nebraska, US | |
3673672 | 3673672 | 2022-02-15 | US | Montana | Phillips | 30071 | 1030 | 28 | 0 | 48.25936577 | -107.9128511 | 2022-02-16 04:21:10 | Phillips, Montana, US | |
2644786 | 2644786 | 2022-02-14 | US | Texas | Brewster | 48043 | 1030 | 25 | 0 | 29.81008251 | -103.25203259999999 | 2022-02-15 04:21:09 | Brewster, Texas, US | |
2643796 | 2643796 | 2022-02-14 | US | Nebraska | Antelope | 31003 | 1030 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2022-02-15 04:21:09 | Antelope, Nebraska, US | |
2643664 | 2643664 | 2022-02-14 | US | Missouri | Holt | 29087 | 1030 | 25 | 0 | 40.09799248 | -95.21638879999999 | 2022-02-15 04:21:09 | Holt, Missouri, US | |
188772 | 188772 | 2022-02-13 | US | Pennsylvania | Sullivan | 42113 | 1030 | 33 | 0 | 41.44634738 | -76.51246591 | 2022-02-14 04:20:51 | Sullivan, Pennsylvania, US | |
315801 | 315801 | 2022-02-12 | France | Saint Pierre and Miquelon | 1030 | 1 | 0 | 46.8852 | -56.3159 | 2022-02-13 04:21:00 | Saint Pierre and Miquelon, France | |||
1467542 | 1467542 | 2022-02-10 | US | Washington | San Juan | 53055 | 1030 | 1 | 0 | 48.60182783 | -122.96745 | 2022-02-11 04:21:09 | San Juan, Washington, US | |
1466127 | 1466127 | 2022-02-10 | US | Nebraska | Antelope | 31003 | 1030 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2022-02-11 04:21:09 | Antelope, Nebraska, US | |
3077503 | 3077503 | 2022-02-09 | US | Washington | San Juan | 53055 | 1030 | 1 | 0 | 48.60182783 | -122.96745 | 2022-02-10 04:21:14 | San Juan, Washington, US | |
3061809 | 3061809 | 2022-01-29 | China | Tianjin | 1030 | 3 | 0 | 39.3054 | 117.323 | 2022-01-30 04:21:26 | Tianjin, China | |||
1143000 | 1143000 | 2022-01-23 | US | Nebraska | Howard | 31093 | 1030 | 10 | 0 | 41.2200529 | -98.5166499 | 2022-01-24 04:21:12 | Howard, Nebraska, US | |
2834918 | 2834918 | 2022-01-22 | US | Nebraska | Howard | 31093 | 1030 | 10 | 0 | 41.2200529 | -98.5166499 | 2022-01-23 04:21:13 | Howard, Nebraska, US | |
3427036 | 3427036 | 2022-01-21 | US | Nebraska | Howard | 31093 | 1030 | 10 | 0 | 41.2200529 | -98.5166499 | 2022-01-22 04:21:13 | Howard, Nebraska, US | |
1287901 | 1287901 | 2022-01-04 | US | Missouri | Dade | 29057 | 1030 | 38 | 0 | 37.431814 | -93.8503345 | 2022-01-05 04:21:59 | Dade, Missouri, US | |
1703234 | 1703234 | 2022-01-03 | US | South Dakota | Kingsbury | 46077 | 1030 | 20 | 0 | 44.36956169 | -97.4913945 | 2022-01-04 04:22:17 | Kingsbury, South Dakota, US | |
1701399 | 1701399 | 2022-01-03 | US | Illinois | Stark | 17175 | 1030 | 30 | 0 | 41.09309773 | -89.79745866 | 2022-01-04 04:22:17 | Stark, Illinois, US | |
3519788 | 3519788 | 2022-01-02 | US | Alabama | Choctaw | 1023 | 1030 | 30 | 0 | 32.02227341 | -88.26564429999998 | 2022-01-03 02:22:25 | Choctaw, Alabama, US | |
733662 | 733662 | 2021-12-27 | US | Texas | Jim Hogg | 48247 | 1030 | 20 | 0 | 27.04453923 | -98.69681870000001 | 2021-12-28 04:21:47 | Jim Hogg, Texas, US | |
2114834 | 2114834 | 2021-12-26 | US | Texas | Jim Hogg | 48247 | 1030 | 20 | 0 | 27.04453923 | -98.69681870000001 | 2021-12-27 04:21:58 | Jim Hogg, Texas, US | |
3817289 | 3817289 | 2021-12-23 | US | Georgia | Randolph | 13243 | 1030 | 44 | 0 | 31.76622818 | -84.75732369 | 2021-12-24 04:21:34 | Randolph, Georgia, US | |
1661758 | 1661758 | 2021-12-12 | US | Kansas | Phillips | 20147 | 1030 | 28 | 0 | 39.78465501 | -99.34668865 | 2021-12-13 04:22:02 | Phillips, Kansas, US | |
1665774 | 1665774 | 2021-12-11 | US | Kansas | Phillips | 20147 | 1030 | 28 | 0 | 39.78465501 | -99.34668865 | 2021-12-12 04:22:12 | Phillips, Kansas, US | |
3656926 | 3656926 | 2021-12-10 | US | Kansas | Phillips | 20147 | 1030 | 28 | 0 | 39.78465501 | -99.34668865 | 2021-12-11 04:22:45 | Phillips, Kansas, US | |
3097 | 3097 | 2021-12-02 | US | Puerto Rico | Orocovis | 72107 | 1030 | 0 | 0 | 18.215046 | -66.433604 | 2021-12-03 04:23:05 | Orocovis, Puerto Rico, US | |
1147696 | 1147696 | 2021-12-01 | US | Puerto Rico | Orocovis | 72107 | 1030 | 0 | 0 | 18.215046 | -66.433604 | 2021-12-02 04:22:37 | Orocovis, Puerto Rico, US | |
3404208 | 3404208 | 2021-11-30 | US | Puerto Rico | Orocovis | 72107 | 1030 | 0 | 0 | 18.215046 | -66.433604 | 2021-12-01 04:22:29 | Orocovis, Puerto Rico, US | |
152751 | 152751 | 2021-11-29 | US | Puerto Rico | Orocovis | 72107 | 1030 | 0 | 0 | 18.215046 | -66.433604 | 2021-11-30 04:22:53 | Orocovis, Puerto Rico, US | |
1234397 | 1234397 | 2021-11-28 | US | Puerto Rico | Orocovis | 72107 | 1030 | 0 | 0 | 18.215046 | -66.433604 | 2021-11-29 04:22:30 | Orocovis, 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]);