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 |
---|---|---|---|---|---|---|---|
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 |
919638 | 919638 | 2021-01-11 | Marion | South Carolina | 45067 | 2369 | 75 |
919773 | 919773 | 2021-01-11 | Marion | Tennessee | 47115 | 2144 | 28 |
919968 | 919968 | 2021-01-11 | Marion | Texas | 48315 | 321 | 19 |
920311 | 920311 | 2021-01-11 | Marion | West Virginia | 54049 | 2546 | 17 |
913994 | 913994 | 2021-01-10 | Marion | Alabama | 1093 | 2320 | 46 |
914102 | 914102 | 2021-01-10 | Marion | Arkansas | 5089 | 738 | 24 |
914310 | 914310 | 2021-01-10 | Marion | Florida | 12083 | 20537 | 504 |
914433 | 914433 | 2021-01-10 | Marion | Georgia | 13197 | 349 | 10 |
914605 | 914605 | 2021-01-10 | Marion | Illinois | 17121 | 3829 | 111 |
914698 | 914698 | 2021-01-10 | Marion | Indiana | 18097 | 78078 | 1306 |
914804 | 914804 | 2021-01-10 | Marion | Iowa | 19125 | 2912 | 51 |
914898 | 914898 | 2021-01-10 | Marion | Kansas | 20115 | 778 | 5 |
915022 | 915022 | 2021-01-10 | Marion | Kentucky | 21155 | 1674 | 20 |
915407 | 915407 | 2021-01-10 | Marion | Mississippi | 28091 | 1970 | 69 |
915508 | 915508 | 2021-01-10 | Marion | Missouri | 29127 | 2464 | 30 |
916057 | 916057 | 2021-01-10 | Marion | Ohio | 39101 | 7080 | 111 |
916196 | 916196 | 2021-01-10 | Marion | Oregon | 41047 | 15440 | 223 |
916393 | 916393 | 2021-01-10 | Marion | South Carolina | 45067 | 2330 | 75 |
916528 | 916528 | 2021-01-10 | Marion | Tennessee | 47115 | 2120 | 27 |
916723 | 916723 | 2021-01-10 | Marion | Texas | 48315 | 316 | 19 |
917066 | 917066 | 2021-01-10 | Marion | West Virginia | 54049 | 2492 | 17 |
910749 | 910749 | 2021-01-09 | Marion | Alabama | 1093 | 2304 | 46 |
910857 | 910857 | 2021-01-09 | Marion | Arkansas | 5089 | 727 | 24 |
911065 | 911065 | 2021-01-09 | Marion | Florida | 12083 | 20317 | 498 |
911188 | 911188 | 2021-01-09 | Marion | Georgia | 13197 | 347 | 10 |
911360 | 911360 | 2021-01-09 | Marion | Illinois | 17121 | 3766 | 111 |
911453 | 911453 | 2021-01-09 | Marion | Indiana | 18097 | 77458 | 1302 |
911559 | 911559 | 2021-01-09 | Marion | Iowa | 19125 | 2907 | 51 |
911653 | 911653 | 2021-01-09 | Marion | Kansas | 20115 | 778 | 5 |
911777 | 911777 | 2021-01-09 | Marion | Kentucky | 21155 | 1665 | 20 |
912162 | 912162 | 2021-01-09 | Marion | Mississippi | 28091 | 1948 | 69 |
912263 | 912263 | 2021-01-09 | Marion | Missouri | 29127 | 2451 | 30 |
912812 | 912812 | 2021-01-09 | Marion | Ohio | 39101 | 7056 | 111 |
912951 | 912951 | 2021-01-09 | Marion | Oregon | 41047 | 15211 | 223 |
913148 | 913148 | 2021-01-09 | Marion | South Carolina | 45067 | 2310 | 75 |
913283 | 913283 | 2021-01-09 | Marion | Tennessee | 47115 | 2092 | 26 |
913478 | 913478 | 2021-01-09 | Marion | Texas | 48315 | 309 | 19 |
913821 | 913821 | 2021-01-09 | Marion | West Virginia | 54049 | 2420 | 16 |
907504 | 907504 | 2021-01-08 | Marion | Alabama | 1093 | 2281 | 46 |
907612 | 907612 | 2021-01-08 | Marion | Arkansas | 5089 | 719 | 24 |
907820 | 907820 | 2021-01-08 | Marion | Florida | 12083 | 20040 | 498 |
907943 | 907943 | 2021-01-08 | Marion | Georgia | 13197 | 336 | 10 |
908115 | 908115 | 2021-01-08 | Marion | Illinois | 17121 | 3746 | 111 |
908208 | 908208 | 2021-01-08 | Marion | Indiana | 18097 | 76554 | 1292 |
908314 | 908314 | 2021-01-08 | Marion | Iowa | 19125 | 2898 | 51 |
908408 | 908408 | 2021-01-08 | Marion | Kansas | 20115 | 778 | 5 |
908532 | 908532 | 2021-01-08 | Marion | Kentucky | 21155 | 1638 | 20 |
908917 | 908917 | 2021-01-08 | Marion | Mississippi | 28091 | 1918 | 68 |
909018 | 909018 | 2021-01-08 | Marion | Missouri | 29127 | 2433 | 30 |
909567 | 909567 | 2021-01-08 | Marion | Ohio | 39101 | 7018 | 111 |
909706 | 909706 | 2021-01-08 | Marion | Oregon | 41047 | 15103 | 220 |
909903 | 909903 | 2021-01-08 | Marion | South Carolina | 45067 | 2234 | 73 |
910038 | 910038 | 2021-01-08 | Marion | Tennessee | 47115 | 2071 | 26 |
910233 | 910233 | 2021-01-08 | Marion | Texas | 48315 | 305 | 18 |
910576 | 910576 | 2021-01-08 | Marion | West Virginia | 54049 | 2331 | 16 |
904258 | 904258 | 2021-01-07 | Marion | Alabama | 1093 | 2248 | 46 |
904366 | 904366 | 2021-01-07 | Marion | Arkansas | 5089 | 707 | 24 |
904574 | 904574 | 2021-01-07 | Marion | Florida | 12083 | 19585 | 496 |
904697 | 904697 | 2021-01-07 | Marion | Georgia | 13197 | 331 | 10 |
904869 | 904869 | 2021-01-07 | Marion | Illinois | 17121 | 3702 | 109 |
904962 | 904962 | 2021-01-07 | Marion | Indiana | 18097 | 75694 | 1281 |
905068 | 905068 | 2021-01-07 | Marion | Iowa | 19125 | 2887 | 50 |
905162 | 905162 | 2021-01-07 | Marion | Kansas | 20115 | 759 | 5 |
905286 | 905286 | 2021-01-07 | Marion | Kentucky | 21155 | 1624 | 20 |
905671 | 905671 | 2021-01-07 | Marion | Mississippi | 28091 | 1880 | 68 |
905772 | 905772 | 2021-01-07 | Marion | Missouri | 29127 | 2422 | 30 |
906322 | 906322 | 2021-01-07 | Marion | Ohio | 39101 | 6983 | 110 |
906461 | 906461 | 2021-01-07 | Marion | Oregon | 41047 | 14927 | 219 |
906658 | 906658 | 2021-01-07 | Marion | South Carolina | 45067 | 2182 | 70 |
906793 | 906793 | 2021-01-07 | Marion | Tennessee | 47115 | 2039 | 26 |
906988 | 906988 | 2021-01-07 | Marion | Texas | 48315 | 303 | 18 |
907331 | 907331 | 2021-01-07 | Marion | West Virginia | 54049 | 2252 | 16 |
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);