johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
307 rows where confirmed = 2552 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3175676 | 3175676 | 2022-12-19 | US | Missouri | Carroll | 29033 | 2552 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-12-20 04:21:04 | Carroll, Missouri, US | |
1630193 | 1630193 | 2022-12-18 | US | Missouri | Carroll | 29033 | 2552 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-12-19 04:21:03 | Carroll, Missouri, US | |
505572 | 505572 | 2022-12-17 | US | Missouri | Carroll | 29033 | 2552 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-12-18 04:21:03 | Carroll, Missouri, US | |
3326144 | 3326144 | 2022-12-16 | US | Missouri | Carroll | 29033 | 2552 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-12-17 04:21:04 | Carroll, Missouri, US | |
544656 | 544656 | 2022-12-15 | US | Missouri | Carroll | 29033 | 2552 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-12-16 04:21:01 | Carroll, Missouri, US | |
350184 | 350184 | 2022-12-14 | US | Missouri | Carroll | 29033 | 2552 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-12-15 04:20:58 | Carroll, Missouri, US | |
309772 | 309772 | 2022-12-13 | US | Missouri | Carroll | 29033 | 2552 | 46 | 0 | 39.42762566 | -93.50626255 | 2022-12-14 04:21:04 | Carroll, Missouri, US | |
721852 | 721852 | 2022-12-04 | US | Virginia | Lexington | 51678 | 2552 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-12-05 04:20:58 | Lexington, Virginia, US | |
2820141 | 2820141 | 2022-12-03 | US | Virginia | Lexington | 51678 | 2552 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-12-04 04:20:56 | Lexington, Virginia, US | |
836997 | 836997 | 2022-12-02 | US | Virginia | Lexington | 51678 | 2552 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-12-03 04:21:02 | Lexington, Virginia, US | |
482824 | 482824 | 2022-11-08 | US | Texas | Swisher | 48437 | 2552 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-11-09 04:21:22 | Swisher, Texas, US | |
2441974 | 2441974 | 2022-11-07 | US | Texas | Swisher | 48437 | 2552 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-11-08 04:21:21 | Swisher, Texas, US | |
3041486 | 3041486 | 2022-10-27 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-28 04:22:31 | La Salle, Texas, US | |
541906 | 541906 | 2022-10-26 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-27 04:22:01 | La Salle, Texas, US | |
1833307 | 1833307 | 2022-10-25 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-26 04:22:19 | La Salle, Texas, US | |
797568 | 797568 | 2022-10-24 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-25 04:21:53 | La Salle, Texas, US | |
3280023 | 3280023 | 2022-10-23 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-24 04:22:29 | La Salle, Texas, US | |
2271061 | 2271061 | 2022-10-22 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-23 04:22:46 | La Salle, Texas, US | |
1595361 | 1595361 | 2022-10-21 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-22 04:22:53 | La Salle, Texas, US | |
2275077 | 2275077 | 2022-10-20 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-21 04:22:23 | La Salle, Texas, US | |
201412 | 201412 | 2022-10-19 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-20 04:22:59 | La Salle, Texas, US | |
2760073 | 2760073 | 2022-10-18 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-19 04:22:26 | La Salle, Texas, US | |
2027907 | 2027907 | 2022-10-17 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-18 04:22:42 | La Salle, Texas, US | |
2162685 | 2162685 | 2022-10-16 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-17 04:20:31 | La Salle, Texas, US | |
518882 | 518882 | 2022-10-15 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-16 04:22:39 | La Salle, Texas, US | |
2035939 | 2035939 | 2022-10-14 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-15 04:22:00 | La Salle, Texas, US | |
3756627 | 3756627 | 2022-10-13 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-14 04:22:28 | La Salle, Texas, US | |
3217452 | 3217452 | 2022-10-12 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-13 04:22:39 | La Salle, Texas, US | |
3253301 | 3253301 | 2022-10-11 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-12 04:22:51 | La Salle, Texas, US | |
3251112 | 3251112 | 2022-10-11 | US | Idaho | Washington | 16087 | 2552 | 58 | 0 | 44.45275475 | -116.7847688 | 2022-10-12 04:22:51 | Washington, Idaho, US | |
2970560 | 2970560 | 2022-10-10 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-11 04:23:05 | La Salle, Texas, US | |
2968371 | 2968371 | 2022-10-10 | US | Idaho | Washington | 16087 | 2552 | 58 | 0 | 44.45275475 | -116.7847688 | 2022-10-11 04:23:05 | Washington, Idaho, US | |
3100596 | 3100596 | 2022-10-09 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-10 04:22:32 | La Salle, Texas, US | |
3098407 | 3098407 | 2022-10-09 | US | Idaho | Washington | 16087 | 2552 | 58 | 0 | 44.45275475 | -116.7847688 | 2022-10-10 04:22:32 | Washington, Idaho, US | |
4005821 | 4005821 | 2022-10-08 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-09 04:21:16 | La Salle, Texas, US | |
4003632 | 4003632 | 2022-10-08 | US | Idaho | Washington | 16087 | 2552 | 58 | 0 | 44.45275475 | -116.7847688 | 2022-10-09 04:21:16 | Washington, Idaho, US | |
399418 | 399418 | 2022-10-07 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-08 04:22:56 | La Salle, Texas, US | |
397229 | 397229 | 2022-10-07 | US | Idaho | Washington | 16087 | 2552 | 58 | 0 | 44.45275475 | -116.7847688 | 2022-10-08 04:22:56 | Washington, Idaho, US | |
2532535 | 2532535 | 2022-10-06 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-07 04:23:08 | La Salle, Texas, US | |
1813929 | 1813929 | 2022-10-05 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-06 04:21:22 | La Salle, Texas, US | |
133903 | 133903 | 2022-10-04 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-05 04:23:06 | La Salle, Texas, US | |
131943 | 131943 | 2022-10-04 | US | Iowa | Emmet | 19063 | 2552 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-10-05 04:23:06 | Emmet, Iowa, US | |
2688850 | 2688850 | 2022-10-03 | US | Texas | La Salle | 48283 | 2552 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-10-04 04:22:55 | La Salle, Texas, US | |
2686890 | 2686890 | 2022-10-03 | US | Iowa | Emmet | 19063 | 2552 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-10-04 04:22:55 | Emmet, Iowa, US | |
2260957 | 2260957 | 2022-10-02 | US | Iowa | Emmet | 19063 | 2552 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-10-03 04:23:11 | Emmet, Iowa, US | |
2996483 | 2996483 | 2022-10-01 | US | Iowa | Emmet | 19063 | 2552 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-10-02 04:21:23 | Emmet, Iowa, US | |
854809 | 854809 | 2022-09-30 | US | Iowa | Emmet | 19063 | 2552 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-10-01 04:23:01 | Emmet, Iowa, US | |
2376735 | 2376735 | 2022-09-29 | US | Iowa | Emmet | 19063 | 2552 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-09-30 04:23:09 | Emmet, Iowa, US | |
2376020 | 2376020 | 2022-09-29 | US | Arkansas | Cleveland | 5025 | 2552 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-09-30 04:23:09 | Cleveland, Arkansas, US | |
1561286 | 1561286 | 2022-09-28 | US | Iowa | Emmet | 19063 | 2552 | 55 | 0 | 43.37782951 | -94.67858943 | 2022-09-29 04:22:34 | Emmet, Iowa, US | |
3998091 | 3998091 | 2022-09-27 | US | Washington | Lincoln | 53043 | 2552 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-09-28 04:23:01 | Lincoln, Washington, US | |
2772419 | 2772419 | 2022-09-26 | US | Washington | Lincoln | 53043 | 2552 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-09-27 04:23:01 | Lincoln, Washington, US | |
384739 | 384739 | 2022-09-23 | US | Arkansas | Nevada | 5099 | 2552 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-09-24 04:21:40 | Nevada, Arkansas, US | |
1624805 | 1624805 | 2022-09-22 | US | Arkansas | Nevada | 5099 | 2552 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-09-23 04:23:13 | Nevada, Arkansas, US | |
422680 | 422680 | 2022-09-18 | US | Virginia | Franklin City | 51620 | 2552 | 54 | 0 | 36.6831435 | -76.93859681 | 2022-09-19 04:21:49 | Franklin City, Virginia, US | |
3376704 | 3376704 | 2022-09-17 | US | Virginia | Franklin City | 51620 | 2552 | 54 | 0 | 36.6831435 | -76.93859681 | 2022-09-18 04:22:50 | Franklin City, Virginia, US | |
2358812 | 2358812 | 2022-09-16 | US | Virginia | Franklin City | 51620 | 2552 | 54 | 0 | 36.6831435 | -76.93859681 | 2022-09-17 04:20:19 | Franklin City, Virginia, US | |
2397780 | 2397780 | 2022-09-12 | US | Tennessee | Moore | 47127 | 2552 | 40 | 0 | 35.27724699 | -86.36230578 | 2022-09-13 04:20:57 | Moore, Tennessee, US | |
3550553 | 3550553 | 2022-09-01 | US | Texas | Castro | 48069 | 2552 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-09-02 04:21:07 | Castro, Texas, US | |
2326827 | 2326827 | 2022-08-24 | US | West Virginia | Clay | 54015 | 2552 | 48 | 0 | 38.46231092 | -81.07652217 | 2022-08-25 04:21:13 | Clay, West Virginia, US | |
2496796 | 2496796 | 2022-08-15 | US | Puerto Rico | Maunabo | 72095 | 2552 | 0 | 0 | 18.017889 | -65.922235 | 2022-08-16 04:20:58 | Maunabo, Puerto Rico, US | |
478956 | 478956 | 2022-06-26 | US | West Virginia | Ritchie | 54085 | 2552 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-06-27 04:21:00 | Ritchie, West Virginia, US | |
942331 | 942331 | 2022-06-25 | US | West Virginia | Ritchie | 54085 | 2552 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-06-26 04:21:02 | Ritchie, West Virginia, US | |
3350151 | 3350151 | 2022-06-24 | US | West Virginia | Ritchie | 54085 | 2552 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-06-25 04:20:57 | Ritchie, West Virginia, US | |
230886 | 230886 | 2022-05-31 | US | Michigan | Mackinac | 26097 | 2552 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-06-01 04:20:55 | Mackinac, Michigan, US | |
3187651 | 3187651 | 2022-05-30 | US | Michigan | Mackinac | 26097 | 2552 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-05-31 04:20:51 | Mackinac, Michigan, US | |
3199800 | 3199800 | 2022-05-29 | US | Michigan | Mackinac | 26097 | 2552 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-05-30 04:20:50 | Mackinac, Michigan, US | |
2726678 | 2726678 | 2022-05-28 | US | Michigan | Mackinac | 26097 | 2552 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-05-29 04:20:53 | Mackinac, Michigan, US | |
1315859 | 1315859 | 2022-05-27 | US | Michigan | Mackinac | 26097 | 2552 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-05-28 04:21:07 | Mackinac, Michigan, US | |
1851651 | 1851651 | 2022-05-26 | US | Michigan | Mackinac | 26097 | 2552 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-05-27 04:20:56 | Mackinac, Michigan, US | |
2049527 | 2049527 | 2022-05-25 | US | Michigan | Mackinac | 26097 | 2552 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-05-26 04:20:50 | Mackinac, Michigan, US | |
623538 | 623538 | 2022-05-22 | US | Michigan | Mackinac | 26097 | 2552 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-05-26 04:20:50 | Mackinac, Michigan, US | |
2599832 | 2599832 | 2022-05-05 | US | Minnesota | Yellow Medicine | 27173 | 2552 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-05-06 04:21:00 | Yellow Medicine, Minnesota, US | |
3268841 | 3268841 | 2022-05-04 | US | Virginia | Galax | 51640 | 2552 | 78 | 0 | 36.66601852 | -80.91703124 | 2022-05-05 04:20:55 | Galax, Virginia, US | |
3268524 | 3268524 | 2022-05-04 | US | Texas | Blanco | 48031 | 2552 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-05-05 04:20:55 | Blanco, Texas, US | |
466775 | 466775 | 2022-05-02 | US | Virginia | Nelson | 51125 | 2552 | 35 | 0 | 37.78790447 | -78.88498513 | 2022-05-03 04:21:00 | Nelson, Virginia, US | |
1697412 | 1697412 | 2022-04-28 | US | Indiana | Crawford | 18025 | 2552 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-04-29 04:20:59 | Crawford, Indiana, US | |
3853743 | 3853743 | 2022-04-27 | US | Missouri | Linn | 29115 | 2552 | 64 | 0 | 39.87001769 | -93.10704106 | 2022-04-28 04:20:47 | Linn, Missouri, US | |
3852895 | 3852895 | 2022-04-27 | US | Indiana | Crawford | 18025 | 2552 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-04-28 04:20:47 | Crawford, Indiana, US | |
1328173 | 1328173 | 2022-04-26 | US | Missouri | Linn | 29115 | 2552 | 64 | 0 | 39.87001769 | -93.10704106 | 2022-04-27 04:20:52 | Linn, Missouri, US | |
1327325 | 1327325 | 2022-04-26 | US | Indiana | Crawford | 18025 | 2552 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-04-27 04:20:52 | Crawford, Indiana, US | |
3724127 | 3724127 | 2022-04-25 | US | Missouri | Linn | 29115 | 2552 | 64 | 0 | 39.87001769 | -93.10704106 | 2022-04-26 04:20:51 | Linn, Missouri, US | |
3723279 | 3723279 | 2022-04-25 | US | Indiana | Crawford | 18025 | 2552 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-04-26 04:20:51 | Crawford, Indiana, US | |
2032113 | 2032113 | 2022-04-24 | US | Virginia | Galax | 51640 | 2552 | 77 | 0 | 36.66601852 | -80.91703124 | 2022-04-25 04:20:56 | Galax, Virginia, US | |
2030695 | 2030695 | 2022-04-24 | US | Missouri | Linn | 29115 | 2552 | 64 | 0 | 39.87001769 | -93.10704106 | 2022-04-25 04:20:56 | Linn, Missouri, US | |
749688 | 749688 | 2022-04-23 | US | Virginia | Galax | 51640 | 2552 | 77 | 0 | 36.66601852 | -80.91703124 | 2022-04-24 04:20:56 | Galax, Virginia, US | |
748270 | 748270 | 2022-04-23 | US | Missouri | Linn | 29115 | 2552 | 64 | 0 | 39.87001769 | -93.10704106 | 2022-04-24 04:20:56 | Linn, Missouri, US | |
3440173 | 3440173 | 2022-04-22 | US | Virginia | Galax | 51640 | 2552 | 77 | 0 | 36.66601852 | -80.91703124 | 2022-04-23 04:20:50 | Galax, Virginia, US | |
3438755 | 3438755 | 2022-04-22 | US | Missouri | Linn | 29115 | 2552 | 64 | 0 | 39.87001769 | -93.10704106 | 2022-04-23 04:20:50 | Linn, Missouri, US | |
2895758 | 2895758 | 2022-04-21 | US | Virginia | Galax | 51640 | 2552 | 77 | 0 | 36.66601852 | -80.91703124 | 2022-04-22 04:20:45 | Galax, Virginia, US | |
2894340 | 2894340 | 2022-04-21 | US | Missouri | Linn | 29115 | 2552 | 64 | 0 | 39.87001769 | -93.10704106 | 2022-04-22 04:20:45 | Linn, Missouri, US | |
2310630 | 2310630 | 2022-04-20 | US | Virginia | Galax | 51640 | 2552 | 77 | 0 | 36.66601852 | -80.91703124 | 2022-04-21 04:20:46 | Galax, Virginia, US | |
2254769 | 2254769 | 2022-04-19 | US | Virginia | Galax | 51640 | 2552 | 77 | 0 | 36.66601852 | -80.91703124 | 2022-04-20 04:20:45 | Galax, Virginia, US | |
2252621 | 2252621 | 2022-04-19 | US | Iowa | Grundy | 19075 | 2552 | 42 | 0 | 42.40183723 | -92.78829551 | 2022-04-20 04:20:45 | Grundy, Iowa, US | |
1847171 | 1847171 | 2022-04-18 | US | Iowa | Grundy | 19075 | 2552 | 42 | 0 | 42.40183723 | -92.78829551 | 2022-04-19 04:21:00 | Grundy, Iowa, US | |
3420257 | 3420257 | 2022-04-17 | US | Virginia | Floyd | 51063 | 2552 | 47 | 0 | 36.9302126 | -80.36738849 | 2022-04-18 04:21:12 | Floyd, Virginia, US | |
3418115 | 3418115 | 2022-04-17 | US | Iowa | Grundy | 19075 | 2552 | 42 | 0 | 42.40183723 | -92.78829551 | 2022-04-18 04:21:12 | Grundy, Iowa, US | |
307206 | 307206 | 2022-04-16 | US | Virginia | Floyd | 51063 | 2552 | 47 | 0 | 36.9302126 | -80.36738849 | 2022-04-17 04:20:59 | Floyd, Virginia, US | |
305064 | 305064 | 2022-04-16 | US | Iowa | Grundy | 19075 | 2552 | 42 | 0 | 42.40183723 | -92.78829551 | 2022-04-17 04:20:59 | Grundy, Iowa, US | |
2673151 | 2673151 | 2022-04-15 | US | Virginia | Floyd | 51063 | 2552 | 47 | 0 | 36.9302126 | -80.36738849 | 2022-04-16 04:20:48 | Floyd, Virginia, 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]);