ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Brevard" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534748 | 534748 | 2020-09-15 | Brevard | Florida | 12009 | 8050 | 263 |
531513 | 531513 | 2020-09-14 | Brevard | Florida | 12009 | 7995 | 256 |
528276 | 528276 | 2020-09-13 | Brevard | Florida | 12009 | 7960 | 254 |
525040 | 525040 | 2020-09-12 | Brevard | Florida | 12009 | 7926 | 254 |
521804 | 521804 | 2020-09-11 | Brevard | Florida | 12009 | 7861 | 253 |
518567 | 518567 | 2020-09-10 | Brevard | Florida | 12009 | 7787 | 245 |
515332 | 515332 | 2020-09-09 | Brevard | Florida | 12009 | 7742 | 237 |
512099 | 512099 | 2020-09-08 | Brevard | Florida | 12009 | 7689 | 235 |
508866 | 508866 | 2020-09-07 | Brevard | Florida | 12009 | 7656 | 235 |
505634 | 505634 | 2020-09-06 | Brevard | Florida | 12009 | 7633 | 235 |
502400 | 502400 | 2020-09-05 | Brevard | Florida | 12009 | 7598 | 234 |
499166 | 499166 | 2020-09-04 | Brevard | Florida | 12009 | 7532 | 228 |
495933 | 495933 | 2020-09-03 | Brevard | Florida | 12009 | 7464 | 223 |
492699 | 492699 | 2020-09-02 | Brevard | Florida | 12009 | 7423 | 218 |
489466 | 489466 | 2020-09-01 | Brevard | Florida | 12009 | 7378 | 210 |
486233 | 486233 | 2020-08-31 | Brevard | Florida | 12009 | 7234 | 210 |
482998 | 482998 | 2020-08-30 | Brevard | Florida | 12009 | 7201 | 210 |
479764 | 479764 | 2020-08-29 | Brevard | Florida | 12009 | 7182 | 209 |
476531 | 476531 | 2020-08-28 | Brevard | Florida | 12009 | 7132 | 207 |
473298 | 473298 | 2020-08-27 | Brevard | Florida | 12009 | 7092 | 205 |
470066 | 470066 | 2020-08-26 | Brevard | Florida | 12009 | 7040 | 200 |
466837 | 466837 | 2020-08-25 | Brevard | Florida | 12009 | 6972 | 195 |
463608 | 463608 | 2020-08-24 | Brevard | Florida | 12009 | 6946 | 195 |
460379 | 460379 | 2020-08-23 | Brevard | Florida | 12009 | 6912 | 195 |
457152 | 457152 | 2020-08-22 | Brevard | Florida | 12009 | 6889 | 195 |
453924 | 453924 | 2020-08-21 | Brevard | Florida | 12009 | 6797 | 194 |
450696 | 450696 | 2020-08-20 | Brevard | Florida | 12009 | 6753 | 192 |
447468 | 447468 | 2020-08-19 | Brevard | Florida | 12009 | 6667 | 189 |
444241 | 444241 | 2020-08-18 | Brevard | Florida | 12009 | 6614 | 181 |
441015 | 441015 | 2020-08-17 | Brevard | Florida | 12009 | 6538 | 178 |
437789 | 437789 | 2020-08-16 | Brevard | Florida | 12009 | 6511 | 178 |
434563 | 434563 | 2020-08-15 | Brevard | Florida | 12009 | 6478 | 174 |
431338 | 431338 | 2020-08-14 | Brevard | Florida | 12009 | 6392 | 168 |
428110 | 428110 | 2020-08-13 | Brevard | Florida | 12009 | 6313 | 163 |
424886 | 424886 | 2020-08-12 | Brevard | Florida | 12009 | 6248 | 160 |
421665 | 421665 | 2020-08-11 | Brevard | Florida | 12009 | 6190 | 157 |
418444 | 418444 | 2020-08-10 | Brevard | Florida | 12009 | 6099 | 151 |
415223 | 415223 | 2020-08-09 | Brevard | Florida | 12009 | 6064 | 151 |
412003 | 412003 | 2020-08-08 | Brevard | Florida | 12009 | 5963 | 142 |
408784 | 408784 | 2020-08-07 | Brevard | Florida | 12009 | 5851 | 140 |
405564 | 405564 | 2020-08-06 | Brevard | Florida | 12009 | 5794 | 134 |
402346 | 402346 | 2020-08-05 | Brevard | Florida | 12009 | 5712 | 132 |
399130 | 399130 | 2020-08-04 | Brevard | Florida | 12009 | 5671 | 123 |
395914 | 395914 | 2020-08-03 | Brevard | Florida | 12009 | 5619 | 117 |
392698 | 392698 | 2020-08-02 | Brevard | Florida | 12009 | 5587 | 117 |
389481 | 389481 | 2020-08-01 | Brevard | Florida | 12009 | 5521 | 115 |
386264 | 386264 | 2020-07-31 | Brevard | Florida | 12009 | 5420 | 114 |
383046 | 383046 | 2020-07-30 | Brevard | Florida | 12009 | 5333 | 108 |
379829 | 379829 | 2020-07-29 | Brevard | Florida | 12009 | 5254 | 95 |
376612 | 376612 | 2020-07-28 | Brevard | Florida | 12009 | 5155 | 85 |
373398 | 373398 | 2020-07-27 | Brevard | Florida | 12009 | 5069 | 65 |
370186 | 370186 | 2020-07-26 | Brevard | Florida | 12009 | 4966 | 64 |
366976 | 366976 | 2020-07-25 | Brevard | Florida | 12009 | 4898 | 64 |
363769 | 363769 | 2020-07-24 | Brevard | Florida | 12009 | 4756 | 64 |
360562 | 360562 | 2020-07-23 | Brevard | Florida | 12009 | 4658 | 60 |
357357 | 357357 | 2020-07-22 | Brevard | Florida | 12009 | 4561 | 58 |
354154 | 354154 | 2020-07-21 | Brevard | Florida | 12009 | 4413 | 53 |
350952 | 350952 | 2020-07-20 | Brevard | Florida | 12009 | 4303 | 50 |
347751 | 347751 | 2020-07-19 | Brevard | Florida | 12009 | 4222 | 50 |
344551 | 344551 | 2020-07-18 | Brevard | Florida | 12009 | 4060 | 49 |
341352 | 341352 | 2020-07-17 | Brevard | Florida | 12009 | 3945 | 46 |
338155 | 338155 | 2020-07-16 | Brevard | Florida | 12009 | 3804 | 44 |
334960 | 334960 | 2020-07-15 | Brevard | Florida | 12009 | 3722 | 40 |
331767 | 331767 | 2020-07-14 | Brevard | Florida | 12009 | 3632 | 34 |
328580 | 328580 | 2020-07-13 | Brevard | Florida | 12009 | 3510 | 29 |
325394 | 325394 | 2020-07-12 | Brevard | Florida | 12009 | 3369 | 29 |
322213 | 322213 | 2020-07-11 | Brevard | Florida | 12009 | 3237 | 28 |
319034 | 319034 | 2020-07-10 | Brevard | Florida | 12009 | 3104 | 27 |
315861 | 315861 | 2020-07-09 | Brevard | Florida | 12009 | 2985 | 26 |
312686 | 312686 | 2020-07-08 | Brevard | Florida | 12009 | 2812 | 20 |
309516 | 309516 | 2020-07-07 | Brevard | Florida | 12009 | 2705 | 20 |
306348 | 306348 | 2020-07-06 | Brevard | Florida | 12009 | 2591 | 19 |
303184 | 303184 | 2020-07-05 | Brevard | Florida | 12009 | 2521 | 19 |
300020 | 300020 | 2020-07-04 | Brevard | Florida | 12009 | 2453 | 19 |
296858 | 296858 | 2020-07-03 | Brevard | Florida | 12009 | 2366 | 18 |
293702 | 293702 | 2020-07-02 | Brevard | Florida | 12009 | 2180 | 17 |
290548 | 290548 | 2020-07-01 | Brevard | Florida | 12009 | 1962 | 17 |
287397 | 287397 | 2020-06-30 | Brevard | Florida | 12009 | 1793 | 17 |
284251 | 284251 | 2020-06-29 | Brevard | Florida | 12009 | 1716 | 17 |
281105 | 281105 | 2020-06-28 | Brevard | Florida | 12009 | 1631 | 17 |
277958 | 277958 | 2020-06-27 | Brevard | Florida | 12009 | 1547 | 17 |
274810 | 274810 | 2020-06-26 | Brevard | Florida | 12009 | 1297 | 17 |
271670 | 271670 | 2020-06-25 | Brevard | Florida | 12009 | 1149 | 17 |
268534 | 268534 | 2020-06-24 | Brevard | Florida | 12009 | 1022 | 17 |
265404 | 265404 | 2020-06-23 | Brevard | Florida | 12009 | 918 | 17 |
262276 | 262276 | 2020-06-22 | Brevard | Florida | 12009 | 878 | 16 |
259149 | 259149 | 2020-06-21 | Brevard | Florida | 12009 | 850 | 16 |
256022 | 256022 | 2020-06-20 | Brevard | Florida | 12009 | 817 | 16 |
252903 | 252903 | 2020-06-19 | Brevard | Florida | 12009 | 748 | 16 |
249788 | 249788 | 2020-06-18 | Brevard | Florida | 12009 | 688 | 16 |
246676 | 246676 | 2020-06-17 | Brevard | Florida | 12009 | 650 | 16 |
243563 | 243563 | 2020-06-16 | Brevard | Florida | 12009 | 608 | 16 |
240452 | 240452 | 2020-06-15 | Brevard | Florida | 12009 | 565 | 15 |
237344 | 237344 | 2020-06-14 | Brevard | Florida | 12009 | 545 | 15 |
234237 | 234237 | 2020-06-13 | Brevard | Florida | 12009 | 541 | 15 |
231131 | 231131 | 2020-06-12 | Brevard | Florida | 12009 | 519 | 13 |
228028 | 228028 | 2020-06-11 | Brevard | Florida | 12009 | 506 | 13 |
224926 | 224926 | 2020-06-10 | Brevard | Florida | 12009 | 484 | 13 |
221831 | 221831 | 2020-06-09 | Brevard | Florida | 12009 | 471 | 13 |
218736 | 218736 | 2020-06-08 | Brevard | Florida | 12009 | 464 | 13 |
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);