johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
152 rows where confirmed = 4425 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3717439 | 3717439 | 2022-12-06 | US | Texas | Zavala | 48507 | 4425 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-07 04:20:58 | Zavala, Texas, US | |
2418144 | 2418144 | 2022-12-05 | US | Texas | Zavala | 48507 | 4425 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-06 04:21:03 | Zavala, Texas, US | |
721752 | 721752 | 2022-12-04 | US | Texas | Zavala | 48507 | 4425 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-05 04:20:58 | Zavala, Texas, US | |
2820041 | 2820041 | 2022-12-03 | US | Texas | Zavala | 48507 | 4425 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-04 04:20:56 | Zavala, Texas, US | |
836897 | 836897 | 2022-12-02 | US | Texas | Zavala | 48507 | 4425 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-03 04:21:02 | Zavala, Texas, US | |
2139427 | 2139427 | 2022-12-01 | US | Texas | Zavala | 48507 | 4425 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-02 04:21:07 | Zavala, Texas, US | |
1967843 | 1967843 | 2022-11-30 | US | Texas | Zavala | 48507 | 4425 | 70 | 0 | 28.86617238 | -99.76050829 | 2022-12-01 04:21:03 | Zavala, Texas, US | |
2559207 | 2559207 | 2022-11-29 | US | Oregon | Curry | 41015 | 4425 | 67 | 0 | 42.45911325 | -124.157282 | 2022-11-30 04:21:07 | Curry, Oregon, US | |
1242281 | 1242281 | 2022-11-28 | US | Oregon | Curry | 41015 | 4425 | 67 | 0 | 42.45911325 | -124.157282 | 2022-11-29 04:21:05 | Curry, Oregon, US | |
3554269 | 3554269 | 2022-11-27 | US | Oregon | Curry | 41015 | 4425 | 67 | 0 | 42.45911325 | -124.157282 | 2022-11-28 04:21:02 | Curry, Oregon, US | |
2102749 | 2102749 | 2022-11-26 | US | Oregon | Curry | 41015 | 4425 | 67 | 0 | 42.45911325 | -124.157282 | 2022-11-27 04:21:05 | Curry, Oregon, US | |
490240 | 490240 | 2022-11-25 | US | Oregon | Curry | 41015 | 4425 | 67 | 0 | 42.45911325 | -124.157282 | 2022-11-26 04:21:11 | Curry, Oregon, US | |
3526069 | 3526069 | 2022-11-24 | US | Oregon | Curry | 41015 | 4425 | 67 | 0 | 42.45911325 | -124.157282 | 2022-11-25 04:21:06 | Curry, Oregon, US | |
3314852 | 3314852 | 2022-11-23 | US | Oregon | Curry | 41015 | 4425 | 67 | 0 | 42.45911325 | -124.157282 | 2022-11-24 04:21:09 | Curry, Oregon, US | |
3462367 | 3462367 | 2022-11-21 | US | New Mexico | Los Alamos | 35028 | 4425 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-11-22 04:20:47 | Los Alamos, New Mexico, US | |
2433560 | 2433560 | 2022-11-09 | US | Oregon | Hood River | 41027 | 4425 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-10 04:21:16 | Hood River, Oregon, US | |
482216 | 482216 | 2022-11-08 | US | Oregon | Hood River | 41027 | 4425 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-09 04:21:22 | Hood River, Oregon, US | |
2441366 | 2441366 | 2022-11-07 | US | Oregon | Hood River | 41027 | 4425 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-08 04:21:21 | Hood River, Oregon, US | |
1052464 | 1052464 | 2022-11-06 | US | Oregon | Hood River | 41027 | 4425 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-07 04:21:26 | Hood River, Oregon, US | |
620488 | 620488 | 2022-11-05 | US | Oregon | Hood River | 41027 | 4425 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-06 04:21:24 | Hood River, Oregon, US | |
1024992 | 1024992 | 2022-11-04 | US | Oregon | Hood River | 41027 | 4425 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-05 04:21:52 | Hood River, Oregon, US | |
433983 | 433983 | 2022-11-03 | US | Oregon | Hood River | 41027 | 4425 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-04 04:22:11 | Hood River, Oregon, US | |
852225 | 852225 | 2022-11-02 | US | Oregon | Hood River | 41027 | 4425 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-11-03 04:22:05 | Hood River, Oregon, US | |
2026972 | 2026972 | 2022-10-17 | US | New Mexico | Socorro | 35053 | 4425 | 96 | 0 | 34.00715494 | -106.9298354 | 2022-10-18 04:22:42 | Socorro, New Mexico, US | |
3253513 | 3253513 | 2022-10-11 | US | Virginia | King William | 51101 | 4425 | 48 | 0 | 37.70965316 | -77.09384941 | 2022-10-12 04:22:51 | King William, Virginia, US | |
2019672 | 2019672 | 2022-09-20 | US | Tennessee | Grundy | 47061 | 4425 | 77 | 0 | 35.38433717 | -85.72142731 | 2022-09-21 04:23:22 | Grundy, Tennessee, US | |
3776266 | 3776266 | 2022-08-30 | US | North Carolina | Polk | 37149 | 4425 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-08-31 04:20:57 | Polk, North Carolina, US | |
1682862 | 1682862 | 2022-08-29 | US | North Carolina | Polk | 37149 | 4425 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-08-30 04:21:03 | Polk, North Carolina, US | |
1879411 | 1879411 | 2022-08-28 | US | North Dakota | Richland | 38077 | 4425 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-08-29 04:21:06 | Richland, North Dakota, US | |
1879346 | 1879346 | 2022-08-28 | US | North Carolina | Polk | 37149 | 4425 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-08-29 04:21:06 | Polk, North Carolina, US | |
2098473 | 2098473 | 2022-08-27 | US | North Carolina | Polk | 37149 | 4425 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-08-28 04:21:02 | Polk, North Carolina, US | |
1534288 | 1534288 | 2022-08-26 | US | North Carolina | Polk | 37149 | 4425 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-08-27 04:20:57 | Polk, North Carolina, US | |
2831175 | 2831175 | 2022-08-25 | US | North Carolina | Polk | 37149 | 4425 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-08-26 04:21:02 | Polk, North Carolina, US | |
2325708 | 2325708 | 2022-08-24 | US | North Carolina | Polk | 37149 | 4425 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-08-25 04:21:13 | Polk, North Carolina, US | |
994008 | 994008 | 2022-08-16 | US | Texas | Andrews | 48003 | 4425 | 72 | 0 | 32.30468633 | -102.6376548 | 2022-08-17 04:20:59 | Andrews, Texas, US | |
1971334 | 1971334 | 2022-08-13 | US | Puerto Rico | Guayanilla | 72059 | 4425 | 0 | 0 | 18.039942 | -66.79186 | 2022-08-14 04:20:55 | Guayanilla, Puerto Rico, US | |
1098477 | 1098477 | 2022-08-03 | US | Alabama | Clay | 1027 | 4425 | 83 | 0 | 33.26984193 | -85.85836077 | 2022-08-04 04:20:58 | Clay, Alabama, US | |
1406071 | 1406071 | 2022-08-02 | US | Illinois | Mercer | 17131 | 4425 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-08-03 04:20:59 | Mercer, Illinois, US | |
1405402 | 1405402 | 2022-08-02 | US | Alabama | Clay | 1027 | 4425 | 83 | 0 | 33.26984193 | -85.85836077 | 2022-08-03 04:20:59 | Clay, Alabama, US | |
3617440 | 3617440 | 2022-08-01 | US | Alabama | Clay | 1027 | 4425 | 83 | 0 | 33.26984193 | -85.85836077 | 2022-08-02 04:20:53 | Clay, Alabama, US | |
3871920 | 3871920 | 2022-07-31 | US | Alabama | Clay | 1027 | 4425 | 83 | 0 | 33.26984193 | -85.85836077 | 2022-08-01 04:21:03 | Clay, Alabama, US | |
674674 | 674674 | 2022-07-30 | US | Alabama | Clay | 1027 | 4425 | 83 | 0 | 33.26984193 | -85.85836077 | 2022-07-31 04:21:02 | Clay, Alabama, US | |
1783873 | 1783873 | 2022-07-29 | US | Alabama | Clay | 1027 | 4425 | 83 | 0 | 33.26984193 | -85.85836077 | 2022-07-30 04:20:42 | Clay, Alabama, US | |
1069471 | 1069471 | 2022-07-28 | US | Wisconsin | Washburn | 55129 | 4425 | 47 | 0 | 45.89838588 | -91.79050449 | 2022-07-29 04:20:45 | Washburn, Wisconsin, US | |
1069223 | 1069223 | 2022-07-28 | US | Virginia | Giles | 51071 | 4425 | 50 | 0 | 37.31234791 | -80.70636931 | 2022-07-29 04:20:45 | Giles, Virginia, US | |
959969 | 959969 | 2022-07-19 | US | Indiana | Carroll | 18015 | 4425 | 70 | 0 | 40.5807832 | -86.56198812 | 2022-07-20 04:20:59 | Carroll, Indiana, US | |
558569 | 558569 | 2022-06-16 | Canada | Yukon | 4425 | 26 | 0 | 64.2823 | -135.0 | 2022-06-17 04:20:56 | Yukon, Canada | |||
3855127 | 3855127 | 2022-04-27 | US | Virginia | Bristol | 51520 | 4425 | 79 | 0 | 36.6163024 | -82.16359122 | 2022-04-28 04:20:47 | Bristol, Virginia, US | |
1548976 | 1548976 | 2022-03-07 | US | Illinois | Johnson | 17087 | 4425 | 40 | 0 | 37.45939802 | -88.88165419 | 2022-03-08 04:20:54 | Johnson, Illinois, US | |
577599 | 577599 | 2022-02-25 | US | Puerto Rico | Naranjito | 72105 | 4425 | 0 | 0 | 18.288019 | -66.252703 | 2022-02-26 04:21:12 | Naranjito, Puerto Rico, US | |
1514175 | 1514175 | 2022-02-24 | US | Puerto Rico | Naranjito | 72105 | 4425 | 0 | 0 | 18.288019 | -66.252703 | 2022-02-25 04:21:11 | Naranjito, Puerto Rico, US | |
1058714 | 1058714 | 2022-02-23 | US | Georgia | Putnam | 13237 | 4425 | 100 | 0 | 33.32056115 | -83.37552891 | 2022-02-24 04:21:14 | Putnam, Georgia, US | |
1058695 | 1058695 | 2022-02-23 | US | Georgia | Meriwether | 13199 | 4425 | 134 | 0 | 33.04163534 | -84.68859732 | 2022-02-24 04:21:14 | Meriwether, Georgia, US | |
73066 | 73066 | 2022-02-07 | US | Missouri | Texas | 29215 | 4425 | 80 | 0 | 37.31728859 | -91.96564727 | 2022-02-08 04:21:15 | Texas, Missouri, US | |
1297244 | 1297244 | 2022-02-05 | US | Texas | Robertson | 48395 | 4425 | 71 | 0 | 31.02539637 | -96.51272246 | 2022-02-06 04:21:00 | Robertson, Texas, US | |
2476339 | 2476339 | 2022-02-03 | US | North Carolina | Yancey | 37199 | 4425 | 46 | 0 | 35.90079156 | -82.31237181 | 2022-02-04 04:21:10 | Yancey, North Carolina, US | |
2658589 | 2658589 | 2022-01-31 | US | Georgia | Elbert | 13105 | 4425 | 97 | 0 | 34.11302332 | -82.83936148 | 2022-02-01 04:21:11 | Elbert, Georgia, US | |
3301181 | 3301181 | 2022-01-30 | US | Illinois | Clay | 17025 | 4425 | 62 | 0 | 38.75388572 | -88.48914513 | 2022-01-31 04:21:09 | Clay, Illinois, US | |
3062972 | 3062972 | 2022-01-29 | US | Illinois | Clay | 17025 | 4425 | 62 | 0 | 38.75388572 | -88.48914513 | 2022-01-30 04:21:26 | Clay, Illinois, US | |
3810906 | 3810906 | 2022-01-28 | US | Illinois | Clay | 17025 | 4425 | 62 | 0 | 38.75388572 | -88.48914513 | 2022-01-29 04:21:10 | Clay, Illinois, US | |
1318821 | 1318821 | 2022-01-26 | US | Colorado | Chaffee | 8015 | 4425 | 42 | 0 | 38.74745778 | -106.19265729999998 | 2022-01-27 04:21:19 | Chaffee, Colorado, US | |
3687943 | 3687943 | 2022-01-13 | US | Arkansas | Arkansas | 5001 | 4425 | 67 | 0 | 34.29145151 | -91.37277296 | 2022-01-14 04:21:54 | Arkansas, Arkansas, US | |
2612525 | 2612525 | 2022-01-06 | US | Ohio | Holmes | 39075 | 4425 | 167 | 0 | 40.56163713 | -81.92635677 | 2022-01-07 04:22:09 | Holmes, Ohio, US | |
1671370 | 1671370 | 2021-12-29 | US | South Dakota | Yankton | 46135 | 4425 | 44 | 0 | 43.00924485 | -97.39467635 | 2021-12-30 04:21:25 | Yankton, South Dakota, US | |
405556 | 405556 | 2021-12-07 | US | Kansas | Barton | 20009 | 4425 | 69 | 0 | 38.47889676 | -98.75636726 | 2021-12-08 04:22:46 | Barton, Kansas, US | |
1031638 | 1031638 | 2021-12-06 | US | Kansas | Barton | 20009 | 4425 | 69 | 0 | 38.47889676 | -98.75636726 | 2021-12-07 04:22:34 | Barton, Kansas, US | |
1234761 | 1234761 | 2021-11-28 | US | Texas | Jasper | 48241 | 4425 | 161 | 0 | 30.74685667 | -94.02667579 | 2021-11-29 04:22:30 | Jasper, Texas, US | |
1361468 | 1361468 | 2021-11-27 | US | Texas | Jasper | 48241 | 4425 | 161 | 0 | 30.74685667 | -94.02667579 | 2021-11-28 04:22:43 | Jasper, Texas, US | |
761459 | 761459 | 2021-11-26 | US | Texas | Jasper | 48241 | 4425 | 161 | 0 | 30.74685667 | -94.02667579 | 2021-11-27 04:22:45 | Jasper, Texas, US | |
1805876 | 1805876 | 2021-11-25 | US | Texas | Jasper | 48241 | 4425 | 161 | 0 | 30.74685667 | -94.02667579 | 2021-11-26 04:22:33 | Jasper, Texas, US | |
907310 | 907310 | 2021-11-24 | US | Texas | Jasper | 48241 | 4425 | 161 | 0 | 30.74685667 | -94.02667579 | 2021-11-25 04:22:33 | Jasper, Texas, US | |
3073160 | 3073160 | 2021-11-23 | US | Texas | Jasper | 48241 | 4425 | 161 | 0 | 30.74685667 | -94.02667579 | 2021-11-24 04:22:14 | Jasper, Texas, US | |
3752258 | 3752258 | 2021-11-22 | US | Texas | Jasper | 48241 | 4425 | 161 | 0 | 30.74685667 | -94.02667579 | 2021-11-23 04:22:39 | Jasper, Texas, US | |
1017465 | 1017465 | 2021-11-21 | US | Texas | Jasper | 48241 | 4425 | 161 | 0 | 30.74685667 | -94.02667579 | 2021-11-22 04:22:20 | Jasper, Texas, US | |
725629 | 725629 | 2021-11-20 | US | Texas | Jasper | 48241 | 4425 | 161 | 0 | 30.74685667 | -94.02667579 | 2021-11-21 04:22:13 | Jasper, Texas, US | |
1323306 | 1323306 | 2021-11-14 | US | Indiana | Clay | 18021 | 4425 | 60 | 0 | 39.39561833 | -87.11723506 | 2021-11-15 04:21:36 | Clay, Indiana, US | |
2848156 | 2848156 | 2021-11-10 | US | Virginia | Amherst | 51009 | 4425 | 60 | 0 | 37.60308293 | -79.14548696 | 2021-11-11 04:21:45 | Amherst, Virginia, US | |
498157 | 498157 | 2021-11-06 | US | Ohio | Pike | 39131 | 4425 | 77 | 0 | 39.07634001 | -83.06769584 | 2021-11-07 04:21:53 | Pike, Ohio, US | |
3494990 | 3494990 | 2021-10-26 | US | South Carolina | Edgefield | 45037 | 4425 | 57 | 0 | 33.77221995 | -81.96231108 | 2021-10-27 04:22:32 | Edgefield, South Carolina, US | |
3796133 | 3796133 | 2021-10-25 | US | New York | Greene | 36039 | 4425 | 87 | 0 | 42.275797 | -74.12384884 | 2021-10-26 04:22:09 | Greene, New York, US | |
598639 | 598639 | 2021-10-19 | US | Illinois | Bureau | 17011 | 4425 | 91 | 0 | 41.40385234 | -89.5283051 | 2021-10-20 04:21:00 | Bureau, Illinois, US | |
637421 | 637421 | 2021-10-13 | US | West Virginia | Mineral | 54057 | 4425 | 106 | 0 | 39.41561583 | -78.94104895 | 2021-10-14 04:21:29 | Mineral, West Virginia, US | |
3009592 | 3009592 | 2021-10-11 | US | New York | Otsego | 36077 | 4425 | 52 | 0 | 42.63492579 | -75.03151402 | 2021-10-12 04:21:09 | Otsego, New York, US | |
3449497 | 3449497 | 2021-09-10 | US | Colorado | Summit | 8117 | 4425 | 10 | 0 | 39.63803232 | -106.1150762 | 2021-09-11 04:21:30 | Summit, Colorado, US | |
249920 | 249920 | 2021-09-04 | US | Colorado | Montrose | 8085 | 4425 | 77 | 0 | 38.40214114 | -108.26390220000002 | 2021-09-05 04:21:33 | Montrose, Colorado, US | |
35194 | 35194 | 2021-08-25 | US | Puerto Rico | Toa Alta | 72135 | 4425 | 0 | 0 | 18.362406 | -66.246616 | 2021-08-26 04:21:28 | Toa Alta, Puerto Rico, US | |
3108575 | 3108575 | 2021-08-24 | US | Texas | Howard | 48227 | 4425 | 106 | 0 | 32.30621324 | -101.4356444 | 2021-08-25 04:21:41 | Howard, Texas, US | |
3167779 | 3167779 | 2021-08-23 | US | New Hampshire | Grafton | 33009 | 4425 | 29 | 0 | 43.93779815 | -71.82057197 | 2021-08-24 04:21:19 | Grafton, New Hampshire, US | |
590664 | 590664 | 2021-08-08 | US | Illinois | Randolph | 17157 | 4425 | 87 | 0 | 38.05095369 | -89.82512254 | 2021-08-09 04:21:24 | Randolph, Illinois, US | |
2204676 | 2204676 | 2021-08-07 | US | Illinois | Randolph | 17157 | 4425 | 87 | 0 | 38.05095369 | -89.82512254 | 2021-08-08 04:21:33 | Randolph, Illinois, US | |
1118626 | 1118626 | 2021-08-06 | US | Illinois | Randolph | 17157 | 4425 | 87 | 0 | 38.05095369 | -89.82512254 | 2021-08-07 04:21:30 | Randolph, Illinois, US | |
1933512 | 1933512 | 2021-07-05 | US | Indiana | DeKalb | 18033 | 4425 | 85 | 0 | 41.39804622 | -84.99906934 | 2021-07-06 04:21:32 | DeKalb, Indiana, US | |
1166243 | 1166243 | 2021-07-04 | US | Indiana | DeKalb | 18033 | 4425 | 85 | 0 | 41.39804622 | -84.99906934 | 2021-07-05 04:21:28 | DeKalb, Indiana, US | |
1496677 | 1496677 | 2021-07-03 | US | Indiana | DeKalb | 18033 | 4425 | 85 | 0 | 41.39804622 | -84.99906934 | 2021-07-04 04:21:38 | DeKalb, Indiana, US | |
2072992 | 2072992 | 2021-07-02 | US | Indiana | DeKalb | 18033 | 4425 | 85 | 0 | 41.39804622 | -84.99906934 | 2021-07-03 04:21:37 | DeKalb, Indiana, US | |
3128319 | 3128319 | 2021-06-28 | US | South Carolina | Dillon | 45033 | 4425 | 85 | 0 | 34.39007791 | -79.37741872 | 2021-06-29 04:21:28 | Dillon, South Carolina, US | |
1714558 | 1714558 | 2021-06-25 | US | New York | Fulton | 36035 | 4425 | 93 | 0 | 43.11363907 | -74.41798804 | 2021-06-26 04:21:43 | Fulton, New York, US | |
2297683 | 2297683 | 2021-06-24 | US | New York | Fulton | 36035 | 4425 | 92 | 0 | 43.11363907 | -74.41798804 | 2021-06-25 04:21:33 | Fulton, New York, US | |
2425122 | 2425122 | 2021-06-23 | US | New York | Fulton | 36035 | 4425 | 92 | 0 | 43.11363907 | -74.41798804 | 2021-06-24 04:21:55 | Fulton, New York, US | |
2423886 | 2423886 | 2021-06-23 | US | Illinois | Jefferson | 17081 | 4425 | 122 | 0 | 38.29980057 | -88.9240025 | 2021-06-24 04:21:55 | Jefferson, Illinois, 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]);