ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Jackson" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635237 | 635237 | 2020-10-16 | Jackson | Florida | 12063 | 3018 | 83 |
631991 | 631991 | 2020-10-15 | Jackson | Florida | 12063 | 3000 | 83 |
628747 | 628747 | 2020-10-14 | Jackson | Florida | 12063 | 2986 | 83 |
625504 | 625504 | 2020-10-13 | Jackson | Florida | 12063 | 2975 | 82 |
622261 | 622261 | 2020-10-12 | Jackson | Florida | 12063 | 2966 | 84 |
619018 | 619018 | 2020-10-11 | Jackson | Florida | 12063 | 2965 | 84 |
615776 | 615776 | 2020-10-10 | Jackson | Florida | 12063 | 2932 | 83 |
612535 | 612535 | 2020-10-09 | Jackson | Florida | 12063 | 2932 | 83 |
609293 | 609293 | 2020-10-08 | Jackson | Florida | 12063 | 2927 | 82 |
606050 | 606050 | 2020-10-07 | Jackson | Florida | 12063 | 2904 | 79 |
602808 | 602808 | 2020-10-06 | Jackson | Florida | 12063 | 2888 | 79 |
599565 | 599565 | 2020-10-05 | Jackson | Florida | 12063 | 2876 | 81 |
596322 | 596322 | 2020-10-04 | Jackson | Florida | 12063 | 2875 | 82 |
593080 | 593080 | 2020-10-03 | Jackson | Florida | 12063 | 2867 | 81 |
589840 | 589840 | 2020-10-02 | Jackson | Florida | 12063 | 2852 | 81 |
586599 | 586599 | 2020-10-01 | Jackson | Florida | 12063 | 2840 | 81 |
583359 | 583359 | 2020-09-30 | Jackson | Florida | 12063 | 2833 | 80 |
580120 | 580120 | 2020-09-29 | Jackson | Florida | 12063 | 2822 | 79 |
576879 | 576879 | 2020-09-28 | Jackson | Florida | 12063 | 2811 | 77 |
573636 | 573636 | 2020-09-27 | Jackson | Florida | 12063 | 2810 | 77 |
570394 | 570394 | 2020-09-26 | Jackson | Florida | 12063 | 2801 | 77 |
567152 | 567152 | 2020-09-25 | Jackson | Florida | 12063 | 2791 | 77 |
563912 | 563912 | 2020-09-24 | Jackson | Florida | 12063 | 2773 | 77 |
560672 | 560672 | 2020-09-23 | Jackson | Florida | 12063 | 2768 | 77 |
557436 | 557436 | 2020-09-22 | Jackson | Florida | 12063 | 2750 | 77 |
554199 | 554199 | 2020-09-21 | Jackson | Florida | 12063 | 2727 | 76 |
550960 | 550960 | 2020-09-20 | Jackson | Florida | 12063 | 2722 | 76 |
547721 | 547721 | 2020-09-19 | Jackson | Florida | 12063 | 2706 | 76 |
544483 | 544483 | 2020-09-18 | Jackson | Florida | 12063 | 2683 | 76 |
541247 | 541247 | 2020-09-17 | Jackson | Florida | 12063 | 2673 | 75 |
538010 | 538010 | 2020-09-16 | Jackson | Florida | 12063 | 2644 | 74 |
534774 | 534774 | 2020-09-15 | Jackson | Florida | 12063 | 2632 | 73 |
531539 | 531539 | 2020-09-14 | Jackson | Florida | 12063 | 2618 | 73 |
528302 | 528302 | 2020-09-13 | Jackson | Florida | 12063 | 2617 | 73 |
525066 | 525066 | 2020-09-12 | Jackson | Florida | 12063 | 2593 | 73 |
521830 | 521830 | 2020-09-11 | Jackson | Florida | 12063 | 2565 | 73 |
518593 | 518593 | 2020-09-10 | Jackson | Florida | 12063 | 2547 | 72 |
515358 | 515358 | 2020-09-09 | Jackson | Florida | 12063 | 2528 | 70 |
512125 | 512125 | 2020-09-08 | Jackson | Florida | 12063 | 2506 | 70 |
508892 | 508892 | 2020-09-07 | Jackson | Florida | 12063 | 2489 | 69 |
505660 | 505660 | 2020-09-06 | Jackson | Florida | 12063 | 2482 | 68 |
502426 | 502426 | 2020-09-05 | Jackson | Florida | 12063 | 2478 | 67 |
499192 | 499192 | 2020-09-04 | Jackson | Florida | 12063 | 2445 | 67 |
495959 | 495959 | 2020-09-03 | Jackson | Florida | 12063 | 2428 | 66 |
492725 | 492725 | 2020-09-02 | Jackson | Florida | 12063 | 2414 | 66 |
489492 | 489492 | 2020-09-01 | Jackson | Florida | 12063 | 2385 | 66 |
486259 | 486259 | 2020-08-31 | Jackson | Florida | 12063 | 2336 | 66 |
483024 | 483024 | 2020-08-30 | Jackson | Florida | 12063 | 2335 | 66 |
479790 | 479790 | 2020-08-29 | Jackson | Florida | 12063 | 2327 | 66 |
476557 | 476557 | 2020-08-28 | Jackson | Florida | 12063 | 2314 | 65 |
473324 | 473324 | 2020-08-27 | Jackson | Florida | 12063 | 2301 | 65 |
470092 | 470092 | 2020-08-26 | Jackson | Florida | 12063 | 2292 | 65 |
466863 | 466863 | 2020-08-25 | Jackson | Florida | 12063 | 2282 | 65 |
463634 | 463634 | 2020-08-24 | Jackson | Florida | 12063 | 2236 | 65 |
460405 | 460405 | 2020-08-23 | Jackson | Florida | 12063 | 2229 | 65 |
457178 | 457178 | 2020-08-22 | Jackson | Florida | 12063 | 2220 | 64 |
453950 | 453950 | 2020-08-21 | Jackson | Florida | 12063 | 2198 | 59 |
450722 | 450722 | 2020-08-20 | Jackson | Florida | 12063 | 2180 | 57 |
447494 | 447494 | 2020-08-19 | Jackson | Florida | 12063 | 2159 | 53 |
444267 | 444267 | 2020-08-18 | Jackson | Florida | 12063 | 2111 | 53 |
441041 | 441041 | 2020-08-17 | Jackson | Florida | 12063 | 2036 | 53 |
437815 | 437815 | 2020-08-16 | Jackson | Florida | 12063 | 2030 | 52 |
434589 | 434589 | 2020-08-15 | Jackson | Florida | 12063 | 2018 | 51 |
431364 | 431364 | 2020-08-14 | Jackson | Florida | 12063 | 2007 | 47 |
428136 | 428136 | 2020-08-13 | Jackson | Florida | 12063 | 1996 | 46 |
424912 | 424912 | 2020-08-12 | Jackson | Florida | 12063 | 1953 | 43 |
421691 | 421691 | 2020-08-11 | Jackson | Florida | 12063 | 1936 | 41 |
418470 | 418470 | 2020-08-10 | Jackson | Florida | 12063 | 1897 | 38 |
415249 | 415249 | 2020-08-09 | Jackson | Florida | 12063 | 1821 | 38 |
412029 | 412029 | 2020-08-08 | Jackson | Florida | 12063 | 1817 | 37 |
408810 | 408810 | 2020-08-07 | Jackson | Florida | 12063 | 1832 | 37 |
405590 | 405590 | 2020-08-06 | Jackson | Florida | 12063 | 1797 | 36 |
402372 | 402372 | 2020-08-05 | Jackson | Florida | 12063 | 1745 | 35 |
399156 | 399156 | 2020-08-04 | Jackson | Florida | 12063 | 1643 | 33 |
395940 | 395940 | 2020-08-03 | Jackson | Florida | 12063 | 1618 | 33 |
392724 | 392724 | 2020-08-02 | Jackson | Florida | 12063 | 1613 | 33 |
389507 | 389507 | 2020-08-01 | Jackson | Florida | 12063 | 1588 | 32 |
386290 | 386290 | 2020-07-31 | Jackson | Florida | 12063 | 1566 | 31 |
383072 | 383072 | 2020-07-30 | Jackson | Florida | 12063 | 1553 | 28 |
379855 | 379855 | 2020-07-29 | Jackson | Florida | 12063 | 1544 | 26 |
376638 | 376638 | 2020-07-28 | Jackson | Florida | 12063 | 1297 | 26 |
373424 | 373424 | 2020-07-27 | Jackson | Florida | 12063 | 1270 | 19 |
370212 | 370212 | 2020-07-26 | Jackson | Florida | 12063 | 1266 | 18 |
367002 | 367002 | 2020-07-25 | Jackson | Florida | 12063 | 1220 | 18 |
363795 | 363795 | 2020-07-24 | Jackson | Florida | 12063 | 979 | 17 |
360588 | 360588 | 2020-07-23 | Jackson | Florida | 12063 | 963 | 17 |
357383 | 357383 | 2020-07-22 | Jackson | Florida | 12063 | 916 | 15 |
354180 | 354180 | 2020-07-21 | Jackson | Florida | 12063 | 887 | 15 |
350978 | 350978 | 2020-07-20 | Jackson | Florida | 12063 | 857 | 12 |
347777 | 347777 | 2020-07-19 | Jackson | Florida | 12063 | 831 | 10 |
344577 | 344577 | 2020-07-18 | Jackson | Florida | 12063 | 769 | 10 |
341378 | 341378 | 2020-07-17 | Jackson | Florida | 12063 | 756 | 7 |
338181 | 338181 | 2020-07-16 | Jackson | Florida | 12063 | 682 | 6 |
334986 | 334986 | 2020-07-15 | Jackson | Florida | 12063 | 675 | 5 |
331793 | 331793 | 2020-07-14 | Jackson | Florida | 12063 | 652 | 2 |
328606 | 328606 | 2020-07-13 | Jackson | Florida | 12063 | 632 | 2 |
325420 | 325420 | 2020-07-12 | Jackson | Florida | 12063 | 587 | 2 |
322239 | 322239 | 2020-07-11 | Jackson | Florida | 12063 | 581 | 2 |
319060 | 319060 | 2020-07-10 | Jackson | Florida | 12063 | 556 | 2 |
315887 | 315887 | 2020-07-09 | Jackson | Florida | 12063 | 517 | 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);