ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "St. Joseph" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054282 | 1054282 | 2021-02-22 | St. Joseph | Indiana | 18141 | 29522 | 528 |
1051035 | 1051035 | 2021-02-21 | St. Joseph | Indiana | 18141 | 29457 | 525 |
1047788 | 1047788 | 2021-02-20 | St. Joseph | Indiana | 18141 | 29401 | 524 |
1044543 | 1044543 | 2021-02-19 | St. Joseph | Indiana | 18141 | 29298 | 522 |
1041298 | 1041298 | 2021-02-18 | St. Joseph | Indiana | 18141 | 29218 | 519 |
1038053 | 1038053 | 2021-02-17 | St. Joseph | Indiana | 18141 | 29133 | 519 |
1034808 | 1034808 | 2021-02-16 | St. Joseph | Indiana | 18141 | 29039 | 519 |
1031562 | 1031562 | 2021-02-15 | St. Joseph | Indiana | 18141 | 28988 | 517 |
1028315 | 1028315 | 2021-02-14 | St. Joseph | Indiana | 18141 | 28958 | 517 |
1025070 | 1025070 | 2021-02-13 | St. Joseph | Indiana | 18141 | 28858 | 516 |
1021825 | 1021825 | 2021-02-12 | St. Joseph | Indiana | 18141 | 28769 | 515 |
1018580 | 1018580 | 2021-02-11 | St. Joseph | Indiana | 18141 | 28690 | 513 |
1015335 | 1015335 | 2021-02-10 | St. Joseph | Indiana | 18141 | 28592 | 513 |
1012090 | 1012090 | 2021-02-09 | St. Joseph | Indiana | 18141 | 28514 | 510 |
1008844 | 1008844 | 2021-02-08 | St. Joseph | Indiana | 18141 | 28480 | 510 |
1005598 | 1005598 | 2021-02-07 | St. Joseph | Indiana | 18141 | 28436 | 507 |
1002352 | 1002352 | 2021-02-06 | St. Joseph | Indiana | 18141 | 28382 | 506 |
999106 | 999106 | 2021-02-05 | St. Joseph | Indiana | 18141 | 28291 | 504 |
995860 | 995860 | 2021-02-04 | St. Joseph | Indiana | 18141 | 28242 | 502 |
992614 | 992614 | 2021-02-03 | St. Joseph | Indiana | 18141 | 28131 | 419 |
989368 | 989368 | 2021-02-02 | St. Joseph | Indiana | 18141 | 28083 | 416 |
986121 | 986121 | 2021-02-01 | St. Joseph | Indiana | 18141 | 28039 | 413 |
982874 | 982874 | 2021-01-31 | St. Joseph | Indiana | 18141 | 27992 | 412 |
979628 | 979628 | 2021-01-30 | St. Joseph | Indiana | 18141 | 27923 | 412 |
976382 | 976382 | 2021-01-29 | St. Joseph | Indiana | 18141 | 27850 | 412 |
973137 | 973137 | 2021-01-28 | St. Joseph | Indiana | 18141 | 27767 | 407 |
969892 | 969892 | 2021-01-27 | St. Joseph | Indiana | 18141 | 27658 | 405 |
966648 | 966648 | 2021-01-26 | St. Joseph | Indiana | 18141 | 27607 | 403 |
963403 | 963403 | 2021-01-25 | St. Joseph | Indiana | 18141 | 27566 | 402 |
960158 | 960158 | 2021-01-24 | St. Joseph | Indiana | 18141 | 27484 | 401 |
956912 | 956912 | 2021-01-23 | St. Joseph | Indiana | 18141 | 27415 | 401 |
953667 | 953667 | 2021-01-22 | St. Joseph | Indiana | 18141 | 27295 | 400 |
950422 | 950422 | 2021-01-21 | St. Joseph | Indiana | 18141 | 27168 | 400 |
947176 | 947176 | 2021-01-20 | St. Joseph | Indiana | 18141 | 27049 | 398 |
943929 | 943929 | 2021-01-19 | St. Joseph | Indiana | 18141 | 26952 | 398 |
940684 | 940684 | 2021-01-18 | St. Joseph | Indiana | 18141 | 26882 | 392 |
937439 | 937439 | 2021-01-17 | St. Joseph | Indiana | 18141 | 26801 | 391 |
934194 | 934194 | 2021-01-16 | St. Joseph | Indiana | 18141 | 26719 | 389 |
930949 | 930949 | 2021-01-15 | St. Joseph | Indiana | 18141 | 26577 | 389 |
927704 | 927704 | 2021-01-14 | St. Joseph | Indiana | 18141 | 26444 | 389 |
924458 | 924458 | 2021-01-13 | St. Joseph | Indiana | 18141 | 26262 | 388 |
921213 | 921213 | 2021-01-12 | St. Joseph | Indiana | 18141 | 26101 | 388 |
917968 | 917968 | 2021-01-11 | St. Joseph | Indiana | 18141 | 25999 | 385 |
914723 | 914723 | 2021-01-10 | St. Joseph | Indiana | 18141 | 25878 | 385 |
911478 | 911478 | 2021-01-09 | St. Joseph | Indiana | 18141 | 25720 | 385 |
908233 | 908233 | 2021-01-08 | St. Joseph | Indiana | 18141 | 25570 | 379 |
904987 | 904987 | 2021-01-07 | St. Joseph | Indiana | 18141 | 25366 | 377 |
901742 | 901742 | 2021-01-06 | St. Joseph | Indiana | 18141 | 25130 | 377 |
898497 | 898497 | 2021-01-05 | St. Joseph | Indiana | 18141 | 24951 | 375 |
895252 | 895252 | 2021-01-04 | St. Joseph | Indiana | 18141 | 24864 | 371 |
892005 | 892005 | 2021-01-03 | St. Joseph | Indiana | 18141 | 24761 | 370 |
888759 | 888759 | 2021-01-02 | St. Joseph | Indiana | 18141 | 24673 | 367 |
885513 | 885513 | 2021-01-01 | St. Joseph | Indiana | 18141 | 24478 | 367 |
882268 | 882268 | 2020-12-31 | St. Joseph | Indiana | 18141 | 24264 | 367 |
879023 | 879023 | 2020-12-30 | St. Joseph | Indiana | 18141 | 24068 | 361 |
875778 | 875778 | 2020-12-29 | St. Joseph | Indiana | 18141 | 23966 | 358 |
872533 | 872533 | 2020-12-28 | St. Joseph | Indiana | 18141 | 23892 | 354 |
869288 | 869288 | 2020-12-27 | St. Joseph | Indiana | 18141 | 23813 | 352 |
866043 | 866043 | 2020-12-26 | St. Joseph | Indiana | 18141 | 23756 | 350 |
862798 | 862798 | 2020-12-25 | St. Joseph | Indiana | 18141 | 23613 | 345 |
859553 | 859553 | 2020-12-24 | St. Joseph | Indiana | 18141 | 23435 | 345 |
856308 | 856308 | 2020-12-23 | St. Joseph | Indiana | 18141 | 23214 | 340 |
853063 | 853063 | 2020-12-22 | St. Joseph | Indiana | 18141 | 23075 | 335 |
849818 | 849818 | 2020-12-21 | St. Joseph | Indiana | 18141 | 22988 | 323 |
846573 | 846573 | 2020-12-20 | St. Joseph | Indiana | 18141 | 22867 | 321 |
843327 | 843327 | 2020-12-19 | St. Joseph | Indiana | 18141 | 22670 | 320 |
840082 | 840082 | 2020-12-18 | St. Joseph | Indiana | 18141 | 22512 | 318 |
836837 | 836837 | 2020-12-17 | St. Joseph | Indiana | 18141 | 22341 | 316 |
833591 | 833591 | 2020-12-16 | St. Joseph | Indiana | 18141 | 22157 | 309 |
830344 | 830344 | 2020-12-15 | St. Joseph | Indiana | 18141 | 21948 | 307 |
827098 | 827098 | 2020-12-14 | St. Joseph | Indiana | 18141 | 21813 | 304 |
823851 | 823851 | 2020-12-13 | St. Joseph | Indiana | 18141 | 21668 | 304 |
820605 | 820605 | 2020-12-12 | St. Joseph | Indiana | 18141 | 21454 | 299 |
817359 | 817359 | 2020-12-11 | St. Joseph | Indiana | 18141 | 21125 | 294 |
814113 | 814113 | 2020-12-10 | St. Joseph | Indiana | 18141 | 20847 | 292 |
810868 | 810868 | 2020-12-09 | St. Joseph | Indiana | 18141 | 20636 | 287 |
807623 | 807623 | 2020-12-08 | St. Joseph | Indiana | 18141 | 20438 | 282 |
804378 | 804378 | 2020-12-07 | St. Joseph | Indiana | 18141 | 20168 | 277 |
801133 | 801133 | 2020-12-06 | St. Joseph | Indiana | 18141 | 20008 | 273 |
797888 | 797888 | 2020-12-05 | St. Joseph | Indiana | 18141 | 19749 | 270 |
794643 | 794643 | 2020-12-04 | St. Joseph | Indiana | 18141 | 19464 | 263 |
791398 | 791398 | 2020-12-03 | St. Joseph | Indiana | 18141 | 19206 | 259 |
788153 | 788153 | 2020-12-02 | St. Joseph | Indiana | 18141 | 18348 | 257 |
784909 | 784909 | 2020-12-01 | St. Joseph | Indiana | 18141 | 18148 | 253 |
781664 | 781664 | 2020-11-30 | St. Joseph | Indiana | 18141 | 17834 | 250 |
778418 | 778418 | 2020-11-29 | St. Joseph | Indiana | 18141 | 17625 | 248 |
775173 | 775173 | 2020-11-28 | St. Joseph | Indiana | 18141 | 17435 | 246 |
771928 | 771928 | 2020-11-27 | St. Joseph | Indiana | 18141 | 17283 | 245 |
768683 | 768683 | 2020-11-26 | St. Joseph | Indiana | 18141 | 17098 | 245 |
765437 | 765437 | 2020-11-25 | St. Joseph | Indiana | 18141 | 16826 | 240 |
762192 | 762192 | 2020-11-24 | St. Joseph | Indiana | 18141 | 16551 | 234 |
758947 | 758947 | 2020-11-23 | St. Joseph | Indiana | 18141 | 16346 | 231 |
755700 | 755700 | 2020-11-22 | St. Joseph | Indiana | 18141 | 16152 | 228 |
752454 | 752454 | 2020-11-21 | St. Joseph | Indiana | 18141 | 15894 | 226 |
749208 | 749208 | 2020-11-20 | St. Joseph | Indiana | 18141 | 15564 | 225 |
745962 | 745962 | 2020-11-19 | St. Joseph | Indiana | 18141 | 15264 | 222 |
742715 | 742715 | 2020-11-18 | St. Joseph | Indiana | 18141 | 14990 | 214 |
739468 | 739468 | 2020-11-17 | St. Joseph | Indiana | 18141 | 14725 | 209 |
736224 | 736224 | 2020-11-16 | St. Joseph | Indiana | 18141 | 14486 | 207 |
732978 | 732978 | 2020-11-15 | St. Joseph | Indiana | 18141 | 14229 | 205 |
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);