ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,571 rows where county = "Genesee" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4746 | 4746 | 2020-03-19 | Genesee | Michigan | 26049 | 1 | 0 |
5565 | 5565 | 2020-03-20 | Genesee | Michigan | 26049 | 1 | 0 |
5720 | 5720 | 2020-03-20 | Genesee | New York | 36037 | 1 | 0 |
6530 | 6530 | 2020-03-21 | Genesee | Michigan | 26049 | 7 | 0 |
6714 | 6714 | 2020-03-21 | Genesee | New York | 36037 | 1 | 0 |
7608 | 7608 | 2020-03-22 | Genesee | Michigan | 26049 | 14 | 0 |
7808 | 7808 | 2020-03-22 | Genesee | New York | 36037 | 1 | 0 |
8781 | 8781 | 2020-03-23 | Genesee | Michigan | 26049 | 23 | 0 |
9006 | 9006 | 2020-03-23 | Genesee | New York | 36037 | 1 | 0 |
10070 | 10070 | 2020-03-24 | Genesee | Michigan | 26049 | 34 | 0 |
10313 | 10313 | 2020-03-24 | Genesee | New York | 36037 | 1 | 0 |
11482 | 11482 | 2020-03-25 | Genesee | Michigan | 26049 | 46 | 0 |
11749 | 11749 | 2020-03-25 | Genesee | New York | 36037 | 2 | 0 |
13063 | 13063 | 2020-03-26 | Genesee | Michigan | 26049 | 63 | 1 |
13352 | 13352 | 2020-03-26 | Genesee | New York | 36037 | 4 | 0 |
14773 | 14773 | 2020-03-27 | Genesee | Michigan | 26049 | 91 | 4 |
15086 | 15086 | 2020-03-27 | Genesee | New York | 36037 | 6 | 0 |
16593 | 16593 | 2020-03-28 | Genesee | Michigan | 26049 | 110 | 5 |
16916 | 16916 | 2020-03-28 | Genesee | New York | 36037 | 7 | 0 |
18509 | 18509 | 2020-03-29 | Genesee | Michigan | 26049 | 127 | 5 |
18840 | 18840 | 2020-03-29 | Genesee | New York | 36037 | 9 | 0 |
20527 | 20527 | 2020-03-30 | Genesee | Michigan | 26049 | 150 | 7 |
20879 | 20879 | 2020-03-30 | Genesee | New York | 36037 | 9 | 0 |
22638 | 22638 | 2020-03-31 | Genesee | Michigan | 26049 | 185 | 7 |
23002 | 23002 | 2020-03-31 | Genesee | New York | 36037 | 10 | 0 |
24817 | 24817 | 2020-04-01 | Genesee | Michigan | 26049 | 249 | 8 |
25196 | 25196 | 2020-04-01 | Genesee | New York | 36037 | 13 | 1 |
27070 | 27070 | 2020-04-02 | Genesee | Michigan | 26049 | 349 | 10 |
27456 | 27456 | 2020-04-02 | Genesee | New York | 36037 | 17 | 1 |
29388 | 29388 | 2020-04-03 | Genesee | Michigan | 26049 | 422 | 11 |
29780 | 29780 | 2020-04-03 | Genesee | New York | 36037 | 17 | 1 |
31766 | 31766 | 2020-04-04 | Genesee | Michigan | 26049 | 464 | 15 |
32166 | 32166 | 2020-04-04 | Genesee | New York | 36037 | 21 | 1 |
34191 | 34191 | 2020-04-05 | Genesee | Michigan | 26049 | 504 | 18 |
34597 | 34597 | 2020-04-05 | Genesee | New York | 36037 | 22 | 1 |
36650 | 36650 | 2020-04-06 | Genesee | Michigan | 26049 | 568 | 26 |
37067 | 37067 | 2020-04-06 | Genesee | New York | 36037 | 23 | 1 |
39158 | 39158 | 2020-04-07 | Genesee | Michigan | 26049 | 638 | 33 |
39582 | 39582 | 2020-04-07 | Genesee | New York | 36037 | 33 | 1 |
41710 | 41710 | 2020-04-08 | Genesee | Michigan | 26049 | 713 | 39 |
42139 | 42139 | 2020-04-08 | Genesee | New York | 36037 | 47 | 0 |
44286 | 44286 | 2020-04-09 | Genesee | Michigan | 26049 | 755 | 48 |
44722 | 44722 | 2020-04-09 | Genesee | New York | 36037 | 56 | 0 |
46894 | 46894 | 2020-04-10 | Genesee | Michigan | 26049 | 828 | 57 |
47335 | 47335 | 2020-04-10 | Genesee | New York | 36037 | 65 | 0 |
49537 | 49537 | 2020-04-11 | Genesee | Michigan | 26049 | 919 | 62 |
49990 | 49990 | 2020-04-11 | Genesee | New York | 36037 | 67 | 0 |
52207 | 52207 | 2020-04-12 | Genesee | Michigan | 26049 | 955 | 68 |
52663 | 52663 | 2020-04-12 | Genesee | New York | 36037 | 69 | 0 |
54888 | 54888 | 2020-04-13 | Genesee | Michigan | 26049 | 988 | 77 |
55346 | 55346 | 2020-04-13 | Genesee | New York | 36037 | 71 | 0 |
57586 | 57586 | 2020-04-14 | Genesee | Michigan | 26049 | 1030 | 86 |
58046 | 58046 | 2020-04-14 | Genesee | New York | 36037 | 76 | 0 |
60296 | 60296 | 2020-04-15 | Genesee | Michigan | 26049 | 1084 | 89 |
60760 | 60760 | 2020-04-15 | Genesee | New York | 36037 | 76 | 1 |
63018 | 63018 | 2020-04-16 | Genesee | Michigan | 26049 | 1147 | 99 |
63486 | 63486 | 2020-04-16 | Genesee | New York | 36037 | 78 | 2 |
65756 | 65756 | 2020-04-17 | Genesee | Michigan | 26049 | 1197 | 106 |
66228 | 66228 | 2020-04-17 | Genesee | New York | 36037 | 83 | 2 |
68507 | 68507 | 2020-04-18 | Genesee | Michigan | 26049 | 1228 | 112 |
68985 | 68985 | 2020-04-18 | Genesee | New York | 36037 | 87 | 2 |
71271 | 71271 | 2020-04-19 | Genesee | Michigan | 26049 | 1240 | 115 |
71752 | 71752 | 2020-04-19 | Genesee | New York | 36037 | 117 | 2 |
74043 | 74043 | 2020-04-20 | Genesee | Michigan | 26049 | 1256 | 123 |
74527 | 74527 | 2020-04-20 | Genesee | New York | 36037 | 119 | 2 |
76823 | 76823 | 2020-04-21 | Genesee | Michigan | 26049 | 1298 | 131 |
77308 | 77308 | 2020-04-21 | Genesee | New York | 36037 | 121 | 2 |
79609 | 79609 | 2020-04-22 | Genesee | Michigan | 26049 | 1362 | 138 |
80097 | 80097 | 2020-04-22 | Genesee | New York | 36037 | 122 | 2 |
82404 | 82404 | 2020-04-23 | Genesee | Michigan | 26049 | 1387 | 144 |
82896 | 82896 | 2020-04-23 | Genesee | New York | 36037 | 126 | 2 |
85208 | 85208 | 2020-04-24 | Genesee | Michigan | 26049 | 1434 | 151 |
85700 | 85700 | 2020-04-24 | Genesee | New York | 36037 | 127 | 2 |
88018 | 88018 | 2020-04-25 | Genesee | Michigan | 26049 | 1452 | 157 |
88512 | 88512 | 2020-04-25 | Genesee | New York | 36037 | 141 | 2 |
90834 | 90834 | 2020-04-26 | Genesee | Michigan | 26049 | 1467 | 161 |
91327 | 91327 | 2020-04-26 | Genesee | New York | 36037 | 144 | 2 |
93655 | 93655 | 2020-04-27 | Genesee | Michigan | 26049 | 1483 | 165 |
94152 | 94152 | 2020-04-27 | Genesee | New York | 36037 | 148 | 2 |
96490 | 96490 | 2020-04-28 | Genesee | Michigan | 26049 | 1533 | 174 |
96988 | 96988 | 2020-04-28 | Genesee | New York | 36037 | 149 | 2 |
99336 | 99336 | 2020-04-29 | Genesee | Michigan | 26049 | 1564 | 180 |
99835 | 99835 | 2020-04-29 | Genesee | New York | 36037 | 152 | 2 |
102188 | 102188 | 2020-04-30 | Genesee | Michigan | 26049 | 1581 | 188 |
102688 | 102688 | 2020-04-30 | Genesee | New York | 36037 | 153 | 2 |
105048 | 105048 | 2020-05-01 | Genesee | Michigan | 26049 | 1600 | 192 |
105550 | 105550 | 2020-05-01 | Genesee | New York | 36037 | 154 | 2 |
107912 | 107912 | 2020-05-02 | Genesee | Michigan | 26049 | 1620 | 196 |
108417 | 108417 | 2020-05-02 | Genesee | New York | 36037 | 155 | 2 |
110784 | 110784 | 2020-05-03 | Genesee | Michigan | 26049 | 1634 | 196 |
111290 | 111290 | 2020-05-03 | Genesee | New York | 36037 | 155 | 2 |
113662 | 113662 | 2020-05-04 | Genesee | Michigan | 26049 | 1647 | 199 |
114171 | 114171 | 2020-05-04 | Genesee | New York | 36037 | 159 | 2 |
116543 | 116543 | 2020-05-05 | Genesee | Michigan | 26049 | 1668 | 200 |
117051 | 117051 | 2020-05-05 | Genesee | New York | 36037 | 159 | 2 |
119504 | 119504 | 2020-05-06 | Genesee | Michigan | 26049 | 1710 | 208 |
120012 | 120012 | 2020-05-06 | Genesee | New York | 36037 | 162 | 2 |
122476 | 122476 | 2020-05-07 | Genesee | Michigan | 26049 | 1731 | 213 |
122987 | 122987 | 2020-05-07 | Genesee | New York | 36037 | 168 | 2 |
125458 | 125458 | 2020-05-08 | Genesee | Michigan | 26049 | 1739 | 214 |
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);