ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Christian" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193719 | 1193719 | 2021-04-06 | Christian | Illinois | 17021 | 3433 | 89 |
1190469 | 1190469 | 2021-04-05 | Christian | Illinois | 17021 | 3426 | 89 |
1187222 | 1187222 | 2021-04-04 | Christian | Illinois | 17021 | 3425 | 89 |
1183975 | 1183975 | 2021-04-03 | Christian | Illinois | 17021 | 3424 | 89 |
1180728 | 1180728 | 2021-04-02 | Christian | Illinois | 17021 | 3422 | 89 |
1177481 | 1177481 | 2021-04-01 | Christian | Illinois | 17021 | 3417 | 89 |
1174234 | 1174234 | 2021-03-31 | Christian | Illinois | 17021 | 3411 | 89 |
1170987 | 1170987 | 2021-03-30 | Christian | Illinois | 17021 | 3405 | 89 |
1167739 | 1167739 | 2021-03-29 | Christian | Illinois | 17021 | 3400 | 89 |
1164491 | 1164491 | 2021-03-28 | Christian | Illinois | 17021 | 3398 | 89 |
1161243 | 1161243 | 2021-03-27 | Christian | Illinois | 17021 | 3397 | 89 |
1157995 | 1157995 | 2021-03-26 | Christian | Illinois | 17021 | 3395 | 89 |
1154748 | 1154748 | 2021-03-25 | Christian | Illinois | 17021 | 3393 | 89 |
1151501 | 1151501 | 2021-03-24 | Christian | Illinois | 17021 | 3389 | 89 |
1148254 | 1148254 | 2021-03-23 | Christian | Illinois | 17021 | 3386 | 89 |
1145007 | 1145007 | 2021-03-22 | Christian | Illinois | 17021 | 3380 | 89 |
1141760 | 1141760 | 2021-03-21 | Christian | Illinois | 17021 | 3377 | 89 |
1138514 | 1138514 | 2021-03-20 | Christian | Illinois | 17021 | 3376 | 89 |
1135268 | 1135268 | 2021-03-19 | Christian | Illinois | 17021 | 3375 | 89 |
1132021 | 1132021 | 2021-03-18 | Christian | Illinois | 17021 | 3372 | 89 |
1128773 | 1128773 | 2021-03-17 | Christian | Illinois | 17021 | 3364 | 89 |
1125527 | 1125527 | 2021-03-16 | Christian | Illinois | 17021 | 3360 | 89 |
1122281 | 1122281 | 2021-03-15 | Christian | Illinois | 17021 | 3359 | 89 |
1119034 | 1119034 | 2021-03-14 | Christian | Illinois | 17021 | 3357 | 89 |
1115787 | 1115787 | 2021-03-13 | Christian | Illinois | 17021 | 3355 | 89 |
1112541 | 1112541 | 2021-03-12 | Christian | Illinois | 17021 | 3353 | 89 |
1109295 | 1109295 | 2021-03-11 | Christian | Illinois | 17021 | 3353 | 89 |
1106049 | 1106049 | 2021-03-10 | Christian | Illinois | 17021 | 3346 | 89 |
1102803 | 1102803 | 2021-03-09 | Christian | Illinois | 17021 | 3343 | 88 |
1099557 | 1099557 | 2021-03-08 | Christian | Illinois | 17021 | 3341 | 88 |
1096309 | 1096309 | 2021-03-07 | Christian | Illinois | 17021 | 3336 | 87 |
1093063 | 1093063 | 2021-03-06 | Christian | Illinois | 17021 | 3330 | 87 |
1089817 | 1089817 | 2021-03-05 | Christian | Illinois | 17021 | 3326 | 86 |
1086572 | 1086572 | 2021-03-04 | Christian | Illinois | 17021 | 3324 | 86 |
1083326 | 1083326 | 2021-03-03 | Christian | Illinois | 17021 | 3322 | 86 |
1080080 | 1080080 | 2021-03-02 | Christian | Illinois | 17021 | 3315 | 86 |
1076835 | 1076835 | 2021-03-01 | Christian | Illinois | 17021 | 3305 | 86 |
1073589 | 1073589 | 2021-02-28 | Christian | Illinois | 17021 | 3305 | 86 |
1070343 | 1070343 | 2021-02-27 | Christian | Illinois | 17021 | 3301 | 85 |
1067098 | 1067098 | 2021-02-26 | Christian | Illinois | 17021 | 3297 | 85 |
1063853 | 1063853 | 2021-02-25 | Christian | Illinois | 17021 | 3294 | 84 |
1060608 | 1060608 | 2021-02-24 | Christian | Illinois | 17021 | 3287 | 83 |
1057362 | 1057362 | 2021-02-23 | Christian | Illinois | 17021 | 3285 | 83 |
1054116 | 1054116 | 2021-02-22 | Christian | Illinois | 17021 | 3282 | 82 |
1050869 | 1050869 | 2021-02-21 | Christian | Illinois | 17021 | 3275 | 80 |
1047622 | 1047622 | 2021-02-20 | Christian | Illinois | 17021 | 3267 | 80 |
1044377 | 1044377 | 2021-02-19 | Christian | Illinois | 17021 | 3264 | 80 |
1041132 | 1041132 | 2021-02-18 | Christian | Illinois | 17021 | 3259 | 80 |
1037887 | 1037887 | 2021-02-17 | Christian | Illinois | 17021 | 3249 | 80 |
1034642 | 1034642 | 2021-02-16 | Christian | Illinois | 17021 | 3247 | 80 |
1031396 | 1031396 | 2021-02-15 | Christian | Illinois | 17021 | 3243 | 80 |
1028149 | 1028149 | 2021-02-14 | Christian | Illinois | 17021 | 3241 | 80 |
1024904 | 1024904 | 2021-02-13 | Christian | Illinois | 17021 | 3238 | 80 |
1021659 | 1021659 | 2021-02-12 | Christian | Illinois | 17021 | 3236 | 80 |
1018414 | 1018414 | 2021-02-11 | Christian | Illinois | 17021 | 3232 | 80 |
1015169 | 1015169 | 2021-02-10 | Christian | Illinois | 17021 | 3224 | 80 |
1011924 | 1011924 | 2021-02-09 | Christian | Illinois | 17021 | 3211 | 80 |
1008678 | 1008678 | 2021-02-08 | Christian | Illinois | 17021 | 3200 | 80 |
1005432 | 1005432 | 2021-02-07 | Christian | Illinois | 17021 | 3193 | 80 |
1002186 | 1002186 | 2021-02-06 | Christian | Illinois | 17021 | 3185 | 80 |
998940 | 998940 | 2021-02-05 | Christian | Illinois | 17021 | 3160 | 80 |
995694 | 995694 | 2021-02-04 | Christian | Illinois | 17021 | 3156 | 80 |
992448 | 992448 | 2021-02-03 | Christian | Illinois | 17021 | 3146 | 80 |
989202 | 989202 | 2021-02-02 | Christian | Illinois | 17021 | 3136 | 80 |
985955 | 985955 | 2021-02-01 | Christian | Illinois | 17021 | 3124 | 80 |
982708 | 982708 | 2021-01-31 | Christian | Illinois | 17021 | 3119 | 80 |
979462 | 979462 | 2021-01-30 | Christian | Illinois | 17021 | 3114 | 80 |
976217 | 976217 | 2021-01-29 | Christian | Illinois | 17021 | 3106 | 80 |
972972 | 972972 | 2021-01-28 | Christian | Illinois | 17021 | 3090 | 80 |
969727 | 969727 | 2021-01-27 | Christian | Illinois | 17021 | 3077 | 80 |
966483 | 966483 | 2021-01-26 | Christian | Illinois | 17021 | 3067 | 80 |
963238 | 963238 | 2021-01-25 | Christian | Illinois | 17021 | 3062 | 80 |
959993 | 959993 | 2021-01-24 | Christian | Illinois | 17021 | 3056 | 79 |
956747 | 956747 | 2021-01-23 | Christian | Illinois | 17021 | 3052 | 79 |
953502 | 953502 | 2021-01-22 | Christian | Illinois | 17021 | 3034 | 77 |
950257 | 950257 | 2021-01-21 | Christian | Illinois | 17021 | 3007 | 76 |
947011 | 947011 | 2021-01-20 | Christian | Illinois | 17021 | 2997 | 75 |
943764 | 943764 | 2021-01-19 | Christian | Illinois | 17021 | 2986 | 74 |
940519 | 940519 | 2021-01-18 | Christian | Illinois | 17021 | 2979 | 74 |
937274 | 937274 | 2021-01-17 | Christian | Illinois | 17021 | 2974 | 74 |
934029 | 934029 | 2021-01-16 | Christian | Illinois | 17021 | 2964 | 74 |
930784 | 930784 | 2021-01-15 | Christian | Illinois | 17021 | 2953 | 73 |
927539 | 927539 | 2021-01-14 | Christian | Illinois | 17021 | 2923 | 72 |
924293 | 924293 | 2021-01-13 | Christian | Illinois | 17021 | 2896 | 72 |
921048 | 921048 | 2021-01-12 | Christian | Illinois | 17021 | 2880 | 71 |
917803 | 917803 | 2021-01-11 | Christian | Illinois | 17021 | 2851 | 70 |
914558 | 914558 | 2021-01-10 | Christian | Illinois | 17021 | 2836 | 70 |
911313 | 911313 | 2021-01-09 | Christian | Illinois | 17021 | 2820 | 70 |
908068 | 908068 | 2021-01-08 | Christian | Illinois | 17021 | 2799 | 70 |
904822 | 904822 | 2021-01-07 | Christian | Illinois | 17021 | 2763 | 70 |
901577 | 901577 | 2021-01-06 | Christian | Illinois | 17021 | 2718 | 68 |
898332 | 898332 | 2021-01-05 | Christian | Illinois | 17021 | 2702 | 68 |
895087 | 895087 | 2021-01-04 | Christian | Illinois | 17021 | 2682 | 68 |
891840 | 891840 | 2021-01-03 | Christian | Illinois | 17021 | 2671 | 68 |
888593 | 888593 | 2021-01-02 | Christian | Illinois | 17021 | 2652 | 67 |
885348 | 885348 | 2021-01-01 | Christian | Illinois | 17021 | 2600 | 66 |
882103 | 882103 | 2020-12-31 | Christian | Illinois | 17021 | 2600 | 66 |
878858 | 878858 | 2020-12-30 | Christian | Illinois | 17021 | 2567 | 64 |
875613 | 875613 | 2020-12-29 | Christian | Illinois | 17021 | 2548 | 64 |
872368 | 872368 | 2020-12-28 | Christian | Illinois | 17021 | 2525 | 63 |
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);