ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Hernando" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293723 | 293723 | 2020-07-02 | Hernando | Florida | 12053 | 451 | 5 |
290569 | 290569 | 2020-07-01 | Hernando | Florida | 12053 | 408 | 5 |
287418 | 287418 | 2020-06-30 | Hernando | Florida | 12053 | 373 | 5 |
284272 | 284272 | 2020-06-29 | Hernando | Florida | 12053 | 361 | 5 |
281126 | 281126 | 2020-06-28 | Hernando | Florida | 12053 | 346 | 5 |
277979 | 277979 | 2020-06-27 | Hernando | Florida | 12053 | 312 | 5 |
274831 | 274831 | 2020-06-26 | Hernando | Florida | 12053 | 260 | 5 |
271691 | 271691 | 2020-06-25 | Hernando | Florida | 12053 | 227 | 5 |
268555 | 268555 | 2020-06-24 | Hernando | Florida | 12053 | 218 | 5 |
265425 | 265425 | 2020-06-23 | Hernando | Florida | 12053 | 206 | 5 |
262297 | 262297 | 2020-06-22 | Hernando | Florida | 12053 | 200 | 5 |
259170 | 259170 | 2020-06-21 | Hernando | Florida | 12053 | 185 | 5 |
256043 | 256043 | 2020-06-20 | Hernando | Florida | 12053 | 171 | 5 |
252924 | 252924 | 2020-06-19 | Hernando | Florida | 12053 | 158 | 5 |
249809 | 249809 | 2020-06-18 | Hernando | Florida | 12053 | 151 | 5 |
246697 | 246697 | 2020-06-17 | Hernando | Florida | 12053 | 147 | 5 |
243584 | 243584 | 2020-06-16 | Hernando | Florida | 12053 | 146 | 5 |
240473 | 240473 | 2020-06-15 | Hernando | Florida | 12053 | 141 | 5 |
237365 | 237365 | 2020-06-14 | Hernando | Florida | 12053 | 140 | 5 |
234258 | 234258 | 2020-06-13 | Hernando | Florida | 12053 | 135 | 5 |
231152 | 231152 | 2020-06-12 | Hernando | Florida | 12053 | 132 | 5 |
228049 | 228049 | 2020-06-11 | Hernando | Florida | 12053 | 130 | 5 |
224947 | 224947 | 2020-06-10 | Hernando | Florida | 12053 | 129 | 5 |
221852 | 221852 | 2020-06-09 | Hernando | Florida | 12053 | 127 | 5 |
218757 | 218757 | 2020-06-08 | Hernando | Florida | 12053 | 126 | 5 |
215666 | 215666 | 2020-06-07 | Hernando | Florida | 12053 | 125 | 5 |
212579 | 212579 | 2020-06-06 | Hernando | Florida | 12053 | 122 | 5 |
209494 | 209494 | 2020-06-05 | Hernando | Florida | 12053 | 122 | 5 |
206413 | 206413 | 2020-06-04 | Hernando | Florida | 12053 | 122 | 5 |
203333 | 203333 | 2020-06-03 | Hernando | Florida | 12053 | 120 | 5 |
200257 | 200257 | 2020-06-02 | Hernando | Florida | 12053 | 118 | 5 |
197184 | 197184 | 2020-06-01 | Hernando | Florida | 12053 | 115 | 5 |
194114 | 194114 | 2020-05-31 | Hernando | Florida | 12053 | 115 | 5 |
191047 | 191047 | 2020-05-30 | Hernando | Florida | 12053 | 113 | 5 |
187982 | 187982 | 2020-05-29 | Hernando | Florida | 12053 | 113 | 5 |
184926 | 184926 | 2020-05-28 | Hernando | Florida | 12053 | 113 | 5 |
181872 | 181872 | 2020-05-27 | Hernando | Florida | 12053 | 113 | 5 |
178828 | 178828 | 2020-05-26 | Hernando | Florida | 12053 | 112 | 5 |
175784 | 175784 | 2020-05-25 | Hernando | Florida | 12053 | 112 | 5 |
172741 | 172741 | 2020-05-24 | Hernando | Florida | 12053 | 109 | 5 |
169700 | 169700 | 2020-05-23 | Hernando | Florida | 12053 | 109 | 5 |
166663 | 166663 | 2020-05-22 | Hernando | Florida | 12053 | 110 | 5 |
163630 | 163630 | 2020-05-21 | Hernando | Florida | 12053 | 108 | 5 |
160602 | 160602 | 2020-05-20 | Hernando | Florida | 12053 | 107 | 5 |
157576 | 157576 | 2020-05-19 | Hernando | Florida | 12053 | 109 | 5 |
154560 | 154560 | 2020-05-18 | Hernando | Florida | 12053 | 110 | 5 |
151548 | 151548 | 2020-05-17 | Hernando | Florida | 12053 | 109 | 5 |
148539 | 148539 | 2020-05-16 | Hernando | Florida | 12053 | 108 | 5 |
145536 | 145536 | 2020-05-15 | Hernando | Florida | 12053 | 105 | 5 |
142536 | 142536 | 2020-05-14 | Hernando | Florida | 12053 | 104 | 5 |
139540 | 139540 | 2020-05-13 | Hernando | Florida | 12053 | 101 | 5 |
136549 | 136549 | 2020-05-12 | Hernando | Florida | 12053 | 101 | 5 |
133560 | 133560 | 2020-05-11 | Hernando | Florida | 12053 | 101 | 5 |
130569 | 130569 | 2020-05-10 | Hernando | Florida | 12053 | 100 | 5 |
127578 | 127578 | 2020-05-09 | Hernando | Florida | 12053 | 98 | 5 |
124591 | 124591 | 2020-05-08 | Hernando | Florida | 12053 | 98 | 5 |
121612 | 121612 | 2020-05-07 | Hernando | Florida | 12053 | 97 | 5 |
118643 | 118643 | 2020-05-06 | Hernando | Florida | 12053 | 97 | 5 |
115683 | 115683 | 2020-05-05 | Hernando | Florida | 12053 | 96 | 5 |
112800 | 112800 | 2020-05-04 | Hernando | Florida | 12053 | 96 | 5 |
109925 | 109925 | 2020-05-03 | Hernando | Florida | 12053 | 94 | 5 |
107056 | 107056 | 2020-05-02 | Hernando | Florida | 12053 | 92 | 5 |
104191 | 104191 | 2020-05-01 | Hernando | Florida | 12053 | 92 | 5 |
101336 | 101336 | 2020-04-30 | Hernando | Florida | 12053 | 90 | 5 |
98486 | 98486 | 2020-04-29 | Hernando | Florida | 12053 | 89 | 4 |
95641 | 95641 | 2020-04-28 | Hernando | Florida | 12053 | 89 | 4 |
92809 | 92809 | 2020-04-27 | Hernando | Florida | 12053 | 89 | 4 |
89991 | 89991 | 2020-04-26 | Hernando | Florida | 12053 | 88 | 3 |
87174 | 87174 | 2020-04-25 | Hernando | Florida | 12053 | 89 | 3 |
84366 | 84366 | 2020-04-24 | Hernando | Florida | 12053 | 86 | 3 |
81566 | 81566 | 2020-04-23 | Hernando | Florida | 12053 | 83 | 3 |
78772 | 78772 | 2020-04-22 | Hernando | Florida | 12053 | 84 | 3 |
75988 | 75988 | 2020-04-21 | Hernando | Florida | 12053 | 84 | 3 |
73212 | 73212 | 2020-04-20 | Hernando | Florida | 12053 | 84 | 3 |
70443 | 70443 | 2020-04-19 | Hernando | Florida | 12053 | 84 | 3 |
67681 | 67681 | 2020-04-18 | Hernando | Florida | 12053 | 84 | 3 |
64933 | 64933 | 2020-04-17 | Hernando | Florida | 12053 | 83 | 2 |
62200 | 62200 | 2020-04-16 | Hernando | Florida | 12053 | 76 | 2 |
59481 | 59481 | 2020-04-15 | Hernando | Florida | 12053 | 76 | 2 |
56773 | 56773 | 2020-04-14 | Hernando | Florida | 12053 | 71 | 2 |
54081 | 54081 | 2020-04-13 | Hernando | Florida | 12053 | 71 | 2 |
51401 | 51401 | 2020-04-12 | Hernando | Florida | 12053 | 71 | 2 |
48740 | 48740 | 2020-04-11 | Hernando | Florida | 12053 | 69 | 2 |
46110 | 46110 | 2020-04-10 | Hernando | Florida | 12053 | 64 | 2 |
43509 | 43509 | 2020-04-09 | Hernando | Florida | 12053 | 62 | 1 |
40935 | 40935 | 2020-04-08 | Hernando | Florida | 12053 | 57 | 1 |
38392 | 38392 | 2020-04-07 | Hernando | Florida | 12053 | 51 | 1 |
35901 | 35901 | 2020-04-06 | Hernando | Florida | 12053 | 48 | 0 |
33455 | 33455 | 2020-04-05 | Hernando | Florida | 12053 | 43 | 0 |
31049 | 31049 | 2020-04-04 | Hernando | Florida | 12053 | 40 | 0 |
28690 | 28690 | 2020-04-03 | Hernando | Florida | 12053 | 38 | 0 |
26387 | 26387 | 2020-04-02 | Hernando | Florida | 12053 | 34 | 0 |
24157 | 24157 | 2020-04-01 | Hernando | Florida | 12053 | 28 | 0 |
21996 | 21996 | 2020-03-31 | Hernando | Florida | 12053 | 24 | 0 |
19918 | 19918 | 2020-03-30 | Hernando | Florida | 12053 | 21 | 0 |
17938 | 17938 | 2020-03-29 | Hernando | Florida | 12053 | 20 | 0 |
16045 | 16045 | 2020-03-28 | Hernando | Florida | 12053 | 14 | 0 |
14260 | 14260 | 2020-03-27 | Hernando | Florida | 12053 | 12 | 0 |
12591 | 12591 | 2020-03-26 | Hernando | Florida | 12053 | 9 | 0 |
11043 | 11043 | 2020-03-25 | Hernando | Florida | 12053 | 8 | 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);