ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,212 rows where county = "Marion" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
939439 | 939439 | 2021-01-17 | Marion | Texas | 48315 | 391 | 20 |
939782 | 939782 | 2021-01-17 | Marion | West Virginia | 54049 | 2843 | 23 |
933465 | 933465 | 2021-01-16 | Marion | Alabama | 1093 | 2446 | 50 |
933573 | 933573 | 2021-01-16 | Marion | Arkansas | 5089 | 792 | 26 |
933781 | 933781 | 2021-01-16 | Marion | Florida | 12083 | 22030 | 534 |
933904 | 933904 | 2021-01-16 | Marion | Georgia | 13197 | 406 | 10 |
934076 | 934076 | 2021-01-16 | Marion | Illinois | 17121 | 3938 | 111 |
934169 | 934169 | 2021-01-16 | Marion | Indiana | 18097 | 81265 | 1359 |
934275 | 934275 | 2021-01-16 | Marion | Iowa | 19125 | 3017 | 52 |
934369 | 934369 | 2021-01-16 | Marion | Kansas | 20115 | 847 | 5 |
934493 | 934493 | 2021-01-16 | Marion | Kentucky | 21155 | 1742 | 20 |
934878 | 934878 | 2021-01-16 | Marion | Mississippi | 28091 | 2083 | 71 |
934979 | 934979 | 2021-01-16 | Marion | Missouri | 29127 | 2509 | 32 |
935528 | 935528 | 2021-01-16 | Marion | Ohio | 39101 | 7305 | 113 |
935667 | 935667 | 2021-01-16 | Marion | Oregon | 41047 | 16085 | 238 |
935864 | 935864 | 2021-01-16 | Marion | South Carolina | 45067 | 2570 | 81 |
935999 | 935999 | 2021-01-16 | Marion | Tennessee | 47115 | 2266 | 31 |
936194 | 936194 | 2021-01-16 | Marion | Texas | 48315 | 361 | 19 |
936537 | 936537 | 2021-01-16 | Marion | West Virginia | 54049 | 2801 | 23 |
930220 | 930220 | 2021-01-15 | Marion | Alabama | 1093 | 2405 | 49 |
930328 | 930328 | 2021-01-15 | Marion | Arkansas | 5089 | 782 | 26 |
930536 | 930536 | 2021-01-15 | Marion | Florida | 12083 | 21788 | 529 |
930659 | 930659 | 2021-01-15 | Marion | Georgia | 13197 | 402 | 10 |
930831 | 930831 | 2021-01-15 | Marion | Illinois | 17121 | 3923 | 111 |
930924 | 930924 | 2021-01-15 | Marion | Indiana | 18097 | 80752 | 1349 |
931030 | 931030 | 2021-01-15 | Marion | Iowa | 19125 | 3004 | 52 |
931124 | 931124 | 2021-01-15 | Marion | Kansas | 20115 | 847 | 5 |
931248 | 931248 | 2021-01-15 | Marion | Kentucky | 21155 | 1729 | 20 |
931633 | 931633 | 2021-01-15 | Marion | Mississippi | 28091 | 2061 | 71 |
931734 | 931734 | 2021-01-15 | Marion | Missouri | 29127 | 2503 | 32 |
932283 | 932283 | 2021-01-15 | Marion | Ohio | 39101 | 7266 | 112 |
932422 | 932422 | 2021-01-15 | Marion | Oregon | 41047 | 15972 | 233 |
932619 | 932619 | 2021-01-15 | Marion | South Carolina | 45067 | 2522 | 80 |
932754 | 932754 | 2021-01-15 | Marion | Tennessee | 47115 | 2227 | 31 |
932949 | 932949 | 2021-01-15 | Marion | Texas | 48315 | 354 | 19 |
933292 | 933292 | 2021-01-15 | Marion | West Virginia | 54049 | 2714 | 23 |
926975 | 926975 | 2021-01-14 | Marion | Alabama | 1093 | 2386 | 49 |
927083 | 927083 | 2021-01-14 | Marion | Arkansas | 5089 | 770 | 25 |
927291 | 927291 | 2021-01-14 | Marion | Florida | 12083 | 21414 | 525 |
927414 | 927414 | 2021-01-14 | Marion | Georgia | 13197 | 393 | 10 |
927586 | 927586 | 2021-01-14 | Marion | Illinois | 17121 | 3896 | 111 |
927679 | 927679 | 2021-01-14 | Marion | Indiana | 18097 | 80078 | 1345 |
927785 | 927785 | 2021-01-14 | Marion | Iowa | 19125 | 2988 | 52 |
927879 | 927879 | 2021-01-14 | Marion | Kansas | 20115 | 839 | 5 |
928003 | 928003 | 2021-01-14 | Marion | Kentucky | 21155 | 1719 | 20 |
928388 | 928388 | 2021-01-14 | Marion | Mississippi | 28091 | 2033 | 71 |
928489 | 928489 | 2021-01-14 | Marion | Missouri | 29127 | 2494 | 32 |
929038 | 929038 | 2021-01-14 | Marion | Ohio | 39101 | 7231 | 112 |
929177 | 929177 | 2021-01-14 | Marion | Oregon | 41047 | 15878 | 233 |
929374 | 929374 | 2021-01-14 | Marion | South Carolina | 45067 | 2483 | 79 |
929509 | 929509 | 2021-01-14 | Marion | Tennessee | 47115 | 2200 | 31 |
929704 | 929704 | 2021-01-14 | Marion | Texas | 48315 | 348 | 19 |
930047 | 930047 | 2021-01-14 | Marion | West Virginia | 54049 | 2640 | 21 |
923729 | 923729 | 2021-01-13 | Marion | Alabama | 1093 | 2372 | 49 |
923837 | 923837 | 2021-01-13 | Marion | Arkansas | 5089 | 762 | 25 |
924045 | 924045 | 2021-01-13 | Marion | Florida | 12083 | 21210 | 520 |
924168 | 924168 | 2021-01-13 | Marion | Georgia | 13197 | 384 | 10 |
924340 | 924340 | 2021-01-13 | Marion | Illinois | 17121 | 3886 | 111 |
924433 | 924433 | 2021-01-13 | Marion | Indiana | 18097 | 79548 | 1334 |
924539 | 924539 | 2021-01-13 | Marion | Iowa | 19125 | 2966 | 52 |
924633 | 924633 | 2021-01-13 | Marion | Kansas | 20115 | 839 | 5 |
924757 | 924757 | 2021-01-13 | Marion | Kentucky | 21155 | 1706 | 20 |
925142 | 925142 | 2021-01-13 | Marion | Mississippi | 28091 | 2007 | 71 |
925243 | 925243 | 2021-01-13 | Marion | Missouri | 29127 | 2488 | 32 |
925793 | 925793 | 2021-01-13 | Marion | Ohio | 39101 | 7202 | 111 |
925932 | 925932 | 2021-01-13 | Marion | Oregon | 41047 | 15740 | 233 |
926129 | 926129 | 2021-01-13 | Marion | South Carolina | 45067 | 2437 | 79 |
926264 | 926264 | 2021-01-13 | Marion | Tennessee | 47115 | 2186 | 31 |
926459 | 926459 | 2021-01-13 | Marion | Texas | 48315 | 345 | 19 |
926802 | 926802 | 2021-01-13 | Marion | West Virginia | 54049 | 2612 | 20 |
920484 | 920484 | 2021-01-12 | Marion | Alabama | 1093 | 2358 | 47 |
920592 | 920592 | 2021-01-12 | Marion | Arkansas | 5089 | 750 | 24 |
920800 | 920800 | 2021-01-12 | Marion | Florida | 12083 | 20978 | 516 |
920923 | 920923 | 2021-01-12 | Marion | Georgia | 13197 | 362 | 10 |
921095 | 921095 | 2021-01-12 | Marion | Illinois | 17121 | 3857 | 111 |
921188 | 921188 | 2021-01-12 | Marion | Indiana | 18097 | 79099 | 1329 |
921294 | 921294 | 2021-01-12 | Marion | Iowa | 19125 | 2951 | 52 |
921388 | 921388 | 2021-01-12 | Marion | Kansas | 20115 | 795 | 5 |
921512 | 921512 | 2021-01-12 | Marion | Kentucky | 21155 | 1692 | 20 |
921897 | 921897 | 2021-01-12 | Marion | Mississippi | 28091 | 1991 | 71 |
921998 | 921998 | 2021-01-12 | Marion | Missouri | 29127 | 2482 | 32 |
922547 | 922547 | 2021-01-12 | Marion | Ohio | 39101 | 7161 | 111 |
922686 | 922686 | 2021-01-12 | Marion | Oregon | 41047 | 15643 | 231 |
922883 | 922883 | 2021-01-12 | Marion | South Carolina | 45067 | 2389 | 79 |
923018 | 923018 | 2021-01-12 | Marion | Tennessee | 47115 | 2160 | 31 |
923213 | 923213 | 2021-01-12 | Marion | Texas | 48315 | 338 | 19 |
923556 | 923556 | 2021-01-12 | Marion | West Virginia | 54049 | 2580 | 19 |
917239 | 917239 | 2021-01-11 | Marion | Alabama | 1093 | 2335 | 46 |
917347 | 917347 | 2021-01-11 | Marion | Arkansas | 5089 | 739 | 24 |
917555 | 917555 | 2021-01-11 | Marion | Florida | 12083 | 20694 | 508 |
917678 | 917678 | 2021-01-11 | Marion | Georgia | 13197 | 354 | 10 |
917850 | 917850 | 2021-01-11 | Marion | Illinois | 17121 | 3843 | 110 |
917943 | 917943 | 2021-01-11 | Marion | Indiana | 18097 | 78630 | 1312 |
918049 | 918049 | 2021-01-11 | Marion | Iowa | 19125 | 2934 | 51 |
918143 | 918143 | 2021-01-11 | Marion | Kansas | 20115 | 793 | 5 |
918267 | 918267 | 2021-01-11 | Marion | Kentucky | 21155 | 1686 | 20 |
918652 | 918652 | 2021-01-11 | Marion | Mississippi | 28091 | 1988 | 69 |
918753 | 918753 | 2021-01-11 | Marion | Missouri | 29127 | 2472 | 30 |
919302 | 919302 | 2021-01-11 | Marion | Ohio | 39101 | 7121 | 111 |
919441 | 919441 | 2021-01-11 | Marion | Oregon | 41047 | 15550 | 222 |
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);