⚠️ 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

17,452 rows where province_or_state = "North Dakota" sorted by day descending

View and edit SQL

province_or_state

  • North Dakota · 17,452

country_or_region

  • US 17,452
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
903058 2021-03-04 US North Dakota Adams 38001 266 3 0 263 46.09686891 -102.5285397 2021-03-05 05:26:29 Adams, North Dakota, US
903059 2021-03-04 US North Dakota Barnes 38003 1298 31 0 1267 46.93579637 -98.06605978 2021-03-05 05:26:29 Barnes, North Dakota, US
903060 2021-03-04 US North Dakota Benson 38005 1029 18 0 1011 48.0683985 -99.35916363 2021-03-05 05:26:29 Benson, North Dakota, US
903061 2021-03-04 US North Dakota Billings 38007 53 0 0 53 47.02366884 -103.3762965 2021-03-05 05:26:29 Billings, North Dakota, US
903062 2021-03-04 US North Dakota Bottineau 38009 688 20 0 668 48.79106111 -100.8378166 2021-03-05 05:26:29 Bottineau, North Dakota, US
903063 2021-03-04 US North Dakota Bowman 38011 392 5 0 387 46.11285362 -103.5203343 2021-03-05 05:26:29 Bowman, North Dakota, US
903064 2021-03-04 US North Dakota Burke 38013 224 1 0 223 48.79094471 -102.5182117 2021-03-05 05:26:29 Burke, North Dakota, US
903065 2021-03-04 US North Dakota Burleigh 38015 14679 186 0 14493 46.97847375 -100.4645214 2021-03-05 05:26:29 Burleigh, North Dakota, US
903066 2021-03-04 US North Dakota Cass 38017 21463 196 0 21267 46.93201724 -97.2444719 2021-03-05 05:26:29 Cass, North Dakota, US
903067 2021-03-04 US North Dakota Cavalier 38019 416 5 0 411 48.77286211 -98.46685243 2021-03-05 05:26:29 Cavalier, North Dakota, US
903068 2021-03-04 US North Dakota Dickey 38021 737 32 0 705 46.11017712 -98.5049008 2021-03-05 05:26:29 Dickey, North Dakota, US
903069 2021-03-04 US North Dakota Divide 38023 164 2 0 162 48.814938700000006 -103.4873611 2021-03-05 05:26:29 Divide, North Dakota, US
903070 2021-03-04 US North Dakota Dunn 38025 366 7 0 359 47.35423935 -102.6160468 2021-03-05 05:26:29 Dunn, North Dakota, US
903071 2021-03-04 US North Dakota Eddy 38027 459 6 0 453 47.71701474 -98.90432337 2021-03-05 05:26:29 Eddy, North Dakota, US
903072 2021-03-04 US North Dakota Emmons 38029 407 12 0 395 46.28398398 -100.2389766 2021-03-05 05:26:29 Emmons, North Dakota, US
903073 2021-03-04 US North Dakota Foster 38031 567 19 0 548 47.4571084 -98.88279923 2021-03-05 05:26:29 Foster, North Dakota, US
903074 2021-03-04 US North Dakota Golden Valley 38033 247 2 0 245 46.94022281 -103.8465421 2021-03-05 05:26:29 Golden Valley, North Dakota, US
903075 2021-03-04 US North Dakota Grand Forks 38035 9824 76 0 9748 47.92093639 -97.45450447 2021-03-05 05:26:29 Grand Forks, North Dakota, US
903076 2021-03-04 US North Dakota Grant 38037 184 7 0 177 46.35821257 -101.6390013 2021-03-05 05:26:29 Grant, North Dakota, US
903077 2021-03-04 US North Dakota Griggs 38039 307 2 0 305 47.45785838 -98.23850925 2021-03-05 05:26:29 Griggs, North Dakota, US
903078 2021-03-04 US North Dakota Hettinger 38041 319 4 0 315 46.43375068 -102.4632417 2021-03-05 05:26:29 Hettinger, North Dakota, US
903079 2021-03-04 US North Dakota Kidder 38043 256 10 0 246 46.97830064 -99.77507857 2021-03-05 05:26:29 Kidder, North Dakota, US
903080 2021-03-04 US North Dakota LaMoure 38045 497 17 0 480 46.45681054 -98.53542355 2021-03-05 05:26:29 LaMoure, North Dakota, US
903081 2021-03-04 US North Dakota Logan 38047 219 8 0 211 46.45729487 -99.47719806 2021-03-05 05:26:29 Logan, North Dakota, US
903082 2021-03-04 US North Dakota McHenry 38049 601 21 0 580 48.23104458 -100.6324822 2021-03-05 05:26:29 McHenry, North Dakota, US
903083 2021-03-04 US North Dakota McIntosh 38051 323 7 0 316 46.11182017 -99.44145858 2021-03-05 05:26:29 McIntosh, North Dakota, US
903084 2021-03-04 US North Dakota McKenzie 38053 1166 12 0 1154 47.74133370000001 -103.395905 2021-03-05 05:26:29 McKenzie, North Dakota, US
903085 2021-03-04 US North Dakota McLean 38055 1212 31 0 1181 47.60766714 -101.3182418 2021-03-05 05:26:29 McLean, North Dakota, US
903086 2021-03-04 US North Dakota Mercer 38057 1073 9 0 1064 47.31213126 -101.8318399 2021-03-05 05:26:29 Mercer, North Dakota, US
903087 2021-03-04 US North Dakota Morton 38059 4948 94 0 4854 46.71681782 -101.2822377 2021-03-05 05:26:29 Morton, North Dakota, US
903088 2021-03-04 US North Dakota Mountrail 38061 1273 17 0 1256 48.20197971 -102.3555315 2021-03-05 05:26:29 Mountrail, North Dakota, US
903089 2021-03-04 US North Dakota Nelson 38063 447 13 0 434 47.9226426 -98.19038437 2021-03-05 05:26:29 Nelson, North Dakota, US
903090 2021-03-04 US North Dakota Oliver 38065 153 2 0 151 47.11530482 -101.3406158 2021-03-05 05:26:29 Oliver, North Dakota, US
903091 2021-03-04 US North Dakota Pembina 38067 752 11 0 741 48.76623521 -97.5523809 2021-03-05 05:26:29 Pembina, North Dakota, US
903092 2021-03-04 US North Dakota Pierce 38069 524 24 0 500 48.24977025 -99.96407787 2021-03-05 05:26:29 Pierce, North Dakota, US
903093 2021-03-04 US North Dakota Ramsey 38071 1611 30 0 1581 48.26886249 -98.72223879 2021-03-05 05:26:29 Ramsey, North Dakota, US
903094 2021-03-04 US North Dakota Ransom 38073 618 16 0 602 46.45621782 -97.65742504 2021-03-05 05:26:29 Ransom, North Dakota, US
903095 2021-03-04 US North Dakota Renville 38075 305 13 0 292 48.71982533 -101.6603912 2021-03-05 05:26:29 Renville, North Dakota, US
903096 2021-03-04 US North Dakota Richland 38077 1771 16 0 1755 46.26440649 -96.94852979 2021-03-05 05:26:29 Richland, North Dakota, US
903097 2021-03-04 US North Dakota Rolette 38079 2123 28 0 2095 48.77245354 -99.84097493 2021-03-05 05:26:29 Rolette, North Dakota, US
903098 2021-03-04 US North Dakota Sargent 38081 429 6 0 423 46.10830372 -97.63217159 2021-03-05 05:26:29 Sargent, North Dakota, US
903099 2021-03-04 US North Dakota Sheridan 38083 103 2 0 101 47.57700669 -100.3426391 2021-03-05 05:26:29 Sheridan, North Dakota, US
903100 2021-03-04 US North Dakota Sioux 38085 641 11 0 630 46.11323337 -101.0440149 2021-03-05 05:26:29 Sioux, North Dakota, US
903101 2021-03-04 US North Dakota Slope 38087 31 0 0 31 46.44737738 -103.4601547 2021-03-05 05:26:29 Slope, North Dakota, US
903102 2021-03-04 US North Dakota Stark 38089 4396 49 0 4347 46.80851182 -102.6576326 2021-03-05 05:26:29 Stark, North Dakota, US
903103 2021-03-04 US North Dakota Steele 38091 172 2 0 170 47.45611548 -97.72728747 2021-03-05 05:26:29 Steele, North Dakota, US
903104 2021-03-04 US North Dakota Stutsman 38093 3286 79 0 3207 46.97962541 -98.95637318 2021-03-05 05:26:29 Stutsman, North Dakota, US
903105 2021-03-04 US North Dakota Towner 38095 300 11 0 289 48.68565745 -99.24564265 2021-03-05 05:26:29 Towner, North Dakota, US
903106 2021-03-04 US North Dakota Traill 38097 987 18 0 969 47.45367788 -97.16323288 2021-03-05 05:26:29 Traill, North Dakota, US
903107 2021-03-04 US North Dakota Unassigned 90038 0 30 0 -30 48.814938700000006 0.0 2021-03-05 05:26:29 Unassigned, North Dakota, US
903108 2021-03-04 US North Dakota Walsh 38099 1761 24 0 1737 48.36876964 -97.72574783 2021-03-05 05:26:29 Walsh, North Dakota, US
903109 2021-03-04 US North Dakota Ward 38101 9193 189 0 9004 48.22390169 -101.5436763 2021-03-05 05:26:29 Ward, North Dakota, US
903110 2021-03-04 US North Dakota Wells 38103 428 8 0 420 47.58614526 -99.65904998 2021-03-05 05:26:29 Wells, North Dakota, US
903111 2021-03-04 US North Dakota Williams 38105 4496 36 0 4460 48.34522353 -103.4793387 2021-03-05 05:26:29 Williams, North Dakota, US
910783 2021-03-03 US North Dakota Adams 38001 266 3 0 263 46.09686891 -102.5285397 2021-03-04 05:24:24 Adams, North Dakota, US
910784 2021-03-03 US North Dakota Barnes 38003 1296 31 0 1265 46.93579637 -98.06605978 2021-03-04 05:24:24 Barnes, North Dakota, US
910785 2021-03-03 US North Dakota Benson 38005 1029 18 0 1011 48.0683985 -99.35916363 2021-03-04 05:24:24 Benson, North Dakota, US
910786 2021-03-03 US North Dakota Billings 38007 53 0 0 53 47.02366884 -103.3762965 2021-03-04 05:24:24 Billings, North Dakota, US
910787 2021-03-03 US North Dakota Bottineau 38009 687 20 0 667 48.79106111 -100.8378166 2021-03-04 05:24:24 Bottineau, North Dakota, US
910788 2021-03-03 US North Dakota Bowman 38011 390 5 0 385 46.11285362 -103.5203343 2021-03-04 05:24:24 Bowman, North Dakota, US
910789 2021-03-03 US North Dakota Burke 38013 222 1 0 221 48.79094471 -102.5182117 2021-03-04 05:24:24 Burke, North Dakota, US
910790 2021-03-03 US North Dakota Burleigh 38015 14673 186 0 14487 46.97847375 -100.4645214 2021-03-04 05:24:24 Burleigh, North Dakota, US
910791 2021-03-03 US North Dakota Cass 38017 21430 196 0 21234 46.93201724 -97.2444719 2021-03-04 05:24:24 Cass, North Dakota, US
910792 2021-03-03 US North Dakota Cavalier 38019 416 5 0 411 48.77286211 -98.46685243 2021-03-04 05:24:24 Cavalier, North Dakota, US
910793 2021-03-03 US North Dakota Dickey 38021 736 32 0 704 46.11017712 -98.5049008 2021-03-04 05:24:24 Dickey, North Dakota, US
910794 2021-03-03 US North Dakota Divide 38023 163 2 0 161 48.814938700000006 -103.4873611 2021-03-04 05:24:24 Divide, North Dakota, US
910795 2021-03-03 US North Dakota Dunn 38025 365 7 0 358 47.35423935 -102.6160468 2021-03-04 05:24:24 Dunn, North Dakota, US
910796 2021-03-03 US North Dakota Eddy 38027 458 6 0 452 47.71701474 -98.90432337 2021-03-04 05:24:24 Eddy, North Dakota, US
910797 2021-03-03 US North Dakota Emmons 38029 407 12 0 395 46.28398398 -100.2389766 2021-03-04 05:24:24 Emmons, North Dakota, US
910798 2021-03-03 US North Dakota Foster 38031 564 19 0 545 47.4571084 -98.88279923 2021-03-04 05:24:24 Foster, North Dakota, US
910799 2021-03-03 US North Dakota Golden Valley 38033 246 2 0 244 46.94022281 -103.8465421 2021-03-04 05:24:24 Golden Valley, North Dakota, US
910800 2021-03-03 US North Dakota Grand Forks 38035 9819 76 0 9743 47.92093639 -97.45450447 2021-03-04 05:24:24 Grand Forks, North Dakota, US
910801 2021-03-03 US North Dakota Grant 38037 184 7 0 177 46.35821257 -101.6390013 2021-03-04 05:24:24 Grant, North Dakota, US
910802 2021-03-03 US North Dakota Griggs 38039 306 2 0 304 47.45785838 -98.23850925 2021-03-04 05:24:24 Griggs, North Dakota, US
910803 2021-03-03 US North Dakota Hettinger 38041 318 4 0 314 46.43375068 -102.4632417 2021-03-04 05:24:24 Hettinger, North Dakota, US
910804 2021-03-03 US North Dakota Kidder 38043 256 10 0 246 46.97830064 -99.77507857 2021-03-04 05:24:24 Kidder, North Dakota, US
910805 2021-03-03 US North Dakota LaMoure 38045 497 17 0 480 46.45681054 -98.53542355 2021-03-04 05:24:24 LaMoure, North Dakota, US
910806 2021-03-03 US North Dakota Logan 38047 217 8 0 209 46.45729487 -99.47719806 2021-03-04 05:24:24 Logan, North Dakota, US
910807 2021-03-03 US North Dakota McHenry 38049 600 21 0 579 48.23104458 -100.6324822 2021-03-04 05:24:24 McHenry, North Dakota, US
910808 2021-03-03 US North Dakota McIntosh 38051 321 7 0 314 46.11182017 -99.44145858 2021-03-04 05:24:24 McIntosh, North Dakota, US
910809 2021-03-03 US North Dakota McKenzie 38053 1166 12 0 1154 47.74133370000001 -103.395905 2021-03-04 05:24:24 McKenzie, North Dakota, US
910810 2021-03-03 US North Dakota McLean 38055 1212 31 0 1181 47.60766714 -101.3182418 2021-03-04 05:24:24 McLean, North Dakota, US
910811 2021-03-03 US North Dakota Mercer 38057 1072 9 0 1063 47.31213126 -101.8318399 2021-03-04 05:24:24 Mercer, North Dakota, US
910812 2021-03-03 US North Dakota Morton 38059 4945 94 0 4851 46.71681782 -101.2822377 2021-03-04 05:24:24 Morton, North Dakota, US
910813 2021-03-03 US North Dakota Mountrail 38061 1272 17 0 1255 48.20197971 -102.3555315 2021-03-04 05:24:24 Mountrail, North Dakota, US
910814 2021-03-03 US North Dakota Nelson 38063 447 13 0 434 47.9226426 -98.19038437 2021-03-04 05:24:24 Nelson, North Dakota, US
910815 2021-03-03 US North Dakota Oliver 38065 152 2 0 150 47.11530482 -101.3406158 2021-03-04 05:24:24 Oliver, North Dakota, US
910816 2021-03-03 US North Dakota Pembina 38067 752 11 0 741 48.76623521 -97.5523809 2021-03-04 05:24:24 Pembina, North Dakota, US
910817 2021-03-03 US North Dakota Pierce 38069 523 24 0 499 48.24977025 -99.96407787 2021-03-04 05:24:24 Pierce, North Dakota, US
910818 2021-03-03 US North Dakota Ramsey 38071 1609 30 0 1579 48.26886249 -98.72223879 2021-03-04 05:24:24 Ramsey, North Dakota, US
910819 2021-03-03 US North Dakota Ransom 38073 618 16 0 602 46.45621782 -97.65742504 2021-03-04 05:24:24 Ransom, North Dakota, US
910820 2021-03-03 US North Dakota Renville 38075 305 13 0 292 48.71982533 -101.6603912 2021-03-04 05:24:24 Renville, North Dakota, US
910821 2021-03-03 US North Dakota Richland 38077 1766 16 0 1750 46.26440649 -96.94852979 2021-03-04 05:24:24 Richland, North Dakota, US
910822 2021-03-03 US North Dakota Rolette 38079 2122 28 0 2094 48.77245354 -99.84097493 2021-03-04 05:24:24 Rolette, North Dakota, US
910823 2021-03-03 US North Dakota Sargent 38081 428 6 0 422 46.10830372 -97.63217159 2021-03-04 05:24:24 Sargent, North Dakota, US
910824 2021-03-03 US North Dakota Sheridan 38083 103 2 0 101 47.57700669 -100.3426391 2021-03-04 05:24:24 Sheridan, North Dakota, US
910825 2021-03-03 US North Dakota Sioux 38085 641 11 0 630 46.11323337 -101.0440149 2021-03-04 05:24:24 Sioux, North Dakota, US
910826 2021-03-03 US North Dakota Slope 38087 31 0 0 31 46.44737738 -103.4601547 2021-03-04 05:24:24 Slope, North Dakota, US
910827 2021-03-03 US North Dakota Stark 38089 4386 49 0 4337 46.80851182 -102.6576326 2021-03-04 05:24:24 Stark, North Dakota, US
910828 2021-03-03 US North Dakota Steele 38091 172 2 0 170 47.45611548 -97.72728747 2021-03-04 05:24:24 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]);