ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,356 rows where county = "Christian" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Christian · 1,055 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1093970 | 1093970 | 2021-03-06 | Christian | Missouri | 29043 | 8515 | 80 |
1089817 | 1089817 | 2021-03-05 | Christian | Illinois | 17021 | 3326 | 86 |
1090231 | 1090231 | 2021-03-05 | Christian | Kentucky | 21047 | 6249 | 79 |
1090724 | 1090724 | 2021-03-05 | Christian | Missouri | 29043 | 8515 | 80 |
1086572 | 1086572 | 2021-03-04 | Christian | Illinois | 17021 | 3324 | 86 |
1086986 | 1086986 | 2021-03-04 | Christian | Kentucky | 21047 | 6247 | 79 |
1087479 | 1087479 | 2021-03-04 | Christian | Missouri | 29043 | 8489 | 80 |
1083326 | 1083326 | 2021-03-03 | Christian | Illinois | 17021 | 3322 | 86 |
1083740 | 1083740 | 2021-03-03 | Christian | Kentucky | 21047 | 6242 | 79 |
1084234 | 1084234 | 2021-03-03 | Christian | Missouri | 29043 | 8489 | 80 |
1080080 | 1080080 | 2021-03-02 | Christian | Illinois | 17021 | 3315 | 86 |
1080494 | 1080494 | 2021-03-02 | Christian | Kentucky | 21047 | 6238 | 79 |
1080988 | 1080988 | 2021-03-02 | Christian | Missouri | 29043 | 8489 | 78 |
1076835 | 1076835 | 2021-03-01 | Christian | Illinois | 17021 | 3305 | 86 |
1077249 | 1077249 | 2021-03-01 | Christian | Kentucky | 21047 | 6231 | 79 |
1077742 | 1077742 | 2021-03-01 | Christian | Missouri | 29043 | 8489 | 78 |
1073589 | 1073589 | 2021-02-28 | Christian | Illinois | 17021 | 3305 | 86 |
1074003 | 1074003 | 2021-02-28 | Christian | Kentucky | 21047 | 6229 | 79 |
1074496 | 1074496 | 2021-02-28 | Christian | Missouri | 29043 | 8468 | 78 |
1070343 | 1070343 | 2021-02-27 | Christian | Illinois | 17021 | 3301 | 85 |
1070757 | 1070757 | 2021-02-27 | Christian | Kentucky | 21047 | 6220 | 79 |
1071250 | 1071250 | 2021-02-27 | Christian | Missouri | 29043 | 8468 | 78 |
1067098 | 1067098 | 2021-02-26 | Christian | Illinois | 17021 | 3297 | 85 |
1067512 | 1067512 | 2021-02-26 | Christian | Kentucky | 21047 | 6214 | 79 |
1068005 | 1068005 | 2021-02-26 | Christian | Missouri | 29043 | 8468 | 78 |
1063853 | 1063853 | 2021-02-25 | Christian | Illinois | 17021 | 3294 | 84 |
1064267 | 1064267 | 2021-02-25 | Christian | Kentucky | 21047 | 6209 | 79 |
1064760 | 1064760 | 2021-02-25 | Christian | Missouri | 29043 | 8400 | 77 |
1060608 | 1060608 | 2021-02-24 | Christian | Illinois | 17021 | 3287 | 83 |
1061022 | 1061022 | 2021-02-24 | Christian | Kentucky | 21047 | 6193 | 79 |
1061516 | 1061516 | 2021-02-24 | Christian | Missouri | 29043 | 8400 | 77 |
1057362 | 1057362 | 2021-02-23 | Christian | Illinois | 17021 | 3285 | 83 |
1057776 | 1057776 | 2021-02-23 | Christian | Kentucky | 21047 | 6178 | 79 |
1058270 | 1058270 | 2021-02-23 | Christian | Missouri | 29043 | 8400 | 77 |
1054116 | 1054116 | 2021-02-22 | Christian | Illinois | 17021 | 3282 | 82 |
1054530 | 1054530 | 2021-02-22 | Christian | Kentucky | 21047 | 6162 | 79 |
1055024 | 1055024 | 2021-02-22 | Christian | Missouri | 29043 | 8400 | 75 |
1050869 | 1050869 | 2021-02-21 | Christian | Illinois | 17021 | 3275 | 80 |
1051283 | 1051283 | 2021-02-21 | Christian | Kentucky | 21047 | 6160 | 79 |
1051777 | 1051777 | 2021-02-21 | Christian | Missouri | 29043 | 8375 | 75 |
1047622 | 1047622 | 2021-02-20 | Christian | Illinois | 17021 | 3267 | 80 |
1048036 | 1048036 | 2021-02-20 | Christian | Kentucky | 21047 | 6148 | 79 |
1048530 | 1048530 | 2021-02-20 | Christian | Missouri | 29043 | 8375 | 75 |
1044377 | 1044377 | 2021-02-19 | Christian | Illinois | 17021 | 3264 | 80 |
1044791 | 1044791 | 2021-02-19 | Christian | Kentucky | 21047 | 6105 | 79 |
1045284 | 1045284 | 2021-02-19 | Christian | Missouri | 29043 | 8375 | 75 |
1041132 | 1041132 | 2021-02-18 | Christian | Illinois | 17021 | 3259 | 80 |
1041546 | 1041546 | 2021-02-18 | Christian | Kentucky | 21047 | 6102 | 79 |
1042039 | 1042039 | 2021-02-18 | Christian | Missouri | 29043 | 8360 | 75 |
1037887 | 1037887 | 2021-02-17 | Christian | Illinois | 17021 | 3249 | 80 |
1038301 | 1038301 | 2021-02-17 | Christian | Kentucky | 21047 | 6066 | 79 |
1038794 | 1038794 | 2021-02-17 | Christian | Missouri | 29043 | 8360 | 71 |
1034642 | 1034642 | 2021-02-16 | Christian | Illinois | 17021 | 3247 | 80 |
1035056 | 1035056 | 2021-02-16 | Christian | Kentucky | 21047 | 6062 | 78 |
1035549 | 1035549 | 2021-02-16 | Christian | Missouri | 29043 | 8360 | 71 |
1031396 | 1031396 | 2021-02-15 | Christian | Illinois | 17021 | 3243 | 80 |
1031810 | 1031810 | 2021-02-15 | Christian | Kentucky | 21047 | 6041 | 78 |
1032304 | 1032304 | 2021-02-15 | Christian | Missouri | 29043 | 8360 | 71 |
1028149 | 1028149 | 2021-02-14 | Christian | Illinois | 17021 | 3241 | 80 |
1028563 | 1028563 | 2021-02-14 | Christian | Kentucky | 21047 | 6041 | 78 |
1029057 | 1029057 | 2021-02-14 | Christian | Missouri | 29043 | 8360 | 71 |
1024904 | 1024904 | 2021-02-13 | Christian | Illinois | 17021 | 3238 | 80 |
1025318 | 1025318 | 2021-02-13 | Christian | Kentucky | 21047 | 6041 | 78 |
1025811 | 1025811 | 2021-02-13 | Christian | Missouri | 29043 | 8360 | 71 |
1021659 | 1021659 | 2021-02-12 | Christian | Illinois | 17021 | 3236 | 80 |
1022073 | 1022073 | 2021-02-12 | Christian | Kentucky | 21047 | 6041 | 78 |
1022566 | 1022566 | 2021-02-12 | Christian | Missouri | 29043 | 8360 | 71 |
1018414 | 1018414 | 2021-02-11 | Christian | Illinois | 17021 | 3232 | 80 |
1018828 | 1018828 | 2021-02-11 | Christian | Kentucky | 21047 | 6032 | 78 |
1019321 | 1019321 | 2021-02-11 | Christian | Missouri | 29043 | 8215 | 71 |
1015169 | 1015169 | 2021-02-10 | Christian | Illinois | 17021 | 3224 | 80 |
1015583 | 1015583 | 2021-02-10 | Christian | Kentucky | 21047 | 6005 | 78 |
1016076 | 1016076 | 2021-02-10 | Christian | Missouri | 29043 | 8215 | 71 |
1011924 | 1011924 | 2021-02-09 | Christian | Illinois | 17021 | 3211 | 80 |
1012338 | 1012338 | 2021-02-09 | Christian | Kentucky | 21047 | 5973 | 78 |
1012831 | 1012831 | 2021-02-09 | Christian | Missouri | 29043 | 8215 | 71 |
1008678 | 1008678 | 2021-02-08 | Christian | Illinois | 17021 | 3200 | 80 |
1009092 | 1009092 | 2021-02-08 | Christian | Kentucky | 21047 | 5950 | 78 |
1009586 | 1009586 | 2021-02-08 | Christian | Missouri | 29043 | 8215 | 71 |
1005432 | 1005432 | 2021-02-07 | Christian | Illinois | 17021 | 3193 | 80 |
1005846 | 1005846 | 2021-02-07 | Christian | Kentucky | 21047 | 5950 | 75 |
1006339 | 1006339 | 2021-02-07 | Christian | Missouri | 29043 | 8146 | 71 |
1002186 | 1002186 | 2021-02-06 | Christian | Illinois | 17021 | 3185 | 80 |
1002600 | 1002600 | 2021-02-06 | Christian | Kentucky | 21047 | 5934 | 75 |
1003093 | 1003093 | 2021-02-06 | Christian | Missouri | 29043 | 8146 | 71 |
998940 | 998940 | 2021-02-05 | Christian | Illinois | 17021 | 3160 | 80 |
999354 | 999354 | 2021-02-05 | Christian | Kentucky | 21047 | 5895 | 75 |
999848 | 999848 | 2021-02-05 | Christian | Missouri | 29043 | 8146 | 71 |
995694 | 995694 | 2021-02-04 | Christian | Illinois | 17021 | 3156 | 80 |
996108 | 996108 | 2021-02-04 | Christian | Kentucky | 21047 | 5841 | 75 |
996602 | 996602 | 2021-02-04 | Christian | Missouri | 29043 | 7913 | 71 |
992448 | 992448 | 2021-02-03 | Christian | Illinois | 17021 | 3146 | 80 |
992862 | 992862 | 2021-02-03 | Christian | Kentucky | 21047 | 5814 | 75 |
993356 | 993356 | 2021-02-03 | Christian | Missouri | 29043 | 7913 | 69 |
989202 | 989202 | 2021-02-02 | Christian | Illinois | 17021 | 3136 | 80 |
989616 | 989616 | 2021-02-02 | Christian | Kentucky | 21047 | 5772 | 74 |
990110 | 990110 | 2021-02-02 | Christian | Missouri | 29043 | 7913 | 69 |
985955 | 985955 | 2021-02-01 | Christian | Illinois | 17021 | 3124 | 80 |
986369 | 986369 | 2021-02-01 | Christian | Kentucky | 21047 | 5747 | 74 |
986863 | 986863 | 2021-02-01 | Christian | Missouri | 29043 | 7913 | 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);