ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where fips = 12057 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
599562 | 599562 | 2020-10-05 | Hillsborough | Florida | 12057 | 43027 | 673 |
596319 | 596319 | 2020-10-04 | Hillsborough | Florida | 12057 | 42891 | 671 |
593077 | 593077 | 2020-10-03 | Hillsborough | Florida | 12057 | 42765 | 668 |
589837 | 589837 | 2020-10-02 | Hillsborough | Florida | 12057 | 42565 | 660 |
586596 | 586596 | 2020-10-01 | Hillsborough | Florida | 12057 | 42380 | 654 |
583356 | 583356 | 2020-09-30 | Hillsborough | Florida | 12057 | 42248 | 646 |
580117 | 580117 | 2020-09-29 | Hillsborough | Florida | 12057 | 42118 | 636 |
576876 | 576876 | 2020-09-28 | Hillsborough | Florida | 12057 | 41947 | 628 |
573633 | 573633 | 2020-09-27 | Hillsborough | Florida | 12057 | 41826 | 628 |
570391 | 570391 | 2020-09-26 | Hillsborough | Florida | 12057 | 41722 | 628 |
567149 | 567149 | 2020-09-25 | Hillsborough | Florida | 12057 | 41506 | 625 |
563909 | 563909 | 2020-09-24 | Hillsborough | Florida | 12057 | 41351 | 620 |
560669 | 560669 | 2020-09-23 | Hillsborough | Florida | 12057 | 41178 | 614 |
557433 | 557433 | 2020-09-22 | Hillsborough | Florida | 12057 | 41016 | 605 |
554196 | 554196 | 2020-09-21 | Hillsborough | Florida | 12057 | 40898 | 604 |
550957 | 550957 | 2020-09-20 | Hillsborough | Florida | 12057 | 40751 | 604 |
547718 | 547718 | 2020-09-19 | Hillsborough | Florida | 12057 | 40587 | 604 |
544480 | 544480 | 2020-09-18 | Hillsborough | Florida | 12057 | 40349 | 604 |
541244 | 541244 | 2020-09-17 | Hillsborough | Florida | 12057 | 40126 | 601 |
538007 | 538007 | 2020-09-16 | Hillsborough | Florida | 12057 | 39888 | 596 |
534771 | 534771 | 2020-09-15 | Hillsborough | Florida | 12057 | 39751 | 591 |
531536 | 531536 | 2020-09-14 | Hillsborough | Florida | 12057 | 39600 | 585 |
528299 | 528299 | 2020-09-13 | Hillsborough | Florida | 12057 | 39450 | 586 |
525063 | 525063 | 2020-09-12 | Hillsborough | Florida | 12057 | 39298 | 585 |
521827 | 521827 | 2020-09-11 | Hillsborough | Florida | 12057 | 39138 | 584 |
518590 | 518590 | 2020-09-10 | Hillsborough | Florida | 12057 | 38917 | 579 |
515355 | 515355 | 2020-09-09 | Hillsborough | Florida | 12057 | 38790 | 568 |
512122 | 512122 | 2020-09-08 | Hillsborough | Florida | 12057 | 38652 | 565 |
508889 | 508889 | 2020-09-07 | Hillsborough | Florida | 12057 | 38545 | 562 |
505657 | 505657 | 2020-09-06 | Hillsborough | Florida | 12057 | 38426 | 562 |
502423 | 502423 | 2020-09-05 | Hillsborough | Florida | 12057 | 38262 | 559 |
499189 | 499189 | 2020-09-04 | Hillsborough | Florida | 12057 | 37981 | 558 |
495956 | 495956 | 2020-09-03 | Hillsborough | Florida | 12057 | 37821 | 558 |
492722 | 492722 | 2020-09-02 | Hillsborough | Florida | 12057 | 37668 | 554 |
489489 | 489489 | 2020-09-01 | Hillsborough | Florida | 12057 | 37458 | 551 |
486256 | 486256 | 2020-08-31 | Hillsborough | Florida | 12057 | 37136 | 551 |
483021 | 483021 | 2020-08-30 | Hillsborough | Florida | 12057 | 37013 | 547 |
479787 | 479787 | 2020-08-29 | Hillsborough | Florida | 12057 | 36784 | 545 |
476554 | 476554 | 2020-08-28 | Hillsborough | Florida | 12057 | 36574 | 541 |
473321 | 473321 | 2020-08-27 | Hillsborough | Florida | 12057 | 36354 | 540 |
470089 | 470089 | 2020-08-26 | Hillsborough | Florida | 12057 | 36157 | 537 |
466860 | 466860 | 2020-08-25 | Hillsborough | Florida | 12057 | 35953 | 534 |
463631 | 463631 | 2020-08-24 | Hillsborough | Florida | 12057 | 35814 | 530 |
460402 | 460402 | 2020-08-23 | Hillsborough | Florida | 12057 | 35721 | 520 |
457175 | 457175 | 2020-08-22 | Hillsborough | Florida | 12057 | 35574 | 519 |
453947 | 453947 | 2020-08-21 | Hillsborough | Florida | 12057 | 35293 | 519 |
450719 | 450719 | 2020-08-20 | Hillsborough | Florida | 12057 | 35061 | 512 |
447491 | 447491 | 2020-08-19 | Hillsborough | Florida | 12057 | 34851 | 508 |
444264 | 444264 | 2020-08-18 | Hillsborough | Florida | 12057 | 34605 | 490 |
441038 | 441038 | 2020-08-17 | Hillsborough | Florida | 12057 | 34368 | 487 |
437812 | 437812 | 2020-08-16 | Hillsborough | Florida | 12057 | 34238 | 483 |
434586 | 434586 | 2020-08-15 | Hillsborough | Florida | 12057 | 34040 | 460 |
431361 | 431361 | 2020-08-14 | Hillsborough | Florida | 12057 | 33694 | 458 |
428133 | 428133 | 2020-08-13 | Hillsborough | Florida | 12057 | 33428 | 427 |
424909 | 424909 | 2020-08-12 | Hillsborough | Florida | 12057 | 33198 | 426 |
421688 | 421688 | 2020-08-11 | Hillsborough | Florida | 12057 | 32996 | 395 |
418467 | 418467 | 2020-08-10 | Hillsborough | Florida | 12057 | 32731 | 388 |
415246 | 415246 | 2020-08-09 | Hillsborough | Florida | 12057 | 32587 | 388 |
412026 | 412026 | 2020-08-08 | Hillsborough | Florida | 12057 | 32268 | 388 |
408807 | 408807 | 2020-08-07 | Hillsborough | Florida | 12057 | 31865 | 386 |
405587 | 405587 | 2020-08-06 | Hillsborough | Florida | 12057 | 31563 | 378 |
402369 | 402369 | 2020-08-05 | Hillsborough | Florida | 12057 | 31197 | 377 |
399153 | 399153 | 2020-08-04 | Hillsborough | Florida | 12057 | 30798 | 369 |
395937 | 395937 | 2020-08-03 | Hillsborough | Florida | 12057 | 30450 | 348 |
392721 | 392721 | 2020-08-02 | Hillsborough | Florida | 12057 | 30118 | 347 |
389504 | 389504 | 2020-08-01 | Hillsborough | Florida | 12057 | 29589 | 341 |
386287 | 386287 | 2020-07-31 | Hillsborough | Florida | 12057 | 29116 | 335 |
383069 | 383069 | 2020-07-30 | Hillsborough | Florida | 12057 | 28742 | 331 |
379852 | 379852 | 2020-07-29 | Hillsborough | Florida | 12057 | 28268 | 323 |
376635 | 376635 | 2020-07-28 | Hillsborough | Florida | 12057 | 27823 | 310 |
373421 | 373421 | 2020-07-27 | Hillsborough | Florida | 12057 | 27483 | 298 |
370209 | 370209 | 2020-07-26 | Hillsborough | Florida | 12057 | 27077 | 295 |
366999 | 366999 | 2020-07-25 | Hillsborough | Florida | 12057 | 26626 | 280 |
363792 | 363792 | 2020-07-24 | Hillsborough | Florida | 12057 | 26037 | 280 |
360585 | 360585 | 2020-07-23 | Hillsborough | Florida | 12057 | 25432 | 278 |
357380 | 357380 | 2020-07-22 | Hillsborough | Florida | 12057 | 24891 | 260 |
354177 | 354177 | 2020-07-21 | Hillsborough | Florida | 12057 | 24550 | 244 |
350975 | 350975 | 2020-07-20 | Hillsborough | Florida | 12057 | 24135 | 243 |
347774 | 347774 | 2020-07-19 | Hillsborough | Florida | 12057 | 23706 | 235 |
344574 | 344574 | 2020-07-18 | Hillsborough | Florida | 12057 | 23103 | 234 |
341375 | 341375 | 2020-07-17 | Hillsborough | Florida | 12057 | 22502 | 233 |
338178 | 338178 | 2020-07-16 | Hillsborough | Florida | 12057 | 21557 | 232 |
334983 | 334983 | 2020-07-15 | Hillsborough | Florida | 12057 | 21018 | 192 |
331790 | 331790 | 2020-07-14 | Hillsborough | Florida | 12057 | 20508 | 189 |
328603 | 328603 | 2020-07-13 | Hillsborough | Florida | 12057 | 19828 | 188 |
325417 | 325417 | 2020-07-12 | Hillsborough | Florida | 12057 | 19150 | 188 |
322236 | 322236 | 2020-07-11 | Hillsborough | Florida | 12057 | 18360 | 187 |
319057 | 319057 | 2020-07-10 | Hillsborough | Florida | 12057 | 17662 | 186 |
315884 | 315884 | 2020-07-09 | Hillsborough | Florida | 12057 | 16666 | 182 |
312709 | 312709 | 2020-07-08 | Hillsborough | Florida | 12057 | 16099 | 163 |
309539 | 309539 | 2020-07-07 | Hillsborough | Florida | 12057 | 15362 | 163 |
306371 | 306371 | 2020-07-06 | Hillsborough | Florida | 12057 | 14677 | 158 |
303207 | 303207 | 2020-07-05 | Hillsborough | Florida | 12057 | 14336 | 150 |
300043 | 300043 | 2020-07-04 | Hillsborough | Florida | 12057 | 13700 | 150 |
296881 | 296881 | 2020-07-03 | Hillsborough | Florida | 12057 | 13044 | 148 |
293725 | 293725 | 2020-07-02 | Hillsborough | Florida | 12057 | 12376 | 145 |
290571 | 290571 | 2020-07-01 | Hillsborough | Florida | 12057 | 11465 | 140 |
287420 | 287420 | 2020-06-30 | Hillsborough | Florida | 12057 | 10752 | 138 |
284274 | 284274 | 2020-06-29 | Hillsborough | Florida | 12057 | 10323 | 135 |
281128 | 281128 | 2020-06-28 | Hillsborough | Florida | 12057 | 9918 | 132 |
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);