ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Grant" 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 |
---|---|---|---|---|---|---|---|
536437 | 536437 | 2020-09-15 | Grant | North Dakota | 38037 | 11 | 0 |
533201 | 533201 | 2020-09-14 | Grant | North Dakota | 38037 | 9 | 0 |
529966 | 529966 | 2020-09-13 | Grant | North Dakota | 38037 | 9 | 0 |
526729 | 526729 | 2020-09-12 | Grant | North Dakota | 38037 | 9 | 0 |
523493 | 523493 | 2020-09-11 | Grant | North Dakota | 38037 | 9 | 0 |
520257 | 520257 | 2020-09-10 | Grant | North Dakota | 38037 | 9 | 0 |
517021 | 517021 | 2020-09-09 | Grant | North Dakota | 38037 | 9 | 0 |
513786 | 513786 | 2020-09-08 | Grant | North Dakota | 38037 | 9 | 0 |
510553 | 510553 | 2020-09-07 | Grant | North Dakota | 38037 | 9 | 0 |
507320 | 507320 | 2020-09-06 | Grant | North Dakota | 38037 | 9 | 0 |
504088 | 504088 | 2020-09-05 | Grant | North Dakota | 38037 | 9 | 0 |
500854 | 500854 | 2020-09-04 | Grant | North Dakota | 38037 | 9 | 0 |
497620 | 497620 | 2020-09-03 | Grant | North Dakota | 38037 | 9 | 0 |
494387 | 494387 | 2020-09-02 | Grant | North Dakota | 38037 | 9 | 0 |
491153 | 491153 | 2020-09-01 | Grant | North Dakota | 38037 | 9 | 0 |
487920 | 487920 | 2020-08-31 | Grant | North Dakota | 38037 | 9 | 0 |
484687 | 484687 | 2020-08-30 | Grant | North Dakota | 38037 | 9 | 0 |
481452 | 481452 | 2020-08-29 | Grant | North Dakota | 38037 | 9 | 0 |
478219 | 478219 | 2020-08-28 | Grant | North Dakota | 38037 | 9 | 0 |
474986 | 474986 | 2020-08-27 | Grant | North Dakota | 38037 | 9 | 0 |
471752 | 471752 | 2020-08-26 | Grant | North Dakota | 38037 | 9 | 0 |
468520 | 468520 | 2020-08-25 | Grant | North Dakota | 38037 | 9 | 0 |
465292 | 465292 | 2020-08-24 | Grant | North Dakota | 38037 | 9 | 0 |
462063 | 462063 | 2020-08-23 | Grant | North Dakota | 38037 | 9 | 0 |
458835 | 458835 | 2020-08-22 | Grant | North Dakota | 38037 | 8 | 0 |
455607 | 455607 | 2020-08-21 | Grant | North Dakota | 38037 | 5 | 0 |
452379 | 452379 | 2020-08-20 | Grant | North Dakota | 38037 | 4 | 0 |
449151 | 449151 | 2020-08-19 | Grant | North Dakota | 38037 | 4 | 0 |
445923 | 445923 | 2020-08-18 | Grant | North Dakota | 38037 | 4 | 0 |
442697 | 442697 | 2020-08-17 | Grant | North Dakota | 38037 | 4 | 0 |
439470 | 439470 | 2020-08-16 | Grant | North Dakota | 38037 | 4 | 0 |
436245 | 436245 | 2020-08-15 | Grant | North Dakota | 38037 | 4 | 0 |
433019 | 433019 | 2020-08-14 | Grant | North Dakota | 38037 | 4 | 0 |
429793 | 429793 | 2020-08-13 | Grant | North Dakota | 38037 | 4 | 0 |
426568 | 426568 | 2020-08-12 | Grant | North Dakota | 38037 | 4 | 0 |
423345 | 423345 | 2020-08-11 | Grant | North Dakota | 38037 | 4 | 0 |
420122 | 420122 | 2020-08-10 | Grant | North Dakota | 38037 | 4 | 0 |
416902 | 416902 | 2020-08-09 | Grant | North Dakota | 38037 | 4 | 0 |
413681 | 413681 | 2020-08-08 | Grant | North Dakota | 38037 | 4 | 0 |
410461 | 410461 | 2020-08-07 | Grant | North Dakota | 38037 | 4 | 0 |
407241 | 407241 | 2020-08-06 | Grant | North Dakota | 38037 | 4 | 0 |
404022 | 404022 | 2020-08-05 | Grant | North Dakota | 38037 | 4 | 0 |
400804 | 400804 | 2020-08-04 | Grant | North Dakota | 38037 | 4 | 0 |
397589 | 397589 | 2020-08-03 | Grant | North Dakota | 38037 | 4 | 0 |
394372 | 394372 | 2020-08-02 | Grant | North Dakota | 38037 | 4 | 0 |
391156 | 391156 | 2020-08-01 | Grant | North Dakota | 38037 | 4 | 0 |
387939 | 387939 | 2020-07-31 | Grant | North Dakota | 38037 | 4 | 0 |
384722 | 384722 | 2020-07-30 | Grant | North Dakota | 38037 | 4 | 0 |
381504 | 381504 | 2020-07-29 | Grant | North Dakota | 38037 | 4 | 0 |
378287 | 378287 | 2020-07-28 | Grant | North Dakota | 38037 | 4 | 0 |
375070 | 375070 | 2020-07-27 | Grant | North Dakota | 38037 | 4 | 0 |
371858 | 371858 | 2020-07-26 | Grant | North Dakota | 38037 | 4 | 0 |
368646 | 368646 | 2020-07-25 | Grant | North Dakota | 38037 | 4 | 0 |
365437 | 365437 | 2020-07-24 | Grant | North Dakota | 38037 | 4 | 0 |
362231 | 362231 | 2020-07-23 | Grant | North Dakota | 38037 | 4 | 0 |
359025 | 359025 | 2020-07-22 | Grant | North Dakota | 38037 | 4 | 0 |
355821 | 355821 | 2020-07-21 | Grant | North Dakota | 38037 | 4 | 0 |
352618 | 352618 | 2020-07-20 | Grant | North Dakota | 38037 | 4 | 0 |
349415 | 349415 | 2020-07-19 | Grant | North Dakota | 38037 | 4 | 0 |
346214 | 346214 | 2020-07-18 | Grant | North Dakota | 38037 | 4 | 0 |
343015 | 343015 | 2020-07-17 | Grant | North Dakota | 38037 | 4 | 0 |
339817 | 339817 | 2020-07-16 | Grant | North Dakota | 38037 | 4 | 0 |
336621 | 336621 | 2020-07-15 | Grant | North Dakota | 38037 | 4 | 0 |
333427 | 333427 | 2020-07-14 | Grant | North Dakota | 38037 | 4 | 0 |
330236 | 330236 | 2020-07-13 | Grant | North Dakota | 38037 | 4 | 0 |
327049 | 327049 | 2020-07-12 | Grant | North Dakota | 38037 | 3 | 0 |
323865 | 323865 | 2020-07-11 | Grant | North Dakota | 38037 | 3 | 0 |
320685 | 320685 | 2020-07-10 | Grant | North Dakota | 38037 | 3 | 0 |
317508 | 317508 | 2020-07-09 | Grant | North Dakota | 38037 | 3 | 0 |
314334 | 314334 | 2020-07-08 | Grant | North Dakota | 38037 | 3 | 0 |
311163 | 311163 | 2020-07-07 | Grant | North Dakota | 38037 | 3 | 0 |
307995 | 307995 | 2020-07-06 | Grant | North Dakota | 38037 | 3 | 0 |
304828 | 304828 | 2020-07-05 | Grant | North Dakota | 38037 | 3 | 0 |
301665 | 301665 | 2020-07-04 | Grant | North Dakota | 38037 | 3 | 0 |
298502 | 298502 | 2020-07-03 | Grant | North Dakota | 38037 | 3 | 0 |
295342 | 295342 | 2020-07-02 | Grant | North Dakota | 38037 | 3 | 0 |
292187 | 292187 | 2020-07-01 | Grant | North Dakota | 38037 | 3 | 0 |
289035 | 289035 | 2020-06-30 | Grant | North Dakota | 38037 | 3 | 0 |
285885 | 285885 | 2020-06-29 | Grant | North Dakota | 38037 | 3 | 0 |
282740 | 282740 | 2020-06-28 | Grant | North Dakota | 38037 | 3 | 0 |
279594 | 279594 | 2020-06-27 | Grant | North Dakota | 38037 | 2 | 0 |
276446 | 276446 | 2020-06-26 | Grant | North Dakota | 38037 | 2 | 0 |
273300 | 273300 | 2020-06-25 | Grant | North Dakota | 38037 | 2 | 0 |
270161 | 270161 | 2020-06-24 | Grant | North Dakota | 38037 | 2 | 0 |
267027 | 267027 | 2020-06-23 | Grant | North Dakota | 38037 | 2 | 0 |
263899 | 263899 | 2020-06-22 | Grant | North Dakota | 38037 | 2 | 0 |
260771 | 260771 | 2020-06-21 | Grant | North Dakota | 38037 | 2 | 0 |
257644 | 257644 | 2020-06-20 | Grant | North Dakota | 38037 | 2 | 0 |
254519 | 254519 | 2020-06-19 | Grant | North Dakota | 38037 | 2 | 0 |
251404 | 251404 | 2020-06-18 | Grant | North Dakota | 38037 | 2 | 0 |
248289 | 248289 | 2020-06-17 | Grant | North Dakota | 38037 | 2 | 0 |
245176 | 245176 | 2020-06-16 | Grant | North Dakota | 38037 | 2 | 0 |
242064 | 242064 | 2020-06-15 | Grant | North Dakota | 38037 | 2 | 0 |
238955 | 238955 | 2020-06-14 | Grant | North Dakota | 38037 | 2 | 0 |
235847 | 235847 | 2020-06-13 | Grant | North Dakota | 38037 | 2 | 0 |
232742 | 232742 | 2020-06-12 | Grant | North Dakota | 38037 | 2 | 0 |
229637 | 229637 | 2020-06-11 | Grant | North Dakota | 38037 | 2 | 0 |
226533 | 226533 | 2020-06-10 | Grant | North Dakota | 38037 | 2 | 0 |
223433 | 223433 | 2020-06-09 | Grant | North Dakota | 38037 | 2 | 0 |
220339 | 220339 | 2020-06-08 | Grant | North Dakota | 38037 | 2 | 0 |
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);