johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
640 rows where confirmed = 554 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
719144 | 719144 | 2022-12-04 | US | Colorado | Sedgwick | 8115 | 554 | 12 | 0 | 40.87595412 | -102.3519227 | 2022-12-05 04:20:58 | Sedgwick, Colorado, US | |
2817433 | 2817433 | 2022-12-03 | US | Colorado | Sedgwick | 8115 | 554 | 12 | 0 | 40.87595412 | -102.3519227 | 2022-12-04 04:20:56 | Sedgwick, Colorado, US | |
834289 | 834289 | 2022-12-02 | US | Colorado | Sedgwick | 8115 | 554 | 12 | 0 | 40.87595412 | -102.3519227 | 2022-12-03 04:21:02 | Sedgwick, Colorado, US | |
2441141 | 2441141 | 2022-11-07 | US | North Dakota | Divide | 38023 | 554 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-11-08 04:21:21 | Divide, North Dakota, US | |
1052239 | 1052239 | 2022-11-06 | US | North Dakota | Divide | 38023 | 554 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-11-07 04:21:26 | Divide, North Dakota, US | |
620263 | 620263 | 2022-11-05 | US | North Dakota | Divide | 38023 | 554 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-11-06 04:21:24 | Divide, North Dakota, US | |
1024767 | 1024767 | 2022-11-04 | US | North Dakota | Divide | 38023 | 554 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-11-05 04:21:52 | Divide, North Dakota, US | |
433758 | 433758 | 2022-11-03 | US | North Dakota | Divide | 38023 | 554 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-11-04 04:22:11 | Divide, North Dakota, US | |
433375 | 433375 | 2022-11-03 | US | Montana | Meagher | 30059 | 554 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-11-04 04:22:11 | Meagher, Montana, US | |
852000 | 852000 | 2022-11-02 | US | North Dakota | Divide | 38023 | 554 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-11-03 04:22:05 | Divide, North Dakota, US | |
851617 | 851617 | 2022-11-02 | US | Montana | Meagher | 30059 | 554 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-11-03 04:22:05 | Meagher, Montana, US | |
712468 | 712468 | 2022-11-01 | US | Montana | Meagher | 30059 | 554 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-11-02 04:22:09 | Meagher, Montana, US | |
3286917 | 3286917 | 2022-10-31 | US | Montana | Meagher | 30059 | 554 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-11-01 04:22:36 | Meagher, Montana, US | |
321950 | 321950 | 2022-10-30 | US | Montana | Meagher | 30059 | 554 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-10-31 04:21:36 | Meagher, Montana, US | |
914226 | 914226 | 2022-10-29 | US | Montana | Meagher | 30059 | 554 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-10-30 04:22:14 | Meagher, Montana, US | |
1368495 | 1368495 | 2022-10-28 | US | Montana | Meagher | 30059 | 554 | 10 | 0 | 46.59907074 | -110.8898557 | 2022-10-29 04:21:13 | Meagher, Montana, US | |
255721 | 255721 | 2022-09-08 | US | North Dakota | Kidder | 38043 | 554 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-09-09 04:21:11 | Kidder, North Dakota, US | |
1253652 | 1253652 | 2022-08-23 | US | South Dakota | Mellette | 46095 | 554 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-08-24 04:20:46 | Mellette, South Dakota, US | |
2855756 | 2855756 | 2022-08-22 | US | South Dakota | Mellette | 46095 | 554 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-08-23 04:20:56 | Mellette, South Dakota, US | |
2405728 | 2405728 | 2022-08-21 | US | South Dakota | Mellette | 46095 | 554 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-08-22 04:20:38 | Mellette, South Dakota, US | |
3800806 | 3800806 | 2022-08-20 | US | South Dakota | Mellette | 46095 | 554 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-08-21 04:20:44 | Mellette, South Dakota, US | |
2366392 | 2366392 | 2022-08-19 | US | South Dakota | Mellette | 46095 | 554 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-08-20 04:21:01 | Mellette, South Dakota, US | |
1164063 | 1164063 | 2022-08-18 | US | South Dakota | Mellette | 46095 | 554 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-08-19 04:20:54 | Mellette, South Dakota, US | |
3953387 | 3953387 | 2022-08-17 | US | South Dakota | Mellette | 46095 | 554 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-08-18 04:21:11 | Mellette, South Dakota, US | |
1073112 | 1073112 | 2022-08-07 | US | Texas | Schleicher | 48413 | 554 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-08-08 04:21:08 | Schleicher, Texas, US | |
1943700 | 1943700 | 2022-08-06 | US | Texas | Schleicher | 48413 | 554 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-08-07 04:20:54 | Schleicher, Texas, US | |
883499 | 883499 | 2022-08-05 | US | Texas | Schleicher | 48413 | 554 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-08-06 04:20:56 | Schleicher, Texas, US | |
2011910 | 2011910 | 2022-08-04 | US | Texas | Schleicher | 48413 | 554 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-08-05 04:20:52 | Schleicher, Texas, US | |
1405821 | 1405821 | 2022-08-02 | US | Georgia | Clay | 13061 | 554 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-08-03 04:20:59 | Clay, Georgia, US | |
3617859 | 3617859 | 2022-08-01 | US | Georgia | Clay | 13061 | 554 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-08-02 04:20:53 | Clay, Georgia, US | |
3872339 | 3872339 | 2022-07-31 | US | Georgia | Clay | 13061 | 554 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-08-01 04:21:03 | Clay, Georgia, US | |
675093 | 675093 | 2022-07-30 | US | Georgia | Clay | 13061 | 554 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-07-31 04:21:02 | Clay, Georgia, US | |
1784292 | 1784292 | 2022-07-29 | US | Georgia | Clay | 13061 | 554 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-07-30 04:20:42 | Clay, Georgia, US | |
1066655 | 1066655 | 2022-07-28 | US | Georgia | Clay | 13061 | 554 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-07-29 04:20:45 | Clay, Georgia, US | |
2337955 | 2337955 | 2022-07-27 | US | Oklahoma | Harmon | 40057 | 554 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-07-28 04:20:56 | Harmon, Oklahoma, US | |
2336174 | 2336174 | 2022-07-27 | US | Georgia | Clay | 13061 | 554 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-07-28 04:20:56 | Clay, Georgia, US | |
1490145 | 1490145 | 2022-07-26 | US | Oklahoma | Harmon | 40057 | 554 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-07-27 04:21:04 | Harmon, Oklahoma, US | |
2596591 | 2596591 | 2022-07-25 | US | Oklahoma | Harmon | 40057 | 554 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-07-26 04:20:58 | Harmon, Oklahoma, US | |
898706 | 898706 | 2022-07-24 | US | Oklahoma | Harmon | 40057 | 554 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-07-25 04:20:51 | Harmon, Oklahoma, US | |
93700 | 93700 | 2022-07-23 | US | Oklahoma | Harmon | 40057 | 554 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-07-24 04:20:47 | Harmon, Oklahoma, US | |
902722 | 902722 | 2022-07-22 | US | Oklahoma | Harmon | 40057 | 554 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-07-23 04:20:53 | Harmon, Oklahoma, US | |
672858 | 672858 | 2022-07-21 | US | Oklahoma | Harmon | 40057 | 554 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-07-22 04:21:15 | Harmon, Oklahoma, US | |
3112661 | 3112661 | 2022-07-13 | US | Texas | Menard | 48327 | 554 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-07-14 04:20:57 | Menard, Texas, US | |
632054 | 632054 | 2022-07-12 | US | Nevada | Lincoln | 32017 | 554 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-07-13 04:20:58 | Lincoln, Nevada, US | |
1213698 | 1213698 | 2022-07-11 | US | Nevada | Lincoln | 32017 | 554 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-07-12 04:20:51 | Lincoln, Nevada, US | |
2791180 | 2791180 | 2022-07-10 | US | Nevada | Lincoln | 32017 | 554 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-07-11 04:20:46 | Lincoln, Nevada, US | |
144133 | 144133 | 2022-07-09 | US | Nevada | Lincoln | 32017 | 554 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-07-10 04:20:54 | Lincoln, Nevada, US | |
1419233 | 1419233 | 2022-07-08 | US | Nevada | Lincoln | 32017 | 554 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-07-09 04:20:59 | Lincoln, Nevada, US | |
2743158 | 2743158 | 2022-07-07 | US | Nevada | Lincoln | 32017 | 554 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-07-08 04:20:56 | Lincoln, Nevada, US | |
1201953 | 1201953 | 2022-07-06 | US | Nevada | Lincoln | 32017 | 554 | 8 | 0 | 37.64268459 | -114.8790388 | 2022-07-07 04:20:55 | Lincoln, Nevada, US | |
3967302 | 3967302 | 2022-07-05 | US | Georgia | Baker | 13007 | 554 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-07-06 04:20:58 | Baker, Georgia, US | |
3078813 | 3078813 | 2022-07-04 | US | Georgia | Baker | 13007 | 554 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-07-05 04:20:45 | Baker, Georgia, US | |
1768095 | 1768095 | 2022-07-03 | US | Georgia | Baker | 13007 | 554 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-07-04 04:20:54 | Baker, Georgia, US | |
3366081 | 3366081 | 2022-07-02 | US | Georgia | Baker | 13007 | 554 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-07-03 04:20:59 | Baker, Georgia, US | |
594410 | 594410 | 2022-07-01 | US | Georgia | Baker | 13007 | 554 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-07-02 04:21:16 | Baker, Georgia, US | |
3940811 | 3940811 | 2022-06-30 | US | Georgia | Baker | 13007 | 554 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-07-01 04:21:10 | Baker, Georgia, US | |
2490769 | 2490769 | 2022-06-29 | US | Georgia | Baker | 13007 | 554 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-06-30 04:21:01 | Baker, Georgia, US | |
478909 | 478909 | 2022-06-26 | US | Washington | Wahkiakum | 53069 | 554 | 7 | 0 | 46.2918004 | -123.4250831 | 2022-06-27 04:21:00 | Wahkiakum, Washington, US | |
942284 | 942284 | 2022-06-25 | US | Washington | Wahkiakum | 53069 | 554 | 7 | 0 | 46.2918004 | -123.4250831 | 2022-06-26 04:21:02 | Wahkiakum, Washington, US | |
3350104 | 3350104 | 2022-06-24 | US | Washington | Wahkiakum | 53069 | 554 | 7 | 0 | 46.2918004 | -123.4250831 | 2022-06-25 04:20:57 | Wahkiakum, Washington, US | |
3509446 | 3509446 | 2022-06-05 | US | Nebraska | Cherry | 31031 | 554 | 12 | 0 | 42.54502621 | -101.1244332 | 2022-06-06 04:20:57 | Cherry, Nebraska, US | |
3529523 | 3529523 | 2022-06-04 | US | Nebraska | Cherry | 31031 | 554 | 12 | 0 | 42.54502621 | -101.1244332 | 2022-06-05 04:20:55 | Cherry, Nebraska, US | |
3585066 | 3585066 | 2022-05-17 | US | North Dakota | Renville | 38075 | 554 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-05-18 04:20:50 | Renville, North Dakota, US | |
1506023 | 1506023 | 2022-05-16 | US | North Dakota | Renville | 38075 | 554 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-05-17 04:20:59 | Renville, North Dakota, US | |
2086382 | 2086382 | 2022-05-15 | US | North Dakota | Renville | 38075 | 554 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-05-16 04:20:47 | Renville, North Dakota, US | |
3357092 | 3357092 | 2022-05-14 | US | North Dakota | Renville | 38075 | 554 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-05-15 04:20:53 | Renville, North Dakota, US | |
660737 | 660737 | 2022-05-13 | US | North Dakota | Renville | 38075 | 554 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-05-14 04:20:48 | Renville, North Dakota, US | |
2535820 | 2535820 | 2022-05-12 | US | North Dakota | Renville | 38075 | 554 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-05-13 04:20:51 | Renville, North Dakota, US | |
3447266 | 3447266 | 2022-05-11 | US | North Dakota | Renville | 38075 | 554 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-05-12 04:20:54 | Renville, North Dakota, US | |
1950225 | 1950225 | 2022-04-12 | US | Minnesota | Cook | 27031 | 554 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-04-13 04:21:03 | Cook, Minnesota, US | |
3207978 | 3207978 | 2022-04-11 | US | Minnesota | Cook | 27031 | 554 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-04-12 04:20:49 | Cook, Minnesota, US | |
1577864 | 1577864 | 2022-04-10 | US | Minnesota | Cook | 27031 | 554 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-04-11 04:21:02 | Cook, Minnesota, US | |
1654106 | 1654106 | 2022-04-09 | US | Minnesota | Cook | 27031 | 554 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-04-10 04:20:52 | Cook, Minnesota, US | |
2117428 | 2117428 | 2022-04-08 | US | Minnesota | Cook | 27031 | 554 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-04-09 04:20:42 | Cook, Minnesota, US | |
3321952 | 3321952 | 2022-04-07 | US | Minnesota | Cook | 27031 | 554 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-04-08 04:20:48 | Cook, Minnesota, US | |
2802488 | 2802488 | 2022-04-06 | US | Minnesota | Cook | 27031 | 554 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-04-07 04:20:53 | Cook, Minnesota, US | |
3869257 | 3869257 | 2022-04-05 | US | Minnesota | Cook | 27031 | 554 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-04-06 04:20:49 | Cook, Minnesota, US | |
2750599 | 2750599 | 2022-04-04 | US | Minnesota | Cook | 27031 | 554 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-04-05 04:20:48 | Cook, Minnesota, US | |
3731945 | 3731945 | 2022-04-03 | US | Minnesota | Cook | 27031 | 554 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-04-04 04:20:51 | Cook, Minnesota, US | |
501380 | 501380 | 2022-04-02 | US | Minnesota | Cook | 27031 | 554 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-04-03 04:20:48 | Cook, Minnesota, US | |
3352365 | 3352365 | 2022-04-01 | US | Minnesota | Cook | 27031 | 554 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-04-02 04:20:47 | Cook, Minnesota, US | |
1541670 | 1541670 | 2022-03-31 | US | Minnesota | Cook | 27031 | 554 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-04-01 04:20:28 | Cook, Minnesota, US | |
697580 | 697580 | 2022-03-17 | US | Texas | Oldham | 48359 | 554 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-03-18 04:20:55 | Oldham, Texas, US | |
945704 | 945704 | 2022-02-28 | US | South Dakota | Faulk | 46049 | 554 | 16 | 0 | 45.07082625 | -99.14535601 | 2022-03-01 04:21:09 | Faulk, South Dakota, US | |
1299343 | 1299343 | 2022-02-17 | US | Kansas | Graham | 20065 | 554 | 13 | 0 | 39.34987223 | -99.88332493 | 2022-02-18 04:21:04 | Graham, Kansas, US | |
3821729 | 3821729 | 2022-02-16 | US | Kansas | Graham | 20065 | 554 | 13 | 0 | 39.34987223 | -99.88332493 | 2022-02-17 04:20:56 | Graham, Kansas, US | |
3076168 | 3076168 | 2022-02-09 | US | Nebraska | Sherman | 31163 | 554 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-02-10 04:21:14 | Sherman, Nebraska, US | |
3301673 | 3301673 | 2022-01-30 | US | Kentucky | Robertson | 21201 | 554 | 20 | 0 | 38.51923469 | -84.05055616 | 2022-01-31 04:21:09 | Robertson, Kentucky, US | |
3063464 | 3063464 | 2022-01-29 | US | Kentucky | Robertson | 21201 | 554 | 20 | 0 | 38.51923469 | -84.05055616 | 2022-01-30 04:21:26 | Robertson, Kentucky, US | |
3811398 | 3811398 | 2022-01-28 | US | Kentucky | Robertson | 21201 | 554 | 20 | 0 | 38.51923469 | -84.05055616 | 2022-01-29 04:21:10 | Robertson, Kentucky, US | |
1960970 | 1960970 | 2022-01-20 | US | Alaska | Aleutians East | 2013 | 554 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-01-21 04:21:09 | Aleutians East, Alaska, US | |
3226865 | 3226865 | 2022-01-19 | US | Alaska | Aleutians East | 2013 | 554 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-01-20 04:21:07 | Aleutians East, Alaska, US | |
1692930 | 1692930 | 2022-01-10 | US | Colorado | Custer | 8027 | 554 | 17 | 0 | 38.10883162 | -105.3683478 | 2022-01-11 04:22:01 | Custer, Colorado, US | |
2610482 | 2610482 | 2022-01-06 | US | Alaska | Petersburg | 2195 | 554 | 3 | 0 | 57.13978948 | -132.9540995 | 2022-01-07 04:22:09 | Petersburg, Alaska, US | |
1282424 | 1282424 | 2022-01-05 | US | Alaska | Petersburg | 2195 | 554 | 3 | 0 | 57.13978948 | -132.9540995 | 2022-01-06 04:22:09 | Petersburg, Alaska, US | |
1703508 | 1703508 | 2022-01-03 | US | Texas | Lipscomb | 48295 | 554 | 12 | 0 | 36.27783108 | -100.27331509999999 | 2022-01-04 04:22:17 | Lipscomb, Texas, US | |
2780161 | 2780161 | 2021-12-31 | US | Texas | Mason | 48319 | 554 | 8 | 0 | 30.71780434 | -99.22629416 | 2022-01-01 04:22:14 | Mason, Texas, US | |
2963200 | 2963200 | 2021-12-24 | China | Tianjin | 554 | 3 | 0 | 39.3054 | 117.323 | 2021-12-25 04:21:37 | Tianjin, China | |||
798218 | 798218 | 2021-12-22 | China | Guangxi | 554 | 2 | 0 | 23.8298 | 108.7881 | 2021-12-23 04:21:21 | Guangxi, China | |||
1256507 | 1256507 | 2021-12-20 | US | Minnesota | Lake of the Woods | 27077 | 554 | 5 | 0 | 48.77217001 | -94.90274472 | 2021-12-21 03:21:27 | Lake of the Woods, Minnesota, 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]);