johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
252 rows where confirmed = 3041 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754814 | 2754814 | 2022-12-29 | US | Missouri | Grundy | 29079 | 3041 | 72 | 0 | 40.11406587 | -93.56509276 | 2022-12-30 04:21:04 | Grundy, Missouri, US | |
1075820 | 1075820 | 2022-12-28 | US | Missouri | Grundy | 29079 | 3041 | 72 | 0 | 40.11406587 | -93.56509276 | 2022-12-29 04:21:01 | Grundy, Missouri, US | |
329817 | 329817 | 2022-12-27 | US | Missouri | Grundy | 29079 | 3041 | 72 | 0 | 40.11406587 | -93.56509276 | 2022-12-28 04:21:04 | Grundy, Missouri, US | |
295360 | 295360 | 2022-11-15 | US | Virginia | Galax | 51640 | 3041 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-16 04:21:09 | Galax, Virginia, US | |
2506713 | 2506713 | 2022-11-10 | US | Colorado | Prowers | 8099 | 3041 | 52 | 0 | 37.95544985 | -102.3926052 | 2022-11-11 04:21:22 | Prowers, Colorado, US | |
2758427 | 2758427 | 2022-10-18 | US | Louisiana | East Carroll | 22035 | 3041 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-10-19 04:22:26 | East Carroll, Louisiana, US | |
2026261 | 2026261 | 2022-10-17 | US | Louisiana | East Carroll | 22035 | 3041 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-10-18 04:22:42 | East Carroll, Louisiana, US | |
2161039 | 2161039 | 2022-10-16 | US | Louisiana | East Carroll | 22035 | 3041 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-10-17 04:20:31 | East Carroll, Louisiana, US | |
517236 | 517236 | 2022-10-15 | US | Louisiana | East Carroll | 22035 | 3041 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-10-16 04:22:39 | East Carroll, Louisiana, US | |
2034293 | 2034293 | 2022-10-14 | US | Louisiana | East Carroll | 22035 | 3041 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-10-15 04:22:00 | East Carroll, Louisiana, US | |
3216715 | 3216715 | 2022-10-12 | US | North Dakota | McLean | 38055 | 3041 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-10-13 04:22:39 | McLean, North Dakota, US | |
3100825 | 3100825 | 2022-10-09 | US | Virginia | Nelson | 51125 | 3041 | 37 | 0 | 37.78790447 | -78.88498513 | 2022-10-10 04:22:32 | Nelson, Virginia, US | |
4006050 | 4006050 | 2022-10-08 | US | Virginia | Nelson | 51125 | 3041 | 37 | 0 | 37.78790447 | -78.88498513 | 2022-10-09 04:21:16 | Nelson, Virginia, US | |
399647 | 399647 | 2022-10-07 | US | Virginia | Nelson | 51125 | 3041 | 37 | 0 | 37.78790447 | -78.88498513 | 2022-10-08 04:22:56 | Nelson, Virginia, US | |
131754 | 131754 | 2022-10-04 | US | Illinois | Jasper | 17079 | 3041 | 32 | 0 | 39.01054275 | -88.15437049 | 2022-10-05 04:23:06 | Jasper, Illinois, US | |
2686701 | 2686701 | 2022-10-03 | US | Illinois | Jasper | 17079 | 3041 | 32 | 0 | 39.01054275 | -88.15437049 | 2022-10-04 04:22:55 | Jasper, Illinois, US | |
1978066 | 1978066 | 2022-09-25 | US | Kentucky | McLean | 21149 | 3041 | 57 | 0 | 37.5301951 | -87.26803443 | 2022-09-26 04:20:52 | McLean, Kentucky, US | |
2651233 | 2651233 | 2022-09-24 | US | Kentucky | McLean | 21149 | 3041 | 57 | 0 | 37.5301951 | -87.26803443 | 2022-09-25 04:23:31 | McLean, Kentucky, US | |
385673 | 385673 | 2022-09-23 | US | Kentucky | McLean | 21149 | 3041 | 57 | 0 | 37.5301951 | -87.26803443 | 2022-09-24 04:21:40 | McLean, Kentucky, US | |
1625739 | 1625739 | 2022-09-22 | US | Kentucky | McLean | 21149 | 3041 | 57 | 0 | 37.5301951 | -87.26803443 | 2022-09-23 04:23:13 | McLean, Kentucky, US | |
1371943 | 1371943 | 2022-09-21 | US | Kentucky | McLean | 21149 | 3041 | 57 | 0 | 37.5301951 | -87.26803443 | 2022-09-22 04:22:56 | McLean, Kentucky, US | |
2020065 | 2020065 | 2022-09-20 | US | Virginia | Floyd | 51063 | 3041 | 50 | 0 | 36.9302126 | -80.36738849 | 2022-09-21 04:23:22 | Floyd, Virginia, US | |
2018173 | 2018173 | 2022-09-20 | US | Kentucky | McLean | 21149 | 3041 | 57 | 0 | 37.5301951 | -87.26803443 | 2022-09-21 04:23:22 | McLean, Kentucky, US | |
3572046 | 3572046 | 2022-09-19 | US | Kentucky | McLean | 21149 | 3041 | 57 | 0 | 37.5301951 | -87.26803443 | 2022-09-20 04:22:48 | McLean, Kentucky, US | |
2010243 | 2010243 | 2022-08-04 | US | Louisiana | West Feliciana | 22125 | 3041 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-08-05 04:20:52 | West Feliciana, Louisiana, US | |
896649 | 896649 | 2022-07-24 | US | Arkansas | Lee | 5077 | 3041 | 62 | 0 | 34.78498904 | -90.78383866 | 2022-07-25 04:20:51 | Lee, Arkansas, US | |
91643 | 91643 | 2022-07-23 | US | Arkansas | Lee | 5077 | 3041 | 62 | 0 | 34.78498904 | -90.78383866 | 2022-07-24 04:20:47 | Lee, Arkansas, US | |
3969592 | 3969592 | 2022-07-05 | US | Texas | Callahan | 48059 | 3041 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-07-06 04:20:58 | Callahan, Texas, US | |
477627 | 477627 | 2022-06-26 | US | New Jersey | Unassigned | 90034 | 3041 | 0 | 0 | 41.13891592 | 0.0 | 2022-06-27 04:21:00 | Unassigned, New Jersey, US | |
166816 | 166816 | 2022-06-21 | US | Georgia | Charlton | 13049 | 3041 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-06-22 04:20:54 | Charlton, Georgia, US | |
1764099 | 1764099 | 2022-06-20 | US | Georgia | Charlton | 13049 | 3041 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-06-21 04:20:56 | Charlton, Georgia, US | |
3270285 | 3270285 | 2022-06-19 | US | Georgia | Charlton | 13049 | 3041 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-06-20 04:21:01 | Charlton, Georgia, US | |
3398197 | 3398197 | 2022-06-18 | US | Georgia | Charlton | 13049 | 3041 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-06-19 04:20:51 | Charlton, Georgia, US | |
2312074 | 2312074 | 2022-06-17 | US | Georgia | Charlton | 13049 | 3041 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-06-18 04:21:10 | Charlton, Georgia, US | |
559578 | 559578 | 2022-06-16 | US | Georgia | Charlton | 13049 | 3041 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-06-17 04:20:56 | Charlton, Georgia, US | |
3983380 | 3983380 | 2022-06-15 | US | Georgia | Charlton | 13049 | 3041 | 62 | 0 | 30.78371028 | -82.13951596 | 2022-06-16 04:20:55 | Charlton, Georgia, US | |
2982006 | 2982006 | 2022-06-13 | US | Puerto Rico | Hormigueros | 72067 | 3041 | 0 | 0 | 18.134532 | -67.113972 | 2022-06-14 04:20:52 | Hormigueros, Puerto Rico, US | |
3728505 | 3728505 | 2022-06-07 | US | North Carolina | Alleghany | 37005 | 3041 | 16 | 0 | 36.49360862 | -81.12857041 | 2022-06-08 04:20:55 | Alleghany, North Carolina, US | |
3889907 | 3889907 | 2022-06-06 | US | North Carolina | Alleghany | 37005 | 3041 | 16 | 0 | 36.49360862 | -81.12857041 | 2022-06-07 04:21:08 | Alleghany, North Carolina, US | |
3509676 | 3509676 | 2022-06-05 | US | North Carolina | Alleghany | 37005 | 3041 | 16 | 0 | 36.49360862 | -81.12857041 | 2022-06-06 04:20:57 | Alleghany, North Carolina, US | |
3507872 | 3507872 | 2022-06-05 | US | Arkansas | Desha | 5041 | 3041 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-06-06 04:20:57 | Desha, Arkansas, US | |
3529753 | 3529753 | 2022-06-04 | US | North Carolina | Alleghany | 37005 | 3041 | 16 | 0 | 36.49360862 | -81.12857041 | 2022-06-05 04:20:55 | Alleghany, North Carolina, US | |
3527949 | 3527949 | 2022-06-04 | US | Arkansas | Desha | 5041 | 3041 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-06-05 04:20:55 | Desha, Arkansas, US | |
3135839 | 3135839 | 2022-06-03 | US | North Carolina | Alleghany | 37005 | 3041 | 16 | 0 | 36.49360862 | -81.12857041 | 2022-06-04 04:20:58 | Alleghany, North Carolina, US | |
3580914 | 3580914 | 2022-06-02 | US | North Carolina | Alleghany | 37005 | 3041 | 16 | 0 | 36.49360862 | -81.12857041 | 2022-06-03 04:20:58 | Alleghany, North Carolina, US | |
973207 | 973207 | 2022-06-01 | US | North Carolina | Alleghany | 37005 | 3041 | 16 | 0 | 36.49360862 | -81.12857041 | 2022-06-02 05:20:39 | Alleghany, North Carolina, US | |
231614 | 231614 | 2022-05-31 | US | North Dakota | Barnes | 38003 | 3041 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-06-01 04:20:55 | Barnes, North Dakota, US | |
3188379 | 3188379 | 2022-05-30 | US | North Dakota | Barnes | 38003 | 3041 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-05-31 04:20:51 | Barnes, North Dakota, US | |
3200528 | 3200528 | 2022-05-29 | US | North Dakota | Barnes | 38003 | 3041 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-05-30 04:20:50 | Barnes, North Dakota, US | |
2727406 | 2727406 | 2022-05-28 | US | North Dakota | Barnes | 38003 | 3041 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-05-29 04:20:53 | Barnes, North Dakota, US | |
1187310 | 1187310 | 2022-05-18 | US | Oklahoma | Johnston | 40069 | 3041 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-05-19 04:20:54 | Johnston, Oklahoma, US | |
3585207 | 3585207 | 2022-05-17 | US | Oklahoma | Johnston | 40069 | 3041 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-05-18 04:20:50 | Johnston, Oklahoma, US | |
1506164 | 1506164 | 2022-05-16 | US | Oklahoma | Johnston | 40069 | 3041 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-05-17 04:20:59 | Johnston, Oklahoma, US | |
2086523 | 2086523 | 2022-05-15 | US | Oklahoma | Johnston | 40069 | 3041 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-05-16 04:20:47 | Johnston, Oklahoma, US | |
3357233 | 3357233 | 2022-05-14 | US | Oklahoma | Johnston | 40069 | 3041 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-05-15 04:20:53 | Johnston, Oklahoma, US | |
660878 | 660878 | 2022-05-13 | US | Oklahoma | Johnston | 40069 | 3041 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-05-14 04:20:48 | Johnston, Oklahoma, US | |
2535961 | 2535961 | 2022-05-12 | US | Oklahoma | Johnston | 40069 | 3041 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-05-13 04:20:51 | Johnston, Oklahoma, US | |
2535094 | 2535094 | 2022-05-12 | US | Minnesota | Aitkin | 27001 | 3041 | 62 | 0 | 46.60962049 | -93.4116826 | 2022-05-13 04:20:51 | Aitkin, Minnesota, US | |
3268078 | 3268078 | 2022-05-04 | US | Oklahoma | Noble | 40103 | 3041 | 39 | 0 | 36.38953329 | -97.22928674 | 2022-05-05 04:20:55 | Noble, Oklahoma, US | |
1574717 | 1574717 | 2022-05-03 | US | Oklahoma | Noble | 40103 | 3041 | 39 | 0 | 36.38953329 | -97.22928674 | 2022-05-04 04:20:59 | Noble, Oklahoma, US | |
1574515 | 1574515 | 2022-05-03 | US | North Carolina | Washington | 37187 | 3041 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-05-04 04:20:59 | Washington, North Carolina, US | |
465977 | 465977 | 2022-05-02 | US | Oklahoma | Noble | 40103 | 3041 | 39 | 0 | 36.38953329 | -97.22928674 | 2022-05-03 04:21:00 | Noble, Oklahoma, US | |
465775 | 465775 | 2022-05-02 | US | North Carolina | Washington | 37187 | 3041 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-05-03 04:21:00 | Washington, North Carolina, US | |
3918616 | 3918616 | 2022-05-01 | US | Oklahoma | Noble | 40103 | 3041 | 39 | 0 | 36.38953329 | -97.22928674 | 2022-05-02 04:21:10 | Noble, Oklahoma, US | |
3918414 | 3918414 | 2022-05-01 | US | North Carolina | Washington | 37187 | 3041 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-05-02 04:21:10 | Washington, North Carolina, US | |
2843420 | 2843420 | 2022-04-30 | US | Oklahoma | Noble | 40103 | 3041 | 39 | 0 | 36.38953329 | -97.22928674 | 2022-05-01 04:20:57 | Noble, Oklahoma, US | |
2843218 | 2843218 | 2022-04-30 | US | North Carolina | Washington | 37187 | 3041 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-05-01 04:20:57 | Washington, North Carolina, US | |
1159733 | 1159733 | 2022-04-29 | US | Oklahoma | Noble | 40103 | 3041 | 39 | 0 | 36.38953329 | -97.22928674 | 2022-04-30 04:21:05 | Noble, Oklahoma, US | |
1159531 | 1159531 | 2022-04-29 | US | North Carolina | Washington | 37187 | 3041 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-04-30 04:21:05 | Washington, North Carolina, US | |
1698915 | 1698915 | 2022-04-28 | US | Oklahoma | Noble | 40103 | 3041 | 39 | 0 | 36.38953329 | -97.22928674 | 2022-04-29 04:20:59 | Noble, Oklahoma, US | |
1698713 | 1698713 | 2022-04-28 | US | North Carolina | Washington | 37187 | 3041 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-04-29 04:20:59 | Washington, North Carolina, US | |
3854196 | 3854196 | 2022-04-27 | US | North Carolina | Washington | 37187 | 3041 | 50 | 0 | 35.83810081 | -76.57299037 | 2022-04-28 04:20:47 | Washington, North Carolina, US | |
3724041 | 3724041 | 2022-04-25 | US | Mississippi | Perry | 28111 | 3041 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-04-26 04:20:51 | Perry, Mississippi, US | |
2030609 | 2030609 | 2022-04-24 | US | Mississippi | Perry | 28111 | 3041 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-04-25 04:20:56 | Perry, Mississippi, US | |
748184 | 748184 | 2022-04-23 | US | Mississippi | Perry | 28111 | 3041 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-04-24 04:20:56 | Perry, Mississippi, US | |
3438669 | 3438669 | 2022-04-22 | US | Mississippi | Perry | 28111 | 3041 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-04-23 04:20:50 | Perry, Mississippi, US | |
2894254 | 2894254 | 2022-04-21 | US | Mississippi | Perry | 28111 | 3041 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-04-22 04:20:45 | Perry, Mississippi, US | |
2309126 | 2309126 | 2022-04-20 | US | Mississippi | Perry | 28111 | 3041 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-04-21 04:20:46 | Perry, Mississippi, US | |
2253265 | 2253265 | 2022-04-19 | US | Mississippi | Perry | 28111 | 3041 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-04-20 04:20:45 | Perry, Mississippi, US | |
1847815 | 1847815 | 2022-04-18 | US | Mississippi | Perry | 28111 | 3041 | 64 | 0 | 31.17161885 | -88.99281835 | 2022-04-19 04:21:00 | Perry, Mississippi, US | |
696382 | 696382 | 2022-03-17 | US | Montana | Custer | 30017 | 3041 | 46 | 0 | 46.25319932 | -105.57375259999998 | 2022-03-18 04:20:55 | Custer, Montana, US | |
694426 | 694426 | 2022-03-17 | Kiribati | 3041 | 13 | 0 | -3.3704 | -168.734 | 2022-03-18 04:20:55 | Kiribati | ||||
2319369 | 2319369 | 2022-03-16 | Kiribati | 3041 | 13 | 0 | -3.3704 | -168.734 | 2022-03-17 04:20:56 | Kiribati | ||||
3628839 | 3628839 | 2022-03-13 | US | Georgia | Telfair | 13271 | 3041 | 81 | 0 | 31.92829517 | -82.93491155 | 2022-03-14 04:20:46 | Telfair, Georgia, US | |
951747 | 951747 | 2022-03-12 | US | Georgia | Telfair | 13271 | 3041 | 81 | 0 | 31.92829517 | -82.93491155 | 2022-03-13 04:20:49 | Telfair, Georgia, US | |
357208 | 357208 | 2022-03-11 | US | Georgia | Telfair | 13271 | 3041 | 81 | 0 | 31.92829517 | -82.93491155 | 2022-03-12 04:20:50 | Telfair, Georgia, US | |
1866360 | 1866360 | 2022-03-10 | US | Georgia | Telfair | 13271 | 3041 | 81 | 0 | 31.92829517 | -82.93491155 | 2022-03-11 04:20:50 | Telfair, Georgia, US | |
2735145 | 2735145 | 2022-02-27 | US | Nebraska | Seward | 31159 | 3041 | 32 | 0 | 40.87241834 | -97.139673 | 2022-02-28 04:21:05 | Seward, Nebraska, US | |
2734155 | 2734155 | 2022-02-27 | US | Indiana | Pulaski | 18131 | 3041 | 83 | 0 | 41.04166107 | -86.69890683 | 2022-02-28 04:21:05 | Pulaski, Indiana, US | |
3048298 | 3048298 | 2022-02-26 | US | Nebraska | Seward | 31159 | 3041 | 32 | 0 | 40.87241834 | -97.139673 | 2022-02-27 04:21:04 | Seward, Nebraska, US | |
3047308 | 3047308 | 2022-02-26 | US | Indiana | Pulaski | 18131 | 3041 | 83 | 0 | 41.04166107 | -86.69890683 | 2022-02-27 04:21:04 | Pulaski, Indiana, US | |
576953 | 576953 | 2022-02-25 | US | Nebraska | Seward | 31159 | 3041 | 32 | 0 | 40.87241834 | -97.139673 | 2022-02-26 04:21:12 | Seward, Nebraska, US | |
575963 | 575963 | 2022-02-25 | US | Indiana | Pulaski | 18131 | 3041 | 83 | 0 | 41.04166107 | -86.69890683 | 2022-02-26 04:21:12 | Pulaski, Indiana, US | |
1513529 | 1513529 | 2022-02-24 | US | Nebraska | Seward | 31159 | 3041 | 32 | 0 | 40.87241834 | -97.139673 | 2022-02-25 04:21:11 | Seward, Nebraska, US | |
1061037 | 1061037 | 2022-02-23 | US | Texas | Nolan | 48353 | 3041 | 95 | 0 | 32.30365282 | -100.4060208 | 2022-02-24 04:21:14 | Nolan, Texas, US | |
1059970 | 1059970 | 2022-02-23 | US | Nebraska | Seward | 31159 | 3041 | 32 | 0 | 40.87241834 | -97.139673 | 2022-02-24 04:21:14 | Seward, Nebraska, US | |
2645127 | 2645127 | 2022-02-14 | US | Virginia | Martinsville | 51690 | 3041 | 107 | 0 | 36.68212094 | -79.86352771 | 2022-02-15 04:21:09 | Martinsville, Virginia, US | |
2643780 | 2643780 | 2022-02-14 | US | Montana | Roosevelt | 30085 | 3041 | 70 | 0 | 48.29607488 | -105.00792679999999 | 2022-02-15 04:21:09 | Roosevelt, Montana, US | |
2660848 | 2660848 | 2022-01-31 | US | Texas | Comanche | 48093 | 3041 | 72 | 0 | 31.94854689 | -98.55876441 | 2022-02-01 04:21:11 | Comanche, Texas, US | |
1231002 | 1231002 | 2022-01-24 | US | Virginia | Patrick | 51141 | 3041 | 72 | 0 | 36.680163799999995 | -80.2865648 | 2022-01-25 04:21:05 | Patrick, 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]);