ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Jackson" and fips = 12063 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386290 | 386290 | 2020-07-31 | Jackson | Florida | 12063 | 1566 | 31 |
383072 | 383072 | 2020-07-30 | Jackson | Florida | 12063 | 1553 | 28 |
379855 | 379855 | 2020-07-29 | Jackson | Florida | 12063 | 1544 | 26 |
376638 | 376638 | 2020-07-28 | Jackson | Florida | 12063 | 1297 | 26 |
373424 | 373424 | 2020-07-27 | Jackson | Florida | 12063 | 1270 | 19 |
370212 | 370212 | 2020-07-26 | Jackson | Florida | 12063 | 1266 | 18 |
367002 | 367002 | 2020-07-25 | Jackson | Florida | 12063 | 1220 | 18 |
363795 | 363795 | 2020-07-24 | Jackson | Florida | 12063 | 979 | 17 |
360588 | 360588 | 2020-07-23 | Jackson | Florida | 12063 | 963 | 17 |
357383 | 357383 | 2020-07-22 | Jackson | Florida | 12063 | 916 | 15 |
354180 | 354180 | 2020-07-21 | Jackson | Florida | 12063 | 887 | 15 |
350978 | 350978 | 2020-07-20 | Jackson | Florida | 12063 | 857 | 12 |
347777 | 347777 | 2020-07-19 | Jackson | Florida | 12063 | 831 | 10 |
344577 | 344577 | 2020-07-18 | Jackson | Florida | 12063 | 769 | 10 |
341378 | 341378 | 2020-07-17 | Jackson | Florida | 12063 | 756 | 7 |
338181 | 338181 | 2020-07-16 | Jackson | Florida | 12063 | 682 | 6 |
334986 | 334986 | 2020-07-15 | Jackson | Florida | 12063 | 675 | 5 |
331793 | 331793 | 2020-07-14 | Jackson | Florida | 12063 | 652 | 2 |
328606 | 328606 | 2020-07-13 | Jackson | Florida | 12063 | 632 | 2 |
325420 | 325420 | 2020-07-12 | Jackson | Florida | 12063 | 587 | 2 |
322239 | 322239 | 2020-07-11 | Jackson | Florida | 12063 | 581 | 2 |
319060 | 319060 | 2020-07-10 | Jackson | Florida | 12063 | 556 | 2 |
315887 | 315887 | 2020-07-09 | Jackson | Florida | 12063 | 517 | 2 |
312712 | 312712 | 2020-07-08 | Jackson | Florida | 12063 | 504 | 2 |
309542 | 309542 | 2020-07-07 | Jackson | Florida | 12063 | 415 | 2 |
306374 | 306374 | 2020-07-06 | Jackson | Florida | 12063 | 411 | 2 |
303210 | 303210 | 2020-07-05 | Jackson | Florida | 12063 | 406 | 2 |
300046 | 300046 | 2020-07-04 | Jackson | Florida | 12063 | 401 | 2 |
296884 | 296884 | 2020-07-03 | Jackson | Florida | 12063 | 394 | 2 |
293728 | 293728 | 2020-07-02 | Jackson | Florida | 12063 | 381 | 2 |
290574 | 290574 | 2020-07-01 | Jackson | Florida | 12063 | 365 | 2 |
287423 | 287423 | 2020-06-30 | Jackson | Florida | 12063 | 363 | 2 |
284277 | 284277 | 2020-06-29 | Jackson | Florida | 12063 | 359 | 2 |
281131 | 281131 | 2020-06-28 | Jackson | Florida | 12063 | 359 | 2 |
277984 | 277984 | 2020-06-27 | Jackson | Florida | 12063 | 353 | 2 |
274836 | 274836 | 2020-06-26 | Jackson | Florida | 12063 | 350 | 2 |
271696 | 271696 | 2020-06-25 | Jackson | Florida | 12063 | 347 | 2 |
268560 | 268560 | 2020-06-24 | Jackson | Florida | 12063 | 342 | 2 |
265430 | 265430 | 2020-06-23 | Jackson | Florida | 12063 | 341 | 2 |
262302 | 262302 | 2020-06-22 | Jackson | Florida | 12063 | 338 | 2 |
259175 | 259175 | 2020-06-21 | Jackson | Florida | 12063 | 333 | 2 |
256048 | 256048 | 2020-06-20 | Jackson | Florida | 12063 | 330 | 2 |
252929 | 252929 | 2020-06-19 | Jackson | Florida | 12063 | 329 | 2 |
249814 | 249814 | 2020-06-18 | Jackson | Florida | 12063 | 327 | 2 |
246702 | 246702 | 2020-06-17 | Jackson | Florida | 12063 | 329 | 2 |
243589 | 243589 | 2020-06-16 | Jackson | Florida | 12063 | 326 | 1 |
240478 | 240478 | 2020-06-15 | Jackson | Florida | 12063 | 320 | 1 |
237370 | 237370 | 2020-06-14 | Jackson | Florida | 12063 | 319 | 1 |
234263 | 234263 | 2020-06-13 | Jackson | Florida | 12063 | 318 | 1 |
231157 | 231157 | 2020-06-12 | Jackson | Florida | 12063 | 316 | 1 |
228054 | 228054 | 2020-06-11 | Jackson | Florida | 12063 | 315 | 1 |
224952 | 224952 | 2020-06-10 | Jackson | Florida | 12063 | 311 | 1 |
221857 | 221857 | 2020-06-09 | Jackson | Florida | 12063 | 310 | 1 |
218762 | 218762 | 2020-06-08 | Jackson | Florida | 12063 | 309 | 1 |
215671 | 215671 | 2020-06-07 | Jackson | Florida | 12063 | 308 | 1 |
212584 | 212584 | 2020-06-06 | Jackson | Florida | 12063 | 298 | 1 |
209499 | 209499 | 2020-06-05 | Jackson | Florida | 12063 | 298 | 1 |
206418 | 206418 | 2020-06-04 | Jackson | Florida | 12063 | 290 | 1 |
203338 | 203338 | 2020-06-03 | Jackson | Florida | 12063 | 269 | 1 |
200262 | 200262 | 2020-06-02 | Jackson | Florida | 12063 | 266 | 1 |
197189 | 197189 | 2020-06-01 | Jackson | Florida | 12063 | 256 | 1 |
194119 | 194119 | 2020-05-31 | Jackson | Florida | 12063 | 251 | 1 |
191052 | 191052 | 2020-05-30 | Jackson | Florida | 12063 | 249 | 1 |
187987 | 187987 | 2020-05-29 | Jackson | Florida | 12063 | 248 | 1 |
184931 | 184931 | 2020-05-28 | Jackson | Florida | 12063 | 241 | 0 |
181877 | 181877 | 2020-05-27 | Jackson | Florida | 12063 | 240 | 0 |
178833 | 178833 | 2020-05-26 | Jackson | Florida | 12063 | 239 | 0 |
175789 | 175789 | 2020-05-25 | Jackson | Florida | 12063 | 238 | 0 |
172746 | 172746 | 2020-05-24 | Jackson | Florida | 12063 | 230 | 0 |
169705 | 169705 | 2020-05-23 | Jackson | Florida | 12063 | 225 | 0 |
166668 | 166668 | 2020-05-22 | Jackson | Florida | 12063 | 219 | 0 |
163635 | 163635 | 2020-05-21 | Jackson | Florida | 12063 | 173 | 0 |
160607 | 160607 | 2020-05-20 | Jackson | Florida | 12063 | 171 | 0 |
157581 | 157581 | 2020-05-19 | Jackson | Florida | 12063 | 148 | 0 |
154565 | 154565 | 2020-05-18 | Jackson | Florida | 12063 | 131 | 0 |
151553 | 151553 | 2020-05-17 | Jackson | Florida | 12063 | 129 | 0 |
148544 | 148544 | 2020-05-16 | Jackson | Florida | 12063 | 126 | 0 |
145541 | 145541 | 2020-05-15 | Jackson | Florida | 12063 | 125 | 0 |
142541 | 142541 | 2020-05-14 | Jackson | Florida | 12063 | 105 | 0 |
139545 | 139545 | 2020-05-13 | Jackson | Florida | 12063 | 106 | 0 |
136554 | 136554 | 2020-05-12 | Jackson | Florida | 12063 | 131 | 0 |
133565 | 133565 | 2020-05-11 | Jackson | Florida | 12063 | 97 | 0 |
130574 | 130574 | 2020-05-10 | Jackson | Florida | 12063 | 91 | 0 |
127583 | 127583 | 2020-05-09 | Jackson | Florida | 12063 | 72 | 0 |
124596 | 124596 | 2020-05-08 | Jackson | Florida | 12063 | 74 | 0 |
121617 | 121617 | 2020-05-07 | Jackson | Florida | 12063 | 31 | 0 |
118648 | 118648 | 2020-05-06 | Jackson | Florida | 12063 | 23 | 0 |
115688 | 115688 | 2020-05-05 | Jackson | Florida | 12063 | 15 | 0 |
112805 | 112805 | 2020-05-04 | Jackson | Florida | 12063 | 15 | 0 |
109930 | 109930 | 2020-05-03 | Jackson | Florida | 12063 | 15 | 0 |
107061 | 107061 | 2020-05-02 | Jackson | Florida | 12063 | 14 | 0 |
104196 | 104196 | 2020-05-01 | Jackson | Florida | 12063 | 14 | 0 |
101341 | 101341 | 2020-04-30 | Jackson | Florida | 12063 | 14 | 0 |
98491 | 98491 | 2020-04-29 | Jackson | Florida | 12063 | 14 | 0 |
95646 | 95646 | 2020-04-28 | Jackson | Florida | 12063 | 13 | 0 |
92814 | 92814 | 2020-04-27 | Jackson | Florida | 12063 | 13 | 0 |
89996 | 89996 | 2020-04-26 | Jackson | Florida | 12063 | 13 | 0 |
87179 | 87179 | 2020-04-25 | Jackson | Florida | 12063 | 13 | 0 |
84371 | 84371 | 2020-04-24 | Jackson | Florida | 12063 | 13 | 0 |
81571 | 81571 | 2020-04-23 | Jackson | Florida | 12063 | 13 | 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);