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 2022-02-14 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 |
---|---|---|---|---|---|---|---|
2215236 | 2215236 | 2022-02-14 | Adams | North Dakota | 38001 | 569 | 9 |
2215237 | 2215237 | 2022-02-14 | Barnes | North Dakota | 38003 | 2925 | 46 |
2215238 | 2215238 | 2022-02-14 | Benson | North Dakota | 38005 | 1906 | 22 |
2215239 | 2215239 | 2022-02-14 | Billings | North Dakota | 38007 | 137 | 1 |
2215240 | 2215240 | 2022-02-14 | Bottineau | North Dakota | 38009 | 1563 | 25 |
2215241 | 2215241 | 2022-02-14 | Bowman | North Dakota | 38011 | 823 | 9 |
2215242 | 2215242 | 2022-02-14 | Burke | North Dakota | 38013 | 428 | 3 |
2215243 | 2215243 | 2022-02-14 | Burleigh | North Dakota | 38015 | 34177 | 292 |
2215244 | 2215244 | 2022-02-14 | Cass | North Dakota | 38017 | 57865 | 321 |
2215245 | 2215245 | 2022-02-14 | Cavalier | North Dakota | 38019 | 794 | 7 |
2215246 | 2215246 | 2022-02-14 | Dickey | North Dakota | 38021 | 1466 | 39 |
2215247 | 2215247 | 2022-02-14 | Divide | North Dakota | 38023 | 453 | 4 |
2215248 | 2215248 | 2022-02-14 | Dunn | North Dakota | 38025 | 1013 | 8 |
2215249 | 2215249 | 2022-02-14 | Eddy | North Dakota | 38027 | 744 | 6 |
2215250 | 2215250 | 2022-02-14 | Emmons | North Dakota | 38029 | 719 | 17 |
2215251 | 2215251 | 2022-02-14 | Foster | North Dakota | 38031 | 966 | 21 |
2215252 | 2215252 | 2022-02-14 | Golden Valley | North Dakota | 38033 | 467 | 4 |
2215253 | 2215253 | 2022-02-14 | Grand Forks | North Dakota | 38035 | 21599 | 118 |
2215254 | 2215254 | 2022-02-14 | Grant | North Dakota | 38037 | 448 | 11 |
2215255 | 2215255 | 2022-02-14 | Griggs | North Dakota | 38039 | 561 | 2 |
2215256 | 2215256 | 2022-02-14 | Hettinger | North Dakota | 38041 | 810 | 7 |
2215257 | 2215257 | 2022-02-14 | Kidder | North Dakota | 38043 | 491 | 13 |
2215258 | 2215258 | 2022-02-14 | LaMoure | North Dakota | 38045 | 969 | 19 |
2215259 | 2215259 | 2022-02-14 | Logan | North Dakota | 38047 | 425 | 11 |
2215260 | 2215260 | 2022-02-14 | McHenry | North Dakota | 38049 | 1268 | 30 |
2215261 | 2215261 | 2022-02-14 | McIntosh | North Dakota | 38051 | 654 | 9 |
2215262 | 2215262 | 2022-02-14 | McKenzie | North Dakota | 38053 | 3199 | 25 |
2215263 | 2215263 | 2022-02-14 | McLean | North Dakota | 38055 | 2697 | 49 |
2215264 | 2215264 | 2022-02-14 | Mercer | North Dakota | 38057 | 2502 | 23 |
2215265 | 2215265 | 2022-02-14 | Morton | North Dakota | 38059 | 11013 | 140 |
2215266 | 2215266 | 2022-02-14 | Mountrail | North Dakota | 38061 | 3159 | 34 |
2215267 | 2215267 | 2022-02-14 | Nelson | North Dakota | 38063 | 747 | 18 |
2215268 | 2215268 | 2022-02-14 | Oliver | North Dakota | 38065 | 323 | 4 |
2215269 | 2215269 | 2022-02-14 | Pembina | North Dakota | 38067 | 1933 | 16 |
2215270 | 2215270 | 2022-02-14 | Pierce | North Dakota | 38069 | 1036 | 31 |
2215271 | 2215271 | 2022-02-14 | Ramsey | North Dakota | 38071 | 3525 | 52 |
2215272 | 2215272 | 2022-02-14 | Ransom | North Dakota | 38073 | 1466 | 27 |
2215273 | 2215273 | 2022-02-14 | Renville | North Dakota | 38075 | 544 | 15 |
2215274 | 2215274 | 2022-02-14 | Richland | North Dakota | 38077 | 3971 | 21 |
2215275 | 2215275 | 2022-02-14 | Rolette | North Dakota | 38079 | 5666 | 40 |
2215276 | 2215276 | 2022-02-14 | Sargent | North Dakota | 38081 | 1013 | 9 |
2215277 | 2215277 | 2022-02-14 | Sheridan | North Dakota | 38083 | 289 | 7 |
2215278 | 2215278 | 2022-02-14 | Sioux | North Dakota | 38085 | 1311 | 19 |
2215279 | 2215279 | 2022-02-14 | Slope | North Dakota | 38087 | 63 | 0 |
2215280 | 2215280 | 2022-02-14 | Stark | North Dakota | 38089 | 11454 | 81 |
2215281 | 2215281 | 2022-02-14 | Steele | North Dakota | 38091 | 379 | 2 |
2215282 | 2215282 | 2022-02-14 | Stutsman | North Dakota | 38093 | 6867 | 95 |
2215283 | 2215283 | 2022-02-14 | Towner | North Dakota | 38095 | 623 | 12 |
2215284 | 2215284 | 2022-02-14 | Traill | North Dakota | 38097 | 2114 | 23 |
2215285 | 2215285 | 2022-02-14 | Unknown | North Dakota | 0 | 47 | |
2215286 | 2215286 | 2022-02-14 | Walsh | North Dakota | 38099 | 3273 | 34 |
2215287 | 2215287 | 2022-02-14 | Ward | North Dakota | 38101 | 20325 | 244 |
2215288 | 2215288 | 2022-02-14 | Wells | North Dakota | 38103 | 989 | 11 |
2215289 | 2215289 | 2022-02-14 | Williams | North Dakota | 38105 | 10277 | 68 |
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);