ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Escambia" and state = "Florida" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
268545 | 268545 | 2020-06-24 | Escambia | Florida | 12033 | 1312 | 43 |
271681 | 271681 | 2020-06-25 | Escambia | Florida | 12033 | 1404 | 43 |
274821 | 274821 | 2020-06-26 | Escambia | Florida | 12033 | 1559 | 44 |
277969 | 277969 | 2020-06-27 | Escambia | Florida | 12033 | 1611 | 44 |
281116 | 281116 | 2020-06-28 | Escambia | Florida | 12033 | 1660 | 44 |
284262 | 284262 | 2020-06-29 | Escambia | Florida | 12033 | 1702 | 44 |
287408 | 287408 | 2020-06-30 | Escambia | Florida | 12033 | 1952 | 45 |
290559 | 290559 | 2020-07-01 | Escambia | Florida | 12033 | 2046 | 44 |
293713 | 293713 | 2020-07-02 | Escambia | Florida | 12033 | 2240 | 45 |
296869 | 296869 | 2020-07-03 | Escambia | Florida | 12033 | 2397 | 46 |
300031 | 300031 | 2020-07-04 | Escambia | Florida | 12033 | 2597 | 47 |
303195 | 303195 | 2020-07-05 | Escambia | Florida | 12033 | 2809 | 47 |
306359 | 306359 | 2020-07-06 | Escambia | Florida | 12033 | 2942 | 47 |
309527 | 309527 | 2020-07-07 | Escambia | Florida | 12033 | 3059 | 48 |
312697 | 312697 | 2020-07-08 | Escambia | Florida | 12033 | 3188 | 51 |
315872 | 315872 | 2020-07-09 | Escambia | Florida | 12033 | 3332 | 52 |
319045 | 319045 | 2020-07-10 | Escambia | Florida | 12033 | 3485 | 53 |
322224 | 322224 | 2020-07-11 | Escambia | Florida | 12033 | 3662 | 53 |
325405 | 325405 | 2020-07-12 | Escambia | Florida | 12033 | 4146 | 53 |
328591 | 328591 | 2020-07-13 | Escambia | Florida | 12033 | 4335 | 54 |
331778 | 331778 | 2020-07-14 | Escambia | Florida | 12033 | 4483 | 54 |
334971 | 334971 | 2020-07-15 | Escambia | Florida | 12033 | 4745 | 55 |
338166 | 338166 | 2020-07-16 | Escambia | Florida | 12033 | 5054 | 56 |
341363 | 341363 | 2020-07-17 | Escambia | Florida | 12033 | 5346 | 56 |
344562 | 344562 | 2020-07-18 | Escambia | Florida | 12033 | 5557 | 57 |
347762 | 347762 | 2020-07-19 | Escambia | Florida | 12033 | 5765 | 58 |
350963 | 350963 | 2020-07-20 | Escambia | Florida | 12033 | 5900 | 61 |
354165 | 354165 | 2020-07-21 | Escambia | Florida | 12033 | 6074 | 62 |
357368 | 357368 | 2020-07-22 | Escambia | Florida | 12033 | 6302 | 63 |
360573 | 360573 | 2020-07-23 | Escambia | Florida | 12033 | 6461 | 73 |
363780 | 363780 | 2020-07-24 | Escambia | Florida | 12033 | 6684 | 76 |
366987 | 366987 | 2020-07-25 | Escambia | Florida | 12033 | 6854 | 76 |
370197 | 370197 | 2020-07-26 | Escambia | Florida | 12033 | 7018 | 80 |
373409 | 373409 | 2020-07-27 | Escambia | Florida | 12033 | 7158 | 82 |
376623 | 376623 | 2020-07-28 | Escambia | Florida | 12033 | 7250 | 85 |
379840 | 379840 | 2020-07-29 | Escambia | Florida | 12033 | 7429 | 88 |
383057 | 383057 | 2020-07-30 | Escambia | Florida | 12033 | 7598 | 92 |
386275 | 386275 | 2020-07-31 | Escambia | Florida | 12033 | 7738 | 95 |
389492 | 389492 | 2020-08-01 | Escambia | Florida | 12033 | 7908 | 97 |
392709 | 392709 | 2020-08-02 | Escambia | Florida | 12033 | 8007 | 97 |
395925 | 395925 | 2020-08-03 | Escambia | Florida | 12033 | 8125 | 97 |
399141 | 399141 | 2020-08-04 | Escambia | Florida | 12033 | 8262 | 101 |
402357 | 402357 | 2020-08-05 | Escambia | Florida | 12033 | 8367 | 107 |
405575 | 405575 | 2020-08-06 | Escambia | Florida | 12033 | 8515 | 111 |
408795 | 408795 | 2020-08-07 | Escambia | Florida | 12033 | 8757 | 115 |
412014 | 412014 | 2020-08-08 | Escambia | Florida | 12033 | 9297 | 120 |
415234 | 415234 | 2020-08-09 | Escambia | Florida | 12033 | 9508 | 120 |
418455 | 418455 | 2020-08-10 | Escambia | Florida | 12033 | 9632 | 120 |
421676 | 421676 | 2020-08-11 | Escambia | Florida | 12033 | 9807 | 131 |
424897 | 424897 | 2020-08-12 | Escambia | Florida | 12033 | 9929 | 137 |
428121 | 428121 | 2020-08-13 | Escambia | Florida | 12033 | 10035 | 141 |
431349 | 431349 | 2020-08-14 | Escambia | Florida | 12033 | 10122 | 147 |
434574 | 434574 | 2020-08-15 | Escambia | Florida | 12033 | 10205 | 150 |
437800 | 437800 | 2020-08-16 | Escambia | Florida | 12033 | 10265 | 152 |
441026 | 441026 | 2020-08-17 | Escambia | Florida | 12033 | 10317 | 152 |
444252 | 444252 | 2020-08-18 | Escambia | Florida | 12033 | 10405 | 159 |
447479 | 447479 | 2020-08-19 | Escambia | Florida | 12033 | 10499 | 164 |
450707 | 450707 | 2020-08-20 | Escambia | Florida | 12033 | 10595 | 170 |
453935 | 453935 | 2020-08-21 | Escambia | Florida | 12033 | 10684 | 171 |
457163 | 457163 | 2020-08-22 | Escambia | Florida | 12033 | 10752 | 171 |
460390 | 460390 | 2020-08-23 | Escambia | Florida | 12033 | 10790 | 171 |
463619 | 463619 | 2020-08-24 | Escambia | Florida | 12033 | 10832 | 171 |
466848 | 466848 | 2020-08-25 | Escambia | Florida | 12033 | 10871 | 178 |
470077 | 470077 | 2020-08-26 | Escambia | Florida | 12033 | 10944 | 179 |
473309 | 473309 | 2020-08-27 | Escambia | Florida | 12033 | 10999 | 183 |
476542 | 476542 | 2020-08-28 | Escambia | Florida | 12033 | 11066 | 184 |
479775 | 479775 | 2020-08-29 | Escambia | Florida | 12033 | 11121 | 186 |
483009 | 483009 | 2020-08-30 | Escambia | Florida | 12033 | 11151 | 186 |
486244 | 486244 | 2020-08-31 | Escambia | Florida | 12033 | 11183 | 186 |
489477 | 489477 | 2020-09-01 | Escambia | Florida | 12033 | 11256 | 188 |
492710 | 492710 | 2020-09-02 | Escambia | Florida | 12033 | 11312 | 189 |
495944 | 495944 | 2020-09-03 | Escambia | Florida | 12033 | 11360 | 190 |
499177 | 499177 | 2020-09-04 | Escambia | Florida | 12033 | 11418 | 192 |
502411 | 502411 | 2020-09-05 | Escambia | Florida | 12033 | 11482 | 193 |
505645 | 505645 | 2020-09-06 | Escambia | Florida | 12033 | 11521 | 193 |
508877 | 508877 | 2020-09-07 | Escambia | Florida | 12033 | 11544 | 193 |
512110 | 512110 | 2020-09-08 | Escambia | Florida | 12033 | 11575 | 193 |
515343 | 515343 | 2020-09-09 | Escambia | Florida | 12033 | 11634 | 194 |
518578 | 518578 | 2020-09-10 | Escambia | Florida | 12033 | 11702 | 200 |
521815 | 521815 | 2020-09-11 | Escambia | Florida | 12033 | 11766 | 203 |
525051 | 525051 | 2020-09-12 | Escambia | Florida | 12033 | 11818 | 203 |
528287 | 528287 | 2020-09-13 | Escambia | Florida | 12033 | 11867 | 203 |
531524 | 531524 | 2020-09-14 | Escambia | Florida | 12033 | 11891 | 204 |
534759 | 534759 | 2020-09-15 | Escambia | Florida | 12033 | 11944 | 210 |
537995 | 537995 | 2020-09-16 | Escambia | Florida | 12033 | 11973 | 213 |
541232 | 541232 | 2020-09-17 | Escambia | Florida | 12033 | 11991 | 215 |
544468 | 544468 | 2020-09-18 | Escambia | Florida | 12033 | 11996 | 217 |
547706 | 547706 | 2020-09-19 | Escambia | Florida | 12033 | 12015 | 217 |
550945 | 550945 | 2020-09-20 | Escambia | Florida | 12033 | 12033 | 217 |
554184 | 554184 | 2020-09-21 | Escambia | Florida | 12033 | 12043 | 217 |
557421 | 557421 | 2020-09-22 | Escambia | Florida | 12033 | 12069 | 218 |
560657 | 560657 | 2020-09-23 | Escambia | Florida | 12033 | 12103 | 222 |
563897 | 563897 | 2020-09-24 | Escambia | Florida | 12033 | 12142 | 228 |
567137 | 567137 | 2020-09-25 | Escambia | Florida | 12033 | 12181 | 228 |
570379 | 570379 | 2020-09-26 | Escambia | Florida | 12033 | 12219 | 228 |
573621 | 573621 | 2020-09-27 | Escambia | Florida | 12033 | 12243 | 228 |
576864 | 576864 | 2020-09-28 | Escambia | Florida | 12033 | 12249 | 228 |
580105 | 580105 | 2020-09-29 | Escambia | Florida | 12033 | 12319 | 230 |
583344 | 583344 | 2020-09-30 | Escambia | Florida | 12033 | 12353 | 235 |
586584 | 586584 | 2020-10-01 | Escambia | Florida | 12033 | 12393 | 237 |
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);