ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Greene" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637439 | 637439 | 2020-10-16 | Greene | Tennessee | 47059 | 1444 | 48 |
634193 | 634193 | 2020-10-15 | Greene | Tennessee | 47059 | 1435 | 48 |
630948 | 630948 | 2020-10-14 | Greene | Tennessee | 47059 | 1383 | 48 |
627704 | 627704 | 2020-10-13 | Greene | Tennessee | 47059 | 1374 | 48 |
624462 | 624462 | 2020-10-12 | Greene | Tennessee | 47059 | 1365 | 48 |
621219 | 621219 | 2020-10-11 | Greene | Tennessee | 47059 | 1336 | 48 |
617976 | 617976 | 2020-10-10 | Greene | Tennessee | 47059 | 1308 | 48 |
614734 | 614734 | 2020-10-09 | Greene | Tennessee | 47059 | 1288 | 48 |
611493 | 611493 | 2020-10-08 | Greene | Tennessee | 47059 | 1268 | 48 |
608251 | 608251 | 2020-10-07 | Greene | Tennessee | 47059 | 1258 | 48 |
605008 | 605008 | 2020-10-06 | Greene | Tennessee | 47059 | 1234 | 48 |
601766 | 601766 | 2020-10-05 | Greene | Tennessee | 47059 | 1230 | 48 |
598523 | 598523 | 2020-10-04 | Greene | Tennessee | 47059 | 1214 | 48 |
595280 | 595280 | 2020-10-03 | Greene | Tennessee | 47059 | 1200 | 48 |
592039 | 592039 | 2020-10-02 | Greene | Tennessee | 47059 | 1198 | 46 |
588798 | 588798 | 2020-10-01 | Greene | Tennessee | 47059 | 1189 | 46 |
585558 | 585558 | 2020-09-30 | Greene | Tennessee | 47059 | 1185 | 46 |
582318 | 582318 | 2020-09-29 | Greene | Tennessee | 47059 | 1169 | 46 |
579078 | 579078 | 2020-09-28 | Greene | Tennessee | 47059 | 1166 | 44 |
575837 | 575837 | 2020-09-27 | Greene | Tennessee | 47059 | 1161 | 44 |
572593 | 572593 | 2020-09-26 | Greene | Tennessee | 47059 | 1156 | 44 |
569351 | 569351 | 2020-09-25 | Greene | Tennessee | 47059 | 1142 | 44 |
566110 | 566110 | 2020-09-24 | Greene | Tennessee | 47059 | 1129 | 43 |
562869 | 562869 | 2020-09-23 | Greene | Tennessee | 47059 | 1118 | 39 |
559632 | 559632 | 2020-09-22 | Greene | Tennessee | 47059 | 1112 | 37 |
556395 | 556395 | 2020-09-21 | Greene | Tennessee | 47059 | 1107 | 37 |
553158 | 553158 | 2020-09-20 | Greene | Tennessee | 47059 | 1106 | 37 |
549919 | 549919 | 2020-09-19 | Greene | Tennessee | 47059 | 1079 | 36 |
546680 | 546680 | 2020-09-18 | Greene | Tennessee | 47059 | 1075 | 36 |
543443 | 543443 | 2020-09-17 | Greene | Tennessee | 47059 | 1037 | 34 |
540207 | 540207 | 2020-09-16 | Greene | Tennessee | 47059 | 1026 | 32 |
536970 | 536970 | 2020-09-15 | Greene | Tennessee | 47059 | 1018 | 32 |
533734 | 533734 | 2020-09-14 | Greene | Tennessee | 47059 | 1010 | 30 |
530499 | 530499 | 2020-09-13 | Greene | Tennessee | 47059 | 979 | 28 |
527262 | 527262 | 2020-09-12 | Greene | Tennessee | 47059 | 976 | 28 |
524026 | 524026 | 2020-09-11 | Greene | Tennessee | 47059 | 974 | 28 |
520790 | 520790 | 2020-09-10 | Greene | Tennessee | 47059 | 962 | 23 |
517554 | 517554 | 2020-09-09 | Greene | Tennessee | 47059 | 948 | 22 |
514319 | 514319 | 2020-09-08 | Greene | Tennessee | 47059 | 938 | 19 |
511086 | 511086 | 2020-09-07 | Greene | Tennessee | 47059 | 937 | 19 |
507853 | 507853 | 2020-09-06 | Greene | Tennessee | 47059 | 926 | 19 |
504621 | 504621 | 2020-09-05 | Greene | Tennessee | 47059 | 916 | 19 |
501387 | 501387 | 2020-09-04 | Greene | Tennessee | 47059 | 890 | 18 |
498153 | 498153 | 2020-09-03 | Greene | Tennessee | 47059 | 878 | 18 |
494920 | 494920 | 2020-09-02 | Greene | Tennessee | 47059 | 857 | 17 |
491686 | 491686 | 2020-09-01 | Greene | Tennessee | 47059 | 844 | 16 |
488453 | 488453 | 2020-08-31 | Greene | Tennessee | 47059 | 820 | 16 |
485220 | 485220 | 2020-08-30 | Greene | Tennessee | 47059 | 814 | 16 |
481985 | 481985 | 2020-08-29 | Greene | Tennessee | 47059 | 816 | 16 |
478751 | 478751 | 2020-08-28 | Greene | Tennessee | 47059 | 800 | 16 |
475518 | 475518 | 2020-08-27 | Greene | Tennessee | 47059 | 779 | 11 |
472285 | 472285 | 2020-08-26 | Greene | Tennessee | 47059 | 759 | 11 |
469053 | 469053 | 2020-08-25 | Greene | Tennessee | 47059 | 738 | 11 |
465824 | 465824 | 2020-08-24 | Greene | Tennessee | 47059 | 730 | 10 |
462595 | 462595 | 2020-08-23 | Greene | Tennessee | 47059 | 721 | 10 |
459367 | 459367 | 2020-08-22 | Greene | Tennessee | 47059 | 712 | 10 |
456139 | 456139 | 2020-08-21 | Greene | Tennessee | 47059 | 685 | 10 |
452911 | 452911 | 2020-08-20 | Greene | Tennessee | 47059 | 669 | 9 |
449683 | 449683 | 2020-08-19 | Greene | Tennessee | 47059 | 653 | 9 |
446455 | 446455 | 2020-08-18 | Greene | Tennessee | 47059 | 627 | 9 |
443229 | 443229 | 2020-08-17 | Greene | Tennessee | 47059 | 609 | 9 |
440002 | 440002 | 2020-08-16 | Greene | Tennessee | 47059 | 605 | 9 |
436777 | 436777 | 2020-08-15 | Greene | Tennessee | 47059 | 563 | 9 |
433550 | 433550 | 2020-08-14 | Greene | Tennessee | 47059 | 561 | 9 |
430325 | 430325 | 2020-08-13 | Greene | Tennessee | 47059 | 552 | 9 |
427098 | 427098 | 2020-08-12 | Greene | Tennessee | 47059 | 524 | 9 |
423875 | 423875 | 2020-08-11 | Greene | Tennessee | 47059 | 504 | 9 |
420653 | 420653 | 2020-08-10 | Greene | Tennessee | 47059 | 504 | 8 |
417432 | 417432 | 2020-08-09 | Greene | Tennessee | 47059 | 492 | 8 |
414211 | 414211 | 2020-08-08 | Greene | Tennessee | 47059 | 467 | 8 |
410991 | 410991 | 2020-08-07 | Greene | Tennessee | 47059 | 447 | 7 |
407772 | 407772 | 2020-08-06 | Greene | Tennessee | 47059 | 418 | 7 |
404552 | 404552 | 2020-08-05 | Greene | Tennessee | 47059 | 398 | 6 |
401334 | 401334 | 2020-08-04 | Greene | Tennessee | 47059 | 376 | 5 |
398119 | 398119 | 2020-08-03 | Greene | Tennessee | 47059 | 371 | 5 |
394902 | 394902 | 2020-08-02 | Greene | Tennessee | 47059 | 369 | 5 |
391686 | 391686 | 2020-08-01 | Greene | Tennessee | 47059 | 362 | 5 |
388469 | 388469 | 2020-07-31 | Greene | Tennessee | 47059 | 344 | 5 |
385252 | 385252 | 2020-07-30 | Greene | Tennessee | 47059 | 324 | 5 |
382034 | 382034 | 2020-07-29 | Greene | Tennessee | 47059 | 316 | 5 |
378817 | 378817 | 2020-07-28 | Greene | Tennessee | 47059 | 300 | 5 |
375601 | 375601 | 2020-07-27 | Greene | Tennessee | 47059 | 295 | 5 |
372388 | 372388 | 2020-07-26 | Greene | Tennessee | 47059 | 284 | 5 |
369176 | 369176 | 2020-07-25 | Greene | Tennessee | 47059 | 261 | 5 |
365967 | 365967 | 2020-07-24 | Greene | Tennessee | 47059 | 248 | 5 |
362761 | 362761 | 2020-07-23 | Greene | Tennessee | 47059 | 243 | 4 |
359554 | 359554 | 2020-07-22 | Greene | Tennessee | 47059 | 237 | 4 |
356350 | 356350 | 2020-07-21 | Greene | Tennessee | 47059 | 238 | 4 |
353147 | 353147 | 2020-07-20 | Greene | Tennessee | 47059 | 223 | 3 |
349944 | 349944 | 2020-07-19 | Greene | Tennessee | 47059 | 209 | 3 |
346744 | 346744 | 2020-07-18 | Greene | Tennessee | 47059 | 196 | 3 |
343544 | 343544 | 2020-07-17 | Greene | Tennessee | 47059 | 193 | 2 |
340346 | 340346 | 2020-07-16 | Greene | Tennessee | 47059 | 187 | 2 |
337149 | 337149 | 2020-07-15 | Greene | Tennessee | 47059 | 173 | 2 |
333955 | 333955 | 2020-07-14 | Greene | Tennessee | 47059 | 163 | 2 |
330763 | 330763 | 2020-07-13 | Greene | Tennessee | 47059 | 157 | 2 |
327577 | 327577 | 2020-07-12 | Greene | Tennessee | 47059 | 151 | 2 |
324392 | 324392 | 2020-07-11 | Greene | Tennessee | 47059 | 151 | 2 |
321211 | 321211 | 2020-07-10 | Greene | Tennessee | 47059 | 138 | 2 |
318033 | 318033 | 2020-07-09 | Greene | Tennessee | 47059 | 123 | 2 |
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);