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 |
---|---|---|---|---|---|---|---|
1179648 | 1179648 | 2021-04-01 | Marion | Texas | 48315 | 525 | 33 |
1179991 | 1179991 | 2021-04-01 | Marion | West Virginia | 54049 | 3941 | 48 |
1173670 | 1173670 | 2021-03-31 | Marion | Alabama | 1093 | 3062 | 99 |
1173778 | 1173778 | 2021-03-31 | Marion | Arkansas | 5089 | 1032 | 30 |
1173986 | 1173986 | 2021-03-31 | Marion | Florida | 12083 | 29044 | 919 |
1174109 | 1174109 | 2021-03-31 | Marion | Georgia | 13197 | 544 | 19 |
1174281 | 1174281 | 2021-03-31 | Marion | Illinois | 17121 | 4364 | 120 |
1174375 | 1174375 | 2021-03-31 | Marion | Indiana | 18097 | 93789 | 1758 |
1174481 | 1174481 | 2021-03-31 | Marion | Iowa | 19125 | 3509 | 74 |
1174575 | 1174575 | 2021-03-31 | Marion | Kansas | 20115 | 1045 | 24 |
1174699 | 1174699 | 2021-03-31 | Marion | Kentucky | 21155 | 2210 | 35 |
1175084 | 1175084 | 2021-03-31 | Marion | Mississippi | 28091 | 2640 | 79 |
1175185 | 1175185 | 2021-03-31 | Marion | Missouri | 29127 | 3603 | 43 |
1175734 | 1175734 | 2021-03-31 | Marion | Ohio | 39101 | 8225 | 135 |
1175874 | 1175874 | 2021-03-31 | Marion | Oregon | 41047 | 19341 | 297 |
1176071 | 1176071 | 2021-03-31 | Marion | South Carolina | 45067 | 3423 | 101 |
1176206 | 1176206 | 2021-03-31 | Marion | Tennessee | 47115 | 3051 | 46 |
1176401 | 1176401 | 2021-03-31 | Marion | Texas | 48315 | 525 | 33 |
1176744 | 1176744 | 2021-03-31 | Marion | West Virginia | 54049 | 3934 | 48 |
1170423 | 1170423 | 2021-03-30 | Marion | Alabama | 1093 | 3056 | 99 |
1170531 | 1170531 | 2021-03-30 | Marion | Arkansas | 5089 | 1031 | 30 |
1170739 | 1170739 | 2021-03-30 | Marion | Florida | 12083 | 28996 | 918 |
1170862 | 1170862 | 2021-03-30 | Marion | Georgia | 13197 | 544 | 19 |
1171034 | 1171034 | 2021-03-30 | Marion | Illinois | 17121 | 4359 | 120 |
1171128 | 1171128 | 2021-03-30 | Marion | Indiana | 18097 | 93673 | 1759 |
1171234 | 1171234 | 2021-03-30 | Marion | Iowa | 19125 | 3507 | 74 |
1171328 | 1171328 | 2021-03-30 | Marion | Kansas | 20115 | 1045 | 24 |
1171452 | 1171452 | 2021-03-30 | Marion | Kentucky | 21155 | 2210 | 35 |
1171837 | 1171837 | 2021-03-30 | Marion | Mississippi | 28091 | 2640 | 78 |
1171938 | 1171938 | 2021-03-30 | Marion | Missouri | 29127 | 3599 | 43 |
1172487 | 1172487 | 2021-03-30 | Marion | Ohio | 39101 | 8215 | 135 |
1172627 | 1172627 | 2021-03-30 | Marion | Oregon | 41047 | 19315 | 297 |
1172824 | 1172824 | 2021-03-30 | Marion | South Carolina | 45067 | 3423 | 101 |
1172959 | 1172959 | 2021-03-30 | Marion | Tennessee | 47115 | 3049 | 46 |
1173154 | 1173154 | 2021-03-30 | Marion | Texas | 48315 | 525 | 33 |
1173497 | 1173497 | 2021-03-30 | Marion | West Virginia | 54049 | 3924 | 48 |
1167175 | 1167175 | 2021-03-29 | Marion | Alabama | 1093 | 3050 | 99 |
1167283 | 1167283 | 2021-03-29 | Marion | Arkansas | 5089 | 1031 | 30 |
1167491 | 1167491 | 2021-03-29 | Marion | Florida | 12083 | 28951 | 916 |
1167614 | 1167614 | 2021-03-29 | Marion | Georgia | 13197 | 544 | 19 |
1167786 | 1167786 | 2021-03-29 | Marion | Illinois | 17121 | 4355 | 120 |
1167880 | 1167880 | 2021-03-29 | Marion | Indiana | 18097 | 93584 | 1757 |
1167986 | 1167986 | 2021-03-29 | Marion | Iowa | 19125 | 3503 | 74 |
1168080 | 1168080 | 2021-03-29 | Marion | Kansas | 20115 | 1045 | 24 |
1168204 | 1168204 | 2021-03-29 | Marion | Kentucky | 21155 | 2211 | 35 |
1168589 | 1168589 | 2021-03-29 | Marion | Mississippi | 28091 | 2639 | 78 |
1168690 | 1168690 | 2021-03-29 | Marion | Missouri | 29127 | 3596 | 42 |
1169240 | 1169240 | 2021-03-29 | Marion | Ohio | 39101 | 8198 | 133 |
1169380 | 1169380 | 2021-03-29 | Marion | Oregon | 41047 | 19298 | 296 |
1169577 | 1169577 | 2021-03-29 | Marion | South Carolina | 45067 | 3417 | 101 |
1169712 | 1169712 | 2021-03-29 | Marion | Tennessee | 47115 | 3047 | 46 |
1169907 | 1169907 | 2021-03-29 | Marion | Texas | 48315 | 525 | 33 |
1170250 | 1170250 | 2021-03-29 | Marion | West Virginia | 54049 | 3914 | 48 |
1163927 | 1163927 | 2021-03-28 | Marion | Alabama | 1093 | 3050 | 99 |
1164035 | 1164035 | 2021-03-28 | Marion | Arkansas | 5089 | 1027 | 30 |
1164243 | 1164243 | 2021-03-28 | Marion | Florida | 12083 | 28926 | 916 |
1164366 | 1164366 | 2021-03-28 | Marion | Georgia | 13197 | 544 | 19 |
1164538 | 1164538 | 2021-03-28 | Marion | Illinois | 17121 | 4354 | 120 |
1164632 | 1164632 | 2021-03-28 | Marion | Indiana | 18097 | 93491 | 1757 |
1164738 | 1164738 | 2021-03-28 | Marion | Iowa | 19125 | 3499 | 74 |
1164832 | 1164832 | 2021-03-28 | Marion | Kansas | 20115 | 1045 | 24 |
1164956 | 1164956 | 2021-03-28 | Marion | Kentucky | 21155 | 2210 | 35 |
1165341 | 1165341 | 2021-03-28 | Marion | Mississippi | 28091 | 2638 | 78 |
1165442 | 1165442 | 2021-03-28 | Marion | Missouri | 29127 | 3596 | 42 |
1165992 | 1165992 | 2021-03-28 | Marion | Ohio | 39101 | 8190 | 133 |
1166132 | 1166132 | 2021-03-28 | Marion | Oregon | 41047 | 19279 | 296 |
1166329 | 1166329 | 2021-03-28 | Marion | South Carolina | 45067 | 3411 | 101 |
1166464 | 1166464 | 2021-03-28 | Marion | Tennessee | 47115 | 3043 | 46 |
1166659 | 1166659 | 2021-03-28 | Marion | Texas | 48315 | 525 | 33 |
1167002 | 1167002 | 2021-03-28 | Marion | West Virginia | 54049 | 3896 | 48 |
1160679 | 1160679 | 2021-03-27 | Marion | Alabama | 1093 | 3049 | 99 |
1160787 | 1160787 | 2021-03-27 | Marion | Arkansas | 5089 | 1027 | 30 |
1160995 | 1160995 | 2021-03-27 | Marion | Florida | 12083 | 28889 | 916 |
1161118 | 1161118 | 2021-03-27 | Marion | Georgia | 13197 | 544 | 19 |
1161290 | 1161290 | 2021-03-27 | Marion | Illinois | 17121 | 4351 | 120 |
1161384 | 1161384 | 2021-03-27 | Marion | Indiana | 18097 | 93377 | 1757 |
1161490 | 1161490 | 2021-03-27 | Marion | Iowa | 19125 | 3498 | 74 |
1161584 | 1161584 | 2021-03-27 | Marion | Kansas | 20115 | 1045 | 24 |
1161708 | 1161708 | 2021-03-27 | Marion | Kentucky | 21155 | 2207 | 35 |
1162093 | 1162093 | 2021-03-27 | Marion | Mississippi | 28091 | 2638 | 78 |
1162194 | 1162194 | 2021-03-27 | Marion | Missouri | 29127 | 3595 | 42 |
1162744 | 1162744 | 2021-03-27 | Marion | Ohio | 39101 | 8190 | 133 |
1162884 | 1162884 | 2021-03-27 | Marion | Oregon | 41047 | 19263 | 296 |
1163081 | 1163081 | 2021-03-27 | Marion | South Carolina | 45067 | 3405 | 101 |
1163216 | 1163216 | 2021-03-27 | Marion | Tennessee | 47115 | 3043 | 46 |
1163411 | 1163411 | 2021-03-27 | Marion | Texas | 48315 | 525 | 33 |
1163754 | 1163754 | 2021-03-27 | Marion | West Virginia | 54049 | 3895 | 48 |
1157431 | 1157431 | 2021-03-26 | Marion | Alabama | 1093 | 3049 | 99 |
1157539 | 1157539 | 2021-03-26 | Marion | Arkansas | 5089 | 1027 | 30 |
1157747 | 1157747 | 2021-03-26 | Marion | Florida | 12083 | 28831 | 914 |
1157870 | 1157870 | 2021-03-26 | Marion | Georgia | 13197 | 544 | 19 |
1158042 | 1158042 | 2021-03-26 | Marion | Illinois | 17121 | 4347 | 120 |
1158136 | 1158136 | 2021-03-26 | Marion | Indiana | 18097 | 93229 | 1756 |
1158242 | 1158242 | 2021-03-26 | Marion | Iowa | 19125 | 3498 | 74 |
1158336 | 1158336 | 2021-03-26 | Marion | Kansas | 20115 | 1045 | 24 |
1158460 | 1158460 | 2021-03-26 | Marion | Kentucky | 21155 | 2204 | 35 |
1158845 | 1158845 | 2021-03-26 | Marion | Mississippi | 28091 | 2637 | 78 |
1158946 | 1158946 | 2021-03-26 | Marion | Missouri | 29127 | 3591 | 42 |
1159495 | 1159495 | 2021-03-26 | Marion | Ohio | 39101 | 8184 | 133 |
1159635 | 1159635 | 2021-03-26 | Marion | Oregon | 41047 | 19233 | 296 |
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);