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 |
---|---|---|---|---|---|---|---|
1193155 | 1193155 | 2021-04-06 | Marion | Alabama | 1093 | 3063 | 101 |
1193263 | 1193263 | 2021-04-06 | Marion | Arkansas | 5089 | 1034 | 30 |
1193471 | 1193471 | 2021-04-06 | Marion | Florida | 12083 | 29327 | 927 |
1193594 | 1193594 | 2021-04-06 | Marion | Georgia | 13197 | 545 | 19 |
1193766 | 1193766 | 2021-04-06 | Marion | Illinois | 17121 | 4363 | 119 |
1193860 | 1193860 | 2021-04-06 | Marion | Indiana | 18097 | 94507 | 1763 |
1193966 | 1193966 | 2021-04-06 | Marion | Iowa | 19125 | 3528 | 75 |
1194060 | 1194060 | 2021-04-06 | Marion | Kansas | 20115 | 1048 | 24 |
1194184 | 1194184 | 2021-04-06 | Marion | Kentucky | 21155 | 2214 | 36 |
1194568 | 1194568 | 2021-04-06 | Marion | Mississippi | 28091 | 2649 | 79 |
1194669 | 1194669 | 2021-04-06 | Marion | Missouri | 29127 | 3619 | 43 |
1195219 | 1195219 | 2021-04-06 | Marion | Ohio | 39101 | 8261 | 135 |
1195359 | 1195359 | 2021-04-06 | Marion | Oregon | 41047 | 19547 | 298 |
1195556 | 1195556 | 2021-04-06 | Marion | South Carolina | 45067 | 3447 | 101 |
1195691 | 1195691 | 2021-04-06 | Marion | Tennessee | 47115 | 3067 | 46 |
1195886 | 1195886 | 2021-04-06 | Marion | Texas | 48315 | 526 | 33 |
1196230 | 1196230 | 2021-04-06 | Marion | West Virginia | 54049 | 3993 | 48 |
1189905 | 1189905 | 2021-04-05 | Marion | Alabama | 1093 | 3066 | 101 |
1190013 | 1190013 | 2021-04-05 | Marion | Arkansas | 5089 | 1033 | 30 |
1190221 | 1190221 | 2021-04-05 | Marion | Florida | 12083 | 29294 | 925 |
1190344 | 1190344 | 2021-04-05 | Marion | Georgia | 13197 | 544 | 19 |
1190516 | 1190516 | 2021-04-05 | Marion | Illinois | 17121 | 4364 | 119 |
1190610 | 1190610 | 2021-04-05 | Marion | Indiana | 18097 | 94433 | 1763 |
1190716 | 1190716 | 2021-04-05 | Marion | Iowa | 19125 | 3523 | 75 |
1190810 | 1190810 | 2021-04-05 | Marion | Kansas | 20115 | 1048 | 24 |
1190934 | 1190934 | 2021-04-05 | Marion | Kentucky | 21155 | 2214 | 36 |
1191319 | 1191319 | 2021-04-05 | Marion | Mississippi | 28091 | 2648 | 79 |
1191420 | 1191420 | 2021-04-05 | Marion | Missouri | 29127 | 3615 | 43 |
1191971 | 1191971 | 2021-04-05 | Marion | Ohio | 39101 | 8257 | 135 |
1192111 | 1192111 | 2021-04-05 | Marion | Oregon | 41047 | 19510 | 297 |
1192308 | 1192308 | 2021-04-05 | Marion | South Carolina | 45067 | 3440 | 101 |
1192443 | 1192443 | 2021-04-05 | Marion | Tennessee | 47115 | 3065 | 46 |
1192638 | 1192638 | 2021-04-05 | Marion | Texas | 48315 | 526 | 33 |
1192982 | 1192982 | 2021-04-05 | Marion | West Virginia | 54049 | 3985 | 48 |
1186658 | 1186658 | 2021-04-04 | Marion | Alabama | 1093 | 3066 | 101 |
1186766 | 1186766 | 2021-04-04 | Marion | Arkansas | 5089 | 1033 | 30 |
1186974 | 1186974 | 2021-04-04 | Marion | Florida | 12083 | 29260 | 926 |
1187097 | 1187097 | 2021-04-04 | Marion | Georgia | 13197 | 544 | 19 |
1187269 | 1187269 | 2021-04-04 | Marion | Illinois | 17121 | 4364 | 119 |
1187363 | 1187363 | 2021-04-04 | Marion | Indiana | 18097 | 94311 | 1763 |
1187469 | 1187469 | 2021-04-04 | Marion | Iowa | 19125 | 3519 | 75 |
1187563 | 1187563 | 2021-04-04 | Marion | Kansas | 20115 | 1046 | 24 |
1187687 | 1187687 | 2021-04-04 | Marion | Kentucky | 21155 | 2214 | 36 |
1188071 | 1188071 | 2021-04-04 | Marion | Mississippi | 28091 | 2648 | 79 |
1188172 | 1188172 | 2021-04-04 | Marion | Missouri | 29127 | 3614 | 43 |
1188722 | 1188722 | 2021-04-04 | Marion | Ohio | 39101 | 8249 | 135 |
1188862 | 1188862 | 2021-04-04 | Marion | Oregon | 41047 | 19481 | 297 |
1189059 | 1189059 | 2021-04-04 | Marion | South Carolina | 45067 | 3435 | 101 |
1189194 | 1189194 | 2021-04-04 | Marion | Tennessee | 47115 | 3057 | 46 |
1189389 | 1189389 | 2021-04-04 | Marion | Texas | 48315 | 526 | 33 |
1189732 | 1189732 | 2021-04-04 | Marion | West Virginia | 54049 | 3976 | 48 |
1183411 | 1183411 | 2021-04-03 | Marion | Alabama | 1093 | 3065 | 101 |
1183519 | 1183519 | 2021-04-03 | Marion | Arkansas | 5089 | 1033 | 30 |
1183727 | 1183727 | 2021-04-03 | Marion | Florida | 12083 | 29225 | 926 |
1183850 | 1183850 | 2021-04-03 | Marion | Georgia | 13197 | 544 | 19 |
1184022 | 1184022 | 2021-04-03 | Marion | Illinois | 17121 | 4364 | 119 |
1184116 | 1184116 | 2021-04-03 | Marion | Indiana | 18097 | 94165 | 1763 |
1184222 | 1184222 | 2021-04-03 | Marion | Iowa | 19125 | 3519 | 75 |
1184316 | 1184316 | 2021-04-03 | Marion | Kansas | 20115 | 1046 | 24 |
1184440 | 1184440 | 2021-04-03 | Marion | Kentucky | 21155 | 2214 | 36 |
1184824 | 1184824 | 2021-04-03 | Marion | Mississippi | 28091 | 2648 | 79 |
1184925 | 1184925 | 2021-04-03 | Marion | Missouri | 29127 | 3612 | 43 |
1185475 | 1185475 | 2021-04-03 | Marion | Ohio | 39101 | 8249 | 135 |
1185615 | 1185615 | 2021-04-03 | Marion | Oregon | 41047 | 19453 | 297 |
1185812 | 1185812 | 2021-04-03 | Marion | South Carolina | 45067 | 3435 | 101 |
1185947 | 1185947 | 2021-04-03 | Marion | Tennessee | 47115 | 3057 | 46 |
1186142 | 1186142 | 2021-04-03 | Marion | Texas | 48315 | 526 | 33 |
1186485 | 1186485 | 2021-04-03 | Marion | West Virginia | 54049 | 3964 | 48 |
1180164 | 1180164 | 2021-04-02 | Marion | Alabama | 1093 | 3064 | 101 |
1180272 | 1180272 | 2021-04-02 | Marion | Arkansas | 5089 | 1033 | 30 |
1180480 | 1180480 | 2021-04-02 | Marion | Florida | 12083 | 29169 | 923 |
1180603 | 1180603 | 2021-04-02 | Marion | Georgia | 13197 | 544 | 19 |
1180775 | 1180775 | 2021-04-02 | Marion | Illinois | 17121 | 4364 | 119 |
1180869 | 1180869 | 2021-04-02 | Marion | Indiana | 18097 | 94013 | 1763 |
1180975 | 1180975 | 2021-04-02 | Marion | Iowa | 19125 | 3514 | 75 |
1181069 | 1181069 | 2021-04-02 | Marion | Kansas | 20115 | 1046 | 24 |
1181193 | 1181193 | 2021-04-02 | Marion | Kentucky | 21155 | 2213 | 36 |
1181578 | 1181578 | 2021-04-02 | Marion | Mississippi | 28091 | 2643 | 79 |
1181679 | 1181679 | 2021-04-02 | Marion | Missouri | 29127 | 3609 | 43 |
1182228 | 1182228 | 2021-04-02 | Marion | Ohio | 39101 | 8241 | 135 |
1182368 | 1182368 | 2021-04-02 | Marion | Oregon | 41047 | 19417 | 297 |
1182565 | 1182565 | 2021-04-02 | Marion | South Carolina | 45067 | 3428 | 101 |
1182700 | 1182700 | 2021-04-02 | Marion | Tennessee | 47115 | 3057 | 46 |
1182895 | 1182895 | 2021-04-02 | Marion | Texas | 48315 | 525 | 33 |
1183238 | 1183238 | 2021-04-02 | Marion | West Virginia | 54049 | 3953 | 48 |
1176917 | 1176917 | 2021-04-01 | Marion | Alabama | 1093 | 3063 | 99 |
1177025 | 1177025 | 2021-04-01 | Marion | Arkansas | 5089 | 1032 | 30 |
1177233 | 1177233 | 2021-04-01 | Marion | Florida | 12083 | 29105 | 920 |
1177356 | 1177356 | 2021-04-01 | Marion | Georgia | 13197 | 544 | 19 |
1177528 | 1177528 | 2021-04-01 | Marion | Illinois | 17121 | 4365 | 120 |
1177622 | 1177622 | 2021-04-01 | Marion | Indiana | 18097 | 93884 | 1761 |
1177728 | 1177728 | 2021-04-01 | Marion | Iowa | 19125 | 3511 | 75 |
1177822 | 1177822 | 2021-04-01 | Marion | Kansas | 20115 | 1045 | 24 |
1177946 | 1177946 | 2021-04-01 | Marion | Kentucky | 21155 | 2210 | 35 |
1178331 | 1178331 | 2021-04-01 | Marion | Mississippi | 28091 | 2643 | 79 |
1178432 | 1178432 | 2021-04-01 | Marion | Missouri | 29127 | 3605 | 43 |
1178981 | 1178981 | 2021-04-01 | Marion | Ohio | 39101 | 8233 | 135 |
1179121 | 1179121 | 2021-04-01 | Marion | Oregon | 41047 | 19379 | 297 |
1179318 | 1179318 | 2021-04-01 | Marion | South Carolina | 45067 | 3423 | 101 |
1179453 | 1179453 | 2021-04-01 | Marion | Tennessee | 47115 | 3057 | 46 |
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);