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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- 2020-06-19 1
- 2020-06-20 1
- 2020-06-21 1
- 2020-06-22 1
- 2020-06-23 1
- 2020-06-24 1
- 2020-06-25 1
- 2020-06-26 1
- 2020-06-27 1
- 2020-06-28 1
- 2020-06-29 1
- 2020-06-30 1
- 2020-07-01 1
- 2020-07-02 1
- 2020-07-03 1
- 2020-07-04 1
- 2020-07-05 1
- 2020-07-06 1
- 2020-07-07 1
- 2020-07-08 1
- …
state 1
- Florida 704
fips 1
- 12057 · 704 ✖
county 1
- Hillsborough 704
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
221854 | 221854 | 2020-06-09 | Hillsborough | Florida | 12057 | 2923 | 93 |
224949 | 224949 | 2020-06-10 | Hillsborough | Florida | 12057 | 3027 | 94 |
228051 | 228051 | 2020-06-11 | Hillsborough | Florida | 12057 | 3174 | 96 |
231154 | 231154 | 2020-06-12 | Hillsborough | Florida | 12057 | 3295 | 99 |
234260 | 234260 | 2020-06-13 | Hillsborough | Florida | 12057 | 3504 | 99 |
237367 | 237367 | 2020-06-14 | Hillsborough | Florida | 12057 | 3613 | 99 |
240475 | 240475 | 2020-06-15 | Hillsborough | Florida | 12057 | 3826 | 99 |
243586 | 243586 | 2020-06-16 | Hillsborough | Florida | 12057 | 4029 | 103 |
246699 | 246699 | 2020-06-17 | Hillsborough | Florida | 12057 | 4273 | 104 |
249811 | 249811 | 2020-06-18 | Hillsborough | Florida | 12057 | 4610 | 105 |
252926 | 252926 | 2020-06-19 | Hillsborough | Florida | 12057 | 4982 | 109 |
256045 | 256045 | 2020-06-20 | Hillsborough | Florida | 12057 | 5319 | 114 |
259172 | 259172 | 2020-06-21 | Hillsborough | Florida | 12057 | 5580 | 114 |
262299 | 262299 | 2020-06-22 | Hillsborough | Florida | 12057 | 5973 | 115 |
265427 | 265427 | 2020-06-23 | Hillsborough | Florida | 12057 | 6176 | 119 |
268557 | 268557 | 2020-06-24 | Hillsborough | Florida | 12057 | 6892 | 121 |
271693 | 271693 | 2020-06-25 | Hillsborough | Florida | 12057 | 7329 | 127 |
274833 | 274833 | 2020-06-26 | Hillsborough | Florida | 12057 | 8018 | 132 |
277981 | 277981 | 2020-06-27 | Hillsborough | Florida | 12057 | 9130 | 132 |
281128 | 281128 | 2020-06-28 | Hillsborough | Florida | 12057 | 9918 | 132 |
284274 | 284274 | 2020-06-29 | Hillsborough | Florida | 12057 | 10323 | 135 |
287420 | 287420 | 2020-06-30 | Hillsborough | Florida | 12057 | 10752 | 138 |
290571 | 290571 | 2020-07-01 | Hillsborough | Florida | 12057 | 11465 | 140 |
293725 | 293725 | 2020-07-02 | Hillsborough | Florida | 12057 | 12376 | 145 |
296881 | 296881 | 2020-07-03 | Hillsborough | Florida | 12057 | 13044 | 148 |
300043 | 300043 | 2020-07-04 | Hillsborough | Florida | 12057 | 13700 | 150 |
303207 | 303207 | 2020-07-05 | Hillsborough | Florida | 12057 | 14336 | 150 |
306371 | 306371 | 2020-07-06 | Hillsborough | Florida | 12057 | 14677 | 158 |
309539 | 309539 | 2020-07-07 | Hillsborough | Florida | 12057 | 15362 | 163 |
312709 | 312709 | 2020-07-08 | Hillsborough | Florida | 12057 | 16099 | 163 |
315884 | 315884 | 2020-07-09 | Hillsborough | Florida | 12057 | 16666 | 182 |
319057 | 319057 | 2020-07-10 | Hillsborough | Florida | 12057 | 17662 | 186 |
322236 | 322236 | 2020-07-11 | Hillsborough | Florida | 12057 | 18360 | 187 |
325417 | 325417 | 2020-07-12 | Hillsborough | Florida | 12057 | 19150 | 188 |
328603 | 328603 | 2020-07-13 | Hillsborough | Florida | 12057 | 19828 | 188 |
331790 | 331790 | 2020-07-14 | Hillsborough | Florida | 12057 | 20508 | 189 |
334983 | 334983 | 2020-07-15 | Hillsborough | Florida | 12057 | 21018 | 192 |
338178 | 338178 | 2020-07-16 | Hillsborough | Florida | 12057 | 21557 | 232 |
341375 | 341375 | 2020-07-17 | Hillsborough | Florida | 12057 | 22502 | 233 |
344574 | 344574 | 2020-07-18 | Hillsborough | Florida | 12057 | 23103 | 234 |
347774 | 347774 | 2020-07-19 | Hillsborough | Florida | 12057 | 23706 | 235 |
350975 | 350975 | 2020-07-20 | Hillsborough | Florida | 12057 | 24135 | 243 |
354177 | 354177 | 2020-07-21 | Hillsborough | Florida | 12057 | 24550 | 244 |
357380 | 357380 | 2020-07-22 | Hillsborough | Florida | 12057 | 24891 | 260 |
360585 | 360585 | 2020-07-23 | Hillsborough | Florida | 12057 | 25432 | 278 |
363792 | 363792 | 2020-07-24 | Hillsborough | Florida | 12057 | 26037 | 280 |
366999 | 366999 | 2020-07-25 | Hillsborough | Florida | 12057 | 26626 | 280 |
370209 | 370209 | 2020-07-26 | Hillsborough | Florida | 12057 | 27077 | 295 |
373421 | 373421 | 2020-07-27 | Hillsborough | Florida | 12057 | 27483 | 298 |
376635 | 376635 | 2020-07-28 | Hillsborough | Florida | 12057 | 27823 | 310 |
379852 | 379852 | 2020-07-29 | Hillsborough | Florida | 12057 | 28268 | 323 |
383069 | 383069 | 2020-07-30 | Hillsborough | Florida | 12057 | 28742 | 331 |
386287 | 386287 | 2020-07-31 | Hillsborough | Florida | 12057 | 29116 | 335 |
389504 | 389504 | 2020-08-01 | Hillsborough | Florida | 12057 | 29589 | 341 |
392721 | 392721 | 2020-08-02 | Hillsborough | Florida | 12057 | 30118 | 347 |
395937 | 395937 | 2020-08-03 | Hillsborough | Florida | 12057 | 30450 | 348 |
399153 | 399153 | 2020-08-04 | Hillsborough | Florida | 12057 | 30798 | 369 |
402369 | 402369 | 2020-08-05 | Hillsborough | Florida | 12057 | 31197 | 377 |
405587 | 405587 | 2020-08-06 | Hillsborough | Florida | 12057 | 31563 | 378 |
408807 | 408807 | 2020-08-07 | Hillsborough | Florida | 12057 | 31865 | 386 |
412026 | 412026 | 2020-08-08 | Hillsborough | Florida | 12057 | 32268 | 388 |
415246 | 415246 | 2020-08-09 | Hillsborough | Florida | 12057 | 32587 | 388 |
418467 | 418467 | 2020-08-10 | Hillsborough | Florida | 12057 | 32731 | 388 |
421688 | 421688 | 2020-08-11 | Hillsborough | Florida | 12057 | 32996 | 395 |
424909 | 424909 | 2020-08-12 | Hillsborough | Florida | 12057 | 33198 | 426 |
428133 | 428133 | 2020-08-13 | Hillsborough | Florida | 12057 | 33428 | 427 |
431361 | 431361 | 2020-08-14 | Hillsborough | Florida | 12057 | 33694 | 458 |
434586 | 434586 | 2020-08-15 | Hillsborough | Florida | 12057 | 34040 | 460 |
437812 | 437812 | 2020-08-16 | Hillsborough | Florida | 12057 | 34238 | 483 |
441038 | 441038 | 2020-08-17 | Hillsborough | Florida | 12057 | 34368 | 487 |
444264 | 444264 | 2020-08-18 | Hillsborough | Florida | 12057 | 34605 | 490 |
447491 | 447491 | 2020-08-19 | Hillsborough | Florida | 12057 | 34851 | 508 |
450719 | 450719 | 2020-08-20 | Hillsborough | Florida | 12057 | 35061 | 512 |
453947 | 453947 | 2020-08-21 | Hillsborough | Florida | 12057 | 35293 | 519 |
457175 | 457175 | 2020-08-22 | Hillsborough | Florida | 12057 | 35574 | 519 |
460402 | 460402 | 2020-08-23 | Hillsborough | Florida | 12057 | 35721 | 520 |
463631 | 463631 | 2020-08-24 | Hillsborough | Florida | 12057 | 35814 | 530 |
466860 | 466860 | 2020-08-25 | Hillsborough | Florida | 12057 | 35953 | 534 |
470089 | 470089 | 2020-08-26 | Hillsborough | Florida | 12057 | 36157 | 537 |
473321 | 473321 | 2020-08-27 | Hillsborough | Florida | 12057 | 36354 | 540 |
476554 | 476554 | 2020-08-28 | Hillsborough | Florida | 12057 | 36574 | 541 |
479787 | 479787 | 2020-08-29 | Hillsborough | Florida | 12057 | 36784 | 545 |
483021 | 483021 | 2020-08-30 | Hillsborough | Florida | 12057 | 37013 | 547 |
486256 | 486256 | 2020-08-31 | Hillsborough | Florida | 12057 | 37136 | 551 |
489489 | 489489 | 2020-09-01 | Hillsborough | Florida | 12057 | 37458 | 551 |
492722 | 492722 | 2020-09-02 | Hillsborough | Florida | 12057 | 37668 | 554 |
495956 | 495956 | 2020-09-03 | Hillsborough | Florida | 12057 | 37821 | 558 |
499189 | 499189 | 2020-09-04 | Hillsborough | Florida | 12057 | 37981 | 558 |
502423 | 502423 | 2020-09-05 | Hillsborough | Florida | 12057 | 38262 | 559 |
505657 | 505657 | 2020-09-06 | Hillsborough | Florida | 12057 | 38426 | 562 |
508889 | 508889 | 2020-09-07 | Hillsborough | Florida | 12057 | 38545 | 562 |
512122 | 512122 | 2020-09-08 | Hillsborough | Florida | 12057 | 38652 | 565 |
515355 | 515355 | 2020-09-09 | Hillsborough | Florida | 12057 | 38790 | 568 |
518590 | 518590 | 2020-09-10 | Hillsborough | Florida | 12057 | 38917 | 579 |
521827 | 521827 | 2020-09-11 | Hillsborough | Florida | 12057 | 39138 | 584 |
525063 | 525063 | 2020-09-12 | Hillsborough | Florida | 12057 | 39298 | 585 |
528299 | 528299 | 2020-09-13 | Hillsborough | Florida | 12057 | 39450 | 586 |
531536 | 531536 | 2020-09-14 | Hillsborough | Florida | 12057 | 39600 | 585 |
534771 | 534771 | 2020-09-15 | Hillsborough | Florida | 12057 | 39751 | 591 |
538007 | 538007 | 2020-09-16 | Hillsborough | Florida | 12057 | 39888 | 596 |
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);