ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Rutherford" and state = "Tennessee" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
261333 | 261333 | 2020-06-21 | Rutherford | Tennessee | 47149 | 2060 | 32 |
264461 | 264461 | 2020-06-22 | Rutherford | Tennessee | 47149 | 2100 | 32 |
267589 | 267589 | 2020-06-23 | Rutherford | Tennessee | 47149 | 2150 | 33 |
270723 | 270723 | 2020-06-24 | Rutherford | Tennessee | 47149 | 2211 | 33 |
273862 | 273862 | 2020-06-25 | Rutherford | Tennessee | 47149 | 2266 | 34 |
277009 | 277009 | 2020-06-26 | Rutherford | Tennessee | 47149 | 2337 | 34 |
280157 | 280157 | 2020-06-27 | Rutherford | Tennessee | 47149 | 2362 | 34 |
283303 | 283303 | 2020-06-28 | Rutherford | Tennessee | 47149 | 2362 | 34 |
286448 | 286448 | 2020-06-29 | Rutherford | Tennessee | 47149 | 2450 | 34 |
289599 | 289599 | 2020-06-30 | Rutherford | Tennessee | 47149 | 2528 | 34 |
292751 | 292751 | 2020-07-01 | Rutherford | Tennessee | 47149 | 2648 | 35 |
295907 | 295907 | 2020-07-02 | Rutherford | Tennessee | 47149 | 2733 | 35 |
299067 | 299067 | 2020-07-03 | Rutherford | Tennessee | 47149 | 2854 | 35 |
302231 | 302231 | 2020-07-04 | Rutherford | Tennessee | 47149 | 2919 | 35 |
305394 | 305394 | 2020-07-05 | Rutherford | Tennessee | 47149 | 2987 | 35 |
308562 | 308562 | 2020-07-06 | Rutherford | Tennessee | 47149 | 3040 | 35 |
311731 | 311731 | 2020-07-07 | Rutherford | Tennessee | 47149 | 3111 | 36 |
314905 | 314905 | 2020-07-08 | Rutherford | Tennessee | 47149 | 3234 | 37 |
318078 | 318078 | 2020-07-09 | Rutherford | Tennessee | 47149 | 3326 | 38 |
321256 | 321256 | 2020-07-10 | Rutherford | Tennessee | 47149 | 3428 | 39 |
324437 | 324437 | 2020-07-11 | Rutherford | Tennessee | 47149 | 3525 | 39 |
327622 | 327622 | 2020-07-12 | Rutherford | Tennessee | 47149 | 3602 | 39 |
330808 | 330808 | 2020-07-13 | Rutherford | Tennessee | 47149 | 3755 | 39 |
334000 | 334000 | 2020-07-14 | Rutherford | Tennessee | 47149 | 3839 | 39 |
337194 | 337194 | 2020-07-15 | Rutherford | Tennessee | 47149 | 3944 | 39 |
340391 | 340391 | 2020-07-16 | Rutherford | Tennessee | 47149 | 4114 | 40 |
343589 | 343589 | 2020-07-17 | Rutherford | Tennessee | 47149 | 4242 | 41 |
346789 | 346789 | 2020-07-18 | Rutherford | Tennessee | 47149 | 4397 | 41 |
349989 | 349989 | 2020-07-19 | Rutherford | Tennessee | 47149 | 4503 | 41 |
353192 | 353192 | 2020-07-20 | Rutherford | Tennessee | 47149 | 4618 | 41 |
356395 | 356395 | 2020-07-21 | Rutherford | Tennessee | 47149 | 4716 | 43 |
359599 | 359599 | 2020-07-22 | Rutherford | Tennessee | 47149 | 4828 | 43 |
362806 | 362806 | 2020-07-23 | Rutherford | Tennessee | 47149 | 5016 | 45 |
366012 | 366012 | 2020-07-24 | Rutherford | Tennessee | 47149 | 5127 | 45 |
369221 | 369221 | 2020-07-25 | Rutherford | Tennessee | 47149 | 5202 | 47 |
372433 | 372433 | 2020-07-26 | Rutherford | Tennessee | 47149 | 5389 | 47 |
375646 | 375646 | 2020-07-27 | Rutherford | Tennessee | 47149 | 5514 | 48 |
378862 | 378862 | 2020-07-28 | Rutherford | Tennessee | 47149 | 5579 | 48 |
382079 | 382079 | 2020-07-29 | Rutherford | Tennessee | 47149 | 5682 | 49 |
385297 | 385297 | 2020-07-30 | Rutherford | Tennessee | 47149 | 5753 | 49 |
388514 | 388514 | 2020-07-31 | Rutherford | Tennessee | 47149 | 5899 | 51 |
391731 | 391731 | 2020-08-01 | Rutherford | Tennessee | 47149 | 5999 | 51 |
394947 | 394947 | 2020-08-02 | Rutherford | Tennessee | 47149 | 6042 | 51 |
398164 | 398164 | 2020-08-03 | Rutherford | Tennessee | 47149 | 6072 | 53 |
401379 | 401379 | 2020-08-04 | Rutherford | Tennessee | 47149 | 6155 | 53 |
404597 | 404597 | 2020-08-05 | Rutherford | Tennessee | 47149 | 6254 | 53 |
407817 | 407817 | 2020-08-06 | Rutherford | Tennessee | 47149 | 6298 | 53 |
411036 | 411036 | 2020-08-07 | Rutherford | Tennessee | 47149 | 6404 | 53 |
414256 | 414256 | 2020-08-08 | Rutherford | Tennessee | 47149 | 6463 | 54 |
417477 | 417477 | 2020-08-09 | Rutherford | Tennessee | 47149 | 6553 | 54 |
420698 | 420698 | 2020-08-10 | Rutherford | Tennessee | 47149 | 6589 | 55 |
423920 | 423920 | 2020-08-11 | Rutherford | Tennessee | 47149 | 6629 | 55 |
427143 | 427143 | 2020-08-12 | Rutherford | Tennessee | 47149 | 6719 | 56 |
430370 | 430370 | 2020-08-13 | Rutherford | Tennessee | 47149 | 6834 | 55 |
433595 | 433595 | 2020-08-14 | Rutherford | Tennessee | 47149 | 6938 | 57 |
436822 | 436822 | 2020-08-15 | Rutherford | Tennessee | 47149 | 6999 | 59 |
440047 | 440047 | 2020-08-16 | Rutherford | Tennessee | 47149 | 7080 | 59 |
443274 | 443274 | 2020-08-17 | Rutherford | Tennessee | 47149 | 7137 | 59 |
446500 | 446500 | 2020-08-18 | Rutherford | Tennessee | 47149 | 7179 | 61 |
449728 | 449728 | 2020-08-19 | Rutherford | Tennessee | 47149 | 7223 | 61 |
452956 | 452956 | 2020-08-20 | Rutherford | Tennessee | 47149 | 7300 | 61 |
456184 | 456184 | 2020-08-21 | Rutherford | Tennessee | 47149 | 7363 | 65 |
459412 | 459412 | 2020-08-22 | Rutherford | Tennessee | 47149 | 7404 | 64 |
462640 | 462640 | 2020-08-23 | Rutherford | Tennessee | 47149 | 7461 | 64 |
465869 | 465869 | 2020-08-24 | Rutherford | Tennessee | 47149 | 7486 | 64 |
469098 | 469098 | 2020-08-25 | Rutherford | Tennessee | 47149 | 7523 | 67 |
472330 | 472330 | 2020-08-26 | Rutherford | Tennessee | 47149 | 7620 | 67 |
475563 | 475563 | 2020-08-27 | Rutherford | Tennessee | 47149 | 7670 | 67 |
478796 | 478796 | 2020-08-28 | Rutherford | Tennessee | 47149 | 7725 | 68 |
482030 | 482030 | 2020-08-29 | Rutherford | Tennessee | 47149 | 7770 | 68 |
485265 | 485265 | 2020-08-30 | Rutherford | Tennessee | 47149 | 7799 | 70 |
488498 | 488498 | 2020-08-31 | Rutherford | Tennessee | 47149 | 7825 | 70 |
491731 | 491731 | 2020-09-01 | Rutherford | Tennessee | 47149 | 7868 | 70 |
494965 | 494965 | 2020-09-02 | Rutherford | Tennessee | 47149 | 7930 | 70 |
498198 | 498198 | 2020-09-03 | Rutherford | Tennessee | 47149 | 8018 | 73 |
501432 | 501432 | 2020-09-04 | Rutherford | Tennessee | 47149 | 8059 | 77 |
504666 | 504666 | 2020-09-05 | Rutherford | Tennessee | 47149 | 8110 | 80 |
507898 | 507898 | 2020-09-06 | Rutherford | Tennessee | 47149 | 8159 | 80 |
511131 | 511131 | 2020-09-07 | Rutherford | Tennessee | 47149 | 8188 | 80 |
514364 | 514364 | 2020-09-08 | Rutherford | Tennessee | 47149 | 8242 | 80 |
517599 | 517599 | 2020-09-09 | Rutherford | Tennessee | 47149 | 8270 | 81 |
520835 | 520835 | 2020-09-10 | Rutherford | Tennessee | 47149 | 8387 | 82 |
524071 | 524071 | 2020-09-11 | Rutherford | Tennessee | 47149 | 8420 | 82 |
527307 | 527307 | 2020-09-12 | Rutherford | Tennessee | 47149 | 8492 | 84 |
530544 | 530544 | 2020-09-13 | Rutherford | Tennessee | 47149 | 8530 | 84 |
533779 | 533779 | 2020-09-14 | Rutherford | Tennessee | 47149 | 8629 | 84 |
537015 | 537015 | 2020-09-15 | Rutherford | Tennessee | 47149 | 8661 | 85 |
540252 | 540252 | 2020-09-16 | Rutherford | Tennessee | 47149 | 8718 | 85 |
543488 | 543488 | 2020-09-17 | Rutherford | Tennessee | 47149 | 8779 | 86 |
546725 | 546725 | 2020-09-18 | Rutherford | Tennessee | 47149 | 8869 | 87 |
549964 | 549964 | 2020-09-19 | Rutherford | Tennessee | 47149 | 8902 | 87 |
553203 | 553203 | 2020-09-20 | Rutherford | Tennessee | 47149 | 8986 | 87 |
556440 | 556440 | 2020-09-21 | Rutherford | Tennessee | 47149 | 9031 | 87 |
559677 | 559677 | 2020-09-22 | Rutherford | Tennessee | 47149 | 9058 | 88 |
562914 | 562914 | 2020-09-23 | Rutherford | Tennessee | 47149 | 9113 | 88 |
566155 | 566155 | 2020-09-24 | Rutherford | Tennessee | 47149 | 9150 | 88 |
569396 | 569396 | 2020-09-25 | Rutherford | Tennessee | 47149 | 9240 | 89 |
572638 | 572638 | 2020-09-26 | Rutherford | Tennessee | 47149 | 9293 | 89 |
575882 | 575882 | 2020-09-27 | Rutherford | Tennessee | 47149 | 9361 | 89 |
579123 | 579123 | 2020-09-28 | Rutherford | Tennessee | 47149 | 9408 | 90 |
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);