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 |
---|---|---|---|---|---|---|---|
1082246 | 1082246 | 2021-03-02 | Marion | Texas | 48315 | 520 | 27 |
1082589 | 1082589 | 2021-03-02 | Marion | West Virginia | 54049 | 3682 | 33 |
1076271 | 1076271 | 2021-03-01 | Marion | Alabama | 1093 | 2819 | 95 |
1076379 | 1076379 | 2021-03-01 | Marion | Arkansas | 5089 | 961 | 29 |
1076587 | 1076587 | 2021-03-01 | Marion | Florida | 12083 | 27663 | 803 |
1076710 | 1076710 | 2021-03-01 | Marion | Georgia | 13197 | 533 | 15 |
1076882 | 1076882 | 2021-03-01 | Marion | Illinois | 17121 | 4262 | 117 |
1076976 | 1076976 | 2021-03-01 | Marion | Indiana | 18097 | 90913 | 1714 |
1077082 | 1077082 | 2021-03-01 | Marion | Iowa | 19125 | 3389 | 69 |
1077176 | 1077176 | 2021-03-01 | Marion | Kansas | 20115 | 1024 | 23 |
1077300 | 1077300 | 2021-03-01 | Marion | Kentucky | 21155 | 2148 | 24 |
1077684 | 1077684 | 2021-03-01 | Marion | Mississippi | 28091 | 2526 | 78 |
1077785 | 1077785 | 2021-03-01 | Marion | Missouri | 29127 | 2646 | 41 |
1078334 | 1078334 | 2021-03-01 | Marion | Ohio | 39101 | 7982 | 137 |
1078473 | 1078473 | 2021-03-01 | Marion | Oregon | 41047 | 18486 | 285 |
1078670 | 1078670 | 2021-03-01 | Marion | South Carolina | 45067 | 3249 | 98 |
1078805 | 1078805 | 2021-03-01 | Marion | Tennessee | 47115 | 2940 | 44 |
1079000 | 1079000 | 2021-03-01 | Marion | Texas | 48315 | 520 | 27 |
1079343 | 1079343 | 2021-03-01 | Marion | West Virginia | 54049 | 3676 | 33 |
1073025 | 1073025 | 2021-02-28 | Marion | Alabama | 1093 | 2818 | 95 |
1073133 | 1073133 | 2021-02-28 | Marion | Arkansas | 5089 | 961 | 29 |
1073341 | 1073341 | 2021-02-28 | Marion | Florida | 12083 | 27628 | 791 |
1073464 | 1073464 | 2021-02-28 | Marion | Georgia | 13197 | 533 | 15 |
1073636 | 1073636 | 2021-02-28 | Marion | Illinois | 17121 | 4262 | 117 |
1073730 | 1073730 | 2021-02-28 | Marion | Indiana | 18097 | 90846 | 1708 |
1073836 | 1073836 | 2021-02-28 | Marion | Iowa | 19125 | 3379 | 69 |
1073930 | 1073930 | 2021-02-28 | Marion | Kansas | 20115 | 1021 | 23 |
1074054 | 1074054 | 2021-02-28 | Marion | Kentucky | 21155 | 2146 | 24 |
1074438 | 1074438 | 2021-02-28 | Marion | Mississippi | 28091 | 2525 | 78 |
1074539 | 1074539 | 2021-02-28 | Marion | Missouri | 29127 | 2646 | 41 |
1075089 | 1075089 | 2021-02-28 | Marion | Ohio | 39101 | 7979 | 137 |
1075228 | 1075228 | 2021-02-28 | Marion | Oregon | 41047 | 18468 | 285 |
1075425 | 1075425 | 2021-02-28 | Marion | South Carolina | 45067 | 3248 | 97 |
1075560 | 1075560 | 2021-02-28 | Marion | Tennessee | 47115 | 2936 | 44 |
1075755 | 1075755 | 2021-02-28 | Marion | Texas | 48315 | 519 | 27 |
1076098 | 1076098 | 2021-02-28 | Marion | West Virginia | 54049 | 3669 | 33 |
1069779 | 1069779 | 2021-02-27 | Marion | Alabama | 1093 | 2816 | 95 |
1069887 | 1069887 | 2021-02-27 | Marion | Arkansas | 5089 | 943 | 30 |
1070095 | 1070095 | 2021-02-27 | Marion | Florida | 12083 | 27572 | 784 |
1070218 | 1070218 | 2021-02-27 | Marion | Georgia | 13197 | 533 | 15 |
1070390 | 1070390 | 2021-02-27 | Marion | Illinois | 17121 | 4262 | 117 |
1070484 | 1070484 | 2021-02-27 | Marion | Indiana | 18097 | 90767 | 1707 |
1070590 | 1070590 | 2021-02-27 | Marion | Iowa | 19125 | 3379 | 69 |
1070684 | 1070684 | 2021-02-27 | Marion | Kansas | 20115 | 1021 | 23 |
1070808 | 1070808 | 2021-02-27 | Marion | Kentucky | 21155 | 2146 | 24 |
1071192 | 1071192 | 2021-02-27 | Marion | Mississippi | 28091 | 2519 | 78 |
1071293 | 1071293 | 2021-02-27 | Marion | Missouri | 29127 | 2646 | 41 |
1071843 | 1071843 | 2021-02-27 | Marion | Ohio | 39101 | 7973 | 137 |
1071982 | 1071982 | 2021-02-27 | Marion | Oregon | 41047 | 18416 | 285 |
1072179 | 1072179 | 2021-02-27 | Marion | South Carolina | 45067 | 3239 | 97 |
1072314 | 1072314 | 2021-02-27 | Marion | Tennessee | 47115 | 2928 | 44 |
1072509 | 1072509 | 2021-02-27 | Marion | Texas | 48315 | 517 | 27 |
1072852 | 1072852 | 2021-02-27 | Marion | West Virginia | 54049 | 3663 | 33 |
1066534 | 1066534 | 2021-02-26 | Marion | Alabama | 1093 | 2812 | 95 |
1066642 | 1066642 | 2021-02-26 | Marion | Arkansas | 5089 | 941 | 30 |
1066850 | 1066850 | 2021-02-26 | Marion | Florida | 12083 | 27485 | 782 |
1066973 | 1066973 | 2021-02-26 | Marion | Georgia | 13197 | 531 | 15 |
1067145 | 1067145 | 2021-02-26 | Marion | Illinois | 17121 | 4257 | 117 |
1067239 | 1067239 | 2021-02-26 | Marion | Indiana | 18097 | 90624 | 1703 |
1067345 | 1067345 | 2021-02-26 | Marion | Iowa | 19125 | 3379 | 69 |
1067439 | 1067439 | 2021-02-26 | Marion | Kansas | 20115 | 1021 | 23 |
1067563 | 1067563 | 2021-02-26 | Marion | Kentucky | 21155 | 2144 | 24 |
1067947 | 1067947 | 2021-02-26 | Marion | Mississippi | 28091 | 2515 | 78 |
1068048 | 1068048 | 2021-02-26 | Marion | Missouri | 29127 | 2645 | 41 |
1068597 | 1068597 | 2021-02-26 | Marion | Ohio | 39101 | 7963 | 137 |
1068736 | 1068736 | 2021-02-26 | Marion | Oregon | 41047 | 18373 | 285 |
1068933 | 1068933 | 2021-02-26 | Marion | South Carolina | 45067 | 3233 | 97 |
1069068 | 1069068 | 2021-02-26 | Marion | Tennessee | 47115 | 2916 | 42 |
1069263 | 1069263 | 2021-02-26 | Marion | Texas | 48315 | 515 | 27 |
1069606 | 1069606 | 2021-02-26 | Marion | West Virginia | 54049 | 3655 | 33 |
1063289 | 1063289 | 2021-02-25 | Marion | Alabama | 1093 | 2808 | 94 |
1063397 | 1063397 | 2021-02-25 | Marion | Arkansas | 5089 | 938 | 30 |
1063605 | 1063605 | 2021-02-25 | Marion | Florida | 12083 | 27382 | 780 |
1063728 | 1063728 | 2021-02-25 | Marion | Georgia | 13197 | 530 | 15 |
1063900 | 1063900 | 2021-02-25 | Marion | Illinois | 17121 | 4255 | 117 |
1063994 | 1063994 | 2021-02-25 | Marion | Indiana | 18097 | 90535 | 1698 |
1064100 | 1064100 | 2021-02-25 | Marion | Iowa | 19125 | 3374 | 69 |
1064194 | 1064194 | 2021-02-25 | Marion | Kansas | 20115 | 1018 | 23 |
1064318 | 1064318 | 2021-02-25 | Marion | Kentucky | 21155 | 2142 | 24 |
1064702 | 1064702 | 2021-02-25 | Marion | Mississippi | 28091 | 2507 | 78 |
1064803 | 1064803 | 2021-02-25 | Marion | Missouri | 29127 | 2644 | 41 |
1065352 | 1065352 | 2021-02-25 | Marion | Ohio | 39101 | 7954 | 137 |
1065491 | 1065491 | 2021-02-25 | Marion | Oregon | 41047 | 18335 | 285 |
1065688 | 1065688 | 2021-02-25 | Marion | South Carolina | 45067 | 3229 | 96 |
1065823 | 1065823 | 2021-02-25 | Marion | Tennessee | 47115 | 2909 | 42 |
1066018 | 1066018 | 2021-02-25 | Marion | Texas | 48315 | 514 | 27 |
1066361 | 1066361 | 2021-02-25 | Marion | West Virginia | 54049 | 3642 | 33 |
1060044 | 1060044 | 2021-02-24 | Marion | Alabama | 1093 | 2807 | 93 |
1060152 | 1060152 | 2021-02-24 | Marion | Arkansas | 5089 | 933 | 30 |
1060360 | 1060360 | 2021-02-24 | Marion | Florida | 12083 | 27301 | 778 |
1060483 | 1060483 | 2021-02-24 | Marion | Georgia | 13197 | 523 | 15 |
1060655 | 1060655 | 2021-02-24 | Marion | Illinois | 17121 | 4253 | 117 |
1060749 | 1060749 | 2021-02-24 | Marion | Indiana | 18097 | 90430 | 1698 |
1060855 | 1060855 | 2021-02-24 | Marion | Iowa | 19125 | 3346 | 69 |
1060949 | 1060949 | 2021-02-24 | Marion | Kansas | 20115 | 1018 | 19 |
1061073 | 1061073 | 2021-02-24 | Marion | Kentucky | 21155 | 2138 | 24 |
1061458 | 1061458 | 2021-02-24 | Marion | Mississippi | 28091 | 2498 | 78 |
1061559 | 1061559 | 2021-02-24 | Marion | Missouri | 29127 | 2642 | 41 |
1062108 | 1062108 | 2021-02-24 | Marion | Ohio | 39101 | 7944 | 135 |
1062246 | 1062246 | 2021-02-24 | Marion | Oregon | 41047 | 18279 | 284 |
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);