ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Tipton" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537024 | 537024 | 2020-09-15 | Tipton | Tennessee | 47167 | 1650 | 17 |
533788 | 533788 | 2020-09-14 | Tipton | Tennessee | 47167 | 1642 | 17 |
530553 | 530553 | 2020-09-13 | Tipton | Tennessee | 47167 | 1614 | 16 |
527316 | 527316 | 2020-09-12 | Tipton | Tennessee | 47167 | 1605 | 15 |
524080 | 524080 | 2020-09-11 | Tipton | Tennessee | 47167 | 1603 | 15 |
520844 | 520844 | 2020-09-10 | Tipton | Tennessee | 47167 | 1590 | 15 |
517608 | 517608 | 2020-09-09 | Tipton | Tennessee | 47167 | 1572 | 15 |
514373 | 514373 | 2020-09-08 | Tipton | Tennessee | 47167 | 1566 | 15 |
511140 | 511140 | 2020-09-07 | Tipton | Tennessee | 47167 | 1561 | 15 |
507907 | 507907 | 2020-09-06 | Tipton | Tennessee | 47167 | 1556 | 15 |
504675 | 504675 | 2020-09-05 | Tipton | Tennessee | 47167 | 1532 | 15 |
501441 | 501441 | 2020-09-04 | Tipton | Tennessee | 47167 | 1522 | 15 |
498207 | 498207 | 2020-09-03 | Tipton | Tennessee | 47167 | 1518 | 15 |
494974 | 494974 | 2020-09-02 | Tipton | Tennessee | 47167 | 1481 | 15 |
491740 | 491740 | 2020-09-01 | Tipton | Tennessee | 47167 | 1470 | 15 |
488507 | 488507 | 2020-08-31 | Tipton | Tennessee | 47167 | 1462 | 15 |
485274 | 485274 | 2020-08-30 | Tipton | Tennessee | 47167 | 1455 | 15 |
482039 | 482039 | 2020-08-29 | Tipton | Tennessee | 47167 | 1448 | 15 |
478805 | 478805 | 2020-08-28 | Tipton | Tennessee | 47167 | 1431 | 15 |
475572 | 475572 | 2020-08-27 | Tipton | Tennessee | 47167 | 1392 | 14 |
472339 | 472339 | 2020-08-26 | Tipton | Tennessee | 47167 | 1356 | 14 |
469107 | 469107 | 2020-08-25 | Tipton | Tennessee | 47167 | 1349 | 13 |
465878 | 465878 | 2020-08-24 | Tipton | Tennessee | 47167 | 1337 | 13 |
462649 | 462649 | 2020-08-23 | Tipton | Tennessee | 47167 | 1323 | 13 |
459421 | 459421 | 2020-08-22 | Tipton | Tennessee | 47167 | 1309 | 13 |
456193 | 456193 | 2020-08-21 | Tipton | Tennessee | 47167 | 1301 | 13 |
452965 | 452965 | 2020-08-20 | Tipton | Tennessee | 47167 | 1295 | 13 |
449737 | 449737 | 2020-08-19 | Tipton | Tennessee | 47167 | 1295 | 12 |
446509 | 446509 | 2020-08-18 | Tipton | Tennessee | 47167 | 1274 | 12 |
443283 | 443283 | 2020-08-17 | Tipton | Tennessee | 47167 | 1268 | 12 |
440056 | 440056 | 2020-08-16 | Tipton | Tennessee | 47167 | 1256 | 12 |
436831 | 436831 | 2020-08-15 | Tipton | Tennessee | 47167 | 1253 | 12 |
433604 | 433604 | 2020-08-14 | Tipton | Tennessee | 47167 | 1247 | 12 |
430379 | 430379 | 2020-08-13 | Tipton | Tennessee | 47167 | 1233 | 12 |
427152 | 427152 | 2020-08-12 | Tipton | Tennessee | 47167 | 1217 | 10 |
423929 | 423929 | 2020-08-11 | Tipton | Tennessee | 47167 | 1217 | 10 |
420707 | 420707 | 2020-08-10 | Tipton | Tennessee | 47167 | 1211 | 10 |
417486 | 417486 | 2020-08-09 | Tipton | Tennessee | 47167 | 1208 | 10 |
414265 | 414265 | 2020-08-08 | Tipton | Tennessee | 47167 | 1195 | 9 |
411045 | 411045 | 2020-08-07 | Tipton | Tennessee | 47167 | 1183 | 9 |
407826 | 407826 | 2020-08-06 | Tipton | Tennessee | 47167 | 1155 | 9 |
404606 | 404606 | 2020-08-05 | Tipton | Tennessee | 47167 | 1137 | 9 |
401388 | 401388 | 2020-08-04 | Tipton | Tennessee | 47167 | 1123 | 9 |
398173 | 398173 | 2020-08-03 | Tipton | Tennessee | 47167 | 1106 | 9 |
394956 | 394956 | 2020-08-02 | Tipton | Tennessee | 47167 | 1104 | 9 |
391740 | 391740 | 2020-08-01 | Tipton | Tennessee | 47167 | 1094 | 9 |
388523 | 388523 | 2020-07-31 | Tipton | Tennessee | 47167 | 1065 | 9 |
385306 | 385306 | 2020-07-30 | Tipton | Tennessee | 47167 | 1040 | 9 |
382088 | 382088 | 2020-07-29 | Tipton | Tennessee | 47167 | 1026 | 9 |
378871 | 378871 | 2020-07-28 | Tipton | Tennessee | 47167 | 1000 | 8 |
375655 | 375655 | 2020-07-27 | Tipton | Tennessee | 47167 | 966 | 8 |
372442 | 372442 | 2020-07-26 | Tipton | Tennessee | 47167 | 931 | 8 |
369230 | 369230 | 2020-07-25 | Tipton | Tennessee | 47167 | 912 | 8 |
366021 | 366021 | 2020-07-24 | Tipton | Tennessee | 47167 | 899 | 8 |
362815 | 362815 | 2020-07-23 | Tipton | Tennessee | 47167 | 877 | 8 |
359608 | 359608 | 2020-07-22 | Tipton | Tennessee | 47167 | 840 | 8 |
356404 | 356404 | 2020-07-21 | Tipton | Tennessee | 47167 | 835 | 8 |
353201 | 353201 | 2020-07-20 | Tipton | Tennessee | 47167 | 809 | 8 |
349998 | 349998 | 2020-07-19 | Tipton | Tennessee | 47167 | 798 | 8 |
346798 | 346798 | 2020-07-18 | Tipton | Tennessee | 47167 | 792 | 8 |
343598 | 343598 | 2020-07-17 | Tipton | Tennessee | 47167 | 780 | 8 |
340400 | 340400 | 2020-07-16 | Tipton | Tennessee | 47167 | 763 | 7 |
337203 | 337203 | 2020-07-15 | Tipton | Tennessee | 47167 | 740 | 7 |
334009 | 334009 | 2020-07-14 | Tipton | Tennessee | 47167 | 727 | 7 |
330817 | 330817 | 2020-07-13 | Tipton | Tennessee | 47167 | 717 | 7 |
327631 | 327631 | 2020-07-12 | Tipton | Tennessee | 47167 | 698 | 7 |
324446 | 324446 | 2020-07-11 | Tipton | Tennessee | 47167 | 696 | 7 |
321265 | 321265 | 2020-07-10 | Tipton | Tennessee | 47167 | 692 | 6 |
318087 | 318087 | 2020-07-09 | Tipton | Tennessee | 47167 | 674 | 6 |
314914 | 314914 | 2020-07-08 | Tipton | Tennessee | 47167 | 662 | 5 |
311740 | 311740 | 2020-07-07 | Tipton | Tennessee | 47167 | 653 | 5 |
308571 | 308571 | 2020-07-06 | Tipton | Tennessee | 47167 | 649 | 5 |
305403 | 305403 | 2020-07-05 | Tipton | Tennessee | 47167 | 645 | 5 |
302240 | 302240 | 2020-07-04 | Tipton | Tennessee | 47167 | 637 | 5 |
299076 | 299076 | 2020-07-03 | Tipton | Tennessee | 47167 | 633 | 5 |
295916 | 295916 | 2020-07-02 | Tipton | Tennessee | 47167 | 620 | 5 |
292760 | 292760 | 2020-07-01 | Tipton | Tennessee | 47167 | 611 | 4 |
289608 | 289608 | 2020-06-30 | Tipton | Tennessee | 47167 | 607 | 4 |
286457 | 286457 | 2020-06-29 | Tipton | Tennessee | 47167 | 605 | 4 |
283312 | 283312 | 2020-06-28 | Tipton | Tennessee | 47167 | 593 | 4 |
280166 | 280166 | 2020-06-27 | Tipton | Tennessee | 47167 | 593 | 4 |
277018 | 277018 | 2020-06-26 | Tipton | Tennessee | 47167 | 584 | 4 |
273871 | 273871 | 2020-06-25 | Tipton | Tennessee | 47167 | 580 | 4 |
270732 | 270732 | 2020-06-24 | Tipton | Tennessee | 47167 | 571 | 4 |
267598 | 267598 | 2020-06-23 | Tipton | Tennessee | 47167 | 565 | 4 |
264470 | 264470 | 2020-06-22 | Tipton | Tennessee | 47167 | 563 | 4 |
261342 | 261342 | 2020-06-21 | Tipton | Tennessee | 47167 | 562 | 4 |
258215 | 258215 | 2020-06-20 | Tipton | Tennessee | 47167 | 554 | 4 |
255089 | 255089 | 2020-06-19 | Tipton | Tennessee | 47167 | 551 | 4 |
251974 | 251974 | 2020-06-18 | Tipton | Tennessee | 47167 | 541 | 4 |
248859 | 248859 | 2020-06-17 | Tipton | Tennessee | 47167 | 534 | 4 |
245746 | 245746 | 2020-06-16 | Tipton | Tennessee | 47167 | 525 | 3 |
242634 | 242634 | 2020-06-15 | Tipton | Tennessee | 47167 | 520 | 3 |
239524 | 239524 | 2020-06-14 | Tipton | Tennessee | 47167 | 510 | 3 |
236416 | 236416 | 2020-06-13 | Tipton | Tennessee | 47167 | 501 | 3 |
233310 | 233310 | 2020-06-12 | Tipton | Tennessee | 47167 | 497 | 3 |
230205 | 230205 | 2020-06-11 | Tipton | Tennessee | 47167 | 491 | 3 |
227101 | 227101 | 2020-06-10 | Tipton | Tennessee | 47167 | 488 | 3 |
224001 | 224001 | 2020-06-09 | Tipton | Tennessee | 47167 | 487 | 3 |
220906 | 220906 | 2020-06-08 | Tipton | Tennessee | 47167 | 480 | 3 |
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);