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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
19929 | 19929 | 2020-03-30 | Marion | Florida | 12083 | 23 | 0 |
20144 | 20144 | 2020-03-30 | Marion | Illinois | 17121 | 2 | 0 |
20209 | 20209 | 2020-03-30 | Marion | Indiana | 18097 | 805 | 13 |
20376 | 20376 | 2020-03-30 | Marion | Kentucky | 21155 | 1 | 0 |
20664 | 20664 | 2020-03-30 | Marion | Mississippi | 28091 | 4 | 0 |
21055 | 21055 | 2020-03-30 | Marion | Ohio | 39101 | 7 | 0 |
21143 | 21143 | 2020-03-30 | Marion | Oregon | 41047 | 123 | 3 |
21247 | 21247 | 2020-03-30 | Marion | South Carolina | 45067 | 2 | 0 |
21333 | 21333 | 2020-03-30 | Marion | Tennessee | 47115 | 6 | 0 |
21649 | 21649 | 2020-03-30 | Marion | West Virginia | 54049 | 5 | 1 |
21767 | 21767 | 2020-03-31 | Marion | Alabama | 1093 | 9 | 0 |
22007 | 22007 | 2020-03-31 | Marion | Florida | 12083 | 28 | 0 |
22236 | 22236 | 2020-03-31 | Marion | Illinois | 17121 | 2 | 0 |
22304 | 22304 | 2020-03-31 | Marion | Indiana | 18097 | 965 | 18 |
22481 | 22481 | 2020-03-31 | Marion | Kentucky | 21155 | 1 | 0 |
22781 | 22781 | 2020-03-31 | Marion | Mississippi | 28091 | 5 | 0 |
23187 | 23187 | 2020-03-31 | Marion | Ohio | 39101 | 8 | 0 |
23277 | 23277 | 2020-03-31 | Marion | Oregon | 41047 | 141 | 3 |
23385 | 23385 | 2020-03-31 | Marion | South Carolina | 45067 | 2 | 1 |
23472 | 23472 | 2020-03-31 | Marion | Tennessee | 47115 | 6 | 0 |
23799 | 23799 | 2020-03-31 | Marion | West Virginia | 54049 | 5 | 1 |
23923 | 23923 | 2020-04-01 | Marion | Alabama | 1093 | 11 | 2 |
24169 | 24169 | 2020-04-01 | Marion | Florida | 12083 | 30 | 0 |
24404 | 24404 | 2020-04-01 | Marion | Illinois | 17121 | 2 | 0 |
24475 | 24475 | 2020-04-01 | Marion | Indiana | 18097 | 1119 | 23 |
24657 | 24657 | 2020-04-01 | Marion | Kentucky | 21155 | 1 | 0 |
24965 | 24965 | 2020-04-01 | Marion | Mississippi | 28091 | 6 | 0 |
25382 | 25382 | 2020-04-01 | Marion | Ohio | 39101 | 9 | 0 |
25475 | 25475 | 2020-04-01 | Marion | Oregon | 41047 | 151 | 3 |
25583 | 25583 | 2020-04-01 | Marion | South Carolina | 45067 | 2 | 1 |
25674 | 25674 | 2020-04-01 | Marion | Tennessee | 47115 | 8 | 1 |
26017 | 26017 | 2020-04-01 | Marion | West Virginia | 54049 | 8 | 1 |
26145 | 26145 | 2020-04-02 | Marion | Alabama | 1093 | 11 | 2 |
26399 | 26399 | 2020-04-02 | Marion | Florida | 12083 | 33 | 0 |
26639 | 26639 | 2020-04-02 | Marion | Illinois | 17121 | 2 | 0 |
26714 | 26714 | 2020-04-02 | Marion | Indiana | 18097 | 1306 | 26 |
26905 | 26905 | 2020-04-02 | Marion | Kentucky | 21155 | 1 | 0 |
27219 | 27219 | 2020-04-02 | Marion | Mississippi | 28091 | 5 | 0 |
27650 | 27650 | 2020-04-02 | Marion | Ohio | 39101 | 10 | 0 |
27747 | 27747 | 2020-04-02 | Marion | Oregon | 41047 | 164 | 4 |
27858 | 27858 | 2020-04-02 | Marion | South Carolina | 45067 | 2 | 1 |
27953 | 27953 | 2020-04-02 | Marion | Tennessee | 47115 | 13 | 1 |
28309 | 28309 | 2020-04-02 | Marion | West Virginia | 54049 | 10 | 1 |
28442 | 28442 | 2020-04-03 | Marion | Alabama | 1093 | 16 | 2 |
28702 | 28702 | 2020-04-03 | Marion | Florida | 12083 | 38 | 0 |
28816 | 28816 | 2020-04-03 | Marion | Georgia | 13197 | 1 | 0 |
28949 | 28949 | 2020-04-03 | Marion | Illinois | 17121 | 3 | 0 |
29024 | 29024 | 2020-04-03 | Marion | Indiana | 18097 | 1431 | 35 |
29154 | 29154 | 2020-04-03 | Marion | Kansas | 20115 | 1 | 0 |
29221 | 29221 | 2020-04-03 | Marion | Kentucky | 21155 | 1 | 0 |
29538 | 29538 | 2020-04-03 | Marion | Mississippi | 28091 | 5 | 0 |
29979 | 29979 | 2020-04-03 | Marion | Ohio | 39101 | 11 | 0 |
30080 | 30080 | 2020-04-03 | Marion | Oregon | 41047 | 178 | 4 |
30193 | 30193 | 2020-04-03 | Marion | South Carolina | 45067 | 2 | 1 |
30288 | 30288 | 2020-04-03 | Marion | Tennessee | 47115 | 14 | 1 |
30662 | 30662 | 2020-04-03 | Marion | West Virginia | 54049 | 11 | 1 |
30799 | 30799 | 2020-04-04 | Marion | Alabama | 1093 | 17 | 2 |
31062 | 31062 | 2020-04-04 | Marion | Florida | 12083 | 42 | 0 |
31176 | 31176 | 2020-04-04 | Marion | Georgia | 13197 | 2 | 0 |
31313 | 31313 | 2020-04-04 | Marion | Illinois | 17121 | 3 | 0 |
31390 | 31390 | 2020-04-04 | Marion | Indiana | 18097 | 1572 | 36 |
31528 | 31528 | 2020-04-04 | Marion | Kansas | 20115 | 2 | 0 |
31597 | 31597 | 2020-04-04 | Marion | Kentucky | 21155 | 3 | 0 |
31918 | 31918 | 2020-04-04 | Marion | Mississippi | 28091 | 6 | 0 |
32368 | 32368 | 2020-04-04 | Marion | Ohio | 39101 | 12 | 0 |
32470 | 32470 | 2020-04-04 | Marion | Oregon | 41047 | 188 | 5 |
32584 | 32584 | 2020-04-04 | Marion | South Carolina | 45067 | 2 | 1 |
32679 | 32679 | 2020-04-04 | Marion | Tennessee | 47115 | 16 | 1 |
33063 | 33063 | 2020-04-04 | Marion | West Virginia | 54049 | 13 | 1 |
33203 | 33203 | 2020-04-05 | Marion | Alabama | 1093 | 19 | 2 |
33468 | 33468 | 2020-04-05 | Marion | Florida | 12083 | 50 | 2 |
33583 | 33583 | 2020-04-05 | Marion | Georgia | 13197 | 2 | 0 |
33723 | 33723 | 2020-04-05 | Marion | Illinois | 17121 | 3 | 0 |
33801 | 33801 | 2020-04-05 | Marion | Indiana | 18097 | 1764 | 41 |
33942 | 33942 | 2020-04-05 | Marion | Kansas | 20115 | 2 | 0 |
34019 | 34019 | 2020-04-05 | Marion | Kentucky | 21155 | 5 | 0 |
34345 | 34345 | 2020-04-05 | Marion | Mississippi | 28091 | 7 | 0 |
34801 | 34801 | 2020-04-05 | Marion | Ohio | 39101 | 19 | 0 |
34904 | 34904 | 2020-04-05 | Marion | Oregon | 41047 | 198 | 5 |
35020 | 35020 | 2020-04-05 | Marion | South Carolina | 45067 | 2 | 1 |
35116 | 35116 | 2020-04-05 | Marion | Tennessee | 47115 | 16 | 1 |
35501 | 35501 | 2020-04-05 | Marion | West Virginia | 54049 | 14 | 1 |
35642 | 35642 | 2020-04-06 | Marion | Alabama | 1093 | 19 | 2 |
35914 | 35914 | 2020-04-06 | Marion | Florida | 12083 | 55 | 2 |
36033 | 36033 | 2020-04-06 | Marion | Georgia | 13197 | 2 | 0 |
36175 | 36175 | 2020-04-06 | Marion | Illinois | 17121 | 3 | 0 |
36254 | 36254 | 2020-04-06 | Marion | Indiana | 18097 | 1960 | 45 |
36343 | 36343 | 2020-04-06 | Marion | Iowa | 19125 | 1 | 0 |
36399 | 36399 | 2020-04-06 | Marion | Kansas | 20115 | 3 | 0 |
36477 | 36477 | 2020-04-06 | Marion | Kentucky | 21155 | 5 | 0 |
36808 | 36808 | 2020-04-06 | Marion | Mississippi | 28091 | 8 | 0 |
37270 | 37270 | 2020-04-06 | Marion | Ohio | 39101 | 25 | 0 |
37379 | 37379 | 2020-04-06 | Marion | Oregon | 41047 | 209 | 6 |
37495 | 37495 | 2020-04-06 | Marion | South Carolina | 45067 | 4 | 1 |
37592 | 37592 | 2020-04-06 | Marion | Tennessee | 47115 | 20 | 1 |
37986 | 37986 | 2020-04-06 | Marion | West Virginia | 54049 | 17 | 1 |
38130 | 38130 | 2020-04-07 | Marion | Alabama | 1093 | 21 | 3 |
38405 | 38405 | 2020-04-07 | Marion | Florida | 12083 | 62 | 2 |
38526 | 38526 | 2020-04-07 | Marion | Georgia | 13197 | 4 | 0 |
38671 | 38671 | 2020-04-07 | Marion | Illinois | 17121 | 3 | 0 |
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);