ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Nassau" and state = "Florida" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
249828 | 249828 | 2020-06-18 | Nassau | Florida | 12089 | 97 | 1 |
252943 | 252943 | 2020-06-19 | Nassau | Florida | 12089 | 101 | 1 |
256062 | 256062 | 2020-06-20 | Nassau | Florida | 12089 | 111 | 1 |
259189 | 259189 | 2020-06-21 | Nassau | Florida | 12089 | 115 | 1 |
262316 | 262316 | 2020-06-22 | Nassau | Florida | 12089 | 120 | 1 |
265444 | 265444 | 2020-06-23 | Nassau | Florida | 12089 | 126 | 1 |
268574 | 268574 | 2020-06-24 | Nassau | Florida | 12089 | 128 | 1 |
271710 | 271710 | 2020-06-25 | Nassau | Florida | 12089 | 136 | 1 |
274850 | 274850 | 2020-06-26 | Nassau | Florida | 12089 | 146 | 1 |
277998 | 277998 | 2020-06-27 | Nassau | Florida | 12089 | 158 | 1 |
281145 | 281145 | 2020-06-28 | Nassau | Florida | 12089 | 169 | 1 |
284291 | 284291 | 2020-06-29 | Nassau | Florida | 12089 | 175 | 1 |
287437 | 287437 | 2020-06-30 | Nassau | Florida | 12089 | 182 | 1 |
290588 | 290588 | 2020-07-01 | Nassau | Florida | 12089 | 196 | 1 |
293742 | 293742 | 2020-07-02 | Nassau | Florida | 12089 | 225 | 1 |
296898 | 296898 | 2020-07-03 | Nassau | Florida | 12089 | 253 | 1 |
300060 | 300060 | 2020-07-04 | Nassau | Florida | 12089 | 277 | 1 |
303224 | 303224 | 2020-07-05 | Nassau | Florida | 12089 | 313 | 1 |
306388 | 306388 | 2020-07-06 | Nassau | Florida | 12089 | 325 | 1 |
309556 | 309556 | 2020-07-07 | Nassau | Florida | 12089 | 346 | 2 |
312726 | 312726 | 2020-07-08 | Nassau | Florida | 12089 | 375 | 2 |
315901 | 315901 | 2020-07-09 | Nassau | Florida | 12089 | 405 | 2 |
319074 | 319074 | 2020-07-10 | Nassau | Florida | 12089 | 438 | 2 |
322253 | 322253 | 2020-07-11 | Nassau | Florida | 12089 | 482 | 2 |
325434 | 325434 | 2020-07-12 | Nassau | Florida | 12089 | 524 | 2 |
328620 | 328620 | 2020-07-13 | Nassau | Florida | 12089 | 546 | 2 |
331807 | 331807 | 2020-07-14 | Nassau | Florida | 12089 | 570 | 3 |
335000 | 335000 | 2020-07-15 | Nassau | Florida | 12089 | 600 | 3 |
338195 | 338195 | 2020-07-16 | Nassau | Florida | 12089 | 626 | 3 |
341392 | 341392 | 2020-07-17 | Nassau | Florida | 12089 | 660 | 3 |
344591 | 344591 | 2020-07-18 | Nassau | Florida | 12089 | 682 | 4 |
347791 | 347791 | 2020-07-19 | Nassau | Florida | 12089 | 745 | 4 |
350992 | 350992 | 2020-07-20 | Nassau | Florida | 12089 | 784 | 4 |
354194 | 354194 | 2020-07-21 | Nassau | Florida | 12089 | 811 | 5 |
357397 | 357397 | 2020-07-22 | Nassau | Florida | 12089 | 838 | 7 |
360602 | 360602 | 2020-07-23 | Nassau | Florida | 12089 | 865 | 7 |
363809 | 363809 | 2020-07-24 | Nassau | Florida | 12089 | 895 | 7 |
367016 | 367016 | 2020-07-25 | Nassau | Florida | 12089 | 919 | 8 |
370226 | 370226 | 2020-07-26 | Nassau | Florida | 12089 | 941 | 8 |
373438 | 373438 | 2020-07-27 | Nassau | Florida | 12089 | 967 | 8 |
376652 | 376652 | 2020-07-28 | Nassau | Florida | 12089 | 986 | 8 |
379869 | 379869 | 2020-07-29 | Nassau | Florida | 12089 | 1009 | 8 |
383086 | 383086 | 2020-07-30 | Nassau | Florida | 12089 | 1037 | 10 |
386304 | 386304 | 2020-07-31 | Nassau | Florida | 12089 | 1054 | 10 |
389521 | 389521 | 2020-08-01 | Nassau | Florida | 12089 | 1079 | 10 |
392738 | 392738 | 2020-08-02 | Nassau | Florida | 12089 | 1104 | 10 |
395954 | 395954 | 2020-08-03 | Nassau | Florida | 12089 | 1121 | 11 |
399170 | 399170 | 2020-08-04 | Nassau | Florida | 12089 | 1138 | 11 |
402386 | 402386 | 2020-08-05 | Nassau | Florida | 12089 | 1155 | 11 |
405604 | 405604 | 2020-08-06 | Nassau | Florida | 12089 | 1184 | 11 |
408824 | 408824 | 2020-08-07 | Nassau | Florida | 12089 | 1202 | 11 |
412043 | 412043 | 2020-08-08 | Nassau | Florida | 12089 | 1219 | 11 |
415263 | 415263 | 2020-08-09 | Nassau | Florida | 12089 | 1233 | 11 |
418484 | 418484 | 2020-08-10 | Nassau | Florida | 12089 | 1239 | 11 |
421705 | 421705 | 2020-08-11 | Nassau | Florida | 12089 | 1253 | 11 |
424926 | 424926 | 2020-08-12 | Nassau | Florida | 12089 | 1270 | 11 |
428150 | 428150 | 2020-08-13 | Nassau | Florida | 12089 | 1280 | 11 |
431378 | 431378 | 2020-08-14 | Nassau | Florida | 12089 | 1296 | 11 |
434603 | 434603 | 2020-08-15 | Nassau | Florida | 12089 | 1316 | 13 |
437829 | 437829 | 2020-08-16 | Nassau | Florida | 12089 | 1334 | 13 |
441055 | 441055 | 2020-08-17 | Nassau | Florida | 12089 | 1345 | 13 |
444281 | 444281 | 2020-08-18 | Nassau | Florida | 12089 | 1354 | 13 |
447508 | 447508 | 2020-08-19 | Nassau | Florida | 12089 | 1372 | 13 |
450736 | 450736 | 2020-08-20 | Nassau | Florida | 12089 | 1396 | 14 |
453964 | 453964 | 2020-08-21 | Nassau | Florida | 12089 | 1435 | 15 |
457192 | 457192 | 2020-08-22 | Nassau | Florida | 12089 | 1456 | 15 |
460419 | 460419 | 2020-08-23 | Nassau | Florida | 12089 | 1498 | 15 |
463648 | 463648 | 2020-08-24 | Nassau | Florida | 12089 | 1512 | 15 |
466877 | 466877 | 2020-08-25 | Nassau | Florida | 12089 | 1522 | 16 |
470106 | 470106 | 2020-08-26 | Nassau | Florida | 12089 | 1533 | 16 |
473338 | 473338 | 2020-08-27 | Nassau | Florida | 12089 | 1574 | 16 |
476571 | 476571 | 2020-08-28 | Nassau | Florida | 12089 | 1620 | 18 |
479804 | 479804 | 2020-08-29 | Nassau | Florida | 12089 | 1643 | 19 |
483038 | 483038 | 2020-08-30 | Nassau | Florida | 12089 | 1659 | 19 |
486273 | 486273 | 2020-08-31 | Nassau | Florida | 12089 | 1704 | 19 |
489506 | 489506 | 2020-09-01 | Nassau | Florida | 12089 | 1728 | 20 |
492739 | 492739 | 2020-09-02 | Nassau | Florida | 12089 | 1729 | 22 |
495973 | 495973 | 2020-09-03 | Nassau | Florida | 12089 | 1765 | 22 |
499206 | 499206 | 2020-09-04 | Nassau | Florida | 12089 | 1777 | 22 |
502440 | 502440 | 2020-09-05 | Nassau | Florida | 12089 | 1794 | 24 |
505674 | 505674 | 2020-09-06 | Nassau | Florida | 12089 | 1816 | 24 |
508906 | 508906 | 2020-09-07 | Nassau | Florida | 12089 | 1839 | 24 |
512139 | 512139 | 2020-09-08 | Nassau | Florida | 12089 | 1850 | 25 |
515372 | 515372 | 2020-09-09 | Nassau | Florida | 12089 | 1869 | 29 |
518607 | 518607 | 2020-09-10 | Nassau | Florida | 12089 | 1880 | 29 |
521844 | 521844 | 2020-09-11 | Nassau | Florida | 12089 | 1891 | 29 |
525080 | 525080 | 2020-09-12 | Nassau | Florida | 12089 | 1914 | 31 |
528316 | 528316 | 2020-09-13 | Nassau | Florida | 12089 | 1929 | 31 |
531553 | 531553 | 2020-09-14 | Nassau | Florida | 12089 | 1948 | 31 |
534788 | 534788 | 2020-09-15 | Nassau | Florida | 12089 | 1960 | 31 |
538024 | 538024 | 2020-09-16 | Nassau | Florida | 12089 | 1978 | 35 |
541261 | 541261 | 2020-09-17 | Nassau | Florida | 12089 | 1989 | 35 |
544497 | 544497 | 2020-09-18 | Nassau | Florida | 12089 | 1999 | 37 |
547735 | 547735 | 2020-09-19 | Nassau | Florida | 12089 | 2010 | 37 |
550974 | 550974 | 2020-09-20 | Nassau | Florida | 12089 | 2024 | 37 |
554213 | 554213 | 2020-09-21 | Nassau | Florida | 12089 | 2031 | 37 |
557450 | 557450 | 2020-09-22 | Nassau | Florida | 12089 | 2036 | 40 |
560686 | 560686 | 2020-09-23 | Nassau | Florida | 12089 | 2053 | 41 |
563926 | 563926 | 2020-09-24 | Nassau | Florida | 12089 | 2062 | 42 |
567166 | 567166 | 2020-09-25 | Nassau | Florida | 12089 | 2075 | 42 |
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);