johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
39 rows where active = 3478 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 24
- Missouri 4
- Kansas 3
- Virginia 3
- Illinois 2
- Iowa 2
- Louisiana 2
- Michigan 2
- Minnesota 2
- Nebraska 2
- North Carolina 2
- Wisconsin 2
- Alabama 1
- Arizona 1
- California 1
- Indiana 1
- Kentucky 1
- North Dakota 1
- Ohio 1
- Oregon 1
- Pennsylvania 1
- Tennessee 1
- Texas 1
- Utah 1
- West Virginia 1
country_or_region 1
- US · 39 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3668153 | 3668153 | 2021-03-06 | US | California | Amador | 6005 | 3518 | 42 | 0 | 3478 | 38.44583082 | -120.65696 | 2021-03-07 05:21:54 | Amador, California, US |
1939760 | 1939760 | 2021-02-23 | US | Virginia | Charlottesville | 51540 | 3519 | 41 | 0 | 3478 | 38.03527919 | -78.48569588 | 2021-02-24 05:29:16 | Charlottesville, Virginia, US |
1939976 | 1939976 | 2021-02-23 | US | Wisconsin | Clark | 55019 | 3539 | 61 | 0 | 3478 | 44.73483377 | -90.61207486 | 2021-02-24 05:29:16 | Clark, Wisconsin, US |
184126 | 184126 | 2021-02-21 | US | Nebraska | Lincoln | 31111 | 3529 | 51 | 0 | 3478 | 41.04658298 | -100.7475374 | 2021-02-22 05:24:21 | Lincoln, Nebraska, US |
744933 | 744933 | 2021-02-20 | US | Oregon | Linn | 41043 | 3533 | 55 | 0 | 3478 | 44.48899494 | -122.5373154 | 2021-02-21 05:24:33 | Linn, Oregon, US |
3053401 | 3053401 | 2021-02-16 | US | Texas | Titus | 48449 | 3831 | 74 | 0 | 3478 | 33.21339719 | -94.96797273 | 2021-02-17 05:23:10 | Titus, Texas, US |
3053670 | 3053670 | 2021-02-16 | US | West Virginia | Ohio | 54069 | 3545 | 67 | 0 | 3478 | 40.0955451 | -80.62203992 | 2021-02-17 05:23:10 | Ohio, West Virginia, US |
2284946 | 2284946 | 2021-02-14 | US | Louisiana | St. Bernard | 22087 | 3524 | 46 | 0 | 3478 | 29.87761636 | -89.51887093 | 2021-02-15 05:24:49 | St. Bernard, Louisiana, US |
2641121 | 2641121 | 2021-02-11 | US | Virginia | Shenandoah | 51171 | 3579 | 101 | 0 | 3478 | 38.85905135 | -78.56813762 | 2021-02-12 05:23:29 | Shenandoah, Virginia, US |
1591086 | 1591086 | 2021-02-05 | US | Tennessee | Campbell | 47013 | 3577 | 51 | 0 | 3478 | 36.40355516 | -84.15108559999999 | 2021-02-06 05:23:55 | Campbell, Tennessee, US |
2484609 | 2484609 | 2021-01-28 | US | Pennsylvania | Bedford | 42009 | 3598 | 120 | 0 | 3478 | 40.00522157 | -78.48998442 | 2021-01-29 05:22:23 | Bedford, Pennsylvania, US |
2428376 | 2428376 | 2021-01-23 | US | Kentucky | Whitley | 21235 | 3492 | 14 | 0 | 3478 | 36.75700531 | -84.14541217 | 2021-01-24 05:22:35 | Whitley, Kentucky, US |
909217 | 909217 | 2021-01-19 | US | Illinois | Stephenson | 17177 | 3532 | 54 | 0 | 3478 | 42.35129217 | -89.662598 | 2021-01-20 05:21:54 | Stephenson, Illinois, US |
3517014 | 3517014 | 2021-01-15 | US | Michigan | Cass | 26027 | 3532 | 54 | 0 | 3478 | 41.91522292 | -85.99405727 | 2021-01-16 05:22:40 | Cass, Michigan, US |
3882986 | 3882986 | 2021-01-14 | US | Virginia | Washington | 51191 | 3537 | 59 | 0 | 3478 | 36.72341572 | -81.95666289 | 2021-01-15 05:22:24 | Washington, Virginia, US |
2228527 | 2228527 | 2021-01-02 | US | Illinois | Marion | 17121 | 3575 | 97 | 0 | 3478 | 38.64963204 | -88.91899208 | 2021-01-03 05:22:52 | Marion, Illinois, US |
1012041 | 1012041 | 2020-12-30 | US | Minnesota | Nobles | 27105 | 3523 | 45 | 0 | 3478 | 43.67434621 | -95.75329576 | 2020-12-31 05:22:49 | Nobles, Minnesota, US |
3763233 | 3763233 | 2020-12-28 | US | Michigan | Marquette | 26103 | 3530 | 52 | 0 | 3478 | 46.4338914 | -87.64043701 | 2020-12-29 05:22:37 | Marquette, Michigan, US |
3763353 | 3763353 | 2020-12-28 | US | Minnesota | Winona | 27169 | 3520 | 42 | 0 | 3478 | 43.98772283 | -91.78081305 | 2020-12-29 05:22:37 | Winona, Minnesota, US |
2121582 | 2121582 | 2020-12-20 | US | Missouri | Callaway | 29027 | 3495 | 17 | 0 | 3478 | 38.83674754 | -91.92186505 | 2020-12-21 05:27:58 | Callaway, Missouri, US |
2121769 | 2121769 | 2020-12-20 | US | Nebraska | Dodge | 31053 | 3518 | 40 | 0 | 3478 | 41.58071748 | -96.65598179 | 2020-12-21 05:27:58 | Dodge, Nebraska, US |
1903129 | 1903129 | 2020-12-18 | US | Missouri | Taney | 29213 | 3525 | 47 | 0 | 3478 | 36.65465345 | -93.04075153 | 2020-12-19 05:27:52 | Taney, Missouri, US |
846008 | 846008 | 2020-12-12 | US | Arizona | Gila | 4007 | 3591 | 113 | 0 | 3478 | 33.80190085 | -110.8132779 | 2020-12-13 05:27:20 | Gila, Arizona, US |
1586677 | 1586677 | 2020-11-30 | US | Ohio | Wayne | 39169 | 3581 | 103 | 0 | 3478 | 40.82925852 | -81.88844833 | 2020-12-01 05:26:18 | Wayne, Ohio, US |
3340931 | 3340931 | 2020-11-17 | US | North Carolina | Orange | 37135 | 3539 | 61 | 0 | 3478 | 36.06092947 | -79.12167935 | 2020-11-18 05:40:31 | Orange, North Carolina, US |
2081205 | 2081205 | 2020-10-31 | US | Kansas | Ford | 20057 | 3491 | 13 | 0 | 3478 | 37.69200114 | -99.88825298 | 2020-11-01 04:36:19 | Ford, Kansas, US |
2244658 | 2244658 | 2020-10-30 | US | Kansas | Ford | 20057 | 3491 | 13 | 0 | 3478 | 37.69200114 | -99.88825298 | 2020-10-31 04:24:44 | Ford, Kansas, US |
211513 | 211513 | 2020-10-29 | US | Kansas | Ford | 20057 | 3491 | 13 | 0 | 3478 | 37.69200114 | -99.88825298 | 2020-10-30 04:24:49 | Ford, Kansas, US |
755471 | 755471 | 2020-10-28 | US | Iowa | Dallas | 19049 | 3525 | 47 | 0 | 3478 | 41.68560356 | -94.04127625 | 2020-10-29 04:24:49 | Dallas, Iowa, US |
821106 | 821106 | 2020-10-09 | US | Wisconsin | La Crosse | 55063 | 3486 | 8 | 0 | 3478 | 43.90632465 | -91.11451093 | 2020-10-10 04:23:57 | La Crosse, Wisconsin, US |
3802282 | 3802282 | 2020-10-05 | US | Alabama | Morgan | 1103 | 3509 | 31 | 0 | 3478 | 34.45500589 | -86.85475946 | 2020-10-06 04:23:33 | Morgan, Alabama, US |
2838340 | 2838340 | 2020-09-21 | US | Louisiana | Terrebonne | 22109 | 3588 | 110 | 0 | 3478 | 29.37343766 | -90.82626855 | 2020-09-22 04:23:00 | Terrebonne, Louisiana, US |
3095318 | 3095318 | 2020-09-20 | US | Missouri | Jasper | 29097 | 3521 | 43 | 0 | 3478 | 37.20351921 | -94.34050458 | 2020-09-21 04:23:00 | Jasper, Missouri, US |
549018 | 549018 | 2020-09-12 | US | North Carolina | Alamance | 37001 | 3526 | 48 | 0 | 3478 | 36.0434701 | -79.39976137 | 2020-09-13 04:30:52 | Alamance, North Carolina, US |
2665036 | 2665036 | 2020-09-04 | US | Utah | Weber-Morgan | 3507 | 29 | 0 | 3478 | 41.27116049 | -111.9145117 | 2020-09-05 04:28:19 | Weber-Morgan, Utah, US | |
2062256 | 2062256 | 2020-09-01 | US | North Dakota | Cass | 38017 | 3606 | 76 | 0 | 3478 | 46.93201724 | -97.2444719 | 2020-09-02 04:28:25 | Cass, North Dakota, US |
3563644 | 3563644 | 2020-08-25 | US | Indiana | Hamilton | 18057 | 3588 | 110 | 0 | 3478 | 40.07306535 | -86.05244729 | 2020-08-26 04:28:11 | Hamilton, Indiana, US |
2738110 | 2738110 | 2020-08-03 | US | Missouri | Jackson | 29095 | 3537 | 59 | 0 | 3478 | 39.01002188 | -94.34724536 | 2020-08-04 04:41:59 | Jackson, Missouri, US |
2563457 | 2563457 | 2020-07-24 | US | Iowa | Woodbury | 19193 | 3525 | 47 | 0 | 3478 | 42.38979414 | -96.0459439 | 2020-07-25 04:47:39 | Woodbury, Iowa, 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]);