ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Citrus" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293706 | 293706 | 2020-07-02 | Citrus | Florida | 12017 | 345 | 13 |
290552 | 290552 | 2020-07-01 | Citrus | Florida | 12017 | 323 | 13 |
287401 | 287401 | 2020-06-30 | Citrus | Florida | 12017 | 291 | 13 |
284255 | 284255 | 2020-06-29 | Citrus | Florida | 12017 | 284 | 13 |
281109 | 281109 | 2020-06-28 | Citrus | Florida | 12017 | 277 | 12 |
277962 | 277962 | 2020-06-27 | Citrus | Florida | 12017 | 264 | 12 |
274814 | 274814 | 2020-06-26 | Citrus | Florida | 12017 | 240 | 12 |
271674 | 271674 | 2020-06-25 | Citrus | Florida | 12017 | 226 | 12 |
268538 | 268538 | 2020-06-24 | Citrus | Florida | 12017 | 219 | 12 |
265408 | 265408 | 2020-06-23 | Citrus | Florida | 12017 | 204 | 12 |
262280 | 262280 | 2020-06-22 | Citrus | Florida | 12017 | 199 | 12 |
259153 | 259153 | 2020-06-21 | Citrus | Florida | 12017 | 189 | 12 |
256026 | 256026 | 2020-06-20 | Citrus | Florida | 12017 | 183 | 12 |
252907 | 252907 | 2020-06-19 | Citrus | Florida | 12017 | 168 | 12 |
249792 | 249792 | 2020-06-18 | Citrus | Florida | 12017 | 162 | 12 |
246680 | 246680 | 2020-06-17 | Citrus | Florida | 12017 | 157 | 12 |
243567 | 243567 | 2020-06-16 | Citrus | Florida | 12017 | 152 | 12 |
240456 | 240456 | 2020-06-15 | Citrus | Florida | 12017 | 150 | 12 |
237348 | 237348 | 2020-06-14 | Citrus | Florida | 12017 | 143 | 12 |
234241 | 234241 | 2020-06-13 | Citrus | Florida | 12017 | 140 | 12 |
231135 | 231135 | 2020-06-12 | Citrus | Florida | 12017 | 135 | 12 |
228032 | 228032 | 2020-06-11 | Citrus | Florida | 12017 | 132 | 12 |
224930 | 224930 | 2020-06-10 | Citrus | Florida | 12017 | 130 | 12 |
221835 | 221835 | 2020-06-09 | Citrus | Florida | 12017 | 128 | 12 |
218740 | 218740 | 2020-06-08 | Citrus | Florida | 12017 | 128 | 12 |
215649 | 215649 | 2020-06-07 | Citrus | Florida | 12017 | 128 | 12 |
212562 | 212562 | 2020-06-06 | Citrus | Florida | 12017 | 125 | 12 |
209477 | 209477 | 2020-06-05 | Citrus | Florida | 12017 | 125 | 12 |
206396 | 206396 | 2020-06-04 | Citrus | Florida | 12017 | 122 | 12 |
203316 | 203316 | 2020-06-03 | Citrus | Florida | 12017 | 122 | 12 |
200240 | 200240 | 2020-06-02 | Citrus | Florida | 12017 | 122 | 12 |
197167 | 197167 | 2020-06-01 | Citrus | Florida | 12017 | 122 | 12 |
194097 | 194097 | 2020-05-31 | Citrus | Florida | 12017 | 121 | 12 |
191030 | 191030 | 2020-05-30 | Citrus | Florida | 12017 | 121 | 12 |
187965 | 187965 | 2020-05-29 | Citrus | Florida | 12017 | 120 | 12 |
184909 | 184909 | 2020-05-28 | Citrus | Florida | 12017 | 119 | 12 |
181855 | 181855 | 2020-05-27 | Citrus | Florida | 12017 | 119 | 12 |
178811 | 178811 | 2020-05-26 | Citrus | Florida | 12017 | 119 | 12 |
175767 | 175767 | 2020-05-25 | Citrus | Florida | 12017 | 119 | 12 |
172724 | 172724 | 2020-05-24 | Citrus | Florida | 12017 | 119 | 12 |
169683 | 169683 | 2020-05-23 | Citrus | Florida | 12017 | 119 | 12 |
166646 | 166646 | 2020-05-22 | Citrus | Florida | 12017 | 118 | 12 |
163613 | 163613 | 2020-05-21 | Citrus | Florida | 12017 | 115 | 12 |
160585 | 160585 | 2020-05-20 | Citrus | Florida | 12017 | 115 | 12 |
157559 | 157559 | 2020-05-19 | Citrus | Florida | 12017 | 114 | 12 |
154543 | 154543 | 2020-05-18 | Citrus | Florida | 12017 | 112 | 12 |
151531 | 151531 | 2020-05-17 | Citrus | Florida | 12017 | 112 | 12 |
148522 | 148522 | 2020-05-16 | Citrus | Florida | 12017 | 110 | 11 |
145519 | 145519 | 2020-05-15 | Citrus | Florida | 12017 | 110 | 11 |
142519 | 142519 | 2020-05-14 | Citrus | Florida | 12017 | 109 | 11 |
139523 | 139523 | 2020-05-13 | Citrus | Florida | 12017 | 109 | 11 |
136532 | 136532 | 2020-05-12 | Citrus | Florida | 12017 | 107 | 11 |
133543 | 133543 | 2020-05-11 | Citrus | Florida | 12017 | 106 | 11 |
130552 | 130552 | 2020-05-10 | Citrus | Florida | 12017 | 106 | 11 |
127561 | 127561 | 2020-05-09 | Citrus | Florida | 12017 | 104 | 11 |
124574 | 124574 | 2020-05-08 | Citrus | Florida | 12017 | 102 | 11 |
121595 | 121595 | 2020-05-07 | Citrus | Florida | 12017 | 102 | 11 |
118626 | 118626 | 2020-05-06 | Citrus | Florida | 12017 | 101 | 11 |
115666 | 115666 | 2020-05-05 | Citrus | Florida | 12017 | 100 | 11 |
112783 | 112783 | 2020-05-04 | Citrus | Florida | 12017 | 99 | 11 |
109908 | 109908 | 2020-05-03 | Citrus | Florida | 12017 | 99 | 11 |
107039 | 107039 | 2020-05-02 | Citrus | Florida | 12017 | 99 | 11 |
104174 | 104174 | 2020-05-01 | Citrus | Florida | 12017 | 99 | 11 |
101319 | 101319 | 2020-04-30 | Citrus | Florida | 12017 | 99 | 11 |
98469 | 98469 | 2020-04-29 | Citrus | Florida | 12017 | 97 | 11 |
95624 | 95624 | 2020-04-28 | Citrus | Florida | 12017 | 97 | 11 |
92792 | 92792 | 2020-04-27 | Citrus | Florida | 12017 | 97 | 11 |
89974 | 89974 | 2020-04-26 | Citrus | Florida | 12017 | 97 | 11 |
87157 | 87157 | 2020-04-25 | Citrus | Florida | 12017 | 95 | 9 |
84349 | 84349 | 2020-04-24 | Citrus | Florida | 12017 | 95 | 9 |
81549 | 81549 | 2020-04-23 | Citrus | Florida | 12017 | 94 | 9 |
78755 | 78755 | 2020-04-22 | Citrus | Florida | 12017 | 92 | 8 |
75971 | 75971 | 2020-04-21 | Citrus | Florida | 12017 | 92 | 8 |
73195 | 73195 | 2020-04-20 | Citrus | Florida | 12017 | 86 | 8 |
70426 | 70426 | 2020-04-19 | Citrus | Florida | 12017 | 84 | 8 |
67664 | 67664 | 2020-04-18 | Citrus | Florida | 12017 | 82 | 8 |
64916 | 64916 | 2020-04-17 | Citrus | Florida | 12017 | 82 | 8 |
62183 | 62183 | 2020-04-16 | Citrus | Florida | 12017 | 80 | 8 |
59464 | 59464 | 2020-04-15 | Citrus | Florida | 12017 | 74 | 8 |
56756 | 56756 | 2020-04-14 | Citrus | Florida | 12017 | 75 | 7 |
54064 | 54064 | 2020-04-13 | Citrus | Florida | 12017 | 72 | 7 |
51384 | 51384 | 2020-04-12 | Citrus | Florida | 12017 | 71 | 6 |
48723 | 48723 | 2020-04-11 | Citrus | Florida | 12017 | 67 | 6 |
46093 | 46093 | 2020-04-10 | Citrus | Florida | 12017 | 64 | 6 |
43492 | 43492 | 2020-04-09 | Citrus | Florida | 12017 | 58 | 6 |
40918 | 40918 | 2020-04-08 | Citrus | Florida | 12017 | 55 | 5 |
38375 | 38375 | 2020-04-07 | Citrus | Florida | 12017 | 51 | 2 |
35885 | 35885 | 2020-04-06 | Citrus | Florida | 12017 | 46 | 2 |
33440 | 33440 | 2020-04-05 | Citrus | Florida | 12017 | 43 | 2 |
31034 | 31034 | 2020-04-04 | Citrus | Florida | 12017 | 34 | 2 |
28676 | 28676 | 2020-04-03 | Citrus | Florida | 12017 | 28 | 2 |
26374 | 26374 | 2020-04-02 | Citrus | Florida | 12017 | 27 | 2 |
24144 | 24144 | 2020-04-01 | Citrus | Florida | 12017 | 23 | 2 |
21985 | 21985 | 2020-03-31 | Citrus | Florida | 12017 | 19 | 2 |
19907 | 19907 | 2020-03-30 | Citrus | Florida | 12017 | 17 | 2 |
17927 | 17927 | 2020-03-29 | Citrus | Florida | 12017 | 16 | 1 |
16035 | 16035 | 2020-03-28 | Citrus | Florida | 12017 | 15 | 1 |
14251 | 14251 | 2020-03-27 | Citrus | Florida | 12017 | 11 | 1 |
12582 | 12582 | 2020-03-26 | Citrus | Florida | 12017 | 11 | 1 |
11034 | 11034 | 2020-03-25 | Citrus | Florida | 12017 | 9 | 1 |
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);