ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Sumner" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537023 | 537023 | 2020-09-15 | Sumner | Tennessee | 47165 | 4548 | 92 |
533787 | 533787 | 2020-09-14 | Sumner | Tennessee | 47165 | 4532 | 91 |
530552 | 530552 | 2020-09-13 | Sumner | Tennessee | 47165 | 4469 | 91 |
527315 | 527315 | 2020-09-12 | Sumner | Tennessee | 47165 | 4458 | 91 |
524079 | 524079 | 2020-09-11 | Sumner | Tennessee | 47165 | 4433 | 90 |
520843 | 520843 | 2020-09-10 | Sumner | Tennessee | 47165 | 4384 | 89 |
517607 | 517607 | 2020-09-09 | Sumner | Tennessee | 47165 | 4318 | 88 |
514372 | 514372 | 2020-09-08 | Sumner | Tennessee | 47165 | 4300 | 87 |
511139 | 511139 | 2020-09-07 | Sumner | Tennessee | 47165 | 4282 | 87 |
507906 | 507906 | 2020-09-06 | Sumner | Tennessee | 47165 | 4263 | 87 |
504674 | 504674 | 2020-09-05 | Sumner | Tennessee | 47165 | 4246 | 87 |
501440 | 501440 | 2020-09-04 | Sumner | Tennessee | 47165 | 4220 | 87 |
498206 | 498206 | 2020-09-03 | Sumner | Tennessee | 47165 | 4192 | 86 |
494973 | 494973 | 2020-09-02 | Sumner | Tennessee | 47165 | 4136 | 87 |
491739 | 491739 | 2020-09-01 | Sumner | Tennessee | 47165 | 4117 | 87 |
488506 | 488506 | 2020-08-31 | Sumner | Tennessee | 47165 | 4094 | 86 |
485273 | 485273 | 2020-08-30 | Sumner | Tennessee | 47165 | 4065 | 86 |
482038 | 482038 | 2020-08-29 | Sumner | Tennessee | 47165 | 4051 | 86 |
478804 | 478804 | 2020-08-28 | Sumner | Tennessee | 47165 | 4007 | 86 |
475571 | 475571 | 2020-08-27 | Sumner | Tennessee | 47165 | 3972 | 86 |
472338 | 472338 | 2020-08-26 | Sumner | Tennessee | 47165 | 3939 | 83 |
469106 | 469106 | 2020-08-25 | Sumner | Tennessee | 47165 | 3903 | 83 |
465877 | 465877 | 2020-08-24 | Sumner | Tennessee | 47165 | 3889 | 82 |
462648 | 462648 | 2020-08-23 | Sumner | Tennessee | 47165 | 3871 | 82 |
459420 | 459420 | 2020-08-22 | Sumner | Tennessee | 47165 | 3846 | 82 |
456192 | 456192 | 2020-08-21 | Sumner | Tennessee | 47165 | 3808 | 81 |
452964 | 452964 | 2020-08-20 | Sumner | Tennessee | 47165 | 3781 | 80 |
449736 | 449736 | 2020-08-19 | Sumner | Tennessee | 47165 | 3730 | 78 |
446508 | 446508 | 2020-08-18 | Sumner | Tennessee | 47165 | 3665 | 77 |
443282 | 443282 | 2020-08-17 | Sumner | Tennessee | 47165 | 3649 | 76 |
440055 | 440055 | 2020-08-16 | Sumner | Tennessee | 47165 | 3636 | 75 |
436830 | 436830 | 2020-08-15 | Sumner | Tennessee | 47165 | 3622 | 75 |
433603 | 433603 | 2020-08-14 | Sumner | Tennessee | 47165 | 3581 | 74 |
430378 | 430378 | 2020-08-13 | Sumner | Tennessee | 47165 | 3538 | 73 |
427151 | 427151 | 2020-08-12 | Sumner | Tennessee | 47165 | 3501 | 73 |
423928 | 423928 | 2020-08-11 | Sumner | Tennessee | 47165 | 3473 | 73 |
420706 | 420706 | 2020-08-10 | Sumner | Tennessee | 47165 | 3449 | 72 |
417485 | 417485 | 2020-08-09 | Sumner | Tennessee | 47165 | 3433 | 73 |
414264 | 414264 | 2020-08-08 | Sumner | Tennessee | 47165 | 3404 | 73 |
411044 | 411044 | 2020-08-07 | Sumner | Tennessee | 47165 | 3365 | 73 |
407825 | 407825 | 2020-08-06 | Sumner | Tennessee | 47165 | 3316 | 72 |
404605 | 404605 | 2020-08-05 | Sumner | Tennessee | 47165 | 3264 | 71 |
401387 | 401387 | 2020-08-04 | Sumner | Tennessee | 47165 | 3219 | 70 |
398172 | 398172 | 2020-08-03 | Sumner | Tennessee | 47165 | 3178 | 70 |
394955 | 394955 | 2020-08-02 | Sumner | Tennessee | 47165 | 3160 | 69 |
391739 | 391739 | 2020-08-01 | Sumner | Tennessee | 47165 | 3136 | 69 |
388522 | 388522 | 2020-07-31 | Sumner | Tennessee | 47165 | 3106 | 69 |
385305 | 385305 | 2020-07-30 | Sumner | Tennessee | 47165 | 3044 | 68 |
382087 | 382087 | 2020-07-29 | Sumner | Tennessee | 47165 | 3014 | 68 |
378870 | 378870 | 2020-07-28 | Sumner | Tennessee | 47165 | 2962 | 68 |
375654 | 375654 | 2020-07-27 | Sumner | Tennessee | 47165 | 2925 | 68 |
372441 | 372441 | 2020-07-26 | Sumner | Tennessee | 47165 | 2889 | 67 |
369229 | 369229 | 2020-07-25 | Sumner | Tennessee | 47165 | 2833 | 67 |
366020 | 366020 | 2020-07-24 | Sumner | Tennessee | 47165 | 2790 | 67 |
362814 | 362814 | 2020-07-23 | Sumner | Tennessee | 47165 | 2721 | 65 |
359607 | 359607 | 2020-07-22 | Sumner | Tennessee | 47165 | 2670 | 62 |
356403 | 356403 | 2020-07-21 | Sumner | Tennessee | 47165 | 2571 | 62 |
353200 | 353200 | 2020-07-20 | Sumner | Tennessee | 47165 | 2505 | 61 |
349997 | 349997 | 2020-07-19 | Sumner | Tennessee | 47165 | 2458 | 60 |
346797 | 346797 | 2020-07-18 | Sumner | Tennessee | 47165 | 2426 | 60 |
343597 | 343597 | 2020-07-17 | Sumner | Tennessee | 47165 | 2344 | 57 |
340399 | 340399 | 2020-07-16 | Sumner | Tennessee | 47165 | 2264 | 57 |
337202 | 337202 | 2020-07-15 | Sumner | Tennessee | 47165 | 2189 | 57 |
334008 | 334008 | 2020-07-14 | Sumner | Tennessee | 47165 | 2103 | 57 |
330816 | 330816 | 2020-07-13 | Sumner | Tennessee | 47165 | 2040 | 56 |
327630 | 327630 | 2020-07-12 | Sumner | Tennessee | 47165 | 1945 | 56 |
324445 | 324445 | 2020-07-11 | Sumner | Tennessee | 47165 | 1897 | 56 |
321264 | 321264 | 2020-07-10 | Sumner | Tennessee | 47165 | 1874 | 56 |
318086 | 318086 | 2020-07-09 | Sumner | Tennessee | 47165 | 1802 | 56 |
314913 | 314913 | 2020-07-08 | Sumner | Tennessee | 47165 | 1727 | 55 |
311739 | 311739 | 2020-07-07 | Sumner | Tennessee | 47165 | 1670 | 53 |
308570 | 308570 | 2020-07-06 | Sumner | Tennessee | 47165 | 1636 | 52 |
305402 | 305402 | 2020-07-05 | Sumner | Tennessee | 47165 | 1610 | 52 |
302239 | 302239 | 2020-07-04 | Sumner | Tennessee | 47165 | 1593 | 52 |
299075 | 299075 | 2020-07-03 | Sumner | Tennessee | 47165 | 1559 | 52 |
295915 | 295915 | 2020-07-02 | Sumner | Tennessee | 47165 | 1507 | 52 |
292759 | 292759 | 2020-07-01 | Sumner | Tennessee | 47165 | 1469 | 52 |
289607 | 289607 | 2020-06-30 | Sumner | Tennessee | 47165 | 1417 | 52 |
286456 | 286456 | 2020-06-29 | Sumner | Tennessee | 47165 | 1371 | 51 |
283311 | 283311 | 2020-06-28 | Sumner | Tennessee | 47165 | 1318 | 51 |
280165 | 280165 | 2020-06-27 | Sumner | Tennessee | 47165 | 1318 | 51 |
277017 | 277017 | 2020-06-26 | Sumner | Tennessee | 47165 | 1296 | 51 |
273870 | 273870 | 2020-06-25 | Sumner | Tennessee | 47165 | 1260 | 51 |
270731 | 270731 | 2020-06-24 | Sumner | Tennessee | 47165 | 1231 | 51 |
267597 | 267597 | 2020-06-23 | Sumner | Tennessee | 47165 | 1212 | 49 |
264469 | 264469 | 2020-06-22 | Sumner | Tennessee | 47165 | 1196 | 49 |
261341 | 261341 | 2020-06-21 | Sumner | Tennessee | 47165 | 1181 | 49 |
258214 | 258214 | 2020-06-20 | Sumner | Tennessee | 47165 | 1165 | 49 |
255088 | 255088 | 2020-06-19 | Sumner | Tennessee | 47165 | 1155 | 49 |
251973 | 251973 | 2020-06-18 | Sumner | Tennessee | 47165 | 1130 | 49 |
248858 | 248858 | 2020-06-17 | Sumner | Tennessee | 47165 | 1119 | 48 |
245745 | 245745 | 2020-06-16 | Sumner | Tennessee | 47165 | 1112 | 48 |
242633 | 242633 | 2020-06-15 | Sumner | Tennessee | 47165 | 1105 | 48 |
239523 | 239523 | 2020-06-14 | Sumner | Tennessee | 47165 | 1088 | 48 |
236415 | 236415 | 2020-06-13 | Sumner | Tennessee | 47165 | 1075 | 48 |
233309 | 233309 | 2020-06-12 | Sumner | Tennessee | 47165 | 1059 | 47 |
230204 | 230204 | 2020-06-11 | Sumner | Tennessee | 47165 | 1049 | 47 |
227100 | 227100 | 2020-06-10 | Sumner | Tennessee | 47165 | 1033 | 47 |
224000 | 224000 | 2020-06-09 | Sumner | Tennessee | 47165 | 1011 | 46 |
220905 | 220905 | 2020-06-08 | Sumner | Tennessee | 47165 | 987 | 46 |
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);