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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
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);