ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 38015 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
273290 | 273290 | 2020-06-25 | Burleigh | North Dakota | 38015 | 217 | 0 |
276436 | 276436 | 2020-06-26 | Burleigh | North Dakota | 38015 | 223 | 0 |
279584 | 279584 | 2020-06-27 | Burleigh | North Dakota | 38015 | 234 | 0 |
282730 | 282730 | 2020-06-28 | Burleigh | North Dakota | 38015 | 241 | 0 |
285875 | 285875 | 2020-06-29 | Burleigh | North Dakota | 38015 | 249 | 0 |
289025 | 289025 | 2020-06-30 | Burleigh | North Dakota | 38015 | 258 | 0 |
292177 | 292177 | 2020-07-01 | Burleigh | North Dakota | 38015 | 267 | 0 |
295332 | 295332 | 2020-07-02 | Burleigh | North Dakota | 38015 | 281 | 0 |
298492 | 298492 | 2020-07-03 | Burleigh | North Dakota | 38015 | 302 | 0 |
301655 | 301655 | 2020-07-04 | Burleigh | North Dakota | 38015 | 314 | 0 |
304818 | 304818 | 2020-07-05 | Burleigh | North Dakota | 38015 | 322 | 0 |
307985 | 307985 | 2020-07-06 | Burleigh | North Dakota | 38015 | 328 | 0 |
311153 | 311153 | 2020-07-07 | Burleigh | North Dakota | 38015 | 343 | 0 |
314324 | 314324 | 2020-07-08 | Burleigh | North Dakota | 38015 | 363 | 0 |
317498 | 317498 | 2020-07-09 | Burleigh | North Dakota | 38015 | 385 | 0 |
320675 | 320675 | 2020-07-10 | Burleigh | North Dakota | 38015 | 409 | 0 |
323855 | 323855 | 2020-07-11 | Burleigh | North Dakota | 38015 | 425 | 0 |
327039 | 327039 | 2020-07-12 | Burleigh | North Dakota | 38015 | 444 | 0 |
330226 | 330226 | 2020-07-13 | Burleigh | North Dakota | 38015 | 466 | 0 |
333416 | 333416 | 2020-07-14 | Burleigh | North Dakota | 38015 | 469 | 0 |
336610 | 336610 | 2020-07-15 | Burleigh | North Dakota | 38015 | 478 | 0 |
339806 | 339806 | 2020-07-16 | Burleigh | North Dakota | 38015 | 500 | 0 |
343004 | 343004 | 2020-07-17 | Burleigh | North Dakota | 38015 | 525 | 0 |
346203 | 346203 | 2020-07-18 | Burleigh | North Dakota | 38015 | 548 | 0 |
349404 | 349404 | 2020-07-19 | Burleigh | North Dakota | 38015 | 564 | 1 |
352607 | 352607 | 2020-07-20 | Burleigh | North Dakota | 38015 | 580 | 1 |
355810 | 355810 | 2020-07-21 | Burleigh | North Dakota | 38015 | 595 | 1 |
359014 | 359014 | 2020-07-22 | Burleigh | North Dakota | 38015 | 633 | 2 |
362220 | 362220 | 2020-07-23 | Burleigh | North Dakota | 38015 | 680 | 3 |
365426 | 365426 | 2020-07-24 | Burleigh | North Dakota | 38015 | 696 | 3 |
368635 | 368635 | 2020-07-25 | Burleigh | North Dakota | 38015 | 729 | 3 |
371847 | 371847 | 2020-07-26 | Burleigh | North Dakota | 38015 | 763 | 3 |
375059 | 375059 | 2020-07-27 | Burleigh | North Dakota | 38015 | 788 | 3 |
378276 | 378276 | 2020-07-28 | Burleigh | North Dakota | 38015 | 839 | 3 |
381493 | 381493 | 2020-07-29 | Burleigh | North Dakota | 38015 | 866 | 4 |
384711 | 384711 | 2020-07-30 | Burleigh | North Dakota | 38015 | 877 | 4 |
387928 | 387928 | 2020-07-31 | Burleigh | North Dakota | 38015 | 915 | 4 |
391145 | 391145 | 2020-08-01 | Burleigh | North Dakota | 38015 | 944 | 4 |
394361 | 394361 | 2020-08-02 | Burleigh | North Dakota | 38015 | 961 | 5 |
397578 | 397578 | 2020-08-03 | Burleigh | North Dakota | 38015 | 979 | 5 |
400793 | 400793 | 2020-08-04 | Burleigh | North Dakota | 38015 | 1007 | 5 |
404011 | 404011 | 2020-08-05 | Burleigh | North Dakota | 38015 | 1049 | 5 |
407230 | 407230 | 2020-08-06 | Burleigh | North Dakota | 38015 | 1082 | 5 |
410450 | 410450 | 2020-08-07 | Burleigh | North Dakota | 38015 | 1108 | 5 |
413670 | 413670 | 2020-08-08 | Burleigh | North Dakota | 38015 | 1142 | 6 |
416891 | 416891 | 2020-08-09 | Burleigh | North Dakota | 38015 | 1171 | 6 |
420111 | 420111 | 2020-08-10 | Burleigh | North Dakota | 38015 | 1201 | 6 |
423334 | 423334 | 2020-08-11 | Burleigh | North Dakota | 38015 | 1244 | 8 |
426557 | 426557 | 2020-08-12 | Burleigh | North Dakota | 38015 | 1255 | 8 |
429782 | 429782 | 2020-08-13 | Burleigh | North Dakota | 38015 | 1294 | 8 |
433008 | 433008 | 2020-08-14 | Burleigh | North Dakota | 38015 | 1325 | 8 |
436234 | 436234 | 2020-08-15 | Burleigh | North Dakota | 38015 | 1344 | 8 |
439459 | 439459 | 2020-08-16 | Burleigh | North Dakota | 38015 | 1388 | 9 |
442686 | 442686 | 2020-08-17 | Burleigh | North Dakota | 38015 | 1409 | 11 |
445912 | 445912 | 2020-08-18 | Burleigh | North Dakota | 38015 | 1460 | 12 |
449140 | 449140 | 2020-08-19 | Burleigh | North Dakota | 38015 | 1502 | 12 |
452368 | 452368 | 2020-08-20 | Burleigh | North Dakota | 38015 | 1552 | 12 |
455596 | 455596 | 2020-08-21 | Burleigh | North Dakota | 38015 | 1625 | 12 |
458824 | 458824 | 2020-08-22 | Burleigh | North Dakota | 38015 | 1673 | 13 |
462052 | 462052 | 2020-08-23 | Burleigh | North Dakota | 38015 | 1701 | 13 |
465281 | 465281 | 2020-08-24 | Burleigh | North Dakota | 38015 | 1716 | 13 |
468509 | 468509 | 2020-08-25 | Burleigh | North Dakota | 38015 | 1750 | 13 |
471741 | 471741 | 2020-08-26 | Burleigh | North Dakota | 38015 | 1810 | 13 |
474975 | 474975 | 2020-08-27 | Burleigh | North Dakota | 38015 | 1865 | 14 |
478208 | 478208 | 2020-08-28 | Burleigh | North Dakota | 38015 | 1915 | 14 |
481441 | 481441 | 2020-08-29 | Burleigh | North Dakota | 38015 | 1943 | 15 |
484676 | 484676 | 2020-08-30 | Burleigh | North Dakota | 38015 | 1987 | 16 |
487909 | 487909 | 2020-08-31 | Burleigh | North Dakota | 38015 | 2016 | 16 |
491142 | 491142 | 2020-09-01 | Burleigh | North Dakota | 38015 | 2038 | 17 |
494376 | 494376 | 2020-09-02 | Burleigh | North Dakota | 38015 | 2099 | 18 |
497609 | 497609 | 2020-09-03 | Burleigh | North Dakota | 38015 | 2118 | 19 |
500843 | 500843 | 2020-09-04 | Burleigh | North Dakota | 38015 | 2157 | 19 |
504077 | 504077 | 2020-09-05 | Burleigh | North Dakota | 38015 | 2212 | 20 |
507309 | 507309 | 2020-09-06 | Burleigh | North Dakota | 38015 | 2290 | 20 |
510542 | 510542 | 2020-09-07 | Burleigh | North Dakota | 38015 | 2326 | 20 |
513775 | 513775 | 2020-09-08 | Burleigh | North Dakota | 38015 | 2348 | 20 |
517010 | 517010 | 2020-09-09 | Burleigh | North Dakota | 38015 | 2399 | 20 |
520246 | 520246 | 2020-09-10 | Burleigh | North Dakota | 38015 | 2461 | 22 |
523482 | 523482 | 2020-09-11 | Burleigh | North Dakota | 38015 | 2493 | 25 |
526718 | 526718 | 2020-09-12 | Burleigh | North Dakota | 38015 | 2554 | 25 |
529955 | 529955 | 2020-09-13 | Burleigh | North Dakota | 38015 | 2643 | 25 |
533190 | 533190 | 2020-09-14 | Burleigh | North Dakota | 38015 | 2685 | 26 |
536426 | 536426 | 2020-09-15 | Burleigh | North Dakota | 38015 | 2767 | 27 |
539663 | 539663 | 2020-09-16 | Burleigh | North Dakota | 38015 | 2782 | 30 |
542899 | 542899 | 2020-09-17 | Burleigh | North Dakota | 38015 | 2856 | 34 |
546136 | 546136 | 2020-09-18 | Burleigh | North Dakota | 38015 | 2943 | 36 |
549375 | 549375 | 2020-09-19 | Burleigh | North Dakota | 38015 | 3002 | 36 |
552614 | 552614 | 2020-09-20 | Burleigh | North Dakota | 38015 | 3080 | 36 |
555851 | 555851 | 2020-09-21 | Burleigh | North Dakota | 38015 | 3121 | 36 |
559088 | 559088 | 2020-09-22 | Burleigh | North Dakota | 38015 | 3201 | 36 |
562325 | 562325 | 2020-09-23 | Burleigh | North Dakota | 38015 | 3280 | 38 |
565566 | 565566 | 2020-09-24 | Burleigh | North Dakota | 38015 | 3399 | 40 |
568807 | 568807 | 2020-09-25 | Burleigh | North Dakota | 38015 | 3434 | 42 |
572049 | 572049 | 2020-09-26 | Burleigh | North Dakota | 38015 | 3525 | 43 |
575293 | 575293 | 2020-09-27 | Burleigh | North Dakota | 38015 | 3582 | 43 |
578534 | 578534 | 2020-09-28 | Burleigh | North Dakota | 38015 | 3651 | 45 |
581774 | 581774 | 2020-09-29 | Burleigh | North Dakota | 38015 | 3712 | 46 |
585015 | 585015 | 2020-09-30 | Burleigh | North Dakota | 38015 | 3790 | 49 |
588255 | 588255 | 2020-10-01 | Burleigh | North Dakota | 38015 | 3833 | 50 |
591496 | 591496 | 2020-10-02 | Burleigh | North Dakota | 38015 | 3914 | 53 |
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);