ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where "date" is on date 2021-12-30 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2065616 | 2065616 | 2021-12-30 | Adams | North Dakota | 38001 | 469 | 8 |
2065617 | 2065617 | 2021-12-30 | Barnes | North Dakota | 38003 | 2214 | 40 |
2065618 | 2065618 | 2021-12-30 | Benson | North Dakota | 38005 | 1476 | 22 |
2065619 | 2065619 | 2021-12-30 | Billings | North Dakota | 38007 | 119 | 1 |
2065620 | 2065620 | 2021-12-30 | Bottineau | North Dakota | 38009 | 1183 | 24 |
2065621 | 2065621 | 2021-12-30 | Bowman | North Dakota | 38011 | 679 | 9 |
2065622 | 2065622 | 2021-12-30 | Burke | North Dakota | 38013 | 360 | 3 |
2065623 | 2065623 | 2021-12-30 | Burleigh | North Dakota | 38015 | 25455 | 281 |
2065624 | 2065624 | 2021-12-30 | Cass | North Dakota | 38017 | 39497 | 284 |
2065625 | 2065625 | 2021-12-30 | Cavalier | North Dakota | 38019 | 596 | 7 |
2065626 | 2065626 | 2021-12-30 | Dickey | North Dakota | 38021 | 1186 | 38 |
2065627 | 2065627 | 2021-12-30 | Divide | North Dakota | 38023 | 338 | 3 |
2065628 | 2065628 | 2021-12-30 | Dunn | North Dakota | 38025 | 872 | 7 |
2065629 | 2065629 | 2021-12-30 | Eddy | North Dakota | 38027 | 601 | 6 |
2065630 | 2065630 | 2021-12-30 | Emmons | North Dakota | 38029 | 610 | 16 |
2065631 | 2065631 | 2021-12-30 | Foster | North Dakota | 38031 | 727 | 19 |
2065632 | 2065632 | 2021-12-30 | Golden Valley | North Dakota | 38033 | 387 | 4 |
2065633 | 2065633 | 2021-12-30 | Grand Forks | North Dakota | 38035 | 15012 | 103 |
2065634 | 2065634 | 2021-12-30 | Grant | North Dakota | 38037 | 377 | 9 |
2065635 | 2065635 | 2021-12-30 | Griggs | North Dakota | 38039 | 459 | 2 |
2065636 | 2065636 | 2021-12-30 | Hettinger | North Dakota | 38041 | 562 | 7 |
2065637 | 2065637 | 2021-12-30 | Kidder | North Dakota | 38043 | 404 | 13 |
2065638 | 2065638 | 2021-12-30 | LaMoure | North Dakota | 38045 | 775 | 18 |
2065639 | 2065639 | 2021-12-30 | Logan | North Dakota | 38047 | 352 | 11 |
2065640 | 2065640 | 2021-12-30 | McHenry | North Dakota | 38049 | 1065 | 28 |
2065641 | 2065641 | 2021-12-30 | McIntosh | North Dakota | 38051 | 541 | 9 |
2065642 | 2065642 | 2021-12-30 | McKenzie | North Dakota | 38053 | 2675 | 23 |
2065643 | 2065643 | 2021-12-30 | McLean | North Dakota | 38055 | 2202 | 47 |
2065644 | 2065644 | 2021-12-30 | Mercer | North Dakota | 38057 | 1983 | 22 |
2065645 | 2065645 | 2021-12-30 | Morton | North Dakota | 38059 | 8536 | 131 |
2065646 | 2065646 | 2021-12-30 | Mountrail | North Dakota | 38061 | 2269 | 32 |
2065647 | 2065647 | 2021-12-30 | Nelson | North Dakota | 38063 | 618 | 16 |
2065648 | 2065648 | 2021-12-30 | Oliver | North Dakota | 38065 | 257 | 4 |
2065649 | 2065649 | 2021-12-30 | Pembina | North Dakota | 38067 | 1501 | 15 |
2065650 | 2065650 | 2021-12-30 | Pierce | North Dakota | 38069 | 852 | 29 |
2065651 | 2065651 | 2021-12-30 | Ramsey | North Dakota | 38071 | 2617 | 44 |
2065652 | 2065652 | 2021-12-30 | Ransom | North Dakota | 38073 | 1090 | 23 |
2065653 | 2065653 | 2021-12-30 | Renville | North Dakota | 38075 | 454 | 15 |
2065654 | 2065654 | 2021-12-30 | Richland | North Dakota | 38077 | 3012 | 21 |
2065655 | 2065655 | 2021-12-30 | Rolette | North Dakota | 38079 | 3571 | 36 |
2065656 | 2065656 | 2021-12-30 | Sargent | North Dakota | 38081 | 781 | 9 |
2065657 | 2065657 | 2021-12-30 | Sheridan | North Dakota | 38083 | 237 | 6 |
2065658 | 2065658 | 2021-12-30 | Sioux | North Dakota | 38085 | 987 | 18 |
2065659 | 2065659 | 2021-12-30 | Slope | North Dakota | 38087 | 55 | 0 |
2065660 | 2065660 | 2021-12-30 | Stark | North Dakota | 38089 | 9093 | 79 |
2065661 | 2065661 | 2021-12-30 | Steele | North Dakota | 38091 | 301 | 2 |
2065662 | 2065662 | 2021-12-30 | Stutsman | North Dakota | 38093 | 5152 | 92 |
2065663 | 2065663 | 2021-12-30 | Towner | North Dakota | 38095 | 476 | 11 |
2065664 | 2065664 | 2021-12-30 | Traill | North Dakota | 38097 | 1662 | 21 |
2065665 | 2065665 | 2021-12-30 | Unknown | North Dakota | 45 | 45 | |
2065666 | 2065666 | 2021-12-30 | Walsh | North Dakota | 38099 | 2588 | 33 |
2065667 | 2065667 | 2021-12-30 | Ward | North Dakota | 38101 | 15183 | 234 |
2065668 | 2065668 | 2021-12-30 | Wells | North Dakota | 38103 | 812 | 11 |
2065669 | 2065669 | 2021-12-30 | Williams | North Dakota | 38105 | 8099 | 61 |
Advanced export
JSON shape: default, array, newline-delimited
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);