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 |
---|---|---|---|---|---|---|---|
280834 | 280834 | 2020-06-28 | Marion | Alabama | 1093 | 194 | 12 |
280937 | 280937 | 2020-06-28 | Marion | Arkansas | 5089 | 4 | 0 |
281141 | 281141 | 2020-06-28 | Marion | Florida | 12083 | 631 | 10 |
281264 | 281264 | 2020-06-28 | Marion | Georgia | 13197 | 78 | 2 |
281430 | 281430 | 2020-06-28 | Marion | Illinois | 17121 | 65 | 0 |
281523 | 281523 | 2020-06-28 | Marion | Indiana | 18097 | 11358 | 724 |
281629 | 281629 | 2020-06-28 | Marion | Iowa | 19125 | 60 | 0 |
281718 | 281718 | 2020-06-28 | Marion | Kansas | 20115 | 10 | 1 |
281836 | 281836 | 2020-06-28 | Marion | Kentucky | 21155 | 49 | 0 |
282218 | 282218 | 2020-06-28 | Marion | Mississippi | 28091 | 228 | 11 |
282318 | 282318 | 2020-06-28 | Marion | Missouri | 29127 | 16 | 0 |
282825 | 282825 | 2020-06-28 | Marion | Ohio | 39101 | 2721 | 37 |
282960 | 282960 | 2020-06-28 | Marion | Oregon | 41047 | 1475 | 41 |
283156 | 283156 | 2020-06-28 | Marion | South Carolina | 45067 | 191 | 7 |
283284 | 283284 | 2020-06-28 | Marion | Tennessee | 47115 | 57 | 4 |
283472 | 283472 | 2020-06-28 | Marion | Texas | 48315 | 26 | 1 |
283807 | 283807 | 2020-06-28 | Marion | West Virginia | 54049 | 56 | 2 |
277686 | 277686 | 2020-06-27 | Marion | Alabama | 1093 | 193 | 12 |
277790 | 277790 | 2020-06-27 | Marion | Arkansas | 5089 | 4 | 0 |
277994 | 277994 | 2020-06-27 | Marion | Florida | 12083 | 598 | 10 |
278117 | 278117 | 2020-06-27 | Marion | Georgia | 13197 | 78 | 2 |
278282 | 278282 | 2020-06-27 | Marion | Illinois | 17121 | 65 | 0 |
278375 | 278375 | 2020-06-27 | Marion | Indiana | 18097 | 11304 | 724 |
278481 | 278481 | 2020-06-27 | Marion | Iowa | 19125 | 58 | 0 |
278570 | 278570 | 2020-06-27 | Marion | Kansas | 20115 | 10 | 1 |
278688 | 278688 | 2020-06-27 | Marion | Kentucky | 21155 | 49 | 0 |
279070 | 279070 | 2020-06-27 | Marion | Mississippi | 28091 | 225 | 11 |
279170 | 279170 | 2020-06-27 | Marion | Missouri | 29127 | 15 | 0 |
279679 | 279679 | 2020-06-27 | Marion | Ohio | 39101 | 2719 | 37 |
279814 | 279814 | 2020-06-27 | Marion | Oregon | 41047 | 1432 | 41 |
280010 | 280010 | 2020-06-27 | Marion | South Carolina | 45067 | 176 | 7 |
280138 | 280138 | 2020-06-27 | Marion | Tennessee | 47115 | 57 | 4 |
280326 | 280326 | 2020-06-27 | Marion | Texas | 48315 | 26 | 1 |
280661 | 280661 | 2020-06-27 | Marion | West Virginia | 54049 | 56 | 2 |
274538 | 274538 | 2020-06-26 | Marion | Alabama | 1093 | 189 | 12 |
274642 | 274642 | 2020-06-26 | Marion | Arkansas | 5089 | 4 | 0 |
274846 | 274846 | 2020-06-26 | Marion | Florida | 12083 | 524 | 10 |
274969 | 274969 | 2020-06-26 | Marion | Georgia | 13197 | 77 | 2 |
275134 | 275134 | 2020-06-26 | Marion | Illinois | 17121 | 65 | 0 |
275227 | 275227 | 2020-06-26 | Marion | Indiana | 18097 | 11226 | 723 |
275333 | 275333 | 2020-06-26 | Marion | Iowa | 19125 | 55 | 0 |
275422 | 275422 | 2020-06-26 | Marion | Kansas | 20115 | 10 | 1 |
275540 | 275540 | 2020-06-26 | Marion | Kentucky | 21155 | 49 | 0 |
275922 | 275922 | 2020-06-26 | Marion | Mississippi | 28091 | 223 | 11 |
276022 | 276022 | 2020-06-26 | Marion | Missouri | 29127 | 14 | 0 |
276531 | 276531 | 2020-06-26 | Marion | Ohio | 39101 | 2717 | 36 |
276666 | 276666 | 2020-06-26 | Marion | Oregon | 41047 | 1400 | 41 |
276862 | 276862 | 2020-06-26 | Marion | South Carolina | 45067 | 171 | 6 |
276990 | 276990 | 2020-06-26 | Marion | Tennessee | 47115 | 56 | 4 |
277178 | 277178 | 2020-06-26 | Marion | Texas | 48315 | 25 | 1 |
277513 | 277513 | 2020-06-26 | Marion | West Virginia | 54049 | 55 | 2 |
271398 | 271398 | 2020-06-25 | Marion | Alabama | 1093 | 188 | 12 |
271502 | 271502 | 2020-06-25 | Marion | Arkansas | 5089 | 3 | 0 |
271706 | 271706 | 2020-06-25 | Marion | Florida | 12083 | 493 | 10 |
271829 | 271829 | 2020-06-25 | Marion | Georgia | 13197 | 77 | 2 |
271992 | 271992 | 2020-06-25 | Marion | Illinois | 17121 | 65 | 0 |
272085 | 272085 | 2020-06-25 | Marion | Indiana | 18097 | 11164 | 722 |
272191 | 272191 | 2020-06-25 | Marion | Iowa | 19125 | 52 | 0 |
272279 | 272279 | 2020-06-25 | Marion | Kansas | 20115 | 9 | 1 |
272397 | 272397 | 2020-06-25 | Marion | Kentucky | 21155 | 49 | 0 |
272779 | 272779 | 2020-06-25 | Marion | Mississippi | 28091 | 215 | 10 |
272879 | 272879 | 2020-06-25 | Marion | Missouri | 29127 | 14 | 0 |
273384 | 273384 | 2020-06-25 | Marion | Ohio | 39101 | 2717 | 36 |
273519 | 273519 | 2020-06-25 | Marion | Oregon | 41047 | 1382 | 38 |
273715 | 273715 | 2020-06-25 | Marion | South Carolina | 45067 | 170 | 6 |
273843 | 273843 | 2020-06-25 | Marion | Tennessee | 47115 | 56 | 4 |
274030 | 274030 | 2020-06-25 | Marion | Texas | 48315 | 23 | 1 |
274365 | 274365 | 2020-06-25 | Marion | West Virginia | 54049 | 55 | 2 |
268264 | 268264 | 2020-06-24 | Marion | Alabama | 1093 | 184 | 12 |
268367 | 268367 | 2020-06-24 | Marion | Arkansas | 5089 | 2 | 0 |
268570 | 268570 | 2020-06-24 | Marion | Florida | 12083 | 467 | 10 |
268693 | 268693 | 2020-06-24 | Marion | Georgia | 13197 | 77 | 2 |
268855 | 268855 | 2020-06-24 | Marion | Illinois | 17121 | 63 | 0 |
268948 | 268948 | 2020-06-24 | Marion | Indiana | 18097 | 11118 | 720 |
269054 | 269054 | 2020-06-24 | Marion | Iowa | 19125 | 50 | 0 |
269142 | 269142 | 2020-06-24 | Marion | Kansas | 20115 | 9 | 1 |
269261 | 269261 | 2020-06-24 | Marion | Kentucky | 21155 | 48 | 0 |
269641 | 269641 | 2020-06-24 | Marion | Mississippi | 28091 | 203 | 10 |
269740 | 269740 | 2020-06-24 | Marion | Missouri | 29127 | 13 | 0 |
270245 | 270245 | 2020-06-24 | Marion | Ohio | 39101 | 2714 | 35 |
270380 | 270380 | 2020-06-24 | Marion | Oregon | 41047 | 1378 | 36 |
270576 | 270576 | 2020-06-24 | Marion | South Carolina | 45067 | 164 | 6 |
270704 | 270704 | 2020-06-24 | Marion | Tennessee | 47115 | 54 | 4 |
270890 | 270890 | 2020-06-24 | Marion | Texas | 48315 | 23 | 1 |
271225 | 271225 | 2020-06-24 | Marion | West Virginia | 54049 | 54 | 2 |
265135 | 265135 | 2020-06-23 | Marion | Alabama | 1093 | 176 | 12 |
265237 | 265237 | 2020-06-23 | Marion | Arkansas | 5089 | 2 | 0 |
265440 | 265440 | 2020-06-23 | Marion | Florida | 12083 | 424 | 10 |
265563 | 265563 | 2020-06-23 | Marion | Georgia | 13197 | 78 | 3 |
265725 | 265725 | 2020-06-23 | Marion | Illinois | 17121 | 62 | 0 |
265818 | 265818 | 2020-06-23 | Marion | Indiana | 18097 | 11099 | 716 |
265924 | 265924 | 2020-06-23 | Marion | Iowa | 19125 | 48 | 0 |
266011 | 266011 | 2020-06-23 | Marion | Kansas | 20115 | 9 | 1 |
266128 | 266128 | 2020-06-23 | Marion | Kentucky | 21155 | 48 | 0 |
266508 | 266508 | 2020-06-23 | Marion | Mississippi | 28091 | 196 | 10 |
266607 | 266607 | 2020-06-23 | Marion | Missouri | 29127 | 13 | 0 |
267111 | 267111 | 2020-06-23 | Marion | Ohio | 39101 | 2713 | 35 |
267246 | 267246 | 2020-06-23 | Marion | Oregon | 41047 | 1365 | 35 |
267442 | 267442 | 2020-06-23 | Marion | South Carolina | 45067 | 159 | 6 |
267570 | 267570 | 2020-06-23 | Marion | Tennessee | 47115 | 53 | 4 |
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);