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

29,159 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 · 29,159 ✖
Link rowid date ▲ county state fips cases deaths
1818620 1818620 2021-10-15 Adams North Dakota 38001 361 4
1818621 1818621 2021-10-15 Barnes North Dakota 38003 1754 33
1818622 1818622 2021-10-15 Benson North Dakota 38005 1263 20
1818623 1818623 2021-10-15 Billings North Dakota 38007 89 0
1818624 1818624 2021-10-15 Bottineau North Dakota 38009 938 20
1818625 1818625 2021-10-15 Bowman North Dakota 38011 546 7
1818626 1818626 2021-10-15 Burke North Dakota 38013 294 3
1818627 1818627 2021-10-15 Burleigh North Dakota 38015 21486 223
1818628 1818628 2021-10-15 Cass North Dakota 38017 30652 232
1818629 1818629 2021-10-15 Cavalier North Dakota 38019 520 5
1818630 1818630 2021-10-15 Dickey North Dakota 38021 955 33
1818631 1818631 2021-10-15 Divide North Dakota 38023 255 2
1818632 1818632 2021-10-15 Dunn North Dakota 38025 670 7
1818633 1818633 2021-10-15 Eddy North Dakota 38027 515 6
1818634 1818634 2021-10-15 Emmons North Dakota 38029 535 15
1818635 1818635 2021-10-15 Foster North Dakota 38031 638 19
1818636 1818636 2021-10-15 Golden Valley North Dakota 38033 329 4
1818637 1818637 2021-10-15 Grand Forks North Dakota 38035 12614 82
1818638 1818638 2021-10-15 Grant North Dakota 38037 305 7
1818639 1818639 2021-10-15 Griggs North Dakota 38039 362 2
1818640 1818640 2021-10-15 Hettinger North Dakota 38041 455 5
1818641 1818641 2021-10-15 Kidder North Dakota 38043 351 11
1818642 1818642 2021-10-15 LaMoure North Dakota 38045 654 17
1818643 1818643 2021-10-15 Logan North Dakota 38047 317 11
1818644 1818644 2021-10-15 McHenry North Dakota 38049 840 23
1818645 1818645 2021-10-15 McIntosh North Dakota 38051 445 8
1818646 1818646 2021-10-15 McKenzie North Dakota 38053 2225 20
1818647 1818647 2021-10-15 McLean North Dakota 38055 1709 33
1818648 1818648 2021-10-15 Mercer North Dakota 38057 1664 12
1818649 1818649 2021-10-15 Morton North Dakota 38059 7100 107
1818650 1818650 2021-10-15 Mountrail North Dakota 38061 1826 25
1818651 1818651 2021-10-15 Nelson North Dakota 38063 536 16
1818652 1818652 2021-10-15 Oliver North Dakota 38065 198 3
1818653 1818653 2021-10-15 Pembina North Dakota 38067 1140 11
1818654 1818654 2021-10-15 Pierce North Dakota 38069 741 27
1818655 1818655 2021-10-15 Ramsey North Dakota 38071 2120 33
1818656 1818656 2021-10-15 Ransom North Dakota 38073 911 19
1818657 1818657 2021-10-15 Renville North Dakota 38075 364 14
1818658 1818658 2021-10-15 Richland North Dakota 38077 2439 19
1818659 1818659 2021-10-15 Rolette North Dakota 38079 2751 31
1818660 1818660 2021-10-15 Sargent North Dakota 38081 588 7
1818661 1818661 2021-10-15 Sheridan North Dakota 38083 150 3
1818662 1818662 2021-10-15 Sioux North Dakota 38085 847 15
1818663 1818663 2021-10-15 Slope North Dakota 38087 41 0
1818664 1818664 2021-10-15 Stark North Dakota 38089 7272 60
1818665 1818665 2021-10-15 Steele North Dakota 38091 244 2
1818666 1818666 2021-10-15 Stutsman North Dakota 38093 4273 85
1818667 1818667 2021-10-15 Towner North Dakota 38095 377 11
1818668 1818668 2021-10-15 Traill North Dakota 38097 1239 19
1818669 1818669 2021-10-15 Unknown North Dakota   34 34
1818670 1818670 2021-10-15 Walsh North Dakota 38099 2206 29
1818671 1818671 2021-10-15 Ward North Dakota 38101 12520 212
1818672 1818672 2021-10-15 Wells North Dakota 38103 558 9
1818673 1818673 2021-10-15 Williams North Dakota 38105 6564 48
1815371 1815371 2021-10-14 Adams North Dakota 38001 359 4
1815372 1815372 2021-10-14 Barnes North Dakota 38003 1751 33
1815373 1815373 2021-10-14 Benson North Dakota 38005 1260 20
1815374 1815374 2021-10-14 Billings North Dakota 38007 89 0
1815375 1815375 2021-10-14 Bottineau North Dakota 38009 934 20
1815376 1815376 2021-10-14 Bowman North Dakota 38011 541 7
1815377 1815377 2021-10-14 Burke North Dakota 38013 293 3
1815378 1815378 2021-10-14 Burleigh North Dakota 38015 21407 223
1815379 1815379 2021-10-14 Cass North Dakota 38017 30552 232
1815380 1815380 2021-10-14 Cavalier North Dakota 38019 520 5
1815381 1815381 2021-10-14 Dickey North Dakota 38021 949 33
1815382 1815382 2021-10-14 Divide North Dakota 38023 255 2
1815383 1815383 2021-10-14 Dunn North Dakota 38025 661 7
1815384 1815384 2021-10-14 Eddy North Dakota 38027 511 6
1815385 1815385 2021-10-14 Emmons North Dakota 38029 532 15
1815386 1815386 2021-10-14 Foster North Dakota 38031 636 19
1815387 1815387 2021-10-14 Golden Valley North Dakota 38033 329 4
1815388 1815388 2021-10-14 Grand Forks North Dakota 38035 12565 82
1815389 1815389 2021-10-14 Grant North Dakota 38037 305 7
1815390 1815390 2021-10-14 Griggs North Dakota 38039 361 2
1815391 1815391 2021-10-14 Hettinger North Dakota 38041 453 5
1815392 1815392 2021-10-14 Kidder North Dakota 38043 350 10
1815393 1815393 2021-10-14 LaMoure North Dakota 38045 651 17
1815394 1815394 2021-10-14 Logan North Dakota 38047 316 10
1815395 1815395 2021-10-14 McHenry North Dakota 38049 831 23
1815396 1815396 2021-10-14 McIntosh North Dakota 38051 443 8
1815397 1815397 2021-10-14 McKenzie North Dakota 38053 2214 20
1815398 1815398 2021-10-14 McLean North Dakota 38055 1704 33
1815399 1815399 2021-10-14 Mercer North Dakota 38057 1655 12
1815400 1815400 2021-10-14 Morton North Dakota 38059 7067 105
1815401 1815401 2021-10-14 Mountrail North Dakota 38061 1822 23
1815402 1815402 2021-10-14 Nelson North Dakota 38063 534 16
1815403 1815403 2021-10-14 Oliver North Dakota 38065 198 3
1815404 1815404 2021-10-14 Pembina North Dakota 38067 1137 11
1815405 1815405 2021-10-14 Pierce North Dakota 38069 737 27
1815406 1815406 2021-10-14 Ramsey North Dakota 38071 2109 33
1815407 1815407 2021-10-14 Ransom North Dakota 38073 911 18
1815408 1815408 2021-10-14 Renville North Dakota 38075 362 14
1815409 1815409 2021-10-14 Richland North Dakota 38077 2430 19
1815410 1815410 2021-10-14 Rolette North Dakota 38079 2743 31
1815411 1815411 2021-10-14 Sargent North Dakota 38081 584 7
1815412 1815412 2021-10-14 Sheridan North Dakota 38083 148 3
1815413 1815413 2021-10-14 Sioux North Dakota 38085 846 15
1815414 1815414 2021-10-14 Slope North Dakota 38087 41 0
1815415 1815415 2021-10-14 Stark North Dakota 38089 7231 60
1815416 1815416 2021-10-14 Steele North Dakota 38091 244 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] desc);