johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
157 rows where confirmed = 5094 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 143
- San Marino 5
- Malaysia 2
- Russia 2
- China 1
- Honduras 1
- Netherlands 1
- Spain 1
- Suriname 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3460809 | 3460809 | 2022-11-21 | US | Colorado | Otero | 8089 | 5094 | 133 | 0 | 37.9014485 | -103.7173385 | 2022-11-22 04:20:47 | Otero, Colorado, US | |
2431933 | 2431933 | 2022-11-09 | US | Illinois | Hancock | 17067 | 5094 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-11-10 04:21:16 | Hancock, Illinois, US | |
482815 | 482815 | 2022-11-08 | US | Texas | Shelby | 48419 | 5094 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-11-09 04:21:22 | Shelby, Texas, US | |
481208 | 481208 | 2022-11-08 | US | Michigan | Antrim | 26009 | 5094 | 73 | 0 | 44.99690221 | -85.15503082 | 2022-11-09 04:21:22 | Antrim, Michigan, US | |
2441965 | 2441965 | 2022-11-07 | US | Texas | Shelby | 48419 | 5094 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-11-08 04:21:21 | Shelby, Texas, US | |
2440358 | 2440358 | 2022-11-07 | US | Michigan | Antrim | 26009 | 5094 | 73 | 0 | 44.99690221 | -85.15503082 | 2022-11-08 04:21:21 | Antrim, Michigan, US | |
1051456 | 1051456 | 2022-11-06 | US | Michigan | Antrim | 26009 | 5094 | 73 | 0 | 44.99690221 | -85.15503082 | 2022-11-07 04:21:26 | Antrim, Michigan, US | |
619480 | 619480 | 2022-11-05 | US | Michigan | Antrim | 26009 | 5094 | 73 | 0 | 44.99690221 | -85.15503082 | 2022-11-06 04:21:24 | Antrim, Michigan, US | |
1023984 | 1023984 | 2022-11-04 | US | Michigan | Antrim | 26009 | 5094 | 73 | 0 | 44.99690221 | -85.15503082 | 2022-11-05 04:21:52 | Antrim, Michigan, US | |
432975 | 432975 | 2022-11-03 | US | Michigan | Antrim | 26009 | 5094 | 73 | 0 | 44.99690221 | -85.15503082 | 2022-11-04 04:22:11 | Antrim, Michigan, US | |
851217 | 851217 | 2022-11-02 | US | Michigan | Antrim | 26009 | 5094 | 73 | 0 | 44.99690221 | -85.15503082 | 2022-11-03 04:22:05 | Antrim, Michigan, US | |
712068 | 712068 | 2022-11-01 | US | Michigan | Antrim | 26009 | 5094 | 73 | 0 | 44.99690221 | -85.15503082 | 2022-11-02 04:22:09 | Antrim, Michigan, US | |
2272471 | 2272471 | 2022-10-20 | US | California | Colusa | 6011 | 5094 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-10-21 04:22:23 | Colusa, California, US | |
198806 | 198806 | 2022-10-19 | US | California | Colusa | 6011 | 5094 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-10-20 04:22:59 | Colusa, California, US | |
2532923 | 2532923 | 2022-10-06 | US | Wisconsin | Crawford | 55023 | 5094 | 31 | 0 | 43.23870316 | -90.93073686 | 2022-10-07 04:23:08 | Crawford, Wisconsin, US | |
3776643 | 3776643 | 2022-08-30 | US | Puerto Rico | Comerio | 72045 | 5094 | 0 | 0 | 18.224687 | -66.221622 | 2022-08-31 04:20:57 | Comerio, Puerto Rico, US | |
3272551 | 3272551 | 2022-06-19 | US | Texas | Burleson | 48051 | 5094 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-06-20 04:21:01 | Burleson, Texas, US | |
3400463 | 3400463 | 2022-06-18 | US | Texas | Burleson | 48051 | 5094 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-06-19 04:20:51 | Burleson, Texas, US | |
3507740 | 3507740 | 2022-06-05 | US | Alabama | Butler | 1013 | 5094 | 129 | 0 | 31.75300095 | -86.68057478 | 2022-06-06 04:20:57 | Butler, Alabama, US | |
3527817 | 3527817 | 2022-06-04 | US | Alabama | Butler | 1013 | 5094 | 129 | 0 | 31.75300095 | -86.68057478 | 2022-06-05 04:20:55 | Butler, Alabama, US | |
3133903 | 3133903 | 2022-06-03 | US | Alabama | Butler | 1013 | 5094 | 129 | 0 | 31.75300095 | -86.68057478 | 2022-06-04 04:20:58 | Butler, Alabama, US | |
3580574 | 3580574 | 2022-06-02 | US | Missouri | Perry | 29157 | 5094 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-03 04:20:58 | Perry, Missouri, US | |
3578978 | 3578978 | 2022-06-02 | US | Alabama | Butler | 1013 | 5094 | 129 | 0 | 31.75300095 | -86.68057478 | 2022-06-03 04:20:58 | Butler, Alabama, US | |
972867 | 972867 | 2022-06-01 | US | Missouri | Perry | 29157 | 5094 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-02 05:20:39 | Perry, Missouri, US | |
231174 | 231174 | 2022-05-31 | US | Missouri | Perry | 29157 | 5094 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-01 04:20:55 | Perry, Missouri, US | |
3187939 | 3187939 | 2022-05-30 | US | Missouri | Perry | 29157 | 5094 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-05-31 04:20:51 | Perry, Missouri, US | |
3200088 | 3200088 | 2022-05-29 | US | Missouri | Perry | 29157 | 5094 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-05-30 04:20:50 | Perry, Missouri, US | |
2726966 | 2726966 | 2022-05-28 | US | Missouri | Perry | 29157 | 5094 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-05-29 04:20:53 | Perry, Missouri, US | |
1316147 | 1316147 | 2022-05-27 | US | Missouri | Perry | 29157 | 5094 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-05-28 04:21:07 | Perry, Missouri, US | |
3001617 | 3001617 | 2022-05-24 | US | North Carolina | Currituck | 37053 | 5094 | 36 | 0 | 36.36123664 | -75.95876401 | 2022-05-24 23:20:57 | Currituck, North Carolina, US | |
3595338 | 3595338 | 2022-05-23 | US | North Carolina | Currituck | 37053 | 5094 | 36 | 0 | 36.36123664 | -75.95876401 | 2022-05-24 04:20:57 | Currituck, North Carolina, US | |
1111886 | 1111886 | 2022-05-21 | US | North Carolina | Currituck | 37053 | 5094 | 36 | 0 | 36.36123664 | -75.95876401 | 2022-05-22 04:20:52 | Currituck, North Carolina, US | |
1171510 | 1171510 | 2022-05-20 | US | North Carolina | Currituck | 37053 | 5094 | 36 | 0 | 36.36123664 | -75.95876401 | 2022-05-21 04:20:58 | Currituck, North Carolina, US | |
3898273 | 3898273 | 2022-05-19 | US | North Carolina | Currituck | 37053 | 5094 | 36 | 0 | 36.36123664 | -75.95876401 | 2022-05-20 04:20:57 | Currituck, North Carolina, US | |
1187057 | 1187057 | 2022-05-18 | US | North Carolina | Currituck | 37053 | 5094 | 36 | 0 | 36.36123664 | -75.95876401 | 2022-05-19 04:20:54 | Currituck, North Carolina, US | |
225390 | 225390 | 2022-05-09 | US | Virginia | Prince Edward | 51147 | 5094 | 70 | 0 | 37.22554789 | -78.43597949 | 2022-05-10 04:20:50 | Prince Edward, Virginia, US | |
2600026 | 2600026 | 2022-05-05 | US | Missouri | Vernon | 29217 | 5094 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-05-06 04:21:00 | Vernon, Missouri, US | |
3267475 | 3267475 | 2022-05-04 | US | Missouri | Vernon | 29217 | 5094 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-05-05 04:20:55 | Vernon, Missouri, US | |
1574114 | 1574114 | 2022-05-03 | US | Missouri | Vernon | 29217 | 5094 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-05-04 04:20:59 | Vernon, Missouri, US | |
465374 | 465374 | 2022-05-02 | US | Missouri | Vernon | 29217 | 5094 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-05-03 04:21:00 | Vernon, Missouri, US | |
3918013 | 3918013 | 2022-05-01 | US | Missouri | Vernon | 29217 | 5094 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-05-02 04:21:10 | Vernon, Missouri, US | |
2842817 | 2842817 | 2022-04-30 | US | Missouri | Vernon | 29217 | 5094 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-05-01 04:20:57 | Vernon, Missouri, US | |
1159130 | 1159130 | 2022-04-29 | US | Missouri | Vernon | 29217 | 5094 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-04-30 04:21:05 | Vernon, Missouri, US | |
1698312 | 1698312 | 2022-04-28 | US | Missouri | Vernon | 29217 | 5094 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-04-29 04:20:59 | Vernon, Missouri, US | |
3723702 | 3723702 | 2022-04-25 | US | Louisiana | Concordia | 22029 | 5094 | 89 | 0 | 31.44817835 | -91.63814433 | 2022-04-26 04:20:51 | Concordia, Louisiana, US | |
2030270 | 2030270 | 2022-04-24 | US | Louisiana | Concordia | 22029 | 5094 | 89 | 0 | 31.44817835 | -91.63814433 | 2022-04-25 04:20:56 | Concordia, Louisiana, US | |
747845 | 747845 | 2022-04-23 | US | Louisiana | Concordia | 22029 | 5094 | 89 | 0 | 31.44817835 | -91.63814433 | 2022-04-24 04:20:56 | Concordia, Louisiana, US | |
3439987 | 3439987 | 2022-04-22 | US | Texas | Limestone | 48293 | 5094 | 124 | 0 | 31.5454767 | -96.58095444 | 2022-04-23 04:20:50 | Limestone, Texas, US | |
3438330 | 3438330 | 2022-04-22 | US | Louisiana | Concordia | 22029 | 5094 | 89 | 0 | 31.44817835 | -91.63814433 | 2022-04-23 04:20:50 | Concordia, Louisiana, US | |
2893915 | 2893915 | 2022-04-21 | US | Louisiana | Concordia | 22029 | 5094 | 89 | 0 | 31.44817835 | -91.63814433 | 2022-04-22 04:20:45 | Concordia, Louisiana, US | |
2308787 | 2308787 | 2022-04-20 | US | Louisiana | Concordia | 22029 | 5094 | 89 | 0 | 31.44817835 | -91.63814433 | 2022-04-21 04:20:46 | Concordia, Louisiana, US | |
3209816 | 3209816 | 2022-04-11 | US | Wisconsin | Green Lake | 55047 | 5094 | 63 | 0 | 43.80025981 | -89.04679553 | 2022-04-12 04:20:49 | Green Lake, Wisconsin, US | |
2801578 | 2801578 | 2022-04-06 | US | Georgia | Fannin | 13111 | 5094 | 152 | 0 | 34.86430205 | -84.316964 | 2022-04-07 04:20:53 | Fannin, Georgia, US | |
2749689 | 2749689 | 2022-04-04 | US | Georgia | Fannin | 13111 | 5094 | 152 | 0 | 34.86430205 | -84.316964 | 2022-04-05 04:20:48 | Fannin, Georgia, US | |
3022082 | 3022082 | 2022-03-23 | China | Shanghai | 5094 | 7 | 0 | 31.201999999999998 | 121.4491 | 2022-03-24 04:20:43 | Shanghai, China | |||
3238831 | 3238831 | 2022-03-21 | US | Arkansas | Logan | 5083 | 5094 | 77 | 0 | 35.21413234 | -93.71951016 | 2022-03-22 04:20:54 | Logan, Arkansas, US | |
24904 | 24904 | 2022-03-20 | US | Arkansas | Logan | 5083 | 5094 | 76 | 0 | 35.21413234 | -93.71951016 | 2022-03-21 04:20:50 | Logan, Arkansas, US | |
264174 | 264174 | 2022-03-15 | US | Oregon | Wasco | 41065 | 5094 | 57 | 0 | 45.16292781 | -121.16709540000001 | 2022-03-16 04:20:50 | Wasco, Oregon, US | |
358804 | 358804 | 2022-03-11 | US | Ohio | Holmes | 39075 | 5094 | 182 | 0 | 40.56163713 | -81.92635677 | 2022-03-12 04:20:50 | Holmes, Ohio, US | |
943817 | 943817 | 2022-02-28 | US | Illinois | Edgar | 17045 | 5094 | 57 | 0 | 39.6809186 | -87.74759563 | 2022-03-01 04:21:09 | Edgar, Illinois, US | |
3912471 | 3912471 | 2022-02-20 | US | Arizona | La Paz | 4012 | 5094 | 132 | 0 | 33.72854224 | -113.98100290000001 | 2022-02-21 04:21:05 | La Paz, Arizona, US | |
3822006 | 3822006 | 2022-02-16 | US | Maine | Waldo | 23027 | 5094 | 52 | 0 | 44.4858305 | -69.12061935 | 2022-02-17 04:20:56 | Waldo, Maine, US | |
3076261 | 3076261 | 2022-02-09 | US | New Mexico | Taos | 35055 | 5094 | 82 | 0 | 36.58006022 | -105.63101979999999 | 2022-02-10 04:21:14 | Taos, New Mexico, US | |
462561 | 462561 | 2022-02-02 | US | Texas | Moore | 48341 | 5094 | 104 | 0 | 35.83769242 | -101.8930281 | 2022-02-03 04:21:21 | Moore, Texas, US | |
1320076 | 1320076 | 2022-01-26 | US | Mississippi | Wayne | 28153 | 5094 | 73 | 0 | 31.64135687 | -88.69573913 | 2022-01-27 04:21:19 | Wayne, Mississippi, US | |
1389792 | 1389792 | 2022-01-07 | Netherlands | Unknown | 5094 | 32 | 0 | 2022-01-08 04:21:53 | Unknown, Netherlands | |||||
1078891 | 1078891 | 2021-12-09 | US | Illinois | Bureau | 17011 | 5094 | 100 | 0 | 41.40385234 | -89.5283051 | 2021-12-10 04:22:28 | Bureau, Illinois, US | |
1016137 | 1016137 | 2021-11-21 | US | Mississippi | George | 28039 | 5094 | 80 | 0 | 30.86259065 | -88.64436789 | 2021-11-22 04:22:20 | George, Mississippi, US | |
724301 | 724301 | 2021-11-20 | US | Mississippi | George | 28039 | 5094 | 80 | 0 | 30.86259065 | -88.64436789 | 2021-11-21 04:22:13 | George, Mississippi, US | |
163831 | 163831 | 2021-11-19 | US | Mississippi | George | 28039 | 5094 | 80 | 0 | 30.86259065 | -88.64436789 | 2021-11-20 04:22:17 | George, Mississippi, US | |
3345320 | 3345320 | 2021-11-16 | US | Pennsylvania | Snyder | 42109 | 5094 | 108 | 0 | 40.77129231 | -77.06840691 | 2021-11-17 04:21:48 | Snyder, Pennsylvania, US | |
3495120 | 3495120 | 2021-10-26 | US | Tennessee | Hardeman | 47069 | 5094 | 80 | 0 | 35.20772017 | -88.99161161 | 2021-10-27 04:22:32 | Hardeman, Tennessee, US | |
3796978 | 3796978 | 2021-10-25 | US | Texas | Fannin | 48147 | 5094 | 149 | 0 | 33.59564294 | -96.10751083 | 2021-10-26 04:22:09 | Fannin, Texas, US | |
685424 | 685424 | 2021-10-24 | US | Texas | Fannin | 48147 | 5094 | 149 | 0 | 33.59564294 | -96.10751083 | 2021-10-25 04:22:31 | Fannin, Texas, US | |
773432 | 773432 | 2021-10-23 | US | Texas | Fannin | 48147 | 5094 | 149 | 0 | 33.59564294 | -96.10751083 | 2021-10-24 04:21:22 | Fannin, Texas, US | |
2126016 | 2126016 | 2021-10-21 | US | New York | Tioga | 36107 | 5094 | 71 | 0 | 42.16852837 | -76.30835812 | 2021-10-22 04:21:14 | Tioga, New York, US | |
445305 | 445305 | 2021-10-20 | US | Missouri | Polk | 29167 | 5094 | 50 | 0 | 37.616229600000004 | -93.39828174 | 2021-10-21 04:21:18 | Polk, Missouri, US | |
444744 | 444744 | 2021-10-20 | US | Kentucky | Clay | 21051 | 5094 | 56 | 0 | 37.16451126 | -83.712575 | 2021-10-21 04:21:18 | Clay, Kentucky, US | |
600209 | 600209 | 2021-10-19 | US | Oklahoma | Caddo | 40015 | 5094 | 114 | 0 | 35.17364557 | -98.37534464 | 2021-10-20 04:21:00 | Caddo, Oklahoma, US | |
599624 | 599624 | 2021-10-19 | US | Missouri | Polk | 29167 | 5094 | 50 | 0 | 37.616229600000004 | -93.39828174 | 2021-10-20 04:21:00 | Polk, Missouri, US | |
2046386 | 2046386 | 2021-10-18 | US | Oklahoma | Caddo | 40015 | 5094 | 114 | 0 | 35.17364557 | -98.37534464 | 2021-10-19 04:20:54 | Caddo, Oklahoma, US | |
1911747 | 1911747 | 2021-10-17 | US | Oklahoma | Caddo | 40015 | 5094 | 114 | 0 | 35.17364557 | -98.37534464 | 2021-10-18 04:21:10 | Caddo, Oklahoma, US | |
937336 | 937336 | 2021-10-16 | US | Oklahoma | Caddo | 40015 | 5094 | 114 | 0 | 35.17364557 | -98.37534464 | 2021-10-17 04:21:29 | Caddo, Oklahoma, US | |
2945891 | 2945891 | 2021-10-15 | US | Oklahoma | Caddo | 40015 | 5094 | 114 | 0 | 35.17364557 | -98.37534464 | 2021-10-16 04:21:15 | Caddo, Oklahoma, US | |
494171 | 494171 | 2021-10-14 | US | Oklahoma | Caddo | 40015 | 5094 | 114 | 0 | 35.17364557 | -98.37534464 | 2021-10-15 04:21:26 | Caddo, Oklahoma, US | |
636617 | 636617 | 2021-10-13 | US | Pennsylvania | Perry | 42099 | 5094 | 114 | 0 | 40.40206612 | -77.26297447 | 2021-10-14 04:21:29 | Perry, Pennsylvania, US | |
636459 | 636459 | 2021-10-13 | US | Oklahoma | Caddo | 40015 | 5094 | 114 | 0 | 35.17364557 | -98.37534464 | 2021-10-14 04:21:29 | Caddo, Oklahoma, US | |
635875 | 635875 | 2021-10-13 | US | Missouri | Pulaski | 29169 | 5094 | 76 | 0 | 37.82462075 | -92.20783203 | 2021-10-14 04:21:29 | Pulaski, Missouri, US | |
469507 | 469507 | 2021-10-07 | US | Nebraska | Lincoln | 31111 | 5094 | 60 | 0 | 41.04658298 | -100.74753740000001 | 2021-10-08 04:21:25 | Lincoln, Nebraska, US | |
1336000 | 1336000 | 2021-09-28 | US | Minnesota | Isanti | 27059 | 5094 | 71 | 0 | 45.56181234 | -93.29487636 | 2021-09-29 04:21:45 | Isanti, Minnesota, US | |
3013580 | 3013580 | 2021-09-22 | US | New York | Montgomery | 36057 | 5094 | 133 | 0 | 42.90123494 | -74.44011632 | 2021-09-23 04:21:43 | Montgomery, New York, US | |
1388966 | 1388966 | 2021-09-13 | US | Virginia | Franklin | 51067 | 5094 | 86 | 0 | 36.99536167 | -79.88023649 | 2021-09-14 04:21:41 | Franklin, Virginia, US | |
1778596 | 1778596 | 2021-08-30 | US | Texas | Uvalde | 48463 | 5094 | 79 | 0 | 29.35739637 | -99.76229172 | 2021-08-31 04:21:46 | Uvalde, Texas, US | |
3893045 | 3893045 | 2021-08-29 | US | Indiana | Montgomery | 18107 | 5094 | 95 | 0 | 40.04034823 | -86.89335024 | 2021-08-30 04:21:23 | Montgomery, Indiana, US | |
2794148 | 2794148 | 2021-08-28 | US | Indiana | Montgomery | 18107 | 5094 | 95 | 0 | 40.04034823 | -86.89335024 | 2021-08-29 04:21:14 | Montgomery, Indiana, US | |
2924307 | 2924307 | 2021-08-27 | US | Indiana | Montgomery | 18107 | 5094 | 95 | 0 | 40.04034823 | -86.89335024 | 2021-08-28 04:21:28 | Montgomery, Indiana, US | |
2177269 | 2177269 | 2021-08-22 | US | Minnesota | Goodhue | 27049 | 5094 | 76 | 0 | 44.40849741 | -92.72341949999999 | 2021-08-23 04:21:27 | Goodhue, Minnesota, US | |
3557365 | 3557365 | 2021-08-21 | US | Minnesota | Goodhue | 27049 | 5094 | 76 | 0 | 44.40849741 | -92.72341949999999 | 2021-08-22 04:21:29 | Goodhue, Minnesota, US | |
1855707 | 1855707 | 2021-08-20 | US | Minnesota | Goodhue | 27049 | 5094 | 76 | 0 | 44.40849741 | -92.72341949999999 | 2021-08-21 04:21:38 | Goodhue, Minnesota, US | |
1344715 | 1344715 | 2021-08-11 | US | North Dakota | Stark | 38089 | 5094 | 52 | 0 | 46.80851182 | -102.65763259999999 | 2021-08-12 04:21:25 | Stark, North Dakota, 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]);