ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Montgomery" and fips = 17135 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1076892 | 1076892 | 2021-03-01 | Montgomery | Illinois | 17135 | 3500 | 74 |
1073646 | 1073646 | 2021-02-28 | Montgomery | Illinois | 17135 | 3495 | 74 |
1070400 | 1070400 | 2021-02-27 | Montgomery | Illinois | 17135 | 3492 | 74 |
1067155 | 1067155 | 2021-02-26 | Montgomery | Illinois | 17135 | 3486 | 73 |
1063910 | 1063910 | 2021-02-25 | Montgomery | Illinois | 17135 | 3473 | 73 |
1060665 | 1060665 | 2021-02-24 | Montgomery | Illinois | 17135 | 3467 | 73 |
1057419 | 1057419 | 2021-02-23 | Montgomery | Illinois | 17135 | 3460 | 73 |
1054173 | 1054173 | 2021-02-22 | Montgomery | Illinois | 17135 | 3453 | 73 |
1050926 | 1050926 | 2021-02-21 | Montgomery | Illinois | 17135 | 3448 | 73 |
1047679 | 1047679 | 2021-02-20 | Montgomery | Illinois | 17135 | 3440 | 73 |
1044434 | 1044434 | 2021-02-19 | Montgomery | Illinois | 17135 | 3435 | 73 |
1041189 | 1041189 | 2021-02-18 | Montgomery | Illinois | 17135 | 3428 | 73 |
1037944 | 1037944 | 2021-02-17 | Montgomery | Illinois | 17135 | 3420 | 73 |
1034699 | 1034699 | 2021-02-16 | Montgomery | Illinois | 17135 | 3415 | 73 |
1031453 | 1031453 | 2021-02-15 | Montgomery | Illinois | 17135 | 3408 | 73 |
1028206 | 1028206 | 2021-02-14 | Montgomery | Illinois | 17135 | 3399 | 73 |
1024961 | 1024961 | 2021-02-13 | Montgomery | Illinois | 17135 | 3397 | 73 |
1021716 | 1021716 | 2021-02-12 | Montgomery | Illinois | 17135 | 3379 | 73 |
1018471 | 1018471 | 2021-02-11 | Montgomery | Illinois | 17135 | 3372 | 73 |
1015226 | 1015226 | 2021-02-10 | Montgomery | Illinois | 17135 | 3357 | 73 |
1011981 | 1011981 | 2021-02-09 | Montgomery | Illinois | 17135 | 3336 | 73 |
1008735 | 1008735 | 2021-02-08 | Montgomery | Illinois | 17135 | 3326 | 73 |
1005489 | 1005489 | 2021-02-07 | Montgomery | Illinois | 17135 | 3325 | 72 |
1002243 | 1002243 | 2021-02-06 | Montgomery | Illinois | 17135 | 3321 | 72 |
998997 | 998997 | 2021-02-05 | Montgomery | Illinois | 17135 | 3315 | 70 |
995751 | 995751 | 2021-02-04 | Montgomery | Illinois | 17135 | 3306 | 69 |
992505 | 992505 | 2021-02-03 | Montgomery | Illinois | 17135 | 3298 | 68 |
989259 | 989259 | 2021-02-02 | Montgomery | Illinois | 17135 | 3282 | 64 |
986012 | 986012 | 2021-02-01 | Montgomery | Illinois | 17135 | 3271 | 63 |
982765 | 982765 | 2021-01-31 | Montgomery | Illinois | 17135 | 3257 | 61 |
979519 | 979519 | 2021-01-30 | Montgomery | Illinois | 17135 | 3247 | 61 |
976274 | 976274 | 2021-01-29 | Montgomery | Illinois | 17135 | 3240 | 61 |
973029 | 973029 | 2021-01-28 | Montgomery | Illinois | 17135 | 3229 | 61 |
969784 | 969784 | 2021-01-27 | Montgomery | Illinois | 17135 | 3198 | 60 |
966540 | 966540 | 2021-01-26 | Montgomery | Illinois | 17135 | 3174 | 57 |
963295 | 963295 | 2021-01-25 | Montgomery | Illinois | 17135 | 3166 | 53 |
960050 | 960050 | 2021-01-24 | Montgomery | Illinois | 17135 | 3159 | 53 |
956804 | 956804 | 2021-01-23 | Montgomery | Illinois | 17135 | 3154 | 53 |
953559 | 953559 | 2021-01-22 | Montgomery | Illinois | 17135 | 3122 | 50 |
950314 | 950314 | 2021-01-21 | Montgomery | Illinois | 17135 | 3105 | 47 |
947068 | 947068 | 2021-01-20 | Montgomery | Illinois | 17135 | 3078 | 44 |
943821 | 943821 | 2021-01-19 | Montgomery | Illinois | 17135 | 3053 | 41 |
940576 | 940576 | 2021-01-18 | Montgomery | Illinois | 17135 | 3038 | 40 |
937331 | 937331 | 2021-01-17 | Montgomery | Illinois | 17135 | 3031 | 40 |
934086 | 934086 | 2021-01-16 | Montgomery | Illinois | 17135 | 3006 | 40 |
930841 | 930841 | 2021-01-15 | Montgomery | Illinois | 17135 | 2970 | 37 |
927596 | 927596 | 2021-01-14 | Montgomery | Illinois | 17135 | 2943 | 37 |
924350 | 924350 | 2021-01-13 | Montgomery | Illinois | 17135 | 2899 | 37 |
921105 | 921105 | 2021-01-12 | Montgomery | Illinois | 17135 | 2846 | 35 |
917860 | 917860 | 2021-01-11 | Montgomery | Illinois | 17135 | 2754 | 33 |
914615 | 914615 | 2021-01-10 | Montgomery | Illinois | 17135 | 2634 | 33 |
911370 | 911370 | 2021-01-09 | Montgomery | Illinois | 17135 | 2597 | 31 |
908125 | 908125 | 2021-01-08 | Montgomery | Illinois | 17135 | 2541 | 29 |
904879 | 904879 | 2021-01-07 | Montgomery | Illinois | 17135 | 2477 | 27 |
901634 | 901634 | 2021-01-06 | Montgomery | Illinois | 17135 | 2449 | 25 |
898389 | 898389 | 2021-01-05 | Montgomery | Illinois | 17135 | 2386 | 25 |
895144 | 895144 | 2021-01-04 | Montgomery | Illinois | 17135 | 2328 | 25 |
891897 | 891897 | 2021-01-03 | Montgomery | Illinois | 17135 | 2254 | 25 |
888650 | 888650 | 2021-01-02 | Montgomery | Illinois | 17135 | 2225 | 25 |
885405 | 885405 | 2021-01-01 | Montgomery | Illinois | 17135 | 2166 | 24 |
882160 | 882160 | 2020-12-31 | Montgomery | Illinois | 17135 | 2166 | 24 |
878915 | 878915 | 2020-12-30 | Montgomery | Illinois | 17135 | 2115 | 23 |
875670 | 875670 | 2020-12-29 | Montgomery | Illinois | 17135 | 2069 | 22 |
872425 | 872425 | 2020-12-28 | Montgomery | Illinois | 17135 | 2057 | 22 |
869180 | 869180 | 2020-12-27 | Montgomery | Illinois | 17135 | 2025 | 22 |
865935 | 865935 | 2020-12-26 | Montgomery | Illinois | 17135 | 1993 | 22 |
862690 | 862690 | 2020-12-25 | Montgomery | Illinois | 17135 | 1821 | 22 |
859445 | 859445 | 2020-12-24 | Montgomery | Illinois | 17135 | 1729 | 22 |
856200 | 856200 | 2020-12-23 | Montgomery | Illinois | 17135 | 1691 | 22 |
852955 | 852955 | 2020-12-22 | Montgomery | Illinois | 17135 | 1655 | 21 |
849710 | 849710 | 2020-12-21 | Montgomery | Illinois | 17135 | 1638 | 21 |
846465 | 846465 | 2020-12-20 | Montgomery | Illinois | 17135 | 1612 | 21 |
843219 | 843219 | 2020-12-19 | Montgomery | Illinois | 17135 | 1593 | 20 |
839974 | 839974 | 2020-12-18 | Montgomery | Illinois | 17135 | 1587 | 20 |
836729 | 836729 | 2020-12-17 | Montgomery | Illinois | 17135 | 1555 | 20 |
833483 | 833483 | 2020-12-16 | Montgomery | Illinois | 17135 | 1531 | 20 |
830236 | 830236 | 2020-12-15 | Montgomery | Illinois | 17135 | 1507 | 18 |
826990 | 826990 | 2020-12-14 | Montgomery | Illinois | 17135 | 1490 | 18 |
823743 | 823743 | 2020-12-13 | Montgomery | Illinois | 17135 | 1473 | 18 |
820497 | 820497 | 2020-12-12 | Montgomery | Illinois | 17135 | 1449 | 18 |
817251 | 817251 | 2020-12-11 | Montgomery | Illinois | 17135 | 1425 | 18 |
814005 | 814005 | 2020-12-10 | Montgomery | Illinois | 17135 | 1404 | 18 |
810760 | 810760 | 2020-12-09 | Montgomery | Illinois | 17135 | 1362 | 18 |
807515 | 807515 | 2020-12-08 | Montgomery | Illinois | 17135 | 1334 | 18 |
804270 | 804270 | 2020-12-07 | Montgomery | Illinois | 17135 | 1325 | 19 |
801025 | 801025 | 2020-12-06 | Montgomery | Illinois | 17135 | 1311 | 19 |
797780 | 797780 | 2020-12-05 | Montgomery | Illinois | 17135 | 1296 | 19 |
794535 | 794535 | 2020-12-04 | Montgomery | Illinois | 17135 | 1278 | 19 |
791290 | 791290 | 2020-12-03 | Montgomery | Illinois | 17135 | 1240 | 19 |
788045 | 788045 | 2020-12-02 | Montgomery | Illinois | 17135 | 1212 | 19 |
784801 | 784801 | 2020-12-01 | Montgomery | Illinois | 17135 | 1189 | 18 |
781556 | 781556 | 2020-11-30 | Montgomery | Illinois | 17135 | 1159 | 18 |
778310 | 778310 | 2020-11-29 | Montgomery | Illinois | 17135 | 1155 | 18 |
775065 | 775065 | 2020-11-28 | Montgomery | Illinois | 17135 | 1141 | 18 |
771820 | 771820 | 2020-11-27 | Montgomery | Illinois | 17135 | 1126 | 18 |
768575 | 768575 | 2020-11-26 | Montgomery | Illinois | 17135 | 1115 | 18 |
765329 | 765329 | 2020-11-25 | Montgomery | Illinois | 17135 | 1079 | 18 |
762084 | 762084 | 2020-11-24 | Montgomery | Illinois | 17135 | 1058 | 18 |
758839 | 758839 | 2020-11-23 | Montgomery | Illinois | 17135 | 1050 | 18 |
755592 | 755592 | 2020-11-22 | Montgomery | Illinois | 17135 | 1043 | 18 |
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);