ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Davidson" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637428 | 637428 | 2020-10-16 | Davidson | Tennessee | 47037 | 31178 | 324 |
634182 | 634182 | 2020-10-15 | Davidson | Tennessee | 47037 | 31011 | 324 |
630937 | 630937 | 2020-10-14 | Davidson | Tennessee | 47037 | 30957 | 323 |
627693 | 627693 | 2020-10-13 | Davidson | Tennessee | 47037 | 30829 | 322 |
624451 | 624451 | 2020-10-12 | Davidson | Tennessee | 47037 | 30575 | 321 |
621208 | 621208 | 2020-10-11 | Davidson | Tennessee | 47037 | 30366 | 321 |
617965 | 617965 | 2020-10-10 | Davidson | Tennessee | 47037 | 30196 | 321 |
614723 | 614723 | 2020-10-09 | Davidson | Tennessee | 47037 | 30045 | 321 |
611482 | 611482 | 2020-10-08 | Davidson | Tennessee | 47037 | 29915 | 319 |
608240 | 608240 | 2020-10-07 | Davidson | Tennessee | 47037 | 29790 | 319 |
604997 | 604997 | 2020-10-06 | Davidson | Tennessee | 47037 | 29630 | 317 |
601755 | 601755 | 2020-10-05 | Davidson | Tennessee | 47037 | 29395 | 316 |
598512 | 598512 | 2020-10-04 | Davidson | Tennessee | 47037 | 29225 | 316 |
595269 | 595269 | 2020-10-03 | Davidson | Tennessee | 47037 | 29158 | 313 |
592028 | 592028 | 2020-10-02 | Davidson | Tennessee | 47037 | 29136 | 313 |
588787 | 588787 | 2020-10-01 | Davidson | Tennessee | 47037 | 29065 | 313 |
585547 | 585547 | 2020-09-30 | Davidson | Tennessee | 47037 | 29005 | 312 |
582307 | 582307 | 2020-09-29 | Davidson | Tennessee | 47037 | 28911 | 311 |
579067 | 579067 | 2020-09-28 | Davidson | Tennessee | 47037 | 28846 | 307 |
575826 | 575826 | 2020-09-27 | Davidson | Tennessee | 47037 | 28653 | 306 |
572582 | 572582 | 2020-09-26 | Davidson | Tennessee | 47037 | 28551 | 306 |
569340 | 569340 | 2020-09-25 | Davidson | Tennessee | 47037 | 28415 | 303 |
566099 | 566099 | 2020-09-24 | Davidson | Tennessee | 47037 | 28392 | 298 |
562858 | 562858 | 2020-09-23 | Davidson | Tennessee | 47037 | 28287 | 297 |
559621 | 559621 | 2020-09-22 | Davidson | Tennessee | 47037 | 28223 | 294 |
556384 | 556384 | 2020-09-21 | Davidson | Tennessee | 47037 | 28169 | 293 |
553147 | 553147 | 2020-09-20 | Davidson | Tennessee | 47037 | 28002 | 289 |
549908 | 549908 | 2020-09-19 | Davidson | Tennessee | 47037 | 27927 | 289 |
546669 | 546669 | 2020-09-18 | Davidson | Tennessee | 47037 | 27761 | 287 |
543432 | 543432 | 2020-09-17 | Davidson | Tennessee | 47037 | 27693 | 284 |
540196 | 540196 | 2020-09-16 | Davidson | Tennessee | 47037 | 27563 | 284 |
536959 | 536959 | 2020-09-15 | Davidson | Tennessee | 47037 | 27492 | 283 |
533723 | 533723 | 2020-09-14 | Davidson | Tennessee | 47037 | 27300 | 281 |
530488 | 530488 | 2020-09-13 | Davidson | Tennessee | 47037 | 27189 | 279 |
527251 | 527251 | 2020-09-12 | Davidson | Tennessee | 47037 | 27153 | 277 |
524015 | 524015 | 2020-09-11 | Davidson | Tennessee | 47037 | 27009 | 274 |
520779 | 520779 | 2020-09-10 | Davidson | Tennessee | 47037 | 26988 | 274 |
517543 | 517543 | 2020-09-09 | Davidson | Tennessee | 47037 | 26889 | 269 |
514308 | 514308 | 2020-09-08 | Davidson | Tennessee | 47037 | 26827 | 267 |
511075 | 511075 | 2020-09-07 | Davidson | Tennessee | 47037 | 26686 | 264 |
507842 | 507842 | 2020-09-06 | Davidson | Tennessee | 47037 | 26432 | 264 |
504610 | 504610 | 2020-09-05 | Davidson | Tennessee | 47037 | 26314 | 264 |
501376 | 501376 | 2020-09-04 | Davidson | Tennessee | 47037 | 26279 | 261 |
498142 | 498142 | 2020-09-03 | Davidson | Tennessee | 47037 | 26235 | 259 |
494909 | 494909 | 2020-09-02 | Davidson | Tennessee | 47037 | 26162 | 260 |
491675 | 491675 | 2020-09-01 | Davidson | Tennessee | 47037 | 26019 | 259 |
488442 | 488442 | 2020-08-31 | Davidson | Tennessee | 47037 | 25975 | 259 |
485209 | 485209 | 2020-08-30 | Davidson | Tennessee | 47037 | 25945 | 258 |
481974 | 481974 | 2020-08-29 | Davidson | Tennessee | 47037 | 25860 | 255 |
478740 | 478740 | 2020-08-28 | Davidson | Tennessee | 47037 | 25715 | 254 |
475507 | 475507 | 2020-08-27 | Davidson | Tennessee | 47037 | 25589 | 251 |
472274 | 472274 | 2020-08-26 | Davidson | Tennessee | 47037 | 25452 | 250 |
469042 | 469042 | 2020-08-25 | Davidson | Tennessee | 47037 | 25384 | 249 |
465813 | 465813 | 2020-08-24 | Davidson | Tennessee | 47037 | 25326 | 246 |
462584 | 462584 | 2020-08-23 | Davidson | Tennessee | 47037 | 25180 | 245 |
459356 | 459356 | 2020-08-22 | Davidson | Tennessee | 47037 | 25144 | 245 |
456128 | 456128 | 2020-08-21 | Davidson | Tennessee | 47037 | 24963 | 245 |
452900 | 452900 | 2020-08-20 | Davidson | Tennessee | 47037 | 24840 | 242 |
449672 | 449672 | 2020-08-19 | Davidson | Tennessee | 47037 | 24696 | 235 |
446444 | 446444 | 2020-08-18 | Davidson | Tennessee | 47037 | 24514 | 231 |
443218 | 443218 | 2020-08-17 | Davidson | Tennessee | 47037 | 24388 | 230 |
439991 | 439991 | 2020-08-16 | Davidson | Tennessee | 47037 | 24143 | 227 |
436766 | 436766 | 2020-08-15 | Davidson | Tennessee | 47037 | 24036 | 220 |
433539 | 433539 | 2020-08-14 | Davidson | Tennessee | 47037 | 23808 | 221 |
430314 | 430314 | 2020-08-13 | Davidson | Tennessee | 47037 | 23595 | 221 |
427087 | 427087 | 2020-08-12 | Davidson | Tennessee | 47037 | 23434 | 221 |
423864 | 423864 | 2020-08-11 | Davidson | Tennessee | 47037 | 23305 | 219 |
420642 | 420642 | 2020-08-10 | Davidson | Tennessee | 47037 | 23191 | 217 |
417421 | 417421 | 2020-08-09 | Davidson | Tennessee | 47037 | 22904 | 213 |
414200 | 414200 | 2020-08-08 | Davidson | Tennessee | 47037 | 22714 | 213 |
410980 | 410980 | 2020-08-07 | Davidson | Tennessee | 47037 | 22446 | 212 |
407761 | 407761 | 2020-08-06 | Davidson | Tennessee | 47037 | 22247 | 211 |
404541 | 404541 | 2020-08-05 | Davidson | Tennessee | 47037 | 21997 | 208 |
401323 | 401323 | 2020-08-04 | Davidson | Tennessee | 47037 | 21879 | 205 |
398108 | 398108 | 2020-08-03 | Davidson | Tennessee | 47037 | 21770 | 202 |
394891 | 394891 | 2020-08-02 | Davidson | Tennessee | 47037 | 21575 | 199 |
391675 | 391675 | 2020-08-01 | Davidson | Tennessee | 47037 | 21410 | 198 |
388458 | 388458 | 2020-07-31 | Davidson | Tennessee | 47037 | 21060 | 198 |
385241 | 385241 | 2020-07-30 | Davidson | Tennessee | 47037 | 20928 | 195 |
382023 | 382023 | 2020-07-29 | Davidson | Tennessee | 47037 | 20517 | 194 |
378806 | 378806 | 2020-07-28 | Davidson | Tennessee | 47037 | 20517 | 194 |
375590 | 375590 | 2020-07-27 | Davidson | Tennessee | 47037 | 20154 | 188 |
372377 | 372377 | 2020-07-26 | Davidson | Tennessee | 47037 | 19744 | 186 |
369165 | 369165 | 2020-07-25 | Davidson | Tennessee | 47037 | 19374 | 186 |
365956 | 365956 | 2020-07-24 | Davidson | Tennessee | 47037 | 19124 | 179 |
362750 | 362750 | 2020-07-23 | Davidson | Tennessee | 47037 | 18830 | 179 |
359543 | 359543 | 2020-07-22 | Davidson | Tennessee | 47037 | 18423 | 173 |
356339 | 356339 | 2020-07-21 | Davidson | Tennessee | 47037 | 18076 | 172 |
353136 | 353136 | 2020-07-20 | Davidson | Tennessee | 47037 | 17836 | 166 |
349933 | 349933 | 2020-07-19 | Davidson | Tennessee | 47037 | 17420 | 166 |
346733 | 346733 | 2020-07-18 | Davidson | Tennessee | 47037 | 16972 | 166 |
343533 | 343533 | 2020-07-17 | Davidson | Tennessee | 47037 | 16532 | 164 |
340335 | 340335 | 2020-07-16 | Davidson | Tennessee | 47037 | 16079 | 160 |
337138 | 337138 | 2020-07-15 | Davidson | Tennessee | 47037 | 15757 | 157 |
333944 | 333944 | 2020-07-14 | Davidson | Tennessee | 47037 | 15473 | 155 |
330752 | 330752 | 2020-07-13 | Davidson | Tennessee | 47037 | 14702 | 146 |
327566 | 327566 | 2020-07-12 | Davidson | Tennessee | 47037 | 14538 | 143 |
324381 | 324381 | 2020-07-11 | Davidson | Tennessee | 47037 | 14319 | 143 |
321200 | 321200 | 2020-07-10 | Davidson | Tennessee | 47037 | 13802 | 142 |
318022 | 318022 | 2020-07-09 | Davidson | Tennessee | 47037 | 13440 | 138 |
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);