ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Santa Rosa" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534798 | 534798 | 2020-09-15 | Santa Rosa | Florida | 12113 | 5157 | 69 |
531563 | 531563 | 2020-09-14 | Santa Rosa | Florida | 12113 | 5139 | 66 |
528326 | 528326 | 2020-09-13 | Santa Rosa | Florida | 12113 | 5126 | 66 |
525090 | 525090 | 2020-09-12 | Santa Rosa | Florida | 12113 | 5103 | 66 |
521854 | 521854 | 2020-09-11 | Santa Rosa | Florida | 12113 | 5087 | 65 |
518617 | 518617 | 2020-09-10 | Santa Rosa | Florida | 12113 | 5026 | 63 |
515382 | 515382 | 2020-09-09 | Santa Rosa | Florida | 12113 | 4990 | 60 |
512149 | 512149 | 2020-09-08 | Santa Rosa | Florida | 12113 | 4958 | 59 |
508916 | 508916 | 2020-09-07 | Santa Rosa | Florida | 12113 | 4950 | 59 |
505684 | 505684 | 2020-09-06 | Santa Rosa | Florida | 12113 | 4936 | 59 |
502450 | 502450 | 2020-09-05 | Santa Rosa | Florida | 12113 | 4891 | 59 |
499216 | 499216 | 2020-09-04 | Santa Rosa | Florida | 12113 | 4845 | 59 |
495983 | 495983 | 2020-09-03 | Santa Rosa | Florida | 12113 | 4812 | 58 |
492749 | 492749 | 2020-09-02 | Santa Rosa | Florida | 12113 | 4763 | 58 |
489516 | 489516 | 2020-09-01 | Santa Rosa | Florida | 12113 | 4714 | 57 |
486283 | 486283 | 2020-08-31 | Santa Rosa | Florida | 12113 | 4671 | 55 |
483048 | 483048 | 2020-08-30 | Santa Rosa | Florida | 12113 | 4659 | 55 |
479814 | 479814 | 2020-08-29 | Santa Rosa | Florida | 12113 | 4634 | 55 |
476581 | 476581 | 2020-08-28 | Santa Rosa | Florida | 12113 | 4592 | 55 |
473348 | 473348 | 2020-08-27 | Santa Rosa | Florida | 12113 | 4566 | 55 |
470116 | 470116 | 2020-08-26 | Santa Rosa | Florida | 12113 | 4523 | 54 |
466887 | 466887 | 2020-08-25 | Santa Rosa | Florida | 12113 | 4483 | 54 |
463658 | 463658 | 2020-08-24 | Santa Rosa | Florida | 12113 | 4462 | 54 |
460429 | 460429 | 2020-08-23 | Santa Rosa | Florida | 12113 | 4443 | 54 |
457202 | 457202 | 2020-08-22 | Santa Rosa | Florida | 12113 | 4418 | 54 |
453974 | 453974 | 2020-08-21 | Santa Rosa | Florida | 12113 | 4385 | 53 |
450746 | 450746 | 2020-08-20 | Santa Rosa | Florida | 12113 | 4341 | 53 |
447518 | 447518 | 2020-08-19 | Santa Rosa | Florida | 12113 | 4303 | 50 |
444291 | 444291 | 2020-08-18 | Santa Rosa | Florida | 12113 | 4264 | 50 |
441065 | 441065 | 2020-08-17 | Santa Rosa | Florida | 12113 | 4237 | 47 |
437839 | 437839 | 2020-08-16 | Santa Rosa | Florida | 12113 | 4223 | 47 |
434613 | 434613 | 2020-08-15 | Santa Rosa | Florida | 12113 | 4173 | 47 |
431388 | 431388 | 2020-08-14 | Santa Rosa | Florida | 12113 | 4125 | 45 |
428160 | 428160 | 2020-08-13 | Santa Rosa | Florida | 12113 | 4088 | 44 |
424936 | 424936 | 2020-08-12 | Santa Rosa | Florida | 12113 | 4053 | 41 |
421715 | 421715 | 2020-08-11 | Santa Rosa | Florida | 12113 | 4013 | 40 |
418494 | 418494 | 2020-08-10 | Santa Rosa | Florida | 12113 | 3963 | 38 |
415273 | 415273 | 2020-08-09 | Santa Rosa | Florida | 12113 | 3939 | 37 |
412053 | 412053 | 2020-08-08 | Santa Rosa | Florida | 12113 | 3857 | 37 |
408834 | 408834 | 2020-08-07 | Santa Rosa | Florida | 12113 | 3791 | 36 |
405614 | 405614 | 2020-08-06 | Santa Rosa | Florida | 12113 | 3700 | 34 |
402396 | 402396 | 2020-08-05 | Santa Rosa | Florida | 12113 | 3610 | 32 |
399180 | 399180 | 2020-08-04 | Santa Rosa | Florida | 12113 | 3552 | 30 |
395964 | 395964 | 2020-08-03 | Santa Rosa | Florida | 12113 | 3484 | 24 |
392748 | 392748 | 2020-08-02 | Santa Rosa | Florida | 12113 | 3454 | 24 |
389531 | 389531 | 2020-08-01 | Santa Rosa | Florida | 12113 | 3399 | 24 |
386314 | 386314 | 2020-07-31 | Santa Rosa | Florida | 12113 | 3336 | 22 |
383096 | 383096 | 2020-07-30 | Santa Rosa | Florida | 12113 | 3279 | 22 |
379879 | 379879 | 2020-07-29 | Santa Rosa | Florida | 12113 | 3125 | 22 |
376662 | 376662 | 2020-07-28 | Santa Rosa | Florida | 12113 | 2945 | 22 |
373448 | 373448 | 2020-07-27 | Santa Rosa | Florida | 12113 | 2789 | 19 |
370236 | 370236 | 2020-07-26 | Santa Rosa | Florida | 12113 | 2507 | 19 |
367026 | 367026 | 2020-07-25 | Santa Rosa | Florida | 12113 | 2365 | 19 |
363819 | 363819 | 2020-07-24 | Santa Rosa | Florida | 12113 | 2288 | 19 |
360612 | 360612 | 2020-07-23 | Santa Rosa | Florida | 12113 | 2147 | 19 |
357407 | 357407 | 2020-07-22 | Santa Rosa | Florida | 12113 | 2090 | 18 |
354204 | 354204 | 2020-07-21 | Santa Rosa | Florida | 12113 | 2018 | 17 |
351002 | 351002 | 2020-07-20 | Santa Rosa | Florida | 12113 | 1976 | 15 |
347801 | 347801 | 2020-07-19 | Santa Rosa | Florida | 12113 | 1909 | 15 |
344601 | 344601 | 2020-07-18 | Santa Rosa | Florida | 12113 | 1822 | 13 |
341402 | 341402 | 2020-07-17 | Santa Rosa | Florida | 12113 | 1740 | 13 |
338205 | 338205 | 2020-07-16 | Santa Rosa | Florida | 12113 | 1663 | 12 |
335010 | 335010 | 2020-07-15 | Santa Rosa | Florida | 12113 | 1523 | 11 |
331817 | 331817 | 2020-07-14 | Santa Rosa | Florida | 12113 | 1412 | 11 |
328630 | 328630 | 2020-07-13 | Santa Rosa | Florida | 12113 | 1379 | 11 |
325444 | 325444 | 2020-07-12 | Santa Rosa | Florida | 12113 | 1331 | 11 |
322263 | 322263 | 2020-07-11 | Santa Rosa | Florida | 12113 | 1142 | 11 |
319084 | 319084 | 2020-07-10 | Santa Rosa | Florida | 12113 | 1085 | 10 |
315911 | 315911 | 2020-07-09 | Santa Rosa | Florida | 12113 | 1033 | 10 |
312736 | 312736 | 2020-07-08 | Santa Rosa | Florida | 12113 | 993 | 10 |
309566 | 309566 | 2020-07-07 | Santa Rosa | Florida | 12113 | 941 | 9 |
306398 | 306398 | 2020-07-06 | Santa Rosa | Florida | 12113 | 902 | 9 |
303234 | 303234 | 2020-07-05 | Santa Rosa | Florida | 12113 | 867 | 9 |
300070 | 300070 | 2020-07-04 | Santa Rosa | Florida | 12113 | 815 | 9 |
296908 | 296908 | 2020-07-03 | Santa Rosa | Florida | 12113 | 743 | 9 |
293752 | 293752 | 2020-07-02 | Santa Rosa | Florida | 12113 | 676 | 9 |
290598 | 290598 | 2020-07-01 | Santa Rosa | Florida | 12113 | 617 | 9 |
287447 | 287447 | 2020-06-30 | Santa Rosa | Florida | 12113 | 593 | 9 |
284301 | 284301 | 2020-06-29 | Santa Rosa | Florida | 12113 | 482 | 9 |
281155 | 281155 | 2020-06-28 | Santa Rosa | Florida | 12113 | 468 | 9 |
278008 | 278008 | 2020-06-27 | Santa Rosa | Florida | 12113 | 442 | 9 |
274860 | 274860 | 2020-06-26 | Santa Rosa | Florida | 12113 | 437 | 9 |
271720 | 271720 | 2020-06-25 | Santa Rosa | Florida | 12113 | 411 | 9 |
268584 | 268584 | 2020-06-24 | Santa Rosa | Florida | 12113 | 371 | 9 |
265454 | 265454 | 2020-06-23 | Santa Rosa | Florida | 12113 | 355 | 9 |
262326 | 262326 | 2020-06-22 | Santa Rosa | Florida | 12113 | 350 | 9 |
259199 | 259199 | 2020-06-21 | Santa Rosa | Florida | 12113 | 344 | 9 |
256072 | 256072 | 2020-06-20 | Santa Rosa | Florida | 12113 | 342 | 9 |
252953 | 252953 | 2020-06-19 | Santa Rosa | Florida | 12113 | 330 | 9 |
249838 | 249838 | 2020-06-18 | Santa Rosa | Florida | 12113 | 319 | 9 |
246726 | 246726 | 2020-06-17 | Santa Rosa | Florida | 12113 | 305 | 9 |
243613 | 243613 | 2020-06-16 | Santa Rosa | Florida | 12113 | 297 | 9 |
240502 | 240502 | 2020-06-15 | Santa Rosa | Florida | 12113 | 293 | 9 |
237394 | 237394 | 2020-06-14 | Santa Rosa | Florida | 12113 | 291 | 9 |
234287 | 234287 | 2020-06-13 | Santa Rosa | Florida | 12113 | 285 | 9 |
231181 | 231181 | 2020-06-12 | Santa Rosa | Florida | 12113 | 275 | 9 |
228078 | 228078 | 2020-06-11 | Santa Rosa | Florida | 12113 | 273 | 9 |
224976 | 224976 | 2020-06-10 | Santa Rosa | Florida | 12113 | 262 | 9 |
221881 | 221881 | 2020-06-09 | Santa Rosa | Florida | 12113 | 261 | 9 |
218786 | 218786 | 2020-06-08 | Santa Rosa | Florida | 12113 | 258 | 9 |
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);