ny_times_us_counties

Table actions
⚠️ 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 license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

17,171 rows where state = "North Dakota" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • North Dakota · 17,171 ✖
Link rowid date ▲ county state fips cases deaths
1097704 1097704 2021-03-07 Adams North Dakota 38001 266 3
1097705 1097705 2021-03-07 Barnes North Dakota 38003 1300 31
1097706 1097706 2021-03-07 Benson North Dakota 38005 1030 18
1097707 1097707 2021-03-07 Billings North Dakota 38007 53 0
1097708 1097708 2021-03-07 Bottineau North Dakota 38009 689 20
1097709 1097709 2021-03-07 Bowman North Dakota 38011 396 5
1097710 1097710 2021-03-07 Burke North Dakota 38013 224 1
1097711 1097711 2021-03-07 Burleigh North Dakota 38015 14703 186
1097712 1097712 2021-03-07 Cass North Dakota 38017 21504 196
1097713 1097713 2021-03-07 Cavalier North Dakota 38019 416 5
1097714 1097714 2021-03-07 Dickey North Dakota 38021 738 32
1097715 1097715 2021-03-07 Divide North Dakota 38023 166 2
1097716 1097716 2021-03-07 Dunn North Dakota 38025 367 7
1097717 1097717 2021-03-07 Eddy North Dakota 38027 459 6
1097718 1097718 2021-03-07 Emmons North Dakota 38029 407 12
1097719 1097719 2021-03-07 Foster North Dakota 38031 568 19
1097720 1097720 2021-03-07 Golden Valley North Dakota 38033 247 2
1097721 1097721 2021-03-07 Grand Forks North Dakota 38035 9836 76
1097722 1097722 2021-03-07 Grant North Dakota 38037 184 7
1097723 1097723 2021-03-07 Griggs North Dakota 38039 307 2
1097724 1097724 2021-03-07 Hettinger North Dakota 38041 320 4
1097725 1097725 2021-03-07 Kidder North Dakota 38043 256 10
1097726 1097726 2021-03-07 LaMoure North Dakota 38045 497 17
1097727 1097727 2021-03-07 Logan North Dakota 38047 219 8
1097728 1097728 2021-03-07 McHenry North Dakota 38049 607 21
1097729 1097729 2021-03-07 McIntosh North Dakota 38051 323 7
1097730 1097730 2021-03-07 McKenzie North Dakota 38053 1167 12
1097731 1097731 2021-03-07 McLean North Dakota 38055 1216 31
1097732 1097732 2021-03-07 Mercer North Dakota 38057 1073 9
1097733 1097733 2021-03-07 Morton North Dakota 38059 4948 95
1097734 1097734 2021-03-07 Mountrail North Dakota 38061 1274 17
1097735 1097735 2021-03-07 Nelson North Dakota 38063 447 13
1097736 1097736 2021-03-07 Oliver North Dakota 38065 153 2
1097737 1097737 2021-03-07 Pembina North Dakota 38067 753 11
1097738 1097738 2021-03-07 Pierce North Dakota 38069 528 24
1097739 1097739 2021-03-07 Ramsey North Dakota 38071 1614 30
1097740 1097740 2021-03-07 Ransom North Dakota 38073 619 16
1097741 1097741 2021-03-07 Renville North Dakota 38075 305 13
1097742 1097742 2021-03-07 Richland North Dakota 38077 1783 16
1097743 1097743 2021-03-07 Rolette North Dakota 38079 2126 28
1097744 1097744 2021-03-07 Sargent North Dakota 38081 431 6
1097745 1097745 2021-03-07 Sheridan North Dakota 38083 103 2
1097746 1097746 2021-03-07 Sioux North Dakota 38085 641 11
1097747 1097747 2021-03-07 Slope North Dakota 38087 31 0
1097748 1097748 2021-03-07 Stark North Dakota 38089 4412 49
1097749 1097749 2021-03-07 Steele North Dakota 38091 174 2
1097750 1097750 2021-03-07 Stutsman North Dakota 38093 3292 79
1097751 1097751 2021-03-07 Towner North Dakota 38095 300 11
1097752 1097752 2021-03-07 Traill North Dakota 38097 992 18
1097753 1097753 2021-03-07 Unknown North Dakota   30 30
1097754 1097754 2021-03-07 Walsh North Dakota 38099 1765 24
1097755 1097755 2021-03-07 Ward North Dakota 38101 9227 189
1097756 1097756 2021-03-07 Wells North Dakota 38103 428 8
1097757 1097757 2021-03-07 Williams North Dakota 38105 4507 36
1094456 1094456 2021-03-06 Adams North Dakota 38001 266 3
1094457 1094457 2021-03-06 Barnes North Dakota 38003 1300 31
1094458 1094458 2021-03-06 Benson North Dakota 38005 1030 18
1094459 1094459 2021-03-06 Billings North Dakota 38007 53 0
1094460 1094460 2021-03-06 Bottineau North Dakota 38009 689 20
1094461 1094461 2021-03-06 Bowman North Dakota 38011 396 5
1094462 1094462 2021-03-06 Burke North Dakota 38013 224 1
1094463 1094463 2021-03-06 Burleigh North Dakota 38015 14700 186
1094464 1094464 2021-03-06 Cass North Dakota 38017 21499 196
1094465 1094465 2021-03-06 Cavalier North Dakota 38019 416 5
1094466 1094466 2021-03-06 Dickey North Dakota 38021 738 32
1094467 1094467 2021-03-06 Divide North Dakota 38023 166 2
1094468 1094468 2021-03-06 Dunn North Dakota 38025 367 7
1094469 1094469 2021-03-06 Eddy North Dakota 38027 459 6
1094470 1094470 2021-03-06 Emmons North Dakota 38029 407 12
1094471 1094471 2021-03-06 Foster North Dakota 38031 568 19
1094472 1094472 2021-03-06 Golden Valley North Dakota 38033 247 2
1094473 1094473 2021-03-06 Grand Forks North Dakota 38035 9831 76
1094474 1094474 2021-03-06 Grant North Dakota 38037 184 7
1094475 1094475 2021-03-06 Griggs North Dakota 38039 307 2
1094476 1094476 2021-03-06 Hettinger North Dakota 38041 320 4
1094477 1094477 2021-03-06 Kidder North Dakota 38043 256 10
1094478 1094478 2021-03-06 LaMoure North Dakota 38045 497 17
1094479 1094479 2021-03-06 Logan North Dakota 38047 219 8
1094480 1094480 2021-03-06 McHenry North Dakota 38049 607 21
1094481 1094481 2021-03-06 McIntosh North Dakota 38051 323 7
1094482 1094482 2021-03-06 McKenzie North Dakota 38053 1167 12
1094483 1094483 2021-03-06 McLean North Dakota 38055 1216 31
1094484 1094484 2021-03-06 Mercer North Dakota 38057 1073 9
1094485 1094485 2021-03-06 Morton North Dakota 38059 4947 95
1094486 1094486 2021-03-06 Mountrail North Dakota 38061 1274 17
1094487 1094487 2021-03-06 Nelson North Dakota 38063 447 13
1094488 1094488 2021-03-06 Oliver North Dakota 38065 153 2
1094489 1094489 2021-03-06 Pembina North Dakota 38067 753 11
1094490 1094490 2021-03-06 Pierce North Dakota 38069 527 24
1094491 1094491 2021-03-06 Ramsey North Dakota 38071 1614 30
1094492 1094492 2021-03-06 Ransom North Dakota 38073 619 16
1094493 1094493 2021-03-06 Renville North Dakota 38075 305 13
1094494 1094494 2021-03-06 Richland North Dakota 38077 1783 16
1094495 1094495 2021-03-06 Rolette North Dakota 38079 2125 28
1094496 1094496 2021-03-06 Sargent North Dakota 38081 431 6
1094497 1094497 2021-03-06 Sheridan North Dakota 38083 103 2
1094498 1094498 2021-03-06 Sioux North Dakota 38085 641 11
1094499 1094499 2021-03-06 Slope North Dakota 38087 31 0
1094500 1094500 2021-03-06 Stark North Dakota 38089 4407 49
1094501 1094501 2021-03-06 Steele North Dakota 38091 173 2

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);