ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jackson" and fips = 29095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055050 | 1055050 | 2021-02-22 | Jackson | Missouri | 29095 | 29886 | 370 |
1051803 | 1051803 | 2021-02-21 | Jackson | Missouri | 29095 | 29875 | 370 |
1048556 | 1048556 | 2021-02-20 | Jackson | Missouri | 29095 | 29845 | 370 |
1045310 | 1045310 | 2021-02-19 | Jackson | Missouri | 29095 | 29783 | 369 |
1042065 | 1042065 | 2021-02-18 | Jackson | Missouri | 29095 | 29741 | 369 |
1038820 | 1038820 | 2021-02-17 | Jackson | Missouri | 29095 | 29614 | 357 |
1035575 | 1035575 | 2021-02-16 | Jackson | Missouri | 29095 | 29516 | 354 |
1032330 | 1032330 | 2021-02-15 | Jackson | Missouri | 29095 | 29495 | 352 |
1029083 | 1029083 | 2021-02-14 | Jackson | Missouri | 29095 | 29483 | 352 |
1025837 | 1025837 | 2021-02-13 | Jackson | Missouri | 29095 | 29456 | 352 |
1022592 | 1022592 | 2021-02-12 | Jackson | Missouri | 29095 | 29388 | 348 |
1019347 | 1019347 | 2021-02-11 | Jackson | Missouri | 29095 | 29309 | 347 |
1016102 | 1016102 | 2021-02-10 | Jackson | Missouri | 29095 | 29228 | 328 |
1012857 | 1012857 | 2021-02-09 | Jackson | Missouri | 29095 | 29160 | 328 |
1009612 | 1009612 | 2021-02-08 | Jackson | Missouri | 29095 | 29056 | 327 |
1006365 | 1006365 | 2021-02-07 | Jackson | Missouri | 29095 | 29025 | 327 |
1003119 | 1003119 | 2021-02-06 | Jackson | Missouri | 29095 | 28972 | 326 |
999874 | 999874 | 2021-02-05 | Jackson | Missouri | 29095 | 28884 | 324 |
996628 | 996628 | 2021-02-04 | Jackson | Missouri | 29095 | 28782 | 323 |
993382 | 993382 | 2021-02-03 | Jackson | Missouri | 29095 | 28660 | 321 |
990136 | 990136 | 2021-02-02 | Jackson | Missouri | 29095 | 28573 | 320 |
986889 | 986889 | 2021-02-01 | Jackson | Missouri | 29095 | 28474 | 308 |
983642 | 983642 | 2021-01-31 | Jackson | Missouri | 29095 | 28420 | 308 |
980396 | 980396 | 2021-01-30 | Jackson | Missouri | 29095 | 28363 | 308 |
977150 | 977150 | 2021-01-29 | Jackson | Missouri | 29095 | 28261 | 308 |
973905 | 973905 | 2021-01-28 | Jackson | Missouri | 29095 | 28001 | 307 |
970660 | 970660 | 2021-01-27 | Jackson | Missouri | 29095 | 27886 | 307 |
967415 | 967415 | 2021-01-26 | Jackson | Missouri | 29095 | 27751 | 305 |
964171 | 964171 | 2021-01-25 | Jackson | Missouri | 29095 | 27634 | 299 |
960926 | 960926 | 2021-01-24 | Jackson | Missouri | 29095 | 27585 | 297 |
957680 | 957680 | 2021-01-23 | Jackson | Missouri | 29095 | 27320 | 297 |
954435 | 954435 | 2021-01-22 | Jackson | Missouri | 29095 | 27169 | 293 |
951190 | 951190 | 2021-01-21 | Jackson | Missouri | 29095 | 27046 | 292 |
947944 | 947944 | 2021-01-20 | Jackson | Missouri | 29095 | 26934 | 290 |
944697 | 944697 | 2021-01-19 | Jackson | Missouri | 29095 | 26775 | 285 |
941452 | 941452 | 2021-01-18 | Jackson | Missouri | 29095 | 26712 | 283 |
938207 | 938207 | 2021-01-17 | Jackson | Missouri | 29095 | 26610 | 283 |
934962 | 934962 | 2021-01-16 | Jackson | Missouri | 29095 | 26508 | 283 |
931717 | 931717 | 2021-01-15 | Jackson | Missouri | 29095 | 26348 | 282 |
928472 | 928472 | 2021-01-14 | Jackson | Missouri | 29095 | 26171 | 280 |
925226 | 925226 | 2021-01-13 | Jackson | Missouri | 29095 | 25970 | 279 |
921981 | 921981 | 2021-01-12 | Jackson | Missouri | 29095 | 25848 | 279 |
918736 | 918736 | 2021-01-11 | Jackson | Missouri | 29095 | 25548 | 264 |
915491 | 915491 | 2021-01-10 | Jackson | Missouri | 29095 | 25384 | 264 |
912246 | 912246 | 2021-01-09 | Jackson | Missouri | 29095 | 25179 | 264 |
909001 | 909001 | 2021-01-08 | Jackson | Missouri | 29095 | 24938 | 263 |
905755 | 905755 | 2021-01-07 | Jackson | Missouri | 29095 | 24721 | 262 |
902510 | 902510 | 2021-01-06 | Jackson | Missouri | 29095 | 24441 | 260 |
899265 | 899265 | 2021-01-05 | Jackson | Missouri | 29095 | 24252 | 258 |
896020 | 896020 | 2021-01-04 | Jackson | Missouri | 29095 | 24069 | 245 |
892773 | 892773 | 2021-01-03 | Jackson | Missouri | 29095 | 24069 | 245 |
889527 | 889527 | 2021-01-02 | Jackson | Missouri | 29095 | 23827 | 245 |
886281 | 886281 | 2021-01-01 | Jackson | Missouri | 29095 | 23679 | 245 |
883036 | 883036 | 2020-12-31 | Jackson | Missouri | 29095 | 23425 | 243 |
879791 | 879791 | 2020-12-30 | Jackson | Missouri | 29095 | 23183 | 239 |
876546 | 876546 | 2020-12-29 | Jackson | Missouri | 29095 | 23016 | 235 |
873301 | 873301 | 2020-12-28 | Jackson | Missouri | 29095 | 22842 | 230 |
870056 | 870056 | 2020-12-27 | Jackson | Missouri | 29095 | 22735 | 230 |
866811 | 866811 | 2020-12-26 | Jackson | Missouri | 29095 | 22654 | 230 |
863566 | 863566 | 2020-12-25 | Jackson | Missouri | 29095 | 22542 | 230 |
860321 | 860321 | 2020-12-24 | Jackson | Missouri | 29095 | 22368 | 229 |
857076 | 857076 | 2020-12-23 | Jackson | Missouri | 29095 | 22116 | 222 |
853831 | 853831 | 2020-12-22 | Jackson | Missouri | 29095 | 21876 | 217 |
850586 | 850586 | 2020-12-21 | Jackson | Missouri | 29095 | 21757 | 207 |
847341 | 847341 | 2020-12-20 | Jackson | Missouri | 29095 | 21519 | 207 |
844095 | 844095 | 2020-12-19 | Jackson | Missouri | 29095 | 21404 | 206 |
840850 | 840850 | 2020-12-18 | Jackson | Missouri | 29095 | 21257 | 207 |
837605 | 837605 | 2020-12-17 | Jackson | Missouri | 29095 | 21082 | 206 |
834359 | 834359 | 2020-12-16 | Jackson | Missouri | 29095 | 20918 | 205 |
831112 | 831112 | 2020-12-15 | Jackson | Missouri | 29095 | 20779 | 205 |
827866 | 827866 | 2020-12-14 | Jackson | Missouri | 29095 | 20584 | 197 |
824619 | 824619 | 2020-12-13 | Jackson | Missouri | 29095 | 20408 | 197 |
821373 | 821373 | 2020-12-12 | Jackson | Missouri | 29095 | 20291 | 197 |
818127 | 818127 | 2020-12-11 | Jackson | Missouri | 29095 | 19784 | 196 |
814881 | 814881 | 2020-12-10 | Jackson | Missouri | 29095 | 19784 | 196 |
811636 | 811636 | 2020-12-09 | Jackson | Missouri | 29095 | 19522 | 193 |
808391 | 808391 | 2020-12-08 | Jackson | Missouri | 29095 | 19335 | 193 |
805146 | 805146 | 2020-12-07 | Jackson | Missouri | 29095 | 19126 | 190 |
801901 | 801901 | 2020-12-06 | Jackson | Missouri | 29095 | 18944 | 190 |
798656 | 798656 | 2020-12-05 | Jackson | Missouri | 29095 | 18654 | 190 |
795411 | 795411 | 2020-12-04 | Jackson | Missouri | 29095 | 18369 | 186 |
792166 | 792166 | 2020-12-03 | Jackson | Missouri | 29095 | 18081 | 185 |
788921 | 788921 | 2020-12-02 | Jackson | Missouri | 29095 | 17812 | 184 |
785676 | 785676 | 2020-12-01 | Jackson | Missouri | 29095 | 17660 | 183 |
782432 | 782432 | 2020-11-30 | Jackson | Missouri | 29095 | 17379 | 180 |
779186 | 779186 | 2020-11-29 | Jackson | Missouri | 29095 | 17136 | 180 |
775941 | 775941 | 2020-11-28 | Jackson | Missouri | 29095 | 16937 | 177 |
772696 | 772696 | 2020-11-27 | Jackson | Missouri | 29095 | 16812 | 176 |
769451 | 769451 | 2020-11-26 | Jackson | Missouri | 29095 | 16601 | 176 |
766205 | 766205 | 2020-11-25 | Jackson | Missouri | 29095 | 16310 | 176 |
762960 | 762960 | 2020-11-24 | Jackson | Missouri | 29095 | 16106 | 175 |
759715 | 759715 | 2020-11-23 | Jackson | Missouri | 29095 | 15920 | 171 |
756468 | 756468 | 2020-11-22 | Jackson | Missouri | 29095 | 15695 | 171 |
753222 | 753222 | 2020-11-21 | Jackson | Missouri | 29095 | 15478 | 171 |
749976 | 749976 | 2020-11-20 | Jackson | Missouri | 29095 | 15213 | 170 |
746730 | 746730 | 2020-11-19 | Jackson | Missouri | 29095 | 14949 | 166 |
743483 | 743483 | 2020-11-18 | Jackson | Missouri | 29095 | 14701 | 165 |
740236 | 740236 | 2020-11-17 | Jackson | Missouri | 29095 | 14380 | 163 |
736992 | 736992 | 2020-11-16 | Jackson | Missouri | 29095 | 13966 | 155 |
733746 | 733746 | 2020-11-15 | Jackson | Missouri | 29095 | 13748 | 153 |
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);