ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Livingston" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054158 | 1054158 | 2021-02-22 | Livingston | Illinois | 17105 | 4132 | 87 |
1050911 | 1050911 | 2021-02-21 | Livingston | Illinois | 17105 | 4127 | 86 |
1047664 | 1047664 | 2021-02-20 | Livingston | Illinois | 17105 | 4120 | 86 |
1044419 | 1044419 | 2021-02-19 | Livingston | Illinois | 17105 | 4108 | 85 |
1041174 | 1041174 | 2021-02-18 | Livingston | Illinois | 17105 | 4098 | 84 |
1037929 | 1037929 | 2021-02-17 | Livingston | Illinois | 17105 | 4089 | 84 |
1034684 | 1034684 | 2021-02-16 | Livingston | Illinois | 17105 | 4081 | 84 |
1031438 | 1031438 | 2021-02-15 | Livingston | Illinois | 17105 | 4073 | 84 |
1028191 | 1028191 | 2021-02-14 | Livingston | Illinois | 17105 | 4062 | 84 |
1024946 | 1024946 | 2021-02-13 | Livingston | Illinois | 17105 | 4060 | 83 |
1021701 | 1021701 | 2021-02-12 | Livingston | Illinois | 17105 | 4048 | 83 |
1018456 | 1018456 | 2021-02-11 | Livingston | Illinois | 17105 | 4039 | 82 |
1015211 | 1015211 | 2021-02-10 | Livingston | Illinois | 17105 | 4034 | 81 |
1011966 | 1011966 | 2021-02-09 | Livingston | Illinois | 17105 | 4027 | 81 |
1008720 | 1008720 | 2021-02-08 | Livingston | Illinois | 17105 | 4023 | 81 |
1005474 | 1005474 | 2021-02-07 | Livingston | Illinois | 17105 | 4015 | 81 |
1002228 | 1002228 | 2021-02-06 | Livingston | Illinois | 17105 | 4005 | 81 |
998982 | 998982 | 2021-02-05 | Livingston | Illinois | 17105 | 4000 | 79 |
995736 | 995736 | 2021-02-04 | Livingston | Illinois | 17105 | 3980 | 77 |
992490 | 992490 | 2021-02-03 | Livingston | Illinois | 17105 | 3962 | 76 |
989244 | 989244 | 2021-02-02 | Livingston | Illinois | 17105 | 3955 | 76 |
985997 | 985997 | 2021-02-01 | Livingston | Illinois | 17105 | 3943 | 76 |
982750 | 982750 | 2021-01-31 | Livingston | Illinois | 17105 | 3932 | 74 |
979504 | 979504 | 2021-01-30 | Livingston | Illinois | 17105 | 3920 | 74 |
976259 | 976259 | 2021-01-29 | Livingston | Illinois | 17105 | 3899 | 74 |
973014 | 973014 | 2021-01-28 | Livingston | Illinois | 17105 | 3873 | 74 |
969769 | 969769 | 2021-01-27 | Livingston | Illinois | 17105 | 3857 | 73 |
966525 | 966525 | 2021-01-26 | Livingston | Illinois | 17105 | 3828 | 71 |
963280 | 963280 | 2021-01-25 | Livingston | Illinois | 17105 | 3811 | 70 |
960035 | 960035 | 2021-01-24 | Livingston | Illinois | 17105 | 3792 | 70 |
956789 | 956789 | 2021-01-23 | Livingston | Illinois | 17105 | 3779 | 70 |
953544 | 953544 | 2021-01-22 | Livingston | Illinois | 17105 | 3759 | 69 |
950299 | 950299 | 2021-01-21 | Livingston | Illinois | 17105 | 3697 | 68 |
947053 | 947053 | 2021-01-20 | Livingston | Illinois | 17105 | 3667 | 66 |
943806 | 943806 | 2021-01-19 | Livingston | Illinois | 17105 | 3647 | 66 |
940561 | 940561 | 2021-01-18 | Livingston | Illinois | 17105 | 3635 | 66 |
937316 | 937316 | 2021-01-17 | Livingston | Illinois | 17105 | 3624 | 66 |
934071 | 934071 | 2021-01-16 | Livingston | Illinois | 17105 | 3608 | 66 |
930826 | 930826 | 2021-01-15 | Livingston | Illinois | 17105 | 3579 | 66 |
927581 | 927581 | 2021-01-14 | Livingston | Illinois | 17105 | 3524 | 66 |
924335 | 924335 | 2021-01-13 | Livingston | Illinois | 17105 | 3481 | 65 |
921090 | 921090 | 2021-01-12 | Livingston | Illinois | 17105 | 3437 | 65 |
917845 | 917845 | 2021-01-11 | Livingston | Illinois | 17105 | 3403 | 65 |
914600 | 914600 | 2021-01-10 | Livingston | Illinois | 17105 | 3390 | 64 |
911355 | 911355 | 2021-01-09 | Livingston | Illinois | 17105 | 3362 | 64 |
908110 | 908110 | 2021-01-08 | Livingston | Illinois | 17105 | 3328 | 64 |
904864 | 904864 | 2021-01-07 | Livingston | Illinois | 17105 | 3280 | 62 |
901619 | 901619 | 2021-01-06 | Livingston | Illinois | 17105 | 3246 | 61 |
898374 | 898374 | 2021-01-05 | Livingston | Illinois | 17105 | 3220 | 60 |
895129 | 895129 | 2021-01-04 | Livingston | Illinois | 17105 | 3201 | 60 |
891882 | 891882 | 2021-01-03 | Livingston | Illinois | 17105 | 3180 | 60 |
888635 | 888635 | 2021-01-02 | Livingston | Illinois | 17105 | 3166 | 59 |
885390 | 885390 | 2021-01-01 | Livingston | Illinois | 17105 | 3140 | 58 |
882145 | 882145 | 2020-12-31 | Livingston | Illinois | 17105 | 3140 | 58 |
878900 | 878900 | 2020-12-30 | Livingston | Illinois | 17105 | 3118 | 58 |
875655 | 875655 | 2020-12-29 | Livingston | Illinois | 17105 | 3093 | 58 |
872410 | 872410 | 2020-12-28 | Livingston | Illinois | 17105 | 3059 | 58 |
869165 | 869165 | 2020-12-27 | Livingston | Illinois | 17105 | 3050 | 58 |
865920 | 865920 | 2020-12-26 | Livingston | Illinois | 17105 | 3040 | 58 |
862675 | 862675 | 2020-12-25 | Livingston | Illinois | 17105 | 3030 | 58 |
859430 | 859430 | 2020-12-24 | Livingston | Illinois | 17105 | 2997 | 57 |
856185 | 856185 | 2020-12-23 | Livingston | Illinois | 17105 | 2967 | 57 |
852940 | 852940 | 2020-12-22 | Livingston | Illinois | 17105 | 2934 | 57 |
849695 | 849695 | 2020-12-21 | Livingston | Illinois | 17105 | 2907 | 55 |
846450 | 846450 | 2020-12-20 | Livingston | Illinois | 17105 | 2893 | 55 |
843204 | 843204 | 2020-12-19 | Livingston | Illinois | 17105 | 2874 | 55 |
839959 | 839959 | 2020-12-18 | Livingston | Illinois | 17105 | 2860 | 55 |
836714 | 836714 | 2020-12-17 | Livingston | Illinois | 17105 | 2840 | 52 |
833468 | 833468 | 2020-12-16 | Livingston | Illinois | 17105 | 2812 | 51 |
830221 | 830221 | 2020-12-15 | Livingston | Illinois | 17105 | 2779 | 50 |
826975 | 826975 | 2020-12-14 | Livingston | Illinois | 17105 | 2758 | 49 |
823728 | 823728 | 2020-12-13 | Livingston | Illinois | 17105 | 2736 | 49 |
820482 | 820482 | 2020-12-12 | Livingston | Illinois | 17105 | 2723 | 49 |
817236 | 817236 | 2020-12-11 | Livingston | Illinois | 17105 | 2698 | 49 |
813990 | 813990 | 2020-12-10 | Livingston | Illinois | 17105 | 2636 | 48 |
810745 | 810745 | 2020-12-09 | Livingston | Illinois | 17105 | 2593 | 46 |
807500 | 807500 | 2020-12-08 | Livingston | Illinois | 17105 | 2555 | 45 |
804255 | 804255 | 2020-12-07 | Livingston | Illinois | 17105 | 2515 | 41 |
801010 | 801010 | 2020-12-06 | Livingston | Illinois | 17105 | 2484 | 41 |
797765 | 797765 | 2020-12-05 | Livingston | Illinois | 17105 | 2471 | 40 |
794520 | 794520 | 2020-12-04 | Livingston | Illinois | 17105 | 2419 | 38 |
791275 | 791275 | 2020-12-03 | Livingston | Illinois | 17105 | 2387 | 38 |
788030 | 788030 | 2020-12-02 | Livingston | Illinois | 17105 | 2348 | 36 |
784786 | 784786 | 2020-12-01 | Livingston | Illinois | 17105 | 2312 | 29 |
781541 | 781541 | 2020-11-30 | Livingston | Illinois | 17105 | 2268 | 28 |
778295 | 778295 | 2020-11-29 | Livingston | Illinois | 17105 | 2245 | 27 |
775050 | 775050 | 2020-11-28 | Livingston | Illinois | 17105 | 2234 | 27 |
771805 | 771805 | 2020-11-27 | Livingston | Illinois | 17105 | 2212 | 26 |
768560 | 768560 | 2020-11-26 | Livingston | Illinois | 17105 | 2184 | 24 |
765314 | 765314 | 2020-11-25 | Livingston | Illinois | 17105 | 2135 | 23 |
762069 | 762069 | 2020-11-24 | Livingston | Illinois | 17105 | 2095 | 21 |
758824 | 758824 | 2020-11-23 | Livingston | Illinois | 17105 | 2034 | 21 |
755577 | 755577 | 2020-11-22 | Livingston | Illinois | 17105 | 2005 | 19 |
752331 | 752331 | 2020-11-21 | Livingston | Illinois | 17105 | 1978 | 18 |
749085 | 749085 | 2020-11-20 | Livingston | Illinois | 17105 | 1922 | 18 |
745839 | 745839 | 2020-11-19 | Livingston | Illinois | 17105 | 1863 | 17 |
742592 | 742592 | 2020-11-18 | Livingston | Illinois | 17105 | 1788 | 16 |
739345 | 739345 | 2020-11-17 | Livingston | Illinois | 17105 | 1725 | 15 |
736101 | 736101 | 2020-11-16 | Livingston | Illinois | 17105 | 1661 | 15 |
732855 | 732855 | 2020-11-15 | Livingston | Illinois | 17105 | 1617 | 15 |
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);