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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536436 | 536436 | 2020-09-15 | Grand Forks | North Dakota | 38035 | 1951 | 12 |
533200 | 533200 | 2020-09-14 | Grand Forks | North Dakota | 38035 | 1934 | 12 |
529965 | 529965 | 2020-09-13 | Grand Forks | North Dakota | 38035 | 1902 | 12 |
526728 | 526728 | 2020-09-12 | Grand Forks | North Dakota | 38035 | 1887 | 12 |
523492 | 523492 | 2020-09-11 | Grand Forks | North Dakota | 38035 | 1874 | 12 |
520256 | 520256 | 2020-09-10 | Grand Forks | North Dakota | 38035 | 1810 | 12 |
517020 | 517020 | 2020-09-09 | Grand Forks | North Dakota | 38035 | 1810 | 12 |
513785 | 513785 | 2020-09-08 | Grand Forks | North Dakota | 38035 | 1796 | 12 |
510552 | 510552 | 2020-09-07 | Grand Forks | North Dakota | 38035 | 1795 | 12 |
507319 | 507319 | 2020-09-06 | Grand Forks | North Dakota | 38035 | 1760 | 12 |
504087 | 504087 | 2020-09-05 | Grand Forks | North Dakota | 38035 | 1729 | 12 |
500853 | 500853 | 2020-09-04 | Grand Forks | North Dakota | 38035 | 1679 | 11 |
497619 | 497619 | 2020-09-03 | Grand Forks | North Dakota | 38035 | 1611 | 11 |
494386 | 494386 | 2020-09-02 | Grand Forks | North Dakota | 38035 | 1531 | 11 |
491152 | 491152 | 2020-09-01 | Grand Forks | North Dakota | 38035 | 1512 | 11 |
487919 | 487919 | 2020-08-31 | Grand Forks | North Dakota | 38035 | 1482 | 11 |
484686 | 484686 | 2020-08-30 | Grand Forks | North Dakota | 38035 | 1468 | 10 |
481451 | 481451 | 2020-08-29 | Grand Forks | North Dakota | 38035 | 1444 | 10 |
478218 | 478218 | 2020-08-28 | Grand Forks | North Dakota | 38035 | 1297 | 10 |
474985 | 474985 | 2020-08-27 | Grand Forks | North Dakota | 38035 | 1251 | 10 |
471751 | 471751 | 2020-08-26 | Grand Forks | North Dakota | 38035 | 1170 | 10 |
468519 | 468519 | 2020-08-25 | Grand Forks | North Dakota | 38035 | 1154 | 10 |
465291 | 465291 | 2020-08-24 | Grand Forks | North Dakota | 38035 | 1044 | 10 |
462062 | 462062 | 2020-08-23 | Grand Forks | North Dakota | 38035 | 1019 | 10 |
458834 | 458834 | 2020-08-22 | Grand Forks | North Dakota | 38035 | 980 | 10 |
455606 | 455606 | 2020-08-21 | Grand Forks | North Dakota | 38035 | 903 | 10 |
452378 | 452378 | 2020-08-20 | Grand Forks | North Dakota | 38035 | 858 | 10 |
449150 | 449150 | 2020-08-19 | Grand Forks | North Dakota | 38035 | 827 | 10 |
445922 | 445922 | 2020-08-18 | Grand Forks | North Dakota | 38035 | 805 | 9 |
442696 | 442696 | 2020-08-17 | Grand Forks | North Dakota | 38035 | 799 | 8 |
439469 | 439469 | 2020-08-16 | Grand Forks | North Dakota | 38035 | 789 | 8 |
436244 | 436244 | 2020-08-15 | Grand Forks | North Dakota | 38035 | 775 | 8 |
433018 | 433018 | 2020-08-14 | Grand Forks | North Dakota | 38035 | 737 | 8 |
429792 | 429792 | 2020-08-13 | Grand Forks | North Dakota | 38035 | 728 | 7 |
426567 | 426567 | 2020-08-12 | Grand Forks | North Dakota | 38035 | 710 | 7 |
423344 | 423344 | 2020-08-11 | Grand Forks | North Dakota | 38035 | 701 | 6 |
420121 | 420121 | 2020-08-10 | Grand Forks | North Dakota | 38035 | 683 | 6 |
416901 | 416901 | 2020-08-09 | Grand Forks | North Dakota | 38035 | 677 | 6 |
413680 | 413680 | 2020-08-08 | Grand Forks | North Dakota | 38035 | 672 | 6 |
410460 | 410460 | 2020-08-07 | Grand Forks | North Dakota | 38035 | 662 | 6 |
407240 | 407240 | 2020-08-06 | Grand Forks | North Dakota | 38035 | 657 | 6 |
404021 | 404021 | 2020-08-05 | Grand Forks | North Dakota | 38035 | 650 | 6 |
400803 | 400803 | 2020-08-04 | Grand Forks | North Dakota | 38035 | 642 | 5 |
397588 | 397588 | 2020-08-03 | Grand Forks | North Dakota | 38035 | 637 | 5 |
394371 | 394371 | 2020-08-02 | Grand Forks | North Dakota | 38035 | 626 | 5 |
391155 | 391155 | 2020-08-01 | Grand Forks | North Dakota | 38035 | 624 | 4 |
387938 | 387938 | 2020-07-31 | Grand Forks | North Dakota | 38035 | 619 | 4 |
384721 | 384721 | 2020-07-30 | Grand Forks | North Dakota | 38035 | 608 | 4 |
381503 | 381503 | 2020-07-29 | Grand Forks | North Dakota | 38035 | 607 | 4 |
378286 | 378286 | 2020-07-28 | Grand Forks | North Dakota | 38035 | 605 | 4 |
375069 | 375069 | 2020-07-27 | Grand Forks | North Dakota | 38035 | 601 | 4 |
371857 | 371857 | 2020-07-26 | Grand Forks | North Dakota | 38035 | 596 | 4 |
368645 | 368645 | 2020-07-25 | Grand Forks | North Dakota | 38035 | 575 | 4 |
365436 | 365436 | 2020-07-24 | Grand Forks | North Dakota | 38035 | 569 | 4 |
362230 | 362230 | 2020-07-23 | Grand Forks | North Dakota | 38035 | 560 | 4 |
359024 | 359024 | 2020-07-22 | Grand Forks | North Dakota | 38035 | 555 | 4 |
355820 | 355820 | 2020-07-21 | Grand Forks | North Dakota | 38035 | 549 | 4 |
352617 | 352617 | 2020-07-20 | Grand Forks | North Dakota | 38035 | 533 | 4 |
349414 | 349414 | 2020-07-19 | Grand Forks | North Dakota | 38035 | 509 | 4 |
346213 | 346213 | 2020-07-18 | Grand Forks | North Dakota | 38035 | 483 | 4 |
343014 | 343014 | 2020-07-17 | Grand Forks | North Dakota | 38035 | 481 | 4 |
339816 | 339816 | 2020-07-16 | Grand Forks | North Dakota | 38035 | 470 | 4 |
336620 | 336620 | 2020-07-15 | Grand Forks | North Dakota | 38035 | 462 | 4 |
333426 | 333426 | 2020-07-14 | Grand Forks | North Dakota | 38035 | 461 | 4 |
330235 | 330235 | 2020-07-13 | Grand Forks | North Dakota | 38035 | 458 | 4 |
327048 | 327048 | 2020-07-12 | Grand Forks | North Dakota | 38035 | 447 | 4 |
323864 | 323864 | 2020-07-11 | Grand Forks | North Dakota | 38035 | 431 | 4 |
320684 | 320684 | 2020-07-10 | Grand Forks | North Dakota | 38035 | 422 | 4 |
317507 | 317507 | 2020-07-09 | Grand Forks | North Dakota | 38035 | 412 | 4 |
314333 | 314333 | 2020-07-08 | Grand Forks | North Dakota | 38035 | 411 | 4 |
311162 | 311162 | 2020-07-07 | Grand Forks | North Dakota | 38035 | 408 | 4 |
307994 | 307994 | 2020-07-06 | Grand Forks | North Dakota | 38035 | 406 | 4 |
304827 | 304827 | 2020-07-05 | Grand Forks | North Dakota | 38035 | 403 | 4 |
301664 | 301664 | 2020-07-04 | Grand Forks | North Dakota | 38035 | 402 | 4 |
298501 | 298501 | 2020-07-03 | Grand Forks | North Dakota | 38035 | 397 | 4 |
295341 | 295341 | 2020-07-02 | Grand Forks | North Dakota | 38035 | 390 | 4 |
292186 | 292186 | 2020-07-01 | Grand Forks | North Dakota | 38035 | 387 | 4 |
289034 | 289034 | 2020-06-30 | Grand Forks | North Dakota | 38035 | 385 | 4 |
285884 | 285884 | 2020-06-29 | Grand Forks | North Dakota | 38035 | 385 | 4 |
282739 | 282739 | 2020-06-28 | Grand Forks | North Dakota | 38035 | 384 | 4 |
279593 | 279593 | 2020-06-27 | Grand Forks | North Dakota | 38035 | 379 | 4 |
276445 | 276445 | 2020-06-26 | Grand Forks | North Dakota | 38035 | 376 | 4 |
273299 | 273299 | 2020-06-25 | Grand Forks | North Dakota | 38035 | 373 | 4 |
270160 | 270160 | 2020-06-24 | Grand Forks | North Dakota | 38035 | 366 | 4 |
267026 | 267026 | 2020-06-23 | Grand Forks | North Dakota | 38035 | 365 | 4 |
263898 | 263898 | 2020-06-22 | Grand Forks | North Dakota | 38035 | 365 | 4 |
260770 | 260770 | 2020-06-21 | Grand Forks | North Dakota | 38035 | 361 | 4 |
257643 | 257643 | 2020-06-20 | Grand Forks | North Dakota | 38035 | 361 | 4 |
254518 | 254518 | 2020-06-19 | Grand Forks | North Dakota | 38035 | 358 | 4 |
251403 | 251403 | 2020-06-18 | Grand Forks | North Dakota | 38035 | 356 | 4 |
248288 | 248288 | 2020-06-17 | Grand Forks | North Dakota | 38035 | 350 | 4 |
245175 | 245175 | 2020-06-16 | Grand Forks | North Dakota | 38035 | 346 | 4 |
242063 | 242063 | 2020-06-15 | Grand Forks | North Dakota | 38035 | 345 | 4 |
238954 | 238954 | 2020-06-14 | Grand Forks | North Dakota | 38035 | 343 | 4 |
235846 | 235846 | 2020-06-13 | Grand Forks | North Dakota | 38035 | 342 | 4 |
232741 | 232741 | 2020-06-12 | Grand Forks | North Dakota | 38035 | 341 | 4 |
229636 | 229636 | 2020-06-11 | Grand Forks | North Dakota | 38035 | 339 | 4 |
226532 | 226532 | 2020-06-10 | Grand Forks | North Dakota | 38035 | 339 | 4 |
223432 | 223432 | 2020-06-09 | Grand Forks | North Dakota | 38035 | 339 | 4 |
220338 | 220338 | 2020-06-08 | Grand Forks | North Dakota | 38035 | 339 | 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);