johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

6,221 rows where province_or_state = "North Dakota" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • North Dakota · 6,221

country_or_region

  • US 6,221
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391097 2020-08-08 US North Dakota Adams 38001 2 0 0 2 46.09686891 -102.5285397 2020-08-09 04:34:54 Adams, North Dakota, US
391224 2020-08-08 US North Dakota Barnes 38003 37 0 0 37 46.93579637 -98.06605978 2020-08-09 04:34:54 Barnes, North Dakota, US
391271 2020-08-08 US North Dakota Benson 38005 134 2 0 132 48.0683985 -99.35916363 2020-08-09 04:34:54 Benson, North Dakota, US
391300 2020-08-08 US North Dakota Billings 38007 2 0 0 2 47.02366884 -103.3762965 2020-08-09 04:34:54 Billings, North Dakota, US
391336 2020-08-08 US North Dakota Bottineau 38009 18 0 0 18 48.79106111 -100.8378166 2020-08-09 04:34:54 Bottineau, North Dakota, US
391342 2020-08-08 US North Dakota Bowman 38011 6 0 0 6 46.11285362 -103.5203343 2020-08-09 04:34:54 Bowman, North Dakota, US
391406 2020-08-08 US North Dakota Burke 38013 23 0 0 23 48.79094471 -102.51821170000001 2020-08-09 04:34:54 Burke, North Dakota, US
391407 2020-08-08 US North Dakota Burleigh 38015 1142 6 0 1136 46.97847375 -100.46452140000001 2020-08-09 04:34:54 Burleigh, North Dakota, US
391516 2020-08-08 US North Dakota Cass 38017 3028 76 0 2952 46.93201724 -97.24447190000001 2020-08-09 04:34:54 Cass, North Dakota, US
391527 2020-08-08 US North Dakota Cavalier 38019 31 0 0 31 48.77286211 -98.46685243 2020-08-09 04:34:54 Cavalier, North Dakota, US
391880 2020-08-08 US North Dakota Dickey 38021 12 0 0 12 46.11017712 -98.50490079999999 2020-08-09 04:34:54 Dickey, North Dakota, US
391890 2020-08-08 US North Dakota Divide 38023 2 0 0 2 48.814938700000006 -103.48736109999999 2020-08-09 04:34:54 Divide, North Dakota, US
391927 2020-08-08 US North Dakota Dunn 38025 30 0 0 30 47.35423935 -102.61604679999999 2020-08-09 04:34:54 Dunn, North Dakota, US
391946 2020-08-08 US North Dakota Eddy 38027 18 0 0 18 47.71701474 -98.90432337 2020-08-09 04:34:54 Eddy, North Dakota, US
391976 2020-08-08 US North Dakota Emmons 38029 17 1 0 16 46.28398398 -100.2389766 2020-08-09 04:34:54 Emmons, North Dakota, US
392054 2020-08-08 US North Dakota Foster 38031 25 0 0 25 47.457108399999996 -98.88279923 2020-08-09 04:34:54 Foster, North Dakota, US
392157 2020-08-08 US North Dakota Golden Valley 38033 4 0 0 4 46.94022281 -103.8465421 2020-08-09 04:34:54 Golden Valley, North Dakota, US
392175 2020-08-08 US North Dakota Grand Forks 38035 672 6 0 666 47.92093639 -97.45450447 2020-08-09 04:34:54 Grand Forks, North Dakota, US
392187 2020-08-08 US North Dakota Grant 38037 4 0 0 4 46.35821257 -101.63900129999999 2020-08-09 04:34:54 Grant, North Dakota, US
392233 2020-08-08 US North Dakota Griggs 38039 34 1 0 33 47.45785838 -98.23850925 2020-08-09 04:34:54 Griggs, North Dakota, US
392364 2020-08-08 US North Dakota Hettinger 38041 6 0 0 6 46.43375068 -102.4632417 2020-08-09 04:34:54 Hettinger, North Dakota, US
392606 2020-08-08 US North Dakota Kidder 38043 13 0 0 13 46.97830064 -99.77507857 2020-08-09 04:34:54 Kidder, North Dakota, US
392649 2020-08-08 US North Dakota LaMoure 38045 16 0 0 16 46.45681054 -98.53542355 2020-08-09 04:34:54 LaMoure, North Dakota, US
392813 2020-08-08 US North Dakota Logan 38047 7 0 0 7 46.45729487 -99.47719806 2020-08-09 04:34:54 Logan, North Dakota, US
392970 2020-08-08 US North Dakota McHenry 38049 16 1 0 15 48.23104458 -100.6324822 2020-08-09 04:34:54 McHenry, North Dakota, US
392972 2020-08-08 US North Dakota McIntosh 38051 30 2 0 28 46.11182017 -99.44145858 2020-08-09 04:34:54 McIntosh, North Dakota, US
392975 2020-08-08 US North Dakota McKenzie 38053 89 1 0 88 47.74133370000001 -103.395905 2020-08-09 04:34:54 McKenzie, North Dakota, US
392979 2020-08-08 US North Dakota McLean 38055 59 0 0 59 47.60766714 -101.3182418 2020-08-09 04:34:54 McLean, North Dakota, US
393012 2020-08-08 US North Dakota Mercer 38057 28 0 0 28 47.31213126 -101.8318399 2020-08-09 04:34:54 Mercer, North Dakota, US
393134 2020-08-08 US North Dakota Morton 38059 357 3 0 354 46.71681782 -101.2822377 2020-08-09 04:34:54 Morton, North Dakota, US
393137 2020-08-08 US North Dakota Mountrail 38061 129 1 0 128 48.20197971 -102.3555315 2020-08-09 04:34:54 Mountrail, North Dakota, US
393163 2020-08-08 US North Dakota Nelson 38063 25 0 0 25 47.9226426 -98.19038437 2020-08-09 04:34:54 Nelson, North Dakota, US
393245 2020-08-08 US North Dakota Oliver 38065 7 0 0 7 47.11530482 -101.3406158 2020-08-09 04:34:54 Oliver, North Dakota, US
393338 2020-08-08 US North Dakota Pembina 38067 27 0 0 27 48.76623521 -97.5523809 2020-08-09 04:34:54 Pembina, North Dakota, US
393383 2020-08-08 US North Dakota Pierce 38069 11 0 0 11 48.24977025 -99.96407787 2020-08-09 04:34:54 Pierce, North Dakota, US
393502 2020-08-08 US North Dakota Ramsey 38071 69 2 0 67 48.26886249 -98.72223879 2020-08-09 04:34:54 Ramsey, North Dakota, US
393513 2020-08-08 US North Dakota Ransom 38073 28 0 0 28 46.45621782 -97.65742504 2020-08-09 04:34:54 Ransom, North Dakota, US
393530 2020-08-08 US North Dakota Renville 38075 9 0 0 9 48.71982533 -101.6603912 2020-08-09 04:34:54 Renville, North Dakota, US
393540 2020-08-08 US North Dakota Richland 38077 105 1 0 104 46.26440649 -96.94852979 2020-08-09 04:34:54 Richland, North Dakota, US
393583 2020-08-08 US North Dakota Rolette 38079 61 0 0 61 48.77245354 -99.84097493 2020-08-09 04:34:54 Rolette, North Dakota, US
393661 2020-08-08 US North Dakota Sargent 38081 11 0 0 11 46.10830372 -97.63217159 2020-08-09 04:34:54 Sargent, North Dakota, US
393729 2020-08-08 US North Dakota Sheridan 38083 8 0 0 8 47.57700669 -100.3426391 2020-08-09 04:34:54 Sheridan, North Dakota, US
393745 2020-08-08 US North Dakota Sioux 38085 79 1 0 78 46.11323337 -101.04401490000001 2020-08-09 04:34:54 Sioux, North Dakota, US
393750 2020-08-08 US North Dakota Slope 38087 3 0 0 3 46.44737738 -103.4601547 2020-08-09 04:34:54 Slope, North Dakota, US
393811 2020-08-08 US North Dakota Stark 38089 259 3 0 256 46.80851182 -102.65763259999999 2020-08-09 04:34:54 Stark, North Dakota, US
393819 2020-08-08 US North Dakota Steele 38091 14 0 0 14 47.45611548 -97.72728747 2020-08-09 04:34:54 Steele, North Dakota, US
393842 2020-08-08 US North Dakota Stutsman 38093 127 2 0 125 46.97962541 -98.95637318 2020-08-09 04:34:54 Stutsman, North Dakota, US
393945 2020-08-08 US North Dakota Towner 38095 5 0 0 5 48.68565745 -99.24564265 2020-08-09 04:34:54 Towner, North Dakota, US
393947 2020-08-08 US North Dakota Traill 38097 54 0 0 54 47.45367788 -97.16323288 2020-08-09 04:34:54 Traill, North Dakota, US
394014 2020-08-08 US North Dakota Unassigned 90038 0 0 0 0 48.814938700000006 0 2020-08-09 04:34:54 Unassigned, North Dakota, US
394105 2020-08-08 US North Dakota Walsh 38099 104 0 0 104 48.36876964 -97.72574783 2020-08-09 04:34:54 Walsh, North Dakota, US
394112 2020-08-08 US North Dakota Ward 38101 221 1 0 220 48.22390169 -101.54367629999999 2020-08-09 04:34:54 Ward, North Dakota, US
394202 2020-08-08 US North Dakota Wells 38103 21 0 0 21 47.58614526 -99.65904998 2020-08-09 04:34:54 Wells, North Dakota, US
394243 2020-08-08 US North Dakota Williams 38105 269 2 0 267 48.34522353 -103.4793387 2020-08-09 04:34:54 Williams, North Dakota, US
281661 2020-08-07 US North Dakota Adams 38001 2 0 0 2 46.09686891 -102.5285397 2020-08-08 04:34:53 Adams, North Dakota, US
281788 2020-08-07 US North Dakota Barnes 38003 37 0 0 37 46.93579637 -98.06605978 2020-08-08 04:34:53 Barnes, North Dakota, US
281835 2020-08-07 US North Dakota Benson 38005 132 2 0 130 48.0683985 -99.35916363 2020-08-08 04:34:53 Benson, North Dakota, US
281864 2020-08-07 US North Dakota Billings 38007 2 0 0 2 47.02366884 -103.3762965 2020-08-08 04:34:53 Billings, North Dakota, US
281900 2020-08-07 US North Dakota Bottineau 38009 18 0 0 18 48.79106111 -100.8378166 2020-08-08 04:34:53 Bottineau, North Dakota, US
281906 2020-08-07 US North Dakota Bowman 38011 6 0 0 6 46.11285362 -103.5203343 2020-08-08 04:34:53 Bowman, North Dakota, US
281970 2020-08-07 US North Dakota Burke 38013 23 0 0 23 48.79094471 -102.51821170000001 2020-08-08 04:34:53 Burke, North Dakota, US
281971 2020-08-07 US North Dakota Burleigh 38015 1108 5 0 1103 46.97847375 -100.46452140000001 2020-08-08 04:34:53 Burleigh, North Dakota, US
282080 2020-08-07 US North Dakota Cass 38017 3006 76 0 2930 46.93201724 -97.24447190000001 2020-08-08 04:34:53 Cass, North Dakota, US
282091 2020-08-07 US North Dakota Cavalier 38019 31 0 0 31 48.77286211 -98.46685243 2020-08-08 04:34:53 Cavalier, North Dakota, US
282444 2020-08-07 US North Dakota Dickey 38021 12 0 0 12 46.11017712 -98.50490079999999 2020-08-08 04:34:53 Dickey, North Dakota, US
282454 2020-08-07 US North Dakota Divide 38023 2 0 0 2 48.814938700000006 -103.48736109999999 2020-08-08 04:34:53 Divide, North Dakota, US
282491 2020-08-07 US North Dakota Dunn 38025 30 0 0 30 47.35423935 -102.61604679999999 2020-08-08 04:34:53 Dunn, North Dakota, US
282510 2020-08-07 US North Dakota Eddy 38027 15 0 0 15 47.71701474 -98.90432337 2020-08-08 04:34:53 Eddy, North Dakota, US
282540 2020-08-07 US North Dakota Emmons 38029 17 1 0 16 46.28398398 -100.2389766 2020-08-08 04:34:53 Emmons, North Dakota, US
282618 2020-08-07 US North Dakota Foster 38031 27 0 0 27 47.457108399999996 -98.88279923 2020-08-08 04:34:53 Foster, North Dakota, US
282721 2020-08-07 US North Dakota Golden Valley 38033 4 0 0 4 46.94022281 -103.8465421 2020-08-08 04:34:53 Golden Valley, North Dakota, US
282739 2020-08-07 US North Dakota Grand Forks 38035 662 6 0 656 47.92093639 -97.45450447 2020-08-08 04:34:53 Grand Forks, North Dakota, US
282751 2020-08-07 US North Dakota Grant 38037 4 0 0 4 46.35821257 -101.63900129999999 2020-08-08 04:34:53 Grant, North Dakota, US
282797 2020-08-07 US North Dakota Griggs 38039 32 1 0 31 47.45785838 -98.23850925 2020-08-08 04:34:53 Griggs, North Dakota, US
282928 2020-08-07 US North Dakota Hettinger 38041 6 0 0 6 46.43375068 -102.4632417 2020-08-08 04:34:53 Hettinger, North Dakota, US
283170 2020-08-07 US North Dakota Kidder 38043 13 0 0 13 46.97830064 -99.77507857 2020-08-08 04:34:53 Kidder, North Dakota, US
283213 2020-08-07 US North Dakota LaMoure 38045 16 0 0 16 46.45681054 -98.53542355 2020-08-08 04:34:53 LaMoure, North Dakota, US
283377 2020-08-07 US North Dakota Logan 38047 7 0 0 7 46.45729487 -99.47719806 2020-08-08 04:34:53 Logan, North Dakota, US
283534 2020-08-07 US North Dakota McHenry 38049 16 1 0 15 48.23104458 -100.6324822 2020-08-08 04:34:53 McHenry, North Dakota, US
283536 2020-08-07 US North Dakota McIntosh 38051 27 2 0 25 46.11182017 -99.44145858 2020-08-08 04:34:53 McIntosh, North Dakota, US
283539 2020-08-07 US North Dakota McKenzie 38053 86 1 0 85 47.74133370000001 -103.395905 2020-08-08 04:34:53 McKenzie, North Dakota, US
283543 2020-08-07 US North Dakota McLean 38055 51 0 0 51 47.60766714 -101.3182418 2020-08-08 04:34:53 McLean, North Dakota, US
283576 2020-08-07 US North Dakota Mercer 38057 26 0 0 26 47.31213126 -101.8318399 2020-08-08 04:34:53 Mercer, North Dakota, US
283698 2020-08-07 US North Dakota Morton 38059 333 3 0 330 46.71681782 -101.2822377 2020-08-08 04:34:53 Morton, North Dakota, US
283701 2020-08-07 US North Dakota Mountrail 38061 123 1 0 122 48.20197971 -102.3555315 2020-08-08 04:34:53 Mountrail, North Dakota, US
283727 2020-08-07 US North Dakota Nelson 38063 24 0 0 24 47.9226426 -98.19038437 2020-08-08 04:34:53 Nelson, North Dakota, US
283809 2020-08-07 US North Dakota Oliver 38065 7 0 0 7 47.11530482 -101.3406158 2020-08-08 04:34:53 Oliver, North Dakota, US
283902 2020-08-07 US North Dakota Pembina 38067 27 0 0 27 48.76623521 -97.5523809 2020-08-08 04:34:53 Pembina, North Dakota, US
283947 2020-08-07 US North Dakota Pierce 38069 11 0 0 11 48.24977025 -99.96407787 2020-08-08 04:34:53 Pierce, North Dakota, US
284066 2020-08-07 US North Dakota Ramsey 38071 66 2 0 64 48.26886249 -98.72223879 2020-08-08 04:34:53 Ramsey, North Dakota, US
284077 2020-08-07 US North Dakota Ransom 38073 27 0 0 27 46.45621782 -97.65742504 2020-08-08 04:34:53 Ransom, North Dakota, US
284094 2020-08-07 US North Dakota Renville 38075 9 0 0 9 48.71982533 -101.6603912 2020-08-08 04:34:53 Renville, North Dakota, US
284104 2020-08-07 US North Dakota Richland 38077 104 0 0 104 46.26440649 -96.94852979 2020-08-08 04:34:53 Richland, North Dakota, US
284147 2020-08-07 US North Dakota Rolette 38079 52 0 0 52 48.77245354 -99.84097493 2020-08-08 04:34:53 Rolette, North Dakota, US
284225 2020-08-07 US North Dakota Sargent 38081 11 0 0 11 46.10830372 -97.63217159 2020-08-08 04:34:53 Sargent, North Dakota, US
284293 2020-08-07 US North Dakota Sheridan 38083 8 0 0 8 47.57700669 -100.3426391 2020-08-08 04:34:53 Sheridan, North Dakota, US
284309 2020-08-07 US North Dakota Sioux 38085 63 1 0 62 46.11323337 -101.04401490000001 2020-08-08 04:34:53 Sioux, North Dakota, US
284314 2020-08-07 US North Dakota Slope 38087 3 0 0 3 46.44737738 -103.4601547 2020-08-08 04:34:53 Slope, North Dakota, US
284375 2020-08-07 US North Dakota Stark 38089 248 3 0 245 46.80851182 -102.65763259999999 2020-08-08 04:34:53 Stark, North Dakota, US
284383 2020-08-07 US North Dakota Steele 38091 14 0 0 14 47.45611548 -97.72728747 2020-08-08 04:34:53 Steele, North Dakota, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);
Powered by Datasette · Query took 1364.769ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette