ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
236 rows where county = "Scott", deaths = 1 and fips = 17171 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
820514 | 820514 | 2020-12-12 | Scott | Illinois | 17171 | 276 | 1 |
823760 | 823760 | 2020-12-13 | Scott | Illinois | 17171 | 279 | 1 |
827007 | 827007 | 2020-12-14 | Scott | Illinois | 17171 | 280 | 1 |
830253 | 830253 | 2020-12-15 | Scott | Illinois | 17171 | 285 | 1 |
833500 | 833500 | 2020-12-16 | Scott | Illinois | 17171 | 285 | 1 |
836746 | 836746 | 2020-12-17 | Scott | Illinois | 17171 | 289 | 1 |
839991 | 839991 | 2020-12-18 | Scott | Illinois | 17171 | 289 | 1 |
843236 | 843236 | 2020-12-19 | Scott | Illinois | 17171 | 292 | 1 |
846482 | 846482 | 2020-12-20 | Scott | Illinois | 17171 | 292 | 1 |
849727 | 849727 | 2020-12-21 | Scott | Illinois | 17171 | 292 | 1 |
852972 | 852972 | 2020-12-22 | Scott | Illinois | 17171 | 298 | 1 |
856217 | 856217 | 2020-12-23 | Scott | Illinois | 17171 | 299 | 1 |
859462 | 859462 | 2020-12-24 | Scott | Illinois | 17171 | 307 | 1 |
862707 | 862707 | 2020-12-25 | Scott | Illinois | 17171 | 307 | 1 |
865952 | 865952 | 2020-12-26 | Scott | Illinois | 17171 | 309 | 1 |
869197 | 869197 | 2020-12-27 | Scott | Illinois | 17171 | 311 | 1 |
872442 | 872442 | 2020-12-28 | Scott | Illinois | 17171 | 313 | 1 |
875687 | 875687 | 2020-12-29 | Scott | Illinois | 17171 | 321 | 1 |
878932 | 878932 | 2020-12-30 | Scott | Illinois | 17171 | 325 | 1 |
882177 | 882177 | 2020-12-31 | Scott | Illinois | 17171 | 327 | 1 |
885422 | 885422 | 2021-01-01 | Scott | Illinois | 17171 | 327 | 1 |
888667 | 888667 | 2021-01-02 | Scott | Illinois | 17171 | 333 | 1 |
891914 | 891914 | 2021-01-03 | Scott | Illinois | 17171 | 333 | 1 |
895161 | 895161 | 2021-01-04 | Scott | Illinois | 17171 | 335 | 1 |
898406 | 898406 | 2021-01-05 | Scott | Illinois | 17171 | 339 | 1 |
901651 | 901651 | 2021-01-06 | Scott | Illinois | 17171 | 341 | 1 |
904896 | 904896 | 2021-01-07 | Scott | Illinois | 17171 | 343 | 1 |
908142 | 908142 | 2021-01-08 | Scott | Illinois | 17171 | 344 | 1 |
911387 | 911387 | 2021-01-09 | Scott | Illinois | 17171 | 352 | 1 |
914632 | 914632 | 2021-01-10 | Scott | Illinois | 17171 | 352 | 1 |
917877 | 917877 | 2021-01-11 | Scott | Illinois | 17171 | 354 | 1 |
921122 | 921122 | 2021-01-12 | Scott | Illinois | 17171 | 362 | 1 |
924367 | 924367 | 2021-01-13 | Scott | Illinois | 17171 | 362 | 1 |
927613 | 927613 | 2021-01-14 | Scott | Illinois | 17171 | 366 | 1 |
930858 | 930858 | 2021-01-15 | Scott | Illinois | 17171 | 367 | 1 |
934103 | 934103 | 2021-01-16 | Scott | Illinois | 17171 | 373 | 1 |
937348 | 937348 | 2021-01-17 | Scott | Illinois | 17171 | 373 | 1 |
940593 | 940593 | 2021-01-18 | Scott | Illinois | 17171 | 375 | 1 |
943838 | 943838 | 2021-01-19 | Scott | Illinois | 17171 | 385 | 1 |
947085 | 947085 | 2021-01-20 | Scott | Illinois | 17171 | 386 | 1 |
950331 | 950331 | 2021-01-21 | Scott | Illinois | 17171 | 396 | 1 |
953576 | 953576 | 2021-01-22 | Scott | Illinois | 17171 | 397 | 1 |
956821 | 956821 | 2021-01-23 | Scott | Illinois | 17171 | 407 | 1 |
960067 | 960067 | 2021-01-24 | Scott | Illinois | 17171 | 408 | 1 |
963312 | 963312 | 2021-01-25 | Scott | Illinois | 17171 | 408 | 1 |
966557 | 966557 | 2021-01-26 | Scott | Illinois | 17171 | 413 | 1 |
969801 | 969801 | 2021-01-27 | Scott | Illinois | 17171 | 414 | 1 |
973046 | 973046 | 2021-01-28 | Scott | Illinois | 17171 | 416 | 1 |
976291 | 976291 | 2021-01-29 | Scott | Illinois | 17171 | 418 | 1 |
979536 | 979536 | 2021-01-30 | Scott | Illinois | 17171 | 421 | 1 |
982782 | 982782 | 2021-01-31 | Scott | Illinois | 17171 | 422 | 1 |
986029 | 986029 | 2021-02-01 | Scott | Illinois | 17171 | 422 | 1 |
989276 | 989276 | 2021-02-02 | Scott | Illinois | 17171 | 425 | 1 |
992522 | 992522 | 2021-02-03 | Scott | Illinois | 17171 | 427 | 1 |
995768 | 995768 | 2021-02-04 | Scott | Illinois | 17171 | 427 | 1 |
999014 | 999014 | 2021-02-05 | Scott | Illinois | 17171 | 433 | 1 |
1002260 | 1002260 | 2021-02-06 | Scott | Illinois | 17171 | 440 | 1 |
1005506 | 1005506 | 2021-02-07 | Scott | Illinois | 17171 | 440 | 1 |
1008752 | 1008752 | 2021-02-08 | Scott | Illinois | 17171 | 441 | 1 |
1011998 | 1011998 | 2021-02-09 | Scott | Illinois | 17171 | 443 | 1 |
1015243 | 1015243 | 2021-02-10 | Scott | Illinois | 17171 | 444 | 1 |
1018488 | 1018488 | 2021-02-11 | Scott | Illinois | 17171 | 444 | 1 |
1021733 | 1021733 | 2021-02-12 | Scott | Illinois | 17171 | 444 | 1 |
1024978 | 1024978 | 2021-02-13 | Scott | Illinois | 17171 | 444 | 1 |
1028223 | 1028223 | 2021-02-14 | Scott | Illinois | 17171 | 444 | 1 |
1031470 | 1031470 | 2021-02-15 | Scott | Illinois | 17171 | 444 | 1 |
1034716 | 1034716 | 2021-02-16 | Scott | Illinois | 17171 | 445 | 1 |
1037961 | 1037961 | 2021-02-17 | Scott | Illinois | 17171 | 446 | 1 |
1041206 | 1041206 | 2021-02-18 | Scott | Illinois | 17171 | 446 | 1 |
1044451 | 1044451 | 2021-02-19 | Scott | Illinois | 17171 | 446 | 1 |
1047696 | 1047696 | 2021-02-20 | Scott | Illinois | 17171 | 446 | 1 |
1050943 | 1050943 | 2021-02-21 | Scott | Illinois | 17171 | 446 | 1 |
1054190 | 1054190 | 2021-02-22 | Scott | Illinois | 17171 | 447 | 1 |
1057436 | 1057436 | 2021-02-23 | Scott | Illinois | 17171 | 448 | 1 |
1060682 | 1060682 | 2021-02-24 | Scott | Illinois | 17171 | 448 | 1 |
1063927 | 1063927 | 2021-02-25 | Scott | Illinois | 17171 | 448 | 1 |
1067172 | 1067172 | 2021-02-26 | Scott | Illinois | 17171 | 448 | 1 |
1070417 | 1070417 | 2021-02-27 | Scott | Illinois | 17171 | 449 | 1 |
1073663 | 1073663 | 2021-02-28 | Scott | Illinois | 17171 | 449 | 1 |
1076909 | 1076909 | 2021-03-01 | Scott | Illinois | 17171 | 449 | 1 |
1080154 | 1080154 | 2021-03-02 | Scott | Illinois | 17171 | 449 | 1 |
1083400 | 1083400 | 2021-03-03 | Scott | Illinois | 17171 | 449 | 1 |
1086646 | 1086646 | 2021-03-04 | Scott | Illinois | 17171 | 449 | 1 |
1089891 | 1089891 | 2021-03-05 | Scott | Illinois | 17171 | 449 | 1 |
1093137 | 1093137 | 2021-03-06 | Scott | Illinois | 17171 | 449 | 1 |
1096383 | 1096383 | 2021-03-07 | Scott | Illinois | 17171 | 449 | 1 |
1099631 | 1099631 | 2021-03-08 | Scott | Illinois | 17171 | 449 | 1 |
1102877 | 1102877 | 2021-03-09 | Scott | Illinois | 17171 | 451 | 1 |
1106123 | 1106123 | 2021-03-10 | Scott | Illinois | 17171 | 451 | 1 |
1109369 | 1109369 | 2021-03-11 | Scott | Illinois | 17171 | 451 | 1 |
1112615 | 1112615 | 2021-03-12 | Scott | Illinois | 17171 | 451 | 1 |
1115861 | 1115861 | 2021-03-13 | Scott | Illinois | 17171 | 451 | 1 |
1119108 | 1119108 | 2021-03-14 | Scott | Illinois | 17171 | 451 | 1 |
1122355 | 1122355 | 2021-03-15 | Scott | Illinois | 17171 | 451 | 1 |
1125601 | 1125601 | 2021-03-16 | Scott | Illinois | 17171 | 451 | 1 |
1128847 | 1128847 | 2021-03-17 | Scott | Illinois | 17171 | 451 | 1 |
1132095 | 1132095 | 2021-03-18 | Scott | Illinois | 17171 | 451 | 1 |
1135342 | 1135342 | 2021-03-19 | Scott | Illinois | 17171 | 452 | 1 |
1138588 | 1138588 | 2021-03-20 | Scott | Illinois | 17171 | 452 | 1 |
1141834 | 1141834 | 2021-03-21 | Scott | Illinois | 17171 | 452 | 1 |
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);