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 |
---|---|---|---|---|---|---|---|
386093 | 386093 | 2020-07-31 | Marion | Arkansas | 5089 | 23 | 0 |
386300 | 386300 | 2020-07-31 | Marion | Florida | 12083 | 4892 | 60 |
386423 | 386423 | 2020-07-31 | Marion | Georgia | 13197 | 136 | 4 |
386592 | 386592 | 2020-07-31 | Marion | Illinois | 17121 | 130 | 0 |
386686 | 386686 | 2020-07-31 | Marion | Indiana | 18097 | 14575 | 766 |
386792 | 386792 | 2020-07-31 | Marion | Iowa | 19125 | 147 | 0 |
386886 | 386886 | 2020-07-31 | Marion | Kansas | 20115 | 51 | 1 |
387007 | 387007 | 2020-07-31 | Marion | Kentucky | 21155 | 101 | 0 |
387392 | 387392 | 2020-07-31 | Marion | Mississippi | 28091 | 581 | 17 |
387493 | 387493 | 2020-07-31 | Marion | Missouri | 29127 | 139 | 1 |
388027 | 388027 | 2020-07-31 | Marion | Ohio | 39101 | 2860 | 44 |
388165 | 388165 | 2020-07-31 | Marion | Oregon | 41047 | 2575 | 67 |
388361 | 388361 | 2020-07-31 | Marion | South Carolina | 45067 | 511 | 12 |
388495 | 388495 | 2020-07-31 | Marion | Tennessee | 47115 | 195 | 4 |
388687 | 388687 | 2020-07-31 | Marion | Texas | 48315 | 123 | 7 |
389029 | 389029 | 2020-07-31 | Marion | West Virginia | 54049 | 170 | 2 |
382768 | 382768 | 2020-07-30 | Marion | Alabama | 1093 | 537 | 24 |
382875 | 382875 | 2020-07-30 | Marion | Arkansas | 5089 | 22 | 0 |
383082 | 383082 | 2020-07-30 | Marion | Florida | 12083 | 4682 | 56 |
383205 | 383205 | 2020-07-30 | Marion | Georgia | 13197 | 131 | 4 |
383374 | 383374 | 2020-07-30 | Marion | Illinois | 17121 | 125 | 0 |
383468 | 383468 | 2020-07-30 | Marion | Indiana | 18097 | 14412 | 765 |
383574 | 383574 | 2020-07-30 | Marion | Iowa | 19125 | 142 | 0 |
383668 | 383668 | 2020-07-30 | Marion | Kansas | 20115 | 50 | 1 |
383789 | 383789 | 2020-07-30 | Marion | Kentucky | 21155 | 97 | 0 |
384174 | 384174 | 2020-07-30 | Marion | Mississippi | 28091 | 569 | 16 |
384275 | 384275 | 2020-07-30 | Marion | Missouri | 29127 | 127 | 1 |
384810 | 384810 | 2020-07-30 | Marion | Ohio | 39101 | 2855 | 42 |
384948 | 384948 | 2020-07-30 | Marion | Oregon | 41047 | 2541 | 67 |
385144 | 385144 | 2020-07-30 | Marion | South Carolina | 45067 | 498 | 12 |
385278 | 385278 | 2020-07-30 | Marion | Tennessee | 47115 | 190 | 4 |
385470 | 385470 | 2020-07-30 | Marion | Texas | 48315 | 122 | 7 |
385812 | 385812 | 2020-07-30 | Marion | West Virginia | 54049 | 170 | 2 |
379551 | 379551 | 2020-07-29 | Marion | Alabama | 1093 | 519 | 24 |
379658 | 379658 | 2020-07-29 | Marion | Arkansas | 5089 | 21 | 0 |
379865 | 379865 | 2020-07-29 | Marion | Florida | 12083 | 4314 | 55 |
379988 | 379988 | 2020-07-29 | Marion | Georgia | 13197 | 128 | 4 |
380157 | 380157 | 2020-07-29 | Marion | Illinois | 17121 | 122 | 0 |
380251 | 380251 | 2020-07-29 | Marion | Indiana | 18097 | 14237 | 762 |
380357 | 380357 | 2020-07-29 | Marion | Iowa | 19125 | 141 | 0 |
380451 | 380451 | 2020-07-29 | Marion | Kansas | 20115 | 50 | 1 |
380572 | 380572 | 2020-07-29 | Marion | Kentucky | 21155 | 97 | 0 |
380957 | 380957 | 2020-07-29 | Marion | Mississippi | 28091 | 550 | 16 |
381059 | 381059 | 2020-07-29 | Marion | Missouri | 29127 | 111 | 1 |
381592 | 381592 | 2020-07-29 | Marion | Ohio | 39101 | 2841 | 42 |
381730 | 381730 | 2020-07-29 | Marion | Oregon | 41047 | 2495 | 67 |
381926 | 381926 | 2020-07-29 | Marion | South Carolina | 45067 | 486 | 12 |
382060 | 382060 | 2020-07-29 | Marion | Tennessee | 47115 | 183 | 4 |
382252 | 382252 | 2020-07-29 | Marion | Texas | 48315 | 122 | 7 |
382594 | 382594 | 2020-07-29 | Marion | West Virginia | 54049 | 167 | 2 |
376335 | 376335 | 2020-07-28 | Marion | Alabama | 1093 | 509 | 24 |
376442 | 376442 | 2020-07-28 | Marion | Arkansas | 5089 | 18 | 0 |
376648 | 376648 | 2020-07-28 | Marion | Florida | 12083 | 3928 | 51 |
376771 | 376771 | 2020-07-28 | Marion | Georgia | 13197 | 126 | 4 |
376940 | 376940 | 2020-07-28 | Marion | Illinois | 17121 | 116 | 0 |
377034 | 377034 | 2020-07-28 | Marion | Indiana | 18097 | 14094 | 761 |
377140 | 377140 | 2020-07-28 | Marion | Iowa | 19125 | 138 | 0 |
377234 | 377234 | 2020-07-28 | Marion | Kansas | 20115 | 46 | 1 |
377355 | 377355 | 2020-07-28 | Marion | Kentucky | 21155 | 94 | 0 |
377740 | 377740 | 2020-07-28 | Marion | Mississippi | 28091 | 532 | 16 |
377842 | 377842 | 2020-07-28 | Marion | Missouri | 29127 | 102 | 1 |
378375 | 378375 | 2020-07-28 | Marion | Ohio | 39101 | 2836 | 42 |
378513 | 378513 | 2020-07-28 | Marion | Oregon | 41047 | 2474 | 67 |
378709 | 378709 | 2020-07-28 | Marion | South Carolina | 45067 | 477 | 12 |
378843 | 378843 | 2020-07-28 | Marion | Tennessee | 47115 | 184 | 4 |
379035 | 379035 | 2020-07-28 | Marion | Texas | 48315 | 119 | 7 |
379377 | 379377 | 2020-07-28 | Marion | West Virginia | 54049 | 159 | 2 |
373121 | 373121 | 2020-07-27 | Marion | Alabama | 1093 | 504 | 24 |
373228 | 373228 | 2020-07-27 | Marion | Arkansas | 5089 | 18 | 0 |
373434 | 373434 | 2020-07-27 | Marion | Florida | 12083 | 3581 | 50 |
373557 | 373557 | 2020-07-27 | Marion | Georgia | 13197 | 126 | 4 |
373725 | 373725 | 2020-07-27 | Marion | Illinois | 17121 | 116 | 0 |
373819 | 373819 | 2020-07-27 | Marion | Indiana | 18097 | 13953 | 760 |
373925 | 373925 | 2020-07-27 | Marion | Iowa | 19125 | 137 | 0 |
374019 | 374019 | 2020-07-27 | Marion | Kansas | 20115 | 46 | 1 |
374140 | 374140 | 2020-07-27 | Marion | Kentucky | 21155 | 92 | 0 |
374525 | 374525 | 2020-07-27 | Marion | Mississippi | 28091 | 516 | 16 |
374627 | 374627 | 2020-07-27 | Marion | Missouri | 29127 | 92 | 1 |
375158 | 375158 | 2020-07-27 | Marion | Ohio | 39101 | 2825 | 41 |
375297 | 375297 | 2020-07-27 | Marion | Oregon | 41047 | 2437 | 65 |
375493 | 375493 | 2020-07-27 | Marion | South Carolina | 45067 | 465 | 12 |
375627 | 375627 | 2020-07-27 | Marion | Tennessee | 47115 | 175 | 4 |
375819 | 375819 | 2020-07-27 | Marion | Texas | 48315 | 117 | 6 |
376161 | 376161 | 2020-07-27 | Marion | West Virginia | 54049 | 159 | 2 |
369909 | 369909 | 2020-07-26 | Marion | Alabama | 1093 | 493 | 24 |
370016 | 370016 | 2020-07-26 | Marion | Arkansas | 5089 | 18 | 0 |
370222 | 370222 | 2020-07-26 | Marion | Florida | 12083 | 3426 | 49 |
370345 | 370345 | 2020-07-26 | Marion | Georgia | 13197 | 125 | 4 |
370513 | 370513 | 2020-07-26 | Marion | Illinois | 17121 | 114 | 0 |
370607 | 370607 | 2020-07-26 | Marion | Indiana | 18097 | 13835 | 759 |
370713 | 370713 | 2020-07-26 | Marion | Iowa | 19125 | 136 | 0 |
370807 | 370807 | 2020-07-26 | Marion | Kansas | 20115 | 42 | 1 |
370928 | 370928 | 2020-07-26 | Marion | Kentucky | 21155 | 91 | 0 |
371313 | 371313 | 2020-07-26 | Marion | Mississippi | 28091 | 502 | 16 |
371415 | 371415 | 2020-07-26 | Marion | Missouri | 29127 | 85 | 1 |
371946 | 371946 | 2020-07-26 | Marion | Ohio | 39101 | 2821 | 41 |
372084 | 372084 | 2020-07-26 | Marion | Oregon | 41047 | 2413 | 65 |
372280 | 372280 | 2020-07-26 | Marion | South Carolina | 45067 | 453 | 12 |
372414 | 372414 | 2020-07-26 | Marion | Tennessee | 47115 | 172 | 4 |
372606 | 372606 | 2020-07-26 | Marion | Texas | 48315 | 117 | 7 |
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);