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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 479 ✖
- 132616 14
- 132955 14
- 133482 14
- 134233 14
- 81335 11
- 135740 8
- 42359 7
- 42604 7
- 42844 7
- 43207 7
- 43702 7
- 44399 7
- 45840 7
- 48006 7
- 51525 7
- 55378 7
- 59735 7
- 64323 7
- 68833 7
- 72518 7
- 75107 7
- 77272 7
- 78479 7
- 79247 7
- 79757 7
- 80128 7
- 80429 7
- 80672 7
- 80892 7
- 81106 7
- 81839 7
- 82136 7
- 82434 7
- 83648 7
- 88645 7
- 96835 7
- 108383 7
- 116349 7
- 122479 7
- 126687 7
- 130075 7
- 131391 7
- 132047 7
- 132397 7
- 42856 4
- 81580 3
- 7 2
- 328 2
- 399 2
- 9777 2
- 14981 2
- 19789 2
- 21034 2
- 1 1
- 2 1
- 3 1
- 4 1
- 5 1
- 9 1
- 12 1
- 14 1
- 20 1
- 27 1
- 30 1
- 32 1
- 37 1
- 47 1
- 49 1
- 62 1
- 72 1
- 79 1
- 92 1
- 98 1
- 105 1
- 111 1
- 121 1
- 123 1
- 133 1
- 148 1
- 163 1
- 173 1
- 192 1
- 205 1
- 210 1
- 215 1
- 218 1
- 224 1
- 225 1
- 235 1
- 247 1
- 250 1
- 252 1
- 266 1
- 268 1
- 270 1
- 285 1
- 289 1
- 297 1
- 308 1
- 310 1
- 319 1
- 320 1
- 325 1
- 326 1
- 330 1
- 344 1
- 346 1
- 348 1
- 356 1
- 359 1
- 365 1
- 367 1
- 371 1
- 372 1
- 376 1
- 380 1
- 389 1
- 394 1
- 398 1
- 401 1
- 409 1
- 420 1
- 422 1
- 424 1
- 427 1
- 428 1
- 431 1
- 439 1
- 453 1
- 457 1
- 464 1
- 471 1
- 484 1
- 506 1
- 519 1
- 541 1
- 545 1
- 565 1
- 608 1
- 650 1
- 688 1
- 748 1
- 817 1
- 850 1
- 878 1
- 918 1
- 1022 1
- 1149 1
- 1297 1
- 1547 1
- 1631 1
- 1716 1
- 1793 1
- 1962 1
- 2180 1
- 2366 1
- 2453 1
- 2521 1
- 2591 1
- 2705 1
- 2812 1
- 2985 1
- 3104 1
- 3237 1
- 3369 1
- 3510 1
- 3632 1
- 3722 1
- 3804 1
- 3945 1
- 4060 1
- 4222 1
- 4303 1
- 4413 1
- 4561 1
- 4658 1
- 4756 1
- 4898 1
- 4966 1
- 5069 1
- 5155 1
- 5254 1
- 5333 1
- 5420 1
- 5521 1
- 5587 1
- 5619 1
- 5671 1
- 5712 1
- 5794 1
- 5851 1
- 5963 1
- 6064 1
- 6099 1
- 6190 1
- 6248 1
- 6313 1
- 6392 1
- 6478 1
- 6511 1
- 6538 1
- 6614 1
- 6667 1
- 6753 1
- 6797 1
- 6889 1
- 6912 1
- 6946 1
- 6972 1
- 7040 1
- 7092 1
- 7132 1
- 7182 1
- 7201 1
- 7234 1
- 7378 1
- 7423 1
- 7464 1
- 7532 1
- 7598 1
- 7633 1
- 7656 1
- 7689 1
- 7742 1
- 7787 1
- 7861 1
- 7926 1
- 7960 1
- 7995 1
- 8050 1
- 8097 1
- 8193 1
- 8264 1
- 8352 1
- 8395 1
- 8429 1
- 8502 1
- 8578 1
- 8636 1
- 8728 1
- 8800 1
- 8841 1
- 8848 1
- 8983 1
- 9049 1
- 9154 1
- 9221 1
- 9335 1
- 9373 1
- 9399 1
- 9511 1
- 9568 1
- 9657 1
- 9913 1
- 9936 1
- 10025 1
- 10110 1
- 10183 1
- 10268 1
- 10349 1
- 10397 1
- 10427 1
- 10521 1
- 10596 1
- 10747 1
- 10849 1
- 10999 1
- 11055 1
- 11083 1
- 11249 1
- 11318 1
- 11502 1
- 11637 1
- 11743 1
- 11780 1
- 11888 1
- 12034 1
- 12195 1
- 12318 1
- 12429 1
- 12572 1
- 12680 1
- 12780 1
- 12925 1
- 13092 1
- 13167 1
- 13312 1
- 13452 1
- 13602 1
- 13652 1
- 13802 1
- 13948 1
- 14112 1
- 14301 1
- 14464 1
- 14564 1
- 14650 1
- 14811 1
- 15259 1
- 15361 1
- 15494 1
- 15556 1
- 15744 1
- 15953 1
- 16208 1
- 16376 1
- 16529 1
- 16626 1
- 16721 1
- 16879 1
- 17077 1
- 17233 1
- 17444 1
- 17631 1
- 17730 1
- 17897 1
- 18081 1
- 18301 1
- 18511 1
- 18729 1
- 18903 1
- 19022 1
- 19178 1
- 19344 1
- 19535 1
- 20050 1
- 20145 1
- 20355 1
- 20522 1
- 20778 1
- 21541 1
- 21640 1
- 22037 1
- 22364 1
- 22669 1
- 23103 1
- 23513 1
- 23827 1
- 23944 1
- 24314 1
- 24594 1
- 24917 1
- 25207 1
- 25585 1
- 25831 1
- 26081 1
- 26230 1
- 26488 1
- 26735 1
- 26975 1
- 27245 1
- 27542 1
- 27737 1
- 27971 1
- 28147 1
- 28384 1
- 28604 1
- 28792 1
- 29177 1
- 29345 1
- 29518 1
- 29829 1
- 30026 1
- 30153 1
- 30459 1
- 30624 1
- 30858 1
- 31006 1
- 31238 1
- 31414 1
- 31581 1
- 31741 1
- 31906 1
- 32013 1
- 32083 1
- 32277 1
- 32445 1
- 32555 1
- 32675 1
- 32855 1
- 33007 1
- 33106 1
- 33238 1
- 33429 1
- 33578 1
- 33739 1
- 33885 1
- 33990 1
- 34070 1
- 34212 1
- 34303 1
- 34434 1
- 34549 1
- 34648 1
- 34767 1
- 34833 1
- 34944 1
- 35081 1
- 35185 1
- 35342 1
- 35464 1
- 35573 1
- 35618 1
- 35820 1
- 35840 1
- 35925 1
- 36051 1
- 36142 1
- 36225 1
- 36306 1
- 36438 1
- 36548 1
- 36652 1
- 36746 1
- 36859 1
- 36951 1
- 37012 1
- 37116 1
- 37190 1
- 37326 1
- 37451 1
- 37563 1
- 37660 1
- 37716 1
- 37852 1
- 37984 1
- 38123 1
- 38267 1
- 38389 1
- 38508 1
- 38547 1
- 38712 1
- 38872 1
- 39002 1
- 39153 1
- 39271 1
- 39385 1
- 39464 1
- 39626 1
- 39745 1
- 39883 1
- 40013 1
- 40186 1
- 40323 1
- 40432 1
- 40538 1
- 40660 1
- 40780 1
- 40904 1
- 41041 1
- 41119 1
- 41183 1
- 41251 1
- 41350 1
- 41443 1
- 41545 1
- 41637 1
- 41704 1
- 41767 1
- 41841 1
- 41933 1
- 42045 1
- 42111 1
- 42193 1
- 42237 1
- 42294 1
- 42358 1
- 42440 1
- 42511 1
- 42565 1
- 42640 1
- 42661 1
- 42676 1
- 42716 1
- 42767 1
- 42818 1
- 42963 1
- 42999 1
- 43052 1
state 1
- Florida 788
fips 1
- 12009 · 788 ✖
county 1
- Brevard 788
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3300 | 3300 | 2020-03-17 | Brevard | Florida | 12009 | 1 | 0 |
3857 | 3857 | 2020-03-18 | Brevard | Florida | 12009 | 2 | 0 |
4522 | 4522 | 2020-03-19 | Brevard | Florida | 12009 | 3 | 0 |
5301 | 5301 | 2020-03-20 | Brevard | Florida | 12009 | 4 | 0 |
6229 | 6229 | 2020-03-21 | Brevard | Florida | 12009 | 5 | 0 |
7266 | 7266 | 2020-03-22 | Brevard | Florida | 12009 | 7 | 0 |
8412 | 8412 | 2020-03-23 | Brevard | Florida | 12009 | 7 | 0 |
9657 | 9657 | 2020-03-24 | Brevard | Florida | 12009 | 9 | 0 |
11031 | 11031 | 2020-03-25 | Brevard | Florida | 12009 | 12 | 0 |
12579 | 12579 | 2020-03-26 | Brevard | Florida | 12009 | 14 | 0 |
14248 | 14248 | 2020-03-27 | Brevard | Florida | 12009 | 20 | 0 |
16032 | 16032 | 2020-03-28 | Brevard | Florida | 12009 | 27 | 0 |
17924 | 17924 | 2020-03-29 | Brevard | Florida | 12009 | 30 | 0 |
19904 | 19904 | 2020-03-30 | Brevard | Florida | 12009 | 32 | 0 |
21981 | 21981 | 2020-03-31 | Brevard | Florida | 12009 | 37 | 0 |
24140 | 24140 | 2020-04-01 | Brevard | Florida | 12009 | 47 | 0 |
26370 | 26370 | 2020-04-02 | Brevard | Florida | 12009 | 49 | 0 |
28672 | 28672 | 2020-04-03 | Brevard | Florida | 12009 | 62 | 0 |
31030 | 31030 | 2020-04-04 | Brevard | Florida | 12009 | 72 | 0 |
33436 | 33436 | 2020-04-05 | Brevard | Florida | 12009 | 79 | 0 |
35881 | 35881 | 2020-04-06 | Brevard | Florida | 12009 | 92 | 0 |
38371 | 38371 | 2020-04-07 | Brevard | Florida | 12009 | 98 | 2 |
40914 | 40914 | 2020-04-08 | Brevard | Florida | 12009 | 105 | 2 |
43488 | 43488 | 2020-04-09 | Brevard | Florida | 12009 | 111 | 2 |
46089 | 46089 | 2020-04-10 | Brevard | Florida | 12009 | 121 | 2 |
48719 | 48719 | 2020-04-11 | Brevard | Florida | 12009 | 123 | 3 |
51380 | 51380 | 2020-04-12 | Brevard | Florida | 12009 | 133 | 4 |
54060 | 54060 | 2020-04-13 | Brevard | Florida | 12009 | 148 | 6 |
56752 | 56752 | 2020-04-14 | Brevard | Florida | 12009 | 163 | 6 |
59460 | 59460 | 2020-04-15 | Brevard | Florida | 12009 | 173 | 6 |
62179 | 62179 | 2020-04-16 | Brevard | Florida | 12009 | 192 | 6 |
64912 | 64912 | 2020-04-17 | Brevard | Florida | 12009 | 205 | 7 |
67660 | 67660 | 2020-04-18 | Brevard | Florida | 12009 | 210 | 7 |
70422 | 70422 | 2020-04-19 | Brevard | Florida | 12009 | 215 | 7 |
73191 | 73191 | 2020-04-20 | Brevard | Florida | 12009 | 218 | 7 |
75967 | 75967 | 2020-04-21 | Brevard | Florida | 12009 | 224 | 7 |
78751 | 78751 | 2020-04-22 | Brevard | Florida | 12009 | 225 | 7 |
81545 | 81545 | 2020-04-23 | Brevard | Florida | 12009 | 235 | 8 |
84345 | 84345 | 2020-04-24 | Brevard | Florida | 12009 | 247 | 8 |
87153 | 87153 | 2020-04-25 | Brevard | Florida | 12009 | 250 | 8 |
89970 | 89970 | 2020-04-26 | Brevard | Florida | 12009 | 252 | 8 |
92788 | 92788 | 2020-04-27 | Brevard | Florida | 12009 | 266 | 8 |
95620 | 95620 | 2020-04-28 | Brevard | Florida | 12009 | 268 | 8 |
98465 | 98465 | 2020-04-29 | Brevard | Florida | 12009 | 270 | 8 |
101315 | 101315 | 2020-04-30 | Brevard | Florida | 12009 | 285 | 8 |
104170 | 104170 | 2020-05-01 | Brevard | Florida | 12009 | 289 | 8 |
107035 | 107035 | 2020-05-02 | Brevard | Florida | 12009 | 297 | 8 |
109904 | 109904 | 2020-05-03 | Brevard | Florida | 12009 | 308 | 8 |
112779 | 112779 | 2020-05-04 | Brevard | Florida | 12009 | 310 | 8 |
115662 | 115662 | 2020-05-05 | Brevard | Florida | 12009 | 319 | 8 |
118622 | 118622 | 2020-05-06 | Brevard | Florida | 12009 | 320 | 8 |
121591 | 121591 | 2020-05-07 | Brevard | Florida | 12009 | 325 | 8 |
124570 | 124570 | 2020-05-08 | Brevard | Florida | 12009 | 326 | 9 |
127557 | 127557 | 2020-05-09 | Brevard | Florida | 12009 | 328 | 9 |
130548 | 130548 | 2020-05-10 | Brevard | Florida | 12009 | 328 | 9 |
133539 | 133539 | 2020-05-11 | Brevard | Florida | 12009 | 330 | 9 |
136528 | 136528 | 2020-05-12 | Brevard | Florida | 12009 | 346 | 9 |
139519 | 139519 | 2020-05-13 | Brevard | Florida | 12009 | 344 | 9 |
142515 | 142515 | 2020-05-14 | Brevard | Florida | 12009 | 348 | 9 |
145515 | 145515 | 2020-05-15 | Brevard | Florida | 12009 | 356 | 9 |
148518 | 148518 | 2020-05-16 | Brevard | Florida | 12009 | 359 | 10 |
151527 | 151527 | 2020-05-17 | Brevard | Florida | 12009 | 365 | 10 |
154539 | 154539 | 2020-05-18 | Brevard | Florida | 12009 | 367 | 11 |
157555 | 157555 | 2020-05-19 | Brevard | Florida | 12009 | 371 | 11 |
160581 | 160581 | 2020-05-20 | Brevard | Florida | 12009 | 372 | 11 |
163609 | 163609 | 2020-05-21 | Brevard | Florida | 12009 | 376 | 11 |
166642 | 166642 | 2020-05-22 | Brevard | Florida | 12009 | 380 | 11 |
169679 | 169679 | 2020-05-23 | Brevard | Florida | 12009 | 389 | 11 |
172720 | 172720 | 2020-05-24 | Brevard | Florida | 12009 | 394 | 11 |
175763 | 175763 | 2020-05-25 | Brevard | Florida | 12009 | 398 | 12 |
178807 | 178807 | 2020-05-26 | Brevard | Florida | 12009 | 399 | 12 |
181851 | 181851 | 2020-05-27 | Brevard | Florida | 12009 | 399 | 12 |
184905 | 184905 | 2020-05-28 | Brevard | Florida | 12009 | 401 | 12 |
187961 | 187961 | 2020-05-29 | Brevard | Florida | 12009 | 409 | 12 |
191026 | 191026 | 2020-05-30 | Brevard | Florida | 12009 | 420 | 12 |
194093 | 194093 | 2020-05-31 | Brevard | Florida | 12009 | 422 | 12 |
197163 | 197163 | 2020-06-01 | Brevard | Florida | 12009 | 424 | 13 |
200236 | 200236 | 2020-06-02 | Brevard | Florida | 12009 | 427 | 13 |
203312 | 203312 | 2020-06-03 | Brevard | Florida | 12009 | 428 | 13 |
206392 | 206392 | 2020-06-04 | Brevard | Florida | 12009 | 431 | 13 |
209473 | 209473 | 2020-06-05 | Brevard | Florida | 12009 | 439 | 13 |
212558 | 212558 | 2020-06-06 | Brevard | Florida | 12009 | 453 | 13 |
215645 | 215645 | 2020-06-07 | Brevard | Florida | 12009 | 457 | 13 |
218736 | 218736 | 2020-06-08 | Brevard | Florida | 12009 | 464 | 13 |
221831 | 221831 | 2020-06-09 | Brevard | Florida | 12009 | 471 | 13 |
224926 | 224926 | 2020-06-10 | Brevard | Florida | 12009 | 484 | 13 |
228028 | 228028 | 2020-06-11 | Brevard | Florida | 12009 | 506 | 13 |
231131 | 231131 | 2020-06-12 | Brevard | Florida | 12009 | 519 | 13 |
234237 | 234237 | 2020-06-13 | Brevard | Florida | 12009 | 541 | 15 |
237344 | 237344 | 2020-06-14 | Brevard | Florida | 12009 | 545 | 15 |
240452 | 240452 | 2020-06-15 | Brevard | Florida | 12009 | 565 | 15 |
243563 | 243563 | 2020-06-16 | Brevard | Florida | 12009 | 608 | 16 |
246676 | 246676 | 2020-06-17 | Brevard | Florida | 12009 | 650 | 16 |
249788 | 249788 | 2020-06-18 | Brevard | Florida | 12009 | 688 | 16 |
252903 | 252903 | 2020-06-19 | Brevard | Florida | 12009 | 748 | 16 |
256022 | 256022 | 2020-06-20 | Brevard | Florida | 12009 | 817 | 16 |
259149 | 259149 | 2020-06-21 | Brevard | Florida | 12009 | 850 | 16 |
262276 | 262276 | 2020-06-22 | Brevard | Florida | 12009 | 878 | 16 |
265404 | 265404 | 2020-06-23 | Brevard | Florida | 12009 | 918 | 17 |
268534 | 268534 | 2020-06-24 | Brevard | Florida | 12009 | 1022 | 17 |
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);