ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Bradley" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536946 | 536946 | 2020-09-15 | Bradley | Tennessee | 47011 | 2747 | 16 |
533710 | 533710 | 2020-09-14 | Bradley | Tennessee | 47011 | 2740 | 16 |
530475 | 530475 | 2020-09-13 | Bradley | Tennessee | 47011 | 2710 | 16 |
527238 | 527238 | 2020-09-12 | Bradley | Tennessee | 47011 | 2683 | 16 |
524002 | 524002 | 2020-09-11 | Bradley | Tennessee | 47011 | 2683 | 16 |
520766 | 520766 | 2020-09-10 | Bradley | Tennessee | 47011 | 2648 | 16 |
517530 | 517530 | 2020-09-09 | Bradley | Tennessee | 47011 | 2606 | 16 |
514295 | 514295 | 2020-09-08 | Bradley | Tennessee | 47011 | 2595 | 16 |
511062 | 511062 | 2020-09-07 | Bradley | Tennessee | 47011 | 2587 | 16 |
507829 | 507829 | 2020-09-06 | Bradley | Tennessee | 47011 | 2578 | 16 |
504597 | 504597 | 2020-09-05 | Bradley | Tennessee | 47011 | 2569 | 16 |
501363 | 501363 | 2020-09-04 | Bradley | Tennessee | 47011 | 2535 | 16 |
498129 | 498129 | 2020-09-03 | Bradley | Tennessee | 47011 | 2526 | 16 |
494896 | 494896 | 2020-09-02 | Bradley | Tennessee | 47011 | 2524 | 16 |
491662 | 491662 | 2020-09-01 | Bradley | Tennessee | 47011 | 2501 | 16 |
488429 | 488429 | 2020-08-31 | Bradley | Tennessee | 47011 | 2473 | 16 |
485196 | 485196 | 2020-08-30 | Bradley | Tennessee | 47011 | 2468 | 16 |
481961 | 481961 | 2020-08-29 | Bradley | Tennessee | 47011 | 2460 | 16 |
478727 | 478727 | 2020-08-28 | Bradley | Tennessee | 47011 | 2439 | 16 |
475494 | 475494 | 2020-08-27 | Bradley | Tennessee | 47011 | 2416 | 16 |
472261 | 472261 | 2020-08-26 | Bradley | Tennessee | 47011 | 2398 | 16 |
469029 | 469029 | 2020-08-25 | Bradley | Tennessee | 47011 | 2370 | 16 |
465800 | 465800 | 2020-08-24 | Bradley | Tennessee | 47011 | 2359 | 16 |
462571 | 462571 | 2020-08-23 | Bradley | Tennessee | 47011 | 2336 | 16 |
459343 | 459343 | 2020-08-22 | Bradley | Tennessee | 47011 | 2306 | 16 |
456115 | 456115 | 2020-08-21 | Bradley | Tennessee | 47011 | 2276 | 16 |
452887 | 452887 | 2020-08-20 | Bradley | Tennessee | 47011 | 2247 | 16 |
449659 | 449659 | 2020-08-19 | Bradley | Tennessee | 47011 | 2232 | 16 |
446431 | 446431 | 2020-08-18 | Bradley | Tennessee | 47011 | 2192 | 16 |
443205 | 443205 | 2020-08-17 | Bradley | Tennessee | 47011 | 2175 | 16 |
439978 | 439978 | 2020-08-16 | Bradley | Tennessee | 47011 | 2166 | 16 |
436753 | 436753 | 2020-08-15 | Bradley | Tennessee | 47011 | 2126 | 16 |
433526 | 433526 | 2020-08-14 | Bradley | Tennessee | 47011 | 2102 | 15 |
430301 | 430301 | 2020-08-13 | Bradley | Tennessee | 47011 | 2066 | 15 |
427074 | 427074 | 2020-08-12 | Bradley | Tennessee | 47011 | 2013 | 15 |
423851 | 423851 | 2020-08-11 | Bradley | Tennessee | 47011 | 1991 | 15 |
420629 | 420629 | 2020-08-10 | Bradley | Tennessee | 47011 | 1956 | 13 |
417408 | 417408 | 2020-08-09 | Bradley | Tennessee | 47011 | 1943 | 12 |
414187 | 414187 | 2020-08-08 | Bradley | Tennessee | 47011 | 1903 | 12 |
410967 | 410967 | 2020-08-07 | Bradley | Tennessee | 47011 | 1874 | 12 |
407748 | 407748 | 2020-08-06 | Bradley | Tennessee | 47011 | 1817 | 12 |
404528 | 404528 | 2020-08-05 | Bradley | Tennessee | 47011 | 1771 | 12 |
401310 | 401310 | 2020-08-04 | Bradley | Tennessee | 47011 | 1739 | 10 |
398095 | 398095 | 2020-08-03 | Bradley | Tennessee | 47011 | 1713 | 10 |
394878 | 394878 | 2020-08-02 | Bradley | Tennessee | 47011 | 1705 | 10 |
391662 | 391662 | 2020-08-01 | Bradley | Tennessee | 47011 | 1681 | 10 |
388445 | 388445 | 2020-07-31 | Bradley | Tennessee | 47011 | 1651 | 10 |
385228 | 385228 | 2020-07-30 | Bradley | Tennessee | 47011 | 1593 | 10 |
382010 | 382010 | 2020-07-29 | Bradley | Tennessee | 47011 | 1555 | 10 |
378793 | 378793 | 2020-07-28 | Bradley | Tennessee | 47011 | 1525 | 10 |
375577 | 375577 | 2020-07-27 | Bradley | Tennessee | 47011 | 1492 | 10 |
372364 | 372364 | 2020-07-26 | Bradley | Tennessee | 47011 | 1449 | 9 |
369152 | 369152 | 2020-07-25 | Bradley | Tennessee | 47011 | 1390 | 9 |
365943 | 365943 | 2020-07-24 | Bradley | Tennessee | 47011 | 1359 | 9 |
362737 | 362737 | 2020-07-23 | Bradley | Tennessee | 47011 | 1330 | 9 |
359530 | 359530 | 2020-07-22 | Bradley | Tennessee | 47011 | 1284 | 8 |
356326 | 356326 | 2020-07-21 | Bradley | Tennessee | 47011 | 1271 | 8 |
353123 | 353123 | 2020-07-20 | Bradley | Tennessee | 47011 | 1239 | 7 |
349920 | 349920 | 2020-07-19 | Bradley | Tennessee | 47011 | 1205 | 7 |
346720 | 346720 | 2020-07-18 | Bradley | Tennessee | 47011 | 1177 | 7 |
343520 | 343520 | 2020-07-17 | Bradley | Tennessee | 47011 | 1165 | 6 |
340322 | 340322 | 2020-07-16 | Bradley | Tennessee | 47011 | 1114 | 6 |
337125 | 337125 | 2020-07-15 | Bradley | Tennessee | 47011 | 1096 | 6 |
333931 | 333931 | 2020-07-14 | Bradley | Tennessee | 47011 | 1061 | 5 |
330739 | 330739 | 2020-07-13 | Bradley | Tennessee | 47011 | 1010 | 4 |
327553 | 327553 | 2020-07-12 | Bradley | Tennessee | 47011 | 972 | 4 |
324368 | 324368 | 2020-07-11 | Bradley | Tennessee | 47011 | 959 | 4 |
321187 | 321187 | 2020-07-10 | Bradley | Tennessee | 47011 | 925 | 4 |
318009 | 318009 | 2020-07-09 | Bradley | Tennessee | 47011 | 889 | 4 |
314836 | 314836 | 2020-07-08 | Bradley | Tennessee | 47011 | 874 | 4 |
311662 | 311662 | 2020-07-07 | Bradley | Tennessee | 47011 | 773 | 4 |
308493 | 308493 | 2020-07-06 | Bradley | Tennessee | 47011 | 745 | 4 |
305325 | 305325 | 2020-07-05 | Bradley | Tennessee | 47011 | 707 | 3 |
302162 | 302162 | 2020-07-04 | Bradley | Tennessee | 47011 | 674 | 3 |
298998 | 298998 | 2020-07-03 | Bradley | Tennessee | 47011 | 662 | 3 |
295838 | 295838 | 2020-07-02 | Bradley | Tennessee | 47011 | 604 | 3 |
292682 | 292682 | 2020-07-01 | Bradley | Tennessee | 47011 | 580 | 3 |
289530 | 289530 | 2020-06-30 | Bradley | Tennessee | 47011 | 550 | 3 |
286379 | 286379 | 2020-06-29 | Bradley | Tennessee | 47011 | 493 | 3 |
283234 | 283234 | 2020-06-28 | Bradley | Tennessee | 47011 | 444 | 3 |
280088 | 280088 | 2020-06-27 | Bradley | Tennessee | 47011 | 444 | 3 |
276940 | 276940 | 2020-06-26 | Bradley | Tennessee | 47011 | 430 | 3 |
273793 | 273793 | 2020-06-25 | Bradley | Tennessee | 47011 | 421 | 3 |
270654 | 270654 | 2020-06-24 | Bradley | Tennessee | 47011 | 406 | 3 |
267520 | 267520 | 2020-06-23 | Bradley | Tennessee | 47011 | 393 | 3 |
264392 | 264392 | 2020-06-22 | Bradley | Tennessee | 47011 | 349 | 3 |
261264 | 261264 | 2020-06-21 | Bradley | Tennessee | 47011 | 338 | 3 |
258137 | 258137 | 2020-06-20 | Bradley | Tennessee | 47011 | 328 | 2 |
255011 | 255011 | 2020-06-19 | Bradley | Tennessee | 47011 | 314 | 2 |
251896 | 251896 | 2020-06-18 | Bradley | Tennessee | 47011 | 305 | 2 |
248781 | 248781 | 2020-06-17 | Bradley | Tennessee | 47011 | 303 | 2 |
245668 | 245668 | 2020-06-16 | Bradley | Tennessee | 47011 | 302 | 2 |
242556 | 242556 | 2020-06-15 | Bradley | Tennessee | 47011 | 288 | 2 |
239446 | 239446 | 2020-06-14 | Bradley | Tennessee | 47011 | 281 | 2 |
236338 | 236338 | 2020-06-13 | Bradley | Tennessee | 47011 | 272 | 2 |
233232 | 233232 | 2020-06-12 | Bradley | Tennessee | 47011 | 266 | 2 |
230127 | 230127 | 2020-06-11 | Bradley | Tennessee | 47011 | 241 | 2 |
227023 | 227023 | 2020-06-10 | Bradley | Tennessee | 47011 | 238 | 2 |
223923 | 223923 | 2020-06-09 | Bradley | Tennessee | 47011 | 233 | 2 |
220828 | 220828 | 2020-06-08 | Bradley | Tennessee | 47011 | 219 | 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);