ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Dyer" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536963 | 536963 | 2020-09-15 | Dyer | Tennessee | 47045 | 1161 | 13 |
533727 | 533727 | 2020-09-14 | Dyer | Tennessee | 47045 | 1152 | 12 |
530492 | 530492 | 2020-09-13 | Dyer | Tennessee | 47045 | 1129 | 12 |
527255 | 527255 | 2020-09-12 | Dyer | Tennessee | 47045 | 1125 | 10 |
524019 | 524019 | 2020-09-11 | Dyer | Tennessee | 47045 | 1100 | 11 |
520783 | 520783 | 2020-09-10 | Dyer | Tennessee | 47045 | 1082 | 10 |
517547 | 517547 | 2020-09-09 | Dyer | Tennessee | 47045 | 1061 | 11 |
514312 | 514312 | 2020-09-08 | Dyer | Tennessee | 47045 | 1063 | 10 |
511079 | 511079 | 2020-09-07 | Dyer | Tennessee | 47045 | 1060 | 10 |
507846 | 507846 | 2020-09-06 | Dyer | Tennessee | 47045 | 1056 | 10 |
504614 | 504614 | 2020-09-05 | Dyer | Tennessee | 47045 | 1034 | 10 |
501380 | 501380 | 2020-09-04 | Dyer | Tennessee | 47045 | 1025 | 10 |
498146 | 498146 | 2020-09-03 | Dyer | Tennessee | 47045 | 1013 | 10 |
494913 | 494913 | 2020-09-02 | Dyer | Tennessee | 47045 | 988 | 10 |
491679 | 491679 | 2020-09-01 | Dyer | Tennessee | 47045 | 975 | 10 |
488446 | 488446 | 2020-08-31 | Dyer | Tennessee | 47045 | 964 | 10 |
485213 | 485213 | 2020-08-30 | Dyer | Tennessee | 47045 | 952 | 10 |
481978 | 481978 | 2020-08-29 | Dyer | Tennessee | 47045 | 947 | 10 |
478744 | 478744 | 2020-08-28 | Dyer | Tennessee | 47045 | 924 | 10 |
475511 | 475511 | 2020-08-27 | Dyer | Tennessee | 47045 | 917 | 9 |
472278 | 472278 | 2020-08-26 | Dyer | Tennessee | 47045 | 887 | 9 |
469046 | 469046 | 2020-08-25 | Dyer | Tennessee | 47045 | 866 | 9 |
465817 | 465817 | 2020-08-24 | Dyer | Tennessee | 47045 | 862 | 9 |
462588 | 462588 | 2020-08-23 | Dyer | Tennessee | 47045 | 852 | 9 |
459360 | 459360 | 2020-08-22 | Dyer | Tennessee | 47045 | 829 | 9 |
456132 | 456132 | 2020-08-21 | Dyer | Tennessee | 47045 | 809 | 9 |
452904 | 452904 | 2020-08-20 | Dyer | Tennessee | 47045 | 794 | 9 |
449676 | 449676 | 2020-08-19 | Dyer | Tennessee | 47045 | 772 | 9 |
446448 | 446448 | 2020-08-18 | Dyer | Tennessee | 47045 | 751 | 9 |
443222 | 443222 | 2020-08-17 | Dyer | Tennessee | 47045 | 747 | 9 |
439995 | 439995 | 2020-08-16 | Dyer | Tennessee | 47045 | 737 | 9 |
436770 | 436770 | 2020-08-15 | Dyer | Tennessee | 47045 | 728 | 9 |
433543 | 433543 | 2020-08-14 | Dyer | Tennessee | 47045 | 715 | 9 |
430318 | 430318 | 2020-08-13 | Dyer | Tennessee | 47045 | 696 | 9 |
427091 | 427091 | 2020-08-12 | Dyer | Tennessee | 47045 | 679 | 8 |
423868 | 423868 | 2020-08-11 | Dyer | Tennessee | 47045 | 668 | 8 |
420646 | 420646 | 2020-08-10 | Dyer | Tennessee | 47045 | 663 | 8 |
417425 | 417425 | 2020-08-09 | Dyer | Tennessee | 47045 | 650 | 8 |
414204 | 414204 | 2020-08-08 | Dyer | Tennessee | 47045 | 628 | 7 |
410984 | 410984 | 2020-08-07 | Dyer | Tennessee | 47045 | 619 | 7 |
407765 | 407765 | 2020-08-06 | Dyer | Tennessee | 47045 | 593 | 7 |
404545 | 404545 | 2020-08-05 | Dyer | Tennessee | 47045 | 579 | 7 |
401327 | 401327 | 2020-08-04 | Dyer | Tennessee | 47045 | 568 | 7 |
398112 | 398112 | 2020-08-03 | Dyer | Tennessee | 47045 | 555 | 7 |
394895 | 394895 | 2020-08-02 | Dyer | Tennessee | 47045 | 542 | 7 |
391679 | 391679 | 2020-08-01 | Dyer | Tennessee | 47045 | 534 | 7 |
388462 | 388462 | 2020-07-31 | Dyer | Tennessee | 47045 | 515 | 6 |
385245 | 385245 | 2020-07-30 | Dyer | Tennessee | 47045 | 487 | 5 |
382027 | 382027 | 2020-07-29 | Dyer | Tennessee | 47045 | 459 | 5 |
378810 | 378810 | 2020-07-28 | Dyer | Tennessee | 47045 | 457 | 5 |
375594 | 375594 | 2020-07-27 | Dyer | Tennessee | 47045 | 446 | 5 |
372381 | 372381 | 2020-07-26 | Dyer | Tennessee | 47045 | 436 | 5 |
369169 | 369169 | 2020-07-25 | Dyer | Tennessee | 47045 | 424 | 5 |
365960 | 365960 | 2020-07-24 | Dyer | Tennessee | 47045 | 416 | 5 |
362754 | 362754 | 2020-07-23 | Dyer | Tennessee | 47045 | 400 | 5 |
359547 | 359547 | 2020-07-22 | Dyer | Tennessee | 47045 | 383 | 5 |
356343 | 356343 | 2020-07-21 | Dyer | Tennessee | 47045 | 383 | 5 |
353140 | 353140 | 2020-07-20 | Dyer | Tennessee | 47045 | 373 | 4 |
349937 | 349937 | 2020-07-19 | Dyer | Tennessee | 47045 | 365 | 3 |
346737 | 346737 | 2020-07-18 | Dyer | Tennessee | 47045 | 358 | 3 |
343537 | 343537 | 2020-07-17 | Dyer | Tennessee | 47045 | 352 | 3 |
340339 | 340339 | 2020-07-16 | Dyer | Tennessee | 47045 | 337 | 3 |
337142 | 337142 | 2020-07-15 | Dyer | Tennessee | 47045 | 326 | 3 |
333948 | 333948 | 2020-07-14 | Dyer | Tennessee | 47045 | 310 | 3 |
330756 | 330756 | 2020-07-13 | Dyer | Tennessee | 47045 | 302 | 3 |
327570 | 327570 | 2020-07-12 | Dyer | Tennessee | 47045 | 292 | 3 |
324385 | 324385 | 2020-07-11 | Dyer | Tennessee | 47045 | 291 | 3 |
321204 | 321204 | 2020-07-10 | Dyer | Tennessee | 47045 | 280 | 3 |
318026 | 318026 | 2020-07-09 | Dyer | Tennessee | 47045 | 274 | 3 |
314853 | 314853 | 2020-07-08 | Dyer | Tennessee | 47045 | 270 | 3 |
311679 | 311679 | 2020-07-07 | Dyer | Tennessee | 47045 | 261 | 3 |
308510 | 308510 | 2020-07-06 | Dyer | Tennessee | 47045 | 254 | 3 |
305342 | 305342 | 2020-07-05 | Dyer | Tennessee | 47045 | 251 | 1 |
302179 | 302179 | 2020-07-04 | Dyer | Tennessee | 47045 | 248 | 1 |
299015 | 299015 | 2020-07-03 | Dyer | Tennessee | 47045 | 240 | 1 |
295855 | 295855 | 2020-07-02 | Dyer | Tennessee | 47045 | 232 | 1 |
292699 | 292699 | 2020-07-01 | Dyer | Tennessee | 47045 | 225 | 1 |
289547 | 289547 | 2020-06-30 | Dyer | Tennessee | 47045 | 214 | 1 |
286396 | 286396 | 2020-06-29 | Dyer | Tennessee | 47045 | 206 | 0 |
283251 | 283251 | 2020-06-28 | Dyer | Tennessee | 47045 | 192 | 0 |
280105 | 280105 | 2020-06-27 | Dyer | Tennessee | 47045 | 192 | 0 |
276957 | 276957 | 2020-06-26 | Dyer | Tennessee | 47045 | 184 | 0 |
273810 | 273810 | 2020-06-25 | Dyer | Tennessee | 47045 | 181 | 0 |
270671 | 270671 | 2020-06-24 | Dyer | Tennessee | 47045 | 181 | 0 |
267537 | 267537 | 2020-06-23 | Dyer | Tennessee | 47045 | 174 | 0 |
264409 | 264409 | 2020-06-22 | Dyer | Tennessee | 47045 | 164 | 0 |
261281 | 261281 | 2020-06-21 | Dyer | Tennessee | 47045 | 158 | 0 |
258154 | 258154 | 2020-06-20 | Dyer | Tennessee | 47045 | 145 | 0 |
255028 | 255028 | 2020-06-19 | Dyer | Tennessee | 47045 | 141 | 0 |
251913 | 251913 | 2020-06-18 | Dyer | Tennessee | 47045 | 122 | 0 |
248798 | 248798 | 2020-06-17 | Dyer | Tennessee | 47045 | 116 | 0 |
245685 | 245685 | 2020-06-16 | Dyer | Tennessee | 47045 | 106 | 0 |
242573 | 242573 | 2020-06-15 | Dyer | Tennessee | 47045 | 99 | 0 |
239463 | 239463 | 2020-06-14 | Dyer | Tennessee | 47045 | 91 | 0 |
236355 | 236355 | 2020-06-13 | Dyer | Tennessee | 47045 | 86 | 0 |
233249 | 233249 | 2020-06-12 | Dyer | Tennessee | 47045 | 82 | 0 |
230144 | 230144 | 2020-06-11 | Dyer | Tennessee | 47045 | 73 | 0 |
227040 | 227040 | 2020-06-10 | Dyer | Tennessee | 47045 | 71 | 0 |
223940 | 223940 | 2020-06-09 | Dyer | Tennessee | 47045 | 70 | 0 |
220845 | 220845 | 2020-06-08 | Dyer | Tennessee | 47045 | 67 | 0 |
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);