daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
102,044 rows where province_or_state = "North Carolina" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-07-23 | US | North Carolina | Alleghany | 37005 | 55 | 0 | 0 | 55 | 36.49360862 | -81.12857041 | 2020-07-24 05:30:40 | Alleghany, North Carolina, US |
2020-07-23 | US | North Carolina | Avery | 37011 | 65 | 0 | 0 | 65 | 36.07569796 | -81.92308483 | 2020-07-24 05:30:40 | Avery, North Carolina, US |
2020-07-23 | US | North Carolina | Chowan | 37041 | 72 | 0 | 0 | 72 | 36.12908077 | -76.60118385 | 2020-07-24 05:30:40 | Chowan, North Carolina, US |
2020-07-23 | US | North Carolina | Clay | 37043 | 44 | 0 | 0 | 44 | 35.05704275 | -83.74353633 | 2020-07-24 05:30:40 | Clay, North Carolina, US |
2020-07-23 | US | North Carolina | Currituck | 37053 | 57 | 0 | 0 | 57 | 36.36123664 | -75.95876401 | 2020-07-24 05:30:40 | Currituck, North Carolina, US |
2020-07-23 | US | North Carolina | Graham | 37075 | 17 | 0 | 0 | 17 | 35.3506925 | -83.83369267 | 2020-07-24 05:30:40 | Graham, North Carolina, US |
2020-07-23 | US | North Carolina | Haywood | 37087 | 200 | 0 | 0 | 200 | 35.55269063 | -82.98196486 | 2020-07-24 05:30:40 | Haywood, North Carolina, US |
2020-07-23 | US | North Carolina | Hyde | 37095 | 35 | 0 | 0 | 35 | 35.42017674 | -76.15180542 | 2020-07-24 05:30:40 | Hyde, North Carolina, US |
2020-07-23 | US | North Carolina | Madison | 37115 | 27 | 0 | 0 | 27 | 35.85402722 | -82.71346418 | 2020-07-24 05:30:40 | Madison, North Carolina, US |
2020-07-23 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2020-07-24 05:30:40 | Unassigned, North Carolina, US |
2020-07-23 | US | North Carolina | Watauga | 37189 | 203 | 0 | 0 | 203 | 36.23103603 | -81.70033724 | 2020-07-24 05:30:40 | Watauga, North Carolina, US |
2020-07-23 | US | North Carolina | Yancey | 37199 | 92 | 0 | 0 | 92 | 35.90079156 | -82.31237181 | 2020-07-24 05:30:40 | Yancey, North Carolina, US |
2022-11-12 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2022-11-13 04:21:14 | Unassigned, North Carolina, US | |
2021-09-01 | US | North Carolina | Unassigned | 90037 | 1 | 0 | 0 | 36.49360862 | 0.0 | 2021-09-02 04:21:15 | Unassigned, North Carolina, US | |
2022-02-07 | US | North Carolina | Unassigned | 90037 | 1306 | 0 | 0 | 36.49360862 | 0.0 | 2022-02-08 04:21:15 | Unassigned, North Carolina, US | |
2020-12-03 | US | North Carolina | Unassigned | 90037 | 160 | 0 | 0 | 160 | 36.49360862 | 0.0 | 2020-12-04 05:27:27 | Unassigned, North Carolina, US |
2020-10-14 | US | North Carolina | Avery | 37011 | 475 | 0 | 0 | 475 | 36.07569796 | -81.92308483 | 2020-10-15 04:24:28 | Avery, North Carolina, US |
2020-10-14 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2020-10-15 04:24:28 | Unassigned, North Carolina, US |
2020-10-14 | US | North Carolina | Yancey | 37199 | 238 | 0 | 0 | 238 | 35.90079156 | -82.31237181 | 2020-10-15 04:24:28 | Yancey, North Carolina, US |
2021-05-25 | US | North Carolina | Unassigned | 90037 | 1 | 0 | 0 | 36.49360862 | 0.0 | 2021-05-26 04:20:35 | Unassigned, North Carolina, US | |
2021-11-09 | US | North Carolina | Unassigned | 90037 | 1 | 0 | 0 | 36.49360862 | 0.0 | 2021-11-10 04:21:38 | Unassigned, North Carolina, US | |
2022-07-23 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2022-07-24 04:20:47 | Unassigned, North Carolina, US | |
2020-08-04 | US | North Carolina | Alleghany | 37005 | 165 | 0 | 0 | 165 | 36.49360862 | -81.12857041 | 2020-08-05 04:34:43 | Alleghany, North Carolina, US |
2020-08-04 | US | North Carolina | Avery | 37011 | 99 | 0 | 0 | 99 | 36.07569796 | -81.92308483 | 2020-08-05 04:34:43 | Avery, North Carolina, US |
2020-08-04 | US | North Carolina | Clay | 37043 | 76 | 0 | 0 | 76 | 35.05704275 | -83.74353633 | 2020-08-05 04:34:43 | Clay, North Carolina, US |
2020-08-04 | US | North Carolina | Currituck | 37053 | 71 | 0 | 0 | 71 | 36.36123664 | -75.95876401 | 2020-08-05 04:34:43 | Currituck, North Carolina, US |
2020-08-04 | US | North Carolina | Graham | 37075 | 29 | 0 | 0 | 29 | 35.3506925 | -83.83369267 | 2020-08-05 04:34:43 | Graham, North Carolina, US |
2020-08-04 | US | North Carolina | Hyde | 37095 | 37 | 0 | 0 | 37 | 35.42017674 | -76.15180542 | 2020-08-05 04:34:43 | Hyde, North Carolina, US |
2020-08-04 | US | North Carolina | Madison | 37115 | 41 | 0 | 0 | 41 | 35.85402722 | -82.71346418 | 2020-08-05 04:34:43 | Madison, North Carolina, US |
2020-08-04 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2020-08-05 04:34:43 | Unassigned, North Carolina, US |
2020-08-04 | US | North Carolina | Watauga | 37189 | 283 | 0 | 0 | 283 | 36.23103603 | -81.70033724 | 2020-08-05 04:34:43 | Watauga, North Carolina, US |
2020-08-04 | US | North Carolina | Yancey | 37199 | 101 | 0 | 0 | 101 | 35.90079156 | -82.31237181 | 2020-08-05 04:34:43 | Yancey, North Carolina, US |
2022-01-14 | US | North Carolina | Unassigned | 90037 | 12366 | 0 | 0 | 36.49360862 | 0.0 | 2022-01-15 04:21:07 | Unassigned, North Carolina, US | |
2021-08-15 | US | North Carolina | Unassigned | 90037 | 108 | 0 | 0 | 36.49360862 | 0.0 | 2021-08-16 04:21:31 | Unassigned, North Carolina, US | |
2021-06-19 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2021-06-20 04:21:48 | Unassigned, North Carolina, US | |
2020-05-08 | US | North Carolina | Alexander | 37003 | 8 | 0 | 0 | 8 | 35.922379600000006 | -81.17751948 | 2020-05-09 02:32:35 | Alexander, North Carolina, US |
2020-05-08 | US | North Carolina | Alleghany | 37005 | 7 | 0 | 0 | 7 | 36.49360862 | -81.12857041 | 2020-05-09 02:32:35 | Alleghany, North Carolina, US |
2020-05-08 | US | North Carolina | Anson | 37007 | 37 | 0 | 0 | 37 | 34.97403241 | -80.09953279 | 2020-05-09 02:32:35 | Anson, North Carolina, US |
2020-05-08 | US | North Carolina | Ashe | 37009 | 7 | 0 | 0 | 7 | 36.43296207 | -81.49862729 | 2020-05-09 02:32:35 | Ashe, North Carolina, US |
2020-05-08 | US | North Carolina | Beaufort | 37013 | 24 | 0 | 0 | 24 | 35.48531943 | -76.84325809 | 2020-05-09 02:32:35 | Beaufort, North Carolina, US |
2020-05-08 | US | North Carolina | Bladen | 37017 | 50 | 0 | 0 | 50 | 34.61296243 | -78.56180059 | 2020-05-09 02:32:35 | Bladen, North Carolina, US |
2020-05-08 | US | North Carolina | Caldwell | 37027 | 52 | 0 | 0 | 52 | 35.95204977 | -81.54799522 | 2020-05-09 02:32:35 | Caldwell, North Carolina, US |
2020-05-08 | US | North Carolina | Camden | 37029 | 2 | 0 | 0 | 2 | 36.33804939 | -76.15568396 | 2020-05-09 02:32:35 | Camden, North Carolina, US |
2020-05-08 | US | North Carolina | Caswell | 37033 | 38 | 0 | 0 | 38 | 36.39312665 | -79.33353281 | 2020-05-09 02:32:35 | Caswell, North Carolina, US |
2020-05-08 | US | North Carolina | Chowan | 37041 | 8 | 0 | 0 | 8 | 36.12908077 | -76.60118385 | 2020-05-09 02:32:35 | Chowan, North Carolina, US |
2020-05-08 | US | North Carolina | Clay | 37043 | 6 | 0 | 0 | 6 | 35.05704275 | -83.74353633 | 2020-05-09 02:32:35 | Clay, North Carolina, US |
2020-05-08 | US | North Carolina | Currituck | 37053 | 9 | 0 | 0 | 9 | 36.36123664 | -75.95876401 | 2020-05-09 02:32:35 | Currituck, North Carolina, US |
2020-05-08 | US | North Carolina | Gates | 37073 | 10 | 0 | 0 | 10 | 36.44667547 | -76.69749701 | 2020-05-09 02:32:35 | Gates, North Carolina, US |
2020-05-08 | US | North Carolina | Graham | 37075 | 2 | 0 | 0 | 2 | 35.3506925 | -83.83369267 | 2020-05-09 02:32:35 | Graham, North Carolina, US |
2020-05-08 | US | North Carolina | Greene | 37079 | 34 | 0 | 0 | 34 | 35.48544173 | -77.67578087 | 2020-05-09 02:32:35 | Greene, North Carolina, US |
2020-05-08 | US | North Carolina | Haywood | 37087 | 18 | 0 | 0 | 18 | 35.55269063 | -82.98196486 | 2020-05-09 02:32:35 | Haywood, North Carolina, US |
2020-05-08 | US | North Carolina | Hoke | 37093 | 117 | 0 | 0 | 117 | 35.01888303 | -79.23651674 | 2020-05-09 02:32:35 | Hoke, North Carolina, US |
2020-05-08 | US | North Carolina | Hyde | 37095 | 1 | 0 | 0 | 1 | 35.42017674 | -76.15180542 | 2020-05-09 02:32:35 | Hyde, North Carolina, US |
2020-05-08 | US | North Carolina | Jackson | 37099 | 21 | 0 | 0 | 21 | 35.28814273 | -83.14093385 | 2020-05-09 02:32:35 | Jackson, North Carolina, US |
2020-05-08 | US | North Carolina | Lincoln | 37109 | 39 | 0 | 0 | 39 | 35.48508185 | -81.21740317 | 2020-05-09 02:32:35 | Lincoln, North Carolina, US |
2020-05-08 | US | North Carolina | Madison | 37115 | 1 | 0 | 0 | 1 | 35.85402722 | -82.71346418 | 2020-05-09 02:32:35 | Madison, North Carolina, US |
2020-05-08 | US | North Carolina | Mitchell | 37121 | 5 | 0 | 0 | 5 | 36.01059309 | -82.1582442 | 2020-05-09 02:32:35 | Mitchell, North Carolina, US |
2020-05-08 | US | North Carolina | Pamlico | 37137 | 8 | 0 | 0 | 8 | 35.15253315 | -76.66559823 | 2020-05-09 02:32:35 | Pamlico, North Carolina, US |
2020-05-08 | US | North Carolina | Perquimans | 37143 | 14 | 0 | 0 | 14 | 36.17847453 | -76.40603143 | 2020-05-09 02:32:35 | Perquimans, North Carolina, US |
2020-05-08 | US | North Carolina | Polk | 37149 | 31 | 0 | 0 | 31 | 35.27820615 | -82.16812354 | 2020-05-09 02:32:35 | Polk, North Carolina, US |
2020-05-08 | US | North Carolina | Scotland | 37165 | 36 | 0 | 0 | 36 | 34.8386299 | -79.4757978 | 2020-05-09 02:32:35 | Scotland, North Carolina, US |
2020-05-08 | US | North Carolina | Stokes | 37169 | 11 | 0 | 0 | 11 | 36.4017975 | -80.23893369 | 2020-05-09 02:32:35 | Stokes, North Carolina, US |
2020-05-08 | US | North Carolina | Surry | 37171 | 30 | 0 | 0 | 30 | 36.41689489 | -80.69102283 | 2020-05-09 02:32:35 | Surry, North Carolina, US |
2020-05-08 | US | North Carolina | Swain | 37173 | 5 | 0 | 0 | 5 | 35.48665845 | -83.48748932 | 2020-05-09 02:32:35 | Swain, North Carolina, US |
2020-05-08 | US | North Carolina | Transylvania | 37175 | 8 | 0 | 0 | 8 | 35.20383864 | -82.79638423 | 2020-05-09 02:32:35 | Transylvania, North Carolina, US |
2020-05-08 | US | North Carolina | Tyrrell | 37177 | 4 | 0 | 0 | 4 | 35.87147226 | -76.17055253 | 2020-05-09 02:32:35 | Tyrrell, North Carolina, US |
2020-05-08 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2020-05-09 02:32:35 | Unassigned, North Carolina, US |
2020-05-08 | US | North Carolina | Warren | 37185 | 22 | 0 | 0 | 22 | 36.39728256 | -78.10652228 | 2020-05-09 02:32:35 | Warren, North Carolina, US |
2020-05-08 | US | North Carolina | Watauga | 37189 | 9 | 0 | 0 | 9 | 36.23103603 | -81.70033724 | 2020-05-09 02:32:35 | Watauga, North Carolina, US |
2020-05-08 | US | North Carolina | Yancey | 37199 | 7 | 0 | 0 | 7 | 35.90079156 | -82.31237181 | 2020-05-09 02:32:35 | Yancey, North Carolina, US |
2022-09-06 | US | North Carolina | Unassigned | 90037 | 1 | 0 | 0 | 36.49360862 | 0.0 | 2022-09-07 04:20:59 | Unassigned, North Carolina, US | |
2020-07-19 | US | North Carolina | Alleghany | 37005 | 53 | 0 | 0 | 53 | 36.49360862 | -81.12857041 | 2020-07-20 05:34:40 | Alleghany, North Carolina, US |
2020-07-19 | US | North Carolina | Avery | 37011 | 51 | 0 | 0 | 51 | 36.07569796 | -81.92308483 | 2020-07-20 05:34:40 | Avery, North Carolina, US |
2020-07-19 | US | North Carolina | Beaufort | 37013 | 197 | 0 | 0 | 197 | 35.48531943 | -76.84325809 | 2020-07-20 05:34:40 | Beaufort, North Carolina, US |
2020-07-19 | US | North Carolina | Chowan | 37041 | 51 | 0 | 0 | 51 | 36.12908077 | -76.60118385 | 2020-07-20 05:34:40 | Chowan, North Carolina, US |
2020-07-19 | US | North Carolina | Clay | 37043 | 31 | 0 | 0 | 31 | 35.05704275 | -83.74353633 | 2020-07-20 05:34:40 | Clay, North Carolina, US |
2020-07-19 | US | North Carolina | Currituck | 37053 | 48 | 0 | 0 | 48 | 36.36123664 | -75.95876401 | 2020-07-20 05:34:40 | Currituck, North Carolina, US |
2020-07-19 | US | North Carolina | Graham | 37075 | 10 | 0 | 0 | 10 | 35.3506925 | -83.83369267 | 2020-07-20 05:34:40 | Graham, North Carolina, US |
2020-07-19 | US | North Carolina | Haywood | 37087 | 171 | 0 | 0 | 171 | 35.55269063 | -82.98196486 | 2020-07-20 05:34:40 | Haywood, North Carolina, US |
2020-07-19 | US | North Carolina | Hyde | 37095 | 33 | 0 | 0 | 33 | 35.42017674 | -76.15180542 | 2020-07-20 05:34:40 | Hyde, North Carolina, US |
2020-07-19 | US | North Carolina | Madison | 37115 | 22 | 0 | 0 | 22 | 35.85402722 | -82.71346418 | 2020-07-20 05:34:40 | Madison, North Carolina, US |
2020-07-19 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2020-07-20 05:34:40 | Unassigned, North Carolina, US |
2020-07-19 | US | North Carolina | Watauga | 37189 | 176 | 0 | 0 | 176 | 36.23103603 | -81.70033724 | 2020-07-20 05:34:40 | Watauga, North Carolina, US |
2020-07-19 | US | North Carolina | Yancey | 37199 | 67 | 0 | 0 | 67 | 35.90079156 | -82.31237181 | 2020-07-20 05:34:40 | Yancey, North Carolina, US |
2020-11-18 | US | North Carolina | Unassigned | 90037 | 6 | 0 | 0 | 6 | 36.49360862 | 0.0 | 2020-11-19 05:25:23 | Unassigned, North Carolina, US |
2022-01-09 | US | North Carolina | Unassigned | 90037 | 3783 | 0 | 0 | 36.49360862 | 0.0 | 2022-01-10 04:22:07 | Unassigned, North Carolina, US | |
2022-10-04 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2022-10-05 04:23:06 | Unassigned, North Carolina, US | |
2020-04-29 | US | North Carolina | Alexander | 37003 | 4 | 0 | 0 | 4 | 35.922379600000006 | -81.17751948 | 2020-04-30 02:32:27 | Alexander, North Carolina, US |
2020-04-29 | US | North Carolina | Alleghany | 37005 | 2 | 0 | 0 | 2 | 36.49360862 | -81.12857041 | 2020-04-30 02:32:27 | Alleghany, North Carolina, US |
2020-04-29 | US | North Carolina | Anson | 37007 | 24 | 0 | 0 | 24 | 34.97403241 | -80.09953279 | 2020-04-30 02:32:27 | Anson, North Carolina, US |
2020-04-29 | US | North Carolina | Ashe | 37009 | 5 | 0 | 0 | 5 | 36.43296207 | -81.49862729 | 2020-04-30 02:32:27 | Ashe, North Carolina, US |
2020-04-29 | US | North Carolina | Beaufort | 37013 | 22 | 0 | 0 | 22 | 35.48531943 | -76.84325809 | 2020-04-30 02:32:27 | Beaufort, North Carolina, US |
2020-04-29 | US | North Carolina | Bladen | 37017 | 20 | 0 | 0 | 20 | 34.61296243 | -78.56180059 | 2020-04-30 02:32:27 | Bladen, North Carolina, US |
2020-04-29 | US | North Carolina | Caldwell | 37027 | 33 | 0 | 0 | 33 | 35.95204977 | -81.54799522 | 2020-04-30 02:32:27 | Caldwell, North Carolina, US |
2020-04-29 | US | North Carolina | Camden | 37029 | 1 | 0 | 0 | 1 | 36.33804939 | -76.15568396 | 2020-04-30 02:32:27 | Camden, North Carolina, US |
2020-04-29 | US | North Carolina | Caswell | 37033 | 19 | 0 | 0 | 19 | 36.39312665 | -79.33353281 | 2020-04-30 02:32:27 | Caswell, North Carolina, US |
2020-04-29 | US | North Carolina | Chowan | 37041 | 7 | 0 | 0 | 7 | 36.12908077 | -76.60118385 | 2020-04-30 02:32:27 | Chowan, North Carolina, US |
2020-04-29 | US | North Carolina | Clay | 37043 | 6 | 0 | 0 | 6 | 35.05704275 | -83.74353633 | 2020-04-30 02:32:27 | Clay, North Carolina, US |
2020-04-29 | US | North Carolina | Currituck | 37053 | 5 | 0 | 0 | 5 | 36.36123664 | -75.95876401 | 2020-04-30 02:32:27 | Currituck, North Carolina, US |
2020-04-29 | US | North Carolina | Duplin | 37061 | 78 | 0 | 0 | 78 | 34.93449805 | -77.93140529 | 2020-04-30 02:32:27 | Duplin, North Carolina, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;