ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Lee" and fips = 17103 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193760 | 1193760 | 2021-04-06 | Lee | Illinois | 17103 | 3777 | 87 |
1190510 | 1190510 | 2021-04-05 | Lee | Illinois | 17103 | 3761 | 87 |
1187263 | 1187263 | 2021-04-04 | Lee | Illinois | 17103 | 3753 | 87 |
1184016 | 1184016 | 2021-04-03 | Lee | Illinois | 17103 | 3748 | 87 |
1180769 | 1180769 | 2021-04-02 | Lee | Illinois | 17103 | 3743 | 87 |
1177522 | 1177522 | 2021-04-01 | Lee | Illinois | 17103 | 3725 | 87 |
1174275 | 1174275 | 2021-03-31 | Lee | Illinois | 17103 | 3714 | 86 |
1171028 | 1171028 | 2021-03-30 | Lee | Illinois | 17103 | 3693 | 86 |
1167780 | 1167780 | 2021-03-29 | Lee | Illinois | 17103 | 3690 | 86 |
1164532 | 1164532 | 2021-03-28 | Lee | Illinois | 17103 | 3677 | 86 |
1161284 | 1161284 | 2021-03-27 | Lee | Illinois | 17103 | 3669 | 86 |
1158036 | 1158036 | 2021-03-26 | Lee | Illinois | 17103 | 3650 | 85 |
1154789 | 1154789 | 2021-03-25 | Lee | Illinois | 17103 | 3631 | 84 |
1151542 | 1151542 | 2021-03-24 | Lee | Illinois | 17103 | 3606 | 84 |
1148295 | 1148295 | 2021-03-23 | Lee | Illinois | 17103 | 3578 | 84 |
1145048 | 1145048 | 2021-03-22 | Lee | Illinois | 17103 | 3569 | 84 |
1141801 | 1141801 | 2021-03-21 | Lee | Illinois | 17103 | 3562 | 84 |
1138555 | 1138555 | 2021-03-20 | Lee | Illinois | 17103 | 3538 | 84 |
1135309 | 1135309 | 2021-03-19 | Lee | Illinois | 17103 | 3524 | 84 |
1132062 | 1132062 | 2021-03-18 | Lee | Illinois | 17103 | 3513 | 84 |
1128814 | 1128814 | 2021-03-17 | Lee | Illinois | 17103 | 3495 | 84 |
1125568 | 1125568 | 2021-03-16 | Lee | Illinois | 17103 | 3475 | 84 |
1122322 | 1122322 | 2021-03-15 | Lee | Illinois | 17103 | 3466 | 84 |
1119075 | 1119075 | 2021-03-14 | Lee | Illinois | 17103 | 3462 | 84 |
1115828 | 1115828 | 2021-03-13 | Lee | Illinois | 17103 | 3459 | 83 |
1112582 | 1112582 | 2021-03-12 | Lee | Illinois | 17103 | 3442 | 82 |
1109336 | 1109336 | 2021-03-11 | Lee | Illinois | 17103 | 3427 | 82 |
1106090 | 1106090 | 2021-03-10 | Lee | Illinois | 17103 | 3415 | 82 |
1102844 | 1102844 | 2021-03-09 | Lee | Illinois | 17103 | 3403 | 82 |
1099598 | 1099598 | 2021-03-08 | Lee | Illinois | 17103 | 3383 | 82 |
1096350 | 1096350 | 2021-03-07 | Lee | Illinois | 17103 | 3383 | 82 |
1093104 | 1093104 | 2021-03-06 | Lee | Illinois | 17103 | 3381 | 82 |
1089858 | 1089858 | 2021-03-05 | Lee | Illinois | 17103 | 3372 | 82 |
1086613 | 1086613 | 2021-03-04 | Lee | Illinois | 17103 | 3367 | 82 |
1083367 | 1083367 | 2021-03-03 | Lee | Illinois | 17103 | 3363 | 82 |
1080121 | 1080121 | 2021-03-02 | Lee | Illinois | 17103 | 3362 | 82 |
1076876 | 1076876 | 2021-03-01 | Lee | Illinois | 17103 | 3353 | 82 |
1073630 | 1073630 | 2021-02-28 | Lee | Illinois | 17103 | 3352 | 82 |
1070384 | 1070384 | 2021-02-27 | Lee | Illinois | 17103 | 3351 | 82 |
1067139 | 1067139 | 2021-02-26 | Lee | Illinois | 17103 | 3343 | 82 |
1063894 | 1063894 | 2021-02-25 | Lee | Illinois | 17103 | 3342 | 82 |
1060649 | 1060649 | 2021-02-24 | Lee | Illinois | 17103 | 3328 | 82 |
1057403 | 1057403 | 2021-02-23 | Lee | Illinois | 17103 | 3324 | 82 |
1054157 | 1054157 | 2021-02-22 | Lee | Illinois | 17103 | 3303 | 82 |
1050910 | 1050910 | 2021-02-21 | Lee | Illinois | 17103 | 3300 | 82 |
1047663 | 1047663 | 2021-02-20 | Lee | Illinois | 17103 | 3298 | 82 |
1044418 | 1044418 | 2021-02-19 | Lee | Illinois | 17103 | 3295 | 82 |
1041173 | 1041173 | 2021-02-18 | Lee | Illinois | 17103 | 3298 | 82 |
1037928 | 1037928 | 2021-02-17 | Lee | Illinois | 17103 | 3299 | 82 |
1034683 | 1034683 | 2021-02-16 | Lee | Illinois | 17103 | 3291 | 82 |
1031437 | 1031437 | 2021-02-15 | Lee | Illinois | 17103 | 3285 | 82 |
1028190 | 1028190 | 2021-02-14 | Lee | Illinois | 17103 | 3285 | 82 |
1024945 | 1024945 | 2021-02-13 | Lee | Illinois | 17103 | 3281 | 82 |
1021700 | 1021700 | 2021-02-12 | Lee | Illinois | 17103 | 3280 | 82 |
1018455 | 1018455 | 2021-02-11 | Lee | Illinois | 17103 | 3274 | 82 |
1015210 | 1015210 | 2021-02-10 | Lee | Illinois | 17103 | 3268 | 82 |
1011965 | 1011965 | 2021-02-09 | Lee | Illinois | 17103 | 3254 | 81 |
1008719 | 1008719 | 2021-02-08 | Lee | Illinois | 17103 | 3250 | 81 |
1005473 | 1005473 | 2021-02-07 | Lee | Illinois | 17103 | 3246 | 81 |
1002227 | 1002227 | 2021-02-06 | Lee | Illinois | 17103 | 3245 | 80 |
998981 | 998981 | 2021-02-05 | Lee | Illinois | 17103 | 3233 | 80 |
995735 | 995735 | 2021-02-04 | Lee | Illinois | 17103 | 3230 | 79 |
992489 | 992489 | 2021-02-03 | Lee | Illinois | 17103 | 3230 | 79 |
989243 | 989243 | 2021-02-02 | Lee | Illinois | 17103 | 3223 | 79 |
985996 | 985996 | 2021-02-01 | Lee | Illinois | 17103 | 3219 | 79 |
982749 | 982749 | 2021-01-31 | Lee | Illinois | 17103 | 3214 | 78 |
979503 | 979503 | 2021-01-30 | Lee | Illinois | 17103 | 3207 | 78 |
976258 | 976258 | 2021-01-29 | Lee | Illinois | 17103 | 3189 | 78 |
973013 | 973013 | 2021-01-28 | Lee | Illinois | 17103 | 3179 | 78 |
969768 | 969768 | 2021-01-27 | Lee | Illinois | 17103 | 3171 | 76 |
966524 | 966524 | 2021-01-26 | Lee | Illinois | 17103 | 3156 | 76 |
963279 | 963279 | 2021-01-25 | Lee | Illinois | 17103 | 3145 | 76 |
960034 | 960034 | 2021-01-24 | Lee | Illinois | 17103 | 3142 | 76 |
956788 | 956788 | 2021-01-23 | Lee | Illinois | 17103 | 3133 | 76 |
953543 | 953543 | 2021-01-22 | Lee | Illinois | 17103 | 3120 | 75 |
950298 | 950298 | 2021-01-21 | Lee | Illinois | 17103 | 3076 | 74 |
947052 | 947052 | 2021-01-20 | Lee | Illinois | 17103 | 3062 | 73 |
943805 | 943805 | 2021-01-19 | Lee | Illinois | 17103 | 3048 | 72 |
940560 | 940560 | 2021-01-18 | Lee | Illinois | 17103 | 3031 | 72 |
937315 | 937315 | 2021-01-17 | Lee | Illinois | 17103 | 3024 | 72 |
934070 | 934070 | 2021-01-16 | Lee | Illinois | 17103 | 3018 | 72 |
930825 | 930825 | 2021-01-15 | Lee | Illinois | 17103 | 3003 | 72 |
927580 | 927580 | 2021-01-14 | Lee | Illinois | 17103 | 2996 | 72 |
924334 | 924334 | 2021-01-13 | Lee | Illinois | 17103 | 2942 | 71 |
921089 | 921089 | 2021-01-12 | Lee | Illinois | 17103 | 2921 | 70 |
917844 | 917844 | 2021-01-11 | Lee | Illinois | 17103 | 2909 | 69 |
914599 | 914599 | 2021-01-10 | Lee | Illinois | 17103 | 2885 | 69 |
911354 | 911354 | 2021-01-09 | Lee | Illinois | 17103 | 2869 | 69 |
908109 | 908109 | 2021-01-08 | Lee | Illinois | 17103 | 2864 | 69 |
904863 | 904863 | 2021-01-07 | Lee | Illinois | 17103 | 2843 | 69 |
901618 | 901618 | 2021-01-06 | Lee | Illinois | 17103 | 2821 | 66 |
898373 | 898373 | 2021-01-05 | Lee | Illinois | 17103 | 2772 | 65 |
895128 | 895128 | 2021-01-04 | Lee | Illinois | 17103 | 2750 | 64 |
891881 | 891881 | 2021-01-03 | Lee | Illinois | 17103 | 2744 | 64 |
888634 | 888634 | 2021-01-02 | Lee | Illinois | 17103 | 2741 | 64 |
885389 | 885389 | 2021-01-01 | Lee | Illinois | 17103 | 2707 | 64 |
882144 | 882144 | 2020-12-31 | Lee | Illinois | 17103 | 2707 | 64 |
878899 | 878899 | 2020-12-30 | Lee | Illinois | 17103 | 2694 | 64 |
875654 | 875654 | 2020-12-29 | Lee | Illinois | 17103 | 2670 | 64 |
872409 | 872409 | 2020-12-28 | Lee | Illinois | 17103 | 2658 | 64 |
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);