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-08-28 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 |
---|---|---|---|---|---|---|---|
1662677 | 1662677 | 2021-08-28 | Adams | North Dakota | 38001 | 295 | 3 |
1662678 | 1662678 | 2021-08-28 | Barnes | North Dakota | 38003 | 1461 | 32 |
1662679 | 1662679 | 2021-08-28 | Benson | North Dakota | 38005 | 1143 | 20 |
1662680 | 1662680 | 2021-08-28 | Billings | North Dakota | 38007 | 57 | 0 |
1662681 | 1662681 | 2021-08-28 | Bottineau | North Dakota | 38009 | 770 | 20 |
1662682 | 1662682 | 2021-08-28 | Bowman | North Dakota | 38011 | 426 | 5 |
1662683 | 1662683 | 2021-08-28 | Burke | North Dakota | 38013 | 260 | 3 |
1662684 | 1662684 | 2021-08-28 | Burleigh | North Dakota | 38015 | 17018 | 202 |
1662685 | 1662685 | 2021-08-28 | Cass | North Dakota | 38017 | 26066 | 218 |
1662686 | 1662686 | 2021-08-28 | Cavalier | North Dakota | 38019 | 451 | 5 |
1662687 | 1662687 | 2021-08-28 | Dickey | North Dakota | 38021 | 828 | 33 |
1662688 | 1662688 | 2021-08-28 | Divide | North Dakota | 38023 | 195 | 2 |
1662689 | 1662689 | 2021-08-28 | Dunn | North Dakota | 38025 | 452 | 7 |
1662690 | 1662690 | 2021-08-28 | Eddy | North Dakota | 38027 | 479 | 6 |
1662691 | 1662691 | 2021-08-28 | Emmons | North Dakota | 38029 | 476 | 14 |
1662692 | 1662692 | 2021-08-28 | Foster | North Dakota | 38031 | 601 | 19 |
1662693 | 1662693 | 2021-08-28 | Golden Valley | North Dakota | 38033 | 289 | 3 |
1662694 | 1662694 | 2021-08-28 | Grand Forks | North Dakota | 38035 | 11098 | 80 |
1662695 | 1662695 | 2021-08-28 | Grant | North Dakota | 38037 | 225 | 7 |
1662696 | 1662696 | 2021-08-28 | Griggs | North Dakota | 38039 | 332 | 2 |
1662697 | 1662697 | 2021-08-28 | Hettinger | North Dakota | 38041 | 345 | 4 |
1662698 | 1662698 | 2021-08-28 | Kidder | North Dakota | 38043 | 298 | 10 |
1662699 | 1662699 | 2021-08-28 | LaMoure | North Dakota | 38045 | 557 | 17 |
1662700 | 1662700 | 2021-08-28 | Logan | North Dakota | 38047 | 277 | 10 |
1662701 | 1662701 | 2021-08-28 | McHenry | North Dakota | 38049 | 692 | 23 |
1662702 | 1662702 | 2021-08-28 | McIntosh | North Dakota | 38051 | 359 | 7 |
1662703 | 1662703 | 2021-08-28 | McKenzie | North Dakota | 38053 | 1577 | 15 |
1662704 | 1662704 | 2021-08-28 | McLean | North Dakota | 38055 | 1375 | 32 |
1662705 | 1662705 | 2021-08-28 | Mercer | North Dakota | 38057 | 1220 | 11 |
1662706 | 1662706 | 2021-08-28 | Morton | North Dakota | 38059 | 5631 | 102 |
1662707 | 1662707 | 2021-08-28 | Mountrail | North Dakota | 38061 | 1526 | 19 |
1662708 | 1662708 | 2021-08-28 | Nelson | North Dakota | 38063 | 495 | 15 |
1662709 | 1662709 | 2021-08-28 | Oliver | North Dakota | 38065 | 163 | 3 |
1662710 | 1662710 | 2021-08-28 | Pembina | North Dakota | 38067 | 865 | 11 |
1662711 | 1662711 | 2021-08-28 | Pierce | North Dakota | 38069 | 584 | 26 |
1662712 | 1662712 | 2021-08-28 | Ramsey | North Dakota | 38071 | 1770 | 30 |
1662713 | 1662713 | 2021-08-28 | Ransom | North Dakota | 38073 | 714 | 17 |
1662714 | 1662714 | 2021-08-28 | Renville | North Dakota | 38075 | 339 | 14 |
1662715 | 1662715 | 2021-08-28 | Richland | North Dakota | 38077 | 2095 | 18 |
1662716 | 1662716 | 2021-08-28 | Rolette | North Dakota | 38079 | 2248 | 28 |
1662717 | 1662717 | 2021-08-28 | Sargent | North Dakota | 38081 | 504 | 7 |
1662718 | 1662718 | 2021-08-28 | Sheridan | North Dakota | 38083 | 127 | 2 |
1662719 | 1662719 | 2021-08-28 | Sioux | North Dakota | 38085 | 687 | 12 |
1662720 | 1662720 | 2021-08-28 | Slope | North Dakota | 38087 | 32 | 0 |
1662721 | 1662721 | 2021-08-28 | Stark | North Dakota | 38089 | 5424 | 52 |
1662722 | 1662722 | 2021-08-28 | Steele | North Dakota | 38091 | 201 | 2 |
1662723 | 1662723 | 2021-08-28 | Stutsman | North Dakota | 38093 | 3670 | 82 |
1662724 | 1662724 | 2021-08-28 | Towner | North Dakota | 38095 | 342 | 11 |
1662725 | 1662725 | 2021-08-28 | Traill | North Dakota | 38097 | 1102 | 18 |
1662726 | 1662726 | 2021-08-28 | Unknown | North Dakota | 32 | 32 | |
1662727 | 1662727 | 2021-08-28 | Walsh | North Dakota | 38099 | 1959 | 27 |
1662728 | 1662728 | 2021-08-28 | Ward | North Dakota | 38101 | 10736 | 204 |
1662729 | 1662729 | 2021-08-28 | Wells | North Dakota | 38103 | 468 | 8 |
1662730 | 1662730 | 2021-08-28 | Williams | North Dakota | 38105 | 5362 | 42 |
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);