ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 12009 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
271670 | 271670 | 2020-06-25 | Brevard | Florida | 12009 | 1149 | 17 |
274810 | 274810 | 2020-06-26 | Brevard | Florida | 12009 | 1297 | 17 |
277958 | 277958 | 2020-06-27 | Brevard | Florida | 12009 | 1547 | 17 |
281105 | 281105 | 2020-06-28 | Brevard | Florida | 12009 | 1631 | 17 |
284251 | 284251 | 2020-06-29 | Brevard | Florida | 12009 | 1716 | 17 |
287397 | 287397 | 2020-06-30 | Brevard | Florida | 12009 | 1793 | 17 |
290548 | 290548 | 2020-07-01 | Brevard | Florida | 12009 | 1962 | 17 |
293702 | 293702 | 2020-07-02 | Brevard | Florida | 12009 | 2180 | 17 |
296858 | 296858 | 2020-07-03 | Brevard | Florida | 12009 | 2366 | 18 |
300020 | 300020 | 2020-07-04 | Brevard | Florida | 12009 | 2453 | 19 |
303184 | 303184 | 2020-07-05 | Brevard | Florida | 12009 | 2521 | 19 |
306348 | 306348 | 2020-07-06 | Brevard | Florida | 12009 | 2591 | 19 |
309516 | 309516 | 2020-07-07 | Brevard | Florida | 12009 | 2705 | 20 |
312686 | 312686 | 2020-07-08 | Brevard | Florida | 12009 | 2812 | 20 |
315861 | 315861 | 2020-07-09 | Brevard | Florida | 12009 | 2985 | 26 |
319034 | 319034 | 2020-07-10 | Brevard | Florida | 12009 | 3104 | 27 |
322213 | 322213 | 2020-07-11 | Brevard | Florida | 12009 | 3237 | 28 |
325394 | 325394 | 2020-07-12 | Brevard | Florida | 12009 | 3369 | 29 |
328580 | 328580 | 2020-07-13 | Brevard | Florida | 12009 | 3510 | 29 |
331767 | 331767 | 2020-07-14 | Brevard | Florida | 12009 | 3632 | 34 |
334960 | 334960 | 2020-07-15 | Brevard | Florida | 12009 | 3722 | 40 |
338155 | 338155 | 2020-07-16 | Brevard | Florida | 12009 | 3804 | 44 |
341352 | 341352 | 2020-07-17 | Brevard | Florida | 12009 | 3945 | 46 |
344551 | 344551 | 2020-07-18 | Brevard | Florida | 12009 | 4060 | 49 |
347751 | 347751 | 2020-07-19 | Brevard | Florida | 12009 | 4222 | 50 |
350952 | 350952 | 2020-07-20 | Brevard | Florida | 12009 | 4303 | 50 |
354154 | 354154 | 2020-07-21 | Brevard | Florida | 12009 | 4413 | 53 |
357357 | 357357 | 2020-07-22 | Brevard | Florida | 12009 | 4561 | 58 |
360562 | 360562 | 2020-07-23 | Brevard | Florida | 12009 | 4658 | 60 |
363769 | 363769 | 2020-07-24 | Brevard | Florida | 12009 | 4756 | 64 |
366976 | 366976 | 2020-07-25 | Brevard | Florida | 12009 | 4898 | 64 |
370186 | 370186 | 2020-07-26 | Brevard | Florida | 12009 | 4966 | 64 |
373398 | 373398 | 2020-07-27 | Brevard | Florida | 12009 | 5069 | 65 |
376612 | 376612 | 2020-07-28 | Brevard | Florida | 12009 | 5155 | 85 |
379829 | 379829 | 2020-07-29 | Brevard | Florida | 12009 | 5254 | 95 |
383046 | 383046 | 2020-07-30 | Brevard | Florida | 12009 | 5333 | 108 |
386264 | 386264 | 2020-07-31 | Brevard | Florida | 12009 | 5420 | 114 |
389481 | 389481 | 2020-08-01 | Brevard | Florida | 12009 | 5521 | 115 |
392698 | 392698 | 2020-08-02 | Brevard | Florida | 12009 | 5587 | 117 |
395914 | 395914 | 2020-08-03 | Brevard | Florida | 12009 | 5619 | 117 |
399130 | 399130 | 2020-08-04 | Brevard | Florida | 12009 | 5671 | 123 |
402346 | 402346 | 2020-08-05 | Brevard | Florida | 12009 | 5712 | 132 |
405564 | 405564 | 2020-08-06 | Brevard | Florida | 12009 | 5794 | 134 |
408784 | 408784 | 2020-08-07 | Brevard | Florida | 12009 | 5851 | 140 |
412003 | 412003 | 2020-08-08 | Brevard | Florida | 12009 | 5963 | 142 |
415223 | 415223 | 2020-08-09 | Brevard | Florida | 12009 | 6064 | 151 |
418444 | 418444 | 2020-08-10 | Brevard | Florida | 12009 | 6099 | 151 |
421665 | 421665 | 2020-08-11 | Brevard | Florida | 12009 | 6190 | 157 |
424886 | 424886 | 2020-08-12 | Brevard | Florida | 12009 | 6248 | 160 |
428110 | 428110 | 2020-08-13 | Brevard | Florida | 12009 | 6313 | 163 |
431338 | 431338 | 2020-08-14 | Brevard | Florida | 12009 | 6392 | 168 |
434563 | 434563 | 2020-08-15 | Brevard | Florida | 12009 | 6478 | 174 |
437789 | 437789 | 2020-08-16 | Brevard | Florida | 12009 | 6511 | 178 |
441015 | 441015 | 2020-08-17 | Brevard | Florida | 12009 | 6538 | 178 |
444241 | 444241 | 2020-08-18 | Brevard | Florida | 12009 | 6614 | 181 |
447468 | 447468 | 2020-08-19 | Brevard | Florida | 12009 | 6667 | 189 |
450696 | 450696 | 2020-08-20 | Brevard | Florida | 12009 | 6753 | 192 |
453924 | 453924 | 2020-08-21 | Brevard | Florida | 12009 | 6797 | 194 |
457152 | 457152 | 2020-08-22 | Brevard | Florida | 12009 | 6889 | 195 |
460379 | 460379 | 2020-08-23 | Brevard | Florida | 12009 | 6912 | 195 |
463608 | 463608 | 2020-08-24 | Brevard | Florida | 12009 | 6946 | 195 |
466837 | 466837 | 2020-08-25 | Brevard | Florida | 12009 | 6972 | 195 |
470066 | 470066 | 2020-08-26 | Brevard | Florida | 12009 | 7040 | 200 |
473298 | 473298 | 2020-08-27 | Brevard | Florida | 12009 | 7092 | 205 |
476531 | 476531 | 2020-08-28 | Brevard | Florida | 12009 | 7132 | 207 |
479764 | 479764 | 2020-08-29 | Brevard | Florida | 12009 | 7182 | 209 |
482998 | 482998 | 2020-08-30 | Brevard | Florida | 12009 | 7201 | 210 |
486233 | 486233 | 2020-08-31 | Brevard | Florida | 12009 | 7234 | 210 |
489466 | 489466 | 2020-09-01 | Brevard | Florida | 12009 | 7378 | 210 |
492699 | 492699 | 2020-09-02 | Brevard | Florida | 12009 | 7423 | 218 |
495933 | 495933 | 2020-09-03 | Brevard | Florida | 12009 | 7464 | 223 |
499166 | 499166 | 2020-09-04 | Brevard | Florida | 12009 | 7532 | 228 |
502400 | 502400 | 2020-09-05 | Brevard | Florida | 12009 | 7598 | 234 |
505634 | 505634 | 2020-09-06 | Brevard | Florida | 12009 | 7633 | 235 |
508866 | 508866 | 2020-09-07 | Brevard | Florida | 12009 | 7656 | 235 |
512099 | 512099 | 2020-09-08 | Brevard | Florida | 12009 | 7689 | 235 |
515332 | 515332 | 2020-09-09 | Brevard | Florida | 12009 | 7742 | 237 |
518567 | 518567 | 2020-09-10 | Brevard | Florida | 12009 | 7787 | 245 |
521804 | 521804 | 2020-09-11 | Brevard | Florida | 12009 | 7861 | 253 |
525040 | 525040 | 2020-09-12 | Brevard | Florida | 12009 | 7926 | 254 |
528276 | 528276 | 2020-09-13 | Brevard | Florida | 12009 | 7960 | 254 |
531513 | 531513 | 2020-09-14 | Brevard | Florida | 12009 | 7995 | 256 |
534748 | 534748 | 2020-09-15 | Brevard | Florida | 12009 | 8050 | 263 |
537984 | 537984 | 2020-09-16 | Brevard | Florida | 12009 | 8097 | 266 |
541221 | 541221 | 2020-09-17 | Brevard | Florida | 12009 | 8193 | 270 |
544457 | 544457 | 2020-09-18 | Brevard | Florida | 12009 | 8264 | 274 |
547695 | 547695 | 2020-09-19 | Brevard | Florida | 12009 | 8352 | 276 |
550934 | 550934 | 2020-09-20 | Brevard | Florida | 12009 | 8395 | 277 |
554173 | 554173 | 2020-09-21 | Brevard | Florida | 12009 | 8429 | 277 |
557410 | 557410 | 2020-09-22 | Brevard | Florida | 12009 | 8502 | 281 |
560646 | 560646 | 2020-09-23 | Brevard | Florida | 12009 | 8578 | 284 |
563886 | 563886 | 2020-09-24 | Brevard | Florida | 12009 | 8636 | 290 |
567126 | 567126 | 2020-09-25 | Brevard | Florida | 12009 | 8728 | 291 |
570368 | 570368 | 2020-09-26 | Brevard | Florida | 12009 | 8800 | 293 |
573610 | 573610 | 2020-09-27 | Brevard | Florida | 12009 | 8841 | 293 |
576853 | 576853 | 2020-09-28 | Brevard | Florida | 12009 | 8848 | 293 |
580094 | 580094 | 2020-09-29 | Brevard | Florida | 12009 | 8983 | 295 |
583333 | 583333 | 2020-09-30 | Brevard | Florida | 12009 | 9049 | 298 |
586573 | 586573 | 2020-10-01 | Brevard | Florida | 12009 | 9154 | 299 |
589814 | 589814 | 2020-10-02 | Brevard | Florida | 12009 | 9221 | 303 |
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);