johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
737 rows where confirmed = 529 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753808 | 2753808 | 2022-12-29 | US | Georgia | Webster | 13307 | 529 | 10 | 0 | 32.04066113 | -84.54742852 | 2022-12-30 04:21:04 | Webster, Georgia, US | |
1074814 | 1074814 | 2022-12-28 | US | Georgia | Webster | 13307 | 529 | 10 | 0 | 32.04066113 | -84.54742852 | 2022-12-29 04:21:01 | Webster, Georgia, US | |
1628110 | 1628110 | 2022-12-18 | China | Qinghai | 529 | 0 | 0 | 35.7452 | 95.9956 | 2022-12-19 04:21:03 | Qinghai, China | |||
3462148 | 3462148 | 2022-11-21 | US | Missouri | Worth | 29227 | 529 | 4 | 0 | 40.47945588 | -94.42328751 | 2022-11-22 04:20:47 | Worth, Missouri, US | |
1642333 | 1642333 | 2022-11-20 | US | Missouri | Worth | 29227 | 529 | 4 | 0 | 40.47945588 | -94.42328751 | 2022-11-21 04:21:05 | Worth, Missouri, US | |
2065890 | 2065890 | 2022-11-19 | US | Missouri | Worth | 29227 | 529 | 4 | 0 | 40.47945588 | -94.42328751 | 2022-11-20 04:21:08 | Worth, Missouri, US | |
1757284 | 1757284 | 2022-11-18 | US | Missouri | Worth | 29227 | 529 | 4 | 0 | 40.47945588 | -94.42328751 | 2022-11-19 04:21:14 | Worth, Missouri, US | |
3028277 | 3028277 | 2022-11-17 | US | Missouri | Worth | 29227 | 529 | 4 | 0 | 40.47945588 | -94.42328751 | 2022-11-18 04:21:15 | Worth, Missouri, US | |
2487988 | 2487988 | 2022-11-16 | US | Missouri | Worth | 29227 | 529 | 4 | 0 | 40.47945588 | -94.42328751 | 2022-11-17 04:21:11 | Worth, Missouri, US | |
293999 | 293999 | 2022-11-15 | US | Missouri | Worth | 29227 | 529 | 4 | 0 | 40.47945588 | -94.42328751 | 2022-11-16 04:21:09 | Worth, Missouri, US | |
3287307 | 3287307 | 2022-10-31 | US | North Dakota | Grant | 38037 | 529 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-11-01 04:22:36 | Grant, North Dakota, US | |
322340 | 322340 | 2022-10-30 | US | North Dakota | Grant | 38037 | 529 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-10-31 04:21:36 | Grant, North Dakota, US | |
914616 | 914616 | 2022-10-29 | US | North Dakota | Grant | 38037 | 529 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-10-30 04:22:14 | Grant, North Dakota, US | |
1368885 | 1368885 | 2022-10-28 | US | North Dakota | Grant | 38037 | 529 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-10-29 04:21:13 | Grant, North Dakota, US | |
2757851 | 2757851 | 2022-10-18 | US | Idaho | Butte | 16023 | 529 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-10-19 04:22:26 | Butte, Idaho, US | |
2025685 | 2025685 | 2022-10-17 | US | Idaho | Butte | 16023 | 529 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-10-18 04:22:42 | Butte, Idaho, US | |
2160463 | 2160463 | 2022-10-16 | US | Idaho | Butte | 16023 | 529 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-10-17 04:20:31 | Butte, Idaho, US | |
516660 | 516660 | 2022-10-15 | US | Idaho | Butte | 16023 | 529 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-10-16 04:22:39 | Butte, Idaho, US | |
2033717 | 2033717 | 2022-10-14 | US | Idaho | Butte | 16023 | 529 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-10-15 04:22:00 | Butte, Idaho, US | |
2019793 | 2019793 | 2022-09-20 | US | Texas | Culberson | 48109 | 529 | 14 | 0 | 31.44506775 | -104.5185739 | 2022-09-21 04:23:22 | Culberson, Texas, US | |
3573666 | 3573666 | 2022-09-19 | US | Texas | Culberson | 48109 | 529 | 14 | 0 | 31.44506775 | -104.5185739 | 2022-09-20 04:22:48 | Culberson, Texas, US | |
419997 | 419997 | 2022-09-18 | US | Colorado | Sedgwick | 8115 | 529 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-09-19 04:21:49 | Sedgwick, Colorado, US | |
3374021 | 3374021 | 2022-09-17 | US | Colorado | Sedgwick | 8115 | 529 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-09-18 04:22:50 | Sedgwick, Colorado, US | |
2356129 | 2356129 | 2022-09-16 | US | Colorado | Sedgwick | 8115 | 529 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-09-17 04:20:19 | Sedgwick, Colorado, US | |
255711 | 255711 | 2022-09-08 | US | North Dakota | Divide | 38023 | 529 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-09-09 04:21:11 | Divide, North Dakota, US | |
632803 | 632803 | 2022-07-12 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-07-13 04:20:58 | Mellette, South Dakota, US | |
1214447 | 1214447 | 2022-07-11 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-07-12 04:20:51 | Mellette, South Dakota, US | |
2791929 | 2791929 | 2022-07-10 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-07-11 04:20:46 | Mellette, South Dakota, US | |
144882 | 144882 | 2022-07-09 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-07-10 04:20:54 | Mellette, South Dakota, US | |
1419982 | 1419982 | 2022-07-08 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-07-09 04:20:59 | Mellette, South Dakota, US | |
2744162 | 2744162 | 2022-07-07 | US | Texas | Knox | 48275 | 529 | 26 | 0 | 33.60519951 | -99.7422906 | 2022-07-08 04:20:56 | Knox, Texas, US | |
2743907 | 2743907 | 2022-07-07 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-07-08 04:20:56 | Mellette, South Dakota, US | |
1202957 | 1202957 | 2022-07-06 | US | Texas | Knox | 48275 | 529 | 26 | 0 | 33.60519951 | -99.7422906 | 2022-07-07 04:20:55 | Knox, Texas, US | |
1202702 | 1202702 | 2022-07-06 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-07-07 04:20:55 | Mellette, South Dakota, US | |
3969700 | 3969700 | 2022-07-05 | US | Texas | Knox | 48275 | 529 | 26 | 0 | 33.60519951 | -99.7422906 | 2022-07-06 04:20:58 | Knox, Texas, US | |
3969445 | 3969445 | 2022-07-05 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-07-06 04:20:58 | Mellette, South Dakota, US | |
3080956 | 3080956 | 2022-07-04 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-07-05 04:20:45 | Mellette, South Dakota, US | |
1770238 | 1770238 | 2022-07-03 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-07-04 04:20:54 | Mellette, South Dakota, US | |
3368224 | 3368224 | 2022-07-02 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-07-03 04:20:59 | Mellette, South Dakota, US | |
596553 | 596553 | 2022-07-01 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-07-02 04:21:16 | Mellette, South Dakota, US | |
3942954 | 3942954 | 2022-06-30 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-07-01 04:21:10 | Mellette, South Dakota, US | |
2492912 | 2492912 | 2022-06-29 | US | South Dakota | Mellette | 46095 | 529 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-06-30 04:21:01 | Mellette, South Dakota, US | |
1650786 | 1650786 | 2022-06-23 | US | North Dakota | Kidder | 38043 | 529 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-06-24 04:20:58 | Kidder, North Dakota, US | |
3159746 | 3159746 | 2022-06-09 | US | Nebraska | Perkins | 31135 | 529 | 12 | 0 | 40.85082525 | -101.6502942 | 2022-06-10 04:20:55 | Perkins, Nebraska, US | |
1423213 | 1423213 | 2022-06-08 | US | Nebraska | Perkins | 31135 | 529 | 12 | 0 | 40.85082525 | -101.6502942 | 2022-06-09 04:20:54 | Perkins, Nebraska, US | |
3728327 | 3728327 | 2022-06-07 | US | Nebraska | Perkins | 31135 | 529 | 12 | 0 | 40.85082525 | -101.6502942 | 2022-06-08 04:20:55 | Perkins, Nebraska, US | |
3889729 | 3889729 | 2022-06-06 | US | Nebraska | Perkins | 31135 | 529 | 12 | 0 | 40.85082525 | -101.6502942 | 2022-06-07 04:21:08 | Perkins, Nebraska, US | |
3509498 | 3509498 | 2022-06-05 | US | Nebraska | Perkins | 31135 | 529 | 12 | 0 | 40.85082525 | -101.6502942 | 2022-06-06 04:20:57 | Perkins, Nebraska, US | |
3529575 | 3529575 | 2022-06-04 | US | Nebraska | Perkins | 31135 | 529 | 12 | 0 | 40.85082525 | -101.6502942 | 2022-06-05 04:20:55 | Perkins, Nebraska, US | |
1172417 | 1172417 | 2022-05-20 | US | Texas | Schleicher | 48413 | 529 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-05-21 04:20:58 | Schleicher, Texas, US | |
3899180 | 3899180 | 2022-05-19 | US | Texas | Schleicher | 48413 | 529 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-05-20 04:20:57 | Schleicher, Texas, US | |
1187964 | 1187964 | 2022-05-18 | US | Texas | Schleicher | 48413 | 529 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-05-19 04:20:54 | Schleicher, Texas, US | |
1572913 | 1572913 | 2022-05-03 | US | Georgia | Clay | 13061 | 529 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-05-04 04:20:59 | Clay, Georgia, US | |
464173 | 464173 | 2022-05-02 | US | Georgia | Clay | 13061 | 529 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-05-03 04:21:00 | Clay, Georgia, US | |
3916812 | 3916812 | 2022-05-01 | US | Georgia | Clay | 13061 | 529 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-05-02 04:21:10 | Clay, Georgia, US | |
2841616 | 2841616 | 2022-04-30 | US | Georgia | Clay | 13061 | 529 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-05-01 04:20:57 | Clay, Georgia, US | |
1157929 | 1157929 | 2022-04-29 | US | Georgia | Clay | 13061 | 529 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-04-30 04:21:05 | Clay, Georgia, US | |
1697269 | 1697269 | 2022-04-28 | US | Idaho | Custer | 16037 | 529 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-04-29 04:20:59 | Custer, Idaho, US | |
1697111 | 1697111 | 2022-04-28 | US | Georgia | Clay | 13061 | 529 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-04-29 04:20:59 | Clay, Georgia, US | |
3852752 | 3852752 | 2022-04-27 | US | Idaho | Custer | 16037 | 529 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-04-28 04:20:47 | Custer, Idaho, US | |
3852594 | 3852594 | 2022-04-27 | US | Georgia | Clay | 13061 | 529 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-04-28 04:20:47 | Clay, Georgia, US | |
2895175 | 2895175 | 2022-04-21 | US | Puerto Rico | Maricao | 72093 | 529 | 0 | 0 | 18.171795 | -66.942126 | 2022-04-22 04:20:45 | Maricao, Puerto Rico, US | |
3323706 | 3323706 | 2022-04-07 | US | Washington | Wahkiakum | 53069 | 529 | 6 | 0 | 46.29180039999999 | -123.4250831 | 2022-04-08 04:20:48 | Wahkiakum, Washington, US | |
2804242 | 2804242 | 2022-04-06 | US | Washington | Wahkiakum | 53069 | 529 | 6 | 0 | 46.29180039999999 | -123.4250831 | 2022-04-07 04:20:53 | Wahkiakum, Washington, US | |
3871011 | 3871011 | 2022-04-05 | US | Washington | Wahkiakum | 53069 | 529 | 6 | 0 | 46.29180039999999 | -123.4250831 | 2022-04-06 04:20:49 | Wahkiakum, Washington, US | |
2752353 | 2752353 | 2022-04-04 | US | Washington | Wahkiakum | 53069 | 529 | 6 | 0 | 46.29180039999999 | -123.4250831 | 2022-04-05 04:20:48 | Wahkiakum, Washington, US | |
3733699 | 3733699 | 2022-04-03 | US | Washington | Wahkiakum | 53069 | 529 | 6 | 0 | 46.29180039999999 | -123.4250831 | 2022-04-04 04:20:51 | Wahkiakum, Washington, US | |
503134 | 503134 | 2022-04-02 | US | Washington | Wahkiakum | 53069 | 529 | 6 | 0 | 46.29180039999999 | -123.4250831 | 2022-04-03 04:20:48 | Wahkiakum, Washington, US | |
3354119 | 3354119 | 2022-04-01 | US | Washington | Wahkiakum | 53069 | 529 | 6 | 0 | 46.29180039999999 | -123.4250831 | 2022-04-02 04:20:47 | Wahkiakum, Washington, US | |
1543424 | 1543424 | 2022-03-31 | US | Washington | Wahkiakum | 53069 | 529 | 6 | 0 | 46.29180039999999 | -123.4250831 | 2022-04-01 04:20:28 | Wahkiakum, Washington, US | |
2481437 | 2481437 | 2022-03-30 | US | Washington | Wahkiakum | 53069 | 529 | 6 | 0 | 46.29180039999999 | -123.4250831 | 2022-03-31 04:20:56 | Wahkiakum, Washington, US | |
2321336 | 2321336 | 2022-03-16 | US | Montana | Granite | 30039 | 529 | 8 | 0 | 46.40605220000001 | -113.4414186 | 2022-03-17 04:20:56 | Granite, Montana, US | |
263536 | 263536 | 2022-03-15 | US | Montana | Granite | 30039 | 529 | 8 | 0 | 46.40605220000001 | -113.4414186 | 2022-03-16 04:20:50 | Granite, Montana, US | |
2265895 | 2265895 | 2022-03-14 | US | Montana | Granite | 30039 | 529 | 8 | 0 | 46.40605220000001 | -113.4414186 | 2022-03-15 04:20:47 | Granite, Montana, US | |
3630066 | 3630066 | 2022-03-13 | US | Nebraska | Perkins | 31135 | 529 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-03-14 04:20:46 | Perkins, Nebraska, US | |
3629961 | 3629961 | 2022-03-13 | US | Montana | Granite | 30039 | 529 | 8 | 0 | 46.40605220000001 | -113.4414186 | 2022-03-14 04:20:46 | Granite, Montana, US | |
952974 | 952974 | 2022-03-12 | US | Nebraska | Perkins | 31135 | 529 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-03-13 04:20:49 | Perkins, Nebraska, US | |
952869 | 952869 | 2022-03-12 | US | Montana | Granite | 30039 | 529 | 8 | 0 | 46.40605220000001 | -113.4414186 | 2022-03-13 04:20:49 | Granite, Montana, US | |
358435 | 358435 | 2022-03-11 | US | Nebraska | Perkins | 31135 | 529 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-03-12 04:20:50 | Perkins, Nebraska, US | |
358330 | 358330 | 2022-03-11 | US | Montana | Granite | 30039 | 529 | 8 | 0 | 46.40605220000001 | -113.4414186 | 2022-03-12 04:20:50 | Granite, Montana, US | |
1867482 | 1867482 | 2022-03-10 | US | Montana | Granite | 30039 | 529 | 8 | 0 | 46.40605220000001 | -113.4414186 | 2022-03-11 04:20:50 | Granite, Montana, US | |
2142177 | 2142177 | 2022-03-09 | US | Montana | Granite | 30039 | 529 | 8 | 0 | 46.40605220000001 | -113.4414186 | 2022-03-10 04:20:48 | Granite, Montana, US | |
1994768 | 1994768 | 2022-03-01 | US | Nebraska | Perkins | 31135 | 529 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-03-02 04:21:07 | Perkins, Nebraska, US | |
944942 | 944942 | 2022-02-28 | US | Nebraska | Perkins | 31135 | 529 | 11 | 0 | 40.85082525 | -101.6502942 | 2022-03-01 04:21:09 | Perkins, Nebraska, US | |
3672403 | 3672403 | 2022-02-15 | US | Georgia | Baker | 13007 | 529 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-02-16 04:21:10 | Baker, Georgia, US | |
2642504 | 2642504 | 2022-02-14 | US | Georgia | Baker | 13007 | 529 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-02-15 04:21:09 | Baker, Georgia, US | |
186821 | 186821 | 2022-02-13 | US | Georgia | Baker | 13007 | 529 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-02-14 04:20:51 | Baker, Georgia, US | |
316667 | 316667 | 2022-02-12 | US | Georgia | Baker | 13007 | 529 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-02-13 04:21:00 | Baker, Georgia, US | |
233993 | 233993 | 2022-02-11 | US | Georgia | Baker | 13007 | 529 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-02-12 04:21:06 | Baker, Georgia, US | |
1464835 | 1464835 | 2022-02-10 | US | Georgia | Baker | 13007 | 529 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-02-11 04:21:09 | Baker, Georgia, US | |
3074796 | 3074796 | 2022-02-09 | US | Georgia | Baker | 13007 | 529 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-02-10 04:21:14 | Baker, Georgia, US | |
461802 | 461802 | 2022-02-02 | US | North Dakota | Renville | 38075 | 529 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-02-03 04:21:21 | Renville, North Dakota, US | |
3303083 | 3303083 | 2022-01-30 | US | South Dakota | Hand | 46059 | 529 | 8 | 0 | 44.54708407 | -99.00386459 | 2022-01-31 04:21:09 | Hand, South Dakota, US | |
3064874 | 3064874 | 2022-01-29 | US | South Dakota | Hand | 46059 | 529 | 8 | 0 | 44.54708407 | -99.00386459 | 2022-01-30 04:21:26 | Hand, South Dakota, US | |
3812808 | 3812808 | 2022-01-28 | US | South Dakota | Hand | 46059 | 529 | 8 | 0 | 44.54708407 | -99.00386459 | 2022-01-29 04:21:10 | Hand, South Dakota, US | |
1144525 | 1144525 | 2022-01-23 | US | Wyoming | Niobrara | 56027 | 529 | 8 | 0 | 43.05607708 | -104.47588959999999 | 2022-01-24 04:21:12 | Niobrara, Wyoming, US | |
1141721 | 1141721 | 2022-01-23 | US | Georgia | Glascock | 13125 | 529 | 22 | 0 | 33.22879932 | -82.61297636 | 2022-01-24 04:21:12 | Glascock, Georgia, US | |
2836443 | 2836443 | 2022-01-22 | US | Wyoming | Niobrara | 56027 | 529 | 8 | 0 | 43.05607708 | -104.47588959999999 | 2022-01-23 04:21:13 | Niobrara, Wyoming, US | |
2833639 | 2833639 | 2022-01-22 | US | Georgia | Glascock | 13125 | 529 | 22 | 0 | 33.22879932 | -82.61297636 | 2022-01-23 04:21:13 | Glascock, Georgia, US | |
3428561 | 3428561 | 2022-01-21 | US | Wyoming | Niobrara | 56027 | 529 | 8 | 0 | 43.05607708 | -104.47588959999999 | 2022-01-22 04:21:13 | Niobrara, Wyoming, 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]);