johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
450 rows where confirmed = 2117 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
309231 | 309231 | 2022-12-13 | US | Kansas | Russell | 20167 | 2117 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-12-14 04:21:04 | Russell, Kansas, US | |
1150292 | 1150292 | 2022-12-12 | US | Kansas | Russell | 20167 | 2117 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-12-13 04:21:01 | Russell, Kansas, US | |
870146 | 870146 | 2022-12-11 | US | Kansas | Russell | 20167 | 2117 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-12-12 04:21:01 | Russell, Kansas, US | |
258676 | 258676 | 2022-12-10 | US | Kansas | Russell | 20167 | 2117 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-12-11 04:20:50 | Russell, Kansas, US | |
3937390 | 3937390 | 2022-12-09 | US | Kansas | Russell | 20167 | 2117 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-12-10 04:21:02 | Russell, Kansas, US | |
3378722 | 3378722 | 2022-12-08 | US | Kansas | Russell | 20167 | 2117 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-12-09 04:21:05 | Russell, Kansas, US | |
1985993 | 1985993 | 2022-12-07 | US | Kansas | Russell | 20167 | 2117 | 42 | 0 | 38.91462787 | -98.76254297 | 2022-12-08 04:21:07 | Russell, Kansas, US | |
480418 | 480418 | 2022-11-08 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-09 04:21:22 | Irwin, Georgia, US | |
2439568 | 2439568 | 2022-11-07 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-08 04:21:21 | Irwin, Georgia, US | |
1050666 | 1050666 | 2022-11-06 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-07 04:21:26 | Irwin, Georgia, US | |
618690 | 618690 | 2022-11-05 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-06 04:21:24 | Irwin, Georgia, US | |
1023194 | 1023194 | 2022-11-04 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-05 04:21:52 | Irwin, Georgia, US | |
432185 | 432185 | 2022-11-03 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-04 04:22:11 | Irwin, Georgia, US | |
850427 | 850427 | 2022-11-02 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-03 04:22:05 | Irwin, Georgia, US | |
711278 | 711278 | 2022-11-01 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-02 04:22:09 | Irwin, Georgia, US | |
3285727 | 3285727 | 2022-10-31 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-01 04:22:36 | Irwin, Georgia, US | |
320760 | 320760 | 2022-10-30 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-10-31 04:21:36 | Irwin, Georgia, US | |
913036 | 913036 | 2022-10-29 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-10-30 04:22:14 | Irwin, Georgia, US | |
1367305 | 1367305 | 2022-10-28 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-10-29 04:21:13 | Irwin, Georgia, US | |
3039160 | 3039160 | 2022-10-27 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-10-28 04:22:31 | Irwin, Georgia, US | |
539580 | 539580 | 2022-10-26 | US | Georgia | Irwin | 13155 | 2117 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-10-27 04:22:01 | Irwin, Georgia, US | |
3253352 | 3253352 | 2022-10-11 | US | Texas | Rains | 48379 | 2117 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-10-12 04:22:51 | Rains, Texas, US | |
2970611 | 2970611 | 2022-10-10 | US | Texas | Rains | 48379 | 2117 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-10-11 04:23:05 | Rains, Texas, US | |
133757 | 133757 | 2022-10-04 | US | Tennessee | Van Buren | 47175 | 2117 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-10-05 04:23:06 | Van Buren, Tennessee, US | |
2688704 | 2688704 | 2022-10-03 | US | Tennessee | Van Buren | 47175 | 2117 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-10-04 04:22:55 | Van Buren, Tennessee, US | |
2262771 | 2262771 | 2022-10-02 | US | Tennessee | Van Buren | 47175 | 2117 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-10-03 04:23:11 | Van Buren, Tennessee, US | |
2998297 | 2998297 | 2022-10-01 | US | Tennessee | Van Buren | 47175 | 2117 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-10-02 04:21:23 | Van Buren, Tennessee, US | |
856623 | 856623 | 2022-09-30 | US | Tennessee | Van Buren | 47175 | 2117 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-10-01 04:23:01 | Van Buren, Tennessee, US | |
2378549 | 2378549 | 2022-09-29 | US | Tennessee | Van Buren | 47175 | 2117 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-09-30 04:23:09 | Van Buren, Tennessee, US | |
1563100 | 1563100 | 2022-09-28 | US | Tennessee | Van Buren | 47175 | 2117 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-09-29 04:22:34 | Van Buren, Tennessee, US | |
1560729 | 1560729 | 2022-09-28 | US | Colorado | Lake | 8065 | 2117 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-09-29 04:22:34 | Lake, Colorado, US | |
1373811 | 1373811 | 2022-09-21 | US | Virginia | Buena Vista | 51530 | 2117 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-09-22 04:22:56 | Buena Vista, Virginia, US | |
2325916 | 2325916 | 2022-08-24 | US | Oklahoma | Kiowa | 40075 | 2117 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-25 04:21:13 | Kiowa, Oklahoma, US | |
1253325 | 1253325 | 2022-08-23 | US | Oklahoma | Kiowa | 40075 | 2117 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-24 04:20:46 | Kiowa, Oklahoma, US | |
2855429 | 2855429 | 2022-08-22 | US | Oklahoma | Kiowa | 40075 | 2117 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-23 04:20:56 | Kiowa, Oklahoma, US | |
2405401 | 2405401 | 2022-08-21 | US | Oklahoma | Kiowa | 40075 | 2117 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-22 04:20:38 | Kiowa, Oklahoma, US | |
3800479 | 3800479 | 2022-08-20 | US | Oklahoma | Kiowa | 40075 | 2117 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-21 04:20:44 | Kiowa, Oklahoma, US | |
2366065 | 2366065 | 2022-08-19 | US | Oklahoma | Kiowa | 40075 | 2117 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-20 04:21:01 | Kiowa, Oklahoma, US | |
1163736 | 1163736 | 2022-08-18 | US | Oklahoma | Kiowa | 40075 | 2117 | 55 | 0 | 34.91671958 | -98.97720696 | 2022-08-19 04:20:54 | Kiowa, Oklahoma, US | |
3911113 | 3911113 | 2022-08-11 | US | Texas | Hansford | 48195 | 2117 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-08-12 04:20:54 | Hansford, Texas, US | |
3910016 | 3910016 | 2022-08-11 | US | Montana | Madison | 30057 | 2117 | 23 | 0 | 45.30080065 | -111.9173017 | 2022-08-12 04:20:54 | Madison, Montana, US | |
1349409 | 1349409 | 2022-08-10 | US | Texas | Floyd | 48153 | 2117 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-08-11 04:20:49 | Floyd, Texas, US | |
1348333 | 1348333 | 2022-08-10 | US | Montana | Madison | 30057 | 2117 | 23 | 0 | 45.30080065 | -111.9173017 | 2022-08-11 04:20:49 | Madison, Montana, US | |
1088088 | 1088088 | 2022-08-09 | US | Montana | Madison | 30057 | 2117 | 23 | 0 | 45.30080065 | -111.9173017 | 2022-08-10 04:20:57 | Madison, Montana, US | |
3545503 | 3545503 | 2022-08-08 | US | Montana | Madison | 30057 | 2117 | 23 | 0 | 45.30080065 | -111.9173017 | 2022-08-09 04:20:34 | Madison, Montana, US | |
1071906 | 1071906 | 2022-08-07 | US | Montana | Madison | 30057 | 2117 | 23 | 0 | 45.30080065 | -111.9173017 | 2022-08-08 04:21:08 | Madison, Montana, US | |
1942494 | 1942494 | 2022-08-06 | US | Montana | Madison | 30057 | 2117 | 23 | 0 | 45.30080065 | -111.9173017 | 2022-08-07 04:20:54 | Madison, Montana, US | |
882293 | 882293 | 2022-08-05 | US | Montana | Madison | 30057 | 2117 | 23 | 0 | 45.30080065 | -111.9173017 | 2022-08-06 04:20:56 | Madison, Montana, US | |
1406191 | 1406191 | 2022-08-02 | US | Indiana | Union | 18161 | 2117 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-08-03 04:20:59 | Union, Indiana, US | |
3618229 | 3618229 | 2022-08-01 | US | Indiana | Union | 18161 | 2117 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-08-02 04:20:53 | Union, Indiana, US | |
960128 | 960128 | 2022-07-19 | US | Iowa | Palo Alto | 19147 | 2117 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-07-20 04:20:59 | Palo Alto, Iowa, US | |
3211515 | 3211515 | 2022-07-18 | US | Iowa | Palo Alto | 19147 | 2117 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-07-19 04:20:58 | Palo Alto, Iowa, US | |
3406690 | 3406690 | 2022-07-17 | US | Iowa | Palo Alto | 19147 | 2117 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-07-18 04:20:59 | Palo Alto, Iowa, US | |
2152890 | 2152890 | 2022-07-16 | US | Iowa | Palo Alto | 19147 | 2117 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-07-17 04:21:15 | Palo Alto, Iowa, US | |
2420123 | 2420123 | 2022-07-15 | US | Iowa | Palo Alto | 19147 | 2117 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-07-16 04:21:05 | Palo Alto, Iowa, US | |
3430198 | 3430198 | 2022-07-14 | US | Iowa | Palo Alto | 19147 | 2117 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-07-15 04:20:53 | Palo Alto, Iowa, US | |
3110718 | 3110718 | 2022-07-13 | US | Iowa | Palo Alto | 19147 | 2117 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-07-14 04:20:57 | Palo Alto, Iowa, US | |
631112 | 631112 | 2022-07-12 | US | Iowa | Howard | 19089 | 2117 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-07-13 04:20:58 | Howard, Iowa, US | |
1212756 | 1212756 | 2022-07-11 | US | Iowa | Howard | 19089 | 2117 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-07-12 04:20:51 | Howard, Iowa, US | |
2790238 | 2790238 | 2022-07-10 | US | Iowa | Howard | 19089 | 2117 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-07-11 04:20:46 | Howard, Iowa, US | |
143191 | 143191 | 2022-07-09 | US | Iowa | Howard | 19089 | 2117 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-07-10 04:20:54 | Howard, Iowa, US | |
1418291 | 1418291 | 2022-07-08 | US | Iowa | Howard | 19089 | 2117 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-07-09 04:20:59 | Howard, Iowa, US | |
2742216 | 2742216 | 2022-07-07 | US | Iowa | Howard | 19089 | 2117 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-07-08 04:20:56 | Howard, Iowa, US | |
1201011 | 1201011 | 2022-07-06 | US | Iowa | Howard | 19089 | 2117 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-07-07 04:20:55 | Howard, Iowa, US | |
2150956 | 2150956 | 2022-06-27 | US | Virginia | Buena Vista | 51530 | 2117 | 44 | 0 | 37.73484642 | -79.35296097 | 2022-06-28 04:20:58 | Buena Vista, Virginia, US | |
169552 | 169552 | 2022-06-21 | US | West Virginia | Pleasants | 54073 | 2117 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-06-22 04:20:54 | Pleasants, West Virginia, US | |
3159604 | 3159604 | 2022-06-09 | US | Missouri | St. Clair | 29185 | 2117 | 36 | 0 | 38.03699437 | -93.77631447 | 2022-06-10 04:20:55 | St. Clair, Missouri, US | |
1423071 | 1423071 | 2022-06-08 | US | Missouri | St. Clair | 29185 | 2117 | 36 | 0 | 38.03699437 | -93.77631447 | 2022-06-09 04:20:54 | St. Clair, Missouri, US | |
3728185 | 3728185 | 2022-06-07 | US | Missouri | St. Clair | 29185 | 2117 | 36 | 0 | 38.03699437 | -93.77631447 | 2022-06-08 04:20:55 | St. Clair, Missouri, US | |
3889587 | 3889587 | 2022-06-06 | US | Missouri | St. Clair | 29185 | 2117 | 36 | 0 | 38.03699437 | -93.77631447 | 2022-06-07 04:21:08 | St. Clair, Missouri, US | |
3509356 | 3509356 | 2022-06-05 | US | Missouri | St. Clair | 29185 | 2117 | 36 | 0 | 38.03699437 | -93.77631447 | 2022-06-06 04:20:57 | St. Clair, Missouri, US | |
3529433 | 3529433 | 2022-06-04 | US | Missouri | St. Clair | 29185 | 2117 | 36 | 0 | 38.03699437 | -93.77631447 | 2022-06-05 04:20:55 | St. Clair, Missouri, US | |
3135519 | 3135519 | 2022-06-03 | US | Missouri | St. Clair | 29185 | 2117 | 36 | 0 | 38.03699437 | -93.77631447 | 2022-06-04 04:20:58 | St. Clair, Missouri, US | |
3582108 | 3582108 | 2022-06-02 | US | West Virginia | Gilmer | 54021 | 2117 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-06-03 04:20:58 | Gilmer, West Virginia, US | |
3187520 | 3187520 | 2022-05-30 | US | Louisiana | Red River | 22081 | 2117 | 53 | 0 | 32.09530039 | -93.34213308 | 2022-05-31 04:20:51 | Red River, Louisiana, US | |
3199669 | 3199669 | 2022-05-29 | US | Louisiana | Red River | 22081 | 2117 | 53 | 0 | 32.09530039 | -93.34213308 | 2022-05-30 04:20:50 | Red River, Louisiana, US | |
2726547 | 2726547 | 2022-05-28 | US | Louisiana | Red River | 22081 | 2117 | 53 | 0 | 32.09530039 | -93.34213308 | 2022-05-29 04:20:53 | Red River, Louisiana, US | |
1315728 | 1315728 | 2022-05-27 | US | Louisiana | Red River | 22081 | 2117 | 53 | 0 | 32.09530039 | -93.34213308 | 2022-05-28 04:21:07 | Red River, Louisiana, US | |
3000458 | 3000458 | 2022-05-24 | US | Indiana | Warren | 18171 | 2117 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-05-25 04:20:56 | Warren, Indiana, US | |
3000233 | 3000233 | 2022-05-24 | US | Idaho | Boundary | 16021 | 2117 | 62 | 0 | 48.76684761 | -116.4630179 | 2022-05-25 04:20:56 | Boundary, Idaho, US | |
3594179 | 3594179 | 2022-05-23 | US | Indiana | Warren | 18171 | 2117 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-05-24 04:20:57 | Warren, Indiana, US | |
3593954 | 3593954 | 2022-05-23 | US | Idaho | Boundary | 16021 | 2117 | 62 | 0 | 48.76684761 | -116.4630179 | 2022-05-24 04:20:57 | Boundary, Idaho, US | |
3899186 | 3899186 | 2022-05-19 | US | Texas | Somervell | 48425 | 2117 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-20 04:20:57 | Somervell, Texas, US | |
1187970 | 1187970 | 2022-05-18 | US | Texas | Somervell | 48425 | 2117 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-19 04:20:54 | Somervell, Texas, US | |
3585867 | 3585867 | 2022-05-17 | US | Texas | Somervell | 48425 | 2117 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-18 04:20:50 | Somervell, Texas, US | |
1506824 | 1506824 | 2022-05-16 | US | Texas | Somervell | 48425 | 2117 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-17 04:20:59 | Somervell, Texas, US | |
2087183 | 2087183 | 2022-05-15 | US | Texas | Somervell | 48425 | 2117 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-16 04:20:47 | Somervell, Texas, US | |
1574884 | 1574884 | 2022-05-03 | US | Puerto Rico | Hormigueros | 72067 | 2117 | 0 | 0 | 18.134532 | -67.113972 | 2022-05-04 04:20:59 | Hormigueros, Puerto Rico, US | |
466144 | 466144 | 2022-05-02 | US | Puerto Rico | Hormigueros | 72067 | 2117 | 0 | 0 | 18.134532 | -67.113972 | 2022-05-03 04:21:00 | Hormigueros, Puerto Rico, US | |
2843560 | 2843560 | 2022-04-30 | US | Puerto Rico | Arroyo | 72015 | 2117 | 0 | 0 | 17.998457 | -66.056546 | 2022-05-01 04:20:57 | Arroyo, Puerto Rico, US | |
1696149 | 1696149 | 2022-04-28 | China | Yunnan | 2117 | 2 | 0 | 24.974 | 101.487 | 2022-04-29 04:20:59 | Yunnan, China | |||
1327026 | 1327026 | 2022-04-26 | US | Georgia | Clinch | 13065 | 2117 | 42 | 0 | 30.91395822 | -82.70432472 | 2022-04-27 04:20:52 | Clinch, Georgia, US | |
3722980 | 3722980 | 2022-04-25 | US | Georgia | Clinch | 13065 | 2117 | 42 | 0 | 30.91395822 | -82.70432472 | 2022-04-26 04:20:51 | Clinch, Georgia, US | |
2029548 | 2029548 | 2022-04-24 | US | Georgia | Clinch | 13065 | 2117 | 42 | 0 | 30.91395822 | -82.70432472 | 2022-04-25 04:20:56 | Clinch, Georgia, US | |
747123 | 747123 | 2022-04-23 | US | Georgia | Clinch | 13065 | 2117 | 42 | 0 | 30.91395822 | -82.70432472 | 2022-04-24 04:20:56 | Clinch, Georgia, US | |
3437608 | 3437608 | 2022-04-22 | US | Georgia | Clinch | 13065 | 2117 | 42 | 0 | 30.91395822 | -82.70432472 | 2022-04-23 04:20:50 | Clinch, Georgia, US | |
2893193 | 2893193 | 2022-04-21 | US | Georgia | Clinch | 13065 | 2117 | 42 | 0 | 30.91395822 | -82.70432472 | 2022-04-22 04:20:45 | Clinch, Georgia, US | |
2308065 | 2308065 | 2022-04-20 | US | Georgia | Clinch | 13065 | 2117 | 42 | 0 | 30.91395822 | -82.70432472 | 2022-04-21 04:20:46 | Clinch, Georgia, US | |
1224930 | 1224930 | 2022-04-14 | US | Kansas | Pawnee | 20145 | 2117 | 24 | 0 | 38.18108732 | -99.23692334 | 2022-04-13 23:21:06 | Pawnee, Kansas, US | |
2444088 | 2444088 | 2022-04-13 | US | Kansas | Pawnee | 20145 | 2117 | 24 | 0 | 38.18108732 | -99.23692334 | 2022-04-13 23:21:06 | Pawnee, Kansas, 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]);