ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Jefferson" and state = "Florida" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
328607 | 328607 | 2020-07-13 | Jefferson | Florida | 12065 | 87 | 4 |
331794 | 331794 | 2020-07-14 | Jefferson | Florida | 12065 | 93 | 4 |
334987 | 334987 | 2020-07-15 | Jefferson | Florida | 12065 | 100 | 4 |
338182 | 338182 | 2020-07-16 | Jefferson | Florida | 12065 | 102 | 4 |
341379 | 341379 | 2020-07-17 | Jefferson | Florida | 12065 | 109 | 4 |
344578 | 344578 | 2020-07-18 | Jefferson | Florida | 12065 | 110 | 4 |
347778 | 347778 | 2020-07-19 | Jefferson | Florida | 12065 | 113 | 4 |
350979 | 350979 | 2020-07-20 | Jefferson | Florida | 12065 | 113 | 5 |
354181 | 354181 | 2020-07-21 | Jefferson | Florida | 12065 | 118 | 5 |
357384 | 357384 | 2020-07-22 | Jefferson | Florida | 12065 | 122 | 5 |
360589 | 360589 | 2020-07-23 | Jefferson | Florida | 12065 | 156 | 5 |
363796 | 363796 | 2020-07-24 | Jefferson | Florida | 12065 | 160 | 5 |
367003 | 367003 | 2020-07-25 | Jefferson | Florida | 12065 | 169 | 5 |
370213 | 370213 | 2020-07-26 | Jefferson | Florida | 12065 | 174 | 5 |
373425 | 373425 | 2020-07-27 | Jefferson | Florida | 12065 | 177 | 5 |
376639 | 376639 | 2020-07-28 | Jefferson | Florida | 12065 | 184 | 5 |
379856 | 379856 | 2020-07-29 | Jefferson | Florida | 12065 | 188 | 5 |
383073 | 383073 | 2020-07-30 | Jefferson | Florida | 12065 | 192 | 5 |
386291 | 386291 | 2020-07-31 | Jefferson | Florida | 12065 | 229 | 5 |
389508 | 389508 | 2020-08-01 | Jefferson | Florida | 12065 | 337 | 5 |
392725 | 392725 | 2020-08-02 | Jefferson | Florida | 12065 | 344 | 5 |
395941 | 395941 | 2020-08-03 | Jefferson | Florida | 12065 | 363 | 5 |
399157 | 399157 | 2020-08-04 | Jefferson | Florida | 12065 | 417 | 5 |
402373 | 402373 | 2020-08-05 | Jefferson | Florida | 12065 | 433 | 5 |
405591 | 405591 | 2020-08-06 | Jefferson | Florida | 12065 | 438 | 5 |
408811 | 408811 | 2020-08-07 | Jefferson | Florida | 12065 | 447 | 5 |
412030 | 412030 | 2020-08-08 | Jefferson | Florida | 12065 | 448 | 5 |
415250 | 415250 | 2020-08-09 | Jefferson | Florida | 12065 | 453 | 5 |
418471 | 418471 | 2020-08-10 | Jefferson | Florida | 12065 | 455 | 5 |
421692 | 421692 | 2020-08-11 | Jefferson | Florida | 12065 | 462 | 5 |
424913 | 424913 | 2020-08-12 | Jefferson | Florida | 12065 | 462 | 5 |
428137 | 428137 | 2020-08-13 | Jefferson | Florida | 12065 | 462 | 5 |
431365 | 431365 | 2020-08-14 | Jefferson | Florida | 12065 | 462 | 5 |
434590 | 434590 | 2020-08-15 | Jefferson | Florida | 12065 | 467 | 5 |
437816 | 437816 | 2020-08-16 | Jefferson | Florida | 12065 | 467 | 5 |
441042 | 441042 | 2020-08-17 | Jefferson | Florida | 12065 | 469 | 5 |
444268 | 444268 | 2020-08-18 | Jefferson | Florida | 12065 | 474 | 5 |
447495 | 447495 | 2020-08-19 | Jefferson | Florida | 12065 | 473 | 5 |
450723 | 450723 | 2020-08-20 | Jefferson | Florida | 12065 | 477 | 5 |
453951 | 453951 | 2020-08-21 | Jefferson | Florida | 12065 | 481 | 5 |
457179 | 457179 | 2020-08-22 | Jefferson | Florida | 12065 | 488 | 5 |
460406 | 460406 | 2020-08-23 | Jefferson | Florida | 12065 | 491 | 5 |
463635 | 463635 | 2020-08-24 | Jefferson | Florida | 12065 | 491 | 5 |
466864 | 466864 | 2020-08-25 | Jefferson | Florida | 12065 | 492 | 5 |
470093 | 470093 | 2020-08-26 | Jefferson | Florida | 12065 | 493 | 6 |
473325 | 473325 | 2020-08-27 | Jefferson | Florida | 12065 | 493 | 6 |
476558 | 476558 | 2020-08-28 | Jefferson | Florida | 12065 | 496 | 6 |
479791 | 479791 | 2020-08-29 | Jefferson | Florida | 12065 | 495 | 6 |
483025 | 483025 | 2020-08-30 | Jefferson | Florida | 12065 | 498 | 6 |
486260 | 486260 | 2020-08-31 | Jefferson | Florida | 12065 | 500 | 6 |
489493 | 489493 | 2020-09-01 | Jefferson | Florida | 12065 | 502 | 6 |
492726 | 492726 | 2020-09-02 | Jefferson | Florida | 12065 | 504 | 6 |
495960 | 495960 | 2020-09-03 | Jefferson | Florida | 12065 | 506 | 6 |
499193 | 499193 | 2020-09-04 | Jefferson | Florida | 12065 | 510 | 6 |
502427 | 502427 | 2020-09-05 | Jefferson | Florida | 12065 | 513 | 6 |
505661 | 505661 | 2020-09-06 | Jefferson | Florida | 12065 | 518 | 7 |
508893 | 508893 | 2020-09-07 | Jefferson | Florida | 12065 | 517 | 7 |
512126 | 512126 | 2020-09-08 | Jefferson | Florida | 12065 | 517 | 7 |
515359 | 515359 | 2020-09-09 | Jefferson | Florida | 12065 | 522 | 7 |
518594 | 518594 | 2020-09-10 | Jefferson | Florida | 12065 | 525 | 7 |
521831 | 521831 | 2020-09-11 | Jefferson | Florida | 12065 | 529 | 7 |
525067 | 525067 | 2020-09-12 | Jefferson | Florida | 12065 | 530 | 7 |
528303 | 528303 | 2020-09-13 | Jefferson | Florida | 12065 | 532 | 8 |
531540 | 531540 | 2020-09-14 | Jefferson | Florida | 12065 | 534 | 8 |
534775 | 534775 | 2020-09-15 | Jefferson | Florida | 12065 | 534 | 8 |
538011 | 538011 | 2020-09-16 | Jefferson | Florida | 12065 | 536 | 8 |
541248 | 541248 | 2020-09-17 | Jefferson | Florida | 12065 | 540 | 8 |
544484 | 544484 | 2020-09-18 | Jefferson | Florida | 12065 | 542 | 8 |
547722 | 547722 | 2020-09-19 | Jefferson | Florida | 12065 | 544 | 8 |
550961 | 550961 | 2020-09-20 | Jefferson | Florida | 12065 | 546 | 8 |
554200 | 554200 | 2020-09-21 | Jefferson | Florida | 12065 | 546 | 8 |
557437 | 557437 | 2020-09-22 | Jefferson | Florida | 12065 | 548 | 8 |
560673 | 560673 | 2020-09-23 | Jefferson | Florida | 12065 | 550 | 8 |
563913 | 563913 | 2020-09-24 | Jefferson | Florida | 12065 | 552 | 8 |
567153 | 567153 | 2020-09-25 | Jefferson | Florida | 12065 | 555 | 8 |
570395 | 570395 | 2020-09-26 | Jefferson | Florida | 12065 | 555 | 9 |
573637 | 573637 | 2020-09-27 | Jefferson | Florida | 12065 | 557 | 9 |
576880 | 576880 | 2020-09-28 | Jefferson | Florida | 12065 | 562 | 9 |
580121 | 580121 | 2020-09-29 | Jefferson | Florida | 12065 | 563 | 9 |
583360 | 583360 | 2020-09-30 | Jefferson | Florida | 12065 | 560 | 9 |
586600 | 586600 | 2020-10-01 | Jefferson | Florida | 12065 | 562 | 9 |
589841 | 589841 | 2020-10-02 | Jefferson | Florida | 12065 | 566 | 9 |
593081 | 593081 | 2020-10-03 | Jefferson | Florida | 12065 | 567 | 9 |
596323 | 596323 | 2020-10-04 | Jefferson | Florida | 12065 | 568 | 9 |
599566 | 599566 | 2020-10-05 | Jefferson | Florida | 12065 | 569 | 9 |
602809 | 602809 | 2020-10-06 | Jefferson | Florida | 12065 | 569 | 9 |
606051 | 606051 | 2020-10-07 | Jefferson | Florida | 12065 | 570 | 9 |
609294 | 609294 | 2020-10-08 | Jefferson | Florida | 12065 | 576 | 9 |
612536 | 612536 | 2020-10-09 | Jefferson | Florida | 12065 | 586 | 9 |
615777 | 615777 | 2020-10-10 | Jefferson | Florida | 12065 | 586 | 9 |
619019 | 619019 | 2020-10-11 | Jefferson | Florida | 12065 | 601 | 9 |
622262 | 622262 | 2020-10-12 | Jefferson | Florida | 12065 | 601 | 9 |
625505 | 625505 | 2020-10-13 | Jefferson | Florida | 12065 | 602 | 9 |
628748 | 628748 | 2020-10-14 | Jefferson | Florida | 12065 | 603 | 9 |
631992 | 631992 | 2020-10-15 | Jefferson | Florida | 12065 | 608 | 9 |
635238 | 635238 | 2020-10-16 | Jefferson | Florida | 12065 | 611 | 9 |
638483 | 638483 | 2020-10-17 | Jefferson | Florida | 12065 | 620 | 9 |
641730 | 641730 | 2020-10-18 | Jefferson | Florida | 12065 | 625 | 9 |
644978 | 644978 | 2020-10-19 | Jefferson | Florida | 12065 | 626 | 9 |
648223 | 648223 | 2020-10-20 | Jefferson | Florida | 12065 | 631 | 9 |
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);