ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 38035 and state = "North Dakota" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
20998 | 20998 | 2020-03-30 | Grand Forks | North Dakota | 38035 | 2 | 0 |
23127 | 23127 | 2020-03-31 | Grand Forks | North Dakota | 38035 | 3 | 0 |
25322 | 25322 | 2020-04-01 | Grand Forks | North Dakota | 38035 | 5 | 0 |
27588 | 27588 | 2020-04-02 | Grand Forks | North Dakota | 38035 | 5 | 0 |
29916 | 29916 | 2020-04-03 | Grand Forks | North Dakota | 38035 | 6 | 0 |
32304 | 32304 | 2020-04-04 | Grand Forks | North Dakota | 38035 | 10 | 0 |
34737 | 34737 | 2020-04-05 | Grand Forks | North Dakota | 38035 | 11 | 0 |
37206 | 37206 | 2020-04-06 | Grand Forks | North Dakota | 38035 | 11 | 0 |
39723 | 39723 | 2020-04-07 | Grand Forks | North Dakota | 38035 | 11 | 0 |
42280 | 42280 | 2020-04-08 | Grand Forks | North Dakota | 38035 | 11 | 0 |
44864 | 44864 | 2020-04-09 | Grand Forks | North Dakota | 38035 | 11 | 0 |
47477 | 47477 | 2020-04-10 | Grand Forks | North Dakota | 38035 | 11 | 0 |
50132 | 50132 | 2020-04-11 | Grand Forks | North Dakota | 38035 | 11 | 0 |
52805 | 52805 | 2020-04-12 | Grand Forks | North Dakota | 38035 | 11 | 0 |
55489 | 55489 | 2020-04-13 | Grand Forks | North Dakota | 38035 | 11 | 0 |
58190 | 58190 | 2020-04-14 | Grand Forks | North Dakota | 38035 | 12 | 0 |
60904 | 60904 | 2020-04-15 | Grand Forks | North Dakota | 38035 | 20 | 0 |
63630 | 63630 | 2020-04-16 | Grand Forks | North Dakota | 38035 | 23 | 0 |
66373 | 66373 | 2020-04-17 | Grand Forks | North Dakota | 38035 | 32 | 0 |
69130 | 69130 | 2020-04-18 | Grand Forks | North Dakota | 38035 | 99 | 0 |
71896 | 71896 | 2020-04-19 | Grand Forks | North Dakota | 38035 | 133 | 0 |
74671 | 74671 | 2020-04-20 | Grand Forks | North Dakota | 38035 | 138 | 0 |
77452 | 77452 | 2020-04-21 | Grand Forks | North Dakota | 38035 | 143 | 0 |
80241 | 80241 | 2020-04-22 | Grand Forks | North Dakota | 38035 | 154 | 0 |
83040 | 83040 | 2020-04-23 | Grand Forks | North Dakota | 38035 | 162 | 0 |
85844 | 85844 | 2020-04-24 | Grand Forks | North Dakota | 38035 | 170 | 0 |
88657 | 88657 | 2020-04-25 | Grand Forks | North Dakota | 38035 | 173 | 0 |
91472 | 91472 | 2020-04-26 | Grand Forks | North Dakota | 38035 | 195 | 0 |
94298 | 94298 | 2020-04-27 | Grand Forks | North Dakota | 38035 | 231 | 0 |
97135 | 97135 | 2020-04-28 | Grand Forks | North Dakota | 38035 | 234 | 0 |
99984 | 99984 | 2020-04-29 | Grand Forks | North Dakota | 38035 | 251 | 0 |
102837 | 102837 | 2020-04-30 | Grand Forks | North Dakota | 38035 | 258 | 0 |
105699 | 105699 | 2020-05-01 | Grand Forks | North Dakota | 38035 | 262 | 0 |
108566 | 108566 | 2020-05-02 | Grand Forks | North Dakota | 38035 | 265 | 0 |
111440 | 111440 | 2020-05-03 | Grand Forks | North Dakota | 38035 | 267 | 0 |
114321 | 114321 | 2020-05-04 | Grand Forks | North Dakota | 38035 | 269 | 0 |
117201 | 117201 | 2020-05-05 | Grand Forks | North Dakota | 38035 | 270 | 0 |
120162 | 120162 | 2020-05-06 | Grand Forks | North Dakota | 38035 | 271 | 1 |
123138 | 123138 | 2020-05-07 | Grand Forks | North Dakota | 38035 | 275 | 1 |
126121 | 126121 | 2020-05-08 | Grand Forks | North Dakota | 38035 | 282 | 2 |
129110 | 129110 | 2020-05-09 | Grand Forks | North Dakota | 38035 | 284 | 2 |
132099 | 132099 | 2020-05-10 | Grand Forks | North Dakota | 38035 | 285 | 2 |
135090 | 135090 | 2020-05-11 | Grand Forks | North Dakota | 38035 | 287 | 2 |
138080 | 138080 | 2020-05-12 | Grand Forks | North Dakota | 38035 | 293 | 2 |
141076 | 141076 | 2020-05-13 | Grand Forks | North Dakota | 38035 | 297 | 2 |
144071 | 144071 | 2020-05-14 | Grand Forks | North Dakota | 38035 | 304 | 2 |
147072 | 147072 | 2020-05-15 | Grand Forks | North Dakota | 38035 | 307 | 3 |
150079 | 150079 | 2020-05-16 | Grand Forks | North Dakota | 38035 | 315 | 3 |
153089 | 153089 | 2020-05-17 | Grand Forks | North Dakota | 38035 | 317 | 3 |
156106 | 156106 | 2020-05-18 | Grand Forks | North Dakota | 38035 | 317 | 3 |
159126 | 159126 | 2020-05-19 | Grand Forks | North Dakota | 38035 | 317 | 3 |
162153 | 162153 | 2020-05-20 | Grand Forks | North Dakota | 38035 | 319 | 3 |
165182 | 165182 | 2020-05-21 | Grand Forks | North Dakota | 38035 | 320 | 3 |
168217 | 168217 | 2020-05-22 | Grand Forks | North Dakota | 38035 | 320 | 3 |
171256 | 171256 | 2020-05-23 | Grand Forks | North Dakota | 38035 | 321 | 3 |
174298 | 174298 | 2020-05-24 | Grand Forks | North Dakota | 38035 | 323 | 3 |
177342 | 177342 | 2020-05-25 | Grand Forks | North Dakota | 38035 | 325 | 3 |
180385 | 180385 | 2020-05-26 | Grand Forks | North Dakota | 38035 | 326 | 3 |
183433 | 183433 | 2020-05-27 | Grand Forks | North Dakota | 38035 | 327 | 3 |
186490 | 186490 | 2020-05-28 | Grand Forks | North Dakota | 38035 | 328 | 3 |
189550 | 189550 | 2020-05-29 | Grand Forks | North Dakota | 38035 | 331 | 3 |
192614 | 192614 | 2020-05-30 | Grand Forks | North Dakota | 38035 | 333 | 3 |
195684 | 195684 | 2020-05-31 | Grand Forks | North Dakota | 38035 | 333 | 3 |
198757 | 198757 | 2020-06-01 | Grand Forks | North Dakota | 38035 | 336 | 3 |
201832 | 201832 | 2020-06-02 | Grand Forks | North Dakota | 38035 | 335 | 3 |
204909 | 204909 | 2020-06-03 | Grand Forks | North Dakota | 38035 | 336 | 3 |
207990 | 207990 | 2020-06-04 | Grand Forks | North Dakota | 38035 | 336 | 3 |
211072 | 211072 | 2020-06-05 | Grand Forks | North Dakota | 38035 | 336 | 4 |
214156 | 214156 | 2020-06-06 | Grand Forks | North Dakota | 38035 | 336 | 4 |
217246 | 217246 | 2020-06-07 | Grand Forks | North Dakota | 38035 | 337 | 4 |
220338 | 220338 | 2020-06-08 | Grand Forks | North Dakota | 38035 | 339 | 4 |
223432 | 223432 | 2020-06-09 | Grand Forks | North Dakota | 38035 | 339 | 4 |
226532 | 226532 | 2020-06-10 | Grand Forks | North Dakota | 38035 | 339 | 4 |
229636 | 229636 | 2020-06-11 | Grand Forks | North Dakota | 38035 | 339 | 4 |
232741 | 232741 | 2020-06-12 | Grand Forks | North Dakota | 38035 | 341 | 4 |
235846 | 235846 | 2020-06-13 | Grand Forks | North Dakota | 38035 | 342 | 4 |
238954 | 238954 | 2020-06-14 | Grand Forks | North Dakota | 38035 | 343 | 4 |
242063 | 242063 | 2020-06-15 | Grand Forks | North Dakota | 38035 | 345 | 4 |
245175 | 245175 | 2020-06-16 | Grand Forks | North Dakota | 38035 | 346 | 4 |
248288 | 248288 | 2020-06-17 | Grand Forks | North Dakota | 38035 | 350 | 4 |
251403 | 251403 | 2020-06-18 | Grand Forks | North Dakota | 38035 | 356 | 4 |
254518 | 254518 | 2020-06-19 | Grand Forks | North Dakota | 38035 | 358 | 4 |
257643 | 257643 | 2020-06-20 | Grand Forks | North Dakota | 38035 | 361 | 4 |
260770 | 260770 | 2020-06-21 | Grand Forks | North Dakota | 38035 | 361 | 4 |
263898 | 263898 | 2020-06-22 | Grand Forks | North Dakota | 38035 | 365 | 4 |
267026 | 267026 | 2020-06-23 | Grand Forks | North Dakota | 38035 | 365 | 4 |
270160 | 270160 | 2020-06-24 | Grand Forks | North Dakota | 38035 | 366 | 4 |
273299 | 273299 | 2020-06-25 | Grand Forks | North Dakota | 38035 | 373 | 4 |
276445 | 276445 | 2020-06-26 | Grand Forks | North Dakota | 38035 | 376 | 4 |
279593 | 279593 | 2020-06-27 | Grand Forks | North Dakota | 38035 | 379 | 4 |
282739 | 282739 | 2020-06-28 | Grand Forks | North Dakota | 38035 | 384 | 4 |
285884 | 285884 | 2020-06-29 | Grand Forks | North Dakota | 38035 | 385 | 4 |
289034 | 289034 | 2020-06-30 | Grand Forks | North Dakota | 38035 | 385 | 4 |
292186 | 292186 | 2020-07-01 | Grand Forks | North Dakota | 38035 | 387 | 4 |
295341 | 295341 | 2020-07-02 | Grand Forks | North Dakota | 38035 | 390 | 4 |
298501 | 298501 | 2020-07-03 | Grand Forks | North Dakota | 38035 | 397 | 4 |
301664 | 301664 | 2020-07-04 | Grand Forks | North Dakota | 38035 | 402 | 4 |
304827 | 304827 | 2020-07-05 | Grand Forks | North Dakota | 38035 | 403 | 4 |
307994 | 307994 | 2020-07-06 | Grand Forks | North Dakota | 38035 | 406 | 4 |
311162 | 311162 | 2020-07-07 | Grand Forks | North Dakota | 38035 | 408 | 4 |
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);