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)
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 |
2894 | 2894 | 2020-03-16 | Marion | Indiana | 18097 | 7 | 1 |
3088 | 3088 | 2020-03-16 | Marion | Oregon | 41047 | 3 | 0 |
3385 | 3385 | 2020-03-17 | Marion | Indiana | 18097 | 9 | 1 |
3617 | 3617 | 2020-03-17 | Marion | Oregon | 41047 | 4 | 0 |
3959 | 3959 | 2020-03-18 | Marion | Indiana | 18097 | 11 | 1 |
4232 | 4232 | 2020-03-18 | Marion | Oregon | 41047 | 8 | 0 |
4635 | 4635 | 2020-03-19 | Marion | Indiana | 18097 | 19 | 1 |
4971 | 4971 | 2020-03-19 | Marion | Oregon | 41047 | 13 | 0 |
5443 | 5443 | 2020-03-20 | Marion | Indiana | 18097 | 26 | 3 |
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 |
6382 | 6382 | 2020-03-21 | Marion | Indiana | 18097 | 47 | 3 |
6806 | 6806 | 2020-03-21 | Marion | Ohio | 39101 | 1 | 0 |
6841 | 6841 | 2020-03-21 | Marion | Oregon | 41047 | 19 | 1 |
7129 | 7129 | 2020-03-22 | Marion | Alabama | 1093 | 1 | 0 |
7286 | 7286 | 2020-03-22 | Marion | Florida | 12083 | 3 | 0 |
7436 | 7436 | 2020-03-22 | Marion | Indiana | 18097 | 83 | 4 |
7917 | 7917 | 2020-03-22 | Marion | Ohio | 39101 | 1 | 0 |
7956 | 7956 | 2020-03-22 | Marion | Oregon | 41047 | 22 | 1 |
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 |
8594 | 8594 | 2020-03-23 | Marion | Indiana | 18097 | 111 | 4 |
8867 | 8867 | 2020-03-23 | Marion | Mississippi | 28091 | 1 | 0 |
9123 | 9123 | 2020-03-23 | Marion | Ohio | 39101 | 3 | 0 |
9166 | 9166 | 2020-03-23 | Marion | Oregon | 41047 | 30 | 1 |
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 |
9864 | 9864 | 2020-03-24 | Marion | Indiana | 18097 | 162 | 7 |
10163 | 10163 | 2020-03-24 | Marion | Mississippi | 28091 | 1 | 0 |
10439 | 10439 | 2020-03-24 | Marion | Ohio | 39101 | 4 | 0 |
10485 | 10485 | 2020-03-24 | Marion | Oregon | 41047 | 32 | 1 |
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 |
11259 | 11259 | 2020-03-25 | Marion | Indiana | 18097 | 227 | 7 |
11583 | 11583 | 2020-03-25 | Marion | Mississippi | 28091 | 1 | 0 |
11888 | 11888 | 2020-03-25 | Marion | Ohio | 39101 | 4 | 0 |
11947 | 11947 | 2020-03-25 | Marion | Oregon | 41047 | 43 | 2 |
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 |
12816 | 12816 | 2020-03-26 | Marion | Indiana | 18097 | 294 | 7 |
13176 | 13176 | 2020-03-26 | Marion | Mississippi | 28091 | 1 | 0 |
13496 | 13496 | 2020-03-26 | Marion | Ohio | 39101 | 4 | 0 |
13563 | 13563 | 2020-03-26 | Marion | Oregon | 41047 | 57 | 2 |
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 |
14501 | 14501 | 2020-03-27 | Marion | Indiana | 18097 | 485 | 9 |
14894 | 14894 | 2020-03-27 | Marion | Mississippi | 28091 | 1 | 0 |
15234 | 15234 | 2020-03-27 | Marion | Ohio | 39101 | 5 | 0 |
15308 | 15308 | 2020-03-27 | Marion | Oregon | 41047 | 83 | 3 |
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 |
16299 | 16299 | 2020-03-28 | Marion | Indiana | 18097 | 585 | 11 |
16718 | 16718 | 2020-03-28 | Marion | Mississippi | 28091 | 3 | 0 |
17076 | 17076 | 2020-03-28 | Marion | Ohio | 39101 | 5 | 0 |
17155 | 17155 | 2020-03-28 | Marion | Oregon | 41047 | 94 | 3 |
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 |
18203 | 18203 | 2020-03-29 | Marion | Indiana | 18097 | 677 | 11 |
18640 | 18640 | 2020-03-29 | Marion | Mississippi | 28091 | 4 | 0 |
19010 | 19010 | 2020-03-29 | Marion | Ohio | 39101 | 6 | 0 |
19093 | 19093 | 2020-03-29 | Marion | Oregon | 41047 | 109 | 3 |
19195 | 19195 | 2020-03-29 | Marion | South Carolina | 45067 | 1 | 0 |
19277 | 19277 | 2020-03-29 | Marion | Tennessee | 47115 | 5 | 0 |
19582 | 19582 | 2020-03-29 | Marion | West Virginia | 54049 | 5 | 1 |
19695 | 19695 | 2020-03-30 | Marion | Alabama | 1093 | 9 | 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);