ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,570 rows where county = "Otsego" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3464 | 3464 | 2020-03-17 | Otsego | Michigan | 26137 | 1 | 0 |
4047 | 4047 | 2020-03-18 | Otsego | Michigan | 26137 | 1 | 0 |
4757 | 4757 | 2020-03-19 | Otsego | Michigan | 26137 | 1 | 0 |
5576 | 5576 | 2020-03-20 | Otsego | Michigan | 26137 | 1 | 0 |
6541 | 6541 | 2020-03-21 | Otsego | Michigan | 26137 | 1 | 0 |
7621 | 7621 | 2020-03-22 | Otsego | Michigan | 26137 | 1 | 0 |
8797 | 8797 | 2020-03-23 | Otsego | Michigan | 26137 | 3 | 0 |
9023 | 9023 | 2020-03-23 | Otsego | New York | 36077 | 1 | 0 |
10091 | 10091 | 2020-03-24 | Otsego | Michigan | 26137 | 5 | 0 |
10331 | 10331 | 2020-03-24 | Otsego | New York | 36077 | 1 | 0 |
11506 | 11506 | 2020-03-25 | Otsego | Michigan | 26137 | 6 | 0 |
11767 | 11767 | 2020-03-25 | Otsego | New York | 36077 | 2 | 0 |
13093 | 13093 | 2020-03-26 | Otsego | Michigan | 26137 | 7 | 0 |
13370 | 13370 | 2020-03-26 | Otsego | New York | 36077 | 3 | 0 |
14805 | 14805 | 2020-03-27 | Otsego | Michigan | 26137 | 7 | 0 |
15104 | 15104 | 2020-03-27 | Otsego | New York | 36077 | 5 | 0 |
16626 | 16626 | 2020-03-28 | Otsego | Michigan | 26137 | 14 | 0 |
16934 | 16934 | 2020-03-28 | Otsego | New York | 36077 | 7 | 0 |
18542 | 18542 | 2020-03-29 | Otsego | Michigan | 26137 | 17 | 0 |
18859 | 18859 | 2020-03-29 | Otsego | New York | 36077 | 10 | 0 |
20561 | 20561 | 2020-03-30 | Otsego | Michigan | 26137 | 17 | 0 |
20898 | 20898 | 2020-03-30 | Otsego | New York | 36077 | 17 | 0 |
22673 | 22673 | 2020-03-31 | Otsego | Michigan | 26137 | 19 | 0 |
23021 | 23021 | 2020-03-31 | Otsego | New York | 36077 | 18 | 0 |
24853 | 24853 | 2020-04-01 | Otsego | Michigan | 26137 | 19 | 0 |
25215 | 25215 | 2020-04-01 | Otsego | New York | 36077 | 19 | 1 |
27106 | 27106 | 2020-04-02 | Otsego | Michigan | 26137 | 19 | 0 |
27475 | 27475 | 2020-04-02 | Otsego | New York | 36077 | 21 | 1 |
29425 | 29425 | 2020-04-03 | Otsego | Michigan | 26137 | 20 | 0 |
29799 | 29799 | 2020-04-03 | Otsego | New York | 36077 | 21 | 1 |
31803 | 31803 | 2020-04-04 | Otsego | Michigan | 26137 | 22 | 1 |
32185 | 32185 | 2020-04-04 | Otsego | New York | 36077 | 26 | 2 |
34228 | 34228 | 2020-04-05 | Otsego | Michigan | 26137 | 24 | 1 |
34616 | 34616 | 2020-04-05 | Otsego | New York | 36077 | 29 | 2 |
36687 | 36687 | 2020-04-06 | Otsego | Michigan | 26137 | 26 | 2 |
37086 | 37086 | 2020-04-06 | Otsego | New York | 36077 | 34 | 2 |
39196 | 39196 | 2020-04-07 | Otsego | Michigan | 26137 | 28 | 2 |
39601 | 39601 | 2020-04-07 | Otsego | New York | 36077 | 34 | 2 |
41748 | 41748 | 2020-04-08 | Otsego | Michigan | 26137 | 29 | 2 |
42158 | 42158 | 2020-04-08 | Otsego | New York | 36077 | 38 | 2 |
44324 | 44324 | 2020-04-09 | Otsego | Michigan | 26137 | 29 | 2 |
44741 | 44741 | 2020-04-09 | Otsego | New York | 36077 | 39 | 2 |
46933 | 46933 | 2020-04-10 | Otsego | Michigan | 26137 | 29 | 2 |
47354 | 47354 | 2020-04-10 | Otsego | New York | 36077 | 41 | 2 |
49577 | 49577 | 2020-04-11 | Otsego | Michigan | 26137 | 31 | 2 |
50009 | 50009 | 2020-04-11 | Otsego | New York | 36077 | 43 | 2 |
52247 | 52247 | 2020-04-12 | Otsego | Michigan | 26137 | 33 | 2 |
52682 | 52682 | 2020-04-12 | Otsego | New York | 36077 | 43 | 2 |
54929 | 54929 | 2020-04-13 | Otsego | Michigan | 26137 | 34 | 2 |
55365 | 55365 | 2020-04-13 | Otsego | New York | 36077 | 43 | 3 |
57627 | 57627 | 2020-04-14 | Otsego | Michigan | 26137 | 34 | 2 |
58065 | 58065 | 2020-04-14 | Otsego | New York | 36077 | 44 | 3 |
60337 | 60337 | 2020-04-15 | Otsego | Michigan | 26137 | 35 | 2 |
60779 | 60779 | 2020-04-15 | Otsego | New York | 36077 | 44 | 4 |
63059 | 63059 | 2020-04-16 | Otsego | Michigan | 26137 | 44 | 2 |
63505 | 63505 | 2020-04-16 | Otsego | New York | 36077 | 44 | 4 |
65797 | 65797 | 2020-04-17 | Otsego | Michigan | 26137 | 45 | 3 |
66247 | 66247 | 2020-04-17 | Otsego | New York | 36077 | 44 | 4 |
68548 | 68548 | 2020-04-18 | Otsego | Michigan | 26137 | 54 | 5 |
69004 | 69004 | 2020-04-18 | Otsego | New York | 36077 | 47 | 4 |
71312 | 71312 | 2020-04-19 | Otsego | Michigan | 26137 | 72 | 5 |
71771 | 71771 | 2020-04-19 | Otsego | New York | 36077 | 48 | 5 |
74084 | 74084 | 2020-04-20 | Otsego | Michigan | 26137 | 72 | 5 |
74546 | 74546 | 2020-04-20 | Otsego | New York | 36077 | 49 | 5 |
76864 | 76864 | 2020-04-21 | Otsego | Michigan | 26137 | 77 | 6 |
77327 | 77327 | 2020-04-21 | Otsego | New York | 36077 | 49 | 5 |
79650 | 79650 | 2020-04-22 | Otsego | Michigan | 26137 | 78 | 6 |
80116 | 80116 | 2020-04-22 | Otsego | New York | 36077 | 49 | 5 |
82445 | 82445 | 2020-04-23 | Otsego | Michigan | 26137 | 83 | 6 |
82915 | 82915 | 2020-04-23 | Otsego | New York | 36077 | 50 | 5 |
85249 | 85249 | 2020-04-24 | Otsego | Michigan | 26137 | 84 | 7 |
85719 | 85719 | 2020-04-24 | Otsego | New York | 36077 | 50 | 5 |
88059 | 88059 | 2020-04-25 | Otsego | Michigan | 26137 | 84 | 7 |
88531 | 88531 | 2020-04-25 | Otsego | New York | 36077 | 60 | 5 |
90875 | 90875 | 2020-04-26 | Otsego | Michigan | 26137 | 87 | 8 |
91346 | 91346 | 2020-04-26 | Otsego | New York | 36077 | 60 | 5 |
93696 | 93696 | 2020-04-27 | Otsego | Michigan | 26137 | 87 | 8 |
94171 | 94171 | 2020-04-27 | Otsego | New York | 36077 | 62 | 5 |
96531 | 96531 | 2020-04-28 | Otsego | Michigan | 26137 | 88 | 8 |
97007 | 97007 | 2020-04-28 | Otsego | New York | 36077 | 65 | 5 |
99377 | 99377 | 2020-04-29 | Otsego | Michigan | 26137 | 90 | 8 |
99854 | 99854 | 2020-04-29 | Otsego | New York | 36077 | 66 | 5 |
102229 | 102229 | 2020-04-30 | Otsego | Michigan | 26137 | 92 | 8 |
102707 | 102707 | 2020-04-30 | Otsego | New York | 36077 | 67 | 5 |
105089 | 105089 | 2020-05-01 | Otsego | Michigan | 26137 | 92 | 8 |
105569 | 105569 | 2020-05-01 | Otsego | New York | 36077 | 67 | 5 |
107953 | 107953 | 2020-05-02 | Otsego | Michigan | 26137 | 93 | 8 |
108436 | 108436 | 2020-05-02 | Otsego | New York | 36077 | 67 | 5 |
110825 | 110825 | 2020-05-03 | Otsego | Michigan | 26137 | 93 | 8 |
111309 | 111309 | 2020-05-03 | Otsego | New York | 36077 | 67 | 5 |
113703 | 113703 | 2020-05-04 | Otsego | Michigan | 26137 | 93 | 8 |
114190 | 114190 | 2020-05-04 | Otsego | New York | 36077 | 67 | 5 |
116584 | 116584 | 2020-05-05 | Otsego | Michigan | 26137 | 94 | 8 |
117070 | 117070 | 2020-05-05 | Otsego | New York | 36077 | 67 | 5 |
119545 | 119545 | 2020-05-06 | Otsego | Michigan | 26137 | 95 | 8 |
120031 | 120031 | 2020-05-06 | Otsego | New York | 36077 | 67 | 5 |
122517 | 122517 | 2020-05-07 | Otsego | Michigan | 26137 | 95 | 8 |
123006 | 123006 | 2020-05-07 | Otsego | New York | 36077 | 67 | 5 |
125499 | 125499 | 2020-05-08 | Otsego | Michigan | 26137 | 95 | 9 |
125989 | 125989 | 2020-05-08 | Otsego | New York | 36077 | 67 | 5 |
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);