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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
614 | 614 | 2020-03-06 | Marion | Indiana | 18097 | 1 | 0 |
698 | 698 | 2020-03-07 | Marion | Indiana | 18097 | 1 | 0 |
796 | 796 | 2020-03-08 | Marion | Indiana | 18097 | 1 | 0 |
833 | 833 | 2020-03-08 | Marion | Oregon | 41047 | 1 | 0 |
916 | 916 | 2020-03-09 | Marion | Indiana | 18097 | 1 | 0 |
961 | 961 | 2020-03-09 | Marion | Oregon | 41047 | 1 | 0 |
1061 | 1061 | 2020-03-10 | Marion | Indiana | 18097 | 1 | 0 |
1112 | 1112 | 2020-03-10 | Marion | Oregon | 41047 | 1 | 0 |
1238 | 1238 | 2020-03-11 | Marion | Indiana | 18097 | 1 | 0 |
1303 | 1303 | 2020-03-11 | Marion | Oregon | 41047 | 2 | 0 |
1452 | 1452 | 2020-03-12 | Marion | Indiana | 18097 | 2 | 0 |
1547 | 1547 | 2020-03-12 | Marion | Oregon | 41047 | 2 | 0 |
1723 | 1723 | 2020-03-13 | Marion | Indiana | 18097 | 2 | 0 |
1843 | 1843 | 2020-03-13 | Marion | Oregon | 41047 | 2 | 0 |
2055 | 2055 | 2020-03-14 | Marion | Indiana | 18097 | 3 | 0 |
2204 | 2204 | 2020-03-14 | Marion | Oregon | 41047 | 2 | 0 |
2449 | 2449 | 2020-03-15 | Marion | Indiana | 18097 | 6 | 0 |
2623 | 2623 | 2020-03-15 | Marion | Oregon | 41047 | 2 | 0 |
3088 | 3088 | 2020-03-16 | Marion | Oregon | 41047 | 3 | 0 |
3617 | 3617 | 2020-03-17 | Marion | Oregon | 41047 | 4 | 0 |
4232 | 4232 | 2020-03-18 | Marion | Oregon | 41047 | 8 | 0 |
4971 | 4971 | 2020-03-19 | Marion | Oregon | 41047 | 13 | 0 |
5805 | 5805 | 2020-03-20 | Marion | Ohio | 39101 | 1 | 0 |
5839 | 5839 | 2020-03-20 | Marion | Oregon | 41047 | 17 | 0 |
6095 | 6095 | 2020-03-21 | Marion | Alabama | 1093 | 1 | 0 |
6246 | 6246 | 2020-03-21 | Marion | Florida | 12083 | 2 | 0 |
6806 | 6806 | 2020-03-21 | Marion | Ohio | 39101 | 1 | 0 |
7129 | 7129 | 2020-03-22 | Marion | Alabama | 1093 | 1 | 0 |
7286 | 7286 | 2020-03-22 | Marion | Florida | 12083 | 3 | 0 |
7917 | 7917 | 2020-03-22 | Marion | Ohio | 39101 | 1 | 0 |
8059 | 8059 | 2020-03-22 | Marion | Tennessee | 47115 | 1 | 0 |
8269 | 8269 | 2020-03-23 | Marion | Alabama | 1093 | 1 | 0 |
8432 | 8432 | 2020-03-23 | Marion | Florida | 12083 | 4 | 0 |
8867 | 8867 | 2020-03-23 | Marion | Mississippi | 28091 | 1 | 0 |
9123 | 9123 | 2020-03-23 | Marion | Ohio | 39101 | 3 | 0 |
9277 | 9277 | 2020-03-23 | Marion | Tennessee | 47115 | 1 | 0 |
9496 | 9496 | 2020-03-24 | Marion | Alabama | 1093 | 1 | 0 |
9677 | 9677 | 2020-03-24 | Marion | Florida | 12083 | 4 | 0 |
10163 | 10163 | 2020-03-24 | Marion | Mississippi | 28091 | 1 | 0 |
10439 | 10439 | 2020-03-24 | Marion | Ohio | 39101 | 4 | 0 |
10610 | 10610 | 2020-03-24 | Marion | Tennessee | 47115 | 1 | 0 |
10861 | 10861 | 2020-03-25 | Marion | Alabama | 1093 | 3 | 0 |
11052 | 11052 | 2020-03-25 | Marion | Florida | 12083 | 5 | 0 |
11583 | 11583 | 2020-03-25 | Marion | Mississippi | 28091 | 1 | 0 |
11888 | 11888 | 2020-03-25 | Marion | Ohio | 39101 | 4 | 0 |
12031 | 12031 | 2020-03-25 | Marion | South Carolina | 45067 | 1 | 0 |
12089 | 12089 | 2020-03-25 | Marion | Tennessee | 47115 | 1 | 0 |
12314 | 12314 | 2020-03-25 | Marion | West Virginia | 54049 | 1 | 0 |
12400 | 12400 | 2020-03-26 | Marion | Alabama | 1093 | 7 | 0 |
12600 | 12600 | 2020-03-26 | Marion | Florida | 12083 | 5 | 0 |
13176 | 13176 | 2020-03-26 | Marion | Mississippi | 28091 | 1 | 0 |
13496 | 13496 | 2020-03-26 | Marion | Ohio | 39101 | 4 | 0 |
13653 | 13653 | 2020-03-26 | Marion | South Carolina | 45067 | 1 | 0 |
13714 | 13714 | 2020-03-26 | Marion | Tennessee | 47115 | 2 | 0 |
13965 | 13965 | 2020-03-26 | Marion | West Virginia | 54049 | 2 | 0 |
14061 | 14061 | 2020-03-27 | Marion | Alabama | 1093 | 7 | 0 |
14270 | 14270 | 2020-03-27 | Marion | Florida | 12083 | 9 | 0 |
14894 | 14894 | 2020-03-27 | Marion | Mississippi | 28091 | 1 | 0 |
15234 | 15234 | 2020-03-27 | Marion | Ohio | 39101 | 5 | 0 |
15400 | 15400 | 2020-03-27 | Marion | South Carolina | 45067 | 1 | 0 |
15466 | 15466 | 2020-03-27 | Marion | Tennessee | 47115 | 2 | 0 |
15736 | 15736 | 2020-03-27 | Marion | West Virginia | 54049 | 3 | 0 |
15839 | 15839 | 2020-03-28 | Marion | Alabama | 1093 | 9 | 0 |
16055 | 16055 | 2020-03-28 | Marion | Florida | 12083 | 18 | 0 |
16718 | 16718 | 2020-03-28 | Marion | Mississippi | 28091 | 3 | 0 |
17076 | 17076 | 2020-03-28 | Marion | Ohio | 39101 | 5 | 0 |
17255 | 17255 | 2020-03-28 | Marion | South Carolina | 45067 | 1 | 0 |
17329 | 17329 | 2020-03-28 | Marion | Tennessee | 47115 | 4 | 0 |
17616 | 17616 | 2020-03-28 | Marion | West Virginia | 54049 | 5 | 0 |
17723 | 17723 | 2020-03-29 | Marion | Alabama | 1093 | 10 | 0 |
17948 | 17948 | 2020-03-29 | Marion | Florida | 12083 | 22 | 0 |
18640 | 18640 | 2020-03-29 | Marion | Mississippi | 28091 | 4 | 0 |
19010 | 19010 | 2020-03-29 | Marion | Ohio | 39101 | 6 | 0 |
19195 | 19195 | 2020-03-29 | Marion | South Carolina | 45067 | 1 | 0 |
19277 | 19277 | 2020-03-29 | Marion | Tennessee | 47115 | 5 | 0 |
19695 | 19695 | 2020-03-30 | Marion | Alabama | 1093 | 9 | 0 |
19929 | 19929 | 2020-03-30 | Marion | Florida | 12083 | 23 | 0 |
20144 | 20144 | 2020-03-30 | Marion | Illinois | 17121 | 2 | 0 |
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 |
21247 | 21247 | 2020-03-30 | Marion | South Carolina | 45067 | 2 | 0 |
21333 | 21333 | 2020-03-30 | Marion | Tennessee | 47115 | 6 | 0 |
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 |
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 |
23472 | 23472 | 2020-03-31 | Marion | Tennessee | 47115 | 6 | 0 |
24169 | 24169 | 2020-04-01 | Marion | Florida | 12083 | 30 | 0 |
24404 | 24404 | 2020-04-01 | Marion | Illinois | 17121 | 2 | 0 |
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 |
26399 | 26399 | 2020-04-02 | Marion | Florida | 12083 | 33 | 0 |
26639 | 26639 | 2020-04-02 | Marion | Illinois | 17121 | 2 | 0 |
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 |
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);