ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Madison" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054162 | 1054162 | 2021-02-22 | Madison | Illinois | 17119 | 27687 | 523 |
1050915 | 1050915 | 2021-02-21 | Madison | Illinois | 17119 | 27664 | 522 |
1047668 | 1047668 | 2021-02-20 | Madison | Illinois | 17119 | 27616 | 522 |
1044423 | 1044423 | 2021-02-19 | Madison | Illinois | 17119 | 27562 | 521 |
1041178 | 1041178 | 2021-02-18 | Madison | Illinois | 17119 | 27507 | 520 |
1037933 | 1037933 | 2021-02-17 | Madison | Illinois | 17119 | 27452 | 516 |
1034688 | 1034688 | 2021-02-16 | Madison | Illinois | 17119 | 27424 | 515 |
1031442 | 1031442 | 2021-02-15 | Madison | Illinois | 17119 | 27389 | 515 |
1028195 | 1028195 | 2021-02-14 | Madison | Illinois | 17119 | 27338 | 515 |
1024950 | 1024950 | 2021-02-13 | Madison | Illinois | 17119 | 27273 | 515 |
1021705 | 1021705 | 2021-02-12 | Madison | Illinois | 17119 | 27192 | 513 |
1018460 | 1018460 | 2021-02-11 | Madison | Illinois | 17119 | 27127 | 511 |
1015215 | 1015215 | 2021-02-10 | Madison | Illinois | 17119 | 27038 | 511 |
1011970 | 1011970 | 2021-02-09 | Madison | Illinois | 17119 | 26970 | 511 |
1008724 | 1008724 | 2021-02-08 | Madison | Illinois | 17119 | 26907 | 511 |
1005478 | 1005478 | 2021-02-07 | Madison | Illinois | 17119 | 26839 | 511 |
1002232 | 1002232 | 2021-02-06 | Madison | Illinois | 17119 | 26763 | 510 |
998986 | 998986 | 2021-02-05 | Madison | Illinois | 17119 | 26666 | 510 |
995740 | 995740 | 2021-02-04 | Madison | Illinois | 17119 | 26563 | 510 |
992494 | 992494 | 2021-02-03 | Madison | Illinois | 17119 | 26467 | 510 |
989248 | 989248 | 2021-02-02 | Madison | Illinois | 17119 | 26351 | 510 |
986001 | 986001 | 2021-02-01 | Madison | Illinois | 17119 | 26251 | 502 |
982754 | 982754 | 2021-01-31 | Madison | Illinois | 17119 | 26173 | 499 |
979508 | 979508 | 2021-01-30 | Madison | Illinois | 17119 | 26033 | 499 |
976263 | 976263 | 2021-01-29 | Madison | Illinois | 17119 | 25953 | 499 |
973018 | 973018 | 2021-01-28 | Madison | Illinois | 17119 | 25824 | 497 |
969773 | 969773 | 2021-01-27 | Madison | Illinois | 17119 | 25705 | 492 |
966529 | 966529 | 2021-01-26 | Madison | Illinois | 17119 | 25542 | 487 |
963284 | 963284 | 2021-01-25 | Madison | Illinois | 17119 | 25429 | 480 |
960039 | 960039 | 2021-01-24 | Madison | Illinois | 17119 | 25299 | 477 |
956793 | 956793 | 2021-01-23 | Madison | Illinois | 17119 | 25198 | 475 |
953548 | 953548 | 2021-01-22 | Madison | Illinois | 17119 | 25015 | 472 |
950303 | 950303 | 2021-01-21 | Madison | Illinois | 17119 | 24822 | 471 |
947057 | 947057 | 2021-01-20 | Madison | Illinois | 17119 | 24604 | 468 |
943810 | 943810 | 2021-01-19 | Madison | Illinois | 17119 | 24398 | 463 |
940565 | 940565 | 2021-01-18 | Madison | Illinois | 17119 | 24262 | 463 |
937320 | 937320 | 2021-01-17 | Madison | Illinois | 17119 | 24144 | 462 |
934075 | 934075 | 2021-01-16 | Madison | Illinois | 17119 | 23998 | 461 |
930830 | 930830 | 2021-01-15 | Madison | Illinois | 17119 | 23853 | 455 |
927585 | 927585 | 2021-01-14 | Madison | Illinois | 17119 | 23664 | 449 |
924339 | 924339 | 2021-01-13 | Madison | Illinois | 17119 | 23450 | 445 |
921094 | 921094 | 2021-01-12 | Madison | Illinois | 17119 | 23239 | 444 |
917849 | 917849 | 2021-01-11 | Madison | Illinois | 17119 | 23063 | 433 |
914604 | 914604 | 2021-01-10 | Madison | Illinois | 17119 | 22953 | 433 |
911359 | 911359 | 2021-01-09 | Madison | Illinois | 17119 | 22785 | 429 |
908114 | 908114 | 2021-01-08 | Madison | Illinois | 17119 | 22561 | 426 |
904868 | 904868 | 2021-01-07 | Madison | Illinois | 17119 | 22258 | 423 |
901623 | 901623 | 2021-01-06 | Madison | Illinois | 17119 | 22058 | 418 |
898378 | 898378 | 2021-01-05 | Madison | Illinois | 17119 | 21825 | 411 |
895133 | 895133 | 2021-01-04 | Madison | Illinois | 17119 | 21688 | 402 |
891886 | 891886 | 2021-01-03 | Madison | Illinois | 17119 | 21557 | 397 |
888639 | 888639 | 2021-01-02 | Madison | Illinois | 17119 | 21409 | 394 |
885394 | 885394 | 2021-01-01 | Madison | Illinois | 17119 | 21054 | 389 |
882149 | 882149 | 2020-12-31 | Madison | Illinois | 17119 | 21054 | 389 |
878904 | 878904 | 2020-12-30 | Madison | Illinois | 17119 | 20827 | 384 |
875659 | 875659 | 2020-12-29 | Madison | Illinois | 17119 | 20555 | 384 |
872414 | 872414 | 2020-12-28 | Madison | Illinois | 17119 | 20434 | 382 |
869169 | 869169 | 2020-12-27 | Madison | Illinois | 17119 | 20334 | 379 |
865924 | 865924 | 2020-12-26 | Madison | Illinois | 17119 | 20238 | 373 |
862679 | 862679 | 2020-12-25 | Madison | Illinois | 17119 | 20181 | 373 |
859434 | 859434 | 2020-12-24 | Madison | Illinois | 17119 | 20065 | 372 |
856189 | 856189 | 2020-12-23 | Madison | Illinois | 17119 | 19793 | 366 |
852944 | 852944 | 2020-12-22 | Madison | Illinois | 17119 | 19568 | 362 |
849699 | 849699 | 2020-12-21 | Madison | Illinois | 17119 | 19386 | 360 |
846454 | 846454 | 2020-12-20 | Madison | Illinois | 17119 | 19267 | 355 |
843208 | 843208 | 2020-12-19 | Madison | Illinois | 17119 | 19129 | 354 |
839963 | 839963 | 2020-12-18 | Madison | Illinois | 17119 | 18933 | 350 |
836718 | 836718 | 2020-12-17 | Madison | Illinois | 17119 | 18707 | 346 |
833472 | 833472 | 2020-12-16 | Madison | Illinois | 17119 | 18388 | 344 |
830225 | 830225 | 2020-12-15 | Madison | Illinois | 17119 | 18164 | 337 |
826979 | 826979 | 2020-12-14 | Madison | Illinois | 17119 | 17969 | 329 |
823732 | 823732 | 2020-12-13 | Madison | Illinois | 17119 | 17766 | 329 |
820486 | 820486 | 2020-12-12 | Madison | Illinois | 17119 | 17482 | 325 |
817240 | 817240 | 2020-12-11 | Madison | Illinois | 17119 | 17273 | 316 |
813994 | 813994 | 2020-12-10 | Madison | Illinois | 17119 | 17020 | 313 |
810749 | 810749 | 2020-12-09 | Madison | Illinois | 17119 | 16760 | 307 |
807504 | 807504 | 2020-12-08 | Madison | Illinois | 17119 | 16537 | 298 |
804259 | 804259 | 2020-12-07 | Madison | Illinois | 17119 | 16348 | 287 |
801014 | 801014 | 2020-12-06 | Madison | Illinois | 17119 | 16167 | 285 |
797769 | 797769 | 2020-12-05 | Madison | Illinois | 17119 | 15899 | 276 |
794524 | 794524 | 2020-12-04 | Madison | Illinois | 17119 | 15643 | 271 |
791279 | 791279 | 2020-12-03 | Madison | Illinois | 17119 | 15363 | 270 |
788034 | 788034 | 2020-12-02 | Madison | Illinois | 17119 | 15129 | 263 |
784790 | 784790 | 2020-12-01 | Madison | Illinois | 17119 | 14832 | 262 |
781545 | 781545 | 2020-11-30 | Madison | Illinois | 17119 | 14607 | 259 |
778299 | 778299 | 2020-11-29 | Madison | Illinois | 17119 | 14379 | 255 |
775054 | 775054 | 2020-11-28 | Madison | Illinois | 17119 | 14210 | 253 |
771809 | 771809 | 2020-11-27 | Madison | Illinois | 17119 | 14013 | 249 |
768564 | 768564 | 2020-11-26 | Madison | Illinois | 17119 | 13868 | 241 |
765318 | 765318 | 2020-11-25 | Madison | Illinois | 17119 | 13560 | 241 |
762073 | 762073 | 2020-11-24 | Madison | Illinois | 17119 | 13291 | 235 |
758828 | 758828 | 2020-11-23 | Madison | Illinois | 17119 | 13074 | 231 |
755581 | 755581 | 2020-11-22 | Madison | Illinois | 17119 | 12865 | 219 |
752335 | 752335 | 2020-11-21 | Madison | Illinois | 17119 | 12653 | 219 |
749089 | 749089 | 2020-11-20 | Madison | Illinois | 17119 | 12394 | 219 |
745843 | 745843 | 2020-11-19 | Madison | Illinois | 17119 | 12032 | 217 |
742596 | 742596 | 2020-11-18 | Madison | Illinois | 17119 | 11826 | 204 |
739349 | 739349 | 2020-11-17 | Madison | Illinois | 17119 | 11500 | 200 |
736105 | 736105 | 2020-11-16 | Madison | Illinois | 17119 | 11271 | 184 |
732859 | 732859 | 2020-11-15 | Madison | Illinois | 17119 | 10983 | 183 |
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);